1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29: 
30: 
31: 
32: 
33: 
34: 
35: 
36: 
37: 
38: 
39: 
40: 
41: 
42: 
43: 
44: 
45:

/* ### Foren ### */
echo "
";

// Kategorien queryn
$db->mysqlquery("SELECT catid,title FROM `1_cats`");

// Kategorien intialisieren
$main_cats = "";

while($db->next_record())
{

$catid=$db->record['catid'];
$cattitel=$db->record['title'];

// Foren queryn
$db2->mysqlquery("SELECT boardid,title,beschreibung,moderatoren FROM `1_boards` WHERE catid=\"$catid\" ORDER BY sort ASC");

// Foren intialisieren
$main_foren = "";

while($db2->next_record())
{

$boardid=$db2->record['boardid'];
$forumtitel=$db2->record['title'];
$beschreibung = $db2->record['beschreibung'];
$moderatoren = $db2->record['moderatoren'];

$db3->mysqlquery("SELECT id FROM `1_threads` WHERE boardid=\"$boardid\"");   
$themen=$db3->num_rows();

$db3->mysqlquery("SELECT id FROM `1_answers` WHERE boardid=\"$boardid\"");   
$beitraege=$db3->num_rows();

eval ("\$main_foren .= \"".addslashes(gettemplate("main_foren"))."\";");
}
eval ("\$main_cats .= \"".addslashes(gettemplate("main_cats"))."\";");
}

eval ("\$main_uebersichtn = \"".addslashes(gettemplate("main_uebersichtn"))."\";");
eval ("\$main = \"".addslashes(gettemplate("main"))."\";");
echo $main;

echo "
";

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29: 
30: 
31: 
32: 
33: 
34: 
35: 
36: 
37: 
38: 
39: 
40: 
41: 
42: 
43: 
44: 
45: 
46: 
47: 
48: 
49: 
50: 
51: 
52: 
53: 
54: 
55: 
56: 
57: 
58: 
59: 
60:

link_id=@mysql_connect($this->datenbankhost, $this->datenbankuser, $this->datenbankpass);
mysql_query(sprintf("use %s",$this->datenbankdbna),$this->link_id);
}

function mysqlquery($query)
{
$this->connection();
$this->query_id = mysql_query($query,$this->link_id);
$this->row = 0;
return $this->query;
}

function next_record()  
{  
$this->record = mysql_fetch_array($this->query_id);  
$this->row   += 1;  
$this->errno = mysql_errno();  
$this->error = mysql_error();  
$stat = is_array($this->record);  
if (!$stat)  
{  
mysql_free_result($this->query_id);  
$this->query_id = 0;  
}  
return $stat;  
}

function num_rows() 
{ 
return mysql_num_rows($this->query_id); 
}

function close()
{
mysql_close($this->link_id);
}

}

$db = new db_mysql;
$db2 = new db_mysql;
$db3 = new db_mysql;
?>

1:

var $datenbankpass = "";   // Datenbankpasswort