Denilen her şeyi yaptım fakat login panelinde mysql'li bir şekilde giriş yapamıyorum lütfen çözüm yollarını sunun.

Konsol :
[20-04-20 03:08:43] SCRIPT ERROR: account/rules_apps/server_rules_s.lua:1: '=' expected near 'Ara'
[20-04-20 03:08:43] ERROR: Loading script failed: account/rules_apps/server_rules_s.lua:1: '=' expected near 'Ara'
[20-04-20 03:09:05] ERROR: mysql/connection.lua:206: attempt to call global 'mysql_escape_string' (a nil value)
[20-04-20 03:09:05] ERROR: mysql/connection.lua:206: attempt to call global 'mysql_escape_string' (a nil value)
[20-04-20 03:09:05] ERROR: account/login-panel/server.lua:215: call: failed to call 'mysql:escape_string' [string "?"]
[20-04-20 03:09:05] ERROR: mysql/connection.lua:206: attempt to call global 'mysql_escape_string' (a nil value)
[20-04-20 03:09:05] ERROR: mysql/connection.lua:206: attempt to call global 'mysql_escape_string' (a nil value)
[20-04-20 03:09:05] ERROR: account/login-panel/server.lua:215: call: failed to call 'mysql:escape_string' [string "?"]
[20-04-20 03:09:05] ERROR: account/login-panel/server.lua:215: attempt to concatenate a boolean value
[20-04-20 03:09:12] ERROR: mysql/connection.lua:206: attempt to call global 'mysql_escape_string' (a nil value)
[20-04-20 03:09:12] ERROR: mysql/connection.lua:206: attempt to call global 'mysql_escape_string' (a nil value)
[20-04-20 03:09:12] ERROR: account/login-panel/server.lua:32: call: failed to call 'mysql:escape_string' [string "?"]
[20-04-20 03:09:12] ERROR: account/login-panel/server.lua:32: attempt to concatenate a boolean value


Hosting servisi kullanıyorum. Orada verilen bilgilerle de girişlerimi gerçekleştiriyorum.

Lütfen yardımcı olun şimdiden teşekkürler.

server dosyasını atabilir misin?

Dostum hepsini atamasamda kişisel bilgilerimin  olduğundan, ama istediğin dosyaları atabilirim. Bana dosya adlarını söyler misin?

Connection.lua'yı atıyorum.

-- connection settings
local hostname = "blabla"
local username = "lbalba"
local password = "bılıbılı"
local database = "dılıdılı"
local port =  3306

-- global things.
local MySQLConnection = nil
local resultPool = { }
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 :O! [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
      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
      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)
   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

nereden bulabilirim onun konumunu?

Server side'dan kastın ne anlamadım konumu nerede acaba?

Üzgünüm dediğini tam anlamadım biraz açar mısın?

---

Mesaj Birleştirildi: [time]21 Nisan 2020, 03:35:10[/time]

---

Eğer buysa

 /mods/deathmatch/resources/mysql/meta.xml


<!-- above is legacy -->
      <export function="lazyQuery" type="server"/>
      <export function="ping"          type="server" http="false" />
      <export function="escape_string"    type="server" http="false" />
      <export function="query"          type="server" http="false" />
      <export function="forumQuery"      type="server" http="false" />
      <export function="forum_query_fetch_assoc"    type="server" http="false" />
      <export function="forum_query_free" type="server" http="false" />
      <export function="forum_query_insert_free"type="server" http="false" />
      <export function="unbuffered_query" type="server" http="false" />
      <export function="query_free"       type="server" http="false" />
      <export function="fetch_assoc"       type="server" http="false" />
      <export function="rows_assoc"       type="server" http="false" />
      <export function="free_result"       type="server" http="false" />
      <export function="result"          type="server" http="false" />
      <export function="num_rows"       type="server" http="false" />
      <export function="query_fetch_assoc"type="server" http="false" />
      <export function="query_rows_assoc" type="server" http="false" />
      <export function="insert_id"       type="server" http="false" />
      <export function="query_rows_assoc" type="server" http="false" />
      <export function="query_insert_free"type="server" http="false" />
      <export function="escape_string"    type="server" http="false" />
      <export function="debugMode"        type="server" http="false" />
      <export function="returnQueryStats" type="server" http="false" />
      <export function="getOpenQueryStr"  type="server" http="false" />
      

---

Mesaj Birleştirildi: [time]21 Nisan 2020, 03:42:19[/time]

---

function getCharacterIDFromName(charName)
   if not charName then return false end
   charName = string.gsub(charName, " ", "_")
   local query = exports.mysql:query_fetch_assoc("SELECT `id` FROM characters WHERE `charactername`='"..exports.mysql:escape_string(charName).."' LIMIT 1")
   if query then
      local id = tonumber(query["id"])
      exports.mysql:free_result(query)
      if id > 0 then
         return id
      end
   end
   return false
end
function getCharacterNameFromID(charID)
   if not charID then return false end
   local query = exports.mysql:query_fetch_assoc("SELECT `charactername` FROM characters WHERE `id`='"..exports.mysql:escape_string(charID).."' LIMIT 1")
   if query then
      local charName = tostring(query["charactername"])
      exports.mysql:free_result(query)
      if charName then
         return charName
      end
   end
   outputDebugString("getCharacterNameFromID(): Unable",2)
   return false
end

local userNamesCache = {}
function getUserNameFromID(userID)
   if not userID then return false end
   if userNamesCache[userID] then
      return userNamesCache[userID]
   end
   local query = exports.mysql:query_fetch_assoc("SELECT `username` FROM accounts WHERE `id`='"..mysql:escape_string(tostring(userID)).."' LIMIT 1")
   if query then
      local userName = tostring(query["username"])
      exports.mysql:free_result(query)
      if userName then
         userNamesCache[userID] = userName
         return userName
      end
   end
--   outputDebugString("getUserNameFromID(): Unable",2)
   return false
end

function getPlayerFromCharacterID(charID)
   local players = exports.pool:getPoolElementsByType("player")
   for k,v in ipairs(players) do
      if(tonumber(getElementData(v, "dbid")) == tonumber(charID)) then
         return v
      end
   end
   return false
end

---

Mesaj Birleştirildi: 21 Nisan 2020, 02:37:11

---

function toSQL(stuff)
   return exports.mysql:escape_string(stuff)
end

function getSmallestIdFromDbTable(tableName) -- finds the smallest ID in the SQL instead of auto increment
   if not tableName then
      return false
   end
   local result = exports.mysql:query_fetch_assoc("SELECT MIN(e1.id+1) AS nextID FROM "..tableName.." AS e1 LEFT JOIN "..tableName.." AS e2 ON e1.id +1 = e2.id WHERE e2.id IS NULL")
   if result then
      local id = tonumber(result["nextID"]) or 1
      return id
   end
   return false
end