Dyanmic Object Spawning

[Secrets]

The victim:



Place it on the ground and...



Pick it up and it goes back into the inventory. Portable campfires for all!

SQL, uses item ID 999:

INSERT INTO items
   (`id`, `minstatus`, `Name`, `aagi`, `ac`, `accuracy`, `acha`, `adex`, `aint`, `artifactflag`, `asta`, `astr`, `attack`, `augrestrict`, `augslot1type`, `augslot1unk`, `augslot2type`, `augslot2unk`, `augslot3type`, `augslot3unk`, `augslot4type`, `augslot4unk`, `augslot5type`, `augslot5unk`, `augtype`, `avoidance`, `awis`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `banedmgamt`, `banedmgraceamt`, `banedmgbody`, `banedmgrace`, `bardtype`, `bardvalue`, `book`, `casttime`, `casttime_`, `charmfile`, `charmfileid`, `classes`, `color`, `combateffects`, `extradmgskill`, `extradmgamt`, `price`, `cr`, `damage`, `damageshield`, `deity`, `delay`, `augdistiller`, `dotshielding`, `dr`, `clicktype`, `clicklevel2`, `elemdmgtype`, `elemdmgamt`, `endur`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `filename`, `focuseffect`, `fr`, `fvnodrop`, `haste`, `clicklevel`, `hp`, `regen`, `icon`, `idfile`, `itemclass`, `itemtype`, `ldonprice`, `ldontheme`, `ldonsold`, `light`, `lore`, `loregroup`, `magic`, `mana`, `manaregen`, `enduranceregen`, `material`, `maxcharges`, `mr`, `nodrop`, `norent`, `pendingloreflag`, `pr`, `procrate`, `races`, `range`, `reclevel`, `recskill`, `reqlevel`, `sellrate`, `shielding`, `size`, `skillmodtype`, `skillmodvalue`, `slots`, `clickeffect`, `spellshield`, `strikethrough`, `stunresist`, `summonedflag`, `tradeskills`, `favor`, `weight`, `unknown002`, `unknown003`, `unknown005`, `unknown007`, `unknown018`, `unknown019`, `unknown020`, `UNK012`, `UNK013`, `benefitflag`, `unknown061`, `UNK054`, `unknown067`, `unknown069`, `UNK059`, `UNK061`, `unknown081`, `unknown105`, `booktype`, `unknown122`, `unknown123`, `unknown124`, `recastdelay`, `recasttype`, `guildfavor`, `unknown128`, `UNK123`, `UNK124`, `attuneable`, `nopet`, `unknown133`, `updated`, `comment`, `UNK127`, `pointtype`, `potionbelt`, `potionbeltslots`, `stacksize`, `notransfer`, `stackable`, `UNK134`, `UNK137`, `proceffect`, `proctype`, `proclevel2`, `proclevel`, `UNK142`, `worneffect`, `worntype`, `wornlevel2`, `wornlevel`, `UNK147`, `focustype`, `focuslevel2`, `focuslevel`, `UNK152`, `scrolleffect`, `scrolltype`, `scrolllevel2`, `scrolllevel`, `UNK157`, `serialized`, `verified`, `serialization`, `source`, `UNK033`, `lorefile`, `UNK014`, `svcorruption`, `UNK038`, `UNK060`, `augslot1unk2`, `augslot2unk2`, `augslot3unk2`, `augslot4unk2`, `augslot5unk2`, `UNK098`, `UNK109`, `UNK120`, `UNK121`, `questitemflag`, `UNK131`, `UNK132`, `clickunk5`, `clickunk6`, `clickunk7`, `procunk1`, `procunk2`, `procunk3`, `procunk4`, `procunk6`, `procunk7`, `wornunk1`, `wornunk2`, `wornunk3`, `wornunk4`, `wornunk5`, `wornunk6`, `wornunk7`, `focusunk1`, `focusunk2`, `focusunk3`, `focusunk4`, `focusunk5`, `focusunk6`, `focusunk7`, `scrollunk1`, `scrollunk2`, `scrollunk3`, `scrollunk4`, `scrollunk5`, `scrollunk6`, `scrollunk7`, `UNK193`, `purity`, `evolvinglevel`, `UNK129`)
VALUES
   (999, 0, 'Campfire of Doom', 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0, '1', 0, '1', 0, '1', 0, '1', 0, '1', 0, 0, 0, 4, 10, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '0', 65535, 4278190080, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, 0, 1103, 'IT78', 0, 1, 0, 0, '0', 0, 'Full Muffin Crate', -1, '0', 0, 0, 0, 0, -1, 0, 0, 255, 0, 0, 0, 32767, 0, 0, 0, 0, 1111, 0, '3', 255, 0, 0, -1, 0, 0, 0, 0, 0, 0, 30, '0', '0', '0', '0', '0', '0', '0', '0', '1', 0, '0', '0', '0', '0', '0', '0', '0', '0', 0, '0', '0', '0', 0, -1, 0, '0', '0', '0', '0', '0', '0', "10/21/2007 07:59:29", '', '0', 0, '0', '0', 20, '0', '0', '', '0', -1, '0', 0, 0, '0', -1, '0', 0, 0, '0', '0', 0, 0, '0', -1, '0', 0, 0, '0', "0/0/0000 00:00:00", "3/2/2006 15:27:54", '', '13THFLOOR', '0', '', 0, 0, '0', '0', '0', '0', '0', '0', '0', '0', '0', -1, '0', '0', '0', '0', '0', '', 0, '0', '0', '0', '0', '', '0', 0, '0', '0', '0', '0', '', '0', 0, 0, '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '0', 0, 0, 0, 0);

I didn't bother making it a container, but I bet you could make it one and store items in it, drop it, and have someone come along and take your campfire, put more items in it, etc.

This works with all objects that have a model file, too. Imagine actual portable tradeskill stations, you could make a quest command to depop and repop the item and you could use it as a tradeskill station, when you are done trigger the quest again and put the tradeskill item back on the cursor. I would like to see this done if not for eqemulator functionality, but if for something like EQBots unique to show the limits of the client.

of course i'm kind of lost at the coding part of that...

but hey, I can dream can't I? :p

edited: forgot SQL.

[Deimos]

The problem we were discussing is making it so that it can't be picked up.

[Deimos]

So... anyone make any progress on this yet? : p