vb.org Archive

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)

Bitsys 01-16-2003 12:38 AM

Quote:

Originally posted by jeremy
I select "yes" and the Itemshop bank no longer work.But my
members save a lot of money in the Itemshop bank.How do I
move the money from the bank to the store money?

Or can you open the bank service when i select "yes"?
:)

If all you want is a one-time script that converts all bank money into lesane's store points, then I can make one for you real quick. Let me know if this is what you need.

SpyGuy007 01-16-2003 01:37 AM

I definitely need it!

Oh, and jeremy, there is a bank hack for Lesane's Store hack. As far as I know, it should work along with this hack.

jeremy 01-16-2003 03:25 AM

Yes,a one-time script will solve my problem.

And I need it.

thank SpyGuy007 & Bitsys :)

heretic 01-17-2003 11:46 AM

Ok, I'm going to try and install this over the weekend, and I have a few questions:

1) how stable is .60, is it close enough to where I can install it on the test board and *should* expect minimal issues? I'm referring to the database fix on the previous page, was that added to the release?

2) The win/loss issue, I didn't see if there was a resolution.

3) this is a vbhacker release only? no manual file as well?

I figure I'll find out a few answers before you get a chance to reply, wish me luck :)

Bitsys 01-17-2003 01:31 PM

SpyGuy007 and jeremy:

The script for converting bank money and money in pocket to Lesane's Store Points at a one to one ratio is attached to this post. Upload the file to your admin directoy and execute it. The script will go through each user and convert the money. Make sure you don't run the script more than once. If you do, then user's will get twice as much money as they are supposed to get, since each time you run it it converts the Itemshop money into Lesane's Points without subtracting from the Itemshop money.

heretic:

1) Version 0.60 is a lot more stable than the other version. However, there is always the possibility that you will get errors. On a test board, the install is usually flawless. I am not sure as to which database fix you are referring to. However, the fix I posted for Kurayami will be in the next version, just in case something goes wrong during the installation. I hope to release version 0.61 today, so it might be better if you wait for that version.

2) No resolution yet. The fix will be in the next version.

3) You have two options: (1) Let vbhacker do all of the hacking or (2) Let vbhacker make a text file that tells you how to install the hack manually. To generate the text file using vbhacker, from the main page click on the hack you want to install and at the bottom select "Generate a text file" instead of "Install". Then click continue.

heretic 01-17-2003 05:37 PM

Bitsys, I did everything, and added the postbit sample, as well as the showthread edit, however I'm getting this when viewing threads, must be somewhere in the showthread.php file:

Quote:

Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
, battle_options, items_options LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN items_user ON items_user.userid=user.userid
LEFT JOIN battle_stats ON battle_stats.userid=user.userid
LEFT JOIN rpg_classf ON rpg_classf.id=user.rpgclass
LEFT JOIN rpg_classm ON rpg_classm.id=user.rpgclass
LEFT JOIN rpg_element ON rpg_element.elementid=user.element
LEFT JOIN rpg_race ON rpg_race.raceid=user.rpgrace AND rpg_race.alignmentid=user.alignment
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,1,2)
ORDER BY dateline

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

mysql error number: 1066

Date: Friday 17th of January 2003 02:21:13 PM
Script: http://www.the-rift.net/dev/dev/show...php?threadid=1
Referer: http://www.the-rift.net/dev/forumdisplay.php?forumid=2

Bitsys 01-17-2003 05:57 PM

Quote:

Originally posted by heretic
Bitsys, I did everything, and added the postbit sample, as well as the showthread edit, however I'm getting this when viewing threads, must be somewhere in the showthread.php file:


In one of the showthread edits, you must find and add the same piece of code twice. Go through showthread.php and find the code twice and add it once per instance. If you used vbhacker, did you get any errors?

heretic 01-17-2003 05:57 PM

only chmod errors. I did the part about it being twice..I'll check a 3rd time

Bitsys, I'm on AOL while at work, S/N is "a rabid lemur"

heretic 01-17-2003 06:19 PM

ok, I found that this

Code:

attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter,
had not been changed twice to this

Code:

user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,items_options.pointfield,items_options.lesanestore,battle_options.namefield,battle_options.exprate,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


hopefully this'll work

Bitsys 01-17-2003 07:58 PM

Version 0.61 is done, see the first post for the new .zip file. It has some interesting changes. The upgrade instructions are included in the .zip file and are located in the "upgrade" directory.

New features:
  • Battle formulas have changed. When using your fists, you do less damage than before, and there is a random factor added that is plus or minus 15% of the total damage. When using a weapon, there is now a plus or minus 25% damage factored in.
  • Attack Spells now cost a minimum of 5 MA to cast.
  • Healing Spells now cost 0.1 MA per HP healed (amount healed is determined by the buff of the item).
  • You can now update all users' stats at one time from the admin control panel. You can also update one user's stats from the edit users menu. NOTE: If you have changed the update stats code in member.php, then you must also change the update stats code in rpgadmin.php in the same way, or else you could get unexpected results.
  • You can now adjust how much it costs to heal per HP and per MA. Setting this to 0 will make healing free.
  • You can now set how much HP, MA, and PP users get per level. Before, the amount per level of HP was 75, I would recommend setting it to somewhere between 20 and 50. Please experiement with this to determine the best number for your board.
  • The itemshop now won't let you buy a weapons if you already own it.

There may have been some more small things that I forgot to mention. You may or may not notice them.

Bugs fixed (I hope):
  • Winners and losers of battle should now get the correct win/loss status as well as the wager if they won.
  • When cancelling/declining a battle, users are now refunded their money and are not given credit for a battle.
  • The links in the postbit that generate a pop-up will no longer scroll to the top of the page before displaying. If you have the links in your postbit already, then open the sample potbit text file and copy and paste just the links with javascript in them.
  • Fixed the level 1 users could not buy itemshop items that were at level 1 or 0 bug.
  • Some other minor bugs.


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


All times are GMT. The time now is 07:43 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02839 seconds
  • Memory Usage 1,758KB
  • 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
  • (2)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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