Reikia pagalbos

[Bicas_Biciuks]

Sveiki, man reikia pagalbos, turiu LRG gamemode naujesnį, bet iškilo bėda, jis surištas su web, ką daryti, kaip atrišti, nes negaliu prisijungti ir panašiai, ta nesamonė kai prisijungi neužsiregistraves yra pačiame gale, ten parašyta jog jūsų vartotojas nėra užregistruotas, eikite užsiregistruoti i lrg.lt. padėkite atrišti prašau labai

Jei kam nepatogu naudoti kodu esančiu tarp CODE gairių, štai pastebin linkas:

http://pastebin.com/zfBRuQxR

enum pKintamieji
{
mysqlid,
prisijunges,
admin,
vip,
ispejimai,
uztildytas,
floodas,
skambutis,
pakvietimas,

exp,
lvl,

pila, // degalus i masina

darbas,
rangas,
dIspejimai,
direktorius,
pinigai,
saskaita,
bankas,
bauda,
namuose,
biznis,

teises1, // lengvosios
teises2, // sunkios,
teises3, // motociklai
teises4, // lektuvai
teises5, // laivai
perkam, // masinos model id

gaudomas,
ikalintas,
kalejime,
lytis,
drabuziai,
uniforma,
apsirenges,
mobsas,
drugs,

Float:hp,
Float:armor,
Float:*Myliu SuperGames.lt*,
Float:py,
Float:pz,
Float:pang,
pastatas,
interjeras,
world,
naujokas,

masinu,
gaminama,

lektuvas,
surakintas,
cpoint,
bilietas,
pmasina
}
new pInfo[MAX_PLAYERS][pKintamieji];
enum darbKintamieji
{
//isveziotojo
krovinio, // picos, baldai, maistas,
vezimai
}
new pDarbas[MAX_PLAYERS][darbKintamieji];
stock Clear(playerid)
{
pDarbas[playerid][krovinio] = 0;
pInfo[playerid][ispejimai] = 0;
pInfo[playerid][teises1] = 0;
pInfo[playerid][surakintas] = 0;
 pInfo[playerid][cpoint] = -1;
 pInfo[playerid][bankas] = 0;
 pInfo[playerid][drugs] = 0;
   pInfo[playerid][kalejime] = 0;
   pInfo[playerid][bilietas] = 0;
pInfo[playerid][pmasina] = 0;
pInfo[playerid][prisijunges] = 0;
pInfo[playerid][biznis] = 0;
pInfo[playerid][uniforma] = 0;
pInfo[playerid][drabuziai] = 0;
SetPlayerScore( playerid, 0 );
pInfo[playerid][skambutis] = -1;
pInfo[playerid][lektuvas] = -1;
pInfo[playerid][mobsas] = 20;
pInfo[playerid][pinigai] = 0;
pInfo[playerid][pastatas] = -1;
pInfo[playerid][apsirenges] = 0;
pInfo[playerid][direktorius] = 0;
pInfo[playerid][pila] = 0;



autoDB[ playerid ][ currentCP ] = -1;
}
stock LoadPlayerData(playerid)
{
new
 str[ 32 ],
 query[ 256 ],
 weps[ 2 ][ 12 ];
/*  Float:*Myliu SuperGames.lt*,
 Float:py,
 Float:pz,
 Float:hp,
 pint;*/

 format( query, 256, "SELECT * FROM `zaidejai` WHERE id = %d", pInfo[playerid][mysqlid] );
mysql_query( query );
mysql_store_result();
   mysql_fetch_row( query );
 mysql_fetch_field_row( str, "Patirtis" );

new tmpxp = strval( str );
   SetPlayerScore( playerid, tmpxp );
   // Nustatom pozicija
   mysql_fetch_field_row( str, "poz_X" ); pInfo[playerid][*Myliu SuperGames.lt*] = floatstr( str );
mysql_fetch_field_row( str, "poz_Y" ); pInfo[playerid][py] = floatstr( str );
mysql_fetch_field_row( str, "poz_Z" ); pInfo[playerid][pz] = floatstr( str );
SetPlayerPos( playerid, pInfo[playerid][*Myliu SuperGames.lt*], pInfo[playerid][py], pInfo[playerid][pz] +0.75 );
// Nustatom interjera
mysql_fetch_field_row( str, "Interjeras" ); pInfo[playerid][interjeras] = strval( str );
   SetPlayerInterior( playerid, pInfo[playerid][interjeras] );
   // Nustatom virtualu
mysql_fetch_field_row( str, "World" ); pInfo[playerid][world] = strval( str );
   SetPlayerVirtualWorld( playerid, pInfo[playerid][world] );
   // Nustatom gaudomumo lygi
mysql_fetch_field_row( str, "Gaudomas" ); pInfo[playerid][gaudomas] = strval( str );
   SetPlayerWantedLevel( playerid, pInfo[playerid][gaudomas] );
   // Nustatom pinigus kiseneje
   mysql_fetch_field_row( str, "Kiseneje" ); pInfo[playerid][pinigai] = strval( str );
   GivePlayerMoneyA( playerid, pInfo[playerid][pinigai] );
   // Nustatom zaidejo givybes
   mysql_fetch_field_row( str, "Hp" ); pInfo[playerid][hp] = strval( str );
   SetPlayerHealth( playerid, pInfo[playerid][hp] );
   // Nustatom zaidejo Armora
   mysql_fetch_field_row( str, "Armor" ); pInfo[playerid][armor] = strval( str );
   SetPlayerArmour( playerid, pInfo[playerid][armor] );
   mysql_fetch_field_row( str, "Banke" ); pInfo[playerid][bankas] = strval( str ); //Nustatom pinigus banke
   mysql_fetch_field_row( str, "Namuose" ); pInfo[playerid][namuose] = strval( str ); // Nustatom pinigus namuose
   mysql_fetch_field_row( str, "Biznis" ); pInfo[playerid][biznis] = strval( str ); // Nustatom biznio ID
   mysql_fetch_field_row( str, "Direktorius" ); pInfo[playerid][direktorius] = strval( str ); // Uzdedam direktoriu
   mysql_fetch_field_row( str, "Kalejime" ); pInfo[playerid][kalejime] = strval( str ); // Nustatom zaidejo laika kalejime
   mysql_fetch_field_row( str, "Darbas" ); pInfo[playerid][darbas] = strval( str ); // Uzdedam zaidejui darba
   mysql_fetch_field_row( str, "Drabuziai" ); pInfo[playerid][drabuziai] = strval( str ); // Nustatom zaidejo drabuzius
   mysql_fetch_field_row( str, "Apsirenges" ); pInfo[playerid][apsirenges] = strval( str ); // Nustatom ar zaidejas apsivilkes uniforma
   mysql_fetch_field_row( str, "Mobsas" ); pInfo[playerid][mobsas] = strval( str ); // Nustatom zaidejo tel. saskaita
   mysql_fetch_field_row( str, "Lytis" ); pInfo[playerid][lytis] = strval( str ); // Nustatom zaidejo lyti
   mysql_fetch_field_row( str, "Drugs" ); pInfo[playerid][drugs] = strval( str ); // Nustatom kiek turi zaidejas narkotiku
   mysql_fetch_field_row( str, "Teises" ); pInfo[playerid][teises1] = strval( str ); // Nustatom ar zaidejas turi teises
   mysql_fetch_field_row( str, "Masinu" ); pInfo[playerid][masinu] = strval( str ); // Nustatom ar zaidejas turi teises
   mysql_fetch_field_row( str, "Gaminama" ); pInfo[playerid][gaminama] = strval( str ); // Nustatom ar zaidejas turi teises
   mysql_fetch_field_row( str, "Admin" ); pInfo[playerid][admin] = strval( str ); // Nustatom admin lygi
   mysql_fetch_field_row( str, "Ispejimai" ); pInfo[playerid][ispejimai] = strval( str ); // Nustatom ispejimus
   mysql_fetch_field_row( str, "Uztildytas" ); pInfo[playerid][uztildytas] = strval( str ); // Nustatom ispejimus

   if ( pInfo[playerid][apsirenges] == 1 )
   {
    SetPlayerSkin( playerid, pInfo[playerid][uniforma] );
}else{
 SetPlayerSkin( playerid, pInfo[playerid][drabuziai] );
}
   //Ginklu uzkrovimas
   mysql_fetch_field_row( str, "G0" ); weps[ 0 ][ 0 ] = strval( str );
mysql_fetch_field_row( str, "A0" ); weps[ 1 ][ 0 ] = strval( str );
mysql_fetch_field_row( str, "G1" ); weps[ 0 ][ 1 ] = strval( str );
mysql_fetch_field_row( str, "A1" ); weps[ 1 ][ 1 ] = strval( str );
mysql_fetch_field_row( str, "G2" ); weps[ 0 ][ 2 ] = strval( str );
mysql_fetch_field_row( str, "A2" ); weps[ 1 ][ 2 ] = strval( str );
mysql_fetch_field_row( str, "G3" ); weps[ 0 ][ 3 ] = strval( str );
mysql_fetch_field_row( str, "A3" ); weps[ 1 ][ 3 ] = strval( str );
mysql_fetch_field_row( str, "G4" ); weps[ 0 ][ 4 ] = strval( str );
mysql_fetch_field_row( str, "A4" ); weps[ 1 ][ 4 ] = strval( str );
mysql_fetch_field_row( str, "G5" ); weps[ 0 ][ 5 ] = strval( str );
mysql_fetch_field_row( str, "A5" ); weps[ 1 ][ 5 ] = strval( str );
mysql_fetch_field_row( str, "G6" ); weps[ 0 ][ 6 ] = strval( str );
mysql_fetch_field_row( str, "A6" ); weps[ 1 ][ 6 ] = strval( str );
mysql_fetch_field_row( str, "G7" ); weps[ 0 ][ 7 ] = strval( str );
mysql_fetch_field_row( str, "A7" ); weps[ 1 ][ 7 ] = strval( str );
mysql_fetch_field_row( str, "G8" ); weps[ 0 ][ 8 ] = strval( str );
mysql_fetch_field_row( str, "A8" ); weps[ 1 ][ 8 ] = strval( str );
mysql_fetch_field_row( str, "G9" ); weps[ 0 ][ 9 ] = strval( str );
mysql_fetch_field_row( str, "A9" ); weps[ 1 ][ 9 ] = strval( str );
mysql_fetch_field_row( str, "G10" ); weps[ 0 ][ 10 ] = strval( str );
mysql_fetch_field_row( str, "A10" ); weps[ 1 ][ 10 ] = strval( str );
mysql_fetch_field_row( str, "G11" ); weps[ 0 ][ 11 ] = strval( str );
mysql_fetch_field_row( str, "A11" ); weps[ 1 ][ 11 ] = strval( str );
GivePlayerWeapon( playerid, weps[ 0 ][ 0 ], weps[ 1 ][ 0 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 1 ], weps[ 1 ][ 1 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 2 ], weps[ 1 ][ 2 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 3 ], weps[ 1 ][ 3 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 4 ], weps[ 1 ][ 4 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 5 ], weps[ 1 ][ 5 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 6 ], weps[ 1 ][ 6 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 7 ], weps[ 1 ][ 7 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 8 ], weps[ 1 ][ 8 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 9 ], weps[ 1 ][ 9 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 10 ], weps[ 1 ][ 10 ] );
GivePlayerWeapon( playerid, weps[ 0 ][ 11 ], weps[ 1 ][ 11 ] );
mysql_free_result(); // Isleidziam mysql
   if ( pInfo[playerid][kalejime] > 0 ) Ikalinti( playerid, pInfo[playerid][kalejime] );

format( query, 128, "UPDATE `zaidejai` SET \
 Prisijunges = 1 \
	 WHERE `id` = %i",
  pInfo[playerid][mysqlid] );
mysql_query( query );

   KraunamDarba( playerid );
}
stock SavePlayerData( playerid )
{
new
 query[ 256 ];

//GameTextForPlayer( playerid, "~r~] Saugojamas jusu zaidimas ]", 1000, 5 );

new weps[ 2 ][ 12 ]; //Isgaunam koordinates bei kita info

format( query, 256, "UPDATE `zaidejai` SET \
 Kiseneje = %d, \
 Banke = %d, \
 Namuose = %d, \
 Biznis = %d, \
 Gaudomas = %d, \
 Direktorius = %d, \
 Kalejime = %d, \
 Ispejimai = %d, \
 Uztildytas = %d \
  WHERE `id` = %d",
 GetPlayerMoneyA(playerid),
 pInfo[playerid][bankas],
 pInfo[playerid][namuose],
 pInfo[playerid][biznis],
 pInfo[playerid][gaudomas],
 pInfo[playerid][direktorius],
 pInfo[playerid][kalejime],
 pInfo[playerid][ispejimai],
 pInfo[playerid][uztildytas],
  pInfo[playerid][mysqlid] );
mysql_query( query );

for ( new tmp = 0; tmp < 12; tmp++ ) GetPlayerWeaponData( playerid, tmp,weps[ 0 ][ tmp ], weps[ 1 ][ tmp ] ); //Isgaunam ginklu informacija

format( query, 256, "UPDATE `zaidejai` SET \
 G0 = %d, A0 = %d, \
 G1 = %d, A1 = %d, \
 G2 = %d, A2 = %d, \
 G3 = %d, A3 = %d, \
 G4 = %d, A4 = %d, \
 G5 = %d, A5 = %d, \
 G6 = %d, A6 = %d, \
 G7 = %d, A7 = %d, \
 G8 = %d, A8 = %d, \
 G9 = %d, A9 = %d, \
 G10 = %d, A10 = %d, \
 G11 = %d, A11 = %d \
	 WHERE `id` = %d",
 weps[ 0 ][ 0 ], weps[ 1 ][ 0],
 weps[ 0 ][ 1 ], weps[ 1 ][ 1 ],
 weps[ 0 ][ 2 ], weps[ 1 ][ 2 ],
 weps[ 0 ][ 3 ], weps[ 1 ][ 3 ],
 weps[ 0 ][ 4 ], weps[ 1 ][ 4 ],
 weps[ 0 ][ 5 ], weps[ 1 ][ 5 ],
 weps[ 0 ][ 6 ], weps[ 1 ][ 6 ],
 weps[ 0 ][ 7 ], weps[ 1 ][ 7 ],
 weps[ 0 ][ 8 ], weps[ 1 ][ 8 ],
 weps[ 0 ][ 9 ], weps[ 1 ][ 9 ],
 weps[ 0 ][ 10 ], weps[ 1 ][ 10 ],
 weps[ 0 ][ 11 ], weps[ 1 ][ 11 ],
  pInfo[playerid][mysqlid] );
mysql_query( query );

format( query, 256, "UPDATE `zaidejai` SET \
 Drabuziai = %d, \
 Patirtis = %d, \
 Mobsas = %d, \
 Pastatas = %d, \
 Lytis = %d, \
 Drugs = %d, \
    Teises = %d, \
    Masinu = %d \
  Where `id` = %d",
 pInfo[playerid][drabuziai],
 pInfo[playerid][exp],
 pInfo[playerid][mobsas],
 pInfo[playerid][pastatas],
 pInfo[playerid][lytis],
 pInfo[playerid][drugs],
 pInfo[playerid][teises1],
 pInfo[playerid][masinu],
  pInfo[playerid][mysqlid] );
mysql_query( query );

GetPlayerPos( playerid, pInfo[playerid][*Myliu SuperGames.lt*], pInfo[playerid][py], pInfo[playerid][pz] );
GetPlayerHealth( playerid, pInfo[playerid][hp] );
GetPlayerArmour( playerid, pInfo[playerid][armor] );

format( query, 256, "UPDATE `zaidejai` SET \
 poz_X = %f, \
 poz_Y = %f, \
 poz_Z = %f, \
 Hp = %f, \
 Armor = %f, \
 Interjeras = %d, \
 Teises = %d, \
 World = %d \
	 WHERE `id` = %d",
 pInfo[playerid][*Myliu SuperGames.lt*],
 pInfo[playerid][py],
 pInfo[playerid][pz],
 pInfo[playerid][hp],
 pInfo[playerid][armor],
 GetPlayerInterior( playerid ),
 pInfo[playerid][teises1],
 GetPlayerVirtualWorld( playerid ),
  pInfo[playerid][mysqlid] );
mysql_query( query );

SaugomMasina( playerid );
Saugom2Masina( playerid );
SaugomDarba( playerid );

format( query, 128, "UPDATE `zaidejai` SET \
 Prisijunges = 0 \
	 WHERE `id` = %i",
  pInfo[playerid][mysqlid] );
mysql_query( query );

//GameTextForPlayer(playerid,"~r~] Jusu zaidimas issaugotas ]",1000,5);
}
stock KraunamDarba( playerid )
{
new
 vardas[ MAX_PLAYER_NAME ],
 str[ 64 ],
 query[ 256 ];
   GetPlayerName( playerid, vardas, sizeof vardas );

format( query, 256, "SELECT * FROM `zaidejai` WHERE `Vardas` = '%s'", vardas );
mysql_query( query );
mysql_store_result();
   mysql_fetch_row( query );

   mysql_fetch_field_row( str, "Darbas" ); pInfo[playerid][darbas] = strval( str );
   mysql_fetch_field_row( str, "Rangas" ); pInfo[playerid][rangas] = strval( str );
   mysql_fetch_field_row( str, "dIspejimai" ); pInfo[playerid][dIspejimai] = strval( str );

mysql_free_result ( );
}

stock SaugomDarba( playerid )
{
new
 vardas[ MAX_PLAYER_NAME ],
 query[ 256 ];
GetPlayerName( playerid, vardas, sizeof vardas );
format( query, 256, "UPDATE `zaidejai` SET \
 Darbas = %i, \
 Rangas = %i, \
 dIspejimai = %i \
  WHERE `Vardas` = '%s'",
 pInfo[playerid][darbas],
 pInfo[playerid][rangas],
 pInfo[playerid][dIspejimai],
    vardas );
mysql_query( query );
}

stock SaugomMasina( playerid )
{
new
 query[ 256 ];
format( query, 256, "UPDATE `masinos` SET \
 Masina = %i, \
 Dauzta = %i, \
 Dauzyta = %i, \
 Spalva1 = %i, \
 Spalva2 = %i, \
 Dazymas = %i, \
 Laikas = %i, \
 Numeriai = '%s' \
	 WHERE `id` = %i",
 NuosavaM[ playerid ][ modelis ],
 NuosavaM[ playerid ][ dauzta ],
 NuosavaM[ playerid ][ dauzyta ],
 NuosavaM[ playerid ][ spalva1 ],
 NuosavaM[ playerid ][ spalva2 ],
 NuosavaM[ playerid ][ dazymas ],
 NuosavaM[ playerid ][ laikas ],
 NuosavaM[ playerid ][ numeriai ],
  NuosavaM[ playerid ][ sqlID ] );
mysql_query( query );

if ( NuosavaM[ playerid ][ mID ] == -1 ) return;

new
 Float:coo[ 4 ],
 Float:mheal;

GetVehicleHealth( NuosavaM[ playerid ][ mID ], mheal );
GetVehiclePos( NuosavaM[ playerid ][ mID ], coo[ 0 ], coo[ 1 ], coo[ 2 ] );
GetVehicleZAngle( NuosavaM[ playerid ][ mID ], coo[ 3 ] );

format( query, 256, "UPDATE `masinos` SET \
 Health = %f, \
 Degalai = %i, \
 X = %f, \
 Y = %f, \
 Z = %f, \
 A = %f, \
 Uzrakinta = %i \
	 WHERE `id` = %i",
 mheal,
 vehicleDB[ NuosavaM[ playerid ][ mID ] ][ gas ],
 coo[ 0 ],
 coo[ 1 ],
 coo[ 2 ],
 coo[ 3 ],
 NuosavaM[ playerid ][ uzrakinta ],
  NuosavaM[ playerid ][ sqlID ] );
mysql_query( query );

format( query, 256, "UPDATE `masinos` SET \
 Mod0 = %i, \
 Mod1 = %i, \
 Mod2 = %i, \
 Mod3 = %i, \
 Mod4 = %i, \
 Mod5 = %i, \
 Mod6 = %i, \
 Mod7 = %i \
	 WHERE `id` = %i",
    GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 0 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 1 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 2 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 3 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 4 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 5 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 6 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 7 ),
  NuosavaM[ playerid ][ sqlID ] );
mysql_query( query );

format( query, 256, "UPDATE `masinos` SET \
 Mod8 = %i, \
 Mod9 = %i, \
 Mod10 = %i, \
 Mod11 = %i, \
 Mod12 = %i, \
 Mod13 = %i, \
 Rida = %f \
	 WHERE `id` = %i",
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 8 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 9 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 10 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 11 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 12 ),
 GetVehicleComponentInSlot( NuosavaM[ playerid ][ mID ], 13 ),
 vehicleDB[ NuosavaM[ playerid ][ mID ] ][ rida ],
  NuosavaM[ playerid ][ sqlID ] );
mysql_query( query );

DestroyVehicle( NuosavaM[ playerid ][ mID ] );
}
stock Saugom2Masina( playerid )
{
new
 query[ 256 ];
format( query, 256, "UPDATE `2masinos` SET \
 Masina = %i, \
 Dauzta = %i, \
 Dauzyta = %i, \
 Spalva1 = %i, \
 Spalva2 = %i, \
 Dazymas = %i, \
 Laikas = %i, \
 Numeriai = '%s' \
	 WHERE `id` = %i",
 NuosavaM2[ playerid ][ modelis ],
 NuosavaM2[ playerid ][ dauzta ],
 NuosavaM2[ playerid ][ dauzyta ],
 NuosavaM2[ playerid ][ spalva1 ],
 NuosavaM2[ playerid ][ spalva2 ],
 NuosavaM2[ playerid ][ dazymas ],
 NuosavaM2[ playerid ][ laikas ],
 NuosavaM2[ playerid ][ numeriai ],
  NuosavaM2[ playerid ][ sqlID ] );
mysql_query( query );

if ( NuosavaM2[ playerid ][ mID ] == -1 ) return;
new
 Float:coo[ 4 ],
 Float:mheal;
GetVehicleHealth( NuosavaM2[ playerid ][ mID ], mheal );
GetVehiclePos( NuosavaM2[ playerid ][ mID ], coo[ 0 ], coo[ 1 ], coo[ 2 ] );
GetVehicleZAngle( NuosavaM2[ playerid ][ mID ], coo[ 3 ] );
format( query, 256, "UPDATE `2masinos` SET \
 Health = %f, \
 Degalai = %i, \
 X = %f, \
 Y = %f, \
 Z = %f, \
 A = %f, \
 Uzrakinta = %i \
	 WHERE `id` = %i",
 mheal,
 vehicleDB[ NuosavaM2[ playerid ][ mID ] ][ gas ],
 coo[ 0 ],
 coo[ 1 ],
 coo[ 2 ],
 coo[ 3 ],
 NuosavaM2[ playerid ][ uzrakinta ],
  NuosavaM2[ playerid ][ sqlID ] );
mysql_query( query );
format( query, 256, "UPDATE `2masinos` SET \
 Mod0 = %i, \
 Mod1 = %i, \
 Mod2 = %i, \
 Mod3 = %i, \
 Mod4 = %i, \
 Mod5 = %i, \
 Mod6 = %i, \
 Mod7 = %i \
	 WHERE `id` = %i",
    GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 0 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 1 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 2 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 3 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 4 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 5 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 6 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 7 ),
  NuosavaM2[ playerid ][ sqlID ] );
mysql_query( query );
format( query, 256, "UPDATE `2masinos` SET \
 Mod8 = %i, \
 Mod9 = %i, \
 Mod10 = %i, \
 Mod11 = %i, \
 Mod12 = %i, \
 Mod13 = %i, \
 Rida = %f \
	 WHERE `id` = %i",
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 8 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 9 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 10 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 11 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 12 ),
 GetVehicleComponentInSlot( NuosavaM2[ playerid ][ mID ], 13 ),
 vehicleDB[ NuosavaM2[ playerid ][ mID ] ][ rida ],
  NuosavaM2[ playerid ][ sqlID ] );
mysql_query( query );
DestroyVehicle( NuosavaM2[ playerid ][ mID ] );
}
stock KraunamMasina( playerid )
{
new query[ 256 ], str[ 32 ], name[30];
GetPlayerName(playerid, name, sizeof(name));
format( query, 256, "SELECT * FROM `masinos` WHERE `Savininkas` = '%s'", name );
mysql_query( query );
mysql_store_result();
mysql_fetch_row( query );

mysql_fetch_field_row( str, "id" ); NuosavaM[ playerid ][ sqlID ] = strval( str );
mysql_fetch_field_row( str, "Savininkas" ); format( NuosavaM[ playerid ][ savininkas ], MAX_PLAYER_NAME, "%s", str );
mysql_fetch_field_row( str, "Masina" ); NuosavaM[ playerid ][ modelis ] = strval( str );
   mysql_fetch_field_row( str, "Pagaminta" ); NuosavaM[ playerid ][ pagaminta ] = strval( str );
mysql_fetch_field_row( str, "Dauzta" ); NuosavaM[ playerid ][ dauzta ] = strval( str );
mysql_fetch_field_row( str, "Dauzyta" ); NuosavaM[ playerid ][ dauzyta ] = strval( str );
mysql_fetch_field_row( str, "Spalva1" ); NuosavaM[ playerid ][ spalva1 ] = strval( str );
mysql_fetch_field_row( str, "Spalva2" ); NuosavaM[ playerid ][ spalva2 ] = strval( str );
mysql_fetch_field_row( str, "Dazymas" ); NuosavaM[ playerid ][ dazymas ] = strval( str );
mysql_fetch_field_row( str, "Numeriai" ); format( NuosavaM[ playerid ][ numeriai ], 10, "%s", str );
mysql_fetch_field_row( str, "Uzrakinta" ); NuosavaM[ playerid ][ uzrakinta ] = strval( str );
mysql_fetch_field_row( str, "Signalizacija" ); NuosavaM[ playerid ][ signalizacija ] = strval( str );
mysql_fetch_field_row( str, "Health" ); NuosavaM[ playerid ][ vheal ] = strval( str );
mysql_fetch_field_row( str, "Degalai" ); NuosavaM[ playerid ][ degalai ] = strval( str );
   mysql_fetch_field_row( str, "X" ); NuosavaM[ playerid ][ v_X ] = floatstr( str );
   mysql_fetch_field_row( str, "Y" ); NuosavaM[ playerid ][ v_Y ] = floatstr( str );
   mysql_fetch_field_row( str, "Z" ); NuosavaM[ playerid ][ v_Z ] = floatstr( str );
   mysql_fetch_field_row( str, "A" ); NuosavaM[ playerid ][ v_A ] = floatstr( str );
mysql_fetch_field_row( str, "Mod0" ); NuosavaM[ playerid ][ mod0 ] = strval( str );
mysql_fetch_field_row( str, "Mod1" ); NuosavaM[ playerid ][ mod1 ] = strval( str );
mysql_fetch_field_row( str, "Mod2" ); NuosavaM[ playerid ][ mod2 ] = strval( str );
mysql_fetch_field_row( str, "Mod3" ); NuosavaM[ playerid ][ mod3 ] = strval( str );
mysql_fetch_field_row( str, "Mod4" ); NuosavaM[ playerid ][ mod4 ] = strval( str );
mysql_fetch_field_row( str, "Mod5" ); NuosavaM[ playerid ][ mod5 ] = strval( str );
mysql_fetch_field_row( str, "Mod6" ); NuosavaM[ playerid ][ mod6 ] = strval( str );
mysql_fetch_field_row( str, "Mod7" ); NuosavaM[ playerid ][ mod7 ] = strval( str );
mysql_fetch_field_row( str, "Mod8" ); NuosavaM[ playerid ][ mod8 ] = strval( str );
mysql_fetch_field_row( str, "Mod9" ); NuosavaM[ playerid ][ mod9 ] = strval( str );
mysql_fetch_field_row( str, "Mod10" ); NuosavaM[ playerid ][ mod10 ] = strval( str );
mysql_fetch_field_row( str, "Mod11" ); NuosavaM[ playerid ][ mod11 ] = strval( str );
mysql_fetch_field_row( str, "Mod12" ); NuosavaM[ playerid ][ mod12 ] = strval( str );
mysql_fetch_field_row( str, "Mod13" ); NuosavaM[ playerid ][ mod13 ] = strval( str );
mysql_fetch_field_row( str, "Laikas" ); NuosavaM[ playerid ][ laikas ] = strval( str );
   mysql_fetch_field_row( str, "Rida" ); NuosavaM[ playerid ][ rida ] = floatstr( str );
mysql_free_result(); // Isleidziam mysql

if(NuosavaM[playerid][pagaminta] == 1){ NuosavaM[ playerid ][ servID ] = SukuriamMasina( playerid ); }
}
stock Kraunam2Masina( playerid )
{
new query[ 256 ], str[ 32 ], name[30];
format( query, 256, "SELECT * FROM `masinos2` WHERE `Savininkas` = '%s'", name );
mysql_query( query );
mysql_store_result();
mysql_fetch_row( query );
mysql_fetch_field_row( str, "id" ); NuosavaM2[ playerid ][ sqlID ] = strval( str );
mysql_fetch_field_row( str, "Masina" ); NuosavaM2[ playerid ][ modelis ] = strval( str );
   mysql_fetch_field_row( str, "Pagaminta" ); NuosavaM2[ playerid ][ pagaminta ] = strval( str );
mysql_fetch_field_row( str, "Dauzta" ); NuosavaM2[ playerid ][ dauzta ] = strval( str );
mysql_fetch_field_row( str, "Dauzyta" ); NuosavaM2[ playerid ][ dauzyta ] = strval( str );
mysql_fetch_field_row( str, "Spalva1" ); NuosavaM2[ playerid ][ spalva1 ] = strval( str );
mysql_fetch_field_row( str, "Spalva2" ); NuosavaM2[ playerid ][ spalva2 ] = strval( str );
mysql_fetch_field_row( str, "Dazymas" ); NuosavaM2[ playerid ][ dazymas ] = strval( str );
mysql_fetch_field_row( str, "Numeriai" ); format( NuosavaM2[ playerid ][ numeriai ], 10, "%s", str );
mysql_fetch_field_row( str, "Uzrakinta" ); NuosavaM2[ playerid ][ uzrakinta ] = strval( str );
mysql_fetch_field_row( str, "Signalizacija" ); NuosavaM2[ playerid ][ signalizacija ] = strval( str );
mysql_fetch_field_row( str, "Health" ); NuosavaM2[ playerid ][ vheal ] = strval( str );
mysql_fetch_field_row( str, "Degalai" ); NuosavaM2[ playerid ][ degalai ] = strval( str );
   mysql_fetch_field_row( str, "X" ); NuosavaM2[ playerid ][ v_X ] = floatstr( str );
   mysql_fetch_field_row( str, "Y" ); NuosavaM2[ playerid ][ v_Y ] = floatstr( str );
   mysql_fetch_field_row( str, "Z" ); NuosavaM2[ playerid ][ v_Z ] = floatstr( str );
   mysql_fetch_field_row( str, "A" ); NuosavaM2[ playerid ][ v_A ] = floatstr( str );
mysql_fetch_field_row( str, "Mod0" ); NuosavaM2[ playerid ][ mod0 ] = strval( str );
mysql_fetch_field_row( str, "Mod1" ); NuosavaM2[ playerid ][ mod1 ] = strval( str );
mysql_fetch_field_row( str, "Mod2" ); NuosavaM2[ playerid ][ mod2 ] = strval( str );
mysql_fetch_field_row( str, "Mod3" ); NuosavaM2[ playerid ][ mod3 ] = strval( str );
mysql_fetch_field_row( str, "Mod4" ); NuosavaM2[ playerid ][ mod4 ] = strval( str );
mysql_fetch_field_row( str, "Mod5" ); NuosavaM2[ playerid ][ mod5 ] = strval( str );
mysql_fetch_field_row( str, "Mod6" ); NuosavaM2[ playerid ][ mod6 ] = strval( str );
mysql_fetch_field_row( str, "Mod7" ); NuosavaM2[ playerid ][ mod7 ] = strval( str );
mysql_fetch_field_row( str, "Mod8" ); NuosavaM2[ playerid ][ mod8 ] = strval( str );
mysql_fetch_field_row( str, "Mod9" ); NuosavaM2[ playerid ][ mod9 ] = strval( str );
mysql_fetch_field_row( str, "Mod10" ); NuosavaM2[ playerid ][ mod10 ] = strval( str );
mysql_fetch_field_row( str, "Mod11" ); NuosavaM2[ playerid ][ mod11 ] = strval( str );
mysql_fetch_field_row( str, "Mod12" ); NuosavaM2[ playerid ][ mod12 ] = strval( str );
mysql_fetch_field_row( str, "Mod13" ); NuosavaM2[ playerid ][ mod13 ] = strval( str );
mysql_fetch_field_row( str, "Laikas" ); NuosavaM2[ playerid ][ laikas ] = strval( str );
mysql_fetch_field_row( str, "Rida" ); NuosavaM2[ playerid ][ rida ] = floatstr( str );
mysql_free_result(); // Isleidziam mysql
if(NuosavaM[playerid][pagaminta] == 1){ NuosavaM2[ playerid ][ servID ] = Sukuriam2Masina( playerid ); }
}
stock ZaidejoPrijungimas(playerid)
{
Clear( playerid );
new
 query[ 128 ],
  vardas[ MAX_PLAYER_NAME ];

   GetPlayerName( playerid, vardas, sizeof( vardas ) );

   format( query, sizeof( query ), "SELECT `id` FROM `zaidejai` WHERE `Vardas` = '%s'", vardas );
mysql_query( query );
mysql_store_result();

if( mysql_num_rows() >= 1 )
{
 if( mysql_num_rows() >= 2 )
 {
  mysql_free_result();
  SendClientMessage(playerid, WHITE, "MYSQL duombazeje rasti du tokie pat charakteriai, prasome susisiekti su administracija.");
  Kick(playerid);
 }else{
  pInfo[playerid][mysqlid] = mysql_fetch_int();
  mysql_free_result();

  format( query, sizeof( query ), "SELECT `id` FROM `vehicles` WHERE `savininkas` = '%s' AND `nuosava` = 1", vardas );
  mysql_query( query );
  mysql_store_result();

// masina nr1
/*   if ( mysql_num_rows() >= 1)
  {
   new vid = mysql_fetch_int() - 1;
   vehicleDB[ vid ][ sqlID ] = vid+1;
   vehicleDB[ vid ][ savininkas ] = vardas;
   mysql_free_result();

  }else{
   format( query, sizeof( query ), "INSERT INTO `vehicles` (`savininkas`,`nuosava`) VALUES ('%s',1)", vardas );
   mysql_query( query );
   new vid = mysql_insert_id() - 1;
   vehicleDB[ vid ][ sqlID ] = vid+1;
   vehicleDB[ vid ][ savininkas ] = vardas;
   mysql_free_result();
  }

  format( query, sizeof( query ), "SELECT `id` FROM `vehicles` WHERE `savininkas` = '%s' AND `nuosava` = 2", vardas );
  mysql_query( query );
  mysql_store_result();

   new msg[50];
   format( msg,sizeof(msg),"rado: %d", mysql_num_rows());
   SendClientMessage(playerid,COLOR,msg);
// masina nr2
  if ( mysql_num_rows() >= 1 )
  {
   new vid = mysql_fetch_int() - 1;
   vehicleDB[ vid ][ sqlID ] = vid+1;
   vehicleDB[ vid ][ savininkas ] = vardas;
   mysql_free_result();
  }else{
   format( query, sizeof( query ), "INSERT INTO `vehicles` (`savininkas`,`nuosava`) VALUES ('%s',2)", vardas );
   mysql_query( query );
   new vid = mysql_insert_id() - 1;
   vehicleDB[ vid ][ sqlID ] = vid+1;
   vehicleDB[ vid ][ savininkas ] = vardas;
   mysql_free_result();
  }*/

  new
   name[ MAX_PLAYER_NAME ],
   login[ 128 ];

  GetPlayerName( playerid, name, sizeof( name ) );
  format( login, sizeof( login ), "\t{0062FF}Sveiki suize i LRG.LT serveri!\n\n\t{FFFFFF}Zaideja/-s: {FF0000}%s\n\n\t{00B100}Prasome ivesti savo slaptazodi:", name );
  ShowPlayerDialog( playerid, 1, DIALOG_STYLE_INPUT, "{FF484B}LRG.LT prisijungimas", login, "Prisijungti", "Atsijungti" );
 }
}else{
 mysql_free_result();
  new
   name[ MAX_PLAYER_NAME ],
   reg[ 200 ];
  GetPlayerName( playerid, name, sizeof( name ) );
  format( reg, sizeof( reg ), "\t{0062FF}Sveiki atvyke i LRG.LT serveri!\n\n\t{FFFFFF}Zaideja/-s: {FF0000}%s\n\n\t{00B100}Jusu vartotojas neregistruotas,\n\tprasome prisiregistruoti puslapyje:\n\t\t{D40000}LRG.LT", name );

 ShowPlayerDialog( playerid, 0, DIALOG_STYLE_MSGBOX, "{FF484B}LRG.LT registracija", reg, "Iseiti", "" );
 Kick( playerid );
}
}