Just log in: http://localhost/phpmyadmin and and click on the left corner on icon SQL and there put this code
function onKill(cid, target)
if(isMonster(target) == TRUE) then
if getCreatureMaster(target) == target then
local name = getCreatureName(target)
local monsterkills = db.getResult("SELECT mid, kills FROM vorgpl_monsterskills WHERE name = '" .. name .. "' LIMIT 1")
if(monsterkills:getID() ~= -1) then
db.executeQuery("UPDATE vorgpl_monsterskills SET kills = " .. (monsterkills:getDataInt("kills") + 1) .. " WHERE mid = " .. monsterkills:getDataInt("mid") .. " LIMIT 1")
else
db.executeQuery("INSERT INTO vorgpl_monsterskills (name, kills) VALUES ('" .. name .. "', 1)")
end
end
end
return TRUE
end
function onKill(cid, target)
local allowed = { -- allowed pets, costs & level required
["cat"], ["dog"], , ["deer"] , ["pig"], ["parrot"], ["seagull"], ["chicken"], ["rabbit"],
["squirrel"], ["frog"], ["rat"], ["sheep"], ["wolf"], ["skeleton"], ["war wolf"], ["demon skeleton"]}
if allowed[name] == getCreatureName(target) then
if(isMonster(target) == TRUE)then
if getCreatureMaster(target) == target then
local name =
local monsterkills = db.getResult("SELECT mid, kills FROM vorgpl_monsterskills WHERE name = '" .. name .. "' LIMIT 1")
if(monsterkills:getID() ~= -1) then
db.executeQuery("UPDATE vorgpl_monsterskills SET kills = " .. (monsterkills:getDataInt("kills") + 1) .. " WHERE mid = " .. monsterkills:getDataInt("mid") .. " LIMIT 1")
else
db.executeQuery("INSERT INTO vorgpl_monsterskills (name, kills) VALUES ('" .. name .. "', 1)")
end
end
end
end
return TRUE
end