Thread: Add-On Releases - Jujubins Lottery
View Single Post
  #8  
Old 01-12-2009, 11:00 AM
R-D's Avatar
R-D R-D is offline
 
Join Date: Jan 2008
Posts: 158
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Oh man, that's funny. I doubt even a paid modification would manage 15 minute support.

Looks like he just forgot to use the tableprefix when initially installing (and also uninstalling) the database table. A simple edit should fix it.

Note: It's probably best to uninstall before you make this change, then re-install the product again, otherwise the old db table probably won't be removed.

Open the product and find:
Code:
<codes>
		<code version="1.0.0">
			<installcode><![CDATA[$db->reporterror = false;
$db->query("CREATE TABLE `jlottery` (
  `ticket` int(8) NOT NULL AUTO_INCREMENT,
  `userid` varchar(500) NOT NULL,
  `username` varchar(500) NOT NULL,
  `email` varchar(500) NOT NULL,
  `usertitle` varchar(500) NOT NULL,
  `time` int(10) NOT NULL,
  `day` int(2) NOT NULL,
  `winner` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ticket`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1");
$db->reporterror = true;]]></installcode>
			<uninstallcode><![CDATA[$db->reporterror = false;
$db->query("DROP TABLE `jlottery`");
$db->reporterror = true;]]></uninstallcode>
		</code>
	</codes>
Replace with:
Code:
<codes>
		<code version="1.0.0">
			<installcode><![CDATA[$db->reporterror = false;
$db->query("CREATE TABLE " . TABLE_PREFIX . "jlottery (
  ticket int(8) NOT NULL AUTO_INCREMENT,
  userid varchar(500) NOT NULL,
  username varchar(500) NOT NULL,
  email varchar(500) NOT NULL,
  usertitle varchar(500) NOT NULL,
  time int(10) NOT NULL,
  day int(2) NOT NULL,
  winner int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (ticket)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1");
$db->reporterror = true;]]></installcode>
			<uninstallcode><![CDATA[$db->reporterror = false;
$db->query("DROP TABLE " . TABLE_PREFIX . "jlottery");
$db->reporterror = true;]]></uninstallcode>
		</code>
	</codes>
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04454 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