Thread: Add-On Releases - -:[GAME]:- Sudoku 2009
View Single Post
  #37  
Old 06-01-2009, 07:11 AM
djilou djilou is offline
 
Join Date: Dec 2006
Posts: 119
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

there are no query to create tables guthaben and guthaben_shop_preise

Code:
<installcode><![CDATA[
				$db->hide_errors();

				$db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `sudokupermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");
				$db->query("ALTER TABLE `" . TABLE_PREFIX . "administrator` ADD `customsudokupermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");

				$db->query("ALTER TABLE `" . TABLE_PREFIX . "guthaben` ADD `sudoku` INT(11) NOT NULL DEFAULT '0'");
				$db->query("ALTER TABLE `" . TABLE_PREFIX . "guthaben` ADD `sudoku_pay` INT(11) NOT NULL DEFAULT '0'");
				$db->query("ALTER TABLE `" . TABLE_PREFIX . "guthaben` ADD `sudoku_get` INT(11) NOT NULL DEFAULT '0'");
				$db->query("INSERT INTO `" . TABLE_PREFIX . "guthaben_shop_preise` (`name`,`pvar1`,`pvar2`) VALUES ('guthaben_shop_sudoku_pay','\$guthaben[sudoku_pay]','\$guthaben[sudoku]')");
				$db->query("INSERT INTO `" . TABLE_PREFIX . "guthaben_shop_preise` (`name`,`pvar1`,`pvar2`) VALUES ('guthaben_shop_sudoku_get','\$guthaben[sudoku_get]','\$guthaben[sudoku]')");

				$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "sudoku_config;");
				$db->query("CREATE TABLE " . TABLE_PREFIX . "sudoku_config (
			  	subsend  int(11) NOT NULL default '100',
				  plevel1  int(11) NOT NULL default '2000',
				  plevel2  int(11) NOT NULL default '3500',
				  plevel3  int(11) NOT NULL default '5000',
				  plevel4  int(11) NOT NULL default '8000',
		  		postings int(4) NOT NULL default '0',
				  guthaben int(11) NOT NULL default '0',
				  month    int(11) NOT NULL default '30',
			  	pay      int(4) NOT NULL default '0',
			  	betrag   int(4) NOT NULL default '0'
				) TYPE=MyISAM;");
				$db->query("INSERT INTO " . TABLE_PREFIX . "sudoku_config (betrag) VALUES (0)");

				$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "sudoku_user;");
				$db->query("CREATE TABLE " . TABLE_PREFIX . "sudoku_user (
				  userid   int(11) NOT NULL default '0',
				  ingame   int(2) NOT NULL default '0',
		  		level    int(2) NOT NULL default '0',
					pgame    text NOT NULL,
					ogame    text NOT NULL,
			  	score    int(11) NOT NULL default '0',
			  	time     int(11) NOT NULL default '0',
				  endtime  int(11) NOT NULL default '0',
				  mistakes int(4) NOT NULL default '0'
				) TYPE=MyISAM;");

				$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "sudoku_highscore;");
				$db->query("CREATE TABLE " . TABLE_PREFIX . "sudoku_highscore (
				  userid   int(11) NOT NULL default '0',
			  	level    int(2) NOT NULL default '0',
				  score    int(11) NOT NULL default '0',
			  	playtime int(11) NOT NULL default '0',
				  mistakes int(4) NOT NULL default '0'
				) TYPE=MyISAM;");

				$db->show_errors();
			]]></installcode>
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03440 seconds
  • Memory Usage 1,772KB
  • 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
  • (1)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