Image

[2012-11-25 19:43:27] ERROR: account_manager\s_account_functions.lua:39: bad argument #1 to 'pairs' (table expected, got number)

[2012-11-25 19:31:50] ERROR: account_manager\s_account_functions.lua:39: attempt to call a number value Line 39: for result, row in mysql:rowsAssoc ( query ) do

Yes.

Christopher2

Yes.

[2012-11-25 18:54:33] ERROR: account_manager\s_account_functions.lua:38: attempt to concatenate field 'Name' (a nil value)

Nothing. No output.

-

[2012-11-25 17:50:11] ERROR: account_manager\s_account_functions.lua:54: attempt to index field '?' (a nil value) I've already tried it.

[2012-11-25 17:51:15] ERROR: account_manager\s_account_functions.lua:54: attempt to index local 'query' (a number value) with outputConsole ( peds [ i ] [ "Name" ] ) Christopher Christopher There is 2 characters in the database. Christopher and Christopher2

How can i load all characters?

Yes. When there are x characters in the database, the server loads the first character x times in the table.

-

-

My mistake. It works. Thank you very much.

[2012-11-24 22:18:14] ERROR: Client triggered serverside event onClientLoginRequest, but event is not added serverside mysql = exports.database function createAccount(username, email, password) local query = mysql:query("SELECT * FROM `Accounts` WHERE `Username` = '" .. mysql:escapeString(username) .. "'") if (username) and (username~="") then if (mysql:numRows(query) == 0) or (getAccount(username)) then if (password) and (password~="") then local query = mysql:query("INSERT INTO `Accounts` (Username, Email, Password) VALUES ('" .. mysql:escapeString(username) .. "', '" .. mysql:escapeString(email) .. "', '" .. mysql:escapeString(password) .. "')") addAccount(username, password) exports.box:showBoxS ("info","Sikeresen regisztráltál, most kérlek jelentkezz be.") else exports.box:showBoxS ("error","Nem adtál meg jelszót.") end else exports.box:showBoxS ("error","A megadott felhasználónév foglalt.") end else exports.box:showBoxS ("error","Nem adtál meg felhasználónevet.") end mysql:freeResult(query) end addEvent("createAccount", true) addEventHandler("createAccount", getRootElement(), createAccount) function onClientLoginRequest(thePlayer, nickname, password) if (nickname) and (nickname~="") then if (password) and (password~="") then local query = mysql:query("SELECT * FROM `Accounts` WHERE `Username` = '" .. mysql:escapeString(nickname) .. "' AND `Password` = '" .. mysql:escapeString(password) .. "'") if (mysql:numRows(query) == 1) then local sourceAccount = getPlayerAccount(thePlayer) if not isGuestAccount(sourceAccount) then exports.box:showBoxS(thePlayer,"error","Már be vagy jelentkezve.") else local account = getAccount(nickname, password) if (account ~= false) then local data = mysql:fetchRow(query) local query = mysql:query("SELECT * FROM `Characters` WHERE `AccountID` = '" .. data[1] .. "'") if (mysql:numRows(query) > 0) then local peds = {} local rows = mysql:numRows(query) for i = 0, rows do peds[i] = {} outputChatBox ( "Index: ".. i ..": ".. tostring ( peds[i] ) ) peds[i]["CharacterID"] = data[1] peds[i]["AccountID"] = data[2] peds[i]["Name"] = data[3] peds[i]["Gender"] = data[4] peds[i]["Age"] = data[5] peds[i]["Skin"] = data[6] peds[i]["PosX"] = data[7] peds[i]["PosY"] = data[8] peds[i]["PosZ"] = data[9] peds[i]["Dimension"] = data[10] peds[i]["Interior"] = data[11] peds[i]["Health"] = data[12] peds[i]["Armour"] = data[13] triggerClientEvent(thePlayer, "onSuccessLogin", getRootElement(), peds) logIn(thePlayer, account, password) exports.box:showBoxS(thePlayer,"info","Sikeresen bejelentkeztél.") else exports.box:showBoxS(thePlayer,"error","Nincs egyetlen karakter sem hozzárendelve ehhez az accounthoz. A játék megkezdése elott mindenképpen szükséged van legalább 1 karakterre, melyet weboldalunkon tudsz elkészíteni. ([url=http://www.sa-stories.net]http://www.sa-stories.net[/url])") end else exports.box:showBoxS(thePlayer,"error","A MySQL adatbázisban és a szerver belso adatbázisában található jelszavak nem egyeznek!\nJavaslat: A probléma megoldásához kérlek vedd fel a kapcsolatot egy adminisztrátorral.") end end else exports.box:showBoxS(thePlayer,"error","Helytelen bejelentkezési adatokat adtál meg.") end else exports.box:showBoxS(thePlayer,"error","Nem adtál meg jelszót.") end else exports.box:showBoxS(thePlayer,"error","Nem adtál meg felhasználónevet.") end mysql:freeResult(query) end addEvent("onClientLoginRequest", true) addEventHandler("onClientLoginRequest", getRootElement(), onClientLoginRequest) Line 72-73: addEvent("onClientLoginRequest", true) addEventHandler("onClientLoginRequest", getRootElement(), onClientLoginRequest)

Yes, i'm sure.

I don't know. E: Can you tell me a better way to store the mysql data in dynamic arrays? I have an account, and x characters on the database. I want to link the characters to the account, and load all of them in the same time. e.g. charData[char1]["data1"] charData[char1]["data2"] ... charData[char2]["data5"] ... charData[char6]["data1"] ... charData[char x]["data x"] Eh, my english sucks.

1. time: Index: 0: table: 02933A48 2 time: Index: 0: table: 0282DEE0 3. time: Index: 0: table: 0290A318 4. time: Index: 0: table: 02838190 5. time: Index: 0: table: 02837120 6. time Index: 0: table: 0283CA38 It makes a new table every time when it executes.

Error is still the same. But the line, where the error is, now 41. Line 41: peds[i][CharacterID] = data[1] P.S.: Sorry for my bad english. (Sometimes i use google translator)

mysql = exports.database function createAccount(username, email, password) local query = mysql:query("SELECT * FROM `Accounts` WHERE `Username` = '" .. mysql:escapeString(username) .. "'") if (username) and (username~="") then if (mysql:numRows(query) == 0) or (getAccount(username)) then if (password) and (password~="") then local query = mysql:query("INSERT INTO `Accounts` (Username, Email, Password) VALUES ('" .. mysql:escapeString(username) .. "', '" .. mysql:escapeString(email) .. "', '" .. mysql:escapeString(password) .. "')") addAccount(username, password) exports.box:showBoxS ("info","Sikeresen regisztráltál, most kérlek jelentkezz be.") else exports.box:showBoxS ("error","Nem adtál meg jelszót.") end else exports.box:showBoxS ("error","A megadott felhasználónév foglalt.") end else exports.box:showBoxS ("error","Nem adtál meg felhasználónevet.") end mysql:freeResult(query) end addEvent("createAccount", true) addEventHandler("createAccount", getRootElement(), createAccount) function onClientLoginRequest(thePlayer, nickname, password) if (nickname) and (nickname~="") then if (password) and (password~="") then local query = mysql:query("SELECT * FROM `Accounts` WHERE `Username` = '" .. mysql:escapeString(nickname) .. "' AND `Password` = '" .. mysql:escapeString(password) .. "'") if (mysql:numRows(query) == 1) then local sourceAccount = getPlayerAccount(thePlayer) if not isGuestAccount(sourceAccount) then exports.box:showBoxS(thePlayer,"error","Már be vagy jelentkezve.") else local account = getAccount(nickname, password) if (account ~= false) then local data = mysql:fetchRow(query) local query = mysql:query("SELECT * FROM `Characters` WHERE `AccountID` = '" .. data[1] .. "'") if (mysql:numRows(query) > 0) then local peds = {} local rows = mysql:numRows(query) for i = 0, rows do peds[i] = {} peds[i][CharacterID] = data[1] peds[i][AccountID] = data[2] peds[i][Name] = data[3] peds[i][Gender] = data[4] peds[i][Age] = data[5] peds[i][Skin] = data[6] peds[i][PosX] = data[7] peds[i][PosY] = data[8] peds[i][PosZ] = data[9] peds[i][Dimension] = data[10] peds[i][Interior] = data[11] peds[i][Health] = data[12] peds[i][Armour] = data[13] end triggerClientEvent(thePlayer, "onSuccessLogin", getRootElement(), peds) logIn(thePlayer, account, password) exports.box:showBoxS(thePlayer,"info","Sikeresen bejelentkeztél.") else exports.box:showBoxS(thePlayer,"error","Nincs egyetlen karakter sem hozzárendelve ehhez az accounthoz. A játék megkezdése előtt mindenképpen szükséged van legalább 1 karakterre, melyet weboldalunkon tudsz elkészíteni. ([url=http://www.sa-stories.net]www.sa-stories.net[/url])") end else exports.box:showBoxS(thePlayer,"error","A MySQL adatbázisban és a szerver belső adatbázisában található jelszavak nem egyeznek!\nJavaslat: A probléma megoldásához kérlek vedd fel a kapcsolatot egy adminisztrátorral.") end end else exports.box:showBoxS(thePlayer,"error","Helytelen bejelentkezési adatokat adtál meg.") end else exports.box:showBoxS(thePlayer,"error","Nem adtál meg jelszót.") end else exports.box:showBoxS(thePlayer,"error","Nem adtál meg felhasználónevet.") end mysql:freeResult(query) end addEvent("onClientLoginRequest", true) addEventHandler("onClientLoginRequest", getRootElement(), onClientLoginRequest)

I get the same error message.

local peds = {} E: Here's the full code. mysql = exports.database function createAccount(username, email, password) local query = mysql:query("SELECT * FROM `Accounts` WHERE `Username` = '" .. mysql:escapeString(username) .. "'") if (username) and (username~="") then if (mysql:numRows(query) == 0) or (getAccount(username)) then if (password) and (password~="") then local query = mysql:query("INSERT INTO `Accounts` (Username, Email, Password) VALUES ('" .. mysql:escapeString(username) .. "', '" .. mysql:escapeString(email) .. "', '" .. mysql:escapeString(password) .. "')") addAccount(username, password) exports.box:showBoxS ("info","Sikeresen regisztráltál, most kérlek jelentkezz be.") else exports.box:showBoxS ("error","Nem adtál meg jelszót.") end else exports.box:showBoxS ("error","A megadott felhasználónév foglalt.") end else exports.box:showBoxS ("error","Nem adtál meg felhasználónevet.") end mysql:freeResult(query) end addEvent("createAccount", true) addEventHandler("createAccount", getRootElement(), createAccount) function onClientLoginRequest(thePlayer, nickname, password) if (nickname) and (nickname~="") then if (password) and (password~="") then local query = mysql:query("SELECT * FROM `Accounts` WHERE `Username` = '" .. mysql:escapeString(nickname) .. "' AND `Password` = '" .. mysql:escapeString(password) .. "'") if (mysql:numRows(query) == 1) then local sourceAccount = getPlayerAccount(thePlayer) if not isGuestAccount(sourceAccount) then exports.box:showBoxS(thePlayer,"error","Már be vagy jelentkezve.") else local account = getAccount(nickname, password) if (account ~= false) then local data = mysql:fetchRow(query) local query = mysql:query("SELECT * FROM `Characters` WHERE `AccountID` = '" .. data[1] .. "'") if (mysql:numRows(query) > 0) then local peds = {} peds[i] = {} local rows = mysql:numRows(query) for i = 0, rows do peds[i][CharacterID] = data[1] peds[i][AccountID] = data[2] peds[i][Name] = data[3] peds[i][Gender] = data[4] peds[i][Age] = data[5] peds[i][Skin] = data[6] peds[i][PosX] = data[7] peds[i][PosY] = data[8] peds[i][PosZ] = data[9] peds[i][Dimension] = data[10] peds[i][Interior] = data[11] peds[i][Health] = data[12] peds[i][Armour] = data[13] end triggerClientEvent(thePlayer, "onSuccessLogin", getRootElement(), peds) logIn(thePlayer, account, password) exports.box:showBoxS(thePlayer,"info","Sikeresen bejelentkeztél.") else exports.box:showBoxS(thePlayer,"error","Nincs egyetlen karakter sem hozzárendelve ehhez az accounthoz. A játék megkezdése előtt mindenképpen szükséged van legalább 1 karakterre, melyet weboldalunkon tudsz elkészíteni. ([url=http://www.sa-stories.net]www.sa-stories.net[/url])") end else exports.box:showBoxS(thePlayer,"error","A MySQL adatbázisban és a szerver belső adatbázisában található jelszavak nem egyeznek!\nJavaslat: A probléma megoldásához kérlek vedd fel a kapcsolatot egy adminisztrátorral.") end end else exports.box:showBoxS(thePlayer,"error","Helytelen bejelentkezési adatokat adtál meg.") end else exports.box:showBoxS(thePlayer,"error","Nem adtál meg jelszót.") end else exports.box:showBoxS(thePlayer,"error","Nem adtál meg felhasználónevet.") end mysql:freeResult(query) end addEvent("onClientLoginRequest", true) addEventHandler("onClientLoginRequest", getRootElement(), onClientLoginRequest)

Line 37: peds[i] = {}