1
JayeDon08
Some Clients Take Things Too Far!!!
  • 2008/8/8 20:01

  • JayeDon08

  • Just popping in

  • Posts: 15

  • Since: 2007/1/14


Hello Xoopers... I have a big problem. I have a client who has took the initiative, to delete my administrator privileges , make her own and then delete hers also. Don't ask me why...it happened. Now I have been dumfounded the past week trying to figure out how to reinstitute my administrator privileges on my username so i can update the site.

Any help anyone please?

2
trabis
Re: Some Clients Take Things Too Far!!!
  • 2008/8/8 20:26

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


If you have access to the database then got to table:
(prefix)_groups_users_link

You will have 3 columns:
linkid, groupid, uid

by default admin is set as groupid=1
so you must add a line with groupid=1 and uid=(your uid here)

ps:linkid is autoincremented so you do not need to enter nothing there.
Also check if you have a line groupid=2 and uid=(your uid) because you also want to be in the users groups I guess!

3
jlm69
Re: Some Clients Take Things Too Far!!!
  • 2008/8/8 20:27

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


If you have a backup of the database when you were webmaster, you could look through it, in the table 'users', and find user id '1' which would have been you, and then just take the insert statement using phpmyadmin and execute the insert statement.
There could be other tables that you might need as well but that is a start.

If you don't have a backup let us know.

I am just guessing, but seems right to me.

Hope this helps,

John

4
jlm69
Re: Some Clients Take Things Too Far!!!
  • 2008/8/8 20:33

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


trabis,

That is the other table I was thinking of, you must have posted 2 seconds before me.

John

5
trabis
Re: Some Clients Take Things Too Far!!!
  • 2008/8/8 20:37

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Yup, after I posted I notice your answer so it must have been 1 milisecond diference! In 'users' table there will be not much to see. There is only the 'level' that is set to 0 if user is deactivated or to 1 if it is active. Level is set to 5 for superadmin but I never saw that being used anyway.

6
JayeDon08
Re: Some Clients Take Things Too Far!!!
  • 2008/8/8 20:46

  • JayeDon08

  • Just popping in

  • Posts: 15

  • Since: 2007/1/14


You guys rock...But....my epxertise is NOT databases.

I am in the database server I see everything you two are speaking of, but I just dont know what to plug in where...

7
JayeDon08
Re: Some Clients Take Things Too Far!!!
  • 2008/8/8 20:47

  • JayeDon08

  • Just popping in

  • Posts: 15

  • Since: 2007/1/14


Im going to do a screen capture of what I see. Please give me a moment

8
jlm69
Re: Some Clients Take Things Too Far!!!
  • 2008/8/8 20:49

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


Be careful not to show sensitive info in your post.

John

9
JayeDon08
Re: Some Clients Take Things Too Far!!!
  • 2008/8/8 20:55

  • JayeDon08

  • Just popping in

  • Posts: 15

  • Since: 2007/1/14


.

10
trabis
Re: Some Clients Take Things Too Far!!!
  • 2008/8/8 21:01

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Click on browse and then in insert. Add the data above.
If you don´t know what your uid is then go to the site and mouseover your username. Your uid will be the number after uid= in the status bar.

Login

Who's Online

182 user(s) are online (73 user(s) are browsing Support Forums)


Members: 0


Guests: 182


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits