View Full Version : Need to UNQUERY THIS
tommyxv
07-06-2005, 08:31 AM
Can someone tell me how to remove this from my database?
// Add v3 Article settings
if ($_REQUEST['caction'] == 2)
{
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "settinggroup (grouptitle, displayorder, volatile) VALUES ('v3_articles', '2000', '0')");
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'settinggroup_v3_articles', 'v3 Articles', '5000')");
The Geek
07-06-2005, 08:49 AM
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "settinggroup (grouptitle, displayorder, volatile) VALUES ('v3_articles', '2000', '0')");
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'settinggroup_v3_articles', 'v3 Articles', '5000')");
Its difficult to say without knowing the rest of the code, however have you thought about:
Running something like:
DELETE FROM settinggroup where grouptitle='v3_articles'
and
DELETE FROM phrase where varname='settinggroup_v3_articles' and text='v3 Articles'
Make sure your table prefixes are in there and I would do a backup first beofre you go in deleting things if you are unfamiliar with sql.
Also, since it looks like you are messing with the phrases, you will need to rebuild them by editing a phrase and then saving it.
On a side note - I dont see why its so important to remove these, its not like they are really taking up any space.
tommyxv
07-06-2005, 12:26 PM
Thanks you! It work perfectly. I only had to run the first query since i deleted the phrase from the admincp. I didnt have any table prefixes.
That was the last of V3Articles. I wanted to completely remove it.
It was showing up in my adminCP, then i deleted the phrase, and had an empty clickable space in my vb settings option list.
Thanks Again,
Tommy
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.