SaedAmer Posted August 1, 2017 Author Share Posted August 1, 2017 ايه المشكلة هنا outputChatBox("#FF0000 # #FFFFFF[ #CD0000"..tag .."#FFFFFF ]x #A5A5A5".. getPlayerName(source) .. ""..colour.." : ".. msg.."",root, 255, 255, 255, true) Link to comment
Mhmd.z Posted August 1, 2017 Share Posted August 1, 2017 On 01/08/2017 at 19:02, SaedAmer said: ايه المشكلة هنا outputChatBox("#FF0000 # #FFFFFF[ #CD0000"..tag .."#FFFFFF ]x #A5A5A5".. getPlayerName(source) .. ""..colour.." : ".. msg.."",root, 255, 255, 255, true) Expand يلي مكتوب بالدي بق هو انه كولر يلي معرفه جدول مو سترنقcolour وريني تعريف Link to comment
SaedAmer Posted August 1, 2017 Author Share Posted August 1, 2017 On 01/08/2017 at 19:29, Mhmd.z said: يلي مكتوب بالدي بق هو انه كولر يلي معرفه جدول مو سترنقcolour وريني تعريف Expand addEventHandler("onPlayerChat",root,function (msg) local tag = getElementData(source,"tag") or 'player' local colour = getElementData(source,"colour") or '#FFFFFF' outputChatBox("#FF0000 # #FFFFFF[ #CD0000"..tag .."#FFFFFF ]x #A5A5A5".. getPlayerName(source) .. ""..colour.." : ".. msg.."",root, 255, 255, 255, true) return cancelEvent() end) executeSQLQuery("CREATE TABLE IF NOT EXISTS PlayersTag (player, serial, tag, colour)") addEventHandler("onPlayerQuit", root, function () local tag = getElementData(source, "tag") local colour = getElementData(source, "colour") local playerName = getPlayerName(source) local serial = getPlayerSerial(source) local sqlTag = executeSQLQuery("SELECT tag FROM PlayersTag WHERE serial=?", serial) if isGuestAccount(getPlayerAccount(source)) then return end if not tag or not colour then return end if sqlTag == 0 then executeSQLQuery("INSERT INTO PlayersTag(player, serial, tag, colour) VALUES(?,?,?,?)", playerName, serial, tag, colour) else executeSQLQuery("UPDATE PlayersTag SET player=?,serial=?,tag=?,colour=? WHERE serial=?", playerName, serial, tag, colour) end end ) addEventHandler("onPlayerLogin", root, function () local serial = getPlayerSerial(source) local sqlTag = executeSQLQuery("SELECT tag FROM PlayersTag WHERE serial=?", serial) local sqlColour = executeSQLQuery("SELECT colour FROM PlayersTag WHERE serial=?", serial) if sqlTag ~= 0 then setElementData(source, "tag", sqlTag) setElementData(source, "colour", sqlColour) outputChatBox("Your tag is: "..sqlTag, source) else outputChatBox("You havn't a tag", source) end end ) Link to comment
Abdul KariM Posted August 1, 2017 Share Posted August 1, 2017 (edited) executeSQLQuery("CREATE TABLE IF NOT EXISTS PlayersTag (player, serial, tag, colour)") addEventHandler("onPlayerChat",root,function (msg) local tag = getElementData(source,"tag") or 'player' local colour = getElementData(source,"colour") or '#FFFFFF' outputChatBox("#FF0000 # #FFFFFF[ #CD0000"..tag .."#FFFFFF ]x #A5A5A5".. getPlayerName(source) .. ""..colour.." : ".. msg.."",root, 255, 255, 255, true) return cancelEvent() end) function getPlayerTag ( player ) local playerSerial = player and getPlayerSerial ( player ) local playerResult = executeSQLQuery("SELECT * FROM PlayersTag WHERE serial = ? ", playerSerial ) if ( #playerResult ~= 0 and type ( playerResult ) == "table" ) then return playerResult [ 1 ] [ "tag" ] , playerResult [ 1 ] [ "colour" ] end return false end function savePlayerTag ( player ) local playerSerial = player and getPlayerSerial ( player ) local playerTag = getElementData ( player , "tag" ) or false local playerColor = getElementData ( player , "colour" ) or false local playerName = getPlayerName ( player ) if ( not playerTag or not playerColor ) then return false end if ( getPlayerTag ( player ) ~= false ) then executeSQLQuery("UPDATE PlayersTag SET player=?,tag=?,colour=? WHERE serial=?", playerName, playerTag, playerColor,playerSerial) else executeSQLQuery("INSERT INTO PlayersTag(player, serial, tag, colour) VALUES(?,?,?,?)", playerName, playerSerial, playerTag, playerColor) return true end return false end addEventHandler("onPlayerQuit", root, function ( ) savePlayerTag ( source ) end ) addEventHandler("onPlayerLogin", root, function ( ) local playerTag , playerColor = getPlayerTag ( source ) if ( playerTag and playerColor ) then setElementData ( source , "tag" , playerTag ) setElementData ( source , "colour" , playerColor ) end end ) Edited August 1, 2017 by Abdul KariM 2 Link to comment
SaedAmer Posted August 1, 2017 Author Share Posted August 1, 2017 On 01/08/2017 at 21:41, Abdul KariM said: executeSQLQuery("CREATE TABLE IF NOT EXISTS PlayersTag (player, serial, tag, colour)") addEventHandler("onPlayerChat",root,function (msg) local tag = getElementData(source,"tag") or 'player' local colour = getElementData(source,"colour") or '#FFFFFF' outputChatBox("#FF0000 # #FFFFFF[ #CD0000"..tag .."#FFFFFF ]x #A5A5A5".. getPlayerName(source) .. ""..colour.." : ".. msg.."",root, 255, 255, 255, true) return cancelEvent() end) function getPlayerTag ( player ) local playerSerial = player and getPlayerSerial ( player ) local playerResult = executeSQLQuery("SELECT * FROM PlayersTag WHERE serial = ? ", playerSerial ) if ( #playerResult ~= 0 and type ( playerResult ) == "table" ) then return playerResult [ 1 ] [ "tag" ] , playerResult [ 1 ] [ "colour" ] end return false end function savePlayerTag ( player ) local playerSerial = player and getPlayerSerial ( player ) local playerTag = getElementData ( player , "tag" ) or false local playerColor = getElementData ( player , "colour" ) or false local playerName = getPlayerName ( player ) if ( not playerTag or not playerColor ) then return false end if ( getPlayerTag ( player ) ~= false ) then executeSQLQuery("UPDATE PlayersTag SET player=?,tag=?,colour=? WHERE serial=?", playerName, playerTag, playerColor,playerSerial) else executeSQLQuery("INSERT INTO PlayersTag(player, serial, tag, colour) VALUES(?,?,?,?)", playerName, playerSerial, playerTag, playerColor) return true end return false end addEventHandler("onPlayerQuit", root, function ( ) savePlayerTag ( source ) end ) addEventHandler("onPlayerLogin", root, function ( ) local playerTag , playerColor = getPlayerTag ( source ) if ( playerTag and playerColor ) then setElementData ( source , "tag" , playerTag ) setElementData ( source , "colour" , playerColor ) end end ) Expand تمام تسلم اشتغل بس الحذف مش شغال في تعديل علي الكود ولا لازم اسوي كود حذف من قعدة البيانات ؟ ----- addEventHandler("onClientGUIClick",root,function() if(source == GUIEditor.button[2]) then if guiGetText (GUIEditor.edit[1]) ~= '' then setElementData (localPlayer,'tag',guiGetText (GUIEditor.edit[1])) setElementData (localPlayer,'colour',guiGetText (GUIEditor.edit[2])) end elseif(source == GUIEditor.button[1]) then setElementData (localPlayer,'tag',false) setElementData (localPlayer,'colour',false) end end) -------- Link to comment
Abdul KariM Posted August 1, 2017 Share Posted August 1, 2017 لو تبي تحذف التاج نهائي لازم من السكل Link to comment
SaedAmer Posted August 1, 2017 Author Share Posted August 1, 2017 On 01/08/2017 at 22:56, Abdul KariM said: لو تبي تحذف التاج نهائي لازم من السكل Expand كده ؟ كلنت ----- addEventHandler("onClientGUIClick",root,function() if(source == GUIEditor.button[2]) then if guiGetText (GUIEditor.edit[1]) ~= '' then setElementData (localPlayer,'tag',guiGetText (GUIEditor.edit[1])) setElementData (localPlayer,'colour',guiGetText (GUIEditor.edit[2])) end elseif(source == GUIEditor.button[1]) then setElementData (localPlayer,'tag',false) setElementData (localPlayer,'colour',false) triggerServerEvent("DelTag",localPlayer) end end) -------- سيرفر addEvent("noLocal",true) addEventHandler("noLocal", root, function() local tag = executeSQLQuery ( "DELETE tag FROM PlayersTag WHERE Serial =?", getPlayerSerial(source) ) local colour = executeSQLQuery ( "DELETE colour FROM PlayersTag WHERE Serial =?", getPlayerSerial(source) ) end ) Link to comment
Abdul KariM Posted August 1, 2017 Share Posted August 1, 2017 client addEventHandler("onClientGUIClick",root, function ( ) if( source == GUIEditor.button[2] ) then if guiGetText ( GUIEditor.edit[1] ) ~= '' then setElementData (localPlayer,'tag',guiGetText (GUIEditor.edit[1])) setElementData (localPlayer,'colour',guiGetText (GUIEditor.edit[2])) end elseif( source == GUIEditor.button[1] ) then triggerServerEvent("DelTag",localPlayer) end end ) server function DeletePlayerTag ( player ) if ( getPlayerTag ( player ) == false ) then return false end local playerSerial = getPlayerSerial ( player ) executeSQLQuery("DELETE FROM PlayersTag WHERE serial=?", playerSerial ) setElementData ( player , "tag" , false ) setElementData ( player , "colour" , false ) return true end addEvent("DelTag",true) addEventHandler("DelTag", root, function ( ) DeletePlayerTag ( source ) end ) 2 Link to comment
SaedAmer Posted August 2, 2017 Author Share Posted August 2, 2017 On 01/08/2017 at 23:19, Abdul KariM said: client server Expand تمام شكرا دلوقتي عاوز فكشانات عبارة عن لما اضغط علي لاعب من الجريد لست التاج يروحله هوا مش يجيلي انا Link to comment
Abdul KariM Posted August 2, 2017 Share Posted August 2, 2017 guiGridListGetSelectedItem guiGridListGetItemText getPlayerFromName triggerServerEvent setElementData 1 Link to comment
SaedAmer Posted August 2, 2017 Author Share Posted August 2, 2017 On 02/08/2017 at 00:13, Abdul KariM said: guiGridListGetSelectedItem guiGridListGetItemText getPlayerFromName triggerServerEvent setElementData Expand صح ؟ كلنت ---------- addEventHandler("onClientGUIClick",GUIEditor.button[1],function() local playerName = guiGridListGetItemText (GUIEditor.gridlist[1], guiGridListGetSelectedItem (GUIEditor.gridlist[1] ), 1 ) if playerName and guiGetText(GUIEditor.edit[1]) then triggerServerEvent("AddTag",localPlayer,playerName,guiGetText(GUIEditor.edit[1])) end end,false) سيرفر addEvent("AddTag",true) addEventHandler("AddTag", getRootElement(),function(Player,tag) local name = getPlayerFromName(Player) if name then setElementData (name,'tag',tag) end end) Link to comment
SaedAmer Posted August 2, 2017 Author Share Posted August 2, 2017 On 02/08/2017 at 00:27, Abdul KariM said: ليش ماتجرب ؟ Expand جربت ما شتغل و ما في شئ بالدي بق Link to comment
SaedAmer Posted August 2, 2017 Author Share Posted August 2, 2017 up مساعده شباب ----------------------- Link to comment
' A F . Posted August 3, 2017 Share Posted August 3, 2017 اذا حطيته اطلع وأدخل شوف يجيك ولا ؟ Link to comment
SaedAmer Posted August 3, 2017 Author Share Posted August 3, 2017 (edited) On 03/08/2017 at 00:24, Default said: اذا حطيته اطلع وأدخل شوف يجيك ولا ؟ Expand اخوي كود الحفط تمام اشتغل انا اتكلم علي ده On 02/08/2017 at 00:24, SaedAmer said: صح ؟ كلنت ---------- addEventHandler("onClientGUIClick",GUIEditor.button[1],function() local playerName = guiGridListGetItemText (GUIEditor.gridlist[1], guiGridListGetSelectedItem (GUIEditor.gridlist[1] ), 1 ) if playerName and guiGetText(GUIEditor.edit[1]) then triggerServerEvent("AddTag",localPlayer,playerName,guiGetText(GUIEditor.edit[1])) end end,false) سيرفر addEvent("AddTag",true) addEventHandler("AddTag", getRootElement(),function(Player,tag) local name = getPlayerFromName(Player) if name then setElementData (name,'tag',tag) end end) Expand هذا لما اختار لاعب من الجريد لست و اكتب في التاج و الون و اضغط البوتن التاج يروح للاعب الي انا محدده ---- جربت الكود ماشتغل ولا طلع شئ بالديب بق Edited August 3, 2017 by SaedAmer Link to comment
' A F . Posted August 3, 2017 Share Posted August 3, 2017 -- # Client addEventHandler ( "onClientGUIClick" , root , function ( ) if ( source == GUIEditor.button[1] ) then local sel = guiGridListGetSelectedItem ( GUIEditor.gridlist[1] ) ; if ( sel ~= 0 and guiGetText ( GUIEditor.edit[1] ) ~= "" ) then triggerServerEvent ( "AddTag" , localPlayer , guiGridListGetItemText ( GUIEditor.gridlist[1] , sel , 1 ) , guiGetText ( GUIEditor.edit[1] ) ); end end end ); -- # Server addEvent("AddTag",true) addEventHandler("AddTag", root , function ( plr , value ) if ( getPlayerFromName ( plr ) ) then setElementData ( getPlayerFromName ( plr ) , "tag" , value ) ; savePlayerTag ( getPlayerFromName ( plr ) ) end end) 1 Link to comment
SaedAmer Posted August 3, 2017 Author Share Posted August 3, 2017 On 03/08/2017 at 00:39, Default said: Expand جربت الكود محصلش حاجة نفس الكلام + التاج مش بيتمسح و طبعا اذا تفيط المود مقدر اتكلم بالشات دي الاكواد كاملة بدون الوحة كلنت ------- guiGridListAddColumn(GUIEditor.gridlist[1], "Players", 0.9) GUIEditor.edit[1] = guiCreateEdit(250, 32, 171, 31, "التاج", false, GUIEditor.window[1]) GUIEditor.edit[2] = guiCreateEdit(250, 70, 171, 32, "#FFFFFF", false, GUIEditor.window[1]) ---------- addEventHandler ( "onClientGUIClick" , root , function ( ) if ( source == GUIEditor.button[1] ) then local sel = guiGridListGetSelectedItem ( GUIEditor.gridlist[1] ) ; if ( sel ~= 0 and guiGetText ( GUIEditor.edit[1] ) ~= "" ) then triggerServerEvent ( "AddTag" , localPlayer , guiGridListGetItemText ( GUIEditor.gridlist[1] , sel , 1 ) , guiGetText ( GUIEditor.edit[1] ) ); end end end ); function update () guiGridListClear(GUIEditor.gridlist[1]) for i,v in ipairs (getElementsByType("player")) do local rp = guiGridListAddRow (GUIEditor.gridlist[1]) guiGridListSetItemText (GUIEditor.gridlist[1],rp,1,getPlayerName(v),false,false) end end addEventHandler ("onClientResourceStart",resourceRoot,update) addEventHandler ("onClientPlayerJoin",root,update) addEventHandler ("onClientPlayerChangeNick",root,update) addEventHandler ("onClientPlayerQuit",root,update) -------------- addEventHandler( 'onClientGUIClick', root, function() if (source == GUIEditor.button[2]) then outputChatBox('# [TagSystem]: تم تفعيل التاج ',0,255,0,true ) end end ) addEventHandler( 'onClientGUIClick', root, function() if (source == GUIEditor.button[1]) then outputChatBox('# [TagSystem]: تم ارجاع التاج كما كان ',255,0,0,true ) end end ) addEventHandler("onClientGUIClick",root, function ( ) if( source == GUIEditor.button[2] ) then if guiGetText ( GUIEditor.edit[1] ) ~= '' then setElementData (localPlayer,'tag',guiGetText (GUIEditor.edit[1])) setElementData (localPlayer,'colour',guiGetText (GUIEditor.edit[2])) end elseif( source == GUIEditor.button[1] ) then triggerServerEvent("DelTag",localPlayer) end end ) outputChatBox('# [TagSystem]: Created By #S3eeD',0,255,0,true ) سيرفر addEvent("AddTag",true) addEventHandler("AddTag", root , function ( plr , value ) if ( getPlayerFromName ( plr ) ) then setElementData ( getPlayerFromName ( plr ) , "tag" , value ) ; savePlayerTag ( getPlayerFromName ( plr ) ) end end) executeSQLQuery("CREATE TABLE IF NOT EXISTS PlayersTag (player, serial, tag, colour)") addEventHandler("onPlayerChat",root,function (msg) local tag = getElementData(source,"tag") or 'player' local colour = getElementData(source,"colour") or '#FFFFFF' outputChatBox("#FF0000 # #FFFFFF[ #CD0000"..tag .."#FFFFFF ]x #A5A5A5".. getPlayerName(source) .. ""..colour.." : ".. msg.."",root, 255, 255, 255, true) return cancelEvent() end) ------------ function getPlayerTag ( player ) local playerSerial = player and getPlayerSerial ( player ) local playerResult = executeSQLQuery("SELECT * FROM PlayersTag WHERE serial = ? ", playerSerial ) if ( #playerResult ~= 0 and type ( playerResult ) == "table" ) then return playerResult [ 1 ] [ "tag" ] , playerResult [ 1 ] [ "colour" ] end return false end function savePlayerTag ( player ) local playerSerial = player and getPlayerSerial ( player ) local playerTag = getElementData ( player , "tag" ) or false local playerColor = getElementData ( player , "colour" ) or false local playerName = getPlayerName ( player ) if ( not playerTag or not playerColor ) then return false end if ( getPlayerTag ( player ) ~= false ) then executeSQLQuery("UPDATE PlayersTag SET player=?,tag=?,colour=? WHERE serial=?", playerName, playerTag, playerColor,playerSerial) else executeSQLQuery("INSERT INTO PlayersTag(player, serial, tag, colour) VALUES(?,?,?,?)", playerName, playerSerial, playerTag, playerColor) return true end return false end addEventHandler("onPlayerQuit", root, function ( ) savePlayerTag ( source ) end ) addEventHandler("onPlayerLogin", root, function ( ) local playerTag , playerColor = getPlayerTag ( source ) if ( playerTag and playerColor ) then setElementData ( source , "tag" , playerTag ) setElementData ( source , "colour" , playerColor ) end end ) ------------- function DeletePlayerTag ( player ) if ( getPlayerTag ( player ) == false ) then return false end local playerSerial = getPlayerSerial ( player ) executeSQLQuery("DELETE FROM PlayersTag WHERE serial=?", playerSerial ) setElementData ( player , "tag" , false ) setElementData ( player , "colour" , false ) return true end addEvent("DelTag",true) addEventHandler("DelTag", root, function ( ) DeletePlayerTag ( source ) end ) Link to comment
' A F . Posted August 3, 2017 Share Posted August 3, 2017 addEvent("AddTag",true) addEventHandler("AddTag", root , function ( plr , value ) if ( getPlayerFromName ( plr ) ) then setElementData ( getPlayerFromName ( plr ) , "tag" , value ) ; savePlayerTag ( getPlayerFromName ( plr ) ) outputChatBox("Right!",source,100,100,100,true) end end) شوف يجيك بالشات ولا Link to comment
SaedAmer Posted August 3, 2017 Author Share Posted August 3, 2017 On 03/08/2017 at 01:18, Default said: addEvent("AddTag",true)addEventHandler("AddTag", root , function ( plr , value )if ( getPlayerFromName ( plr ) ) then setElementData ( getPlayerFromName ( plr ) , "tag" , value ) ;savePlayerTag ( getPlayerFromName ( plr ) ) outputChatBox("Right!",source,100,100,100,true)endend) شوف يجيك بالشات ولا Expand ماجاتش حاجة بالشات Link to comment
SaedAmer Posted August 3, 2017 Author Share Posted August 3, 2017 On 03/08/2017 at 01:40, Default said: الخطا منك اجل Expand مني كيف مافهمت Link to comment
SaedAmer Posted August 3, 2017 Author Share Posted August 3, 2017 كلنت GUIEditor = { edit = {}, button = {}, window = {}, label = {}, gridlist = {} } addEventHandler("onClientResourceStart", resourceRoot, function() local screenW, screenH = guiGetScreenSize() GUIEditor.window[1] = guiCreateWindow((screenW - 431) / 2, (screenH - 402) / 2, 431, 402, "Tag Panel", false) guiWindowSetSizable(GUIEditor.window[1], false) guiSetProperty(GUIEditor.window[1], "CaptionColour", "FFFFFEFE") GUIEditor.gridlist[1] = guiCreateGridList(9, 22, 230, 370, false, GUIEditor.window[1]) guiGridListAddColumn(GUIEditor.gridlist[1], "Players", 0.9) GUIEditor.edit[1] = guiCreateEdit(250, 32, 171, 31, "التاج", false, GUIEditor.window[1]) GUIEditor.edit[2] = guiCreateEdit(250, 70, 171, 32, "#FFFFFF", false, GUIEditor.window[1]) GUIEditor.button[1] = guiCreateButton(246, 325, 75, 29, "حذف", false, GUIEditor.window[1]) guiSetProperty(GUIEditor.button[1], "NormalTextColour", "FFFFFEFE") GUIEditor.button[2] = guiCreateButton(346, 325, 75, 29, "تفعيل", false, GUIEditor.window[1]) guiSetProperty(GUIEditor.button[2], "NormalTextColour", "FFFFFEFE") GUIEditor.label[1] = guiCreateLabel(316, 373, 99, 19, "Created By #S3eeD", false, GUIEditor.window[1]) guiLabelSetColor(GUIEditor.label[1], 225, 0, 0) guiSetVisible( GUIEditor.window[1], false) end ) addEvent ( 'open', true ) addEventHandler ( 'open', root, function ( ) if guiGetVisible (GUIEditor.window[1]) then guiSetVisible (GUIEditor.window[1], false ) showCursor ( false ) guiSetInputEnabled ( false ) else guiSetVisible (GUIEditor.window[1], true ) showCursor ( true ) guiSetInputEnabled ( true ) end end ) ---------- addEvent("AddTag",true) addEventHandler("AddTag", root , function ( plr , value ) if ( getPlayerFromName ( plr ) ) then setElementData ( getPlayerFromName ( plr ) , "tag" , value ) ; savePlayerTag ( getPlayerFromName ( plr ) ) outputChatBox("Right!",source,100,100,100,true) end end) function update () guiGridListClear(GUIEditor.gridlist[1]) for i,v in ipairs (getElementsByType("player")) do local rp = guiGridListAddRow (GUIEditor.gridlist[1]) guiGridListSetItemText (GUIEditor.gridlist[1],rp,1,getPlayerName(v),false,false) end end addEventHandler ("onClientResourceStart",resourceRoot,update) addEventHandler ("onClientPlayerJoin",root,update) addEventHandler ("onClientPlayerChangeNick",root,update) addEventHandler ("onClientPlayerQuit",root,update) -------------- addEventHandler( 'onClientGUIClick', root, function() if (source == GUIEditor.button[2]) then outputChatBox('# [TagSystem]: تم تفعيل التاج ',0,255,0,true ) end end ) addEventHandler( 'onClientGUIClick', root, function() if (source == GUIEditor.button[1]) then outputChatBox('# [TagSystem]: تم ارجاع التاج كما كان ',255,0,0,true ) end end ) addEventHandler("onClientGUIClick",root, function ( ) if( source == GUIEditor.button[2] ) then if guiGetText ( GUIEditor.edit[1] ) ~= '' then setElementData (localPlayer,'tag',guiGetText (GUIEditor.edit[1])) setElementData (localPlayer,'colour',guiGetText (GUIEditor.edit[2])) end elseif( source == GUIEditor.button[1] ) then triggerServerEvent("DelTag",localPlayer) end end ) outputChatBox('# [TagSystem]: Created By #S3eeD',0,255,0,true ) سيرفر addCommandHandler ( 'open', function ( thePlayer ) accName = getAccountName ( getPlayerAccount ( thePlayer ) ) if isObjectInACLGroup ('user.'..accName, aclGetGroup ( "Console" ) ) then triggerClientEvent( thePlayer, 'open', thePlayer ) else outputChatBox ( "* You Don't Have Permissions !!", thePlayer, 255, 0, 0, true ) end end ) addEvent("AddTag",true) addEventHandler("AddTag", root , function ( plr , value ) if ( getPlayerFromName ( plr ) ) then setElementData ( getPlayerFromName ( plr ) , "tag" , value ) ; savePlayerTag ( getPlayerFromName ( plr ) ) end end) executeSQLQuery("CREATE TABLE IF NOT EXISTS PlayersTag (player, serial, tag, colour)") addEventHandler("onPlayerChat",root,function (msg) local tag = getElementData(source,"tag") or 'player' local colour = getElementData(source,"colour") or '#FFFFFF' outputChatBox("#FF0000 # #FFFFFF[ #CD0000"..tag .."#FFFFFF ]x #A5A5A5".. getPlayerName(source) .. ""..colour.." : ".. msg.."",root, 255, 255, 255, true) return cancelEvent() end) ------------ function getPlayerTag ( player ) local playerSerial = player and getPlayerSerial ( player ) local playerResult = executeSQLQuery("SELECT * FROM PlayersTag WHERE serial = ? ", playerSerial ) if ( #playerResult ~= 0 and type ( playerResult ) == "table" ) then return playerResult [ 1 ] [ "tag" ] , playerResult [ 1 ] [ "colour" ] end return false end function savePlayerTag ( player ) local playerSerial = player and getPlayerSerial ( player ) local playerTag = getElementData ( player , "tag" ) or false local playerColor = getElementData ( player , "colour" ) or false local playerName = getPlayerName ( player ) if ( not playerTag or not playerColor ) then return false end if ( getPlayerTag ( player ) ~= false ) then executeSQLQuery("UPDATE PlayersTag SET player=?,tag=?,colour=? WHERE serial=?", playerName, playerTag, playerColor,playerSerial) else executeSQLQuery("INSERT INTO PlayersTag(player, serial, tag, colour) VALUES(?,?,?,?)", playerName, playerSerial, playerTag, playerColor) return true end return false end addEventHandler("onPlayerQuit", root, function ( ) savePlayerTag ( source ) end ) addEventHandler("onPlayerLogin", root, function ( ) local playerTag , playerColor = getPlayerTag ( source ) if ( playerTag and playerColor ) then setElementData ( source , "tag" , playerTag ) setElementData ( source , "colour" , playerColor ) end end ) ------------- function DeletePlayerTag ( player ) if ( getPlayerTag ( player ) == false ) then return false end local playerSerial = getPlayerSerial ( player ) executeSQLQuery("DELETE FROM PlayersTag WHERE serial=?", playerSerial ) setElementData ( player , "tag" , false ) setElementData ( player , "colour" , false ) return true end addEvent("DelTag",true) addEventHandler("DelTag", root, function ( ) DeletePlayerTag ( source ) end ) Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now