vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   RPG Integration Hack (https://vborg.vbsupport.ru/showthread.php?t=108790)

Replicators 03-25-2006 05:09 AM

Just ignore that step

xlegends 03-25-2006 05:55 AM

Quote:

Originally Posted by Replicators
Just ignore that step


Thanks rep, everything installed fine and I can enter the different scripts of the hack.

Having huge db problem, I cant seem to save the character creation which is required before doing anything,.,.



Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE rpg_user SET
ap = 60,
maxhp = 45,
maxmp = 33,
maxpp = 53,
hp = 45,
mp = 33,
pp = 53,
elementid = 2,
alignmentid = 2,
raceid = 2,
genderid = 3,
classid = 61,
typeid = 1,
inputlevel = 0,
dropdown = 1,
canchallenge = 1,
rpgname = 'DBG'
WHERE userid = 7105;

MySQL Error : Unknown column 'inputlevel' in 'field list'
Error Number : 1054
Date : Saturday, March 25th 2006 @ 07:53:41 AM
Script : /http://www.xxxxxxxxxx.com/forums/headquarters.php
Referrer : /http://wwwxxxxxxxxxx.com/forums/headquarters.php?

Ziki 03-25-2006 06:15 AM

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(`monsterbattleid`) AS `ibotbattles` FROM `forumziki_rpg_monster_battles`;

MySQL Error : Unknown column 'monsterbattleid' in 'field list'
Error Number : 1054
Date : Friday, March 24th 2006 @ 11:28:47 PM
Script : http://www.zikihideout.com/forums/monsterarena.php?
Referrer : http://www.zikihideout.com/forums/monsterarena.php?
IP Address : 87.197.143.145
Username : ZIKI-SET
Classname : vb_database

Revan can you please look at it?There are tables missing...

Revan 03-25-2006 08:52 AM

I will release an update that will fix all these issues in 5 minutes.

Revan 03-25-2006 09:01 AM

Beta 5 Released

I had to make this quick update because I messed up badly on the SQL tables, causing many people to have errors.
Terribly sorry for the mess, it should all be good now.

Replicators 03-25-2006 11:49 AM

We don't expect you to be perfect >8)

EDIT: Encountered this error while making a monster battle..

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

                INSERT INTO sf_rpg_monster_battles
                        (`owner`,
                        `opponent`,
                        `battlestate`,
                        `turnid`,
                        `lastactive`,
                        `wager`,
                        `sceneid`,
                        `musicid`)
                VALUES
                        ('1',
                        '32',
                        '1',
                        '1',
                        '1143295803',
                        '3',
                        '4',
                        '0');

MySQL Error  : Unknown column 'musicid' in 'field list'
Error Number : 1054
Date        : Saturday, March 25th 2006 @ 06:10:03 AM
Script      : http://***.******.***/monsterarena.php
Referrer    : http://***.******.***/monsterarena.php?do=newbattle
IP Address  : **.**.***.***
Username    : Replicators
Classname    : vb_database


Revan 03-25-2006 02:04 PM

[sql]ALTER TABLE `rpg_monster_battles` CHANGE `midi` `musicid` INT( 10 ) NOT NULL DEFAULT '-1'[/sql]
remember to add a table prefix.
Also will be updating the file shortly.

Replicators 03-25-2006 02:09 PM

That worked, but then i got this...

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

                INSERT INTO sf_rpg_ibot_templates
                        (`userid`,
                        `ibotid`,
                        `hp`,
                        `maxhp`,
                        `mp`,
                        `maxmp`,
                        `pp`,
                        `maxpp`,
                        `ap`)
                VALUES
                        ('1',
                        '1',
                        '30',
                        '30',
                        '10',
                        '10',
                        '7',
                        '7',
                        '0');

MySQL Error  : Duplicate entry '1' for key 1
Error Number : 1062
Date        : Saturday, March 25th 2006 @ 08:07:56 AM
Script      : http://***.******.***/monsterarena.php
Referrer    : http://***.******.***/monsterarena.php?do=newbattle
IP Address  : **.**.***.***
Username    : Replicators
Classname    : vb_database


Revan 03-25-2006 02:59 PM

That's because the battle creation halted where it shouldn't have. Run these two:
[sql]TRUNCATE TABLE `rpg_monster_battles`[/sql]
[sql]TRUNCATE TABLE `rpg_ibot_templates`[/sql]

Otikeu 03-25-2006 10:05 PM

So, how do we update from (I believe BETA 1) to BETA 5?

Also a feature request. Maybe save a payment history, incase someone like me needs to revamp their item choices (aka remove spells for different types) and will like to refund all money spent for the items? I'd be a life saving feature... ;)


All times are GMT. The time now is 11:02 PM.

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.01373 seconds
  • Memory Usage 1,750KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (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