|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Support::Linux Servers Support forum for Linux EQEMu users. |
 |
|
 |
04-10-2011, 09:47 PM
|
 |
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
Looking at your core dumps, I would guess the problem is with items.
Code:
#3 0x00000000007314df in SoD::SerializeItem (inst=0x7fc81c000c70,
slot_id_in=0, length=0x7fffffffc664, depth=0 '\0')
at /usr/include/c++/4.3/istream:587
#4 0x0000000000732f19 in SoD::Strategy::Encode_OP_CharInventory (
p=<value optimized out>, dest=0x7fc81c036e70, ack_req=true)
at ../common/patches/SoD.cpp:1250
#5 0x0000000000735d64 in StructStrategy::Encode (this=0x7fc82ee8cf00,
p=0x7fffffffc1f8, dest=0x7fffffffbfb0, ack_req=72)
at ../common/StructStrategy.cpp:22
#6 0x000000000070790f in EQStreamProxy::FastQueuePacket (
this=<value optimized out>, p=0x7fffffffbfb0, ack_req=112)
at ../common/EQStreamProxy.cpp:36
#7 0x0000000000707774 in EQStreamProxy::QueuePacket (this=0x7fc81c03ded0,
p=<value optimized out>, ack_req=72) at ../common/EQStreamProxy.cpp:30
#8 0x00000000004dff17 in Client::QueuePacket (this=<value optimized out>,
app=0x7fffffffbfb0, ack_req=72, required_state=469765232, filter=787009280)
at client.cpp:750
---Type <return> to continue, or q <return> to quit---
#9 0x00000000004f59ca in Client::BulkSendInventoryItems (this=0x7fc81c002450)
at client_process.cpp:935
Your zones are crashing when loading inventory/items, so something with them being sent is causing it. You can find a little more information about the crash if you go through the frames and list the code around each frame.
Example:
To prove your issue is item related, I started a char on your server on Titanium and deleted all items on it. Then, exited and logged him in using SoD and got in just fine. Though, it looks like you clearly have other issues, because I got myself killed and it crashed the zone as well. I think that zone crash was probably related to the new respawn window. You might want to try disabling that in your rules once you get your items issue worked out. |
 |
|
 |
|
|
|
04-10-2011, 10:02 PM
|
 |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,072
|
|
Quote:
Originally Posted by trevius
Looking at your core dumps, I would guess the problem is with items.
Code:
#3 0x00000000007314df in SoD::SerializeItem (inst=0x7fc81c000c70,
slot_id_in=0, length=0x7fffffffc664, depth=0 '\0')
at /usr/include/c++/4.3/istream:587
#4 0x0000000000732f19 in SoD::Strategy::Encode_OP_CharInventory (
p=<value optimized out>, dest=0x7fc81c036e70, ack_req=true)
at ../common/patches/SoD.cpp:1250
#5 0x0000000000735d64 in StructStrategy::Encode (this=0x7fc82ee8cf00,
p=0x7fffffffc1f8, dest=0x7fffffffbfb0, ack_req=72)
at ../common/StructStrategy.cpp:22
#6 0x000000000070790f in EQStreamProxy::FastQueuePacket (
this=<value optimized out>, p=0x7fffffffbfb0, ack_req=112)
at ../common/EQStreamProxy.cpp:36
#7 0x0000000000707774 in EQStreamProxy::QueuePacket (this=0x7fc81c03ded0,
p=<value optimized out>, ack_req=72) at ../common/EQStreamProxy.cpp:30
#8 0x00000000004dff17 in Client::QueuePacket (this=<value optimized out>,
app=0x7fffffffbfb0, ack_req=72, required_state=469765232, filter=787009280)
at client.cpp:750
---Type <return> to continue, or q <return> to quit---
#9 0x00000000004f59ca in Client::BulkSendInventoryItems (this=0x7fc81c002450)
at client_process.cpp:935
Your zones are crashing when loading inventory/items, so something with them being sent is causing it. You can find a little more information about the crash if you go through the frames and list the code around each frame.
Example:
To prove your issue is item related, I started a char on your server on Titanium and deleted all items on it. Then, exited and logged him in using SoD and got in just fine. Though, it looks like you clearly have other issues, because I got myself killed and it crashed the zone as well. I think that zone crash was probably related to the new respawn window. You might want to try disabling that in your rules once you get your items issue worked out. |
I told him the same thing regarding items last week...
Quote:
[20:35] Kingmort: and this has more info
[20:35] Kingmort: http://pastebin.com/qhBLequ3
[20:40] Akkadius: Sorry was afk
[20:41] Akkadius: Sure you replaced all the .conf's?
[20:41] Akkadius: Looks like packet sends
[20:42] Akkadius: item related
[20:43] Kingmort: yeah i've replaced all the conf files several times
[20:43] Kingmort: oh .. so items table issue?
[20:44] Akkadius: Could be
[20:44] Akkadius: But if it was solely the items table causing issues you wouldn't be able to get even Titanium users in, much less boot the processes alone
[20:45] Kingmort: I'll check PEQ's latest release for items table, and compaire it to mine
[20:55] Kingmort: one thing i've noticed so far, my table has Unk061, but latest peq doesn't even have that at all
[20:56] Akkadius: Older SQL updates
[20:57] Akkadius: http://code.google.com/p/projecteqem...le_cleanup.sql
[20:57] Akkadius: Have you ran that?
[21:01] Kingmort: that one line
[21:01] Kingmort: ALTER TABLE items CHANGE UNK061 elitematerial INT(11) DEFAULT 0 NOT NULL;
[21:01] Kingmort: it gave an error said elitematerial already existed
[21:02] Akkadius: Chances are you have ran it then
[21:02] Akkadius: what about the drop entries
|
I don't know how far he went with this tho.
|
|
|
|
|
|
|
04-11-2011, 12:33 AM
|
|
Banned
|
|
Join Date: Sep 2006
Posts: 841
|
|
Right yeah they are both the same now , it could be something with some items added recently. I'll also have to go in and check out the inventory table.
Thing's I've done THUS FAR:
* Replaced all .conf files
* Gone to latest build
* Confirmed Items Table is the same as PEQ
Here are the two core drops from today , Assuming one of them is yours Trev  thanks for the help testing.
Code:
Core was generated by `./zone'.
Program terminated with signal 11, Segmentation fault.
[New process 4633]
[New process 4639]
[New process 4638]
[New process 4637]
[New process 4636]
#0 0x00007fed88b29e42 in std::locale::operator= ()
from /usr/lib/libstdc++.so.6
(gdb) frame 1
#1 0x00007fed88b28a02 in std::ios_base::_M_init ()
from /usr/lib/libstdc++.so.6
(gdb) list
153
154 //bool ZoneBootup(int32 iZoneID, bool iStaticZone = false);
155 //char *strsep(char **stringp, const char *delim);
156
157 #ifdef ADDONCMD
158 #include "addoncmd.h"
159 extern AddonCmd addonCmd;
160 #endif
161
162 int main(int argc, char** argv) {
(gdb) frame 2
#2 0x00007fed88b3be69 in std::basic_ios<char, std::char_traits<char> >::init
() from /usr/lib/libstdc++.so.6
(gdb) list
163 const char *zone_name;
164
165 if(argc == 3) {
166 worldserver.SetLauncherName(argv[2]);
167 worldserver.SetLaunchedName(argv[1]);
168 if(strncmp(argv[1], "dynamic_", 8) == 0) {
169 //dynamic zone with a launcher name correlation
170 zone_name = ".";
171 } else {
172 zone_name = argv[1];
(gdb) frame 3
#3 0x000000000073503b in SoD::Strategy::Encode_OP_ZonePlayerToBind (
p=0x7fffffffe0e8, dest=0x7fed741e98f0, ack_req=<value optimized out>)
at /usr/include/c++/4.3/istream:587
587 { this->init(0); }
(gdb) list
582 //@}
583
584 protected:
585 basic_istream()
586 : _M_gcount(streamsize(0))
587 { this->init(0); }
588
589 template<typename _ValueT>
590 __istream_type&
591 _M_extract(_ValueT& __v);
(gdb) frame 4
#4 0x0000000000735d64 in StructStrategy::Encode (this=0x7fed88dbdf00,
p=0x7fffffffdf48, dest=0x7fffffffdd40, ack_req=72)
at ../common/StructStrategy.cpp:22
22 proc(p, dest, ack_req);
(gdb) list
17 }
18
19 void StructStrategy::Encode(EQApplicationPacket **p, EQStream *dest, bool ack_req) const {
20 EmuOpcode op = (*p)->GetOpcode();
21 Encoder proc = encoders[op];
22 proc(p, dest, ack_req);
23 }
24
25 void StructStrategy::Decode(EQApplicationPacket *p) const {
26 EmuOpcode op = p->GetOpcode();
(gdb) frame 5
#5 0x000000000070790f in EQStreamProxy::FastQueuePacket (
this=<value optimized out>, p=0x7fffffffdd40, ack_req=224)
at ../common/EQStreamProxy.cpp:36
36 m_structs->Encode(p, m_stream, ack_req);
(gdb) list
31 }
32
33 void EQStreamProxy::FastQueuePacket(EQApplicationPacket **p, bool ack_req) {
34 if(p == NULL || *p == NULL)
35 return;
36 m_structs->Encode(p, m_stream, ack_req);
37 }
38
39 EQApplicationPacket *EQStreamProxy::PopPacket() {
40 EQApplicationPacket *pack = m_stream->PopPacket();
(gdb)
Code:
Core was generated by `./zone'.
Program terminated with signal 11, Segmentation fault.
[New process 4641]
[New process 4647]
[New process 4646]
[New process 4645]
[New process 4644]
#0 0x00007f18f325ee42 in std::locale::operator= ()
from /usr/lib/libstdc++.so.6
(gdb) frame 1
#1 0x00007f18f325da02 in std::ios_base::_M_init ()
from /usr/lib/libstdc++.so.6
(gdb) list
153
154 //bool ZoneBootup(int32 iZoneID, bool iStaticZone = false);
155 //char *strsep(char **stringp, const char *delim);
156
157 #ifdef ADDONCMD
158 #include "addoncmd.h"
159 extern AddonCmd addonCmd;
160 #endif
161
162 int main(int argc, char** argv) {
(gdb) frame 2
#2 0x00007f18f3270e69 in std::basic_ios<char, std::char_traits<char> >::init
() from /usr/lib/libstdc++.so.6
(gdb) list
163 const char *zone_name;
164
165 if(argc == 3) {
166 worldserver.SetLauncherName(argv[2]);
167 worldserver.SetLaunchedName(argv[1]);
168 if(strncmp(argv[1], "dynamic_", 8) == 0) {
169 //dynamic zone with a launcher name correlation
170 zone_name = ".";
171 } else {
172 zone_name = argv[1];
(gdb) frame 3
#3 0x00000000007314df in SoD::SerializeItem (inst=0x7f18e800ae50,
slot_id_in=22, length=0x7fffffffb114, depth=0 '\0')
at /usr/include/c++/4.3/istream:587
587 { this->init(0); }
(gdb) list
582 //@}
583
584 protected:
585 basic_istream()
586 : _M_gcount(streamsize(0))
587 { this->init(0); }
588
589 template<typename _ValueT>
590 __istream_type&
591 _M_extract(_ValueT& __v);
(gdb) frame 4
#4 0x0000000000732f19 in SoD::Strategy::Encode_OP_CharInventory (
p=<value optimized out>, dest=0x7f18e060f9e0, ack_req=true)
at ../common/patches/SoD.cpp:1250
1250 char* Serialized = SerializeItem((const ItemInst*)eq->inst, eq->slot_id, &Length, 0);
(gdb) list
1245
1246 for(int r = 0; r < ItemCount; r++, eq++) {
1247
1248 uint32 Length = 0;
1249
1250 char* Serialized = SerializeItem((const ItemInst*)eq->inst, eq->slot_id, &Length, 0);
1251
1252 if(Serialized) {
1253
1254 uchar *OldBuffer = in->pBuffer;
(gdb) frame 5
#5 0x0000000000735d64 in StructStrategy::Encode (this=0x7f18f34f2f00,
p=0x7fffffffaca8, dest=0x7fffffffaa60, ack_req=72)
at ../common/StructStrategy.cpp:22
22 proc(p, dest, ack_req);
(gdb) list
17 }
18
19 void StructStrategy::Encode(EQApplicationPacket **p, EQStream *dest, bool ack_req) const {
20 EmuOpcode op = (*p)->GetOpcode();
21 Encoder proc = encoders[op];
22 proc(p, dest, ack_req);
23 }
24
25 void StructStrategy::Decode(EQApplicationPacket *p) const {
26 EmuOpcode op = p->GetOpcode();
(gdb)
|
|
|
|
|
|
|
04-11-2011, 04:17 AM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
I am not sure why it works for Titanium and not other clients, but my best guess is that you still have some table issues. There are a lot of required SQL updates needed from the older revision you were probably running. You may have 1 or more fields set to incompatible default values that cause them to fail when loading or something like that. You might also need to make sure that when you compile, you are compiling all of the most recent files in the common/patches/ folder. If you are compiling older version of the patch files, who know what odd issues it would cause.
Since there are other crash issues related to the SoD client (and probably other new clients), I would think your problem is with the patch files you are compiling. It could probably also be an issue with your shared mem file compile, but I really have no clue how you have stuff setup.
There is also a chance you could be running into some 64bit issue, cause I don't know much about what to expect crash-wise from that. As far as I know, the source should work with 64 bit, but I haven't tested it myself to confirm.
And yeah, both of those crashes were me. One was when I first created the char using SoD and the other is when I died on the char after I deleted all items on him.
|
|
|
|
04-29-2011, 02:12 PM
|
|
Banned
|
|
Join Date: Sep 2006
Posts: 841
|
|
Still have no clue what is causing this.. What more info do people need in order to fix this issue ?? More Core Drops ?? I can put the schema of my tables in here, though i have double checked they are the same as PEQ's rev 1752 exactly...
I need to get this fixed !
|
|
|
|
05-02-2011, 02:31 PM
|
|
Banned
|
|
Join Date: Sep 2006
Posts: 841
|
|
After looking through all the SQL updates after trev said that might be whatsup I ran into some that were updating this table : "tblWorldServerRegistration"
Well, I don't have that table what is it.. Is it important , would it be causing this? (maybe not)
I couldn't find any of the updates really pertaining to the items or inventory table other than 1542_items_table_cleanup
Here is my Schema for Items and Inventory , maybe some one can see something I am not.
-=ITEMS=-
Code:
CREATE TABLE IF NOT EXISTS `items` (
`id` int(11) NOT NULL default '0',
`minstatus` smallint(5) NOT NULL default '0',
`Name` varchar(64) NOT NULL default '',
`aagi` int(11) NOT NULL default '0',
`ac` int(11) NOT NULL default '0',
`accuracy` int(11) NOT NULL default '0',
`acha` int(11) NOT NULL default '0',
`adex` int(11) NOT NULL default '0',
`aint` int(11) NOT NULL default '0',
`artifactflag` tinyint(3) unsigned NOT NULL default '0',
`asta` int(11) NOT NULL default '0',
`astr` int(11) NOT NULL default '0',
`attack` int(11) NOT NULL default '0',
`augrestrict` int(11) NOT NULL default '0',
`augslot1type` tinyint(3) NOT NULL default '0',
`augslot1visible` tinyint(3) default NULL,
`augslot2type` tinyint(3) NOT NULL default '0',
`augslot2visible` tinyint(3) default NULL,
`augslot3type` tinyint(3) NOT NULL default '0',
`augslot3visible` tinyint(3) default NULL,
`augslot4type` tinyint(3) NOT NULL default '0',
`augslot4visible` tinyint(3) default NULL,
`augslot5type` tinyint(3) NOT NULL default '0',
`augslot5visible` tinyint(3) default NULL,
`augtype` int(11) NOT NULL default '0',
`avoidance` int(11) NOT NULL default '0',
`awis` int(11) NOT NULL default '0',
`bagsize` int(11) NOT NULL default '0',
`bagslots` int(11) NOT NULL default '0',
`bagtype` int(11) NOT NULL default '0',
`bagwr` int(11) NOT NULL default '0',
`banedmgamt` int(11) NOT NULL default '0',
`banedmgraceamt` int(11) NOT NULL default '0',
`banedmgbody` int(11) NOT NULL default '0',
`banedmgrace` int(11) NOT NULL default '0',
`bardtype` int(11) NOT NULL default '0',
`bardvalue` int(11) NOT NULL default '0',
`book` int(11) NOT NULL default '0',
`casttime` int(11) NOT NULL default '0',
`casttime_` int(11) NOT NULL default '0',
`charmfile` varchar(32) NOT NULL default '',
`charmfileid` varchar(32) NOT NULL default '',
`classes` int(11) NOT NULL default '0',
`color` int(10) unsigned NOT NULL default '0',
`combateffects` varchar(10) NOT NULL default '',
`extradmgskill` int(11) NOT NULL default '0',
`extradmgamt` int(11) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`cr` int(11) NOT NULL default '0',
`damage` int(11) NOT NULL default '0',
`damageshield` int(11) NOT NULL default '0',
`deity` int(11) NOT NULL default '0',
`delay` int(11) NOT NULL default '0',
`augdistiller` int(11) NOT NULL default '0',
`dotshielding` int(11) NOT NULL default '0',
`dr` int(11) NOT NULL default '0',
`clicktype` int(11) NOT NULL default '0',
`clicklevel2` int(11) NOT NULL default '0',
`elemdmgtype` int(11) NOT NULL default '0',
`elemdmgamt` int(11) NOT NULL default '0',
`endur` int(11) NOT NULL default '0',
`factionamt1` int(11) NOT NULL default '0',
`factionamt2` int(11) NOT NULL default '0',
`factionamt3` int(11) NOT NULL default '0',
`factionamt4` int(11) NOT NULL default '0',
`factionmod1` int(11) NOT NULL default '0',
`factionmod2` int(11) NOT NULL default '0',
`factionmod3` int(11) NOT NULL default '0',
`factionmod4` int(11) NOT NULL default '0',
`filename` varchar(32) NOT NULL default '',
`focuseffect` int(11) NOT NULL default '0',
`fr` int(11) NOT NULL default '0',
`fvnodrop` int(11) NOT NULL default '0',
`haste` int(11) NOT NULL default '0',
`clicklevel` int(11) NOT NULL default '0',
`hp` int(11) NOT NULL default '0',
`regen` int(11) NOT NULL default '0',
`icon` int(11) NOT NULL default '0',
`idfile` varchar(30) NOT NULL default '',
`itemclass` int(11) NOT NULL default '0',
`itemtype` int(11) NOT NULL default '0',
`ldonprice` int(11) NOT NULL default '0',
`ldontheme` int(11) NOT NULL default '0',
`ldonsold` int(11) NOT NULL default '0',
`light` int(11) NOT NULL default '0',
`lore` varchar(80) NOT NULL default '',
`loregroup` int(11) NOT NULL default '0',
`magic` int(11) NOT NULL default '0',
`mana` int(11) NOT NULL default '0',
`manaregen` int(11) NOT NULL default '0',
`enduranceregen` int(11) NOT NULL default '0',
`material` int(11) NOT NULL default '0',
`maxcharges` int(11) NOT NULL default '0',
`mr` int(11) NOT NULL default '0',
`nodrop` int(11) NOT NULL default '0',
`norent` int(11) NOT NULL default '0',
`pendingloreflag` tinyint(3) unsigned NOT NULL default '0',
`pr` int(11) NOT NULL default '0',
`procrate` int(11) NOT NULL default '0',
`races` int(11) NOT NULL default '0',
`range` int(11) NOT NULL default '0',
`reclevel` int(11) NOT NULL default '0',
`recskill` int(11) NOT NULL default '0',
`reqlevel` int(11) NOT NULL default '0',
`sellrate` float NOT NULL default '0',
`shielding` int(11) NOT NULL default '0',
`size` int(11) NOT NULL default '0',
`skillmodtype` int(11) NOT NULL default '0',
`skillmodvalue` int(11) NOT NULL default '0',
`slots` int(11) NOT NULL default '0',
`clickeffect` int(11) NOT NULL default '0',
`spellshield` int(11) NOT NULL default '0',
`strikethrough` int(11) NOT NULL default '0',
`stunresist` int(11) NOT NULL default '0',
`summonedflag` tinyint(3) unsigned NOT NULL default '0',
`tradeskills` int(11) NOT NULL default '0',
`favor` int(11) NOT NULL default '0',
`weight` int(11) NOT NULL default '0',
`UNK012` int(11) NOT NULL default '0',
`UNK013` int(11) NOT NULL default '0',
`benefitflag` int(11) NOT NULL default '0',
`UNK054` int(11) NOT NULL default '0',
`UNK059` int(11) NOT NULL default '0',
`booktype` int(11) NOT NULL default '0',
`recastdelay` int(11) NOT NULL default '0',
`recasttype` int(11) NOT NULL default '0',
`guildfavor` int(11) NOT NULL default '0',
`UNK123` int(11) NOT NULL default '0',
`UNK124` int(11) NOT NULL default '0',
`attuneable` int(11) NOT NULL default '0',
`nopet` int(11) NOT NULL default '0',
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
`comment` varchar(255) NOT NULL default '',
`UNK127` int(11) NOT NULL default '0',
`pointtype` int(11) NOT NULL default '0',
`potionbelt` int(11) NOT NULL default '0',
`potionbeltslots` int(11) NOT NULL default '0',
`stacksize` int(11) NOT NULL default '0',
`notransfer` int(11) NOT NULL default '0',
`stackable` int(11) NOT NULL default '0',
`UNK134` varchar(255) NOT NULL default '',
`UNK137` int(11) NOT NULL default '0',
`proceffect` int(11) NOT NULL default '0',
`proctype` int(11) NOT NULL default '0',
`proclevel2` int(11) NOT NULL default '0',
`proclevel` int(11) NOT NULL default '0',
`UNK142` int(11) NOT NULL default '0',
`worneffect` int(11) NOT NULL default '0',
`worntype` int(11) NOT NULL default '0',
`wornlevel2` int(11) NOT NULL default '0',
`wornlevel` int(11) NOT NULL default '0',
`UNK147` int(11) NOT NULL default '0',
`focustype` int(11) NOT NULL default '0',
`focuslevel2` int(11) NOT NULL default '0',
`focuslevel` int(11) NOT NULL default '0',
`UNK152` int(11) NOT NULL default '0',
`scrolleffect` int(11) NOT NULL default '0',
`scrolltype` int(11) NOT NULL default '0',
`scrolllevel2` int(11) NOT NULL default '0',
`scrolllevel` int(11) NOT NULL default '0',
`UNK157` int(11) NOT NULL default '0',
`serialized` datetime default NULL,
`verified` datetime default NULL,
`serialization` text,
`source` varchar(20) NOT NULL default '',
`UNK033` int(11) NOT NULL default '0',
`lorefile` varchar(32) NOT NULL default '',
`UNK014` int(11) NOT NULL default '0',
`svcorruption` int(11) NOT NULL default '0',
`UNK038` int(11) NOT NULL default '0',
`UNK060` int(11) NOT NULL default '0',
`augslot1unk2` int(11) NOT NULL default '0',
`augslot2unk2` int(11) NOT NULL default '0',
`augslot3unk2` int(11) NOT NULL default '0',
`augslot4unk2` int(11) NOT NULL default '0',
`augslot5unk2` int(11) NOT NULL default '0',
`UNK120` int(11) NOT NULL default '0',
`UNK121` int(11) NOT NULL default '0',
`questitemflag` int(11) NOT NULL default '0',
`UNK132` text NOT NULL,
`clickunk5` int(11) NOT NULL default '0',
`clickunk6` varchar(32) NOT NULL default '',
`clickunk7` int(11) NOT NULL default '0',
`procunk1` int(11) NOT NULL default '0',
`procunk2` int(11) NOT NULL default '0',
`procunk3` int(11) NOT NULL default '0',
`procunk4` int(11) NOT NULL default '0',
`procunk6` varchar(32) NOT NULL default '',
`procunk7` int(11) NOT NULL default '0',
`wornunk1` int(11) NOT NULL default '0',
`wornunk2` int(11) NOT NULL default '0',
`wornunk3` int(11) NOT NULL default '0',
`wornunk4` int(11) NOT NULL default '0',
`wornunk5` int(11) NOT NULL default '0',
`wornunk6` varchar(32) NOT NULL default '',
`wornunk7` int(11) NOT NULL default '0',
`focusunk1` int(11) NOT NULL default '0',
`focusunk2` int(11) NOT NULL default '0',
`focusunk3` int(11) NOT NULL default '0',
`focusunk4` int(11) NOT NULL default '0',
`focusunk5` int(11) NOT NULL default '0',
`focusunk6` varchar(32) NOT NULL default '',
`focusunk7` int(11) NOT NULL default '0',
`scrollunk1` int(11) NOT NULL default '0',
`scrollunk2` int(11) NOT NULL default '0',
`scrollunk3` int(11) NOT NULL default '0',
`scrollunk4` int(11) NOT NULL default '0',
`scrollunk5` int(11) NOT NULL default '0',
`scrollunk6` varchar(32) NOT NULL default '',
`scrollunk7` int(11) NOT NULL default '0',
`UNK193` int(11) NOT NULL default '0',
`purity` int(11) NOT NULL default '0',
`evolvinglevel` int(11) NOT NULL default '0',
`clickname` varchar(64) NOT NULL default '',
`procname` varchar(64) NOT NULL default '',
`wornname` varchar(64) NOT NULL default '',
`focusname` varchar(64) NOT NULL default '',
`scrollname` varchar(64) NOT NULL default '',
`dsmitigation` smallint(6) NOT NULL default '0',
`heroic_str` smallint(6) NOT NULL default '0',
`heroic_int` smallint(6) NOT NULL default '0',
`heroic_wis` smallint(6) NOT NULL default '0',
`heroic_agi` smallint(6) NOT NULL default '0',
`heroic_dex` smallint(6) NOT NULL default '0',
`heroic_sta` smallint(6) NOT NULL default '0',
`heroic_cha` smallint(6) NOT NULL default '0',
`heroic_pr` smallint(6) NOT NULL default '0',
`heroic_dr` smallint(6) NOT NULL default '0',
`heroic_fr` smallint(6) NOT NULL default '0',
`heroic_cr` smallint(6) NOT NULL default '0',
`heroic_mr` smallint(6) NOT NULL default '0',
`heroic_svcorrup` smallint(6) NOT NULL default '0',
`healamt` smallint(6) NOT NULL default '0',
`spelldmg` smallint(6) NOT NULL default '0',
`clairvoyance` smallint(6) NOT NULL default '0',
`backstabdmg` smallint(6) NOT NULL default '0',
`created` varchar(64) NOT NULL default '',
`elitematerial` smallint(6) NOT NULL default '0',
`ldonsellbackrate` smallint(6) NOT NULL default '0',
`scriptfileid` smallint(6) NOT NULL default '0',
`expendablearrow` smallint(6) NOT NULL default '0',
`powersourcecapacity` smallint(6) NOT NULL default '0',
`bardeffect` smallint(6) NOT NULL default '0',
`bardeffecttype` smallint(6) NOT NULL default '0',
`bardlevel2` smallint(6) NOT NULL default '0',
`bardlevel` smallint(6) NOT NULL default '0',
`bardunk1` smallint(6) NOT NULL default '0',
`bardunk2` smallint(6) NOT NULL default '0',
`bardunk3` smallint(6) NOT NULL default '0',
`bardunk4` smallint(6) NOT NULL default '0',
`bardunk5` smallint(6) NOT NULL default '0',
`bardname` varchar(64) NOT NULL default '',
`bardunk7` smallint(6) NOT NULL default '0',
`UNK214` smallint(6) NOT NULL default '0',
UNIQUE KEY `ID` (`id`),
KEY `name_idx` (`Name`),
KEY `lore_idx` (`lore`),
KEY `minstatus` (`minstatus`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-=INVENTORY=-
Code:
CREATE TABLE IF NOT EXISTS `inventory` (
`charid` int(11) unsigned NOT NULL default '0',
`slotid` mediumint(7) unsigned NOT NULL default '0',
`itemid` int(11) unsigned default '0',
`charges` tinyint(3) unsigned default '0',
`color` int(11) unsigned NOT NULL default '0',
`augslot1` mediumint(7) unsigned NOT NULL default '0',
`augslot2` mediumint(7) unsigned NOT NULL default '0',
`augslot3` mediumint(7) unsigned NOT NULL default '0',
`augslot4` mediumint(7) unsigned NOT NULL default '0',
`augslot5` mediumint(7) unsigned default '0',
`instnodrop` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`charid`,`slotid`),
KEY `ix_inventory_itemid` (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Any help would be greatly appreciated
|
|
|
|
|
|
|
05-07-2011, 02:41 PM
|
|
Banned
|
|
Join Date: Sep 2006
Posts: 841
|
|
Oh also :
Code:
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch 6.2
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch Titanium
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch SoF
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch SoD
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch Underfoot
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch HoT
So the patch files are loading for sure.. I just have to figure out the exact cause of whats doing this in order to fix it.
The one thing I do see from most of these depending on what client they use of course is lines similar to this listed under frames 3 and 4..
Code:
#3 0x0000000000743047 in Underfoot::SerializeItem (inst=0x7f9474171b90,
slot_id_in=22, length=0x7fffffffa984, depth=0 '\0')
at /usr/include/c++/4.3/istream:587
587 { this->init(0); }
(gdb) frame 4
#4 0x0000000000744b21 in Underfoot::Strategy::Encode_OP_CharInventory (
p=<value optimized out>, dest=0x17b2480, ack_req=true)
at ../common/patches/Underfoot.cpp:1278
1278 char* Serialized = SerializeItem((const ItemInst*)eq->inst, eq->slot_id, &Length, 0);
(gdb) list
1273
1274 for(int r = 0; r < ItemCount; r++, eq++) {
1275
1276 uint32 Length = 0;
1277
1278 char* Serialized = SerializeItem((const ItemInst*)eq->inst, eq->slot_id, &Length, 0);
1279
1280 if(Serialized) {
1281
1282 uchar *OldBuffer = in->pBuffer;
(gdb)
I see no sign of SerializedItem anywhere in Inventory or Items, i do find a "serialized" in items but those are all set to either NULL or "0000-00-00 00:00:00" also i see "serialization" but those are all set to NULL as they should be.
Mort
|
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Hybrid Mode
|
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 12:12 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
