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

Basically, when a user creates a Battle it sends that PM. The opposing user clicks on the link however the screen says "Invalid Password". No password is stored in the database. I know that because on the PM it has a blank space where the password should be. My AIM is GuitarBro05 if you need any more information. You could of course use this thread...it's up to you. But I love the idea of your hack (perfect for this RPG tournament we're planning). I really hope you can help.

*EDIT: Fixed! ::Does Happy Dance::

Confuzzled

08-23-2003 01:00 AM

Hello people :) I installed this addon on a site for someone and all was well. Suddenly though, it broke and we get a error like this.

Code:



Invalid SQL: SELECT items_user.item15,items_user.itid15,items.type FROM items_user

                        LEFT JOIN items ON items.itemid=items_user.itid15

                        WHERE items_user.userid='1'

mysql error: Unknown column 'items_user.item15' in 'field list'



mysql error number: 1054



Date: Friday 22nd of August 2003 10:03:16 PM

Script: http://www.domain/vb/vb/battlefight....ttlenumber=461

Referer: http://www.domain/vb/battle.php?action=browse

The part that's REALLY confusing, is that it's adding a /vb onto it, could that be breaking it? We didn't do anything to the hack, it just suddenly did this @_@

I've run the database checker in the admincp, but still no avail
Any solutions?

~Francisco

Bitsys

08-23-2003 01:11 AM

Quote:

Today at 09:00 PM Confuzzled said this in Post #2162
Hello people :) I installed this addon on a site for someone and all was well. Suddenly though, it broke and we get a error like this.

Code:

Invalid SQL: SELECT items_user.item15,items_user.itid15,items.type FROM items_user LEFT JOIN items ON items.itemid=items_user.itid15 WHERE items_user.userid='1' mysql error: Unknown column 'items_user.item15' in 'field list' mysql error number: 1054 Date: Friday 22nd of August 2003 10:03:16 PM Script: http://www.domain/vb/vb/battlefight....ttlenumber=461 Referer: http://www.domain/vb/battle.php?action=browse

The part that's REALLY confusing, is that it's adding a /vb onto it, could that be breaking it? We didn't do anything to the hack, it just suddenly did this @_@

I've run the database checker in the admincp, but still no avail
Any solutions?

~Francisco

What is the structure of your items_user table?

In battlefight.php, are you able to find the following:

PHP Code:


		
			
$itemcats = $DB_site->query("SELECT id, battletype FROM items_cats WHERE type = 0 ORDER BY battletype");

Have you added any personal item shops recently?

Confuzzled

08-23-2003 01:38 AM

thank you for the quick reply.
I did a check on the file, and it IS there. I've talked with the admin, and he said that yes, there are personal shops are in play.

Is there any place in the admincp that lists the stores and what their selling? What should i look for in the personal shops that could bust it like this?

Thanks again

~Francisco

Bitsys

08-23-2003 01:30 PM

Quote:

Yesterday at 09:38 PM Confuzzled said this in Post #2164
thank you for the quick reply.
I did a check on the file, and it IS there. I've talked with the admin, and he said that yes, there are personal shops are in play.

Is there any place in the admincp that lists the stores and what their selling? What should i look for in the personal shops that could bust it like this?

Thanks again

~Francisco

I am pretty sure there is nothing you did wrong. I think this is a bug from the last version that I have fixed on my version but I haven't released yet. To test this theory, try the following:

In battlefight.php, find:

PHP Code:


		
			
$itemcats = $DB_site->query("SELECT id, battletype FROM items_cats ORDER BY battletype");

and CHANGE it to:

PHP Code:


		
			
$itemcats = $DB_site->query("SELECT id, battletype FROM items_cats WHERE type = 0 ORDER BY battletype");

If that does not work then it may be something else that I am not aware of.

legendarysk8er

08-23-2003 04:08 PM

I wish the new version would come soon.

Bitsys

08-25-2003 05:51 PM

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

This is a mainly bug fix version.

Bugs Fixed:

Fixed mysql error in battleupdate.php when personal itemshop IDs were greater than non-personal IDs and the user had a personal item.
Removed hard-coded references to the word "Gil" from battle.php. There is now a "$" in its place.
Fixed personal itemshop money exploit involving negative cost for items.
Fixed class bug in itemshop.php that allowed certain class IDs to buy items meant for other classes.

Major Changes:

All code in battleupdate.php has been re-written.
All code in battle.php and heal.php that deals with money will now use the user's cash instead of his/her bank account. This should alleviate the appearence of disappearing bank money and help track down any existing bugs.

The working shields add-on has been included in this version of the hack. You do not need to re-install it after upgrading.

The uninstaller for the previous version should work for this version as well.

This version will probably be buggy, since I have not had adequate time to test it, so as always, if you find any bugs or errors, let me know :)

legendarysk8er

08-25-2003 06:00 PM

Ok, I'll wait for others to post how it went first to make sure there's nothing wrong with it.

Hobbes

08-25-2003 11:43 PM

installed on 2.3.2....went good :)

All times are GMT. The time now is 09:08 PM.

Page 213 of 251

213

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02566 seconds Memory Usage 1,756KB 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_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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
Messages: