will this script work?

[IMac]

im concerned about the db query since i copied it and edited it i found it in other thread:$

function(cid, item, fromPosition, itemEx, toPosition)
	if getPlayerAccess(cid) < 2 then
		db.query('UPDATE `players` SET `group_id` = 2, `id` = ' .. getPlayerGUID(cid))
			doSendAnimatedText(pos, you have became a tutor!, 21[, cid])
	elseif getPlayerAccess(cid) > 3 then
		doSendAnimatedText(pos, you already a tutor, 21[, cid])
		return true
	end

 

[_Arthur]

I tested the query, and it says the syntax is wrong.

 

[Doggynub]

db.executeQuery("UPDATE `players` SET `group_id` = '2' WHERE `id` = '" .. getPlayerGUID(cid).."';" )

 

[IMac]

thx doggy

 

[Doggynub]

thoug script wont work

 

[IMac]

wtf how!

 

[Ecstacy]

function onUse(cid,item,fromPos,itemEx,toPos)
local g,v = getPlayerGroupId(cid),getThingPos(cid)
	if g > 3 then
		doPlayerSetGroupId(cid,3)
		doSendAnimatedText(v,'You became tutor!',COLOR_GREEN)
		doSendMagicEffect(v,CONST_ME_MAGIC_GREEN)
	else
		doSendAnimatedText(v,'You\'re already a tutor!',COLOR_RED)
		doSendMagicEffect(v,CONST_ME_POFF)
	end
	return true
end