/**
*
* obacht, die Methode ist nicht sauber
* wenn der Parameter id nicht uebergeben wird ein Array mit
* allen Platformobjekten zurückgegeben die in der DB vorhanden sind :)
* @param Primary Key $id
*/
public function mysqlSelect($id=""){
if(!$this->dbh())
return false;
if (empty($id)){
$sql="SELECT * FROM cms_platform";
$stmt=$this->dbh->prepare($sql);
$stmt->execute();
$platforms=array();
foreach($stmt->fetchAll() as $value){
$p = new pPlatform();
$p->id($value['id']);
$p->name($value['name']);
$p->dbh=$this->dbh();
// echo $value['id'] . " " . $value['name']. "\n";
$platforms[$value['id']]=$p;
}
// print_r($platforms);
return $platforms;
} else {
$sql="SELECT * FROM cms_platform WHERE id=?";
$stmt=$this->dbh->prepare($sql);
$stmt->bindParam(1, $id, PDO::PARAM_INT);
$stmt->execute();
$result=$stmt->fetch(PDO::FETCH_ASSOC);
$this->id($result['id']);
$this->name($result['name']);
}
}//SELECT
$nav->nElements($n);
$nav->itemsPerSite(15);
$nav->targetUrl($sitename);
$nav->additionalUrlParams(array('view'=>$get->view()));
//-----lsExploits--------------------------------------------------------------------------------------------------------------------------------------------------------------
$e= new pExploit();
$e->dbh($dbh);
//$c=new pCategory();
$p=new pPlatform();
$p->dbh($dbh);
$p->mysqlSelect($get->view());
$exploits=$e->mySqlSelectByPlatform($get->view(),$nav->mysqlStart(), $nav->itemsPerSite()); //anpassen
$viewByCategory=$f->getLink($p->name(), $sitename, array("view"=> $p->id()));
echo "<div class=\"exploit-category\">\n";
echo "<h4 class=\"category-title\">$viewByCategory</h4><table>\n";
echo "<tr><th>Date</th><th>DL</th><th>V</th><th>Description</th><th>DL's</th><th>Category</th><th>Author</th></tr>";
$ctr=0;
foreach ($exploits as $e){
$ctr%2==0 ? $modulo="table-gerade" : $modulo="table-ungerade";
$viewExploit=$f->getLink($e->title(), "ViewExploit.php", array("view"=> $e->id()));
$viewByAuthor=$f->getLink($e->autor(), "ViewByAuthor.php", array("view"=>1));
$viewByCategory=$f->getLink($e->loadCategory(), "ViewByCategory.php", array("view"=>$e->category()));
$download="";
if ($e->file()!='')
$download=$f->getLink('⎘', $e->file());
