#5 Save Player

stock SavePlayer(playerid) {
    new query[256], dest[1024];
    if (!registered[playerid] && !logged[playerid])
        mysql_format(SQL, dest, sizeof(dest), "INSERT INTO `players` (`Username`, `Password`, `Skin`, `Money`, `Level`, `Email`, `Gender`) VALUES ('%e','%d','%d','%d','%d','%e','%d')", GetName(playerid), PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pMoney], \
            PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pGender]);
    else {
        mysql_format(SQL, query, sizeof(query), "UPDATE `players` SET `Username` = '%e', `Password` = '%d', `Skin` = '%d', `Money` = '%d', `Level` = '%d',", GetName(playerid), PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pLevel]);
        strcat(dest, query, sizeof(dest));
        mysql_format(SQL, query, sizeof(query), "`Email` = '%e', `Gender` = '%d', `Admin` = '%d', `AdminCode` = '%d', `Inactivity` = '%d'WHERE `ID` = '%d' LIMIT 1", PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pGender], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pAdminCode], PlayerInfo[playerid][pInactivity], PlayerInfo[playerid][sID]);
        strcat(dest, query, sizeof(dest));
    }
    mysql_tquery(SQL, dest);
}