06:26:46 <@Mega-Mario> uh, thread listing page numbers are glitched in user mode 06:26:48 <@Mega-Mario> http://board.kafuka.org/thread.php?user=21&page=101

https://board.kafuka.org/thread.php?user=21&page=101

Should made a [blockquote] basically a copy of the code block w/o prettifty. (I think it would be easier than [ code syncol=f] for most people

I don't know how accurate these reports are but

21:44:21 < Rydia> Emuz turns 110 21:44:22 < Rydia> Rydia turns 101 21:44:23 < Rydia> July 2092

Need a blockquote/ircquote tag or give some options for code. IRCquote could be interesting for later searching.

The code for the NEW needs a bit of work. Mostly when you reg you always start with everything "NEW" when on most boards it's only after your start date it treats it as "NEW". It doesn't always accept when you've read something either. The only way to clear it is to use the manual 'mark forum as read' to clear it out. (in the case of global announcements the whole board) Plus I wanted to add support for marking threads ad "EDT" or 'edited' so people can see when there was an edit made. gfx/new.php has support for displaying them if we do. (This is a minor thing that doesn't matter if it gets done, but it's related and good to note it. )

As for the page count it may not be taking into account the right "page per thread" like you said. I've not really looked into that..

Posted by Mega-Mario

---

About showing post edits, well, I don't think it should apply to all the posts in the thread, only the latest post and perhaps the first one too. ABXD has something similar, if the latest post in a thread is edited, the thread is marked as NEW.

The 'threads start out read' bit should be easy

---

I did have limits in mind but since I haven't hashed them out I never really documented them. First thread of a post is key to how I would use it. (very good for announcements as well), and latest post in thread makes sense too. I agree that not all should trigger it or we'll have a whole board of "EDT". Covering those two hits the major need for the 'EDT' flag. Also NEW should always trump 'EDT' since if it's still 'NEW' to you it doesn't matter if it was edited afterward.

I saw briefly you did fix that already heh Cool!

the dump made was using a script, it may be incorrect. Live has the proper UNIQUE in place. (of course if it didn't it would be messed up.)

[why an installer is needed.. better than a sql dump.]

AUTO INC is implemented on users (and it should on others but I can't look now.)

So it's that dump I would say. I may need to make another one..

-- phpMyAdmin SQL Dump -- version 3.4.8 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 23, 2012 at 09:31 PM -- Server version: 5.5.24 -- PHP Version: 5.4.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- -- Database: `ab2db` -- -- -------------------------------------------------------- -- -- Table structure for table `dailystats` -- CREATE TABLE IF NOT EXISTS `dailystats` ( `date` char(8) NOT NULL, `users` int(11) DEFAULT '0', `threads` int(11) DEFAULT '0', `posts` int(11) DEFAULT '0', `views` int(11) DEFAULT '0', PRIMARY KEY (`date`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `forums` -- CREATE TABLE IF NOT EXISTS `forums` ( `id` int(5) NOT NULL DEFAULT '0', `cat` tinyint(3) unsigned NOT NULL DEFAULT '0', `ord` tinyint(3) unsigned NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL, `descr` varchar(255) NOT NULL, `threads` mediumint(8) NOT NULL DEFAULT '0', `posts` mediumint(8) NOT NULL DEFAULT '0', `lastdate` int(11) NOT NULL DEFAULT '0', `lastuser` mediumint(8) unsigned NOT NULL DEFAULT '0', `lastid` int(11) NOT NULL, `minpower` tinyint(4) NOT NULL DEFAULT '-1', `minpowerthread` tinyint(4) NOT NULL DEFAULT '0', `minpowerreply` tinyint(4) NOT NULL DEFAULT '0', `private` int(1) NOT NULL, `trash` int(1) NOT NULL, `announcechan_id` int(11) NOT NULL DEFAULT '0', `readonly` int(1) NOT NULL DEFAULT '0', `announce` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `posts` -- CREATE TABLE IF NOT EXISTS `posts` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user` mediumint(9) unsigned NOT NULL DEFAULT '0', `thread` mediumint(9) unsigned NOT NULL DEFAULT '0', `date` int(11) NOT NULL DEFAULT '0', `mood` int(11) NOT NULL DEFAULT '-1', `nolayout` int(1) NOT NULL, `ip` char(15) NOT NULL, `num` mediumint(9) NOT NULL DEFAULT '0', `deleted` tinyint(1) NOT NULL DEFAULT '0', `announce` int(1) NOT NULL, PRIMARY KEY (`id`), KEY `threadid` (`thread`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21406 ; -- -------------------------------------------------------- -- -- Table structure for table `threads` -- CREATE TABLE IF NOT EXISTS `threads` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `replies` mediumint(8) unsigned NOT NULL DEFAULT '0', `views` mediumint(8) unsigned NOT NULL DEFAULT '0', `closed` tinyint(3) unsigned NOT NULL DEFAULT '0', `sticky` tinyint(3) unsigned NOT NULL DEFAULT '0', `forum` int(5) NOT NULL DEFAULT '0', `user` mediumint(8) unsigned NOT NULL DEFAULT '0', `lastdate` int(11) NOT NULL DEFAULT '0', `lastuser` mediumint(8) unsigned NOT NULL DEFAULT '0', `lastid` int(11) NOT NULL DEFAULT '0', `icon` varchar(100) NOT NULL, `tags` int(12) NOT NULL, `announce` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=537 ; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL, `displayname` varchar(32) NOT NULL, `pass` varchar(32) NOT NULL, `posts` mediumint(9) NOT NULL DEFAULT '0', `threads` mediumint(9) NOT NULL DEFAULT '0', `regdate` int(11) NOT NULL DEFAULT '0', `lastpost` int(11) NOT NULL DEFAULT '0', `lastview` int(11) NOT NULL DEFAULT '0', `lastforum` int(10) NOT NULL, `ip` varchar(15) NOT NULL, `ipfwd` varchar(64) NOT NULL, `url` varchar(255) NOT NULL, `ipbanned` tinyint(4) NOT NULL DEFAULT '0', `pmblocked` tinyint(1) NOT NULL DEFAULT '0', `canreport` tinyint(4) NOT NULL DEFAULT '1', `renamethread` tinyint(4) NOT NULL DEFAULT '1', `sex` tinyint(4) NOT NULL DEFAULT '2', `power` tinyint(4) NOT NULL DEFAULT '0', `tzoff` float NOT NULL DEFAULT '0', `dateformat` varchar(15) NOT NULL DEFAULT 'm-d-y', `timeformat` varchar(15) NOT NULL DEFAULT 'h:i A', `ppp` smallint(3) unsigned NOT NULL DEFAULT '20', `tpp` smallint(3) unsigned NOT NULL DEFAULT '20', `longpages` int(1) NOT NULL DEFAULT '0', `fontsize` smallint(5) unsigned NOT NULL DEFAULT '68', `theme` varchar(32) NOT NULL DEFAULT 'bmatrix', `birth` varchar(10) NOT NULL DEFAULT '-1', `rankset` int(10) NOT NULL DEFAULT '1', `title` varchar(255) NOT NULL, `realname` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `homeurl` varchar(255) NOT NULL, `homename` varchar(255) NOT NULL, `usepic` tinyint(4) NOT NULL DEFAULT '0', `head` text NOT NULL, `sign` text NOT NULL, `signsep` int(1) NOT NULL DEFAULT '0', `bio` text NOT NULL, `minipic` text NOT NULL, `etc` int(11) NOT NULL, `group_id` int(11) NOT NULL DEFAULT '1', `hidden` int(1) NOT NULL DEFAULT '0', `blocklayouts` int(11) NOT NULL DEFAULT '0', `blocksprites` int(11) NOT NULL DEFAULT '0', `timezone` varchar(128) NOT NULL DEFAULT 'UTC', `hidequickreply` int(1) NOT NULL DEFAULT '0', `adinfo` text NOT NULL, `redirtype` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=104 ;

Here is the proper structure off of live..

Posted by Scrydan

---

Yeah, that has been long since fixed in 2.6. In fact, I am actually to the point `power` can be completely removed from everything.

---

Umm. Yay!

Hopefully soon we'll migrate over. I'm expecting to be back next week and my number one thing is AB 2.6 and Kafuka's pending update.