CODE for CLANS.. and other stuff

[zad67]

for skill table hum
// Load all our skill data
DoSQL("SELECT id,level,lvl_point,range,power FROM list_data_skills");
result = mysql_store_result(mysql);
while(row = mysql_fetch_row(result)){
CSkillData* thisskilldata = new CSkillData;
thisskilldata->id = atoi(row[0]);
thisskilldata->level = atoi(row[1]);
thisskilldata->lvl_point = atoi(row[2]);
thisskilldata->range = atoi(row[3]);
thisskilldata->power = atoi(row[4]);
SkillData.push_back( thisskilldata );

for list_data_npc table

// Load all our npc data
DoSQL("SELECT id,wspeed,rspeed,level,hpmulti,atkpower,atkspeed,exp,atkdistance,npctab1,npctab2,npctab3,npctab4 FROM list_data_npcs");
result = mysql_store_result(mysql);
while(row = mysql_fetch_row(result)){
CNPCData* thisnpcdata = new CNPCData;
thisnpcdata->id = atoi(row[0]);
thisnpcdata->wspeed = atoi(row[1]);
thisnpcdata->rspeed = atoi(row[2]);
thisnpcdata->level = atoi(row[3]);
thisnpcdata->health = atoi(row[4]);
thisnpcdata->atkpower = atoi(row[5]);
thisnpcdata->atkspeed = atoi(row[6]);
thisnpcdata->exp = atoi(row[7]);
thisnpcdata->atkdistance = atoi(row[8]);
thisnpcdata->tab[0] = atoi(row[9]);
thisnpcdata->tab[1] = atoi(row[10]);
thisnpcdata->tab[2] = atoi(row[11]);
thisnpcdata->tab[3] = atoi(row[12]);
NPCData.push_back( thisnpcdata );
}

for item sell table
// Load all our sell data
DoSQL("SELECT id,item001,item002,item003,item004,item005,item006,item007,item008,item009,item010, \
item011,item012,item013,item014,item015,item016,item017,item018,item019,item020, \
item021,item022,item023,item024,item025,item026,item027,item028,item029,item030, \
item031,item032,item033,item034,item035,item036,item037,item038,item039,item040, \
item041,item042,item043,item044,item045,item046,item047,item048 FROM list_data_sell");

 

[Erwt]

I want to begin scripting.. maybe its nice that if you make a code that you Add that to the database and upload somewhere.. then if some other guy maked nice things too.. add id and upload again, so you get a full SQL file with all things.. (and no noobs asking, how does this work). just an idea.. to make it simple..

 

[deadspirit]

To view the content, you need to sign in or register

DATABASE FOR THOSE TAHT USE MY CODE

 

[zad67]

deadspirit - thanks does the skills table make the skills work if data is correct

 

[Erwt]

Deadspirit.. is that the one with Your AND Zad codes in it? upload it.. post it and set as info.. with things it includes and what it needs to be done..(sry for my english, very fast typing

 

[deadspirit]

yes but i didnt put in my skill tree packets and skills as well.. still learning to reverse how a packet tree gets added or how it works in the packet itself...

a skill packet works like this (command),(size),(BYTES), 03/CF/05/FF/01/AB/... and the size goes on till all are counted for... every skill in the skill tree.. now 03 = the skill number .. CF is the skill type and also the ID uses in the skill itself...

so a skill packet would have USERID..00... 03 (skill number) CF... 05 number of skill points in the tree... etc... hard to explain but just something......

 

[zad67]

there his codes not mine 9dump

Deadspirit - very nice work

 

[Erwt]

yup, oke everytime you release something please do this like example:

Download HERE!
- NPC Buying Selling (Deadspirit)
- Clans Working (Zed67)
- Skills to lvl 70 (Deadspirit)
- Fully Spawn (Zed67)

just for example.. littlebit credits and we know what it is then.. Thanks for understanding

 

[zad67]

or you could read who released/posted it

 

[rl2171]

Does the code go anywhere in each of the files listed?

Anything else besides getting the updated database parts?

One final question, where is the clan icon and clan name stored? (or did I miss that part? ;-) )

 

[kac123ige]

wow all in one night you guys are working hard thanks

 

[AditudE]

Hmmm

[Err] 1406 - Data too long for column 'name' at row 2
[Msg] Finished - Unsuccessfully

When extracting SQL

 

[Akeval]

So how would one go about putting this in? i would like to use it, but could you give instructions?

 

[kac123ige]

for skill table hum
// Load all our skill data
DoSQL("SELECT id,level,lvl_point,range,power FROM list_data_skills");
result = mysql_store_result(mysql);
while(row = mysql_fetch_row(result)){
CSkillData* thisskilldata = new CSkillData;
thisskilldata->id = atoi(row[0]);
thisskilldata->level = atoi(row[1]);
thisskilldata->lvl_point = atoi(row[2]);
thisskilldata->range = atoi(row[3]);
thisskilldata->power = atoi(row[4]);
SkillData.push_back( thisskilldata );

for list_data_npc table

// Load all our npc data
DoSQL("SELECT id,wspeed,rspeed,level,hpmulti,atkpower,atkspeed,exp,atkdistance,npctab1,npctab2,npctab3,npctab4 FROM list_data_npcs");
result = mysql_store_result(mysql);
while(row = mysql_fetch_row(result)){
CNPCData* thisnpcdata = new CNPCData;
thisnpcdata->id = atoi(row[0]);
thisnpcdata->wspeed = atoi(row[1]);
thisnpcdata->rspeed = atoi(row[2]);
thisnpcdata->level = atoi(row[3]);
thisnpcdata->health = atoi(row[4]);
thisnpcdata->atkpower = atoi(row[5]);
thisnpcdata->atkspeed = atoi(row[6]);
thisnpcdata->exp = atoi(row[7]);
thisnpcdata->atkdistance = atoi(row[8]);
thisnpcdata->tab[0] = atoi(row[9]);
thisnpcdata->tab[1] = atoi(row[10]);
thisnpcdata->tab[2] = atoi(row[11]);
thisnpcdata->tab[3] = atoi(row[12]);
NPCData.push_back( thisnpcdata );
}

for item sell table
// Load all our sell data
DoSQL("SELECT id,item001,item002,item003,item004,item005,item006,item007,item008,item009,item010, \
item011,item012,item013,item014,item015,item016,item017,item018,item019,item020, \
item021,item022,item023,item024,item025,item026,item027,item028,item029,item030, \
item031,item032,item033,item034,item035,item036,item037,item038,item039,item040, \
item041,item042,item043,item044,item045,item046,item047,item048 FROM list_data_sell");

what exactly does this code do and where exactly do you put it
@Akeval :when i get to my computer ill compile a 127.0.0.1 version
or acctually deadspirit has a compiled world server on the 2nd page

 

[kac123ige]

here is the compiled world server

 

[rl2171]

here is the compiled world server

Thx for the file.

Very strange, when I double clicked on it, the gave a error....Failed to start because the application configuration is incorrect.

Everything is still the same with the one from Brett's version, any thoughts on this?

 

[kac123ige]

im not sure but i get this error when i try to compile
Error 1 error C2039: 'pakManageClan' : is not a member of 'CWorldServer'
Error 2 error C3861: 'pakManageClan': identifier not found

 

[rl2171]

Here is the error I now get when attempting to compile:

Compiling...
gmcmds.cpp
worldpackets.cpp
Generating Code...
Linking...
gmcmds.obj : error LNK2019: unresolved external symbol "public: struct CNPCData * __thiscall CWorldServer::GetNPCData(unsigned int)" (?GetNPCData@CWorldServer@@QAEPAUCNPCData@@I@Z) referenced in function "public: bool __thiscall CWorldServer:akGMMon(class CWorldClient *,int,int)" (?pakGMMon@CWorldServer@@QAE_NPAVCWorldClient@@HH@Z)
worldpackets.obj : error LNK2001: unresolved external symbol "public: struct CNPCData * __thiscall CWorldServer::GetNPCData(unsigned int)" (?GetNPCData@CWorldServer@@QAEPAUCNPCData@@I@Z)
worldserver.obj : error LNK2001: unresolved external symbol "public: struct CNPCData * __thiscall CWorldServer::GetNPCData(unsigned int)" (?GetNPCData@CWorldServer@@QAEPAUCNPCData@@I@Z)
worldpackets.obj : error LNK2019: unresolved external symbol "public: struct CSellData * __thiscall CWorldServer::GetSellData(unsigned int)" (?GetSellData@CWorldServer@@QAEPAUCSellData@@I@Z) referenced in function "public: bool __thiscall CWorldServer:akNPCBuy(class CWorldClient *,struct CPacket *)" (?pakNPCBuy@CWorldServer@@QAE_NPAVCWorldClient@@PAUCPacket@@@Z)
worldserver.obj : error LNK2019: unresolved external symbol "public: struct CSkillData * __thiscall CWorldServer::GetSkillData(unsigned int,unsigned int)" (?GetSkillData@CWorldServer@@QAEPAUCSkillData@@II@Z) referenced in function "public: virtual void __thiscall CWorldServer::OnServerStep(void)" (?OnServerStep@CWorldServer@@UAEXXZ)
Q:\Rose Server\Servers\EVO\Debug\3. World Server.exe : fatal error LNK1120: 3 unresolved externals


I think I got everything into the files, but zad67 I am not sure on the parts you had where they go.

Lat question for the night ;-) Does all these updates work with the code that Brett just released?

Thanks

 

[iNeverDownAway]

here is the compiled world server

i got error with this exe :\

 

[xxlovely]

NOW, this code is for drose or erose?Who can tell me ?