Or without any loops:
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
local maps = {
garner = true,
crystal = true
}
GetExp_PKM = function( dead , atk , money )
CrystalByMobHook(dead,atk, money)
local DeadMonster = GetChaID(dead)
local accountName = GetActName(atk)
local currentMap = GetChaMapName(atk)
if maps[currentMap] 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