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)

Graphics 02-01-2003 02:23 PM

Is there any way I can reste the RPG so everyone is back to nothing?
I go to do it and it says test.

Graphics 02-01-2003 03:06 PM

Can you add a new item category in the next version?
Items that add to the characters anger in battle?

Xyphen 02-01-2003 04:19 PM

The next version is going to be cool..

Bitsys 02-01-2003 05:32 PM

Mrpolish:
Not yet. however, I am always getting closer.

saint_seiya:
That would be the ideal solution, however, there isn't an easy way to make the server call a script at a given time. It is possible, but I don't know the specifics of it.

Graphics:
Wait for the next version.

(second post):
I don't think I can add that in the next version.

Colon33 02-01-2003 11:47 PM

So is the latest beta safe to use on a public board? Anyone? Are there any major errors still?

mr e 02-02-2003 12:38 AM

i wouldn't use any beta on a production board, but if you are make a backup first or you could be screwed

Solice 02-02-2003 07:53 AM

I installed this, and now all the posts appear as if they're created by guests...

Bitsys 02-02-2003 12:07 PM

Colon33:
Generally, it won't nuke your board or anything like that. However, the RPG is still changing and there have been some recent bugs and exploits that people have found that could make them extremely rich or invincible, etc. I would wait until at least the next version so that you don't have to keep restarting the RPG every time someone finds a new exploit and uses it.


Quote:

Originally posted by Solice
I installed this, and now all the posts appear as if they're created by guests...
In the admin cp, click on the "DB Fix" link and run the script.

Solice 02-03-2003 01:07 PM

thnx

only other problem is, the battle page doesn't load, i go into battle and it doesn't load at all..

Bitsys 02-03-2003 01:21 PM

Quote:

Originally posted by Solice
thnx

only other problem is, the battle page doesn't load, i go into battle and it doesn't load at all..

I assume you mean battleupdate.php? What page are you at before you try join the battle? Is the page just blank? No error message? What are your battle options set to?

Solice 02-03-2003 11:42 PM

Quote:

I assume you mean battleupdate.php
no, battlefight.php, and im at battle.php

Quote:

No error message
after a while it just comes up with server timeout message

Quote:

What are your battle options set to
everything at default.


another thing;
in the itemshop main page everything is repeated, it isn't the templates because Ive checked 20 times already, and deleted any multiple ones.

PSI|Dr-X 02-04-2003 06:25 PM

I think i will wait for the full version :)

Gohan 02-05-2003 12:30 AM

When will release final version?

mr e 02-05-2003 01:25 AM

he's working on integrating other peoples hacks and testing the install file now

Dribbles 02-05-2003 02:07 AM

Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter,
user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,items_options.pointfield,items_options.lesanes tore,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

FROM post

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 attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,722,920,968,1242,1249,1252,1261,1262,1539,2212, 2236,7019,7438,8427)
ORDER BY dateline

mysql error: Unknown table 'items_options' in field list

mysql error number: 1109

Date: Tuesday 04th of February 2003 11:05:10 PM
Script: /showthread.php?s=&threadid=237
Referer: /forumdisplay.php?s=&forumid=4

mr e 02-05-2003 02:11 AM

you dont have the table item_options in your db, run install_itemshop_items.php and it should fix it

Dribbles 02-05-2003 02:58 AM

Quote:

Originally posted by mr e
you dont have the table item_options in your db, run install_itemshop_items.php and it should fix it
admin/install_itemshop_items.php

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

Database error in vBulletin Control Panel 2.2.9:

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

mr e 02-05-2003 03:19 AM

run this query

[sql]CREATE TABLE `items_options` (
`pointfield` varchar(8) NOT NULL default '0',
`refund` varchar(5) NOT NULL default '0',
`stockdate` varchar(250) NOT NULL default '',
`onofforder` smallint(6) NOT NULL default '0',
`sold` int(11) NOT NULL default '0',
`profit` int(11) NOT NULL default '0',
`minstock` int(11) NOT NULL default '0',
`maxstock` int(11) NOT NULL default '0',
`stockreset` varchar(250) NOT NULL default '0',
`pcost` int(11) NOT NULL default '0',
`padd` tinyint(4) NOT NULL default '0',
`hidelevel` tinyint(4) NOT NULL default '0',
`lesanestore` tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;[/sql]

then run this one

[sql]INSERT INTO `items_options` (`pointfield`, `refund`, `stockdate`, `onofforder`, `sold`, `profit`, `minstock`, `maxstock`, `stockreset`, `pcost`, `padd`, `hidelevel`, `lesanestore`) VALUES ('field5', '.75', '', '0', '0', '0', '4', '7', '604800', '2000', '10','0','0');
[/sql]

Colon33 02-05-2003 03:27 AM

We need like a mailing list. I used all these hacks on my previous board. ANd i requested numerous times this type of hack... and bitsys looks like he did a good job. I cnat wait until its ironed out.

Bitsys 02-05-2003 06:37 PM

Quote:

Originally posted by Solice

no, battlefight.php, and im at battle.php


after a while it just comes up with server timeout message


everything at default.


another thing;
in the itemshop main page everything is repeated, it isn't the templates because Ive checked 20 times already, and deleted any multiple ones.

What version are you running? Have you tried re-uploading another copy? What is your Max HP/MA/PP at? What background are you using for the battle?

If none of the above leads to a solution, then open battlefight.php and DELETE all '@' symbols. There should be 7 of them. Let me know if it shows an error message then and what it says.

What do you mean by everything is repeated? Are the actual items repeated, or are the item categories repeated? Or do you mean the page is repeated? How many times did you run the install script?


Gohan:
Hopefully soon.


Dribbles:
It appears that some of the file edits to showthread.php were not made. Have vbhacker generate a text file of the hack (this option is at the bottom of the vbhacker start screen), and manually re-apply all of the changes to showthread.php. In particular, the installer did not insert
PHP Code:

battle_optionsitems_options 

after
PHP Code:

FROM post 

although it could have missed something else as well. The whole query should look something like (but not necessarily EXACTLY like):
PHP Code:

SELECT
post
.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter,
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
".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
FROM postbattle_optionsitems_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
".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 $postids
ORDER BY dateline $postorder 

around line 420 of showthread.php.

Dan 02-05-2003 11:20 PM

Hmm...... I installed this all correctly but I get a white screen everytime I goto battle any help out there?

mr e 02-05-2003 11:29 PM

are the templates all there?

Solice 02-06-2003 12:14 AM

thnx Bitsys, working now

[edit]it doesn't let u use weapons:([/edit]

Mijae 02-06-2003 12:58 AM

Oricon, how many styles do you have?

Graphics 02-06-2003 07:16 AM

Any date on the next release Bitsys? I cant open my forum till its out

Bitsys 02-06-2003 12:27 PM

Oricon:
Try some of the things I listed on the previous page for Solice.

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

Graphics:
I'm hoping I can get the next version out this weekend. The next version will have 4 add-ons built in, an admin FAQ, lots of bug fixes, some adjusted battle formulas, and the reset stuff should be working. I have the installer and files ready to go, I am just testing the different changes I made.

PSI|Dr-X 02-06-2003 01:16 PM

Bytsis any idea of the full version when it's out :) im waiting on it

Dribbles 02-06-2003 05:06 PM

great work ... looking forward to the next version

Mystic Gohan 02-06-2003 08:19 PM

edit: if fixed it.

Solice 02-06-2003 09:28 PM

oh, thnx bistys...
lol

Solice 02-07-2003 07:10 AM

i got anuther prob, my members have updated their rpg stats, but it keeps saying they are illegable for battle...:(

Graphics 02-07-2003 07:28 AM

thnx bitsys thats great

Bitsys 02-07-2003 10:33 AM

Quote:

Originally posted by Solice
i got anuther prob, my members have updated their rpg stats, but it keeps saying they are illegable for battle...:(
Did you read https://vborg.vbsupport.ru/showthrea...672#post328672 yet?

Solice 02-07-2003 11:02 AM

my members have all of them...:(

Graphics 02-08-2003 12:58 PM

Hey Bitsys is there any way you can make random battles and make the person who attacks first random?

Graphics 02-08-2003 01:04 PM

Oh and can you add the limit break hack?
That would make it perfect ;)

Rufus69 02-08-2003 04:23 PM

bah, why doesn't the weapons work?

I hate punching people >_<

Dribbles 02-08-2003 08:32 PM

Can you make it so that the other person doesn't need you to accept the battle before fighting? That way people can jump each other with sneak attacks :) They'll need to form gangs for protection LOL!

Graphics 02-08-2003 10:05 PM

Nah that would be kool Dribbles.

mr e 02-09-2003 02:41 AM

what happens when a level 20 challenges a level 2?


All times are GMT. The time now is 02:15 AM.

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.02998 seconds
  • Memory Usage 1,847KB
  • 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
  • (3)bbcode_php_printable
  • (8)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