Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)

Paste

Pasted as Plain Text by Hoss ( 13 years ago )
SavePlayer(playerid)
{
 if(pInfo[playerid][Logged] == 1)
    {
     new query[1000];
     format(query, 1000, "UPDATE `"#playerdata"` SET `donor`='%d', `admin`='%d', `score`='%d', `money`='%d', `kills`='%d', `deaths`='%d',`Rank`='%d',`Respect`='%d',`DonatorPoints`='%d',`Donated`='%d'",query,pInfo[playerid][dLevel], pInfo[playerid][pAdmin], pInfo[playerid][Score], pInfo[playerid][pMoney], pInfo[playerid][pKills], pInfo[playerid][pDeaths],pInfo[playerid][pRank],pInfo[playerid][pRespect],pInfo[playerid][pDonatorPoints],pInfo[playerid][pDonated]);
        printf("Query 1 Printed");
  format(query, 1000, "%s, `Turfs`='%d',`WeaponTrucks`='%d'", query, pInfo[playerid][pTurfs],pInfo[playerid][pWeaponTrucks]);
        printf("Query 2 Printed");
  format(query, 1000, "%s, `Action1`='%d', `Action2`='%d',`Action3`='%d',`Action4`='%d',`Action5`='%d',`Action6`='%d',`Action7`='%d',`Action8`='%d',`Action9`='%d',`Action10`='%d'", query, pInfo[playerid][Action1],pInfo[playerid][Action2],pInfo[playerid][Action3],pInfo[playerid][Action4],pInfo[playerid][Action5],pInfo[playerid][Action6],pInfo[playerid][Action7],pInfo[playerid][Action8],pInfo[playerid][Action9],pInfo[playerid][Action10]);
        printf("Query 3 Printed");
  format(query, 1000, "%s, `Seconds`='%d',`Minutes`='%d',`Hours`='%d',`Week`='%d',`TotalHours`='%d',`TotalMins`=%d, `helpers`='%d', `online`='0' WHERE `nick`='%s' LIMIT 1", query, pInfo[playerid][Sec],pInfo[playerid][Min],pInfo[playerid][Hour],pInfo[playerid][Week],pInfo[playerid][TotalHours],pInfo[playerid][TotalMins],pInfo[playerid][Helpers], pInfo[playerid][Nick]);
        mysql_query(query);
    }
}

stock MySQL_Login(playerid)
{
 format(Query, SOQ, "SELECT * FROM `playerdata` WHERE `nick` COLLATE latin1_general_cs = '%s' LIMIT 1", pInfo[playerid][Nick]);
    mysql_query(Query);
    mysql_store_result();
    while(mysql_fetch_row(Query))
    {
        mysql_fetch_int("id", pInfo[playerid][ID]);
     mysql_fetch_int("donor", pInfo[playerid][dLevel]);
        mysql_fetch_int("admin", pInfo[playerid][pAdmin]);
        mysql_fetch_int("score", pInfo[playerid][Score]); SetPlayerScore(playerid, pInfo[playerid][Score]);
        mysql_fetch_int("money", pInfo[playerid][pMoney]); GivePlayerMoney(playerid, pInfo[playerid][pMoney]);
        mysql_fetch_int("kills", pInfo[playerid][pKills]);
        mysql_fetch_int("deaths", pInfo[playerid][pDeaths]);
        mysql_fetch_int("Rank", pInfo[playerid][pRank]);
        mysql_fetch_int("Respect", pInfo[playerid][pRespect]);
        mysql_fetch_int("DonatorPoints", pInfo[playerid][pDonatorPoints]);
        mysql_fetch_int("Donated", pInfo[playerid][pDonated]);
        mysql_fetch_int("Turfs", pInfo[playerid][pTurfs]);
        mysql_fetch_int("WeaponTrucks", pInfo[playerid][pWeaponTrucks]);
        mysql_fetch_int("Action1", pInfo[playerid][Action1]);
  mysql_fetch_int("Action2", pInfo[playerid][Action2]);
        mysql_fetch_int("Action3", pInfo[playerid][Action3]);
  mysql_fetch_int("Action4", pInfo[playerid][Action4]);
        mysql_fetch_int("Action5", pInfo[playerid][Action5]);
  mysql_fetch_int("Action6", pInfo[playerid][Action6]);
        mysql_fetch_int("Action7", pInfo[playerid][Action7]);
  mysql_fetch_int("Action8", pInfo[playerid][Action8]);
        mysql_fetch_int("Action9", pInfo[playerid][Action9]);
  mysql_fetch_int("Action10", pInfo[playerid][Action10]);
        mysql_fetch_int("Seconds", pInfo[playerid][Sec]);
     mysql_fetch_int("Minutes", pInfo[playerid][Min]);
     mysql_fetch_int("Hours", pInfo[playerid][Hour]);
     mysql_fetch_int("Week", pInfo[playerid][Week]);
  mysql_fetch_int("TotalHours", pInfo[playerid][TotalHours]);
  mysql_fetch_int("TotalMins", pInfo[playerid][TotalMins]);
  mysql_fetch_int("helpers", pInfo[playerid][Helpers]);
    }
    mysql_free_result();
    format(Query, SOQ, "UPDATE `playerdata` SET `ip` = '%s', `laston` = UTC_TIMESTAMP(), `online` = 1 WHERE `id` = '%d' LIMIT 1", pInfo[playerid][IP], pInfo[playerid][ID]);
    mysql_query(Query);
    SendClientMessage(playerid, -1, "You have been logged in!");
    TimeTimer = SetTimerEx("TimeOnServer", 1000, 1, "i", playerid);
    pInfo[playerid][Logged] = 1;
    //SendMessageToRAdmins(red, "Player has successfully logged in!");
    return 1;
}

 

Revise this Paste

Your Name: Code Language: