vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   RPG Integration Hack - Old Support Thread (https://vborg.vbsupport.ru/showthread.php?t=73868)

DaPro 08-25-2004 04:09 PM

I downloaded whats in the first post, and nothing worked right, so I tried looking around these posts for help and I eventually found a bunch of random txt files that helped me to set everything up perfectly. It was just really messed up and found SP txt and all these other readme's, and what not. :-/

Revan 08-25-2004 04:17 PM

this isnt making much sense...
If you downloaded the zip that has the "Gold" in it, then it has all the fixes already applied to both its main readme and the hack php files.
This I know because I can look at the rpg files right now, and I can see that it has all the fixes from the SP (Service Pack) integrated in them.
If your talkin about all the readmes inside the zip, then you shouldnt worry about anything but the RPG SYS INSTALL. All the other files I keep in there for copyright purposes, as I believe Bitsys made that txt to give credit where credit is due :)
If your talkin about the req_limitations.txt, I put that in there because I wanted to make people aware of the Requirements and Limitations this hack got.

And theres no other txt files than the one in the main post, and the ones in the addon post.
I HAVE to keep the SP txt file in that other post, because if not, users who still got the "pre-Gold" version might come back and find everyone saying "this works" and theirs dont.


Anyways, if you can clean up the templates and get them validated against XHTML 1.0 Transitional, then you da man! ;)
Templates was until now the only help request I didnt get filled ;)


EDIT: I do know this hack doesnt look very professional... And its not, Im just one guy here....
Im not a 1337 coder, nor am I a HTML guru... I learned tons of things just through the convert of this hack...

I just did it because I wanted to let vB gain back what wBB took, because I wanted to offer an alternative to a paid hack, and because I believe in sharing :)

If anyone wants to be my "PR Person" and can help me in making this look more professional, then its welcomed with thanks and credit just like every other helper :)

DaPro 08-25-2004 04:34 PM

It's ok dude, I am not knocking the hustle, I am just saying it was extremely hard to get this working. I am glad you put so much work into this, I was just frustrated. I must have ++++ed up somewhere in the process so don't mind me. I will do the templates next week. Stay tuned!!!

Zantheus 08-25-2004 04:43 PM

Hello Fellow Users,

I also recently tried to install this hack, got the installer working and everything now, and added one fix from here to it, but it is not letting me goto "Update RPG info" it comes up with the following error:

Quote:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM rpg_datastore
mysql error: Table 'burning_forums.rpg_datastore' doesn't exist

mysql error number: 1146
Help would be greatly appreciated, thanks in advance!

Revan 08-25-2004 05:28 PM

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:
Code:

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 :)

Rahzel_hx 08-25-2004 07:15 PM

I still get invaild battle or password .... i dunno why i used the update sp1 any ideas?

Revan 08-25-2004 07:31 PM

Try to reupload the battlefight.php from the new zip?
Before the gold came out, the hack was tested to bits so there shouldnt be such errors....

Rahzel_hx 08-25-2004 07:39 PM

too late i already screwd things up >_< lol i will have to reinstall it all... or something >_> i messed the databases up and i tryed the new installer and it can't add some data table rpg_items_options but i can add it usin that sql entry .... weird bbl gotta reinstall X(

But the old installer adds it no problem?

Edit: i fixed w/e was wrong with it so far ...*goes to test battles*

Revan 08-25-2004 07:47 PM

Ok this is severey pissing me off now.
50 % are having errors with the old installer
50 % are having errors with the new installer
wtf am I supposed to do...? *goes to cry in the corner*

But seriously now.
Im tempted to just drop this whole ++++in installer deal and give people a SQL file to use.
You know what Im gonna do that for the next version.
Lotsa other people do it.
Installers are for ponces
XD

Rahzel_hx 08-25-2004 07:53 PM

lol i agree sry about all the trouble, but no installer will make it work better cause then if it don't work its the person installing its fault ^_^

DaPro 08-25-2004 07:56 PM

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 08-25-2004 07:59 PM

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 08-26-2004 12:31 AM

Quote:

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:
Code:

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 08-26-2004 12:45 AM

woohoo!! installed and running just spiffy! great stuff

ogetbilo 08-26-2004 01:15 AM

PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQLUPDATE 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 08-26-2004 01:29 AM

Few Errors:
#1,
Code:

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 08-26-2004 01:57 AM

Quote:

#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 08-26-2004 02:19 AM

oh ok one down 3 togo

Ganon 08-26-2004 02:25 AM

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 08-26-2004 03:32 AM

hrmz. same problem as ganon as well

Rahzel_hx 08-26-2004 08:44 AM

Quote:

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

umm how do i go about doing this lol confused my self....

DaPro 08-26-2004 01:23 PM

Well I was testing this hack out, and there are far to many errors to be considered ready for use, my advise to anyone using this script is to USE AT YOUR OWN RISK and make a backup before using! When the hack gets a little more official I would suggest getting it, but right now I suggest to all to wait and let the hacks porters and creators really beta test it out. Sorry Raven, this hack is really not ready for release man. Later!

Revan 08-26-2004 01:42 PM

Quote:

Originally Posted by Zantheus
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!

Sounds like you didnt import the rpg_templates.xml into your current style.
If you did, then theres no reason why this would happen.


Quote:

Originally Posted by ogetbilo
PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQLUPDATE 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.

1. that error is already fixed
2. Read the first post :)


Quote:

Originally Posted by Rahzel_hx
Few Errors:
#1,
Code:

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)

#1: I dont know how to fix this. The adding of midis works fine, so I consider this very low priority
#2: Yes they do, but ONLY in IE. If you are using Firefox, you need to get an extension that allows the playing of BGSOUND elements.
"Why dont you use embed instead!?"
Because I found this caused a box to appear in the top corner, which looked ugly.
If anyone can tell me the code to make the EMBED completely invisible, do tell me please :)
#3: You probably didnt upload the images for them, or you put the images from "images2.zip" in the wrong place. The file is there and it works fine here ;)


Quote:

Originally Posted by 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

You didnt run the query for the RPG Stats addon.
Please fetch that txt from the Addons post (linked to from the first post) and run the query inside. :)

Kalakov 08-26-2004 01:56 PM

Quote:

Originally Posted by Revan
................
You didnt run the query for the RPG Stats addon.
Please fetch that txt from the Addons post (linked to from the first post) and run the query inside. :)



what is the name of the txt file ? :) (having the same prob)

Revan 08-26-2004 03:04 PM

Its the "User Select RPG Postbit" txt file.
(Not like there was a ton of them ;) )

Heres the query to run:
[sql]ALTER TABLE `user` ADD `rpgstats` CHAR(1) NOT NULL DEFAULT '1';[/sql]
(Remember to add a prefix if you use one)

Kalakov 08-26-2004 03:26 PM

Ahhhhhh :) dint see it in the RPG SYSTEM INSTALL.txt file

it works Perfect now =)



fiskeboller !

Kalakov 08-26-2004 05:22 PM

If anyone want to test it check www.thewired.be user: "test" pass: "test"

Ganon 08-26-2004 07:11 PM

Quote:

Originally Posted by Revan
Its the "User Select RPG Postbit" txt file.
(Not like there was a ton of them ;) )

Heres the query to run:
[sql]ALTER TABLE `user` ADD `rpgstats` CHAR(1) NOT NULL DEFAULT '1';[/sql]
(Remember to add a prefix if you use one)

It's working perfect now, thanks! :D

Valr the Slain 08-26-2004 08:45 PM

When in "Edit Items", the items seem to not show up for me to edit. There isn't any errors listed, but when I click "Update Items", I receive this error:

Warning: Variable passed to each() is not an array or object in /home/initial/public_html/forums/admincp/itemadmin.php on line 292

The line 292 contains the following:

PHP Code:

while (list($key,$val) = each($name) AND list($key,$val2) = each($cat

What could be the problem?

designstylez 08-26-2004 09:00 PM

I get the same error.


Quote:

Originally Posted by Valr the Slain
When in "Edit Items", the items seem to not show up for me to edit. There isn't any errors listed, but when I click "Update Items", I receive this error:

Warning: Variable passed to each() is not an array or object in /home/initial/public_html/forums/admincp/itemadmin.php on line 292

The line 292 contains the following:

PHP Code:

while (list($key,$val) = each($name) AND list($key,$val2) = each($cat

What could be the problem?


Ganon 08-26-2004 09:47 PM

A member on my board is trying to get into the "edit RPG info" link in her User CP. It goes incredibly slow and eventually times out. She gave me permission to log into her account, to see if it's a problem with her account or her computer, and I had the same problem. It works fine for me under my name, and a couple test names I have set up on the board. Any suggestions?

Rahzel_hx 08-27-2004 12:09 AM

lol the pictures show up for the background images but there is writing in the top right of the screen that is all... ( everything is in the right place.. soo i dunno but it don't affect anything so it ok)

hmm i will try in IE.... right now i use myie2 and i don't get sound =(

fade 08-27-2004 01:38 AM

Quote:

Originally Posted by Valr the Slain
When in "Edit Items", the items seem to not show up for me to edit. There isn't any errors listed, but when I click "Update Items", I receive this error:

Warning: Variable passed to each() is not an array or object in /home/initial/public_html/forums/admincp/itemadmin.php on line 292

The line 292 contains the following:

PHP Code:

while (list($key,$val) = each($name) AND list($key,$val2) = each($cat

What could be the problem?

getting this problem as well. had a look around and also found problems with joining a clan. you can send an "invite" to users to join clans and that user will receive a pm, the link to accept the invitation doesn't appear to have the full url, it starts as "http://clancp.php....." also, when i actually go to play a battle, it simply times out (for me and the other player) reporting a time out error message

Quote:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/sites/site93/web/forum/battlefight.php on line 706
any ideas would be great :)

Ganon 08-27-2004 02:00 AM

When I try to edit options for the itemshop, I get this error:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE rpg_items_options SET refund='.75',onofforder='0',minstock='4',maxstock= '7',stockreset='604800',pcost='',padd='',hidelevel ='0'
mysql error: Unknown column 'pcost' in 'field list'

mysql error number: 1054

Date: Thursday 26th of August 2004 09:58:41 PM
Script: http://www.ganonstower.com/forums/admincp/itemadmin.php
Referer:
Username: Ganon
IP Address: xx.x.xxx.xxx

There is also nothing on the board that lets you buy items or anything like that. I'm guessing there's probably another query I missed, or something like that?

Valr the Slain 08-27-2004 02:10 AM

Quote:

Originally Posted by Ganon
A member on my board is trying to get into the "edit RPG info" link in her User CP. It goes incredibly slow and eventually times out. She gave me permission to log into her account, to see if it's a problem with her account or her computer, and I had the same problem. It works fine for me under my name, and a couple test names I have set up on the board. Any suggestions?

This is also a situation that I have been wondering what the problem was. I took the same actions as Ganon and came up with the same results. She once had an error similar to fades, but it was a fatal error to the db_mysql.php file. Unfortunately, I don't have the line anymore.

ogetbilo 08-27-2004 09:09 AM

I reinstalled RPG and I did all the changes that I have to do in the service pack for the showthread.php , profile.php etc...

The only thing that is not working is admncp/itemadmin.php
When I go to admincp and try to edit items I cannot see any item so I cannot edit items.
Also when I try to update Itemshop settings I get the following error.

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE rpg_items_options SET refund='.75',onofforder='1',minstock='4',maxstock='7',stockreset='604800',pcost='',padd='',hidelevel='0'
mysql error: Unknown column 'pcost' in 'field list'

mysql error number: 1054

Date: Friday 27th of August 2004 01:06:04 PM
Script: http://forum.*****.com/admincp/itemadmin.php
Referer: http://forum.*****.com/admincp/itema...action=options
Username: ****
IP Address: *******

I hope this will be the latest bug in this mod.Cause it is one of the best.

Revan 08-27-2004 01:38 PM

Quote:

Originally Posted by Ganon
When I try to edit options for the itemshop, I get this error:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE rpg_items_options SET refund='.75',onofforder='0',minstock='4',maxstock= '7',stockreset='604800',pcost='',padd='',hidelevel ='0'
mysql error: Unknown column 'pcost' in 'field list'

mysql error number: 1054

Date: Thursday 26th of August 2004 09:58:41 PM
Script: http://www.ganonstower.com/forums/admincp/itemadmin.php
Referer:
Username: Ganon
IP Address: xx.x.xxx.xxx

There is also nothing on the board that lets you buy items or anything like that. I'm guessing there's probably another query I missed, or something like that?

This is a bug in the itemadmin.php, summit I left out when I was cleaning out the installer and forgot to check for files actually using those fields...
New itemadmin.php attached, and zip updated.
This itemadmin.php also fixes the "Items doesnt show for edit" bug (which automatically solved the "each()" bug).


Quote:

Originally Posted by fade
getting this problem as well. had a look around and also found problems with joining a clan. you can send an "invite" to users to join clans and that user will receive a pm, the link to accept the invitation doesn't appear to have the full url, it starts as "http://clancp.php....." also, when i actually go to play a battle, it simply times out (for me and the other player) reporting a time out error message

any ideas would be great :)

The clancp stuff was a small mishap on my side, just open clancp.php and find [php][URL=clancp.php[/php]
change to
[php][URL=http://your.forum/url/clancp.php[/php]
zip updated with this, also readme updated.

About the timeout errors (both of them), that is impossible to determine and fix. I have just tried the battle AND update rpg info, reinstalled with the newest installer. I assure you I made no hotfixes to my files, and I used all the php files in the current zip.
This is a server side problem, Im sure of it... sorry... :(
My friend DeMiNe0 suggests that you could try putting turk MM cache on your server or php accell.
Just dont ask me what any of that means :p


Quote:

Originally Posted by Ganon
A member on my board is trying to get into the "edit RPG info" link in her User CP. It goes incredibly slow and eventually times out. She gave me permission to log into her account, to see if it's a problem with her account or her computer, and I had the same problem. It works fine for me under my name, and a couple test names I have set up on the board. Any suggestions?

You should try running the DB Fix. Her id might not show in the record and for some reason this times the script/browser out.
If its not that, then theres no solution.



To summarize for those reading this, the changes in the zip now is:
itemadmin.php errors fix
chancp.php bug fix
readme updated (added recommended values for Modifiers in the Edit Options of the Battle category)

oldfan 08-27-2004 03:00 PM

How stable is this addon?
I wanna install it, but I'm reading about alot of errors.
Or is that user end errors?
Thanks, lookin good :)

Revan 08-27-2004 03:16 PM

AFAIK theres no more bugs left.
IF you should discover any new bugs, I can 99 % guarantee it will be fixed/explained within 24 hours, usually as soon as I check back on this thread and read the error report (depending on the details of your report of course).

Actually the only trivial "bug" left is this warning notice that seems to appear on the adding of midi's, but it works 100 % so dont worry about that :)


If you do install it now, then please click the install button ;)

designstylez 08-27-2004 03:20 PM

Having some problems with itemshop.php...

When I click on Expand All Generic Items, it works. But when I click on Expand for Available Weapons or Available Accessories, nothing happens. It does not expand.

But anyways, this RPG thing is tite!!! I Love it!


All times are GMT. The time now is 08:06 AM.

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.01803 seconds
  • Memory Usage 1,900KB
  • 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
  • (5)bbcode_code_printable
  • (5)bbcode_php_printable
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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