Warez Script v2 - Seite 3 - Scriptzbase.ORG

Nova · 20.01.2008, 18:56

Du musst das noch mit dem Datum Verbinden

Und dann sotiereren

Mofu · 20.01.2008, 19:02

Zitat:

Zitat von Nova

Du musst das noch mit dem Datum Verbinden

Also noch ein Zusatzkritermium a'la AND WHERE speicherdatum = $datum...
Muss wohl doch mal das Script installieren oder einer müsste mal nen Screen von dem Table der Files machen, dmit ich weiß, wo das Speicherdatum ist...

Gruss
Mofu

Nova · 20.01.2008, 19:09

iss AND WHERE posttime = $datum

Es gibt auch noch sowas wie lastupdatetime

Mofu · 20.01.2008, 19:14

Zitat:

Zitat von Nova

iss AND WHERE posttime = $datum

Es gibt auch noch sowas wie lastupdatetime

Jepp, aber kenn ich den Code des Scripts ???
Neee, also weiß ich nicht, welche Tables er nutzt oder was zur Verfügung steht oder wie die Dats gespeichert werden...
Und meine Glaskugel ist gerade zur Reinigung.

Gruss
Mofu

Nova · 20.01.2008, 19:16

PHP-Code:


			
$sql = mysql_query("SELECT * FROM $files_table WHERE `cat` ='$key' AND `status` ='1' ORDER BY id DESC AND WHERE posttime = $datum;")or die(mysql_error());

Das is der code so ziemlich

Mofu · 20.01.2008, 19:21

Zitat:

Zitat von Nova

PHP-Code:


			
$sql = mysql_query("SELECT * FROM $files_table WHERE `cat` ='$key' AND `status` ='1' ORDER BY id DESC AND WHERE posttime = $datum;")or die(mysql_error());

Das is der code so ziemlich

Wenn du jetzt noch deine Sortieranweisung nach hinten setzt und die $datum-Vari mit Begrenzer setzt is es korrekt.
]

PHP-Code:


			
$sql = mysql_query("SELECT * FROM $files_table WHERE `cat` ='$key' AND `status` ='1' AND posttime = '$datum' ORDER BY id DESC")or die(mysql_error());

Nur muß vorher noch die Vari $datum definiert werden, wenn in der DB die posttime (als Tag 00.00.00) als Timestamp gespeichert ist also
$datum = time();

Wenn allerdings das Postdatum sekundengenau vorliegt, muss in deine Query auch noch eine BETWEEN-Abfrage rein, also Abfrage zwischen Tag-00.00.00 bis Tag-23.59.59.

Dann müsste man also einmal den Startpunkt und den Endpunkt definieren:

$startdatum = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$enddatum = mktime(23, 59, 59, date("m"), date("d"), date("Y"));

und die Query

PHP-Code:


			
$sql = mysql_query("SELECT * FROM $files_table WHERE `cat` ='$key' AND `status` ='1' AND (posttime > '$startdatum' AND posttime < '$enddatum') ORDER BY id DESC")or die(mysql_error());

Gruss
Mofu

PS: Alles ohne Gewähr, denn wie gesagt, Blindflug ohne den Code zu haben :-)

**The Don** · 20.01.2008, 19:29

Hmm also ich hab da ne Fehlermeldung!

Zitat:

mysql_query(): MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE posttime = '' ORDER BY id DESC' at line 1 in /wwwroot/v2/index.php: mysql_query on line 213

Hier mal die Orgina index.php (also nicht meine)

PHP-Code:


			
<?

session_start();

include "includes/var.inc.php";

$section = $_GET['section'];

$username = $_SESSION['username'];
$user_sql = mysql_query("SELECT * FROM $users_table WHERE username='$username'");
$user_info = mysql_fetch_array($user_sql);
$user_id = $user_info['id'];
$user_level = $user_info['level'];
$user_uploads_num = $user_info['uploads'];
$user_uploads_size = $user_info['mbs'];

if(!$username){
   $user_panel_header = "off";
   } else {
   $user_panel_header = "on";
   }


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>DDL-Speed</title>
<link href="style/style.css" rel="stylesheet" type="text/css" />
<link rel="search" type="application/opensearchdescription+xml" title="DDL-Speed.dl.am Suche" href="ddlspeedsuche.xml" />
<script language="javascript1.2">function alert() {}</script>
<script type='text/javascript' src='includes/menu.js'></script>


<noscript><style type="text/css">.qmmc {width:180px !important;height:200px !important;overflow:scroll;}.qmmc div {position:relative !important;visibility:visible !important;}.qmmc a {float:none !important;white-space:normal !important;}</style></noscript>
<script type="text/javascript" src="http://binlayer.de/layer-3537-1.js"></script>
<?     
    switch($section){
                 case "download": echo "<script language=\"Javascript\" type=\"text/javascript\">\n";
                                  include "includes/editor.js";
                                  echo "</script>\n"; ; break;                                                           
                }?>

</head>

<body>
<table class="main" width="954" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="180" class="left_header" align="center" valign="bottom"><img src="images/header_left_panel.png" alt="header_left_panel" border="0" usemap="#Map" /></td>
    <td width="560"><img src="images/header.png" alt="header" width="560" height="126" border="0" usemap="#Map2" /></td>
    <td width="214" class="right_header" valign="bottom">
    
    
      <table width="194" align="left" cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td valign="bottom" class="header_user_panel"><img src="images/user_panel_header_<? echo $user_panel_header; ?>.png" alt="user_panel_header" /></td>
        </tr>
        <tr>
          <td class="user_panel_back">
          
          <? if(!$username){
                
                 echo "<form method=\"post\" action=\"index.php?section=checkuser\">\n";
                 echo "<table width=\"190\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"5\">\n";
                   echo "<tr>\n";
                    echo "<td width=\"31\"><span class=\"small_font\">User</span></td>\n";
                    echo "<td align=\"center\" width=\"159\"><input type=\"text\" name=\"username\" class=\"input_text_small\" /></td>\n";
                  echo "</tr>\n";
                  echo "<tr>\n";
                    echo "<td><span class=\"small_font\">Pass</span></td>\n";
                    echo "<td align=\"center\"><input type=\"password\" name=\"password\" class=\"input_text_small\" /></td>\n";
                  echo "</tr>\n";
                  echo "<tr>\n";                    
                    echo "<td colspan=\"2\"><a href=\"index.php?section=lost_pw\"><img src=\"images/lost_pw.png\" border=\"0\" alt=\"lost_pw\" /></a>&nbsp;&nbsp;&nbsp;<input type=\"image\" value=\"LogIn\" src=\"images/login_button.png\" /></td>\n";
                  echo "</tr>\n";
                 echo "</table>\n";
                 echo "</form>\n";
                 
                 } else {
                 
                 echo "<table width=\"190\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"5\">\n";
                   echo "<tr>\n";
                    echo "<td align=\"center\" width=\"31\"><span class=\"small_font\">Du bist eingeloggt als<br /><b>".$username."</b></span></td>\n";                    
                  echo "</tr>\n";
                  echo "<tr>\n";
                    echo "<td align=\"center\"><span class=\"small_font\">bisherige Uploads: <b>".$user_uploads_num."</b></span></td>\n";                    
                  echo "</tr>\n";
                  echo "<tr>\n";
                    echo "<td align=\"center\"><span class=\"small_font\"><b>".$user_uploads_size." MB</b> insgesamt</span></td>\n";                    
                  echo "</tr>\n";                  
                 echo "</table>\n";
                 
                 }
                 
                 ?>          </td>
        </tr>        
      </table>    </td>
  </tr>
  <tr>
    <td class="left_content_back" valign="top">
    <table width="180" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="180" class="left_content_back"><? include "navi.php" ?></td>
      </tr>            
    </table>
    </td>
    <td rowspan="2" valign="top" class="gerneral_back">    
      <img src="images/sub_header.png" alt="sub_header" />
          
        
    <?
    
// Search
    
    echo "<table width=\"560\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
      echo "<tr>\n";        
        echo "<td valign=\"top\" width=\"21\"><img src=\"images/search_left.png\" alt=\"search_left\" /></td>\n";
        echo "<td width=\"495\" class=\"search_back\">    \n";        
        
        echo "<form method=\"post\" action=\"index.php?section=search_result\">\n";
        echo "<table width=\"495\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
          echo "<tr>\n";
            echo "<td><b>Suche:</b></td>\n";
            echo "<td><input type=\"text\" name=\"expression\" class=\"input_text\" /></td>\n";                  
            echo "<td><input type=\"radio\" value=\"\" name=\"search_cat\" checked=\"checked\" /><span class=\"small_font\"> None</span>
                                <input type=\"radio\" value=\"title\" name=\"search_cat\" /><span class=\"small_font\"> Title</span>
                                <input type=\"radio\" value=\"interpret\" name=\"search_cat\" /><span class=\"small_font\"> Artist</span>
                                <input type=\"radio\" value=\"name\" name=\"search_cat\" /><span class=\"small_font\"> Uploader</span></td>\n";                 
           echo "<td><input type=\"image\" value=\"search\" src=\"images/search_button.png\" /></td>\n"; 
          echo "</tr>\n";  
        echo "</table>\n";
        echo "</form>\n";    
        
        echo "</td>\n";
        echo "<td valign=\"top\" width=\"44\"><img src=\"images/search_right.png\" alt=\"search_right\" /></td>\n";
      echo "</tr>\n";
    echo "</table>\n";
    
// News
    
    switch($section){
                    default: $sql = mysql_query("SELECT * FROM $news_table WHERE `id` ='1'");
                             $row = mysql_fetch_array($sql);
                             
                             $news = $row['text'];
                             $date = $row['date'];
                             $title = $row['title'];
                             
                             echo "<table width=\"544\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
                               echo "<tr>\n";
                                 echo "<td><img src=\"images/news_top.png\" alt=\"news_top\" /></td>\n";
                               echo "</tr>\n";
                               echo "<tr>\n";
                                 echo "<td class=\"news_back\">\n";                                   
                                 
                                   echo "<b>".$title."</b>&nbsp;&nbsp;".$date."\n";
                                   echo "<br />\n";
                                   echo $news;                                 
                                  
                                 echo "</td>\n";
                               echo "</tr>\n";
                               echo "<tr>\n";
                                 echo "<td><img src=\"images/news_footer.png\" alt=\"news_footer\" /></td>\n";
                               echo "</tr>\n";
                             echo "</table>\n";
                             
// Top Releases         
                             
                             echo "<table width=\"544\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
                               echo "<tr>\n";
                                 echo "<td><img src=\"images/top_releases_header.png\" alt=\"news_top\" /></td>\n";
                               echo "</tr>\n";
                               echo "<tr>\n";
                                 echo "<td align=\"center\" class=\"news_back\">\n";                                   
                                 
                                   $sql = mysql_query("SELECT * FROM $highlightes_table ORDER BY changed DESC");
                                   while($row = mysql_fetch_array($sql)){
                                                 
                                          $id = $row['upload_id'];
                                          $img_src = $row['img_src'];
                                          
                                          if(!$img_src){
                                             $img_src = "no_pic.png";
                                             } 
                                        
                                          echo "<a href=\"index.php?section=download&amp;id=$id\"><img src=\"images/highlightes/$img_src\" border=\"0\" height=\"98\" width=\"70\" alt=\"pic\" /></a> ";
                                          unset($img_src);
                                        }                                  
                                 echo "</td>\n";
                               echo "</tr>\n";
                               echo "<tr>\n";
                                 echo "<td><img src=\"images/news_footer.png\" alt=\"news_footer\" /></td>\n";
                               echo "</tr>\n";
                             echo "</table>\n";
                             
// Last Uploads
                             
                             $cats = array(1,4,5,2,6,3);
                             
                             foreach($cats as $key){
                             
                                     $last_sql = mysql_query("SELECT * FROM $files_table WHERE `cat` ='$key' AND `status` ='1' ORDER BY id DESC LIMIT 1")or die(mysql_error());    
                                     $last_row = mysql_fetch_array($last_sql);
                                     $last = $last_row['posttime'];
                                     
                                     $time = date("H:i", $last);
                                     $date = date("d.m.y", $last);
                                     
                                     $last_update = "$date - $time Uhr";
                             
                                     $sql = mysql_query("SELECT * FROM $files_table WHERE `cat` ='$key' AND `status` ='1' ORDER BY id DESC LIMIT 10")or die(mysql_error());    
                                     
                                     switch($key){
                                            case "1": $echo = "Movies"; $icon = "movies.png"; $width = 300;  break;
                                            case "2": $echo = "Apps"; $icon = "apps.png"; $width = 300;  break;
                                            case "3": $echo = "Games"; $icon = "games.png"; $width = 300;  break;
                                            case "4": $echo = "Music-Files"; $icon = "music.png"; $width = 150;  break;
                                            case "5": $echo = "XXX-Files"; $icon = "xxx.png"; $width = 300;  break;
                                            case "6": $echo = "Serien"; $icon = "movies.png"; $width = 300; break;
                                            }
                                            
                                    $genre_status = mysql_query("SELECT * FROM $genre_status_table WHERE `id` ='$key'");
                                    $genre_status = mysql_fetch_array($genre_status);
                                    $genre_status = $genre_status['status'];
                                            
                                     echo "<table width=\"560\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
                                       echo "<tr>\n";
                                         echo "<td width=\"21\" rowspan=\"2\"><img src=\"images/left_table_top.png\" alt=\"left_table_top\" width=\"21\" height=\"58\" /></td>\n";
                                         echo "<td width=\"501\" class=\"table_top_back\"><p class=\"heading\">Die letzten 10 ".$echo."</p></td>\n";
                                         echo "<td width=\"38\" rowspan=\"2\"><img src=\"images/right_table_top.png\" alt=\"right_Table_top\" width=\"38\" height=\"58\" /></td>\n";
                                       echo "</tr>\n";
                                       echo "<tr>\n";
                                         echo "<td class=\"table_middle_back\"><span class=\"small_heading\">Letztes Update: ".$last_update."</span></td>\n";
                                       echo "</tr>\n";
                                       echo "<tr>\n";
                                         echo "<td colspan=\"3\" align=\"center\" class=\"table_back\">\n";    
                                         
                                          
                                          echo "<table width=\"500\" align=\"center\" cellspacing=\"0\" cellpadding=\"3\">\n";
                                           echo "<tr>\n";
                                             echo "<td align=\"center\" width=\"".$width."\"><b>Title</b></td>\n";
                                             if($key == 4){
                                             echo "<td align=\"center\" width=\"150\"><b>Interpret</b></td>\n";
                                             }
                                             if($genre_status == 0){                                                     
                                                 echo "<td align=\"center\" width=\"100\"><b>Kategorie</b></td>\n";
                                                 } else {
                                                 echo "<td align=\"center\" width=\"100\"><b>Genre</b></td>\n";
                                                 }
                                             echo "<td align=\"center\" width=\"100\" ><b>Size</b></td>\n";                                                     
                                           echo "</tr>\n";
                                          
                                          while($row = mysql_fetch_array($sql)){
                                          
                                                
                                                $genre = $row['genre'];
                                                $genre = mysql_query("SELECT * FROM $genres_table WHERE `id` ='$genre'");
                                                $genre = mysql_fetch_array($genre);
                                                $genre = $genre['name'];
                                                
                                                $subcat = $row['subcat_id'];
                                                $subcat = mysql_query("SELECT * FROM $subcats_table WHERE `id` ='$subcat'");
                                                $subcat = mysql_fetch_array($subcat);
                                                $subcat = $subcat['name'];    
                                                
                                                $interpret = $row['interpret'];
                                          
                                                             echo "<tr>\n";
                                                               echo "<td align=\"left\" width=\"300\"><a href=\"index.php?section=download&amp;cat=".$row['cat'].";&amp;id=".$row['id']."\">";
                                                               
                                                               if (strlen($row["title"]) >

20.01.2008, 18:56	#51 (permalink)
Nova Spam-Hippie Registriert seit: 16.12.2007 Ort: In a piece of a world Beiträge: 703 Abgegebene Danke: 26 Erhielt 66 Danke für 27 Beiträge	Du musst das noch mit dem Datum Verbinden Und dann sotiereren

20.01.2008, 19:09	#53 (permalink)
Nova Spam-Hippie Registriert seit: 16.12.2007 Ort: In a piece of a world Beiträge: 703 Abgegebene Danke: 26 Erhielt 66 Danke für 27 Beiträge	iss AND WHERE posttime = $datum Es gibt auch noch sowas wie lastupdatetime

20.01.2008, 19:16	#55 (permalink)
Nova Spam-Hippie Registriert seit: 16.12.2007 Ort: In a piece of a world Beiträge: 703 Abgegebene Danke: 26 Erhielt 66 Danke für 27 Beiträge	PHP-Code: $sql = mysql_query("SELECT * FROM $files_table WHERE `cat` ='$key' AND `status` ='1' ORDER BY id DESC AND WHERE posttime = $datum;")or die(mysql_error()); Das is der code so ziemlich