Jump to content

supernovaa

Members
  • Posts

    12
  • Joined

  • Last visited

Details

  • Gang
    heroes

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

supernovaa's Achievements

Square

Square (6/54)

2

Reputation

  1. New city Project status: 20%
  2. Hi, guys! My problem with auto start. Im starting server, loaded 83 resources and not starting. Sorry for my bad English. Whats the problem? Console. [10:24:41] WARNING: Ignoring duplicate client file in resource 'sa_itemsystem': 'slot_hover.png' [10:24:44] Resources: 83 loaded, 0 failed [10:24:44] Server password set to 'flyphone' [10:24:44] MODULE: Loaded "MySQL 5.0 database module" (0.50) by "Alberto Alonso <[email protected]>" [10:24:44] MODULE: Loaded "SHA Module" (1.02) by "mabako" [10:24:44] MODULE: Loaded "Sockets Module" (1.10) by "Gamesnert, MCvarial & x86" [10:24:44] Starting resources... [10:24:44] Server started and is ready to accept connections! [10:24:44] To stop the server, type 'shutdown' or press Ctrl-C [10:24:44] Type 'help' for a list of commands. [10:24:44] Querying MTA master server... success! (Auto detected IP:109.110.151.161) Mtaserver.conf <module src="mta_mysql.dll" /> <module src="sha.dll" /> <module src="ml_sockets.dll" /> <reurce src="sa_sql" startup="1" /> <reurce src="sa_core" startup="1" protected="0" /> <reurce src="sa_accounts" startup="1" protected="0" /> <reurce src="sa_achi" startup="1" protected="0" /> <reurce src="sa_ad" startup="1" protected="0" /> <reurce src="sa_admin" startup="1" protected="0" /> <reurce src="sa_anims" startup="1" protected="0" /> <reurce src="sa_anticheat-system" startup="1" protected="0" /> <reurce src="sa_bank" startup="1" protected="0" /> <reurce src="sa_bankmap" startup="1" protected="0" /> <reurce src="sa_blur" startup="1" protected="0" /> <reurce src="sa_bone_attach" startup="1" protected="0" /> <reurce src="sa_box" startup="1" protected="0" /> <reurce src="sa_bw" startup="1" protected="0" /> <reurce src="sa_cache" startup="1" protected="0" /> <reurce src="sa_carshop" startup="1" protected="0" /> <reurce src="sa_charData" startup="1" protected="0" /> <reurce src="sa_charDataBase" startup="1" protected="0" /> <reurce src="sa_charID" startup="1" protected="0" /> <reurce src="sa_chat" startup="1" protected="0" /> <reurce src="sa_dashboard" startup="1" protected="0" /> <reurce src="sa_disco" startup="1" protected="0" /> <reurce src="sa_documents" startup="1" protected="0" /> <reurce src="sa_elevators" startup="1" protected="0" /> <reurce src="sa_engine" startup="1" protected="0" /> <reurce src="sa_fightstyle" startup="1" protected="0" /> <reurce src="sa_flappybirds" startup="1" protected="0" /> <reurce src="sa_freecam" startup="1" protected="0" /> <reurce src="sa_freecam-tv" startup="1" protected="0" /> <reurce src="sa_fuel" startup="1" protected="0" /> <reurce src="sa_groups" startup="1" protected="0" /> <reurce src="sa_groupsscripting" startup="1" protected="0" /> <reurce src="sa_heli" startup="1" protected="0" /> <reurce src="sa_help" startup="1" protected="0" /> <reurce src="sa_hud" startup="1" protected="0" /> <reurce src="sa_interiorsystem" startup="1" protected="0" /> <reurce src="sa_itemsysten" startup="1" protected="0" /> <reurce src="sa_jobs" startup="1" protected="0" /> <reurce src="sa_journals" startup="1" protected="0" /> <reurce src="sa_kezdes" startup="1" protected="0" /> <reurce src="sa_kreszmap" startup="1" protected="0" /> <reurce src="sa_kresztablak" startup="1" protected="0" /> <reurce src="sa_language" startup="1" protected="0" /> <reurce src="sa_licenses" startup="1" protected="0" /> <reurce src="sa_loader" startup="1" protected="0" /> <reurce src="sa_lspd-system" startup="1" protected="0" /> <reurce src="sa_main" startup="1" protected="0" /> <reurce src="sa_mechanic" startup="1" protected="0" /> <reurce src="sa_minimap" startup="1" protected="0" /> <reurce src="sa_nicknames" startup="1" protected="0" /> <reurce src="sa_nightshader" startup="1" protected="0" /> <reurce src="sa_parachute" startup="1" protected="0" /> <reurce src="sa_ped" startup="1" protected="0" /> <reurce src="sa_phone" startup="1" protected="0" /> <reurce src="sa_playereffect" startup="1" protected="0" /> <reurce src="sa_pool" startup="1" protected="0" /> <reurce src="sa_pos" startup="1" protected="0" /> <reurce src="sa_premium" startup="1" protected="0" /> <reurce src="sa_punishment" startup="1" protected="0" /> <reurce src="sa_radar" startup="1" protected="0" /> <reurce src="sa_radio" startup="1" protected="0" /> <reurce src="sa_realistictrain" startup="1" protected="0" /> <reurce src="sa_saveVeh" startup="1" protected="0" /> <reurce src="sa_saveChar" startup="1" protected="0" /> <reurce src="sa_Score" startup="1" protected="0" /> <reurce src="sa_social" startup="1" protected="0" /> <reurce src="sa_speedo" startup="1" protected="0" /> <reurce src="sa_szemetszedes" startup="1" protected="0" /> <reurce src="sa_tabla" startup="1" protected="0" /> <reurce src="sa_tuning" startup="1" protected="0" /> <reurce src="sa_vehicle" startup="1" protected="0" /> <reurce src="sa_vehicle-system" startup="1" protected="0" /> <reurce src="sa_vehInteriors" startup="1" protected="0" /> <reurce src="sa_vonat" startup="1" protected="0" /> <reurce src="sa_walking" startup="1" protected="0" /> <reurce src="sa_water" startup="1" protected="0" /> <reurce src="sa_weapon" startup="1" protected="0" /> <reurce src="sa_weather-system" startup="1" protected="0" />
  3. function showItemList() if getElementData(getLocalPlayer(), "adminlevel") == 0 then return end if not (wItemsList) then wItemsList = guiCreateWindow(0.15, 0.15, 0.7, 0.7, "Items List", true) local gridItems = guiCreateGridList(0.025, 0.1, 0.95, 0.775, true, wItemsList) local colID = guiGridListAddColumn(gridItems, "ID", 0.1) local colName = guiGridListAddColumn(gridItems, "Tárgy neve", 0.3) local colDesc = guiGridListAddColumn(gridItems, "Leírás", 0.6) for key, value in pairs(g_items) do if key ~= 74 and key ~= 75 then local row = guiGridListAddRow(gridItems) guiGridListSetItemText(gridItems, row, colID, tostring(key), false, true) guiGridListSetItemText(gridItems, row, colName, value[1], false, false) guiGridListSetItemText(gridItems, row, colDesc, value[2], false, false) end end bItemListClose = guiCreateButton(0.025, 0.9, 0.95, 0.1, "Bezárás", true, wItemsList) addEventHandler("onClientGUIClick", bItemListClose, closeItemsList, false) showCursor(true) else guiSetVisible(wItemsList, true) guiBringToFront(wItemsList) showCursor(true) end end function showChemistrySet() if not (wItems) then if not (wChemistrySet) then local width, height = 600, 500 local scrWidth, scrHeight = guiGetScreenSize() local x = scrWidth/2 - (width/2) local y = scrHeight/2 - (height/2) wChemistrySet = guiCreateWindow(x, y, width, height, "Kémia szett", false) guiWindowSetSizable(wChemistrySet, false) local items = getItems(getLocalPlayer()) chemItems = { } if items then for slot, item in ipairs(items) do if item and item[1] >= 30 and item[1] <= 33 then chemItems[slot] = { } chemItems[slot][1] = getItemName(item[1]) chemItems[slot][2] = item[1] chemItems[slot][3] = slot end end end -- ITEMS gChemicals = guiCreateGridList(0.025, 0.05, 0.95, 0.85, true, wChemistrySet) colChemSlot = guiGridListAddColumn(gChemicals, "Hely", 0.1) colChemName = guiGridListAddColumn(gChemicals, "Név", 0.855) guiGridListSetSelectionMode(gChemicals, 1) for k, v in pairs(chemItems) do local itemid = tonumber(chemItems[k][2]) local itemtype = getItemType(itemid) if (itemtype) then local row = guiGridListAddRow(gChemicals) guiGridListSetItemText(gChemicals, row, colChemSlot, tostring(chemItems[k][3]), false, true) guiGridListSetItemText(gChemicals, row, colChemName, tostring(chemItems[k][1]), false, false) end end -- buttons bMixItems = guiCreateButton(0.05, 0.91, 0.7, 0.15, "Kiválasztottak összekeverése", true, wChemistrySet) addEventHandler("onClientGUIClick", bMixItems, mixItems, false) guiSetEnabled(bMixItems, false) bChemClose = guiCreateButton(0.8, 0.91, 0.15, 0.15, "Bezárás", true, wChemistrySet) addEventHandler("onClientGUIClick", gChemicals, checkSelectedItems, false) addEventHandler("onClientGUIClick", bChemClose, hideChemistrySet, false) showCursor(true) else hideChemistrySet() end end end function showItemList() if getElementData(getLocalPlayer(), "adminlevel") == 0 then return end if not (wItemsList) then wItemsList = guiCreateWindow(0.15, 0.15, 0.7, 0.7, "Items List", true) local gridItems = guiCreateGridList(0.025, 0.1, 0.95, 0.775, true, wItemsList) local colID = guiGridListAddColumn(gridItems, "ID", 0.1) local colName = guiGridListAddColumn(gridItems, "Tárgy neve", 0.3) local colDesc = guiGridListAddColumn(gridItems, "Leírás", 0.6) for key, value in pairs(g_items) do if key ~= 74 and key ~= 75 then local row = guiGridListAddRow(gridItems) guiGridListSetItemText(gridItems, row, colID, tostring(key), false, true) guiGridListSetItemText(gridItems, row, colName, value[1], false, false) guiGridListSetItemText(gridItems, row, colDesc, value[2], false, false) end end bItemListClose = guiCreateButton(0.025, 0.9, 0.95, 0.1, "Bezárás", true, wItemsList) addEventHandler("onClientGUIClick", bItemListClose, closeItemsList, false) showCursor(true) else guiSetVisible(wItemsList, true) guiBringToFront(wItemsList) showCursor(true) end end
  4. Hi guys! I have a bit problem. Im download Drawtag 1.1 resource and when i typing "/draw" then i see the gui window and it working. When i open the inventory and i click for item, after i open the draw but the buttons doesnt working. The buttons is: clear, close and done button. Sorry for my bad English. Drawtag 1.1 code function createDrawingWindow() local sw,sh = guiGetScreenSize() draw_window = guiCreateWindow((sw-512)*0.5,(sh-384)*0.5,512,384,"Drawing",false) guiWindowSetSizable(draw_window,false) button_close = guiCreateButton(352,304,96,32,"Close",false,draw_window) button_done = guiCreateButton(304,344,64,24,"Done",false,draw_window) button_clear = guiCreateButton(432,344,64,24,"Clear",false,draw_window) guiSetVisible(draw_window,false) setDefaultColors() brush_size = 4 drawdest = dxCreateRenderTarget(256,256,true) erasedest = dxCreateRenderTarget(256,256,false) if not drawdest or not erasedest then return end black = tocolor(0,0,0,255) white = tocolor(255,255,255,255) green = tocolor(0,128,0,255) midblue = tocolor(0,0,192,255) red = tocolor(255,0,0,255) lime = tocolor(0,255,0,255) blue = tocolor(0,0,255,255) transparent = tocolor(255,255,255,128) addEventHandler("onClientGUIClick", button_close, buttonCloseDrawingWindow, false) addEventHandler("onClientGUIClick", button_done, buttonDoneDrawing, false) addEventHandler("onClientGUIClick", button_clear, buttonClearImage, false) brush_preview_bg = white end Inventory code function showChemistrySet() if not (wItems) then if not (wChemistrySet) then local width, height = 600, 500 local scrWidth, scrHeight = guiGetScreenSize() local x = scrWidth/2 - (width/2) local y = scrHeight/2 - (height/2) wChemistrySet = guiCreateWindow(x, y, width, height, "Kémia szett", false) guiWindowSetSizable(wChemistrySet, false) local items = getItems(getLocalPlayer()) chemItems = { } if items then for slot, item in ipairs(items) do if item and item[1] >= 30 and item[1] <= 33 then chemItems[slot] = { } chemItems[slot][1] = getItemName(item[1]) chemItems[slot][2] = item[1] chemItems[slot][3] = slot end end end -- ITEMS gChemicals = guiCreateGridList(0.025, 0.05, 0.95, 0.85, true, wChemistrySet) colChemSlot = guiGridListAddColumn(gChemicals, "Hely", 0.1) colChemName = guiGridListAddColumn(gChemicals, "Név", 0.855) guiGridListSetSelectionMode(gChemicals, 1) for k, v in pairs(chemItems) do local itemid = tonumber(chemItems[k][2]) local itemtype = getItemType(itemid) if (itemtype) then local row = guiGridListAddRow(gChemicals) guiGridListSetItemText(gChemicals, row, colChemSlot, tostring(chemItems[k][3]), false, true) guiGridListSetItemText(gChemicals, row, colChemName, tostring(chemItems[k][1]), false, false) end end -- buttons bMixItems = guiCreateButton(0.05, 0.91, 0.7, 0.15, "Kiválasztottak összekeverése", true, wChemistrySet) addEventHandler("onClientGUIClick", bMixItems, mixItems, false) guiSetEnabled(bMixItems, false) bChemClose = guiCreateButton(0.8, 0.91, 0.15, 0.15, "Bezárás", true, wChemistrySet) addEventHandler("onClientGUIClick", gChemicals, checkSelectedItems, false) addEventHandler("onClientGUIClick", bChemClose, hideChemistrySet, false) showCursor(true) else hideChemistrySet() end end end
  5. 2. local kapcsolat = exports["mysql"]:getConnection() addEventHandler("onResourceStart", root, function(res) if ( ( res == getResourceFromName("mysql") ) or ( res == getThisResource() and getResourceState(res) == "running") ) then kapcsolat = exports["mysql"]:getConnection() end end ) [23:31:28] restart: Requested by Console [23:31:28] restart: Resource restarting... [23:31:28] Stopping sg_tuning [23:31:28] Resource 'sg_tuning' changed, reloading and starting [23:31:28] Starting sg_tuning [23:31:28] ERROR: sg_tuning\server.lua:1: exports: Call to non-running server resource (mysql) [string "?"] [23:31:28] ERROR: sg_tuning\server.lua:5: exports: Call to non-running server resource (mysql) [string "?"] [23:31:28] sg_tuning restarted successfully 3. Working. First i started the gamemode, then i want login and register but i cant. Sorry for my bad English. [23:34:27] WARNING: sg_login\server.lua:494: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got nil] [23:34:27] WARNING: sg_login\server.lua:496: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean] [23:34:27] ERROR: sg_login\server.lua:500: attempt to get length of local 'qh' (a boolean value) [23:34:38] ERROR: sg_login\server.lua:58: attempt to concatenate a nil value [23:34:38] ERROR: sg_login\server.lua:58: attempt to concatenate a nil value [23:35:20] DENIED: Denied 'James' access to command 'debugscript' [23:35:22] ERROR: sg_login\server.lua:58: attempt to concatenate a nil value [23:35:22] ERROR: sg_login\server.lua:58: attempt to concatenate a nil value Thanks for helping, please help again. and [23:39:02] ERROR: sg_tuning\server.lua:1: exports: Call to non-running server resource (mysql) [string "?"] [23:39:02] ERROR: sg_tuning\server.lua:5: exports: Call to non-running server resource (mysql) [string "?"] [23:39:02] ERROR: sg_login\server.lua:4: exports: Call to non-running server resource (mysql) [string "?"]
  6. Hi guys! My problem's. Thanks in advance. __________________________________________________________________________________________________________________________________________________________ Problem __________________________________________________________________________________________________________________________________________________________ ERROR: sg_hud\server.lua:8: attempt to call global 'food' (a nil value) __________________________________________________________________________________________________________________________________________________________ Script __________________________________________________________________________________________________________________________________________________________ addCommandHandler("set", function(player) setPedArmor ( player, 100 ) setElementHealth(player, 100) setElementData(player, "food", 100) setElementData(player, "drink", 100) end) food() drink() function drink(player) if getElementData(player, "logedin") then setTimer(function() setElementData(player, "drink", getElementData(player, "drink") - 1) end, 50, 0) end end function food(player) if getElementData(player, "logedin") then setTimer(function() setElementData(player, "food", getElementData(player, "food") - 1) end, 50, 0) end end Problem ERROR: sg_tuning\server.lua:1: exports: Call to non-running server resource (mysql) [string "?"] Script local kapcsolat = exports["mysql"]:getConnection() addEvent("updateServerTuning", true) addEventHandler("updateServerTuning", getRootElement(), function(veh, buzi1, buzi2, where, szam) local dbid = getElementData(veh, "veh:id") setVehicleHandling(veh, buzi2, buzi1) outputChatBox("MELEG MIKI MERT".. buzi2.."És".. where.. "Meg".. szam) dbExec(kapcsolat, "UPDATE vehicles SET ".. where .." = ? WHERE ID = ?",szam, dbid) end) function enter (theVehicle, seat) triggerClientEvent ( source, "playTurboSound", source) end addEventHandler ( "onPlayerVehicleEnter", getRootElement(), enter ) --[[addEvent("updateneon", true) addEventHandler("updateneon", getRootElement(), function(neon, veh) local dbid = getElementData(veh, "veh:id") dbExec(kapcsolat, "UPDATE jarmuvek SET neon = ? WHERE ID = ?",neon, dbid) end)]]-- function addUpgrade(vehicle, tuning, slot, curr) if curr == 6 then removeVehicleUpgrade(vehicle, slot) addVehicleUpgrade(vehicle, tuning) addVehicleUpgrade(vehicle, tuning+1) else removeVehicleUpgrade(vehicle, slot) addVehicleUpgrade(vehicle, tuning) end end addEvent("addVehicleUpgradeOptik", true) addEventHandler("addVehicleUpgradeOptik", getRootElement(), addUpgrade) And [22:25:34] SCRIPT ERROR: sg_login\server.lua:30: ')' expected (to close '(' at line 21) near 'dbQuery' [22:25:34] ERROR: Loading script failed: sg_login\server.lua:30: ')' expected (to close '(' at line 21) near 'dbQuery' Script local mysql = exports.mysql local postable = {} local regisztalhat = true function playerRegister(player, username, password, password2) local md5password = md5(password) if(password~=password2)then triggerClientEvent("info",player,"A felhasználónév túl rövid!", "red") return end if(string.len(username)<5)then triggerClientEvent("info",player,"A felhasználónév túl rövid!", "red") return end if(string.len(password)<5)then triggerClientEvent("info", player, "A jelszó túl rövid!", "red") return end serial = getPlayerSerial(player) dbQuery(function(qh, player, username, md5password) local a, b, c = dbPoll(qh, 0) if b > 0 then outputChatBox("Neked már van accountod") regisztalhat = false return end end, {player,username,md5password}, mysql:getConnection(), ("SELECT * FROM characters WHERE charactername='" .. safecharname .. "' AND account='" .. mysql:escape_string(id) .. "' AND cked = 0") dbQuery(function(qh, player, username, md5password) local result, rows, errorMsg = dbPoll(qh, 0) if not regisztalhat then return end if rows > 0 then exports.sg_box:addNotification("Ez a felhasználónév már foglalt!","red") else local _, id = mysql:query_free("INSERT INTO accounts SET serial = '".. serial .."', username = '"..tostring(username).."', password = '"..tostring(md5password).."'", true) exports.sg_box:addNotification("Sikeresen regisztráltál!","green") end end, {player,username,md5password}, mysql:getConnection(), "SELECT * FROM accounts WHERE username = ? LIMIT 1", username) end addEvent("playerRegister", true) addEventHandler("playerRegister", getRootElement(), playerRegister) function playerLogin(player, username, password) password = md5(password) local query = mysql:singleQuery("SELECT * FROM accounts WHERE username = ? AND password = ? LIMIT 1", username, password) if query then --local querys = mysql:singleQuery("SELECT serial FROM accounts WHERE username = ? LIMIT 1", username) outputChatBox("[socialGaming] #FFFFFFSikeres bejelentkezés!",player,169,139,101,true) setElementData(player, "accountID", query.id) acc = getElementData(player, "accountID") CharSelect(acc, player) setElementData(player, "adminlevel", query.admin) else outputChatBox("[socialGaming] #FFFFFFSikertelen bejelentkezés!",player,177,9,45,true) end end addEvent("playerLogin", true) addEventHandler("playerLogin", getRootElement(), playerLogin) addEvent("createCharacter", true) addEventHandler("createCharacter", getRootElement(), function(p, nev, kor, suly, magassag, leiras, gender, color) acc = getElementData(p, "accountID") local qh = dbQuery( mysql:getConnection(), "SELECT `charactername` FROM `karakterek` WHERE `charactername` = ?", tostring(a)) local result = dbPoll ( qh, -1 ) local count = 0 local pw u = nil if result then for _, row in ipairs ( result ) do u = string.lower(row["charactername"]) end if u ~= nil then exports.sg_box:createSmallNotification(client,"Már van ilyen karakter név, kérlek válassz másikat!", 1) return end end dbFree( qh ) local user = getElementData(client, "username") qhh = dbExec( mysql:getConnection(), "INSERT INTO `karakterek` SET `charactername` = ?, `id` = ?, `skin` = 1, `kor` = ?, `suly` = ?, `magassag` = ?, `leiras` = ?, `gender` = ?,`color` = ? ", nev, acc, kor, suly, magassag, leiras, gender, color) if qhh then CharSelect(acc, p) end end) local postable = {} function CharSelect(acc, source) local accid = getElementData(source,"accountID") local qh = dbQuery(mysql:getConnection(),"SELECT * FROM karakterek WHERE id = ? LIMIT 1", accid) local result, lineNumber = dbPoll ( qh, -1 ) if(result) then if(lineNumber > 0) then for _, rows in ipairs( result ) do postable = {} level = rows["level"] xp = rows["xp"] jatszottpercek = rows["spentTime"] nev = rows["charactername"] anev = rows["adminnick"] fraki = rows["faction"] frakir = rows["factionrank"] factionleader = rows["factionleader"] skin = rows["skin"] dutyskin = rows["dutyskin"] induty = rows["inDuty"] kor = rows["kor"] suly = rows["suly"] mag = rows["magassag"] job = rows["job"] desc = rows["leiras"] gender = rows["gender"] health = rows["health"] bankmoney = rows["bankmoney"] keszpenz = rows["keszpenz"] money = rows["money"] color = rows["color"] pajzs = rows["pajzs"] ehesseg = rows["ehesseg"] maxvehicles = rows["maxvehicles"] hasznaltkocsislot = rows["hasznaltkocsislot"] premiumPont = rows["premiumPont"] adminduty = rows["adminduty"] adminlevel = rows["adminlevel"] pozicio = fromJSON(rows["pozicio"]) postable = {pozicio[1],pozicio[2],pozicio[3],pozicio[4]} halal = rows["isDead"] end setPlayerName(source, string.gsub(nev, " ", "_")) setElementData(source, "charactername", nev) setElementData(source, "adminduty", 0) setElementData(source, "adminnick", anev) spawnPlayer(source, postable[1], postable[2], postable[3], postable[4]) setElementData(source, "logedin", true) setElementData(source, "jatszottpercek", jatszottpercek) setElementData(source, "faction", fraki) setElementData(source, "factionrank", frakir) setElementData(source, "factionleader", factionleader) setElementData(source, "age", kor) setElementData(source, "gender", gender) setElementData(source, "bankmoney", bankmoney) setElementData(source, "keszpenz", keszpenz) setElementData(source, "adminduty", adminduty) setElementData(source, "adminlevel", adminlevel) setElementData(source, "premiumPont", premiumPont) setElementData(source, "xp", xp) setElementData(source, "level", level) if halal == 1 then setElementHealth(source, 0) else setElementHealth(source, health) end setElementData(source, "money", money) setElementData(source, "color", color) setPedArmor(source, pajzs) setElementData(source, "weight", suly) setElementData(source, "height", mag) setElementData(source, "desc", desc) setElementData(source, "job:id", job) setElementData(source, "ehesseg", ehesseg) setElementData(source, "maxvehicles", maxvehicles) setElementData(source, "hasznaltkocsislot", hasznaltkocsislot) setElementData(source, "normalskin", skin) setElementData(source, "dutyskin", dutyskin) setElementData(source, "inDuty", induty) if getElementData(source, "inDuty") then actualskin = getElementData(source, "dutyskin") else actualskin = getElementData(source, "normalskin") end setElementModel(source, actualskin) --color health ehesseg pajzs spentTime faction factionrank factionleader maxVeh maxInt setCameraTarget(source) triggerClientEvent(source,"succes", source) else triggerClientEvent(source,"characterCreation", source) end end end addEventHandler("onPlayerQuit", getRootElement(), function() if getElementData(source, "logedin") then savePlayer(source) end end) function savePlayer(p) if isElement(p) then local x,y,z = getElementPosition(p) local rot = getPedRotation(p) local dbid = tonumber(getElementData(p, "accountID")) or 0 local admin = tonumber(getElementData(p, "adminlevel")) or 0 local position = toJSON({x,y,z,rot}) local orak = getElementData(p, "jatszottpercek") or 0 local faction = getElementData(p, "faction") or 0 local hp = getElementHealth(p) local bankmoney = getElementData(p, "bankmoney") local keszpenz = getElementData(p, "keszpenz") local money = getElementData(p, "money") local armor = getPedArmor(p) local ehesseg = getElementData(p, "ehesseg") local skin = getElementData(p, "normalskin") local duty = getElementData(p, "inDuty") local dutyskin = getElementData(p, "dutyskin") local job = getElementData(p, "job:id") local maxvehicles = getElementData(p, "maxvehicles") or 4 local hasznaltkocsislot = getElementData(p, "hasznaltkocsislot") or 0 local premiumPont = getElementData(p, "premiumPont") or 0 local xp = getElementData(p, "xp") or 0 local level = getElementData(p, "level") or 0 dbExec(mysql:getConnection(), "UPDATE karakterek SET pozicio = ?, spentTime = ?, faction = ?, health = ?, bankmoney = ?, money = ?, pajzs = ?, ehesseg = ?, skin = ?, job = ? WHERE ID = ?", position, spentTime, faction, hp, bankmoney, money, armor, ehesseg, skin, job, dbid) dbExec(mysql:getConnection(), "UPDATE karakterek SET maxvehicles = ?,hasznaltkocsislot = ?,premiumPont = ?, inDuty = ?, dutyskin = ?, keszpenz = ? WHERE ID = ?", maxvehicles,hasznaltkocsislot,premiumPont, duty, dutyskin,keszpenz,dbid) dbExec(mysql:getConnection(), "UPDATE accounts SET admin = ? WHERE ID = ?",admin,xp,level,dbid) dbExec(mysql:getConnection(), "UPDATE karakterek SET xp=?,level=? WHERE ID = ?",xp,level,dbid) end end addEvent("savePlayer", true) addEventHandler("savePlayer", getRootElement(), savePlayer) function saveAllPlayer() local count = 0 for i, p in ipairs(getElementsByType("player")) do if (getElementData(p, "logedin") or false) then savePlayer(p) count = count + 1 end end outputDebugString("Ellett mentve "..count.." jatekos adata!") end saveAllPlayer() setTimer(saveAllPlayer, 1000*60*10, 0) addCommandHandler("saveall",saveAllPlayer) addEvent("checkPlayerBanState", true) addEventHandler("checkPlayerBanState", getRootElement(), function(player) local serial = getPlayerSerial(player) local query = dbQuery(mysql:getConnection(),"SELECT * FROM banlist WHERE serial=?",serial) local qh = dbPoll(query, -1) local playerSerial, timeStamp, bannedBy, reason if #qh > 0 then for k, data in ipairs (qh) do outputChatBox("Ok") playerSerial = data["serial"]
  7. Mysql database running. Whats the problem? I dont understand
  8. Okay, im change script. dbQuery = function(qh, player, username, md5password) Warning: restart sg_login [18:54:03] restart: Requested by Console [18:54:03] restart: Resource restarting... [18:54:03] Stopping sg_login [18:54:03] Starting sg_login [18:54:03] ERROR: sg_login\server.lua:1: exports: Call to non-running server resource (mysql) [string "?"] [18:54:03] INFO: Ellett mentve 0 jatekos adata! [18:54:03] sg_login restarted successfully [18:54:03] WARNING: sg_login\server.lua:246: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got nil] [18:54:03] WARNING: sg_login\server.lua:247: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean] [18:54:03] ERROR: sg_login\server.lua:249: attempt to get length of local 'qh' (a boolean value) [18:54:21] ERROR: sg_login\server.lua:28: attempt to concatenate a nil value [18:54:24] DENIED: Denied 'James' access to command 'debugscript' [18:54:25] ERROR: sg_login\server.lua:28: attempt to concatenate a nil value [18:54:26] ERROR: sg_login\server.lua:28: attempt to concatenate a nil value 246 line local query = dbQuery(mysql:getConnection(),"SELECT * FROM banlist WHERE serial=?",serial) 247 line local qh = dbPoll(query, -1) 249 line local playerSerial, timeStamp, bannedBy, reason 28 line end, {player,username,md5password}, mysql:getConnection(), ("SELECT * FROM characters WHERE charactername='" .. safecharname .. "' AND account='" .. mysql:escape_string(id) .. "' AND cked = 0") Not wokring.
  9. Hi guys! I have problem with one gamemode. First i started the gamemode, then i want login and register but i cant. Sorry for my bad English. Console errors: restart sg_login [18:08:08] restart: Requested by Console [18:08:08] restart: Resource restarting... [18:08:08] Stopping sg_login [18:08:08] Starting sg_login [18:08:08] SCRIPT ERROR: sg_login\server.lua:30: ')' expected (to close '(' at line 21) near 'dbQuery' [18:08:08] ERROR: Loading script failed: sg_login\server.lua:30: ')' expected (to close '(' at line 21) near 'dbQuery' [18:08:08] sg_login restarted successfully [18:08:08] ERROR: Client (James) triggered serverside event checkPlayerBanState, but event is not added serverside [18:08:16] DENIED: Denied 'James' access to command 'debugscript' [18:08:18] ERROR: Client (James) triggered serverside event playerLogin, but event is not added serverside [18:08:21] ERROR: Client (James) triggered serverside event playerRegister, but event is not added serverside [18:08:25] ERROR: Client (James) triggered serverside event playerRegister, but event is not added serverside Script, server.lua: local mysql = exports.mysql local postable = {} local regisztalhat = true function playerRegister(player, username, password, password2) local md5password = md5(password) if(password~=password2)then triggerClientEvent("info",player,"A felhasználónév túl rövid!", "red") return end if(string.len(username)<5)then triggerClientEvent("info",player,"A felhasználónév túl rövid!", "red") return end if(string.len(password)<5)then triggerClientEvent("info", player, "A jelszó túl rövid!", "red") return end serial = getPlayerSerial(player) dbQuery(function(qh, player, username, md5password) local a, b, c = dbPoll(qh, 0) if b > 0 then outputChatBox("Neked már van accountod") regisztalhat = false return end end, {player,username,md5password}, mysql:getConnection(), ("SELECT * FROM characters WHERE charactername='" .. safecharname .. "' AND account='" .. mysql:escape_string(id) .. "' AND cked = 0") dbQuery(function(qh, player, username, md5password) local result, rows, errorMsg = dbPoll(qh, 0) if not regisztalhat then return end if rows > 0 then exports.sg_box:addNotification("Ez a felhasználónév már foglalt!","red") else local _, id = mysql:query_free("INSERT INTO accounts SET serial = '".. serial .."', username = '"..tostring(username).."', password = '"..tostring(md5password).."'", true) exports.sg_box:addNotification("Sikeresen regisztráltál!","green") end end, {player,username,md5password}, mysql:getConnection(), "SELECT * FROM accounts WHERE username = ? LIMIT 1", username) end addEvent("playerRegister", true) addEventHandler("playerRegister", getRootElement(), playerRegister) function playerLogin(player, username, password) password = md5(password) local query = mysql:singleQuery("SELECT * FROM accounts WHERE username = ? AND password = ? LIMIT 1", username, password) if query then --local querys = mysql:singleQuery("SELECT serial FROM accounts WHERE username = ? LIMIT 1", username) outputChatBox("[socialGaming] #FFFFFFSikeres bejelentkezés!",player,169,139,101,true) setElementData(player, "accountID", query.id) acc = getElementData(player, "accountID") CharSelect(acc, player) setElementData(player, "adminlevel", query.admin) else outputChatBox("[socialGaming] #FFFFFFSikertelen bejelentkezés!",player,177,9,45,true) end end addEvent("playerLogin", true) addEventHandler("playerLogin", getRootElement(), playerLogin) addEvent("createCharacter", true) addEventHandler("createCharacter", getRootElement(), function(p, nev, kor, suly, magassag, leiras, gender, color) acc = getElementData(p, "accountID") local qh = dbQuery( mysql:getConnection(), "SELECT `charactername` FROM `karakterek` WHERE `charactername` = ?", tostring(a)) local result = dbPoll ( qh, -1 ) local count = 0 local pw u = nil if result then for _, row in ipairs ( result ) do u = string.lower(row["charactername"]) end if u ~= nil then exports.sg_box:createSmallNotification(client,"Már van ilyen karakter név, kérlek válassz másikat!", 1) return end end dbFree( qh ) local user = getElementData(client, "username") qhh = dbExec( mysql:getConnection(), "INSERT INTO `karakterek` SET `charactername` = ?, `id` = ?, `skin` = 1, `kor` = ?, `suly` = ?, `magassag` = ?, `leiras` = ?, `gender` = ?,`color` = ? ", nev, acc, kor, suly, magassag, leiras, gender, color) if qhh then CharSelect(acc, p) end end) local postable = {} function CharSelect(acc, source) local accid = getElementData(source,"accountID") local qh = dbQuery(mysql:getConnection(),"SELECT * FROM karakterek WHERE id = ? LIMIT 1", accid) local result, lineNumber = dbPoll ( qh, -1 ) if(result) then if(lineNumber > 0) then for _, rows in ipairs( result ) do postable = {} level = rows["level"] xp = rows["xp"] jatszottpercek = rows["spentTime"] nev = rows["charactername"] anev = rows["adminnick"] fraki = rows["faction"] frakir = rows["factionrank"] factionleader = rows["factionleader"] skin = rows["skin"] dutyskin = rows["dutyskin"] induty = rows["inDuty"] kor = rows["kor"] suly = rows["suly"] mag = rows["magassag"] job = rows["job"] desc = rows["leiras"] gender = rows["gender"] health = rows["health"] bankmoney = rows["bankmoney"] keszpenz = rows["keszpenz"] money = rows["money"] color = rows["color"] pajzs = rows["pajzs"] ehesseg = rows["ehesseg"] maxvehicles = rows["maxvehicles"] hasznaltkocsislot = rows["hasznaltkocsislot"] premiumPont = rows["premiumPont"] adminduty = rows["adminduty"] adminlevel = rows["adminlevel"] pozicio = fromJSON(rows["pozicio"]) postable = {pozicio[1],pozicio[2],pozicio[3],pozicio[4]} halal = rows["isDead"] end setPlayerName(source, string.gsub(nev, " ", "_")) setElementData(source, "charactername", nev) setElementData(source, "adminduty", 0) setElementData(source, "adminnick", anev) spawnPlayer(source, postable[1], postable[2], postable[3], postable[4]) setElementData(source, "logedin", true) setElementData(source, "jatszottpercek", jatszottpercek) setElementData(source, "faction", fraki) setElementData(source, "factionrank", frakir) setElementData(source, "factionleader", factionleader) setElementData(source, "age", kor) setElementData(source, "gender", gender) setElementData(source, "bankmoney", bankmoney) setElementData(source, "keszpenz", keszpenz) setElementData(source, "adminduty", adminduty) setElementData(source, "adminlevel", adminlevel) setElementData(source, "premiumPont", premiumPont) setElementData(source, "xp", xp) setElementData(source, "level", level) if halal == 1 then setElementHealth(source, 0) else setElementHealth(source, health) end setElementData(source, "money", money) setElementData(source, "color", color) setPedArmor(source, pajzs) setElementData(source, "weight", suly) setElementData(source, "height", mag) setElementData(source, "desc", desc) setElementData(source, "job:id", job) setElementData(source, "ehesseg", ehesseg) setElementData(source, "maxvehicles", maxvehicles) setElementData(source, "hasznaltkocsislot", hasznaltkocsislot) setElementData(source, "normalskin", skin) setElementData(source, "dutyskin", dutyskin) setElementData(source, "inDuty", induty) if getElementData(source, "inDuty") then actualskin = getElementData(source, "dutyskin") else actualskin = getElementData(source, "normalskin") end setElementModel(source, actualskin) --color health ehesseg pajzs spentTime faction factionrank factionleader maxVeh maxInt setCameraTarget(source) triggerClientEvent(source,"succes", source) else triggerClientEvent(source,"characterCreation", source) end end end addEventHandler("onPlayerQuit", getRootElement(), function() if getElementData(source, "logedin") then savePlayer(source) end end) function savePlayer(p) if isElement(p) then local x,y,z = getElementPosition(p) local rot = getPedRotation(p) local dbid = tonumber(getElementData(p, "accountID")) or 0 local admin = tonumber(getElementData(p, "adminlevel")) or 0 local position = toJSON({x,y,z,rot}) local orak = getElementData(p, "jatszottpercek") or 0 local faction = getElementData(p, "faction") or 0 local hp = getElementHealth(p) local bankmoney = getElementData(p, "bankmoney") local keszpenz = getElementData(p, "keszpenz") local money = getElementData(p, "money") local armor = getPedArmor(p) local ehesseg = getElementData(p, "ehesseg") local skin = getElementData(p, "normalskin") local duty = getElementData(p, "inDuty") local dutyskin = getElementData(p, "dutyskin") local job = getElementData(p, "job:id") local maxvehicles = getElementData(p, "maxvehicles") or 4 local hasznaltkocsislot = getElementData(p, "hasznaltkocsislot") or 0 local premiumPont = getElementData(p, "premiumPont") or 0 local xp = getElementData(p, "xp") or 0 local level = getElementData(p, "level") or 0 dbExec(mysql:getConnection(), "UPDATE karakterek SET pozicio = ?, spentTime = ?, faction = ?, health = ?, bankmoney = ?, money = ?, pajzs = ?, ehesseg = ?, skin = ?, job = ? WHERE ID = ?", position, spentTime, faction, hp, bankmoney, money, armor, ehesseg, skin, job, dbid) dbExec(mysql:getConnection(), "UPDATE karakterek SET maxvehicles = ?,hasznaltkocsislot = ?,premiumPont = ?, inDuty = ?, dutyskin = ?, keszpenz = ? WHERE ID = ?", maxvehicles,hasznaltkocsislot,premiumPont, duty, dutyskin,keszpenz,dbid) dbExec(mysql:getConnection(), "UPDATE accounts SET admin = ? WHERE ID = ?",admin,xp,level,dbid) dbExec(mysql:getConnection(), "UPDATE karakterek SET xp=?,level=? WHERE ID = ?",xp,level,dbid) end end addEvent("savePlayer", true) addEventHandler("savePlayer", getRootElement(), savePlayer) function saveAllPlayer() local count = 0 for i, p in ipairs(getElementsByType("player")) do if (getElementData(p, "logedin") or false) then savePlayer(p) count = count + 1 end end outputDebugString("Ellett mentve "..count.." jatekos adata!") end saveAllPlayer() setTimer(saveAllPlayer, 1000*60*10, 0) addCommandHandler("saveall",saveAllPlayer) addEvent("checkPlayerBanState", true) addEventHandler("checkPlayerBanState", getRootElement(), function(player) local serial = getPlayerSerial(player) local query = dbQuery(mysql:getConnection(),"SELECT * FROM banlist WHERE serial=?",serial) local qh = dbPoll(query, -1) local playerSerial, timeStamp, bannedBy, reason if #qh > 0 then for k, data in ipairs (qh) do outputChatBox("Ok") playerSerial = data["serial"]
×
×
  • Create New...