Nottinghster
Tibia World RPG Developer
- Joined
- Oct 24, 2007
- Messages
- 1,570
- Solutions
- 6
- Reaction score
- 437
- Location
- Brazil - Rio de Janeiro
- GitHub
- Nottinghster
Let's to the Code:
Credits: 100% Rogier1337 (Drakaro)
In ioaccountsql.cp change:
For:
Now in protocollogin.cpp in function parsefirstpacket change:
For this:
In account.h after of
Add:
Also in account.h replace:
For:
Now go to Project> options of the project> parameters and add:
Database things:
Make a new table named worlds.
Inside worlds add 4 new fields.
field 1: named `worldid` as an integer.
field 2: named `worldname` as a string.
field 3: named `worldip` as a string.
field 4: named `worldport` as an integer.
Now at players database, add a new field called `worldid` as an integer.
At the worlds u have to insert your world, dont forget to set the worldid at players database.
Credits: 100% Rogier1337 (Drakaro)
In ioaccountsql.cp change:
Code:
Account IOAccountSQL::loadAccount(uint32_t accno)For:
Code:
Account IOAccountSQL::loadAccount(uint32_t accno)
{
Account acc;
Database* mysql = Database::instance();
DBQuery query;
DBResult result;
query << "SELECT id,password FROM accounts WHERE id=" << accno;
if(mysql->connect() && mysql->storeQuery(query, result)){
acc.accnumber = result.getDataInt("id");
acc.password = result.getDataString("password");
#ifndef __ROGIER_MULTIWORLD__
query << "SELECT name FROM players WHERE account_id=" << accno;
#else //__ROGIER_MULTIWORLD__
query << "SELECT name,worldid FROM players WHERE account_id=" << accno;
#endif //__ROGIER_MULTIWORLD__
if(mysql->storeQuery(query, result)){
for(uint32_t i = 0; i < result.getNumRows(); ++i){
std::string ss = result.getDataString("name", i);
#ifndef __ROGIER_MULTIWORLD__
acc.charList.push_back(ss.c_str());
#else //__ROGIER_MULTIWORLD__
int worldid = result.getDataInt("worldid", i);
query.reset();
result.clear();
query << "SELECT * FROM worlds WHERE worldid=" << worldid;
mysql->storeQuery(query, result);
struct CharInfo info;
info.worldName = result.getDataString("worldname", i);
info.worldIp = result.getDataString("worldip", i);
info.worldPort = result.getDataInt("worldport", i);
acc.charList[ss] = info;
#endif //__ROGIER_MULTIWORLD__
}
#ifndef __ROGIER_MULTIWORLD__
acc.charList.sort();
#endif //__ROGIER_MULTIWORLD__
}
}
return acc;
}Now in protocollogin.cpp in function parsefirstpacket change:
Code:
std::list<std::string>::iterator it;
for(it = account.charList.begin(); it != account.charList.end(); it++){
output->AddString((*it));
output->AddString(g_config.getString(ConfigManager::WORLD_NAME));
output->AddU32(serverip);
output->AddU16(g_config.getNumber(ConfigManager::PORT));
}For this:
Code:
#ifndef __ROGIER_MULTIWORLD__
std::list<std::string>::iterator it;
for(it = account.charList.begin(); it != account.charList.end(); it++){
output->AddString((*it));
output->AddString(g_config.getString(ConfigManager::WORLD_NAME));
output->AddU32(serverip);
output->AddU16(g_config.getNumber(ConfigManager::PORT));
}
#else //__ROGIER_MULTIWORLD__
std::map<std::string, CharInfo>::iterator it;
for(it = account.charList.begin(); it != account.charList.end(); it++){
output->AddString(it->first);
output->AddString(it->second.worldName);
output->AddU32(inet_addr(it->second.worldIp.c_str()));
output->AddU16(it->second.worldPort);
}
#endif //__ROGIER_MULTIWORLD__In account.h after of
Code:
class AccountAdd:
Code:
#ifdef __ROGIER_MULTIWORLD__
#include <map>
struct CharInfo
{
std::string worldIp;
std::string worldName;
short worldPort;
};
#endif //__ROGIER_MULTIWORLD__Also in account.h replace:
Code:
std::list<std::string> charList;For:
Code:
#ifdef __ROGIER_MULTIWORLD__
std::list<std::string> charList;
#else //__ROGIER_MULTIWORLD__
std::map<std::string, CharInfo> charList;
#endif //__ROGIER_MULTIWORLD__Now go to Project> options of the project> parameters and add:
Code:
-D__ROGIER_MULTIWORLD__Database things:
Make a new table named worlds.
Inside worlds add 4 new fields.
field 1: named `worldid` as an integer.
field 2: named `worldname` as a string.
field 3: named `worldip` as a string.
field 4: named `worldport` as an integer.
Now at players database, add a new field called `worldid` as an integer.
At the worlds u have to insert your world, dont forget to set the worldid at players database.
Last edited:
