SQL Get A nil Result

[iPrestege]

Hello Guys Am Working On My Script But I Have Problem When Am Trying To Click To Show The Msg And Set The Memo To Player Who Send The Msg But I Get It Nil! Help Please!

-- Server --

  
addEvent ( "ReadMsg", true ) 
addEventHandler ( "ReadMsg", root, 
    function () 
        triggerClientEvent ( source,"ClientMsg",source,Number, Url, Serial ) 
    end 
) 

Am Already Have The SQL Table ;

executeSQLQuery ( "CREATE TABLE IF NOT EXISTS Receiving_System (Number,Url,Name,Serial)" ) 
executeSQLQuery ( "INSERT INTO `Receiving_System` ( `Number`, `Url`, `Serial`, `Name` ) VALUES ( ?, ?, ?, ? )", Number, Url, Serial, Name ) 

-- Client --

addEventHandler("onClientGUIDoubleClick",GUIEditor.gridlist[1], 
    function ( ) 
    if guiGridListGetSelectedItem(GUIEditor.gridlist[1]) == -1 then return end 
            triggerServerEvent("ReadMsg",localPlayer) 
    end,false 
) 
  
addEvent("ClientMsg",true) 
addEventHandler("ClientMsg",root, 
    function ( Number, Url, Serial ) 
        guiSetVisible(GUIEditor.window[3], true) 
        guiSetText(GUIEditor.memo[2],tostring(Serial)) 
    end 
) 

Thank's! in Advance!

[Castillo]

addEvent ( "ReadMsg", true ) 
addEventHandler ( "ReadMsg", root, 
    function () 
        triggerClientEvent ( source,"ClientMsg",source,Number, Url, Serial ) 
    end 
) 

Where are all these variables defined at?

[Tete omar]

addEvent ( "ReadMsg", true ) 
addEventHandler ( "ReadMsg", root, 
    function () 
        triggerClientEvent ( source,"ClientMsg",source,Number, Url, Serial ) 
    end 
) 

Where are all these variables defined at?

I think he forgot to pass them

[iPrestege]

addEvent ( "ReadMsg", true ) 
addEventHandler ( "ReadMsg", root, 
    function () 
        triggerClientEvent ( source,"ClientMsg",source,Number, Url, Serial ) 
    end 
) 

Where are all these variables defined at?

-- Client Side When Any Player Click The Send Msg Button --

addEventHandler("onClientGUIClick",getRootElement(), 
    function ( ) 
        if ( source == GUIEditor.button[1] ) then 
        local Number = guiGetText(GUIEditor.edit[1]) 
        local Url = guiGetText(GUIEditor.edit[2]) 
        local Name = getPlayerName(localPlayer) 
        local Serial = getPlayerSerial(localPlayer) 
            if ( Number == "" or Number == " " or Number == "  " or Number == "   " or Number == "  " ) then return outputChatBox("* Check Number!",255,0,0,true) end 
            if ( Url == "" or Url == " " or Url == "  " or Url == "   " or Url == "  "  ) then return  
                outputChatBox("* Check The Url!",255,0,0,true) end 
                triggerServerEvent("SendRequest",localPlayer,Number,Url,Name,Serial) 
                outputChatBox("* Send It!",0,255,0,true) 
                guiSetVisible(GUIEditor.window[1], false) 
                guiSetText(GUIEditor.edit[1]," ") 
                guiSetText(GUIEditor.edit[2]," ") 
                playSoundFrontEnd(11) 
        end 
    end 
) 

-- Full Server Code --

addEventHandler ( "onResourceStart", resourceRoot, 
    function ( ) 
        executeSQLQuery ( "CREATE TABLE IF NOT EXISTS Receiving_System (Number,Url,Name,Serial)" ) 
    end 
) 
  
function setReceiving_System ( Number, Url, Serial, Name ) 
    return executeSQLQuery ( "INSERT INTO `Receiving_System` ( `Number`, `Url`, `Serial`, `Name` ) VALUES ( ?, ?, ?, ? )", Number, Url, Serial, Name ) 
end 
  
function SelectFromSql ( ) 
    local data = executeSQLQuery ( "SELECT * FROM Receiving_System" ) 
    if ( type ( data ) == "table" and #data == 0) or not data then 
        return { } 
    else 
        return data 
    end 
end 
  
function UpDateListInSql ( element ) 
    if ( not isElement ( element ) ) then 
        return 
    end 
  
    local Upsql = SelectFromSql ( ) 
    triggerClientEvent ( element, "CreateListRequest", element, Upsql ) 
end 
  
addEvent ( "RefreshSQLData", true ) 
addEventHandler ( "RefreshSQLData", root, 
    function ( ) 
        UpDateListInSql ( source ) 
    end 
) 
  
addEvent ( "SendRequest", true ) 
addEventHandler ( "SendRequest", root, 
    function ( Number, Url, Serial, Name ) 
        setReceiving_System ( Number, Url, Serial, Name ) 
        triggerClientEvent ( root, "ListRequest", root, Number, Url, Serial, Name ) 
    end 
) 
addEvent ( "ReadMsg", true ) 
addEventHandler ( "ReadMsg", root, 
    function ( Number, Url, Serial, Name ) 
        triggerClientEvent ( source,"ClientMsg",source,Number, Url, Serial, Name) 
    end 
) 
  
  

[TAPL]

addEvent ( "SendRequest", true ) 
addEventHandler ( "SendRequest", root, 
    function ( Number, Url, Serial, Name ) 
        setReceiving_System ( Number, Url, Serial, Name ) 
        triggerClientEvent ( root, "ListRequest", root, Number, Url, Serial, Name ) 
    end 
) 

Name is before Serial.

triggerServerEvent("SendRequest",localPlayer,Number,Url,Name,Serial) 

[iPrestege]

addEvent ( "SendRequest", true ) 
addEventHandler ( "SendRequest", root, 
    function ( Number, Url, Serial, Name ) 
        setReceiving_System ( Number, Url, Serial, Name ) 
        triggerClientEvent ( root, "ListRequest", root, Number, Url, Serial, Name ) 
    end 
) 

Name is before Serial.

triggerServerEvent("SendRequest",localPlayer,Number,Url,Name,Serial) 

Hmmm.... i get the same "nil" but i have another problem now when i press send button show my serial on the grid and not my name?

[TAPL]

I didn't understand where you get nil.

Again at line 3 and line 8 (server side), Name is before Serial. Not sure if that actually an problem, but just fix it.

[iPrestege]

I didn't understand where you get nil.

Again at line 3 and line 8 (server side), Name is before Serial. Not sure if that actually an problem, but just fix it.

1- I Have A Gui Panel With Memo I Want To Set The Player Who Send The Msg Using Send Btn And if you want the full client script i can send it .

2- Yes i change it .

[MR.S3D]

Server

  
  
addEventHandler ( "onResourceStart", resourceRoot, 
    function ( ) 
        executeSQLQuery ( "CREATE TABLE IF NOT EXISTS Receiving_System (Number,Url,Name,Serial)" ) 
    end 
) 
  
function setReceiving_System ( Number, Url, Name, Serial ) 
    return executeSQLQuery ( "INSERT INTO `Receiving_System` ( `Number`, `Url`, `Name`, `Serial` ) VALUES ( ?, ?, ?, ? )", tostring( Number ), tostring ( Url ), tostring ( Name ), tostring ( Serial )) 
end 
  
function SelectFromSql ( ) 
    local data = executeSQLQuery ( "SELECT * FROM Receiving_System" ) 
    if ( type ( data ) == "table" and #data == 0) or not data then 
        return { } 
    else 
        return data 
    end 
end 
  
function UpDateListInSql ( element ) 
    if ( not isElement ( element ) ) then 
        return 
    end 
  
    local Upsql = SelectFromSql ( ) 
    triggerClientEvent ( element, "CreateListRequest", element, Upsql ) 
end 
  
addEvent ( "RefreshSQLData", true ) 
addEventHandler ( "RefreshSQLData", root, 
    function ( ) 
        UpDateListInSql ( source ) 
    end 
) 
  
addEvent ( "SendRequest", true ) 
addEventHandler ( "SendRequest", root, 
    function ( Number, Url, Name, Serial ) 
        setReceiving_System ( Number, Url, Name, Serial ) 
        triggerClientEvent ( root, "ListRequest", root, Number, Url, Serial, Name ) 
    end 
) 
addEvent ( "ReadMsg", true ) 
addEventHandler ( "ReadMsg", root, 
    function ( Number, Url, Serial, Name ) 
        triggerClientEvent ( source,"ClientMsg",source,Number, Url, Serial, Name) 
    end 
) 
  
  

[iPrestege]

-- Fixed

Edited April 21, 2013 by Guest

[Castillo]

Since you are clearing the list on line 83, the problem must be here:

        if pass then    
            local count = guiGridListGetRowCount (  GUIEditor.gridlist[1] ) + 1  
            local row = guiGridListAddRow ( GUIEditor.gridlist[1] ) 
            guiGridListSetItemText( GUIEditor.gridlist[1], row, 1,''..count..'-',false,false ) 
            guiGridListSetItemText ( GUIEditor.gridlist[1], row, 2,Name, false, false ) 
            guiGridListSetItemData ( GUIEditor.gridlist[1], row, 2, tostring (Serial)) 
        end  

[iPrestege]

Ah Yah Thank's Fixed And Work .

[Castillo]

You're welcome.