Hey,few days i created lib for new quest function mysql.execute like mysql.query in lib for r2089. Today is a christmas and i publish this lib in elitepvpers. I'm from poland and i don't like polish forums becouse users is still rips from other country forums.
Virustotal:
My lib require libmysqlclient.so.18 and libstdc++.so.6
libmysqlclient.so.18
Virustotal:
libstdc++.so.6
Libs move to /usr/lib or for Freebsd x64 to /usr/lib32/
Usage libMysql:
Start game with command
For x64 (amd64):
For x32 (i386):
Add to quest_functions:
Quest example:
SELECT
Quest example #2
Note: If query is empty or error function return false (boolean)
UPDATE,INSERT,REPLACE,DELETE[..]
If you have problem with lib please send PM to me.
Thanks to iMer:)
Merry Christmas and sorry if my english is bad for reading this topic :p
THIS ONLY FOR REVISION 34083!!
Download:Code:
https://mega.co.nz/#!xswAEBAI!cOegNW8vRNg9hofph7IH0xXlf8tp6GZgRrg8SsCNWjo
Code:
http://www6.zippyshare.com/v/655717/file.html
Code:
https://www.virustotal.com/pl/file/2169bc2413fc0821ac057008277394cab557121a14150d4583a9c0c15de2ff82/analysis/1387912797/
libmysqlclient.so.18
Code:
https://mega.co.nz/#!Il4w1A7A!H-k0vSeNYDXCxBTELMavaCndNJcn4U020e-aw3Im5TM
Code:
http://www6.zippyshare.com/v/43921991/file.html
Code:
https://www.virustotal.com/pl/file/fdc974c402890fbf113ff40b978b1674dcd72b1dc2f091cdd59fbbf8a47303d4/analysis/1387912961/
Code:
http://imer.cc/files/libstdc++.so.6
Usage libMysql:
Start game with command
For x64 (amd64):
Code:
env LD_32_PRELOAD=./libMysql.so ./game
Code:
env LD_PRELOAD=./libMysql.so ./game
Code:
mysql.execute
SELECT
Code:
quest libmysql begin
state start begin
when login begin
local mysql = mysql.execute("SELECT name,level FROM player.player LIMIT 2")
say("Player 1: "..mysql[1][1].." Lv. "..mysql[1][2])
say("Player 2: "..mysql[2][1].." Lv. "..mysql[2][2])
end
end
end
Code:
quest libmysql begin
state start begin
when login begin
local mysql = mysql.execute("SELECT name,level FROM player.player LIMIT 2")
for key,value in pairs(mysql) do
say("Player"..key..": "..value[1].." Lv. "..value[2])
end
end
end
end
UPDATE,INSERT,REPLACE,DELETE[..]
Code:
quest libmysql begin
state start begin
when login begin
mysql.execute("UPDATE player.player SET level=99 WHERE level>99")
end
end
end
Thanks to iMer:)
Merry Christmas and sorry if my english is bad for reading this topic :p
