Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)

Reply
 
Thread Tools Display Modes
  #11  
Old 06-09-2005, 10:51 PM
Weapon-x Weapon-x is offline
 
Join Date: Jan 2005
Location: USA
Posts: 117
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

so it should look something like

DELETE FROM 6654654datastore WHERE title = 'arcadesettings' LIMIT 1;
ALTER TABLE 6654654user DROP arcadesettings;
ALTER TABLE 6654654usergroup DROP arcadepermissions;
DROP TABLE 6654654games;
DROP TABLE 6654654gamechallenges;
DROP TABLE 6654654gamesessions;
DROP TABLE 6654654gamenews;
DELETE FROM 6654654datastore WHERE title = 'arcadesettings' LIMIT 1;
DELETE FROM 6654654datastore WHERE title = 'scoresettings' LIMIT 1;

just like that? is that all right?
Reply With Quote
  #12  
Old 06-09-2005, 11:57 PM
iSpanish's Avatar
iSpanish iSpanish is offline
 
Join Date: Jan 2005
Location: Oregon
Posts: 124
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Weapon-x
so it should look something like

DELETE FROM 6654654datastore WHERE title = 'arcadesettings' LIMIT 1;
ALTER TABLE 6654654user DROP arcadesettings;
ALTER TABLE 6654654usergroup DROP arcadepermissions;
DROP TABLE 6654654games;
DROP TABLE 6654654gamechallenges;
DROP TABLE 6654654gamesessions;
DROP TABLE 6654654gamenews;
DELETE FROM 6654654datastore WHERE title = 'arcadesettings' LIMIT 1;
DELETE FROM 6654654datastore WHERE title = 'scoresettings' LIMIT 1;

just like that? is that all right?
i think like this

try this

[sql]
DELETE FROM " . TABLE_PREFIX . "datastore WHERE title = 'arcadesettings' LIMIT 1;
ALTER TABLE " . TABLE_PREFIX . "user DROP arcadesettings;
ALTER TABLE " . TABLE_PREFIX . "usergroup DROP arcadepermissions;
DROP TABLE " . TABLE_PREFIX . "games;
DROP TABLE " . TABLE_PREFIX . "gamechallenges;
DROP TABLE " . TABLE_PREFIX . "gamesessions;
DROP TABLE " . TABLE_PREFIX . "gamenews;
DELETE FROM " . TABLE_PREFIX . "datastore WHERE title = 'arcadesettings' LIMIT 1;
DELETE FROM " . TABLE_PREFIX . "datastore WHERE title = 'scoresettings' LIMIT 1;
[/sql]
Reply With Quote
  #13  
Old 06-10-2005, 12:34 AM
Weapon-x Weapon-x is offline
 
Join Date: Jan 2005
Location: USA
Posts: 117
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

replace the word "PREFIX" with the real prefix or replace the word "TABLE_PREFIX" with the real prefix?
Reply With Quote
  #14  
Old 06-10-2005, 01:40 AM
iSpanish's Avatar
iSpanish iSpanish is offline
 
Join Date: Jan 2005
Location: Oregon
Posts: 124
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Weapon-x
replace the word "PREFIX" with the real prefix or replace the word "TABLE_PREFIX" with the real prefix?
replace " . TABLE_PREFIX . " with the real prefix


look in your config.php
PHP Code:
// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix '6654654_'
if that true
do this
[sql]
DELETE FROM 6654654_datastore WHERE title = 'arcadesettings' LIMIT 1;
ALTER TABLE 6654654_user DROP arcadesettings;
ALTER TABLE 6654654_usergroup DROP arcadepermissions;
DROP TABLE 6654654_games;
DROP TABLE 6654654_gamechallenges;
DROP TABLE 6654654_gamesessions;
DROP TABLE 6654654_gamenews;
DELETE FROM 6654654_datastore WHERE title = 'arcadesettings' LIMIT 1;
DELETE FROM 6654654_datastore WHERE title = 'scoresettings' LIMIT 1;
[/sql]
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:15 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08740 seconds
  • Memory Usage 2,188KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete