how to remove a GM account?

[dupei10]

how to remove a gm account, what command?

[MentaL]

[Psytrac]

"call delGM(USERid, 1)" maybe?

(I don' know, I've never had to)

[dupei10]

#1305 - PROCEDURE pw.DelGM does not exist , why?

[Psytrac]

try remGM then?

[dupei10]

PROCEDURE pw.remGM does not exist

[Psytrac]

well heck idk then, I never have to do that

if(act.compareTo("delete") == 0)
									{
										statement.executeUpdate("DELETE FROM auth WHERE userid='" + ident + "'");
										message = "<font color=\"00cc00\">GM Access Removed From User</font>";
									}

you decipher that

[dupei10]

and now what do I do? will that can not be deletegm? or removegm?

[Psytrac]

that is the command that pwAdmin uses..

[dupei10]

but where do I put the id of the User to remove the GM?

[343]

There is no SQL procedure/functions to remove GM. Adding a GM using the SQL function addGM merely adds the user to the auth table of dbo. To delete a user from the GM list you can [manually] remove the userid from the auth table in dbo.

One possible method is as shown from pwAdmin:

DELETE FROM auth WHERE userid='1024'

where 1024 = the USERID of the user you desire to remove GM powers from

[dupei10]

actually this is the best forum world, are thankful, you can close here ... thank you again!

[343]

[s]closed[/s]