Show Your Support
$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$forumid','1','0','".addslashes($postusername)."','$bbuserinfo[userid]','".addslashes($postusername)."','".time()."','$iconid','$visible','$attachcount')");
$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach,datestarted) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$forumid','1','0','".addslashes($postusername)."','$bbuserinfo[userid]','".addslashes($postusername)."','".time()."','$iconid','$visible','$attachcount','".time()."')");
ALTER TABLE thread ADD datestarted VARCHAR (50) not null
switch ($sortfield) { case 'title': case 'lastpost': case 'replycount': case 'views': case 'postusername': case 'voteavg':
switch ($sortfield) { case 'datestarted': case 'title': case 'lastpost': case 'replycount': case 'views': case 'postusername': case 'voteavg':
lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attach
lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attach,datestarted
<select name="sortfield"> <option value="title" $sort[title]>thread title</option>
<option value="datestarted" $sort[datestarted]>date started</option>