awards.py

# -*- coding: UTF-8 -*-
# vim: set expandtab sw=4 ts=4 sts=4:
#
# phpMyAdmin web site
#
# Copyright (C) 2008 - 2016 Michal Cihar <michal@cihar.com>
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along
# with this program; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
#
"""Data for awards"""

from html import escape

# List of awards
AWARDS = [
    {
        'image': 'images/awards/2021-database-management-software.png',
        'link': 'https://digital.com/database-management-software/#phpMyAdmin',
        'title': 'Best Database Management Software of 2021',
        'text': '''
<p>phpMyAdmin was listed in
<a href="https://digital.com/" target="_blank" rel="noopener">Digital.com's</a>
<a href="%(link)s" target="_blank" rel="noopener">Best Database Management Software list</a>
in January 2021.</p>
''',
        'photos': [],
    },
    {
        'image': 'images/awards/2017-hosting-advice.png',
        'link': 'https://www.hostingadvice.com/blog/why-phpmyadmin-best-db-admin-tool-for-business/',
        'title': 'Best Database Admin Tool for Business Hosting',
        'text': '''
<p>phpMyAdmin was awarded
<a href="https://www.hostingadvice.com/" target="_blank" rel="noopener">HostingAdvice</a>'s
<a href="%(link)s" target="_blank" rel="noopener">Best Database Admin Tool for Business Hosting</a>
in January 2017.</p>
''',
        'photos': [],
    },
    {
        'image': 'images/awards/percona-live-logo.png',
        'link': 'https://openlife.cc/blogs/2013/april/mysql-community-awards-2013-and-winners-are',
        'title': '2013 MySQL Community Awards',
        'text': '''
<p>At the <a href="%(link)s" target="_blank" rel="noopener">2013 MySQL Community Awards</a> ceremony, our
project has won MySQL Application of the year 2013.</p>
''',
        'photos': [
            (
                'images/awards/2013-community-awards-3.jpg',
                'Accepting the award',
                'Marc Delisle representing the team'
            ),
            (
                'images/awards/2013-community-awards-1.jpg',
                'The trophy',
                'The trophy'
            ),
            (
                'images/awards/2013-community-awards-2.jpg',
                'The trophy\'s inscription',
                'The trophy\'s inscription'
            ),
        ],
    },
    {
        'image': 'images/awards/sf_cca_2009_logo.png',
        'link': 'https://sourceforge.net/blog/cca06/',
        'title': '2009 SourceForge.net Community Choice Awards',
        'text': '''
<p>For the <a href="%(link)s" target="_blank" rel="noopener">2009 SourceForge.net Community Choice Awards</a>,
phpMyAdmin was present in two categories: Best Tool or Utility for Developers (finalist) and Best Tool or Utility for SysAdmins (winner).</p>
''',
        'photos': [
            (
                'images/awards/sf_cca_2009_trophy.jpg',
                'The trophy',
                'The trophy'
            )
        ],
    },
    {
        'image': 'images/awards/infoworld-bossie-2008.jpg',
        'link': 'http://www.infoworld.com/',
        'title': 'InfoWorld 2008 Best of Open Source Awards',
        'text': '''
<p>Our project has won this <a href="%(link)s" target="_blank" rel="noopener">Infoworld 2008 award:</a>
Best of open source platforms and middleware (MySQL administration).</p>
''',
        'photos': [],
    },
    {
        'image': 'images/awards/sf_cca_2008_winner.png',
        'link': 'https://sourceforge.net/blog/cca08',
        'title': '2008 SourceForge.net Community Choice Awards',
        'text': '''
<p>For the <a href="%(link)s" target="_blank" rel="noopener">2008 SourceForge.net Community Choice Awards</a>,
phpMyAdmin was present in three categories: Best Tool or Utility for Developers (finalist), Best Tool or Utility for SysAdmins (winner), and Most Likely to Be the Next $1B Acquisition (winner).</p>
''',
        'photos': [
            (
                'images/awards/sf_cca_2008_trophies.jpg',
                'The two trophies',
                'The two trophies'
            )
        ],
    },
    {
        'image': 'images/awards/sf_cca_2007_sysadmin.gif',
        'link': 'https://sourceforge.net/blog/cca07',
        'title': '2007 SourceForge.net Community Choice Awards',
        'text': '''
<p>For the <a href="%(link)s" target="_blank" rel="noopener">2007 SourceForge.net Community Choice Awards</a>,
phpMyAdmin was present in two categories: Best Tool or Utility for Developers (nominated) and Best Tool or Utility for SysAdmins (winner).</p>
''',
        'photos': [
            (
                'images/awards/sf_cca_2007_trophy.jpg',
                'The trophy',
                'The trophy'
            )
        ],
    },
    {
        'image': 'images/awards/2006-trophees-logo.png',
        'link': 'https://tropheesdulibre.org/',
        'title': '2006 Trophees du Libre',
        'text': '''
<p>phpMyAdmin has won a Silver Trophy at the Third Trophees du Libre
(Free Software Awards) in the category PHP.</p>
''',
        'photos': [
            (
                'images/awards/2006-trophees-marc.jpg',
                'Receiving the award',
                'Marc Delisle (right) receiving the award in the name of '
                'the phpMyAdmin development team.'
            )
        ],
    },
    {
        'image': 'images/awards/2005-os2world.png',
        'link': 'https://www.os2world.com/',
        'title': '2005 OS2World.com Awards',
        'text': '''
<p>For the <a href="%(link)s" target="_blank" rel="noopener">5th Annual OS/2 World Awards</a>,
phpMyAdmin won in the category Best PHP Application.</p>
''',
        'photos': [],
    },
    {
        'image': 'images/awards/sf_cca_2006_winner.png',
        'link': 'https://sourceforge.net/blog/cca06/',
        'title': '2006 SourceForge.net Community Choice Awards',
        'text': '''
<p>For the first annual SourceForge.net <a href="%(link)s" target="_blank" rel="noopener">Community Choice
Awards</a>, phpMyAdmin won the first place in two categories: Databases and Sysadmin.</p>
''',
        'photos': [],
    },
    {
        'image': 'images/awards/2006-phpmag-ger.png',
        'link': 'https://www.phpmagazin.de/',
        'title': 'PHP Magazin Reader\'s Choice Award 2006',
        'text': '''
<p>phpMyAdmin was awarded the Reader's Choice Award 2006 in the category Best PHP-Tool / Best PHP-Application
by the readers of the <a href="%(link)s" target="_blank" rel="noopener">German PHP Magazin</a>.</p>
''',
        'photos': [],
    },
    {
        'image': 'images/awards/2005-phpmag-ger.gif',
        'link': 'https://www.phpmagazin.de/',
        'title': 'PHP Magazin Reader\'s Choice Award 2005',
        'text': '''
<p>phpMyAdmin was awarded the Reader's Choice Award 2005 in the category Best PHP-Tool / Best PHP-Application
by the readers of the <a href="%(link)s" target="_blank" rel="noopener">German PHP Magazin</a>.</p>
''',
        'photos': [],
    },
    {
        'image': 'images/awards/2003-phpmag-ger.gif',
        'link': 'https://www.phpmagazin.de/',
        'title': 'PHP Magazin Reader\'s Choice Award 2003',
        'text': '''
<p>phpMyAdmin was awarded the Reader's Choice Award 2003 in the category Best PHP-Tool / Best PHP-Application
by the readers of the <a href="%(link)s" target="_blank" rel="noopener">German PHP Magazin</a>.</p>
''',
        'photos': [
            (
                'images/awards/2003-php-conf.jpg',
                'Receiving the award',
                'Alexander Turek and Garvin Hicking receiving the award '
                'in the name of the phpMyAdmin development team at '
                '2003 PHP International Conference.'
            )
        ],
    },
    {
        'image': 'images/awards/2003-phpmag-int.gif',
        'link': 'https://www.phpmagazin.de/',
        'title': 'International PHP Magazine Reader\'s Choice Award 2003',
        'text': '''
<p>phpMyAdmin was awarded the Reader's Choice Award 2003 in the category Best PHP-Tool / Best PHP-Application
by the readers of the <a href="%(link)s" target="_blank" rel="noopener">International PHP Magazine</a>.</p>
''',
        'photos': [
            (
                'images/awards/2003-php-conf.jpg',
                'Receiving the award',
                'Alexander Turek and Garvin Hicking receiving the award '
                'in the name of the phpMyAdmin development team at '
                '2003 PHP International Conference.'
            )
        ],
    },
    {
        'image': 'images/awards/2002-12-sfnet-potm.png',
        'link': 'https://sourceforge.net/potm/potm-2002-12.php',
        'title': 'Sourceforge.net project of the month',
        'text': '''
<p>phpMyAdmin was awarded
<a href="https://sourceforge.net" target="_blank" rel="noopener">Sourceforge.net</a>'s
<a href="%(link)s" target="_blank" rel="noopener">Project of the month</a>
in December 2002. Have a look at that <a href="%(link)s" target="_blank" rel="noopener">article</a>, if you
want to learn about the early years of phpMyAdmin.</p>
''',
        'photos': [],
    },
]

# Allow award text to use other things as format string
for award in AWARDS:
    award['text'] = award['text'] % {
        'link': escape(award['link'])
    }