Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

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.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2004, 08:08 PM
dzags
Sarnak
 
Join Date: Oct 2004
Posts: 34
Default 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.
Reply With Quote
  #2  
Old 10-15-2004, 09:35 PM
adark2002
Fire Beetle
 
Join Date: Oct 2004
Posts: 2
Default

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
Reply With Quote
  #3  
Old 10-16-2004, 01:03 AM
sotonin
Demi-God
 
Join Date: May 2004
Posts: 1,177
Default

i wouldnt do that.

id do

UPDATE items SET unknown008=1 WHERE unknown008=0;

otherwise you overwrite items that had values other than 0
Reply With Quote
  #4  
Old 10-16-2004, 02:21 AM
dzags
Sarnak
 
Join Date: Oct 2004
Posts: 34
Default

Thank you, I appreciate it alot
__________________
err.
Reply With Quote
  #5  
Old 10-16-2004, 03:21 AM
Elkay
Hill Giant
 
Join Date: Sep 2004
Posts: 184
Default

I also thought that the zone data is all stored in the db now.. do we need the map files again now?
Reply With Quote
  #6  
Old 10-16-2004, 06:51 AM
sotonin
Demi-God
 
Join Date: May 2004
Posts: 1,177
Default

the zone config files are in the db. meaning you dont need the /cfg folder. but yes you need maps
Reply With Quote
  #7  
Old 10-16-2004, 02:20 PM
Edgar1898
Senior Member
Former EQEmu Developer
Current EQ2Emu Lead Developer
 
Join Date: Dec 2002
Posts: 1,065
Default

heh, didnt see your thread until I had finished fixing it
__________________
Lethal Encounter
Reply With Quote
  #8  
Old 10-17-2004, 03:27 AM
Elkay
Hill Giant
 
Join Date: Sep 2004
Posts: 184
Default

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?
Reply With Quote
  #9  
Old 10-17-2004, 03:32 AM
Edgar1898
Senior Member
Former EQEmu Developer
Current EQ2Emu Lead Developer
 
Join Date: Dec 2002
Posts: 1,065
Default

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
Reply With Quote
  #10  
Old 10-17-2004, 04:15 AM
sotonin
Demi-God
 
Join Date: May 2004
Posts: 1,177
Default

exactly as edgar said. map files have nothing to do with pathing at all. they only affect agro
Reply With Quote
  #11  
Old 10-19-2004, 10:08 AM
dzags
Sarnak
 
Join Date: Oct 2004
Posts: 34
Default

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.
Reply With Quote
  #12  
Old 10-21-2004, 12:12 AM
movieman
Fire Beetle
 
Join Date: May 2004
Posts: 25
Default

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.
Reply With Quote
  #13  
Old 10-22-2004, 05:39 AM
Xothin
Sarnak
 
Join Date: Oct 2004
Posts: 68
Default

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

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.
Reply With Quote
  #15  
Old 10-22-2004, 03:34 PM
dzags
Sarnak
 
Join Date: Oct 2004
Posts: 34
Default

Sorry Garim, its late, that post confused the hell out of me What do I need to go about to do that?
__________________
err.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 08:44 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3