[Ajuda] Ajuda MYSQL Load/Save
#3

Vc acha que eu jб nгo li isso @hard?

O mais estranho й que as funзхes de salvar e carregar pra player tгo funcionando, olha como ta, parece estar pior

My load players is working... So why my factions load not work?

My load players:

Save players
Код:
stock OnPlayerSave(playerid) {
    new query[1250], ip[25];
    GetPlayerIp(playerid, ip, sizeof(ip));
    money[playerid] = GetPlayerMoneyEx(playerid);

    format(query, sizeof(query), "UPDATE `accounts` SET `Username` = '%s', `IP` = '%s', `scorelevel` = '%d', `maconha` = '%d', `sementes` = '%d', `BPsize` = '%d', `lastlogin` = '%d', `wanted` = '%d', `moneybag` = '%d', `COPskills` = '%d', `CRIMINALskills` = '%d', `PARAMEDICskills` = '%d', `admin` = '%d', `money` = '%d', `bank` = '%d', `kills` = '%d', `deaths` = '%d' WHERE `Username` = '%s' ",
    GetName(playerid),
    ip,
    scorelevel[playerid],
    maconha[playerid],
    sementes[playerid],
    BPsize[playerid],
    lastlogin[playerid],
    wanted[playerid],
    moneybag[playerid],
    COPskills[playerid],
    CRIMINALskills[playerid],
    PARAMEDICskills[playerid],
    admin[playerid],
    money[playerid],
    bank[playerid],
    kills[playerid],
    deaths[playerid],
    GetName(playerid));
    mysql_pquery(ConnectMYSQL, query);

    format(query, sizeof(query), "UPDATE `accounts` SET `eagleSPAWN` = '%d', `shotgunSPAWN` = '%d', `spazSPAWN` = '%d', `mp5SPAWN` = '%d', `akSPAWN` = '%d', `m4SPAWN` = '%d', `rifleSPAWN` = '%d', `sniperSPAWN` = '%d', `meleeSPAWN` = '%d' WHERE `Username` = '%s'",
    GetName(playerid),
    EagleSPAWN[playerid],
    shotgunSPAWN[playerid],
    spazSPAWN[playerid],
    mp5SPAWN[playerid],
    akSPAWN[playerid],
    m4SPAWN[playerid],
    rifleSPAWN[playerid],
    sniperSPAWN[playerid],
    meleeSPAWN[playerid],
    GetName(playerid));
    mysql_pquery(ConnectMYSQL, query);

    format(query, sizeof(query), "UPDATE `accounts` SET `DP` = '%d', `VIP` = '%d', `fmembro` = '%d', `fcargo` = '%d', `preso` = '%d', `presotime` = '%d', `startVIPdia` = '%d', `startVIPmes` = '%d', `startVIPano` = '%d', `carid` = '%d', `carpos0` = '%f', `carpos1` = '%f', `carpos2` = '%f', `carpos3` = '%f' WHERE Username = '%s'",
    DP[playerid],
    VIP[playerid],
    fmembro[playerid],
    fcargo[playerid],
    preso[playerid],
    presotime[playerid],
    startVIPdia[playerid],
    startVIPmes[playerid],
    startVIPano[playerid],
    carid[playerid],
    carpos[playerid][0],
    carpos[playerid][1],
    carpos[playerid][2],
    carpos[playerid][3],
    GetName(playerid) );
    mysql_pquery(ConnectMYSQL, query);

    format(query, sizeof(query), "UPDATE `accounts` SET `spawnpoint` = '%d', `housekey` = '%d', `idiom` = '%d', `tutorial` = '%d', `banned` = '%d', `leftBANdia` = '%d', `leftBANmes` = '%d', `leftBANano` = '%d', `morto` = '%d', `mortotime` = '%d' WHERE Username = '%s'",
    spawnpoint[playerid],
    housekey[playerid],
    idiom[playerid],
    tutorial[playerid],
    banned[playerid],
    leftBANdia[playerid],
    leftBANmes[playerid],
    leftBANano[playerid],
	morto[playerid],
	mortotime[playerid],
    GetName(playerid) );
    mysql_pquery(ConnectMYSQL, query);
}
Load players
Код:
stock OnPlayerLogin(playerid)
{
    new query[512], rows, fields;
	mysql_format(ConnectMYSQL, query, sizeof(query), "SELECT * FROM `accounts` WHERE `Username` = '%s'", Nome(playerid) );
	mysql_query(ConnectMYSQL,query);
    cache_get_data(rows, fields);
    if(rows)
    {
		new int_dest[45];
		int_dest[0] = cache_get_field_content_int(0, "UserID");               	pInfo[playerid][UserID] = int_dest[0];
		int_dest[1] = cache_get_field_content_int(0, "scorelevel");         	scorelevel[playerid] = int_dest[1];
		int_dest[2] = cache_get_field_content_int(0, "maconha");           		maconha[playerid] = int_dest[2];
		int_dest[3] = cache_get_field_content_int(0, "sementes");           	sementes[playerid] = int_dest[3];
		int_dest[4] = cache_get_field_content_int(0, "BPsize");          	 	BPsize[playerid] = int_dest[4];
		int_dest[5] = cache_get_field_content_int(0, "wanted");          	 	wanted[playerid] = int_dest[5];
		int_dest[6] = cache_get_field_content_int(0, "moneybag");          		moneybag[playerid] = int_dest[6];
		int_dest[7] = cache_get_field_content_int(0, "COPskills");          	COPskills[playerid] = int_dest[7];
		int_dest[8] = cache_get_field_content_int(0, "CRIMINALskills");         CRIMINALskills[playerid] = int_dest[8];
		int_dest[9] = cache_get_field_content_int(0, "PARAMEDICskills");        PARAMEDICskills[playerid] = int_dest[9];
		int_dest[10] = cache_get_field_content_int(0, "admin");     			admin[playerid] = int_dest[10];
		int_dest[11] = cache_get_field_content_int(0, "money");     			money[playerid] = int_dest[11];
		int_dest[12] = cache_get_field_content_int(0, "bank");     				bank[playerid] = int_dest[12];
		int_dest[13] = cache_get_field_content_int(0, "kills");     			kills[playerid] = int_dest[13];
		int_dest[14] = cache_get_field_content_int(0, "deaths");     			deaths[playerid] = int_dest[14];
		int_dest[15] = cache_get_field_content_int(0, "DP");     				DP[playerid] = int_dest[15];
		int_dest[16] = cache_get_field_content_int(0, "VIP");     				VIP[playerid] = int_dest[16];
		int_dest[17] = cache_get_field_content_int(0, "fmembro");     			fmembro[playerid] = int_dest[17];
		int_dest[18] = cache_get_field_content_int(0, "fcargo");     			fcargo[playerid] = int_dest[18];
		int_dest[19] = cache_get_field_content_int(0, "preso");     			preso[playerid] = int_dest[19];
		int_dest[20] = cache_get_field_content_int(0, "presotime");     		presotime[playerid] = int_dest[20];
		int_dest[21] = cache_get_field_content_int(0, "startVIPdia");     		startVIPdia[playerid] = int_dest[21];
		int_dest[22] = cache_get_field_content_int(0, "startVIPmes");     		startVIPmes[playerid] = int_dest[22];
		int_dest[23] = cache_get_field_content_int(0, "startVIPano");     		startVIPano[playerid] = int_dest[23];
		int_dest[24] = cache_get_field_content_int(0, "carid");     			carid[playerid] = int_dest[24];
		int_dest[25] = cache_get_field_content_int(0, "spawnpoint");     		spawnpoint[playerid] = int_dest[25];
		int_dest[26] = cache_get_field_content_int(0, "housekey");     			housekey[playerid] = int_dest[26];
		int_dest[27] = cache_get_field_content_int(0, "tutorial");     			tutorial[playerid] = int_dest[27];
		int_dest[28] = cache_get_field_content_int(0, "idiom");     			idiom[playerid] = int_dest[28];
		int_dest[29] = cache_get_field_content_int(0, "banned");     			banned[playerid] = int_dest[29];
		int_dest[30] = cache_get_field_content_int(0, "leftBANdia");     		leftBANdia[playerid] = int_dest[30];
		int_dest[31] = cache_get_field_content_int(0, "leftBANmes");     		leftBANmes[playerid] = int_dest[31];
		int_dest[32] = cache_get_field_content_int(0, "leftBANano");     		leftBANano[playerid] = int_dest[32];
		int_dest[33] = cache_get_field_content_int(0, "eagleSPAWN");     				EagleSPAWN[playerid] = int_dest[33];
		int_dest[34] = cache_get_field_content_int(0, "shotgunSPAWN");     			shotgunSPAWN[playerid] = int_dest[34];
		int_dest[35] = cache_get_field_content_int(0, "spazSPAWN");     				spazSPAWN[playerid] = int_dest[35];
		int_dest[36] = cache_get_field_content_int(0, "mp5SPAWN");     				mp5SPAWN[playerid] = int_dest[36];
		int_dest[37] = cache_get_field_content_int(0, "akSPAWN");     				akSPAWN[playerid] = int_dest[37];
		int_dest[38] = cache_get_field_content_int(0, "m4SPAWN");     				m4SPAWN[playerid] = int_dest[38];
		int_dest[39] = cache_get_field_content_int(0, "rifleSPAWN");     				rifleSPAWN[playerid] = int_dest[39];
		int_dest[40] = cache_get_field_content_int(0, "sniperSPAWN");     			sniperSPAWN[playerid] = int_dest[40];
		int_dest[41] = cache_get_field_content_int(0, "meleeSPAWN");     			meleeSPAWN[playerid] = int_dest[41];
		int_dest[42] = cache_get_field_content_int(0, "lastlogin");          	 		lastlogin[playerid] = int_dest[42];
		int_dest[43] = cache_get_field_content_int(0, "morto");     			morto[playerid] = int_dest[43];
		int_dest[44] = cache_get_field_content_int(0, "mortotime");     		mortotime[playerid] = int_dest[44];


		new Float:float_dest[4];
		float_dest[0] = cache_get_field_content_float(0, "carpos0");     	carpos[playerid][0] = float_dest[0];
		float_dest[1] = cache_get_field_content_float(0, "carpos1");     	carpos[playerid][1] = float_dest[1];
		float_dest[2] = cache_get_field_content_float(0, "carpos2");     	carpos[playerid][2] = float_dest[2];
		float_dest[3] = cache_get_field_content_float(0, "carpos3");     	carpos[playerid][3] = float_dest[3];

		GivePlayerMoneyEx(playerid, money[playerid]);
Reply


Messages In This Thread
Ajuda MYSQL Load/Save - by maikons - 24.09.2015, 17:17
Re: Ajuda MYSQL Load/Save - by HaRdiiZin - 24.09.2015, 18:43
Re: Ajuda MYSQL Load/Save - by maikons - 25.09.2015, 07:30
Re: Ajuda MYSQL Load/Save - by maikons - 26.09.2015, 07:46
Re: Ajuda MYSQL Load/Save - by n0minal - 26.09.2015, 07:52
Re: Ajuda MYSQL Load/Save - by maikons - 26.09.2015, 18:27
Re: Ajuda MYSQL Load/Save - by maikons - 27.09.2015, 04:32
Re: Ajuda MYSQL Load/Save - by n0minal - 27.09.2015, 05:09

Forum Jump:


Users browsing this thread: 1 Guest(s)