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 Community Support forums / 
  3. Beginner's Corner 
  4.  / MySQL Data base
Register
1
davidtillyer
MySQL Data base

I'm using a MySQL DB with my XOOPS site. I have just loged into my "MySQL" db and have 3 "User" files, a "xoops_users" and "Mysite_Users" and "xoops3_users" when I open them they have people that have registered on my old XOOPS site before I got the latest vision.

With the current XOOPS I'm using I have registed a NEW user on the site and confirmed it via the confirmation email, but yet I can still NOT see the newly registered user in any of the 3 "User" files or should I be looking in another file?

DT
2
Dave_L
Re: MySQL Data base

  • 2005/4/17 16:48

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


What do you mean by "logged into my MySQL db"? Are you using a tool such as phpMyAdmin?

The file mainfile.php in your top-level XOOPS directory contains the database access info, such as the database name and the table prefix. That should tell you whether you're looking at the right database and the right table. By default, the table containing the users is "xoops_users".
3
davidtillyer
Re: MySQL Data base

Hi Dave,

I'm using a pice of software called "Navicat" to access my "db" = database.
I use this software to log onto MySQL server and view.
When I open the SW I see the IP address of the server that the database is on, then the dropdown from that is my database name.

When I click on this I see ALL the files.

There is NO mainfile.php there !!!!

the ONLY files I can see with pased registered users to my old site are "xoops_users" and "Mysite_Users" and "xoops3_users"

I do have "xoops_users" so I know I'm in the right area but when I open this there is only one registered user and that the old administrator from my old XOOPS site.

Where else can the users be? I have just registered a user but they do not show in any of the above 3 user tables.

DT
4
Mithrandir
Re: MySQL Data base

mainfile.php is a... erhm... PHP file. In your XOOPS root. The one that contains the connection information so XOOPS knows which database to contact. In there, the prefix is also set, so that should tell you which database and prefix to use when looking for this new user.
5
davidtillyer
Re: MySQL Data base

Hi,

So if I look in my XOOPS core code for a file called "mainfile.php" and open this this should tell me what database file it is wrighting to and what it's called?

DT

PS: I have just opened the "mainfile.php" and it tell me all the info about my user name, password etc, where do I need to look to tell me what file it's storing the registered users in?

DT
6
jdseymour
Re: MySQL Data base

Mainfile.php is in the root website directory where you installed Xoops. The file will give you details about your database server.

It has the database name, the username to connect to the database, the user password to connect to the database, and the prefix for the XOOPS tables within the database.

If you download the file and open a text editor, you will be able to read the information.

HTH.
7
davidtillyer
Re: MySQL Data base

Please read my PS, on MY last message.

DT
8
jdseymour
Re: MySQL Data base

Check the database name, connect to that database server, the users should be in the _user table on that database.

If you have phpmyadmin that would be the easiest way to connect.

PS. See this Faq Page.
9
rowdie
Re: MySQL Data base

  • 2005/4/18 1:46

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


Look at the XOOPS_DB_PREFIX in mainfile.php

The database table with that word before _users is the one that should have your users for that site.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

158 user(s) are online (130 user(s) are browsing Support Forums)

Members: 0

Guests: 158

more...

Donat-O-Meter

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

Latest GitHub Commits