Archetype Zero Bug Reports | |
Before this post/topic, Boardlist said AZBR has 207 posts... | |
miikrr x (6): Board List | Topic List | Post New Message | FAQ | TOS | Log Out | Online: 1 | |
From: miikrr x | Posted: 5/28/04 11:28:52 PM | Options | #001 |
6: New User Online |
That when added up came to 213. I suspect it'll be 207/214 after this post. |
From: miikrr x | Posted: 5/28/04 11:31:48 PM | Options | #002 |
6: New User Online |
Why don't you counted the deleted messages? They're still visible as deleted, and visible in general to mods, so shouldn't the totals include the 'deleted' posts? |
From: Onion | Posted: 5/28/04 11:33:48 PM | Options | #003 |
30: Administrator Offline |
Dunno. No one usually cares about that kind of crap, and the way the SQL is set up, getting topic and message totals and last post time in one query would be either impossible or ineffiecient. |
From: miikrr x | Posted: 5/28/04 11:35:48 PM | Options | #004 |
6: New User Online |
Then why does stats.php include the deleted messages? |
From: Onion | Posted: 5/28/04 11:36:22 PM | Options | #005 |
30: Administrator Offline |
Dunno. Blame it on uG. |
From: miikrr x | Posted: 5/28/04 11:39:05 PM | Options | #006 |
6: New User Online |
fuck you |
From: miikrr x |
Posted: 5/28/04 11:40:28 PM | Options | ![]() |
6: New User Online |
[This message was deleted at the request of the original poster] |
From: Ant P | Posted: 5/29/04 9:29:58 AM | Options | #008 |
6: New User Offline |
$counts = mysql_fetch_row (mysql_query ('SELECT COUNT(DISTINCT(`topic`)), COUNT(`messageid`), MAX(`messsec`) FROM `messages` WHERE `mesboard` = '.$board[0].' AND `active` != \'deleted\'')); |