Huge Probelm!

[AMG]

While testing some MySQL things apparently i damaged my Database.


Here is the scoop....

I created a new group called webmaster because my admin didn't know how to work all the vB control panel things so i took away control panel permissions to admins and gave them only to webmasters. since i was the only webmaster i was the only one added to that group.

Tonite i can't get into my board. It is closed and I am screwed! I used the getadmin.php file but that doesn't help because they don't have control panel abilities. I downloaded my board and looked in all the files and found no way to change this. It appears that I am royally f***ed and do not plan to start the 60+ hours of work all over, Templates, Smilies, vB Codes, Design, Styles, Forums, Categories, Members etc...

I have decided I might as well give away my vB since there is no way to restore this ****. The only thing I can think of is to give admin control panel abilities. But i don't see a way to do that from the files. I also had a secret username as a webmaster backup but apparently that group got deleted with the mess up of the Database! Well I am f***ed and screwed up the @ss with my pants on!

I thank you all for your continual help and 2 Thumbs Up for the non-infiltratable board. It is amazing how Hack Proof it is!



Sh!t SH!T! Son of a B****!

My board is totally f***ed up now!

please contact me if you would like to have a vB and license because I am not going to start over!

Bye!

[AMG]

NO HOPE!

AHHHHH!

I have to start over I guess :( :( :(

What files can I use to upload from my old folder into the new one.

Is there anyway I can keep the members?

I guess its start form scratch ehh?

[Joe]

woha, slow down ... I dont think you have lost everything, however, i have no idea what exactly you did, or what happend, before you do anything else, wait till ed or some other db master helps you out. I dont think you lost everything :)

[Mike Sullivan]

You completely lost me too...

[AMG]

OK this is what occured.

While testing out some PHP & MySQL things I damaged my SQL database. In the event I most likely interfered with vBulletin on my server.

So I had to go in and fix some things because users and forums got messed up.

I went inside the Control Panel and edited everything. When I went to open the board it said that i wasnt;t logged in or didn't have access.

I had changed the Admin status to webmaster so the admins didn't have CP access.

So i used a secret name of mine to try and get in. So it said the same thing. I can only assume that somehow the Webmaster group was deleted. How? I am still wondering.

So the board is closed and I can't get into the CP. My server says he can get me in but when I got in and edited everything. I went to open the board and BOOM it said the thing over.

I am going to get them to let me in one more time but if it doesn't work then something is screwy!

[Mike Sullivan]

Run this script from you main vB directory. Make sure you change # to your userid.

<?php

require("global.php");

$youruserid = "#";

$info=$DB_site->query_first("SELECT usergroupid FROM user WHERE userid='$youruserid'");
$DB_site->query("UPDATE usergroup SET cancontrolpanel=1 WHERE usergroupid=$info[usergroupid]");

echo "done";

?>

[AMG]

THANX!

:) :) :)