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

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

Pagalbos su mysql

^Rokas

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

 Pasidalinti

Ši tema yra neaktyvi. Paskutinis pranešimas šioje temoje buvo prieš 3032 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

^Rokas Dažnas dalyvis (-ė)

^Rokas

Sveiki, kodėl neišseivina lbano priežasties?: 

	CMD:lban(playerid, params[])
{
    if(playerData[playerid][admin] < 2) return SendClientMessage(playerid, -1, "{ffffff}Tokios komandos nera. Visos komandos {FF0000}/pagalba");
    new pID, laikas, prz[50],uQuerry[400],msg[125];
    if(sscanf(params, "uds[50]", pID, laikas, prz)) return SendClientMessage(playerid, BLUE, "* Uþbaninti þaidëjà laikui: /lban [Vardas_Pavardë/ID] [Laikas] [Prieþastis]");
    if(laikas < 1 || laikas > 9999) return SendClientMessage(playerid, BLUE, "* Uþbaninti þaidëjà laikui: /lban [Vardas_Pavardë/ID] [Laikas (1-9999 valandø)] [Prieþastis]");
    if(pID == INVALID_PLAYER_ID) return SendClientMessage(playerid, RED, "* Tokio þaidëjo nëra");
    if(playerData[pID][BanLaikas] > gettime()) return SendClientMessage(playerid, RED, "* Þaidëjas jau uþbanintas.");
    playerData[pID][BanLaikas] = gettime() + (laikas * 60);
    MySQL_Save(pID);
    new BanoLaikas = playerData[pID][BanLaikas];
    format(msg, sizeof(msg), "* [LBAN] %s uþblokavo %s serveryje dël (%s) (%s).", GetPlayerNameEx(playerid), GetPlayerNameEx(pID),prz, ConvertSeconds(BanoLaikas - gettime()));
    SendClientMessageToAll(YELLOW, msg);
    format(uQuerry, 150, "UPDATE `zaidejai` SET `BanoPriezastis` = '%s' WHERE `vardas` = '%s'",prz,GetPlayerNameEx(pID));
    mysql_query(uQuerry);
    SetTimerEx("KickEx", 100, false, "d", pID);
    return 1;
}

Jei padarau taip(visi gauna ta priežasti išskyrus tas kuris užbanintas lbanu): 

	format(uQuerry, 150, "UPDATE `zaidejai` SET `BanoPriezastis` = '%s', WHERE `BanoPriezastis` = ''%s'", prz,prz);
   mysql_query(uQuerry);

^Rokas Dažnas dalyvis (-ė)

^Rokas

  • Autorius
prieš 13 valandas(-ų), GamerX parašė:

Nepagavau minties, bet gal  


WHERE `BanoPriezastis` = ''%s'"

vietoj čia daryk where playerid = %s?

Kadangi pagal šitą kodą tau visų žaidėjų priežastis pakeis į naują.

Esme, kad turi saugoti to zaidejo kuri uzbanino priezasti uz ka jis gavo bana, o man arba neissaugo, arba jei padarau kitaip, duoda visiems tapacia priezasti, o tas kuris uzbanintas negauna priezasties bano

^Rokas Dažnas dalyvis (-ė)

^Rokas

  • Autorius
prieš 4 valandas(-ų), Funkis parašė:

Mysql log kur? 

	[19:43:53]  
[19:43:53] ---------------------------
[19:43:53] MySQL Debugging activated (03/29/18)
[19:43:53] ---------------------------
[19:43:53]  
[19:43:53] >> mysql_connect( )
[19:43:53] CMySQLHandler::CMySQLHandler() - constructor called.
[19:43:53] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "zaidejai" | Username: "root" ...
[19:43:53] CMySQLHandler::Connect() - Connection was successful.
[19:43:53] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[19:43:53] >> mysql_ping( Connection handle: 1 )
[19:43:53] CMySQLHandler::Ping() - Connection is still alive.
[19:44:27] >> mysql_query( Connection handle: 1 )
[19:44:27] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Rokas') - Successfully executed.
[19:44:27] >> mysql_store_result( Connection handle: 1 )
[19:44:27] CMySQLHandler::StoreResult() - Result was stored.
[19:44:27] >> mysql_retrieve_row( Connection handle: 1 )
[19:44:27] >> mysql_num_rows( Connection handle: 1 )
[19:44:27] CMySQLHandler::NumRows() - Returned 0 row(s)
[19:44:27] >> mysql_free_result( Connection handle: 1 )
[19:44:27] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:44:27] >> mysql_query( Connection handle: 1 )
[19:44:27] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Rokas') - Successfully executed.
[19:44:27] >> mysql_store_result( Connection handle: 1 )
[19:44:27] CMySQLHandler::StoreResult() - Result was stored.
[19:44:27] >> mysql_num_rows( Connection handle: 1 )
[19:44:27] CMySQLHandler::NumRows() - Returned 0 row(s)
[19:44:27] >> mysql_free_result( Connection handle: 1 )
[19:44:27] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:44:30] >> mysql_real_escape_string( Connection handle: 1 )
[19:44:30] CMySQLHandler::EscapeString(1234); - Escaped 4 characters to 1234.
[19:44:30] >> mysql_query( Connection handle: 1 )
[19:44:30] CMySQLHandler::Query(INSERT INTO `zaidejai` (vardas,slaptazodis) VALUES ('Rokas','1234')) - Successfully executed.
[19:44:45] >> mysql_query( Connection handle: 1 )
[19:44:45] CMySQLHandler::Query(UPDATE `zaidejai` SET x = '133.005386', y = '-68.738273', z = '1.578125' WHERE vardas = 'Rokas') - Successfully executed.
[19:44:45] >> mysql_query( Connection handle: 1 )
[19:44:46] CMySQLHandler::Query(UPDATE `zaidejai` SET skin = '79', pinigai = '0', patirtis = '0' WHERE vardas = 'Rokas') - Successfully executed.
[19:44:46] >> mysql_query( Connection handle: 1 )
[19:44:46] CMySQLHandler::Query(UPDATE `zaidejai` SET `lytis` = '1' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:44:46] >> mysql_query( Connection handle: 1 )
[19:44:46] CMySQLHandler::Query(UPDATE `zaidejai` SET `alkis` = '100' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:44:46] >> mysql_query( Connection handle: 1 )
[19:44:46] CMySQLHandler::Query(UPDATE `zaidejai` SET `Vip` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:44:46] >> mysql_query( Connection handle: 1 )
[19:44:46] CMySQLHandler::Query(UPDATE `zaidejai` SET `Admin` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:44:46] >> mysql_query( Connection handle: 1 )
[19:44:46] CMySQLHandler::Query(UPDATE `zaidejai` SET `BanLaikas` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:44:46] >> mysql_query( Connection handle: 1 )
[19:44:46] CMySQLHandler::Query(UPDATE `zaidejai` SET `Uzbanintas` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:44:46] >> mysql_query( Connection handle: 1 )
[19:44:46] CMySQLHandler::Query(UPDATE `zaidejai` SET `BanoPriezastis` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:44:46] >> mysql_query( Connection handle: 1 )
[19:44:46] CMySQLHandler::Query(UPDATE zaidejai SET Ginklas0 = 0, Ammo0 = 0, Ginklas1 = 0, Ammo1 = 0, Ginklas2 = 0, Ammo2 = 0, Ginklas3 = 0, Ammo3 = 0, Ginklas4 = 0, Ammo4 = 0, Ginklas5 = 0, Ammo5 = 0, Ginklas6 = 0, Ammo6 = 0, Ginklas7 = 0, Ammo7 = 0, Ginklas8 = 0, Ammo8 = 0, Ginklas9 = 0, Ammo9 = 0, Ginklas10 = 0, Ammo10 = 0, Ginklas11 = 0, Ammo11 = 0 WHERE vardas = 'Rokas') - Successfully executed.
[19:44:46] >> mysql_query( Connection handle: 1 )
[19:44:46] CMySQLHandler::Query(UPDATE `zaidejai` SET hp = '100.000000', armour = '0.000000' WHERE vardas = 'Rokas') - Successfully executed.
[19:45:59] >> mysql_query( Connection handle: 1 )
[19:45:59] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Rokas') - Successfully executed.
[19:45:59] >> mysql_store_result( Connection handle: 1 )
[19:45:59] CMySQLHandler::StoreResult() - Result was stored.
[19:45:59] >> mysql_retrieve_row( Connection handle: 1 )
[19:45:59] >> mysql_num_rows( Connection handle: 1 )
[19:45:59] CMySQLHandler::NumRows() - Returned 1 row(s)
[19:45:59] >> mysql_fetch_field_row( Connection handle: 1 )
[19:45:59] CMySQLHandler::FetchField("Uzbanintas") - 0
[19:45:59] >> mysql_fetch_field_row( Connection handle: 1 )
[19:45:59] CMySQLHandler::FetchField("BanLaikas") - 0
[19:45:59] >> mysql_fetch_field_row( Connection handle: 1 )
[19:45:59] CMySQLHandler::FetchField("ID") -
[19:45:59] >> mysql_fetch_field_row( Connection handle: 1 )
[19:45:59] CMySQLHandler::FetchField("BanoPriezastis") - 0
[19:45:59] >> mysql_free_result( Connection handle: 1 )
[19:45:59] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:45:59] >> mysql_query( Connection handle: 1 )
[19:45:59] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Rokas') - Successfully executed.
[19:45:59] >> mysql_store_result( Connection handle: 1 )
[19:45:59] CMySQLHandler::StoreResult() - Result was stored.
[19:45:59] >> mysql_num_rows( Connection handle: 1 )
[19:45:59] CMySQLHandler::NumRows() - Returned 1 row(s)
[19:46:00] >> mysql_free_result( Connection handle: 1 )
[19:46:00] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:46:01] >> mysql_real_escape_string( Connection handle: 1 )
[19:46:01] CMySQLHandler::EscapeString(1234); - Escaped 4 characters to 1234.
[19:46:01] >> mysql_query( Connection handle: 1 )
[19:46:01] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Rokas' AND slaptazodis = '1234') - Successfully executed.
[19:46:01] >> mysql_store_result( Connection handle: 1 )
[19:46:01] CMySQLHandler::StoreResult() - Result was stored.
[19:46:01] >> mysql_num_rows( Connection handle: 1 )
[19:46:01] CMySQLHandler::NumRows() - Returned 1 row(s)
[19:46:03] >> mysql_query( Connection handle: 1 )
[19:46:03] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Rokas') - Successfully executed.
[19:46:03] >> mysql_store_result( Connection handle: 1 )
[19:46:03] CMySQLHandler::StoreResult() - Result was stored.
[19:46:03] >> mysql_retrieve_row( Connection handle: 1 )
[19:46:03] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:03] CMySQLHandler::FetchField("x") - 133.005386
[19:46:03] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:03] CMySQLHandler::FetchField("y") - -68.738273
[19:46:03] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:03] CMySQLHandler::FetchField("z") - 1.578125
[19:46:03] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:04] CMySQLHandler::FetchField("skin") - 79
[19:46:04] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:04] CMySQLHandler::FetchField("pinigai") - 0
[19:46:04] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:04] CMySQLHandler::FetchField("patirtis") - 0
[19:46:04] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:04] CMySQLHandler::FetchField("lytis") - 1
[19:46:04] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:04] CMySQLHandler::FetchField("alkis") - 100
[19:46:04] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:04] CMySQLHandler::FetchField("Vip") - 0
[19:46:04] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Admin") - 3
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("BanLaikas") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Uzbanintas") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("BanoPriezastis") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ginklas0") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ammo0") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ginklas1") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ammo1") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ginklas2") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ammo2") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ginklas3") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ammo3") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ginklas4") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ammo4") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ginklas5") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ammo5") - 0
[19:46:05] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:05] CMySQLHandler::FetchField("Ginklas6") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ammo6") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ginklas7") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ammo7") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ginklas8") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ammo8") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ginklas9") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ammo9") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ginklas10") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ammo10") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ginklas11") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("Ammo11") - 0
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("hp") - 100
[19:46:06] >> mysql_fetch_field_row( Connection handle: 1 )
[19:46:06] CMySQLHandler::FetchField("armour") - 0
[19:46:06] >> mysql_free_result( Connection handle: 1 )
[19:46:06] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:46:17] >> mysql_query( Connection handle: 1 )
[19:46:17] CMySQLHandler::Query(UPDATE `zaidejai` SET x = '130.786163', y = '-71.253128', z = '1.578125' WHERE vardas = 'Rokas') - Successfully executed.
[19:46:17] >> mysql_query( Connection handle: 1 )
[19:46:17] CMySQLHandler::Query(UPDATE `zaidejai` SET skin = '79', pinigai = '0', patirtis = '0' WHERE vardas = 'Rokas') - Successfully executed.
[19:46:17] >> mysql_query( Connection handle: 1 )
[19:46:17] CMySQLHandler::Query(UPDATE `zaidejai` SET `lytis` = '1' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:17] >> mysql_query( Connection handle: 1 )
[19:46:17] CMySQLHandler::Query(UPDATE `zaidejai` SET `alkis` = '100' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:17] >> mysql_query( Connection handle: 1 )
[19:46:17] CMySQLHandler::Query(UPDATE `zaidejai` SET `troskulys` = '100' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:17] >> mysql_query( Connection handle: 1 )
[19:46:17] CMySQLHandler::Query(UPDATE `zaidejai` SET `myzalas` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:17] >> mysql_query( Connection handle: 1 )
[19:46:17] CMySQLHandler::Query(UPDATE `zaidejai` SET `Vip` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:17] >> mysql_query( Connection handle: 1 )
[19:46:17] CMySQLHandler::Query(UPDATE `zaidejai` SET `Admin` = '3' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:17] >> mysql_query( Connection handle: 1 )
[19:46:17] CMySQLHandler::Query(UPDATE `zaidejai` SET `BanLaikas` = '1522342277' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:17] >> mysql_query( Connection handle: 1 )
[19:46:18] CMySQLHandler::Query(UPDATE `zaidejai` SET `Uzbanintas` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:18] >> mysql_query( Connection handle: 1 )
[19:46:18] CMySQLHandler::Query(UPDATE `zaidejai` SET `BanoPriezastis` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:18] >> mysql_query( Connection handle: 1 )
[19:46:18] CMySQLHandler::Query(UPDATE zaidejai SET Ginklas0 = 0, Ammo0 = 0, Ginklas1 = 0, Ammo1 = 0, Ginklas2 = 0, Ammo2 = 0, Ginklas3 = 0, Ammo3 = 0, Ginklas4 = 0, Ammo4 = 0, Ginklas5 = 0, Ammo5 = 0, Ginklas6 = 0, Ammo6 = 0, Ginklas7 = 0, Ammo7 = 0, Ginklas8 = 0, Ammo8 = 0, Ginklas9 = 0, Ammo9 = 0, Ginklas10 = 0, Ammo10 = 0, Ginklas11 = 0, Ammo11 = 0 WHERE vardas = 'Rokas') - Successfully executed.
[19:46:18] >> mysql_query( Connection handle: 1 )
[19:46:18] CMySQLHandler::Query(UPDATE `zaidejai` SET hp = '100.000000', armour = '0.000000' WHERE vardas = 'Rokas') - Successfully executed.
[19:46:18] >> mysql_query( Connection handle: 1 )
[19:46:18] CMySQLHandler::Query(UPDATE `zaidejai` SET `BanoPriezastis` = 'cheat' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:18] >> mysql_query( Connection handle: 1 )
[19:46:18] CMySQLHandler::Query(UPDATE `zaidejai` SET x = '130.786163', y = '-71.253128', z = '1.578125' WHERE vardas = 'Rokas') - Successfully executed.
[19:46:18] >> mysql_query( Connection handle: 1 )
[19:46:18] CMySQLHandler::Query(UPDATE `zaidejai` SET skin = '79', pinigai = '0', patirtis = '0' WHERE vardas = 'Rokas') - Successfully executed.
[19:46:19] >> mysql_query( Connection handle: 1 )
[19:46:19] CMySQLHandler::Query(UPDATE `zaidejai` SET `lytis` = '1' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:19] >> mysql_query( Connection handle: 1 )
[19:46:19] CMySQLHandler::Query(UPDATE `zaidejai` SET `alkis` = '100' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:19] >> mysql_query( Connection handle: 1 )
[19:46:19] CMySQLHandler::Query(UPDATE `zaidejai` SET `Vip` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:19] >> mysql_query( Connection handle: 1 )
[19:46:19] CMySQLHandler::Query(UPDATE `zaidejai` SET `Admin` = '3' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:19] >> mysql_query( Connection handle: 1 )
[19:46:19] CMySQLHandler::Query(UPDATE `zaidejai` SET `BanLaikas` = '1522342277' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:19] >> mysql_query( Connection handle: 1 )
[19:46:19] CMySQLHandler::Query(UPDATE `zaidejai` SET `Uzbanintas` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:19] >> mysql_query( Connection handle: 1 )
[19:46:20] CMySQLHandler::Query(UPDATE `zaidejai` SET `BanoPriezastis` = '0' WHERE `vardas` = 'Rokas') - Successfully executed.
[19:46:20] >> mysql_query( Connection handle: 1 )
[19:46:20] CMySQLHandler::Query(UPDATE zaidejai SET Ginklas0 = 0, Ammo0 = 0, Ginklas1 = 0, Ammo1 = 0, Ginklas2 = 0, Ammo2 = 0, Ginklas3 = 0, Ammo3 = 0, Ginklas4 = 0, Ammo4 = 0, Ginklas5 = 0, Ammo5 = 0, Ginklas6 = 0, Ammo6 = 0, Ginklas7 = 0, Ammo7 = 0, Ginklas8 = 0, Ammo8 = 0, Ginklas9 = 0, Ammo9 = 0, Ginklas10 = 0, Ammo10 = 0, Ginklas11 = 0, Ammo11 = 0 WHERE vardas = 'Rokas') - Successfully executed.
[19:46:20] >> mysql_query( Connection handle: 1 )
[19:46:20] CMySQLHandler::Query(UPDATE `zaidejai` SET hp = '100.000000', armour = '0.000000' WHERE vardas = 'Rokas') - Successfully executed.
 

 

sitie gal ?:D

^Rokas Dažnas dalyvis (-ė)

^Rokas

  • Autorius
(redaguota)
prieš 16 valandas(-ų), mariusqw parašė: 

format(uQuerry, 150, "UPDATE `zaidejai` SET `BanoPriezastis` = '%s', WHERE vardas = '%s'",prz, GetPlayerName(playerid));
mysql_query(uQuerry);

 

Tai kad ta pati padares kas ir pas mane :D

edit: susitvarkiau

tik dabar kita priezastis, kai prisijunge uzbanintas laiku nerodo jam priezasties 

	    //Jei užbanintas
    new query[100], Idas, JeiUzbanintas, Laikas;
     format(query,sizeof(query),"SELECT * FROM `zaidejai` WHERE vardas = '%s'", GetPlayerNameEx(playerid));
    mysql_query(query);
    mysql_store_result();
    mysql_retrieve_row();
    if(mysql_num_rows())
    {
        mysql_fetch_field_row(query, "Uzbanintas"); JeiUzbanintas = strval(query);
        mysql_fetch_field_row(query, "BanLaikas"); Laikas = strval(query);
        mysql_fetch_field_row(query, "ID"); Idas = strval(query);
        mysql_fetch_field_row( query, "BanoPriezastis");playerData[playerid][BanoPriezastis] = strval(query);
    }
    mysql_free_result();
     if(Laikas >= gettime())
    {
        ClearChat(playerid, 20);
        new msg[100];
        format(msg, sizeof(msg), "{EEA955}* Jūs esate užbanintas dar ({7EEE55}%s{EEA955})", ConvertSeconds(Laikas - gettime()));
        SendClientMessage(playerid, -1, msg);
        format(msg, sizeof(msg), "{EEA955}Jūs esate užbanintas del({7EEE55}%s{EEA955})", BanoPriezastis);
        SendClientMessage(playerid, -1, msg);
        format(msg, sizeof(msg), "{EEA955}* Kad atsibanintum siūsk sms su tekstu: {7EEE55}lunban %d {EEA955}numeriu {7EEE55}1398", Idas);
        SendClientMessage(playerid, -1, msg);
        SendClientMessage(playerid, -1, "{EEA955}* Kaina: {7EEE55}5{EEA955}€.");
        SendClientMessage(playerid, RED, "* PASTABOS: Siunčiant SMS žinutę įsitikinkite, kad serveris įjungtas.");
        SendClientMessage(playerid, RED, "* Tekstas turi būti nurašytas taip kaip parašyta, kitaip negausite unban!.");
        SendClientMessage(playerid, RED, "* Žinutės išsiuntimas galioja tik lietuviškiems telefono operatoriams!.");
        SetTimerEx("KickEx", 100, false, "d", playerid);
        return 1;
    }

bandziau ir taip nepadejo: 

	mysql_fetch_field_row(query, "BanoPriezastis"); ZinutesZin = strval(query);

		format(msg, sizeof(msg), "{EEA955}Jūs esate užbanintas del({7EEE55}%s{EEA955})", ZinutesZin);
		SendClientMessage(playerid, -1, msg);
Redaguota , nario ^Rokas

Ši tema yra neaktyvi. Paskutinis pranešimas šioje temoje buvo prieš 3032 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ą...