Advise please
#1

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];
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)