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 12-19-2002 11:37 PM

Gold per post is in the Itemshop Options menu in a field called "Activity Points". Currently, there is no way to give users a certain amount of gold to begin with. However, you can add that feature in several ways. The easiest way to add it is through phpmyadmin. In the table called `items_user` locate the field called 'bankval'. Change the default value of 'bankval' to whatever you want the users to start with. The other ways are harder to implement.

Strider Xero 12-20-2002 12:16 AM

I'm the one who wanted to uninstall .55

How do I delete the templates?? There's no option in the AdminCP to delete them. All it says is 'Change Original'

Strider Xero 12-20-2002 12:40 AM

i accidentally deleted ALL of my Template tables through phpMyAdmin...uhh...how do I get them back?? I have a back up but just have no idea on how to restore it...obviously i absolutely know nothing about mysql and stuff, so can someone tell me how to restore it?

Bitsys 12-20-2002 02:21 AM

Quote:

Originally posted by Strider Xero
i accidentally deleted ALL of my Template tables through phpMyAdmin...uhh...how do I get them back?? I have a back up but just have no idea on how to restore it...obviously i absolutely know nothing about mysql and stuff, so can someone tell me how to restore it?
Have you tried the "Insert data from a textfile into table" link in phpmyadmin? It is near the middle of the page when you are viewing the table structure.

Strider Xero 12-20-2002 02:26 AM

ok i restored it using the vbulletin.style

but anyway, i've installed .56 using vbhacker, and i had to run some queries. Anyway, i get this error when i try to go to a forum:

Code:

Database error in vBulletin :

Invalid SQL:
        SELECT
       
                thread.threadid
        FROM thread
        WHERE thread.forumid = 6
                AND thread.sticky=0
                AND thread.visible=1
        AND lastpost >= 1037758954 AND sticky=0
       
          ORDER BY sticky DESC, lastpost DESC
          LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 12

mysql error number: 1064

Date: Thursday 19th of December 2002 09:22:34 PM
Script: /forums/forumdisplay.php?forumid=6
Referer: http://www.xeroanime.com/forums/foru....php?forumid=4


Bitsys 12-20-2002 02:29 AM

My hack does not modify forumdisplay.php. I am not sure as to what is causing that error, although it appears as if part of the query is missing.

rrnolan 12-20-2002 04:35 AM

Can I ask you a question about Battle Forums, I notice that I can only buy one Weapon, One Potion, and One Armor, If I try to but a 2nd Weapon it takes the first weapon out of my inventory. Is that correct you can only have one of each

gengar003 12-20-2002 01:39 PM

I have set the level to be determined by the # of posts, but the level won't show up. Because of this, no one can battle.

Also, the purchased items don't show up, and there are no hp/mp/ap etc bars in the profile, are there supposed to be?

Bitsys 12-20-2002 01:44 PM

rrnolan:
That is correct that you can only have one of each. That is the way the original itemshop worked.

gengar003:
Where is the level not showing up at? Did you update your stats? What error are you getting when you try to battle?

Where are the purchased items not showing up? There is supposed to be hp/mp/ap in the bars, but you have to update your stats first. What version are you running?

rrnolan 12-20-2002 01:55 PM

Has anyone written a game manual or how to for folks yet. This is a fun hack but many folks are asking me for a manual

Bitsys 12-20-2002 02:11 PM

Quote:

Originally posted by rrnolan
Has anyone written a game manual or how to for folks yet. This is a fun hack but many folks are asking me for a manual
One person has written a how-to guide for the members of his forums. I will ask him to post it here and you can copy it. Version 0.56 included an admin tutorial at the bottom of the readme file on how to get started.

rrnolan 12-20-2002 02:13 PM

The Manual will be great I can't wait.... :p This thing runs great on 2.6

Graphics 12-20-2002 02:24 PM

kewl :)

gengar003 12-20-2002 02:46 PM

the items purchased do not show up on itemshop.php, where I assume they should.

the level does not show up in user profile.

there are no bars at all.

I did update my stats, error message is stillL: You are ineligible for battle at this time. Please try updating your stats in the User Control Panel.

Also, do you know how to :
-upgrade vb w/out losing installed hacks?
-make rpg points same as lesane store hack points?

Bitsys 12-20-2002 03:21 PM

I am not sure as to why you are having trouble with items showing up.

The level is supposed to show up in the postbit, not in the user profile.

The bars are also supposed to be in the postbit.

I noticed that you overwrote the "Unknown" Alignment with something else. This means that if you use that alignment, then you won't be able to particiate in battles because you must have an alignment other than the original Unknown.

Also, did you run "install_itemshop_items.php"? It seems that you did not run it or you did not go through it all the way because there are only two users in your 'battle_stats' database, when there are supposed to be around 71.


There is a stickied thread in the "Hacking Hints and Tips" forum called Tutorial: Upgrade your hacked board in less then 30 minutes. Try that.

I do know how to make the Lesane Store hack integrated with this hack, however I do not have instructions on how to do that at this time.

Mrpolish 12-20-2002 05:12 PM

When i buy the items in the itemshop and then battle somebody they do not showup while in battle the only thing to use is fists and that does not work out really well.

Bitsys 12-20-2002 05:28 PM

Did you read https://vborg.vbsupport.ru/showthrea...575#post329575 yet?

Mrpolish 12-20-2002 05:42 PM

DUH ME

gengar003 12-20-2002 06:15 PM

Quote:

Originally posted by Bitsys
I am not sure as to why you are having trouble with items showing up.

The level is supposed to show up in the postbit, not in the user profile.

The bars are also supposed to be in the postbit.

I noticed that you overwrote the "Unknown" Alignment with something else. This means that if you use that alignment, then you won't be able to particiate in battles because you must have an alignment other than the original Unknown.

Also, did you run "install_itemshop_items.php"? It seems that you did not run it or you did not go through it all the way because there are only two users in your 'battle_stats' database, when there are supposed to be around 71.

There is a stickied thread in the "Hacking Hints and Tips" forum called Tutorial: Upgrade your hacked board in less then 30 minutes. Try that.

I do know how to make the Lesane Store hack integrated with this hack, however I do not have instructions on how to do that at this time.

Hmm. i didn't run the install Items... stupid me.

what's the postbit?

I'll fix the alignment thing, thanx for the upgrading hacked boards tip, and do you think you could type up instructions for integration wit lesane's hack? I'd really appreciate it...

Kaelon 12-20-2002 06:22 PM

This is looking great, Bitsys! I'd be more than happy to help you test it, but I only have a large scale (250,000 posts, several thousand members, very active) forum in a production environment, though I know its participants would be very eager to try out this phenomenal hack.

Have you considered creating an un-install file for the hack, or any other necessary precautions, so that it can start being tested on production environments in beta?

Thanks, agian. I'll keep following this thread regularly.

Regards,
Kaelon

Bitsys 12-20-2002 06:41 PM

gengar003:
The postbit refers to the postbit template. There is a template group called "Postbit Templates". When I refer to the "postbit template" I am talking about the template that is actually called "postbit" and is the first template located under the "Postbit Templates" group, in your global and/or default template set.

I cannot post instructions for integration with Lesane's store hack becuase my hack keeps getting minor changes that make in unfeasible to be updating two hacks. Also, there are changes that must be made to 5+ .php files, so it is more than a simple job. However, once my hack gets closer to release (I am writing the help documentation right now, after which I need to test the uninstall script) I will work on integrating it into Lesane's Store hack and then releasing that as a completely separate version. I cannot promise anything right now though.

Kaelon:
There is currently an uninstall-script in the works. However, I won't release it until it, too, is bug free ;) As long as you keep reading this thread every now and then, you won't miss it.

gengar003 12-20-2002 07:04 PM

Okay, by now, I'm probably boring you all out of your minds with obvious questions, but I've got another one:

When I deposit money in the bank, it takes the money, but doesn't put it in the bank, it just makes it dissappear.

I understand what you're saying about the integration with the store hack, but could you just post an overview?

In addition, I think I read something about upgrading to newer versions of your hack... is it manual, or can u upgrade with vbhacker?

Bitsys 12-20-2002 07:30 PM

Are you sure the money doesn't appear in your bank account?

I can't post an overview right now, sorry.

Upgrading from one version of the beta to another is manual. However, 0.56 was the last major update. I don't anticipate any future ones to be very hard to upgrade.


BTW, here is a guide that DarkDraco07 created for the members of his forum. Thanks DarkDraco07!
Quote:

-Start off by going to your User Control Panel. Then edit your profile. At the bottom of your profile there is a bunch of RPG settings such as your RPG chars name, gender, alignment, class, etc... Once u have finished this you click the update stats link. (Note: you will have to update your settings every time you level up). Also, when selecting your RPG options from the user cp, you must submit the options first, then go back to the edit profile menu and click the update stats link

-Now you go to the ItemShop. Purchase any item you wish. (Note: The Generic Items can be used by anyone, but all the rest of the items you can buy are based on your charector type) If your a warrior or whatever, you can purchase heavy armor and sword, if your a mage u can purchase spells and so forth. When you buy a potion, it can be used only once. Dont forget to update stats*

-When you are ready for battle you go to the Battle page. Click on new battle. Enter the game name and password and the person you want to fight. When you have finished this there will be a PM sent to the person you challenged telling him the game number and password. Once the opponent has agreed to fight, go back to the battle page and enter the game info and password, or if u want you can click on browse to view all the battles going on and click view on your battle to enter the battle (other people may watch)

-The the battle begins. The are option buttons (radio buttons) with the attacks you can use. All the greyed out attacks mean you dont have that. There will be attack with your weapon, use your fists, use a spell, use a potion, an option to give up and retreat. Pick one, enter a text message in the box if you want and click submit. For everytime that you miss, your AP (anger points) will rise. When your AP reaches 70-99, a check box will appear that says "are you angry yet?". This is the anger attack. Based on how much AP you have, you do more damage. (ex. if you have 80AP then if u check the anger box you will do 8% more damage). Then your AP drops to 0. If you have 100AP you will automatically do 10% more damage. Also if you are level 10+, you will do.1 more damage than you usually will.

-As many know these, ill say them again:
+HP(Hit Points) is your life, when it reaches 0, your dead.
+MA(Mystic Aura) is your magic, when it reaches 0, you cant use magic.
+PP(Power Points) is your power, it doesnt do anything yet.
+AP(Anger Points) is your anger, When it reaches 70-100 you do more damage.
(Note: after a battle, if you have died or lost MA, a moderator or admin has to refill your HP and MA)". Another way you can refill your HP is to make enough posts to gain a new level and then update your stats. When you update your stats after gaining a level, your stats are automatically refilled.)

-Also, all battles will be recorded under a new forum section. Thus giving you EXP for fighting.

So far that is how you battle.

Bitsys 12-20-2002 08:20 PM

Quote:

Originally posted by gengar003
THe items that I've bought are still not showing up, there are still no hp/mp/pp/ap bars anywhere, and whenever i try to enter a battle, it times out, in addition to the bank stealing your money.

Can someone help?

I think I found the problem. When you ran "install_itemshop_items.php", you chose NOT to install the default items, correct?

Hmm, this post is above the post I am responding to....something is not right.

gengar003 12-20-2002 09:47 PM

THe items that I've bought are still not showing up, there are still no hp/mp/pp/ap bars anywhere, and whenever i try to enter a battle, it times out, in addition to the bank stealing your money.

Can someone help?

assassingod 12-21-2002 02:14 PM

Bitsys, thanks for the fix. I can enter the battle now.

gengar003 12-21-2002 03:32 PM

Quote:

Originally posted by Bitsys
I think I found the problem. When you ran "install_itemshop_items.php", you chose NOT to install the default items, correct?

Hmm, this post is above the post I am responding to....something is not right.

Incorrect - I installed the default items.

also, whenever I try to battle, it times out...

Bitsys 12-21-2002 04:35 PM

Quote:

Originally posted by gengar003
Incorrect - I installed the default items.

also, whenever I try to battle, it times out...

For the timeout thing, use the fix I posted for assassingod at https://vborg.vbsupport.ru/showthrea...584#post332584

For some reason, I don't think your items_user database was correctly populated. If you have phpmyadmin, go into it and make sure that there is one row for each user on your site. Also, make sure that the battle_stats database is populated in the same way as the items_user database.

assassingod 12-21-2002 05:19 PM

I have 3 more problems:
I have 2 users I user, admin and user1.

admin can buy items. user1 cant - even though there is enough money.

admin cannot use items in battle.

The 3rd problem is there are some broken itemshop images.

gengar003 12-21-2002 10:11 PM

Quote:

Originally posted by Bitsys

For the timeout thing, use the fix I posted for assassingod at https://vborg.vbsupport.ru/showthrea...584#post332584

For some reason, I don't think your items_user database was correctly populated. If you have phpmyadmin, go into it and make sure that there is one row for each user on your site. Also, make sure that the battle_stats database is populated in the same way as the items_user database.

Okay, there's only two rows in item_user, what do I do? Ditto for battle_stats...

I get this error when trying to run install_itemshop_items.

Quote:

Database error in vBulletin Control Panel 2.2.5:

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: Saturday 21st of December 2002 06:08:35 PM
Script: http://www.pgsforum.com/vb/vb/admin/...ction=additems
Referer: http://www.pgsforum.com/vb/admin/ins...shop_items.php

Colon33 12-22-2002 06:41 AM

the hack clearly states v 2.2.7 , 2.2.8 and 2.2.9. You have 2.2.5 it says. You might need to upgrade.

Travis641 12-22-2002 05:37 PM

Quote:

Originally posted by gengar003


Okay, there's only two rows in item_user, what do I do? Ditto for battle_stats...

I get this error when trying to run install_itemshop_items.


This means you have the column "item1" already inside your database. Meaning you have Itemshop already installed.

Delete the column, and any other columns that Itemshop created to get it to work.

rrnolan 12-22-2002 05:42 PM

Quote:

Originally posted by Colon33
the hack clearly states v 2.2.7 , 2.2.8 and 2.2.9. You have 2.2.5 it says. You might need to upgrade.
Im running it with 2.2.6 with no problems or issues

rrnolan 12-22-2002 05:44 PM

Just checking

Bitsys 12-22-2002 10:50 PM

Sorry, I was out of town yesterday and most of today.

assassingod:
Make sure that the money is in your pocket, not in your bank account.

Try to check your items_user table also. It doesn't seem to be correctly populated. There should be one row for each user on your boards.

Post the actual link that is broken with the itemshop images, so I can see what is wrong. Once again, it appears that your items_user datbase is causing the trouble.

gengar003:
I will post a script you can use to fix it - give me a little while to test it. The reason you can't run the script again is that it has already created the tables.

Colon33:
Although it does state versions 2.2.7, 2.2.8, and 2.2.9, that doesn't mean it won't work on previous versions. Since I do not have a copy of anything before 2.2.7, I cannot test it on those boards. Gengar is helping to test it on a previous version and if all had gone correctly with the installation queries, then I think it would do fine on 2.2.6 or maybe 2.2.5. This is what beta is for.

rrnolan:
The help docs are about 20% complete, roughly 40KB.

Strider Xero 12-23-2002 06:40 AM

so .57 is gonna be released soon right? =)

assassingod 12-23-2002 06:57 AM

Quote:

Originally posted by Bitsys

assassingod:
Make sure that the money is in your pocket, not in your bank account.

Try to check your items_user table also. It doesn't seem to be correctly populated. There should be one row for each user on your boards.

Post the actual link that is broken with the itemshop images, so I can see what is wrong. Once again, it appears that your items_user datbase is causing the trouble.

The money is in the pocket:)
Will do again, thanks.

If I remember correctly, I used the item shop before and got the same error, the URL of the image is board/images/.gif

Will keep trying with the hack

PSI|Dr-X 12-23-2002 09:19 PM

Hey everything worked thnx cool hack but ive got a problem :D
When I am in a battle and wanna attack and press ok then er comes a error



There seems to have been a slight problem with the Dbz Netwerk 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.


And in the url http://localhost/battleupdate.php?ac...&battlekey=123

it is a vb 2.2.6 everything worked:) only this then

(When have itemshop installed never try installing this hack
Whole forum goes DANG only if you are good at queries getting out)


Please help me:)

Mrpolish 12-24-2002 12:55 AM

So far everything works on my mb, battle, itemshop and heal work perfectly.
Im running on 2.2.8

Bitsys 12-24-2002 01:09 AM

gengar003:
To fix your items_user database and battle_stats database, do the following:
  • Download the attached .zip file
  • Extract the file and upload it to your vBulletin admin directory on your server
  • Go to the file in your web browser
  • Click "Yes"
  • Wait for it to finish
  • After completing, if it says that no IDs were inserted, then your tables were fine. If it finds a discrepancy, then it will list the ID(s) that was (were) inserted.
Let me know how it goes.


Strider Xero:
.57 will most liekely be the last Beta update before Final Release. It will include the help documentation and a nifty feature for the admin cp, as well as some bug fixes. It all depends on how busy I get over Christmas.


assassingod:
If you don't feel that the databases are correctly populated, then run the fix I posted for gengar above.

I am not sure about the broken link. This was resolved a long time ago and I have not seen it pop up since until now. I will look into it.


PSI|Dr-X:
Without a more specific error message, there is not a whole lot I can do. Since you are running on localhost, can you change the error messages to be more specific?


Mrpolish:
:)


All times are GMT. The time now is 02:09 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.03336 seconds
  • Memory Usage 1,861KB
  • 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
  • (1)bbcode_code_printable
  • (12)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