An Idea, need help

[mfghs]

ive been asking around a few server ops, mainly the legit servers, and ive come to the conclusion that they dont make non-legit servers because the lack of challenge or purpose, sure, many will argue about what you can do on a non legit server, hey, even i love non legit, but after awhile, it gets old.

So i propose an idea, and i will prolly need quite a bit of help, thats why im posting this.

I want to create a Semi/Non-legit server, where you can summon and level, but summoning is restricted to droppables and all no drops will become tradeable, but gm summon only. Im not quite sure on how possible this is, due to the abundance of no drop items, unless i restrict it to PoP and Luclin items and allow the summoning of all else.

This creates a purpose, you can make your toon as uber as you can buy in the bazaar with unlimited plat, and then to get other items, ie. Raex, Bidilis. by bartering with other players or hunting for yourself. Right now ill work on getting the server up and running, if you have any imput, post here or email me at mfghs@yahoo.com.

I dont know SQL too well but it is possable to turn all nodrop items into GM summonable only br running a SQL command.

[m0oni9]

If I'm reading the flags correctly, the following should set all nodrop items to be gm-only, and then set all of the gm items to not be nodrop:

UPDATE items SET gmflag=1 WHERE nodrop=255;
UPDATE items SET nodrop=0 WHERE gmflag=1;

edit: oops, meant sets to be _not_ nodrop

[mfghs]

alrighty then lol, thanks for the help, guess i can pull this off solo, now just to get the server running =)

[mfghs]

On second thought, this seems a tad more complicated, if anyone wants to pick this idea up and run with it, go ahead. I dont want to bother anyone with the "Suchandsuch isnt working, can someone help" messages lol


All i ask, is if you use this idea, just email me and let me know hehe so i know what server to log into :lol: