Advertisement:

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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
New Mod Site Changes
« 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. :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
« Last Edit: April 05, 2007, 11:36:34 AM by JayBachatero »
Follow me on Twitter

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

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,619
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New Mod Site Changes
« 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.
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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: New Mod Site Changes
« Reply #2 on: August 29, 2006, 11:23:03 PM »
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

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,619
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: New Mod Site Changes
« 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.
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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: New Mod Site Changes
« 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__);
Follow me on Twitter

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

Offline jerm

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 7,250
Re: New Mod Site Changes
« 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..

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: New Mod Site Changes
« 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.
Follow me on Twitter

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

Offline Thantos

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 16,163
  • Gender: Male
Re: New Mod Site Changes
« Reply #7 on: August 30, 2006, 02:13:15 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?

Offline jerm

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 7,250
Re: New Mod Site Changes
« Reply #8 on: August 30, 2006, 02:41:44 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

Offline Amacythe

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,060
  • Gender: Female
Re: New Mod Site Changes
« Reply #9 on: August 30, 2006, 03:39:45 AM »
Maybe we should have another listing for the last few mods downloaded?

bloc

  • Guest
Re: New Mod Site Changes
« 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.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: New Mod Site Changes
« 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.
Follow me on Twitter

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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: New Mod Site Changes
« Reply #12 on: August 30, 2006, 11:23:35 AM »
What do you guys think of adding something like this.

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

  • Guest
Re: New Mod Site Changes
« Reply #13 on: August 30, 2006, 02:22:53 PM »
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

  • Guest
Re: New Mod Site Changes
« Reply #14 on: August 30, 2006, 02:23:32 PM »
Version quick-links looks great.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: New Mod Site Changes
« Reply #15 on: August 30, 2006, 02:32:21 PM »
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

Offline Thantos

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 16,163
  • Gender: Male
Re: New Mod Site Changes
« Reply #16 on: August 30, 2006, 02:36:27 PM »
Well on the details page for sure ;)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: New Mod Site Changes
« Reply #17 on: August 30, 2006, 02:56:52 PM »
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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: New Mod Site Changes
« 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.
« Last Edit: August 30, 2006, 03:45:55 PM by Jay The Code Monkey »
Follow me on Twitter

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

Offline jerm

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 7,250
Re: New Mod Site Changes
« 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