Hallo Comunity,
ich hab mal eine kleine Frage...
& zwar bei dem Ticket System von Extendet kommt ein MYSQL fehler...
Siehe:
Code
support/support_server.lua:108: bad argument #1 to 'mysql_num_rows' (mysqlResult expected, got nil)Die Zeile dazu:
Sprich die Funktion
Lua
function retrieveTicketList ( typ )
local player = client
-- Schnellhilfe
if vioGetElementData ( player, "adminlvl" ) >= 1 and typ == 1 then
if next ( fastHelpTickets ) then
triggerClientEvent ( player, "recieveTicketList", player, 1, fastHelpTickets )
else
triggerClientEvent ( player, "thereAreNoTickets", player )
end
-- Anfragen & Fragen
elseif ( typ == 2 and ticketPermitted[player] ) or ( vioGetElementData ( player, "adminlvl" ) >= 1 and typ == 3 ) then
local tickets = {}
local result = mysql_query ( handler, "SELECT name FROM tickets WHERE kathegory = '"..typ.."' ORDER BY date ASC LIMIT 10" )
local rows = mysql_num_rows ( result ) --Die Zeile is 1
if rows > 0 then
local data
for i = 1, rows do
data = mysql_fetch_assoc ( result )
tickets[data["name"]] = data["name"]
end
triggerClientEvent ( player, "recieveTicketList", player, 2, tickets )
else
triggerClientEvent ( player, "thereAreNoTickets", player )
end
mysql_free_result ( result )
end
end
addEvent ( "retrieveTicketList", true )
addEventHandler ( "retrieveTicketList", getRootElement(), retrieveTicketList )