{SAMP} Neišgauna vardo su priežastimi.

[John'K]

Šitas kodas 

if(zInfo[playerid][Uzbanintas] == 1)
{
new Zin[185];
format (Zin,185,"Administratorius %s užblokavo jus už: %s \n Savininko skype: jovitix222",zInfo[playerid][Bvardas],zInfo[playerid][Bpriezastis]);
ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX,"{0000FF}Jūs esate užblokuotas!",Zin,"Išeiti","");
SavePlayerData(playerid);
SetTimerEx("Tkick", 100, false, "d", playerid);
} 

Iš mysql neišgauna šitų:

zInfo[playerid][Bvardas],zInfo[playerid][Bpriezastis]

Ką daryti? Atsidėkosiu +r3p

[FreeZ-]

Kaip išsaugai?

[nobody0]

Pridedi:

new pName[100],
    query[256],
    priez[256];

    format(query, 256, "SELECT * FROM `"Banų lentelė"` WHERE Admin_Vardas = '%s'", pName);
    mysql_query(query);
    mysql_store_result();

    format(query, 256, "SELECT * FROM `"Banų lentelė"` WHERE Priežastis = '%s'",priez);
    mysql_query(query);
    mysql_store_result();

ir tada pakeiti:

if(zInfo[playerid][Uzbanintas] == 1)
{
new Zin[185];
format (Zin,185,"Administratorius %s užblokavo jus už: %s \n Savininko skype: jovitix222",pName,priez);
ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX,"{0000FF}Jūs esate užblokuotas!",Zin,"Išeiti","");
SavePlayerData(playerid);
SetTimerEx("Tkick", 100, false, "d", playerid);
} 

Turėtų veikt, jei neklystu.

[John'K]

format( Query, sizeof(Query),"UPDATE `serveris` SET Uzbanintas = '%i', Bpriezastis = '%s', Bvardas = '%s', Teises = '%i', Direktorius = '%i' WHERE vardas = '%s'",\zInfo[playerid][Uzbanintas], zInfo[playerid][Bpriezastis], zInfo[playerid][Bvardas], zInfo[playerid][Teises], zInfo[playerid][Direktorius], GetPlayerNameEx(playerid));mysql_query( Query );

Saugo ^

Krauna V

mysql_fetch_field_row( fetch,"Uniformaa" );      zInfo[playerid][Uniformaa]  = strval( fetch ); mysql_fetch_field_row( fetch,"Uzbanintas" );     zInfo[playerid][Uzbanintas]  = strval( fetch );mysql_fetch_field_row( fetch,"Bpriezastis" );    zInfo[playerid][Bpriezastis]  = strval( fetch );

Pridedi:

new pName[100],    query[256],    priez[256];    format(query, 256, "SELECT * FROM `"Banų lentelė"` WHERE Admin_Vardas = '%s'", pName);    mysql_query(query);    mysql_store_result();    format(query, 256, "SELECT * FROM `"Banų lentelė"` WHERE Priežastis = '%s'",priez);    mysql_query(query);    mysql_store_result();

ir tada pakeiti:

if(zInfo[playerid][Uzbanintas] == 1){new Zin[185];format (Zin,185,"Administratorius %s užblokavo jus už: %s \n Savininko skype: jovitix222",pName,priez);ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX,"{0000FF}Jūs esate užblokuotas!",Zin,"Išeiti","");SavePlayerData(playerid);SetTimerEx("Tkick", 100, false, "d", playerid);} 

Turėtų veikt, jei neklystu.

Vistiek neisgauna.

Redaguota Spalio 25, 2014, nario Rimas

[Fexurious]

parodyk kaip sukuri zInfo[playerid][Bvardas] ir zInfo[playerid][Bpriezastis] ir priskiri jiems reikšmes

[John'K]

CMD:ban(playerid, params[]) //ACC BANAS

{

    new

     Priezastis[24],

     ID,

     Zin1[128],

     Zin2[128]

    ;

if(zInfo[playerid][Admin] < 2) return SendClientMessage(playerid,Raudona,"{ff0000}~KLAIDA: {FFFFFF}Tokios komandos nėra!");

{

if(sscanf(params,"us", ID, Priezastis)){SendClientMessage(playerid, Geltona, "~NAUDOJIMAS: /ban (Vardas/ID priežastis)");return 1;}

if(zInfo[ID][Admin] >3) return SendClientMessage(playerid,Raudona,"{ff0000}~KLAIDA: {FFFFFF}Savininko užblokuoti negalite.");

if(strlen(Priezastis) > 24 ) return SendClientMessage(playerid,Raudona, "{ff0000}~KLAIDA: {FFFFFF} priežastis per ilga (daugiausia 20 simbolių)");

if(ID == INVALID_PLAYER_ID ){SendClientMessage( playerid, Raudona, "{ff0000}~KLAIDA: {FFFFFF}Tokio žaidėjo nėra.");return 1;}

        format(Zin1,75,"~BAN: %s užblokavo jus už: %s",zVardas(playerid),Priezastis);

        format(Zin2,75,"~BAN: %s užblokavo: %s už: %s",zVardas(playerid),zVardas(ID),Priezastis);

        SendClientMessage(ID,Raudona,Zin1);

        SendClientMessageToAll(Raudona,Zin2);

        zInfo[ID][Bpriezastis] = strlen(Priezastis);

        zInfo[ID][Bvardas] = zVardas(playerid);

        zInfo[ID][Uzbanintas] = 1;

    KickPlayer(ID);

    }

    return 1;

}

[Fexurious]

kaip sukuri?.. ENUM

[John'K]

Ai :DD

Uzbanintas,
Bpriezastis,
Bvardas [ MAX_PLAYER_NAME ],

zInfo[MAX_PLAYERS][zaidejai],

Redaguota Spalio 26, 2014, nario John'K

[ℛøℓαᾔⅾ@﹩]

O įrašo gerai? jeigu taip parodyk krovimą.

[John'K]

 CMySQLHandler::Query(SELECT * FROM `serveris` WHERE vardas = 'Labas_Test') - Successfully executed.


[11:00:31] >> mysql_store_result( Connection handle: 1 )


[11:00:31] CMySQLHandler::StoreResult() - Result was stored.


[11:00:31] >> mysql_retrieve_row( Connection handle: 1 )


[11:00:31] >> mysql_fetch_field_row( Connection handle: 1 )


[11:00:31] CMySQLHandler::FetchField("Uniformaa") - 0


[11:00:31] >> mysql_fetch_field_row( Connection handle: 1 )


[11:00:31] CMySQLHandler::FetchField("Uzbanintas") - 1


[11:00:31] >> mysql_fetch_field_row( Connection handle: 1 )


[11:00:31] CMySQLHandler::FetchField("Bpriezastis") - John_Kuperis


[11:00:31] >> mysql_fetch_field_row( Connection handle: 1 )


[11:00:31] CMySQLHandler::FetchField("Bvardas") - John_Kuperis


[11:00:31] >> mysql_fetch_field_row( Connection handle: 1 )


[11:00:31] CMySQLHandler::FetchField("Tmasina") - 0


[11:00:31] >> mysql_fetch_field_row( Connection handle: 1 )


[11:00:31] CMySQLHandler::FetchField("Teises") - 0


[11:00:31] >> mysql_fetch_field_row( Connection handle: 1 )


[11:00:31] CMySQLHandler::FetchField("Direktorius") - 0


[11:00:31] >> mysql_fetch_field_row( Connection handle: 1 )


[11:00:31] CMySQLHandler::FetchField("Bsaskaita") - 0


[11:00:31] >> mysql_fetch_field_row( Connection handle: 1 )


[11:00:31] CMySQLHandler::FetchField("Saskaitoskodas") - 0


[11:00:31] >> mysql_fetch_field_row( Connection handle: 1 )


[11:00:31] CMySQLHandler::FetchField("Uniforma") - 0


[11:00:31] >> mysql_free_result( Connection handle: 1 )


[11:00:31] CMySQLHandler::FreeResult() - Result was successfully free'd.


[11:00:31] >> mysql_query( Connection handle: 1 )


[11:00:31] CMySQLHandler::Query(UPDATE `serveris` SET x = '1958.378295', y = '1343.157226', z = '15.874600' WHERE vardas = 'Labas_Test') - Successfully executed.


[11:00:31] >> mysql_query( Connection handle: 1 )


[11:00:31] CMySQLHandler::Query(UPDATE `serveris` SET Skin = '6', Pinigai = '0', Patirtis = '0', Admin = '0', Lytis = '1', Darbas = '0', Uniforma = '0', Uniformaa = '0', Banke = '0' WHERE vardas = 'Labas_Test') - Successfully executed.


[11:00:31] >> mysql_query( Connection handle: 1 )


[11:00:31] CMySQLHandler::Query(UPDATE `serveris` SET Uzbanintas = '1', Bpriezastis = '', Bvardas = '', Teises = '0', Direktorius = '0', Dispejimai = '0' WHERE vardas = 'Labas_Test') - Successfully executed.


[11:00:31] >> mysql_query( Connection handle: 1 )


[11:00:32] CMySQLHandler::Query(UPDATE `serveris` SET Bsaskaita = '0', Saskaitoskodas = '0',  Tmasina = '0', Sedilaiko = '0', Pasodintas = '0' WHERE vardas = 'Labas_Test') - Successfully executed.


[11:00:32] >> mysql_query( Connection handle: 1 )


[11:00:32] CMySQLHandler::Query(UPDATE `serveris` SET hp = '100.000000', armour = '0.000000' WHERE vardas = 'Labas_Test') - Successfully executed.


[11:00:57] >> mysql_close( Connection handle: 1 )


[11:00:57] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[11:00:57] CMySQLHandler::FreeResult() - The result is already empty.


[11:00:57] CMySQLHandler::Disconnect() - Connection was closed.

Cia jau gaves bando prisijungti, ir arsijungiant issaugo 0

 

[BloodTiger]

 

Ai :DD

Uzbanintas,
Bpriezastis,
Bvardas [ MAX_PLAYER_NAME ],

zInfo[MAX_PLAYERS][zaidejai],

 

Bpriezastis turi buti string nurodyk dydi