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
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.
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?
Do you have access to the UBB.threads scripts?
If so, look at the CREATE TABLE queries in createtable.php.
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.
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