RPG Integration Hack - Old Support Thread

[MindTrix]

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

[Polo]

Looks nice! will install it in my local computer for testing ;)

[sblum]

Looks like a really awesome hack, but the last thing I need is more stuff to distract my members from posting :). Maybe I'll install this locally to test it out.

[skinvb]

yeah its cool mod which many people is waiting it.You did a great work.Thanks a lot

[AN-net]

is there an itemshop?

[Beowolf]

Looks awesome, I will have to check it out.

[Ryan Ashbrook]

is there an itemshop?
Yeah, it's got one built-in.

I'll test on my test vB. :)

[TheRayden]

I'm installing it right now, and the only remark I have is to adjust the install instructions a bit.
It's very confusing if you have to jump from editing templates to editing .php in /admincp then to root back to /admincp and back to templates and to /includes and so on and so on. :)

Perhaps you could group it so it has a little more structure.

[Virulent1]

Is this lottery for Ushop? or will any of this have an effect on UShop?

[TheRayden]

When I run the installer.php I get this error:

Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE `user` ADD `rpgclass` int(3) NOT NULL,
ADD `rpgrace` int(3) NOT NULL,
ADD `alignment` int(3) NOT NULL,
ADD `rpgtype` int(3) NOT NULL,
ADD `rpggender` int(3) NOT NULL,
ADD `hp` int(6) NOT NULL default '0',
ADD `maxhp` int(6) NOT NULL default '0',
ADD `ma` int(6) NOT NULL default '0',
ADD `maxma` int(6) NOT NULL default '0',
ADD `pp` int(6) NOT NULL default '0',
ADD `maxpp` int(6) NOT NULL default '0',
ADD `ap` int(6) NOT NULL default '0',
ADD `element` int(3) NOT NULL default '0',
ADD `inbattle` int(3) NOT NULL default '0',
ADD `xp` int(11) NOT NULL default '0',
ADD `clan` smallint(5) NOT NULL default '0';
mysql error: Table '2679db1.user' doesn't exist

mysql error number: 1146

[Revan]

TheRayden, I'll check this out and edit this post with results. Ill also touch up the installer ;)

Virulent1, the lottery is a standalone hack, it does not affect uShop in any way.
You cant gain anything from the uShop either, its just gambling with money.
(Provided I understood your question correctly) ;)


EDIT: Main post updated with a new zip.
Errors fixed and readme cleaned up. Sorry for the hassle.
:)

[???`S?LV?R???`]

looks interesting... not sure if i'll use it though

[TheRayden]

Thanks for the quick respond Revan.
Do I just upload the new files or do I have to make some edits again as well?

[Revan]

You can actually just replace the battleinstall.php in the install folder ;)

[TheRayden]

Ok, the install part worked now. :)

But, when I go to my profile and want to edit the rpg info I get this:
Database error in vBulletin 3.0.3:

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

mysql error number: 1054

[Revan]

crap crap and utter crap :(
Thats for an addon I made for my own forums, I was sure I didnt include it in the readme :(

Sorry again for the hassle...
Just redo the profile.php edits in this new readme (main zip updated):

[M1th]

Is this live on any forums so I can see how it looks/works? thanks :)

[TheRayden]

Ok, another step further. :)

I'm now able to change the options, but when I hit the submit button, I'm getting a blank page.
When I check back, the options didn't save.

[Revan]

Weird. This didnt happen to me, I can do it fine on the localhost right now....
Ill try some more then.

EDIT: Im sorry I cant reproduce this.
Its working fine on my 3.0.0 on localhost, and I copied the installer code directly, overwriting the code I had there.
You can try to edit the actiontemplate array in the beginning, change
'modifyrpg' => array(
'modifyrpg'
),

to
'updaterpg' => array(
'modifyrpg'
),


Thats really all I can find remotely cause of this error.

[Dark Dragon]

cool hack, couple of error though..

- images are missing (unless I'm not thinking right)
- battle logging = gone ?

[Polo]

- images are missing (unless I'm not thinking right)

yeah, that was the same thing that i been wondering since I downloaded the file..... actually since my first post... where are the images and the midi files...

[Revan]

cool hack, couple of error though..
- battle logging = gone ?
Yes, thats gone cos I just couldnt get the damn thing to work. It would show the thread on the main page but the id and text of it was a complete mess, so I decided to scrap it.


And about the images, balls. :knockedout:
I swear they were in there when I made the zip! and...stuff... *looks around and whistles*

*updates zip*
Had to add them in 2 seperate attachments because of the filesize limit.


And theres no midi files, you have to add the midis yourself ;)

[Polo]

And theres no midi files, you have to add the midis yourself

sounds good ;)

[Holidazed]

Is this lottery for Ushop? or will any of this have an effect on UShop?
I am interested in this too. Does this use its own money system or can we use the uShop money system. The last thing I need is yet another unique money system on my site.

[Revan]

Everything uses uCS money system ONLY :)
(hence the limitation of it needing to be the uttpoints field in the user table ;) )

[Dark Dragon]

I grew tired of entering URLs to get to places, so I made a navigation system. This will add an "RPG" category to your navbar.


In navbar template,

Find:

<td class="vbmenu_control"><a href="calendar.php?$session[sessionurl]">$vbphrase[calendar]</a></td>


Add Above:


<if condition="$show['member']">
<td class="vbmenu_control" id="rpg"><a href="#rpg">RPG</a> <script type="text/javascript"> vbmenu_register("rpg"); </script></td>
</if>



Find:

<!-- / NAVBAR POPUP MENUS -->

Add above:


<if condition="$show['member']">
<!-- RPG Menu -->
<div class="vbmenu_popup" id="rpg_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">

<tr><td class="thead">RPG</td></tr>
<tr><td class="vbmenu_option"><a href="rpgcp.php">RPG Main</a></td></tr>
<tr><td class="vbmenu_option"><a href="battle.php">Battle Arena</a></td></tr>
<tr><td class="vbmenu_option"><a href="itemshop.php">Itemshop</a></td></tr>
<tr><td class="vbmenu_option"><a href="profile.php?do=updaterpg">Edit Your Character</a></td></tr>
<tr><td class="vbmenu_option"><a href="heal.php">Healing Center</a></td></tr>
<tr><td class="vbmenu_option"><a href="battle.php?action=showbattlestats">RPG Top 10</a></td></tr>
<tr><td class="vbmenu_option"><a href="battle.php?action=showuserstats">Check Your Stats</a></td></tr>

</table>
</div>
<!-- / RPG Menu -->
</if>


i think this should be included in the hack

[Virulent1]

Im confused... does this lotto use the UShop money system? If not.. you should think about submitting one im sure alot of people would want this :P

[Revan]

Thanks Dark, I had a similar one almost typed down, it was just a second navbar. But your option used the javascript dropdown which is cooler :)
Ill add them both so users can choose ;)

And Virulent, Everything uses uCS money system ONLY
uCS = uCash & uShop.
Theres NO other money system, EVERYTHING is fully integrated with uCS :)

[SB2002]

i don't know if it is me or not, but the main zip file seems to be missing? If it is me then sorry, it's getting late here, lol

[Revan]

Its all fixed now ;)

BTW I'll be going to bed now, so in the morning I'll check if anyone can confirm/defirm (yes I know thats not a word, sue me) TheRayden's error in the profile. :)


//out

[Polo]

uCS = uCash & uShop.

I was about to ask :rolleyes: thanks for the info ;)

[Holidazed]

Can you give us some screen shots? Or maybe a demo site?

[Dark Dragon]

I have the hack installed on my site, The Mystical Realm (http://www.tmrforums.com).

Anyways, I can't get battles to work. If I confirm/decline a battle, I'll get the "Invalid Password or Battle" error. Can anybody confirm if battles work for you? I'm not sure if it's a mistake I made installing it or a problem with the hack. :(

[Virulent1]

Hey is there a way i can just Install the Lotto for Ucash/Ushop without the RPG? i just want the Lottery system :p hehe

[deathemperor]

Very nice Revan, you've made the quickest move of ever.

the only thing I can make sure from now is you will get busy along


Can you give us some screen shots? Or maybe a demo site?
The screen shots are in the first post as attachment.

@Virulent1: I think You can only do it on your own by removing all of the other things but lottery.

[Starscream]

First off, I LOVE this hack! Thanks for releasing it and spending your time coding it.

Secondly, Is there any way to make a dropdown menu in the postbit legacy for the RPG stats? It is currently just too big for my site. I would really appreciate it if anyone could create this or at least point me in the right direction of how to do it.

[Giveit2u43]

I`m trying to add the RPG Stuff to the Public Profile page rather than the Postbit but not having much luck.. anybody else been able to do it or can give me some hints on how to do it?!

[Revan]

First off, I LOVE this hack! Thanks for releasing it and spending your time coding it.

Secondly, Is there any way to make a dropdown menu in the postbit legacy for the RPG stats? It is currently just too big for my site. I would really appreciate it if anyone could create this or at least point me in the right direction of how to do it.
Ive already made a working mod like this for my own forums, check the attachment in the next post ;)
Note that Ill focus more on support for the main hack than this. Not saying your on yer own, just that its not a main priority ;)

I have the hack installed on my site, The Mystical Realm (http://www.tmrforums.com).

Anyways, I can't get battles to work. If I confirm/decline a battle, I'll get the "Invalid Password or Battle" error. Can anybody confirm if battles work for you? I'm not sure if it's a mistake I made installing it or a problem with the hack. :(
Are you sure you input a password?
Because if you leave the Battle Password field blank, you will get that error (Im gonna try to fix that later)

I`m trying to add the RPG Stuff to the Public Profile page rather than the Postbit but not having much luck.. anybody else been able to do it or can give me some hints on how to do it?!
This Ive never tried, so Im no good here :p
I might try it later if Im bored, not promising anything tho ;)

[Revan]

Blarg, this post has no purpose anymore.

[deathemperor]

I tested and found two errors:


1st is database error:
you said that you cant make the posting results, so I wonder what is this for

".TABLE_PREFIX."rpg_battle_options.postresults,".TABLE_PREFIX."rpg_battle_options.battleforum,

it should be removed or when opening rpg.php it will show db error.
one more thing with this script

LEFT JOIN ".TABLE_PREFIX."user ON ".TABLE_PREFIX."user.userid=$userid
it doesn't understand $userid, if I replace it with 1, it's fine of course, I think the solution is replace $userid with $bbuserinfo['userid'], didn't test yet

and:

when I came to clans.php, it show a blank page, came to clans.php?action=view it show a database error ( cant remember, I'm away from my PC).

and the templates as far as I've seen they weren't well-made, this could be easy changed. The manner things should be verify is the code since I'm not sure what to do when errors occurs.

The spells, apart from causing HP/MP, is it possible to causes status ?

I think you should have made it a beta testing board, problems occurs this way it's hard for you to verify --> fix all

[Revan]

I tested and found two errors:


1st is database error:
you said that you cant make the posting results, so I wonder what is this for

".TABLE_PREFIX."rpg_battle_options.postresults,".TABLE_PREFIX."rpg_battle_options.battleforum,

it should be removed or when opening rpg.php it will show db error.
one more thing with this script

LEFT JOIN ".TABLE_PREFIX."user ON ".TABLE_PREFIX."user.userid=$userid
it doesn't understand $userid, if I replace it with 1, it's fine of course, I think the solution is replace $userid with $bbuserinfo['userid'], didn't test yet

This is bogus, because there has been a vital change in the way rpg.php and rpgcp.php acts.

rpg.php is to display the stats of an user, using the arg "?userid=".
rpgcp.php is to display the user browsing the file ONLY.
Why?
Because even if you were not the same user as the user you viewed rpgcp.php for, you would get the "sell" link if he owned an item.
This would either cause you to sell your own item, or create DB errors.

But I have made some small fixes to avoid this sorta thing happening again, I will update the zip.

and:

when I came to clans.php, it show a blank page, came to clans.php?action=view it show a database error ( cant remember, I'm away from my PC).l
This is also bogus, because clans.php is to view a specific clan with the arg "?clanid=".
I have made a similar fix as the above file to prevent this from happening again


and the templates as far as I've seen they weren't well-made, this could be easy changed. The manner things should be verify is the code since I'm not sure what to do when errors occurs.
Please continue to report these holes in the code because I consider them to be
a) annoying
2) spamming the admins email
d) all of the above

And I didnt make the templates, I simply took out the obvious "non-XHTML" stuff in them, and put them in an XML file.
If you know anyone/want to help me with the templates (as requested in the first post), do let me know :)


The spells, apart from causing HP/MP, is it possible to causes status ?
No, not yet.


I think you should have made it a beta testing board, problems occurs this way it's hard for you to verify --> fix all
You sayin I should create a beta board?
I already do have one, on my localhost and I have this live on my 3.0.3 (currently down btw :p ), and no errors was found during my test runs.

*zip updated*

[deathemperor]

This is bogus, because there has been a vital change in the way rpg.php and rpgcp.php acts.

rpg.php is to display the stats of an user, using the arg "?userid=".
rpgcp.php is to display the user browsing the file ONLY.

I know this, but it doesn't work, that's the case

[Revan]

the rpg.php, it works with the arg ?userid=1
(example)
why I am sure? Because:
a) in the code it says "$userid = $_GET['userid']"
b) it works on all my test runs

and I KNOW the rpgcp.php works because theres no $userid in that code :p
:)

[deathemperor]

I know, I didn't say rpgcp.php has something wrong, just rpg.php

how about letting me make the template ? I know HDJ I think I can make it at least look like the old vb2 RPG hack.

[Revan]

What template do you mean?
If you mean the rpg.php's template then no because I spent ages on tweaking that file and its template to make it contain all the info the rpgcp.php contains (since I blocked people from viewing the rpgcp of anyone but themselves)

[SB2002]

Ok, i'm having a bit of a problem, only a small one tho, all the rpg names are displaying as the users location as opposed to users name, is there something I am missing here? I've been through the thread 4 times now and can't find anyone else with this problem..... anyone?

EDIT:

I can change the name through the admincp and it sticks, but the when the user edits it is does not change, i have tested this several times now and it keeps doing the same thing. WHen they first create it it takes on their location as their name, and then when you try to edit it after it has been changed through the user edit users function in the rpg section of the admin cp it stays with what the admin set it as, any ideas?

EDIT 2:

Nevermind, i know Read the f**king manual.......

And yes, I actually am an IT technician, we NEVER read the manual, lol

[Deimos]

I to can't get the battles to work
I request a battle, I get a PM, so does the other person, when he clicks to approve/confirm it, it says invalid password/battle
But the page before DOES have the correct battle/password in the URL.

[Dark Dragon]

I to can't get the battles to work
I request a battle, I get a PM, so does the other person, when he clicks to approve/confirm it, it says invalid password/battle
But the page before DOES have the correct battle/password in the URL.

Same problem here, I thought it was just me though.

[Deimos]

The fix you posted above didn't work for me
When I went to run the sql query..

ALTER TABLE `user` ADD `rpgstats` CHAR(1) NOT NULL DEFAULT '1' AFTER `limitlevel`;

It came up with..

An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'limitlevel' in 'user'

And if I now try and save the updated profile/update RPG info page, it says.

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE user SET element='2', rpgrace='3', alignment='3', rpggender='2', rpgclass='32', rpgtype='0', limitlevel='', rpgstats='0' WHERE userid='1686'
mysql error: Unknown column 'limitlevel' in 'field list'

***************

Edit
I just removed that fix and put the profile.php changes back that were listed in the zip file and it doesn't do it anymore
But I don't then get the option in usercp to choose wether to display stats or not, which is a shame, but I still can't use the battle system :(

[SB2002]

Same problem here, I thought it was just me though.


I'm gettin the same here too

[Link14716]

Out of curiosity, how is this integrated with uCash?

[str8ballin]

does ushop have to be installed to use the rpg shop and lottery? or does it run as a standalone all in one rpg hack?

[Deimos]

(Is a newb) but doesn't it reference the uttpoints field to calculate how many gold coins (gil) a person should have?
The most you post etc, the more gil/gold you get

[deathemperor]

And yes, I actually am an IT technician, we NEVER read the manual, lol
don't let this thing makes you weak IT teck.

@Link: This RPG system uses the UCS point system, I cannot run as a standalone hack, hence users must install UCS first.


@Revan: I mean all the templates that you want it to be re-made. The RPG.php template messes, the table is nice but you didn't make it perfectly (what is that table sitting on the top for ? why not middle or more thing bigger ?)

I suggest you should change rpg.php to this:
find:
if (empty($userid))
{
eval(standard_error('You did not select an user to view RPG stats for!'));
}
replace it with:
if (empty($userid))
{
$_GET['userid']=$bbuserinfo['userid'];
}

why this ?
Because when you come to rpg.php by entering to the url --> no userid --> it should show yourself. other ways the users come to this must be linked from a profile or something like so. one more thing with this:
find
} else {
echo "You must be logged in.";
}


replace it with:

} else {
print_no_permission();
}



well I'll test the battle late today. everyone, just wait.

[Revan]

For the users with the "Invalid battle or password" errors, the fix is here (https://vborg.vbsupport.ru/showpost.php?p=544235&postcount=40). :)
I tried this file and there SHOULD not be any errors in that.

And about the AFTER `limitlevel`, just scrap that.
Its for my own Level Based Limit Break mod I done for my own forums. Run the query without the AFTER part. (or redownload the TXT file if you dont know what I mean ;) )
And about that SQL error where it says unkown field, I believe I already fixed that.
Download the new zip and redo the profile.php edits. :)


(Is a newb) but doesn't it reference the uttpoints field to calculate how many gold coins (gil) a person should have?
The most you post etc, the more gil/gold you get
Yeah thats right :)
Whatever happens to your uCS money also affects your balance in the RPG, and vice versa :)


And death, I implemented your changes and I will send this out as a new build if everyone reports the battles confirming fine :)
EDIT: If you installed the "User select RPG Postbit" mod, you will see a link where it says "View Extended RPG Stats", with a link to rpg.php?userid=$
Thats why I put that error, I forgot that some might not have that installed ;)
Thanks :)

[Deimos]

battles seem to work aok, but....how does one equip an item?
I've got a sword, gloves and a potion, yet the system says I don't have a sword or potion during battle so I have to use my fists?

[Revan]

This could be due to several reasons:
a) You did not update the Item Type in the ACP (I think default is Non-battle Items, hence no usage in battle)
b) It is on the right type but you have to update it anyways :p
c) an error.

Please attempt a) and b), then post back if it still does not work, its then a bug. :)

[Deimos]

Will do Revan, awesome hack btw.

Quick question, you know the optional rpg display in the post bit? i ran through the instructions again and I still get the mysql levellimit error when I try to save changes
Or am I missing something? hehe

[Revan]

Damn sorry I overlooked it. :(
There took it out. Now it better goddam well be free of errors. :p

Sorry for the hassle


BTW I forgot to say in the prev post that items auto-equip ;)

[Deimos]

I removed the limitlevel from profile.php and it works ok now
Sorry about that.

[Deimos]

No problemo, you've done a great job

Btw, regarding the itemtype thing, I went into the ACP area and went to Edit Item types and they're all under "Generic"
I went to the Edit Items and manually set each one to weapons, armor or accessories
oh wait, nm i see where i have to change something :P

[Revan]

Yeah dam I didnt mean Item Type I meant alter the Category and then choose Battle Type :p

[Deimos]

Heh, no problem
Gonna go test it now

[Deimos]

Seems to be working aok, cept ......
I've got a bloodsword, I struck at someone and did 4 damage, he has no armour or weapons
The same guy punches me and does 5 hit points, lol
I'm guessing it's tied to the race, class or stats?

[deathemperor]

hope the battle.php fix works since I got that problem too.

an uncached template has been found in battle.php, you should install Erwin hack for Micro status and fix it, I forgot the template name since again I'm away from my PC.

the navigation system seems to be hard for users to surfing, you should remake it, and the items you should let users by many items to their inventory (can be limited in ACP) so that they can buy many items and equip any they like and even they can gift.

[Revan]

Seems to be working aok, cept ......
I've got a bloodsword, I struck at someone and did 4 damage, he has no armour or weapons
The same guy punches me and does 5 hit points, lol
I'm guessing it's tied to the race, class or stats?
And the Buff of the weapon ;)
Buff = The amount of Attack being added to the regular attack (RegAtk = race + class' Atk)
Whereas fists does damage calculated based on the level of the dude you punch.

Can anyone else confirm the battle/everything else working correctly?
I wanna bring this out as build2, but only if its error free :)

[Deimos]

Good job man, it's a great hack
Do we have to manually add spells?

[Revan]

Yes, you have to manually add and choose the type of spell (heal/attack) :)
Jus remember to create the category and set correct battle type ;)


@death: Remake the navigation sys? I dont understand what you mean. With the navbars its as easy as its gonna get.
You can create as many categories as you want users to be able to equip items.
Working on the cached templates now.


Well if battles are working after Im done with this I will release build2 :)

[DeMiNe0]

This is a great hack. From what i understand from the first post, this is a conversion of bitsys's RPG integration hack with alot of code cleanup and a few more features?
If so, then I would love to help you out with this project. Under my old name; VeoMorphine, i helped bitsys out alot with the old hack, and i even made the rpgcp.

Its a shame that i wont have the time in the next few days to install this hack, but once i do get the time, i will start looking over your code and shooting ideas at ya.

Good job and keep up the great work. I'll keep you informed if i run into any problems.

[Revan]

Great this sounds cool :D
After all Im adding more new ++++ to it and between that, these errors and school (translation: mom being a beeatch :p ) theres not much time left. ;)
Do ya have MSN? Easier to chat there and specially about new stuff that I wanna surprise people with ;)


On a side note, I cleaned up the battle.php and everything, so I release build2 now.
This is a cumulative fix with all the errors reported fixed, and seems to be error free.
:)

[Deimos]

I don't see the zip :P
hehe

---

Got it
Is there anything new I should change since our last communication?

[Revan]

the rpg.php, battle.php and battlefight.php are updated in build2. :)


Since all the errors reported so far is fixed, I probs wont be releasing a new build unless theres new features added or new critical errors fixed.
This means that people might mod the files themselves for addons for their own board, and a reupload of files would then mean extra hassle.
Hence I will start creating a changelog that includes patches (as long as not too much or an unknown piece of coding are changed) for the files to fix the errors. This will be sent out with the "Send Update" for this hack ONLY, so if you dont click the install button, you'll hav tae monitor the thread and just overwrite the files ;)

During the weekend I will start the conversion of the Monster Arena. :)

[Deimos]

Slight problem...I think
If somoene's doing a battle and it's at "Determining" in the status box, when you click "view" it says invalid battle or password.
Or can't you view it until it starts?

[Revan]

That is correct. If theres no battle to view, you cannot view it ;)
Note that it IS an error if this happens to one of the 2 users that actually wants to start a battle, is this the case?
Or is it a 3rd party trying to view?

I will code a small patch that gives a more descriptive error later :)

[Deimos]

3rd party
I had a feeling it was that, so np :)

[GamerzWorld]

Any example forums i can look at ?

[Deimos]

I've got it installed
http://www.uoforums.com/forums/index.php?

[Deimos]

Next question...

When someone dies, it says they have to goto the healing centre
Well, i'm in there on a dead character and there's nothing in here to do?
IT says my hit points are full (0/0), so is my MA (0/0)

The Heal me button doesn't do anything, just refreshes the screen......

------

Also, when trying to cancel a battle when it's waiting for a response from the challenged party, it comes up with a sql error saying the battle table doesn't exist.

[SB2002]

I've just encountered an sql error in the clancp admin. I changed some details of my clan, and then tried to save and got the following:

Invalid SQL: UPDATE rpg_clan SET
title='Empire Of The Fist',
pass='******',
logo='',
ally='5',
enemy='0',
sb_settings='',
col1='0',
col2='0',
col3='0',
col4='0',
sb_col_access='',
cm_col_access='0',
ci_col_access='0',
rm_col_access='0',
WHERE clanid=1
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=1' at line 16

I've not put the password in for obvious reasons

[DeMiNe0]

Great this sounds cool :D
After all Im adding more new ++++ to it and between that, these errors and school (translation: mom being a beeatch :p ) theres not much time left. ;)
Do ya have MSN? Easier to chat there and specially about new stuff that I wanna surprise people with ;)


On a side note, I cleaned up the battle.php and everything, so I release build2 now.
This is a cumulative fix with all the errors reported fixed, and seems to be error free.
:)
Check your PMs here. I send my MSN there.
Looking foward talking to you.

[Deimos]

Heh, i'm getting the password problem again, when accepting new battles
This is with the uploaded/updated battle php files

[Revan]

Next question...

When someone dies, it says they have to goto the healing centre
Well, i'm in there on a dead character and there's nothing in here to do?
IT says my hit points are full (0/0), so is my MA (0/0)

The Heal me button doesn't do anything, just refreshes the screen......

------

Also, when trying to cancel a battle when it's waiting for a response from the challenged party, it comes up with a sql error saying the battle table doesn't exist.
Your first error must be due to the RPG stats not being updated, as that is the only reason who both your HP and MA would be 0 (as its rare to have your MA being exactly 0)

Your second error must be due to even more ".TABLE_PREFIX." missing, I will find the line and tell you how to patch it.
Ah, here it is:
Goto line 59 and replace it ( $DB_site->query("DELETE FROM battle WHERE battlenumber='$battlenumber'");) with $DB_site->query("DELETE FROM ".TABLE_PREFIX."battle WHERE battlenumber='$battlenumber'");

this applies to everybody with a prefix on their forums.


SB2000, the fix for your error is:
Goto line 552 and remove the comma of this code:
rm_col_access='$rm',
Afterwards, go to line 544 and remove it :)
(It is about the Clan Shoutbox, which I was forced to remove due to excessive amount of template and coding errors)


Ok try this file for the invalid stuff errors:

[SB2002]

sweet, thanks for the prompt reply.

This hack has turned my board from a group of none rpg fans into belivers, lol.

[Revan]

np mate :)
Im really sorry for this being so buggy, I swear I tested it... :(
Ah well with the help of you all I hope one day this can be error free :D

[SB2002]

heh, i wouldnt worry too much.I installed the old rpg hack from the start on my old forums and I can recall so many days of db errors that it was just as much fun playing the db error lottery as it was playing the game lol

[Deimos]

Trying to save my RPG Profile (user cp/update info) comes up with.

Invalid SQL: UPDATE user SET element='3', rpgrace='2', alignment='2', rpggender='2', rpgclass='14', rpgtype='0' rpgstats='0' WHERE userid='1686'
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 'rpgstats='0' WHERE userid='1686'' at line 1

fun :P
hehe

[Revan]

You forgot the comma before rpgstats :)
EDIT: no sorry that was my fault. Readme error :(


What I really need is updates on the clancp and battle password bugs...? :)


EDIT2: I just fixed a small graphical bug when an user in battle's HP is less than 25% of max.
Nothing much but it will be included in the next build when all errors are DEAD and BURIED! :p

[Deimos]

Ah, ok
Only issue I see now, is it won't save my RPG name in the usercp?
If I put a name in, it refreshes and doesn't save, heh
I know, i'm a pain

[Revan]

This is really weird, never happened to me before...
Ill look into it tomorrow, now its sleep :p

[Deimos]

Sleep? Pfft, sleep is for the weak! :P

Hehe, sleep well man, good job again

[Deimos]

Bug with the lottery

You Do Not Have Enough Gil To Buy A Ticket!
You Only Have Gil in your pocket.

I only have gil? shouldn't it say "You only have XX Gil in your pocket"?

[deathemperor]

Revan, told you that you should test it before the release, even you said that you tested it with no problems, how can I believe it with those buggy things ?

and I don't know how could you miss this:

$DB_site->query("DELETE FROM battle WHERE battlenumber='$battlenumber'");
should be replace with
$DB_site->query("DELETE FROM ".TABLE_PREFIX."rpg_battle WHERE battlenumber='$battlenumber'");

it's rpg_battle but not battle (there is no battle table), this is a crazy mistake that I couldn't even believe

of course the battle doesn't work, I think you got the same problem like the bitsys' RPG, you can re-read that thread.

[Kru]

I have the store and money system of the vPetz hack installed at my system. Is there a way that I can use it instead of uCash/uShop . I installed vbookie at my forum, too and it allows me to choose between uCash/uShop and vBetz money. Maybe somebody can tell me which changes I must make to run the rpg hack with the vPetz money?

[ogetbilo]

I have 2 questions.
1. Even if you have enough money you cannot heal yourself.Healing is not working.
2. I bought an item and tried to have fight but I couldnt use the item.It says I dont own any weapons I can use.
If a member buys an item does he supposed to do any action in order to use in the battle ?

Also even if you choose to use mid files during the war it isnot also working.

But it is an awesome hack.When you will release without any bugs i will install to my board.

[Deimos]

I have 2 questions.
1. Even if you have enough money you cannot heal yourself.Healing is not working.

I had the same problem to. :(

2. I bought an item and tried to have fight but I couldnt use the item.It says I dont own any weapons I can use.

You have to go into the Admin panel, click Itemshop, then Edit Items
On the next page you'll see "Weapons - Add items, Edit Remove"
Click Edit, then change the battletype to "One handed weapon" or "Two handed"
Then you can use them in battle.

[Deimos]

Is it possible to disallow point generation from a forum which is specifically setup for spam?
Since I put the system in, people are now spamming the "Spam forum" to get "Gil" so they can buy items
Like the petz system, can the code be changed to disallow gil generation for forums which are setup to not count towards post counts?

[Revan]

Revan, told you that you should test it before the release, even you said that you tested it with no problems, how can I believe it with those buggy things ?

and I don't know how could you miss this:

$DB_site->query("DELETE FROM battle WHERE battlenumber='$battlenumber'");
should be replace with
$DB_site->query("DELETE FROM ".TABLE_PREFIX."rpg_battle WHERE battlenumber='$battlenumber'");

it's rpg_battle but not battle (there is no battle table), this is a crazy mistake that I couldn't even believe

of course the battle doesn't work, I think you got the same problem like the bitsys' RPG, you can re-read that thread.
Weird that I didnt find this error when I tried to delete a battle, seeing as Im using the same files as is in the zip and I dont get the error.
It would also help that you actually named the file, saves me the hassle of looking through every file.

Bug with the lottery

You Do Not Have Enough Gil To Buy A Ticket!
You Only Have Gil in your pocket.

I only have gil? shouldn't it say "You only have XX Gil in your pocket"?
EDIT:
Template error. Go into your Template Manager and find in the 'lottery_error2' template;
$usershi[]t[field1]
replace with
$usershi[]t[uttpoints]
Due to vB.org's policy, please remove the []'s from the 2 above to find what you really have to find and replace
;)

I have 2 questions.
1. Even if you have enough money you cannot heal yourself.Healing is not working.
I am still unable to pin this down.
I put on healing cost, and entered my SQL to set my HP and MA to 0, and it updated fine.


In general news, Im gonna talk around and find a host where I can setup a beta forum where I install the uCS and RPG only, and where you can enter and find bugs. :)

[deathemperor]

Is it possible to disallow point generation from a forum which is specifically setup for spam?
Since I put the system in, people are now spamming the "Spam forum" to get "Gil" so they can buy items
Like the petz system, can the code be changed to disallow gil generation for forums which are setup to not count towards post counts?
yes you can, since UCS offers you that.
Go to forum manager --> edit that forum --> set all the number to 0. the users won't have points by posting in that forum

[Revan]

As for the healing errors, try this file.
It doesnt really have any fixes, but its worth a shot.... :ermm:

[Deimos]

In general news, Im gonna talk around and find a host where I can setup a beta forum where I install the uCS and RPG only, and where you can enter and find bugs. :)

If the VBulletin license allows it, i'd be happy to setup a temp boards on my server for you to beta test with
I think the license allows it as long as it's not a live forum, but used for testing, right?

[Revan]

Yeah thatd be cool :D
I would of course need FTP access to do the coding ;)
Awaiting news about this :)

[Deimos]

Sure thing
I've posted about it on the vbulletin.com forums to see if it's ok
I did check the licence agreement but it's abit shady as to wether it would be allowed or not.

If you have a valid licence, you may set up an additional test forum in order to test code, template and database modifications. To make this clear to us and our licence verification procedures, place it in a directory called 'testvb' and be sure to password protect it. It must not be accessible by the general public.

[Revan]

Hm well it would be accessible for the "public" that were to track down errors... perhaps we can have a little group that does this?
This wouldnt be classified as "public" yet enough people could take the hack apart to scan for the remaining bugs...

thanks for doin this, you been a great help :D

[deathemperor]

just: disable new registrations + guests cannot view board.

well if you need a 'beta tester' ^^

[Deimos]

I guess the publically accessible bit means it can't be accessed by going to the domain, which it can't
Hopefully i'll get a response soon.
But in the mean time i'm in the process of setting it up.

[Deimos]

thanks for doin this, you been a great help :D

You mean a pain in the ass :P
hehe
Check yer pm's.

[Revan]

You mean a pain in the ass :P
hehe
Oh so youd rather the errors be left in there? XD
Wtf kinda support would it be if I thought users alerting me about errors was pains ;)

[Deimos]

Hehe, good point.
Forums are setup, so should we just take "recruits" to test them out? (when rpg is setup?)

[Revan]

Yeah sounds good.
Then again we dont want newbies that goes "omfgz heres an error" then leaves and never comes back XD (even tho I havnt seen one in THIS thread)

This sound aight?


Ill begin editing the files for uCS and RPG now, so if I dont reply even if Im viewing this thread thats why ;)

[Deimos]

Sounds good
It's your board to test on, so help yourself
I'll let you deal with giving out the URL etc for testers.

[Polo]

I'm apoligize for my ignorance, but i'm not that of a RPG fan... and i would like to know what the following means... (i hope i'm not the only one that needs to know this....)

RPG ?
HP ?
MA ?
PP ?
EXP ? (Experience maybe?)
Gil ?

Thanks for helping me out understand more about this RPG stuff, i really appreciate it.

[Revan]

The RPG Name not updating error has been fixed even BEFORE the complete RPG has been installed on the error find board! :D
I have added the changes to the build3 changelog text file.

I figure its best to relelease a cumulative Service Pack (M$, bite me :p ) than random error fixes and tons of attachment updates. :)
If anyone really cant wait for the test team to pick the hack apart for all errors, just holler out and I will give you a quickfix ;)



I'm apoligize for my ignorance, but i'm not that of a RPG fan... and i would like to know what the following means... (i hope i'm not the only one that needs to know this....)

RPG ?
HP ?
MA ?
PP ?
EXP ? (Experience maybe?)
Gil ?

Thanks for helping me out understand more about this RPG stuff, i really appreciate it.
RPG - Role Playing Game
HP - Health Points/Hit Points
MA/MP - Magic Aura/Magic Points
PP - Power Points
EXP - EXPerience Points (yer right ;) )
Gil - Money. It is the currency Final Fantasy games use

This helped? :)

[Polo]

Thank you Revan, that is all I needed to know ;) I appreciate it...
Regards

[House_of_Crazed]

Honestly, I'm not surprised that it's messy.

I'm sitting here trying to figure out how to start. I don't see a readme.htm as stated in the README text file.

Maybe it might be a good idea for you to sit down and go through everything & clean it up much more further. Even the installation instructions is messy.

HoC

[winlya]

wow..cool hack..
I am waiting this hack a long time.
But I look this hack same RPG Inferno V1...

[Rahzel_hx]

I'm having trouble i don't know how to install the rpg_phases and rpg_templets

Edit: nvm i'm stupid XD lol i fixed it
Edit#2: The lottery hack doesn't work no matter how many times i say to add lottery it says didn't fill out all the forums... where can i get the pictures for the diffrent classes ect?

[winlya]

hic,I just testing on localhost.But not work.
some error with me when install
Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_clan` (
`clanid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`pass` varchar(50) NOT NULL default '',
`leader` varchar(50) NOT NULL default '',
`clanpoints` varchar(5) NOT NULL default '',
`logo` varchar(100) NOT NULL default '',
`ally` varchar(10) NOT NULL default '0',
`enemy` varchar(10) NOT NULL default '0',
`sb_settings` char(1) NOT NULL default '0',
`maxmem` int(3) NOT NULL default '5',
`col1` varchar(5) NOT NULL default '0',
`col2` varchar(5) NOT NULL default '0',
`col3` varchar(5) NOT NULL default '0',
`col4` varchar(5) NOT NULL default '0',
`sb_col_access` varchar(5) NOT NULL default '0',
`cm_col_access` varchar(5) NOT NULL default '0',
`ci_col_access` varchar(5) NOT NULL default '0',
`rm_col_access` varchar(5) NOT NULL default '0',
`clanmidiurl` varchar(100) NOT NULL default '',
PRIMARY KEY (`clanid`)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 22

mysql error number: 1064

Date: Saturday 21st of August 2004 03:08:46 AM
Script: http://localhost/vbb3.0.3/install/battleinstall.php?step=1
Referer: http://localhost/vbb3.0.3/install/menue.htm
Username: admin
IP Address: 127.0.0.1

And when install rpg_phases...
The file you attempted to import only contains phrases and none of the settings required. You will be unable to make a new language with this file.
Please fix some error man..
thank agian ^_^

[ogetbilo]

With the updated heal.php healing is working now.
But I found 2 more problems.
When I tried to optimize my database tables I had this warning :

rpg_rpg_alignment Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_alignment Check Status: OK
rpg_rpg_alignment Optimize Status: OK
rpg_rpg_classf Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_classf Check Status: OK
rpg_rpg_classf Optimize Status: OK
rpg_rpg_classm Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_classm Check Status: OK
rpg_rpg_classm Optimize Status: OK
rpg_rpg_element Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_element Check Status: OK
rpg_rpg_element Optimize Status: OK
rpg_rpg_race Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_race Check Status: OK
rpg_rpg_race Optimize Status: OK
rpg_rpg_type Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_type Check Status: OK
rpg_rpg_type Optimize Status: OK

Why do i have a warning like this when I optimize the tables.
Also I dont know why but character names are always same with your location.
I thiink you miss coded something ovet there.Noone can update their names.

[Starscream]

Revan, thanks for the dropdown in the postbit. It is perfect for my forum. All things seem to be running great on my site. I have even heavily modified/adapted the RPG elements to fit my site theme and everything has gone pretty smoothly and is operational.

I am having one minor problem concerning the dropdown. I can't figure out how to make the dropdown in the postbit become the default view. I like that you made it so you can choose between having the dropdown or not, but I wish the dropdown would be the default view. It's probably a simple change, but I can't see it. Any help would be very appreciated.

*Clicks Install*

[Rahzel_hx]

And when install rpg_phases...
The file you attempted to import only contains phrases and none of the settings required. You will be unable to make a new language with this file.
Please fix some error man..
thank agian ^_^

Don't select it to be a new language select it to be meged with a language that you already have installed.. example: English Us

[SB2002]

I have a question. I've divided the itemshop into different sections for the different classes, the only thing is, the only weapons people can buy are the generic ones, no matter what class they chose. When they access their classes weapons, it tells them that they must be that class to buy them.

ie i have a pistoleer class, and they should be able to buy the pistols, but whenever they go to that classes shop they are told they must be a pistoleer to purchase them...... any ideas?

Or do I have to just have everything as generic?

[Revan]

hic,I just testing on localhost.But not work.
some error with me when install
Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_clan` (
`clanid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`pass` varchar(50) NOT NULL default '',
`leader` varchar(50) NOT NULL default '',
`clanpoints` varchar(5) NOT NULL default '',
`logo` varchar(100) NOT NULL default '',
`ally` varchar(10) NOT NULL default '0',
`enemy` varchar(10) NOT NULL default '0',
`sb_settings` char(1) NOT NULL default '0',
`maxmem` int(3) NOT NULL default '5',
`col1` varchar(5) NOT NULL default '0',
`col2` varchar(5) NOT NULL default '0',
`col3` varchar(5) NOT NULL default '0',
`col4` varchar(5) NOT NULL default '0',
`sb_col_access` varchar(5) NOT NULL default '0',
`cm_col_access` varchar(5) NOT NULL default '0',
`ci_col_access` varchar(5) NOT NULL default '0',
`rm_col_access` varchar(5) NOT NULL default '0',
`clanmidiurl` varchar(100) NOT NULL default '',
PRIMARY KEY (`clanid`)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 22

mysql error number: 1064

Date: Saturday 21st of August 2004 03:08:46 AM
Script: http://localhost/vB3.0.3/install/battleinstall.php?step=1
Referer: http://localhost/vB3.0.3/install/menue.htm
Username: admin
IP Address: 127.0.0.1

I cant seem to find an error in this installer, just yesterday I installed perfectly on the beta board I use to track down bugs.
At any rate, the new installer has redundant sections removed from it, patches for which will be found in the new version due to be released once all bugs have been pinned.


With the updated heal.php healing is working now.
But I found 2 more problems.
When I tried to optimize my database tables I had this warning :

rpg_rpg_alignment Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_alignment Check Status: OK
rpg_rpg_alignment Optimize Status: OK
rpg_rpg_classf Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_classf Check Status: OK
rpg_rpg_classf Optimize Status: OK
rpg_rpg_classm Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_classm Check Status: OK
rpg_rpg_classm Optimize Status: OK
rpg_rpg_element Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_element Check Status: OK
rpg_rpg_element Optimize Status: OK
rpg_rpg_race Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_race Check Status: OK
rpg_rpg_race Optimize Status: OK
rpg_rpg_type Check Warning: Found row where the auto_increment column has the value 0
rpg_rpg_type Check Status: OK
rpg_rpg_type Optimize Status: OK

Why do i have a warning like this when I optimize the tables.
Also I dont know why but character names are always same with your location.
I thiink you miss coded something ovet there.Noone can update their names.
2 things for you:
First of all, those warnings appear because the rpg_rpg_type is of course auto_increment (since if you add more than one type you would get SQL errors if it didnt automatically increment by one.)
But the default value, the value that your users have BEFORE they update their stats, are "Unknown" which has an ID of 0.
I might change the numbers to have 1 be the default, but this would NOT work if you already installed the hack.
Dont worry about it ;)

Second, please consult the FAQ_FRE file for solution to your RPG Name problem. :)
I will move that info over to the installer as it seems like everyone gets this problem :)



Revan, thanks for the dropdown in the postbit. It is perfect for my forum. All things seem to be running great on my site. I have even heavily modified/adapted the RPG elements to fit my site theme and everything has gone pretty smoothly and is operational.

I am having one minor problem concerning the dropdown. I can't figure out how to make the dropdown in the postbit become the default view. I like that you made it so you can choose between having the dropdown or not, but I wish the dropdown would be the default view. It's probably a simple change, but I can't see it. Any help would be very appreciated.

*Clicks Install*
You can make the dropdown be the default view by running these 2 queries:
ALTER TABLE `user` DROP `rpgstats`;
ALTER TABLE `user` ADD `rpgstats` CHAR(1) NOT NULL DEFAULT '0';
0 is the dropdown value and 1 is the normal postbit value :)
(Just remember to run these seperately in acp, and in quick succession to avoid SQL errors if an user tries to update ;) )
Thanks for clicking install btw :)


I have a question. I've divided the itemshop into different sections for the different classes, the only thing is, the only weapons people can buy are the generic ones, no matter what class they chose. When they access their classes weapons, it tells them that they must be that class to buy them.

ie i have a pistoleer class, and they should be able to buy the pistols, but whenever they go to that classes shop they are told they must be a pistoleer to purchase them...... any ideas?

Or do I have to just have everything as generic?
I believe you have to update the Classes as well. Currently all your classes are (probs) set to Generic type, and so they can only get Generic items ;)
I have not done extensive testing on the Battle Types yet, but it will come in time ;)



Thats about everything I guess :)
The Service Pack 1 that will update this hack to v2.5 build1 is in the works, with new bugs being squashed every day :)
I cannot tell an ETA yet, but heres the remaining sections to test:
* Itemshop
* User's Battle Types as discussed in the above quote
* Battle
* Healing

Finished sections:
* Entire ACP
* Entire ClanCP
* RPG CP

Additional work:
* Templates

:)

[SB2002]

yeah, that was one of the first things i did (altering the classes etc into specific groups) and that is where the problem began, as the itemshop shows the classes, but when you clik them it doesnt actually let you buy the weapons for that class. If needs be I will drop in a test account, give it an rpg class and let you see what i mean.

[deathemperor]

wow..cool hack..
I am waiting this hack a long time.
But I look this hack same RPG Inferno V1...
believe it or not, RPG Inferno is based on Bitsys' RPG hack and another old IB hack that I've used both of them. Bitsys' RPG has been here months (even more than 1 year) before ZT made RPG Inferno and honestly one of the reason drove me to use vb was the RPG hack.

@SB2002, there's no problem with the Itemshop, I've tested and I can buy any items I want while my class is generic and that item is for generic class.

But well the itemshop is messy, Revan. I asked you to let users have many items in their inventories, it meant: you can buy 10 swords in the weapon shop, 5 armors in the armor shop, 4 accessories and 13 potions in different kind from the Potions Shop, 7 spells from the spell shop but can only equip 1 weapon/1 armor/2 accessories/4 potions/3 spells at a time, and the total items you can buy is 30.

well that way everything would be very easy and comfortable for users. We don't need something like: If you want to let user has 2 weapon, create 2 weapon shop hence if I wish to let them own 10 swords I will have to forget everything to sit there and create items for the shops. But actually with this items system, If I create 10 weapon shops it means everyone will be able to have 10 weapons in battle.

my idea sounds troublesome huh ? it's ok, it's just MHO

[Revan]

death; yes I understand what you mean but it is not possible to let an user equip more items than theres categories.
At least not with the current way of storing items, an Im not sure its smart to go about redesigning the entire item storage database :p


yeah, that was one of the first things i did (altering the classes etc into specific groups) and that is where the problem began, as the itemshop shows the classes, but when you clik them it doesnt actually let you buy the weapons for that class. If needs be I will drop in a test account, give it an rpg class and let you see what i mean.
EDIT: I tried this on my localhost also, and I see what you mean now. Ill get right on fixing it.
EDIT2: I have fixed that bug along with some other small graphical bugs, expect a fully working itemshop in v2.5! :D ;)

[SB2002]

splendid. Much appriciated. What sort of eta do you have on 2.5 as I have a board full of members wanting to buy things, lol

[Revan]

I dont really know, I have to finish writing the changelog for the itemshop.php as well as test every aspect of the battles.
Plus I hear DeMiNe0 got some errors for me in the showthread and showpost files.... :p

Id rather not rush the new update, just to be sure I got all the errors.
Such as your error, at first I had this long step by step update gotten as to what I did to get it working (cos it LOOKED like it worked), but then after about 15 mins I saw "wtf this is bs it doesnt work *runs to edit post before he sees it and thinks Im dumb*" ;)
Plus I think its dumb to release quickfixes, because this would just confuse users that downloads the new zip and sees the changelog and goes "hey I cant find this it tells me to find in the changelog!" :p

Im working thoroughly fast ;)

[SB2002]

nah thats cool dude, no rush on it, i'll just throw a couple more arcade games at them to keep the masses happy, lol.

[Rahzel_hx]

i'm not able to reset the rpg stats it goes to a blank page

When i try to start the battle accepting it , it says invaild password or battle

i also get this error when i try to cancle a battle
Database error in vBulletin 3.0.3:

Invalid SQL: DELETE FROM battle WHERE battlenumber='1'
mysql error: Table 'spiritno_forum.battle' doesn't exist

mysql error number: 1146

Date: Saturday 21st of August 2004 03:00:45 PM
Script: http://--------/forum/battlefight.php?action=cancelbattle
Referer: http://--------forum/battlefight.php?action=enterbattle&battlenumber=1
Username: ----------
IP Address: ----------

Edit wish i could fix this my self but umm
Parse error: parse error, unexpected T_CASE in /home/spiritno/public_html/forum/includes/functions_online.php on line 1318
i get this when i goto look at users profiles

[Pixelgrounds]

have al lthe bug fixes iv read in this thread and all the little mods been added to the main page zip file yet?

[orca]

Hmm, I installed this hack but funny enough some images won't show although in the correct directories...This is especially the case for the itemshop directory. hat.gif shows for example but racket.gif not although it exists in that directory.

[Revan]

Hmm, I installed this hack but funny enough some images won't show although in the correct directories...This is especially the case for the itemshop directory. hat.gif shows for example but racket.gif not although it exists in that directory. This I never encountered. All my test forums show the image correctly.... You sure both images are in the same dir?

I'm lv2 in the rpg and i have like 56 hp, 8k ma and 20k pp ? >_< and i'm not able to reset the rpg stats it goes to a blank page
When i try to start the battle accepting it, it says invaild password or battle

i also get this error when i try to cancle a battle
Database error in vBulletin 3.0.3:

Invalid SQL: DELETE FROM battle WHERE battlenumber='1'
mysql error: Table 'spiritno_forum.battle' doesn't exist

mysql error number: 1146

Date: Saturday 21st of August 2004 03:00:45 PM
Script: http://--------/forum/battlefight.php?action=cancelbattle
Referer: http://--------forum/battlefight.php?action=enterbattle&battlenumber=1
Username: ----------
IP Address: ----------

Edit wish i could fix this my self but i'ma vb no0b umm
Parse error: parse error, unexpected T_CASE in /home/spiritno/public_html/forum/includes/functions_online.php on line 1318
i get this when i goto look at users profiles
First of all, your massive amounts of MA and PP are because the MA and PP modifiers are way off the scale.
Enter your AdminCP, and select Edit Options under Battle.
There set new values for MA and PP, recommended values are 0.003 :)

For your battle accept error, this has happened before but was reported to have gone away. But as I see its back, it will be pinned down and fixed for v2.5 ;)

For your Cancel Battle error, that is a small fix which I am just about to note down in the changelog. To fix it quickly, enter battlefight.php and search for:
DELETE FROM ".TABLE_PREFIX."battle
change to
DELETE FROM ".TABLE_PREFIX."rpg_battle

And as for your functions_online stuff:
find
case 'rpgcp':
$userinfo['action'] = "Viewing <a href='rpgcp.php'>RPG CP</a>";
change to
case 'rpgcp':
$userinfo['action'] = "Viewing <a href='rpgcp.php'>RPG CP</a>";
break;

have al lthe bug fixes iv read in this thread and all the little mods been added to the main page zip file yet?
Bug fixes: Most
Addons: None. The addons are in a special post linked to from the main page.


Status on the v2.5:
I am just going through the files looking for missing ".TABLE_PREFIX."es, with much help from DeMiNe0 :)
After this I will start picking apart the battle part of the hack on the live forum.
Then, Im gonna do a fresh reinstall (cos I made tweaks to the installer), and go through it all again.
After THAT, then all bugs should be gone and I can put out the new version :)

And dont worry about having to redo/reupload all the files if you make modifications to the files, all the changes are documented in a changelog file. ;)


EDIT: I just managed to fix all bugs in the heal.php file, healing now works 100 % :D

[Rahzel_hx]

For your Cancel Battle error, that is a small fix which I am just about to note down in the changelog. To fix it quickly, enter battlefight.php and search for:
DELETE FROM ".TABLE_PREFIX."battle
change to
DELETE FROM ".TABLE_PREFIX."rpg_battle

And as for your functions_online stuff:
find
case 'rpgcp':
$userinfo['action'] = "Viewing <a href='rpgcp.php'>RPG CP</a>";
change to
case 'rpgcp':
$userinfo['action'] = "Viewing <a href='rpgcp.php'>RPG CP</a>";
break;

Parse error: parse error, unexpected T_CASE in /home/spiritno/public_html/forum/includes/functions_online.php on line 1319
after that change it gaive me another new error -_- also
DELETE FROM ".TABLE_PREFIX."battle
change to
DELETE FROM ".TABLE_PREFIX."rpg_battle
i don't have a DELETE FROM ".TABLE_PREFIX."battle
it is already DELETE FROM ".TABLE_PREFIX."rpg_battle

Thanks for your help ^__^ i know you will do ur best even though it isn't paid XP

[orca]

Yes, they are in the same dir. Also, if I right-click on the cross and check the path, it's correct.
Would it be possible that mod_rewrite does sth wrong there?

[Revan]

Yes, they are in the same dir. Also, if I right-click on the cross and check the path, it's correct.
Would it be possible that mod_rewrite does sth wrong there?
Mod rewrite sth what? :ermm:
All I know is that it works correctly here, and every dam other test/live board Ive ever seen... :p


Parse error: parse error, unexpected T_CASE in /home/spiritno/public_html/forum/includes/functions_online.php on line 1319
after that change it gaive me another new error -_- also
DELETE FROM ".TABLE_PREFIX."battle
change to
DELETE FROM ".TABLE_PREFIX."rpg_battle
i don't have a DELETE FROM ".TABLE_PREFIX."battle
it is already DELETE FROM ".TABLE_PREFIX."rpg_battle

Thanks for your help ^__^ i know you will do ur best even though it isn't paid XP
Then whats the new error, if that was it then its not cause of this, because I checked all the rpg edits for functions_online and that rpgcp.php was the only one that lacked a break;
Can you post the 2-3 lines surrounding your line 1319 in that file then?

[orca]

Well, I only know that the weapons, asc.gif, desc.gif, src.gif and no item.gif give a red cross. All other gifs work. Funny thing is that if I enter the path to those images directly, it leads me to a crappy main page of my site whereas the working images show up. That's why I asked about mod_rewrite as I use it for the main site. See the following examples:

http://forum.arachid.net/images/itemshop/racket.gif (doesn't show in list)

http://forum.arachid.net/images/itemshop/hat.gif (shows in list)

The files are chmod 777 just to be sure it's no permission problem. The mod_rewrite is actually for www.arachid.net and not for forum.arachid.net.

[Revan]

I can see both of them fine, just like the normal images.
This problem doesnt seem like it can be fixed on my side, sorry :(


On a brighter note, Ive sent the RC1 of the changelog for v2.5 over to the team's testers (yeah didnt that sound fancy :p ), and it addresses 14 errors, redundant coding, adds the features of Admin Only-Classes settable in the ACP (this is actually just a touchup of the old code, previously the Admin classes was selectable for users, now they are hidden), and the RPG CP now also displays your current Battle Type (like Generic etc)

It will most likely be made public in 1-2 days :)

[Pixelgrounds]

I think im going to wait till this is more stable before i install it. Last thing i want is my boss getting mad at me for the site going down or any errors.

[NyCwill]

For the users with the "Invalid battle or password" errors, the fix is here (https://vborg.vbsupport.ru/showpost.php?p=544235&postcount=40). :)


where is the fix?? :surprised:

[House_of_Crazed]

Suggestion -

Add a script that would reset everyone's stats based on their postcount. :D

I tried doing this and accidently reset'ed everyone's characters. *laughs* Good thing it was on a test site, *laughs*

HoC

[Rahzel_hx]

lol nice i don't know what is wrong with functions_online.php i think i just have to site down and re trace my steps ^__^

When the new version comes out will you have a upgrade.txt so we don't have to clean install again

[Revan]

where is the fix?? :surprised:
If its not there, then I took it down because I was doin fixed on it.
Dont worry, the new upgrade's battles has been tested and works 100 % ;)


Suggestion -

Add a script that would reset everyone's stats based on their postcount. :D

I tried doing this and accidently reset'ed everyone's characters. *laughs* Good thing it was on a test site, *laughs*

HoC
This is already in there.
Please enter the 'Reset' script in your AdminCP and read each description thoroughly to find your reset preference ;)
(I cant tell you exactly since Im away from my comp atm)


lol nice i don't know what is wrong with functions_online.php i think i just have to site down and re trace my steps ^__^

When the new version comes out will you have a upgrade.txt so we don't have to clean install again
There will be a changelog text file containing the fixes, both for the rpg files and the file edits you did ;)

[NyCwill]

when will the upgrade be release?

[fade]

hic,I just testing on localhost.But not work.
some error with me when install
Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_clan` (
`clanid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`pass` varchar(50) NOT NULL default '',
`leader` varchar(50) NOT NULL default '',
`clanpoints` varchar(5) NOT NULL default '',
`logo` varchar(100) NOT NULL default '',
`ally` varchar(10) NOT NULL default '0',
`enemy` varchar(10) NOT NULL default '0',
`sb_settings` char(1) NOT NULL default '0',
`maxmem` int(3) NOT NULL default '5',
`col1` varchar(5) NOT NULL default '0',
`col2` varchar(5) NOT NULL default '0',
`col3` varchar(5) NOT NULL default '0',
`col4` varchar(5) NOT NULL default '0',
`sb_col_access` varchar(5) NOT NULL default '0',
`cm_col_access` varchar(5) NOT NULL default '0',
`ci_col_access` varchar(5) NOT NULL default '0',
`rm_col_access` varchar(5) NOT NULL default '0',
`clanmidiurl` varchar(100) NOT NULL default '',
PRIMARY KEY (`clanid`)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 22

mysql error number: 1064

Date: Saturday 21st of August 2004 03:08:46 AM
Script: http://localhost/vB3.0.3/install/battleinstall.php?step=1
Referer: http://localhost/vB3.0.3/install/menue.htm
Username: admin
IP Address: 127.0.0.1


Getting the exact same error message when trying to install..

[Revan]

Getting the exact same error message when trying to install..
Then how come I could paste that very query into a test mySQL dbase and get it to work 100 %?:p

Ive thoroughly tested the new installer also, so it doesnt have any problems.



About the release time, Ill post back once I can breathe some life into the tester ;)

[fade]

Then how come I could paste that very query into a test mySQL dbase and get it to work 100 %?:p


are you able to suggest anything that *might* be causing it?

[Revan]

Nah this has me completely stumped.
I tried the install and reinstall like 5 times and theres no errors.


Anyways I havnt heard anything from testers about errors, and all works fine in all tests, so what the hell, heres the new version :)

[Virulent1]

what if i just installed the lottery and not the rpg thing? will the lottery work correctly with Ushop?

[xiang]

Hi, Revan
I meet the same problem when have a new install. pls check yours pm to find my website.


Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_clan` (
`clanid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`pass` varchar(50) NOT NULL default '',
`leader` varchar(50) NOT NULL default '',
`clanpoints` varchar(5) NOT NULL default '',
`logo` varchar(100) NOT NULL default '',
`ally` varchar(10) NOT NULL default '0',
`enemy` varchar(10) NOT NULL default '0',
`maxmem` int(3) NOT NULL default '5',
`col1` varchar(5) NOT NULL default '0',
`col2` varchar(5) NOT NULL default '0',
`col3` varchar(5) NOT NULL default '0',
`col4` varchar(5) NOT NULL default '0',
`cm_col_access` varchar(5) NOT NULL default '0',
`ci_col_access` varchar(5) NOT NULL default '0',
`rm_col_access` varchar(5) NOT NULL default '0',
`clanmidiurl` varchar(100) NOT NULL default '',
PRIMARY KEY (`clanid`)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 20

mysql error number: 1064

[Revan]

just try removing the ; after MyISAM then... as thats the character in the error :ermm:

[Virulent1]

revan, if i were to install the lottery part ONLY and not the RPG stuff will it work properly with Ushop?

[Valr the Slain]

Hello,
I recently tried to install this hack and came up with this error:


Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_items_options` (
`refund` varchar(5) NOT NULL default '0',
`stockdate` varchar(250) NOT NULL default '0',
`onofforder` smallint(6) NOT NULL default '0',
`sold` int(11) NOT NULL default '0',
`profit` int(11) NOT NULL default '0',
`minstock` int(11) NOT NULL default '0',
`maxstock` int(11) NOT NULL default '0',
`stockreset` varchar(250) NOT NULL default '0',
`hidelevel` tinyint(4) NOT NULL default '0',
) TYPE=MyISAM;
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 ') TYPE=MyISAM' at line 11

mysql error number: 1064


Any possible ways to fix this?

Thank you.

[Revan]

Hello,
I recently tried to install this hack and came up with this error:


Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_items_options` (
`refund` varchar(5) NOT NULL default '0',
`stockdate` varchar(250) NOT NULL default '0',
`onofforder` smallint(6) NOT NULL default '0',
`sold` int(11) NOT NULL default '0',
`profit` int(11) NOT NULL default '0',
`minstock` int(11) NOT NULL default '0',
`maxstock` int(11) NOT NULL default '0',
`stockreset` varchar(250) NOT NULL default '0',
`hidelevel` tinyint(4) NOT NULL default '0',
) TYPE=MyISAM;
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 ') TYPE=MyISAM' at line 11

mysql error number: 1064


Any possible ways to fix this?

Thank you.
Ugh... find this:

`hidelevel` tinyint(4) NOT NULL default '0',
change to this:
`hidelevel` tinyint(4) NOT NULL default '0'


revan, if i were to install the lottery part ONLY and not the RPG stuff will it work properly with Ushop?
No clue.
Its worth a test, but I cannot provide support should anything go wrong ;)

[HiDeo]

Nice hack, thanks

[DaPro]

Ok guys, I have fixed my install problems that most of you were having, so if you would like help, please use my battleinstall.php file and preform these few simple tasks.

*Note: I am not an experienced PHP coder, I am just trying to help myself and others, I will not offer support for this fix, so don't PM me! LOL

Now go into your PHPMYADMIN and go into your users table. Now DROP the following rows before you try to reinstall with the fixed install:

DROP rpgclass
DROP rpgrace
DROP alignment
DROP rpgtype
DROP rpggender
DROP hp
DROP maxhp
DROP ma
DROP maxma
DROP pp
DROP maxpp
DROP ap
DROP element
DROP inbattle
DROP clan
DROP xp

Now after that is all done, we need to clean out all of those old RPG tables added by any previous install attempt. So loud up the installer/installer.php files and click delete on the side menu. Go into your PHPMYADMIN and make sure they were all deleted. If you get an error when you click, don't worry, I got that too :P

Now you are safe to upload the battleinstall.php and run the install. If it says Success or Install OK, then you are GOOD2GO. If you have problems, post here, no PM's!

[Revan]

Ok guys, I have fixed my install problems that most of you were having, so if you would like help, please use my battleinstall.php file and preform these few simple tasks.

*Note: I am not an experienced PHP coder, I am just trying to help myself and others, I will not offer support for this fix, so don't PM me! LOL

Now go into your PHPMYADMIN and go into your users table. Now DROP the following rows before you try to reinstall with the fixed install:

DROP rpgclass
DROP rpgrace
DROP alignment
DROP rpgtype
DROP rpggender
DROP hp
DROP maxhp
DROP ma
DROP maxma
DROP pp
DROP maxpp
DROP ap
DROP element
DROP inbattle
DROP clan
DROP xp

Now after that is all done, we need to clean out all of those old RPG tables added by any previous install attempt. So loud up the installer/installer.php files and click delete on the side menu. Go into your PHPMYADMIN and make sure they were all deleted. If you get an error when you click, don't worry, I got that too :P

Now you are safe to upload the battleinstall.php and run the install. If it says Success or Install OK, then you are GOOD2GO. If you have problems, post here, no PM's!
Thank you very much, if this really does help the other users then you are getting a place in the first post in the thanks section :D
I'll wait to see if people report error fixed before I update the first zip ;)

[DaPro]

Thanks, I just try to help, I will also be re-doing all the RPG templates to make them look more vB Intergrated than off with the style. I should have it done sometime by next week I hope, because there are alot of templates and doing them all today is out of the question :P LOL.

[MayhemSI]

Finally! an installer that works! I had given up on this hack after about 30 minutes of messing with the script.. I'm lazy.. what can I say.. hehe

[DaPro]

Glad to have helped! Well, hopefully it will serve others well, it did take me alot of messing around with the whole shabang of this hack to actually get the damn thing running right. LOL, so the installer unfortunately is only half the battle. No offense to the makers of this port, but there should have been a little wait until you fixed most of the kinks, more beta testing and what not. I would ask for more reorganizing in the readme.

Hopefully my new templates will make it look nicer as well. :)

[Revan]

Um just FYI the v2.5 Gold version fixes all bugs, apart from apparently this installer.
And the readme IS as organised as it gets... what version did you dload anyways? :ermm:

Aight if the installer works Ill update the zip and send out an update....

[DaPro]

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]

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]

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]

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:


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]

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

[Rahzel_hx]

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

[Revan]

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]

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]

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]

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]

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]

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]

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: http://forum...........com/clancp.php?action=edit
Referer: http://forum.............com/clancp.php?action=editclan
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/profile.php?do=updaterpg
Referer:
Username: Ganon
IP Address: xx.x.xxx.xxx

[fade]

hrmz. same problem as ganon as well

[Rahzel_hx]

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]

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]

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.


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: http://forum...........com/clancp.php?action=edit
Referer: http://forum.............com/clancp.php?action=editclan
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 :)


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)
#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 ;)


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/profile.php?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]

................
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]

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

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

[Kalakov]

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

it works Perfect now =)



fiskeboller !

[Kalakov]

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

[Ganon]

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

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

It's working perfect now, thanks! :D

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

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

What could be the problem?

[designstylez]

I get the same error.


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:

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

What could be the problem?

[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?

[Rahzel_hx]

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]

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:

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


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]

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]

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]

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.

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/itemadmin.php?action=options
Username: ****
IP Address: *******

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

[Revan]

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


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 [URL=clancp.php
change to
[URL=http://your.forum/url/clancp.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


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]

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]

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]

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!

[Ganon]

This fixed my problem. Where exactly do users go to buy the items though? I'm not seeing it in the postbit, or in the Ushop anywhere.

[Revan]

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!
I cannot reproduce this, I tried it with a fresh install and it expands fine.
Could you tell me your forum url so I could check this out for myself? :)
EDIT: I went to your forums, entered the Itemshop and clicked the Expand of Armor, and it expanded fine.
If you meant something else then please elaborate :)


This fixed my problem. Where exactly do users go to buy the items though? I'm not seeing it in the postbit, or in the Ushop anywhere.
Try going to the Addons page and install one of the 2 navbar addons ;)

[Valr the Slain]

How would I go about posting the battle results into a forum? I've been looking around for any sort of setting, and I didn't find anything. Maybe I'm not looking hard enough? Could you point me in the right direction, please?

Thanks.

[Revan]

You cannot.
I had to scrap the feature due to an excessive amount of errors and time restrains.
On a side note, DeMiNe0 said he was gonna make a battle archive file, so I guess theres yer chance to get a better way of displaying the battle.... ;)

[Valr the Slain]

Alright, sounds good.

Thanks a bunch.

[designstylez]

Hmm... I just tried it on another computer but still does not expand.

Link: http://www.khmerlife.com/forum/itemshop.php

The "Expand All Generic Items" works, but not the "Available Armor - Expand". Maybe i've tweaked the layout too much that I've might of miss some properties... I dunno.

[Revan]

I went there for the second time and it works perfect in the lay unregistered users see. :)

[Ganon]

I cannot reproduce this, I tried it with a fresh install and it expands fine.
Could you tell me your forum url so I could check this out for myself? :)
EDIT: I went to your forums, entered the Itemshop and clicked the Expand of Armor, and it expanded fine.
If you meant something else then please elaborate :)



Try going to the Addons page and install one of the 2 navbar addons ;)

Every feature seems to be working perfectly now, thanks!

[ogetbilo]

Thanks Revan now I get everythng working perfect.I will write here if I will have any problems.Good job and good help dude.
Clicked Install..

[CHIngs]

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

mysql error number: 1146

what should i DO?

[LeonHartHVA]

Invalid SQL:
SELECT
user.userid,
user.username,
user.rpgclass,
user.element,
user.rpgrace,
user.rpgtype AS rpgtype,
user.alignment,
user.rpggender,
user.posts,
user.maxhp,
user.maxma,
user.maxpp,
user.inbattle,
user.xp,
user.ma AS uma,
user.hp AS uhp,
user.pp AS upp,
user.ap AS uap,
user.uttpoints AS money,
rpg_battle_options.namefield AS namefield,
userfield.*,
rpg_battle_options.exprate,
rpg_battle_options.privacy AS battleprivacy,
rpg_items_user.*,
rpg_battle_stats.*,
rpg_rpg_race.name AS rpgracename,
rpg_rpg_race.alignment AS rpgalignmentname,
rpg_rpg_classf.name AS fclassname,
rpg_rpg_classf.folder AS fclassfolder,
rpg_rpg_classm.name AS mclassname,
rpg_rpg_classm.folder AS mclassfolder,
rpg_rpg_element.name AS elename
FROM rpg_battle_options
LEFT JOIN user ON user.userid=1
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN rpg_items_user ON rpg_items_user.userid=user.userid
LEFT JOIN rpg_battle_stats ON rpg_battle_stats.userid=user.userid
LEFT JOIN rpg_rpg_classf ON rpg_rpg_classf.id=user.rpgclass
LEFT JOIN rpg_rpg_classm ON rpg_rpg_classm.id=user.rpgclass
LEFT JOIN rpg_rpg_element ON rpg_rpg_element.elementid=user.element
LEFT JOIN rpg_rpg_race ON rpg_rpg_race.raceid=user.rpgrace AND rpg_rpg_race.alignmentid=user.alignment

mysql error: Unknown column 'user.uttpoints' in 'field list'

mysql error number: 1054


help me plz

[Revan]

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

mysql error number: 1146

what should i DO?
Please consult the SP1 file located in post #40 in this thread, linked to from the first page :)



Invalid SQL:
SELECT
user.userid,
user.username,
user.rpgclass,
user.element,
user.rpgrace,
user.rpgtype AS rpgtype,
user.alignment,
user.rpggender,
user.posts,
user.maxhp,
user.maxma,
user.maxpp,
user.inbattle,
user.xp,
user.ma AS uma,
user.hp AS uhp,
user.pp AS upp,
user.ap AS uap,
user.uttpoints AS money,
rpg_battle_options.namefield AS namefield,
userfield.*,
rpg_battle_options.exprate,
rpg_battle_options.privacy AS battleprivacy,
rpg_items_user.*,
rpg_battle_stats.*,
rpg_rpg_race.name AS rpgracename,
rpg_rpg_race.alignment AS rpgalignmentname,
rpg_rpg_classf.name AS fclassname,
rpg_rpg_classf.folder AS fclassfolder,
rpg_rpg_classm.name AS mclassname,
rpg_rpg_classm.folder AS mclassfolder,
rpg_rpg_element.name AS elename
FROM rpg_battle_options
LEFT JOIN user ON user.userid=1
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN rpg_items_user ON rpg_items_user.userid=user.userid
LEFT JOIN rpg_battle_stats ON rpg_battle_stats.userid=user.userid
LEFT JOIN rpg_rpg_classf ON rpg_rpg_classf.id=user.rpgclass
LEFT JOIN rpg_rpg_classm ON rpg_rpg_classm.id=user.rpgclass
LEFT JOIN rpg_rpg_element ON rpg_rpg_element.elementid=user.element
LEFT JOIN rpg_rpg_race ON rpg_rpg_race.raceid=user.rpgrace AND rpg_rpg_race.alignmentid=user.alignment

mysql error: Unknown column 'user.uttpoints' in 'field list'

mysql error number: 1054


help me plz
If you have uCS installed, you have changed the Points Field location to something else than the 'uttpoints' in the 'user' table. Please change this back.
If you do not have the uCS installed, then you need to install this BEFORE this hack, otherwise you will get errors like this all over the place.
:)

[Rahzel_hx]

How do i added a field so my rpg name doesn't = my location?

[Revan]

Enter User Profile Field Manager, look at the ID of the "RPG Name" field, remember it, enter Edit Options in the Battle category, change Name Field to the field and id of your RPG Name field.
:)

[korny]

Enter User Profile Field Manager, look at the ID of the "RPG Name" field, remember it, enter Edit Options in the Battle category, change Name Field to the field and id of your RPG Name field.
:)
Hey Revan,

This may sound stupid, but does this hack have an actually battle field, where you and other users are fighting on a image of a field, with 2 or more characters battling it out, or is this RPG hack the one where you just type your actions in a thread, and wait for the other user to reply to your thread with another action?

[Revan]

Its like the RPG Integration Hack for vB2, so its the field stuff.
The latter you described is to me an RP, not RPG.

check out some of the forums that got it installed to see ;)

[Troak]

I got this error when going to update my RPG info

Database error in vBulletin 3.0.0:

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

mysql error number: 1054

[Revan]

ALTER TABLE `user` ADD `rpgstats` CHAR(1) NOT NULL DEFAULT '1';
I think I forgot to add that one to the installer... :p

[Logikos]

Great work revan, hotm definitly!

[Troak]

So how do I fix it using that code?

EDIT: I figured it out, thanks for the help! ^^

[Attrox]

Hmm.. me and my staff have been beta testing it, I'm kinda confused on where everything is. How do we equip items we buy? o.O

[deathemperor]

they are automatically equipped.

[Ganon]

Hmm.. me and my staff have been beta testing it, I'm kinda confused on where everything is. How do we equip items we buy? o.O

I figured it out. You have to go into the admin CP to configure them, how much damage they do, and also configure the item classes. Set weapons up as "one handed weapons" armor as "armor" and potions as "potions" If you want, I'll send you a screenshot of what it looks like from my Admin CP.

[Attrox]

Alright, thank you Ganon. :)

[Rahzel_hx]

Limit is broken >_< it does not do anything i just attack normal and it doesn't go down?

[Revan]

:confused:
Do you get the "Uh-oh, looks like someone is powering up!" message when you use it or not?
And for this to be a valid error, remember that the checkbox has to be checked AND disabled (IE ap = 100%) ;)

[Rahzel_hx]

I don't get a "Uh-oh, looks like someone is powering up!" message and the checkbox is checked and what do you mean by "AND disabled (IE ap = 100%)"

[Revan]

If your AP (Anger Points) is not 100 %, youll either get a disabled checkbox with "You are not mad yet" message.
If your Anger Points are 70-99 %, you will get a selectable checkbox and the message "Let your opponent know that you are mad!" message.
If your Anger Points are 100, you will get a disabled and checked checkbox saying "Thats it, you are mad. No more Mr. Nice Guy!" message.

Im asking this to get to know what your AP % was.
If you had even as much as 1 less than 100, you shouldnt lose any Limit, see ;)

[Henneth]

First of all, great work so far on the hack - it's ideal for the site I'm currently working on. I did have some major problems with it however, which I'll report here hoping they can be fixed in a later version.

I installed it earlier today without any major issues. I did notice a discernable slowdown of the entire site after the installation when performing RPG actions (creating test characters and performing test battles), but as I say, from a functionality perspective everything worked perfectly.

After about 20 minutes of commencing testing of the RPG hack (with only me and one other user online) my webhost suspended my hosting account. I contacted them and discovered that the CPU utilisation on my shared server had gone through the roof from the moment I installed the hack (they named the particular RPG queries and tables that were generating the problem). :ermm:

Luckily enough, I'd taken a full site backup prior to installing the hack so reverted to that and everything is now back to normal and my account is, thankfully, unsuspended. :o

I'd like to be able to perform further testing by cannot take the risk of reinstalling the hack and losing my host. I also noticed, when visting a demo version of the hack on a previous poster's site, that I experienced a very slow response and a number of timeouts when using the RPG menu.

I'll keep an eye on things and see how they progress as I'd really love to be able to integrate this into my site but cannot in it's present release.
:rolleyes:

[Polo]

First of all, great work so far on the hack - it's ideal for the site I'm currently working on. I did have some major problems with it however, which I'll report here hoping they can be fixed in a later version.

I installed it earlier today without any major issues. I did notice a discernable slowdown of the entire site after the installation when performing RPG actions (creating test characters and performing test battles), but as I say, from a functionality perspective everything worked perfectly.

After about 20 minutes of commencing testing of the RPG hack (with only me and one other user online) my webhost suspended my hosting account. I contacted them and discovered that the CPU utilisation on my shared server had gone through the roof from the moment I installed the hack (they named the particular RPG queries and tables that were generating the problem). :ermm:

Luckily enough, I'd taken a full site backup prior to installing the hack so reverted to that and everything is now back to normal and my account is, thankfully, unsuspended. :o

I'd like to be able to perform further testing by cannot take the risk of reinstalling the hack and losing my host. I also noticed, when visting a demo version of the hack on a previous poster's site, that I experienced a very slow response and a number of timeouts when using the RPG menu.

I'll keep an eye on things and see how they progress as I'd really love to be able to integrate this into my site but cannot in it's present release.
:rolleyes:

Wow....

* Polo wonders nervously :ermm:

[Rahzel_hx]

i have 100% limit >_< thats why i asked >_>

EDIT: lol i didn't have a wep but now i do and it says You do not have a weapon. so i can't click it >_<

[fade]

just a couple of really quick questions..

a few users after having played 1 battle, have experienced massive leaps in there MA and PP levels (from 30 to 13000 in some cases). I made sure i configured the rpg system before these initial battles, but have no idea why they are getting such huge bonuses after battles??

also, when a battle is submitted, the person being challenged receives a pm with a "To go to your battle click here". my "here" link is completely broken though, and won't work in it's current state. are you able to let me know which script i need to edit to fix this up at all?

cheers and nice hack, has certainly impressed a lot of my members :)

[Rahzel_hx]

First of all, great work so far on the hack - it's ideal for the site I'm currently working on. I did have some major problems with it however, which I'll report here hoping they can be fixed in a later version.

I installed it earlier today without any major issues. I did notice a discernable slowdown of the entire site after the installation when performing RPG actions (creating test characters and performing test battles), but as I say, from a functionality perspective everything worked perfectly.

After about 20 minutes of commencing testing of the RPG hack (with only me and one other user online) my webhost suspended my hosting account. I contacted them and discovered that the CPU utilisation on my shared server had gone through the roof from the moment I installed the hack (they named the particular RPG queries and tables that were generating the problem). :ermm:

Luckily enough, I'd taken a full site backup prior to installing the hack so reverted to that and everything is now back to normal and my account is, thankfully, unsuspended. :o

I'd like to be able to perform further testing by cannot take the risk of reinstalling the hack and losing my host. I also noticed, when visting a demo version of the hack on a previous poster's site, that I experienced a very slow response and a number of timeouts when using the RPG menu.

I'll keep an eye on things and see how they progress as I'd really love to be able to integrate this into my site but cannot in it's present release.
:rolleyes:

>_> hmm might want to upgrade hosting? i have a unregulated bandwith and space so i have no problems when i use alota space my host upgrads or moves me to a larger server
just a couple of really quick questions..

a few users after having played 1 battle, have experienced massive leaps in there MA and PP levels (from 30 to 13000 in some cases). I made sure i configured the rpg system before these initial battles, but have no idea why they are getting such huge bonuses after battles??

also, when a battle is submitted, the person being challenged receives a pm with a "To go to your battle click here". my "here" link is completely broken though, and won't work in it's current state. are you able to let me know which script i need to edit to fix this up at all?

cheers and nice hack, has certainly impressed a lot of my members :)

hmm check your ma and pp modifers (how much they get a lvl) .003 recomanded, then tell ur users to update there stats xP

[deathemperor]

First of all, great work so far on the hack - it's ideal for the site I'm currently working on. I did have some major problems with it however, which I'll report here hoping they can be fixed in a later version.

I installed it earlier today without any major issues. I did notice a discernable slowdown of the entire site after the installation when performing RPG actions (creating test characters and performing test battles), but as I say, from a functionality perspective everything worked perfectly.

After about 20 minutes of commencing testing of the RPG hack (with only me and one other user online) my webhost suspended my hosting account. I contacted them and discovered that the CPU utilisation on my shared server had gone through the roof from the moment I installed the hack (they named the particular RPG queries and tables that were generating the problem). :ermm:

Luckily enough, I'd taken a full site backup prior to installing the hack so reverted to that and everything is now back to normal and my account is, thankfully, unsuspended. :o

I'd like to be able to perform further testing by cannot take the risk of reinstalling the hack and losing my host. I also noticed, when visting a demo version of the hack on a previous poster's site, that I experienced a very slow response and a number of timeouts when using the RPG menu.

I'll keep an eye on things and see how they progress as I'd really love to be able to integrate this into my site but cannot in it's present release.
:rolleyes:
* deathemperor seconds wonderer....

[Dyntheos]

I have been watching this for some time now and first up I would like to thank Revan for putting the time and effort into making this available for free, and not having to pay for an rpg hack. Thank you.

Some questions not on installing this hack for I haven't begun that process yet but more along the lines of "How does one use" this hack?

I see how you buy gear and join a battle, but an explaination of how limit breaks, and AP and such function would be helpful. How do you actually "battle".

Also how does a member gain gil? Is this via postcount?

Lastly what configuration is needed in the admincp for this and is there a "standard" set of numbers someone could provide, or numbers they are using on thier board?

Again Revan awesome effort. Alot of people have been waiting for this since vb3 was released.

[Revan]

i have 100% limit >_< thats why i asked >_>

EDIT: lol i didn't have a wep but now i do and it says You do not have a weapon. so i can't click it >_<
Hmm.. try entering your ACP, edit the Weapons category and change it from 'Current (Weapons)' to 'Weapons' :)

First of all, great work so far on the hack - it's ideal for the site I'm currently working on. I did have some major problems with it however, which I'll report here hoping they can be fixed in a later version.

I installed it earlier today without any major issues. I did notice a discernable slowdown of the entire site after the installation when performing RPG actions (creating test characters and performing test battles), but as I say, from a functionality perspective everything worked perfectly.

After about 20 minutes of commencing testing of the RPG hack (with only me and one other user online) my webhost suspended my hosting account. I contacted them and discovered that the CPU utilisation on my shared server had gone through the roof from the moment I installed the hack (they named the particular RPG queries and tables that were generating the problem). :ermm:

Luckily enough, I'd taken a full site backup prior to installing the hack so reverted to that and everything is now back to normal and my account is, thankfully, unsuspended. :o

I'd like to be able to perform further testing by cannot take the risk of reinstalling the hack and losing my host. I also noticed, when visting a demo version of the hack on a previous poster's site, that I experienced a very slow response and a number of timeouts when using the RPG menu.

I'll keep an eye on things and see how they progress as I'd really love to be able to integrate this into my site but cannot in it's present release.
:rolleyes:
This has never happened to me, and I run this hack on my Apache on localhost.
Now IF this hack had CPU problems, it WOULD show itself on such a poorly configured "server" as my localhost ;)


I have been watching this for some time now and first up I would like to thank Revan for putting the time and effort into making this available for free, and not having to pay for an rpg hack. Thank you.

Some questions not on installing this hack for I haven't begun that process yet but more along the lines of "How does one use" this hack?

I see how you buy gear and join a battle, but an explaination of how limit breaks, and AP and such function would be helpful. How do you actually "battle".

Also how does a member gain gil? Is this via postcount?

Lastly what configuration is needed in the admincp for this and is there a "standard" set of numbers someone could provide, or numbers they are using on thier board?

Again Revan awesome effort. Alot of people have been waiting for this since vb3 was released.
I cant go into details atm as I am in school and my IT teacher actually got the 24 inch dildo out of his ass and started talking XD
You can enter your ACP and read the RPG Admin Manual, but that is hopelessly outdated. It will be updated in a future version :)


On a more general note, Im as of now working on phrasing the entire hack :)
Thanks for all the positive feedback, it felt damn good releasing this and bursting the bubble of those bastards on wBBMods...
They was all "Alot of people chose wBB over vB because of this rpg hack", now they = pwned! MUAHAHAHAHAHAHAHAHAHAHAH!!!!!1111one
;)

[fade]

omg wbb am teh pwntzord!!!11111222two + x = (b + y/4) * (y + yz)

[fade]

*cough* anyways, are you able to let me know which script to edit to fix the battle notification pm's revan? :)

[Revan]

O sorry I must of missed it. battle.php
I cant remember if I put in the readme that you should change the url, but theres this variable you can use instead, I think its $vboptions[bburl]
Find the phrase "To go to you battle, click" and change the 'http://[whatever url it has now]/battlefight.php' to '$vboptions[bburl]/battlefight.php' and reupload
;)

[Zelda-King]

A couple of issues with the installation instructions:

"run install/installer.php" should surely read "run installer/installer.php"?

####################
now open battle.php
###################

####################
find (do 2 times)
###################

http://forum.ultimateff.net/

####################
now change it to your forum url
###################The text "http://forum.ultimateff.net/" does not exist in any PHP file whatsoever. How has anyone installed this? I can only assume that need was removed and this step wasn't taken out of the instructions?
##########################
open admincp/index.php
##########################

#########
find
#########

if ($printhr == true)
{
construct_nav_spacer();
}

// *************************************************T here are 8 occurences of that code in /admincp/index.php. Which are we to edit? Either I assume?

There don't appear to be any directions for uploading the images. Where do they go?

---

Bug report: Using apostrophies in the lottery results in parsed slashes. ie, putting ' gives you /.

[Revan]

EDIT: It seems like these issues has already been resolved, apart from the admincp instructions being unclear ...

Could you tell me where you saw the lottery lacking stripslashes?
I can find it where it supposed to be in the file thats upped to here.... :ermm:

[Zelda-King]

I created a lottery. Called it "King-X's Lottery". Put some description for it which included words with apostrophies, then when I went to the lottery page the title and description had / added.

Incidentally, I got this error in init.php when adding midis. I don't know if it's a hack clash as my ini.php is modified already but I have to attach the error because the screen only shows for a moment.

The attached image refers to init.php line 343 which for me reads;
define ('REFERRER_PASSTHRU', $url);

[Zelda-King]

As for matters being resolved: nothing I've mentioned has been resolved in the instructions. There is still an instruction to edit two URLs in battle.php (an URL which doesn't exist). It still doesn't say what to do with the images, and the first steps still says "run install/installers.php" when the directory should read "installer/installer.php.

I'll tell you what would be good though: some sort of links solution. There're many sections and it's hard to find links to them, save maybe through the RPG manual.

--

Some user reported the following bug in RPG CP;


Fatal error: Maximum execution time of 30 seconds exceeded in /home/gamercr/public_html/bb/includes/db_mysql.php on line 210 .

I don't get that error but this user is in a custom usergroup. Another user reported the same problem. They aren't in a custom usergroup but they said they suspect it happened because they're part of a clan that doesn't exist (they made and deleted a clan).

(By the way I run vB 3.0.3 and yes I do have the uShop hack.)

[Revan]

Ok first of all that constant only evaulate to scalar stuff isnt something I can fix, because I seriously have no bloody clue wtf it means :p

EDIT: I see that edit stuff now. I was looking in the wrong place before ;)
zip updated.

As for the timeout stuff, that isnt this codings fault. Its PHP been compiled wrong on your server, as 90 % can run this without that stuff. :)

And "member of a clan that doesnt exist" is impossible, if someone deletes a clan thru the clancp, all records of it is removed and they should read "Not in a clan" ;)

[Zelda-King]

Hmm, ok so apparantly it has nothing to do with them deleting a clan. All I know is two people reported that error, but like I said: I don't get that error so I'm still in the process of locating the source of the problem.

Oh, and congratulations on your fixes today...

Now I need to ponder how to link to all these RPG pages. My Quick Links is getting rather long. :/

Update: I 'think' this was ok when I installed it but since unleashing this hack on my users, race doesn't show in the RPG CP and though the races do show in the admin cp they can't be edited and remain at the default 'current'. (They refuse to update.) I did a test with another account and it does show in the RPG CP if you haven't selected yet, though the only option for it now is 'Current', so I guess options users made affected something. Running the reset has fixed something though, so I will see if I can pinpoint what's going on.

Uncached template;

rpgcp.php: itembit2.

[Revan]

You can link to the rpg files by installing either one of the 2 navbar addons in the addons post, linked to from the first page.

Weird race stuff your getting. I edited races for my own forums (using the same file as you, from the zip) only yesterday :p
I wonder what good the reset would do :p ah well.

That uncached template is already listed in the rpgcp.php file, I guess it is uncached because the # of items an user got is relative.

[Zelda-King]

Oh well I figured out the 'blank race' thing. It's just the way it works. If no race is set to 'good' then if you choose to be good you'll just see a blank dropdown.

Thanks for the tip regarding the add-ons. I'd missed that. Unusual but I've been a workaholic with forum stuff lately.

With rpgcp.php I'm still getting a user get either;

Fatal error: Maximum execution time of 30 seconds exceeded in /home/gamercr/public_html/bb/includes/db_mysql.php on line 223

or

Fatal error: Maximum execution time of 30 seconds exceeded in /home/gamercr/public_html/bb/profile.php on line 852

They seem ok when I reset things, UNTIL they update their settings. Most of the others are fine. I've also been informed this happens at another board I used to work at. As for PHP timing out, I've not had this issue with the other 200 odd hacks I ever installed. I'm not saying your explanation isn't necessarily right but I find myself having to weigh things up.

And are admins supposed to not be able to battle? I can't battle even if I follow the prompt to 'update stats'. It seems the others can battle though.

[Rahzel_hx]

weapons where selected as non-combat >_< yea so i think it is fixed

[Revan]

Oh well I figured out the 'blank race' thing. It's just the way it works. If no race is set to 'good' then if you choose to be good you'll just see a blank dropdown.

Thanks for the tip regarding the add-ons. I'd missed that. Unusual but I've been a workaholic with forum stuff lately.

With rpgcp.php I'm still getting a user get either;

Fatal error: Maximum execution time of 30 seconds exceeded in /home/gamercr/public_html/bb/includes/db_mysql.php on line 223

or

Fatal error: Maximum execution time of 30 seconds exceeded in /home/gamercr/public_html/bb/profile.php on line 852

They seem ok when I reset things, UNTIL they update their settings. Most of the others are fine. I've also been informed this happens at another board I used to work at. As for PHP timing out, I've not had this issue with the other 200 odd hacks I ever installed. I'm not saying your explanation isn't necessarily right but I find myself having to weigh things up.

And are admins supposed to not be able to battle? I can't battle even if I follow the prompt to 'update stats'. It seems the others can battle though.
To check your own battle eligibility (spelling), enter rpgcp.php ;)

And the timeouts..... I really cant do anything... Seeing as I cant reproduce it, and its like 4 people in total with this problem... Really sorry mate :(


Its good to hear you got your problem sorted out Raz :) (at least some problems are fixeable :p )

[Troak]

I discovered a problem with the PMing.
I initiated a battle and it sent me a private message.
This was the message.

Your battle has been prepared. It is battle number 2 and is called TEST. There is $0 at stake in this battle. Your battle password is 'RPGTEST'. To go to your battle click /battlefight.php?action=enterbattle&battlenumber=2&battlekey=RPGTEST]here

When I clicked the link it brought me to this invalid URL:

http://$vboptions[bburl/

I'm guessing there was just a slight mix-up in the PM code.