Jump to content
  • 0

Problema admin MYSQL


WiDuAlK

Question

Nick: WiDuAlK

Problema: Salutare , de 1 saptamana am inceput singur un proiect ,  un GM pe mysql si am ajuns la partea cu admin si cu comenzile , de fapt am doar 5 comenzi pt ca deabia l-am inceput. Am pus comanda jetpack , goto , gotols , gotosf , gotolv , fixveh si getcar , si la ele trebuie sa ai peste admin 1 , dar se pot folosi si fara sa ai admin , deci asta e problema , miam psus comanda makeadmin la care trb sa fi logat cu rconul , si ea merge perfect . Mi-am facut cont din nou si imi mergeau comenzile , mam logat cu rconul si miam dat admin 0 , chiar daca deja aveam admin 0 si am incercat comanda din nou si vad ca daca incercam acum comenzile nu imi mai mergeau , de parca ar fi totul in regula , dar dupa ce am intrat din nou , dupa ce - mi dadusem admin 0 , am incercat comenzile sa crezand ca nu mai fac problema dar , la fel mergeau.

Erori / warnings: -

Lini/script: [pawn]enum pData

{

ID ,

        ...

        AdminLevel ,

        ...

}

[/pawn]

[pawn]CMD:gotosf( playerid, params[ ] )

{

if(PlayerInfo[ playerid ][ AdminLevel] < 1 )

    return SendClientMessage( playerid, -1, "Nu esti administrator!" ) ;

   

    if (GetPlayerState(playerid) == 2)

{

new tmpcar = GetPlayerVehicleID(playerid);

SetVehiclePos(tmpcar, -1417.0,-295.8,14.1);

}

else

{

SetPlayerPos(playerid, -1417.0,-295.8,14.1);

}

  return ( 1 ) ;

}

CMD:makeadmin( playerid,params[ ] )

{

new id, alvl ;

if ( !IsPlayerAdmin( playerid ) )

return SendClientMessage(playerid,-1, "Nu esti rcon!");

    if ( sscanf( params, "ui", id, alvl ) )

return SendClientMessage( playerid, -1, "Comanda este: /makeadmin <playerid><admin level>" ) ;

    if ( alvl < 0 || alvl > 10 )

return SendClientMessage( playerid, -1, "0<->10" ) ;

PlayerInfo[ id ][ AdminLevel ] = alvl ;

SendClientMessage( id, -1, "Esti admin!" ) ;

return ( true ) ;

}

CMD:jetpack( playerid, params[ ] )

{

    if ( PlayerInfo[ playerid ][ AdminLevel] < 1 )

    return SendClientMessage( playerid, -1, "Nu esti administrator!" ) ;

    new Float:X,Float:Y,Float:Z;

    GetPlayerPos(playerid,X,Y,Z);

    SetPlayerPos(playerid, X, Y, Z);

    CreatePickup(370,2,X,Y,Z);

    SendClientMessage(playerid, Gri, "* Spawned Jetpack");

    return ( true ) ;

}

CMD:fixveh( playerid, params[ ] )

    {

        if(IsPlayerConnected(playerid))

        {

            if(PlayerInfo[ playerid ][ AdminLevel] < 1 )

            {

                SendClientMessage(playerid, 0xFFFFFFFF, "Nu esti autorizat sa folosesti aceasta comanda!");

                return 1;

            }

            if(IsPlayerInAnyVehicle(playerid))

            {

                RepairVehicle(GetPlayerVehicleID(playerid));

                SendClientMessage(playerid, 0xFFFFFFFF, "Vehicul reparat !");

            }

        }

        return 1;

    }

CMD:getcar(playerid, params[])

{

    new carid;

    if(sscanf(params, "i", carid)) return SendClientMessage(playerid, ~1, "USAGE: /getcar [carid]");

    if(carid > MAX_VEHICLES) return SendClientMessage(playerid, ~1, "That  vehicle does not exists.");

    new Float: gPos[3];

    GetPlayerPos(playerid, gPos[0], gPos[1], gPos[2]);

    SetVehiclePos(carid, gPos[0] + 2, gPos[1], gPos[2]);

    return 1;

}[/pawn]

[pawn]Function:: OnPlayerLogin( playerid )

{

gString[ 0 ] = EOS ;

gQuery[ 0 ] = EOS ;

PlayerInfo[ playerid ][ ID ] = cache_get_field_content_int( 0, "ID", aHandle ) ;

PlayerInfo[ playerid ][ Money ] = cache_get_field_content_int( 0, "Money", aHandle ) ;

PlayerInfo[ playerid ][ AdminLevel ] = cache_get_field_content_int( 0, "AdminLevel", aHandle ) ;

PlayerInfo[ playerid ][ Points ] = cache_get_field_content_int( 0, "Points", aHandle ) ;

PlayerInfo[ playerid ][ Nota ] = cache_get_field_content_int( 0, "Nota", aHandle ) ;

cache_get_field_content( 0, "Mail", PlayerInfo[ playerid ][ Mail ], aHandle, 129 ) ;

cache_get_field_content( 0, "Judet", PlayerInfo[ playerid ][ Judet ], aHandle, 129 ) ;

ResetPlayerMoney( playerid ) ;

GivePlayerMoney( playerid, cache_get_field_content_int( 0, "Money", aHandle ) ) ;

SCM( playerid, Biscuite, "Te-ai logat cu succes!" ) ;

SpawnPlayer(playerid);

TogglePlayerSpectating( playerid, 0 ) ;

Logged[ playerid ] = true;

return ( true ) ;

}

Function:: SavepData( playerid )

{

if ( Logged[ playerid ] == false )

return Kick( playerid ) ;

gQuery[ 0 ] = EOS;

PlayerInfo[ playerid ][ Money ] =   GetPlayerMoney( playerid ) ;

mysql_format( aHandle, gQuery, sizeof( gQuery ), "UPDATE `Users` SET `Money`='%d' , `Ani`='%d' , `AdminLevel`='%d' , `Points`='%d' , `Sex`='%d' `Nota`='%d' , `Level`='%d' WHERE `Name`='%s'",

                                PlayerInfo[ playerid ][ Money ] ,

                                PlayerInfo[ playerid ][ AdminLevel ] ,

                                PlayerInfo[ playerid ][ Points ] ,

                                PlayerInfo[ playerid ][ Sex ] ,

                                PlayerInfo[ playerid ][ Nota ] ,

                                PlayerInfo[ playerid ][ Level ] ,

                                GetName( playerid ) ) ;

mysql_tquery( aHandle, gQuery, "", "" ) ;

gQuery[ 0 ] = EOS;

mysql_format( aHandle, gQuery, sizeof( gQuery ), "UPDATE `Users` SET `Money`='%d' WHERE `Name`='%s'",

                                PlayerInfo[ playerid ][ Money ] ,

                                GetName( playerid ) ) ;

mysql_tquery( aHandle, gQuery, "", "" ) ;

return ( true ) ;

}[/pawn]

Ai incercat sa rezolvi singur ?: Da

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

Nu stiu daca functioneaza dar incearca.

[pawn]CMD:gotosf( playerid, params[ ] )

{

if(PlayerInfo[ playerid ][ AdminLevel] > 0 )

{

    if (GetPlayerState(playerid) == 2)

{

new tmpcar = GetPlayerVehicleID(playerid);

SetVehiclePos(tmpcar, -1417.0,-295.8,14.1);

}

else

{

SetPlayerPos(playerid, -1417.0,-295.8,14.1);

}

else return SendClientMessage(playerid, 0xFF0000AA, "Nu ai nivelul corespunzator pentru aceasta comanda");

}

CMD:makeadmin( playerid,params[ ] )

{

new id, alvl ;

if ( IsPlayerAdmin( playerid ) )

{

    if ( sscanf( params, "ui", id, alvl ) )

return SendClientMessage( playerid, -1, "Comanda este: /makeadmin <playerid><admin level>" ) ;

    if ( alvl < 0 || alvl > 10 )

return SendClientMessage( playerid, -1, "0<->10" ) ;

PlayerInfo[ id ][ AdminLevel ] = alvl ;

SendClientMessage( id, -1, "Esti admin!" ) ;

}

else return SendClientMessage(playerid,-1, "Nu esti rcon!");

}

CMD:jetpack( playerid, params[ ] )

{

    if ( PlayerInfo[ playerid ][ AdminLevel] > 0 )

{

    new Float:X,Float:Y,Float:Z;

    GetPlayerPos(playerid,X,Y,Z);

  SetPlayerPos(playerid, X, Y, Z);

    CreatePickup(370,2,X,Y,Z);

    SendClientMessage(playerid, Gri, "* Spawned Jetpack");

    }

    else return SendClientMessage( playerid, -1, "Nu esti administrator!" ) ;

}

CMD:fixveh( playerid, params[ ] )

    {

        if(IsPlayerConnected(playerid))

        {

            if(PlayerInfo[ playerid ][ AdminLevel] > 0 )

            {

            if(IsPlayerInAnyVehicle(playerid))

            {

                RepairVehicle(GetPlayerVehicleID(playerid));

                SendClientMessage(playerid, 0xFFFFFFFF, "Vehicul reparat !");

            }

        }

        else SendClientMessage(playerid, 0xFFFFFFFF, "Nu esti autorizat sa folosesti aceasta comanda!");

        }

        return 1;

    }

CMD:getcar(playerid, params[])

{

    new carid;

    if(sscanf(params, "i", carid)) return SendClientMessage(playerid, ~1, "USAGE: /getcar [carid]");

    if(carid > MAX_VEHICLES) return SendClientMessage(playerid, ~1, "That  vehicle does not exists.");

    new Float: gPos[3];

    GetPlayerPos(playerid, gPos[0], gPos[1], gPos[2]);

    SetVehiclePos(carid, gPos[0] + 2, gPos[1], gPos[2]);

    return 1;

}[/pawn]

8ffTNVU.png

Link to comment
Share on other sites

Nu stiu daca functioneaza dar incearca.

[pawn]CMD:gotosf( playerid, params[ ] )

{

if(PlayerInfo[ playerid ][ AdminLevel] > 0 )//Tocmai ai facut comanda pentru playerii obisnuiti.

{

    if (GetPlayerState(playerid) == 2)

{

new tmpcar = GetPlayerVehicleID(playerid);

SetVehiclePos(tmpcar, -1417.0,-295.8,14.1);

}

else

{

SetPlayerPos(playerid, -1417.0,-295.8,14.1);

}

else return SendClientMessage(playerid, 0xFF0000AA, "Nu ai nivelul corespunzator pentru aceasta comanda");

}

CMD:makeadmin( playerid,params[ ] )

{

new id, alvl ;

if ( IsPlayerAdmin( playerid ) )

{

    if ( sscanf( params, "ui", id, alvl ) )

return SendClientMessage( playerid, -1, "Comanda este: /makeadmin <playerid><admin level>" ) ;

    if ( alvl < 0 || alvl > 10 )

return SendClientMessage( playerid, -1, "0<->10" ) ;

PlayerInfo[ id ][ AdminLevel ] = alvl ;

SendClientMessage( id, -1, "Esti admin!" ) ;

}

else return SendClientMessage(playerid,-1, "Nu esti rcon!");

}

CMD:jetpack( playerid, params[ ] )

{

    if ( PlayerInfo[ playerid ][ AdminLevel] > 0 )

{

    new Float:X,Float:Y,Float:Z;

    GetPlayerPos(playerid,X,Y,Z);

  SetPlayerPos(playerid, X, Y, Z);

    CreatePickup(370,2,X,Y,Z);

    SendClientMessage(playerid, Gri, "* Spawned Jetpack");

    }

    else return SendClientMessage( playerid, -1, "Nu esti administrator!" ) ;

}

CMD:fixveh( playerid, params[ ] )

    {

        if(IsPlayerConnected(playerid))

        {

            if(PlayerInfo[ playerid ][ AdminLevel] > 0 )

            {

            if(IsPlayerInAnyVehicle(playerid))

            {

                RepairVehicle(GetPlayerVehicleID(playerid));

                SendClientMessage(playerid, 0xFFFFFFFF, "Vehicul reparat !");

            }

        }

        else SendClientMessage(playerid, 0xFFFFFFFF, "Nu esti autorizat sa folosesti aceasta comanda!");

        }

        return 1;

    }

CMD:getcar(playerid, params[])

{

    new carid;

    if(sscanf(params, "i", carid)) return SendClientMessage(playerid, ~1, "USAGE: /getcar [carid]");

    if(carid > MAX_VEHICLES) return SendClientMessage(playerid, ~1, "That  vehicle does not exists.");

    new Float: gPos[3];

    GetPlayerPos(playerid, gPos[0], gPos[1], gPos[2]);

    SetVehiclePos(carid, gPos[0] + 2, gPos[1], gPos[2]);

    return 1;

}[/pawn]

Tu gandesti ce ai spus?

Ia incearca:

[pawn]CMD:gotosf( playerid, params[ ] )

{

if(PlayerInfo[ playerid ][ AdminLevel] >= 1 )//Setezi levelul de admin.

{

    if (GetPlayerState(playerid) == 2)

{

new tmpcar = GetPlayerVehicleID(playerid);

SetVehiclePos(tmpcar, -1417.0,-295.8,14.1);

}

else

{

SetPlayerPos(playerid, -1417.0,-295.8,14.1);

}

else return SendClientMessage(playerid, 0xFF0000AA, "Nu ai nivelul corespunzator pentru aceasta comanda");

}

CMD:makeadmin( playerid,params[ ] )

{

new id, alvl ;

if ( IsPlayerAdmin( playerid ) )//Ai facut comanda ca RCON...

{

    if ( sscanf( params, "ui", id, alvl ) )

return SendClientMessage( playerid, -1, "Comanda este: /makeadmin <playerid><admin level>" ) ;

    if ( alvl < 0 || alvl > 10 )

return SendClientMessage( playerid, -1, "0<->10" ) ;

PlayerInfo[ id ][ AdminLevel ] = alvl ;

SendClientMessage( id, -1, "Esti admin!" ) ;

}

else return SendClientMessage(playerid,-1, "Nu esti rcon!");

}

CMD:jetpack( playerid, params[ ] )

{

    if ( PlayerInfo[ playerid ][ AdminLevel] >= 1 )//Setezi tu adminul...

{

    new Float:X,Float:Y,Float:Z;

    GetPlayerPos(playerid,X,Y,Z);

  SetPlayerPos(playerid, X, Y, Z);

    CreatePickup(370,2,X,Y,Z);

    SendClientMessage(playerid, Gri, "* Spawned Jetpack");

    }

    else return SendClientMessage( playerid, -1, "Nu esti administrator!" ) ;

}

CMD:fixveh( playerid, params[ ] )

    {

        if(IsPlayerConnected(playerid))

        {

            if(PlayerInfo[ playerid ][ AdminLevel] >= 1 )//Setezi tu adminul...

            {

            if(IsPlayerInAnyVehicle(playerid))

            {

                RepairVehicle(GetPlayerVehicleID(playerid));

                SendClientMessage(playerid, 0xFFFFFFFF, "Vehicul reparat !");

            }

        }

        else SendClientMessage(playerid, 0xFFFFFFFF, "Nu esti autorizat sa folosesti aceasta comanda!");

        }

        return 1;

    }

CMD:getcar(playerid, params[])

{

    new carid;

    if(sscanf(params, "i", carid)) return SendClientMessage(playerid, ~1, "USAGE: /getcar [carid]");

    if(carid > MAX_VEHICLES) return SendClientMessage(playerid, ~1, "That  vehicle does not exists.");

    new Float: gPos[3];

    GetPlayerPos(playerid, gPos[0], gPos[1], gPos[2]);

    SetVehiclePos(carid, gPos[0] + 2, gPos[1], gPos[2]);

    return 1;

}[/pawn]

 

 

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.