The Arcive of vBulletin Modifications Site.

Floris · #1 10-09-2004, 12:51 AM

Hey there,

Does someone know the MySQL query to delete custom phrases from a language?

Logikos · #2 10-09-2004, 04:10 AM

Hmm, thats a good idea! I could use that. And could also make a Automatic Query!

Floris · #3 10-09-2004, 04:50 AM

Quote:

Originally Posted by Live Wire

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 · #4 10-09-2004, 06: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 · #5 10-09-2004, 08:47 AM

Moved to the MySQL queries forum

Floris · #6 10-09-2004, 09:03 AM

Quote:

Originally Posted by Dean C

Moved to the MySQL queries forum

I thought that would be non-vb related. like on vbulletin.com

#7 10-09-2004, 10:45 AM

are you serious ?! Floris is missing a way to deal with vB ?! hum.. looks like i will help:

[sql]DELETE FROM ".TABLE_PREFIX."phrase WHERE languageid=0[/sql] for custom languages... as languageid = -1 is the MASTER, and 1 is the english, etc...

Floris · #8 10-09-2004, 11:24 AM

Quote:

Originally Posted by nexialys

are you serious ?! Floris is missing a way to deal with vB ?! hum.. looks like i will help:

[sql]DELETE FROM ".TABLE_PREFIX."phrase WHERE languageid=0[/sql] 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.

#9 10-09-2004, 12:14 PM

remember to Rebuild All Languages ... to refresh the cache!

Floris · #10 10-09-2004, 12:17 PM

Quote:

Originally Posted by nexialys

remember to Rebuild All Languages ... to refresh the cache!

Th?t I knew

tnx for the help.