Error with prestige npc

[DestinationSer]

Theres a error with my prestige npc.
When player prestiges he stays at the same level, he doesnt get lvl 8 so players of my OT have been abusing this. How do i fix?
version 0.4

Hurry!
Thanks

 

[Sir Bananas]

Post the script here, else we cant help you.

 

[DestinationSer]

local keywordHandler = KeywordHandler:new()
local npcHandler = NpcHandler:new(keywordHandler)
NpcSystem.parseParameters(npcHandler)
local Topic = {}

local reborn = 2500 -- free storage
local spellReborn = {
	[1] = 'Reborn1',
	[5] = 'Reborn5',
	[10] = 'Reborn10',
	[25] = 'Reborn25',
	[50] = 'Reborn50',
	[100] = 'Reborn100',
	[250] = 'Reborn250',
	[500] = 'Reborn500'
}
local level = 717217
local maxReborns = 120
local toLevel = 100

function onCreatureAppear(cid)				npcHandler:onCreatureAppear(cid) end
function onCreatureDisappear(cid)			npcHandler:onCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg)			npcHandler:onCreatureSay(cid, type, msg) end
function onThink()					npcHandler:onThink() end

function greetCallback(cid)
	Topic[cid] = nil
	return true
end

function creatureSayCallback(cid, type, msg)
	if not npcHandler:isFocused(cid) then
		return false
	elseif Topic[cid] then
		if msgcontains(msg, 'yes') then
			if getCreatureStorage(cid, reborn) < maxReborns then
				doCreatureSetStorage(cid, reborn, math.max(0, getCreatureStorage(cid, reborn)) + 1)
				for k, v in pairs(spellReborn) do
					if getCreatureStorage(cid, reborn) == k then
						doPlayerLearnInstantSpell(cid, v)
						doSendMagicEffect(getThingPosition(cid), CONST_ME_FIREWORK_RED)
						break
					end
				end
				
				local g = getPlayerGUID(cid)
				npcHandler:releaseFocus(cid)
				doRemoveCreature(cid)
				db.executeQuery('UPDATE players SET level=99,experience=15219400 WHERE id=' .. g)
			else
				npcHandler:say('You reached maximum amount of reborns.', cid)
			end
		else
			npcHandler:say('Maybe next time.', cid)
		end
		Topic[cid] = nil
	else
		if msgcontains(msg, 'reborn') then
			if getPlayerLevel(cid) >= level then
				npcHandler:say('Are you sure that you want to make reborn?',cid)
				Topic[cid] = 1
			else
				npcHandler:say('You don\'t have enough level. ['..level..']',cid)
				Topic[cid] = nil
			end
		end
	end
	return true
end

npcHandler:setCallback(CALLBACK_GREET, greetCallback)
npcHandler:setCallback(CALLBACK_MESSAGE_DEFAULT, creatureSayCallback)
npcHandler:addModule(FocusModule:new())

 

[Korrex]

> db.executeQuery('UPDATE players SET level=99,experience=15219400 WHERE id=' .. g)
u fucking serious?

 

[DestinationSer]

yea :O

 

[Korrex]

yea :O

First of all, where would it get the GUID to reset level on?
Secondly, no need to set experience if you set level.
Thirdly, if you want it to set level to 8, why on earth do you make it set level to 99?

 

[DestinationSer]

Do you rly need to ask questions? Cant you just help me please >.<

 

[Cyro]

db.executeQuery("UPDATE `players` SET level = " .. level .. " WHERE id = " .. guid .. ";")

 

[Korrex]

db.executeQuery("UPDATE `players` SET level = " .. level .. " WHERE id = " .. guid .. ";")

Uh what? xD

db.executeQuery("UPDATE `players` SET `level` = 8 WHERE `id` = "..getPlayerGUID(cid)..";")

 

[Dkadsfe]

How would I make this script make spells based on prestiges and gain spells per perstige?