FUDforum: How To » Moving whole website to a different server

Home » FUDforum » How To » Moving whole website to a different server

Show: Today's Messages :: Polls :: Message Navigator

Re: Moving whole website to a different server [message #40426 is a reply to message #40420]

Thu, 28 February 2008 00:40

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma:

Senior Member

I believe I have found the query: It is in my forumdata/include/theme/default/forumsel.inc. Here is the operative section, with th e CASE info on line 1:

$c = uq('SELECT f.id, f.name, c.name, c.id, CASE WHEN '.$GLOBALS['usr']->last_read.' < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS reads
FROM fud261_fc_view v
INNER JOIN fud261_forum f ON f.id=v.f
INNER JOIN fud261_cat c ON c.id=v.c
LEFT JOIN fud261_msg m ON m.id=f.last_post_id
'.($mod ? '' : 'LEFT JOIN fud261_mod mm ON mm.user_id='._uid.' AND mm.forum_id=f.id INNER JOIN fud261_group_cache g1 ON g1.resource_id=f.id AND g1.user_id=2147483647 LEFT JOIN fud261_group_cache g2 ON g2.resource_id=f.id AND g2.user_id='._uid).'
LEFT JOIN fud261_forum_read fr ON fr.forum_id=f.id AND fr.user_id='._uid.'
'.($mod ? '' : ' WHERE mm.id IS NOT NULL OR ((CASE WHEN g2.id IS NULL THEN g1.group_cache_opt ELSE g2.group_cache_opt END) & 1) > 0').'
ORDER BY v.id');

Should I change it? If I do, what do I do then. I still have no idea about "reads".

[Updated on: Thu, 28 February 2008 04:07]

Report message to a moderator

[Message index]

		Moving whole website to a different server By: WilliamBurns on Mon, 04 February 2008 20:56
		Re: Moving whole website to a different server By: Ilia on Mon, 04 February 2008 21:14
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 06 February 2008 01:28
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 06 February 2008 18:27
		Re: Moving whole website to a different server By: Ilia on Thu, 07 February 2008 01:46
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 07 February 2008 22:03
		Re: Moving whole website to a different server By: Ilia on Sun, 10 February 2008 14:29
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 11 February 2008 18:11
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 11 February 2008 18:20
		Re: Moving whole website to a different server By: Ilia on Mon, 11 February 2008 18:25
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 12 February 2008 00:14
		Re: Moving whole website to a different server By: Ilia on Tue, 12 February 2008 17:49
		Re: Moving whole website to a different server By: sallen812 on Tue, 12 February 2008 17:57
		Re: Moving whole website to a different server By: sallen812 on Tue, 12 February 2008 18:00
		Re: Moving whole website to a different server By: Ilia on Wed, 13 February 2008 20:40
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 14 February 2008 00:16
		Re: Moving whole website to a different server By: Ilia on Thu, 14 February 2008 17:56
		Re: Moving whole website to a different server By: sallen812 on Thu, 14 February 2008 19:16
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 14 February 2008 21:13
		Re: Moving whole website to a different server By: Ilia on Sun, 17 February 2008 17:22
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 19 February 2008 21:11
		Re: Moving whole website to a different server By: Ilia on Wed, 20 February 2008 03:05
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 20 February 2008 22:29
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 21 February 2008 03:00
		Re: Moving whole website to a different server By: Ilia on Thu, 21 February 2008 13:41
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 21 February 2008 18:31
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 21 February 2008 19:26
		Re: Moving whole website to a different server By: WilliamBurns on Fri, 22 February 2008 21:17
		Re: Moving whole website to a different server By: Ilia on Sun, 24 February 2008 15:57
		Re: Moving whole website to a different server By: WilliamBurns on Sun, 24 February 2008 21:50
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 25 February 2008 23:41
		Re: Moving whole website to a different server By: Ilia on Tue, 26 February 2008 00:06
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 26 February 2008 01:06
		Re: Moving whole website to a different server By: Ilia on Tue, 26 February 2008 23:58
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 27 February 2008 01:21
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 27 February 2008 23:34
		Re: Moving whole website to a different server By: Ilia on Thu, 28 February 2008 00:23
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 28 February 2008 00:40
		Re: Moving whole website to a different server By: Ilia on Fri, 29 February 2008 01:21
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 12 February 2008 19:07
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 03 March 2008 20:09
		Re: Moving whole website to a different server By: WilliamBurns on Fri, 07 March 2008 23:03
		Re: Moving whole website to a different server By: Ilia on Sun, 09 March 2008 17:34
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 10 March 2008 16:42
		Re: Moving whole website to a different server By: Ilia on Mon, 10 March 2008 23:25
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 11 March 2008 18:33
		Re: Moving whole website to a different server By: Ilia on Wed, 12 March 2008 17:37
		Re: Moving whole website to a different server By: WilliamBurns on Sat, 15 March 2008 00:04
		Re: Moving whole website to a different server By: Ilia on Mon, 17 March 2008 03:39
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 17 March 2008 18:14
		Re: Moving whole website to a different server By: Ilia on Mon, 17 March 2008 22:35
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 17 March 2008 23:48
		Re: Moving whole website to a different server By: Ilia on Tue, 18 March 2008 18:13
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 18 March 2008 20:17
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 19 March 2008 19:15
		Re: Moving whole website to a different server By: Ilia on Thu, 20 March 2008 00:11
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 24 March 2008 17:36
		Re: Moving whole website to a different server By: Ilia on Mon, 24 March 2008 18:09
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 24 March 2008 20:46
		Re: Moving whole website to a different server By: Ilia on Tue, 25 March 2008 20:19
		Re: Moving whole website to a different server By: WilliamBurns on Fri, 28 March 2008 19:22
		Re: Moving whole website to a different server By: Ilia on Sun, 30 March 2008 14:43
		Re: Moving whole website to a different server By: WilliamBurns on Sun, 30 March 2008 19:38
		Re: Moving whole website to a different server By: voisardf on Wed, 02 April 2008 19:50

Previous Topic:	disable poll
Next Topic:	query string for subject/body

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 22:15:16 GMT 2024

Total time taken to generate the page: 0.05930 seconds