jessiepinkman

of course

factions_s local mysql = exports.mysql local result = mysql:query_fetch_assoc("SELECT * FROM factions") if result then outputChatBox ( "Factions OK" ) else outputChatBox ( "There are no factions :(" ) end while true do local row = mysql_fetch_row(result) if (not row) then break end outputChatBox ( row["name"] ) end end mysql/connection -- connection settings local hostname = get( "hostname" ) or "*******" local username = get( "username" ) or "*************" local password = get( "password" ) or "**********" local database = get( "database" ) or "***********" local port = tonumber( get( "port" ) ) or 3306 -- global things. local MySQLConnection = nil local resultPool = { } local queryPool = { } local sqllog = false local countqueries = 0 -- connectToDatabase - Internal function, to spawn a DB connection function connectToDatabase(res) MySQLConnection = mysql_connect(hostname, username, password, database, port) if (not MySQLConnection) then if (res == getThisResource()) then cancelEvent(true, "Cannot connect to the database.") end return nil end return nil end addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), connectToDatabase, false) -- destroyDatabaseConnection - Internal function, kill the connection if theres one. function destroyDatabaseConnection() if (not MySQLConnection) then return nil end mysql_close(MySQLConnection) return nil end addEventHandler("onResourceStop", getResourceRootElement(getThisResource()), destroyDatabaseConnection, false) -- do something usefull here function logSQLError(str) local message = str or 'N/A' outputDebugString("MYSQL ERROR "..mysql_errno(MySQLConnection) .. ": " .. mysql_error(MySQLConnection)) exports['logs']:logMessage("MYSQL ERROR [QUERY] " .. message .. " [ERROR] " .. mysql_errno(MySQLConnection) .. ": " .. mysql_error(MySQLConnection), 24) end function getFreeResultPoolID() local size = #resultPool if (size == 0) then return 1 end for index, query in ipairs(resultPool) do if (query == nil) then return index end end return (size + 1) end ------------ EXPORTED FUNCTIONS --------------- function ping() if (mysql_ping(MySQLConnection) == false) then -- FUU, NO MOAR CONNECTION destroyDatabaseConnection() connectToDatabase(nil) if (mysql_ping(MySQLConnection) == false) then logSQLError() return false end return true end return true end function escape_string(str) if (ping()) then return mysql_escape_string(MySQLConnection, str) end return false end function query(str) if sqllog then exports['logs']:logMessage(str, 24) end countqueries = countqueries + 1 if (ping()) then local result = mysql_query(MySQLConnection, str) if (not result) then logSQLError(str) return false end local resultid = getFreeResultPoolID() resultPool[resultid] = result queryPool[resultid] = str return resultid end return false end function unbuffered_query(str) if sqllog then exports['logs']:logMessage(str, 24) end countqueries = countqueries + 1 if (ping()) then local result = mysql_unbuffered_query(MySQLConnection, str) if (not result) then logSQLError(str) return false end local resultid = getFreeResultPoolID() resultPool[resultid] = result queryPool[resultid] = str return resultid end return false end function query_free(str) local queryresult = query(str) if not (queryresult == false) then free_result(queryresult) return true end return false end function rows_assoc(resultid) if (not resultPool[resultid]) then return false end return mysql_rows_assoc(resultPool[resultid]) end function fetch_assoc(resultid) if (not resultPool[resultid]) then return false end return mysql_fetch_assoc(resultPool[resultid]) end function free_result(resultid) if (not resultPool[resultid]) then return false end mysql_free_result(resultPool[resultid]) table.remove(resultPool, resultid) table.remove(queryPool, resultid) return nil end -- incase a nub wants to use it, FINE function result(resultid, row_offset, field_offset) if (not resultPool[resultid]) then return false end return mysql_result(resultPool[resultid], row_offset, field_offset) end function num_rows(resultid) if (not resultPool[resultid]) then return false end return mysql_num_rows(resultPool[resultid]) end function insert_id() return mysql_insert_id(MySQLConnection) or false end function query_fetch_assoc(str) local queryresult = query(str) if not (queryresult == false) then local result = fetch_assoc(queryresult) free_result(queryresult) return result end return false end function query_rows_assoc(str) local queryresult = query(str) if not (queryresult == false) then local result = rows_assoc(queryresult) free_result(queryresult) return result end return false end function query_insert_free(str) local queryresult = query(str) if not (queryresult == false) then local result = insert_id() free_result(queryresult) return result end return false end function escape_string(str) return mysql_escape_string(MySQLConnection, str) end function debugMode() if (sqllog) then sqllog = false else sqllog = true end return sqllog end function returnQueryStats() return countqueries -- maybe later more end function getOpenQueryStr( resultid ) if (not queryPool[resultid]) then return false end return queryPool[resultid] end Error: factions_s:11 bad argument #1 to 'mysql_fetch_row' (mysqlResult expected, got table) I just want to loop through all the factions, and display their names on chat.

You're the best

It's okay now, no errors but it's not giving me money

No, i just want to give player money from work

Okay, now it's saying: (Line 4 script_s) bad argument @'getElementData' [expected element at argument 1, got nil]

script_c [..] function strt() payment = 50 if not isElementWithinMarker(localPlayer, work) then return end local random = math.random(2, #places) local target = createMarker(places[random][1], places[random][2], places[random][3]-1.0, "cylinder", 1.0, 255, 0, 0) local blip = createBlipAttachedTo(cel, 12) addEventHandler("onClientMarkerHit", cel, function(el, md) if not md or getElementType(el) ~= "player" then return end if el ~= localPlayer then return end destroyElement(cel) destroyElement(blip) setElementFrozen(el, true) setPedAnimation ( localPlayer, "CARRY", "crry_prtial", 1,true ) setTimer(function() setElementFrozen(el, false) setPedAnimation(localPlayer, false) setElementData(localPlayer, "delivered", true) triggerServerEvent("getPlayerCredits", getRootElement(), payment) -- HERE end, 5000, 1) end) end script_s mysql = exports.mysql addEvent("getPlayerCredits",true) addEventHandler("getPlayerCredits", resourceRoot, payment function (payment) if getElementData(plr, "delivered") == true then exports.global:giveMoney(thePlayer,payment) outputChatBox("OK!",root,0,255,0) return end end) Error: Client triggered server side event getPlayerCredits, but event is not added serverside