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.

I think i will wait for the full version :)

When will release final version?

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

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

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

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]

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.

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
after
although it could have missed something else as well. The whole query should look something like (but not necessarily EXACTLY like):
around line 420 of showthread.php.