Help Please!

[Annas]

Hey all.

I have a problem on this code:

function downloadPlayerAlternateSkin (p, _) 
    local filename = exports.CSTmysql:query("SELECT * FROM Skins") 
    for i=1, #filename do 
    local theskinId = filename[i].skinid 
    outputDebugString("filename[i] = ".. tostring(filename[i])) 
    if theskinId then 
        fetchRemote("http://localhost/shadersqsdqs/"..theskinId..".jpg", checkPlayerAlternateSkinONLOGIN) 
    end 
    end 
end 
addCommandHandler("addskin", downloadPlayerAlternateSkin) 

Console: INFO: filename = table: 0xa9a3b40

Also it makes server lag (NETWORK TROUBLE) for 1min everytime i use that command '/addskin'.

Maybe there is something wrong on my function.. please help me

[denny199]

Well, how much skins do you have in your database?

If you have 100 skins, then you will make 100 requests to your webserver via fetchRemote

[Walid]

100 requests to your webserver via fetchRemote

Are you serious ?

[Annas]

100 requests to your webserver via fetchRemote

Are you serious ?

Help please..

Also ignore useless posts

[Captain Cody]

    function downloadPlayerAlternateSkin (p, _) 
        local filename = exports.CSTmysql:query("SELECT * FROM Skins") 
        for i=1, #filename do 
        local theskinId = filename[i].skinid 
        outputDebugString("filename[i] = ".. tostring(filename[i].skinid)) -- Not sure if this was what you intended to do, but here it was outputting a table as the string. 
  
        if theskinId then 
            fetchRemote("http://localhost/shadersqsdqs/"..theskinId..".jpg", checkPlayerAlternateSkinONLOGIN) 
        end 
        end 
    end 
    addCommandHandler("addskin", downloadPlayerAlternateSkin) 

Not sure if that's what you were trying to do, but some times small errors such as that will indeed freeze up the server.

[Annas]

    function downloadPlayerAlternateSkin (p, _) 
        local filename = exports.CSTmysql:query("SELECT * FROM Skins") 
        for i=1, #filename do 
        local theskinId = filename[i].skinid 
        outputDebugString("filename[i] = ".. tostring(filename[i].skinid)) -- Not sure if this was what you intended to do, but here it was outputting a table as the string. 
  
        if theskinId then 
            fetchRemote("http://localhost/shadersqsdqs/"..theskinId..".jpg", checkPlayerAlternateSkinONLOGIN) 
        end 
        end 
    end 
    addCommandHandler("addskin", downloadPlayerAlternateSkin) 

Not sure if that's what you were trying to do, but some times small errors such as that will indeed freeze up the server.

Not working

ScreenShot:

Debugscript:

Line 5: Attempt to concatenate local 'theskinId' (a nil value)