NPC Faction DB load failure
 

[[ I apologize in advance for using a reply for each error but I wanted to keep each error report clean to avoid confusion, in retrospect I should have used the quote ability I suppose. The compiles are all done using gcc 3.2.2 ]]

eq:~/server/bin> ./startup.zone
Using database 'eq' at localhost
[Status] CURRENT_ZONE_VERSION: EQEMu 0.4.3
[Error] CURRENT_ZONE_VERSION: EQEMu 0.4.3
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] Loading npcs
[Status] Loading npc faction lists
Loading NPC Faction Lists from database...
[Error] Loading npcs faction lists FAILED!
eq:~/server/bin>

gcc32 -c -Wall -Wuninitialized -Wwrite-strings -Wcast-qual -Wbad-function-cast -Wstrict-prototypes -Wno-deprecated -Wnested-externs -Wcomment -Wcast-align -O -ggdb -march=i686 -pipe -D_THREAD_SAFE -D__USE_UNIX98 -D_GNU_SOURCE -DINVERSEXY -DFX -I/usr/include/mysql -I/usr/local/include/mysql -I/usr/local/include/pthread/linuxthreads ../common/database.cpp -o ../common/database.o
../common/database.cpp: In member function `bool Database::LoadNPCTypes()':
../common/database.cpp:3294: warning: unused variable `MYSQL_RES*result2'
../common/database.cpp:3296: warning: unused variable `char**row2'
../common/database.cpp: In member function `bool
Database::GetFactionIdsForNPC(int, LinkedList<NPCFaction*>*, sint32*)':
../common/database.cpp:4551: warning: comparison between signed and unsigned
integer expressions
../common/database.cpp: In member function `bool
Database::LoadNPCFactionLists()':
../common/database.cpp:5002: warning: comparison between signed and unsigned
integer expressions


_______________________________________
Ethereal - The Master Of Spirits
Un-Official EQEMU FreeBSD Complainist
A.K.A - Pain in the ass
_______________________________________

Unrelated to above error, but another section where unused variables appear:
-----------------------------------------------------------------------------------------------------------

gcc32 -c -Wall -Wuninitialized -Wwrite-strings -Wcast-qual -Wbad-function-cast -Wstrict-prototypes -Wno-deprecated -Wnested-externs -Wcomment -Wcast-align -O -ggdb -march=i686 -pipe -D_THREAD_SAFE -D__USE_UNIX98 -D_GNU_SOURCE -DINVERSEXY -DFX -I/usr/include/mysql -I/usr/local/include/mysql -I/usr/local/include/pthread/linuxthreads client_process.cpp -o client_process.o
client_process.cpp: In member function `int Client::HandlePacket(const
APPLAYER*)':
client_process.cpp:194: warning: unused variable `APPLAYER*outapp'
client_process.cpp:1034: warning: comparison between signed and unsigned
integer expressions
client_process.cpp:1479: warning: unused variable `sint16 tx1'
client_process.cpp:1480: warning: unused variable `sint16 tx2'
client_process.cpp:3321: warning: cast from `const char*' to `char*' discards
qualifiers from pointer target type
client_process.cpp:3924: warning: cast from `const Item_Struct*' to `
Item_Struct*' discards qualifiers from pointer target type
client_process.cpp:3916: warning: unused variable `int vlc'
client_process.cpp:3954: warning: cast from `const Item_Struct*' to `
Item_Struct*' discards qualifiers from pointer target type
client_process.cpp:4006: warning: passing `double' for argument 1 of `void
Client::AddMoneyToPP(unsigned int)'
client_process.cpp:4018: warning: passing `double' for argument 1 of `void
Client::AddMoneyToPP(unsigned int)'
client_process.cpp: In member function `void
Client::BulkSendMerchantInventory(int, short unsigned int)':
client_process.cpp:5843: warning: comparison between signed and unsigned
integer expressions

And Another
---------------

gcc32 -c -Wall -Wuninitialized -Wwrite-strings -Wcast-qual -Wbad-function-cast -Wstrict-prototypes -Wno-deprecated -Wnested-externs -Wcomment -Wcast-align -O -ggdb -march=i686 -pipe -D_THREAD_SAFE -D__USE_UNIX98 -D_GNU_SOURCE -DINVERSEXY -DFX -I/usr/include/mysql -I/usr/local/include/mysql -I/usr/local/include/pthread/linuxthreads npc.cpp -o npc.o
npc.cpp: In member function `NPC::NPC(const NPCType*, Spawn2*, float, float,
float, float, bool)':
npc.cpp:106: warning: unused variable `int32 guild'
npc.cpp: In member function `bool Database::NPCSpawnDB(unsigned char, const
char*, NPC*)':
npc.cpp:1239: warning: unused variable `char tmpstr2[64]'
npc.cpp:1266: warning: unused variable `char tmpstr2[64]'

And Another
---------------

gcc32 -c -Wall -Wuninitialized -Wwrite-strings -Wcast-qual -Wbad-function-cast -Wstrict-prototypes -Wno-deprecated -Wnested-externs -Wcomment -Wcast-align -O -ggdb -march=i686 -pipe -D_THREAD_SAFE -D__USE_UNIX98 -D_GNU_SOURCE -DINVERSEXY -DFX -I/usr/include/mysql -I/usr/local/include/mysql -I/usr/local/include/pthread/linuxthreads spells.cpp -o spells.o
spells.cpp: In member function `virtual void Mob::CastSpell(short unsigned int,
short unsigned int, short unsigned int, int, int, int32*)':
spells.cpp:416: warning: comparison between signed and unsigned integer
expressions
spells.cpp: In member function `void Mob::CastedSpellFinished(short unsigned
int, unsigned int, short unsigned int, short unsigned int)':
spells.cpp:557: warning: unused variable `APPLAYER*outapp'
spells.cpp: In member function `void Mob::CalcBonuses()':
spells.cpp:2173: warning: unused variable `StatBonuses*newbon'
spells.cpp: In member function `void Client::CalcEdibleBonuses(StatBonuses*)':
spells.cpp:2233: warning: `uint32 food_inr' might be used uninitialized in this
function
spells.cpp:2235: warning: `uint32 drink_inr' might be used uninitialized in
this function

Last occurance of an unused variable
-----------------------------------------------

gcc32 -c -Wall -Wuninitialized -Wwrite-strings -Wcast-qual -Wbad-function-cast -Wstrict-prototypes -Wno-deprecated -Wnested-externs -Wcomment -Wcast-align -O -ggdb -march=i686 -pipe -D_THREAD_SAFE -D__USE_UNIX98 -D_GNU_SOURCE -DINVERSEXY -DFX -I/usr/include/mysql -I/usr/local/include/mysql -I/usr/local/include/pthread/linuxthreads parser.cpp -o parser.o
parser.cpp: In member function `void Parser::MakeVars(const char*)':
parser.cpp:167: warning: cast from `const char*' to `char*' discards qualifiers
from pointer target type
parser.cpp:170: warning: cast from `const char*' to `char*' discards qualifiers
from pointer target type
parser.cpp: In member function `void Parser::EnumerateVars(char*)':
parser.cpp:419: warning: comparison between signed and unsigned integer
expressions
parser.cpp: In member function `void Parser::CommandEx(char*, unsigned int,
Mob*, Client*)':
parser.cpp:619: warning: unused variable `int8 guildwarset'
parser.cpp:690: warning: cast to pointer from integer of different size
parser.cpp:698: warning: cast to pointer from integer of different size
parser.cpp:720: warning: NULL used in arithmetic

Unused variables arent a problem, it just means someone created a variable name for a future use, and has just neglected to use it..

Are you using an existing database, or did you create one from scratch?

works fine with drawde's database, found in the world building forum, for me.

I miss the days when you could load up the default db and an item list and go, without bothering with mobs or quests or factions.

I got it all up and working :) the base db.sql doesnt include factions the worlddb got it all working tho :) thanks for all yer help you two I know i've been a pain in the ass :lol: