PDA

View Full Version : delete custom phrases query

Floris
10-09-2004, 01:51 AM
Hey there,

Does someone know the MySQL query to delete custom phrases from a language?
Logikos
10-09-2004, 05:10 AM
Hmm, thats a good idea! I could use that. And could also make a Automatic Query! :)
Floris
10-09-2004, 05:50 AM
Hmm, thats a good idea! I could use that. And could also make a Automatic Query! :)
I know the query, someone gave it to me once - but I forgot to note it down.

I just want to add that one line to "execute sql query" ..
Logikos
10-09-2004, 07:50 AM
Ya thats what im talking about, the auto query feature in vb, you just select it from the drop down menu, and press sumbit.
Dean C
10-09-2004, 09:47 AM
Moved to the MySQL queries forum :)
Floris
10-09-2004, 10:03 AM
Moved to the MySQL queries forum :)
I thought that would be non-vb related. like on vbulletin.com
nexialys
10-09-2004, 11:45 AM
are you serious ?! Floris is missing a way to deal with vB ?! hum.. looks like i will help:

DELETE FROM ".TABLE_PREFIX."phrase WHERE languageid=0 for custom languages... as languageid = -1 is the MASTER, and 1 is the english, etc...
Floris
10-09-2004, 12:24 PM
are you serious ?! Floris is missing a way to deal with vB ?! hum.. looks like i will help:

DELETE FROM ".TABLE_PREFIX."phrase WHERE languageid=0 for custom languages... as languageid = -1 is the MASTER, and 1 is the english, etc...
Thank you very much - I will go 'test' this :)
Hopefully it works and the custom phrases are removed from all the languages.
nexialys
10-09-2004, 01:14 PM
remember to Rebuild All Languages ... to refresh the cache!
Floris
10-09-2004, 01:17 PM
remember to Rebuild All Languages ... to refresh the cache!
Th?t I knew :)

tnx for the help.