View Single Post
  #142  
Old 06-18-2006, 07:10 PM
Eq4bits Eq4bits is offline
 
Join Date: May 2006
Posts: 468
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The admincp I'm talking about is the same place you go to edit your webpages, where you see all the vbulletin files ... where they are located...

When you installed vbulletin you had to add the name of the d/b for your forum(s) in the config.php... whatever that value is you could use to set a direct path to your d/b in the xml file for this product.
so wherever you saved the xml file on your computer, go to where it's listed, right click, open with>notepad (or whatever editor you use) then
look for
Code:
<installcode>

		$db->hide_errors();
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "post` ADD `dice` MEDIUMTEXT NOT NULL ;");
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` ADD `dice` MEDIUMTEXT NOT NULL ;");
		$db->show_errors();
		
</installcode>
-
	<uninstallcode>

		$db->hide_errors();
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "post` DROP `dice` ");
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` DROP `dice` ");
		$db->show_errors();
		
</uninstallcode>
THEN change it as follows... Making the asterisks the prefix you used for all your other tables (that you found in your config.php file)
Code:
<installcode>

		$db->hide_errors();
		$db->query_write("ALTER TABLE `****_ post` ADD `dice` MEDIUMTEXT NOT NULL ;");
		$db->query_write("ALTER TABLE `****_thread` ADD `dice` MEDIUMTEXT NOT NULL ;");
		$db->show_errors();
		
</installcode>
-
	<uninstallcode>

		$db->hide_errors();
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "post` DROP `dice` ");
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` DROP `dice` ");
		$db->show_errors();
		
</uninstallcode>
Hopefully THAT will work.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01092 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete