Author Topic: I JUST DELETED MY ADMIN ACCOUNT ACCIDENTLY HOW DO I GET IT BACK  (Read 4587 times)

0 Members and 1 Guest are viewing this topic.

Offline zakaria666

  • Full Member
  • ***
  • Posts: 211
    • View Profile
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

Rembrandt

  • Guest

Offline zakaria666

  • Full Member
  • ***
  • Posts: 211
    • View Profile
Re: I JUST DELETED MY ADMIN ACCOUNT ACCIDENTLY HOW DO I GET IT BACK
« Reply #2 on: July 16, 2010, 07:50:14 PM »
 I    F--KING    LOVE   YOU

THANK YOUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU

MWAH MWAH MWAH

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: I JUST DELETED MY ADMIN ACCOUNT ACCIDENTLY HOW DO I GET IT BACK
« Reply #3 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
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline zakaria666

  • Full Member
  • ***
  • Posts: 211
    • View Profile
Re: I JUST DELETED MY ADMIN ACCOUNT ACCIDENTLY HOW DO I GET IT BACK
« Reply #4 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