Manga of the week

Its working now on Linux too. ??
+rep ??

Working and Enjoying.

Here it is Short code one. Place it in kommiku.php file.
Its daily based.

add_shortcode( 'kommiku_manga_of_the_week' , 'manga_of_the_week' );
	function manga_of_the_week() {
require_once(KOMMIKU_FOLDER.'/admin/database.php');
		$db = new kommiku_database();
		$motw = $db->chapter_update_list();
		if($motw) $i = 0;
			foreach ($motw as $item) {
			$i++;
				$theLIST .= '<table><tr><td><a href="'.HTTP_HOST.KOMMIKU_URL_FORMAT.'/'.$item->series_slug.'/">'.$item->series_name.'</a></td></tr><tr><td>Summary:</td><td>'.$item->series_summary.'</td></tr>
				</table>';
				if($i > 0){break;}
			};	

		return $theLIST;
}

Now edit database file. Add this function

function manga_of_the_week() {
		global $wpdb;
		$chapterUquery = "SELECT
					c.id as id,
					c.title as series_name,
					c.slug as series_slug,
					c.title as title,
					c.slug as slug,
					c.img as series_cover,
					a.slug as latest_slug,
					a.pubdate as last_update,
					c.chapterless as chapterless,
					c.status as status,
					c.summary as series_summary,
					c.categories as series_cat
					FROM <code>".$wpdb->prefix."comic_chapter</code> a,
					(SELECT series_id, max(number) as number
					FROM <code>".$wpdb->prefix."comic_chapter</code>
					GROUP BY series_id) b,
					<code>".$wpdb->prefix."comic_series</code> c
					WHERE b.series_id = a.series_id AND b.number = a.number AND b.series_id = c.id
					ORDER BY RAND(DAYOFWEEK(CURRENT_DATE)) Limit 1";

		$manga_of_the_week = $wpdb->get_results($chapterUquery);
		return $manga_of_the_week;
	}