EQEmulator Forums - Looking for Peq.item

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Looking for Peq.item_tick table (https://www.eqemulator.org/forums/showthread.php?t=37282)

mrfireturkey

09-12-2013 01:57 AM

Looking for Peq.item_tick table

I've searched here and on google for any information about the item_tick table. I'm getting zone errors in my logs - database is peq rev 2506. Looking for a pointer as to what sql file/statement I should load.

Thanks.

Code:

Error in Zone::LoadTickItems: SELECT it_itemid, it_chance, it_level, it_qglobal, it_bagslot FROM item_tick (#1146: Table 'peq.item_tick' doesn't exist)

NatedogEZ

09-12-2013 02:11 AM

Code:

CREATE TABLE `item_tick` (

        `it_itemid` INT(11) NOT NULL,

        `it_chance` INT(11) NOT NULL,

        `it_level` INT(11) NOT NULL,

        `it_id` INT(11) NOT NULL AUTO_INCREMENT,

        `it_qglobal` VARCHAR(50) NOT NULL,

        `it_bagslot` TINYINT(4) NOT NULL,

        PRIMARY KEY (`it_id`)

)

COLLATE='latin1_swedish_ci'

ENGINE=MyISAM;

This is what my database has

mrfireturkey

09-12-2013 02:26 AM

Appreciate it!

cavedude

09-12-2013 12:17 PM

SVN is obsolete, please get your DB from: http://peqtgc.com/releases

All times are GMT -4. The time now is 09:42 PM.