Easily create 50-state Thread Prefixes

[briansol]

Don't feel like entering 50 states selecting all the options each time for prefixes? I didn't either.

If your comfortable with phpmyadmin, this will be easy for you.

Step 1) Make a new Prefix Group.

ID = states1
name = States
Display order = (any you want, given your other lists)
forums = select which forums which the prefixes should appear on (i used it on my classifieds area)
Save(Note: The ID of states1 is important, as it must match the file below. The other options can be any values you wish)

Step 2) Run the attached code block from the txt file in phpmyadmin -> SQL tab

Note 1: You will need to edit the file FIRST if you used a table prefix (perhaps, vb_ or forum_) on your database. ie, replace "INSERT INTO prefix" with "INSERT INTO vb_prefix" and "insert into phrase" with "insert into vb_phrase". Any decent text editor will allow you do to a global replace.
Note 2: This assumes language ID of 0, the default language. I would imagine most people using the states list would have English as their language set. If you are using a different language than default where you want this prefix associated with, you will need to alter the code block from 0 to your language ID as well.Step 3) verify that you have uploaded everything properly by visiting the prefix group in the ACP. you should see something like the screen shot below.

If not, you may need to click on 'edit' as described in post 3 of this thread.
https://vborg.vbsupport.ru/showpost.php?p=1548409&postcount=3

Step 4) Finally, go to a forum you selected in step one, and click new thread. you should see your prefixes listed there.



This list also includes Washington DC.

and feel free to add in Canadian provinces as well if you wish, just follow the same format.

:up:

[Princeton]

thank you - great tip :up:

[Boofo]

Excellent article although you might want to point out that they have to edit and save one state from the list to have them all show up. ;)

[briansol]

Excellent article although you might want to point out that they have to edit and save one state from the list to have them all show up. ;)

i just tried this again and did not have to do this. Anyone else confirm?

--------------- Added 1213388640 at 1213388640 ---------------

I also just noticed that i'm missing a state.

I have washington DC in there, and the list only goes to 50.

rep points to the first person who finds the state i forgot, and then i will edit the file(s).

[Boofo]

When I added the SQL queries from the text file, they ran fine. My listing showed like your pic in the first post except it had no state names on the left column. That is when I clicked on the edit button for one of the states and saved it without doing anything to it and then the whole list showed up fine.

I was just on my way up to report about the missing state. I haven't looked closely enough to figure out which one yet, though.

[Grampz]

i just tried this again and did not have to do this. Anyone else confirm?

--------------- Added 1213388640 at 1213388640 ---------------

I also just noticed that i'm missing a state.

I have washington DC in there, and the list only goes to 50.

rep points to the first person who finds the state i forgot, and then i will edit the file(s).

Washington D.C. is not a state. The state you forgot is Virginia.

[briansol]

Thanks.

VA has been added, and the file updated.

While DC is technically not a state, it is an 'area' that could be considered useful for geographic location on classified forums, etc.

[Brandon Sheley]

great article :)