|
|
|
|
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
|
|
|
|
|
|
