View All"; while ($d_mod_cats = dbarray($q_mod_cats)) { if (checkgroup($d_mod_cats['mod_cat_access'])) { $cat_list .= "\n"; } } $ver_list = "".buildversionoptionlist($mod_ver_id); $mod_type_list = ""; foreach ($mod_types as $k=>$mod_type) { $mod_type_list .= "\n"; } foreach ($mod_orderby as $k=>$mod_orderby) { $mod_orderby_list .= "\n"; } foreach ($mod_orderby_dir as $k=>$mod_orderby_dir) { $mod_orderby_dir_list .= "\n"; } $rows = dbresult(dbquery("SELECT COUNT(*) FROM ".DB_MOD_CATS." tc LEFT JOIN ".DB_MODS." tm USING(mod_cat_id) LEFT JOIN ".DB_MOD_VERSIONS." tv USING(version_id) WHERE ".groupaccess('tc.mod_cat_access')." AND ".$db_opts." AND mod_status='0'"),0); if ($rows != 0) { $result = dbquery( "SELECT tc.*,tm.*,tv.*,SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes FROM ".DB_MOD_CATS." tc LEFT JOIN ".DB_MODS." tm USING(mod_cat_id) LEFT JOIN ".DB_MOD_VERSIONS." tv USING(version_id) LEFT JOIN ".DB_RATINGS." tr ON tr.rating_item_id = tm.mod_id AND tr.rating_type='M' WHERE ".$db_opts." AND ".groupaccess('tc.mod_cat_access')." GROUP BY mod_id, tc.mod_cat_id ORDER BY mod_cat_order, ".$mod_orderby_value." ".$mod_orderby_dir_value." LIMIT ".$_GET['rowstart'].",".$settings['mods_per_page'] ); } echo "\n"; tablebreak(); if ($rows != 0) { echo "

\n"; $mod_cat_old = -1; while ($data = dbarray($result)) { if ($data['mod_cat_id'] <> $mod_cat_old) { echo "\n"; } if ($data['mod_id']) { $ver = "v".$data['version_h'].".".$data['version_l'].($data['version_s'] != "" ? " ".$data['version_s'] : ""); if ($data['count_votes'] > 0) { $rating = str_repeat("

", ceil($data['sum_rating'] / $data['count_votes'])); } else { $rating = $locale['moddb408']; } $mod_author = ($data['mod_author_name'] == "" ? $locale['moddb409'] : $data['mod_author_name']); if ($data['mod_date'] + 604800 > time() + ($settings['timeoffset'] * 3600)) { $new = "

"; } else { $new = "

"; } echo "\n"; $mod_cat_old = $data['mod_cat_id']; } else { echo "\n"; } } echo "

".$locale['moddb401']."		".$locale['moddb405']."	".$locale['moddb402']."	".$locale['moddb403']."	".$locale['moddb404']."	".$locale['moddb406']."
".stripslashes($data['mod_cat_name'])."
".$new."	".trimlink($data['mod_name'], 30)."	".strftime("%d/%m/%Y",$data['mod_date']+($settings['timeoffset']*3600))."	".trimlink($mod_author, 20)."	".$data['mod_version']."	".$ver."	".$rating."
-	".(isset($mod_cat_id) \|\| isset($mod_ver_id) \|\| isset($mod_modtype) ? $locale['moddb424'] : $locale['moddb422'])."

\n"; } else { if (iMEMBER) { echo "
".(isset($mod_cat_id) || isset($mod_ver_id) || isset($mod_modtype) ? $locale['moddb424'] : $locale['moddb421'])."

\n"; } else { echo "

".$locale['moddb425']." ".$locale['moddb426']." ".$locale['moddb427']."

"; } } if ($rows > $settings['mods_per_page']) echo "

\n".makePageNav($_GET['rowstart'], $settings['mods_per_page'], $rows, 3, ($get_vars ? FUSION_SELF."".$get_vars."&" : ""))."\n

\n"; closetable(); echo "\n"; add_to_title ($locale['moddb435'].$locale['moddb400']); require_once THEMES."templates/footer.php"; ?>

Welcome to the MOD database. Use the controls on the right to find the MODs you want.	Category
	Type
	Fusion Version
	Order By