Peršokti į turinį
  • ŽAIDIMAI
  • , ŽAIDIMAI
  • ŽAIDIMAI

Nori pirkti ar parduoti SA:MP turtą? SPAUSK ČIA!

MYSQL ERROR

Versace

Parašė Versace
forume SA:MP Klausimai, pagalba ir prašymai

 Pasidalinti

Ši tema yra neaktyvi. Paskutinis pranešimas šioje temoje buvo prieš 5090 dienas (-ų). Patariame sukurti naują temą, o ne rašyti naują pranešimą.

Už neaktyvių temų prikėlimą galite sulaukti įspėjimo ir pranešimo pašalinimo!

Recommended Posts

GintuxxxKps Naujokas (-ė)

GintuxxxKps

[glow=green,2,300]Sveiki iškilo problema su autosave. Neveikia visiškai atsijungiu ir neišsaugoja pasidariau komanda vistiek neišsaugoja į mysql. Prisidejau prinf tikrinau ar veikia saugojimas supratau pagal loga kai suveikia saugojimo stock meta server_log errorą. [/glow]

[glow=red,2,300]KAI SUVEIKIA AUTOSAVE STOCK ERRORAS LOGE ATRODO TAIP :[/glow]

[22] SAVE: Tikrina prijungima
[22] SAVE: TOLIAU prisijungisuiui tikrina mysql
[22] SAVE: TOLIAU mysql prijungta
[22] SAVE: vygdome išsaugojima
[22] SAVE: saugome kitka
[22] SAVE: toliau išsaugojame
[22] [MySQL] Error (0): Failed to exeute query. Unknown column 'InvID10' in 'field list'.
[22] SAVE: SAugojimas i  pabaiga
[22] SAVE: MySQLUpdateFinish
[22] [MySQL] Error (0): Failed to exeute query. Unknown column 'CheckInfo' in 'field list'.
[22] SAVE: Saugojimas baigesi.

[glow=red,2,300]VISKAS YRA CIA KAIP CHECKINFO, INVID

Mysql skriptas zaidejai.pwn Skripto:[/glow]

Padėkit prašau jei kam nesunku...

#if defined __zaidejai__ikelta
 #endinput
#endif

#define __zaidejai__ikelta

enum pInfo
{
   pSQLID,
   pKey[ 128 ],
   pAge,
   pNationality[ 24 ],
   pbankpass[ 24 ],
   pBankCard,
   pBankLang,
pBornPlace[ 24 ],
pSex[ 12 ],
pPersonalC [ 11 ],
pLevel,
pAdmin,
pVip,
pVguns,
pHelper,
pCash,
pBank,
pBankTransfer,
bool:pMute,
pWarn,
pSkin,
pInt,
pVirWorld,
Float:pPos_x,
Float:pPos_y,
Float:pPos_z,
bool:pCrashed,
pGun [ MAX_SAVED_WEAPONS ],
pAmmo[ MAX_SAVED_WEAPONS ],
pPhNumber,
pPlayHours,
pPayDayMins,
pExp,
pHouseKey,
pJob,
bool:pLocked,
pFaction,
pFRank,
pSalary,
pOOCJail,
pPayDay,
pRadio[ MAX_RADIO_SLOTS ],
pCurRSlot,
pDeaths,
bool:pBikeLic,
bool:pDrivingLic,
bool:pFlyingLic,
bool:pBoatLic,
bool:pWeaponLic,
bool:pTruckLic,
pBikeWarns,
pDriveWarns,
pFlyWarns,
pBoatWarns,
pWeapWarns,
pContract,
pPrisonTime,
pPrisonCam,
pSpawnPlace,
pTrucksPD,
pMinJail,
pPromiles
};

enum FishInfo
{
fDurability,
fBait,
fPermit,
fRecord [ 2 ],
fFish   [ 5 ],
fWeight [ 5 ],
}

new
bool:aExist [ MAX_PLAYERS ], 			 // Ar žaidėjo sąskaita egzistuoja
FishingInfo [ MAX_PLAYERS ][ FishInfo ], // Masyvas saugoti žvejybos informacijai.
PlayerInfo  [ MAX_PLAYERS ][ pInfo ]; 	 // Masyvas saugoti žaidėjų duomenims

stock NullPlayerRegVariables( playerid )
{
// Funkcija: NullPlayerVariables( playerid )
// Išvalys žaidėjo kintamuosius

aLogged[ playerid ] = false;
aExist [ playerid ] = false;

PlayerInfo[ playerid ][ pSQLID    			] = 0;
PlayerInfo[ playerid ][ pAge      			] = 0;
PlayerInfo[ playerid ][ pNationality       	] = false;
PlayerInfo[ playerid ][ pbankpass       	] = false;
PlayerInfo[ playerid ][ pBankCard       	] = false;
PlayerInfo[ playerid ][ pBankLang       	] = false;
PlayerInfo[ playerid ][ pSex		       	] = false;
PlayerInfo[ playerid ][ pPersonalC 			] = 0;
PlayerInfo[ playerid ][ pLevel    			] = 0;
PlayerInfo[ playerid ][ pAdmin    			] = 0;
PlayerInfo[ playerid ][ pVip    			] = 0;
PlayerInfo[ playerid ][ pVguns    			] = 0;
PlayerInfo[ playerid ][ pHelper    			] = 0;
PlayerInfo[ playerid ][ pCash     			] = 0;
PlayerInfo[ playerid ][ pBank     			] = 0;
PlayerInfo[ playerid ][ pBankTransfer		] = 0;
   PlayerInfo[ playerid ][ pMute     			] = false;
   PlayerInfo[ playerid ][ pWarn     			] = 0;
   PlayerInfo[ playerid ][ pSkin     			] = 123;
   PlayerInfo[ playerid ][ pInt      			] = 0;
   PlayerInfo[ playerid ][ pVirWorld 			] = 0;
   PlayerInfo[ playerid ][ pPos_x    			] = 0.0;
   PlayerInfo[ playerid ][ pPos_y    			] = 0.0;
   PlayerInfo[ playerid ][ pPos_z    			] = 0.0;
   PlayerInfo[ playerid ][ pCrashed  			] = false;
   for ( new wep = 0; wep < MAX_SAVED_WEAPONS; wep++ )
   {
       PlayerInfo[ playerid ][ pGun  ][ wep ] = 0;
       PlayerInfo[ playerid ][ pAmmo ][ wep ] = 0;
   }
   PlayerInfo[ playerid ][ pPhNumber   		] = 0;
   PlayerInfo[ playerid ][ pPlayHours  		] = 0;
   PlayerInfo[ playerid ][ pPayDayMins 		] = 0;
   PlayerInfo[ playerid ][ pExp        		] = 0;
   PlayerInfo[ playerid ][ pHouseKey   		] = 0;
   PlayerInfo[ playerid ][ pJob        		] = JOB_NONE;
   PlayerInfo[ playerid ][ pLocked     		] = false;
   PlayerInfo[ playerid ][ pFaction    		] = -1;
   PlayerInfo[ playerid ][ pFRank      		] = 0;
   PlayerInfo[ playerid ][ pOOCJail    		] = 0;
   PlayerInfo[ playerid ][ pPayDay     		] = 0;
   for ( new i = 0; i < MAX_RADIO_SLOTS; i++ )
       PlayerInfo[ playerid ][ pRadio ][ i ] = 0;
PlayerInfo[ playerid ][ pCurRSlot   		] = 0;
PlayerInfo[ playerid ][ pDeaths     		] = 0;
PlayerInfo[ playerid ][ pBikeLic    		] = false;
PlayerInfo[ playerid ][ pDrivingLic 		] = false;
PlayerInfo[ playerid ][ pFlyingLic  		] = false;
PlayerInfo[ playerid ][ pBoatLic    		] = false;
PlayerInfo[ playerid ][ pWeaponLic  		] = false;
PlayerInfo[ playerid ][ pContract   		] = 0;
PlayerInfo[ playerid ][ pPrisonTime 		] = 0;
PlayerInfo[ playerid ][ pPrisonCam  		] = 0;
PlayerInfo[ playerid ][ pSpawnPlace 		] = 0;
PlayerInfo[ playerid ][ pTrucksPD	 		] = 0;
PlayerInfo[ playerid ][ pMinJail	 		] = 0;

drugsloop
{
	DrugInfo [ playerid ][ i ][ dAddiction ] = -1;
	DrugInfo [ playerid ][ i ][ dTime      ] = 0;
	DrugInfo [ playerid ][ i ][ dActive    ] = false;
}

FishingInfo[ playerid ][ fDurability ] = -1;
FishingInfo[ playerid ][ fBait		 ] = 0;
FishingInfo[ playerid ][ fPermit	 ] = 0;
FishingInfo[ playerid ][ fRecord	 ][ 0 ] = 0;
FishingInfo[ playerid ][ fRecord	 ][ 1 ] = 0;

for ( new f = 0; f < 6; f++ )
{
	FishingInfo[ playerid ][ fFish		 ][ f ] = 0;
	FishingInfo[ playerid ][ fWeight	 ][ f ] = 0;
}
}

stock MySQLNameCheck( sqlname[ ] )
{
// Funkcija: MySQLNameCheck( sqlname[ ] )

MySQLCheckConnection( );

new
    string[ 68 ];

format( string, 68, "SELECT `id` FROM `players` WHERE `Name`='%s'",
        sqlname );

mysql_query       ( string );
mysql_store_result( );

if ( mysql_fetch_row( string ) )
    return strval( string );
else
	return 0;
}

stock CheckIfAccExist( playerid )
{
// Funkcija: CheckIfAccExist( playerid )
// Patikrins ar žaidėjo sąskaita egzistuoja

new
    name[ MAX_PLAYER_NAME ];

GetPlayerName( playerid, name, MAX_PLAYER_NAME );
PlayerInfo[ playerid ][ pSQLID ] = MySQLNameCheck( name );

if ( PlayerInfo[ playerid ][ pSQLID ] > 0 )
{ // Sąskaita jau egzistuoja
	new
		ip     [ 24 ],
		string [ 300 ],
		title  [ 300 ];

	GetPlayerRPName ( playerid, name, MAX_PLAYER_NAME );
	GetPlayerIp		( playerid, ip, 24 );
	    format ( title, 300, "Sveiki atvykę {00FF00}%s", name );

	format ( string, 300, "{FFFFFF}Prisijungimas į {00FF00}GTA-SA.LT{FFFFFF}serverį\n\
	Jūsų vardas: {00FF00}%s\n\
	{FFFFFF}Jūsų IP adresas: {00FF00}%s\n\
	\t\t\t\t\t{FFFFFF}Prašome įvesti savo prisijungimo slaptažodį", name, ip );

       ShowPlayerDialog( playerid, 1000, DIALOG_STYLE_INPUT,
					  title,
					  string,
					  "Prisijungti", "Atšaukti" );
	zaidimast[playerid] = SetTimerEx("Zaidimas",60*1000,true,"i",playerid);
	aExist[ playerid ] = true;

}
else
{ // Sąskaita neegzistuoja
RegisterDialog(playerid);
//Kick			 ( playerid );
}
}
stock MySQLUpdateBuild( query[ ], sqlplayerid )
{
// Funkcija: MySQLUpdateBuild( query[ ], sqlplayerid )
// Sukūrė Luk0r

new
	querylen = strlen( query );

if ( querylen < 1 )
	format( query, 255, "UPDATE `players` SET " );
else if ( 255 - querylen < 50 )
{
	format     ( query, 255, "%s WHERE `id`=%d", query, sqlplayerid );
	mysql_query( query );
	format     ( query, 255, "UPDATE `players` SET " );
}
else if ( strfind( query, "=", true ) != -1 )
	format( query, 255, "%s,", query );
}

stock MySQLUpdateFinish( query[ ], sqlplayerid )
{
// Funkcija: MySQLUpdateFinish( query[ ], sqlplayerid )
// Sukūrė Luk0r

if ( !strcmp( query, "WHERE `id`=", false ) )
	mysql_query( query );
else
{
	format     ( query, 255, "%s WHERE `id`=%d", query, sqlplayerid );
	mysql_query( query );
	format     ( query, 255, "UPDATE `players` SET " );
}
}

stock MySQLUpdatePlayerInt( query[ ], sqlplayerid, const sqlvalname[], sqlupdateint )
{
// Funkcija: MySQLUpdatePlayerInt( query[ ], sqlplayerid, const sqlvalname[], sqlupdateint )
// Sukūrė Luk0r

MySQLUpdateBuild( query, sqlplayerid );
format          ( query, 255, "%s`%s`=%d",
				  query, sqlvalname, sqlupdateint );
}

stock MySQLUpdatePlayerFlo( query[ ], sqlplayerid, sqlvalname[ ], Float:sqlupdateflo )
{
// Funkcija: MySQLUpdatePlayerFlo( query[ ], sqlplayerid, sqlvalname[ ], Float:sqlupdateflo )
// Sukūrė: Luk0r

new
	flotostr[ 32 ];

format              ( flotostr, 31, "%f", sqlupdateflo );
MySQLUpdatePlayerStr( query, sqlplayerid, sqlvalname, flotostr );
}

stock MySQLUpdatePlayerStr( query[ ], sqlplayerid, sqlvalname[ ], sqlupdatestr[ ] )
{
// Funkcija: MySQLUpdatePlayerStr( query[ ], sqlplayerid, sqlvalname[ ], sqlupdatestr[ ] )
// Sukūrė Luk0r

MySQLUpdateBuild	( query, sqlplayerid );


new
	escstr[ 128 ];
mysql_real_escape_string( sqlupdatestr, escstr );
format                  ( query, 255, "%s`%s`='%s'",
							query, sqlvalname, escstr );
}

stock LoginPlayer( playerid, password[ ] )
{
// Funckija LoginPlayer( playerid, password[ ] )
// Priskiriame žaidėjui kintamuosius iš duomenų bazės, jei įrašytas
// slaptažodis yra teisingas, jei ne, išspiriame jį iš žaidimo.

MySQLCheckConnection( );

new
    string	   [ 2048 ],
	enteredpass[ 129 ];

format( string, 2024, "SELECT * FROM `players` WHERE `id`=%d LIMIT 1",
		PlayerInfo[ playerid ][ pSQLID ] );

mysql_query       ( string );
mysql_store_result( );

if ( !mysql_fetch_row( string ) )
{
    SendClientMessage( playerid, COLOR_RED, "Prisijungimo klaida #001" );
    SendClientMessage( playerid, COLOR_RED, "Nerasti MySQL duomenys." );
	Kick( playerid );
}

sscanf( string, "p<|>{ds[24]}s[129]s[2000]", PlayerInfo[ playerid ][ pKey ],
        string );

WP_Hash ( enteredpass, 129, password );

if ( !strcmp( PlayerInfo[ playerid ][ pKey ], enteredpass, true ) )
{
    new
        trash [ 24 ],
        money,
        fightstyle;

	if ( sscanf( string, "p<|>ds[24]s[24]dds[24]s[24]s[11]ddddddddlddddffflddddddddddddlddddddddddddddddddddddddddddddlll\
lllddddddddddddddddddddddddddddddddds[28]ds[28]ds[28]ds[28]s[24]",
			PlayerInfo[ playerid ][ pAge        ],
			PlayerInfo[ playerid ][ pNationality],
			PlayerInfo[ playerid ][ pbankpass   ],
			PlayerInfo[ playerid ][ pBankCard   ],
			PlayerInfo[ playerid ][ pBankLang   ],
			PlayerInfo[ playerid ][ pBornPlace	],
			PlayerInfo[ playerid ][ pSex		],
			PlayerInfo[ playerid ][ pPersonalC	],
	        PlayerInfo[ playerid ][ pLevel      ],
	        PlayerInfo[ playerid ][ pAdmin      ],
	        PlayerInfo[ playerid ][ pVip        ],
	        PlayerInfo[ playerid ][ pVguns      ],
			PlayerInfo[ playerid ][ pHelper		],
	        money,
	        PlayerInfo[ playerid ][ pBank       ],
			PlayerInfo[ playerid ][ pBankTransfer ],
	        PlayerInfo[ playerid ][ pMute       ],
	        PlayerInfo[ playerid ][ pWarn       ],
               PlayerInfo[ playerid ][ pSkin       ],
	        PlayerInfo[ playerid ][ pInt        ],
	        PlayerInfo[ playerid ][ pVirWorld   ],
	        PlayerInfo[ playerid ][ pPos_x      ],
	        PlayerInfo[ playerid ][ pPos_y      ],
	        PlayerInfo[ playerid ][ pPos_z      ],
	        PlayerInfo[ playerid ][ pCrashed    ],

	        PlayerInfo[ playerid ][ pGun        ][ 0 ],
	        PlayerInfo[ playerid ][ pGun        ][ 1 ],
	        PlayerInfo[ playerid ][ pGun        ][ 2 ],

	        PlayerInfo[ playerid ][ pAmmo       ][ 0 ],
	        PlayerInfo[ playerid ][ pAmmo       ][ 1 ],
	        PlayerInfo[ playerid ][ pAmmo       ][ 2 ],

	        PlayerInfo[ playerid ][ pPhNumber   ],
	        PlayerInfo[ playerid ][ pPlayHours  ],
	        PlayerInfo[ playerid ][ pPayDayMins ],
	        PlayerInfo[ playerid ][ pExp        ],
	        PlayerInfo[ playerid ][ pHouseKey   ],
	        PlayerInfo[ playerid ][ pJob        ],
	        PlayerInfo[ playerid ][ pLocked     ],
	        PlayerInfo[ playerid ][ pFaction    ],
	        PlayerInfo[ playerid ][ pFRank      ],
			PlayerInfo[ playerid ][ pSalary	    ],
	        PlayerInfo[ playerid ][ pOOCJail    ],
	        PlayerInfo[ playerid ][ pPayDay     ],

	        InvInfo   [ playerid ][ 0 ][ 0 ],
	        InvInfo   [ playerid ][ 0 ][ 1 ],
	        InvInfo   [ playerid ][ 1 ][ 0 ],
	        InvInfo   [ playerid ][ 1 ][ 1 ],
	        InvInfo   [ playerid ][ 2 ][ 0 ],
	        InvInfo   [ playerid ][ 2 ][ 1 ],
	        InvInfo   [ playerid ][ 3 ][ 0 ],
	        InvInfo   [ playerid ][ 3 ][ 1 ],
	        InvInfo   [ playerid ][ 4 ][ 0 ],
	        InvInfo   [ playerid ][ 4 ][ 1 ],
	        InvInfo   [ playerid ][ 5 ][ 0 ],
	        InvInfo   [ playerid ][ 5 ][ 1 ],
	        InvInfo   [ playerid ][ 6 ][ 0 ],
	        InvInfo   [ playerid ][ 6 ][ 1 ],
	        InvInfo   [ playerid ][ 7 ][ 0 ],
	        InvInfo   [ playerid ][ 7 ][ 1 ],
	        InvInfo   [ playerid ][ 8 ][ 0 ],
	        InvInfo   [ playerid ][ 8 ][ 1 ],
	        InvInfo   [ playerid ][ 9 ][ 0 ],
	        InvInfo   [ playerid ][ 9 ][ 1 ],


	        PlayerInfo[ playerid ][ pRadio      ][ 0 ],
	        PlayerInfo[ playerid ][ pRadio      ][ 1 ],
	        PlayerInfo[ playerid ][ pRadio      ][ 2 ],

	        PlayerInfo[ playerid ][ pCurRSlot   ],
	        PlayerInfo[ playerid ][ pDeaths     ],
	        PlayerInfo[ playerid ][ pBikeLic    ],
	        PlayerInfo[ playerid ][ pDrivingLic ],
	        PlayerInfo[ playerid ][ pFlyingLic  ],
	        PlayerInfo[ playerid ][ pBoatLic    ],
	        PlayerInfo[ playerid ][ pWeaponLic  ],
			PlayerInfo[ playerid ][ pTruckLic  ],
	        PlayerInfo[ playerid ][ pBikeWarns  ],
	        PlayerInfo[ playerid ][ pDriveWarns ],
	        PlayerInfo[ playerid ][ pFlyWarns   ],
	        PlayerInfo[ playerid ][ pBoatWarns  ],
	        PlayerInfo[ playerid ][ pWeapWarns  ],
	        PlayerInfo[ playerid ][ pContract   ],
	        PlayerInfo[ playerid ][ pPrisonTime ],
	        PlayerInfo[ playerid ][ pPrisonCam  ],
	        fightstyle,
	        PlayerInfo[ playerid ][ pSpawnPlace ],
	        PlayerInfo[ playerid ][ pTrucksPD   ],
	        PlayerInfo[ playerid ][ pMinJail    ],
	        PlayerInfo[ playerid ][ pPromiles   ],		
			DrugInfo  [ playerid ][ DRUG_COCAINE ][ dAddiction ],
			DrugInfo  [ playerid ][ DRUG_LSD     ][ dAddiction ],
			DrugInfo  [ playerid ][ DRUG_HEROINE ][ dAddiction ],
			FishingInfo[ playerid ][ fDurability ],
			FishingInfo[ playerid ][ fBait		 ],
			FishingInfo[ playerid ][ fPermit	 ],
			FishingInfo[ playerid ][ fRecord	 ][ 0 ],
			FishingInfo[ playerid ][ fRecord	 ][ 1 ],
			FishingInfo[ playerid ][ fFish		 ][ 0 ],
			FishingInfo[ playerid ][ fWeight	 ][ 0 ],
			FishingInfo[ playerid ][ fFish		 ][ 1 ],
			FishingInfo[ playerid ][ fWeight	 ][ 1 ],
			FishingInfo[ playerid ][ fFish		 ][ 2 ],
			FishingInfo[ playerid ][ fWeight	 ][ 2 ],
			FishingInfo[ playerid ][ fFish		 ][ 3 ],
			FishingInfo[ playerid ][ fWeight	 ][ 3 ],
			FishingInfo[ playerid ][ fFish		 ][ 4 ],
			FishingInfo[ playerid ][ fWeight	 ][ 4 ],
			WantedPoints [ playerid ],
			CheckInfo[ playerid ][ 0 ][ camount ],
			CheckInfo[ playerid ][ 0 ][ cgiver ],
			CheckInfo[ playerid ][ 1 ][ camount ],
			CheckInfo[ playerid ][ 1 ][ cgiver ],
			CheckInfo[ playerid ][ 2 ][ camount ],
			CheckInfo[ playerid ][ 2 ][ cgiver ],
			CheckInfo[ playerid ][ 3 ][ camount ],
			CheckInfo[ playerid ][ 3 ][ cgiver ],
			trash ) ) print ( "SSCANF FAIL" );
		new skinas = PlayerInfo[ playerid ][ pSkin ];
	SetPlayerFightingStyle( playerid, fightstyle );

	ResetPlayerMoney( playerid );
	GivePlayerMoney ( playerid, money );
	SetPlayerSkin(playerid, skinas );

	OnPlayerLogin	( playerid );
}
else
{
    SendClientError( playerid, "Slaptažodis yra neteisingas, uždaromas žaid\
imas.");
    Kick( playerid );
}
}

stock OnPlayerLogin( playerid )
{
// Funkcija OnPlayerLogin( playerid )
// Bus iškviesta, kai žaidėjas prisijungs prie savo sąskaitos

// Iškickiname žaidėja, jei jo sąskaita užrakinta
if ( PlayerInfo[ playerid ][ pLocked ] )
{
    SendClientError	( playerid, "Ši sąskaita yra užrakinta.");
    Kick			( playerid );
}

// Jei žaidėjas yra surinkęs 3 įspėjimus
if ( PlayerInfo[ playerid ][ pWarn ] > 2 )
{
    SendClientError	( playerid, "Ši sąskaita yra užrakinta.");
    Kick			( playerid );
}

// Jeigu turi priklausomybę - aptempdom ekraną.
drugsloop
{
	if ( DrugInfo [ playerid ][ i ][ dAddiction ] == 0 )
	{
		new
			string [ 75 ];
		FadeScreen ( playerid );

		format ( string, 74, "[NARKOTIKAI] Jūs ęsate priklausomas nuo %s. Jums reikia dozės.", GetDrugNameByID ( i ) );
		SendClientMessage ( playerid, COLOR_FADE3, string );
	}
}
// Jei žaidėjas prisijungęs pirmą kartą
if ( PlayerInfo[ playerid ][ pLevel ] == 0 )
{
    PlayerInfo[ playerid ][ pLevel    ] = 400;
    PlayerInfo[ playerid ][ pPhNumber ] = 0;
    GivePlayerMoney	( playerid, 5000 );
	PrisijungeNaujokas(playerid);
}
 // Jei žaidėjas administratorius, suteikiam jam admin darbą.
if ( PlayerInfo[ playerid ][ pAdmin ] > 0 && PlayerInfo[ playerid ][ pVip ] > 0 )
{
PrisijungeAdmVip (playerid);
}
else if ( PlayerInfo[ playerid ][ pAdmin ] > 0 )
{
PrisijungeAdminas (playerid);
}
 // Jei VIP, tai suteikiam jam spalvą.
else if ( PlayerInfo[ playerid ][ pVip ] > 0 )
{
PrisijungeVip (playerid);
}
// Žaidėjui saugom kas 1MIN ginklus
   SetTimer( "SaugotiGinklus",    30000, true );
SetPlayerScore  	( playerid, PlayerInfo[ playerid ][ pLevel ] );
SetPlayerSpecialActionEx
					( playerid, SPECIAL_ACTION_NONE );
SetPlayerDrunkLevel ( playerid, PlayerInfo [ playerid ][ pPromiles ] );
SpawnPlayerEx   	( playerid );
SetPVarInt 			( playerid, "lastcarid", -1 );
SetPVarInt 			( playerid, "vehseat", -1 );
SetPlayerWantedLevel( playerid, WantedPoints[ playerid ] );

TruckingTo   [ playerid ] = -1;
aLogged      [ playerid ] = true;
DOR          [ playerid ] = INVALID_3D_TEXT;
FishWaitTime { playerid } = -1;

SetTimerEx			( "allowBoxing", 1200000, false, "dd", playerid,
																playerid );


new
    string[ 47 ],
    name  [ MAX_PLAYER_NAME ];

GetPlayerRPName( playerid, name, MAX_PLAYER_NAME );

if ( !PlayerInfo[ playerid ][ pCrashed ] )
{
	format( string, 46, "~g~Sveiki atvyke~n~~y~%s", name );
	GameTextForPlayer( playerid, string, 3000, 1 );
	aLogged[ playerid ] = true;
	aExist[ playerid ] = true;
}
else
{
    ShowInfoText( playerid, "~p~nutruko rysys..." );
    PlayerInfo[ playerid ][ pCrashed ] = false;
    aLogged[ playerid ] = true;
    aExist[ playerid ] = true;
}

ClearChatbox( playerid, 8 );
format( string, 46, "Sveiki atvykę, %s!", name );
SendClientMessage	( playerid, COLOR_WHITE, string );
aLogged[ playerid ] = true;
   aExist[ playerid ] = true;

ClearChatbox( playerid, 1 );

   foreach (Player, i)
   {
       if ( !aLogged[ i ] ) continue;
	if ( Mask[ i ] )     ShowPlayerNameTagForPlayer( playerid, i, false );
}
   AssignVehiclesToPlayerFromDB	( playerid );
}
stock UpdatePlayer( playerid )
{
// Funkcija UpdatePlayer( playerid )
// Išsaugos žaidėjo duomenis jo faile
printf( "SAVE: Tikrina prijungima" );
if ( aLogged[ playerid ] && aExist[ playerid ] )
{
	printf( "SAVE: TOLIAU prisijungisuiui tikrina mysql" );
    MySQLCheckConnection( );
    printf( "SAVE: TOLIAU mysql prijungta" );
    new
        query[ 628 ],
		tmp  [ 128  ];

	format( query, 628, "UPDATE `players` SET " );
	printf( "SAVE: vygdome išsaugojima" );
	new
	    sqlid = PlayerInfo[ playerid ][ pSQLID ];
	     new money = GetPlayerMoney(playerid);

	MySQLUpdatePlayerInt( query, sqlid, "Level", PlayerInfo[ playerid ][ pLevel ] );
	MySQLUpdatePlayerInt( query, sqlid, "BankCard", PlayerInfo[ playerid ][ pBankCard ] );
	MySQLUpdatePlayerInt( query, sqlid, "BankLang", PlayerInfo[ playerid ][ pBankLang ] );
	MySQLUpdatePlayerInt( query, sqlid, "Admin", PlayerInfo[ playerid ][ pAdmin ] );
	MySQLUpdatePlayerInt( query, sqlid, "Vip", PlayerInfo[ playerid ][ pVip ] );
	MySQLUpdatePlayerInt( query, sqlid, "Vguns", PlayerInfo[ playerid ][ pVguns ] );
	MySQLUpdatePlayerInt( query, sqlid, "Helper", PlayerInfo[ playerid ][ pHelper ] );
	MySQLUpdatePlayerInt( query, sqlid, "Cash", money );
	MySQLUpdatePlayerInt( query, sqlid, "Bank", PlayerInfo[ playerid ][ pBank ] );
	MySQLUpdatePlayerInt( query, sqlid, "BankTransfer",  PlayerInfo[ playerid ][ pBankTransfer ] );
	MySQLUpdatePlayerInt( query, sqlid, "Mute", PlayerInfo[ playerid ][ pMute ] );
	MySQLUpdatePlayerInt( query, sqlid, "Warn", PlayerInfo[ playerid ][ pWarn ] );
	MySQLUpdatePlayerInt( query, sqlid, "Skin", PlayerInfo[ playerid ][ pSkin ] );
	MySQLUpdatePlayerInt( query, sqlid, "Int", PlayerInfo[ playerid ][ pInt ] );
	MySQLUpdatePlayerInt( query, sqlid, "VirWorld", PlayerInfo[ playerid ][ pVirWorld ] );

	if ( PlayerInfo[ playerid ][ pCrashed ] )
	{
		printf( "SAVE: saugome pozicija" );
		GetPlayerPos        ( playerid, PlayerInfo[ playerid ][ pPos_x ], PlayerInfo[ playerid ][ pPos_y ], PlayerInfo[ playerid ][ pPos_z ] );
		MySQLUpdatePlayerFlo( query, sqlid, "Pos_x", PlayerInfo[ playerid ][ pPos_x ] );
		MySQLUpdatePlayerFlo( query, sqlid, "Pos_y", PlayerInfo[ playerid ][ pPos_y ] );
		MySQLUpdatePlayerFlo( query, sqlid, "Pos_z", PlayerInfo[ playerid ][ pPos_z ] );
		MySQLUpdatePlayerInt( query, sqlid, "Crashed", 1 );
	}
	else
	    MySQLUpdatePlayerInt( query, PlayerInfo[ playerid ][ pSQLID ], "Crashed", 0 );

	printf( "SAVE: saugome kitka" );
	MySQLUpdatePlayerInt( query, sqlid, "PhNumber", PlayerInfo[ playerid ][ pPhNumber ] );
	MySQLUpdatePlayerInt( query, sqlid, "PlayHours", PlayerInfo[ playerid ][ pPlayHours ] );
	MySQLUpdatePlayerInt( query, sqlid, "PayDayMins", PlayerInfo[ playerid ][ pPayDayMins ] );
	MySQLUpdatePlayerInt( query, sqlid, "Exp", PlayerInfo[ playerid ][ pExp ] );
	MySQLUpdatePlayerInt( query, sqlid, "HouseKey", PlayerInfo[ playerid ][ pHouseKey ] );
	MySQLUpdatePlayerInt( query, sqlid, "Job", PlayerInfo[ playerid ][ pJob ] );
	MySQLUpdatePlayerInt( query, sqlid, "Locked", PlayerInfo[ playerid ][ pLocked ] );
	MySQLUpdatePlayerInt( query, sqlid, "Faction", PlayerInfo[ playerid ][ pFaction ] );
	MySQLUpdatePlayerInt( query, sqlid, "FRank", PlayerInfo[ playerid ][ pFRank ] );
	MySQLUpdatePlayerInt( query, sqlid, "Salary", PlayerInfo[ playerid ][ pSalary ] );
	MySQLUpdatePlayerInt( query, sqlid, "OOCJail", PlayerInfo[ playerid ][ pOOCJail ] );
	MySQLUpdatePlayerInt( query, sqlid, "PayDay", PlayerInfo[ playerid ][ pPayDay ] );

	for ( new i = 0; i < INVENTORY_SLOTS; i++ )
	{
	    new
	        tmpstr[ 14 ];

		format              ( tmpstr, 13, "InvID%d", i );
		MySQLUpdatePlayerInt( query, sqlid, tmpstr, InvInfo[ playerid ][ i ][ 0 ] );
		format              ( tmpstr, 13, "InvAmmount%d", i );
		MySQLUpdatePlayerInt( query, sqlid, tmpstr, InvInfo[ playerid ][ i ][ 1 ] );
	}

	for ( new i = 0; i < MAX_RADIO_SLOTS; i++ )
	{
	    new
			tmpstr[ 10 ];

		format( tmpstr, 9, "Radio%d", i );
		MySQLUpdatePlayerInt( query, sqlid, tmpstr, PlayerInfo[ playerid ][ pRadio ][ i ] );
	}
	printf( "SAVE: toliau išsaugojame" );
	MySQLUpdatePlayerInt( query, sqlid, "CurRSlot", PlayerInfo[ playerid ][ pCurRSlot ] );
	MySQLUpdatePlayerInt( query, sqlid, "Deaths", PlayerInfo[ playerid ][ pDeaths ] );
	MySQLUpdatePlayerInt( query, sqlid, "BikeLic", PlayerInfo[ playerid ][ pBikeLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "DrivingLic", PlayerInfo[ playerid ][ pDrivingLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "FlyingLic", PlayerInfo[ playerid ][ pFlyingLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "BoatLic", PlayerInfo[ playerid ][ pBoatLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "WeaponLic", PlayerInfo[ playerid ][ pWeaponLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "TruckLic", PlayerInfo[ playerid ][ pTruckLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "BikeWarns", PlayerInfo[ playerid ][ pBikeWarns ] );
	MySQLUpdatePlayerInt( query, sqlid, "DriveWarns", PlayerInfo[ playerid ][ pDriveWarns ] );
	MySQLUpdatePlayerInt( query, sqlid, "FlyWarns", PlayerInfo[ playerid ][ pFlyWarns ] );
	MySQLUpdatePlayerInt( query, sqlid, "BoatWarns", PlayerInfo[ playerid ][ pBoatWarns ] );
	MySQLUpdatePlayerInt( query, sqlid, "WeapWarns", PlayerInfo[ playerid ][ pWeapWarns] );
	MySQLUpdatePlayerInt( query, sqlid, "Contract", PlayerInfo[ playerid ][ pContract ] );
	MySQLUpdatePlayerInt( query, sqlid, "PrisonTime", PlayerInfo[ playerid ][ pPrisonTime ] );
	MySQLUpdatePlayerInt( query, sqlid, "PrisonCam", PlayerInfo[ playerid ][ pPrisonCam ] );
	MySQLUpdatePlayerInt( query, sqlid, "TrucksPD", PlayerInfo[ playerid ][ pTrucksPD ] );

	if ( Countdown [ playerid ] > 0 && CountdownType [ playerid ] == 10 )
		MySQLUpdatePlayerInt( query, sqlid, "MinJail", Countdown [ playerid ] );
	else
		MySQLUpdatePlayerInt( query, sqlid, "MinJail", 0 );

	if ( !IsPlayerOnDrugs ( playerid ) )
		MySQLUpdatePlayerInt( query, sqlid, "promiles", GetPlayerDrunkLevel ( playerid ) );

	MySQLUpdatePlayerInt( query, sqlid, "CocaineAddict", DrugInfo 	[ playerid ][ DRUG_COCAINE ][ dAddiction ] );
	MySQLUpdatePlayerInt( query, sqlid, "LSDAddict",     DrugInfo   [ playerid ][ DRUG_LSD ][ dAddiction ] );
	MySQLUpdatePlayerInt( query, sqlid, "HeroineAddict", DrugInfo	[ playerid ][ DRUG_HEROINE ][ dAddiction ] );

	format ( tmp, 75, "%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d",
			FishingInfo[ playerid ][ fDurability ],
			FishingInfo[ playerid ][ fBait		 ],
			FishingInfo[ playerid ][ fPermit	 ],
			FishingInfo[ playerid ][ fRecord	 ][ 0 ],
			FishingInfo[ playerid ][ fRecord	 ][ 1 ],
			FishingInfo[ playerid ][ fFish		 ][ 0 ],
			FishingInfo[ playerid ][ fWeight	 ][ 0 ],
			FishingInfo[ playerid ][ fFish		 ][ 1 ],
			FishingInfo[ playerid ][ fWeight	 ][ 1 ],
			FishingInfo[ playerid ][ fFish		 ][ 2 ],
			FishingInfo[ playerid ][ fWeight	 ][ 2 ],
			FishingInfo[ playerid ][ fFish		 ][ 3 ],
			FishingInfo[ playerid ][ fWeight	 ][ 3 ],
			FishingInfo[ playerid ][ fFish		 ][ 4 ],
			FishingInfo[ playerid ][ fWeight	 ][ 4 ]		);
              	MySQLUpdatePlayerStr( query, sqlid, "FishInfo", tmp );

	MySQLUpdatePlayerInt( query, sqlid, "WantedPoints", WantedPoints[ playerid ] );

	format ( tmp, 128, "%d|%s|%d|%s|%d|%s|%d|%s",
			CheckInfo[ playerid ][ 0 ][ camount ],
			CheckInfo[ playerid ][ 0 ][ cgiver ],
			CheckInfo[ playerid ][ 1 ][ camount ],
			CheckInfo[ playerid ][ 1 ][ cgiver ],
			CheckInfo[ playerid ][ 2 ][ camount ],
			CheckInfo[ playerid ][ 2 ][ cgiver ],
			CheckInfo[ playerid ][ 3 ][ camount ],
			CheckInfo[ playerid ][ 3 ][ cgiver ] );
	printf( "SAVE: SAugojimas i  pabaiga" );
	MySQLUpdatePlayerStr( query, sqlid, "CheckInfo", tmp );
	printf( "SAVE: MySQLUpdateFinish" );
	MySQLUpdateFinish( query, sqlid );
	printf( "SAVE: Saugojimas baigesi." );
}
}

stock ChangePlayerPass( playerid, newpass[ ] )
{
// Funkcija: ChangePlayerPass( playerid, newpass[ ] )
// Pakeis vartotojo slaptažodį

format( PlayerInfo[ playerid ][ pKey ], 20, "%s", newpass );
UpdatePlayer( playerid );

SendClientMessage( playerid, COLOR_WHITE, "   Slaptažodis pakeistas sėkmingai." );
}

stock UpdateMySQLFightStyle( playerid )
{
// Funkcija: UpdateMySQLKarateStyle( playerid )

MySQLCheckConnection( );

new
    string[ 71 ];

format( string, 71, "UPDATE `players` SET `FightStyle`=%d WHERE `id`=%d",
        GetPlayerFightingStyle( playerid ),
		PlayerInfo[ playerid ][ pSQLID ] );

mysql_query( string );
}

stock UpdateMySQLSpawnPlace( playerid )
{
// Funkcija: UpdateMySQLSpawnPlace( playerid )

MySQLCheckConnection( );

new
    string[ 71 ];

format( string, 71, "UPDATE `players` SET `SpawnPlace`=%d WHERE `id`=%d",
        PlayerInfo[ playerid ][ pSpawnPlace ],
        PlayerInfo[ playerid ][ pSQLID ] );

mysql_query( string );
}
stock ZaidejoVardas(playerid)
{
       new name[24];
       GetPlayerName(playerid, name, sizeof(name));
       return name;
}

stock ZaidejoIP(playerid)
{
       new playerip[16];
       GetPlayerIp(playerid, playerip, sizeof(playerip));
       return playerip;
}
stock InvalidNickKick(playerid)
{
if ( IsPlayerNPC( playerid ) )
	return true;
   new name[MAX_PLAYER_NAME];
GetPlayerName(playerid,name,sizeof(name));
   new where = strfind(name,"_",true);
   new lenght = strlen(name)-1;
   new invalid = strfind(name,"[",true);
   if(invalid == -1) invalid = strfind(name,"]",true);

   if(where == 0 || where == lenght || where==-1)
   {
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Jusu slapyvardis netinkamas.");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Teisinga slapyvardžio forma būtu:");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Vardas_Pavarde");
    Kick(playerid);
    return 1;
 }

 if(strlen(name[where])<4)
 {
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Jusu pavarde per trumpa");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Teisinga slapyvardžio forma būtu:");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Vardas_Pavarde");
    Kick(playerid);
    return 1;
 }

 if(where<3)
 {
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Jusu vardas per trumpas");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Teisinga slapyvardžio forma būtu:");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Vardas_Pavarde");
    Kick(playerid);
    return 1;
 }

 if(invalid != -1)
 {
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Varde rasta netinkamu raidziu.");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Teisinga slapyvardžio forma būtu:");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Vardas_Pavarde");
    Kick(playerid);
    return 1;
 }
 return 0;
}

-- Papildyta --

[glow=green,2,300]Sveiki iškilo problema su autosave. Neveikia visiškai atsijungiu ir neišsaugoja pasidariau komanda vistiek neišsaugoja į mysql. Prisidejau prinf tikrinau ar veikia saugojimas supratau pagal loga kai suveikia saugojimo stock meta server_log errorą. [/glow]

[glow=red,2,300]KAI SUVEIKIA AUTOSAVE STOCK ERRORAS LOGE ATRODO TAIP :[/glow]

[22] SAVE: Tikrina prijungima
[22] SAVE: TOLIAU prisijungisuiui tikrina mysql
[22] SAVE: TOLIAU mysql prijungta
[22] SAVE: vygdome išsaugojima
[22] SAVE: saugome kitka
[22] SAVE: toliau išsaugojame
[22] [MySQL] Error (0): Failed to exeute query. Unknown column 'InvID10' in 'field list'.
[22] SAVE: SAugojimas i  pabaiga
[22] SAVE: MySQLUpdateFinish
[22] [MySQL] Error (0): Failed to exeute query. Unknown column 'CheckInfo' in 'field list'.
[22] SAVE: Saugojimas baigesi.

[glow=red,2,300]VISKAS YRA CIA KAIP CHECKINFO, INVID

Mysql skriptas zaidejai.pwn Skripto:[/glow]

Padėkit prašau jei kam nesunku...

#if defined __zaidejai__ikelta
 #endinput
#endif

#define __zaidejai__ikelta

enum pInfo
{
   pSQLID,
   pKey[ 128 ],
   pAge,
   pNationality[ 24 ],
   pbankpass[ 24 ],
   pBankCard,
   pBankLang,
pBornPlace[ 24 ],
pSex[ 12 ],
pPersonalC [ 11 ],
pLevel,
pAdmin,
pVip,
pVguns,
pHelper,
pCash,
pBank,
pBankTransfer,
bool:pMute,
pWarn,
pSkin,
pInt,
pVirWorld,
Float:pPos_x,
Float:pPos_y,
Float:pPos_z,
bool:pCrashed,
pGun [ MAX_SAVED_WEAPONS ],
pAmmo[ MAX_SAVED_WEAPONS ],
pPhNumber,
pPlayHours,
pPayDayMins,
pExp,
pHouseKey,
pJob,
bool:pLocked,
pFaction,
pFRank,
pSalary,
pOOCJail,
pPayDay,
pRadio[ MAX_RADIO_SLOTS ],
pCurRSlot,
pDeaths,
bool:pBikeLic,
bool:pDrivingLic,
bool:pFlyingLic,
bool:pBoatLic,
bool:pWeaponLic,
bool:pTruckLic,
pBikeWarns,
pDriveWarns,
pFlyWarns,
pBoatWarns,
pWeapWarns,
pContract,
pPrisonTime,
pPrisonCam,
pSpawnPlace,
pTrucksPD,
pMinJail,
pPromiles
};

enum FishInfo
{
fDurability,
fBait,
fPermit,
fRecord [ 2 ],
fFish   [ 5 ],
fWeight [ 5 ],
}

new
bool:aExist [ MAX_PLAYERS ], 			 // Ar žaidėjo sąskaita egzistuoja
FishingInfo [ MAX_PLAYERS ][ FishInfo ], // Masyvas saugoti žvejybos informacijai.
PlayerInfo  [ MAX_PLAYERS ][ pInfo ]; 	 // Masyvas saugoti žaidėjų duomenims

stock NullPlayerRegVariables( playerid )
{
// Funkcija: NullPlayerVariables( playerid )
// Išvalys žaidėjo kintamuosius

aLogged[ playerid ] = false;
aExist [ playerid ] = false;

PlayerInfo[ playerid ][ pSQLID    			] = 0;
PlayerInfo[ playerid ][ pAge      			] = 0;
PlayerInfo[ playerid ][ pNationality       	] = false;
PlayerInfo[ playerid ][ pbankpass       	] = false;
PlayerInfo[ playerid ][ pBankCard       	] = false;
PlayerInfo[ playerid ][ pBankLang       	] = false;
PlayerInfo[ playerid ][ pSex		       	] = false;
PlayerInfo[ playerid ][ pPersonalC 			] = 0;
PlayerInfo[ playerid ][ pLevel    			] = 0;
PlayerInfo[ playerid ][ pAdmin    			] = 0;
PlayerInfo[ playerid ][ pVip    			] = 0;
PlayerInfo[ playerid ][ pVguns    			] = 0;
PlayerInfo[ playerid ][ pHelper    			] = 0;
PlayerInfo[ playerid ][ pCash     			] = 0;
PlayerInfo[ playerid ][ pBank     			] = 0;
PlayerInfo[ playerid ][ pBankTransfer		] = 0;
   PlayerInfo[ playerid ][ pMute     			] = false;
   PlayerInfo[ playerid ][ pWarn     			] = 0;
   PlayerInfo[ playerid ][ pSkin     			] = 123;
   PlayerInfo[ playerid ][ pInt      			] = 0;
   PlayerInfo[ playerid ][ pVirWorld 			] = 0;
   PlayerInfo[ playerid ][ pPos_x    			] = 0.0;
   PlayerInfo[ playerid ][ pPos_y    			] = 0.0;
   PlayerInfo[ playerid ][ pPos_z    			] = 0.0;
   PlayerInfo[ playerid ][ pCrashed  			] = false;
   for ( new wep = 0; wep < MAX_SAVED_WEAPONS; wep++ )
   {
       PlayerInfo[ playerid ][ pGun  ][ wep ] = 0;
       PlayerInfo[ playerid ][ pAmmo ][ wep ] = 0;
   }
   PlayerInfo[ playerid ][ pPhNumber   		] = 0;
   PlayerInfo[ playerid ][ pPlayHours  		] = 0;
   PlayerInfo[ playerid ][ pPayDayMins 		] = 0;
   PlayerInfo[ playerid ][ pExp        		] = 0;
   PlayerInfo[ playerid ][ pHouseKey   		] = 0;
   PlayerInfo[ playerid ][ pJob        		] = JOB_NONE;
   PlayerInfo[ playerid ][ pLocked     		] = false;
   PlayerInfo[ playerid ][ pFaction    		] = -1;
   PlayerInfo[ playerid ][ pFRank      		] = 0;
   PlayerInfo[ playerid ][ pOOCJail    		] = 0;
   PlayerInfo[ playerid ][ pPayDay     		] = 0;
   for ( new i = 0; i < MAX_RADIO_SLOTS; i++ )
       PlayerInfo[ playerid ][ pRadio ][ i ] = 0;
PlayerInfo[ playerid ][ pCurRSlot   		] = 0;
PlayerInfo[ playerid ][ pDeaths     		] = 0;
PlayerInfo[ playerid ][ pBikeLic    		] = false;
PlayerInfo[ playerid ][ pDrivingLic 		] = false;
PlayerInfo[ playerid ][ pFlyingLic  		] = false;
PlayerInfo[ playerid ][ pBoatLic    		] = false;
PlayerInfo[ playerid ][ pWeaponLic  		] = false;
PlayerInfo[ playerid ][ pContract   		] = 0;
PlayerInfo[ playerid ][ pPrisonTime 		] = 0;
PlayerInfo[ playerid ][ pPrisonCam  		] = 0;
PlayerInfo[ playerid ][ pSpawnPlace 		] = 0;
PlayerInfo[ playerid ][ pTrucksPD	 		] = 0;
PlayerInfo[ playerid ][ pMinJail	 		] = 0;

drugsloop
{
	DrugInfo [ playerid ][ i ][ dAddiction ] = -1;
	DrugInfo [ playerid ][ i ][ dTime      ] = 0;
	DrugInfo [ playerid ][ i ][ dActive    ] = false;
}

FishingInfo[ playerid ][ fDurability ] = -1;
FishingInfo[ playerid ][ fBait		 ] = 0;
FishingInfo[ playerid ][ fPermit	 ] = 0;
FishingInfo[ playerid ][ fRecord	 ][ 0 ] = 0;
FishingInfo[ playerid ][ fRecord	 ][ 1 ] = 0;

for ( new f = 0; f < 6; f++ )
{
	FishingInfo[ playerid ][ fFish		 ][ f ] = 0;
	FishingInfo[ playerid ][ fWeight	 ][ f ] = 0;
}
}

stock MySQLNameCheck( sqlname[ ] )
{
// Funkcija: MySQLNameCheck( sqlname[ ] )

MySQLCheckConnection( );

new
    string[ 68 ];

format( string, 68, "SELECT `id` FROM `players` WHERE `Name`='%s'",
        sqlname );

mysql_query       ( string );
mysql_store_result( );

if ( mysql_fetch_row( string ) )
    return strval( string );
else
	return 0;
}

stock CheckIfAccExist( playerid )
{
// Funkcija: CheckIfAccExist( playerid )
// Patikrins ar žaidėjo sąskaita egzistuoja

new
    name[ MAX_PLAYER_NAME ];

GetPlayerName( playerid, name, MAX_PLAYER_NAME );
PlayerInfo[ playerid ][ pSQLID ] = MySQLNameCheck( name );

if ( PlayerInfo[ playerid ][ pSQLID ] > 0 )
{ // Sąskaita jau egzistuoja
	new
		ip     [ 24 ],
		string [ 300 ],
		title  [ 300 ];

	GetPlayerRPName ( playerid, name, MAX_PLAYER_NAME );
	GetPlayerIp		( playerid, ip, 24 );
	    format ( title, 300, "Sveiki atvykę {00FF00}%s", name );

	format ( string, 300, "{FFFFFF}Prisijungimas į {00FF00}GTA-SA.LT{FFFFFF}serverį\n\
	Jūsų vardas: {00FF00}%s\n\
	{FFFFFF}Jūsų IP adresas: {00FF00}%s\n\
	\t\t\t\t\t{FFFFFF}Prašome įvesti savo prisijungimo slaptažodį", name, ip );

       ShowPlayerDialog( playerid, 1000, DIALOG_STYLE_INPUT,
					  title,
					  string,
					  "Prisijungti", "Atšaukti" );
	zaidimast[playerid] = SetTimerEx("Zaidimas",60*1000,true,"i",playerid);
	aExist[ playerid ] = true;

}
else
{ // Sąskaita neegzistuoja
RegisterDialog(playerid);
//Kick			 ( playerid );
}
}
stock MySQLUpdateBuild( query[ ], sqlplayerid )
{
// Funkcija: MySQLUpdateBuild( query[ ], sqlplayerid )
// Sukūrė Luk0r

new
	querylen = strlen( query );

if ( querylen < 1 )
	format( query, 255, "UPDATE `players` SET " );
else if ( 255 - querylen < 50 )
{
	format     ( query, 255, "%s WHERE `id`=%d", query, sqlplayerid );
	mysql_query( query );
	format     ( query, 255, "UPDATE `players` SET " );
}
else if ( strfind( query, "=", true ) != -1 )
	format( query, 255, "%s,", query );
}

stock MySQLUpdateFinish( query[ ], sqlplayerid )
{
// Funkcija: MySQLUpdateFinish( query[ ], sqlplayerid )
// Sukūrė Luk0r

if ( !strcmp( query, "WHERE `id`=", false ) )
	mysql_query( query );
else
{
	format     ( query, 255, "%s WHERE `id`=%d", query, sqlplayerid );
	mysql_query( query );
	format     ( query, 255, "UPDATE `players` SET " );
}
}

stock MySQLUpdatePlayerInt( query[ ], sqlplayerid, const sqlvalname[], sqlupdateint )
{
// Funkcija: MySQLUpdatePlayerInt( query[ ], sqlplayerid, const sqlvalname[], sqlupdateint )
// Sukūrė Luk0r

MySQLUpdateBuild( query, sqlplayerid );
format          ( query, 255, "%s`%s`=%d",
				  query, sqlvalname, sqlupdateint );
}

stock MySQLUpdatePlayerFlo( query[ ], sqlplayerid, sqlvalname[ ], Float:sqlupdateflo )
{
// Funkcija: MySQLUpdatePlayerFlo( query[ ], sqlplayerid, sqlvalname[ ], Float:sqlupdateflo )
// Sukūrė: Luk0r

new
	flotostr[ 32 ];

format              ( flotostr, 31, "%f", sqlupdateflo );
MySQLUpdatePlayerStr( query, sqlplayerid, sqlvalname, flotostr );
}

stock MySQLUpdatePlayerStr( query[ ], sqlplayerid, sqlvalname[ ], sqlupdatestr[ ] )
{
// Funkcija: MySQLUpdatePlayerStr( query[ ], sqlplayerid, sqlvalname[ ], sqlupdatestr[ ] )
// Sukūrė Luk0r

MySQLUpdateBuild	( query, sqlplayerid );


new
	escstr[ 128 ];
mysql_real_escape_string( sqlupdatestr, escstr );
format                  ( query, 255, "%s`%s`='%s'",
							query, sqlvalname, escstr );
}

stock LoginPlayer( playerid, password[ ] )
{
// Funckija LoginPlayer( playerid, password[ ] )
// Priskiriame žaidėjui kintamuosius iš duomenų bazės, jei įrašytas
// slaptažodis yra teisingas, jei ne, išspiriame jį iš žaidimo.

MySQLCheckConnection( );

new
    string	   [ 2048 ],
	enteredpass[ 129 ];

format( string, 2024, "SELECT * FROM `players` WHERE `id`=%d LIMIT 1",
		PlayerInfo[ playerid ][ pSQLID ] );

mysql_query       ( string );
mysql_store_result( );

if ( !mysql_fetch_row( string ) )
{
    SendClientMessage( playerid, COLOR_RED, "Prisijungimo klaida #001" );
    SendClientMessage( playerid, COLOR_RED, "Nerasti MySQL duomenys." );
	Kick( playerid );
}

sscanf( string, "p<|>{ds[24]}s[129]s[2000]", PlayerInfo[ playerid ][ pKey ],
        string );

WP_Hash ( enteredpass, 129, password );

if ( !strcmp( PlayerInfo[ playerid ][ pKey ], enteredpass, true ) )
{
    new
        trash [ 24 ],
        money,
        fightstyle;

	if ( sscanf( string, "p<|>ds[24]s[24]dds[24]s[24]s[11]ddddddddlddddffflddddddddddddlddddddddddddddddddddddddddddddlll\
lllddddddddddddddddddddddddddddddddds[28]ds[28]ds[28]ds[28]s[24]",
			PlayerInfo[ playerid ][ pAge        ],
			PlayerInfo[ playerid ][ pNationality],
			PlayerInfo[ playerid ][ pbankpass   ],
			PlayerInfo[ playerid ][ pBankCard   ],
			PlayerInfo[ playerid ][ pBankLang   ],
			PlayerInfo[ playerid ][ pBornPlace	],
			PlayerInfo[ playerid ][ pSex		],
			PlayerInfo[ playerid ][ pPersonalC	],
	        PlayerInfo[ playerid ][ pLevel      ],
	        PlayerInfo[ playerid ][ pAdmin      ],
	        PlayerInfo[ playerid ][ pVip        ],
	        PlayerInfo[ playerid ][ pVguns      ],
			PlayerInfo[ playerid ][ pHelper		],
	        money,
	        PlayerInfo[ playerid ][ pBank       ],
			PlayerInfo[ playerid ][ pBankTransfer ],
	        PlayerInfo[ playerid ][ pMute       ],
	        PlayerInfo[ playerid ][ pWarn       ],
               PlayerInfo[ playerid ][ pSkin       ],
	        PlayerInfo[ playerid ][ pInt        ],
	        PlayerInfo[ playerid ][ pVirWorld   ],
	        PlayerInfo[ playerid ][ pPos_x      ],
	        PlayerInfo[ playerid ][ pPos_y      ],
	        PlayerInfo[ playerid ][ pPos_z      ],
	        PlayerInfo[ playerid ][ pCrashed    ],

	        PlayerInfo[ playerid ][ pGun        ][ 0 ],
	        PlayerInfo[ playerid ][ pGun        ][ 1 ],
	        PlayerInfo[ playerid ][ pGun        ][ 2 ],

	        PlayerInfo[ playerid ][ pAmmo       ][ 0 ],
	        PlayerInfo[ playerid ][ pAmmo       ][ 1 ],
	        PlayerInfo[ playerid ][ pAmmo       ][ 2 ],

	        PlayerInfo[ playerid ][ pPhNumber   ],
	        PlayerInfo[ playerid ][ pPlayHours  ],
	        PlayerInfo[ playerid ][ pPayDayMins ],
	        PlayerInfo[ playerid ][ pExp        ],
	        PlayerInfo[ playerid ][ pHouseKey   ],
	        PlayerInfo[ playerid ][ pJob        ],
	        PlayerInfo[ playerid ][ pLocked     ],
	        PlayerInfo[ playerid ][ pFaction    ],
	        PlayerInfo[ playerid ][ pFRank      ],
			PlayerInfo[ playerid ][ pSalary	    ],
	        PlayerInfo[ playerid ][ pOOCJail    ],
	        PlayerInfo[ playerid ][ pPayDay     ],

	        InvInfo   [ playerid ][ 0 ][ 0 ],
	        InvInfo   [ playerid ][ 0 ][ 1 ],
	        InvInfo   [ playerid ][ 1 ][ 0 ],
	        InvInfo   [ playerid ][ 1 ][ 1 ],
	        InvInfo   [ playerid ][ 2 ][ 0 ],
	        InvInfo   [ playerid ][ 2 ][ 1 ],
	        InvInfo   [ playerid ][ 3 ][ 0 ],
	        InvInfo   [ playerid ][ 3 ][ 1 ],
	        InvInfo   [ playerid ][ 4 ][ 0 ],
	        InvInfo   [ playerid ][ 4 ][ 1 ],
	        InvInfo   [ playerid ][ 5 ][ 0 ],
	        InvInfo   [ playerid ][ 5 ][ 1 ],
	        InvInfo   [ playerid ][ 6 ][ 0 ],
	        InvInfo   [ playerid ][ 6 ][ 1 ],
	        InvInfo   [ playerid ][ 7 ][ 0 ],
	        InvInfo   [ playerid ][ 7 ][ 1 ],
	        InvInfo   [ playerid ][ 8 ][ 0 ],
	        InvInfo   [ playerid ][ 8 ][ 1 ],
	        InvInfo   [ playerid ][ 9 ][ 0 ],
	        InvInfo   [ playerid ][ 9 ][ 1 ],


	        PlayerInfo[ playerid ][ pRadio      ][ 0 ],
	        PlayerInfo[ playerid ][ pRadio      ][ 1 ],
	        PlayerInfo[ playerid ][ pRadio      ][ 2 ],

	        PlayerInfo[ playerid ][ pCurRSlot   ],
	        PlayerInfo[ playerid ][ pDeaths     ],
	        PlayerInfo[ playerid ][ pBikeLic    ],
	        PlayerInfo[ playerid ][ pDrivingLic ],
	        PlayerInfo[ playerid ][ pFlyingLic  ],
	        PlayerInfo[ playerid ][ pBoatLic    ],
	        PlayerInfo[ playerid ][ pWeaponLic  ],
			PlayerInfo[ playerid ][ pTruckLic  ],
	        PlayerInfo[ playerid ][ pBikeWarns  ],
	        PlayerInfo[ playerid ][ pDriveWarns ],
	        PlayerInfo[ playerid ][ pFlyWarns   ],
	        PlayerInfo[ playerid ][ pBoatWarns  ],
	        PlayerInfo[ playerid ][ pWeapWarns  ],
	        PlayerInfo[ playerid ][ pContract   ],
	        PlayerInfo[ playerid ][ pPrisonTime ],
	        PlayerInfo[ playerid ][ pPrisonCam  ],
	        fightstyle,
	        PlayerInfo[ playerid ][ pSpawnPlace ],
	        PlayerInfo[ playerid ][ pTrucksPD   ],
	        PlayerInfo[ playerid ][ pMinJail    ],
	        PlayerInfo[ playerid ][ pPromiles   ],		
			DrugInfo  [ playerid ][ DRUG_COCAINE ][ dAddiction ],
			DrugInfo  [ playerid ][ DRUG_LSD     ][ dAddiction ],
			DrugInfo  [ playerid ][ DRUG_HEROINE ][ dAddiction ],
			FishingInfo[ playerid ][ fDurability ],
			FishingInfo[ playerid ][ fBait		 ],
			FishingInfo[ playerid ][ fPermit	 ],
			FishingInfo[ playerid ][ fRecord	 ][ 0 ],
			FishingInfo[ playerid ][ fRecord	 ][ 1 ],
			FishingInfo[ playerid ][ fFish		 ][ 0 ],
			FishingInfo[ playerid ][ fWeight	 ][ 0 ],
			FishingInfo[ playerid ][ fFish		 ][ 1 ],
			FishingInfo[ playerid ][ fWeight	 ][ 1 ],
			FishingInfo[ playerid ][ fFish		 ][ 2 ],
			FishingInfo[ playerid ][ fWeight	 ][ 2 ],
			FishingInfo[ playerid ][ fFish		 ][ 3 ],
			FishingInfo[ playerid ][ fWeight	 ][ 3 ],
			FishingInfo[ playerid ][ fFish		 ][ 4 ],
			FishingInfo[ playerid ][ fWeight	 ][ 4 ],
			WantedPoints [ playerid ],
			CheckInfo[ playerid ][ 0 ][ camount ],
			CheckInfo[ playerid ][ 0 ][ cgiver ],
			CheckInfo[ playerid ][ 1 ][ camount ],
			CheckInfo[ playerid ][ 1 ][ cgiver ],
			CheckInfo[ playerid ][ 2 ][ camount ],
			CheckInfo[ playerid ][ 2 ][ cgiver ],
			CheckInfo[ playerid ][ 3 ][ camount ],
			CheckInfo[ playerid ][ 3 ][ cgiver ],
			trash ) ) print ( "SSCANF FAIL" );
		new skinas = PlayerInfo[ playerid ][ pSkin ];
	SetPlayerFightingStyle( playerid, fightstyle );

	ResetPlayerMoney( playerid );
	GivePlayerMoney ( playerid, money );
	SetPlayerSkin(playerid, skinas );

	OnPlayerLogin	( playerid );
}
else
{
    SendClientError( playerid, "Slaptažodis yra neteisingas, uždaromas žaid\
imas.");
    Kick( playerid );
}
}

stock OnPlayerLogin( playerid )
{
// Funkcija OnPlayerLogin( playerid )
// Bus iškviesta, kai žaidėjas prisijungs prie savo sąskaitos

// Iškickiname žaidėja, jei jo sąskaita užrakinta
if ( PlayerInfo[ playerid ][ pLocked ] )
{
    SendClientError	( playerid, "Ši sąskaita yra užrakinta.");
    Kick			( playerid );
}

// Jei žaidėjas yra surinkęs 3 įspėjimus
if ( PlayerInfo[ playerid ][ pWarn ] > 2 )
{
    SendClientError	( playerid, "Ši sąskaita yra užrakinta.");
    Kick			( playerid );
}

// Jeigu turi priklausomybę - aptempdom ekraną.
drugsloop
{
	if ( DrugInfo [ playerid ][ i ][ dAddiction ] == 0 )
	{
		new
			string [ 75 ];
		FadeScreen ( playerid );

		format ( string, 74, "[NARKOTIKAI] Jūs ęsate priklausomas nuo %s. Jums reikia dozės.", GetDrugNameByID ( i ) );
		SendClientMessage ( playerid, COLOR_FADE3, string );
	}
}
// Jei žaidėjas prisijungęs pirmą kartą
if ( PlayerInfo[ playerid ][ pLevel ] == 0 )
{
    PlayerInfo[ playerid ][ pLevel    ] = 400;
    PlayerInfo[ playerid ][ pPhNumber ] = 0;
    GivePlayerMoney	( playerid, 5000 );
	PrisijungeNaujokas(playerid);
}
 // Jei žaidėjas administratorius, suteikiam jam admin darbą.
if ( PlayerInfo[ playerid ][ pAdmin ] > 0 && PlayerInfo[ playerid ][ pVip ] > 0 )
{
PrisijungeAdmVip (playerid);
}
else if ( PlayerInfo[ playerid ][ pAdmin ] > 0 )
{
PrisijungeAdminas (playerid);
}
 // Jei VIP, tai suteikiam jam spalvą.
else if ( PlayerInfo[ playerid ][ pVip ] > 0 )
{
PrisijungeVip (playerid);
}
// Žaidėjui saugom kas 1MIN ginklus
   SetTimer( "SaugotiGinklus",    30000, true );
SetPlayerScore  	( playerid, PlayerInfo[ playerid ][ pLevel ] );
SetPlayerSpecialActionEx
					( playerid, SPECIAL_ACTION_NONE );
SetPlayerDrunkLevel ( playerid, PlayerInfo [ playerid ][ pPromiles ] );
SpawnPlayerEx   	( playerid );
SetPVarInt 			( playerid, "lastcarid", -1 );
SetPVarInt 			( playerid, "vehseat", -1 );
SetPlayerWantedLevel( playerid, WantedPoints[ playerid ] );

TruckingTo   [ playerid ] = -1;
aLogged      [ playerid ] = true;
DOR          [ playerid ] = INVALID_3D_TEXT;
FishWaitTime { playerid } = -1;

SetTimerEx			( "allowBoxing", 1200000, false, "dd", playerid,
																playerid );


new
    string[ 47 ],
    name  [ MAX_PLAYER_NAME ];

GetPlayerRPName( playerid, name, MAX_PLAYER_NAME );

if ( !PlayerInfo[ playerid ][ pCrashed ] )
{
	format( string, 46, "~g~Sveiki atvyke~n~~y~%s", name );
	GameTextForPlayer( playerid, string, 3000, 1 );
	aLogged[ playerid ] = true;
	aExist[ playerid ] = true;
}
else
{
    ShowInfoText( playerid, "~p~nutruko rysys..." );
    PlayerInfo[ playerid ][ pCrashed ] = false;
    aLogged[ playerid ] = true;
    aExist[ playerid ] = true;
}

ClearChatbox( playerid, 8 );
format( string, 46, "Sveiki atvykę, %s!", name );
SendClientMessage	( playerid, COLOR_WHITE, string );
aLogged[ playerid ] = true;
   aExist[ playerid ] = true;

ClearChatbox( playerid, 1 );

   foreach (Player, i)
   {
       if ( !aLogged[ i ] ) continue;
	if ( Mask[ i ] )     ShowPlayerNameTagForPlayer( playerid, i, false );
}
   AssignVehiclesToPlayerFromDB	( playerid );
}
stock UpdatePlayer( playerid )
{
// Funkcija UpdatePlayer( playerid )
// Išsaugos žaidėjo duomenis jo faile
printf( "SAVE: Tikrina prijungima" );
if ( aLogged[ playerid ] && aExist[ playerid ] )
{
	printf( "SAVE: TOLIAU prisijungisuiui tikrina mysql" );
    MySQLCheckConnection( );
    printf( "SAVE: TOLIAU mysql prijungta" );
    new
        query[ 628 ],
		tmp  [ 128  ];

	format( query, 628, "UPDATE `players` SET " );
	printf( "SAVE: vygdome išsaugojima" );
	new
	    sqlid = PlayerInfo[ playerid ][ pSQLID ];
	     new money = GetPlayerMoney(playerid);

	MySQLUpdatePlayerInt( query, sqlid, "Level", PlayerInfo[ playerid ][ pLevel ] );
	MySQLUpdatePlayerInt( query, sqlid, "BankCard", PlayerInfo[ playerid ][ pBankCard ] );
	MySQLUpdatePlayerInt( query, sqlid, "BankLang", PlayerInfo[ playerid ][ pBankLang ] );
	MySQLUpdatePlayerInt( query, sqlid, "Admin", PlayerInfo[ playerid ][ pAdmin ] );
	MySQLUpdatePlayerInt( query, sqlid, "Vip", PlayerInfo[ playerid ][ pVip ] );
	MySQLUpdatePlayerInt( query, sqlid, "Vguns", PlayerInfo[ playerid ][ pVguns ] );
	MySQLUpdatePlayerInt( query, sqlid, "Helper", PlayerInfo[ playerid ][ pHelper ] );
	MySQLUpdatePlayerInt( query, sqlid, "Cash", money );
	MySQLUpdatePlayerInt( query, sqlid, "Bank", PlayerInfo[ playerid ][ pBank ] );
	MySQLUpdatePlayerInt( query, sqlid, "BankTransfer",  PlayerInfo[ playerid ][ pBankTransfer ] );
	MySQLUpdatePlayerInt( query, sqlid, "Mute", PlayerInfo[ playerid ][ pMute ] );
	MySQLUpdatePlayerInt( query, sqlid, "Warn", PlayerInfo[ playerid ][ pWarn ] );
	MySQLUpdatePlayerInt( query, sqlid, "Skin", PlayerInfo[ playerid ][ pSkin ] );
	MySQLUpdatePlayerInt( query, sqlid, "Int", PlayerInfo[ playerid ][ pInt ] );
	MySQLUpdatePlayerInt( query, sqlid, "VirWorld", PlayerInfo[ playerid ][ pVirWorld ] );

	if ( PlayerInfo[ playerid ][ pCrashed ] )
	{
		printf( "SAVE: saugome pozicija" );
		GetPlayerPos        ( playerid, PlayerInfo[ playerid ][ pPos_x ], PlayerInfo[ playerid ][ pPos_y ], PlayerInfo[ playerid ][ pPos_z ] );
		MySQLUpdatePlayerFlo( query, sqlid, "Pos_x", PlayerInfo[ playerid ][ pPos_x ] );
		MySQLUpdatePlayerFlo( query, sqlid, "Pos_y", PlayerInfo[ playerid ][ pPos_y ] );
		MySQLUpdatePlayerFlo( query, sqlid, "Pos_z", PlayerInfo[ playerid ][ pPos_z ] );
		MySQLUpdatePlayerInt( query, sqlid, "Crashed", 1 );
	}
	else
	    MySQLUpdatePlayerInt( query, PlayerInfo[ playerid ][ pSQLID ], "Crashed", 0 );

	printf( "SAVE: saugome kitka" );
	MySQLUpdatePlayerInt( query, sqlid, "PhNumber", PlayerInfo[ playerid ][ pPhNumber ] );
	MySQLUpdatePlayerInt( query, sqlid, "PlayHours", PlayerInfo[ playerid ][ pPlayHours ] );
	MySQLUpdatePlayerInt( query, sqlid, "PayDayMins", PlayerInfo[ playerid ][ pPayDayMins ] );
	MySQLUpdatePlayerInt( query, sqlid, "Exp", PlayerInfo[ playerid ][ pExp ] );
	MySQLUpdatePlayerInt( query, sqlid, "HouseKey", PlayerInfo[ playerid ][ pHouseKey ] );
	MySQLUpdatePlayerInt( query, sqlid, "Job", PlayerInfo[ playerid ][ pJob ] );
	MySQLUpdatePlayerInt( query, sqlid, "Locked", PlayerInfo[ playerid ][ pLocked ] );
	MySQLUpdatePlayerInt( query, sqlid, "Faction", PlayerInfo[ playerid ][ pFaction ] );
	MySQLUpdatePlayerInt( query, sqlid, "FRank", PlayerInfo[ playerid ][ pFRank ] );
	MySQLUpdatePlayerInt( query, sqlid, "Salary", PlayerInfo[ playerid ][ pSalary ] );
	MySQLUpdatePlayerInt( query, sqlid, "OOCJail", PlayerInfo[ playerid ][ pOOCJail ] );
	MySQLUpdatePlayerInt( query, sqlid, "PayDay", PlayerInfo[ playerid ][ pPayDay ] );

	for ( new i = 0; i < INVENTORY_SLOTS; i++ )
	{
	    new
	        tmpstr[ 14 ];

		format              ( tmpstr, 13, "InvID%d", i );
		MySQLUpdatePlayerInt( query, sqlid, tmpstr, InvInfo[ playerid ][ i ][ 0 ] );
		format              ( tmpstr, 13, "InvAmmount%d", i );
		MySQLUpdatePlayerInt( query, sqlid, tmpstr, InvInfo[ playerid ][ i ][ 1 ] );
	}

	for ( new i = 0; i < MAX_RADIO_SLOTS; i++ )
	{
	    new
			tmpstr[ 10 ];

		format( tmpstr, 9, "Radio%d", i );
		MySQLUpdatePlayerInt( query, sqlid, tmpstr, PlayerInfo[ playerid ][ pRadio ][ i ] );
	}
	printf( "SAVE: toliau išsaugojame" );
	MySQLUpdatePlayerInt( query, sqlid, "CurRSlot", PlayerInfo[ playerid ][ pCurRSlot ] );
	MySQLUpdatePlayerInt( query, sqlid, "Deaths", PlayerInfo[ playerid ][ pDeaths ] );
	MySQLUpdatePlayerInt( query, sqlid, "BikeLic", PlayerInfo[ playerid ][ pBikeLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "DrivingLic", PlayerInfo[ playerid ][ pDrivingLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "FlyingLic", PlayerInfo[ playerid ][ pFlyingLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "BoatLic", PlayerInfo[ playerid ][ pBoatLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "WeaponLic", PlayerInfo[ playerid ][ pWeaponLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "TruckLic", PlayerInfo[ playerid ][ pTruckLic ] );
	MySQLUpdatePlayerInt( query, sqlid, "BikeWarns", PlayerInfo[ playerid ][ pBikeWarns ] );
	MySQLUpdatePlayerInt( query, sqlid, "DriveWarns", PlayerInfo[ playerid ][ pDriveWarns ] );
	MySQLUpdatePlayerInt( query, sqlid, "FlyWarns", PlayerInfo[ playerid ][ pFlyWarns ] );
	MySQLUpdatePlayerInt( query, sqlid, "BoatWarns", PlayerInfo[ playerid ][ pBoatWarns ] );
	MySQLUpdatePlayerInt( query, sqlid, "WeapWarns", PlayerInfo[ playerid ][ pWeapWarns] );
	MySQLUpdatePlayerInt( query, sqlid, "Contract", PlayerInfo[ playerid ][ pContract ] );
	MySQLUpdatePlayerInt( query, sqlid, "PrisonTime", PlayerInfo[ playerid ][ pPrisonTime ] );
	MySQLUpdatePlayerInt( query, sqlid, "PrisonCam", PlayerInfo[ playerid ][ pPrisonCam ] );
	MySQLUpdatePlayerInt( query, sqlid, "TrucksPD", PlayerInfo[ playerid ][ pTrucksPD ] );

	if ( Countdown [ playerid ] > 0 && CountdownType [ playerid ] == 10 )
		MySQLUpdatePlayerInt( query, sqlid, "MinJail", Countdown [ playerid ] );
	else
		MySQLUpdatePlayerInt( query, sqlid, "MinJail", 0 );

	if ( !IsPlayerOnDrugs ( playerid ) )
		MySQLUpdatePlayerInt( query, sqlid, "promiles", GetPlayerDrunkLevel ( playerid ) );

	MySQLUpdatePlayerInt( query, sqlid, "CocaineAddict", DrugInfo 	[ playerid ][ DRUG_COCAINE ][ dAddiction ] );
	MySQLUpdatePlayerInt( query, sqlid, "LSDAddict",     DrugInfo   [ playerid ][ DRUG_LSD ][ dAddiction ] );
	MySQLUpdatePlayerInt( query, sqlid, "HeroineAddict", DrugInfo	[ playerid ][ DRUG_HEROINE ][ dAddiction ] );

	format ( tmp, 75, "%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d",
			FishingInfo[ playerid ][ fDurability ],
			FishingInfo[ playerid ][ fBait		 ],
			FishingInfo[ playerid ][ fPermit	 ],
			FishingInfo[ playerid ][ fRecord	 ][ 0 ],
			FishingInfo[ playerid ][ fRecord	 ][ 1 ],
			FishingInfo[ playerid ][ fFish		 ][ 0 ],
			FishingInfo[ playerid ][ fWeight	 ][ 0 ],
			FishingInfo[ playerid ][ fFish		 ][ 1 ],
			FishingInfo[ playerid ][ fWeight	 ][ 1 ],
			FishingInfo[ playerid ][ fFish		 ][ 2 ],
			FishingInfo[ playerid ][ fWeight	 ][ 2 ],
			FishingInfo[ playerid ][ fFish		 ][ 3 ],
			FishingInfo[ playerid ][ fWeight	 ][ 3 ],
			FishingInfo[ playerid ][ fFish		 ][ 4 ],
			FishingInfo[ playerid ][ fWeight	 ][ 4 ]		);
              	MySQLUpdatePlayerStr( query, sqlid, "FishInfo", tmp );

	MySQLUpdatePlayerInt( query, sqlid, "WantedPoints", WantedPoints[ playerid ] );

	format ( tmp, 128, "%d|%s|%d|%s|%d|%s|%d|%s",
			CheckInfo[ playerid ][ 0 ][ camount ],
			CheckInfo[ playerid ][ 0 ][ cgiver ],
			CheckInfo[ playerid ][ 1 ][ camount ],
			CheckInfo[ playerid ][ 1 ][ cgiver ],
			CheckInfo[ playerid ][ 2 ][ camount ],
			CheckInfo[ playerid ][ 2 ][ cgiver ],
			CheckInfo[ playerid ][ 3 ][ camount ],
			CheckInfo[ playerid ][ 3 ][ cgiver ] );
	printf( "SAVE: SAugojimas i  pabaiga" );
	MySQLUpdatePlayerStr( query, sqlid, "CheckInfo", tmp );
	printf( "SAVE: MySQLUpdateFinish" );
	MySQLUpdateFinish( query, sqlid );
	printf( "SAVE: Saugojimas baigesi." );
}
}

stock ChangePlayerPass( playerid, newpass[ ] )
{
// Funkcija: ChangePlayerPass( playerid, newpass[ ] )
// Pakeis vartotojo slaptažodį

format( PlayerInfo[ playerid ][ pKey ], 20, "%s", newpass );
UpdatePlayer( playerid );

SendClientMessage( playerid, COLOR_WHITE, "   Slaptažodis pakeistas sėkmingai." );
}

stock UpdateMySQLFightStyle( playerid )
{
// Funkcija: UpdateMySQLKarateStyle( playerid )

MySQLCheckConnection( );

new
    string[ 71 ];

format( string, 71, "UPDATE `players` SET `FightStyle`=%d WHERE `id`=%d",
        GetPlayerFightingStyle( playerid ),
		PlayerInfo[ playerid ][ pSQLID ] );

mysql_query( string );
}

stock UpdateMySQLSpawnPlace( playerid )
{
// Funkcija: UpdateMySQLSpawnPlace( playerid )

MySQLCheckConnection( );

new
    string[ 71 ];

format( string, 71, "UPDATE `players` SET `SpawnPlace`=%d WHERE `id`=%d",
        PlayerInfo[ playerid ][ pSpawnPlace ],
        PlayerInfo[ playerid ][ pSQLID ] );

mysql_query( string );
}
stock ZaidejoVardas(playerid)
{
       new name[24];
       GetPlayerName(playerid, name, sizeof(name));
       return name;
}

stock ZaidejoIP(playerid)
{
       new playerip[16];
       GetPlayerIp(playerid, playerip, sizeof(playerip));
       return playerip;
}
stock InvalidNickKick(playerid)
{
if ( IsPlayerNPC( playerid ) )
	return true;
   new name[MAX_PLAYER_NAME];
GetPlayerName(playerid,name,sizeof(name));
   new where = strfind(name,"_",true);
   new lenght = strlen(name)-1;
   new invalid = strfind(name,"[",true);
   if(invalid == -1) invalid = strfind(name,"]",true);

   if(where == 0 || where == lenght || where==-1)
   {
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Jusu slapyvardis netinkamas.");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Teisinga slapyvardžio forma būtu:");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Vardas_Pavarde");
    Kick(playerid);
    return 1;
 }

 if(strlen(name[where])<4)
 {
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Jusu pavarde per trumpa");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Teisinga slapyvardžio forma būtu:");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Vardas_Pavarde");
    Kick(playerid);
    return 1;
 }

 if(where<3)
 {
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Jusu vardas per trumpas");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Teisinga slapyvardžio forma būtu:");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Vardas_Pavarde");
    Kick(playerid);
    return 1;
 }

 if(invalid != -1)
 {
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Varde rasta netinkamu raidziu.");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Teisinga slapyvardžio forma būtu:");
    SendClientMessage(playerid,COLOR_RED,"* Administracijos pagalbininkai: Vardas_Pavarde");
    Kick(playerid);
    return 1;
 }
 return 0;
}

5bebb2bcb3c949bbf0f2f9407c13b967561.png

Ši tema yra neaktyvi. Paskutinis pranešimas šioje temoje buvo prieš 5090 dienas (-ų). Patariame sukurti naują temą, o ne rašyti naują pranešimą.

Už neaktyvių temų prikėlimą galite sulaukti įspėjimo ir pranešimo pašalinimo!

Prisijungti prie diskusijos

Palikti atsakymą galite iš karto, o užsiregistruoti vėliau. Jeigu jau turite paskyrą mūsų forume, Prisijunkite.

Svečias
Atsakyti šioje temoje...

×   Įklijuotas tekstas turi teksto formatavimą.   Pašalinti teksto formatavimą

  Galimi tik 75 veidukai.

×   Nuoroda buvo automatiškai įterpta.   Įterpti nuorodą paprastai

×   Jūsų ankstesnis pranešimas buvo atkurtas.   Išvalyti redaktorių

×   Jūs negalite įkelti nuotraukas tiesiogiai.Įkelkite arba įdėkite nuotraukas iš URL.

×
 Pasidalinti
Eiti į

  • Šiame puslapyje naršo:   0 nariai

    • Nėra registruotų narių peržiūrinčių šį forumą.

Skelbimai


×
×
  • Sukurti naują...