[FOTIS6]

I have created a mysql register/login Script.
I also use it for Admins. But I have problems with admins commands.

Код:

new Text3D:adminonduty;
COMMAND:onduty(playerid, params[])
{
	mysql_query("SELECT name FROM playerdata WHERE level > 2");
	mysql_store_result();
	if(mysql_affected_rows()>0)
	{
		new string[128];
		format(string, sizeof(string), "Administrator %s is now onduty!", PlayerName(playerid));
		SendClientMessage(playerid, red, string);
		adminonduty = Create3DTextLabel("Administrator", lightgreen, 30.0, 40.0, 50.0, 40.0, 0);
		Attach3DTextLabelToPlayer(adminonduty, playerid, 0.0, 0.0, 0.7);
		SetPlayerHealth(playerid, 999999);

	}
	else return SendClientMessage(playerid, red, "Error: You must be Administrator level 3 to use this command");
	mysql_free_result();
        return 1;
}

I want to use it for level 3. But all players can use it.
I hope you can help me.

[DBan]

Why not make it easier for yourself?

Create an enum:

pawn Код:

enum playerdata
{
    adminlevel
}
new PlayerInfo[MAX_PLAYERS][playerdata];

Then set the level when the player connects (I created a stock in my script to do that)

pawn Код:

stock SetLevel(playerid)
{
    new query[200], level;
    format(query, sizeof(query), "SELECT adminlevel FROM `playerdata` WHERE user ='%s'", GetName(playerid));
    mysql_query(query);
    mysql_store_result();
    level = mysql_fetch_int(); // This gets the adminlevel and sets it into the variable
    mysql_free_result();
    PlayerInfo[playerid][adminlevel] = level; // Set adminlevel to the level that was stored inside the variable
    return 1;
}

pawn Код:

public OnPlayerConnect
{
    SetLevel(playerid);
    return 1;
}

Then whenever you check if the player is high enough level:

pawn Код:

if(PlayerInfo[playerid][adminlevel] > 2)
{
    // Add code here...
}

[FOTIS6]

Thanks for it but it didn't worked

[DBan]

Quote:

Originally Posted by FOTIS6 Thanks for it but it didn't worked

In what way did it not work? Are you getting errors, or?

EDIT:
Don't copy and paste. The MySQL query was from my script, you'll need to edit it as you will have different table names and columns.

[FOTIS6]

No errors. It didn't work in the server.
Chatlog: Error: You must be Administrator level 3 to use this command

[DBan]

Edited my message ^^

You need to edit the mysql query according to your database.

[FOTIS6]

Код:

enum playerdata
{
    level
}
new PlayerInfo[MAX_PLAYERS][playerdata];

stock SetLevel(playerid)
{
    new query[200], level;
    format(query, sizeof(query), "SELECT level FROM playerdata WHERE user ='%s'", PlayerName(playerid));
    mysql_query(query);
    mysql_store_result();
    level = mysql_fetch_int(); // This gets the adminlevel and sets it into the variable
    mysql_free_result();
    PlayerInfo[playerid][level] = level; // Set adminlevel to the level that was stored inside the variable
    return 1;
}

Didn't work
I edited it.

[DBan]

Quote:

Originally Posted by FOTIS6 Код: enum playerdata { level } new PlayerInfo[MAX_PLAYERS][playerdata]; stock SetLevel(playerid) { new query[200], level; format(query, sizeof(query), "SELECT level FROM playerdata WHERE user ='%s'", PlayerName(playerid)); mysql_query(query); mysql_store_result(); level = mysql_fetch_int(); // This gets the adminlevel and sets it into the variable mysql_free_result(); PlayerInfo[playerid][level] = level; // Set adminlevel to the level that was stored inside the variable return 1; } Didn't work I edited it.

Are you sure your account is set to the correct level? It works perfectly on my server.

pawn Код:

COMMAND:onduty(playerid, params[])
{
    if(PlayerInfo[playerid][adminlevel] > 2)
    {
        new string[128];
        format(string, sizeof(string), "Administrator %s is now onduty!", GetName(playerid));
        SendClientMessage(playerid, CRED, string);
        SetPlayerHealth(playerid, 999999);
    }
    else return SendClientMessage(playerid, CRED, "Error: You must be Administrator level 3 to use this command");
    return 1;
}

I removed the 3d text draws when I edited it, you can put it back in if you want.

[FOTIS6]

Yes. it is set to level 5

[DBan]

Try the code I posted (edited my post)