Witam pomo?e mi kto? z tym ogrpg-db. Poniewa? ten b??d bo tak mi w db3 spami, ?e nie mog? nic odczyta? innego.
[lua]-- Settings
DBHandler=nil
DBName="db_36528"
DBUser="db_36528"
DBPass="fwhvo7ueZRLw"
DBHost="94.23.90.14"
-- Functions
function dbSet(...)
if not {...} then return end
local qh = dbQuery(DBHandler, ...)
if not qh then return false end
local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)
return result, num_affected_rows, last_insert_id
end
function dbGet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbQuery(DBHandler, stringe)
local result,num_affected_rows, last_insert_id =dbPoll(query, -1)
return result
end
addEventHandler("onResourceStart", resourceRoot, function()
DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1;autoreconnect=1")
if DBHandler then
outputDebugString("* Po??czono pomy?lnie Z baz? Danych Serwera MoveRPG 2.0 Pyrek Pozdrawia! (MySQL)")
dbSet("SET NAMES utf8")
else
outputDebugString("* Brak po??czenia! (MySQL)")
end
end)
function pobierzTabeleWynikow(...)
local h=dbQuery(DBHandler,...)
if (not h) then
return nil
end
local rows = dbPoll(h, -1)
return...
Not starting resource ogrpg-db as this server version is too low (1.5.2-9.07903 required)
Kod:
[lua]
--[[
Resource: OURGame v2
Developers: Split <[email protected]>
You have no right to use this code without my permission.
(c) 2015 <[email protected]>. All rights reserved.
]]
-- Functions
function dbSet(...)
if not {...} then return end
local qh = dbQuery(DBHandler, ...)
if not qh then return false end
local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)
return result, num_affected_rows, last_insert_id
end
function dbGet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbQuery(DBHandler, stringe)
local result,num_affected_rows, last_insert_id =dbPoll(query, -1)
return result
end
addEventHandler("onResourceStart", resourceRoot, function()
DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1;autoreconnect=1")
if DBHandler then
outputDebugString("* Po??czono pomy?lnie! (MySQL)")
dbSet("SET NAMES utf8")
else
outputDebugString("* Brak po??czenia! (M...
[20] WARNING: [RPG]/ogrpg-db/s_db.lua:25: Bad argument @ 'dbPrepareString' [Expected db-connection at argument 1, got boolean]
[20] WARNING: [RPG]/ogrpg-db/s_db.lua:26: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
[20] WARNING: [RPG]/ogrpg-db/s_db.lua:27: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
[20] ERROR: [RPG]/lss-domy/domy.lua:133: bad argument #1 to 'ipairs' (table expected, got boolean)
dodatkowo nie mog? wog?le stworzy? konta na serwerze, zamiast panelu logowania mam czarny ekran, prosz? o pomoc!
[lua]--[[
Resource: OURGame v2
Developers: Split <[email protected]>
You have no right to use this code without my permission.
(c) 2015 <[email protected]>. All rights reserved.
]]
-- Functions
function dbSet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbExec(DBHandler, stringe)
return query
end
function dbGet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbQuery(DBHandler, stringe)
local result=dbPoll(query, -1)
return result
end
Witajcie . Mam problem z ogrpg-db , wszystko dobrze pod??czone ale niestety wyskakuj? takie b??dy , hosting serverproject , wersja serwera 1.5.2 R4 (build 7838) .
Za pomoc piwko
Witam, ot?? wi?kszo?? os?b pyta czemu im nie dzia?aj? prawka, bany i wgl rzeczy zwi?zane z baz? danych na ogrpg. Powodem jest brak wgranego modu?u... lecz je?li kto? nie chce u?ywa? modu?u lub nie potrafi go wgra?, to udost?pniam wam ten kodzik na po??czenie za pomoc? funkcji.
Ukryta wiadomość / Hidden message(aby ją zobaczyć musisz postawić użytkownikowi)
Wiadomość została ukryta, aby ją przeczytać należy się zalogować.
-- Functions
function dbSet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbExec(DBHandler, stringe)
return query
end
function dbGet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbQuery(DBHandler, stringe)
local result=dbPoll(query, -1)
return result
end
addEventHandler("onResourceStart", resourceRoot, function()
DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1;autoreconnect=1")
if DBHandler then
outputDebugString("* Connect to server MYSQL...")
dbSet("SET NAMES utf8")
else
outputDebugString("* No Connecting to server MYSQL..")
end
end)
local SQL_LOGIN="Nie podam"
local SQL_PASSWD="Nie podam"
local SQL_DB="Nie podam"
local SQL_HOST="mysql-ols1.ServerProject.pl"
local SQL_PORT=Nie podam
local root = getRootElement()
local SQL
local function connect()
SQL = mysql_connect(SQL_HOST, SQL_LOGIN, SQL_PASSWD, SQL_DB, SQL_PORT)
if (not SQL) then
outpu...