Thread: Tutorial Hack
View Single Post
  #6  
Old 11-30-2003, 08:41 PM
kaotic's Avatar
kaotic kaotic is offline
 
Join Date: Mar 2003
Posts: 259
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've got it installed now, but I did find one problem. In your instructions, it says to run this query:

Quote:
CREATE TABLE tutorials (
tutid tinyint(11) unsigned NOT NULL auto_increment,
tutname varchar(100) NOT NULL default '',
tutpagetext longtext NOT NULL,
tutposted int(10) unsigned default NULL,
tutcat tinyint(5) NOT NULL default '0',
tutposterid tinyint(2) NOT NULL default '0',
tutpostername varchar(50) NOT NULL default '',
tutvotes int(11) NOT NULL default '0',
tutviews int(11) NOT NULL default '0',
catid` varchar(50) NOT NULL default '0',
PRIMARY KEY (`tutid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
Instead, it should be:

Quote:
CREATE TABLE tutorials (
tutid tinyint(11) unsigned NOT NULL auto_increment,
tutname varchar(100) NOT NULL default '',
tutpagetext longtext NOT NULL,
tutposted int(10) unsigned default NULL,
tutcat tinyint(5) NOT NULL default '0',
tutposterid tinyint(2) NOT NULL default '0',
tutpostername varchar(50) NOT NULL default '',
tutvotes int(11) NOT NULL default '0',
tutviews int(11) NOT NULL default '0',
catid varchar(50) NOT NULL default '0',
PRIMARY KEY (`tutid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
With exception of that minor flaw, good hack, good instructions, good job!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01878 seconds
  • Memory Usage 1,763KB
  • 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_quote
  • (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