XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. Xoops Development / 
  3. Xoops Development 
  4.  / xoops tables
Register
1
minimum
xoops tables

  • 2007/3/8 8:36

  • minimum

  • Just popping in

  • Posts: 19

  • Since: 2003/8/17


Hello;

ia there any web with documentation about tables of xoops?

Description of fields and relations between tables...

I've a error in my web. I entry with my user/pass but I've lost the permissions of "admin", and I am the webmaster....
2
wizanda
Re: xoops tables

  • 2007/3/8 9:33

  • wizanda

  • Home away from home

  • Posts: 1585

  • Since: 2004/3/21


Easy way I can think of would be to make another user, go into MySQL and you can make that user Admin/web-master then, by adding the Admin group number to the profile you make.
That way you can log-in as admin with your new user and reset the password your self on your own account, as the password is encrypted, and so why you can't just edit it in Mysql.
3
iHackCode
Re: xoops tables

prefix_groups_users_link is the table. the admin group is group 1.
each row has a group id and a user id.(for me 1 being my admin (the first user that registered) . the list of of users are in the prefix_users table)

example: i got user id 1 in the admin group and registered user group,
Resized Image

.and i think there is a list of what each table does..
CBB / LatestNews / Publisher / XM-Spotlight

(ﾉ◕ヮ◕)ﾉ*:･ﾟ✧
4
minimum
Re: xoops tables

  • 2007/3/8 18:23

  • minimum

  • Just popping in

  • Posts: 19

  • Since: 2003/8/17


My uid is 1, and in .._groups_users_link I have in "groupid" 1 and 2

can I delete all records in .._groups_users_link that his uid isn't in .._users ?

in table .._users, the field "level" an "umode" (thread, nest, flat) what indicated?
5
iHackCode
Re: xoops tables

if the groupid for that uid is both 1 and 2 then you should be in the administrator and registered users group. and you shouldnt delete the other entries since that tells XOOPS what groups the other users are in.

umode is the 'Comments Display Mode' (the setting that is set in the profile
level is the status of the account 'activated or 'not activated
//0 not activated, >0 activated account
CBB / LatestNews / Publisher / XM-Spotlight

(ﾉ◕ヮ◕)ﾉ*:･ﾟ✧
6
minimum
Re: xoops tables

  • 2007/3/9 9:06

  • minimum

  • Just popping in

  • Posts: 19

  • Since: 2003/8/17


thank...

but, I am equal..

I can access my web, but I can't admin area, I'm not authorized to access to admin area.

I'd a trojan in my computer, I believe that they have hacked my web...

in what are table the permissions of the groups defined? how?

can I modify some .php to have total access without control usuary? change the permissions for users and I return to put the control of users

any idea?
7
iHackCode
Re: xoops tables

i dont have a script for that. maybe someone else does..

the table is prefix_group_permission . but im not positive on how to modify it.
CBB / LatestNews / Publisher / XM-Spotlight

(ﾉ◕ヮ◕)ﾉ*:･ﾟ✧

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

127 user(s) are online (76 user(s) are browsing Support Forums)

Members: 0

Guests: 127

more...

Donat-O-Meter

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

Latest GitHub Commits