Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jun 2002
Posts: 303
Enthusiast
Enthusiast
Joined: Jun 2002
Posts: 303
There are other tables for the message board itself, such as the board setup, but they are not applicable to threads. There are approximately 5500 or so posts. The following is a quick summary of what each field in the table is.

[]

id - autoincrements - post number
board - the board # it belongs to, which in this case all are 1
thread - thread number
parent - 0 if thread starter, else id. Let me double check this
author -
email -
subject -
body -
datestamp timestamp(14) -
ip -
host -
vipflag - not applicable in threads
link - URL which is appended at the end of the body with <br>
linkname - description of the above named URL
image - URL of a picture to be displayed in post. appended to end of body with <br>
locked -
sticky -
email_replies - notifies poster of replies by email
hide_email - hides or shows email in post
counter - number of views. This is different than threads in that each post has an individual post view count opposed to a thread count like threads. Not that big of deal if it not included.




I can send a portion of the dump if you need a closer look on how it all gels. Thanks for looking into it.

Mark

Sponsored Links
Entire Thread
Subject Posted By Posted
need a script to transfer data from one message bo fishtails 09/20/2002 3:17 PM
Re: need a script to transfer data from one message bo Aglavalin 09/20/2002 10:34 PM
Re: need a script to transfer data from one message bo fishtails 09/21/2002 2:02 AM
Re: need a script to transfer data from one messag Gardener 09/21/2002 2:26 AM
Re: need a script to transfer data from one messag fishtails 09/21/2002 5:30 AM
Re: need a script to transfer data from one messag Gardener 09/21/2002 5:43 AM
Date / Time formats fishtails 09/25/2002 12:51 AM
Re: Date / Time formats Gardener 09/25/2002 1:20 AM
Re: Problems: B_Topic B_Replies, etc fishtails 09/25/2002 9:26 PM
Re: Problems: B_Topic B_Replies, etc Gardener 09/26/2002 4:47 PM
Almost got it! A few more things though. fishtails 10/01/2002 5:22 PM
WOO HOO! I got it! fishtails 10/02/2002 6:40 PM
Re: WOO HOO! I got it! Dave_L_dup1 10/02/2002 7:31 PM
Re: WOO HOO! I got it! fishtails 10/02/2002 10:49 PM
Re: WOO HOO! I got it! Dave_L_dup1 10/02/2002 11:11 PM
Re: WOO HOO! I got it! Gardener 10/04/2002 5:42 PM
Re: WOO HOO! I got it! fishtails 10/05/2002 2:07 PM
Re: WOO HOO! I got it! Gardener 10/07/2002 12:46 PM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
hatter
hatter
USA
Posts: 69
Joined: January 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)