Admin name

Zsoltisz · March 10, 2016

Hello guys! I have this script. So, when i go in adminduty my name is changed to my account name. That's good.

BUT. When i go out in adminduty my name is not changed to my character name. Please help for me!

//Sorry for bad english.

function adminDuty(thePlayer, commandName) 
    if exports.global:isPlayerAdmin(thePlayer) then 
        local id = getElementData(thePlayer, "playerid") 
        local adminduty = getElementData(thePlayer, "adminduty") 
        local username = getPlayerName(thePlayer) 
        local adminnev = getElementData(thePlayer, "gameaccountusername") 
        local karinev =  mysql:query("SELECT charactername FROM characters WHERE charactername=") 
         
        if (adminduty==0) then 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 1, false) 
            setPlayerName (thePlayer, adminnev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FFFFFFadminszolgálatba #66FF66lépett! #FFFFFFHasználd a #32C8FF/pm " .. id .." #FFFFFFparancsot, hogy írj neki!",getRootElement(),  255, 255, 255, true) 
        elseif (adminduty==1) then 
            local adminlevel = getElementData(thePlayer, "adminlevel") 
            if (adminlevel == 2) then 
                outputChatBox("#66FF66[starMTA-Admin]#FFFFFF1-es Admin nem léphet ki szolgálatból.", thePlayer, 255, 0, 0, true) 
                return 
            end 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 0, false) 
            setPlayerName (thePlayer, karinev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FF6666kilépett #FFFFFFaz adminszolgálatból!", getRootElement(), 255, 0, 0, true) 
        end 
        mysql:query_free("UPDATE accounts SET adminduty=" .. mysql:escape_string(getElementData(thePlayer, "adminduty")) .. " WHERE id = '" .. mysql:escape_string(getElementData(thePlayer, "gameaccountid")).."'" ) 
        exports.global:updateNametagColor(thePlayer) 
    end 
end 
addCommandHandler("adminduty", adminDuty, false, false)

Dimos7 · March 10, 2016

function adminDuty(thePlayer, commandName) 
    if exports.global:isPlayerAdmin(thePlayer) then 
        local id = getElementData(thePlayer, "playerid") 
        local adminduty = getElementData(thePlayer, "adminduty") 
        local username = getPlayerName(thePlayer) 
        local adminnev = getElementData(thePlayer, "gameaccountusername") 
        local karinev =  mysql:query("SELECT * FROM characters WHERE charactername=?") 
        
        if (adminduty==0) then 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 1, false) 
            setPlayerName (thePlayer, adminnev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FFFFFFadminszolgálatba #66FF66lépett! #FFFFFFHasználd a #32C8FF/pm " .. id .." #FFFFFFparancsot, hogy írj neki!",getRootElement(),  255, 255, 255, true) 
        elseif (adminduty==1) then 
            local adminlevel = getElementData(thePlayer, "adminlevel") 
            if (adminlevel == 2) then 
                outputChatBox("#66FF66[starMTA-Admin]#FFFFFF1-es Admin nem léphet ki szolgálatból.", thePlayer, 255, 0, 0, true) 
                return 
            end 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 0, false) 
            setPlayerName (thePlayer, karinev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FF6666kilépett #FFFFFFaz adminszolgálatból!", getRootElement(), 255, 0, 0, true) 
        end 
        mysql:query_free("UPDATE accounts SET adminduty=" .. mysql:escape_string(getElementData(thePlayer, "adminduty")) .. " WHERE id = '" .. mysql:escape_string(getElementData(thePlayer, "gameaccountid")).."'" ) 
        exports.global:updateNametagColor(thePlayer) 
    end 
end 
addCommandHandler("adminduty", adminDuty, false, false)

Zsoltisz · March 10, 2016

Dont working

[2016-03-10 13:37:24] INFO: MYSQL ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1 
[2016-03-10 13:37:24] WARNING: admin-system/Player/s_player_commands.lua:793: Bad argument @ 'setPlayerName' [Expected string at argument 2, got boolean]

Dimos7 · March 10, 2016

function adminDuty(thePlayer, commandName) 
    if exports.global:isPlayerAdmin(thePlayer) then 
        local id = getElementData(thePlayer, "playerid") 
        local adminduty = getElementData(thePlayer, "adminduty") 
        local username = getPlayerName(thePlayer) 
        local adminnev = getElementData(thePlayer, "gameaccountusername") 
        local karinev = getPlayerName(thePlayer) 
        
        if (adminduty==0) then 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 1, false) 
            setPlayerName (thePlayer, adminnev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FFFFFFadminszolgálatba #66FF66lépett! #FFFFFFHasználd a #32C8FF/pm " .. id .." #FFFFFFparancsot, hogy írj neki!",getRootElement(),  255, 255, 255, true) 
        elseif (adminduty==1) then 
            local adminlevel = getElementData(thePlayer, "adminlevel") 
            if (adminlevel == 2) then 
                outputChatBox("#66FF66[starMTA-Admin]#FFFFFF1-es Admin nem léphet ki szolgálatból.", thePlayer, 255, 0, 0, true) 
                return 
            end 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 0, false) 
            setPlayerName (thePlayer, karinev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FF6666kilépett #FFFFFFaz adminszolgálatból!", getRootElement(), 255, 0, 0, true) 
        end 
        mysql:query_free("UPDATE accounts SET adminduty=" .. mysql:escape_string(getElementData(thePlayer, "adminduty")) .. " WHERE id = '" .. mysql:escape_string(getElementData(thePlayer, "gameaccountid")).."'" ) 
        exports.global:updateNametagColor(thePlayer) 
    end 
end 
addCommandHandler("adminduty", adminDuty, false, false)

Zsoltisz · March 14, 2016

No. The getPlayerName is getting my actually name.

Dimos7 · March 14, 2016

function adminDuty(thePlayer, commandName) 
    if exports.global:isPlayerAdmin(thePlayer) then 
        local id = getElementData(thePlayer, "playerid") 
        local adminduty = getElementData(thePlayer, "adminduty") 
        local username = getPlayerName(thePlayer) 
        local adminnev = getElementData(thePlayer, "gameaccountusername") 
        local karinev =  mysql:query("SELECT * FROM characters WHERE charactername=") 
        
        if (adminduty==0) then 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 1, false) 
            setPlayerName (thePlayer, adminnev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FFFFFFadminszolgálatba #66FF66lépett! #FFFFFFHasználd a #32C8FF/pm " .. id .." #FFFFFFparancsot, hogy írj neki!",getRootElement(),  255, 255, 255, true) 
        elseif (adminduty==1) then 
            local adminlevel = getElementData(thePlayer, "adminlevel") 
            if (adminlevel == 2) then 
                outputChatBox("#66FF66[starMTA-Admin]#FFFFFF1-es Admin nem léphet ki szolgálatból.", thePlayer, 255, 0, 0, true) 
                return 
            end 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 0, false) 
            setPlayerName (thePlayer, karinev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FF6666kilépett #FFFFFFaz adminszolgálatból!", getRootElement(), 255, 0, 0, true) 
        end 
        mysql:query_free("UPDATE accounts SET adminduty=" .. mysql:escape_string(getElementData(thePlayer, "adminduty")) .. " WHERE id = '" .. mysql:escape_string(getElementData(thePlayer, "gameaccountid")).."'" ) 
        exports.global:updateNametagColor(thePlayer) 
    end 
end 
addCommandHandler("adminduty", adminDuty, false, false)

Zsoltisz · March 21, 2016

Again error

    [2016-03-21 16:39:20] INFO: MYSQL ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near " at line 1 
    [2016-03-21 16:39:20] WARNING: admin-system/Player/s_player_commands.lua:793: Bad argument @ 'setPlayerName' [Expected string at argument 2, got boolean]

Dimos7 · March 22, 2016

function adminDuty(thePlayer, commandName) 
    if exports.global:isPlayerAdmin(thePlayer) then 
        local id = getElementData(thePlayer, "playerid") 
        local adminduty = getElementData(thePlayer, "adminduty") 
        local username = getPlayerName(thePlayer) 
        local adminnev = getElementData(thePlayer, "gameaccountusername") 
        local karinev =  mysql:query("SELECT * FROM characters WHERE charactername=?") 
        
        if (adminduty==0) then 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 1, false) 
            setPlayerName (thePlayer, adminnev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FFFFFFadminszolgálatba #66FF66lépett! #FFFFFFHasználd a #32C8FF/pm " .. id .." #FFFFFFparancsot, hogy írj neki!",getRootElement(),  255, 255, 255, true) 
        elseif (adminduty==1) then 
            local adminlevel = getElementData(thePlayer, "adminlevel") 
            if (adminlevel == 2) then 
                outputChatBox("#66FF66[starMTA-Admin]#FFFFFF1-es Admin nem léphet ki szolgálatból.", thePlayer, 255, 0, 0, true) 
                return 
            end 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 0, false) 
            setPlayerName (thePlayer, karinev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FF6666kilépett #FFFFFFaz adminszolgálatból!", getRootElement(), 255, 0, 0, true) 
        end 
        mysql:query_free("UPDATE accounts SET adminduty=" .. mysql:escape_string(getElementData(thePlayer, "adminduty")) .. " WHERE id = '" .. mysql:escape_string(getElementData(thePlayer, "gameaccountid")).."'" ) 
        exports.global:updateNametagColor(thePlayer) 
    end 
end 
addCommandHandler("adminduty", adminDuty, false, false)

..:D&G:.. · March 22, 2016

Zsoltisz · March 22, 2016

Again error

Dimos7 · March 22, 2016

function adminDuty(thePlayer, commandName) 
    if exports.global:isPlayerAdmin(thePlayer) then 
        local id = getElementData(thePlayer, "playerid") 
        local adminduty = getElementData(thePlayer, "adminduty") 
        local username = getPlayerName(thePlayer) 
        local adminnev = getElementData(thePlayer, "gameaccountusername") 
        local karinev =  mysql:query("SELECT * FROM characters WHERE charactername=?", charactername) 
        
        if (adminduty==0) then 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 1, false) 
            setPlayerName (thePlayer, adminnev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FFFFFFadminszolgálatba #66FF66lépett! #FFFFFFHasználd a #32C8FF/pm " .. id .." #FFFFFFparancsot, hogy írj neki!",getRootElement(),  255, 255, 255, true) 
        elseif (adminduty==1) then 
            local adminlevel = getElementData(thePlayer, "adminlevel") 
            if (adminlevel == 2) then 
                outputChatBox("#66FF66[starMTA-Admin]#FFFFFF1-es Admin nem léphet ki szolgálatból.", thePlayer, 255, 0, 0, true) 
                return 
            end 
            exports['anticheat-system']:changeProtectedElementDataEx(thePlayer, "adminduty", 0, false) 
            setPlayerName (thePlayer, karinev) 
            outputChatBox("#66FF66[starMTA]#32C8FF " .. adminnev .. " #FF6666kilépett #FFFFFFaz adminszolgálatból!", getRootElement(), 255, 0, 0, true) 
        end 
        mysql:query_free("UPDATE accounts SET adminduty=" .. mysql:escape_string(getElementData(thePlayer, "adminduty")) .. " WHERE id = '" .. mysql:escape_string(getElementData(thePlayer, "gameaccountid")).."'" ) 
        exports.global:updateNametagColor(thePlayer) 
    end 
end 
addCommandHandler("adminduty", adminDuty, false, false)

Sign In

Admin name

Recommended Posts

Zsoltisz

Link to comment

Dimos7

Link to comment

Zsoltisz

Link to comment

Dimos7

Link to comment

Zsoltisz

Link to comment

Dimos7

Link to comment

Zsoltisz

Link to comment

Dimos7

Link to comment

..:D&G:..

Link to comment

Zsoltisz

Link to comment

Dimos7

Link to comment

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Browse

Activity

MTA Network

Social Media