Drakath

I get this error: Database query failed: no such column: Drakath local sql = { Query = executeSQLQuery }; sql.Query( "INSERT INTO myTable ( name, ID, city ) VALUES ( "..getAccountName(getPlayerAccount(source))..", "..ID..", "..city.." )" ); How come it recognizes a value as a column?

Thanks, onClientPickupHit worked.

I thought about this at first but is this really the only way? I can swear that I once saw a script that could trigger an event just for elements created by the same resource.

resourceRoot doesn't work.

How can I use onClientPlayerPickupHit event handler only for pickups created by the same resource? I tried: addEventHandler("onClientPlayerPickupHit", resourceRoot, handlePickups) but it doesn't trigger at all.

Pickup appears but when I hit it, it doesn't give me health points.

Peds can't launch projectiles. You have to create them manually using createProjectile()

I wonder why doesn't it work client-side though.

You are both wrong. function asd (t) local x, y, z = getElementPosition(t) createPickup(x+2, y+2, z, 0, 20) end addCommandHandler("mk", asd) Server side script with a working pickup. No event handlers necessary.

Can anyone confirm this? Somehow I find this wrong.

You can use multiple databases too.

I got a small problem. function asd () local x, y, z = getElementPosition(localPlayer) createPickup(x+2, y+2, z, 0, 20) end asd() When I hit this pickup, nothing happens. Why?

Did you set it to server side in meta.xml?

Thank you all for helping. It is solved.

What if table[randomIndex][2] can be either nil or true? local isTrue = not table[randomIndex][2] --if true it will convert to false if not isTrue then --if not false = true? Is that how it works?

I do know it's a nil but how can a script check if table[2][2] doesn't exist?

I did try those: if table[2][2] then if table[2][2]~=nil then but in both cases it's: ERROR: attempt to index field '?' (a nil value)

By default, it doesn't have a real-time protection. You need a Premium version for that. Are you using one?

Is there a way to check if a specific index value in a table exists? For example I have two tables: table = {{1,2},{1}} Script selects a random table. How can I check if table[randomTable][2] exists?

for i, team in ipairs(getElementsByType("team")) do local players = getPlayersInTeam (team) local teamName = getTeamName(team) for playerKey, playerValue in ipairs ( players ) do local playerName = getPlayerName(playerValue) local status = isPedDead(playerValue) --draw here end end

What you call an "example" is pretty much asking for a whole script. I doubt anyone will make it for free. If you want basic Lua scripts, look around the wiki.

Not exactly what I'm asking. I mean GTA:SA mapped houses in interior 0 (outside). Coordinates for markers at the doorstep of the house.

http://www.lua.org/pil/4.3.4.html http://www.lua.org/manual/5.1/manual.html#pdf-ipairs

getResourceState()