Lamp Quest

[bomba]

My lamp quest don't are working:

 local timeSec = 5

function onUse(cid, item, fromPosition, itemEx, toPosition)
	if ((getPlayerAccess(cid) == 0) or (getPlayerAccess(cid) == 1)) then
	if getPlayerStorageValue(cid, 2044) == FALSE then
	   doPlayerAddItem(cid, 2044, 1)
	   doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have found a Lamp.")
	   addEvent(autoMsg, timeSec*1000, cid)
	   setPlayerStorageValue(cid, 2044, TRUE)
	 elseif getPlayerStorageValue(cid, 2044) == TRUE then
	   doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "It is empty.")
  end
 end
  return TRUE
end

function autoMsg(cid)
	   doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You now have a lamp. Try leaving your house again.")
 return TRUE
end

 

[bomba]

Fix please!

 

[EvulMastah]

function onUse(cid, item, fromPosition, itemEx, toPosition)
	local timeSec = 5
	local access = 1
	if getPlayerGroupId(cid) <= access then
		if getPlayerStorageValue(cid, 2044) == FALSE then
			doPlayerAddItem(cid, 2044, 1)
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have found a Lamp.")
			addEvent(autoMsg, timeSec * 1000, cid)
			setPlayerStorageValue(cid, 2044, TRUE)
		else
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "It is empty.")
		end
	end
  return TRUE
end

function autoMsg(cid)
	return doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You now have a lamp. Try leaving your house again.")
end

 

[bomba]

It's empty.

 

[EvulMastah]

DELETE FROM `player_storage` WHERE `key` =2044

 

[bomba]

DELETE FROM `player_storage` WHERE `key` =2044

What is?

 

[EvulMastah]

Run it in your database.
localhost/phpmyadmin at the SQL-Command Line thingy.

 

[bomba]

I use sqlite:

	-- Database
	-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
	-- To disable sqlKeepAlive use 0 value.
	sqlType = "sqlite"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = ""
	sqlDatabase = "theforgottenserver"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 60
	passwordType = "plain"

 

[EvulMastah]

I use sqlite:

	-- Database
	-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
	-- To disable sqlKeepAlive use 0 value.
	sqlType = "sqlite"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = ""
	sqlDatabase = "theforgottenserver"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 60
	passwordType = "plain"

Then use sqlitemanager to delete from player_storage records with key 2044, or set it in the script to another one, 2045.