RPG Integration Hack /w Battle (BETA)

[SavgeDusk]

For reference I'm writing again what I wrote a while ago (sorry I wasn't around to answer your question. x_x;)

This is what I wrote:
I've got a quick question.
I have a forum called "Records" to keep all the battles played. But I was notified today that some of the battle records are out of order in the gameplay. For example, in the middle of the thread it would say
"[Attack executed]
[Name] died!"
And the next line in the thread would be another attack, and so on. So, the death/end of that battle was not in the right place. And possibly other attacks too.
How can this be fixed? Because I like having this forum there for reference in strategies about how to defeat high-stat members and whatnot.


And this is what you wrote back:
Can you verify that the 'lastactive' column in the `battle` table of your database has an integer value for all of the battles? If so, can you give me some of the values in the lastactive column?

Now my response. -- I'm pretty new to the whole database scene, so I don't know what you mean by "has an integer value for all of the battles". ^^;; Can you please explain what I need to show you in very simple terms? ^^;; Very sorry.

Also, I was wondering.. Is the only cause for any setting being reduced be changing its values in the AdminCP? Like, say I change a class's Reg. Attack, would that be the only cause for it to go down when a user with that effected class updates their stats?
Because some members are switching to another skin and their HP and EXP or something, go down. -- And it looks like every time a thread or post is deleted, their settings are effected. I don't know what to tell them. =/
I don't even know how EXP is gained. x_x; I thought it was by posting, but the only way I see is through battling.

And I know this is super annoying by now, but do you think it would be possible to add in or modify the "visible" thing to only Admin. Or add in an option like that for classes? Because I'd really like to have a special one for only Admin, and not have it accessible for Moderators. -- Instead of it being for Mod and Admin, can it be only for Admin? ^^;;

One more last question (sorry), how hard would it be to code in a "Clan" option? So that you can set it to add in specific members, so that regular members can't just add in themselves. Thanks!

[lioncool1589]

how do i disable retreat battle damn those ppl on my forum using that glitch to get mucho money

[Moreliator]

Bitsy - an update on the item type page in CPANEL:

I'm still having problems. It appears that two columns are mimicing other ones. For example, I have a fire and water category that give me trouble. Whenever I check an item to be available in the fire category, I hit update and when the page reloads it has it checkmarked on both the fire AND water columns! If I try to uncheck the moves from the water category, then press update, they just come right back after page reloads.

I can still uncheck the moves off the fire column. Once I do this, THEN I can also uncheck them from the water column and it works. HOWEVER.... as soon as I check them back on the fire column they come back checked on the water column too! please help.

BTW, I find it quite fascinating the the columns giving me trouble seem related:

For example, for me, the Category Column with the ID of 3 is always mimicing Category 13's check boxes, while the ID of column 2 is alwats mimicing Category 12's check boxes... is there a way to change the ID value...could this be the problem?

EDIT yep, that seems to be the problem. I tried deleting category 13, then adding a new category. It gave teh new category an ID of 17... and I bet you guessed it... The column representing category 7 now mimics every checkmark I place in the column representing category 17!!!! I would appreciate any help you can give. And now that I look closely, it appears that every category that has a counterpart in the teens is having this problem.

-More

[Bitsys]

04-16-03 at 09:47 AM Rusty_Boi said this in Post #1489 (https://vborg.vbsupport.ru/showthread.php?postid=382950#post382950)
i am getting this problem also..

well.. more or less... i fixed the dupilication thing. but when i choose Alignment or class... i get a "error on page" error. anyone have any ideas?
When you double-click the yellow exclamation point icon, what does the message box say the error is? Are you sure you didn't delete the javascript code at the top of the memberprofile template?

04-17-03 at 07:33 AM PixelFx said this in Post #1491 (https://vborg.vbsupport.ru/showthread.php?postid=383344#post383344)
Not sure if anyone has had this, but when I try to donate to another member with out anonamyous setting set, I get the following error.

server info:
PHP Version 4.3.1
Mysql: Client API version 4.0.12
Linux Redhat 7.3



Database error in vBulletin 2.3.0:

Invalid SQL: SELECT field5 FROM userfield WHERE userid=
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

Date: Thursday 17th of April 2003 12:10:44 AM
Script: http://www.xtremegames.ca/forum/forum/itemshop.php
Referer: http://www.xtremegames.ca/forum/itemshop.php?action=donate&user=



in battlefight.php, find:

That is a known bug. For an explanation, see https://vborg.vbsupport.ru/showthread.php?postid=362593#post362593

04-17-03 at 07:01 PM Jagang said this in Post #1495 (https://vborg.vbsupport.ru/showthread.php?postid=383591#post383591)
In the Battle table, the field battlekey is blank even though I set a password. If it helps I am running MySQL 3.23.41

If($battleopt[privacy] != 0 && $battle != $battlekey) {

eval("dooutput(\"".gettemplate('battle_badroom')."\");");
exit;
}
and change it to:
/*If($battleopt[privacy] != 0 && $battle != $battlekey) {

eval("dooutput(\"".gettemplate('battle_badroom')."\");");
exit;
}*/
That will temporarily fix the problem by disabling the password check. This means that battles will be open to everyone.

04-18-03 at 12:57 PM [b]Moreliator said this in Post #1496 (https://vborg.vbsupport.ru/showthread.php?postid=383815#post383815)
Bitsy,
I think I may have found a slight mistake in thh souce code in member.php for the stat updater


if ($hpmulti > 7.5)
$hpmulti = 3;
if ($hpmulti > 2.5)
$hpmulti = 1.5;
if ($hpmulti < 1)
$hpmulti = 1;


I think the last two need "else" statements:


if ($hpmulti > 7.5)
$hpmulti = 3;
elseif ($hpmulti > 2.5)
$hpmulti = 1.5;
elseif ($hpmulti < 1)
$hpmulti = 1;


The elseif probably isn't NECISARY on the last one.


ALSO, I seem to be having a problem with the item types in the admin panel. I recently added a new item Category. now, when I go to uncheck some of the boxes I checked in the "item type" page and press submit, it reloads the page as if i made no changes at all. any suggestions?

The problem is with the "two handed weapons" category. There are two specific columns that are being stubborn and that I can't uncheck. Every other column and item category checks and unchecks fine...


Thanks, that will be fixed in the next version. Also, the problem you are having with the item types will be fixed in the next version as well. Kudos on finding those two bugs :)

04-18-03 at 10:04 PM [b]Koutaru said this in Post #1499 (https://vborg.vbsupport.ru/showthread.php?postid=384026#post384026)
Hmm I was thinking toward they can carry up to 10 items out of any categlory XD Can I do that? I'm a newbie in php but I'm sure if someone tells me what to look for to change, I'll figure it out

I believe you want users to have an inventory, correct? If so, then this is not possible. The original itemshop was designed so that users could only have one item per category.

04-18-03 at 11:22 PM Zalastri said this in Post #1500 (https://vborg.vbsupport.ru/showthread.php?postid=384049#post384049)
First off.. This is one hell of a hack. Good work. My members love it... hell.. my board is based on this hack now. I run a small RP community and this was a hell of a gift. Now then...

The whole user field/points system is a little wacky. You should make the VBhacker.php make a SET variable for money. Cauase for a while I had it displaying usernames as money >.>

Was it displaying usernames or RPG Names? If it was displaying RPG Names, then this means that in the Itemshop Options Menu in the admin CP the Points Field value was not correct. You should have adjusted this to the correct field # by doing the following procedure:

1. Go to your admin panel
2. Go to modify user profile fields
3. Find the Points 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 itemshop options
9. In the Points Field option put in field# and replace the # with the number you recorded in step 7.


04-18-03 at 11:22 PM Zalastri said this in Post #1500 (https://vborg.vbsupport.ru/showthread.php?postid=384049#post384049)
Can you give me the code for your postbit that you had on that screenie?
All of the code is located in the RPG Admin Manual.

04-18-03 at 11:22 PM Zalastri said this in Post #1500 (https://vborg.vbsupport.ru/showthread.php?postid=384049#post384049)
For some reason my forum is very sluggish.. do you happen to have a database speedup php app?
Unfortunately, I do not. There may be some people who can help you at www.vbulletin.com though.

04-18-03 at 11:22 PM Zalastri said this in Post #1500 (https://vborg.vbsupport.ru/showthread.php?postid=384049#post384049)
Users should be able to have a whole inventory.. Not just one item. And you should make it so that on the home page you can just put something like $rpgnav and have a table with all the required RPG links on it.
Although letting people add a variable such as $rpgnav would make it easier to start off with, I think most people would rather do the header themselves. This hack is already fairly standardized across forums so letting people do their own header makes the hack more forum-specific.

04-18-03 at 11:22 PM Zalastri said this in Post #1500 (https://vborg.vbsupport.ru/showthread.php?postid=384049#post384049)
Weapons should have spells that can sometimes cast.. Like poision effects.
The current battle format is not properly designed to handle status modifiers.

04-18-03 at 11:22 PM Zalastri said this in Post #1500 (https://vborg.vbsupport.ru/showthread.php?postid=384049#post384049)
Random encounters... Like.. If you view a post once out of every 70 tiems you get into a random battle with a wolf or something :D Happy coding and good job.
The PVM idea has been suggested before and discussed quite a bit. Feel free to do a search on this thread to read more about it.


04-18-03 at 11:27 PM SavgeDusk said this in Post #1501 (https://vborg.vbsupport.ru/showthread.php?postid=384051#post384051)
For reference I'm writing again what I wrote a while ago (sorry I wasn't around to answer your question. x_x;)

This is what I wrote:
I've got a quick question.
I have a forum called "Records" to keep all the battles played. But I was notified today that some of the battle records are out of order in the gameplay. For example, in the middle of the thread it would say
"[Attack executed]
[Name] died!"
And the next line in the thread would be another attack, and so on. So, the death/end of that battle was not in the right place. And possibly other attacks too.
How can this be fixed? Because I like having this forum there for reference in strategies about how to defeat high-stat members and whatnot.


And this is what you wrote back:
Can you verify that the 'lastactive' column in the `battle` table of your database has an integer value for all of the battles? If so, can you give me some of the values in the lastactive column?

Now my response. -- I'm pretty new to the whole database scene, so I don't know what you mean by "has an integer value for all of the battles". ^^;; Can you please explain what I need to show you in very simple terms? ^^;; Very sorry.
Everyone was new at one time :) Try this:
In phpmyadmin, click on your database name. From there, click on the table called `battle`. At the next screen, click "Browse". If the Browse link is not active, then create a battle and try again. Once browsing, look for the column called 'lastactive'. Tell me the values in that column for each row in the table.

04-18-03 at 11:27 PM SavgeDusk said this in Post #1501 (https://vborg.vbsupport.ru/showthread.php?postid=384051#post384051)
Also, I was wondering.. Is the only cause for any setting being reduced be changing its values in the AdminCP? Like, say I change a class's Reg. Attack, would that be the only cause for it to go down when a user with that effected class updates their stats?
Because some members are switching to another skin and their HP and EXP or something, go down. -- And it looks like every time a thread or post is deleted, their settings are effected. I don't know what to tell them. =/
If you do drastic changes to the classes/races/etc. and you want to have the effects applied right away, then you can go to the Mass Experience menu in the admin CP and do option #5. This will update all user's stats for you. Once you have done this, you can make an announcement stating the changes.

04-18-03 at 11:27 PM SavgeDusk said this in Post #1501 (https://vborg.vbsupport.ru/showthread.php?postid=384051#post384051)
I don't even know how EXP is gained. x_x; I thought it was by posting, but the only way I see is through battling.
To see how experience is gained, go to the Battle Options Menu and lok under the Experience Options heading.

04-18-03 at 11:27 PM SavgeDusk said this in Post #1501 (https://vborg.vbsupport.ru/showthread.php?postid=384051#post384051)
And I know this is super annoying by now, but do you think it would be possible to add in or modify the "visible" thing to only Admin. Or add in an option like that for classes? Because I'd really like to have a special one for only Admin, and not have it accessible for Moderators. -- Instead of it being for Mod and Admin, can it be only for Admin? ^^;;
Thinking about it.

04-18-03 at 11:27 PM SavgeDusk said this in Post #1501 (https://vborg.vbsupport.ru/showthread.php?postid=384051#post384051)
One more last question (sorry), how hard would it be to code in a "Clan" option? So that you can set it to add in specific members, so that regular members can't just add in themselves. Thanks!
It might be easy and it might be hard. I would suggest trying out the clan hack that was recently posted in the Beta forum.

Today at 03:52 PM lioncool1589 said this in Post #1502 (https://vborg.vbsupport.ru/showthread.php?postid=384791#post384791)
how do i disable retreat battle damn those ppl on my forum using that glitch to get mucho money

In battlefight.php, find:
$retreat .= "<INPUT TYPE=\"RADIO\" NAME=\"charaction\" VALUE=\"retreat\">Retreat<BR>";
And change it to:
//$retreat .= "<INPUT TYPE=\"RADIO\" NAME=\"charaction\" VALUE=\"retreat\">Retreat<BR>";

Today at 06:42 PM Moreliator said this in Post #1503 (https://vborg.vbsupport.ru/showthread.php?postid=384875#post384875)
Bitsy - an update on the item type page in CPANEL:

I'm still having problems. It appears that two columns are mimicing other ones. For example, I have a fire and water category that give me trouble. Whenever I check an item to be available in the fire category, I hit update and when the page reloads it has it checkmarked on both the fire AND water columns! If I try to uncheck the moves from the water category, then press update, they just come right back after page reloads.

I can still uncheck the moves off the fire column. Once I do this, THEN I can also uncheck them from the water column and it works. HOWEVER.... as soon as I check them back on the fire column they come back checked on the water column too! please help.

BTW, I find it quite fascinating the the columns giving me trouble seem related:

For example, for me, the Category Column with the ID of 3 is always mimicing Category 13's check boxes, while the ID of column 2 is alwats mimicing Category 12's check boxes... is there a way to change the ID value...could this be the problem?

EDIT yep, that seems to be the problem. I tried deleting category 13, then adding a new category. It gave teh new category an ID of 17... and I bet you guessed it... The column representing category 7 now mimics every checkmark I place in the column representing category 17!!!! I would appreciate any help you can give. And now that I look closely, it appears that every category that has a counterpart in the teens is having this problem.

-More


Thanks, that was exactly the information I needed to find the bug. It will be fixed in the next version.

[Moreliator]

Hey Bitsy,

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

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

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

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

-more

[Airs]

The battling thins doesn't work when a peron has ' in their username.. it screws up and doesn't let the user do anything. and sends a load of error mails to the admin (me)

[Red Blaze]

I too found a bug. When I go to add hp, it won't add. For example I have 144hp and I want it to go up to 199. I have to add 55hp to get to 199, right? Well, I try adding the 55hp but it stays at 144. =/

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

[Jagang]

Today at 03:28 PM Sonikku said this in Post #1507 (https://vborg.vbsupport.ru/showthread.php?postid=385128#post385128)
I too found a bug. When I go to add hp, it won't add. For example I have 144hp and I want it to go up to 199. I have to add 55hp to get to 199, right? Well, I try adding the 55hp but it stays at 144. =/

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

Are you talking about the link in the postbit? If so, my understanding is this option is for refilling health like after a battle. Say the person comes out of battle and has 100 HP out of 144HP, then instead of going to the healer and paying to restore the health you can give him/her 44HP and refill them. I don't think it was designed to raise max levels. I may be wrong but this is my understanding of it and how it works on my board.

[soccerclue]

Hi,

Can someone help me. I am really screwed up right now. My forum is at http://www.asianguild.com Can someone tell me what's wrong in my forum's Edit Profile? The RPG profile are shown two times. I think I messed up with the database. Can anyone tell me where should I change it? And I can't find modifyprofile template. Can someone tell me in which section of template is it? And when I am in the RPGCP, whenever I click HP/MA/PP link, it won't show up. It says "No user specified. If you followed a valid link, please notify the webmaster" can someone please help me. Please help me. Thank you.

[PSI|Dr-X]

You didin't mess anything it's a error in this version :( wait until bytsis replies he will fix your problem

[soccerclue]

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

[Moreliator]

Well bitsy,

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

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

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

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

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


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

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

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

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

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

We apologise for any inconvenience.

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

Thanks.
-More

[soccerclue]

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

[Airs]

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

[Bitsys]

04-20-03 at 09:38 PM Moreliator said this in Post #1505 (https://vborg.vbsupport.ru/showthread.php?postid=384961#post384961)
Hey Bitsy,

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

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

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

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

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

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


Thanks, will be fixed in the next version.


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

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


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

Yesterday at 03:47 PM Moreliator said this in Post #1512 (https://vborg.vbsupport.ru/showthread.php?postid=385686#post385686)
Well bitsy,

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

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

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

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

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


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

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

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



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

Thanks.
-More


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

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


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

Today at 06:54 AM Airs said this in Post #1514 (https://vborg.vbsupport.ru/showthread.php?postid=385902#post385902)
Biiiggg Error... On my forums a user got hacked and the hacker kept creating battles and stealing another users money.. from making challenges himself.


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

[PSI|Dr-X]

Today at 12:54 PM Airs said this in Post #1514 (https://vborg.vbsupport.ru/showthread.php?postid=385902#post385902)
Biiiggg Error... On my forums a user got hacked and the hacker kept creating battles and stealing another users money.. from making challenges himself.


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

[Moreliator]

Today at 08:04 PM Bitsys said this in Post #1515 (https://vborg.vbsupport.ru/showthread.php?postid=386047#post386047)

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



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


Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO battle_posts VALUES (NULL,'326','s'mores','8447','The 1337 Beast used his Scratch to deal 12 points of damage. Mediator tried to dodge, but was not successful. Mediator has died!!')
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mores','8447','The 1337 Beast used his Scratch to dea

mysql error number: 1064

Date: Tuesday 22nd of April 2003 08:00:03 PM
Script: http://smashboards.com///battleupdate.php?action=battlereply&battlenumber=326&username=s\'mores&userid=8447&battlekey=Smashboards
Referer: http://smashboards.com//battlefight.php?action=enterbattle&battlenumber=326&battlekey=Smashboards


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


Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO battle_posts VALUES (NULL,'333','s'mores','8447','[I]The 1337 Beast was awarded $0 for winning the battle.')
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mores','8447','[I]The 1337 Beast was awarded $0 for winn

mysql error number: 1064

Date: Tuesday 22nd of April 2003 08:05:57 PM
Script: http://smashboards.com///battleupdate.php?action=battlereply&battlenumber=333&username=s\'mores&userid=8447&battlekey=smores
Referer: http://smashboards.com//battlefight.php?action=enterbattle&battlenumber=333&username=s\'mores&userid=8447&battlekey=smores



The only other email error message I receive is:


Database error in vBulletin 2.3.0:

Invalid SQL: SELECT field5 FROM userfield WHERE userid=
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

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


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


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

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

[PSI|Dr-X]

When is the next version actually comming?

[soccerclue]

Hi,

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

[Nintel]

I need some help. I get this error:

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

and the coding around line 183 is:

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

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

return $forumcache[$forumid];
}

What's wrong?

[Jagang]

Today at 01:22 AM Nintel said this in Post #1520 (https://vborg.vbsupport.ru/showthread.php?postid=386703#post386703)
I need some help. I get this error:

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

and the coding around line 183 is:

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

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

return $forumcache[$forumid];
}

What's wrong?


Well if the error is in functions.php on line 383 then why are you showing us the coding around line 183 ? I think we could help you better if we saw line 383. That part should say it is part of this hack. and will probally look something like this:
$level = getlevel($post[xp], $post[exprate], 1);
or at least it should. ;)

[Jagang]

BTW for those of you interested here is a cosmetic change that works well with this hack.

https://vborg.vbsupport.ru/showthread.php?s=&threadid=51982

This is for having different postbits for different usergroups. If some of you have a board like mine, you may have members who do not play in the rpg and therefore have no need of stats in the postbit. This change allows you to make a group of just "RPG Members" and the stats only show in their postbits, everyone else can just have the regular postbit.

[SavgeDusk]

Posted By: Bitsys
Everyone was new at one time :) Try this:
In phpmyadmin, click on your database name. From there, click on the table called `battle`. At the next screen, click "Browse". If the Browse link is not active, then create a battle and try again. Once browsing, look for the column called 'lastactive'. Tell me the values in that column for each row in the table.


Hopefully this is what you mean. There's 12 rows. And here are the numbers in the `lastactive` column.

1051039715
1051222856
1051175646
1051170024
1050968041
1051154874
1051221181
1051229874
1051171682
1050696433
1051101281
1050888018

[SM Tengu]

Yesterday at 09:34 PM soccerclue said this in Post #1519 (https://vborg.vbsupport.ru/showthread.php?postid=386561#post386561)
Hi,

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

Have you modified the weapon's Buff, in the Edit Items-section of your Admin Panel?




Excellent work on this hack. You've done a great job.

[soccerclue]

Thanks SM Tengu...I got it now.

[Koutaru]

04-20-03 at 09:07 PM Bitsys said this in Post #1504 (https://vborg.vbsupport.ru/showthread.php?postid=384914#post384914)
I believe you want users to have an inventory, correct? If so, then this is not possible. The original itemshop was designed so that users could only have one item per category.


That's a downer. It would be great to have an inventory and then have users "equip" themselves with items when they go into battle. Then, they can equip themselves of whatever they want like all attack items or all healing items. With a max # of items equippable of course :)

Maybe I'll attempt to redo itemshop in order for this to be done. I'm pretty new to php so I'm not expecting to get done fast but I'm definately going to try because I really want this :) Thanks Bitsys

[Zalastri]

w00t. if anyone wants to see this hack working with spells/armor/swords/shields and such go to www.zalastri.com :) IT works like a charm after some tweaking.

[PixelFx]

looks good :) I don't have spells added yet, or buffs, but if anyone wants a gander at my battle system :) http://www.xtremegames.ca/ I can't wait to test the next release of the RPG Integration Hack /w Battle.



quote:
Yesterday at 03:44 PM PixelFx said this in Post #1486

[ PixelFX ] question
I'm still testing but got the battle system install cleanly, so far with no problems, I also made a custom post bit to try and keep them a bit smaller. Then linked up everything to my vbhome page and profile with addons, everything seemed to install great so far.

if anyone wants to have a look, click the www link in my profile The site is script heavy.

Thanks to everyone that is working on this my self and few others are going to convert the hack over to AD&D 2nd & 3rD Editions.

--------------
[ Bitsys ] reply
Hmm, interesting system you have there. Is that a released hack on vbulletin.org, or a custom job?



Bitsys, spam system?

as for news system, it's part of vbhome, from vbulletin.org, I've done a lot of custom hacks, and changes custom postbit changes to the site, to link up to your rpg hack. As well as some custom profile tweaks.

[Xyphen]

Bitsys bro thnx man.. i updated works perfect on vb2.3.0, no probs here!

[dotagious]

I installed this on a fresh version of vBulletin 2.3.0 without incident. However, I have (so far) found two after the fact problems. I don’t believe the problem has anything to do with my end of things, such as installation, other hacks, etc.

The first problem exists in usercp > edit profile. Here, most of the fields are duplicated, and the form itself displays inaccuracies and contradictions such as it indicating the form as being part of registration. I have attached my modifyprofile template, where the problem likely exists.

The second problem is in reference to the postbit template. I copied/pasted the contents of samplepostbit.txt as instructed. Unfortunately, the entire postbit area when viewed in the forums fails to display correctly. I will attach my postbit template in the post.

Again, this hack was installed on s a fresh version of vBulletin 2.3.0 and has not a single hack or other modification made to it. I had no error messages displayed and did not come upon any problems during installation. I would greatly appreciate text files with the corrections made. Thanks for a great hack… I hope the momentum continues.

[dotagious]

.

[Nintel]

I'm having more problems...he stuff won't show up in the threads. Shouldn't it be showing experience?

[SM Tengu]

Nintel, it's easier to understand the problem if you elaborate what you mean by that.

[kaotic]

My members keep challenging other members that are way out of their league... so I was wondering if there was a way to create a new field in the memberlist that displays each member's level. Can this be done?

[dotagious]

Today at 12:35 AM Me! said this in Post #1535 (https://vborg.vbsupport.ru/showthread.php?postid=388758#post388758)
I'm having difficulties, I installed this hack to a fresh board runninb 2.3.0. Everything installed successfuly. However I didn't do backups so once the installation was finished it said backing up the files was unable to be done since I hadn't chmod'ed them. Everything else it said was successful. Now when I go to my forum nothing shows and itemshop brings up an error.

Fatal error: Call to undefined function: getlevel() in /blahblahstuffhere/forum2/itemshop.php on line 438

Also when I go into user profile the RPG fields have no options in the drop down box. I'm not sure what else I am to do.

Did you run the install_itemshop_items.php ?

Did you add the variables to your postbit template?

[Airs]

How can i possibly remove extra templates.. like i accidentally processed the insert db of the tempaltes a few times now i have like

battle [changeorginal]
battle [changeorginal]
battle [changeorginal]
battle [changeorginal]
battle [changeorginal]

tons of duplicates; how doi remove them?

[Bitsys]

04-23-03 at 05:49 PM Moreliator said this in Post #1517 (https://vborg.vbsupport.ru/showthread.php?postid=386128#post386128)

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

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

To fix the ' in peoples names, do the following:

In battleupdate.php, find:
$DB_site->query("INSERT INTO battle_posts VALUES (NULL,'$battle','$bbuserinfo[username]','$bbuserinfo[userid]','$battleaction')");
And REPLACE it with:
$DB_site->query("INSERT INTO battle_posts VALUES (NULL,'$battle','".addslashes($bbuserinfo[username])."','$bbuserinfo[userid]','$battleaction')");
Still in battleupdate.php, find:
$DB_site->query("INSERT INTO battle_posts VALUES (NULL,'$battlenumber','$bbuserinfo[username]','$bbuserinfo[userid]','$battleaction')");
and REPLACE with:
$DB_site->query("INSERT INTO battle_posts VALUES (NULL,'$battlenumber','".addslashes($bbuserinfo[username])."','$bbuserinfo[userid]','$battleaction')");

I am unable to solve the donation problem. For more information, search this thread and the original itemshop thread to see solutions I have tried that did not work.

For all of you getting the following error:
Fatal error: Call to undefined function: getlevel() in /hsphere/local/home/side5411/forums.nintel.com/forums/admin/functions.php

Do the following:

In admin/functions.php, find:
// ###################### Start gettextareawidth #######################
and ABOVE it, add:
// ###################### Start getlevel #######################
// This function is for the RPG Integration Hack by Bitsys.
// It calculates the level of a person, given their experience
// and the rate of experience gain. It can return float or int.
function getlevel($experience, $exprate=3, $returnfloat=0) {
if($returnfloat) {
if($experience > 0) {
return pow( log10( $experience), floor( $exprate));
} else {
return 0;
}
} else {
if($experience > 0) {
return floor( pow( log10( $experience), floor( $exprate))) + 1;
} else {
return 1;
}
}
}


04-25-03 at 03:37 PM [b]SavgeDusk said this in Post #1523 (https://vborg.vbsupport.ru/showthread.php?postid=387081#post387081)
Hopefully this is what you mean. There's 12 rows. And here are the numbers in the `lastactive` column.

1051039715
1051222856
1051175646
1051170024
1050968041
1051154874
1051221181
1051229874
1051171682
1050696433
1051101281
1050888018

Wait for the next version and see if it fixes this problem.

04-27-03 at 11:31 AM [b]PixelFx said this in Post #1528 (https://vborg.vbsupport.ru/showthread.php?postid=387942#post387942)
looks good :) I don't have spells added yet, or buffs, but if anyone wants a gander at my battle system :) http://www.xtremegames.ca/ I can't wait to test the next release of the RPG Integration Hack /w Battle.



Bitsys, spam system?

as for news system, it's part of vbhome, from vbulletin.org, I've done a lot of custom hacks, and changes custom postbit changes to the site, to link up to your rpg hack. As well as some custom profile tweaks.


Yes, I noticed that there was a spam count in the postbit. I believe I read a post stating that you can't have too many spam counts or it takes away money from the itemshop. Maybe I was dreaming :)

04-28-03 at 01:38 AM dotagious said this in Post #1530 (https://vborg.vbsupport.ru/showthread.php?postid=388303#post388303)
I installed this on a fresh version of vBulletin 2.3.0 without incident. However, I have (so far) found two after the fact problems. I don?t believe the problem has anything to do with my end of things, such as installation, other hacks, etc.

The first problem exists in usercp > edit profile. Here, most of the fields are duplicated, and the form itself displays inaccuracies and contradictions such as it indicating the form as being part of registration. I have attached my modifyprofile template, where the problem likely exists.

The second problem is in reference to the postbit template. I copied/pasted the contents of samplepostbit.txt as instructed. Unfortunately, the entire postbit area when viewed in the forums fails to display correctly. I will attach my postbit template in the post.

Again, this hack was installed on s a fresh version of vBulletin 2.3.0 and has not a single hack or other modification made to it. I had no error messages displayed and did not come upon any problems during installation. I would greatly appreciate text files with the corrections made. Thanks for a great hack? I hope the momentum continues.

Delete the first instance of
<tr><td bgcolor="$bgcolor"><normalfont><b>Element Type:</b></normalfont><br>
<smallfont>The Element type you want to be at the boards.</smallfont></td>
<td bgcolor="$bgcolor"><normalfont>

<select name="element">
$elementoptions
</select>

</normalfont></td>
</tr>
<tr>
<td bgcolor="$bgcolor"><normalfont><b>RPG Alignment:</b></normalfont><br>
<smallfont>The side you want your character to be on the RPG.</smallfont></td>
<td bgcolor="$bgcolor"><normalfont>
<select name="alignment" onchange="updateRaces()">
$alignmentoptions
</select></normalfont></td>
</tr>
<tr>
<td bgcolor="$bgcolor"><normalfont><b>RPG Race:</b></normalfont><br>
<smallfont>The Race you want your character to be on the RPG.</smallfont></td>
<td bgcolor="$bgcolor"><normalfont>
<select name="rpgrace">
$raceoptions
</select></normalfont></td>
</tr>
<tr>
<td bgcolor="$bgcolor"><normalfont><b>RPG Gender:</b></normalfont><br>
<smallfont>This would be your RPG Character's Gender, not your gender in real life.</smallfont></td>
<td bgcolor="$bgcolor"><normalfont>
<select name="rpggender" onchange="updateClasses()">
$genderoptions
</select></normalfont></td>
</tr>

<tr>
<td bgcolor="$bgcolor"><normalfont><b>RPG Class:</b></normalfont><br>
<smallfont>The Class you want your character to be on the RPG.</td>
<td bgcolor="$bgcolor"><smallfont>
<select name="rpgclass" onchange="updateType()">
$classoptions
</select></smallfont>

</td>
</tr>
<tr>
<td bgcolor="$bgcolor"><normalfont><b>RPG Type:</b></normalfont><br><smallfont>Your type is automatically determined by your class.</smallfont></td>

<td bgcolor="$bgcolor" >
<input type="text" class="bginput" name="rpgtypename" value="$rpgtypename" length="30" READONLY><input type="hidden" name="rpgtypeid" value="$rpgtypeid">
</td>
</tr>
<tr>
<td bgcolor="$bgcolor"><normalfont><b>Build Stats</b></normalfont><br>
<smallfont>Click here if you want to have stats shown on the board.</smallfont></td>
<td bgcolor="$bgcolor"><normalfont>
<input type="checkbox" name="updatestats">Update stats
</normalfont></td>
</tr>


Try the attached postbit.

I will see about changing that template edit so that it quits duplicating.

04-28-03 at 11:19 AM Nintel said this in Post #1532 (https://vborg.vbsupport.ru/showthread.php?postid=388457#post388457)
I'm having more problems...he stuff won't show up in the threads. Shouldn't it be showing experience?

Could you provide a link or a screenshot?

04-28-03 at 08:35 PM kaotic said this in Post #1534 (https://vborg.vbsupport.ru/showthread.php?postid=388715#post388715)
My members keep challenging other members that are way out of their league... so I was wondering if there was a way to create a new field in the memberlist that displays each member's level. Can this be done?


Yes, it can be done. Someone was working on it a while ago.

04-28-03 at 11:35 PM Me! said this in Post #1535 (https://vborg.vbsupport.ru/showthread.php?postid=388758#post388758)
I'm having difficulties, I installed this hack to a fresh board runninb 2.3.0. Everything installed successfuly. However I didn't do backups so once the installation was finished it said backing up the files was unable to be done since I hadn't chmod'ed them. Everything else it said was successful. Now when I go to my forum nothing shows and itemshop brings up an error.

Fatal error: Call to undefined function: getlevel() in /blahblahstuffhere/forum2/itemshop.php on line 438

Also when I go into user profile the RPG fields have no options in the drop down box. I'm not sure what else I am to do.


Can you go into phpmyadmin and verify that the appropriate data is in the tables? Just make sure the table that begin with rpg_ aren't empty.

04-29-03 at 10:12 PM Airs said this in Post #1538 (https://vborg.vbsupport.ru/showthread.php?postid=389241#post389241)
How can i possibly remove extra templates.. like i accidentally processed the insert db of the tempaltes a few times now i have like

battle [changeorginal]
battle [changeorginal]
battle [changeorginal]
battle [changeorginal]
battle [changeorginal]

tons of duplicates; how doi remove them?


You will need to go into phpmyadmin, find the template table, and delete them manually.


As for why I haven't responded in a while, well, I had a rough week. Internet keeps going out, power went out for a few hours, fire alarm keeps malfunctioning, etc. Plus, it is exam week.

[PixelFx]

quote:
04-27-03 at 11:31 AM PixelFx said this in Post #1528
looks good I don't have spells added yet, or buffs, but if anyone wants a gander at my battle system http://www.xtremegames.ca/ I can't wait to test the next release of the RPG Integration Hack /w Battle.

Bitsys, spam system?

as for news system, it's part of vbhome, from vbulletin.org, I've done a lot of custom hacks, and changes custom postbit changes to the site, to link up to your rpg hack. As well as some custom profile tweaks.

Yes, I noticed that there was a spam count in the postbit. I believe I read a post stating that you can't have too many spam counts or it takes away money from the itemshop. Maybe I was dreaming



Ah ok, well I have store hack installed, using an addon called anti spam for that, basically if people post too many short replys to my site the system would take store points away.

hacks added,
Added Store Hack by Lesane
Added Spam Killer Hack (store version) by g-force2k2
Added Rpg Battle System to the site by Bitsys
Added Update to Store Hack, seperate from battle system

after adding some of these hacks, I had to custom edit the postbit/profile to make the contents show up for each of these systems which was a great learning exterience, and about 2 hours of juggling and tweaking.

Example shots of how it looks:
my custom postbit,
http://www.xtremegames.ca/code/imgs/new_postbit1.gif

what profile link in postbit looks like
http://www.xtremegames.ca/code/imgs/new_profile.gif

Try talking to g-force2k2 to see if a version could get setup for your next release / future release of the rgg battle system.

I tried to fix most of the bugs I found, my bad, I'll be installing it again on my other site so will make bug list and post it here, and what I changed.

as for requests, I'd love to see away to change what type of currency the rgp system uses, and also have room to add userfields for adding possible multi-currency types to the rpg hack. aka pyreal, Platinum, Gold, Silver, Bronze, etc.

sorry for the long message ... :)

[SM Tengu]

I made a very small add-on that makes the hack even more RPG like.

If you fight a high level opponent it would make sense if you gained more experience than if you fight a low level opponent. So what this hack does is simply to multiply the experience-factor that you set for winning the battle with the opponents level.

Open battleupdate.php and find:
-------

if($battleopt[givewinexp] == 1 && $battleopt[expperwin] > 0) {
if($battle[winnerid] > 0)
$DB_site->query("UPDATE user SET xp=xp+$battleopt[expperwin] WHERE userid='$battle[winnerid]'");
}

-------

And replace with:
-------

if($battleopt[givewinexp] == 1 && $battleopt[expperwin] > 0) {
if($battle[winnerid] > 0)
$DB_site->query("UPDATE user SET xp=xp+($opponentlevel*$battleopt[expperwin];) WHERE userid='$battle[winnerid]'");
}

-------

Very simple hack, but it can prevent some abuse of the fighting system. For example the so called Bottom-feeding.

Perhaps this could be included in the next update? Personally, I think it would make more sense than the current system =)

Bitsys, would it be possible to make different forums gain you a different amount of creds and exp? I've made a raw code hack now, but I have to alter it through the code instead of the admin panel.

For example, I want my users to gain more experience and credits for posting in a serious forum such as "Forum Suggestions". And less if they use "General Discussions".

Perhaps implent a multiplier in the Forum Moderation-system.

[Sun Boy]

Hi,

this's a nice hack

1. when i go to the itemshop and then click on bank nothing change, i am still in the itemshop

2. i don't want to fight a user, i want to add a battle room without a password and any user can come and fight me , can i do that ?

sorry 4 my bad english ;)

thanks, :)
Sun Boy :cool:

[flame]

Anyone know of an "ideal" buff setting for your weapons?

I have been playing about with mine and cant seem to get a good result, also what about race stats is everyone using the defaut setup or their own.

Any help/info would be greatful

@Sun Boy - The reason when you click bank and only see itemshop, is because you must be using lesane's store hack which Can't use the Itemshop Bank. As stated in the installation file.

Flame

[Sun Boy]

flame, thanks :)

[Ryoku]

is there a way i can get the battle and hp hack only. Cuz i already got the itemshop hack install.

[Ryoku]

dont mean to double post but can i install this hack manualy ?

[kaotic]

I think I can help you with the answer to your first question...

12-06-02 at 03:20 AM Bitsys said this in Post #1 (https://vborg.vbsupport.ru/showthread.php?postid=328361#post328361)
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.

[sonic3d]

does ne1 know how to change the the 10 points in the rpg classes for attack, defense, etc. to 20?

l8er
sonic

[GaleForce]

Too many pages to check... Will there every be individual instructions for installing this hack if you already have one of the parts installed? (I have the Itemshop already)

[SM Tengu]

Today at 01:38 AM sonic3d said this in Post #1549 (https://vborg.vbsupport.ru/showthread.php?postid=391509#post391509)
does ne1 know how to change the the 10 points in the rpg classes for attack, defense, etc. to 20?

l8er
sonic

Just go to the Admin Panel, choose 'Edit classes' and then fill in whatever numbers you want there. Finish by pressing "Update (fe)Male classes".

[sonic3d]

isn't that max is up to 10?

l8er
sonic

[SM Tengu]

Yesterday at 11:02 PM sonic3d said this in Post #1552 (https://vborg.vbsupport.ru/showthread.php?postid=391886#post391886)
isn't that max is up to 10?

l8er
sonic


Well, I could change it to 20 at least, perhaps you've got an older version that had a restriction like that?

[sonic3d]

ur right. when i read the manual and it said "Should usually be kept within 1 and 10", didn't realize it said it SHOULD.

thanx for replying.

l8er
sonic

[Link14716]

04-19-03 at 01:27 AM SavgeDusk said this in Post #1501 (https://vborg.vbsupport.ru/showthread.php?postid=384051#post384051)
For reference I'm writing again what I wrote a while ago (sorry I wasn't around to answer your question. x_x;)

This is what I wrote:
I've got a quick question.
I have a forum called "Records" to keep all the battles played. But I was notified today that some of the battle records are out of order in the gameplay. For example, in the middle of the thread it would say
"[Attack executed]
[Name] died!"
And the next line in the thread would be another attack, and so on. So, the death/end of that battle was not in the right place. And possibly other attacks too.
How can this be fixed? Because I like having this forum there for reference in strategies about how to defeat high-stat members and whatnot.

I also had this problem. Here is how I fixed it.

In battleupdate.php...
Find: $posts = $DB_site->query("SELECT * FROM battle_posts WHERE battlenumber='$battle[battlenumber]' ORDER BY battleactionid"); Replace With: $posts = $DB_site->query("SELECT * FROM battle_posts WHERE battlenumber='$battle[battlenumber]' ORDER BY battleactionid ASC");

EDIT: You also have to do this:
showthread.php:
Find:WHERE $postids
ORDER BY dateline $postorder Replace With:WHERE $postids
ORDER BY postid $postorder

[Ryoku]

im having a problem with the itemshops. At the itemshop.php it only show the the weapons items. Armor and Accessories are not showing up.

[Red Blaze]

Can someone help me out with a little addon? I believe it's quite simple, but I'm a noob with php. I requested this before, and some of you thought it was a good idea. To have background midis. You know, just like how you can choose a battle scene, you can choose a midi to play as background music. I got it kinda planed out, but need serious help. Please PM me if someone is willing to help me.

Bitsys, I would ask you for help on this little addon, but knowing that you're the author of the hack I believe you are very busy helping others.

im having a problem with the itemshops. At the itemshop.php it only show the the weapons items. Armor and Accessories are not showing up.

Did you try clicking on "Expand"?

[Davey]

Is there any reason the attack seems to stay at 10 no matter what you do?
I really am having trouble understanding that aspect of the battle system.
On another note, the 'level' is not shown in the battle screen.

Dave.

[SM Tengu]

Today at 03:35 AM Ryoku said this in Post #1556 (https://vborg.vbsupport.ru/showthread.php?postid=391993#post391993)
im having a problem with the itemshops. At the itemshop.php it only show the the weapons items. Armor and Accessories are not showing up.

And did you actually add the other shops? =)



Davey, do you mean damage given, or the attack-stat that I talked about in my two previous posts?

[Davey]

The damage given.

Dave.

[SM Tengu]

Today at 05:02 PM Davey said this in Post #1560 (https://vborg.vbsupport.ru/showthread.php?postid=392235#post392235)
The damage given.

Dave.


For low levels the numbers aren't that high. And the randomness isn't that high either so it will seem to be the exact number each time.

Try using different weapons and armour and you will see that it increases / decreases depending on what you're equipped with and what kind of attack you make.

Also when you go up some levels you will also notice that it increases over time.

[Sun Boy]

Hello,

When i am in a battle, i can't use any weapons or spells or potions, i can't select it, but i have one weapon!, same thing to users!!

PlZzZzZzZz

[roninuta]

This is freaking awesome - from all the screens I have seen this is gonna be soooooooo kewl. As soon as I can get a test server up i will install.

OMG OMG OMG OMG - this is gonna be fun!

[SM Tengu]

Yesterday at 07:05 PM Sun Boy said this in Post #1562 (https://vborg.vbsupport.ru/showthread.php?postid=392300#post392300)
Hello,

When i am in a battle, i can't use any weapons or spells or potions, i can't select it, but i have one weapon!, same thing to users!!

PlZzZzZzZz


Have you set the buff of the weapons in the admin panel? If the weapons don't have a buff, they will not be useable.

[PixelFx]

Today at 12:10 PM roninuta said this in Post #1563 (https://vborg.vbsupport.ru/showthread.php?postid=392372#post392372)
This is freaking awesome - from all the screens I have seen this is gonna be soooooooo kewl. As soon as I can get a test server up i will install.

OMG OMG OMG OMG - this is gonna be fun!


LOL, yup, it's pretty kewl, I can't wait for the next update, not sure when though... ;) *hints* welcome...

seriously it's pretty awesome...

[Sun Boy]

yes i set it
i use Rod and before i buy it i have put the Buff 20 from the cp !
but when i try to play battle i can't use this weapon !! :(

[Sun Boy]

Hello,

it's work good now

but i have some bugs

1. i have install this hack with Store hack, the post count if the user post the post number 1 for him it still on 0

2. same thing in the money, if user post a rplay number 1 for him the money conut say he have 2 Gil, re-download the page then it say he have 5 Gil and still on 0 post !!

[roninuta]

I noticed one thing that I had to do when getting MySQL errors 1054. I already had the Store hack installed and customized. This lead to problems when the installer script for RPG tired to insert colums in the userfield and items_user tables.

I had to empty all the item tabels using phpmyadmin and rerun the install_itemshop_items script (which stops if it finds a duplicated column at anytime).

Also to get my money to work correctly with store I had to setup field6 by hand in the userfield table by hand and set the values via phpmyadmin. After that the money and items work great.

I'm off to customize my profiles now.

So far so good though. Hope this helps people.

[Davey]

Is it possible to let admins edit stats?
I'm talking about STR, MAG, etc., not HP.

Dave.

[Mijae]

When will the next version come out Bytsis?

[midnightz]

Hi I need a little help, a friend of mine installed this and I seem to missing some things like user cp pulldowns and etc.. I will gladly PAY someone to take a look at the installed hack since its on my LIVE board and fix what is necessary. I have mother in law duties I can't escape and really could use the help. It seems that my main two things are.

1 - I have no battle fields show up (in cp its a red x) and etc..

2 - and see attached image.

any help would be awesome, but I don't mind hiring somebody to double check this great script and make sure all is ok

Thanks,

Midnightz & Amy

[DarkDraco07]

check your pm

[LangTuDaTinh]

PROBLEM /W DONATION

please fix the script

in getinfo template

file $post[userid] , change it to $userinfo[userid]

[LangTuDaTinh]

how can i determine bluff number for each item?

and how does it work?

should i put a number only or a - (minus) or + (plus) sign before the bluff number??

what if i buy more than 3 items??? the first item will be lost and what will happen to my money?

[roninuta]

Is anyone else having a problem editing the defaulted (pre-installed) classes?

I can see them just fine in phpmyadmin and can edit them too. The edits I make in the DB work just fine, but in the admin cp, when I select Edit Classes, only the classes I have added to the table show up and are editable.

If I remove my own classes and just leave the defaulted ones in there the list show onlythe button to update classes.

I'm sorry that I don't havea screen shot for you, this terminal seems to not want to cooperate with me right now.

Also I (so far) have only gotten additional item categories to work in personal item shops. I set one up for spells and the option to use it in battle was not available (even when buffer was set and item was equipped).

BTW - this is a great hack - my users are already begging me to turn it on.

[roninuta]

nevermind - I'm an idiot. My type table was empty - I created a new class type - it defaulted to ID4, all my generic types are ID0, I changed my "new" generic from 4 to 0 and wham - all fixed.

Hope that helps others.

[engquist]

well, I note that this support thread is 106 pages long so it must mean that many issues have been resolved/fixed.

I have a new board running VBulletin 2.3.0

Can someone tell me if this hack is fairly stable if I competently follow all the directions? (I'm not asking for a guarantee, just your opinions)

in other words, would anyone go as far as to classify this is almost "no longer beta"

do a lot of you run 2.3.0 and have it working completely fine?

[Zalastri]

Certain unscrupulous users on my forums are cheating.... wagering money they do not have and then getting some kickback... My forums went from 400+ posts a day to less than 20 because of all of the cheaters (Forums are based off of your hack, battling and roleplaying.). Please help

[Bitsys]

05-02-03 at 05:51 AM SM Tengu said this in Post #1541 (https://vborg.vbsupport.ru/showthread.php?postid=390360#post390360)
I made a very small add-on that makes the hack even more RPG like.

If you fight a high level opponent it would make sense if you gained more experience than if you fight a low level opponent. So what this hack does is simply to multiply the experience-factor that you set for winning the battle with the opponents level.


Open battleupdate.php and find:
-------

if($battleopt[givewinexp] == 1 && $battleopt[expperwin] > 0) {
if($battle[winnerid] > 0)
$DB_site->query("UPDATE user SET xp=xp+$battleopt[expperwin] WHERE userid='$battle[winnerid]'");
}

-------


And replace with:
-------

if($battleopt[givewinexp] == 1 && $battleopt[expperwin] > 0) {
if($battle[winnerid] > 0)
$DB_site->query("UPDATE user SET xp=xp+($opponentlevel*$battleopt[expperwin];) WHERE userid='$battle[winnerid]'");
}

-------

Very simple hack, but it can prevent some abuse of the fighting system. For example the so called Bottom-feeding.

Perhaps this could be included in the next update? Personally, I think it would make more sense than the current system =)



Bitsys, would it be possible to make different forums gain you a different amount of creds and exp? I've made a raw code hack now, but I have to alter it through the code instead of the admin panel.

For example, I want my users to gain more experience and credits for posting in a serious forum such as "Forum Suggestions". And less if they use "General Discussions".

Perhaps implent a multiplier in the Forum Moderation-system.
Nice add-on :)

As far as the forum-specific creds and exp goes, I thought about that a while ago but decided against it because I am very reluctant to add another 2 database fields to the `forum` table.

Overall, if such a feature were implemented then it would greatly improve the quality of posts, eh? I am tihnking about it.

05-02-03 at 11:31 AM Sun Boy said this in Post #1542 (https://vborg.vbsupport.ru/showthread.php?postid=390466#post390466)
Hi,

this's a nice hack

1. when i go to the itemshop and then click on bank nothing change, i am still in the itemshop
Are you using Lesane's Store Points for the monetary system? If so, then the bank will not work. Ooops, I see that flame answered your question. Nevermind :)

05-02-03 at 11:31 AM Sun Boy said this in Post #1542 (https://vborg.vbsupport.ru/showthread.php?postid=390466#post390466)
2. i don't want to fight a user, i want to add a battle room without a password and any user can come and fight me , can i do that ?

sorry 4 my bad english ;)

thanks, :)
Sun Boy :cool:
Hmm, I don't think that is currently possible. That is an interesting idea though.

05-03-03 at 02:54 AM Me! said this in Post #1544 (https://vborg.vbsupport.ru/showthread.php?postid=390760#post390760)
Thank you for your response. I went into php my admin and checked and the rpg_ tables do exist and each one has data in it. Maybe I should try a fresh install again?


Yes, but this time make sure you either give write access to the folders where the backups are stored, or disable the backups altogether. That will make it easier to see if any other errors occured.

05-04-03 at 10:22 AM Ryoku said this in Post #1547 (https://vborg.vbsupport.ru/showthread.php?postid=391217#post391217)
dont mean to double post but can i install this hack manualy ?


You can, but it took me 3 hours when I did it the first time. After that, I went with vbhacker.

05-04-03 at 06:56 PM GaleForce said this in Post #1550 (https://vborg.vbsupport.ru/showthread.php?postid=391520#post391520)
Too many pages to check... Will there every be individual instructions for installing this hack if you already have one of the parts installed? (I have the Itemshop already)


Unfortunately, the database tables and php files for the itemshop hack have been changed drastically from the original version and providing instructions for upgrading would be error-prone and difficult.

05-05-03 at 05:17 PM sonic3d said this in Post #1554 (https://vborg.vbsupport.ru/showthread.php?postid=391919#post391919)
ur right. when i read the manual and it said "Should usually be kept within 1 and 10", didn't realize it said it SHOULD.

thanx for replying.

l8er
sonic


Wow, someone read the manual. I'm impressed ;)

05-05-03 at 05:30 PM Link14716 said this in Post #1555 (https://vborg.vbsupport.ru/showthread.php?postid=391922#post391922)
I also had this problem. Here is how I fixed it.

In battleupdate.php...
Find: $posts = $DB_site->query("SELECT * FROM battle_posts WHERE battlenumber='$battle[battlenumber]' ORDER BY battleactionid"); Replace With: $posts = $DB_site->query("SELECT * FROM battle_posts WHERE battlenumber='$battle[battlenumber]' ORDER BY battleactionid ASC");
Thanks, will be fixed in the next version.

05-05-03 at 11:55 PM Davey said this in Post #1558 (https://vborg.vbsupport.ru/showthread.php?postid=392059#post392059)
Is there any reason the attack seems to stay at 10 no matter what you do?
I really am having trouble understanding that aspect of the battle system.
On another note, the 'level' is not shown in the battle screen.

Dave.


Like SM Tengu said, as lower levels it isn't very noticeable. However, there is a +- 25% damage difference built in.

05-07-03 at 12:50 PM Sun Boy said this in Post #1567 (https://vborg.vbsupport.ru/showthread.php?postid=392782#post392782)
Hello,

it's work good now

but i have some bugs

1. i have install this hack with Store hack, the post count if the user post the post number 1 for him it still on 0

2. same thing in the money, if user post a rplay number 1 for him the money conut say he have 2 Gil, re-download the page then it say he have 5 Gil and still on 0 post !!

Could you please elaborate on both issues? I am having trouble understanding where the post count / money count is located (which php file) and the specific aspects of the user in question. Are you saying this use has no posts or 1 post or what?

05-07-03 at 04:26 PM Davey said this in Post #1569 (https://vborg.vbsupport.ru/showthread.php?postid=392860#post392860)
Is it possible to let admins edit stats?
I'm talking about STR, MAG, etc., not HP.

Dave.


Those stats are calculated on the fly and are not stored in the database therefore it is impossible to change them and have the changes stay.

05-10-03 at 11:01 AM v0id said this in Post #1570 (https://vborg.vbsupport.ru/showthread.php?postid=393340#post393340)
When will the next version come out Bytsis?

Not sure :(

Yesterday at 05:38 PM LangTuDaTinh said this in Post #1575 (https://vborg.vbsupport.ru/showthread.php?postid=393911#post393911)
PROBLEM /W DONATION

please fix the script

in getinfo template

file $post[userid] , change it to $userinfo[userid]


Is that code from the Member Profile Add-on? If so, then it will be fixed in the next version. If not, then let me know.

Yesterday at 06:10 PM LangTuDaTinh said this in Post #1576 (https://vborg.vbsupport.ru/showthread.php?postid=393919#post393919)
how can i determine bluff number for each item?
Experiment with different values. All boards are different and it all depends on how much experience you give your users.
Yesterday at 06:10 PM LangTuDaTinh said this in Post #1576 (https://vborg.vbsupport.ru/showthread.php?postid=393919#post393919)
and how does it work?
Search this thread for "battle formula".

Yesterday at 06:10 PM LangTuDaTinh said this in Post #1576 (https://vborg.vbsupport.ru/showthread.php?postid=393919#post393919)
should i put a number only or a - (minus) or + (plus) sign before the bluff number??

Don't worry about the + or -, just put an integer value in the field.

Yesterday at 06:10 PM LangTuDaTinh said this in Post #1576 (https://vborg.vbsupport.ru/showthread.php?postid=393919#post393919)
what if i buy more than 3 items??? the first item will be lost and what will happen to my money?
You will get refunded the appropriate amount of money for the item that is replaced. To determine how much an item will give you if you sell it back, check the Refund column for taht particular item.

Today at 02:14 PM engquist said this in Post #1579 (https://vborg.vbsupport.ru/showthread.php?postid=394208#post394208)
well, I note that this support thread is 106 pages long so it must mean that many issues have been resolved/fixed.

I have a new board running VBulletin 2.3.0

Can someone tell me if this hack is fairly stable if I competently follow all the directions? (I'm not asking for a guarantee, just your opinions)

in other words, would anyone go as far as to classify this is almost "no longer beta"

do a lot of you run 2.3.0 and have it working completely fine?


It is fairly stable. Once any install issues are fixed, there are usually no other problems that occur. Right now, I am working on fixing bugs.

Today at 02:31 PM Zalastri said this in Post #1580 (https://vborg.vbsupport.ru/showthread.php?postid=394214#post394214)
Certain unscrupulous users on my forums are cheating.... wagering money they do not have and then getting some kickback... My forums went from 400+ posts a day to less than 20 because of all of the cheaters (Forums are based off of your hack, battling and roleplaying.). Please help


Although I may not have stated it before, it has always been my opinion that a hack can not be the basis for a forum. It is the people that form the community that will ultimately determine the fate of one's board. If you could provide some more details as to how these people were cheating then that would be great.


My absence from this thread can be partly attributed to my role as a Beta Tester for Star Wars Galaxies. Due to circumstances beyond my control, I am unable to play that game for an unnspecified amount of time. This means that I can spend more time working on the hack again.

[LangTuDaTinh]

my users cheated by create another username and fight with zero $..so their stats gain so fast because of winning...

i don't care about this. we play this for fun...losing or wining is no matter...

great hack...

if user able to add more items that would be great....but this will be require to rewrite nearly the whole hack.

also i woulld like to request a feature... where member can loan money from the system or other members with interest...hight interest from the system..but lower interest from other members.

[midnightz]

Hi all,

I have one lingering issue with a DB error

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT storep FROM user WHERE userid=
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

Date: Tuesday 13th of May 2003 01:54:38 AM
Script: http://www.digikitten.com/forums/forums/itemshop.php
Referer: http://www.digikitten.com/forums/itemshop.php?action=donate&user

I also can't find a bank that will work, any leads please on a working bank.

We got this on install of the bank but it seems that the double forums / somewhere is the cause.

Invalid SQL: ALTER TABLE user ADD money SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
mysql error: Duplicate column name 'money'

mysql error number: 1060

Date: Monday 12th of May 2003 06:18:17 PM
Script: http://www.digikitten.com/forums/forums/admin/install_bank.php?s=&action=db
Referer: http://www.digikitten.com/forums/admin/install_bank.php

----------------------------

Thank you all, this is a great hack, its alot of fun and we are loving it

Amy and midz

[PixelFx]

*Beta Tester for Star Wars Galaxies*
Drools.... still waiting .. grombles...

as for RPG system, if you need a beta tester, I'm totally up for ripping my forum to streads to fix anything ;) that needs testing...

[midnightz]

Ok,

I fiquired out the donate sql error and it works with no DB error :1604

I have a few questions I hope somebody can help with, some or quite well might sound dumb :?

1 - When i'm in my RPG CP I can donate now, but it only brings up amount and anonomous with submit box. Who am I donating to? I can't specify a user. and if I do it directly from the RPGCP the popup box is too small to display correctly

2 - I have Lesanes store hack in but the I was told a bank will not work with Lesanes hack point system. When i try to when I click money inpocket and money in bank I get a screen with my name and the Give points to midnightz
Give points to midnightz - Points to give - pop up?

What bank should I use, or can it work with Lesanes somehow, i'm open for all ideas. :)

3 - I have been told by numerous people that have popup pm activated, including myself that the pop up PM does not appear, is it best to use a pm bar blinking hack and can the name of delted user that appears in the PM be changed to lets say "battle lord" or something different.

This is the addition hack I will be adding to my board, except for a skin to end all skins (hehe).

I am currently working on a enhanced pet hack for the battle with a friend that will have 50 very extreme and strange pets all with super definition (excited).

But before I jump into that I need some basic info like the questions above.

thanks so much, have a good one,

midnightz & Kitten

:)

[midnightz]

Ok, I take that back I used the fix for a template and now my entire db is going nuts. I love this hack, but I might have to dismiss it

mysql error number: 1064 all over every post thread and all, :( damn!

[midnightz]

Ok,

sorry for all the posts, I had by entire board failing, I turned back on lesanes point system and the DB failures stopeed. The RPG point system was causing damage. I think it might be time to hire a pro here and fix all this, I'm annoyed... atm

But happy its not erroring

help lil old me - I'm a designer and just a novice coder

[LangTuDaTinh]

1 - When i'm in my RPG CP I can donate now, but it only brings up amount and anonomous with submit box. Who am I donating to? I can't specify a user. and if I do it directly from the RPGCP the popup box is too small to display correctly

i removed this link from there.

i don't like the current itemshop , i want unlimited weapons (or items) if user want to buy instead of 3 or 4...but that will require to change the whole table and the way the battle work.

[LangTuDaTinh]

there are so many NOT WORKING features in this hack since it's beta....but i must say ..it 's still a great hack...i will list all of them and a fix for them....kekeeke i will fix those small things...so the author will have more time to add more features for this hack..kekkeek

[kevinnguyen]

05-12-03 at 12:10 AM LangTuDaTinh said this in Post #1575 (https://vborg.vbsupport.ru/showthread.php?postid=393919#post393919)
how can i determine bluff number for each item?

and how does it work?

should i put a number only or a - (minus) or + (plus) sign before the bluff number??


what if i buy more than 3 items??? the first item will be lost and what will happen to my money?


u can only buy 1 item in each cate (e.g. 1 weapon, 1 armor, 1 accessory)

[midnightz]

Yesterday at 10:52 PM LangTuDaTinh said this in Post #1588 (https://vborg.vbsupport.ru/showthread.php?postid=394880#post394880)
there are so many NOT WORKING features in this hack since it's beta....but i must say ..it 's still a great hack...i will list all of them and a fix for them....kekeeke i will fix those small things...so the author will have more time to add more features for this hack..kekkeek

Yes very true I noticed, if the authors need some funding to finish this hack, I would contribute to the completion of a 100% error free hack. I can also test it on my Mac platform as well, and I'm glad to help.

This hack needs to become full grown, its awesome

midz

[roninuta]

It works great on the OSX platform both Server (which mine is running on an Xserve colocated) and the client (no problems in classic or OSX).

I'm very happy with the hack.

[midnightz]

I have both a Xserve (mine) and a PC running linux (leased) (and from Texas as well)

You have no problems with donation and other features? Which version of OSX server are you running? I might switch this site to that server.

Is it maybe a LINUX REDHAT thing?

Like I said, my wife loves it and we will pay for its perfection, so it runs on my board :)

Good to see a fellow mac user - I love my Xserve =) Just got it

[MindTrix]

I checked out the screenies in like the 2nd post and it looks amazing, but i saw there was a hell of a lot of options and weapons etc etc etc. Are these easy to edit? I run a rap board and would like to change everything to suit it. So like weapons could be guns and knifes etc etc, and potions etc would be drugs and booze ya get the drift lol. Just wondered b4 i attemted to make my brain work and install this beauty

[roninuta]

Today at 11:35 AM midnightz said this in Post #1592 (https://vborg.vbsupport.ru/showthread.php?postid=395041#post395041)
I have both a Xserve (mine) and a PC running linux (leased) (and from Texas as well)

You have no problems with donation and other features? Which version of OSX server are you running? I might switch this site to that server.

Good to see a fellow mac user - I love my Xserve =) Just got it


Well I honestly haven't tried to donate anything yet. The store donation works but the battle donation doesn't work yet - I am going to just redirect to the store donation if possible. I know that's not a solution but it should work.

I had some problems related to the ID numbers in my tables but that got worked out with some well placed echo statements.

[roninuta]

Today at 12:54 PM MindTrix said this in Post #1593 (https://vborg.vbsupport.ru/showthread.php?postid=395078#post395078)
I checked out the screenies in like the 2nd post and it looks amazing, but i saw there was a hell of a lot of options and weapons etc etc etc. Are these easy to edit? I run a rap board and would like to change everything to suit it. So like weapons could be guns and knifes etc etc, and potions etc would be drugs and booze ya get the drift lol. Just wondered b4 i attemted to make my brain work and install this beauty


It is mondo simple to edit the items. Hell at this point I've gone edit crazy myself. I have them in about 8 categories including admin equipment (it's good to be the king). I added a musket, a blackpowder pistol, and bows for the archer class.

It really is simple - just make sure that the ID numbers are right in your table - that was where I ran into problems.

[MindTrix]

hmmmmmmmmm sounds like it could be a bit complex :(

[midnightz]

I would like to give big props to a few peeps here.

Number one for Bitsys, for helping me get the bugs well under control :) You rock and your a great peep and your hack kicks ass!

To Draco - Man your a great guy as well, and really know this hack from the love you have for it.

Cheers,

Midnightz & Kitten :bunny:

[kevinnguyen]

05-12-03 at 11:51 PM LangTuDaTinh said this in Post #1581 (https://vborg.vbsupport.ru/showthread.php?postid=394302#post394302)
my users cheated by create another username and fight with zero $..so their stats gain so fast because of winning...

i don't care about this. we play this for fun...losing or wining is no matter...

great hack...

if user able to add more items that would be great....but this will be require to rewrite nearly the whole hack.

also i woulld like to request a feature... where member can loan money from the system or other members with interest...hight interest from the system..but lower interest from other members.

to avoid members cheating by this way, i suggest a feature: only allow members that have a specific amount of post to join the battle
that would be great
thanx

[LangTuDaTinh]

hahhahhaha...they still can...it's easy to get that amount of posts in my forum.

as soon as they do..and they just need 1 username...then they can go all the way....hehehe.. ...but no one want to fight /w that person....because they know they gonna lose anyway...that person will soon bored...hehhheeh..

if u want to allow members that have a specific amount of posts to join the battle..then change it in the battle file...the file where member enter to challenge other...add a if and else statment...

[Zalastri]

Well its not the basis... But a major addon. My users will get a newbie and fight them... They will wager lets say 213098243098g gold... Which they dont have. They will OWN the noob.. Then they will get 04398023984098 or however much they wagered gold... which they DID NOT have.. :( People are cheating pretty badly with it.. Heeeelp.. Either a mod that makes it so you have to have the money for wagering... Or a wager limit would be good.

[roninuta]

I have noticed a small bug (maybe a feature?). Editing Item Type defaults some items to Generic (ID0), I have gone into the table and looked (even edited) the vaules. Somehow the default still comes back to include Generic. Maybe I looked at the wrong field.

Anyone know what field item type is associated in the items table? Where this becomes a problem is people being able to purchase items that obviously don't belong to them (although I love the movie Wizards, I don't want all my users with mages having guns).

What script calls this?

Thanks in advance...

[Bitsys]

Today at 07:05 AM Me! said this in Post #1600 (https://vborg.vbsupport.ru/showthread.php?postid=395402#post395402)
One quick question, are spells used in this game? My users are asking me and I can't find the answer XD


Yes. You need to create a new Item Category and set its Battle Type to Spells. After that, you need to add some spells to it and set how much MA they use.

Today at 08:57 AM Zalastri said this in Post #1601 (https://vborg.vbsupport.ru/showthread.php?postid=395436#post395436)
Well its not the basis... But a major addon. My users will get a newbie and fight them... They will wager lets say 213098243098g gold... Which they dont have. They will OWN the noob.. Then they will get 04398023984098 or however much they wagered gold... which they DID NOT have.. :( People are cheating pretty badly with it.. Heeeelp.. Either a mod that makes it so you have to have the money for wagering... Or a wager limit would be good.


This is not supposed to happen. If the user does not have enough money, then the battle screen should tell them that they don't have enough to wager. Can you give me a link to your forums so that I can test this for myself?

Today at 10:04 AM roninuta said this in Post #1602 (https://vborg.vbsupport.ru/showthread.php?postid=395456#post395456)
I have noticed a small bug (maybe a feature?). Editing Item Type defaults some items to Generic (ID0), I have gone into the table and looked (even edited) the vaules. Somehow the default still comes back to include Generic. Maybe I looked at the wrong field.

Anyone know what field item type is associated in the items table? Where this becomes a problem is people being able to purchase items that obviously don't belong to them (although I love the movie Wizards, I don't want all my users with mages having guns).

What script calls this?

Thanks in advance...

The script is itemadmin.php located in the admin folder. Do the items default to Generic even after you set them to another value? Or are NEW items defaulting to Generic after you add them? What is the end result that you want the items to do, be Generic or something else?

If you look through itemadmin.php, you may be able to figure it out for yourself if you want to try that.

[engquist]

I have a question before I begin installation of this awesome hack.

1) Will this itemshop interfere in any way with the Lesane Store Hack?

2) This itemshop is only for items which can be used in battle, right?

[roninuta]

Today at 01:10 PM engquist said this in Post #1604 (https://vborg.vbsupport.ru/showthread.php?postid=395496#post395496)
I have a question before I begin installation of this awesome hack.

1) Will this itemshop interfere in any way with the Lesane Store Hack?

No - there is no interefrence. I found it to work quite well.

[2) This itemshop is only for items which can be used in battle, right? [/B]

You can have non-battle items but you can only buy them in the itemshop - they will not show up in the Lesane Store. I have recently added Backpacks and animals of burden - neither of which are useful in battle - just for extra fluff.

[Zalastri]

My forums are www.zalastri.com :)

[engquist]

I am having one issue. My boards run version 2.3.0 and I've tried installing this hack twice just to make sure. both times it installed successfully, but on each occasion, when I go to edit profile in the user CP, all the RPG info appears twice.....once under "required info." and again at the bottom under "additional info."

1) basically I am wondering why?

2) and which category is it supposed to be under?

3) and how can I fix it if it's not supposed to be this way?

[CCGENERAL]

when you add a class it does not show up in the profile but not on the class options in the admin cp

[engquist]

(my last question still is unanswered)

I have one more question:

4) In the postbit template, I have $rpname displaying N/A and $rpcash showing my character name

see it at: http://rom.gloriousff.com/forums2/showthread.php?s=&threadid=1

edit:
I figured out why, it was because I had to go to Battle edit options and change the RPG name field from 6 to 5...

and I had to change the item edit options point field from field5 to field6

but.......

after I did this, I kept getting database errors when trying to click my "donate" link in the postbit.

so, I found out why....there is no "field6" that then existed in the userfield table, so I created it and now I get no more errors..

so I guess that when an admin changes those values like I did, they will get similar errors and that's how I fixed it...

the only problem I have for now is duplication of all RPG fields in the user CP profile. One set appears in the "Required" fields, and the other in "optional" info....I am running VBulletin 2.3.0

[lioncool1589]

i cant find bank interest in control panel how do i change percent bank interest 10% too much i want to change to 2%

[engquist]

I first got this error when trying to reply to a thread I created on my test board:

Parse error: parse error, unexpected $ in /home/gloriou/public_html/rom/forums2/newreply.php on line (it was the last line of the code)

but there was no unexpected "$" anywhere near there!

so I cleaned up all the spacing and instead I get this error now:

Parse error: parse error, unexpected T_STRING in /home/gloriou/public_html/rom/forums2/newreply.php on line 198

which is roughly in this small peice of code:

if ($userinfo=$DB_site->query_first("
SELECT user.*,userfield.*
FROM user,userfield
WHERE (username='".addslashes(htmlspecialchars($username))."' OR
username='".addslashes(eregi_replace("[^A-Za-z0-9]","",$username))."') AND
user.userid=userfield.userid")) {

I notice it is discussing the "userfield" table, maybe it has something to do with my adding the field6 table or something?

I have attached the file...


but for now, it's sleep time! I've been working on this hack for about 14 hours now, I only stopped to see Matrix Reloaded at the movies!

[Lord Man]

Sign Up Points

Can i do that ?, any 1 sign up take 350 points

thx

[Bitsys]

Yesterday at 09:50 PM engquist said this in Post #1608 (https://vborg.vbsupport.ru/showthread.php?postid=395626#post395626)
I am having one issue. My boards run version 2.3.0 and I've tried installing this hack twice just to make sure. both times it installed successfully, but on each occasion, when I go to edit profile in the user CP, all the RPG info appears twice.....once under "required info." and again at the bottom under "additional info."

1) basically I am wondering why?

2) and which category is it supposed to be under?

3) and how can I fix it if it's not supposed to be this way?

See https://vborg.vbsupport.ru/showthread.php?postid=390143#post390143 about half way down.


Yesterday at 09:58 PM CCGENERAL said this in Post #1609 (https://vborg.vbsupport.ru/showthread.php?postid=395627#post395627)
when you add a class it does not show up in the profile but not on the class options in the admin cp


Could you please clarify or explain the problem in a little more detail?

Today at 03:35 AM lioncool1589 said this in Post #1611 (https://vborg.vbsupport.ru/showthread.php?postid=395676#post395676)
i cant find bank interest in control panel how do i change percent bank interest 10% too much i want to change to 2%

https://vborg.vbsupport.ru/showthread.php?postid=300155#post300155

Today at 05:27 AM engquist said this in Post #1612 (https://vborg.vbsupport.ru/showthread.php?postid=395685#post395685)
I first got this error when trying to reply to a thread I created on my test board:

Parse error: parse error, unexpected $ in /home/gloriou/public_html/rom/forums2/newreply.php on line (it was the last line of the code)

but there was no unexpected "$" anywhere near there!

so I cleaned up all the spacing and instead I get this error now:

Parse error: parse error, unexpected T_STRING in /home/gloriou/public_html/rom/forums2/newreply.php on line 198

which is roughly in this small peice of code:

if ($userinfo=$DB_site->query_first("
SELECT user.*,userfield.*
FROM user,userfield
WHERE (username='".addslashes(htmlspecialchars($username))."' OR
username='".addslashes(eregi_replace("[^A-Za-z0-9]","",$username))."') AND
user.userid=userfield.userid")) {

I notice it is discussing the "userfield" table, maybe it has something to do with my adding the field6 table or something?

I have attached the file...


but for now, it's sleep time! I've been working on this hack for about 14 hours now, I only stopped to see Matrix Reloaded at the movies!


Try the attached newreply.php. You were missing a semi-colon around line 197.

Today at 07:27 AM Lord Man said this in Post #1613 (https://vborg.vbsupport.ru/showthread.php?postid=395705#post395705)
Sign Up Points

Can i do that ?, any 1 sign up take 350 points

thx


Some people say they have done this, but I have never done it myself. I recall that they later removed it because people were creating new accounts and donating the money to their main one.


Today at 08:01 AM Me! said this in Post #1614 (https://vborg.vbsupport.ru/showthread.php?postid=395711#post395711)
Is there anyway to disable the giving of money when a person runs from battle? It's a bug that can be exploited. If a person runs I'd rather they just lose 2 exp or something.

Could you explain this bug in detail?

Today at 08:18 AM Me! said this in Post #1615 (https://vborg.vbsupport.ru/showthread.php?postid=395714#post395714)
I think I may have a quick solution as far as the retreat bug is concerned. Now I'm a novice in PHP so please use this at your own risk.

In battleupdate.php find the following lines:

$newmoney = $DB_site->query_first("SELECT bankval FROM items_user WHERE userid='$winnerid'");
$newmoney = $newmoney[bankval] + $battle[wager] * 2;
$DB_site->query("UPDATE items_user SET bankval='$newmoney' WHERE userid='$winnerid'");
} else {
$newmoney = $DB_site->query_first("SELECT storep FROM user WHERE userid='$winnerid'");
$newmoney = $newmoney[0] + $battle[wager] * 2;

In both instances where it says $battle[wager] * 2 remove the "* 2"

Like I said I'm still learning PHP so PROCEED WITH CAUTION heh


Removing the 2 makes it so that the winner only gets refunded his money, instead of getting refunded his money and his opponenets money.

Unfortunately, the battle script is not smart enough to know hwo the battle was won/lost, therefore it would be rather difficult to change the outcome if someone retreats as opposed to someone dying. This is my fault since I did not plan this part properly.

[MindTrix]

c next post (soz board made double post after i got a error)

[MindTrix]

having trouble :( i chmod my files etc etc but some reason it still didnt edit them so now i gotta do it manually, it says

in showthread.php find ---

FROM post
".iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')."
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid

replace with--

FROM post, battle_options, items_options
".iif($forum[allowicons],'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

thennnn it says find---

LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
".iif ($avatarenabled,"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 = '$postid'
");

and replace it with some other code. Thing is its telling me to find the same bit of code there twice, but its givin meh too different things to replace it with. Now i noticed the code that its sayin to find exists twice in that php file, so do i replace the 1st bit of code i find with the 1st one it says to replace, and 2nd with 2nd bit etc etc :S


Heck should i just try the install again?? but only select template parts?? i dont see why it didnt make the changes even tho i chmod the files to 777

[MindTrix]

Hmmm nm now guys, i ran the install again and it worked this time :)

[roninuta]

The script is itemadmin.php located in the admin folder. Do the items default to Generic even after you set them to another value? Or are NEW items defaulting to Generic after you add them? What is the end result that you want the items to do, be Generic or something else?

If you look through itemadmin.php, you may be able to figure it out for yourself if you want to try that. [/B]

Thanks for the reply Bitsys!

When I setup an item (additem type and add item) I want to change the type defaults. Most items change over just fine to new types. Some of the items would remain generic and some should not be available to generic. When I set them to other types the new values do take and are inserted into the DB just fine - but the generic type stays even when de-selected. I will look through the script and see what I can find

[MindTrix]

These little figures etc, i got ones that are more Rap Suited, but they face forward. If i shrink em to the other ones sizes can i use em in this???

[Jagang]

04-17-03 at 07:01 PM Jagang said this in Post # 1495 (https://vborg.vbsupport.ru/showthread.php?postid=383591#post383591)
In the Battle table, the field battlekey is blank even though I set a password. If it helps I am running MySQL 3.23.41


[i]04-21-03 at 03:07 AM Bitsys said this in Post #1504 (https://vborg.vbsupport.ru/showthread.php?postid=384914#post384914)



in battlefight.php, find:


If($battleopt[privacy] != 0 && $battle[battlekey] != $battlekey) {

eval("dooutput(\"".gettemplate('battle_badroom')."\");");
exit;
}

and change it to:
/*If($battleopt[privacy] != 0 && $battle[battlekey] != $battlekey) {

eval("dooutput(\"".gettemplate('battle_badroom')."\");");
exit;
}*/
That will temporarily fix the problem by disabling the password check. This means that battles will be open to everyone.



This did not work and I am still getting the same error. Invalid battle or password It is not populating a password in the database and the PMs send a link to /battlefight.php?action=enterbattle&battlenumber=23&battlekey=

Public or private battle settings make no difference. I can manually start the battles in the CP by entering a password there or by setting the battle state to 1 and the rest of the battle works fine but without the automation of starting battles the battle system is useless. Any other suggestions?

[MindTrix]

Dont spose people have images they have made for this they feel like sharing? Pleaseee lol

[Jagang]

Yesterday at 11:29 PM MindTrix said this in Post #1623 (https://vborg.vbsupport.ru/showthread.php?postid=395882#post395882)
Dont spose people have images they have made for this they feel like sharing? Pleaseee lol

Try http://www.rpgicons.com/ they have some good images to use for the classes and items.

[MindTrix]

Thanks for the link, mucho appreciatoo or somet :s

Errm that sites cool but its mainly well its all RPG stuff, which i guess makes sense, but i was kinda lookin for mini pics of weapons and otehr stuff. Basically i need to get some mini gun pictures, weed, al that kinda stuff

[LangTuDaTinh]

Today at 01:58 PM Jagang said this in Post #1622 (https://vborg.vbsupport.ru/showthread.php?postid=395857#post395857)
This did not work and I am still getting the same error. Invalid battle or password It is not populating a password in the database and the PMs send a link to /battlefight.php?action=enterbattle&battlenumber=23&battlekey=

Public or private battle settings make no difference. I can manually start the battles in the CP by entering a password there or by setting the battle state to 1 and the rest of the battle works fine but without the automation of starting battles the battle system is useless. Any other suggestions?


in battle.php, change all $key to $key1

and in battle_newbattle (or something like it)...change key to key1..

this would fix it.

problem: somehow after the file battle.php include global.php, the key is lost. it will set back to blank.

i installed this hack by copy and paste (no vbhacker) and i have no problem...

[engquist]

quote:
Yesterday at 09:50 PM engquist said this in Post #1608
I am having one issue. My boards run version 2.3.0 and I've tried installing this hack twice just to make sure. both times it installed successfully, but on each occasion, when I go to edit profile in the user CP, all the RPG info appears twice.....once under "required info." and again at the bottom under "additional info."

1) basically I am wondering why?

2) and which category is it supposed to be under?

3) and how can I fix it if it's not supposed to be this way?



See https://vborg.vbsupport.ru/show...0143#post390143 about half way down.


thanks! This mostly worked except that RPG name is the only field still duplicated...I notice that $customfields must be the variable storing the information for "Biography", "location", "interests", "occupation", and "RPG name"....could you possibly know where the information for this variable is stored so I can edit it to remove the second instance of RPG name which occurs under "Required Information" in the User CP->edit profile? Thank you very much for your time Bitsys!

[engquist]

with regard to the error in newreply.php, I downloaded your file attachment (up a few posts ago) for newreply.php and then uploaded it to my web server and when I try to make a post reply I get:

Parse error: parse error, unexpected $ in /home/gloriou/public_html/rom/forums2/newreply.php on line 656

this only happens with the correctly edited newreply.php file, not the regular one that comes with VB 2.3.0 because I have tried both and I get that error with only the edited one.

maybe if I knew all the changes made to newreply.php that were done by vbhacker, I could isolate the problem?

any ideas on how to fix it?

edit:: ignore all of this post, it was an error with my Lesane Store Hack, I didn't correctly edit newreply.php with that hack!!!

sorry for wasting anyone's time!

[Jing]

some bugs I noticed...

in template modifytemplate:
- 2 $customfields are entered. Simply removing the first one and those related codes below the string will solve double appearance problem when a user modifying profile (which I think is mentioned though I din follow the whole thread)

- instead of $customfields_required, _required is entered in the template. I am not so sure what errors will be generated, but I think it's better to replace it.

Basically the two adjustments fixed the RPG appearing twice problem, as well as a problem where some of the RPG info are shown as "unknown" despite the info are actually configured properly in the admin cp. I am using vb2.3.0 btw.

I hope this helps someone if it hasn't already do so. but if it did, I apologize for not following the thread. :(

[engquist]

some bugs I noticed...

in template modifytemplate:
- 2 $customfields are entered. Simply removing the first one will solve double appearance problem when a user modifying profile (which I think is mentioned though I din follow the whole thread)

- instead of $customfields_required, _required is entered in the template. I am not so sure what errors will be generated, but I think it's better to replace it.

Basically the two adjustments fixed the RPG appearing twice problem, as well as a problem where some of the RPG info are shown as "unknown" despite the info are actually configured properly in the admin cp. I am using vb2.3.0 btw.

I hope this helps someone if it hasn't already do so. but if it did, I apologize for not following the thread.

when I do this, it gets rid of all these fields too though:

Biography:
A few details about yourself
Location:
Where you live
Interests:
Your hobbies, etc
Occupation:
Your job
RPG Name:

but I only want to get rid of RPG name (since it's a duplicate)

[LangTuDaTinh]

have anyone here create a challenge list yet???

for example...a user want to battle...they will add themselves to the list and include a level that they want to challenge...other users can challenge those who are on that list.......if their level is equal or less than the one on that list..?????

this thread is long....

[TheRaven57]

Is there a way to have money given to the participants in a battle automatically? They would have to complete the battle of course so there would be no cheating, but is there a way to do this?

[TheRaven57]

Nevermind, I'm a moron

[Jing]

engguist: if u r viewing the template in preview, those fields won't show. but if you save it, and go to the actual page, you will see that all of the fields you mentioned are listed. :) jsut follow wat i wrote there and u will be fine. :)

[Bitsys]

05-16-03 at 03:58 PM Jagang said this in Post #1622 (https://vborg.vbsupport.ru/showthread.php?postid=395857#post395857)
This did not work and I am still getting the same error. Invalid battle or password It is not populating a password in the database and the PMs send a link to /battlefight.php?action=enterbattle&battlenumber=23&battlekey=

Public or private battle settings make no difference. I can manually start the battles in the CP by entering a password there or by setting the battle state to 1 and the rest of the battle works fine but without the automation of starting battles the battle system is useless. Any other suggestions?

Are you sure that the opponent has confirmed the battle before you are trying to join it?

Yesterday at 03:11 AM engquist said this in Post #1628 (https://vborg.vbsupport.ru/showthread.php?postid=396054#post396054)
thanks! This mostly worked except that RPG name is the only field still duplicated...I notice that $customfields must be the variable storing the information for "Biography", "location", "interests", "occupation", and "RPG name"....could you possibly know where the information for this variable is stored so I can edit it to remove the second instance of RPG name which occurs under "Required Information" in the User CP->edit profile? Thank you very much for your time Bitsys!


Try looking going to the Admin CP->User Proflile Fields->Modify and then remove one of the RPG Name fields, if there are two of them. After that, you have to go back to the Battle Options menu and fix the RPG Name field textbox.

Yesterday at 01:23 PM LangTuDaTinh said this in Post #1632 (https://vborg.vbsupport.ru/showthread.php?postid=396230#post396230)
have anyone here create a challenge list yet???

for example...a user want to battle...they will add themselves to the list and include a level that they want to challenge...other users can challenge those who are on that list.......if their level is equal or less than the one on that list..?????

this thread is long....

No one has done that yet, but it is an interesting idea.

Yesterday at 01:51 PM Me! said this in Post #1633 (https://vborg.vbsupport.ru/showthread.php?postid=396251#post396251)
I've read the manual however I couldn't find anything about allowing users to purchase more then one spell.

Is there anyway I can allow my users to purchase multiple spells, instead of only being allowed to have one at a time?
A lot of people simply create an item category for each type of spell, i.e. Fire Spells, Ice Spells, LIghtning Spells. This usually solves the problem.

Yesterday at 01:51 PM Me! said this in Post #1633 (https://vborg.vbsupport.ru/showthread.php?postid=396251#post396251)
EDIT: ALso can I make it so mods can't give out money? (for example they click on bank or money and can give points without it being taken from their own money, meaning they can give infinate points >.>)

In your mod folder, delete or rename points.php and bank.php.

[PixelFx]

any idea on a tenative date for the next beta release of this rpg system? I'm wondering if I should install 66 again or wait, a week for the next week, for the next release for example?

[eXentriC_nova]

I'm having a few truble here.
I cant install the itemshop.
When I tried to install it says database error
Is it really bcoz of database error?
coz the other stuff like battle has no problems.
the same thing happen when I tried to access the healing ground

[Bitsys]

Today at 09:08 AM PixelFx said this in Post #1638 (https://vborg.vbsupport.ru/showthread.php?postid=396679#post396679)
any idea on a tenative date for the next beta release of this rpg system? I'm wondering if I should install 66 again or wait, a week for the next week, for the next release for example?

Not sure right now. I am waiting for something and I don't know when it is coming.
Today at 10:24 AM eXentriC_nova said this in Post #1639 (https://vborg.vbsupport.ru/showthread.php?postid=396702#post396702)
I'm having a few truble here.
I cant install the itemshop.
When I tried to install it says database error
Is it really bcoz of database error?
coz the other stuff like battle has no problems.
the same thing happen when I tried to access the healing ground


What is the error?

[eXentriC_nova]

This is what I get when installing itemshop:
Database error in vBulletin Control Panel 2.3.0:

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

Date: Sunday 18th of May 2003 11:56:12 AM
Script: http://www.theanimeworld.com/testvb/admin/install_itemshop_items.php?action=additems
Referer: http://forum.theanimeworld.com/admin/install_itemshop_items.php?


and this is when accessing healing ground
Database error in vBulletin 2.3.0:

Invalid SQL: SELECT items_user.bankval, userfield.field5 FROM items_user, userfield WHERE items_user.userid='1' AND userfield.userid='1'
mysql error: Unknown column 'userfield.field5' in 'field list'

mysql error number: 1054

Date: Sunday 18th of May 2003 11:57:52 AM
Script: http://www.theanimeworld.com/testvb/heal.php
Referer: http://forum.theanimeworld.com/

I also get this error when accessing a battle

Fatal error: Maximum execution time of 30 seconds exceeded in /home/theanime/public_html/forum/battlefight.php on line 420

any help is greatly apreciated

[Bitsys]

Today at 11:03 AM eXentriC_nova said this in Post #1641 (https://vborg.vbsupport.ru/showthread.php?postid=396727#post396727)
This is what I get when installing itemshop:
Database error in vBulletin Control Panel 2.3.0:

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

Date: Sunday 18th of May 2003 11:56:12 AM
Script: http://www.theanimeworld.com/testvb/admin/install_itemshop_items.php?action=additems
Referer: http://forum.theanimeworld.com/admin/install_itemshop_items.php?


and this is when accessing healing ground
Database error in vBulletin 2.3.0:

Invalid SQL: SELECT items_user.bankval, userfield.field5 FROM items_user, userfield WHERE items_user.userid='1' AND userfield.userid='1'
mysql error: Unknown column 'userfield.field5' in 'field list'

mysql error number: 1054

Date: Sunday 18th of May 2003 11:57:52 AM
Script: http://www.theanimeworld.com/testvb/heal.php
Referer: http://forum.theanimeworld.com/

I also get this error when accessing a battle

Fatal error: Maximum execution time of 30 seconds exceeded in /home/theanime/public_html/forum/battlefight.php on line 420

any help is greatly apreciated

Could you provide me with a detailed account of what you have done so far to install this hack? Did you run install_itemshop_items.php?

[eXentriC_nova]

a detailed account?
I didnt do much.
I just followed the instruction exactly as it says.
Yes I did run install_itemshop_items.php. The error I said before is found when I try to run that script.

EDIT>never mind this prob. I got too many probs with my forum so I just wanna reinstall it back.

[Jagang]

Yesterday at 02:11 PM Bitsys said this in Post #1637 (https://vborg.vbsupport.ru/showthread.php?postid=396658#post396658)
Are you sure that the opponent has confirmed the battle before you are trying to join it?

I'm playing both sides so yes I'm sure.

[Bitsys]

Today at 05:26 AM Jagang said this in Post #1644 (https://vborg.vbsupport.ru/showthread.php?postid=397079#post397079)
I'm playing both sides so yes I'm sure.

Did you try the suggestion at https://vborg.vbsupport.ru/showthread.php?postid=395912#post395912 ?

[you_ands_i]

I have a problem when I create new battle and input the password is '123456', it's say "Please enter a valid password", why ? Can't I fix it ? Who can help me ?

[Bitsys]

Today at 08:34 AM you_ands_i said this in Post #1646 (https://vborg.vbsupport.ru/showthread.php?postid=397115#post397115)
I have a problem when I create new battle and input the password is '123456', it's say "Please enter a valid password", why ? Can't I fix it ? Who can help me ?



In battle.php, find:
If($key == "" || !isset($key)) {
$message = "Please enter a valid password.";
eval("dooutput(\"".gettemplate('battle_userinbattle')."\");");
exit;
}

and change it to:

/*If($key == "" || !isset($key)) {
$message = "Please enter a valid password.";
eval("dooutput(\"".gettemplate('battle_userinbattle')."\");");
exit;
}*/

[Jagang]

Today at 02:32 PM Bitsys said this in Post #1645 (https://vborg.vbsupport.ru/showthread.php?postid=397113#post397113)
Did you try the suggestion at https://vborg.vbsupport.ru/showthread.php?postid=395912#post395912 ?


Yes still having same issue. Really I'd like to strip the whole password system out since i really have no need of it and all it is doing is causing me problems.

Edit Update: To get the Key to Key1 suggestion to work I had to go back and uncomment the lines you previously had me comment out. now it is indeed populating with a password in the database and the urls. However it does insist you enter a password and won't let you leave that field blank and when trying to get to the battle you get an error like: Fatal error: Maximum execution time of 60 seconds exceeded in /home/virtual/site2/fst/var/www/html/forums/battlefight.php on line 419
Any suggestions?

BTW: line 419 of battlefight.php is
$xv = "itid$nr";

[Sun Boy]

05-16-03 at 04:33 PM Bitsys said this in Post #1616 (https://vborg.vbsupport.ru/showthread.php?postid=395744#post395744)
Some people say they have done this, but I have never done it myself. I recall that they later removed it because people were creating new accounts and donating the money to their main one.

So, Can you make this addon, plase ?

[Spark]

Hi , :)
We have a little problem with this really interessting Hack. When we will select element , race etc. in our profile , it will not saved. We can?t select any Selections , too.
Please help us , we have an demo user for you to look at our problem
http://hang.anime-angelz.de/vbb
Username : test
pass: test

the prob is in the profile and then later in the rpgcp.php
Thx for help

[LangTuDaTinh]

Today at 02:25 PM Spark said this in Post #1650 (https://vborg.vbsupport.ru/showthread.php?postid=397365#post397365)
Hi , :)
We have a little problem with this really interessting Hack. When we will select element , race etc. in our profile , it will not saved. We can?t select any Selections , too.
Please help us , we have an demo user for you to look at our problem
http://hang.anime-angelz.de/vbb
Username : test
pass: test

the prob is in the profile and then later in the rpgcp.php
Thx for help


read the instruction carefully, u missed some codes in member.php. have u edit ur member.php yet...it seems that u have not edited that file yet..

[DarkDraco07]

anyone know how to keep it from displaying battle threads in new post search? i want them to be recorded but not displayed there

[LangTuDaTinh]

Today at 08:23 PM DarkDraco07 said this in Post #1652 (https://vborg.vbsupport.ru/showthread.php?postid=397517#post397517)
anyone know how to keep it from displaying battle threads in new post search? i want them to be recorded but not displayed there



first, get its forumid

second, in search.php

look for if ($action=="getnew") {

about 20 lines below that u will see

$wheresql.=" AND thread.open<>10";

change it to (replace XXXXX with that forumid)

$wheresql.=" AND forumid != XXXXX AND thread.open<>10";

[you_ands_i]

I've already fix "Invalid password" error, but in Private Message the password battle not show and when I click go to Battle, the system show "Invalid Battle Password", why ? fix ?

[Cicada]

just installed it on a test board, no problems, after installing it on a production board, i ran into quite a few -- it does not updae XP with posts;

is tehre any way to:

a) fix this
(EDIT: i think ive fixed it, was in battle optiosn to give users XP per post, duh)


YET, that did not fix the problem :(


b) uninstall teh hack manually

also, i get this error when submitting a new reply:


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

mysql error number: 1054


yet if i hit the back button and submit the reply again, it goes through -- i've added the auto-update stats into the newthread and newreply scripts as per the instructions...

also,

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

mysql error number: 1054



I get that when trying to search for a user to edit in teh admin CP.

i also get

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

mysql error number: 1054


when tryingto donate GP/Points/Gil to a user.

it's also not updating Gil/GP for user posts. :mad:

[LangTuDaTinh]

Yesterday at 11:27 PM you_ands_i said this in Post #1654 (https://vborg.vbsupport.ru/showthread.php?postid=397563#post397563)
I've already fix "Invalid password" error, but in Private Message the password battle not show and when I click go to Battle, the system show "Invalid Battle Password", why ? fix ?

have u change all "$key" in battle.php to "$key1" yet?
also change "key" in battle_newbattle template to "key1". if u do this then u will have no problem...

[Cicada]

Today at 09:52 AM LangTuDaTinh said this in Post #1657 (https://vborg.vbsupport.ru/showthread.php?postid=397583#post397583)
first, where did u get the code for auto update stats for newreply and newthread?

in the new version of this hack, i don't think he use that anymore....

in itemshop > Edit Options >"point field" > change that field id to ur point field id which u can get in Modify from User Profile Fields

do the same for Edit Options from "battle"

but since u are using the old code or something,

to fix this, u need to get the field id from User Profile Fields >Modify,

there are "Points, and "RPG name" , change ALL field6 to fieldxxxxxx (where xxxxxxx is ur RPG name field id) and do the same for ALL field5
which is for "Points"

i downloaded whatever was attatchedto the first post -- where can i get teh newer version/upgrade script for the newest version?

also, the battles are not working :(

[LangTuDaTinh]

oppss i think the code will paste the variable from ur itemshop and rpg setting....so the error look like that

anyway to fix this, do only this

in itemshop > Edit Options >"point field" > change that field id to ur point field id which u can get in Modify from User Profile Fields

do the same for Edit Options from "battle"

note: there are "Points, and "RPG name" , change field6 to fieldxxxxxx (where xxxxxxx is ur RPG name field id) and do the same for field5 which is for "Points"

try to fix this first...then see if "the battle" is working or not

note: i delete my post above to shorter this thread.....eeheh..

[roninuta]

Does anyone know where a good place to start would be if I wanted to setup a class that was admin only? I do not want mods getting to this particular class for testing purposes.

[Cicada]

Today at 09:59 AM LangTuDaTinh said this in Post #1658 (https://vborg.vbsupport.ru/showthread.php?postid=397585#post397585)
oppss i think the code will paste the variable from ur itemshop and rpg setting....so the error look like that

anyway to fix this, do only this




in itemshop > Edit Options >"point field" > change that field id to ur point field id which u can get in Modify from User Profile Fields

i dont understand whete to gt the field ID

[Bitsys]

Yesterday at 03:32 PM Jagang said this in Post #1648 (https://vborg.vbsupport.ru/showthread.php?postid=397321#post397321)
Yes still having same issue. Really I'd like to strip the whole password system out since i really have no need of it and all it is doing is causing me problems.

Did you try what I posted at https://vborg.vbsupport.ru/showthread.php?postid=397117#post397117 ?


Yesterday at 03:49 PM Sun Boy said this in Post #1649 (https://vborg.vbsupport.ru/showthread.php?postid=397337#post397337)
So, Can you make this addon, plase ?

Sorry, I can't do that right now.
Yesterday at 04:25 PM Spark said this in Post #1650 (https://vborg.vbsupport.ru/showthread.php?postid=397365#post397365)
Hi , :)
We have a little problem with this really interessting Hack. When we will select element , race etc. in our profile , it will not saved. We can?t select any Selections , too.
Please help us , we have an demo user for you to look at our problem
http://hang.anime-angelz.de/vbb
Username : test
pass: test

the prob is in the profile and then later in the rpgcp.php
Thx for help

Hi, I visited the board and attempted to log in with the username and password that you provided, but I was not successful. Are you sure that the username and pass you provided to me are correct?

Today at 01:27 AM you_ands_i said this in Post #1654 (https://vborg.vbsupport.ru/showthread.php?postid=397563#post397563)
I've already fix "Invalid password" error, but in Private Message the password battle not show and when I click go to Battle, the system show "Invalid Battle Password", why ? fix ?


Did you turn off private battles in the admin cp?

Today at 03:25 AM Cicada said this in Post #1655 (https://vborg.vbsupport.ru/showthread.php?postid=397577#post397577)
just installed it on a test board, no problems, after installing it on a production board, i ran into quite a few -- it does not updae XP with posts;

is tehre any way to:

a) fix this
(EDIT: i think ive fixed it, was in battle optiosn to give users XP per post, duh)


YET, that did not fix the problem :(


b) uninstall teh hack manually

also, i get this error when submitting a new reply:


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

mysql error number: 1054


yet if i hit the back button and submit the reply again, it goes through -- i've added the auto-update stats into the newthread and newreply scripts as per the instructions...

also,

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

mysql error number: 1054



I get that when trying to search for a user to edit in teh admin CP.

i also get

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

mysql error number: 1054


when tryingto donate GP/Points/Gil to a user.

it's also not updating Gil/GP for user posts. :mad:


Not sure about the first problem, so lets fix the second one and see if it helps. Read https://vborg.vbsupport.ru/showthread.php?postid=331664#post331664 and do the same thing for the Points field.

Today at 03:56 AM Cicada said this in Post #1657 (https://vborg.vbsupport.ru/showthread.php?postid=397584#post397584)
i downloaded whatever was attatchedto the first post -- where can i get teh newer version/upgrade script for the newest version?

also, the battles are not working :(


What error message are you getting?

[Cicada]

Today at 08:43 PM Bitsys said this in Post #1661 (https://vborg.vbsupport.ru/showthread.php?postid=397806#post397806)
Did you try what I posted at https://vborg.vbsupport.ru/showthread.php?postid=397117#post397117 ?

Not sure about the first problem, so lets fix the second one and see if it helps. Read https://vborg.vbsupport.ru/showthread.php?postid=331664#post331664 and do the same thing for the Points field.


What error message are you getting?

that fixed the points updating problem, but i still cant figure out why it doesnt update XP with the posts? I enabled it in the battle optionsto gain XP per post...

BTW,. thank you for hte help with my problem :)

[Bitsys]

Yesterday at 05:24 PM Cicada said this in Post #1662 (https://vborg.vbsupport.ru/showthread.php?postid=397899#post397899)
that fixed the points updating problem, but i still cant figure out why it doesnt update XP with the posts? I enabled it in the battle optionsto gain XP per post...

BTW,. thank you for hte help with my problem :)

How much XP per post are they supposed to be getting?

Yesterday at 08:54 PM Me! said this in Post #1663 (https://vborg.vbsupport.ru/showthread.php?postid=397944#post397944)
Not sure if this was addressed yet but, maybe in another version of this mod you might want to make it verify the user has enough money to match the icrement of the bet made.

A person challenged me to a battle with a wager of 500 gil, However I only have about 200 and it still allowed me into battle.

This is not supposed to be happening. How much money was in your bank account and how much was in your pocket?

[Dribbles]

Is there a way to un-install this hack? I'm mainly concerned with the changes it made to my MySQL database. I seems like there are a lot of things to delete if I have to go in manually with PHPmyAdmin and do it by hand?? Is there an easy list of all the things to delete? thnx

[eXentriC_nova]

I wanna ask how can I make when healing you dont use the money in bank. I wanna to use the money in cash.
Some of my members bugging me thia problem coz them not to get any interest at all.
And also I have this problem. If anyone request a draw and the ppl who are answering to the request accidently click 'submit reply' without choosing yes or no the battle got stuck. The page just refreshes with the option either saying yes to the draw or say no tothw draw. And it goes forever.

[MindTrix]

quick question. Cause im runnin demo battles, its all good, but it seems every punch thats delt always hits. Do they ever miss? and wut about weapons etc? they got some sort of accuracy % ?

[Asso]

OH-MY-GOD! it' a GREAT hack and i'm waiting for this since 2001! THANKS! I'll support you forever!

[sonic3d]

is there a way to change the defense.

like if the buff of the shield is like 5000 and the person who attacked you with a sword has a buff of 5250, then the attack will only do 250 damage. i like this way instead, a lot better.

l8er
sonic

[MindTrix]

Has anyone else noticed how there is 112 pages now of errors, and then the solutions for possibly the greatest and most wanted hack in VB history lol. Im surprised some of VB's best hackers aint lent a hand. Ne wayz i jus wanted to point out that Bitsy has dun a amazing job here and not once has he/she gave a nasty reply or useless reply. he/she has answered everyones questions and comments amazingly and i think everyone should get on their knees and pray to our new god! lol, im outroz (luv da hack)

[MindTrix]

wait i got a moan lol, people on my site have weapons, yet when battling its telling them they dont have any to use, so they can only use their fists, even tho the weapons are showing under their stats etc :S

[Nefi]

Well it works, and it's real nice. But I have a tiny problem. I used VBHacker to install this, if you wanted to know.

Everytime I go to a thread it would always show empty, nothing ever would show. If anyone has any idea on what this is about, please tell me. A screenshot below to show you an idea how. If you need more information tell me ( i did follow all steps )

[Xziz]

Bitsys, are you working on the final version of this hack? I have a lot of members who ask for new features but if you are going to be upgrading it i'd rather wait until you have the upgrade ready and vb3 is ready to just do a fresh install at that point. If not I will be adding features to it here and there.

[Bitsys]

05-21-03 at 04:41 PM Dribbles said this in Post #1665 (https://vborg.vbsupport.ru/showthread.php?postid=398227#post398227)
Is there a way to un-install this hack? I'm mainly concerned with the changes it made to my MySQL database. I seems like there are a lot of things to delete if I have to go in manually with PHPmyAdmin and do it by hand?? Is there an easy list of all the things to delete? thnx


There is not an easy way at the moment, as stated in the first post. If you search this thread, you can come up with a couple of ways I have described before. Quick summary: Delete all tables that were added. Delete the fields added to the userfields and user tables. Manually undo the file edits or restore the backups.

To assist in this process, you can have vbhacker give you a .txt file of how to install the hack. Using this text file, you can do the install in reverse to uninstall it.

05-21-03 at 08:49 PM Me! said this in Post #1666 (https://vborg.vbsupport.ru/showthread.php?postid=398285#post398285)
Hmm I need to test that problem some more and I'll let you know in better detail what's happening

A few minor things I noticed, when someone uses a potion regardless of their gender, it says "he" For example: "MissNegativity used the potion "Yellow Potion" to gain 300 HP. He feels much better now." it's really not a big deal at all, it seems to bug my users and I hear about it all the time XD


Thanks, I found it.

05-24-03 at 03:59 AM eXentriC_nova said this in Post #1668 (https://vborg.vbsupport.ru/showthread.php?postid=399246#post399246)
I wanna ask how can I make when healing you dont use the money in bank. I wanna to use the money in cash.
Some of my members bugging me thia problem coz them not to get any interest at all.
And also I have this problem. If anyone request a draw and the ppl who are answering to the request accidently click 'submit reply' without choosing yes or no the battle got stuck. The page just refreshes with the option either saying yes to the draw or say no tothw draw. And it goes forever.


The first problem is due to the RPG system defaulting to the bank currency instead of cash. I am reluctant to change this because it is more reliable.

The second problem sould have been fixed in the last version. Does the template not have a default option selected?

05-24-03 at 10:40 AM MindTrix said this in Post #1669 (https://vborg.vbsupport.ru/showthread.php?postid=399409#post399409)
quick question. Cause im runnin demo battles, its all good, but it seems every punch thats delt always hits. Do they ever miss? and wut about weapons etc? they got some sort of accuracy % ?


Fists only have a chance of missing if the opponent has armor. Weapons always have a chance of missing, but it is dependent upon the opponents evade, I think. They do not have an accuracy, per se, but they will miss every now and then. Previously, they were missing too much and the battle wasn't very fun.

Yesterday at 01:24 PM sonic3d said this in Post #1671 (https://vborg.vbsupport.ru/showthread.php?postid=399898#post399898)
is there a way to change the defense.

like if the buff of the shield is like 5000 and the person who attacked you with a sword has a buff of 5250, then the attack will only do 250 damage. i like this way instead, a lot better.

l8er
sonic


All formulas are editable in battle.php. Look for
$damagedone = @floor(($weapon[damage] + $regattbonus) * $uelemod * $anger + $bonusattack - $armor - $regdefminus);
and adjust it to your liking.

Yesterday at 05:18 PM MindTrix said this in Post #1673 (https://vborg.vbsupport.ru/showthread.php?postid=399970#post399970)
wait i got a moan lol, people on my site have weapons, yet when battling its telling them they dont have any to use, so they can only use their fists, even tho the weapons are showing under their stats etc :S


Are you sure you assigned a battle type to the weapon categories? To do this, go to the Edit Items Menu and locate a Category Name. Next to the name, you should see an edit link. Click on the link and change the battle type.

Yesterday at 08:02 PM Nefi said this in Post #1674 (https://vborg.vbsupport.ru/showthread.php?postid=400010#post400010)
Well it works, and it's real nice. But I have a tiny problem. I used VBHacker to install this, if you wanted to know.

Everytime I go to a thread it would always show empty, nothing ever would show. If anyone has any idea on what this is about, please tell me. A screenshot below to show you an idea how. If you need more information tell me ( i did follow all steps )


Some of the edits to showthread.php did not work correctly. Send me your showthread.php and I will fix it for you.

Today at 09:57 AM Xziz said this in Post #1675 (https://vborg.vbsupport.ru/showthread.php?postid=400159#post400159)
Bitsys, are you working on the final version of this hack? I have a lot of members who ask for new features but if you are going to be upgrading it i'd rather wait until you have the upgrade ready and vb3 is ready to just do a fresh install at that point. If not I will be adding features to it here and there.


I am extremely close to a final version. However, this hack will not be compatible with vb3 and I don't know if I will update it to be compatible with vb3. I may just make a completely new hack for vb3, but that is doubtful right now (especially since vb3 still isn't out).

[MindTrix]

Thank 4 ya help, it might be the drop down thing u mentioned, but my servers down now so i gotta wait b4 i can check :p

[PixelFx]

Bitsys thanks for all your hard work on this..

[sonic3d]

is ne willing to expand on what this says


$damagedone = @floor(($weapon[damage] + $regattbonus) * $uelemod * $anger + $bonusattack - $armor - $regdefminus);


i know it sats weapons damage plus the atk then does it times the element and anger plus the bonus atk. and it minuses from whose armor and def?

l8er
sonic

[eXentriC_nova]

about my 2nd problem I am using the latest version
and I dont think the template have the default selection selected.

[engquist]

I have another question:

people don't have their money count shown in their postbit (the postbit shows no value whatsoever for their money not even 0) , nor can I donate to them until they've fought a battle, I am using Lesane's store points.....how can I have their money always shown and active even if they haven't fought the first battle?

thank you for your time everyone!

my testing forums are at:

http://rom.gloriousff.com/forums2/

[Bitsys]

Yesterday at 08:07 PM sonic3d said this in Post #1679 (https://vborg.vbsupport.ru/showthread.php?postid=400346#post400346)
is ne willing to expand on what this says


$damagedone = @floor(($weapon[damage] + $regattbonus) * $uelemod * $anger + $bonusattack - $armor - $regdefminus);


i know it sats weapons damage plus the atk then does it times the element and anger plus the bonus atk. and it minuses from whose armor and def?

l8er
sonic

See https://vborg.vbsupport.ru/showthread.php?postid=359314#post359314 for more information.

Today at 12:34 AM eXentriC_nova said this in Post #1680 (https://vborg.vbsupport.ru/showthread.php?postid=400455#post400455)
about my 2nd problem I am using the latest version
and I dont think the template have the default selection selected.


Open the battle_arenadraw template. Find:
<input type="radio" name="charaction" value="drawno">
and change it to
<input type="radio" name="charaction" value="drawno" CHECKED>

Today at 04:46 AM engquist said this in Post #1681 (https://vborg.vbsupport.ru/showthread.php?postid=400495#post400495)
I have another question:

people don't have their money count shown in their postbit (the postbit shows no value whatsoever for their money not even 0) , nor can I donate to them until they've fought a battle, I am using Lesane's store points.....how can I have their money always shown and active even if they haven't fought the first battle?

thank you for your time everyone!

my testing forums are at:

http://rom.gloriousff.com/forums2/


Try putting $post[storep] in place of the other money variable in your postbit template.

There should be no restriction on when you can donate to a user. Are you sure that they have to have completed a battle before you can donate to them? What error message are you getting?

[engquist]

Today at 11:09 AM Bitsys said this in Post #1682 (https://vborg.vbsupport.ru/showthread.php?postid=400620#post400620)

Try putting $post[storep] in place of the other money variable in your postbit template.

There should be no restriction on when you can donate to a user. Are you sure that they have to have completed a battle before you can donate to them? What error message are you getting? [/B]

I have $post[storerep] being used in the postbit already....what's the other variable that you thought I might have previously had? maybe I should try it?


it will do this when I click on donate user:

I click donate user: and here's an example

Verify and choose your action below:
Username wich you want to donate to:
sun2mid

sun2mid have this amount of points on the moment:


Wich action do you want to execute?
Decrease/Increase


it should say: sun2mid have this amount of points on the moment: 0

but there is no number

then I click "increase" and I give 1000

then the screen says:

You Succesfully Donated Points To sun2mid:
You succesfully donated 1000 to sun2mid.
sun2mid have points on the moment

but between the words "have" and "points" should be the number 1000.

it seems that it won't show the amount of points they have until they engage in a battle...if you want to register at my test forum bitsys, I'll give you required access to see the problem yourself:

http://rom.gloriousff.com/forums2/





in other words, if people never choose to battle, they never have any points given to them for posting or anything. I am using VBulletin 2.3.0 and am using Lesane's store points. i have also installed the lesane's lottery addon for the shop.

[Mijae]

Bytsis, I can only hold 4 items at once. Is that normal?

I have a 3 category main itemshop, and there are 3 custom shops made by users, but I only have space to hold 4 items total.

[sonic3d]

how many queries does it add in the showthread?

l8er
sonic

[Xyphen]

I suggest that people who can make addons for this hack start if Bitsys can release the hack as a full version and take it out of Beta status..

[engquist]

how do I do a complete uninstall of this hack, where can i I get a complete listing of all queries that must be undone, and all template edits and additions, and all php file changes? Thank you!

it's a great hack, but there are so many options that I think it's difficult to fix all the bugs and I get too many errors and issues running a new board with VBulletin 2.3.0.

I will wait until all issues have been fixed.

[Mijae]

Sonic3d: it depends on what you add to showthread.php. I have just one query from this hack.

Engquist: using vbhacked that you used to install the hack select "generate html" list or something like that, it will show you all the edits/queries/templates, and you will just have to manually remove everything. There arent that many bugs, I have this hack running under a moderately modified board.

[PSI|Dr-X]

Bytsis, i appreciate if you can make the new version of this beta the sooner possible because this version has alot of bugs...

if anyone has 0.65 contact me plz

[Mijae]

What bugs does it have? My users haven't experienced any yet.

[Bitsys]

05-27-03 at 06:15 PM engquist said this in Post #1683 (https://vborg.vbsupport.ru/showthread.php?postid=400824#post400824)
I have $post[storerep] being used in the postbit already....what's the other variable that you thought I might have previously had? maybe I should try it?


it will do this when I click on donate user:

I click donate user: and here's an example

Verify and choose your action below:
Username wich you want to donate to:
sun2mid

sun2mid have this amount of points on the moment:


Wich action do you want to execute?
Decrease/Increase


it should say: sun2mid have this amount of points on the moment: 0

but there is no number

then I click "increase" and I give 1000

then the screen says:

You Succesfully Donated Points To sun2mid:
You succesfully donated 1000 to sun2mid.
sun2mid have points on the moment

but between the words "have" and "points" should be the number 1000.

it seems that it won't show the amount of points they have until they engage in a battle...if you want to register at my test forum bitsys, I'll give you required access to see the problem yourself:

http://rom.gloriousff.com/forums2/





in other words, if people never choose to battle, they never have any points given to them for posting or anything. I am using VBulletin 2.3.0 and am using Lesane's store points. i have also installed the lesane's lottery addon for the shop.

Is that with the RPG Donate link, or Lesane's Store donate link? If it is an RPG donate link, which one are you clicking?

Yesterday at 10:38 AM v0id said this in Post #1684 (https://vborg.vbsupport.ru/showthread.php?postid=401102#post401102)
Bytsis, I can only hold 4 items at once. Is that normal?

I have a 3 category main itemshop, and there are 3 custom shops made by users, but I only have space to hold 4 items total.


The original itemshop only allows one personal itemshop item in your inventory at a time. So, 3 categories + 1 personal slot = 4 slot total.

Yesterday at 11:56 AM sonic3d said this in Post #1685 (https://vborg.vbsupport.ru/showthread.php?postid=401144#post401144)
how many queries does it add in the showthread?

l8er
sonic


1 query, as stated in the first post.

Yesterday at 03:23 PM engquist said this in Post #1687 (https://vborg.vbsupport.ru/showthread.php?postid=401217#post401217)
how do I do a complete uninstall of this hack, where can i I get a complete listing of all queries that must be undone, and all template edits and additions, and all php file changes? Thank you!

it's a great hack, but there are so many options that I think it's difficult to fix all the bugs and I get too many errors and issues running a new board with VBulletin 2.3.0.

I will wait until all issues have been fixed.


Go to vbhacker. Click on my hack, then at the bottom click on "Generate a text file". Click proceed. It should give you a text file of every single file edit, template edit, and query that was run.

Today at 08:06 AM PSI|Dr-X said this in Post #1690 (https://vborg.vbsupport.ru/showthread.php?postid=401515#post401515)
Bytsis, i appreciate if you can make the new version of this beta the sooner possible because this version has alot of bugs...

if anyone has 0.65 contact me plz


Could you please state the bugs? I think I have most of them fixed, but I want to make sure.

[sonic3d]

ok then, its for sure not this hack that i have a lot of queries in showthread. i think i know what it is though.

l8er
sonic

[Bitsys]

Version 0.67 is done. Check the first post for the new .zip file. Upgrade instructions are included in the upgrade directory.

This is a bug fix version.


Itemshop restocking bug fixed. (The referenced variable was out of scope).
Attempted fix for battle password not validating properly.
Fixed gender message bug in battleupdate.php.
Fixed Edit Item type bug causing item types to default to generic.
Fixed battle_arenadraw template bug causing users to not select an option when drawing.
Fixed usernames with ' bug.
Store points should now display properly in the rpgcp.
The update stats code should now properly take certain variables in to account.


With this version, if you specify non-private battles, then battle creation will not require a valid password.

Also, an item's stock will not reset if it is below the minimum stock value.

An uninstaller is included with this version. If you had problems installing using vbhacker, then the uninstaller will probably have problems too. Look in the UNINSTALL directory for more info.

As always, if you find any bugs or errors, let me know :)

[bharvey42]

Thanks for the update? Any idea if we will see a place to battle monsters?

[Vivi Ornitier]

nice bits.

Though on the first post, u should change the 0.66 to 0.67, u have repeats of 0.66 on the updates.

[Bitsys]

Today at 04:51 PM bharvey42 said this in Post #1695 (https://vborg.vbsupport.ru/showthread.php?postid=401715#post401715)
Any idea if we will see a place to battle monsters?

Not right now :(

Today at 05:28 PM Vivi Ornitier said this in Post #1696 (https://vborg.vbsupport.ru/showthread.php?postid=401737#post401737)
nice bits.

Though on the first post, u should change the 0.66 to 0.67, u have repeats of 0.66 on the updates.

Thanks, fixed.

[kaotic]

Sweet, I've been waiting for this release. :D Do you have any features in mind for future releases? And does this release mean that it's out of beta? Thanks again, Bitsys.

[Mijae]

Edit: oops, there was some error on my side, nevermind.

[Mijae]

Please someone tell me how to make my moderators NOT being able to give users money/hp/mp/pp/ap. Mods are my site are getting nearly billions of cash into the system, as well as battling common members and refilling their own HP/MP during that battle making it unfair.

Please someone make an option to disable this. Or should I just delete the files from the /mod/ folder?

[Bitsys]

Today at 05:39 PM kaotic said this in Post #1698 (https://vborg.vbsupport.ru/showthread.php?postid=401742#post401742)
Do you have any features in mind for future releases?
Not right now.

Today at 05:39 PM kaotic said this in Post #1698 (https://vborg.vbsupport.ru/showthread.php?postid=401742#post401742)
And does this release mean that it's out of beta?

Not yet.

Today at 06:18 PM v0id said this in Post #1700 (https://vborg.vbsupport.ru/showthread.php?postid=401764#post401764)
Or should I just delete the files from the /mod/ folder?

Yup, just delete the files and mods won't be able to do anything.

[PixelFx]

Bitsys,

got the install on 67 done, everything was good as far as I can tell.. everything said successful when I install, however, I'm getting below errors...

Edit Profile:
http://www.shukenja.com/forum/member.php?action=editprofile

for edit character / member profile is there sapposed to be dual information in the setting fields for your character info ? If you set both then it lets you set the character info for your member profile, if you don't, do both sections in your profile, then it won't set the information.

aka in the Registration: Required Information All fields and in the Additional Information fields have dual info...

Next error...

below if I click my own donation button I get the following error (using vbulletin 2.30, rpg system 67)



Database error in vBulletin 2.3.0:

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

mysql error number: 1054

Date: Friday 30th of May 2003 04:04:30 AM
Script: http://www.shukenja.com/forum/forum/itemshop.php?action=donate&user=1
Referer:




I get an error with the healing center,
http://www.shukenja.com/forum/heal.php



Database error in vBulletin 2.3.0:

Invalid SQL: SELECT items_user.bankval, userfield.field5 FROM items_user, userfield WHERE items_user.userid='1' AND userfield.userid='1'
mysql error: Unknown column 'userfield.field5' in 'field list'

mysql error number: 1054

Date: Friday 30th of May 2003 04:29:24 AM
Script: http://www.shukenja.com/forum/forum/heal.php?
Referer: http://www.shukenja.com/forum/index.php?



I've setup a custom welcome panel with links to the different sections of the hack.

http://www.shukenja.com/forum/index.php

Clicking on the item shop link also returns an error page...



Database error in vBulletin 2.3.0:

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

mysql error number: 1054

Date: Friday 30th of May 2003 04:34:40 AM
Script: http://www.shukenja.com/forum/forum/itemshop.php?
Referer: http://www.shukenja.com/forum/index.php



will add more stuff as I find it.. hope it helps...

[Bitsys]

Today at 04:00 AM PixelFx said this in Post #1702 (https://vborg.vbsupport.ru/showthread.php?postid=401915#post401915)
Bitsys,

got the install on 67 done, everything was good as far as I can tell.. everything said successful when I install, however, I'm getting below errors...

Edit Profile:
http://www.shukenja.com/forum/member.php?action=editprofile

for edit character / member profile is there sapposed to be dual information in the setting fields for your character info ? If you set both then it lets you set the character info for your member profile, if you don't, do both sections in your profile, then it won't set the information.

aka in the Registration: Required Information All fields and in the Additional Information fields have dual info...

Just delete the first instance of the duplicate fields in your modifyprofile template. See the middle of https://vborg.vbsupport.ru/showthread.php?postid=390143#post390143 for more info.

Today at 04:00 AM PixelFx said this in Post #1702 (https://vborg.vbsupport.ru/showthread.php?postid=401915#post401915)
Next error...

below if I click my own donation button I get the following error (using vbulletin 2.30, rpg system 67)



Database error in vBulletin 2.3.0:

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

mysql error number: 1054

Date: Friday 30th of May 2003 04:04:30 AM
Script: http://www.shukenja.com/forum/forum/itemshop.php?action=donate&user=1
Referer:




I get an error with the healing center,
http://www.shukenja.com/forum/heal.php



Database error in vBulletin 2.3.0:

Invalid SQL: SELECT items_user.bankval, userfield.field5 FROM items_user, userfield WHERE items_user.userid='1' AND userfield.userid='1'
mysql error: Unknown column 'userfield.field5' in 'field list'

mysql error number: 1054

Date: Friday 30th of May 2003 04:29:24 AM
Script: http://www.shukenja.com/forum/forum/heal.php?
Referer: http://www.shukenja.com/forum/index.php?



I've setup a custom welcome panel with links to the different sections of the hack.

http://www.shukenja.com/forum/index.php

Clicking on the item shop link also returns an error page...



Database error in vBulletin 2.3.0:

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

mysql error number: 1054

Date: Friday 30th of May 2003 04:34:40 AM
Script: http://www.shukenja.com/forum/forum/itemshop.php?
Referer: http://www.shukenja.com/forum/index.php



will add more stuff as I find it.. hope it helps...

Did you run install_itemshop_items.php? If not, then run it. If so, then do the following:

1. Go to your admin panel
2. Go to modify user profile fields
3. Find the Points 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 itemshop options
9. In the point field option put in field# and replace # with the number you recorded in step 7.

Let me know if that helps.

[Mijae]

Thanks Me! Works perfectly. I should have figured it out myself but I didnt even bother checking the files :-\

[kaotic]

(Just thought I'd point something out)

$rpggenderimage = '<img src="{imagesfolder}/gender/female.gif" alt="Male" border="0">';
} elseif($rpguser[rpggender] == "2") {
$rpggendername = "Male";
$rpggenderimage = '<img src="{imagesfolder}/gender/male.gif" alt="Female" border="0">';

The gender gifs and alts were mixed up in rpgcp.php.

[Bitsys]

Today at 11:57 AM kaotic said this in Post #1706 (https://vborg.vbsupport.ru/showthread.php?postid=402020#post402020)
(Just thought I'd point something out)



The gender gifs and alts were mixed up in rpgcp.php.

Oops, thanks!

[Mijae]

Bytsis, in the itemshop categories when you chose "+1 to atk/+1 to def" it doesnt do anything :P

It doesnt even add +1, and the buff wont work either.

Also, can you explain how damage is calculated? Or in which post in this thread can I read about it?

[Mijae]

Also Bytsis, this was posted somewhere on page 158 I believe:


if($battleopt[givewinexp] == 1 && $battleopt[expperwin] > 0) {
if($battle[winnerid] > 0)
$DB_site->query("UPDATE user SET xp=xp+($opponentlevel*$battleopt[expperwin] WHERE userid='$battle[winnerid]'");
}


Is it safe for me to replace your code with that modification?

[PixelFx]

9. In the point field option put in field# and replace # with the number you recorded in step 7.

guess I missed this in the instructions :P works good now, from what I can tell, I'll update this post as I test :) can't wait to add the new art :)

Ok thanks for the modifyprofile info, I'm posting my changed modifyprofile template for those that need a fix for dual fields :)

I think I got more of the bugs worked out of this template :) got rid of the dual posting for the rpg name as well :)

next fun making custom post bit :)

Update: clean install, after making above changes, added custom profile, and custom postbit. just need people to help test. :)

[Bitsys]

Today at 12:13 PM v0id said this in Post #1708 (https://vborg.vbsupport.ru/showthread.php?postid=402026#post402026)
Bytsis, in the itemshop categories when you chose "+1 to atk/+1 to def" it doesnt do anything :P

It doesnt even add +1, and the buff wont work either.
Items with this battle type will add to your attack damage or defense rating as long as you have them in your inventory. Make sure the items have a buff value assigned, or else they won't add anything.

Today at 12:13 PM v0id said this in Post #1708 (https://vborg.vbsupport.ru/showthread.php?postid=402026#post402026)
Also, can you explain how damage is calculated? Or in which post in this thread can I read about it?

https://vborg.vbsupport.ru/showthread.php?postid=359314#post359314

Today at 12:19 PM v0id said this in Post #1709 (https://vborg.vbsupport.ru/showthread.php?postid=402029#post402029)
Also Bytsis, this was posted somewhere on page 158 I believe:


if($battleopt[givewinexp] == 1 && $battleopt[expperwin] > 0) {
if($battle[winnerid] > 0)
$DB_site->query("UPDATE user SET xp=xp+($opponentlevel*$battleopt[expperwin] WHERE userid='$battle[winnerid]'");
}


Is it safe for me to replace your code with that modification?


I don't see a page 158 :( Could you give a link?

Just glancing at it though, that code looks fine.

[Moreliator]

05-29-03 at 10:20 PM Bitsys said this in Post #1694 (https://vborg.vbsupport.ru/showthread.php?postid=401707#post401707)
Version 0.67 is done. Check the first post for the new .zip file. Upgrade instructions are included in the upgrade directory.

This is a bug fix version.




Bitsy, does this version fix the bug where in the Item Admin Panel when you try to add categories over ID 10 it gets confused (I.E. Category ID 12 and 2 mirror each other).

[Mijae]

Ok, I resetted my RPG and now users can use their weapons! They are all selected as generic and stuff, but they just cant select them :P

[Bitsys]

Yesterday at 09:49 PM Moreliator said this in Post #1712 (https://vborg.vbsupport.ru/showthread.php?postid=402190#post402190)
Bitsy, does this version fix the bug where in the Item Admin Panel when you try to add categories over ID 10 it gets confused (I.E. Category ID 12 and 2 mirror each other).

Yes, it should fix that problem.


Yesterday at 10:53 PM v0id said this in Post #1713 (https://vborg.vbsupport.ru/showthread.php?postid=402204#post402204)
Ok, I resetted my RPG and now users can use their weapons! They are all selected as generic and stuff, but they just cant select them :P


So the can or can't use their weapons?

[Mijae]

Here is the attached screenshot of that (small size). What I did was reset RPG and then repopulate the itemshop table with the install_itemshop_items.php and they all got in there, but then it gave me a database error about battle_items table I believe. The whole RPG works but users just cant use their weapons.

Then I deleted category 3 because it was useless since I couldn't get the potions to work in there (no tickbox to make it heal, etc), and then created a new category. Not sure if thats the problem.

I also ran the DB Fix and it did nothing.

[Mijae]

Well, I found out it was the battle_stats table, it doesnt clear when you do the RPG reset.

[Spark]

Hi Girlz :) *g*

I have a problem with the hack.
When i want to choose any RPG Race and RPG Class there isn?t anything. By RPG Alignment i can choose Good or Evil but by RPG CLass and RPG Race there is only "Unknown"

In the attachement is my members.php i hope someone can help me
(Sorry for my bad english, i?m not from Amerika or England )

[Vivi Ornitier]

bits i have a quesoitn. Very very very odd.

I'm really not sure whether this is a battle hack or store hack problem so i'm leavin it to your expert advice.

ANyway

Before like 1 week ago, everyone was gettin gil/store points fine and everythign was happy. But recently, newbies that registerdon't get an gil from posting. It doesnt' even start for them. The place where the gil is supose to go is just balnk. But senior members who registered before that "1 week shift" can still get gil the old way and fine for them.

I checked both store and battle install files and it seems alright but i just want to see if you could help me on this.

Gil doesn't show in postbit, itemshop, bank or anything. You can donate money to the new members but that's it. . . . nothing more. PLEASE PLEASE PLEASE HELP!

[kaotic]

Vivi, you need to make the changes to register.php again. Look at the install text using vBhacker to find the change that you need to make again.

[Vivi Ornitier]

kao: that was the first idea that went thruogh my mind but i looked at the install file and there's just one edit to register.php which is

replace

$userid=$DB_site->insert_id();

with

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

I did that fine.

same thing with store too, one edit, it's all good.

[kaotic]

That's strange. I had the exact same problem, and all I had to do was edit register.php again. Something else I did was take those two queries:

INSERT INTO items_user (userid) VALUES ($userid)
INSERT INTO battle_stats (userid) VALUES ($userid)

I replaced $userid with the ID of each user that had this problem. I can't think of what the problem could be if that doesn't work.

[Vivi Ornitier]

heh i'll try that, but thta would suck if i had to do that for every new member that might register, oh well, i guess i could just put like 1001, 1002, and all the way to like 2000, lol.

But also, if ireplaced userid with just the IDs,what happens to eeryone else? that wasn't included on this userid list

[kaotic]

I'm not sure. :p I gambled with it on my board and everything worked out perfectly. Test it on a new account and see if it works. I'm sure it will, but that still doesn't solve your problem with new registers. Good luck with that.

[Mijae]

Can anyone tell me what query do I have to run to give everyone on my forum $1000 points for the battle arena db table?

And also, what code can I add so every new member who registers start out with a $1000?

[Spark]

Yesterday at 04:20 PM Spark said this in Post #1718 (https://vborg.vbsupport.ru/showthread.php?postid=402498#post402498)
Hi Girlz :) *g*

I have a problem with the hack.
When i want to choose any RPG Race and RPG Class there isn?t anything. By RPG Alignment i can choose Good or Evil but by RPG CLass and RPG Race there is only "Unknown"

In the attachement is my members.php i hope someone can help me
(Sorry for my bad english, i?m not from Amerika or England )


Uhm can nobody help me?

[sonic3d]

Today at 12:00 AM v0id said this in Post #1725 (https://vborg.vbsupport.ru/showthread.php?postid=402724#post402724)
And also, what code can I add so every new member who registers start out with a $1000? [/B]

well for me, this is what i have.

In register.php

find:

$DB_site->query("INSERT INTO userfield $userfieldsnames VALUES ($userid$userfields)");


under it put:

$DB_site->query("UPDATE userfield SET field5=1000 WHERE userid=$userid");


it works for me.

l8er
sonic

[Mijae]

Today at 05:32 AM Spark said this in Post #1726 (https://vborg.vbsupport.ru/showthread.php?postid=402775#post402775)
Uhm can nobody help me?

Go into your Admin Control Panel and then look for in the menu for RPG, there you will see lots of new links that you have to check out.

[PixelFx]

how big or small of a process is to change the currency type from say gil to gold/other?

[007]

Has this hack been updated yet this year? I see that the first post was updated last December....

Has anyone had any big problems with this in 2.2.9? I don't want to wait for it to be a full release... lol

[kaotic]

Are we looking at the same hack? It was just updated a few days ago.

https://vborg.vbsupport.ru/showthread.php?postid=401707#post401707

[007]

Ooops. I'm an idiot. I looked at the post date and not the edited date.

*slaps self*

:ermm: Forget what I said. :) Anyway, how does this work with 2.2.9??

[Mijae]

When I used 2.2.9 it was all good. Now on 2.3.0 it's still working good.

[kaotic]

When I go to "Edit Classes" (via admin cp) and choose to add a class to the female category, the link leads me to add to the male category.

Edit: By the way, I just noticed the original Itemshop was updated to v5.3. I didn't stick around to see what was new, but maybe you should check it out?

[Bitsys]

05-31-03 at 12:17 PM v0id said this in Post #1716 (https://vborg.vbsupport.ru/showthread.php?postid=402386#post402386)
Here is the attached screenshot of that (small size). What I did was reset RPG and then repopulate the itemshop table with the install_itemshop_items.php and they all got in there, but then it gave me a database error about battle_items table I believe. The whole RPG works but users just cant use their weapons.

Then I deleted category 3 because it was useless since I couldn't get the potions to work in there (no tickbox to make it heal, etc), and then created a new category. Not sure if thats the problem.

I also ran the DB Fix and it did nothing.


In the admin cp, go to the RPG Admin manual. In the FAQ, look at the one titled "Q: Why can't I use items in battle? They are always grayed out and it says, "You do not have a "."

[i]05-31-03 at 12:32 PM v0id said this in Post #1717 (https://vborg.vbsupport.ru/showthread.php?postid=402412#post402412)
Well, I found out it was the battle_stats table, it doesnt clear when you do the RPG reset.

Which reset did you do?

05-31-03 at 03:20 PM Spark said this in Post #1718 (https://vborg.vbsupport.ru/showthread.php?postid=402498#post402498)
Hi Girlz :) *g*

I have a problem with the hack.
When i want to choose any RPG Race and RPG Class there isn?t anything. By RPG Alignment i can choose Good or Evil but by RPG CLass and RPG Race there is only "Unknown"

In the attachement is my members.php i hope someone can help me
(Sorry for my bad english, i?m not from Amerika or England )


In the admin cp, does it show that you have more classes/races than just 'Unknown'? Also, when you select a gender, does the rpg class drop-down give you more options than 'Unknown'?

05-31-03 at 06:26 PM Vivi Ornitier said this in Post #1719 (https://vborg.vbsupport.ru/showthread.php?postid=402590#post402590)
bits i have a quesoitn. Very very very odd.

I'm really not sure whether this is a battle hack or store hack problem so i'm leavin it to your expert advice.

ANyway

Before like 1 week ago, everyone was gettin gil/store points fine and everythign was happy. But recently, newbies that registerdon't get an gil from posting. It doesnt' even start for them. The place where the gil is supose to go is just balnk. But senior members who registered before that "1 week shift" can still get gil the old way and fine for them.

I checked both store and battle install files and it seems alright but i just want to see if you could help me on this.

Gil doesn't show in postbit, itemshop, bank or anything. You can donate money to the new members but that's it. . . . nothing more. PLEASE PLEASE PLEASE HELP!

Run DB Fix and tell me what it says.

Yesterday at 01:44 PM PixelFx said this in Post #1729 (https://vborg.vbsupport.ru/showthread.php?postid=402984#post402984)
how big or small of a process is to change the currency type from say gil to gold/other?


Do you mean replacing the word "gil" with "gold", or do you mean designing that currency system you were talking about earlier?

Today at 12:27 AM kaotic said this in Post #1734 (https://vborg.vbsupport.ru/showthread.php?postid=403260#post403260)
When I go to "Edit Classes" (via admin cp) and choose to add a class to the female category, the link leads me to add to the male category.

Just scroll down to the Female classes part. You can either add male classes or female classes from that menu. Each one has a separate submit button.

Today at 12:27 AM kaotic said this in Post #1734 (https://vborg.vbsupport.ru/showthread.php?postid=403260#post403260)
Edit: By the way, I just noticed the original Itemshop was updated to v5.3. I didn't stick around to see what was new, but maybe you should check it out?

I checked it out earlier and I already fixed most of the stuff that I didn't like. The first post says it is 75% faster, but when I read the install file, it looked like it wasn't, so I am not sure. All the functionality that was supposedly added in 5.3 is already in this hack, I think. Let me know if you find something otherwise though, since I just skim read it.

[kaotic]

Alright, thanks. And I'll go ahead and install the new Itemshop just to check it out.

[Mijae]

Bytsis, I did a full RPG reset (I put YES to EVERYTHING) and it did not clear the battle_stats table (I tried twice, both times the data was not erased/dropped).

On a side note: can anyone tell me how to credit users battle arena money for reffering people? I know that with the Store hack (by Lesane) you can set the ammount to give to your users, but since I am a newbie to PHP I am not sure what to do to make it also give you battle arena currency when you reffer someone.

[PixelFx]

Do you mean replacing the word "gil" with "gold", or do you mean designing that currency system you were talking about earlier?

bitsys,

for now just the word from gil to gold

then later the system you and I talked about... the above would be quick fix I hope ;)

Found Error,

When I setup a dual with someone and attack... I hit the attack button and it says the following..

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

[Bitsys]

Today at 04:46 PM v0id said this in Post #1737 (https://vborg.vbsupport.ru/showthread.php?postid=403553#post403553)
Bytsis, I did a full RPG reset (I put YES to EVERYTHING) and it did not clear the battle_stats table (I tried twice, both times the data was not erased/dropped).

The data is not supposed to be dropped, it is only supposed to be reset. By reset, I mean that the fields should be set to 0 (all except the userid field). Did your members' battle stats get reset to 0-0-0-0? Or did they retain their old battle records?

To verify that the table has been reset, you can run this query

UPDATE battle_stats SET battles=0, wins=0, losses=0, draws=0, retreats=0
and compare the data in the table after running the query with the data in the table before running the query.

Today at 05:28 PM PixelFx said this in Post #1738 (https://vborg.vbsupport.ru/showthread.php?postid=403566#post403566)
bitsys,

for now just the word from gil to gold

then later the system you and I talked about... the above would be quick fix I hope ;)
Hmm, I would assume you could do a mass template esit in the admin cp. Replace "gil" with "gold", right? I guess I could go make a list and location of each place where the word "gil" is used, but that seems like too much work for such a simple problem. Have you tried anything yet to switch it?

Today at 05:28 PM PixelFx said this in Post #1738 (https://vborg.vbsupport.ru/showthread.php?postid=403566#post403566)
Found Error,

When I setup a dual with someone and attack... I hit the attack button and it says the following..

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

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.

Let me know if that helps.

[Mijae]

It doesnt reset it. It said it did, but I checked and the data was still there. So I dropped that table, created it again, ran install_itemshop_items.php and run the DB Fix and I got it all working.

[Spark]

Uhm i have a problem
See at the attachement
When i will fight my opponent have o Points everywhere
but see self

[Bitsys]

Today at 12:24 PM Spark said this in Post #1741 (https://vborg.vbsupport.ru/showthread.php?postid=403932#post403932)
Uhm i have a problem
See at the attachement
When i will fight my opponent have o Points everywhere
but see self

Run DB Fix and tell me what it says.

[PixelFx]

seems the hack can't parse names with ' in them,



Database error in vBulletin 2.3.0:

Invalid SQL: SELECT username, hp, rpgrace, rpgclass, rpggender, element, alignment, posts, userid, inbattle FROM user WHERE username='Father's Hand'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Hand'' at line 1

[Bitsys]

Today at 05:54 PM PixelFx said this in Post #1743 (https://vborg.vbsupport.ru/showthread.php?postid=404084#post404084)
seems the hack can't parse names with ' in them,



Database error in vBulletin 2.3.0:

Invalid SQL: SELECT username, hp, rpgrace, rpgclass, rpggender, element, alignment, posts, userid, inbattle FROM user WHERE username='Father's Hand'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Hand'' at line 1



What file is that from?

EDIT: Nvm, I found it in battle.php. See the first post for an updated .zip file with the fixed battle.php.

[PixelFx]

ok thanks :)

[Zalastri]

Any chance of a random event type thing like on neopets? For example.. You can configure events so they have a 1/900 chance of happening. For example.. you could create an event that was like.. "You trip over a tree root and hit the ground with a thud, -5 hp!" Or "You notice a dagger stuck in the tree to the right of you, You pull it out after some struggling, You gained Rusty Dagger!"

Also jobs... Mabye the admin could specify a job.. lets say mining. You could click on the Gold miner job. It brought you to a page with a work symbol on it that you have to click once every ten seconds.. then after 100 clicks a specified action happens.. and random events could be hooked in there too.

Like? :D

[Moreliator]

Will it mess anything up if someone with an '&' in their name tries to play the RPG?

[kaotic]

Today at 02:02 AM Zalastri said this in Post #1746 (https://vborg.vbsupport.ru/showthread.php?postid=404131#post404131)
Any chance of a random event type thing like on neopets? For example.. You can configure events so they have a 1/900 chance of happening. For example.. you could create an event that was like.. "You trip over a tree root and hit the ground with a thud, -5 hp!" Or "You notice a dagger stuck in the tree to the right of you, You pull it out after some struggling, You gained Rusty Dagger!"

Also jobs... Mabye the admin could specify a job.. lets say mining. You could click on the Gold miner job. It brought you to a page with a work symbol on it that you have to click once every ten seconds.. then after 100 clicks a specified action happens.. and random events could be hooked in there too.

Like? :D

lol, I like the ideas. :p They would make a very interesting addition.

[Clive]

is there an uninstaller included? if not, how do I uninstall it?

[Bitsys]

Yesterday at 08:02 PM Zalastri said this in Post #1746 (https://vborg.vbsupport.ru/showthread.php?postid=404131#post404131)
Any chance of a random event type thing like on neopets? For example.. You can configure events so they have a 1/900 chance of happening. For example.. you could create an event that was like.. "You trip over a tree root and hit the ground with a thud, -5 hp!" Or "You notice a dagger stuck in the tree to the right of you, You pull it out after some struggling, You gained Rusty Dagger!"

Also jobs... Mabye the admin could specify a job.. lets say mining. You could click on the Gold miner job. It brought you to a page with a work symbol on it that you have to click once every ten seconds.. then after 100 clicks a specified action happens.. and random events could be hooked in there too.

Like? :D


Sounds interesting.

Yesterday at 08:16 PM Moreliator said this in Post #1747 (https://vborg.vbsupport.ru/showthread.php?postid=404145#post404145)
Will it mess anything up if someone with an '&' in their name tries to play the RPG?


I don't think so, but it couldn't hurt to try it out.

Today at 01:56 AM Clive said this in Post #1749 (https://vborg.vbsupport.ru/showthread.php?postid=404235#post404235)
is there an uninstaller included? if not, how do I uninstall it?


Yes, there is an uninstaller included, but it is definately not guaranteed to remove everything automatically. You may have to do some manual edits.

[Spark]

Yesterday at 05:26 PM Bitsys said this in Post #1742 (https://vborg.vbsupport.ru/showthread.php?postid=404045#post404045)
Run DB Fix and tell me what it says.


Thx this mistake is history
:ermm: But there is a second Mistake that i found
In the fight, i have a weapon , but cant use it.
See self

[Clive]

seeing this thread with 117 pages, I think I'll just ask the question instead of searching if this question has already been anwered =)

about the clans, are the players allowed to make their own clan?

[kaotic]

Kind of...

You can make a new alignment which sort of works like a clan. I think that there is some info about this in your RPG Manual. Check it out.

[TomokiG]

Today at 02:56 PM Spark said this in Post #1751 (https://vborg.vbsupport.ru/showthread.php?postid=404305#post404305)
Thx this mistake is history
:ermm: But there is a second Mistake that i found
In the fight, i have a weapon , but cant use it.
See self

Perhaps you should check your weapons if they have a battle-value (Buff)... ass far I know they are initially set to 0...

?TomokiG?

[Bitsys]

Today at 08:56 AM Spark said this in Post #1751 (https://vborg.vbsupport.ru/showthread.php?postid=404305#post404305)
Thx this mistake is history
:ermm: But there is a second Mistake that i found
In the fight, i have a weapon , but cant use it.
See self


From the first post:
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.


Try doing that ;)

Today at 09:27 AM Clive said this in Post #1752 (https://vborg.vbsupport.ru/showthread.php?postid=404308#post404308)
seeing this thread with 117 pages, I think I'll just ask the question instead of searching if this question has already been anwered =)

about the clans, are the players allowed to make their own clan?


kaotic is correct. There is no native support for clans. However, you can make an alignment for each clan and let the users do it that way.

[Clive]

hmm, just a suggestion =) could you enable regular members to make their own clans? so there will be clan leaders, etc.

that would be very cool =)

[kaotic]

You can try this hack for a clan hack: https://vborg.vbsupport.ru/showthread.php?s=&threadid=51549&perpage=15&display=&pagenumber=1

It isn't integrated with this RPG system, but it works for my site.

[Spark]

I have a little question , again *g*
`There is a Bug with the bank , User can give themself money somuch their want.
Can someone help me ?

[Bitsys]

Today at 01:42 PM Spark said this in Post #1758 (https://vborg.vbsupport.ru/showthread.php?postid=404409#post404409)
I have a little question , again *g*
`There is a Bug with the bank , User can give themself money somuch their want.
Can someone help me ?


Could you explain the process you go through to give yourself money, as a regular user?

The only people that should be able to give themselves money are admins and mods.

[Spark]

@Bitsy
Thx for quick answer. I be surprised of the Support in this forum. :)

But i Have a little question again

I check that weapons , in the One Hand Category, but no weapon hit. Never i ?ve see in a fight that one Weapon hit.
What?s wrong`?

[Bitsys]

Today at 10:33 AM Spark said this in Post #1761 (https://vborg.vbsupport.ru/showthread.php?postid=404761#post404761)
@Bitsy
Thx for quick answer. I be surprised of the Support in this forum. :)

But i Have a little question again

I check that weapons , in the One Hand Category, but no weapon hit. Never i ?ve see in a fight that one Weapon hit.
What?s wrong`?

Did you assign the weapon a buff value greater than 0?

[Spark]

No all Weapons, Spells etc. habe a buff = 0
It must have a greater value?

[kaotic]

Yes, it must be higher than 0...

[Mijae]

Yes, I have it set to 1/5 of the weapon price.

[Clive]

a problem: Some of my forum members bought an itemshop, but their items dont have any use because of the buff. (its 0)

how will I sort it out?

thanks

[kaotic]

Well... you don't. I think it's just there for show. Besides, think of it this way: if your members could actually configure the buff, most of them would give it 1 bill buff, and sell it for maybe 10 points... if that much. :p