Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\apachefriends\xampp\htdocs\mpl\newsletter-521\newsletter\admin\u_edit.php on line 21

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\apachefriends\xampp\htdocs\mpl\newsletter-521\newsletter\admin\u_edit.php on line 27

<?php

if($HTTP_SESSION_VARS[loggedin]) {
include($cfg[includeDir]."/headers/user_edit.php");
include($other."/mysql.php");

if(!isset($seite)) 			$seite=0;
if(!isset($orderclause1))	$orderclause1="ORDER BY email";
if(!isset($orderclause2))	$orderclause2=" ASC";
if(!isset($whereclause))	$whereclause="";

$start=(int)$seite*20;

$query=stripslashes("SELECT * FROM ".$cfg[dbpre]."user $whereclause $orderclause1$orderclause2 LIMIT $start, 20");
$dbres=@mysql_query($query) or error(mysql_error());
$dbres2=@mysql_query(stripslashes("SELECT count(id) FROM ".$cfg[dbpre]."user $whereclause $orderclause1$orderclause2"));

$dbres2=mysql_fetch_array($dbres2);
$anzahl=$dbres2[0];
@mysql_close($conn);
#echo $query


if(mysql_num_rows($dbres) < 1)
{
  echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\">
			  <tr><td></td></tr>
			  <tr><td><h3>$lang[notposs]</h3></td></tr>
			  <tr><td></td></tr>
			 <tr><td>$lang[nousers]</td></tr>
			 </table>";
}
else
{

  
  
  // liest die Anzahl der Abonenten als Zahl aus
include($other."/mysql.php");
$dbusar=@mysql_query("SELECT count(id) AS num FROM ".$cfg[dbpre]."user WHERE acc='y'") or error(mysql_error());
$usars=@mysql_fetch_array($dbusar);


  // Ausgabe ab hier

if($error=="") {

?>



						<table width="100%" border="0" cellspacing="2" cellpadding="2" align="center" class="codebox" style="-moz-border-radius: .3em .3em .3em .3em;">
							 <form action="<?=$PHP_SELF."?".SID."&s=u_edit&seite=$seite"?>" method="post">
						    <tr>
						      <td class="inside_codebox"><select name="whereclause">
						          <option class="search" value=""><?=$lang[usarsorta]?></option>
						          <option class="search" value="WHERE acc='y'"><?=$lang[usarsortb]?></option>
						          <option class="search" value="WHERE acc='n'"><?=$lang[usarsortc]?></option>
						        </select></td>
						      <td class="inside_codebox"><select class="search" name="orderclause1">
						          <option class="search" value="ORDER BY name"><?=$lang[usarsortd]?></option>
						          <option class="search" value="ORDER BY email"><?=$lang[usarsorte]?></option>
						        </select></td>
						      <td class="inside_codebox"><select class="search" name="orderclause2">
						          <option class="search" value="ASC"><?=$lang[usarsortf]?></option>
						          <option class="search" value="DESC"><?=$lang[usarsortg]?></option>
						        </select></td>
						
						      <td class="inside_codebox"><input name="submit" type="submit"  class="sbutt" value="Go"></td>
						
							  </tr></form>
							  </table>

    <?echo " 
	 
	
			<script language=\"JavaScript\" type=\"text/javascript\">
				<!--
				function ckeck_uncheck_all() {
				        var frm = document.editnews;
				        for (var i=0;i<frm.elements.length;i++) {
				                var elmnt = frm.elements[i];
				                if (elmnt.type==\"checkbox\") {
				                        if(frm.master_box.checked == true){ elmnt.checked=true; }
				            else{ elmnt.checked=false; }
				                }
				        }
				        if(frm.master_box.checked == true){ frm.master_box.checked = true; }
				    else{ frm.master_box.checked = false; }
				}
				-->
			</script>
				   <table align=\"right\">
	   <tr><td>$lang[site]: </td>";
       for($i=0;$i<ceil($anzahl/20);$i++) {
         if($seite == $i) {
            $ausgabe=$i+1;
            echo " <td class=\"alert\"><u>$ausgabe</u></td>";
			echo " <td>|</td>";
         } else {
            $ausgabe=$i+1;
            echo " <td><a href=\"admincenter.php?".SID."&s=u_edit&seite=$i&orderclause1=".stripslashes($orderclause1)."&orderclause2=".stripslashes($orderclause2)."&whereclause=".stripslashes($whereclause)."\">$ausgabe</a></td>";
			echo " <td>|</td>";
			}
       }
	   echo"</tr></table>";
	echo"$lang[abonents] $usars[num]


	<table width=\"630\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\">
	<form action=\"'.$PHP_SELF.'?'.SID.'&s=u_edit2&act=del\" method=\"post\" name=\"editnews\" onSubmit=\"return confirm('$lang[usarskill]')\">
	 <tr>
	   <td width=\"266\" class=\"rowhead\">$lang[umail]</td>
	   <td width=\"262\" class=\"rowhead\">$lang[uname]</td>
	   <td width=\"50\" class=\"rowhead\" align=\"center\" >$lang[ustatus]</td>
	   <td colspan=\"2\" class=\"rowhead\">$lang[options]</td>
	
	 </tr>";
	   while($row=mysql_fetch_array($dbres,MYSQL_ASSOC)) {

            $output="<font class=\"mini\">All</font>";
            if($row[cat] != "all") {
                  $cat=explode("|",$row[cat]);
                  $output="";
                  for($i=1;$i<count($cat)-1;$i++) {
                        $output.="<font class=\"mini\">".$categories["id".$cat[$i]][name].", </font>";
                  }
				  
            }
            
  $acc=($row[acc]=="y")? "$lang[aktiv]":"<font class=alert>$lang[inaktiv]</font>";
	   

    echo "
		<tr>
			<td class=\"row\" valign=\"top\">$row[email]</td>
			<td class=\"row\" valign=\"top\">$row[name]</td>
			<td class=\"row\" valign=\"top\" align=\"center\">$acc</td>
			<td width=\"26\" valign=\"middle\" align=\"center\"><a href=\"".$PHP_SELF."?".SID."&s=u_edit2&act=chg&id=".$row[id]."\"><img src=\"../img/edit.gif\" width=\"22\" height=\"16\" title=\"$lang[editthis]: $row[email] \" border=\"0\"></a></td>
			<td width=\"26\" valign=\"top\" align=\"right\"><input class=\"box\"type=\"checkbox\" title=\"$lang[killthis]: $row[email] \" name=\"deli[]\" value=\"$row[id]\"></td>
		</tr>";  }
       echo "<tr>
		   <td colspan=2>
<input type=\"submit\"  class=\"butt\" value=\"$lang[run]\"></td>
		   <td align=\"right\" colspan=\"2\">$lang[markall]</td>
		   <td align=\"right\"><input style=\"border: 0px; background:transparent;\" type=checkbox class=\"box\" name=master_box title=\"$lang[markall2]\" onclick=\"javascript:ckeck_uncheck_all()\"></td>
	   	   </tr>
		   </form>
	   </table>
	   

	   <table align=\"right\">
	   <tr><td>$lang[site]: </td>";
       for($i=0;$i<ceil($anzahl/20);$i++) {
         if($seite == $i) {
            $ausgabe=$i+1;
            echo " <td class=\"alert\"><u>$ausgabe</u></td>";
			echo " <td>|</td>";
         } else {
            $ausgabe=$i+1;
            echo " <td><a href=\"admincenter.php?".SID."&s=u_edit&seite=$i&orderclause1=".stripslashes($orderclause1)."&orderclause2=".stripslashes($orderclause2)."&whereclause=".stripslashes($whereclause)."\">$ausgabe</a></td>";
			echo " <td>|</td>";
         }
       }
	   echo"</tr></table>";
       mysql_free_result($dbres);
} else {
      echo $lang[follErr].": ".$error;
		}
	}

} else {
  echo "$lang[noenter]";
}
?>