|
|
 |
 |
 |
 |
|
 |
 |
|
 |
 |
|
 |
|
Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself. |

10-15-2004, 08:08 PM
|
Sarnak
|
|
Join Date: Oct 2004
Posts: 34
|
|
Item charges = 0
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.
__________________
err.
|

10-15-2004, 09:35 PM
|
Fire Beetle
|
|
Join Date: Oct 2004
Posts: 2
|
|
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
|

10-16-2004, 01:03 AM
|
Demi-God
|
|
Join Date: May 2004
Posts: 1,177
|
|
i wouldnt do that.
id do
UPDATE items SET unknown008=1 WHERE unknown008=0;
otherwise you overwrite items that had values other than 0
|

10-16-2004, 02:21 AM
|
Sarnak
|
|
Join Date: Oct 2004
Posts: 34
|
|
Thank you, I appreciate it alot 
__________________
err.
|

10-16-2004, 03:21 AM
|
Hill Giant
|
|
Join Date: Sep 2004
Posts: 184
|
|
I also thought that the zone data is all stored in the db now.. do we need the map files again now?
|

10-16-2004, 06:51 AM
|
Demi-God
|
|
Join Date: May 2004
Posts: 1,177
|
|
the zone config files are in the db. meaning you dont need the /cfg folder. but yes you need maps
|

10-16-2004, 02:20 PM
|
Senior Member Former EQEmu Developer Current EQ2Emu Lead Developer
|
|
Join Date: Dec 2002
Posts: 1,065
|
|
heh, didnt see your thread until I had finished fixing it
__________________
Lethal Encounter
|

10-17-2004, 03:27 AM
|
Hill Giant
|
|
Join Date: Sep 2004
Posts: 184
|
|
Quote:
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?
|

10-17-2004, 03:32 AM
|
Senior Member Former EQEmu Developer Current EQ2Emu Lead Developer
|
|
Join Date: Dec 2002
Posts: 1,065
|
|
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.
__________________
Lethal Encounter
|

10-17-2004, 04:15 AM
|
Demi-God
|
|
Join Date: May 2004
Posts: 1,177
|
|
exactly as edgar said. map files have nothing to do with pathing at all. they only affect agro
|

10-19-2004, 10:08 AM
|
Sarnak
|
|
Join Date: Oct 2004
Posts: 34
|
|
Code:
UPDATE items SET unknown008=1 WHERE unknown008=0;
running that on my db (6.0) results in
Code:
ERROR 1054: Unknown column 'unknown008' in 'where clause'
ack.
__________________
err.
|

10-21-2004, 12:12 AM
|
Fire Beetle
|
|
Join Date: May 2004
Posts: 25
|
|
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.
|

10-22-2004, 05:39 AM
|
Sarnak
|
|
Join Date: Oct 2004
Posts: 68
|
|
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. 
|
 |
|
 |

10-22-2004, 11:57 AM
|
Fire Beetle
|
|
Join Date: Oct 2004
Location: Tampa, FL
Posts: 19
|
|
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:
Quote:
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.
|
 |
|
 |

10-22-2004, 03:34 PM
|
Sarnak
|
|
Join Date: Oct 2004
Posts: 34
|
|
Sorry Garim, its late, that post confused the hell out of me  What do I need to go about to do that?
__________________
err.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 08:44 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |