NPC Faction DB load failure

[Ethereal]

[[ 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
_______________________________________

[Ethereal]

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

[Ethereal]

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]'

[Ethereal]

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

[Ethereal]

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

[Trumpcard]

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?

[var1ety]

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.

[Ethereal]

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: