RPG Integration Hack - Old Support Thread

Nice conversion there mate, lot of work has gone into it so well done and thanks for sharing it

[DaPro]

WHen using the new installer I made, you have to make sure you delete ALL THE OLD MYSQL TABLES FROM YOUR DATABASE OR IT WILL NOT WORK. That is all there is to it. I mean come on people, it is not that hard :-/.

[Rahzel_hx]

i still get invaild battle or password..... thats with the new battlefight.php

i delted them by hand....

The battles work now ^___^ thnx i used old installer and the new battlefight.php

but the back ground pictures don't show

Edit: fix back ground

[Zantheus]

Originally Posted by Revan

Are you sure you did the file edits correctly?
Because that table was only there in the "pre-Gold" file edits (of profile.php I might add), and I just checked the readme as I type this, the rpg_datastore aint there
Try to dload the new zip, because this I also just checked and the file edit is gone.

For a hotfix; heres what you do:

profile.php
##########################
Find (both instances of):
--------------------------

		$rpgdatafetch = $DB_site->query("SELECT * FROM ".TABLE_PREFIX."rpg_datastore");
		$rpgdata = $DB_site->fetch_array($rpgdatafetch);



Replace with:
---------------------------

		$rpgdata = $DB_site->query_first("SELECT namefield AS rpgname FROM ".TABLE_PREFIX."rpg_battle_options");

Hope this helps, and if you run into more problems, please consult the rpg_SP1_2.5gold.txt linked to from the first post, and see if you lack those edits

Now when I goto click it, it works, just where I think all the selections should be, the page is blank with the left menu still visible - please help!

[fade]

woohoo!! installed and running just spiffy! great stuff

[ogetbilo]

PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE rpg_clan SET 
            title='Dungeon', 
            pass='test',
            logo='.................com/........./dungeon.jpg',
            ally='0',
            enemy='4',
            sb_settings='',
            col1='5',
            col2='7',
            col3='16',
            col4='0',
            sb_col_access='',
            cm_col_access='0',
            ci_col_access='0',
            rm_col_access='0', 
        WHERE clanid=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 'WHERE clanid=2' at line 16

mysql error number: 1064

Date: Thursday 26th of August 2004 05:12:03 AM
Script: [url]http://forum...........com/clancp.php?action=edit[/url]
Referer: [url]http://forum.............com/clancp.php?action=editclan[/url]
Username: ........
IP Address: ............. 


I get this error when I try to update the clan settings.
Do you know how can I fix it ?

Also I got the version 2.3 and now I want to update the games but I couldnt find any instructions for update.

[Rahzel_hx]

Few Errors:
#1,

Warning: Constants may only evaluate to scalar values in /home/spiritno/public_html/forum/includes/init.php on line 343

i get this when i update midis

#2 Midis don't play in battle

#3 Invalid Scene 'style/kingdom.jpg'. in top right corner of screen during battle (happens with all back grounds)

#4 In the profile section it says location i put Everett there since that is my location... and then i goto my rpg info and everett is now my name >_<

[deathemperor]

#4 In the profile section it says location i put Everett there since that is my location... and then i goto my rpg info and everett is now my name >_<

you didn't make a profile field for RPG Name, the default of this RPG is field2, it's your location

[Rahzel_hx]

oh ok one down 3 togo

[Ganon]

I get the following error when I try to use "update rpg info" in my user cp....

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT rpgclass, rpggender, rpgrace, alignment, element, inbattle, rpgstats FROM user WHERE userid='1'
mysql error: Unknown column 'rpgstats' in 'field list'

mysql error number: 1054

Date: Wednesday 25th of August 2004 10:24:56 PM
Script: http://www.ganonstower.com/forums/pr...p?do=updaterpg
Referer:
Username: Ganon
IP Address: xx.x.xxx.xxx

[fade]

hrmz. same problem as ganon as well