Няколко въпроса свързани с Btit

28 ноември 200718 г.

Предварително се извинявам в случай, че съм сбъркал раздела.

Имам три въпроса(втория е по-скоро молба)

1.Как да махна чертите под думите на тази картинка:

http://img134.imageshack.us/img134/6589/dasdasef4.png

2.Mного спешно ми трябва скрипт за такава търсачка.Търсих къде ли не но без успех:

http://img102.imageshack.us/img102/9915/searchzr5.jpg

3.Как мога да премахна лентата, коята съм заградил на снимката:

http://img252.imageshack.us/img252/2913/sc...t002copyue3.jpg

А ето го и въпросния torrents.php(с модификации е):

<?

require_once ("include/functions.php");

require_once ("include/config.php");


$scriptname = htmlspecialchars($_SERVER["PHP_SELF"]);

$addparam = "";


dbconn();


standardheader('Torrents');


if(!$CURUSER || $CURUSER["view_torrents"]!="yes")

{

	err_msg(ERROR.NOT_AUTHORIZED." ".MNU_TORRENT."!",SORRY."...");

	stdfoot();

	exit();

}


block_begin();



if(isset($_GET["search"]))

{

	$trova = htmlspecialchars(str_replace ("+"," ",$_GET["search"]));

} else {

	$trova = "";

}

?>

<script type="text/javascript">

<!--

var newwindow;

function popdetails(url)

{

  newwindow=window.open(url,'popdetails','height=500,width=500,resizable=yes,scrollbars=yes,status=yes');

  if (window.focus) {newwindow.focus()}

}

function poppeer(url)

{

  newwindow=window.open(url,'poppeers','height=400,width=700,resizable=yes,scrollbars=yes');

  if (window.focus) {newwindow.focus()}

}

// -->

</script>



<br>

<table width="100%">

   <tr class=withoutborder>

	  <br><td class=tdtransparent align=center>

	  <a href=torrents.php?search=&category=48&active=1><img src=/tracker/images/categories/cat/cat_movies_xvid.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=44&active=1><img src=/tracker/images/categories/cat/cat_movies_dvd.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=47&active=1><img src=/tracker/images/categories/cat/cat_movies_svcd.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=56&active=1><img src=/tracker/images/categories/cat/cat_episodes.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=32&active=1><img src=/tracker/images/categories/cat/cat_anime.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=42&active=1><img src=/tracker/images/categories/cat/cat_games_xbox.gif class=withoutborder></a>

		<a href=torrents.php?search=&category=36&active=1><img src=/tracker/images/categories/cat/cat_apps.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=35&active=1><img src=/tracker/images/categories/cat/cat_apps_misc.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=34&active=1><img src=/tracker/images/categories/cat/cat_apps_mac.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=33&active=1><img src=/tracker/images/categories/cat/cat_apps_Linux.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=41&active=1><img src=/tracker/images/categories/cat/cat_games_psp.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=39&active=1><img src=/tracker/images/categories/cat/cat_games_pc.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=40&active=1><img src=/tracker/images/categories/cat/cat_gamesrip.gif class=withoutborder></a>   

	  <a href=torrents.php?search=&category=50&active=1><img src=/tracker/images/categories/cat/cat_music_dan.gif class=withoutborder></a>

	  <a href=torrents.php?search=&category=55&active=1><img src=/tracker/images/categories/cat/cat_music.bmp class=withoutborder></a>

	  <a href=torrents.php?search=&category=57&active=1><img src=/tracker/images/categories/cat/cat_xxx_movies.gif class=withoutborder></a>   

	  <a href=torrents.php?search=&category=38&active=1><img src=/tracker/images/categories/cat/cat_e_book.gif class=withoutborder></a>

   </tr></form>

<TABLE width="100%" >

<TR>

<?


/* Rewrite, part 1: encode "WHERE" statement only. */


// echo "Totale torrents trovati: $count";

// selezione categoria

if ($category[0]>0) {

   $where .= " AND category IN (".implode(",",$category).")"; // . $_GET["category"];

   $addparam.="&category=".implode(";",$category); // . $_GET["category"];

}

global $pagertop, $pagerbottom, $query_select;

// Search

if (isset($_GET["search"])) {

   $testocercato = trim($_GET["search"]);

   $testocercato = explode(" ",$testocercato);

   if ($_GET["search"]!="")

	  $search = "search=" . implode("+",$testocercato);

	for ($k=0; $k < count($testocercato); $k++) {

		$query_select .= " namemap.filename LIKE '%" . mysql_escape_string($testocercato[$k]) . "%'";

		if ($k<count($testocercato)-1)

		   $query_select .= " AND ";

	}

	$where .= " AND " . $query_select;

}


// FINE RICERCA


// conteggio dei torrents...


$res = mysql_query("SELECT COUNT(*) FROM summary LEFT JOIN namemap ON summary.info_hash = namemap.info_hash $where")

		or die(mysql_error());


$row = mysql_fetch_row($res);

$count = $row[0];

if (!isset($search)) $search = "";


if ($count) {

   if ($addparam != "") {

	  if ($search != "")

		 $addparam .= "&" . $search . "&";

	  //else

		  //$addparam .= "&";

   }

   else {

	  if ($search != "")

		 $addparam .=  $search . "&";

	  else

		  $addparam .= ""; //$scriptname . "?";

	  }


	$torrentperpage=max(0,$CURUSER["torrentsperpage"]);

	if ($torrentperpage==0)

		$torrentperpage=($ntorrents==0?15:$ntorrents);


	// getting order

	if (isset($_GET["order"]))

		 $order=htmlspecialchars($_GET["order"]);

	else

		$order="data";


	if (isset($_GET["by"]))

		$by=htmlspecialchars($_GET["by"]);

	else

		$by="DESC";



	list($pagertop, $pagerbottom, $limit) = pager($torrentperpage, $count,  $scriptname."?" . $addparam.(strlen($addparam)>0?"&":"")."order=$order&by=$by&");


// Do the query with the uploader nickname

if ($SHOW_UPLOADER)

	$query = "SELECT summary.info_hash as hash, summary.seeds, summary.leechers, format( summary.finished, 0  ) as finished,  summary.dlbytes as dwned , namemap.filename, namemap.url, namemap.info, namemap.anonymous, summary.speed, UNIX_TIMESTAMP( namemap.data ) as added, categories.image, categories.name as cname, namemap.category as catid, namemap.size, namemap.external, namemap.uploader as upname, users.username as uploader, prefixcolor, suffixcolor FROM summary LEFT JOIN namemap ON summary.info_hash = namemap.info_hash LEFT JOIN categories ON categories.id = namemap.category LEFT JOIN users ON users.id = namemap.uploader LEFT JOIN users_level ON users.id_level=users_level.id $where ORDER BY $order $by $limit";


// Do the query without the uploader nickname

else

	$query = "SELECT summary.info_hash as hash, summary.seeds, summary.leechers, format( summary.finished, 0  ) as finished,  summary.dlbytes as dwned , namemap.filename, namemap.url, namemap.info, summary.speed, UNIX_TIMESTAMP( namemap.data ) as added, categories.image, categories.name as cname, namemap.category as catid, namemap.size, namemap.external, namemap.uploader FROM summary LEFT JOIN namemap ON summary.info_hash = namemap.info_hash LEFT JOIN categories ON categories.id = namemap.category $where ORDER BY $order $by $limit";

// End the queries

   $results = mysql_query($query) or err_msg(ERROR,CANT_DO_QUERY.mysql_error()."<br>".$query);

}


$i = 0;


if ($by=="ASC")

	$mark=" ↑";

else

	$mark=" ↓";


?>

</TR>

<TR>

<TD colspan="2" align="center"> <? echo $pagertop ?></td>

</tr>


<TR>

<TABLE width="100%" class="lista">

<!-- Column Headers  -->

<TR>

<?

?>

<TD width=1% align="left" class="header"><? echo "<a href=\"$scriptname?$addparam".(strlen($addparam)>0?"&":"")."order=cname&by=".($order=="cname" && $by=="ASC"?"DESC":"ASC")."\">".CATEGORY."</a>".($order=="cname"?$mark:""); ?></TD>

<TD width=40% align="left" class="header"><? echo "<a href=\"$scriptname?$addparam".(strlen($addparam)>0?"&":"")."order=filename&by=".($order=="filename" && $by=="ASC"?"DESC":"ASC")."\">".FILE."</a>".($order=="filename"?$mark:""); ?></TD>

<TD align="left" class="header" width="10"><? echo COMMENT; ?></TD>

<TD width=3% align="left" class="header"><? echo RATING; ?></TD>

<?

if (max(0,$CURUSER["WT"])>0)

	print("<TD align=\"center\" class=\"header\">".WT."</TD>");

?>

<TD width=2% align="left" class="header"><? echo DOWN; ?></TD>

<TD width=3% align="left" class="header"><? echo "<a href=\"$scriptname?$addparam".(strlen($addparam)>0?"&":"")."order=data&by=".($order=="data" && $by=="ASC"?"DESC":"ASC")."\">".ADDED."</a>".($order=="data"?$mark:""); ?></TD>

<TD width=3% align="center" class="header"><? echo "<a href=\"$scriptname?$addparam".(strlen($addparam)>0?"&":"")."order=size&by=".($order=="size" && $by=="ASC"?"DESC":"ASC")."\">".SIZE."</a>".($order=="size"?$mark:""); ?></TD>

<?

if ($SHOW_UPLOADER)

	print ("<TD width=4% align=\"center\" class=\"header\">".UPLOADER."</TD>");

?>

<TD width=2% align="center" class="header"><? echo "<a href=\"$scriptname?$addparam".(strlen($addparam)>0?"&":"")."order=seeds&by=".($order=="seeds" && $by=="ASC"?"DESC":"ASC")."\">".SHORT_S."</a>".($order=="seeds"?$mark:""); ?></TD>

<TD width=2% align="center" class="header"><? echo "<a href=\"$scriptname?$addparam".(strlen($addparam)>0?"&":"")."order=leechers&by=".($order=="leechers" && $by=="ASC"?"DESC":"ASC")."\">".SHORT_L."</a>".($order=="leechers"?$mark:""); ?></TD>


</TR>

<TR>


<?

if ($SHOW_UPLOADER && max(0,$CURUSER["WT"])>0)

	echo "<TD colspan=\"17\" class=\"lista\"></TD>";

elseif ($SHOW_UPLOADER || max(0,$CURUSER["WT"])>0)

	echo "<TD colspan=\"16\" class=\"lista\"></TD>";

else

	echo "<TD colspan=\"15\" class=\"lista\"></TD>";

?>

</TR>

<?

if ($count) {

  if (!isset($values[$i % 2])) $writeout = "";

  else $writeout = $values[$i % 2];

  while ($data=mysql_fetch_array($results))

  {

   // search for comments

   $commentres = mysql_query("SELECT COUNT(*) as comments FROM comments WHERE info_hash='" . $data["hash"] . "'");

   $commentdata = mysql_fetch_assoc($commentres);

   echo "<TR>\n";

   echo "\t<td align=\"center\" class=\"lista\"><a href=torrents.php?category=$data[catid]>".image_or_link(($data["image"]==""?"":"images/categories/" . $data["image"]),"",$data["cname"])."</td>";

   if ($GLOBALS["usepopup"])

	   echo "\t<TD align=\"left\" class=\"lista\"><A HREF=\"java script:popdetails('details.php?id=".$data["hash"]."');\" title=\"".VIEW_DETAILS.": ".$data["filename"]."\">".$data["filename"]."</A>".($data["external"]=="no"?"":" (<span style=\"color:red\">EXT</span>)")."</td>";

   else

	   echo "\t<TD align=\"left\" class=\"lista\"><A HREF=\"details.php?id=".$data["hash"]."\" title=\"".VIEW_DETAILS.": ".$data["filename"]."\">".$data["filename"]."</A>".($data["external"]=="no"?"":" (<span style=\"color:red\">EXT</span>)")."</td>";

   if ($commentdata) {

	  if ($commentdata["comments"]>0)

		{

		 if ($GLOBALS["usepopup"])

			  echo "\t<TD align=\"center\" class=\"lista\"><A HREF=\"java script:popdetails('details.php?id=".$data["hash"]."#comments');\" title=\"".VIEW_DETAILS.": ".$data["filename"]."\">" . $commentdata["comments"] . "</A></td>";

		 else

			 echo "\t<TD align=\"center\" class=\"lista\"><A HREF=\"details.php?id=".$data["hash"]."#comments\" title=\"".VIEW_DETAILS.": ".$data["filename"]."\">".$commentdata["comments"]."</A></td>";

		}

	 else

		 echo "\t<TD align=\"center\" class=\"lista\">--</td>";

	   }

   else echo "\t<TD align=\"center\" class=\"lista\">--</td>";


   // Rating

   $vres = mysql_query("SELECT sum(rating) as totrate, count(*) as votes FROM ratings WHERE infohash = '" . $data["hash"] . "'");

   $vrow = @mysql_fetch_array($vres);

   if ($vrow && $vrow["votes"]>=1)

	  {

	  $totrate=round($vrow["totrate"]/$vrow["votes"],1);

	  if ($totrate==5)

		 $totrate="<img src=$STYLEPATH/5.gif title=\"$vrow[votes] ".VOTES_RATING.": $totrate/5.0)\" />";

	  elseif ($totrate>4.4 && $totrate<5)

		 $totrate="<img src=$STYLEPATH/4.5.gif title=\"$vrow[votes] ".VOTES_RATING.": $totrate/5.0)\" />";

	  elseif ($totrate>3.9 && $totrate<4.5)

		 $totrate="<img src=$STYLEPATH/4.gif title=\"$vrow[votes] ".VOTES_RATING.": $totrate/5.0)\" />";

	  elseif ($totrate>3.4 && $totrate<4)

		 $totrate="<img src=$STYLEPATH/3.5.gif title=\"$vrow[votes] ".VOTES_RATING.": $totrate/5.0)\" />";

	  elseif ($totrate>2.9 && $totrate<3.5)

		 $totrate="<img src=$STYLEPATH/3.gif title=\"$vrow[votes] ".VOTES_RATING.": $totrate/5.0)\"  />";

	  elseif ($totrate>2.4 && $totrate<3)

		 $totrate="<img src=$STYLEPATH/2.5.gif title=\"$vrow[votes] ".VOTES_RATING.": $totrate/5.0)\"  />";

	  elseif ($totrate>1.9 && $totrate<2.5)

		 $totrate="<img src=$STYLEPATH/2.gif title=\"$vrow[votes] ".VOTES_RATING.": $totrate/5.0)\"  />";

	  elseif ($totrate>1.4 && $totrate<2)

		 $totrate="<img src=$STYLEPATH/1.5.gif title=\"$vrow[votes] ".VOTES_RATING.": $totrate/5.0)\"  />";

	  else

		 $totrate="<img src=$STYLEPATH/1.gif title=\"$vrow[votes] ".VOTES_RATING.": $totrate/5.0)\"  />";

	  }

   else

	   $totrate=NA;


   echo "\t<TD align=\"center\" class=\"lista\">$totrate</td>\n";

	// end rating


	//waitingtime

	// display only if the curuser have some WT restriction

	if (max(0,$CURUSER["WT"])>0)

		{

		$wait=0;

		$resuser=mysql_query("SELECT * FROM users WHERE id=".$CURUSER["uid"]);

		$rowuser=mysql_fetch_array($resuser);

		$wait=0;

		if (max(0,$rowuser['downloaded'])>0) $ratio=number_format($rowuser['uploaded']/$rowuser['downloaded'],2);

		else $ratio=0.0;

//		$res2 =mysql_query("SELECT * FROM namemap WHERE info_hash='".$data["hash"]."'");

//		$added=mysql_fetch_array($res2);

		$vz = $data["added"];

		$timer = floor((time() - $vz) / 3600);

		if($ratio<1.0 && $rowuser['id']!=$data["uploader"]){

			$wait=$CURUSER["WT"];

		}

		$wait -=$timer;


		if ($wait<=0)$wait=0;

	   if (strlen($data["hash"]) > 0)

			echo "\t<td align=\"center\" class=\"lista\">".($wait>0?$wait." h":"---")."</td>\n"; // WT

	//end waitingtime

	}

	   echo "\t<TD align=\"center\" class=\"lista\"><A HREF=download.php?id=".$data["hash"]."&f=" . urlencode($data["filename"]) . ".torrent>".image_or_link("images/download.gif","","torrent")."</A></TD>\n";


   echo "\t<td align=\"center\" class=\"lista\">" . date("d/m/Y",$data["added"]) . "</td>\n"; // data

   echo "\t<td align=\"center\" class=\"lista\">" . makesize($data["size"]) . "</td>\n";

//Uploaders nick details

if ($SHOW_UPLOADER && $data["anonymous"] == "true")

echo "\t<td align=\"center\" class=\"lista\">" . ANONYMOUS . "</td>\n";

elseif ($SHOW_UPLOADER && $data["anonymous"] == "false")

echo "\t<td align=\"center\" class=\"lista\"><a href=userdetails.php?id=" . $data["upname"] . ">".StripSlashes($data['prefixcolor'].$data["uploader"].$data['suffixcolor'])."</a></td>\n";

//Uploaders nick details

   if ($data["external"]=="no")

	  {

	   if ($GLOBALS["usepopup"])

		 {

		 echo "\t<td align=\"center\" class=\"".linkcolor($data["seeds"])."\"><a href=\"java script:poppeer('peers.php?id=".$data["hash"]."');\" title=\"".PEERS_DETAILS."\">" . $data["seeds"] . "</a></td>\n";

		 echo "\t<td align=\"center\" class=\"".linkcolor($data["leechers"])."\"><a href=\"java script:poppeer('peers.php?id=".$data["hash"]."');\" title=\"".PEERS_DETAILS."\">" .$data["leechers"] . "</a></td>\n";

		 if ($data["finished"]>0)

			echo "\t<td align=\"center\" class=\"lista\"><a href=\"java script:poppeer('torrent_history.php?id=".$data["hash"]."');\" title=\"History - ".$data["filename"]."\">" . $data["finished"] . "</a></td>";

		 else

			 echo "\t<td align=\"center\" class=\"lista\">---</td>";

		 }

	   else

		 {

		 echo "\t<td align=\"center\" class=\"".linkcolor($data["seeds"])."\"><a href=\"peers.php?id=".$data["hash"]."\" title=\"".PEERS_DETAILS."\">" . $data["seeds"] . "</a></td>\n";

		 echo "\t<td align=\"center\" class=\"".linkcolor($data["leechers"])."\"><a href=\"peers.php?id=".$data["hash"]."\" title=\"".PEERS_DETAILS."\">" .$data["leechers"] . "</a></td>\n";


		 }

	  }

  // edit and delete picture/link

  if ($CURUSER["uid"]==$data["uploader"] || $CURUSER["edit_torrents"]=="yes")

	 print("<td class=\"lista\" align=\"center\"><a href=edit.php?info_hash=".$data["hash"]."&returnto=".urlencode("torrents.php").">".image_or_link("$STYLEPATH/edit.gif","",EDIT)."</a></td>");

  else

	  print("<td class=\"lista\" align=\"center\"> </td>");


  if ($CURUSER["uid"]==$data["uploader"] || $CURUSER["delete_torrents"]=="yes")

	 print("<td class=\"lista\" align=\"center\"><a href=delete.php?info_hash=".$data["hash"]."&returnto=".urlencode("torrents.php").">".image_or_link("$STYLEPATH/delete.gif","",DELETE)."</a></td>");

  else

	  print("<td class=\"lista\" align=\"center\"> </td>");


   echo "</TR>\n";

   $i++;

  }

} // if count


if ($i == 0 && $SHOW_UPLOADER)

		 echo "<TR><TD class=\"lista\" colspan=\"17\" align=\"center\">".NO_TORRENTS."</TD></TR>";

elseif ($i == 0 && !$SHOW_UPLOADER) echo "<TR><TD class=\"lista\" colspan=\"16\" align=\"center\">".NO_TORRENTS."</TD></TR>";


?>

</table>



<div TD colspan="2" align="center"> <? echo $pagerbottom ?></td></div>


<?


stdfoot();

?>

Предварително БЛАГОДАРЯ на отзовалите се!!!

Редактирано 28 ноември 200718 г. от SkyLined (преглед на промените)

Цитирай

29 ноември 200718 г.

Автор

Никой ли не може да помогне :offtopic_s: ?

Цитирай

1 декември 200718 г.

Не се занимавай с Btit. Use TBDev .

Цитирай

Добре дошли!

Няколко въпроса свързани с Btit

Featured Replies

Добавете отговор

Разглеждащи това в момента 0

Дарение

Бюлетин

Профил

Навигация

Търсене

Конфигуриране на push известия в браузъра

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)