vb.org Archive - RPG Integration Hack /w Battle (BETA)

Page 14 of 63

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)

- - RPG Integration Hack /w Battle (BETA) (https://vborg.vbsupport.ru/showthread.php?t=46417)

Xyphen

01-10-2003 02:09 AM

Bitsys, I just upgraded to the new version v.59b and now when I visit someones Profile "GetInfo" it gives this error..

Code:

Database error in vBulletin 2.2.8:



Invalid SQL: 

        SELECT

        user.userid,user.rpgclass,user.element,user.rpgrace,user.alignment,user.rpggender,user.posts,user.maxhp,user.maxma,user.maxpp,user.inbattle,

        user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,

        items_options.pointfield,battle_options.namefield, userfield.*,

        battle_options.usepostcount,battle_options.exprate,battle_options.levelfield,battle_options.privacy AS battleprivacy,

        items_user.*,battle_stats.*,rpg_race.name AS rpgracename,rpg_race.alignment AS rpgalignmentname,rpg_classf.name AS fclassname,

        rpg_classf.folder AS fclassfolder,rpg_classm.name AS mclassname,rpg_classm.folder AS mclassfolder,rpg_element.name AS elename

        FROM user, userfield, items_user, battle_stats, rpg_classf, rpg_classm, rpg_element, rpg_race, battle_options, items_options

        WHERE

        user.userid=10

        AND userfield.userid=user.userid

        AND items_user.userid=user.userid

        AND battle_stats.userid=user.userid

        AND rpg_classf.id=user.rpgclass

        AND rpg_classm.id=user.rpgclass

        AND rpg_element.elementid=user.element

        AND rpg_race.raceid=user.rpgrace

        AND rpg_race.alignmentid=user.alignment

        

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



mysql error number: 1054



Date: Friday 10th of January 2003 05:03:40 AM

Script: http://www.ooforums.net/forums/forum...info&userid=10

Referer: http://ooforums.net/forums/index.php?s=

Bitsys

01-10-2003 02:22 AM

Travis641:
Re-download the .zip file and upload rpg.php to your server. That should fix it.

Davey:
Can you post the errors you are getting?

AViO 07:
Remove the old member profile add-on (it was one file edit), and use the version I am attaching here. Let me know if it doesn't work or if you are still having problems with the new version.

Travis641

01-10-2003 02:35 AM

Yay, thanks alot. Everything works perfect now! =)

mr e	01-10-2003 02:46 AM

well looks like most of the gimongous erros are gone

Mijae

01-10-2003 03:49 AM

My users are level 20+ withing a day (will reset again) and after updating their stats they still show up as 0 in rpg.php

Mijae

01-10-2003 04:00 AM

Also, does anyone have a good formula to calculate the Buff?

mr e	01-10-2003 04:16 AM

https://vborg.vbsupport.ru/showthrea...122#post340122

Quote:

Originally posted by v0id
My users are level 20+ withing a day (will reset again) and after updating their stats they still show up as 0 in rpg.php

mr e	01-10-2003 04:18 AM

do you mean weapons/armor etc?

Quote:

Originally posted by v0id
Also, does anyone have a good formula to calculate the Buff?

Cyclonus888

01-10-2003 04:41 AM

sorry but Im completely new to installing hacks....how do I make a query??

Bitsys

01-10-2003 10:33 AM

Quote:

Originally posted by v0id
My users are level 20+ withing a day (will reset again) and after updating their stats they still show up as 0 in rpg.php

You can adjust the amount of experience it takes to gain a level in the Battle Options menu. Try changing the Power Level Modifier to 1. It will automatically apply to everyone, without people having to update their stats. You can play around with this to get the desired result.

To fix the 0 in rpg.php, redownload the .zip file and re-upload rpg.php to your server.

Quote:

Originally posted by v0id
Also, does anyone have a good formula to calculate the Buff?

I think armor should be less buff than weapons of the same price range, but should also be a little more expensive.

Quote:

Originally posted by Cyclonus888
sorry but Im completely new to installing hacks....how do I make a query??

If you have phpmyadmin, then try reading http://www.vbulletin.com/forum/showt...threadid=18558 Also, if you haven't already read it, I suggest you read https://vborg.vbsupport.ru/showthrea...threadid=39142

However, for a clean install, you shouldn't have to run any queries unless the install script fails to execute some of them.

Xyphen

01-10-2003 10:48 AM

Bitsys, the problem is now fixed, thank you!

PSI|Dr-X

01-10-2003 11:50 AM

I think the full version is comming very soon :D everything is perfect

only the members are SPAMMING to get the coins :P

Mijae

01-10-2003 01:41 PM

Bitsys, any chance of adding more then one potion to inventory? Same with spells? You could probably make this selectable in admin cp if its not hard :P

Graphics

01-10-2003 02:33 PM

This hack looks truely brillant Bitsy. And to be honest I think you should make Firefly change your title to 'Ultimate Hacker'. ;) Anyways, I have a suggestion for it.

I think a stand-alone hack like this has already been made but I was wondering if you could integrate it... It's a hack that allows you to give your members a rank. i.e. General, Leuitenant for exmaple. And then an image or text signifying the members rank would appear in the postbit.

You could also make it so certain members become 'bosses' when they reach a certain level or if they are a Staff member.

I'd appreciate it if you could add these features. :p

over	01-10-2003 02:41 PM

had same problem as "assassingod" with the 30 secs problem on both 2.2.8 AND 2.2.9 however have sorted out a solution, tryin to work out what done to correct so can post to hassassingod him out :)

Quote:

Originally posted by Bitsys
VeoMorphine:
Nope, 2 or 3 tables had new fields added to them.

assassingod:
An easy fix is to comment out the code. Put "/*" before the loop code and "*/" after the loop code. If this doesn't fix the problem, then there is something seriously wrong.

BTW, the loop code begins with

Code:

// Part of the following code comes from a post made by

and ends with

Code:

// End joint fix.

So, you should make it look like

Code:

/* // Part of the following code comes from a post made by

And

Code:

*/ // End joint fix.

Bitsys

01-10-2003 04:06 PM

v0id:
As much as I would like that feature, I believe it would take too long to develop and implement.

Graphics:
That sounds a lot like a clan add-on, right? Each member has a certain rank, with the clan leaders being the bosses?

over:
Does the battle correctly detect weapons in your inventory? Also, does the itemshop work properly?

Mijae

01-10-2003 05:17 PM

Aww, it would be so nice to have that, someone go do eet :P

Mijae

01-10-2003 05:38 PM

Eh, I remembered a suggestion I had:

Make a script that will revive all who are dead each XX hours, to XX HP. Make it all selectable in the admin cp. For example revive all dead users every 172800 seconds to 25% of their total HP.

It would be useful, but then I guess it would run a lot of queries right?

Bitsys

01-10-2003 06:19 PM

Quote:

Originally posted by v0id
Eh, I remembered a suggestion I had:

Make a script that will revive all who are dead each XX hours, to XX HP. Make it all selectable in the admin cp. For example revive all dead users every 172800 seconds to 25% of their total HP.

It would be useful, but then I guess it would run a lot of queries right?

Well, I think the query would be:

PHP Code:


		
			
UPDATE user SET hp=maxhp*0.25 WHERE hp=0

However, if the users figured out the reset times, then they would participate in a battle, die, and not worry about the consequences since they would get auto-revived, whereas people who dies just after the last reset would have to suffer a lot longer.

Xyphen

01-10-2003 06:28 PM

For who all got a error when visiting online.php a parse error..

This is how to fix it.

FIND THIS IN ONLINE.PHP

PHP Code:


		
			
case 'itemshop':

      $userinfo[where] = "Viewing <a href='itemshop.php?s=$session[sessionhash]'>Itemshop<a>";

      break;

case 'battlefight':

      $userinfo[where] = 'Viewing a Battle';

      break;

case 'battle':

      $userinfo[where] = 'Viewing <a href='battle.php?s=$session[sessionhash]'>Battle Main</a>';

      break;

case 'battleupdate':

      $userinfo[where] = 'Updating a Battle';

      break;

case 'heal':

      $userinfo[where] = 'Healing Center';

      break;

Replace With

PHP Code:


		
			
case 'itemshop':

      $userinfo[where] = "Viewing <a href='itemshop.php?s=$session[sessionhash]'>Itemshop<a>";

      break;

case 'battlefight':

      $userinfo[where] = "Viewing a Battle";

      break;

case 'battle':

      $userinfo[where] = "Viewing <a href='battle.php?s=$session[sessionhash]'>Battle Main</a>";

      break;

case 'battleupdate':

      $userinfo[where] = "Updating a Battle";

      break;

case 'heal':

      $userinfo[where] = "Healing Center";

      break;

Davey

01-10-2003 06:54 PM

[AViO 07]: Actually there's a html error there.
Shouldn't this:

PHP Code:


		
			
case 'itemshop':

      $userinfo[where] = "Viewing <a href='itemshop.php?s=$session[sessionhash]'>Itemshop<a>";

      break;

Be this:

PHP Code:


		
			
case 'itemshop':

      $userinfo[where] = "Viewing <a href='itemshop.php?s=$session[sessionhash]'>Itemshop</a>";

      break;

The close <a> tag was missing a '/'. This would have lead there to be an infinite link, no?

Dave.

PS: I'll install afresh now and see if I still get the errors.

Davey

01-10-2003 07:44 PM

Ok, now you have to sort out a bank error.
Only userid '1' can deposit money properly.
No-body else can.
This is EXTREMELY annoying and has happened before on a previous install of the itemshop/store.

Bitsys

01-10-2003 08:32 PM

Oops, there are tons of errors in online.php besides the ones you guys pointed out. I am in the process of fixing these right now. It will make for a better online.php overall. Thanks for bringing this to my attention.

Davey:
Is it giving you an error message? If not, do the following:
In phpmyadmin, go to the items_user table. Browse this table. There should be one row per user, if there isn't then let me know.

Davey

01-10-2003 09:18 PM

Actually, there's no error message.
It just only lets userid '1' deposit money.
I added the user 'bank' in the admin panel and gave it 10000000, and it worked, it had 10000000.
I went to the bank logged in as 'Bank', and deposited all 10000000, and it said:

Quote:

Cash: 0
Deposit:

Or something of the like. The 'Deposit' bit was empty, not even '0'.
Here is a screenshot of the phpmyadmin 'items_user' table:

Dave.

PS: It seems to me that when you add users in the admin panel, it's not adding those fields correctly.

Bitsys

01-10-2003 09:30 PM

Quote:

Originally posted by Davey
Actually, there's no error message.
It just only lets userid '1' deposit money.
I added the user 'bank' in the admin panel and gave it 10000000, and it worked, it had 10000000.
I went to the bank logged in as 'Bank', and deposited all 10000000, and it said:

Or something of the like. The 'Deposit' bit was empty, not even '0'.
Here is a screenshot of the phpmyadmin 'items_user' table:

Dave.

PS: It seems to me that when you add users in the admin panel, it's not adding those fields correctly.

Oops, forgot to tell you about that. That has been a bug since the beginning. When you add users via the admin cp, the user IDs aren't added to the items_user table or the battle_stats table. To fix this, see the attached file and instructions at https://vborg.vbsupport.ru/showthrea...220#post340220 . Run the attached file and post what it says. Make sure it is in your admin directory.

Davey

01-10-2003 10:00 PM

What attached file?
And now I can't battle either, it says You are inelegible for battle, when I'm not. The other user is legible for battle, also.

Dave.

Bitsys

01-10-2003 10:01 PM

Quote:

Originally posted by Davey
What attached file?
And now I can't battle either, it says You are inelegible for battle, when I'm not. The other user is legible for battle, also.

Dave.

The attached file at https://vborg.vbsupport.ru/show...0220#post340220 .

Bitsys

01-10-2003 11:10 PM

Alright, I think I have fixed online.php. Follow the instructions in the attached file and let me know how it goes. I have tested this on my test board and it seems to work fine, however, I may have missed something (again).

Xyphen

01-10-2003 11:36 PM

Davey, thnx for the fix, but there is a update now!

Mijae

01-11-2003 02:50 AM

How is the HP, MP, PP calculated? I have 1 user at level 2 with 1110+ hp and one with 650+, while all others have 250 at most. I want to know how its calculated so I can figure it out.

Bitsys

01-11-2003 02:57 AM

Quote:

Originally posted by v0id
How is the HP, MP, PP calculated? I have 1 user at level 2 with 1110+ hp and one with 650+, while all others have 250 at most. I want to know how its calculated so I can figure it out.

The formulas are located in member.php. Search for hp, ma, pp ,etc...

The formulas work off of several things, including posts per day, length of time being a member, element, and experience/level. The reason why some users who are low levels can have such high stats is that they may have a much higher post per day number.

The exact code is attached to this post, making it easier to look at. If you have any specific questions about parts of the code, then ask me about it and I will try to explain it. Please remember that this code comes mostly from the Class Hack v3.3 by DarkVincent.

mr e	01-11-2003 05:00 AM

are all these fixes you listed in the new updated version? ex: adding users via admin etc

Mijae

01-11-2003 04:53 PM

There is some kind of error when generating PMs. The challenger user gets a wrong like in the PM, it doesnt include battle #, thus newbies dont know how to continue from there.

Quote:

Mary-chan has challenged you in a battle. It is battle number and is called Ok, I's challenge you. *prepares to die*. There is 0 gil at stake in this battle. Your battle password is 1234. To go to your battle click here

See, it says Battle number and wont show the number, and the link has battlenumber=&battlekey=XXXX

PSI|Dr-X

01-11-2003 05:23 PM

look at the templates there must be something wrong i think with the installation

Bitsys

01-11-2003 05:27 PM

Quote:

Originally posted by v0id
There is some kind of error when generating PMs. The challenger user gets a wrong like in the PM, it doesnt include battle #, thus newbies dont know how to continue from there.

See, it says Battle number and wont show the number, and the link has battlenumber=&battlekey=XXXX

The error is in battle.php. The fix will be in the new version. Hopefully, I will be able to release the new version today. The new version will also, hopefully, have Lesane's Store integration. All you will have to do is say "Yes I have it installed" or "No I do not have it installed" in the Itemshop Options menu.

PSI|Dr-X

01-11-2003 06:40 PM

Cool ill take itemshop :) heh

Xyphen

01-11-2003 07:48 PM

About Lesane's Store integration, I am not going to install it seprately, can you make it like, so when we upgrade/install it gives us a option to install that hack or not? and you include all the files and stuff with all the addons, when installing it also asks which addons you would like to install. :smoke:

Bitsys

01-11-2003 08:21 PM

Quote:

Originally posted by AViO 07
About Lesane's Store integration, I am not going to install it seprately, can you make it like, so when we upgrade/install it gives us a option to install that hack or not? and you include all the files and stuff with all the addons, when installing it also asks which addons you would like to install. :smoke:

Sorry, but the Store hack is Lesane's and he is providing all support for it. I do not want to confuse people by including it with this hack. The reason why most people want the integration is because they already have Lesane's Store hack installed on their forums.

As far as add-ons go, there is only one add-on right now (I think) and that is the member profile add-on. Since this add-on is only one file edit, I do not believe it is necessary to give users the option during the install. It seems much simpler and easier for those who want to use it to just hack the one file.

DarkDraco07

01-11-2003 10:34 PM

for people that have stupid members that are to stupid to read a post you made about how to use the battle hack. you might want to make a .html page like i did

http://www.darknemesis.com/forums/battle.htm

saint_seiya

01-12-2003 12:07 AM

I got a question. Can I install it now, will i be able to upgrade later? Got not ime to read 40 pages so someone update me :) My forums are active and i dont want to mess them up.

All times are GMT. The time now is 01:57 PM.

Page 14 of 63

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03192 seconds Memory Usage 1,863KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (5)bbcode_php_printable (14)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: