[Lua-SQL Extension] Crystal By Mob

[hetser 0]

On 4/18/2020 at 9:47 PM, Angelix said:

@Legacy & @hetser.

This is the content within that rar file.
 

print("* Loading CrystalByMob Extension <init.lua>")
--[[ IGS Crystal By Mob Extension made By Vasil pkoDev,Please do not claim or redistribute the credits :)
*Requirements:
-LuaSQL by Wrexor
-TradeServer Program
-TradeDB 
-SQL 2008 or higher

*Configuration:
I guess the example i gave is clear
Just if you're going to use .\SQLEXPRESS , make it x2 dashes otherwise it will be as .SQLEXPRESS
e.g : .\\SQLEXPRESS

Just change the map that the function will run inside and the monster ID that will give the IGSP

If encountering any bug or flaw or glitch,please contact me - Vasil

--]]
SQLConnector = {};
SQLConnector.sql = { host = "127.0.0.1\\SQLEXPRESS", user = "sa", pass = "Y87dc#$98", db = "TradeDB" };

CrystalByMobHook = GetExp_PKM
GetExp_PKM = function( dead , atk , money  )
	CrystalByMobHook(dead,atk, money)
	local DeadMonster = GetChaID(dead)
	local accountName = GetActName(atk)
	local Money = Money
	local Rum = { };
	Rum['Money'] = Money;

	if(GetChaMapName(atk) == "garner" or GetChaMapName(atk) == "crystal") then
		if(DeadMonster == 1526)then
			QueryAsync(
			SQLConnector.sql['host'],
			SQLConnector.sql['user'],
			SQLConnector.sql['pass'],
			"UPDATE "..SQLConnector.sql['db']..".dbo.AccountInfo SET Money = Money + 1 WHERE accName = '"..accountName.."'"
	);
			BickerNotice( atk, "[IGSP]:You have obtained 1 IGS Crystal from "..GetChaDefaultName(dead) )
		end 
	end
end

Please take into consideration this: 

 

thx a lot!!!!

[eatsangels 2]

On 7/8/2017 at 3:31 AM, Faller said:

Hey, @johan!

You don't need to worry about the points, it's a "show-only" thing. There's no points exchanger or such functions in the IGS itself. When you click in the "Exchange" button, it will simply take you to IGG's website which had the exchange function in PHP.

Do you know how I can change mall points for IG since I tried it but the page gives me an error