[SQL/2.3] General Help?

[WasteMan]

Right.. I've got my server working offline, everythings fine etc..
Just need to ask a few questions...
1. Where is a full list of commands?
Not the on in the folder, as some don't work and I must be doing it wrong - but if anyone has some, which are like "@level <username> <level> & @make <item> <amount>" etc. that would be awesome.

2. Secondly, In SQL do I have to do something to enable spells? Because I level myself to 500, @make twindrakeblade, and then @changejob gamemaster warr, so i'm a warrior, but it still comes up with red asif im not a warrior / lvl32+.. And then I convert myself to a wizard, @make blizzard, thats white but click to learn and nowt happens?
Reason?^

3. OK, i can't find out how to add items -_-.. how do i add items to SQL serv. 2000 ?

EDIT: 4. How do you get mobs to do spell hits? MTK/EM aren't doing spell attacks... ty

Lol thanks...
oh, and how do you do GM Shout? I forgot command lal...
ty
/Gelex.

ps- dont slag me of this my first server i've managed to get offline lol, and generally is my first server..

YOU DON'T HAVE TO ANSWER EVERY QUESTION, ANSWERING 1 WILL STILL HELP..
lol.. ty ^^

 

[Elvin]

1) ? try looking in the m2 for em theyre in that
and also in the m2server or mir200 folder which ever you have.

2)you change gender in game with this @changegender yourname warrior and then u can use @level -1 or whatever u like

3)in sql u just open the tables and add a line at the bottom

4) u'll need to find that one urself havent a clue why mobs wont hit unless ur on gamemaster mode and then what else do u expect
even on observer mobs wont hit you unless you hit them cos they cant see you.

ps:- gm shout is in the m2 server aswell just look th
rough the drop downs or try @@ omg im global gm shouting


no slagging off just help .

once u start learning it will become far far easier.

 

[WasteMan]

1) ? try looking in the m2 for em theyre in that
and also in the m2server or mir200 folder which ever you have.

2)you change gender in game with this @changegender yourname warrior and then u can use @level -1 or whatever u like

3)in sql u just open the tables and add a line at the bottom

4) u'll need to find that one urself havent a clue why mobs wont hit unless ur on gamemaster mode and then what else do u expect
even on observer mobs wont hit you unless you hit them cos they cant see you.

ps:- gm shout is in the m2 server aswell just look th
rough the drop downs or try @@ omg im global gm shouting


no slagging off just help .

once u start learning it will become far far easier.

ty vm - but how do you get the 'FLD_STDMODE, SOURCE, IMGINDEX' ?

And i've just spent ages re-doing drops and adjusting stats, people say its hard work, you think it aint, but it is -_-. lal

 

[Elvin]

get a hold of the hh8 image viewer and look through the wil filees for the imageindex number.

think theres a link to one here
http://www.lomcn.co.uk/forum/showthread.php?t=54969&highlight=hh8

source i think is for things like holy on weapons

and the stdmode pertains to what the item is like 10 female armour 11 male armour, 22 rings some of , 20 necklaces some of and so on look at whats allready in your stditems table and go from that .

hope this helps