Prevent GM's from leveling

[DataMatrix]

1: Open SQL Server Enterprise Manager

2: Expand the tree so it looks like this:
Console Root > Microsoft SQL Servers > SQL Server Group > IP OR (LOCAL) > Management > SQL Server Agent > Jobs

3: Right click and click New Job

4: Call it gm_reset and set Owner to sa

5: Go to the Steps tab and click New

6: Call the step gm_reset change Database to muonline

7: Copy and paste the following code into the Command box:

UPDATE Character
SET clevel=('349'), experience=('0'), resets=('0')
WHERE ctlcode=('8')

8: Click OK then go to the Schedules tab and click New Schedule

9: Call it gm_reset and click Change in the bottom right

10: Change occur to Daily, Daily Frequency to Occurs every 1 minute

11: OK everything and make sure SQL Server Agent is running

[MentaL]

[fusionEST]

why is this necessary??

[bottom kicker]

because some gms go round pking ppl but they cant pk if they are lvl 1 and gms are there to help ppl in town not to go to arena and do evil spirits

[DataMatrix]

And its also if you dont want them resetting and messing up the reset page.

[jamaica]

where can i fin the comands for admins ?

[Maku]

i have strench info: "The server detected the following syntax errors in the command errors:
Error 207: Invalid column name: 'resets'.

[DataMatrix]

Maku, open a design sheet with Characters open in it and call it Resets

[Maku]

what i must give data type and value?

[jimmyman]

int for datatype

[vacyracers]

Good Job Gms Don't lvl Anymore :)

[FragFrog]

because some gms go round pking ppl but they cant pk if they are lvl 1 and gms are there to help ppl in town not to go to arena and do evil spirits

Not a GM in my server... If I ever catch one of them PK'ing people on purpose its an instant demotion to normal player again.. :icon6:

About your code:

UPDATE Character
SET clevel=('349'), experience=('0'), resets=('0')
WHERE ctlcode=('8')

If you want them to stay level 1 as someone mentioned here, that should be

UPDATE Character
SET clevel=('1'), experience=('0'), resets=('0')
WHERE ctlcode=('8')

;)

Also, with my webpackage GM's dont show up on ranking page anyway, but I suppose thats different with other packages :)

[siliconshadow]

Sometimes its nescerry for a gm to kill monster in order to see who the player is underneath them when there afk.

But I agree that gms shuldnt be able to pk.

Maybe theres a way, method of completly stopping gms from pking. But currently its not a priority for me, to many other things on...

[zenka]

cool thx man

[Lucifus]

"The server detected the following syntax errors in the command errors:
Error 207: Invalid column name: 'resets'. I get this error, I am noob to this, How do I open a design sheet, where? Help please.....

[Lucifus]

Um..........................anyone..........=/

[Lsent]

Lucifus, Some people who run servers use websites to manage them. Therefor, they use the mu database for it. And some, like in this case, have there own online systems, thus the "resets" colum. If you do not run a website that manages "reseting after lvl 350" then use the code:

UPDATE Character
SET clevel=('1'), experience=('0')
WHERE ctlcode=('8')

[Dios]

Not a GM in my server... If I ever catch one of them PK'ing people on purpose its an instant demotion to normal player again..

100% Agreed. If you can't handle your GM's how will you handle your players? GM's are supposted to be worthy of their status :)

[Pompuri]

Works greatly with me. thx.

[ubelai]

yup, and if u see them killing monsters, then they might be Partying someone...

[enjo]

is more simple if you place in the Character table on the column exp the value "-99999999"

(it forgives for the bad English but I find that it was of compreensive)

[WAIF]

nice one bro,,