<?php

/****************************************************

**-Userawards-Addon-*********************************

**--original made by Firstborn e.V.******************

*--adapted to version 4.2.1b -- 4.2.2a by Schluepper*

****************************************************/

$us = mysql_num_rows(safe_query("SELECT userID FROM ".PREFIX."user"));

$pm3 = mysql_num_rows(safe_query("SELECT userID FROM ".PREFIX."user WHERE pmsent>='500'"));

$pm2 = mysql_num_rows(safe_query("SELECT userID FROM ".PREFIX."user WHERE pmsent>='250'"));

$pm1 = mysql_num_rows(safe_query("SELECT userID FROM ".PREFIX."user WHERE pmsent>='100'"));

$percpm3 = round($pm3/$us*100, 4);

$percpm2 = round($pm2/$us*100, 4);

$percpm1 = round($pm1/$us*100, 4);

$aktuell = strtotime(date());

/* Bug Fix in 5 years and half year */ 

$membertime4 = $aktuell - 157680000;

$membertime3 = $aktuell - 63072000;

$membertime2 = $aktuell - 31536000;

$membertime1 = $aktuell - 15768000;

$member4 = mysql_num_rows(safe_query("SELECT userID FROM ".PREFIX."user WHERE registerdate<='".$membertime4."'"));

$member3 = mysql_num_rows(safe_query("SELECT userID FROM ".PREFIX."user WHERE registerdate<='".$membertime3."'"));

$member2 = mysql_num_rows(safe_query("SELECT userID FROM ".PREFIX."user WHERE registerdate<='".$membertime2."'"));

$member1 = mysql_num_rows(safe_query("SELECT userID FROM ".PREFIX."user WHERE registerdate<='".$membertime1."'"));

$percmember4 = round($member4/$us*100, 4);

$percmember3 = round($member3/$us*100, 4);

$percmember2 = round($member2/$us*100, 4);

$percmember1 = round($member1/$us*100, 4);

echo '<h2>User Awards</h2>

      <table width="100%" cellpadding="5" cellspacing="1" bgcolor="#cccccc" border="0">

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/member1.png" width="40" height="100" border="0" title="For Membership of 6 months" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>6 Month Membership</b><br />Every user whose register date is dating back more than 180 days, is getting awarded with this medal.<br /><br /><b>'.$member1.'</b> times awarded (corresponds to <b>'.$percmember1.'%</b> of all users)</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/member2.png" width="40" height="100" border="0" title="For Membership of 1 Year" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>1 Year Membership</b><br />Every user whose register date is dating back more than 365 days, is getting awarded with this medal.<br /><br /><b>'.$member2.'</b> times awarded (corresponds to <b>'.$percmember2.'%</b> of all users)</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/member3.png" width="40" height="100" border="0" title="For Membership of 2 Years" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>2 Years Membership</b><br />Every user whose register date is dating back more than 720 days, is getting awarded with this medal.<br /><br /><b>'.$member3.'</b> times awarded (corresponds to <b>'.$percmember3.'%</b> of all users)</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/member4.png" width="40" height="100" border="0" title="For Membership of 5 Years" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>5 Year Membership</b><br />Every user whose register date is dating back more than 1825 days, is getting awarded with this medal.<br /><br /><b>'.$member4.'</b> times awarded (corresponds to <b>'.$percmember4.'%</b> of all users)</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/forum1.png" width="40" height="100" border="0" title="For 100 Forumposts" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>100 Forumposts</b><br />Every user who has postet 100 times or more in the forum, is getting awarded with this medal.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/forum2.png" width="40" height="100" border="0" title="For 250 Forumposts" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>250 Forumposts</b><br />Every user who has postet 250 times or more in the forum, is getting awarded with this medal.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/forum3.png" width="40" height="100" border="0" title="For 500 Forumposts" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>500 Forumposts</b><br />Every user who has postet 500 times or more in the forum, is getting awarded with this medal.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/community1.png" width="40" height="100" border="0" title="For 100 Comments" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>100 Comments</b><br />Every user who has postet 100 or more comments, is getting awarded with this medal. For this award all comments of news, articles, clanwars etc. were summed up.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/community2.png" width="40" height="100" border="0" title="For 250 Comments" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>250 Comments</b><br />Every user who has postet 250 or more comments, is getting awarded with this medal. For this award all comments of news, articles, clanwars etc. were summed up.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/community3.png" width="40" height="100" border="0" title="For 500 Comments" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>500 Comments</b><br />Every user who has postet 500 or more comments, is getting awarded with this medal. For this award all comments of news, articles, clanwars etc. were summed up.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/dist_com_rib.png" width="80" height="100" border="0" title="Distinguished Community Ribbon - For 1000 Forumposts and Comments" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>Distinguished Community Ribbon</b><br />This Ribbon is awarded to this kind of users which receive credit for their commitment to the community. Forumposts and comments of this person have to be over 1000 in sum.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/pm1.png" width="40" height="100" border="0" title="For 100 sended Private Messages" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>100 PM\'s</b><br />Every user who has sended 100 or more private messages, is getting awarded with this trophy.<br /><br /><b>'.$pm1.'</b> times awarded (corresponds to <b>'.$percpm1.'%</b> of all users)</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/pm2.png" width="40" height="100" border="0" title="For 250 sended Private Messages" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>250 PM\'s</b><br />Every user who has sended 250 or more private messages, is getting awarded with this trophy.<br /><br /><b>'.$pm2.'</b> times awarded (corresponds to <b>'.$percpm2.'%</b> of all users)</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/pm3.png" width="40" height="100" border="0" title="For 500 sended Private Messages" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>500 PM\'s</b><br />Every user who has sended 500 or more private messages, is getting awarded with this trophy.<br /><br /><b>'.$pm3.'</b> times awarded (corresponds to <b>'.$percpm3.'%</b> of all users)</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/news1.png" width="40" height="100" border="0" title="For 25 Newsposts" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>25 postet News</b><br />This Award is for editors with 25 or more published news.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/news2.png" width="40" height="100" border="0" title="For 50 Newsposts" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>50 postet News</b><br />This Award is for editors with 50 or more published news</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/news3.png" width="40" height="100" border="0" title="For 100 Newsposts" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>100 postet News</b><br />This Award is for editors with 100 or more published news</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/war1.png" width="40" height="100" border="0" title="For 5 played Clanwars" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>5 played Clanwars</b><br />This Award is for clanmembers with 5 or more Clanwars.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/war2.png" width="40" height="100" border="0" title="For 10 played Clanwars" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>10 played Clanwars</b><br />This Award is for clanmembers with 10 or more Clanwars.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/war3.png" width="40" height="100" border="0" title="For 25 played Clanwars" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>25 played Clanwars</b><br />This Award is for clanmembers with 25 or more Clanwars.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/war4.png" width="40" height="100" border="0" title="For 50 played Clanwars" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>50 played Clanwars</b><br />This Award is for clanmembers with 50 or more Clanwars.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/war5.png" width="40" height="100" border="0" title="For 75 played Clanwars" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>75 played Clanwars</b><br />This Award is for clanmembers with 75 or more Clanwars.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/war6.png" width="40" height="100" border="0" title="For 100 played Clanwars" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>100 played Clanwars</b><br />This Award is for clanmembers with 100 or more Clanwars.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/war7.png" width="40" height="100" border="0" title="For 150 played clanwars" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>150 played Clanwars</b><br />This Award is for Clanmembers with 150 or more Clanwars.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/war8.png" width="40" height="100" border="0" title="For 200 played Clanwars" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>200 played Clanwars</b><br />This Award is for clanmembers with 200 or more Clanwars.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/war9.png" width="40" height="100" border="0" title="For 300 played Clanwars" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>300 played Clanwars</b><br />This Award is for clanmembers with 300 or more Clanwars.</td>

        </tr>

        <tr bgcolor="#ffffff">

         <td align="center" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/war10.png" width="40" height="100" border="0" title="For 500 played Clanwars" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>500 played Clanwars</b><br />This Award is for clanmembers with 500 or more Clanwars.</td>

        </tr>';

          

          

$awardselect=safe_query("SELECT * FROM ".PREFIX."user_award_list ORDER BY uawardID");

while($df=mysql_fetch_array($awardselect)){

     

     $anz= mysql_num_rows(safe_query("SELECT uwID FROM ".PREFIX."user_awards WHERE awardID='".$df[uawardID]."'"));

     $perc=$anz/$us*100;

     $percentage=round($perc, 4);

     

     echo '<tr bgcolor="#ffffff">

            <td align="left" valign="middle" width="170"><img src="images/userawards/awards_left.png" width="40" height="100" border="0" /><img src="images/userawards/special/'.$df[image].'" height="100" border="0" title="'.$df[name].'" /><img src="images/userawards/awards_right.png" width="40" height="100" border="0" /></td><td align="left" valign="middle" ><b>'.$df[name].'</b><br />'.$df[info].'<br /><br /><b>'.$anz.'</b> times awarded (corresponds to <b>'.$percentage.'%</b> of all users)</td>

            </tr>';

}

echo '<tr>

           <td colspan="2" align="right"><h2>Userawards-Addon</h2><h4>--original made by <a href="http://www.firstborn.de" target="_blank">Firstborn e.V.</a> - adapted to version 4.2.2a by <a href="http://www.pro-gamer-united.de" target="_blank">Schluepper</a>--</h4></a></td></tr></table>';

?>