Author Topic: New Mod Site Changes (Read 36831 times)

JayBachatero · « **on:** August 28, 2006, 12:16:58 AM »

Ok this is a list of the new planned changes to the mod site. It's here so that I wont forget what is being discussed.

Things that need to be integrated

Report as unsafe DONE
Stats DONE
~~Review page~~
Permissions DONE

Taskfreak - http://mods.simplemachines.org/todo/index.php?sProject=6&show=today&sort=deadlineDate&dir=1

vbgamer45 · « **Reply #1 on:** August 29, 2006, 11:13:30 PM »

I just was thinking maybe a page with the top rated mod or the mods that are the most downloaded.

JayBachatero · « **Reply #2 on:** August 29, 2006, 11:23:03 PM »

Well Most Popular is based on downloads and rating.

vbgamer45 · « **Reply #3 on:** August 29, 2006, 11:54:13 PM »

Ah, so thats how that works I always thought it was random then would explain it then.

JayBachatero · « **Reply #4 on:** August 30, 2006, 12:01:41 AM »

Yup

Code: [Select]

	$request = my_db_query("
		SELECT ms.ID_MOD, ms.modName, ms.modifiedTime, ms.short_desc, COUNT(lm.ID_MOD) AS recentDownloads, ms.submitTime, 
			(COUNT(lm.ID_MOD)/$popDays) + ms.rating AS score
		FROM {$mod_prefix}mods AS ms
	       		LEFT JOIN {$mod_prefix}log_mods AS lm ON (lm.ID_MOD = ms.ID_MOD)
		WHERE ms.approved = 1
			AND ms.downloads > 0
		GROUP BY ID_MOD
		ORDER BY score DESC
		LIMIT 5", __FILE__, __LINE__);

jerm · « **Reply #5 on:** August 30, 2006, 01:32:00 AM »

the only problem with most popular is that it always seems to be the same ones :/ that female avatar hasn't budged from first place, and neither has the ad mod for months..

JayBachatero · « **Reply #6 on:** August 30, 2006, 01:47:42 AM »

Umm I'll see what I can do then. But how would you show these mods? Maybe have a stats page for most downloaded, highest rating and so on like stats page? Also mod developer with most mods.

Thantos · « **Reply #7 on:** August 30, 2006, 02:13:15 AM »

Quote from: jerm on August 30, 2006, 01:32:00 AM

the only problem with most popular is that it always seems to be the same ones :/ that female avatar hasn't budged from first place, and neither has the ad mod for months..

If they are constantly being downloaded or have a high positive feedback doesn't that make them the most popular?

jerm · « **Reply #8 on:** August 30, 2006, 02:41:44 AM »

Quote from: Thantos on August 30, 2006, 02:13:15 AM

Quote from: jerm on August 30, 2006, 01:32:00 AM
the only problem with most popular is that it always seems to be the same ones :/ that female avatar hasn't budged from first place, and neither has the ad mod for months..
If they are constantly being downloaded or have a high positive feedback doesn't that make them the most popular?

*shurgs* you are right.

I just find it boring.. i hardly look at the top5 anymore cause it doesn't change

Amacythe · « **Reply #9 on:** August 30, 2006, 03:39:45 AM »

Maybe we should have another listing for the last few mods downloaded?

bloc · « **Reply #10 on:** August 30, 2006, 09:42:15 AM »

I would say 5 latest and 5 top is the way to go. Although you might have to juggle the page a bit for both to go in. I suggest moving "Getting started" under below and put 5 top and 5 latest boxes on the right.

This could really be good for Themes site as well. If you implement it, i would love to see the same there.

JayBachatero · « **Reply #11 on:** August 30, 2006, 10:50:39 AM »

Umm about about latest 5 mods and put it right next to the featured mod and move the "Mod developers" down.

JayBachatero · « **Reply #12 on:** August 30, 2006, 11:23:35 AM »

What do you guys think of adding something like this.

Quote from: alx | all4pg on August 30, 2006, 08:23:46 AM

Não seria interessante links com os mods separados por versões?

MODIFICAÇÕES PARA:
1.0.x | 1.1 RC1 | 1.1 RC2 | 1.1 RC3

*
*
*

Would not be interesting links with mods separate for versions?

MODIFICATIONS FOR:
1.0.x | 1.1 RC1 | 1.1 RC2 | 1.1 RC3

(english provided by google... kkkkk sorry!)

It's easy to do too.
SMF 1.1 RC3 | SMF 1.1 RC2 | SMF 1.0.8

bloc · « **Reply #13 on:** August 30, 2006, 02:22:53 PM »

Quote from: Jay The Code Monkey on August 30, 2006, 10:50:39 AM

Umm about about latest 5 mods and put it right next to the featured mod and move the "Mod developers" down.

That can work too. Might be better as then the importance of top 5 seems greater.

bloc · « **Reply #14 on:** August 30, 2006, 02:23:32 PM »

Version quick-links looks great.

JayBachatero · « **Reply #15 on:** August 30, 2006, 02:32:21 PM »

Um where would be the best place to add the Version quick-links?

Thantos · « **Reply #16 on:** August 30, 2006, 02:36:27 PM »

Well on the details page for sure

JayBachatero · « **Reply #17 on:** August 30, 2006, 02:56:52 PM »

Details page? If they in the mod they can see the version there

. I was thinking somewhere in the list page (main page).

JayBachatero · « **Reply #18 on:** August 30, 2006, 03:33:32 PM »

Ok added the "Latest Mods" section. I stored it to cache also.

Also I added a cache time setting. I set that to a day 86400 secs.

Code: [Select]

	// Get the latest 5 mods but only if the cache is older than 24 hours
	if (isset($modSettings['latest_mods_cache']) && (time() - $modSettings['latest_mods_cache_time'] < $mod_site['cache_time']))
	{
		$context['latest_mods'] = @unserialize($modSettings['latest_mods_cache']);
	}
	else
	{
		$context['latest_mods'] = array();

		// Select the info from the db
		$latestModsSelect = db_query("
			SELECT ID_MOD, modName, short_desc, downloads
			FROM {$db_prefix}mods
			WHERE approved = 1
			ORDER BY ID_MOD DESC
			LIMIT 5", __FILE__, __LINE__);

		while ($row = mysql_fetch_assoc($latestModsSelect))
		{
			$context['latest_mods'][$row['ID_MOD']] = array(
				'id' => $row['ID_MOD'],
				'name' => $row['modName'],
				'short_name' => $func['strlen']($row['modName']) <= 20 ? $row['modName'] : $func['substr']($row['modName'], 0, 20) . '...',
				'short_desc' => $row['short_desc'],
				'href' => $context['script'] . '?mod=' . $row['ID_MOD'],
			);
		}
		mysql_free_result($latestModsSelect);

		// Store in the cache
		updateSettings(
			array(
				'latest_mods_cache_time' => time(),
				'latest_mods_cache' => addslashes(serialize($context['latest_mods'])),
			)
		);
	}

EDIT: Forgot link
http://mods.simplemachines.org/area51/jaybachatero/index.php

Bloc I can update the theme site files and hand them over to Mike.

jerm · « **Reply #19 on:** August 30, 2006, 04:57:53 PM »

Looks good.
Lots of white space if you don't full screen lol, but its all good

News:

Author Topic: New Mod Site Changes (Read 36831 times)

bloc

bloc

bloc