Mass schema changes - 2013.08.04

Development forum for the EQ2Emulator Database project.

Moderator: Team Members

Post Reply
User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Mass schema changes - 2013.08.04

Post by John Adams » Sun Aug 04, 2013 12:32 pm

This weekend I have done a lot of work renaming some bad field names, adding fields necessary to support new values in player/npc data, and general cleanup. I have added stuff to character_details, spawn, spawn_npcs, and starting_details today and will commit after testing. Mostly storage for the savagery, dissonance and resists I mentioned in the other post.

Question: I'm assuming NPCs get all this stuff too: savagery, disonnance, elemental, arcane, noxious?


Again, none of my new code is hooked to anything, so hopefully it doesn't break existing code. But from what I see, anything I put in the DB now for "elemental" for instances is going to be overwritten by the elemental=heat hack.

Just a heads up. Minor version 52, coming to an SVN near you soon.

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Re: Mass schema changes - 2013.08.04

Post by John Adams » Sun Aug 04, 2013 12:41 pm

Jab, I'm having a problem with compiling once I added some of my new "Set"s to WorldDatabase. I cannot seem to track it down.
4>WorldDatabase.obj : error LNK2019: unresolved external symbol "public: void __thiscall Spawn::SetTotalSavagery(int)" (?SetTotalSavagery@Spawn@@QAEXH@Z) referenced in function "public: void __thiscall WorldDatabase::LoadNPCs(void)" (?LoadNPCs@WorldDatabase@@QAEXXZ)

4>WorldDatabase.obj : error LNK2019: unresolved external symbol "public: void __thiscall Spawn::SetTotalDissonance(int)" (?SetTotalDissonance@Spawn@@QAEXH@Z) referenced in function "public: void __thiscall WorldDatabase::LoadNPCs(void)" (?LoadNPCs@WorldDatabase@@QAEXXZ)

4>WorldDatabase.obj : error LNK2019: unresolved external symbol "public: void __thiscall Spawn::SetSavagery(int,bool)" (?SetSavagery@Spawn@@QAEXH_N@Z) referenced in function "public: bool __thiscall WorldDatabase::LoadCharacterStats(unsigned int,unsigned int,class Client *)" (?LoadCharacterStats@WorldDatabase@@QAE_NIIPAVClient@@@Z)

4>WorldDatabase.obj : error LNK2019: unresolved external symbol "public: void __thiscall Spawn::SetDissonance(int,bool)" (?SetDissonance@Spawn@@QAEXH_N@Z) referenced in function "public: bool __thiscall WorldDatabase::LoadCharacterStats(unsigned int,unsigned int,class Client *)" (?LoadCharacterStats@WorldDatabase@@QAE_NIIPAVClient@@@Z)
The code in WorldDatabase is:

Code: Select all

		npc->SetTotalSavagery(atoul(row[68]));
		npc->SetTotalDissonance(atoul(row[69]));
And are copies of these same functions, which seem to work just fine:

Code: Select all

		npc->SetTotalHP(atoul(row[26]));
		npc->SetTotalPower(atoul(row[27]));
Advice?

Jabantiz
Lead Developer
Posts: 2912
Joined: Wed Jul 25, 2007 2:52 pm
Location: California

Re: Mass schema changes - 2013.08.04

Post by Jabantiz » Sun Aug 04, 2013 12:44 pm

"unresolved external symbol" usually means it can't find the actual code for those functions listed. If the code is there then try a clean and rebuild.

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Re: Mass schema changes - 2013.08.04

Post by John Adams » Sun Aug 04, 2013 1:36 pm

I'm a dummy. I actually copied the .h declarations of the functions and likely got distracted by Xinux (he loves doing that to me) and never wrote the actual functions themselves. All is well now, thanks!

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests