· 6 years ago · Dec 08, 2019, 11:44 PM
1//w ongamemodeinit
2 mysql_query(Connection, "CREATE TABLE IF NOT EXISTS `Account`(`ID`int AUTO_INCREMENT PRIMARY KEY, `Name` varchar(24) NOT NULL, `Password` varchar(129) NOT NULL, `Email` varchar(129) NOT NULL, `Sex` int(11) NOT NULL, `Age` int(11) NOT NULL, `Score` int(11) NOT NULL, `Money` int(11) NOT NULL, `Skin` int(11) NOT NULL, `Ranga` int(11) NOT NULL, `Frakcja` int(11) NOT NULL)", false);
3
4//ZAPISZ GRACZA
5 mysql_format(Connection, Query, sizeof(Query), "UPDATE `Account` SET `Name`='%e', `Password`='%e', `Email`='%e', `Sex`='%d', `Age`='%d', `Score`='%d', `Money`='%d', `Skin`='%d', `Ranga`='%d', `Frakcja`='%d' WHERE `ID`='%d'",
6 Name(playerid),
7 PlayerInfo[playerid][pPassword],
8 PlayerInfo[playerid][pEmail],
9 PlayerInfo[playerid][pSex],
10 PlayerInfo[playerid][pAge],
11 PlayerInfo[playerid][pScore],
12 PlayerInfo[playerid][pMoney],
13 PlayerInfo[playerid][pSkin],
14 PlayerInfo[playerid][pRanga],
15 PlayerInfo[playerid][pFrakcja],
16 PlayerInfo[playerid][pID]);
17
18//WCZYTAJ GRACZA
19 PlayerInfo[playerid][pSex] = cache_get_field_content_int(0, "Sex");
20 PlayerInfo[playerid][pAge] = cache_get_field_content_int(0, "Age");
21 PlayerInfo[playerid][pScore] = cache_get_field_content_int(0, "Score");
22 PlayerInfo[playerid][pMoney] = cache_get_field_content_int(0, "Money");
23 PlayerInfo[playerid][pSkin] = cache_get_field_content_int(0, "Skin");
24 PlayerInfo[playerid][pRanga] = cache_get_field_content_int(0, "Ranga");
25 PlayerInfo[playerid][pFrakcja] = cache_get_field_content_int(0, "Frakcja");
26
27
28//Zarejestruj gracza
29mysql_format(Connection, Query, sizeof(Query), "INSERT INTO `Account`(`Name`, `Password`, `Email`, `Sex`, `Age`, `Score`, `Money`, `Skin`, `Ranga`, `Frakcja`) VALUES ('%s','%s','%s','%d','%d','%d','%d','%d','%d','%d')",
30 Name(playerid),
31 PlayerInfo[playerid][pPassword],
32 PlayerInfo[playerid][pEmail],
33 PlayerInfo[playerid][pSex],
34 PlayerInfo[playerid][pAge],
35 PlayerInfo[playerid][pScore],
36 PlayerInfo[playerid][pMoney],
37 PlayerInfo[playerid][pSkin],
38 PlayerInfo[playerid][pRanga],
39 PlayerInfo[playerid][pFrakcja]);