Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > RPG Integration Hack
Reload this Page An error in the rpg_install.php
FAQ Community Calendar Today's Posts Search

Reply
Page 2 of 3 1 2 3
 
Thread Tools
An error in the rpg_install.php Details »»
An error in the rpg_install.php
Version: , by Blootix Blootix is offline
Developer Last Online: Nov 2015 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 03-06-2005 Last Update: Never Installs: 0
 
No support by the author.

There's an error in rpg_install.php.

Code:
Parse error: parse error, unexpected ')', expecting ']' in /home/phalanx/public_html/testvb/admincp/rpg_install.php on line 1516
Fresh install on a test board in vB 3.0.7.

Show Your Support

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

Comments
  #12  
Old 03-07-2005, 06:54 AM
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Location: Norway
Posts: 1,671
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It is missing a comma after [sql]`itid3` int(11) NOT NULL default '0'[/sql]
Im uploading a fixed file now.
To remedy this, you have to run uninstall on everything apart from queries, then manually drop every table it has created so far, including the stuff in the user table, then reinstall.
Alternatively, IF the uninstall process is designed like I think, you can TRY to uninstall and see if it does undo the changes.
Reply With Quote
  #13  
Old 03-07-2005, 12:14 PM
animedj animedj is offline
 
Join Date: Mar 2005
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
found sql 2 errors in today's update:

Code:
$RPG_sql['populate']['query']['rpg_element'] = "
INSERT INTO `" . TABLE_PREFIX . "rpg_element`
	(`name`, `hp`, `ma`, `pp`, `ap`)
VALUES
	('Unknown', '0', '0', '0', '0'),
	('Dark', '30', '30', '50', '60', '0', '0', '5', '0'),
I'm guessing it should go like this:

Code:
$RPG_sql['populate']['query']['rpg_element'] = "
INSERT INTO `" . TABLE_PREFIX . "rpg_element`
	(`name`, `hp`, `ma`, `pp`, `ap`, `str`, `def`, `strength`, `weakness`)
VALUES
	('Unknown', '0', '0', '0', '0', '0', '0', '0', '0'),
	('Dark', '30', '30', '50', '60', '0', '0', '5', '0'),
also I found:

Code:
INSERT INTO " . TABLE_PREFIX . "rpg_items_cats 
	(`name, `description`, `catorder`, `ownerid`, `sold`, `profit`, `battletype`, `itemonofforder`)
VALUES
ownerid doesn't exist in the new tables created so I removed it.

Code:
INSERT INTO " . TABLE_PREFIX . "rpg_items_cats 
	(`name, `description`, `catorder`, `sold`, `profit`, `battletype`, `itemonofforder`)
VALUES
Also another bug that I just found was creating my character. It said that 'rpgstats' didn't exists in my user table so I had to create it manually.
Reply With Quote
  #14  
Old 03-07-2005, 02:27 PM
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Location: Norway
Posts: 1,671
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I fixed all those problems, and did some tweaking on the installer.
It was falsely letting you select multiple options for Uninstall, when testing has shown this to be impossible to accomplish.
Fix to be uploaded soon, I just need to test some other stuff first
Reply With Quote
  #15  
Old 03-07-2005, 07:20 PM
hXc Radio hXc Radio is offline
 
Join Date: Mar 2004
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Revan
Fix to be uploaded soon, I just need to test some other stuff first
awesome! thanks for the fast fixes... *clicks install* and awaits the new installer to be uploaded
Reply With Quote
  #16  
Old 03-08-2005, 11:32 PM
Blootix Blootix is offline
 
Join Date: Feb 2005
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by hXc Radio
awesome! thanks for the fast fixes... *clicks install* and awaits the new installer to be uploaded
Did everybody actually install successfully? Because I reset the test board (with uShop installed), and tried to install again, but the installer gives me this message:
Code:
Database error in vBulletin 3.0.7:

Invalid SQL: 
INSERT INTO vb3_`rpg_class`
	(`name`, `folder`, `regatt`, `magicatt`, `magicdef`, `regdef`, `speed`, `evade`, `type`, `typename`, `visible`, `gender`)
VALUES 
	('Unknown', 'mclasses/nonem', 1, 1, 1, 1, 1, 1, '0', 'Generic', 1, 2),
	('Amazon', 'fclasses/archerf', 8, 8, 6, 8, 5, 5, '0', 'Generic', 1, 1),
	('Archer', 'fclasses/archerf', 9, 7, 6, 8, 5, 5, '0', 'Generic', 1, 1),
	('Archmage', 'fclasses/archmagef', 6, 10, 8, 7, 4, 4, '0', 'Generic', 1, 1),
	('Assassin', 'fclasses/assassinf', 10, 8, 7, 6, 5, 5, '0', 'Generic', 1, 1),
	('Black Mage', 'fclasses/blackmagef', 6, 10, 10, 7, 4, 4, '0', 'Generic', 1, 1),
	('Blacksmith', 'fclasses/blacksmithf', 8, 7, 8, 9, 4, 4, '0', 'Generic', 1, 1),
	('Calculator', 'fclasses/calculatorf', 7, 7, 8, 8, 5, 5, '0', 'Generic', 1, 1),
	('Captain', 'fclasses/captainf', 10, 6, 6, 10, 4, 4, '0', 'Generic', 1, 1),
	('Chemist', 'fclasses/chemistf', 7, 8, 8, 9, 5, 5, '0', 'Generic', 1, 1),
	('Dark Knight', 'fclasses/darkknightf', 9, 9, 6, 7, 4, 4, '0', 'Generic', 1, 1),
	('Dragoon', 'fclasses/dragoonf', 8, 8, 7, 7, 6, 6, '0', 'Generic', 1, 1),
	('Ex-Soldier', 'fclasses/ex-soldierf', 10, 6, 7, 9, 5, 5, '0', 'Generic', 1, 1),
	('Foot Soldier', 'fclasses/footsoldierf', 9, 7, 6, 10, 4, 4, '0', 'Generic', 1, 1),
	('Gambler', 'fclasses/gamblerf', 7, 8, 6, 9, 6, 6, '0', 'Generic', 1, 1),
	('Geomancer', 'fclasses/geomancerf', 7, 8, 9, 8, 4, 4, '0', 'Generic', 1, 1),
	('Holy Knight', 'fclasses/holyknightf', 9, 8, 7, 7, 5, 5, '0', 'Generic', 1, 1),
	('Knight', 'fclasses/knightf', 9, 6, 8, 9, 4, 4, '0', 'Generic', 1, 1),
	('Mediator', 'fclasses/mediatorf', 7, 8, 9, 8, 5, 5, '0', 'Generic', 1, 1),
	('Mercenary', 'fclasses/mercenaryf', 9, 7, 7, 8, 5, 5, '0', 'Generic', 1, 1),
	('Mime', 'fclasses/mimef', 8, 8, 6, 8, 5, 5, '0', 'Generic', 1, 1),
	('Monk', 'fclasses/monkf', 9, 7, 6, 8, 5, 5, '0', 'Generic', 1, 1),
	('Ninja', 'fclasses/ninjaf', 9, 8, 7, 6, 5, 5, '0', 'Generic', 1, 1),
	('Oracle', 'fclasses/oraclef', 9, 7, 6, 9, 6, 5, '0', 'Generic', 1, 1),
	('Red Mage', 'fclasses/redmagef', 9, 7, 7, 9, 5, 5, '0', 'Generic', 1, 1),
	('Samurai', 'fclasses/samuraif', 9, 7, 6, 8, 5, 5, '0', 'Generic', 1, 1),
	('Sniper', 'fclasses/sniperf', 9, 8, 6, 8, 5, 5, '0', 'Generic', 1, 1),
	('Squire', 'fclasses/squiref', 8, 6, 7, 9, 5, 5, '0', 'Generic', 1, 1),
	('Summoner', 'fclasses/summonerf', 9, 7, 6, 7, 6, 6, '0', 'Generic', 1, 1),
	('Thief', 'fclasses/thieff', 8, 7, 6, 7, 6, 6, '0', 'Generic', 1, 1),
	('Time Mage', 'fclasses/timemagef', 8, 5, 6, 8, 7, 6, '0', 'Generic', 1, 1),
	('Vampire', 'fclasses/vampiref', 8, 8, 7, 7, 5, 5, '0', 'Generic', 1, 1),
	('White Mage', 'fclasses/whitemagef', 6, 5, 8, 8, 7, 6, '0', 'Generic', 1, 1),
	('Sky Reaper', 'mclasses/skyreaperm', 8, 8, 6, 8, 5, 5, '0', 'Generic', 1, 1),
	('Archer', 'mclasses/archerm', 9, 7, 6, 8, 5, 5, '0', 'Generic', 1, 2),
	('Archmage', 'mclasses/archmagem', 6, 10, 8, 7, 4, 4, '0', 'Generic', 1, 2),
	('Assassin', 'mclasses/assassinm', 10, 8, 7, 6, 5, 5, '0', 'Generic', 1, 2),
	('Black Mage', 'mclasses/blackmagem', 6, 10, 10, 7, 4, 4, '0', 'Generic', 1, 2),
	('Blacksmith', 'mclasses/blacksmithm', 8, 7, 8, 9, 4, 4, '0', 'Generic', 1, 2),
	('Bodyguard', 'mclasses/bodyguardm', 8, 7, 8, 9, 5, 4, '0', 'Generic', 1, 2),
	('Calculator', 'mclasses/calculatorm', 7, 7, 8, 8, 5, 5, '0', 'Generic', 1, 2),
	('Captain', 'mclasses/captainm', 10, 6, 6, 10, 4, 4, '0', 'Generic', 1, 2),
	('Chemist', 'mclasses/chemistm', 7, 8, 8, 9, 5, 5, '0', 'Generic', 1, 2),
	('Dark Knight', 'mclasses/darkknightm', 9, 9, 6, 7, 4, 4, '0', 'Generic', 1, 2),
	('Dragoon', 'mclasses/dragoonm', 8, 8, 7, 7, 6, 6, '0', 'Generic', 1, 2),
	('Ex-Soldier', 'mclasses/ex-soldierm', 10, 6, 7, 9, 5, 5, '0', 'Generic', 1, 2),
	('Foot Soldier', 'mclasses/footsoldierm', 9, 7, 6, 10, 4, 4, '0', 'Generic', 1, 2),
	('Gambler', 'mclasses/gamblerm', 7, 8, 6, 9, 6, 6, '0', 'Generic', 1, 2),
	('Geomancer', 'mclasses/geomancerm', 7, 8, 9, 8, 4, 4, '0', 'Generic', 1, 2),
	('Holy Knight', 'mclasses/holyknightm', 9, 8, 7, 7, 5, 5, '0', 'Generic', 1, 2),
	('Knight', 'mclasses/knightm', 9, 6, 8, 9, 4, 4, '0', 'Generic', 1, 2),
	('Mediator', 'mclasses/mediatorm', 7, 8, 9, 8, 5, 5, '0', 'Generic', 1, 2),
	('Mercenary', 'mclasses/mercenarym', 9, 7, 7, 8, 5, 5, '0', 'Generic', 1, 2),
	('Mime', 'mclasses/mimem', 8, 8, 6, 8, 5, 5, '0', 'Generic', 1, 2),
	('Monk', 'mclasses/monkm', 9, 7, 6, 8, 5, 5, '0', 'Generic', 1, 2),
	('Ninja', 'mclasses/ninjam', 9, 8, 7, 6, 5, 5, '0', 'Generic', 1, 2),
	('Oracle', 'mclasses/oraclem', 9, 7, 6, 9, 6, 5, '0', 'Generic', 1, 2),
	('Red Mage', 'mclasses/redmagem', 9, 7, 7, 9, 5, 5, '0', 'Generic', 1, 2),
	('Samurai', 'mclasses/samuraim', 9, 7, 6, 8, 5, 5, '0', 'Generic', 1, 2),
	('Sniper', 'mclasses/sniperm', 9, 8, 6, 8, 5, 5, '0', 'Generic', 1, 2),
	('Squire', 'mclasses/squirem', 8, 6, 7, 9, 5, 5, '0', 'Generic', 1, 2),
	('Summoner', 'mclasses/summonerm', 9, 7, 6, 7, 6, 6, '0', 'Generic', 1, 2),
	('Thief', 'mclasses/thiefm', 8, 7, 6, 7, 6, 6, '0', 'Generic', 1, 2),
	('Time Mage', 'mclasses/timemagem', 8, 5, 6, 8, 7, 6, '0', 'Generic', 1, 2),
	('Vampire', 'mclasses/vampirem', 8, 8, 7, 7, 5, 5, '0', 'Generic', 1, 2),
	('White Mage', 'mclasses/whitemagem', 6, 5, 8, 8, 7, 6, '0', 'Generic', 1, 2)

mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'rpg_class`
	(`name`, `folder`, `regatt`, `magicatt`, `magicdef`

mysql error number: 1064
I don't think it'll work on the real board if it doesn't work here... Need a fix >_<
Reply With Quote
  #17  
Old 03-09-2005, 01:03 AM
animedj animedj is offline
 
Join Date: Mar 2005
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
ahh see the problem, in install/rpg_mysql-schema.php look for

Code:
$RPG_sql['populate']['query']['rpg_class'] = "
INSERT INTO " . TABLE_PREFIX . "`rpg_class`
and replace for

Code:
$RPG_sql['populate']['query']['rpg_class'] = "
INSERT INTO `" . TABLE_PREFIX . "rpg_class`
Reply With Quote
  #18  
Old 03-09-2005, 01:45 PM
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Location: Norway
Posts: 1,671
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yeah, I really should setup localhost with a prefix...
Reply With Quote
  #19  
Old 03-09-2005, 09:45 PM
Blootix Blootix is offline
 
Join Date: Feb 2005
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Revan
Yeah, I really should setup localhost with a prefix...
Problem solved. Successfully installed! Yay!
Reply With Quote
  #20  
Old 03-11-2005, 03:57 PM
bluesteel bluesteel is offline
 
Join Date: Feb 2003
Location: Macclesfield, UK
Posts: 60
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Hi again Revan

When I tried to save changes in Headquarters, I got an SQL error. Complained about field5 not existing in the userfields table. Checked it, and sure enough field5 was missing!
Added it manually using myPHPAdmin and it works ok now.
Reply With Quote
  #21  
Old 03-11-2005, 04:14 PM
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Location: Norway
Posts: 1,671
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
That is because the AdminCP setting was set to use field5.
Adding it manually is not recommended as it will not work as expected.
You must update the ACP setting yourself.
*thinks he has to code a fix for this as people can't seem to find that setting....*
Reply With Quote
Reply
Page 2 of 3 1 2 3

« Previous Thread | Next Thread »

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 06:00 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04889 seconds
  • Memory Usage 2,314KB
  • Queries Executed 25 (?)
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
  • (8)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete