How to Cache ?

Sama34 · 05-20-2012 01:58 PM

And what about his?

PHP Code:

		static $forums_avatar_cache = null;
		if(!isset($forums_avatar_cache))
		{
			global $db, $cache;
			$forums = $cache->read('forums');

			$uidlist = '0';
			foreach($forums as $key => $val)
			{
				$f = $forums[$key];
				if($f['type'] == 'f' && $f['active'] == 1 && $f['lastposteruid'])
				{
					$uidlist .= ','.intval($f['lastposteruid']);
				}
			}

			$query = $db->simple_select('users', 'uid, avatar, avatardimensions', "uid IN ({$uidlist})");
			while($user = $db->fetch_array($query))
			{
				$forums_avatar_cache[$user['uid']] = $user;
			}
		}

It will make one query each page load in index, and forum display (but less code because of $tids and considering it gets the latest thread poster avatar too) is used.

I tried merging my data with the forum cache but it was to many hooks, too many code, and too many troubles to be worth it for such a feature.

Maybe I will ask for a review Smile

Threaded Mode \| Linear Mode Standard Tools
Forum Jump: View a Printable Version Send this Thread to a Friend Subscribe to this thread