Naming Weapons?

[merb]

I had an idea for a quest where, depending on the player's class, they get a weapon (i.e. 2hs for knights, 1hs for warriors, bards, etc., staff for int casters, etc.) based on parts they turn in. Once they turn in all of the parts, for example the 4 pieces of a staff, it generates a random staff from a list where the rare ones have a lower chance of being generated. Once the player receives the staff, they turn it back in to the NPC and they get a chance to name it and the weapon is returned with the name they chose.

I thought that might be a little hard to do, or maybe it isn't even possible, so, is it possible to let players name a weapon?

[ChaosSlayer]

the whole thing is easy except the naming part.
you could settle for- NPC offering player list of named and player choose one.
but you will actualy make THAT many actual identical items
So if you offering player 20 names to choose from that 20 actual items must be made for single weapons type.
now multyply that by all classes and by all types =)
you looking at rathly 2.5k of items to make =)

now truly best part IF players could actualy name a weapon =)
which means quest code woudl have to activly writign in sql DB
3 weeeks after your server is up the server will crush your players will be generating new names 500 a day
and Db can only hold 100k items max =)

[Knightly]

If you're truly interested in just changing the names on weapons, I can see it being done with custom code (not live-like). But similar to the way that the "Made By:" flag is done on live.

Item name becomes a flag that references back to a specific item number so that there's no duplicate data. And since each named item just has the same stats with a different name, the name becomes more of a flag than anything else.

[loglos]

Originally Posted by ChaosSlayer

your players will be generating new names 500 a day and Db can only hold 100k items max =)

Not to derail but is that an application limit? Is that because all items are loaded into shared mem at startup?

Thanks.

[cavedude]

Originally Posted by loglos

Not to derail but is that an application limit? Is that because all items are loaded into shared mem at startup?

Thanks.

Yes, and yes. The limit can be changed of course very easily, but upping the limit too much will fill your shared memory up quickly. It doesn't use memory as it needs it, rather uses all of the memory it is told to reserve at once.