21.06.2014, 16:15
Need to convert this to MySQL and add more..
pawn Code:
forward CreateCharacter(playerid, charactername[],playercash, playerbank, playerskin); // Creates a character.
public CreateCharacter(playerid, charactername[],playercash, playerbank, playerskin)
{
if(AccountExists(playerid)) // Checking if master account exists.
{
if(MasterAccount[playerid][mLoggedIn]) // Checking if players logged in.
{
if(!CharacterExists(charactername)) // Continue if character does not exist.
{
if(PlayerCharacterCount(playerid) <= MAX_CHARACTER_SLOTS) // Checking if player has went over his character limit.
{
if(strlen(charactername) >= 1)
{
format(query, sizeof(query), "INSERT INTO `Character` (`admin_level`,`cash`,`sex`,`age`,`bank`,`skin`,`religion`,`name`,`owner_id`) VALUES ( 0, %d, %d, %d, %d, %d, %d, '%s', %d)",
playercash,
playersex,
playerage,
playerbank,
playerskin,
playerreligion,
sqlite_escape_string(charactername),
MasterAccount[playerid][mID]);
db_free_result(db_query(database,query));
format(query, sizeof(query), "Your character ID = %d.", sqlite_highest_field(database, "id", "Character"));
SendClientMessage(playerid, COLOR_WHITE, query);
return true;
}
else
{
ShowPlayerDialog(playerid,DIALOG_MAIN_MENU_CREATE_CHARACTER_NAME,DIALOG_STYLE_INPUT,"Master Account - New Character","You left the character name field blank.\n(Firstname Lastname format).","Continue","Go Back");
}
}
else
{
ShowMenuDialog(playerid);
SendClientMessage(playerid, COLOR_RED, "[I:] You have exceeded your character limit, and cannot create a new character.");
}
}
else
{
ShowPlayerDialog(playerid,DIALOG_MAIN_MENU_CREATE_CHARACTER_NAME,DIALOG_STYLE_INPUT,"Master Account - New Character","That character name already exists, choose another.\n(Firstname Lastname format).","Continue","Go Back");
}
}
}
return false;
}
pawn Code:
enum PlayerCharacter
{
cName[MAX_PLAYER_NAME],
cOwnerID,
cID,
cAdminLevel,
Float:cX,
Float:cY,
Float:cZ,
Float:cAngle,
cWorld,
cInterior,
cCash,
cBank,
cSkin,
cMask,
Level,
SpawnPoint,
Accent,
ExperiencePoints,
Deaths,
Kills,
CellPhone,
CellPhoneNumber,
CellBattery,
Job,
CarKey1,
CarKey2,
CarKey3,
Clothes1,
Clothes2,
Clothes3,
ClothesUsed,
CarLicense,
TruckLicense,
HouseKey,
Business1Key,
Business2Key,
Faction,
FactionRank,
}
new Character[MAX_PLAYERS][PlayerCharacter];