Wysłany: 2016-07-27, 11:52
OzikGames|YT Skrypter LUA Wiek: 25 3766 dni Nick w MP: OzikGames
Piwa 749
Mam mianowicie taki problem potrzebuje podpi?? baze danych pod serwer z gm Our-Game w mysql jest wszystko ok tylko trzeba w DB2 ogrpg-db
--[[
Obsluga baz danych , interfejs do bazy MySQL realizowany za pomoca wbudowanych w MTA funkcji db ...
@ author Lukasz Biegaj < wielebny @ bestplay . pl >
@ author WUBE < wube @ lss - rp . pl >
@ copyright 2011 - 2013 Lukasz Biegaj < wielebny @ bestplay . pl >
@ license Dual GPLv2 / MIT
@ package MTA - XyzzyRP
@ link https : //github.com/lpiob/MTA-XyzzyRP GitHub
]]--
local SQL
local function connect ()
-- w ponizszej linii uzupelnij dane autoryzacji
SQL = dbConnect ( "mysql" , "dbname=567871_BritishLife;host=mysql-fr1.ServerProject.pl" , "567871" , "1234CipaDylemata" , "share=1" )
if ( not SQL ) then
outputServerLog ( "BRAK POLACZENIA Z BAZA DANYCH!" )
else
zapytanie ( "SET NAMES utf8;" )
end
end
addEventHandler ( "onResourceStart" , resourceRoot , connect )
function pobierzTabeleWynikow (...)
local h = dbQuery ( SQL ,...)
if ( not h ) then
return nil
end
local rows = dbPoll ( h , - 1 )
return rows
end
function pobierzWyniki (...)
local h = dbQuery ( SQL ,...)
if ( not h ) then
return nil
end
local rows = dbPoll ( h , - 1 )
if not rows then return nil end
return rows [ 1 ]
end
function zapytanie (...)
local h = dbQuery ( SQL ,...)
local result , numrows = dbPoll ( h ,- 1 )
return numrows
end
--[[
function insertID ()
return mysql_insert_id ( SQL )
end
function affectedRows ()
return mysql_affected_rows ( SQL )
end
]]--
function fetchRows ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then return nil end
local tabela ={}
while true do
local row = mysql_fetch_row ( result )
if ( not row ) then break end
table . insert ( tabela , row )
end
mysql_free_result ( result )
return tabela
end --[[
Resource : OURGame v2
Developers : Split < split . programista @ gmail . com >
You have no right to use this code without my permission .
( c ) 2015 < split . programista @ gmail . com >. All rights reserved .
]]
-- Settings
DBHandler = nil
DBName = "567871_BritishLife"
DBUser = "567871"
DBPass = "has?o"
DBHost = "sql.pukawka.pl"
-- Functions
function dbSet (...)
if not {...} then return end
local query = dbExec ( DBHandler , ...)
return query
end
function dbGet (...)
if not {...} then return end
local query = dbQuery ( DBHandler , ...)
local result = dbPoll ( query , - 1 )
return result
end
addEventHandler ( "onResourceStart" , resourceRoot , function()
DBHandler = dbConnect ( "mysql" , "dbname=" .. DBName .. ";host=" .. DBHost .. "" , DBUser , DBPass , "share=1" )
if DBHandler then
outputDebugString ( "* Connect to server MYSQL..." )
else
outputDebugString ( "* No Connecting to server MYSQL.." )
end
end )
local SQL_LOGIN = "db_16073"
local SQL_PASSWD = "1234CipaDylemata"
local SQL_DB = "db_16073"
local SQL_HOST = "mysql-fr1.ServerProject.pl"
local SQL_PORT = 3306
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
outputServerLog ( "BRAK POLACZENIA Z BAZA DANYCH!" )
else
-- mysql_query ( SQL , "SET NAMES utf8" )
-- outputServerLog ( "Modul mysql polaczony!" )
end
end
local function keepAlive ()
if ( not mysql_ping ( SQL )) then
outputServerLog ( "Zerwane polaczenie z baza danych, nawiazywanie..." )
connect ()
end
end
addEventHandler ( "onResourceStart" , getResourceRootElement (),function()
connect ()
setTimer ( keepAlive , 30000 , 0 )
end )
function esc ( value )
return mysql_escape_string ( SQL , value )
end
function pobierzTabeleWynikow ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then
outputDebugString ( "mysql_query failed: (" .. mysql_errno ( SQL ) .. ") " .. mysql_error ( SQL ))
outputServerLog ( "mysql_query failed: (" .. mysql_errno ( SQL ) .. ") " .. mysql_error ( SQL ))
return nil
end
local tabela ={}
for result , row in mysql_rows_assoc ( result ) do
table . insert ( tabela , row )
end
mysql_free_result ( result )
return tabela
end
function pobierzWyniki ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then return nil end
row = mysql_fetch_assoc ( result )
mysql_free_result ( result )
return row
end
function zapytanie ( query )
local result = mysql_query ( SQL , query )
if ( result ) then mysql_free_result ( result ) return true end
return
end
function insertID ()
return mysql_insert_id ( SQL )
end
function affectedRows ()
return mysql_affected_rows ( SQL )
end
function fetchRows ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then return nil end
local tabela ={}
while true do
local row = mysql_fetch_row ( result )
if ( not row ) then break end
table . insert ( tabela , row )
end
mysql_free_result ( result )
return tabela
end
function getSQLLink ()
return SQL
end
Więcej szczegółów Wystawiono 2 piw(a):Mitsoneq , DilerKacper
Wysłany: 2016-07-27, 12:45
mixLoLmix2 Programista Wiek: 35 4113 dni Nick w MP: TomeQmix
Piwa 1915
eee to nie jest dobry pomys? zeby dawac tu has?o
SQL = dbConnect ( "mysql" , "dbname=567871_BritishLife;host=mysql-fr1.ServerProject.pl" , "567871" , "1234CipaDylemata" , "share=1" ) [ Dodano : 2016-07-27, 12:47
-- Settings
DBHandler = nil
DBName = "567871_BritishLife"
DBUser = "567871"
DBPass = "has?o"
DBHost = "sql.pukawka.pl"
[ Dodano : 2016-07-27, 12:53
local SQL
local function connect ()
-- w ponizszej linii uzupelnij dane autoryzacji
SQL = dbConnect ( "mysql" , "dbname=db_16073;host=mysql-fr1.ServerProject.pl" , "db_16073" , "1234CipaDylemata" , "share=1" )
if ( not SQL ) then
outputServerLog ( "BRAK POLACZENIA Z BAZA DANYCH!" )
else
zapytanie ( "SET NAMES utf8;" )
end
end
addEventHandler ( "onResourceStart" , resourceRoot , connect )
function pobierzTabeleWynikow (...)
local h = dbQuery ( SQL ,...)
if ( not h ) then
return nil
end
local rows = dbPoll ( h , - 1 )
return rows
end
function pobierzWyniki (...)
local h = dbQuery ( SQL ,...)
if ( not h ) then
return nil
end
local rows = dbPoll ( h , - 1 )
if not rows then return nil end
return rows [ 1 ]
end
function zapytanie (...)
local h = dbQuery ( SQL ,...)
local result , numrows = dbPoll ( h ,- 1 )
return numrows
end
--[[
function insertID ()
return mysql_insert_id ( SQL )
end
function affectedRows ()
return mysql_affected_rows ( SQL )
end
]]--
function fetchRows ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then return nil end
local tabela ={}
while true do
local row = mysql_fetch_row ( result )
if ( not row ) then break end
table . insert ( tabela , row )
end
mysql_free_result ( result )
return tabela
end
--[[
Resource : OURGame v2
Developers : Split < split . programista @ gmail . com >
You have no right to use this code without my permission .
( c ) 2015 < split . programista @ gmail . com >. All rights reserved .
]]
-- Settings
DBHandler = nil
DBName = "db_16073"
DBUser = "db_16073"
DBPass = "1234CipaDylemata"
DBHost = "mysql-fr1.ServerProject.pl"
-- Functions
function dbSet (...)
if not {...} then return end
local query = dbExec ( DBHandler , ...)
return query
end
function dbGet (...)
if not {...} then return end
local query = dbQuery ( DBHandler , ...)
local result = dbPoll ( query , - 1 )
return result
end
addEventHandler ( "onResourceStart" , resourceRoot , function()
DBHandler = dbConnect ( "mysql" , "dbname=" .. DBName .. ";host=" .. DBHost .. "" , DBUser , DBPass , "share=1" )
if DBHandler then
outputDebugString ( "* Connect to server MYSQL..." )
else
outputDebugString ( "* No Connecting to server MYSQL.." )
end
end )
local SQL_LOGIN = "db_16073"
local SQL_PASSWD = "1234CipaDylemata"
local SQL_DB = "db_16073"
local SQL_HOST = "mysql-fr1.ServerProject.pl"
local SQL_PORT = 3306
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
outputServerLog ( "BRAK POLACZENIA Z BAZA DANYCH!" )
else
-- mysql_query ( SQL , "SET NAMES utf8" )
-- outputServerLog ( "Modul mysql polaczony!" )
end
end
local function keepAlive ()
if ( not mysql_ping ( SQL )) then
outputServerLog ( "Zerwane polaczenie z baza danych, nawiazywanie..." )
connect ()
end
end
addEventHandler ( "onResourceStart" , getResourceRootElement (),function()
connect ()
setTimer ( keepAlive , 30000 , 0 )
end )
function esc ( value )
return mysql_escape_string ( SQL , value )
end
function pobierzTabeleWynikow ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then
outputDebugString ( "mysql_query failed: (" .. mysql_errno ( SQL ) .. ") " .. mysql_error ( SQL ))
outputServerLog ( "mysql_query failed: (" .. mysql_errno ( SQL ) .. ") " .. mysql_error ( SQL ))
return nil
end
local tabela ={}
for result , row in mysql_rows_assoc ( result ) do
table . insert ( tabela , row )
end
mysql_free_result ( result )
return tabela
end
function pobierzWyniki ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then return nil end
row = mysql_fetch_assoc ( result )
mysql_free_result ( result )
return row
end
function zapytanie ( query )
local result = mysql_query ( SQL , query )
if ( result ) then mysql_free_result ( result ) return true end
return
end
function insertID ()
return mysql_insert_id ( SQL )
end
function affectedRows ()
return mysql_affected_rows ( SQL )
end
function fetchRows ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then return nil end
local tabela ={}
while true do
local row = mysql_fetch_row ( result )
if ( not row ) then break end
table . insert ( tabela , row )
end
mysql_free_result ( result )
return tabela
end
function getSQLLink ()
return SQL
end
Podpis
Zajmuję się pisaniem zaawansowanych skryptów lua na zamówienie za bardzo niską cene.
Tagi: baza :: danych :: mysql :: ourgame
Anonymous 245 dni
Anonymous Koniecznie zajrzyj na:
Piwa: 749
