Go Back   PHP Link Directory Forum > PHP Link Directory (phpLD) > Mods and contribution Discussion

Mods and contribution Discussion This forum is only for discussion of modding phpLD. For specific mod releases, please see the appropriate forum.

Closed Thread
 
Thread Tools Display Modes
Old 01-12-2006   #1
tarheit
Supporter
 
Join Date: Jan 2006
Location: Ohio
Posts: 23
Default State Subcategories

For those wanting to add states as categories, I found it much easier to run the following query in phpMyAdmin rather than create each manually in the admin area. Just search the following code for 117 and replace it with the id of the category the states should fall under. Then run the code in phpMyAdmin. I found it saved a lot of time when adding sub categories to several different main categories.

Code:
INSERT INTO PLD_CATEGORY VALUES ('','Alabama','Alabama',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Alaska','Alaska',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Arizona','Arizona',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Arkansas','Arkansas',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','California','California',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Colorado','Colorado',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Connecticut','Connecticut',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Delaware','Delaware',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Florida','Florida',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Georgia','Georgia',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Hawaii','Hawaii',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Idaho','Idaho',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Illinois','Illinois',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Indiana','Indiana',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Iowa','Iowa',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Kansas','Kansas',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Kentucky','Kentucky',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Louisiana','Louisiana',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Maine','Maine',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Maryland','Maryland',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Massachusetts','Massachusetts',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Michigan','Michigan',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Minnesota','Minnesota',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Mississippi','Mississippi',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Missouri','Missouri',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Montana','Montana',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Nebraska','Nebraska',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Nevada','Nevada',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','New Hampshire','New_Hampshire',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','New Jersey','New_Jersey',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','New Mexico','New_Mexico',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','New York','New_York',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','North Carolina','North_Carolina',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','North Dakota','North_Dakota',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Ohio','Ohio',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Oklahoma','Oklahoma',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Oregon','Oregon',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Pennsylvania','Pennsylvania',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Rhode Island','Rhode_Island',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','South Carolina','South_Carolina',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','South Dakota','South_Dakota',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Tennessee','Tennessee',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Texas','Texas',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Utah','Utah',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Vermont','Vermont',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Virginia','Virginia',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Washington','Washington',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','West Virginia','West_Virginia',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Wisconsin','Wisconsin',NULL,117,2,NOW(),0,0,0);
INSERT INTO PLD_CATEGORY VALUES ('','Wyoming','Wyoming',NULL,117,2,NOW(),0,0,0);
-Tim

Last edited by David; 03-21-2009 at 11:48 PM.
tarheit is offline  
Old 01-13-2006   #2
anylink
 
Join Date: Dec 2005
Posts: 7
Default

very nice thanks a load!
anylink is offline  
Old 06-02-2006   #3
DelMarSurf
Supporter
 
Join Date: May 2006
Posts: 46
Default

YEA! This works perfectly. Thanks!!!
DelMarSurf is offline  
Old 06-02-2006   #4
anon
Supporter
 
anon's Avatar
 
Join Date: Feb 2006
Location: As far from you as humanly possible!
Posts: 2,893
Send a message via Yahoo to anon
Default

Quote:
Originally Posted by DelMarSurf
YEA! This works perfectly. Thanks!!!
Remember, i never steer anyone wrong, and like i told you, this breaks things in terms of adding more new categories. Step 2 is to now find my post to fix what's been hacked up by the original posters database additions.

Rob
anon is offline  
Old 10-29-2006   #5
montytx
 
Join Date: Feb 2006
Posts: 11
Default

Does anyone have a state/ city dump they could share?
montytx is offline  
Old 05-28-2007   #6
johnbmtl
 
Join Date: May 2007
Location: Blainville (Montreal area), QC. Canada
Posts: 20
Default

When I try running this on the database (using 3.2), I get the following error:

"#1136 - Column count doesn't match value count at row 1 "

Is this because of something that I am not doing correctly or has the database changed since this was posted?

John
johnbmtl is offline  
Old 06-22-2007   #7
searchangle
 
Join Date: May 2007
Posts: 63
Default I get the Following Error - CAN YOU HELP???

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO PLD_CATEGORY VALUES ('','Alaska','Alaska',NULL,3,2,NOW(),0,0,0); ' at line 1
__________________
______________________________________________
My Site:
Free SEO Tools Directory - SEO Tool Land
searchangle is offline  
Old 08-28-2007   #8
omakad
Supporter
 
Join Date: Jul 2007
Posts: 22
Default

I'm getting the same error. I've run this code before for the rest of my cat's but now it's not working any more. Has anyone figured out what is going on?
omakad is offline  
Old 08-28-2007   #9
Mr_Bill
 
Join Date: May 2007
Posts: 157
Default

If you are trying to use this for v.3.2 you could try this

Code:
INSERT INTO `PLD_CATEGORY` VALUES (1, 'Alabama','Alabama', 'alabama', 'alabama/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (2, 'Alaska','Alaska', 'alaska', 'alaska/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (3, 'Arizona','Arizona', 'arizona', 'arizona/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (4, 'Arkansas','Arkansas', 'arkansas', 'arkansas/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (5, 'California','California', 'california', 'california/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (6, 'Colorado','Colorado', 'colorado', 'colorado/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (7, 'Connecticut','Connecticut', 'connecticut', 'connecticut/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (8, 'Delaware','Delaware', 'delaware', 'delaware/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (9, 'Florida','Florida', 'florida', 'florida/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (10, 'Georgia','Georgia', 'georgia', 'georgia/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (11, 'Hawaii','Hawaii', 'hawaii', 'hawaii/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (12, 'Idaho','Idaho', 'idaho', 'idaho/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (13, 'Illinois','Illinois', 'illinois', 'illinois/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (14, 'Indiana','Indiana', 'indiana', 'indiana/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (15, 'Iowa','Iowa', 'iowa', 'iowa/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (16, 'Kansas','Kansas', 'kansas', 'kansas/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (17, 'Kentucky','Kentucky', 'kentucky', 'kentucky/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (18, 'Louisiana','Louisiana', 'louisiana', 'louisiana/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (19, 'Maine','Maine', 'maine', 'maine/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (20, 'Maryland','Maryland', 'maryland', 'maryland/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (21, 'Massachusetts','Massachusetts', 'massachusetts', 'massachusetts/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (22, 'Michigan','Michigan', 'michigan', 'michigan/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (23, 'Minnesota','Minnesota', 'minnesota', 'minnesota/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (24, 'Mississippi','Mississippi', 'mississippi', 'mississippi/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (25, 'Missouri','Missouri', 'missouri', 'missouri/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (26, 'Montana','Montana', 'montana', 'montana/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (27, 'Nebraska','Nebraska', 'nebraska', 'nebraska/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (28, 'Nevada','Nevada', 'nevada', 'nevada/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (29, 'New Hampshire','New-Hampshire', 'new-hampshire', 'new-hampshire/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (30, 'New Jersey','New-Jersey', 'new-jersey', 'new-jersey/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (31, 'New Mexico','New-Mexico', 'new-mexico', 'new-mexico/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (32, 'New York','New-York', 'new-york', 'new-york/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (33, 'North Carolina','North-Carolina', 'north-carolina', 'north-carolina/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (34, 'North Dakota','North-Dakota', 'north-dakota', 'north-dakota/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (35, 'Ohio','Ohio', 'ohio', 'ohio/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (36, 'Oklahoma','Oklahoma', 'oklahoma', 'oklahoma/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (37, 'Oregon','Oregon', 'oregon', 'oregon', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (38, 'Pennsylvania','Pennsylvania', 'pennsylvania', 'pennsylvania/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (39, 'Rhode Island','Rhode-Island', 'rhode-island', 'rhode-island/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (40, 'South Carolina','South-Carolina', 'south-carolina', 'south-carolina/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (41, 'South Dakota','South-Dakota', 'south-dakota', 'south-dakota/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (42, 'Tennessee','Tennessee', 'tennessee', 'tennessee/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (43, 'Texas','Texas', 'texas', 'texas/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (44, 'Utah','Utah', 'utah', 'utah/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (45, 'Vermont','Vermont', 'vermont', 'vermont/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (46, 'Virginia','Virginia', 'virginia', 'virginia/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (47, 'Washington','Washington', 'washington', 'washington/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (48, 'West Virginia','West-Virginia', 'west-virginia', 'west-virginia/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (49, 'Wisconsin','Wisconsin', 'wisconsin', 'wisconsin/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
INSERT INTO `PLD_CATEGORY` VALUES (50, 'Wyoming','Wyoming', 'wyoming', 'wyoming/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
__________________
Mr_Bill is offline  
Old 08-29-2007   #10
omakad
Supporter
 
Join Date: Jul 2007
Posts: 22
Default

Do we still need to specify the category ID anywhere in this code? and if yes then where? I'm sorry I'm retarded about running mySQL inquires. Thanks.
omakad is offline  
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 01:59 PM.


Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.