Forums

yep it's in debug now

Depending on what he wants string.gsub already should do the job.

Hi! I'm a beginner, so I don't really know what goes wrong in this scirpt, if someone can help me out here I would be very happy. So, as I said I'm a beginner and I tried to get an account system, I think I connected to the MySQL successfully. But here is the Problem! [Open the Spoiler to see the picture.]   I used Debugscript to know what is the problem . This was the original row. execute("UPDATE accounts SET x=?,y=?,z=?,interior=?,dimension=,health=?,armor=?,money=?,rotation=?,team=?,skin=?,weapons=? WHERE id=?",x,y,z,int,dim,health,armor,money,rotation,team,skin,weaponsStr,id) I tought the question mark was the problem, so I changed the money to '0' and I changed the life and the armor to '100' as well, by the way I'll insert here the edited row as well, so you can see what i did. execute("UPDATE accounts SET x=?,y=?,z=?,interior=?,dimension=?,health=100,armor=100,money=0,rotation=?,team=?,skin=?,weapons=? WHERE id=?",x,y,z,int,dim,health,armor,money,rotation,team,skin,weaponsStr,id) And here is the whole script, so you see more details. addEvent("onPlayerAttemptLogin",true) addEventHandler("onPlayerAttemptLogin",root, function(username,password) if (singleQuery("SELECT * FROM accounts WHERE username=? LIMIT 1",string.lower(username))) then local accData = singleQuery("SELECT * FROM accounts WHERE username=? AND password=? LIMIT 1",string.lower(username),sha256(password)) if (accData) then outputChatBox("Welcome back "..getPlayerName(source),source,0,255,0) setElementData(source,"accountID",accData.id) setElementData(source,"accountUsername",accData.username) fadeCamera(source,false,1.0,0,0,0) setTimer(fadeCamera,2000,1,source,true,1.0,0,0,0) setCameraTarget(source,source) showChat(source,true) showPlayerHudComponent(source,"radar",true) showPlayerHudComponent(source,"area_name",true) spawnPlayer(source,accData.x,accData.y,accData.z+1,accData.rotation,accData.skin,accData.interior,accData.dimension,accData.team) local weapons = fromJSON(accData.weapons) if (weapons) then for k,v in pairs(weapons) do giveWeapon(source,tonumber(k),tonumber(v)) end end if (accData.health == 0) then killPed(source) else setElementHealth(source,tonumber(accData.health)) end setPedArmor(source,tonumber(accData.armor)) setPlayerMoney(source,tonumber(accData.money)) setElementData(source,"isGuestAccount",false) triggerClientEvent(source,"closeLoginWindow",source) triggerEvent("onAccountPlayerLogin",source,accData.id,accData.username) log(source) --store the login data. else outputChatBox("Your username and/or password is incorrect!",source,255,0,0) end else outputChatBox("This username doesn't exist!",source,255,0,0) end end) addEvent("onPlayerAttemptRegister",true) addEventHandler("onPlayerAttemptRegister",root, function(username,password1,password2,email) if (singleQuery("SELECT username FROM accounts WHERE username=? LIMIT 1",string.lower(username))) then outputChatBox("This username is taken! please choose another!",source,255,0,0) else local x,y,z = 1450.32421875, -2287.287109375, 13.546875 if (execute("INSERT INTO accounts (username,password,email,serial,x,y,z,interior,dimension,skin,health) VALUES (?,?,?,?,?,?,?,?,?,?,?)",string.lower(username),sha256(password1),email,getPlayerSerial(source),x,y,z+1,0,0,0,100)) then outputChatBox("Your account was registered successfully!",source,0,255,0) triggerClientEvent(source,"switchToLogin",source) end end end) function log(player) if (player) then local serial = getPlayerSerial(player) local ip = getPlayerIP(player) local name = getPlayerName(player) local username = getElementData(player,"accountUsername") local timestamp = getRealTime().timestamp execute("INSERT INTO logs (username,playerName,serial,ip,timestamp) VALUES (?,?,?,?,?)",username,name,serial,ip,timestamp) end end function prepair() setElementData(source,"isGuestAccount",true) outputChatBox("Welcome to the server.",source,0,255,0) end addEventHandler("onPlayerJoin",root,prepair) function saveData() if not (getElementData(source,"isGuestAccount") == true) then x,y,z = getElementPosition(source) int,dim = getElementInterior(source),getElementDimension(source) health,armor = getElementHealth(source),getPedArmor(source) money = getPlayerMoney(source) rotation = getElementRotation(source) team = getTeamName(getPlayerTeam(soure)) skin = getElementModel(source) weapons = {} for i=0,12 do local wep = getPedWeapon(source,i) if (wep > 0) then local ammo = getPedTotalAmmo(source,i) if (ammo > 0) then table.insert(weapons,{wep,ammo}) end end end weaponsStr = toJSON(weapons) id = getElementData(source,"accountID") execute("UPDATE accounts SET x=?,y=?,z=?,interior=?,dimension=?,health=100,armor=100,money=0,rotation=?,team=?,skin=?,weapons=? WHERE id=?",x,y,z,int,dim,health,armor,money,rotation,team,skin,weaponsStr,id) else return false end end addEventHandler("onPlayerQuit",root,saveData) addEventHandler("onPlayerWasted",root,saveData) Thank you If you read this, I hope I didn't make this too long.

setPedAnimation(thePlayer, "ped", "seat_down", -1, false, false, false, false) The first "false" in that line above is for the loop, if you wrote it true it will activate the animation loop But if you wrote "false" it won't. But remember, the first false in this line is for the loop argument..  

I know I can do it that way, but what I'm asking is: I want to something like the server events and client event, I can trigger them anywhere using addEventHandler only, example, so I use "addEventHandler("onPlayerLogin", ...) not triggerEvent("onPlayerLogin", ...). So what I'm looking for I want to create a function that when it function an event handler named 'onSettingsChange' will activate.. function logins() outputChatBox("Welcome....", source) end addEventHandler("onPlayerJoin", root, logins) Here once the player join, the event handler functions right? I want to create like it but when the settings[A custom settings window I created..] change the event handler will function... If it still unclear, I want to create a function that I can trigger in another resource using addEventHandler