Userbase

Code: Selecteer alles

walhalla:~# uptime
 11:05:12 up 450 days, 21:10,  2 users,  load average: 0.75, 0.51, 0.59

Code: Selecteer alles

walhalla:~# uptime
 11:21:31 up 12 min,  1 user,  load average: 0.58, 0.76, 0.52

Code: Selecteer alles

SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, p.post_text, p.post_id, f.forum_id, f.forum_name, p.forum_id
FROM
  phpbb_topics AS t
  Inner Join phpbb_posts AS p ON p.topic_id = t.topic_id
  Inner Join phpbb_users AS u ON u.user_id = p.poster_id
  Inner Join phpbb_forums AS f ON f.forum_id = t.forum_id
WHERE
  t.forum_id NOT IN ( 1,2,3,4 )
  AND p.post_time > (SELECT unix_timestamp(CURRENT_TIMESTAMP ) -43200 )
  AND t.topic_status <>2
ORDER BY p.post_id DESC
LIMIT 25

Code: Selecteer alles

select t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, p.post_text, p.post_id, f.forum_id, f.forum_name, p.forum_id
FROM 
	phpbb_topics  AS t , 
	phpbb_posts AS p , 
	phpbb_users AS u ,
	phpbb_forums AS f 
WHERE 
	p.topic_id in	(SELECT topic_id 
		FROM phpbb_topics
		where forum_id NOT
		IN ( 1, 2, 3, 4 )
		AND post_time > (
		SELECT unix_timestamp(
		CURRENT_TIMESTAMP ) -43200 )
		AND t.topic_status <>2
		)
	AND p.topic_id = t.topic_id
	AND u.user_id = p.poster_id
	AND f.forum_id = t.forum_id
ORDER BY p.post_id DESC
LIMIT 25

Code: Selecteer alles

max_heap_table_size 128M
tmp_table_size 64M