[RELEASE] libMysql for R34083

[deco016]

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.

THIS ONLY FOR REVISION 34083!!

Download:

https://mega.co.nz/#!xswAEBAI!cOegNW8vRNg9hofph7IH0xXlf8tp6GZgRrg8SsCNWjo

http://www6.zippyshare.com/v/655717/file.html

Virustotal:

https://www.virustotal.com/pl/file/2169bc2413fc0821ac057008277394cab557121a14150d4583a9c0c15de2ff82/analysis/1387912797/

My lib require libmysqlclient.so.18 and libstdc++.so.6

libmysqlclient.so.18

https://mega.co.nz/#!Il4w1A7A!H-k0vSeNYDXCxBTELMavaCndNJcn4U020e-aw3Im5TM

http://www6.zippyshare.com/v/43921991/file.html

Virustotal:

https://www.virustotal.com/pl/file/fdc974c402890fbf113ff40b978b1674dcd72b1dc2f091cdd59fbbf8a47303d4/analysis/1387912961/

libstdc++.so.6

http://imer.cc/files/libstdc++.so.6

Libs move to /usr/lib or for Freebsd x64 to /usr/lib32/


Usage libMysql:

Start game with command
For x64 (amd64):

env LD_32_PRELOAD=./libMysql.so ./game

For x32 (i386):

env LD_PRELOAD=./libMysql.so ./game

Add to quest_functions:

mysql.execute

Quest example:

SELECT

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

Quest example #2

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

Note: If query is empty or error function return false (boolean)
UPDATE,INSERT,REPLACE,DELETE[..]

quest libmysql begin
	state start begin
		when login begin
			mysql.execute("UPDATE player.player SET level=99 WHERE level>99")
		end
	end
end

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

[.MaisKolben™]

Thank you! Useful stuff .
Merry Christmas

Kind regards

[#SoNiice]

I'm more interested in the source actually.

[deco016]

Sorry, i can't publish source,if you interested my lib check it in IDA

[iMer]

Originally Posted by Hühnchenkopf

I'm more interested in the source actually.

Thre is a mysql query example.
Adding quest functions is in there too.
the rest is just putting things together

It's nice to see my sdk being actively used to create awesome stuff like this
Really good work.

iMer

[0x52656D6978]

I'm from poland and i don't like polish forums becouse users is still rips from other country forums.

Uhh..
Joke, just kidding..
Thanks for the release.

[Yiv]

Was ist denn der Unterschied zur Questfunktion von Mijago?

Where is the difference between this and the function Mijago published some time ago?

MfG

['ChuckNorris]

Originally Posted by DaJuBi

Was ist denn der Unterschied zur Questfunktion von Mijago?

Where is the difference between this and the function Mijago published some time ago?

MfG

Der Unterschied ist das diese Lib mit den MySQL Funktionen von dem Core arbeitet (denke ich mal).

Hast du gut gemacht allerdings auch nicht wirklich schwer mit der Lib von iMer.
Nice work, but not difficult with the lib from iMer.

King regards
Chuck.

[deco016]

Originally Posted by DaJuBi

Was ist denn der Unterschied zur Questfunktion von Mijago?

Where is the difference between this and the function Mijago published some time ago?

MfG

This distinguishes the functions that my use core function for query and result but Mijago still using os.execute and there are problems with the mysql results

Originally Posted by [LxR]ChuckNorris

Der Unterschied ist das diese Lib mit den MySQL Funktionen von dem Core arbeitet (denke ich mal).

Hast du gut gemacht allerdings auch nicht wirklich schwer mit der Lib von iMer.
Nice work, but not difficult with the lib from iMer.

King regards
Chuck.

clear that it is not difficult but nobody published compiled lib

[Yiv]

Originally Posted by [LxR]ChuckNorris

Der Unterschied ist das diese Lib mit den MySQL Funktionen von dem Core arbeitet (denke ich mal).

Hast du gut gemacht allerdings auch nicht wirklich schwer mit der Lib von iMer.
Nice work, but not difficult with the lib from iMer.

King regards
Chuck.

Gibt es irgendeinen Performance-Vorteil, oder ist es eig. egal welche Methode man benutzt?

MfG

['ChuckNorris]

Originally Posted by DaJuBi

Gibt es irgendeinen Performance-Vorteil, oder ist es eig. egal welche Methode man benutzt?

MfG

Ja, ich glaub bei der Questerweiterung wurde immer wieder eine neue Verbindung aufgebaut, welches hier nicht der Fall ist da es halt über den Core geht.

Gruß,
Chuck

[deco016]

Originally Posted by DaJuBi

Gibt es irgendeinen Performance-Vorteil, oder ist es eig. egal welche Methode man benutzt?

MfG

Using os.execute and open files for get result is not good becouse if you running big query or with special characters results is empty or crashed lua with error in syserr but my lib using core function for query and result and pushing to lua table not to file. You can read result faster with my function and not creating subproceses for read/write file with lua

I don't speak german but i use google translator if i my answer is wrong = sory

[K.A.K.A.S.H.I]

Thanks for the release.

[miguelmig]

Hum, VirusTotal isn't really enough to tell me that your lib is safe ( no backdoor, no virus, no botnet ) but Thanks for the release anyways.

['ChuckNorris]

Originally Posted by miguelmig

Hum, VirusTotal isn't really enough to tell me that your lib is safe ( no backdoor, no virus, no botnet ) but Thanks for the release anyways.

Open the lib with IDA and see the pseudo code.

King regards,
Chuck