Awards PM

<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright © 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
| Name: Awards
| Author: Flyingduck / http://flyingduck.dk/
| Angepasst an v7: ObiWan / http:/www.futigo.de
+--------------------------------------------------------+
| Adapted to v7.02.03: Maksas / http:ltfusions.lt
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "../../maincore.php";
//require_once THEMES."templates/admin_header.php";
require_once THEMES."templates/header.php";
if (!checkrights("AW") || !defined("iAUTH") || $_GET['aid'] != iAUTH) { redirect(BASEDIR."index.php"); }

include INFUSIONS."awards/infusion_db.php";
if (file_exists(INFUSIONS."awards/locale/".$settings['locale'].".php")) {
        include INFUSIONS."awards/locale/".$settings['locale'].".php";
} else {
        include INFUSIONS."awards/locale/German.php";
}
if (isset($_GET['delete']) && isnum($_GET['delete'])) {
        $result = dbquery("DELETE FROM ".DB_AWARD." WHERE award_id='".$_GET['delete']."'");
        redirect(FUSION_SELF.$aidlink);
} elseif (isset($_POST['add'])){
        $result = dbquery("INSERT INTO ".DB_AWARD." VALUES('', '".(isnum($_POST['award_user']) ? $_POST['award_user'] : 0)."', '".stripinput($_POST['award_img'])."', '".stripinput($_POST['award_info'])."')");
  $nuot = "Administracija";
     $nuo = "1";
     $kam = isnum($_POST['award_user']);
     $tema = "Sėkmingas pinigų pervėdimas ";
     $zinute = "Gavote apdovanojimą už ".stripinput($_POST['award_info']);
     $result2 = dbquery("INSERT INTO ".DB_MESSAGES." (message_to, message_from, message_subject, message_message, message_smileys, message_read, message_datestamp, message_folder) VALUES('".$kam."','".$nuo."','".$tema."','".$zinute."','y','0','".time()."','0')");
        redirect(FUSION_SELF.$aidlink);
} else {
        opentable($locale['aw101']);
        echo "<form action='".FUSION_SELF.$aidlink."' method='post'>";
        $_GET['msg_send'] = $data['user_id'];
        echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl2-border'>\n<tr>\n";
        echo "<td width='40%' class='tbl' style='text-align:center;'>".$locale['aw104']." <select name='award_user' class='textbox'>";
        $user_list = ""; $user_types = ""; $sel = "";
        $result = dbquery("SELECT u.user_id, u.user_name, u.user_avatar FROM ".DB_USERS." u ORDER BY user_level DESC, user_name ASC");
        while ($data = dbarray($result)) {
        $sel = ($_GET['msg_send'] == $data['user_id'] ? " selected='selected'" : "");
                $user_list .= "<option value='".$data['user_id']."'".$sel.">".$data['user_name']."</option>\n";
        }
        echo $user_list;
        echo "</select></td></tr><tr>";
        echo "<td width='40%' class='tbl' style='text-align:center;'>".$locale['aw105']." <select name='award_img' class='textbox'>";
        $awardImages = makefileopts(makefilelist(INFUSIONS."awards/images/awards/", ".|..|index.php"));
        $image_files = makefilelist(INFUSIONS."awards/images/awards/", ".|..|index.php", true);
        $image_list = makefileopts($image_files);
        echo $image_list;
        echo "</select></td></tr>";
        echo "<td width='50%' class='tbl' style='text-align:center;'>".$locale['aw106']."<input type='text' name='award_info' class='textbox'> </td></tr>";
        echo "<tr><td width='20%' class='tbl' style='text-align:center;'><input type='submit' name='add' value='Suteikti' class='button'></td></tr></table></form>";
}
echo "<br /><br />\n";
add_to_head("<script type='text/javascript' src='".INFUSIONS."awards/eap.js'></script>");
echo "<div class='side-label eui_master_head' style='margin-bottom:1px' title='".$locale['aw113']."'><img width='22' src='".INFUSIONS."awards/images/plus.png' style='border: 0px none; vertical-align: middle;'><span class='small'>
<a href='#' onclick='return false;' style='outline:none; text-decoration:none; font-weight: none;'><b>".$locale['aw114']."</b></a>".$locale['aw115']."</span></div>\n";
echo "<div class='eui_master_body' style='margin: 0em 0.2em 0em 0.2em;'>\n";
//$result_award  = dbquery("SELECT * FROM ".DB_AWARD." desc limit 0,1");
$limit = "5";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n";
                echo "<td width='1%' class='tbl2'>&nbsp;</td>\n";
                echo "<td width='10%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['aw116']."</strong></td>\n";
                echo "<td width='10%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['aw108']."</strong></td>\n";
                echo "<td width='10%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['aw109']."</strong></td>\n";
                echo "<td width='10%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['aw110']."</strong></td>\n";
                echo "<td width='10%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['aw111']."</strong></td>\n";
                echo "</tr>\n";

$result = dbquery(" SELECT award_user, award_id, award_img, award_info FROM ".DB_AWARD." WHERE award_user  ORDER BY award_id DESC LIMIT 0,$limit");
if (dbrows($result)) {
while($data = dbarray($result)){
$row_color = ($i % 2 == 2 ? "tbl1" : "tbl2");
echo "<tr>\n<td class='".$row_color."'>";
echo "<td width='10%' class='".$row_color."' style='text-align:center;white-space:nowrap'>".number_format(dbcount("(award_id)", DB_AWARD, "award_user='".$data['award_user']."'"))." </td>\n";
echo "<td width='10%' class='".$row_color."' style='text-align:center;white-space:nowrap'>".$data['award_user']."</td>\n";
echo "<td width='10%' class='".$row_color."'style='text-align:center;white-space:nowrap' ><img src='".INFUSIONS."awards/images/awards/".$data['award_img']."'></td>\n";
echo "<td width='10%' class='".$row_color."' style='text-align:center;white-space:nowrap'>".$data['award_info']."</td>\n";
echo "<td width='10%' class='".$row_color."' style='text-align:center;white-space:nowrap'><a href='".FUSION_SELF.$aidlink."&amp;delete=".$data['award_id']."'>".$locale['aw112']."</a></td>";
echo "</tr>\n";
   }
}
echo "</td></table>";
echo "</div>";
add_to_head("<script type='text/javascript' src='".INFUSIONS."awards/eap.js'></script>");
echo "<div class='side-label eui_head' style='margin-bottom:1px' title='".$locale['aw113']."'><img width='22' src='".INFUSIONS."awards/images/plus.png' style='border: 0px none; vertical-align: middle;'><span class='small'>
<a href='#' onclick='return false;' style='outline:none; text-decoration:none; font-weight: none;'><b>".$locale['aw113']."</b></a>".$locale['aw117']."</span></div>\n";
echo "<div class='eui_body' style='margin: 0em 0.2em 0em 0.2em;'>\n";
$result = dbquery("SELECT * FROM ".DB_AWARD."");
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n";
                echo "<td width='1%' class='tbl2'>&nbsp;</td>\n";
                echo "<td width='10%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['aw108']."</strong></td>\n";
                echo "<td width='10%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['aw109']."</strong></td>\n";
                echo "<td width='10%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['aw110']."</strong></td>\n";
                echo "<td width='10%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['aw111']."</strong></td>\n";
                echo "</tr>\n";
                while($data = dbarray($result)){
                $row_color = ($i % 2 == 2 ? "tbl1" : "tbl2");
                echo "<tr>\n<td class='".$row_color."'>";
                if($data['award_user']){
echo "<td width='10%' class='".$row_color."' style='text-align:center;white-space:nowrap'> ".$data['award_user']."</td>\n";
echo "<td width='10%' class='".$row_color."'style='text-align:center;white-space:nowrap' ><img src='".INFUSIONS."awards/images/awards/".$data['award_img']."'></td>\n";
echo "<td width='10%' class='".$row_color."' style='text-align:center;white-space:nowrap'>".$data['award_info']."</td>\n";
echo "<td width='10%' class='".$row_color."' style='text-align:center;white-space:nowrap'><a href='".FUSION_SELF.$aidlink."&amp;delete=".$data['award_id']."'>".$locale['aw112']."</a></td>";
echo "</tr>\n";
   }
}
echo "</td></table>";
echo "</div>";
closetable();
require_once THEMES."templates/footer.php";
?>