how to remove a GM account?

how to remove a gm account, what command?

"call delGM(USERid, 1)" maybe?

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

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

try remGM then?

PROCEDURE pw.remGM does not exist

well heck idk then, I never have to do that

Code:

---

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

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

that is the command that pwAdmin uses..

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

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

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

[s]closed[/s]