RPG Integration Hack /w Battle (BETA)

RPG Integration Hack BETA by Bitsys
(vBulletin versions 2.2.6?, 2.2.7, 2.2.8, 2.2.9, and 2.3.0)

This hack combines several RPG hacks into one and adds a battle hack. The hacks included in this hack are:

• Zajako's Ultimate HP/MP Stats Hack -----(https://vborg.vbsupport.ru/showthrea...threadid=37720)
• Zajako's RPG Elements Hack -----(https://vborg.vbsupport.ru/showthrea...threadid=35318)
• Zajako's In battle hack -----(https://vborg.vbsupport.ru/showthrea...threadid=42715)
• Zajako's RPname hack -----(https://vborg.vbsupport.ru/showthrea...threadid=43651)
• DV class hack used with permission of J2K (aka the RPG Class Hack v3.3) ----- (https://vborg.vbsupport.ru/showthrea...threadid=43558)
• Mewtwo's/Rake's Original Itemshop v5 -----(https://vborg.vbsupport.ru/showthrea...threadid=38090)

In addition to re-releasing thse hacks, I have added features to all of them (or else there would be no point in re-releasing).

• The RPG hacks are now all editable via the admin control panel.
• The itemshop has been somewhat optimized and some fixes are included that reduce queries in showthread.php and itemshop.php . Also, Lesane's Store Hack has been integrated with the Itemshop. This can be toggled in the admin cp.

This means that the RPG hacks are database driven and have been partially integrated with the Itemshop. This was necessary in order to make a battle hack, which is also included.

Since most people are familiar with the RPG and Itemshop hacks, I will give a brief description of the Battle hack. If you want more information about either of the other two hacks, then refer to their original posts or download the .zip file and read the "readme.txt". If you are a visual learner, then you can scroll down to the second post in this thread, which contains the pictures of all of these hacks.


Battle Features:

• The battle format is turn-based.
• HP, AP, PP, and MA are automatically deducted based on what action a user takes, the damage dealt to an opponent, etc.
• Opponents in battle can use spells, one-handed weapons, two-handed weapons, shields, potions, or their fists.
• A battle is over when a combatant dies, retreats, or there is a draw. Battles can also be ended via the admin control panel.
• A wager can be set on a battle. Whoever wins the battle recieves the amount of money as specified in the wager. Outside bets are not supported yet.
• Battles can be either public or private, as determined by the admin control panel. If private, battles require a password and battles can not be browsed. If public, then any user can view any battle, but only the original combatants can fight.
• The results of a battle can be posted into a designated "Battle" forum, as specified in the admin control panel.
• Inactive battles can be pruned.

Getting started with the battle hack:

• In order to get items to disply in the item shop, you must select which items go with which RPG Type in the "Edit Item Type" Menu of the admin cp.
• In order to assign which weapon categories do what kind of damage in battle, you must go to the "Edit Category" link located in the "Edit Items" menu of the admin cp. Select a Battle type for the category and save changes.
• In order to do damage to your opponent when in battle, you must assign the amount of damage each weapon does in the "Edit Items" menu of the admin cp. The default damage is set to 0. The same principle goes for armor, potions, spells, shields, etc.

Please refer to the screenshots or "readme.txt" for more information.


Why is this a BETA hack?

I have tested the installation of this hack on vBulletin versions 2.2.7, 2.2.8, 2.2.9, and 2.3.0. However, because of the scale of this hack, there is plenty of room for errors. Therefore I am making the following disclaimer while this hack is in the BETA stage:


WARNINGS:

• Do not install this hack on a production board. Please keep this hack, while in the BETA stage, to a test board. The reason for not installing this on a production board is that I cannot provide upgrade instructions for going from one version of the beta hack to the next version of the beta hack. Also, this hack does not have an un-install script yet. So please remember, if you decide to install this on a production board, you are doing so at your own risk.
  
• Do not apply this hack if you already have ANY of the included hacks installed. Please refer to the list at the top to see if you have any of the conflicting hacks installed. Since I am asking that you install this on a test board right now, this should not be a problem since you can re-install a fresh copy of vBulletin in under 5 minutes, as a test board of course.
  
• There is currently no upgrade script for installing this over any of the included hacks. I will make one when this beta is completed.
  
• If you choose to install the postbit features, then an additional query will be added to showthread.php. This query is a SELECT COUNT(*) query and adds around .001 seconds to the page generation. If you don't like the idea of adding an additional query to showthread.php, then you have the option of not installing that part of the hack. See the install file for more information.

Miscellaneous:

The beta of this hack is free. The full/final release will also be free.

All installation instructions and credits are included in the attachment. If you find a bug or have problems, feel free to post them here and I will try to fix them. Please read the included readme file if you have questions. If you can't find the answer, then post your question here and I will answer it.

All hacks included in this hack have been re-released with permission of their original creators.

Screenshots are in the second post of this thread.


Installation:

Installation instructions are included in the .zip file.


ACKK! I NEED HELP!!!

If you are having trouble and need some help, please refer to the help documentation included in the .zip file. It is located in the "extra" directory.

If you need help and you have already installed the hack, make sure you check the RPG Manual link in the admin cp. Also, make sure you read the FAQ included with the manual.

MY THREADS STOPPED DISPLAYING CORRECTLY!!!
See if you are experiencing one of the following symptoms:

• All of my users are being labeled as "Guest" in the postbit template.
• No posts are showing up.
• None of the RPG variables will display in the postbit. The element/gender/class images are broken.
• I get database errors when I go to showthread.php

If you are experiencing one or more of the above problems, then your showthread.php file was not edited correctly by the installer. This problem usually occurs on boards with other hacks installed that modify the queries in showthread.php. Please go to https://vborg.vbsupport.ru/showpost....postcount=2261 and follow the instructions there.


Add-ons:
The following add-ons are not included in the default installation. You must apply these add-ons after you have installed the hack successfully.

Member profile add-on
This add-on let's you display the user's RPG Stats in their member profile. See the .zip file for the add-on. It is located in the "Member Profile Add-on" directory.

Auto-update stats after posting
This add-on automatically updates the user's stats after they make a post, instead of having to click on the update stats button in the user cp. This add-on involves 2 file edits. The add-on is located at https://vborg.vbsupport.ru/showthrea...452#post356452

Donation Queue by Darkwaltz4
Moderate all Donations. See Who is Donating to Who. All Donations go through Admins or Mods. The add-on is located at https://vborg.vbsupport.ru/showthrea...652#post408652

Battle Background Midi System by Darkwaltz4
Full control over the music that plays during your battles! The add-on is located at https://vborg.vbsupport.ru/showthrea...530#post410530

Randomized First Turn Addon by Moreliator
"The following code gives the challenger a 33% chance to start the battle and the challenged person a 66% chance. Works quite well. I also included instructions on how to display "Determining..." on the battle.php browse page, that way people won't decline a challenge if they see they aren't going first. ". The add-on is located at https://vborg.vbsupport.ru/showthrea...614#post410614

Lock RPG Options at a Specified Level Addon by Moreliator
This addon allows you to lock all users' RPG options in their USER CP when they reach a certain level. This add-on is located at https://vborg.vbsupport.ru/showthrea...111#post411111

Personal Shop Items Have Battle Bonuses by Triade
The original personal shop, allows to have an item the don't do nothing in battle. With this add-on, you can build items with bonus in battle (the bonus is in the attack now). This add-on is located at https://vborg.vbsupport.ru/showthrea...328#post426328

Challengable Option by Darkwaltz4
Allows users to set themselves against recieving battle challenges. This add-on can be found at https://vborg.vbsupport.ru/showthrea...143#post411143


Contact Info:
Bitsys
Email: bitsys AT mail DOT com
PM me for a faster response. I prefer PMs.

~~~~~~~~~~~~
Update 09/04/03 @ 1:46pm
v0.68c

Battle debug messages were accidentally left on.
Minor shield bug was fixed in battlefight.php (Thanks Telchar).

Re-upload battleupdate.php and battlefight.php.

The new .zip file is located at the bottom of this post.


Finally, here is the .zip file (v0.68c):

[soccerclue]

Are you sure that it is not working with version 2.3? Coz the first time I try, the link of HP..AP...in rpgcp.php is working. And those links are related with moderator.php files. I think there is some duplicate queries or missing queries I made or moderator.php file is wrong. And in the Edit Options part, that's member.php file, I don't know why the form duplicate for RPG fields. and other information messed up. I am afraid I deleted some used templates or duplicate some RPG datas? I really hope someone could help me this time. I am really screwed.

[Moreliator]

Well bitsy,

I gave it a go and allowed battling on my forums for one night, just to see how many glitches would arise.

A major glitch began to occur with some members' records. One had only participated in 5 battles. It showed his record as 25 wins though, and it showed that he only participated in 5!! He also obtained about 400 gil. this all happened after he pressed the "send reply" button to confirm a victory over another member.

Other members have a higher number of losses than they have even played.

I'm not sure if this helps you any. Do you have any suggestions for me to try out?

Stats and stuff seems fine. Only a couple members out of the hundreds playing had this problem.


Another very recent error is with One Hit KOs...kinda... Users reportedly get into a battle. The first person misses, then the second person selects fists. The refresh page shows the opponent dead.... but when it posts the battle results it never shows what move the guy did to kill the opponenet in one hit... its really odd.

EDIT: Alright, a little more info on the problem. I reset battle statistics and opened battling again. Everything went well, until it hit one of our members again. Here is how it happens:

The user is battling. In all of our cases he has been the challenger, going second, but this may not make a difference. When he refreshes the page, he experiences an error:

There seems to have been a slight problem with the Smash World Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

He then refreshed, and when the page reloaded, his opponent had lost ALL of his HP. In the battle reports, it has his oppoenent dying for no reason at all... Could this be a problem from overload of the database? Immediately after this his battle stats go wild. He has like 74 wins even though his "total battles" column only reads like 5.

Thanks.
-More

[soccerclue]

Ok forget my previous post..i have found the error. However, i have a slight error in UserCP >> Edit Profile page. There are duplicate RPG Name fields in it. Can someone tell me which part should I fix? Is it in template and which one?

[Airs]

Biiiggg Error... On my forums a user got hacked and the hacker kept creating battles and stealing another users money.. from making challenges himself.

[Bitsys]

04-20-03 at 09:38 PM Moreliator said this in Post #1505
Hey Bitsy,

We actually fixed it.... if you want the code we replaced in itemadmin.php just let me know, my AIM name is 'Moreliator'

If your getting the new version out soon, here is another thing you may want to fix: in GIVING gil, you can give letters. For donations, it won't let you, but if you arfe an admin/mod and you decide to give gil to a user, you can type in text like "egg" and it will screw up their financial account, heh. Just thought I'd let you know, although its not too much of a problem.

Once again, if you want that fix just let me know over AIM... may save you some time.

Keep up the good work. I'm goign to be opening battling on my server pretty soon... I'll let you know when its ready so you can take a look at how I implemented your hack on my site.

-more

I didn't do validation checks for mod/admin features because I figured they would know what they were doing, hence why you can enter words for gil.

04-20-03 at 10:19 PM Airs said this in Post #1506
The battling thins doesn't work when a peron has ' in their username.. it screws up and doesn't let the user do anything. and sends a load of error mails to the admin (me)

Thanks, will be fixed in the next version.

04-21-03 at 09:28 AM Sonikku said this in Post #1507
I too found a bug. When I go to add hp, it won't add. For example I have 144hp and I want it to go up to 199. I have to add 55hp to get to 199, right? Well, I try adding the 55hp but it stays at 144. =/

Do you understand what I mean? I sound confusing. ^^;

Does it add and stay for a little while but change when the user updates his/her stats? If so, then this is the way it is supposed to work. You cannot manually change the stats and expect them to stay. The updater overrides manual changes.

Yesterday at 03:47 PM Moreliator said this in Post #1512
Well bitsy,

I gave it a go and allowed battling on my forums for one night, just to see how many glitches would arise.

A major glitch began to occur with some members' records. One had only participated in 5 battles. It showed his record as 25 wins though, and it showed that he only participated in 5!! He also obtained about 400 gil. this all happened after he pressed the "send reply" button to confirm a victory over another member.

Other members have a higher number of losses than they have even played.

I'm not sure if this helps you any. Do you have any suggestions for me to try out?

Stats and stuff seems fine. Only a couple members out of the hundreds playing had this problem.


Another very recent error is with One Hit KOs...kinda... Users reportedly get into a battle. The first person misses, then the second person selects fists. The refresh page shows the opponent dead.... but when it posts the battle results it never shows what move the guy did to kill the opponenet in one hit... its really odd.

EDIT: Alright, a little more info on the problem. I reset battle statistics and opened battling again. Everything went well, until it hit one of our members again. Here is how it happens:

The user is battling. In all of our cases he has been the challenger, going second, but this may not make a difference. When he refreshes the page, he experiences an error:



He then refreshed, and when the page reloaded, his opponent had lost ALL of his HP. In the battle reports, it has his oppoenent dying for no reason at all... Could this be a problem from overload of the database? Immediately after this his battle stats go wild. He has like 74 wins even though his "total battles" column only reads like 5.

Thanks.
-More

Can you send me a copy of the e-mail that was sent to Tech Support when the user got the database error?

Yesterday at 06:54 PM soccerclue said this in Post #1513
Ok forget my previous post..i have found the error. However, i have a slight error in UserCP >> Edit Profile page. There are duplicate RPG Name fields in it. Can someone tell me which part should I fix? Is it in template and which one?

Go to your memberprofile template located under the User Options heading. Look for the two duplicate RPG Name blocks of HTML code and delete the one at the top.

Today at 06:54 AM Airs said this in Post #1514
Biiiggg Error... On my forums a user got hacked and the hacker kept creating battles and stealing another users money.. from making challenges himself.

How am I supposed to prevent a user from getting hacked?

[PSI|Dr-X]

Today at 12:54 PM Airs said this in Post #1514
Biiiggg Error... On my forums a user got hacked and the hacker kept creating battles and stealing another users money.. from making challenges himself.

Just ban that user -_- ..... because the user that has been hacked has probally reported to you else you wouldn't know he was hacked ... or just change the password and give it to the real account owner :bunny:

[Moreliator]

Today at 08:04 PM Bitsys said this in Post #1515

Can you send me a copy of the e-mail that was sent to Tech Support when the user got the database error?

Hmm, well I'm getting so many emails now, that I';m not sure which one it was. But all of them are basically the same:

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO battle_posts VALUES (NULL,'326','s'mores','8447','The 1337 Beast used his Scratch to deal 12 points of damage. Mediator tried to dodge, but was not successful. Mediator has died!!')
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 'mores','8447','[I]The 1337 Beast used his Scratch to dea

mysql error number: 1064

Date: Tuesday 22nd of April 2003 08:00:03 PM
Script: http://smashboards.com///battleupdat...26&username=s\'mores&userid=8447&battlekey=Smashboards
Referer: http://smashboards.com//battlefight....ey=Smashboards

s'mores is the guy who has the really messed up battle record. I checked all the email errors I've been getting, and ever since the first guy got his record screwd up they have all been this '1064' error with similar messages:

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO battle_posts VALUES (NULL,'333','s'mores','8447','The 1337 Beast was awarded $0 for winning the battle.')
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 'mores','8447','[I]The 1337 Beast was awarded $0 for winn

mysql error number: 1064

Date: Tuesday 22nd of April 2003 08:05:57 PM
Script: http://smashboards.com///battleupdat...33&username=s\'mores&userid=8447&battlekey=smores
Referer: http://smashboards.com//battlefight....33&username=s\'mores&userid=8447&battlekey=smores

The only other email error message I receive is:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT field5 FROM userfield WHERE userid=
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 '' at line 1

mysql error number: 1064

Date: Tuesday 22nd of April 2003 05:15:51 PM
Script: http://smashboards.com//itemshop.php
Referer: http://smashboards.com/itemshop.php?action=donate&user=

But that doesn't seem to be too big of a problem.


EDIT: Okay, I did more research, and it appears these problems are coming from the fact that people with a ' in their name are screwing up syntax. I reset battle standings and told the people with ' and & in their name not to play, and so far no problem.

Any ideas on that donation error? It appears members only have success donating through the profile.

[PSI|Dr-X]

When is the next version actually comming?

[soccerclue]

Hi,

I don't know why that everytime people go to battle, they can only use fists even if they have weapons and the HP always decreases 5 points everytime. I am using vb 2.3. Please check my forum at http://www.asianguild.com

[Nintel]

I need some help. I get this error:

Fatal error: Call to undefined function: getlevel() in /hsphere/local/home/side5411/forums.nintel.com/forums/admin/functions.php on line 383

and the coding around line 183 is:

// ###################### Start getforuminfo #######################
function getforuminfo (&$forumid) {
global $DB_site;
global $forumcache;

$forumid = intval($forumid);
if (!isset($forumcache[$forumid])) {
$forumcache[$forumid]=$DB_site->query_first("SELECT * FROM forum WHERE forumid='$forumid'");
}

return $forumcache[$forumid];
}

What's wrong?