<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[PunBB Forums - Track topics in database (version 1.0)]]></title>
	<link rel="self" href="http://punbb.informer.com/forums/feed/atom/topic/21822/"/>
	<updated>2009-10-29T02:51:36Z</updated>
	<generator>PunBB</generator>
	<id>http://punbb.informer.com/forums/topic/21822/track-topics-in-database-version-10/</id>
		<entry>
			<title type="html"><![CDATA[Re: Track topics in database (version 1.0)]]></title>
			<link rel="alternate" href="http://punbb.informer.com/forums/post/132047/#p132047"/>
			<content type="html"><![CDATA[<div class="quotebox"><blockquote><p>With this extension, your read posts are stored in the database (new column &quot;tracked_topics&quot; in the &quot;users&quot; table)</p><p>You could say that my extension corrects a self-inflicted problem, and you&#039;d be right, but maybe a PunBB board admin somewhere needs it too, so there it is.</p></blockquote></div><p>That&#039;s awesome! Great job.</p>]]></content>
			<author>
				<name><![CDATA[sacsp]]></name>
				<uri>http://punbb.informer.com/forums/user/22300/</uri>
			</author>
			<updated>2009-10-29T02:51:36Z</updated>
			<id>http://punbb.informer.com/forums/post/132047/#p132047</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Track topics in database (version 1.0)]]></title>
			<link rel="alternate" href="http://punbb.informer.com/forums/post/132005/#p132005"/>
			<content type="html"><![CDATA[<p>Thanks for extension <img src="http://punbb.informer.com/forums/img/smilies/wink.png" width="15" height="15" alt="wink" /><br />It is very helpful, my users were mad about this problem with 10 minutes.</p>]]></content>
			<author>
				<name><![CDATA[Nevethir]]></name>
				<uri>http://punbb.informer.com/forums/user/3389/</uri>
			</author>
			<updated>2009-10-26T19:47:30Z</updated>
			<id>http://punbb.informer.com/forums/post/132005/#p132005</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Track topics in database (version 1.0)]]></title>
			<link rel="alternate" href="http://punbb.informer.com/forums/post/128673/#p128673"/>
			<content type="html"><![CDATA[<p><a href="http://bedroom.guitarist.free.fr/share/db_tracktopics.zip">Download here</a></p><p>(License : <a href="http://sam.zoy.org/wtfpl">WTFPL</a>)</p><p>Back in the days of PunBB 1.2, new posts were highlighted until you logged out (or timed out), even when you had read them (unless you used <a href="http://www.punres.org/viewtopic.php?id=321">this mod</a>). PunBB 1.3 improved this by keeping track of the posts you read in a tracking cookie, which is simple enough but not suited to my needs.</p><p>In the default installation, PunBB is configured with a visit timeout of 10 minutes, which means that you have to read all the new posts right away : if you go take a walk or something for 20 minutes, you&#039;ll lose track of everything you hadn&#039;t read.</p><p>To accomodate my users who like to idle all day long but not miss one post, my PunBB board is set up with o_timeout_visit = 86400 (24 hours). Problem is, some of us log in from different locations during the day (home, office, iPhone) and so posts that we <em>have</em> read are marked as new.</p><p>With this extension, your read posts are stored in the database (new column &quot;tracked_topics&quot; in the &quot;users&quot; table)</p><p>You could say that my extension corrects a self-inflicted problem, and you&#039;d be right, but maybe a PunBB board admin somewhere needs it too, so there it is.</p><p><strong>PLEASE NOTE</strong> :<br />- This extension might hurt your database performance a tiny bit (count 1 more UPDATE query for each topic view by each user)<br />- Not useful if your o_timeout_visit is lower than 1 or 2 hours, or if each of your users only has one computer<br />- Just after installing the extension, users currently logged in will see some already read messages reappear as new : this is perfectly normal since the new tracking has to start somewhere ! Everything will be back to normal once the users mark those messages as read.<br />- You might want to fix your board and get rid of <a href="http://punbb.informer.com/forums/topic/21787/bug-in-updateusersonline/">this bug</a> while you&#039;re at it (suggested fix inside)</p>]]></content>
			<author>
				<name><![CDATA[bedroom]]></name>
				<uri>http://punbb.informer.com/forums/user/5754/</uri>
			</author>
			<updated>2009-06-25T13:25:23Z</updated>
			<id>http://punbb.informer.com/forums/post/128673/#p128673</id>
		</entry>
</feed>
