Unstucker command

[thugj]

I need a reset to home temple command even if they aren't logged in...like reset to thais in game without having to edit sql database >.<...And a working Promotion npc script for 8.42

heres my scripts that wont work

<?xml version="1.0"

encoding="UTF-8"?>
<npc

name="Promoter"

script="data/npc/scripts/pro

motion.lua"

walkinterval="2000"

floorchange="0">


<health now="100"

max="100"/>
<look

type="133" head="20"

body="39" legs="45" feet="7"

addons="0"/>
</npc>

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

function onCreatureAppear(cid) npcHandlernCreatureAppear(cid) end
function onCreatureDisappear(cid) npcHandlernCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg) npcHandlernCreatureSay(cid, type, msg) end
function onThink() npcHandlernThink() end

local node1 = keywordHandler:addKeyword({'promot'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'I

can promote you for 20000 gold coins. Do you want me to promote you?'})
node1:addChildKeyword({'yes'}, StdModule.promotePlayer, {npcHandler = npcHandler, cost = 20000, level = 20, promotion = 1,

text = 'Congratulations! You are now promoted.'})
node1:addChildKeyword({'no'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'Alright then, come back

when you are ready.', reset = true})
--[[
local node2 = keywordHandler:addKeyword({'epic'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'I can

epicize you for 200000 gold coins. Do you want me to epicize you?'})
node2:addChildKeyword({'yes'}, StdModule.promotePlayer, {npcHandler = npcHandler, cost = 200000, level = 120, promotion =

2, text = 'Congratulations! You are now epicized.'})
node2:addChildKeyword({'no'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'Alright then, come back

when you are ready.', reset = true})
]]--

npcHandler:addModule(FocusModule:new())

 

[Cykotitan]

If the player is offline, you have to execute a SQL query.

 

[thugj]

If the player is offline, you have to execute a SQL query.

well can i make a command to execute a sql query? >.> I just get tired of resetting it 50 times >.<