FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Bugs in 1.1.9-dev (from CVS @ 8:30am Feb 12)
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Bugs in 1.1.9-dev (from CVS @ 8:30am Feb 12) [message #438 is a reply to message #437] Tue, 12 February 2002 18:49 Go to previous messageGo to previous message
ironstorm is currently offline  ironstorm   Canada
Messages: 89
Registered: February 2002
Location: Toronto, Ontario, Canada
Karma:
Member

select * from fud_msg where thread_id=9 


This is an HTML table displaying the results, looks like all of the offset values are 0. I also attached the thread data file again, since it has changed with the addition of a couple of nested replies.

<h3>select * from fud_msg where thread_id=9 (5 Records)</h3>

<table border=1>
<tr class="header">
<th>id</th>
<th>thread_id</th>
<th>poster_id</th>
<th>reply_to</th>
<th>ip_addr</th>
<th>host_name</th>
<th>post_stamp</th>
<th>update_stamp</th>
<th>updated_by</th>
<th>icon</th>
<th>style</th>
<th>subject</th>
<th>attach_cnt</th>
<th>poll_id</th>
<th>approved</th>
<th>show_sig</th>
<th>smiley_disabled</th>
<th>offset</th>
<th>length</th>
</tr>
<tr>
<td>11&nbsp;</td>
<td>9&nbsp;</td>
<td>2&nbsp;</td>
<td>0&nbsp;</td>
<td>10.92.14.83&nbsp;</td>
<td>NULL&nbsp;</td>
<td>1013530668&nbsp;</td>
<td>1013530694&nbsp;</td>
<td>2&nbsp;</td>
<td>NULL&nbsp;</td>
<td>TAGS&nbsp;</td>
<td>The body of the previous message or edit is always appended.&nbsp;</td>
<td>0&nbsp;</td>
<td>0&nbsp;</td>
<td>Y&nbsp;</td>
<td>Y&nbsp;</td>
<td>N&nbsp;</td>
<td>0&nbsp;</td>
<td>65&nbsp;</td>
</tr>
<tr>
<td>12&nbsp;</td>
<td>9&nbsp;</td>
<td>2&nbsp;</td>
<td>11&nbsp;</td>
<td>10.92.14.83&nbsp;</td>
<td>NULL&nbsp;</td>
<td>1013530730&nbsp;</td>
<td>0&nbsp;</td>
<td>0&nbsp;</td>
<td>NULL&nbsp;</td>
<td>TAGS&nbsp;</td>
<td>Re: The body of the previous message or edit is always appended.&nbsp;</td>
<td>0&nbsp;</td>
<td>0&nbsp;</td>
<td>Y&nbsp;</td>
<td>Y&nbsp;</td>
<td>N&nbsp;</td>
<td>0&nbsp;</td>
<td>85&nbsp;</td>
</tr>
<tr>
<td>16&nbsp;</td>
<td>9&nbsp;</td>
<td>0&nbsp;</td>
<td>11&nbsp;</td>
<td>10.92.14.83&nbsp;</td>
<td>NULL&nbsp;</td>
<td>1013532466&nbsp;</td>
<td>0&nbsp;</td>
<td>0&nbsp;</td>
<td>NULL&nbsp;</td>
<td>TAGS&nbsp;</td>
<td>change the subject&nbsp;</td>
<td>0&nbsp;</td>
<td>0&nbsp;</td>
<td>Y&nbsp;</td>
<td>N&nbsp;</td>
<td>N&nbsp;</td>
<td>0&nbsp;</td>
<td>113&nbsp;</td>
</tr>
<tr>
<td>17&nbsp;</td>
<td>9&nbsp;</td>
<td>0&nbsp;</td>
<td>16&nbsp;</td>
<td>10.92.14.83&nbsp;</td>
<td>NULL&nbsp;</td>
<td>1013532517&nbsp;</td>
<td>0&nbsp;</td>
<td>0&nbsp;</td>
<td>NULL&nbsp;</td>
<td>TAGS&nbsp;</td>
<td>A nested reply to Message #3 (change the subject)&nbsp;</td>
<td>0&nbsp;</td>
<td>0&nbsp;</td>
<td>Y&nbsp;</td>
<td>N&nbsp;</td>
<td>N&nbsp;</td>
<td>0&nbsp;</td>
<td>155&nbsp;</td>
</tr>
<tr>
<td>18&nbsp;</td>
<td>9&nbsp;</td>
<td>2&nbsp;</td>
<td>12&nbsp;</td>
<td>10.92.14.83&nbsp;</td>
<td>NULL&nbsp;</td>
<td>1013532591&nbsp;</td>
<td>0&nbsp;</td>
<td>0&nbsp;</td>
<td>NULL&nbsp;</td>
<td>TAGS&nbsp;</td>
<td>nested reply&nbsp;</td>
<td>0&nbsp;</td>
<td>0&nbsp;</td>
<td>Y&nbsp;</td>
<td>Y&nbsp;</td>
<td>N&nbsp;</td>
<td>0&nbsp;</td>
<td>189&nbsp;</td>
</tr>
</table>
  • Attachment: th_9.zip
    (Size: 0.21KB, Downloaded 1186 times)
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Comments on installing FUD 1.1.1 on Win2K
Next Topic: Need Help - pro i did the consistancy check and i have an error
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 16:45:03 GMT 2024

Total time taken to generate the page: 0.04338 seconds