Code: Select all

function spawn(NPC)
	SetPlayerProximityFunction(NPC, 20, "InRange", "LeavingRange")
end

function InRange(NPC, Spawn)
	Say(NPC, "Hey, you've come within 20 meters of me!", Spawn)
end

function LeavingRange(NPC, Spawn)
	Say(NPC, "You're now outside my 20 meter radius of checking for spawns.", Spawn)
end

function respawn(NPC)
	spawn(NPC)
end

function hailed(NPC, Spawn)
	FaceTarget(NPC, Spawn)
	conversation = CreateConversation()
	
	AddConversationOption(conversation, "Just great thanks, and yourself?", "GreatThanks")
	AddConversationOption(conversation, "Grande.")
	StartConversation(conversation, NPC, Spawn, "Hey there " .. GetName(Spawn) .. ", how are ya doin' today?")
end

function hailed_busy(NPC, Spawn)
	Say(NPC, "You've hailed me while I'm busy like fighting.", Spawn)
end

function targeted(NPC, Spawn)
	Say(NPC, "You've targeted me.", Spawn)
end

function attacked(NPC, Spawn)
	Say(NPC, "You've attacked me.", Spawn)
end

function healthchanged(NPC, Spawn)
	Say(NPC, "My health has changed.", Spawn)
end

function aggro(NPC, Spawn)
	Say(NPC, "This is called when you first attack me.", Spawn)
end

function killed(NPC, Spawn)
	Say(NPC, "I've killed you!", Spawn)
end

function death(NPC, Spawn)
	Say(NPC, "You've killed me :(", Spawn)
end

function casted_on(NPC, Spawn, SpellName)
	Say(NPC, "You casted " .. SpellName .. " on me!", Spawn)
end

-----------------------------------------------------------------------------
--			functions to handle the extended conversations from hailed
-----------------------------------------------------------------------------

function GreatThanks(NPC, Spawn)
	FaceTarget(NPC, Spawn)
	conversation = CreateConversation()
	
	AddConversationOption(conversation, "Good to hear..")
	StartConversation(conversation, NPC, Spawn, "Wonderful!")
end

Code: Select all

insert into items (name, item_type,icon,weight,description,sell_price,lua_script) values ('Basic Backpack','Bag', 10,5,'A 4 slot bag with 5 perc reduction',10,'');

Code: Select all

select id,name from items where name like '%Basic Backpack%';

Code: Select all

insert into item_details_bag (item_id,num_slots,weight_reduction) values (1,4,5);