View Single Post
  #4  
Old 28th March 2013, 19:53
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,113
Default
Here let me do it for you
PHP Code:
<?
require_once("include/bittorrent.php");
dbconn();
loggedinorreturn();

/* --- Ieslēdzam, ja gribam izvēlēties gadus --- */
$where 'WHERE year = \'2013\''//Default
if(isset($_GET["year"]))
{
    if(
$_GET["year"] == 'all')
    {
        
$whwere ='';
    }
    else
    {
        
$where 'WHERE year = \'20'$_GET["year"] . '\'';
    }
}
/* --- End --- */


$res1 mysql_query("SELECT COUNT(*) FROM premieres " $where); 
/* --- Aizvietojam ar $res1 = mysql_query("SELECT COUNT(*) FROM premieres"); ja negribam gada izvēli --- */


$row1 mysql_fetch_array($res1);
$count $row1[0];
$limit 16;
list(
$pagertop$pagerbottom$limit) = pager($limit$count"/filmas.php?", array('nopage' => true));

stdhead($tracker_lang['movies']);

?>
<style>
.wrapper { white-space: nowrap; }
.wrapper .field { 
    width: 175px;
    overflow: hidden;
    display: block;
    text-overflow: ellipsis;
}
.wrapper .field:hover { 
    position: relative;    
    overflow: visible; }
.wrapper .field span { background: #ffffff; }
</style>
<script src="js/glossy.js" language="javascript" type="Text/JavaScript"></script>
<?

/* --- Lai ieslēgtu gada izvēli --- */
print("<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<table width='100%' border='0' cellpadding='0' cellspacing='0'><tr>
<td class='block' width='14' align='left'><img src='themes/"
.$ss_uri."/images/mala_kreisaa.png' width='14' height='24'></td>
<td class='block' width='100%' align='center' valign='middle' background='themes/"
.$ss_uri."/images/vidus.png'><font class='block-title' valign='bottom'><strong>".$tracker_lang['cur_sense']."$where".$tracker_lang['sense_movies']."</strong></font></td>
<td class='block' width='15' align='right'><img src='themes/"
.$ss_uri."/images/mala_labaa.png' width='14' height='24'>
</td></tr>"
);
print(
"<table width=\"100%\" class=\"main\" cellpadding=\"4\">");
print(
"<tr><td>");
if(
get_user_class() >= UC_MODERATOR){
print(
"<center><a href=\"addfilmas.php\">Pievienot jaunu filmu</a></center>"); }
print(
"<form method=\"get\" action=\"filmas.php\"><p align=\"center\">".$tracker_lang['gads_izvele']."&nbsp;<select name=\"year\">
<option value=\"00\">2000</option>
<option value=\"01\">2001</option>
<option value=\"02\">2002</option>
<option value=\"03\">2003</option>
<option value=\"04\">2004</option>
<option value=\"05\">2005</option>
<option value=\"06\">2006</option>
<option value=\"07\">2007</option>
<option value=\"08\">2008</option>
<option value=\"09\">2009</option>
<option value=\"10\">2010</option>
<option value=\"11\">2011</option>
<option value=\"12\">2012</option>
<option value=\"13\">2013</option>
<option value=\"14\">2014</option>
<option value=\"15\">2015</option>
<option value=\"16\">2016</option>
<option value=\"17\">2017</option>
<option value=\"18\">2018</option>
<option value=\"19\">2019</option>
<option value=\"20\">2020</option>
</select>&nbsp;&nbsp;<input class=\"btn\" type=\"submit\" value=\""
.$tracker_lang['sp_gatavs']."\" /></p></form>");
print(
"</td></tr>");
print(
"</table>");
/* --- End --- */

print("<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<table width='100%' border='0' cellpadding='0' cellspacing='0'><tr>
<td class='block' width='14' align='left'><img src='themes/"
.$ss_uri."/images/mala_kreisaa.png' width='14' height='24'></td>
<td class='block' width='100%' align='center' valign='middle' background='themes/"
.$ss_uri."/images/vidus.png'><font class='block-title' valign='bottom'><strong>".$tracker_lang['new_movies']."</strong></font></td>
<td class='block' width='15' align='right'><img src='themes/"
.$ss_uri."/images/mala_labaa.png' width='14' height='24'>
</td></tr>"
);
print(
"<table width=\"100%\" class=\"main\" cellpadding=\"4\">");
print(
"<tr>");

$res mysql_query("SELECT premieres.id, premieres.name, premieres.year, premieres.genre, premieres.descr, premieres.imdb, premieres.imdb_rating, premieres.uploaded, premieres.url, premieres.poster, premieres.owner, premieres.ori_name, users.username, users.class FROM premieres LEFT JOIN users ON premieres.owner = users.id WHERE year = '$where' ORDER BY id DESC $limit");
if(
mysql_num_rows($res) > 0){
while(
$arr mysql_fetch_array($res))
{
$id $arr['id'];
$name $arr['name'];
$ori_name $arr['ori_name'];
$year $arr['year'];
$genre $arr['genre'];
$imdb $arr['imdb'];
$imdb_rating $arr['imdb_rating'];
$lang $arr['lang'];
$year $arr['year'];
$descr $arr['descr'];
$uploaded $arr['uploaded'];
$url $arr['url'];

$search_name preg_replace("/[^-_a-z0-9]+/i""+"$ori_name);
$poster "<a href=\"http://filebitz.org/browse.php?c25=1&c26=1&c24=1&c41=1&c47=1&c23=1&search=$search_name\"><img src=\"$arr[poster]\" width=\"170\" height=\"228\" border=\"0\" class=\"glossy\" title=\"".htmlspecialchars_uni($descr)."\"></a>";

$shortname myTruncate($ori_name25" ");
$shortname2 myTruncate($name25" ");

print(
"<td align=\"center\" colspan=\"3\" border=\"0\" width=\"175\"><div align=\"center\"><hr><a href=\"http://filebitz.org/browse.php?c25=1&c26=1&c24=1&c41=1&c47=1&c23=1&search=$search_name\" title=\"$name\"><b><u>$shortname2</u></b></a>
<br><small><a href=\"http://filebitz.org/browse.php?c25=1&c26=1&c24=1&c41=1&c47=1&c23=1&search=
$search_name\" title=\"$ori_name\"><b><a href=\"#\" title=\"$ori_name\">$shortname</b></a></small>
<hr><p>
$poster</p>
<hr><div class=\"wrapper\"><span class=\"field\"><span><b>"
.$tracker_lang['genrei']."</b>: <font color=\"red\">$genre</font></span></span></div>
<br><b>"
.$tracker_lang['my_year']."</b>: <font color=\"red\">$year</font>
<br><a href=
$imdb><img src=\"pic/filmas/imdb.png\" align=absmiddle alt=IMDB title=IMDB width=35 height=35/></a>
&nbsp;&nbsp;&nbsp;&nbsp;<a href=
$url><img src=\"pic/filmas/youtube.png\" alt=YouTube align=absmiddle title=YouTube width=50 height=17/></a>
<br><b>IMDB Rating:</b> <fony color=\"red\">
$imdb_rating/10</font>");

if(
get_user_class() >= UC_MODERATOR || $CURUSER['id'] == $arr['owner']){
print(
"<br><a href=\"takefilmas.php?p=delete&id=$id\"><b title=\"Dzēst filmu\"><span style=\"color: #CC3333;\"><small>[Dzēst]</small></span></b></a>&nbsp;&nbsp<a href=\"filmasedit.php?id=$id\"><b title=\"Rediģēt filmu\"><span style=\"color: #CC3333;\"><small>[Rediģēt]</small></span></b></a>");
}
print(
"<p></p></div>");
++
$pre[$res];
if (
$pre[$res] <=){
print(
'</td>');
}else{
print(
'</td></tr>');
$pre[$res] = 0;
}
}
print(
"<tr><td class=\"index\" colspan=\"12\">");
print(
"<center>"$pagerbottom ."</center>");
print(
"</td></tr>");
}else{
print(
"<center>Nav nevienas filmas...</center>");
}
print(
"</table></table></table>");

stdfoot();

?>
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum
My Current Demo is here http://demo.btmanager.org/
Reply With Quote