RPG Integration Hack /w Battle (BETA)

[Bitsys]

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/showthread.php?s=&threadid=37720)
Zajako's RPG Elements Hack -----(https://vborg.vbsupport.ru/showthread.php?s=&threadid=35318)
Zajako's In battle hack -----(https://vborg.vbsupport.ru/showthread.php?s=&threadid=42715)
Zajako's RPname hack -----(https://vborg.vbsupport.ru/showthread.php?s=&threadid=43651)
DV class hack used with permission of J2K (aka the RPG Class Hack v3.3) ----- (https://vborg.vbsupport.ru/showthread.php?s=&threadid=43558)
Mewtwo's/Rake's Original Itemshop v5 -----(https://vborg.vbsupport.ru/showthread.php?s=&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.php?p=433115&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/showthread.php?postid=356452#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/showthread.php?postid=408652#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/showthread.php?postid=410530#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/showthread.php?postid=410614#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/showthread.php?s=&postid=411111#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/showthread.php?postid=426328#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/showthread.php?p=411143#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):

[Bitsys]

Here are the pictures (.zip file):

[Brad]

Someone releases a battle hack!, sto pthe presses, hell just froze over ;).

Looks nice so far man, IMO it needs a bit of template work by looking at the screenys. Ill wait for the final myself. Thanks alot.

[Erwin]

Interesting. :) Made it just in time before vB3 comes out. ;)

[Brad]

Thats a bad thing?. vb2 for life ;)

[Bitsys]

Originally posted by Anime-loo
Looks nice so far man, IMO it needs a bit of template work by looking at the screenys. Ill wait for the final myself. Thanks alot.

I have to agree with you on that. Hehe, gives me something else to work on ;)

[Goldknight]

Nice work.. I aint mind to install this hack and beta-tester for you but I dont like vbhacker =\ I wonder can you convert it to .txt for me to do the manual install?

[Brad]

you can get a text file via vbhacker.

[Brad]

Bitsys, im going to install this on localhost, if you'd like i can clean up the templates a bit for you.

[Link14716]

OMG, hell has frozen over! Save me from doom! And don't let hellsatan drive on the ice!

Nice... I'll consider it....

[Goldknight]

Originally posted by Anime-loo
you can get a text file via vbhacker.

Like I said, I dont like vbhacker so I didnt install it at all =\ It s evil >:F

[Bitsys]

Originally posted by Goldknight
Like I said, I dont like vbhacker so I didnt install it at all =\ It s evil >:F

Well, there is not really any "installation" of vbHacker. You simply upload the vbhacker file and you are done. So, umm, that would be the best way to get the text file. However, I must warn you that I doubt you want to manually install this hack. There are 51 new templates, 3 template edits, 16 file edits, and 32 queries (roughly). If you have the stamina and patience, then go for it. However, I suggest vbhacker. I tried to make the install file as clear as possible on what to do and what not to do with the vbhacker part of the installation.
EDIT: I have attached the vbHacker generated text file. It is 160KB. Good luck ;)


Anime-loo:
That would be great if you could clean up the templates a little. :)

[Brad]

Just upload the script, run it, get your txt and deleate it ;)

[Goldknight]

Ok ok, you win Anime-loo I m going to try it out

ohh Bitsys did it.. thanks =) I ll try both manual and vbhacker to see how it is.

[350Chevy]

I think it looks great! Excellent mod! I'll have to toy around with it after it comes out of beta. Maybe I'll transform it from a Battle mod into a Drag Racing mod (buy N20, Turbos, ect..ect..) since my site is a car site. :D

[zajako]

Nice hack. And i thank you for askign permission about my hacks being used. You are truely a responcible hacker :p Just don't drink and hack :p It does not work well :p

[Goldknight]

Originally posted by zajako
Nice hack. And i thank you for askign permission about my hacks being used. You are truely a responcible hacker :p Just don't drink and hack :p It does not work well :p

Now all leave is.. YOUR hack :D Thats one I kept wait and eyes on your thread daily =P

[jjdog2]

nice hack... I install and I did have a few problems, I would rather discuss it on AIM so I will add you to my list and PM you when I see ya on

[Ninth Dimension]

Coolness, this hack looks cool, and i very much might have to spend some time testing this little baby out. well done and good work.

one quick question, I'm guessing that battles can go on for as long as need be until it's over? so that I can battle with someone that it's a diffrent timezone to me? (much like long distance games of chess?)

[Kevorkian]

i've inserted the code for the exp bar ap ma ecc... but work only exp why? http://lnx.animesaga.org/forum/showthread.php?postid=8#post8

[Kevorkian]

the life up with the post O_O i'm at seven post with 81 of hp

[DrkFusion]

I am not really a fan of RPG, but you have done a goo job looking from the previews.

[Bitsys]

Zajako:
I guess it is a good thing I don't drink ;)

jjdog2:
I'll be on AIM for a while today and most of the weekend. You are on my buddy list also.

Ninth Dimension:
That is correct, battles go on as long as possible and both combatants are NOT required to be online at the same time in order to fight. There are several ways a battle can end. If you kill the other player, then the battle ends. If you retreat from the battle, then the battle ends with you getting defeated (i.e. losing the wager). If you request a draw and the other player declines, then you cannot ask for another draw until after the other player requests a draw (and you decline his request). If you request a draw and the other player accepts, then the battle ends. If the other player is being extremeley stubborn, and you do not want to retreat and lose the money, then you can ask an admin to delete the battle from the admin control panel.

Kevorkian:
Look at the 'getpostbit' function of "functions.php" located in your admin directory. Search for code that is not tabbed over like the rest of the code (assuming you installed it with vbHacker). If you do not see code that is un-tabbed, then the install did not go as planned for some reason. Were there any errors in the installation? Also, did you update your stats in the user control panel? If you have not updated your stats or not selected an alignment/race/class/element etc. then you should get 0s for all of the values. At the moment, you are getting nothing (from what I can see). I have attached an image of an example postbit.

DrkFusion:
Thanks!

One thing I forgot to mention about the battle is that there is a built-in anti-grief mechanism. Whenever anyone challenges you, you will receive a PM explaining the terms of the battle. It will also include a link to the battle. When you click on that link (or the one on the battle browse page) you will be asked if you want to accept the challenge. If you decline the challenge, then the battle is over with no more input from you or the person that challenged you. This is in place because several of the level 21s on my forum thought it would be "funny" to challenge level 5s and kill them in one hit. Hence the term "anti-grief mechanism".


Here's the image, Kevorkian:

[ULTIMATESSJ]

holy monkeysticks, it's finally happens *hides in fear*

well it looks nice so far, just to wait now for the billion rpg forums around the internet to install this hack

[Dean C]

This looks quite nice

If i had a battle hack i dont want all this RPG stuff in it but thanks for sharing it with the community anyway :)

Regards

- miSt

[Velocd]

Looks interesting, would anybody be interested in giving a demo account if you have it installed on your forums? Before installation, considering it is a quite large.

[JaZz0r]

Very nice! I have installed it on my test board and FINALLY able to tease my users just a little bit more... ;)

Suggestion: Would be nice to have an option to turn on/off the RPG postbit info (if there is an easy way to do this, please let me know!).

Edit: Can't battle for some reason. When I try to challange someone, I get an error: "Your opponent is ineligible for battle at this time." What makes us eligible? Characters appear to be complete...

Also: The requested URL /battleforum/mod/refill.php was not found on this server.

[DarkDraco07]

hey bitsys, can i talk to you too on aim? my screen name is DarkDraco07

[DarkDraco07]

also can anyone make this store hack integrated? because im using the hack that lets you use store money in itemshop

[Bitsys]

Velocd:
If you want, you can make a test board (as stated at http://www.vbulletin.com/license.html). This is the easiest way to get familiar with this hack, since the admin features are half the fun ;) It takes about 20 minutes to set up a test board and install this hack.

JaZz0r:
Could you please explain a little more about the on/off postbit thing? Do you want it to only display in a certain forum? Or do you want an admin cp "yes/no" button that turns it on and off for the whole board?

I found the missing file causing the 404 error. It was hiding from me. The next update will include it.

There are several checks in place before you can battle. When creating battles, it checks to see if

you have no class selected
you have no race selected
you have no gender selected
you have no alignment selected
you have no hp (you are dead)
you have no posts

If any of the above are true, with either you OR your opponent, then it will say you (or your opponent) are ineligible for battle.


I have fixed an error where the user's RPG name was not displayed properly in the battle arena.

I have added another feature. Instead of having a user's power level automatically calculated based on their post count, you now have the option to make a user's level admin-defined, based on a profile field in the `userfield` database. User fields can be added via the admin cp. The new feature will appear in the battle options menu, and I will upload that version (with the bug fix) as soon as I test it. Someone requested this feature (they also found the bug :)).

Thanks to everyone who has tested (or wants to test) this hack! I greatly appreciate it!

[mewgood]

nice work.
so far any bugs?

[geniuscrew]

*drools*

Looking awesome - so Zak, are u gonna continue with ur hack then?

Very well done Bitsys!

[zajako]

of course. I have been working a lot recently, but i am still working on it, and will not stop, till its done :p

[geniuscrew]

Nice one - However better get back on topic before I get my a$$ kicked ;)

Bitsys - how would you make a heal spell. I'm curious because I'm about to install it.

Also your stats say [+ mp] etc for elements. Does it add the HP? o.O

[Bitsys]

Originally posted by geniuscrew
Nice one - However better get back on topic before I get my a$$ kicked ;)

Bitsys - how would you make a heal spell. I'm curious because I'm about to install it.

Also your stats say [+ mp] etc for elements. Does it add the HP? o.O
I had not thought of heal spells. I will try to add that tomorrow. You can wait for that version if you want, it shouldn't take too long to make.

I am not sure about what you are asking as far as elements are concerned. The formula from the original element hack is still there. The element adds to your HP, MA, and PP. Your AP (anger percentage) must be a value between 0 and 99. Therefore, you can assign anything for the + to HP, + to MA, and + to PP of an elements, however, you should only assign a number between 0 and 99 for the AP of an element. Every time the user updates his/her stats after gaining a new level, the AP modifier of their element will determine how mad they are after gaining a new level.

[geniuscrew]

i didn't install the elements hack before :p

A couple of things.

My EXP is always on 99% and my update.php doesn't do anything when I run it through my cp

[Bitsys]

Originally posted by geniuscrew
i didn't install the elements hack before :p

A couple of things.

My EXP is always on 99% and my update.php doesn't do anything when I run it through my cp

Which version do you have? v52 had an update stats bug. v53 fixed it. For the "99%" error, check to make sure you have the "Use the user's post Count for their Power Level" feature enabled in the "Edit Battle Options" Menu of the admin cp.

[geniuscrew]

OK

So it's 99% because i selected "no"? because I don't really want posts to determine power :/

[Bitsys]

Originally posted by geniuscrew
OK

So it's 99% because i selected "no"? because I don't really want posts to determine power :/

I can easily change what percentage it says, statically. However, I do not have a solution for making the experience change automatically. If your level is not determined by your post count, then it has to be determined by the admin. If the admin determines it, then how do you assign/calculate experience? Let me know, and I will try to implement it.

[geniuscrew]

I was thinking more along the lines of the number of battles you win rather than posts :-/

I'm no whizz at PHP btw lol

[Velocd]

Looks great bitsys, I might consider an installation on my localhost forum just for fun :p The design looks great, and I can tell you're an experienced coder. From most other battle-hack designs I've seen, this is so far the best. ;)

By the way, how query efficient is this hack?

[geniuscrew]

Sorry to bother you again Bitsys, I don't know if it's a bug, but it looks like one.

I cannot "wager" anything, not even 0

[Bitsys]

Velocd:
I have optomised the queries as best I can, including re-doing parts of the itemshop to make it more query efficient. For example, if you look at the picture title "itemshop_generic.jpg", you will notice that there is only one item category displayed. For each item category, there is one query that must be made. In order to save queries, I made it so that you have to click the "expand" link next to the Category name (in the picture, the link is yellow). When you click the link, the page refreshes with the selected category appearing in an "expanded" view at the top of the other categories, and the category that was expanded before becomes "compressed". The reason I did this is because the Generic Item Type page is the default page whenever someone visits itemshop.php. Some people were noticing that itemshop.php eats up quite a few queries. My solution was to have the Generic Items get contracted and all other item types (see itemshop_warrior.jpg) to be automatically all-expanded.

Also, the files that I made (the battle hack files) have been optimised as compared to earlier version. I believe I eventually got battlefight.php down to 18 and battle.php to 7 or 8. Battle browse is 9 I think. I don't know about battleupdate.php though, since there are so many combinations of things that it could do based on how a user attacks. Also, whenever you view the bank, there are now around 8 queries, whereas before there were 21, I think. Overall, there may be some more places for improvement and I will be looking into that a little more.

geniuscrew:
Could you post the exact error message you are getting?

[Goldknight]

Bitsys

So far your .53 verison work great. Several members and I test your hack and will let you know more. Anyway There are three things that I d like to bring up about..

First of all..

What is Ma, PP, and AP? I always like old classic rpg stats anyway I need to know what are these so I can change to old classic rpg stats. Thanks

Second, Check Stats and Donate link (javascript) it s bit annoy me whenever I click these link and bump me to top of the thread. I wonder is there any way for me to stay where I am when I click the link? Thanks

Third, One member want me to ask you, will it affect the queries if I add text and graphic stats both in postbit? Again, it is old classic rpg looks. I like it but I m not sure if it ll increase more queries or not. Pls lemme know.

Many thanks! I ll come again if I have some QQ or suggestions.

[Bitsys]

Originally posted by Goldknight
Bitsys

So far your .53 verison work great. Several members and I test your hack and will let you know more. Anyway There are three things that I d like to bring up about..

First of all..

What is Ma, PP, and AP? I always like old classic rpg stats anyway I need to know what are these so I can change to old classic rpg stats. Thanks

MA = Magic Aura. This is similar to mana in traditional RPGs. MA is used up when you use spells.

PP = Power Percentage/Points. Currently, this does not affet the battle, because I have not implemented any kind of special moves for characters. However, in the future, this will act like a sort of "special attack" pool from which the character can draw upon for special attacks. This is subject to change.

AP = Anger Percentage. This is how mad your character is. When it reaches 100, your character does 10%-X% extra damage, based on your level. Your character gets mad when he/she misses the opponent in battle, or when the opponent dodges, or when he/she fails to do any damage to the opponent.

Originally posted by Goldknight

Second, Check Stats and Donate link (javascript) it s bit annoy me whenever I click these link and bump me to top of the thread. I wonder is there any way for me to stay where I am when I click the link? Thanks

I think I can make a fix for this. I am not sure though. i understand your frustration. If anyone out there knows any easy fix, then please let us know!

Originally posted by Goldknight

Third, One member want me to ask you, will it affect the queries if I add text and graphic stats both in postbit? Again, it is old classic rpg looks. I like it but I m not sure if it ll increase more queries or not. Pls lemme know.

Many thanks! I ll come again if I have some QQ or suggestions.

Whether or not you add text and graphical stats to the postbit will in no way affect the queries. The number of queries is determined by which installation option you choose during the install. If you choose to edit showthread.php, then all of the variables will be available, at the expense of ONE additional query that takes about .001 seconds to execute (it is a SELECT COUNT(*) query). If you choose not to edit showthread.php, then you cannot use any of the variables, and there will be no additional query. Remember this is one additional query for showthread.php, NOT the getpostbit function (which is a looping function inside of showthread.php).

Let me know if you have any more questions. :)

[Goldknight]

Many thanks for answer these questions =)

About Javascript, I ll check it out tmw to find a solution to see if I can solve and will let you know.

Anyway I wonder is there any way for me to edit php or whatever to change the percent of increase hp, ma, pp, and ap? To slow these down I guess =D I just want to play with these a bit more.

In any way, it is great hack and excellent work! Thanks!

[Bitsys]

Originally posted by Goldknight
Anyway I wonder is there any way for me to edit php or whatever to change the percent of increase hp, ma, pp, and ap? To slow these down I guess =D I just want to play with these a bit more.

In any way, it is great hack and excellent work! Thanks!

If you are looking to slow them down, then I assume that you want to make them go up less every time someone updates their stats, correct? There is any easy way to adjust how high they go up:

In update.php find:
$maxhpupdate = ( $level * 75 * $hpmulti) + $hpmodifier;
$maxhpupdate= floor ($maxhpupdate);

$maxmaupdate = $mamodifier + ($jointime * $level) / 5;
$maxmaupdate = floor ($maxmaupdate);

$maxppupdate = $ppmodifier + ($jointime * $level) / 3;
$maxppupdate = floor ($maxppupdate);

Those formulas determine the maximum about of hp, ma, and pp that a person has. AP is determined strictly by their element (see the "+ to ap" field of elements in the admin control panel).

To adjust the amount that HP goes up, change the "75" to a number of your choice (a smaller number will make it go up less, since you are multiplying).

To adjust the amount that MA goes up, change the "5" to a number of your choice (a greater number will make it go up less, since you are dividing).

To adjust the amount that PP goes up, change the "3" to a number of your choice (once again, a greater number equals less PP).

This change should apply retroactively once a user update's their stats. So, you shouldn't have to make a new character to test your changes; just keep updating your stats and notice the difference each time.

Is that what you wanted to do?

[Mijae]

Excellent, finally a working battle script, even if its beta. Ill get a test board up later tonight and test this ;)

[Link14716]

I'll probably install it, but I better be sure and change MA to MP :) MP just looks better and more FFish lol

EDIT: And yes, I am crazy enough to install this on a production board. :D

[Goldknight]

Bitsys , yes thats what I want =D Sorry for not clear. I post these by appox 3 am.

Many thanks!

[Mijae]

This would be one hell of an X-mas gift for my members if this hack goes out of beta before 12/23 :P

Altho not very probably due to the size of the hack and possible bugs it might have ;)

[Goldknight]

Seem that I miss one thing, is there possible for me to tweak fast or slow increase percent of exp? Thanks in advance

[corsacrazy]

:ogre: im always getting

Your opponent is ineligible for battle at this time.
or
You are ineligible for battle at this time. Please try updating your stats in the User Control Panel.

pls help

[Vivi Ornitier]

does this ONLY work on 2.2.7+?

2.2.6 work at all?

[Bitsys]

Goldknight:
I will include that feature in the next release. It will be editable in the admin cp.

corsacrazy:
Did you read this post? https://vborg.vbsupport.ru/showthread.php?postid=328672#post328672

Vivi Ornitier:
I have not tested this on 2.2.6 because I do not have a copy. Feel free to set up a test board of v2.2.6 and give it a shot. If it does work, let me know and I will update the thread accordingly. If not, let me know what went wrong and I might make a separate version for 2.2.6.


The next version (v0.55) will hopefully be released tonight. It will include many bug fixes and some new features. I am currently testing it on my test board.

[jags2ooo]

Ok, I have many questions for Bitsy, 1 how do you make a link so people kno where to go for these battles. Also I want to kno why for instance my stats like attack and speed are all at zero. DO i need to battle for them to go up? An example of my forum is here http://forums.ani-pro.com/vb/index.php

[Brad]

jags, why are you running a new install of 2.2.6?

[kmfdm_kid2000]

Nice work, it'll be great if the full release works ok w/ Zaj's...His is one I've been anticipating...

I got a chance to test out Zajako's new Battle Hack, and let me tell you people, IT'S PURELY AMAZING...

It still needs work, but for what he has so far, it's like nothing you've ever seen before...Like a FULL RPG...

This looks pretty cool too, so when both are final releases, I'll probably install them both...

[geniuscrew]

When I wage anything it says

Processing battle

You do not have 2 gil to wager

But I have 20 gil!

[Bitsys]

jags2ooo:
When you create a battle, you should receive a PM giving you a link to the battle. If the link does not work, then please re-read the install file (step #1). You can also find a list of battles on the Battle Browse screen (link from battle.php).

kmfdm_kid2000:
I have tested his hack. We have also traded template names and database tables. So far, the two hacks are compatible with one another.

geniuscrew:
You must have money in the bank in order to wager. The money is taken directly from the bank. I did this to prevent cheating. I will see if it is OK to pull money from your pocket and I will update it accordingly.

[geniuscrew]

Thanks a lot for your help! That explains it then :: goes off to test battle system ::

[geniuscrew]

I have put 10 gil in the bank, but

- it says Bank Deposit:, then nothing after the colon - is there meant to be something there?

- it says Total Bank Property: 0 and Total Bank Clients: 0 too even though I've put some money in the bank.

Also, it's still not letting me fight [You do not have 3 gil to wager]

Edited: Now I can't take any money out [The amount of money you entered is invalid!]

i'm using a fresh 2.2.9 install btw

[Bitsys]

Yes, it is supposed to look like the screenshot "itemshop_generic". Make sure that you are logged in. Also, can you create a battle by specifying $0 as the wager?

[Goldknight]

Problem fixed

[Bitsys]

To give users gil in the admin CP, go to "Find Users". Click on "List All Users". Find the user you want and click the "Edit" link. At the bottom, you will see a field called "Points". Put as much gil as you want in that field and click "update".

To solve your "I can't use items in battle" problem, do the following:

In admin cp, go to "Edit Items". Look at a category name. Click on the edit link next to that category. Make sure that there is a battle type associated with that item category.

Make sure that the amor and accessories have a check mark next to them under the Generic item type (in the "Edit Item Type" menu in the admin CP). If they do, and you still can't see them in the itemshop, then let me know. The next version will fix this by assigning everything to generic as the default.

[Glenn379]

Hey Bitsys freat hack.. I'm installing it now. May I please talk to you on AOL Instant Messenger? My screename is glennelmo. Please, I'd like to ask you something on there. Thanks for the hack :)

[Goldknight]

Thanks for answer

About gil, oops you re right. I miss that one. Again sorry to waste your time.. I know how annoy I am right now =\

As for Itemshop, I still cannot see Armor or Item at all, my member still can see it or buy it. Yes I did mark all of checkboxes in Generic and still not work for me.

As for battle, I cannot do anything since my member is gone for while. I ll let you know more right after test the battle for Weapons to attack.

Many thanks

[DarkDraco07]

did you click expand next to Armor or Accessories? and u need to set items to generic or whatever to see them

[DarkDraco07]

thats not the problem, i had 2 members register befor i installed it and 1 after. they all bought 1 of each item without a problem. well all fought without problems

[DarkDraco07]

go on your msn messenger or whatever. i added Goldiknight@hotmail.com to my list

[Goldknight]

Thanks to DarkDraco to clear everything else. It s work perfect now. Thanks to him/her and Bitsys =)

[DarkDraco07]

im a him!!

[Goldknight]

Okkk sorry =( you re HIM

[DarkDraco07]

hey bibsys, a question. was the "pm when its your turn" gonna be in v55?

[Mijae]

Edit again:

My alignment changes back to Unknown for no reason.

Running on a test board v229

[jags2ooo]

No I am not using 2.2.6, I am using 2.2.8, it only says 2.2.6, i have to update the image. Well you did not answer my question, why are all the stats empty. Speed, Magic, etc are all set to 0, why is that? and when everyone punches it never hits!

[Bitsys]

v0id:
What other options did you select in the user cp? What race? What class? What gender? etc.

jags2ooo:
Stats are empty until you select a gender, alignment, class, race, etc. in the user control panel. Punches don't do any damage right now because they would be unbalanced if they did. Right now, they should be used as an "I skip this turn" type of move. I am working on a balanced amount of damage for using your fists. One idea I had was to make it so that if you attack your opponent with your fists, and he is not wearing armor, then you have a chance of doing damage. If you try to punch your opponent and he is wearing armor, then you have a high chance of injuring yourself.

v0.55 is almost done with testing and should be ready for release soon. It will not include the "PM when it is your turn in battle" feature, yet.

[Goldknight]

Bitsys or Darco

Right after good sleep, I rechecked everything else and rpg battle work perfect. But one thing I still cannot figure (Darco, I tried!) the spells. How can I get it to work? Is there any way for me to add new spells? Thur Add Item category/ items or ? In battle, I choose Black mage and still cannot access "spells" attack since its grey out.

That is my very last QQ...

[jjdog2]

for those of you wanting to see a test board with this working on it check
http://www.twisted-revoltnetwork.com/testvb

oh, if your not loggedin you cant view the battles...

GoldKinght: To do spells you have to make one in the Itemshop and sell it. You can only have one spell at a time right now though.. maybe he will fix that in a future version.

[Mijae]

Elements screen

[Mijae]

Female classes

[Mijae]

Male classes

[Mijae]

Races

[Mijae]

Postbit

[Mijae]

Last but not least, the profile.

Notice in the pic above it says Alignment: unknown, yet in this pic it stays selected at Human.

[Goldknight]

jjdog2, thats what I think. Many thanks =)

[Mijae]

So far I did this to get it working:

In races screen, in the ID 0 I had to create 2 races, and if I select the 2nd one I get the alignment to show up correctly, but if I chose the 1st one it says Unknown.

If I select Human, it goes to Unknown, if I set it to Nymph it says Neutral, while they are both in the neutral Alignment.

[Davey]

I didn't understand the postbit instructions whatsoever.
I installed it on a fresh install 2.2.9.
Could you make the instructions a little clearer please, Bitsys?
Thanks.

Dave.

[Bitsys]

Ahh, v0id I see what you mean now. I fixed it. Thanks for pointing that out and providing the screenshots, that helped a lot to figure out what the problem was.

A corrected rpgadmin.php file will be included in v55.

[Mijae]

Sorry for my bad english there :P

Anyways, everything else seems to be working 100%.

[Bitsys]

Originally posted by Davey
I didn't understand the postbit instructions whatsoever.
I installed it on a fresh install 2.2.9.
Could you make the instructions a little clearer please, Bitsys?
Thanks.

Dave.

Go to the admin CP. Go to modify templates at the bottom. Click on the link that says "show all" next to the global or default template set. Scroll down until you find a template called "postbit". Click on the "edit" link next to it. It should bring up the html that is used in the postbit tamplate. Copy the code from the file "sample postbit.txt" that came included in the .zip file and paste it after "Posts: $post[posts]" in the edit template field. Click "Save changes" at the bottom to save what you just entered. This will give you the default variables in your posts.

There are additional variables located in Install.txt at the bottom. You add these the same way by copying and pasting whatever comes after the ":" in Install.txt. Example:

In Install.txt:
~Display the user's battle status: $inbattle
Copy:
$inbattle
And paste it into the postbit template as you did before. The "$" in front of the word means that it is a variable. When a post is displayed, "$inbattle" is changed to whatever the value the variable contains. In most instances, "$inbattle" will appear as "Not in Battle" when you view the post on your forums.

Does that help?

[Mijae]

I found another little bug, the Element Icon variable tries to display and image that starts with an upper case (Dark), but the images included are lower case (dark). This makes the images come up with an ugly red X.

This is easy to fix, but I just wanted to point it out.

[Bitsys]

Originally posted by v0id
I found another little bug, the Element Icon variable tries to display and image that starts with an upper case (Dark), but the images included are lower case (dark). This makes the images come up with an ugly red X.

This is easy to fix, but I just wanted to point it out.

Yup, DarkDraco07 pointed that out a little earlier and v55 will fix that bug. A permanent fix is to manually rename the image files.

[Bitsys]

Version 0.55 is completed. There is an upgrade file included to go from version 0.54 to version 0.55.

Bug Fixes:

Personal Itemshop infinite loop bug in getpostbit function fixed.
Personal Itemshop not showing up fixed.
Personal Itemshop images not displaying fixed.
Personal Itemshop unable to delete fixed.
Personal Itemshop unable to edit fixed.
Personal inventory showing up for non logged-in users now doesn't show up.
Battle wager is now taken from your bank account or pocket when you register for a new battle.
Incorrect item images showing in battlefight.php now fixed.
Alignment names displaying improperly in the postbit now fixed.
Element icon names corrected.
You no longer have to make changes to battle.php before uploading.
More minor bugs were fixed.


New features:

"Generic" Itemshop Items can now be expanded all at once, instead of clicking the expand link individually. The expand link is still there.
For those who don't want a user's level based on their posts, you may now give them experience for participating in battle.
You can now adjust how much experience user's get for posts.
New variables available for the postbit template.
When doing a new install, if you run all 3 install files, then you only have to do a few steps in order to jump straight into battle. The steps are: (1)Make a post. (2)Choose a value other than "Unknown" in the user cp and click submit. (3)Update your stats in the user cp. (4)Have another user do the same thing (steps 1-3). (5)Challenge the other user. (6)Join the battle. After doing this, you will want to try buying some items from the itemshop and testing those as well. Make sure you assign the appropriate values in the "Edit category" screen in the admin cp so that the items can be used in battle.
Some other minor aesthetic things.

The original post has been updated to include v55.

I will not be very available for the next 24 hours and I may not respond to your questions very fast. I will respond and help you as soon as I get back. Thanks for understanding.

Once again, thanks for testing!

[mewgood]

cool
I hope the full verson will come out soon;)

[corsacrazy]

all it ever says is :


You are ineligible for battle at this time. Please try updating your stats in the User Control Panel. :cry:


and i have updated a thousand times :(

[Mijae]

Why do I get a download of v53?

[corsacrazy]

^ clear temp internet files and try again ! thats wot i did and it worked 4 me

[VeoMorphine]

i see a hack of the month coming up :)

[Dark Shogun]

I didn't read the whole post yet but I was just wondering if you thought about adding the hotel hack into this.

Dark Shogun

[The_Wanderer]

very impressive... i'll install this when the full version is released.. good job

[Graphics]

kewl i'll reinstall my teszt forum and install 0.55 :D

good hack btw:)

[assassingod]

Installed on 2.2.9, testing battle out now. Receive this error when trying to delete recently added 'type'


Invalid SQL: UPDATE user SET rpgtype='0',rpgclass='0' WHERE type='4'
mysql error: Unknown column 'type' in 'where clause'

mysql error number: 1054

[Bitsys]

corsacrazy:
Did you read https://vborg.vbsupport.ru/showthread.php?postid=328672#post328672 yet?

Originally posted by assassingod
Installed on 2.2.9, testing battle out now. Receive this error when trying to delete recently added 'type'


Invalid SQL: UPDATE user SET rpgtype='0',rpgclass='0' WHERE type='4'
mysql error: Unknown column 'type' in 'where clause'

mysql error number: 1054

Fixed. There are two ways of correcting it. You can download the corrected "rpgadmin.php" file attached to this post and re-upload it to your admin directory, or you can do the following:

In rpgadmin.php, find:
// ###################### deletetype #######################

Below that (6 lines), find:
$DB_site->query("UPDATE user SET rpgtype='0',rpgclass='0' WHERE type='$typeid'");

And replace it with:
$DB_site->query("UPDATE user SET rpgtype='0',rpgclass='0' WHERE rpgtype='$typeid'");

Thanks for finding that one ;). I am surprised someone didn't find it sooner.

Here is the updated file:

[geniuscrew]

I' m getting this error

Fatal error: Maximum execution time of 3 seconds exceeded in /*****/*******/*****/battlefight.php on line 374

Mind you, I have my test vB on a free server [and it's not public]

[corsacrazy]

Originally posted by Bitsys
corsacrazy:
Did you read https://vborg.vbsupport.ru/showthread.php?postid=328672#post328672 yet?

cheers mate i must of missed this somehow :ermm:

[geniuscrew]

Can anyone please tell me how levels and and MA etc, increase, because I start off dead [no HP] so I can't battle

[geniuscrew]

Do mages have to use staffs? I know it sounds stupid but either way, nothing decreases and the only we get is "Use your fists"

[Herman]

My problem is that when in a battle, and my options are listed below, I can ONLY use my fists, request a draw, and retreat.

The other radio buttons for Attacking and such are unusable. Even though I have purchased items in the itemshop! :bunny:

[Herman]

Also, can you please tell me how I get my HP/MP to rise? I have my EXP set, so my level will rise with my post count, but how do I get my HP up and such?

[Bitsys]

geniuscrew:
That error was probably due to a busy server. I have not gotten that error before. If you want to know the exact equations for MP, HP, PP, etc, then see https://vborg.vbsupport.ru/showthread.php?postid=328854#post328854 . Mages do not have to use staffs. If you are only getting "Use your fists" while in battle, then do the following:

Go to the admin CP
Click on "Edit Items"
Next to the weapons category name, click on the "edit" link.
Change the Battle type of the category to One-handed weapons or whatever you see fit. There are several options.
Go back to the battle, after purchasing an item from that category (or if you already had an item from that category, then don't worry about it) and see if it is now usable.


Herman:
Read the above ^^.

Also, make sure you are updating your stats in the USER Control Panel under the Modify Profile screen. You should be doing this after your Alignment, Class, Race etc. has already been set. You must also have at least one post.

I will be able to provide a more detailed explanation of the stats a little later. It is futile to do it now because they keep getting slightly modified.

Let me know if you are still having trouble.

[geniuscrew]

thanks a lot for your help!

I'm guessing "+ Att" is for items only?

Also how can you use an element in battle [i've never had this option so I wouldn't know ;)] and can you specify different levels for the spells and go onto the next level when you reach level X?


Thanks

[Graphics]

hey any idea when there is another update ???

[Bitsys]

genuiscrew:
"+ to Att" means that you want the item to ALWAYS increase the user's attack when they have that item. For example, on the boards I admin, we made all rings give + to att if you had one. Also, we made all necklaces give + to def if you had one. Finally, we made all runes give + to Att AND + to def. Then, we scaled the prices of these items considerably higher than the other items since they were much more valuable based on how they affected your battle statistics.

You cannot use elements in battle. That seems too much like using elemental spells. Instead, elements give you a static boost to your HP, MA, PP, and AP. You can make the boost as large or small as you want in the admin cp.

About the different level for spells: I was toying with an idea last night. I was thinking that I could make each item have a level requirement before you could buy it. This would prevent pooling of money into one low level person just so that they could get the best weapon and kill someone that is a much higher level than them, but poorer. This wouldn't be too hard to implement, and I might be able to get it done today, based on how many bugs people can find. Less bugs = faster implementation.

Graphics:
I will release another update when there are bugs to fix or features to add. Currently, no one has reported another bug since the last update (v0.55b) and I have only added one small feature that isn't worth making people upgrade for quite yet. If I add level requirements today then I will release an update as soon as that is done and tested. Sound good?

[perrera]

Hello,
Indredible hack.... but..
I haved installed succesfully (I hope), but no option to figh was visible.. I turned on in Batlle Option, the option in the Admin, but nothing happens..

Any idea?

[Bitsys]

Originally posted by perrera
Hello,
Indredible hack.... but..
I haved installed succesfully (I hope), but no option to figh was visible.. I turned on in Batlle Option, the option in the Admin, but nothing happens..

Any idea?
Could you explain exactly what steps you took and what exactly you are trying to do?

[Graphics]

i think (this might sound stupid :p)
are you expecting a link to show up in the main forum ???

go to battle.php in your root :)

there you ca battle :D

[perrera]

Originally posted by Graphics
i think (this might sound stupid :p)
are you expecting a link to show up in the main forum ???

go to battle.php in your root :)

there you ca battle :D

Ok... this messages appear:
"You are ineligible for battle at this time. Please try updating your stats in the User Control Panel."

So... how can battle? :bored:

[corsacrazy]

^perrera read here ^

https://vborg.vbsupport.ru/showthread.php?postid=328672#post328672

[perrera]

Do'h.... :lick:
Thanks... :tired:

[jags2ooo]

where is .55 download, did u post it yet? LoL. Also will the punch work?

[jags2ooo]

check out my forum http://forums.dark-anime.net I tested out version .5 it is cool, but lots of bugs, lol

[corsacrazy]

5.5 is located over the original attachment in post #1 ! jap wont work in this version but will hopefully in the next

[jags2ooo]

I get this weird ass error when I try to enter a thread...

Database error in vBulletin 2.2.8:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter,
user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,items_options.pointfield,battle_options.namefi eld,battle_options.usepostcount,battle_options.exp rate,battle_options.levelfield,battle_options.priv acy AS battleprivacy,items_user.*,rpg_race.name AS rpgracename,rpg_race.alignment AS rpgalignmentname,rpg_classf.name AS fclassname,
rpg_classf.folder AS fclassfolder,rpg_classm.name AS mclassname,rpg_classm.folder AS mclassfolder,rpg_element.name AS elename
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post, battle_options, items_options
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN items_user ON items_user.userid=user.userid
LEFT JOIN rpg_classf ON rpg_classf.id=user.rpgclass
LEFT JOIN rpg_classm ON rpg_classm.id=user.rpgclass
LEFT JOIN rpg_element ON rpg_element.elementid=user.element
LEFT JOIN rpg_race ON rpg_race.raceid=user.rpgrace AND rpg_race.alignmentid=user.alignment
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,45,46,47,48)
ORDER BY dateline

mysql error: Unknown column 'battle_options.usepostcount' in 'field list'

mysql error number: 1054

Date: Tuesday 10th of December 2002 05:03:49 PM
Script: http://forums.ani-pro.com/vb/showthread.php?threadid=6
Referer:

I did the upgrade like you said, damn...lol

[Bitsys]

If you did the upgrade, then run this query:

ALTER TABLE `battle_options` ADD `usepostcount` INT(3) DEFAULT '0' NOT NULL;

Seems I missed that one in the upgrade files. Let me know what happens. I will be updating the .zip shortly. Version 0.56 is almost done. I have added some features that people requested.

[jags2ooo]

nope still allot more tables u forgot about, lol.
Ill tell u they are

battle_options.levelfield,battle_options.privacy AS battleprivacy

I think that is it. If you can send me the queries for those, I will be set I am sure.

[jags2ooo]

Actually I just ran this query

ALTER TABLE `battle_options` ADD `levelfield` INT(3) DEFAULT '0' NOT NULL;

and everything is fine, THNX!

[Bitsys]

Originally posted by jags2ooo
Actually I just ran this query

ALTER TABLE `battle_options` ADD `levelfield` INT(3) DEFAULT '0' NOT NULL;

and everything is fine, THNX!

The field 'levelfield' is supposed to be

ALTER TABLE `battle_options` ADD `levelfield` VARCHAR(10) DEFAULT 'field7' NOT NULL;

Also, what version did you upgrade from? 'battle_options.battleprivacy' has been in the install file since the first version. If you don't have that field, then something went wrong in one of the installs.

[jags2ooo]

updated from v54

[Bitsys]

In that case, the install of v54 did not go properly because you are missing fields in the battle_options database that should have been created when the installtion file was run. Did you do a clean install of v54?

[jags2ooo]

yes, i didn't edit it, but tiw works fine now, thnx

[xxskullxx]

I got this running on my test site with no problems at all. Keep up the awesome work, Bitsys :classic:

[geniuscrew]

What category do things like elixir fall in? Because heal for both HP and MP? I believe potions are just for HP...

[Bitsys]

Oh yeah, that is something I forgot to include in the last update. Err, it is included, I just forgot to tell you about it. Here is how it works:

How to make potions replenish HP, MA (MP), or HP and MA:

If the COST of the potion is divisible by 10, then the potion will replenish HP. Examples: 20, 100, 220, 350, 11111111110
If the COST of the potion is divisible by 5, then the potion will replenish MA (MP). Examples: 15, 25, 5555555, 124034535. Things that will not work: 150 (although 150 is divisible by 5, it is divisble by 10 first, and is therefore considered a plus to HP potion.) 110, 117, and 239850.
If the COST of the potion is divisble by 2, then the potion will replenish MA AND HP. Examples: 62, 78, 1239848476. Things that will not work: 310, 55, 17.
If the COST of the potion is an odd number (not divisible by 2), then it does nothing in battle and is considered a dummy potion.


Does that help?

This information will be included in the next version.

[assassingod]

Still using version 0.54, getting this error when trying to a view a thread

Fatal error: Maximum execution time of 30 seconds exceeded in c:\apache\htdocs\testvb\admin\functions.php on line 225

Fatal error: Maximum execution time of 30 seconds exceeded in c:\apache\htdocs\testvb\admin\functions.php on line 2443



Will upgrading to v0.55 sort this out?

[geniuscrew]

Originally posted by Bitsys
Oh yeah, that is something I forgot to include in the last update. Err, it is included, I just forgot to tell you about it. Here is how it works:

How to make potions replenish HP, MA (MP), or HP and MA:

If the COST of the potion is divisible by 10, then the potion will replenish HP. Examples: 20, 100, 220, 350, 11111111110
If the COST of the potion is divisible by 5, then the potion will replenish MA (MP). Examples: 15, 25, 5555555, 124034535. Things that will not work: 150 (although 150 is divisible by 5, it is divisble by 10 first, and is therefore considered a plus to HP potion.) 110, 117, and 239850.
If the COST of the potion is divisble by 2, then the potion will replenish MA AND HP. Examples: 62, 78, 1239848476. Things that will not work: 310, 55, 17.
If the COST of the potion is an odd number (not divisible by 2), then it does nothing in battle and is considered a dummy potion.


Does that help?

This information will be included in the next version.

Thanks - that helps! Sorry I keep bugging you but how do you make a potion replenish ALL your HP and MA? Like the Elixir

[Bitsys]

assassingod:
Yup, 0.55 fixes that "infinite loop in the getpotbit function" bug. A quick fix is to delete all personal itemshop categories in the admin cp, which should be the only reason you are getting that problem.

geniuscrew:
I had not thought of something that refills all of MP and HP before. If you want, I can make it so that all potions that are odd numbered (excluding those divisible by 5) will refill both to the max. Would that work? It would be included in v0.56.

[Graphics]

i have an idea
maybe ther should allready B races etc when you install it so you don't need to ADD them yourselve

or did i install wrong :p

[geniuscrew]

Originally posted by Bitsys
assassingod:
Yup, 0.55 fixes that "infinite loop in the getpotbit function" bug. A quick fix is to delete all personal itemshop categories in the admin cp, which should be the only reason you are getting that problem.

geniuscrew:
I had not thought of something that refills all of MP and HP before. If you want, I can make it so that all potions that are odd numbered (excluding those divisible by 5) will refill both to the max. Would that work? It would be included in v0.56.

That would be cool - thanks.

Have you thought of status effects? [for a future version maybe?]

Graphics
There are two races installed if you run the scripts which install, the classes and elements etc.

Good - Human
Evil - Orc

Hope that helps

[Kaelon]

This looks like an amazing hack. Excellent work!

I run a very large play-by-post role playing game, and I'd love to integrate this feature once it's left beta.

Thanks for your hard work!

Kaelon

[Bitsys]

graphics:
geniuscrew is correct. If you ran the "install_rpg_stuff.php" file AFTER running the other two install files, then you should have been ready to go. This ONLY applies to version 0.55. Version 0.54 and below did not do this.

[geniuscrew]

Bitsys do u have AIM/MSN?

How do you revive yourself if you die?

[Bitsys]

In the current version, you must gain a level and update your stats. They will be automatically refilled. In the future, it will not be so easy. I am thinking of making you pay or do something else in order to revive yourself. Unless, of course, everyone wants their stats to go back up directly after battle, which is certainly possible (and easy) to do.

Any suggestions/ideas?

[JaZz0r]

I receive an error when checking/updating stats. I have v55 and this was freshly installed:

Invalid SQL: SELECT field7 FROM userfield WHERE userid='1'
mysql error: Unknown column 'field7' in 'field list'

mysql error number: 1054

Date: Wednesday 11th of December 2002 10:23:53 AM
Script: http://XXXXX/update.php?action=doupdate
Referer: http://XXXXX/member.php?action=editprofile

Edit: Changed my options from "Give experience to users for participating in battles..." (was turned on) to the post count option (was turned off). This fixed my error.

[JaZz0r]

Also, it seems that I am unable to use any weapons I've purchased. I bought a weapon, updated my stats, went into battle, and still my only 3 options are Use Fists, Request Draw, and Retreat.

One more thing: Using ' in the battle name makes MySQL go nuts.

[Dark Shogun]

Can a admin hype themselves up? (aka Cheat)

Dark Shogun

[corsacrazy]

Originally posted by JaZz0r
Also, it seems that I am unable to use any weapons I've purchased. I bought a weapon, updated my stats, went into battle, and still my only 3 options are Use Fists, Request Draw, and Retreat.

One more thing: Using ' in the battle name makes MySQL go nuts.


using weapons is explained here (https://vborg.vbsupport.ru/showthread.php?postid=329014#post329014)

[Bitsys]

Originally posted by Dark Shogun
Can a admin hype themselves up? (aka Cheat)

Dark Shogun

Admins can give themselves as much HP, MA, and PP as they want. They can also give themseleves as much money as they want. So, in that sense, admins can cheat.

[geniuscrew]

Originally posted by Bitsys
In the current version, you must gain a level and update your stats. They will be automatically refilled. In the future, it will not be so easy. I am thinking of making you pay or do something else in order to revive yourself. Unless, of course, everyone wants their stats to go back up directly after battle, which is certainly possible (and easy) to do.

Any suggestions/ideas?

I have one -


Can you possibly make a separate kind of item type which has Reviving Spells/Items - such as Phoenix Down?

You would then be able to use this spell/Item to revive your character.

But for full replenishing, you could integrate the Inn/Hotel hack - in fact I'm sure one of the battle templates had "Hotel" for a heading :/

Probably a long shot, but hey, you asked for ideas ;)

[Mystic Gohan]

can you make a un-install script and pm it to me or e-mail it or post it even. I kinda installed it on my realy board. If you dont want too I can fix my board no problem but yea.

[geniuscrew]

Is there any use for the non battle items Bitsys?

[perrera]

I recieved an error when I tried to open a thread... :ermm:

"Fatal error: Maximum execution time of 30 seconds exceeded in /home/--/public_html/vb/admin/functions.php on line 224"

Please help...

[Mrpolish]

I received an error also when i try to post i am attaching it.

my vb version: 2.2.8

[Bitsys]

geniuscrew:
Non-battle items can be used for showing off, I guess.

perrera:
Which version are you using?

Mrpolish:
Did you run "install_itemshop_items.php"?

[perrera]

Originally posted by Bitsys

perrera:
Which version are you using?

RPG hack 55b, and Vbulletin 229

[Bitsys]

Originally posted by perrera

RPG hack 55b, and Vbulletin 229
Do you have any personal itemshops? Did you do an upgrade, or did you do a clean install?

If you have personal itemshops, try deleting them in the admin cp. If you did an upgrade, go look for the modifications that had to be made to showthread.php in upgrade.txt and make sure you did them for each instance of the code in showthread. It is easy to find and replace the first instance, but you may have accidentally missed the second instance.

If you don't have and personal itemshops, and you didn't upgrade, then I will need to know which options you have selected for the itemshop.

[SHoeSTeR]

I installed everything and when I post something this is what comes up:

http://www.mtgshoebox.com/test/showthread.php?threadid=2

[Bitsys]

Originally posted by SHoeSTeR
I installed everything and when I post something this is what comes up:

http://www.mtgshoebox.com/test/showthread.php?threadid=2

Did you have any errors during the installation using vbhacker?

[SHoeSTeR]

I didn't use vbhacker, I will this time, does vbhacker install all the templates for me etc.. ?

[Bitsys]

Originally posted by SHoeSTeR
I didn't use vbhacker, I will this time, does vbhacker install all the templates for me etc.. ?

vbHacker does everything except populate the databases with the default items/rpg stuff. It does the file edits, the template additions, the template edits, and the database queries. Just follow the instructions in the install.txt file included in the .zip package and you should be fine.

[VeoMorphine]

Hey, It all installed great the only problem im having is that when sompone has a weapon it still considers the person to not have a weapon and makes them use there fist in battle.

i try ed difrent weapons, and updated rpg stats. I also tryed reloading the items data, and that dint work.

my board is at http://www.ugnet.net/forums/

[corsacrazy]

VeoMorphine read here to use weapons

https://vborg.vbsupport.ru/showthread.php?postid=329014#post329014

[VeoMorphine]

Thank you COrsacrazy, I also found another pretty big problem.

User can steal points from each other by putting a negative number of points in the points feild.

I think i may have a fix for this though. Gimme a few minutes and ill confirm this.

[corsacrazy]

^ lol if thats tru

[Bitsys]

Originally posted by VeoMorphine
Thank you COrsacrazy, I also found another pretty big problem.

User can steal points from each other by putting a negative number of points in the points feild.

I think i may have a fix for this though. Gimme a few minutes and ill confirm this.

Yes, that has been a known bug since the original itemshop. I am adding a fix in v0.56.

[perrera]

Originally posted by Bitsys

Do you have any personal itemshops? Did you do an upgrade, or did you do a clean install?

If you have personal itemshops, try deleting them in the admin cp. If you did an upgrade, go look for the modifications that had to be made to showthread.php in upgrade.txt and make sure you did them for each instance of the code in showthread. It is easy to find and replace the first instance, but you may have accidentally missed the second instance.

If you don't have and personal itemshops, and you didn't upgrade, then I will need to know which options you have selected for the itemshop.
Ok.. I did a clean reinstall an the problem was solved.. BTW when i tried to create a thread:

Database error in vBulletin 2.2.9:


Invalid SQL: SELECT FROM userfield WHERE userid=1
mysql error: You have an error in your SQL syntax near 'FROM userfield WHERE userid=1' at line 1


mysql error number: 1064

:dead:

[Mrpolish]

When i install it on vb 2.2.8 it does not give me any errors but when i try to view posts the page never loads.

[Bitsys]

perrera:
Did you run "install_itemshop_items.php"?

Mrpolish:
How many itemshop categories do you have?

[Mrpolish]

Oka i fixed the post problem and everything is fine now and you are able to post but each time when i post my exp is on 99% and ap on 100%.

[geniuscrew]

Just a little tip

It's a hell of a lot easier to use vBhacker, when installing for the first time.

If upgrading, replace the modified files, then install the new version using vBhacker again!

It's not as time consuming as you think - Takes about 5 minutes!

On my board it's working beautifully :)

[Graphics]

I had some problems with my mods refilling their HP/PP etc. They'd click the link, and see the url and change the last number to a higher number, and it'd turn out to be 999/32 HP etc...
Also, you can donate a negative number, which takes the money away from the person your donating to and gives it to you

[VeoMorphine]

ok, i got a fix done for the donate bug.
I'm at school right now so sadly i cannot upload it but as soon as i can get home, ill put it up.

Im going to work on a small system that i should put up today also that will allow mods and admins to give and take money away from users.

Also may i ask what we might see for the next version?

Also this hack has my vote for hack of the month/year!

[perrera]

Originally posted by Bitsys
perrera:
Did you run "install_itemshop_items.php"?


OK, when I run it...

Invalid SQL: ALTER TABLE items_user
ADD item1 char(250) NOT NULL default 'No Item',
ADD points1 int(5) NOT NULL default '0',
ADD description1 char(250) NOT NULL default 'No Description Available',
ADD icon1 char(250) NOT NULL default '',
ADD itid1 int(11) NOT NULL default '0',
ADD item2 char(250) NOT NULL default 'No Item',
ADD points2 int(5) NOT NULL default '0',
ADD description2 char(250) NOT NULL default 'No Description Available',
ADD icon2 char(250) NOT NULL default '',
ADD itid2 int(11) NOT NULL default '0',
ADD item3 char(250) NOT NULL default 'No Item',
ADD points3 int(5) NOT NULL default '0',
ADD description3 char(250) NOT NULL default 'No Description Available',
ADD icon3 char(250) NOT NULL default '',
ADD itid3 int(11) NOT NULL default '0'
mysql error: Duplicate column name 'item1'

mysql error number: 1060

:(

[VeoMorphine]

perrera
Make sure that table items_user is created, and empty.

And i also have a request. Can you add a function where admins can ajust the ammount of items that are in stock, and be able to refuill them at any time?

[Strider Xero]

Is there any way to make an Element, Alignment, or Class only allowed to be chosen by an Admin/Moderator??

[perrera]

Originally posted by VeoMorphine
perrera
Make sure that table items_user is created, and empty.

Thanks, now is working fine...but, with one detail... the RPG Name is duplicated in the USER PROFILE.. :cry:

[Bitsys]

Graphics:
version 0.56 will fix the "steal money from other users using a negative number in the donate screen" bug.

VeoMorphine (first time):
The next version will include:

Items will have a level associated with them. If you are not a high enough level, then you can't buy the item.
A Healing Center. At the healing center, you can get back HP and MA by spending money.
User's will be able to gain experience based on if they won the battle they were in.

There are a lot of bug fixes and minor additions too.

VeoMorphine (second time):
You want an input box in the admin cp that displays the stock of an item that you can change at will, correct? I think that would be easy to do, I just need clarification.

Strider Xero:
I don't think I will be able to include that in this version. That would involve user group IDs.

perrera:
I have noticed that on most boards, the RPG Name is duplicated. However, on my board it is not. I will look at the install files and see where there is a deviation.

[Strider Xero]

Well hopefully you'll be able to include it in .57 =)

It kinda sucks if a member decides to keep changing elements, alignments, classes, races, etc. So I was wondering if you could include a feature where they'd have to Pay in order to change elements, alignments, classes, races etc. For example:

In order to change Elements, they'd have to pay 200 points or whatever. And to change alignments, they'd have to pay 300. Stupid idea? Yes..no? Well hopefully you'd at least consider the idea.

[Bitsys]

Originally posted by Strider Xero
Well hopefully you'll be able to include it in .57 =)

Also, I was wondering about the Classes. I don't want that little picture showing when a member chooses a Class. Instead I want it to display Text. For example if they choose an archer class, it will display 'Archer'.
From install.txt:
~Display the user's Class name: $rpgclass2
Originally posted by Strider Xero
Oh yeah, one more thing. It kinda sucks if a member decides to keep changing elements, alignments, classes, races, etc. So I was wondering if you could include a feature where they'd have to Pay in order to change elements, alignments, classes, races etc. For example:

In order to change Elements, they'd have to pay 200 points or whatever. And to change alignments, they'd have to pay 300. Stupid idea? Yes..no? Well hopefully you'd at least consider the idea. I am looking into some options like this.

[Davey]

Okay I get this error when making the first thread in a forum:
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT field5 FROM userfield WHERE userid=1
mysql error: Unknown column 'field5' in 'field list'

mysql error number: 1054

Date: Friday 13th of December 2002 06:01:49 PM
Script: http://localhost/rpg/rpg/newthread.php
Referer: http://localhost/rpg/newthread.php?action=newthread&forumid=3
Any ideas?

Dave.

PS: I did this on a clean install of vBulletin 2.2.9.

[VeoMorphine]

Originally posted by Bitsys
Graphics:
version 0.56 will fix the "steal money from other users using a negative number in the donate screen" bug.

VeoMorphine (first time):
The next version will include:

Items will have a level associated with them. If you are not a high enough level, then you can't buy the item.
A Healing Center. At the healing center, you can get back HP and MA by spending money.
User's will be able to gain experience based on if they won the battle they were in.

There are a lot of bug fixes and minor additions too.

VeoMorphine (second time):
You want an input box in the admin cp that displays the stock of an item that you can change at will, correct? I think that would be easy to do, I just need clarification.

Strider Xero:
I don't think I will be able to include that in this version. That would involve user group IDs.

perrera:
I have noticed that on most boards, the RPG Name is duplicated. However, on my board it is not. I will look at the install files and see where there is a deviation.

Yes thats what i think would be great, to be able to ajust the max and current items in stock. I allready modifyed it to do that on my board and its very easy.

And for the healing station in the next version, why not make it like an inn? Restores all stats. Ill help make it once i get home.

with perreras problem. He should just need to delete one of the profile fields, and change the field it uses in the config.

Im also working on a system were mods and admins can take away and give money to users, along with intregrating lusanes store with this.

[Bitsys]

Originally posted by Davey
Okay I get this error when making the first thread in a forum:

Any ideas?

Dave.

PS: I did this on a clean install of vBulletin 2.2.9.

Did you run "install_itemshop_items.php"?

VeoMorphine:
I will add the stock boxes in the next version. Admins can give money to users in the admin control panel.

[VeoMorphine]

yes but, mods cant. Im gona put that in to.

[VeoMorphine]

Use the donate hack attached to this post.
This hack was made by GameZilla, its a really great hack.
Just needs a bit of template work(a VERY little bit)

[Bitsys]

Originally posted by VeoMorphine
Use the donate hack attached to this post.
This hack was made by GameZilla, its a really great hack.
Just needs a bit of template work(a VERY little bit)

Hmm...how does this hack add anything extra that is not already included in my hack?

[geniuscrew]

Originally posted by Bitsys

The next version will include:

User's will be able to gain experience based on if they won the battle they were in.




;)

[VeoMorphine]

Originally posted by Bitsys


Hmm...how does this hack add anything extra that is not already included in my hack?

just fixed the donate -negitive points bug.

[VeoMorphine]

another request:

Could you put a feild were we can chose the cost of mana a spell takes? B/c i really dont get how to ajust that. they all take one mana for me right now.

And is there a way to make admin only classes/races? I would think you could do somthing like add a collum to admin in the classes/races and if its marked one it would only be accsesable to admins.

[Bitsys]

Version 0.56 fixes the negative donate bug.

Being able to choose the amount of mana a spell takes would add an extra field to the database table. I am not too keen on doing that at this point. There will be an updated mana cost equation in a future version based on the spell's level.

Again, making only certain classes/races would add another field to the database table. It would also mean I would have to modify member.php to check and see whether or not a user can use a particular class/race. I feel that the time spent doing this does not warrant its addition right now. I might do it later, but it is not feasible at this time.

[SHoeSTeR]

Battle Arena
Proccesing battle

You are ineligible for battle at this time. Please try updating your stats in the User Control Panel.

I get this error when challenging someone, and I filled in all the fields, hit submit then update stats.

[VeoMorphine]

ya but no matter what i do all my spells are going to use the same mana, basicly eliminating the use for them, unless you can tell me ho to make them use more...

[rrnolan]

I just installed this on my VB 2.6 site the install went without a hitch. This seems like an impressive hack.. Great work.. I have never played this game before and I want to test to see if it works with 2.6.

Bitsy or someone that is experienced if you can give me a and setting up classes and such we could test this out.

Does someone know where I can get detailed instructions for setting up classes, allignments etc. The Readme is kind of lite on detail

My MSN messenger is rrnolan100@hotmail.com
or ICQ 129048868
My Site http://www.digigames2.biz

Thanks a lot

:banana:

[VeoMorphine]

Big bug:

You can press the back button and redo a move and it still counts as a valid move..
So basicly, you can attack like 100 times if the person is afk, and kill him there.

[geniuscrew]

Originally posted by VeoMorphine
another request:

Could you put a feild were we can chose the cost of mana a spell takes? B/c i really dont get how to ajust that. they all take one mana for me right now.


One?! Mine take 30!

rrnolan:

There are 2 files in the admin folder included in the zip:

install_rpg_[something or other].php [It's NOT the integration one - I renamed mine so I don't know what it's called lol]

and

install_itemshop_items.php

Run them both and you should be set :)

[rrnolan]

Originally posted by geniuscrew


rrnolan:

There are 2 files in the admin folder included in the zip:

install_rpg_[something or other].php [It's NOT the integration one - I renamed mine so I don't know what it's called lol]

and

install_itemshop_items.php

Run them both and you should be set :)

Ok I see install

install_itemshop_items.php
install_rpg_integration.hack.php
install_rpg_stuff.php

When I did the hacker install it ran itemshop_items at the end. So I see all the items. I don't see any elements, or Character types
that type of thing. Does install_rpg_stuff.php install all that?

[Bitsys]

SHoeSTeR:
Did you read https://vborg.vbsupport.ru/showthread.php?postid=328672#post328672 yet?

VeoMorphine (first time):
You can manually edit the formula. The current formula is meant for characters above level 5. Like I said though, it will be changing in v0.56.

(second time):
That bug is now fixed. The updated file will be included in v0.56. Thanks.

rrnolan:
Yup, install_rpg_stuff.php installs all the RPG stuff you need to get going. However, if you have already added anything to the RPG via the admin cp, then this file won't work.

[geniuscrew]

Yup - run that and you get everything ;)

[rrnolan]

Is there a way to give myself and one other points and money so I can test this on vb2.6 Everytime I challange someone on my site it tells me they are not able to do battle. I setup a dummy account but there is no money or points for it so Im guessing that is why we cant fight

[Bitsys]

Originally posted by rrnolan
Is there a way to give myself and one other points and money so I can test this on vb2.6 Everytime I challange someone on my site it tells me they are not able to do battle. I setup a dummy account but there is no money or points for it so Im guessing that is why we cant fight

If you set the wager to 0, then money does not matter. However, make sure you have read https://vborg.vbsupport.ru/show...8672#post328672 to see other reasons why you could be getting that error.

[rrnolan]

Bitsy I think it is working fine, except for this error.
I looked in the Userfield table and there is no field6 just field1 - field9 with no 6 in there. What should I do?

Here is the error

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT field6 FROM userfield WHERE userid='277'
mysql error: Unknown column 'field6' in 'field list'

mysql error number: 1054

Date: Friday 13th of December 2002 06:20:25 PM
Script: http://www.digigames2.biz/forums/forums/battleupdate.php?action=battlereply&battlenumber=1&username=ron&userid=277&battlekey=hi
Referer: http://www.digigames2.biz/forums/battlefight.php?action=enterbattle&battlenumber=1&battlekey=hi

[rrnolan]

Char250 type and now the game seems to be working.

When I go to play I see radio buttons and the only ones that are not grayed out are

User your fists
Request a draw
Retreat

Im guessing the way you play is you hit submit with Use you fists selected. I have done that 3 times. Each time I get

ron tried to use his fists. Everyone knows that this is stupid. ron feels ashamed and cowers in his stupidity. ron[imported] rolls his eyes and gets ready for his turn.

Then its the next persons turn. The picture with the two little dudes does not change is that supposed to change?

[Bitsys]

Originally posted by rrnolan
Char250 type and now the game seems to be working.

When I go to play I see radio buttons and the only ones that are not grayed out are

User your fists
Request a draw
Retreat

Im guessing the way you play is you hit submit with Use you fists selected. I have done that 3 times. Each time I get

ron tried to use his fists. Everyone knows that this is stupid. ron feels ashamed and cowers in his stupidity. ron[imported] rolls his eyes and gets ready for his turn.

Then its the next persons turn. The picture with the two little dudes does not change is that supposed to change?

Have you read https://vborg.vbsupport.ru/showthread.php?postid=329575#post329575 yet?

The pictures do not change.

[rrnolan]

Everything Seems To Be Working on VB2.6 The fields got messed up not sure if something there when wrong on setup. The Install required me to do some manual changes. You may want to clarrify that there are to areas that are the same in showthread, when I had to make the manual change it took me an hour to figure out which section the top or the bottom.


I am finding one error so far if I go to the view games and none are in progress, and I press Update Games this error is returned

Warning: Variable passed to each() is not an array or object in D:\digigames2.biz\forums\admin\battleadmin.php on line 23

I am still testing so I will keep you posted.

Bitsy if you want to create an account on my site I will set you up as an admin so you can test out the 2.6 install. http://www.digigames2.biz you will see on the main page a link to battle fourms on the left menus

When you do a fist fight I went back and forth 6 times and never was any damge done to either player. Is that supposed to work that way?

[Bitsys]

Originally posted by rrnolan
Everything Seems To Be Working on VB2.6 The fields got messed up not sure if something there when wrong on setup. The Install required me to do some manual changes. You may want to clarrify that there are to areas that are the same in showthread, when I had to make the manual change it took me an hour to figure out which section the top or the bottom.

Step #11 in the install file states that if there were any errors in showthread.php, then you must find ALL instances of the code that needs to be replaced, not just the first or the last. I will work on clarifying it.
Originally posted by rrnolan

I am finding one error so far if I go to the view games and none are in progress, and I press Update Games this error is returned

Warning: Variable passed to each() is not an array or object in D:\digigames2.biz\forums\admin\battleadmin.php on line 23

I am still testing so I will keep you posted.
Well, I didn't think anyone would want to update it if there weren't any games. The error doesn't do anything harmful.
Originally posted by rrnolan
Bitsy if you want to create an account on my site I will set you up as an admin so you can test out the 2.6 install. http://www.digigames2.biz you will see on the main page a link to battle fourms on the left menus

When you do a fist fight I went back and forth 6 times and never was any damge done to either player. Is that supposed to work that way?
Currently, fists don't do any damage. That will probably change in the future. In the meantime, fists are there so that you will always have a move to make, even when you don't have any weapons or spells or potions etc...

[rrnolan]

Bitsy Thank You So Much for all the help, I think you can show vb2.6 as working with your hack everything is then working the way it is supposed to from what I see.

One last question, is there a player ranking screen that I can link for my users, one that would show based on battles etc who is in 1st place 2nd 3rd 4th etc. So that players know where they stand vs other players.

Take a look at my postbit hack
http://www.digigames2.biz/forums/showthread.php?s=&threadid=1328

[Bitsys]

I had several ideas about doing a battle statistics page. I will think about adding it after I release version 0.56. Version 0.56 is taking a while because of all the new features.

[VeoMorphine]

OK, On my Lusanes Store Intregration, its alot easyer for me to just Port the RPG hack over, to use the Store points system, so ill release the first verson of that once 0.56 is out.

And bitsys, i must say this is truly the best hack i've seen for vb, and ide nomanate/vote for this for hack of the year/month anyday.

[geniuscrew]

Originally posted by VeoMorphine
OK, On my Lusanes Store Intregration, its alot easyer for me to just Port the RPG hack over, to use the Store points system, so ill release the first verson of that once 0.56 is out.

And bitsys, i must say this is truly the best hack i've seen for vb, and ide nomanate/vote for this for hack of the year/month anyday.

Can't you just change the Point field to the store's point field and enter "0" for Activity Points?

[Strider Xero]

Hmm its weird but the HP, MA and PP aren't moving at all...they stay at '0/0'. AP and EXP are okay though. Why is this? I've chosen an element, alignment, race and class but still nothing..its weird.

[geniuscrew]

Have you updated stats in your user CP?

[Strider Xero]

Yep, just updated and still the same. I even tried to refill them by clicking the links...seems only the AP refills, nothing else.

[VeoMorphine]

Originally posted by geniuscrew


Can't you just change the Point field to the store's point field and enter "0" for Activity Points?

The store points are kept inside the user table while the itemshop is in the userfeild table.

[perrera]

How the HP increase?

[mli]

I was bound to get an error and I did.

Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter,
user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,items_options.pointfield,battle_options.namefi eld,battle_options.usepostcount,battle_options.exp rate,battle_options.levelfield,battle_options.priv acy AS battleprivacy,items_user.*,rpg_race.name AS rpgracename,rpg_race.alignment AS rpgalignmentname,rpg_classf.name AS fclassname,
rpg_classf.folder AS fclassfolder,rpg_classm.name AS mclassname,rpg_classm.folder AS mclassfolder,rpg_element.name AS elename
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post, battle_options, items_options
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN items_user ON items_user.userid=user.userid
LEFT JOIN rpg_classf ON rpg_classf.id=user.rpgclass
LEFT JOIN rpg_classm ON rpg_classm.id=user.rpgclass
LEFT JOIN rpg_element ON rpg_element.elementid=user.element
LEFT JOIN rpg_race ON rpg_race.raceid=user.rpgrace AND rpg_race.alignmentid=user.alignment
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,2890)
ORDER BY dateline

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

mysql error number: 1054

Date: Sunday 15th of December 2002 12:04:50 PM
Script: http://rkr.ravencommunity.net/forums/forums/showthread.php?threadid=207
Referer: http://rkr.ravencommunity.net/forums/forumdisplay.php?forumid=5

I get this everytime I open up a thread. WHAT THE HELL IS user.ma??? IT says it can't find it or something.

[jags2ooo]

This is weird, the weapons and accessories do not have anything set under the [damage/deff/buff/] area, it has everything else but that, can anyone send a screenshot of what should properlly be there. Please! Also when is 56 comin, CANT WAIT FOR FULL HAHA

[jags2ooo]

2 request, I think there should be in stats, a show of wins/loses and also the ability to carry up to 6 items per player. that would be sweet for .56

[jags2ooo]

Imma admin, can I raise my own HP, or is that not possible...

[geniuscrew]

Originally posted by jags2ooo
2 request, I think there should be in stats, a show of wins/loses and also the ability to carry up to 6 items per player. that would be sweet for .56

I get ya Veo :)

jags:

You can I think, but as you know, you can have only 1 item from each category. So create more categories - then you will be able to carry more things :)

For example split the mana from the HP pots, etc.

I currently have 5 categories

[VeoMorphine]

ok, for some reasen i get a VB error when a user registers. they register fine, but that error is REALLY anoying. It doesnt give any information, it just gives the same error as if the forums wernt connecting to the db, and asks you to contact the tech team.

Do you get an error?

[geniuscrew]

Mine work perfect :-/

Thanks for joining my forums btw :) - [they aren't the ones I have the RPG hack installed on though ;)]

[VeoMorphine]

No problem ^^

I might just rehack the board on new forums.

[Bitsys]

Strider Xero:
Have you made posts on the forum yet? Your HP, MA, etc is based on post count as well as your activity on the forums and your element.

pererra:
See above ^^

mli:
Your user database did not get the appropriate fields added during installation. Did you get any errors when you installed with vbHacker?

jags2ooo:
Are you referring to the admin cp or itemshop.php?

I am working on adding a battle stats database to list the current top battlers etc.

You cannot raise your own HP to extraordinarily high levels anywhere on the board or admin cp. However, you can use phpmyadmin to raise your stats.

VeoMorphine:
Could you post the error message? Or is it the generic message that doesn't show the failed query?

[VeoMorphine]

no query message in that error, just the ganeric one.
Its a database error, not a file error....

And i dont think its in register.php since i even tryed reverting it back and it was fine.

[Bitsys]

Open up the hacked version of register.php and find:

$userid=$DB_site->insert_id();
$DB_site->query("INSERT INTO items_user (userid) VALUES ($userid)");


If it doesn't look exactly like that, then change it to look like that. If it does look like that, then go to the table `items_user` in phpmyadmin and make sure it has a field called 'userid'.

[jags2ooo]

Also A Good Idea would be to have Fighter Clans, and something in the postbit : Member of : The Ki Clan for example...

[mli]

Originally posted by Bitsys

mli:
Your user database did not get the appropriate fields added during installation. Did you get any errors when you installed with vbHacker?

Yes, some of the queries did not work. But then I ran the queries manually. So it should work out right. What queries do I need to run to fix that error?

[Strider Xero]

bitys, yes i have made posts on the forum. still only the AP and EXP are have gone up...the others stay at 0/0 with the bars not moving...and yes i have set the elements straight and everything.

[jags2ooo]

Originally posted by geniuscrew


I get ya Veo :)

jags:

You can I think, but as you know, you can have only 1 item from each category. So create more categories - then you will be able to carry more things :)

For example split the mana from the HP pots, etc.

I currently have 5 categories

Although I now have more categories, how can I use them, it only shows the originals, and that sucks.

[jags2ooo]

If you don't understand, I went too the item types and added categories such ass 2 handed and onehanded and changed the battle type too fit the category and still does not show, what is up?

[jags2ooo]

Are all battle types suppose to change to current even after u change it to something else?

[Mrpolish]

I get an error when I try to do something in battle

Invalid SQL: SELECT field6 FROM userfield WHERE userid='1'
mysql error: Unknown column 'field6' in 'field list'

mysql error number: 1054
vb ver:2.2.8

[Bitsys]

mli:
You need to add several fields to your `user` table. I am not sure which part of the query failed or why it failed. Can you tell me the name of the last field in your `user` table?

Strider Xero:
What battle options do you have enabled (set to 'Yes')?

jags2ooo:
Make sure that you added the new categories to a default item type. In the admin cp, go to "Edit Item Type" and make sure the categories are associated with an item type.

Yes, it is supposed to say "current" even after you have changed it. This is to reduce queries.

Mrpolish:
What battle options do you have enabled (set to 'Yes')?

[mli]

Ok, I decided to install ALL OVER AGAIN!!! And everything works alright so far, but when I attack my opponent in battle it gives me this error:
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT field6 FROM userfield WHERE userid='1'
mysql error: Unknown column 'field6' in 'field list'

mysql error number: 1054

Date: Monday 16th of December 2002 04:45:42 PM
Script: http://rkr.ravencommunity.net/forums/forums/battleupdate.php?action=battlereply&battlenumber=1&username=mli&userid=1&battlekey=yay
Referer: http://www.rkr.ravencommunity.net/forums/battlefight.php?action=enterbattle

[Mrpolish]

Yes
1.Battle hack is on
2.Give exp to users
3.Do you want a user's power level calculated by and based on their post count?
A user's power level determines ALL of their stats for the battle hack.
No.
Battles are private

[Bitsys]

mli and Mrpolish:
Did you run "install_itemshop_items.php"?

[Mrpolish]

I did

[mli]

lol, we're getting the same error jsut noticed that. Sorry for my post I guess. Here are my options:

RPG Name Field: field6
Battle hack: ON
Max # of battles: 0
Battles are Private: No
Post Battle Results: Yes

Power Level determined by post count: Yes
Power Level Modifier: 3
User's Level Field: field7

Give expierence to user for battles: No

[mli]

Yup, I did

[mli]

Does it have something to do with the RPG Character's name? Since it complains about field6?

[jags2ooo]

It says Generic, not default, and generic is the only type should there be more?

[mli]

Mrpolish try this:

1. Go to your admin panel
2. Go to modify user profile fields
3. Find the RPG Name profile field
4. Right click over the edit link and go to copy shortcut
6. Copy it in your browser
7. Near the end there will be a number. Remember that number
8. Go to edit the battle options
9. In the top option put in field# and replace number with the number you recorded in step 7.

It worked for me :banana:

[Bitsys]

jags2ooo:
Did you add items to the new categories?

[Strider Xero]

Bitsys, my Battle Hack is 'on' also....my settings are the exact same as MLI's..

[Mrpolish]

I get an error when i trz to replz to a post

Invalid SQL: SELECT field5 FROM userfield WHERE userid=1
mysql error: Unknown column 'field5' in 'field list'

mysql error number: 1054

[jags2ooo]

Yes I added the items to the new categories, it is all set up, but it still never shows up, contact me on AIM Bitsy at anipro69.

[jags2ooo]

fixed it

[VeoMorphine]

OK, i fixed the register bug.

Some how, for some un-known reasen the install script was trying to put a userid in the itemshop_user in that was allready there. So i replaced:

$DB_site->query("INSERT INTO items_user (userid) VALUES ($userid)");

With the user update code from the install_itemsho_items.php and it works great now.

[mli]

Originally posted by Mrpolish
I get an error when i trz to replz to a post

Invalid SQL: SELECT field5 FROM userfield WHERE userid=1
mysql error: Unknown column 'field5' in 'field list'

mysql error number: 1054
That's from the itemsop hack. GOOD LUCK WITH THAT!!! I hate the itemshop hack because of that. In the admin panel it asks you want userfield you want the money to be stored in. The only problem is that it has to be a field from 1-9!!! And everytime you create a field a number is wasted. So if you have 5 new fields and you used to have 10 others but you deleted them you'll have to put field15 in the itemshop part of the admin panel. But that won't WORK! Well mine works :glasses:

[jags2ooo]

Hey I was wondering, can I restock items mannuelly or do I have to wait till they do automatically?

[VeoMorphine]

Originally posted by mli

That's from the itemsop hack. GOOD LUCK WITH THAT!!! I hate the itemshop hack because of that. In the admin panel it asks you want userfield you want the money to be stored in. The only problem is that it has to be a field from 1-9!!! And everytime you create a field a number is wasted. So if you have 5 new fields and you used to have 10 others but you deleted them you'll have to put field15 in the itemshop part of the admin panel. But that won't WORK! Well mine works :glasses:

why not just do it through mysql?