vb.org Archive
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   An error in the rpg_install.php (https://vborg.vbsupport.ru/showthread.php?t=77565)

Revan 03-07-2005 06:54 AM
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.

animedj 03-07-2005 12:14 PM
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.

Revan 03-07-2005 02:27 PM
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

hXc Radio 03-07-2005 07:20 PM
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

Blootix 03-08-2005 11:32 PM
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 >_<

animedj 03-09-2005 01:03 AM
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`

Revan 03-09-2005 01:45 PM
Yeah, I really should setup localhost with a prefix...

Blootix 03-09-2005 09:45 PM
Quote:
Originally Posted by Revan
Yeah, I really should setup localhost with a prefix...
Problem solved. Successfully installed! Yay!

bluesteel 03-11-2005 03:57 PM
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.

Revan 03-11-2005 04:14 PM
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....*


All times are GMT. The time now is 01:42 AM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

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.01009 seconds
  • Memory Usage 1,762KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete