help

[Adham]

hi all i want save text in gridlist

but no want save and no db3

client :

triggerServerEvent("load:Columns",localPlayer,localPlayer) 

function Click ( btn )
            if ( source == GUIEditor.checkbox[1] ) then
            guiCheckBoxSetSelected ( GUIEditor.checkbox[2], not guiCheckBoxGetSelected ( source ) )
            elseif ( source == GUIEditor.checkbox[2] ) then
            guiCheckBoxSetSelected ( GUIEditor.checkbox[1], not guiCheckBoxGetSelected ( source ) )
        end
       if btn == "left" then
                   if ( source == GUIEditor.button[1] ) then
               local item = guiComboBoxGetSelected ( com )    
                       local card = guiComboBoxGetItemText( com, item )
               local name, email, number = guiGetText ( GUIEditor.edit[1] ), guiGetText ( GUIEditor.edit[2] ), guiGetText ( GUIEditor.edit[3] )
               if name == "" or number == "" or card == "" or email == "" then return end
                   triggerServerEvent ( "RentSystem:onCreateNewOrder", localPlayer, name, email, number, card )
               guiSetEnabled ( GUIEditor.button[1], false )
                       outMsg ( "تم إرسال الرسالة.", true )
end
end
addEventHandler ( 'onClientGUIClick', root, Click )



addEvent ( "RentSystem:onSendSubscribePlayers", true )
addEventHandler ( "RentSystem:onSendSubscribePlayers", root,
 function ( name, email, number, card, Serial, player )
            local row = guiGridListAddRow ( GUIEditor.gridlist[4] )
               guiGridListSetItemText( GUIEditor.gridlist[4], row, 1,player,false, false)
               guiGridListSetItemText(GUIEditor.gridlist[4], row, 4, Serial , false, false)
               guiGridListSetItemText(GUIEditor.gridlist[4], row, 2, card, false, false)
               guiGridListSetItemColor ( GUIEditor.gridlist[4], row, 1, 255, 255, 0 )
               guiGridListSetItemColor ( GUIEditor.gridlist[4], row, 2, 255, 255, 0 )
               guiGridListSetItemColor ( GUIEditor.gridlist[4], row, 3, 255, 255, 0 )
               guiGridListSetItemColor ( GUIEditor.gridlist[4], row, 4, 255, 255, 0 )
      end
 )    



server



addEventHandler ("onResourceStart", resourceRoot,
function () 
executeSQLQuery ("CREATE TABLE IF NOT EXISTS `Rent_system` (serial,player,card,Serial)")
end
) 
addEvent ( "load:Columns", true ) 
addEventHandler ( "load:Columns", root,
    function ( player ) 
        local result = executeSQLQuery ( "SELECT * FROM `Rent_System` WHERE `serial` = ?", getPlayerSerial (player) ) 
        if ( result and #result == 0 ) then return end
        triggerClientEvent ( player, "RentSystem:onSendSubscribePlayers", player, result ) 
    end
)

addEvent("RentSystem:onCreateNewOrder",true) 
addEventHandler("RentSystem:onCreateNewOrder",root,
    function ( name, email, number, card ) 
                  if ( name and email and number and card ) then
                  local player = getPlayerName ( source )
                  local Serial = getPlayerSerial ( source )
          local result = executeSQLQuery ( "SELECT * FROM `Rent_system` WHERE `serial` = ?", getPlayerSerial (player) ) 
          if ( result and #result == 0 ) then 
                        executeSQLQuery("INSERT INTO `Rent_system` (serial,player,card,Serial) VALUES(?,?,?,?)",getPlayerSerial(source),player,card,serial) 
        end
    end
)  

 

Edited January 26, 2017 by Deativated

[Adham]

...