EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Development (https://www.eqemulator.org/forums/forumdisplay.php?f=621)
-   -   Item out of charges. (https://www.eqemulator.org/forums/showthread.php?t=14517)

red1234 06-23-2004 12:11 PM

Item out of charges.
 
I dunno if anyone posted about this or if this post belongs here, but the fix for this that I found was to change the new unknown008 column to 1 (or any other number).

I created 2 identical 1hb weps with a click effect for 1 second Cazic Touch that could be activated from inventory or in primary. The only difference was that one had a value of 1 and the other a value of 0 for the unknown008 column. The one with the 1 value worked while the other didn't. I also tested this with 10 Dose Blood of the Wolf and the change worked. I didn't test the effect on non-clicky items though.

Hope this helps, I know on Green Leaf the clicky items weren't working :( .

Scorpious2k 06-25-2004 01:11 AM

Nice work!!!!

RangerDown 06-25-2004 02:16 AM

1 sec clicky Cazic Touch is overpowered :shock:

red1234 06-25-2004 07:28 AM

Oh yea, to change the database, from the mysql folder do:
Code:

mysql -u root
use eq;    *or whatever your datatbase name is*
UPDATE items SET unknown008=1;
exit;

And it hasn't affected any non-clicky items that I've seen.

EDIT: removed mysql from first line and table from 3rd line. Worked when I did it /shrug.

Virus11 06-27-2004 04:02 AM

That didn't work for me, so I asked in #eqemu and RangerDown told me this and it works:

Code:

cd\mysql\bin
mysql -u root <dbname>
UPDATE items SET unknown008=1;
quit
exit


pheer 08-05-2004 03:48 AM

Wtf, when I do this it says something about UNKNOWN column 'unknown008' in 'field list'


All times are GMT -4. The time now is 06:34 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.