adding new admin users

Darkcloud4491 posted 11th of August 2009 in Community Voice. 6 comments.

ok step one is to download the profiles table from your SQL database.

next edit the user that you what to give admin rights:

EG.

ID, 'member', 'e-mail@site.com', 'c72e91387791dc466383e7a0b380de6', 'Active', CHANGE THIS FROM 1 (OR WHAT EVER IT IS) TO 3, 0, 'male', 'female', 'headline', '<p>description</p>', 'GB', 'town', '1991-07-13', 1, '2009-07-27 20:32:52', '2009-07-28 20:44:43', '2009-08-11 21:13:30', '2009-08-11 21:22:50', 0, 'TAGS 'ZIP', 0, 0, 0, 19, 0, 0, 1, 3, 'online', 'message', 124935835, 2, '', '', '', '', '', '', 'Single', '', '', '', '', '', '', '', '1st name', '2nd name', 0),

so it will look something like this

2, 'Darkcloud4491', 'mike@mysite.com, 'c72e91387791dc1c2c3a0b380de6', 'Active', 3, 0, 'male', 'female', 'NEVER EAT PAINT', '<p>So i''m me thats who i am</p>', 'GB', 'Exeter', '1991-07-13', 1, '2009-07-27 20:32:52', '2009-07-28 20:44:43', '2009-08-11 21:13:30', '2009-08-11 21:22:50', 0, 'cool, owner, hot, chill, chips, cake, sleep', 'EX364LL', 0, 0, 0, 19, 0, 0, 1, 3, 'online', 'admin like stuff', 1249935835, 2, '', '', '', '', '', '', 'Single', '', '', '', '', '', '', '', 'Michael', 'Howard', 0),

use Notepad++, Notepad, or Visual Web 08 express. the user can then login to the admin panel. (http://yoursite.com/admin)

NOTE: DO NOT EDIT ANYTHING ELSE!!!!!!!!

Comments

Newest

·Oldest

·Top

Please login to post a comment.

houstonlively•11th of August 2009

You just love making things sound complex.. don't you?

You could have just told them to use phpMyAdmin to edit the user record in the 'Profiles'table.

Just edit any user record and change the 'Role' field value to '3'

Permalink•Reply•Plus•0 pluses

Darkcloud4491•12th of August 2009

yeah but some people need to be told how to do that

Permalink•Reply•Plus•0 pluses

houstonlively•12th of August 2009

Oh.... BTW... Do you see anything fundamentally wrong with your procedure? I sure do. I'm not going to tell you what it is though... see if you can figure it out:)

Permalink•Reply•Plus•0 pluses

Darkcloud4491•13th of August 2009

yeah i'm preaty sure they know to insert/update the table if thats what your on about (and this dose work coz i have done this)

Permalink•Reply•Plus•0 pluses

ZopfWare•16th of August 2009

Remember like Houston said "KISS" (keep it simple stupid). It is understood by many of us what you were explaining, However, you should explain the NET result or NET action of your explanation instead of HOW you figured it out. In that way your posts, which ARE informative and HELPFUL, will be more easily understood by the "noobies" here.

Thanks for your post.

Permalink•Reply•Plus•0 pluses

Kingphish•5th of April 2011•to ZopfWare

Great point ZopfWare.

Permalink•Reply•Plus•0 pluses

adding new admin users

Blogs

Help

Product

Company