News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

New Mod Site Changes

Started by JayBachatero, August 28, 2006, 12:16:58 AM

Previous topic - Next topic

JayBachatero

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. :P


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
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

vbgamer45

I just was thinking maybe a page with the top rated mod or the mods that are the most downloaded.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

JayBachatero

Well Most Popular is based on downloads and rating.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

vbgamer45

Ah, so thats how that works I always thought it was random then would explain it then.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

JayBachatero

Yup


$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__);
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

jerm

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

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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Thantos

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

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

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

bloc

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

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

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

JayBachatero

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
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

bloc

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

Version quick-links looks great.

JayBachatero

Um where would be the best place to add the Version quick-links?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Thantos

Well on the details page for sure ;)

JayBachatero

Details page?  If they in the mod they can see the version there :P.  I was thinking somewhere in the list page (main page).
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

JayBachatero

#18
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.


// 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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

jerm

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

Advertisement: