SA-MP Forums Archive
BUG No save money 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: BUG No save money MYSQL (/showthread.php?tid=594574)



BUG No save money MYSQL - csovidiu - 20.11.2015

Hi, i have one problem when i connected on my server i have 0 money this is the line...
Код:
public OnPlayerConnect(playerid)
{
	AntiFlood_InitPlayer( playerid );
	XDeaths[playerid] = 0;
    LastDeath[playerid] = 0;
    destroyer[playerid] = 0;
    pnsmoney[playerid] = 0;
    OnDutymedic[playerid] = 0;
    cased[playerid] = 0;
    caser[playerid] = 1001;
    RepairTime[playerid] = 0;
    Tigaanel[playerid] = 0;
    LastPlayer[playerid] = -1;
    PlayerInfo[playerid][pNRE] = -1;

    KillTimer(login[playerid]);
Код:
// ONPLAYERDISCONNECT
public OnPlayerDisconnect(playerid, reason)
{
	// PAYDAY SAVE
    if(gPlayerLogged[playerid] != 0)
	{
		OnPlayerDateUpdateX2(playerid);
		Update(playerid, pPayDayHadx);
		Update(playerid, pPayDayx);
		Update(playerid, pPayCheckx);
		Update(playerid, pFpunishx);
		Update(playerid, pConnectTimex);
		Update(playerid, pLawyerx);
		Update(playerid, pBank);
		Update(playerid, pCashx);
		Update(playerid, pRP);
		Update(playerid, pJailTimex);
		Update(playerid, pLevelx);
	}
	
	destroyer[playerid] = 0;
	pnsmoney[playerid] = 0;
	OnDutymedic[playerid] = 0;
	RepairTime[playerid] = 0;
	Tigaanel[playerid] = 0;
	foreach(Player, i)
	{
		if(IsACop(playerid))
		{
			if(caser[playerid] == i)
			{
				cased[i] --;
				caser[playerid] = 1001;
			}
		}
	}
	cased[playerid] = 0;
	caser[playerid] = 1001;
	
    if(PlayerInfo[playerid][pMember] > 0)
	{
	    new namex[25],disc[84];
	    GetPlayerName(playerid,namex,sizeof(namex));
		switch(reason)
	    {
	        case 0: format(disc,sizeof(disc),"Your member %s left the server (Crash).",namex);
	        case 1: format(disc,sizeof(disc),"Your member %s left the server (/q).",namex);
	        case 2: format(disc,sizeof(disc),"Your member %s left the server (Kicked/Banned).",namex);
	    }
	    SendLeaderMessage(PlayerInfo[playerid][pMember], COLOR_YELLOW, disc);
	}
	
	if(PlayerInfo[playerid][pFlyMode] > 0)
	{
	    SetPlayerHealth(playerid, 100);
		SetPlayerArmour(playerid, 0);
		StopFly(playerid);
		PlayerInfo[playerid][pFlyMode] = 0;
	}

	new qqerry[128];
	mysql_format(SQL,qqerry, sizeof(qqerry), "UPDATE `users` SET `Status` = '0' WHERE `name` = '%s'", PlayerInfo[playerid][pNormalName]);
    mysql_tquery(SQL,qqerry,"","");

	if(personalcar[playerid] != 0)
	{
		vehEngine[personalcar[playerid]] = 0;
		DestroyVehicle(personalcar[playerid]);
		OwnedVeh(personalcar[playerid]) = 0;
		Gas[personalcar[playerid]] = 100;
		personalcar[playerid] = 0;
	}
	
	if(viddd[playerid] != 0)
	{
	    DestroyVehicle(viddd[playerid]);
	    viddd[playerid] = 0;
	}
	
	tazer[playerid] = 0;						curatj[playerid] = 0;
	playerdeath[playerid] = 0;					biztype[playerid] = 0;
	bizid[playerid] = 0; 						bizprice[playerid] = 0;
	bizoffer[playerid] = 999;					PlayerInfo[playerid][pSleeping] = 0;
	adminacceptedhelp[playerid] = -1;			DeletePVar(playerid, "Help");
	licenseaccepted[playerid] = -1;				licensesend[playerid] = -1;
	SellgunOffer[playerid] = -1;				SellgunPrice[playerid] = 0;
	SellgunMats[playerid] = 0;					SellgunAmmo[playerid] = 0;
	SellgunID[playerid] = 0;					pizzaj[playerid] = 0;
	PlayerPaintballing[playerid] = 0;			PlayerPaintballScore[playerid] = 0;
	hiddenculorr[playerid] = 0;					requestingevent[playerid] = 0;
	eventorganizer[playerid] = 0;				togfind[playerid] = 0;
    PlayerCuffed2[playerid] = 0;				OwnableCarOffer[playerid] = 999;
	OwnableCarID[playerid] = 0;					OwnableCarPrice[playerid] = 0;
	togip[playerid] = 0;						Clanidoff[playerid] = 999;
	WTToggle[playerid] = false; 				WTChannel[playerid] = 0.0;
	antirem[playerid] = 0; 						radiop[playerid] = 0;
 	Radaron[playerid] = 0; 						Radarlimit[playerid] = 0;
  	wantedlost[playerid] = 1799;                Trucker[playerid] = 0;
	personalcar[playerid] = 0;       			Diceid[playerid] = 999;
	Dicem[playerid] = 999; 					    firerockettime[playerid] = 0;
	TaxiCall[playerid] = -1;					Refueling[playerid] = 0;
 	InHQ[playerid] = -1;						InHouse[playerid] = -1;
	InBussines[playerid] = -1; 					raceoff[playerid] = 999;
	toglc[playerid] = 0; 						explosion[playerid] = 0;
	fight[playerid] = 999;						reportaccepted[playerid] = -1;
	adminacceptedreport[playerid] = -1;			motooff[playerid] = 999;
	playerhavereport[playerid] = -1;    		taxim[playerid] = 0;
	fightr[playerid] = 0;                       RocketBoxTime[playerid] = 0;
	fightn[playerid] = 999;						fightrn[playerid] = 0;
	SomatePermission[playerid] = 1;             somatee[playerid] = 1;
	ReportTime[playerid] = 0;                   IsCollectingRubbish[playerid] = 0;
 	hudactivated[playerid] = 0;
    Vending[playerid] = 0;                      PlayerInfo[playerid][pFishPrice] = 0;
	FactionOffer[playerid] = 999;               Sunglasses[playerid] = 0;
	Hatss[playerid] = 0;                        TowAcc[playerid] = 0;
	CheckBus[playerid] = 0;                     JobStep[playerid] = 0;
	viddd[playerid] = 0;                        Trucker2[playerid] = 0;
	TruckID[playerid] = 0;                      Trucker3[playerid] = 0;
	Trucker4[playerid] = 0;                     AreFaina[playerid] = 0;
	CarJacker[playerid] = 0;                    JackAcc[playerid] = 0;
	Fishing[playerid] = 0;                      FishTimer[playerid] = 0;
	TipPeste[playerid] = 0;                     SelFac[playerid] = 0;
	BuyCar[playerid] = -1;                      EnterInModShop[playerid] = 0;
	PlayerInfo[playerid][pHelpedPlayers] = 0;
	PlayerInfo[playerid][pNMuted] = 0;
	PlayerInfo[playerid][pNRE] = -1;
	WantedPoints[playerid] = 0;                 PlayerInfo[playerid][pJailTime] = 0;
	PlayerInfo[playerid][pJailed] = 0;
	
    TextDrawHideForPlayer(playerid, TimeLeftWar1[playerid]);
    KillTimer(timersoo[playerid]);
    TextDrawDestroy(armoraa[playerid]);
	TextDrawDestroy(healthu[playerid]);
	TextDrawHideForPlayer(playerid, UndercoverText[playerid]);