Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > RPG Integration Hack
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Some db errors Details »»
Some db errors
Version: , by jvillan jvillan is offline
Developer Last Online: Feb 2005 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 02-22-2005 Last Update: Never Installs: 0
 
No support by the author.

Im getting the following errors after install (upgrading to 3.0.7 THEN installed the hack):

when i go to RPG Main :
Code:
Database error in vBulletin 3.0.7:

Invalid SQL: 
		SELECT
			user.userid,
			user.username,
			user.rpgclass,
			user.element,
			user.rpgrace,
			user.rpgtype AS rpgtype,
			user.alignment,
			user.rpggender,
			user.posts,
			user.maxhp,
			user.maxma,
			user.maxpp,
			user.inbattle,
			user.xp,
			user.ma AS uma,
			user.hp AS uhp,
			user.pp AS upp,
			user.ap AS uap,
			user.uttpoints AS money,
			rpg_battle_options.namefield AS namefield, 
			userfield.*,
			rpg_battle_options.exprate,
			rpg_battle_options.privacy AS battleprivacy,
			rpg_items_user.*,
			rpg_battle_stats.*,
			rpg_rpg_race.name AS rpgracename,
			rpg_rpg_race.alignment AS rpgalignmentname,
			rpg_rpg_classf.name AS fclassname,
			rpg_rpg_classf.folder AS fclassfolder,
			rpg_rpg_classm.name AS mclassname,
			rpg_rpg_classm.folder AS mclassfolder,
			rpg_rpg_element.name AS elename
		FROM rpg_battle_options
			LEFT JOIN user ON user.userid=10002
			LEFT JOIN userfield ON userfield.userid=user.userid   
			LEFT JOIN rpg_items_user ON rpg_items_user.userid=user.userid
			LEFT JOIN rpg_battle_stats ON rpg_battle_stats.userid=user.userid
			LEFT JOIN rpg_rpg_classf ON rpg_rpg_classf.id=user.rpgclass
			LEFT JOIN rpg_rpg_classm ON rpg_rpg_classm.id=user.rpgclass
			LEFT JOIN rpg_rpg_element ON rpg_rpg_element.elementid=user.element
			LEFT JOIN rpg_rpg_race ON rpg_rpg_race.raceid=user.rpgrace AND rpg_rpg_race.alignmentid=user.alignment
	
mysql error: Unknown column 'user.uttpoints' in 'field list'
Itemshop:
Code:
Invalid SQL: SELECT uttpoints FROM user WHERE userid=10002
mysql error: Unknown column 'uttpoints' in 'field list'
Edit Your Character:
Code:
Invalid SQL: SELECT rpgclass, rpggender, rpgrace, alignment, element, inbattle, rpgstats FROM user WHERE userid='10002'
mysql error: Unknown column 'rpgstats' in 'field list'
Healing Center:
Code:
Invalid SQL: SELECT uttpoints AS money FROM user WHERE userid='10002'
mysql error: Unknown column 'uttpoints' in 'field list'
hope i can get this working soon, thanks!

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 02-22-2005, 05:31 PM
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Location: Norway
Posts: 1,671
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

* Install uCS hack
* Run ALTER TABLE `user` ADD `rpgstats` char(1) NOT NULL DEFAULT '1'
Reply With Quote
Reply


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 05:12 AM.


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.06538 seconds
  • Memory Usage 2,198KB
  • Queries Executed 15 (?)
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
  • (4)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (1)postbit
  • (2)postbit_onlinestatus
  • (2)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete