Use mysql for register/load
#29

Ok, invece per salvare un numero in fase di registrazione? Cioи tu una volta inserito la password ecc, devi mettere in questo caso l'etа in numeri quindi deve salvarla nel db qual'и il codice giusto?

Quote:
Originally Posted by SymonClash
View Post
Per evitare di far uscire una stringa lunghssima, nel caso tu abbia molte cose da salvare, puoi fare cosi:

pawn Code:
stock SalvaStats(playerid)
{
    new query[500], p = playerid;
    mysql_format(g_SQL, query,sizeof(query), "UPDATE `players` SET `LastLogin` = '%e', `Kills` = %d, `Deaths` = %d, `Score` = %i, `Money` = %i, `AccountLevel` = %d, `WantedLevel` = %d, `PlayerGender` = %d WHERE `ID`= %d",
    ReturnDate(), Player[p][Kills], Player[p][Deaths], GetPlayerScore(p), GetPlayerMoney(p), Player[p][AccountLevel], GetPlayerWantedLevel(p) ,Player[p][PlayerGender], Player[p][ID]);
    mysql_query(g_SQL, query);

    format(query,sizeof(query),"UPDATE `players` SET `PlayingHours` = %d, `PlayingMinutes` = %d, `FirstSpawn` = %d, `Job` = %d, `Bank` = %d, `NoPm` = %d WHERE `ID`= %d",
    Player[p][PlayingHours], Player[p][PlayingMinutes], Player[p][FirstSpawn], Player[p][Job], Player[p][Bank], Player[p][NoPm], Player[p][ID]);
    mysql_query(g_SQL, query);
    return 1;
}
Ti ho preso come esempio un mio vecchio script.
Reply


Messages In This Thread
Use mysql for register/load - by OuDayas - 13.01.2019, 13:12
Re: Use mysql for register/load - by Jeffry - 13.01.2019, 13:20
Re: Use mysql for register/load - by OuDayas - 13.01.2019, 15:15
Re: Use mysql for register/load - by Jeffry - 13.01.2019, 15:55
Re: Use mysql for register/load - by OuDayas - 13.01.2019, 16:21
Re: Use mysql for register/load - by Jeffry - 13.01.2019, 17:51
Re: Use mysql for register/load - by OuDayas - 13.01.2019, 21:03
Re: Use mysql for register/load - by Jeffry - 14.01.2019, 19:52
Re: Use mysql for register/load - by codExpert - 14.01.2019, 20:40
Re: Use mysql for register/load - by OuDayas - 15.01.2019, 11:08
Re: Use mysql for register/load - by Jeffry - 15.01.2019, 18:15
Re: Use mysql for register/load - by OuDayas - 16.01.2019, 00:55
Re: Use mysql for register/load - by Jeffry - 16.01.2019, 16:54
Re: Use mysql for register/load - by OuDayas - 17.01.2019, 21:35
Re: Use mysql for register/load - by Jeffry - 19.01.2019, 11:37
Re: Use mysql for register/load - by OuDayas - 19.01.2019, 18:43
Re: Use mysql for register/load - by Stefhan - 20.01.2019, 02:28
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 09:41
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 12:35
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 13:37
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 14:35
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 15:29
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 16:07
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 16:15
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 19:27
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 20:23
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 20:39
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 20:45
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 20:55
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 21:07
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 21:47
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 22:11
Re: Use mysql for register/load - by SymonClash - 21.01.2019, 09:30
Re: Use mysql for register/load - by OuDayas - 21.01.2019, 22:58

Forum Jump:


Users browsing this thread: 1 Guest(s)