|
|
Joined: Mar 2002
Posts: 20
Newbie
|
Newbie
Joined: Mar 2002
Posts: 20 |
I'm curious about how to find out all the table names associated with UBBT...
Im just learning SQL, and I would like to start quering some things from our database...
P.S. i'm new to the admin position
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
The relevant page in the MySQL manual is here. The query is 'SHOW TABLES', but it doesn't seem to work when used in the admin area. It works correctly with phpMyAdmin or with the mysql command on the server.
|
|
|
|
Joined: Mar 2002
Posts: 20
Newbie
|
Newbie
Joined: Mar 2002
Posts: 20 |
I don't have server access. Only the admin section. I know everything on the w3t_users table, I am just curious as to what the other table names are. Can anybody help?
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
Do you have access to the UBB.threads scripts?
If so, look at the CREATE TABLE queries in createtable.php.
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
If you have phpmyadmin access, it's simple to view the tables. If not, you really need to get permission from the forum owner to access the tables anyway, there is sensitive private info in there.
|
|
|
|
Joined: Dec 2000
Posts: 1,471
Addict
|
Addict
Joined: Dec 2000
Posts: 1,471 |
Here ist the table listing, copied from phpMyAdmin:
WWWThreads w3t_AddressBook w3t_Banned w3t_Boards w3t_Category w3t_Favorites w3t_Groups w3t_Last w3t_Messages w3t_ModNotify w3t_Moderators w3t_Online w3t_PollData w3t_Polls w3t_Posts w3t_Subscribe w3t_Users
|
|
|
|
Joined: Mar 2002
Posts: 20
Newbie
|
Newbie
Joined: Mar 2002
Posts: 20 |
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 808
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|