vBulletin LTS

Easily create 50-state Thread Prefixes

by briansol 11 Jun 2008

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.

Spoiler (click to open)

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.

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.

Attached Thumbnails

Attached Files

prefixes.txt (25.3 KB, 62 views)

vblts.ru supports vBulletin®, 2022-2024