SA-MP Forums Archive
Why my house/factions dont save? MYSQL - 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: Why my house/factions dont save? MYSQL (/showthread.php?tid=588174)


Why my house/factions dont save? MYSQL - maikons - 06.09.2015

I have problem, my players are saving fine, but factions and houses not

Why?

When gmx the server

I put on OnGameModeInit():
mysql_log(LOG_ALL);
mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG);

mysql.log:
part 1
http://pastebin.com/Y7si3qwe
part 2
http://pastebin.com/6PEUdwvr

public OnGameModeExit()
SalvarCasas();
SalvarFactions();

savehouse
Код:
stock SalvarCasas() {
	for(new houseid; houseid < MAX_HOUSES; houseid++) {
		new query[1030];
        format(query, sizeof(query), "UPDATE `houses` SET OutPosX = %f, OutPosY = %f, OutPosZ = %f, InPosX = %f, InPosY = %f, InPosZ = %f, World = %d, Price = %d, Interior = %d, Locked = %d, Dono = %s, FHQ = %d, Money = %d, Maconha = %d, Owner = %d, hlastlogin = %d, WHERE ID = %d"
        ,
            HouseInfo[houseid][OutPosX],
            HouseInfo[houseid][OutPosY],
            HouseInfo[houseid][OutPosZ],
            HouseInfo[houseid][InPosX],
            HouseInfo[houseid][InPosY],
            HouseInfo[houseid][InPosZ],
            HouseInfo[houseid][World],
            HouseInfo[houseid][Price],
            HouseInfo[houseid][Interior],
            HouseInfo[houseid][Locked],
            HouseInfo[houseid][Dono],
            HouseInfo[houseid][FHQ],
            HouseInfo[houseid][Money],
            HouseInfo[houseid][Maconha],
            HouseInfo[houseid][Owner],
			HouseInfo[houseid][hlastlogin],
            HouseInfo[houseid][ID]);
        mysql_query(ConnectMYSQL, query);
	}
}
savefactions
Код:
stock SalvarFactions() {
	for(new factionid; factionid < MAX_FACTIONS; factionid++) {
		new query[1030];
		format(query, sizeof(query), "UPDATE `factions` SET `facname` = '%s', `HQposX` = '%f', `HQposY` = '%f', `HQposZ` = '%f', `EagleSPAWNfac` = '%d', `shotgunSPAWNfac` = '%d', `spazSPAWNfac` = '%d', `mp5SPAWNfac` = '%d', `akSPAWNfac` = '%d', `m4SPAWNfac` = '%d', `rifleSPAWNfac` = '%d', `sniperSPAWNfac` = '%d', `meleeSPAWNfac` = '%d', `cofredinheiro` = '%d', `cofresalario` = '%d', `cofrematerial` = '%d', `cofremaconha` = '%d' WHERE `ID` = '%i' ",
            FactionInfo[factionid][facname],
            FactionInfo[factionid][HQposX],
            FactionInfo[factionid][HQposY],
            FactionInfo[factionid][HQposZ],
            FactionInfo[factionid][EagleSPAWNfac],
            FactionInfo[factionid][shotgunSPAWNfac],
			FactionInfo[factionid][spazSPAWNfac],
			FactionInfo[factionid][mp5SPAWNfac],
			FactionInfo[factionid][akSPAWNfac],
			FactionInfo[factionid][m4SPAWNfac],
			FactionInfo[factionid][rifleSPAWNfac],
			FactionInfo[factionid][sniperSPAWNfac],
			FactionInfo[factionid][meleeSPAWNfac],
			FactionInfo[factionid][cofredinheiro],
			FactionInfo[factionid][cofresalario],
			FactionInfo[factionid][cofrematerial],
			FactionInfo[factionid][ID] );
		mysql_pquery(ConnectMYSQL, query);
			
		format(query, sizeof(query), "UPDATE `factions` SET `lider1` = '%d', `lider2` = '%d', `lider3` = '%d', `membro1` = '%d', `membro2` = '%d', `membro3` = '%d', `membro4` = '%d', `membro5` = '%d', `membro6` = '%d', `membro7` = '%d', `membro8` = '%d', `membro9` = '%d', `membro10` = '%d', `membro11` = '%d', `membro12` = '%d' WHERE `ID` = '%i' ",
			FactionInfo[factionid][lider1],
			FactionInfo[factionid][lider2],
			FactionInfo[factionid][lider3],
			FactionInfo[factionid][membro1],
			FactionInfo[factionid][membro2],
			FactionInfo[factionid][membro3],
			FactionInfo[factionid][membro4],
			FactionInfo[factionid][membro5],
			FactionInfo[factionid][membro6],
			FactionInfo[factionid][membro7],
			FactionInfo[factionid][membro8],
			FactionInfo[factionid][membro9],
			FactionInfo[factionid][membro10],
			FactionInfo[factionid][membro11],
			FactionInfo[factionid][membro12],			
			FactionInfo[factionid][ID] );
		mysql_pquery(ConnectMYSQL, query);
	}
}
SAVE PLAYER (WORK FINE)
Код:
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' WHERE Username = '%s'",
    spawnpoint[playerid],
    housekey[playerid],
    idiom[playerid],
    tutorial[playerid],
    banned[playerid],
    leftBANdia[playerid],
    leftBANmes[playerid],
    leftBANano[playerid],
    GetName(playerid) );
    mysql_pquery(ConnectMYSQL, query);
}