SA-MP Forums Archive
MySQL Load Moneybags - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Load Moneybags (/showthread.php?tid=340344)


MySQL Load Moneybags - SanAndreasVille - 06.05.2012

Hello i have this script for load the playerdatas i have add a moneybag save with

Код:
PlayerInfo[playerid][moneybag]
its save the data perfektly

and now how can i load this data from the database here my playerload script:

Код:
           else if(rows > 0)
           {
               if(mysql_fetch_row(line))
               {
                   	new data[3][55];
         			new data2[5];
          			sscanf(line, "p<|>s[50]s[300]dddds[50]ds[100]", data[0], largestring, data2[0], data2[1], data2[2], data2[3], data[2], data2[4], estring);
			   		stringempty(estring);
			   		stringempty(largestring);
      				SetPVarInt(playerid, "Kills", data2[0]);
      				SetPVarInt(playerid, "Logged", 1);
      				SetPVarInt(playerid, "Deaths", data2[1]);
      				SetPlayerScore(playerid, data2[2]);
      				GivePlayerMoney(playerid, data2[3]);
      				SetPVarInt(playerid, "AdminLevel", data2[4]);
                   	SendClientMessage(playerid, 0x0000D9AA, "Logged in!");
                   	mysql_free_result();
                   	GetPlayerIp(playerid, PIP, 18);
                   	format(Query, sizeof(Query), "UPDATE `playerinfo` SET IP = '%s' WHERE user='%s'", PIP, escpname(playerid));
				    mysql_query(Query);
			   }
		   }
       }
    }
    return 1;
}