I need help fast!!! how can i let players open the quest when they alredy opened!

otaf · Nov 25, 2009

I need help fast!!! how can i let players open the quest´again when they alredy opened! becuase its happend something on my server all the items on the houses have been removed!

but the players is still left but i want them open the quests! so they dont complain where is my stuff they can do it over again!

tfs: 0.3.5

otaf · Nov 25, 2009

i need fast help!

Erikas Kontenis · Nov 25, 2009

Change Storage to new...

otaf · Nov 25, 2009

where is it?

Erikas Kontenis · Nov 25, 2009

Code:

--- Scripted By Apsivaflines ---



-- 10544 = PoI Arcane Staff.
-- 10545 = PoI Avenger.
-- 10546 = PoI Arbalest.
-- 10547 = PoI Soft Boots.
-- 10548 = PoI BackPack of Holding.
-- 10549 = PoI Stuffed Dragon.
-- 10550 = PoI Frozen Starlight.
-- 10551 = PoI Ceremonial Ankh
-- 10552 = Holy Tible

function onUse(cid, item, frompos, item2, topos)

	if item.uid == 10544 then
if getPlayerStorageValue(cid,10544) == -1 then -- this one.. change all of it...
 	doPlayerSendTextMessage(cid,25,"You have chosen an arcane staff.")
 	doPlayerAddItem(cid,2453,1)
 	setPlayerStorageValue(cid,10544,1) -- this one.. change all of it.
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
 
	elseif item.uid == 10545 then
if getPlayerStorageValue(cid,10544) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have chosen the avenger.")
 	doPlayerAddItem(cid,6528,1)
 	setPlayerStorageValue(cid,10544,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
 
 	elseif item.uid == 10546 then
if getPlayerStorageValue(cid,10544) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have chosen an arbalest.")
 	doPlayerAddItem(cid,5803,1)
 	setPlayerStorageValue(cid,10544,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
 
	elseif item.uid == 10547 then
if getPlayerStorageValue(cid,10547) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have found a pair of soft boots.")
 	doPlayerAddItem(cid,6132,1)
 	setPlayerStorageValue(cid,10547,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end

	elseif item.uid == 10548 then
ids = {2273, 2268, 2313, 2311}
charges = {10, 10, 30, 50}
if getPlayerStorageValue(cid,10548) == -1 then
 	setPlayerStorageValue(cid,10548,1)
		bp = doPlayerAddItem(cid, 2365, 1)
		for i = 1, #ids do
			doAddContainerItem(bp, ids[i], charges[i])
		end
	else
doPlayerSendTextMessage(cid,25,"It is empty.")
	end 


	elseif item.uid == 10549 then
if getPlayerStorageValue(cid,10549) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have found a stuffed dragon.")
 	doPlayerAddItem(cid,5791,1)
 	setPlayerStorageValue(cid,10549,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
	elseif item.uid == 10550 then
if getPlayerStorageValue(cid,10550) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have found a frozen starlight.")
 	doPlayerAddItem(cid,2361,1)
 	setPlayerStorageValue(cid,10550,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
 
 	elseif item.uid == 10551 then
if getPlayerStorageValue(cid,10551) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have found a ceremonial ankh.")
 	doPlayerAddItem(cid,6561,1)
 	setPlayerStorageValue(cid,10551,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
	elseif item.uid == 10552 then
 
if getPlayerStorageValue(cid,10552) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have found the holy Tible.")
 	local book = doPlayerAddItem(cid,1970,1)
 	doSetItemText(book,"Banor I praise your name.\nBe with me in the battle.\nBe my shield, let me be your sword.\nI will honour the godly spark in my soul. May it flourish and grow.")
 	setPlayerStorageValue(cid,10552,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end

end
return TRUE
end

Erikas Kontenis · Nov 25, 2009

or goto phpmyadmin go to ur server database etc find this table "player_storage" and delete everything...

and now rep me

otaf · Nov 25, 2009

i cant delet it!

Erikas Kontenis · Nov 25, 2009

you dont need do delete it you need to empty it... make it empty.

and rep me !

otaf · Nov 25, 2009

its write you dont have write code to the tigger!

JDB · Nov 25, 2009

I suggest using my chest scripts.

http://otland.net/f81/adv-reward-chests-0-3-5-a-55191/

otaf · Nov 25, 2009

JDB said:
I suggest using my chest scripts.

http://otland.net/f81/adv-reward-chests-0-3-5-a-55191/

its not about the scripts i have alredy the scripts but i want the players open the chest again! when they alredy open it befor!

Erikas Kontenis · Nov 25, 2009

he mean how to delete all quests chest that mean storage becouse he make fail he wanna delete all storages then players can do quests again... and the point is i think he dont know how to make it

otaf · Nov 25, 2009

yes i dont know :S can you give me some pictures

Cykotitan · Nov 25, 2009

apsivaflines said:

Code:

--- Scripted By Apsivaflines ---



-- 10544 = PoI Arcane Staff.
-- 10545 = PoI Avenger.
-- 10546 = PoI Arbalest.
-- 10547 = PoI Soft Boots.
-- 10548 = PoI BackPack of Holding.
-- 10549 = PoI Stuffed Dragon.
-- 10550 = PoI Frozen Starlight.
-- 10551 = PoI Ceremonial Ankh
-- 10552 = Holy Tible

function onUse(cid, item, frompos, item2, topos)

	if item.uid == 10544 then
if getPlayerStorageValue(cid,10544) == -1 then -- this one.. change all of it...
 	doPlayerSendTextMessage(cid,25,"You have chosen an arcane staff.")
 	doPlayerAddItem(cid,2453,1)
 	setPlayerStorageValue(cid,10544,1) -- this one.. change all of it.
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
 
	elseif item.uid == 10545 then
if getPlayerStorageValue(cid,10544) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have chosen the avenger.")
 	doPlayerAddItem(cid,6528,1)
 	setPlayerStorageValue(cid,10544,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
 
 	elseif item.uid == 10546 then
if getPlayerStorageValue(cid,10544) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have chosen an arbalest.")
 	doPlayerAddItem(cid,5803,1)
 	setPlayerStorageValue(cid,10544,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
 
	elseif item.uid == 10547 then
if getPlayerStorageValue(cid,10547) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have found a pair of soft boots.")
 	doPlayerAddItem(cid,6132,1)
 	setPlayerStorageValue(cid,10547,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end

	elseif item.uid == 10548 then
ids = {2273, 2268, 2313, 2311}
charges = {10, 10, 30, 50}
if getPlayerStorageValue(cid,10548) == -1 then
 	setPlayerStorageValue(cid,10548,1)
		bp = doPlayerAddItem(cid, 2365, 1)
		for i = 1, #ids do
			doAddContainerItem(bp, ids[i], charges[i])
		end
	else
doPlayerSendTextMessage(cid,25,"It is empty.")
	end 


	elseif item.uid == 10549 then
if getPlayerStorageValue(cid,10549) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have found a stuffed dragon.")
 	doPlayerAddItem(cid,5791,1)
 	setPlayerStorageValue(cid,10549,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
	elseif item.uid == 10550 then
if getPlayerStorageValue(cid,10550) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have found a frozen starlight.")
 	doPlayerAddItem(cid,2361,1)
 	setPlayerStorageValue(cid,10550,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
 
 	elseif item.uid == 10551 then
if getPlayerStorageValue(cid,10551) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have found a ceremonial ankh.")
 	doPlayerAddItem(cid,6561,1)
 	setPlayerStorageValue(cid,10551,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end
	elseif item.uid == 10552 then
 
if getPlayerStorageValue(cid,10552) == -1 then
 	doPlayerSendTextMessage(cid,25,"You have found the holy Tible.")
 	local book = doPlayerAddItem(cid,1970,1)
 	doSetItemText(book,"Banor I praise your name.\nBe with me in the battle.\nBe my shield, let me be your sword.\nI will honour the godly spark in my soul. May it flourish and grow.")
 	setPlayerStorageValue(cid,10552,1)
 else
 	doPlayerSendTextMessage(cid,25,"It is empty.")
 end

end
return TRUE
end

oo thats a script i made a year ago

Erikas Kontenis · Nov 25, 2009

Cykotitan said:
oo thats a script i made a year ago

i was copy it

and rewrite all all self

the same text just for lern lua

i too got it year ago

how much time's i wrote rep me ?

Cykotitan · Nov 25, 2009

apsivaflines said:
how much time's i wrote rep me ?

lolwut

PHP:

DELETE FROM player_storage

or

PHP:

TRUNCATE TABLE player_storage

I need help fast!!! how can i let players open the quest when they alredy opened!

otaf

New Member

otaf

New Member

Erikas Kontenis

Board Moderator

otaf

New Member

Erikas Kontenis

Board Moderator

Erikas Kontenis

Board Moderator

otaf

New Member

Erikas Kontenis

Board Moderator

otaf

New Member

JDB

OtLand Veteran

otaf

New Member

Erikas Kontenis

Board Moderator

otaf

New Member

Cykotitan

Experienced G'

Erikas Kontenis

Board Moderator

Cykotitan

Experienced G'

Similar threads