The query itself has a problem.
function downloadPlayerAlternatexx(p, _)
local filename = exports.CSTmysql:query("SELECT * FROM skinsShaders")
if (#filename > 0 ) then
fetchRemote("http://localhost/shadersqsdqs/"..filename[1].shaderid..".jpg", checkPlayerAlternateSkin)
end
end
addCommandHandler("additsx", downloadPlayerAlternatexx)
Also you need to poll the result if you haven't.
That solution did not work.
I can see all servers, but I can't join them.It says connecting then MTA freezes (not responding) then simply Entering the game comes for 5-6 seconds then CD16, Connection Timed OUT
Still no answer.
@ccw please help, I'm unable to script or do a shit. , I am bored all these days.
I'm using SingTel as my ISP, it used to work so good. I think the problem is new router, as our router recently got upgraded to a new model by the ISP.
I'm having problem with every server, and I tried using VPN, it did not help.
BTW, yesterday AFTER TRYING 100 TIMES, I connected to SAES then I just disconnected the game and tried reconnecting, it did not work. Then trying 100 times I joined a server. It's pretty tough for me to test scripts as I can't even connect to my local server like wtf.
SQLite - Only one connection possible AFAIK.
MySQL - Many connections possible
SQLite - Stored in a file
MySQL - Stored in a file but more secure
MySQL if you want to use things from web, SQLite for small things would be nice too.
But MySQL is what I would go for.
Yeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees!
Yeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees!
Yeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees!
Yeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees!
Yeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees!
Yeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees!
This is what you call real spam!
i didn't understand you .. , how to save the PNG/JPEG ? , where should i put the '@', can you make an example using my code?, and thanks
You probably can't do that. But you can make a texture and load it as shader as I told. See the example.
fetchRemote is not for downloading files. Use downloadFile instead. fetchRemote is used for POST and GET requests.
After seeing the examples, reliazed that you can do that. You can use the example. You can create a texture using it client side and draw it then.. or apply it.
function loadDatabase(qh)
local res = dbPoll(qh, 0)
for i, o in ipairs(res) do
local result = o.u_text
triggerClientEvent("addUpdatesFromDatabase", root, result)
end
end
dbQuery(loadDatabase, {}, connect, "SELECT * FROM updates_table")