Becoming a Moderator Problem

[Parker Clack]

Well I set myself up as moderator of one of my forums and now I do not have administrative abilities.

1) How do I get back my administrative abilites?

2) How can I be an administator of the site and a moderator of a forum?

Parker

[Edited by Parker Clack on 05-05-2000 at 12:25 AM]

[Menno]

I think you're best off re-installing the software, set up a user group, and then try.

[Parker Clack]

Thanks, that is just what I did.

Parker

[John]

1)

To regain admin control, execute this SQL:



UPDATE user SET usergroupid=6 WHERE username='yourusername';
UPDATE usergroup SET cancontrolpanel=1 WHERE usergroupid=6;


Or if you cannot get to the MySQL client, then this PHP:


<?php

require("global.php");
$DB_site->query("UPDATE user SET usergroupid=6 WHERE username='yourusername'");
$DB_site->query("UPDATE usergroup SET cancontrolpanel=1 WHERE usergroupid=6");

?>


2) Yes you should be able to. You may get a different title, but you should still remain an admin.

Put that script in the main forums dir.

John

[Parker Clack]

Ok,

So I want to save a file like adminupdate.php with:

<?

require("global.php");
$DB_site->query("UPDATE user SET usergroupid=6 WHERE username='Parker Clack'");
$DB_site->query("UPDATE usergroup SET cancontrolpanel=1 WHERE usergroupid=6");

?>

right?

Parker

[Mike Sullivan]

yup, that's right