Item charges = 0

[dzags]

I'm running a 6.0 dr1 server over my LAN but we seem to have a few problems that I was wondering if anyone could help me iron out. I apologize if the answers to these problems are elsewhere, I'm still in the process of looking for them.

1) All items with charges (such as journeyboots) say that they have no charges when we right click on them... why?
2) Monster agro, how do we fix it? I read something about needing the map files but where do I put them?
3)When we login it frequently drops us from a very high place causing a death if we dont do a quick #zone.

Thanks in advance.

[adark2002]

1)To get clickies working try this:

At the command prompt type:
cd\mysql\bin
mysql -u root <dbname>
UPDATE items SET unknown008=1;
quit
exit

2)Do a search to locate where to download the map files ya need then make a Maps folder in your eqemu directory and put them there.(Its a big file)

3)Still trying to get this one figured myself

Good luck

[sotonin]

i wouldnt do that.

id do

UPDATE items SET unknown008=1 WHERE unknown008=0;

otherwise you overwrite items that had values other than 0

[dzags]

Thank you, I appreciate it alot

[Elkay]

I also thought that the zone data is all stored in the db now.. do we need the map files again now?

[sotonin]

the zone config files are in the db. meaning you dont need the /cfg folder. but yes you need maps

[Edgar1898]

heh, didnt see your thread until I had finished fixing it

[Elkay]

Originally Posted by sotonin

the zone config files are in the db. meaning you dont need the /cfg folder. but yes you need maps

How come my pathing worked fine prior to this release even though I had no map files? So with no map files I have to disable all my pathing now?

[Edgar1898]

you need maps for agro, unless they changed paths as well (I havent looked that deeply into paths) it should work the same whether you have maps or not.

[sotonin]

exactly as edgar said. map files have nothing to do with pathing at all. they only affect agro

[dzags]

UPDATE items SET unknown008=1 WHERE unknown008=0;

running that on my db (6.0) results in

ERROR 1054: Unknown column 'unknown008' in 'where clause'

ack.

[movieman]

I believe 'unknown008' was renamed to 'SpellCharges'. That was one of the things I had to fix in my database to get 6.0 running last night.

[Xothin]

Unfortunately, this isn't a permanent fix.

When you log out, and back in, the item will then start saying, Item out of Charges again.

[garim12]

I've been having the same problem on my server. Here's how I fixed it:

First, I looked through the code and found this in database.cpp:

uint32 len_query = MakeAnyLenString(&query, "REPLACE INTO inventory (charid,slotid,itemid,charges,color) VALUES(%i,%i,%i,%i,%i)",
char_id, slot_id, inst->GetItem()->ItemNumber, inst->GetCharges(), inst->GetColor() );

inst->GetCharges() returns -1 if the item is a right clicky with infinite charges. However, the charges field in my database's inventory table was an unsigned tinyint. So you'd summon an item with infinite charges, then when it went to write it to the database, the -1 got changed into a 0, hence the Out of Charges message.

So, I removed the unsigned flag on the charges field in inventory and sharedbank and now all my right clickies work. I'm not sure if changing this impacts anything else yet... only been testing it for about a day so far, but I haven't seen any items yet with enough charges to make changing this variable a problem.

[dzags]

Sorry Garim, its late, that post confused the hell out of me What do I need to go about to do that?