4images Forum & Community

4images Issues / Ausgaben => Installation, Update & Configuration => Topic started by: zakaria666 on July 16, 2010, 04:26:32 PM

Title: I JUST DELETED MY ADMIN ACCOUNT ACCIDENTLY HOW DO I GET IT BACK
Post by: zakaria666 on July 16, 2010, 04:26:32 PM

the subject title says it all, how do i get my admin account back without installing everything again, Cn i??

please help me i was stupid omg

Title: Re: I JUST DELETED MY ADMIN ACCOUNT ACCIDENTLY HOW DO I GET IT BACK
Post by: Rembrandt on July 16, 2010, 06:48:11 PM

? FAQ --->  http://www.4homepages.de/forum/index.php?topic=1858.0

Title: Re: I JUST DELETED MY ADMIN ACCOUNT ACCIDENTLY HOW DO I GET IT BACK
Post by: zakaria666 on July 16, 2010, 07:50:14 PM

 I    F--KING    LOVE   YOU

THANK YOUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU

MWAH MWAH MWAH

Title: Re: I JUST DELETED MY ADMIN ACCOUNT ACCIDENTLY HOW DO I GET IT BACK
Post by: Nicky on July 16, 2010, 07:55:50 PM

as i read here, you have DELETED your account :P

if you can handle with phpmyadmin... go to your 4images database

execute this SQL query

CHANGE "YOURPREFIX_" to your prefix (look into config.php!)

Code: [Select]

INSERT INTO `YOURPREFIX_users` (
`user_id` ,
`user_level` ,
`user_name` ,
`user_password` ,
`user_email` ,
`user_showemail` ,
`user_allowemails` ,
`user_invisible` ,
`user_joindate` ,
`user_activationkey` ,
`user_lastaction` ,
`user_location` ,
`user_lastvisit` ,
`user_comments` ,
`user_homepage` ,
`user_icq`
)
VALUES (
NULL , '9', 'admin', MD5( 'admin' ) , 'yourEMAIL@domain.com', '0', '1', '0', '1233436395', '', '0', '', '0', '0', '', ''
);

Result:

Code: [Select]

Inserted rows: 1
Inserted row id: 78 (Query took 0.0008 sec)
now you can login as administrator with username admin and password admin

if you know your OLD userid .... to get YOUR pictures und YOUR new account...
first verify.. which userid your NEW account have... example: your OLD user_id was 1 and your NEW user_id is 78
execute following query

Code: [Select]

UPDATE `YOUPREFIX_images` SET `user_id` = 78 WHERE `user_id` = 1;
same you can do with tables: comments, groupmatch, lightboxes


AND BTW... do not screaaaaaaaaaaam!..... omg... :D

Title: Re: I JUST DELETED MY ADMIN ACCOUNT ACCIDENTLY HOW DO I GET IT BACK
Post by: zakaria666 on July 16, 2010, 08:32:56 PM

hehe i so apolgize sir i just got so scared.

I deleted my account but not the whole system. It works now hehehehe
god bless u

mwah mwah mwah