I am very close to releasing a final version, which I would suggest waiting for. However, if you still cannot wait for it, then at least wait for the next update, which I should be releasing tonight. I am providing upgrade instructions, though.

Bitsys, I upgraded to v.59, and users are complaing that there stats isn't changing? And It isn't.. it has been the same since I upgraded..

Also Bitsys, it sounds like when you realse the final version there won't be no upgrade? If there is no upgrade then can you please make a uninstall file for us all? I want to uninstall the old version, remove all the files, do a fresh install.. If you can do that, that will be great!!

AViO 07
he is typing the post for the next version right now. btw just because its a final version doesnt mean there wont be updates. there will always be bugs waiting to be squashed in every hack

I didn't say there won't be updates, I said, it sounds like he won't have an upgrade -_- that means, we won't be able to upgrade from beta to final.. anywayz He is realsing the final version, or still beta?

Version 0.60 is done. Upgrade instructions are included (no script this time). Re-download the .zip file from the first post to get the new version (upgrade instructions are in the "upgrade" directory). NOTE ABOUT UPGRADING: This upgrade is VERY tricky. Parts of it you may or may not have to do, depending on which fixes you already applied - the upgrade will tell you which ones you need to look out for. Please pay attention. Most of the upgrading is doing "REPLACE"s, but there is ONE "ADD BEFORE", so pay attention. Also, there is one file edit where you must "FIND" and "REPLACE" the same thing twice in the same file (showthread.php). Please pay attention!

Bug Fixes:

• Fixed battle confirmation PM broken link.
• Fixed battle anger giving plus to MA instead of plus to AP.
• Fixed incorrect alt text for genders
• Other minor bugs

New feature:
In the Itemshop Options menu, there is now a yes or no radio button that you can use to select whether or not you want to use Lesane's Store hack for the points/money system of the RPG.

If you select "No":

• User's RPG money will be stored in the Itemshop Bank and a custom user profile field. The amount in their bank account is referred to as their bank money. The amount in their profile field is referred to as thei money-in-pocket or cash. The total amount in their bank account and pocket determines their total money for the RPG.
• You can display the amount of money in the user's bank account, pocket, and total amount in the postbit using the standard variables listed in install.txt and the help documentation.
• All other aspects of the Itemshop and money system will remain the same as before.

If you select "Yes":

• The Itemshop bank will no longer work.
• The Mass Points function in the admin cp will no longer work.
• The Moderator add/subtract points/bank add-on will no longer work.
• Itemshop Activity points will no longer work (the Store Hack has a MUCH more useful feature for doing this)
• The "Donate" link in the postbit should still work.
• Battle wagers, itemshop purchases, healing, donations, and anything else that has to do with money will be handled through the Store Hack's money system. The Store Hack utilizes a field in the `user` table called 'storep' to store the amount of money a user has for the store.
• You can edit the amount of money a user has in the Store Hack in the "Edit Users" link under the "RPG" heading in the admin cp. This field takes the place of the "Cash" and "Bank" fields that were there previously.

Also, just because some of those features won't work, that doesn't mean you should get php/mysql error messages. You may, however, get some messages I put in there saying what will or will not work.

In the Itemshop Options menu, if you select to use the Store Hack's monetary system yet you do not have the Store Hack installed, then you will get an error.

NOTE: I have never installed Lesane's Store Hack and my Hack on the same board at the same time. The way I tested this hack was that I added a new field in the `user` table called 'storep'. Then, I tested it from there. It is possible that there are file edits that may conflict with one another. This is a small chance, but it is there. I will be doing more testing in the future, but as of right now, I do not think installing both of them will break anything. As always, however, install on a production board at your own risk.

Member Profile Add-on
Re-apply the add-on. Just delete the old code you inserted and re-insert the new code from the .zip file.

Fresh Install
For those of you who are still installing each version on a new test board, please re-read the install file. It has changed quite drastically as well. There are several steps taken out.

As always, post bug reports or any errors you are having so that I can fix them :)

I just upgraded and so far its going good, but I noticed the "Not in Battle" is not a link anymore? Did you remove it or did I mess something on my board?

It won't be a link if:

1. You are in battle. Since you are in battle, you can't battle anyone else and therefore there shouldn't be a link.
2. The post is your post. Since you can't battle yourself, it doesn't make sense to have a link in your post to battle yourself. So, there won't be a link.

If one of the above is not true and it still isn't giving you a link, then let me know.

Oh ok, I didnt know that. I was in battle, thats why it didnt show up. Still working good over here :D

Cool, i am going to install this hack today, its superb! Good job Bitsys :)

Cool bytsis im gonna install it right away

I get an error


When i wanna go to the battle screen

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT ma, hp, pp, ap, maxma, maxhp, maxpp, posts, userid, username, inbattle, alignment, rpgrace, rpggender, element, alignment, rpgclass, rpgtype, xp FROM user WHERE userid='2' OR userid='1' ORDER BY userid ASC
mysql error: Champ 'xp' inconnu dans field list

mysql error number: 1054

Date: Sunday 12th of January 2003 03:37:35 PM
Script: http://localhost/forums1/forums1/bat...battlenumber=1
Referer: http://localhost/forums1/battlefight...attlekey=01515


Another error when i am trying to show a thread

Database error in vBulletin 2.2.6:

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,items_options.lesanestore ,battle_options.namefield,battle_options.usepostco unt,battle_options.exprate,battle_options.levelfie ld,battle_options.privacy AS battleprivacy,items_user.*,battle_stats.*,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 battle_stats ON battle_stats.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,740,741,742,744,747,750,752,754,760)
ORDER BY dateline

mysql error: Champ 'items_options.lesanestore' inconnu dans field list

mysql error number: 1054

Date: Sunday 12th of January 2003 03:46:45 PM
Script: http://localhost/forums1/forums1/sho...id=760#post760
Referer: http://localhost/forums1/index.php?

Please can you make an simple uninstall i really need one :disappointed:



something there is wrong or like that




FORGET IT :smoke: i unedited everything :lick:

(Note to myself ALWAYS BACKUP when installing a big hack)

When i go to showthread:

mysql error: Not unique table/alias: 'icon'

It's better to uninstall it saint cuz i got lot of mysql errors as well

just have an backup or the old version then un edit everything

LOL, if i just made a back up ;)

But I partially uninstalled it, yeah. I am trying to install it on 2.2.9 test board to see how it goes. If it goes well iw ill just install a new board and screw all the posts, i want battles ;)

PSI|Dr-X:
It looks like you didn't run the necessary queries. Do you have phpmyadmin? It looks like the 'xp' field is missing from your `user` table. Also, you are missing the 'lesanestore' field from the `items_options` table. These two fields have the following properties:

xp int(11) not null default '0'

lesanestore tinyint(3) not null default '0'

saint_seiya:
Can you post the full error message?

=/ Hold on

Bytsis

is

xp int(11) not null default '0'

suppose to come in the new version cuz else
you didint type in it only lesane's (but that one was over cuz i had run that querie on the wrong database :P)

It was in the upgrade script going from version 0.58 to 0.59.

i think i didint upgrade :d

I think that may have been the problem.

Hi, I installed the latest version of you hack and I have some problems.[list=1][*]The scoreboard is acting wierd, when someone wins a battle it shows up on the scoreboard as lost, and when someone lost a battle it shows up as won.[*]I set minimum levels for items in the itemshop, but it's not working correctly. I have items for level 1 and level 2. If I am a level 2 character, the link for buying the items is showing up correctly, but when I try to buy a level 2 item it's just refreshing the page, not buying the item. But I can buy a level 1 item. Same as I am level 3, I can buy level 1 and 2 items, but level 3 items are not working.[*]The bank is not working, when I click the bank it's refreshing the page and nothing more.[*]users are gaining a massive amount of extra hp when leveling up. A level 1 character had about 35 hp and a level 2 character about 125.[/list=1]

I hope you can help me with these problems. Thanks in advance.

Bitsy, I am the forum admin for my site and because of the number of posts i have my hit power is 3300, how can I turn my hit power down? Everytime I fight someone I kill them with one hit.

Also is there a way to cap my hitting power

this is how you determine your attack
so just lower the classes attack or the races regular attack and you'll do less

Issy_X:
1. Thanks for finding that one. It will be fixed in the next version.
2. That bug has been reported and will be fixed in the next version.
3. In the Itemshop Options menu, did you choose to use Lesane's Store hack for money/points? If not, what are your itemshop options set to?
4. Still looking in to that one.

rrnolan:
Open battleupdate.php, find:
After, it, add:
Replace X with the amount you don't want it to go over, and replace Y with the amount you want it to be if it goes over. If you only want it to apply to you, then add the following instead:
Replace Z with your userid and X/Y with the previous values as mentioned above.

I am still working on the formulas some more.

There's an error when using vbhacker...the changes made to showthread.php make it so that all user's info that is displayed in the postbit shows them as "guest", having no registration date, and having no post count, yet their other profile fields remain intact, and they really don't have guest status (ex. viewing their profile shows the correct info)

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,items_options.lesanes tore,battle_options.namefield,battle_options.expra te,battle_options.privacy AS battleprivacy,items_user.*,battle_stats.*,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
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 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,29283,29287,29303,29305,29306,29307,29314,29316 )
ORDER BY dateline

mysql error: Unknown table 'items_options' in field list

mysql error number: 1109

Date: Sunday 12th of January 2003 07:02:36 PM
Script: http://www.vgcity.com/forum/forum/sh...?threadid=1147
Referer:

Some of the necessary file edits were not done during the vbhacker part of the installation. Did you get any errors during the install using vbhacker? Also, read below on how to make sure all of the file edits were done.

SpyGuy007:
Can you verify that all of the necessary file edits were made to showthread.php? To verify the edits, have vbhacker generate a text file of the hack. From there, look at all of the edits to showthread.php (they should be at the top) and make sure that they were done. In some instances, the edits were supposed to have executed twice (once for each instance of the code in showthread.php).

Oh man, this is a pain in the ass, i think the auto installer misses a lot of files during the install of it isnce there are some other mods installed =|

Bitsys, I checked the edits that were supposed to be made to showthread.php and I did them exactly as they were written, but the error still comes up. If you look closely, there are two snippets of code that are to be replaced in the install that are the exact same, but are to be replaced with two different things.

Yeah, unfortunately the auto-installed can't be perfect when there are other hacks installed. However, IMO, it still beats doing everything manually. Can you post which code did not insert properly?

Which snippets of code are identical? I don't see it...

Maybe you are referring to
If so, then you should note that the first instance of this snippet in showthread.php is tabbed to the right. Whereas the second instance of this code is NOT tabbed to the right. Since the code to be found is also not tabbed, it will only work on the second instance, and not the first.

What's your aim bytsis

Just installed, For some reason nothing is showing up in the drop down boxes in User CP Profile. The boxes are there, but empty. Am I missing something?

Did you run "install_itemshop_items.php" AND "install_rpg_stuff.php"?

Also, did you get any database errors when using vbhacker?

Everything went along fine. I had to manually edit member.php though. No errors that I noticed and the 2 scripts you just said were linked to automatically from vbhackers install if i'm not mistaken. Either way the items, classes, etc etc are there.

This is what I see

Nevermind, It was a problem with member.php. I hacked the file manually and it works fine now. Thanks.

Oops, sorry. I'm using the store hack money system. And about number 4, I found out that when someone levels up, al his stats are increasing a lot. Like almost 7 times stronger. I don't think that is correct. And I also have a question about spells and MA. I don't know how I can make a spell use MA, a spell is always using 0 MA. How can I change this?

That's another bug I am working out. ;)

Heh

It think all to people who are gonna install 0.60 don't install it lately i have lot of mysql errors

so its better to stick on 0.59

That my suggestion :)

What errors are you getting?