function getNumberOfPictures($kat_id, $modus, $bewertung, $treestatus)
{
unset($username);
if ($_COOKIE['login']) {
list($c_username) = preg_split('#,#', $_COOKIE['login']);
}
//echo "Modus: ".$modus.", User: "******"<BR>";
//echo $treestatus;
include '../../share/global_config.php';
include $sr . '/bin/share/db_connect1.php';
$kat_arr[] = $kat_id;
//Kategorie-Nummern-Container
$result0 = mysql_query("SELECT * FROM {$table1} WHERE username = '******'");
$id = mysql_result($result0, isset($i0), 'id');
$result1 = mysql_query("SELECT * FROM {$table4} WHERE parent = '{$kat_id}'");
$num1 = mysql_num_rows($result1);
if ($num1 > 0) {
for ($i1 = 0; $i1 < $num1; $i1++) {
$kat_id = mysql_result($result1, $i1, 'kat_id');
//$kat_arr[] = $kat_id;
getAllChildIds($kat_id);
}
}
$anz = count($kat_arr);
//echo "Elemente im Kat-Array: ".$anz."<BR>";
$nop = '0';
//number of pictures :-)
foreach ($kat_arr as $kat_nr) {
if ($modus == 'edit') {
//fuer die Oberkategorie (mit Minus) werden nur diejenigen Bilder angezeigt,
//die keiner weiteren Unterkategorie zugeordnert sind.
//Fuer Unterkategorien (mit Plus) werden die Bilder in dieser und aller weiteren Unterkategorien angezeigt
//abhaengig von der Berechtigung wird die Anzahl der Bilder ermittelt:
if (hasPermission($c_username, 'editallpics')) {
//Sonderfall Neuzugaenge: hier wird nur die Anz. der noch nicht kategorisierten Bilder ermittelt:
$result3 = mysql_query("SELECT * FROM {$table4} WHERE kat_id = '{$kat_nr}'");
$parent = mysql_result($result3, isset($i3), 'parent');
if ($parent == '0') {
//es handelt sich um die oberste Kategorie (Neuzugenge)
$result2 = mysql_query("SELECT * \n\t\t\t\t\tFROM {$table2} \n\t\t\t\t\tWHERE has_kat = '0'");
} else {
if ($treestatus == 'plus') {
$result2 = mysql_query("SELECT {$table10}.pic_id, {$table10}.kat_id, {$table2}.Owner, {$table2}.pic_id \n\t\t\t\t\t\tFROM {$table10} INNER JOIN {$table2} \n\t\t\t\t\t\tON {$table10}.kat_id = '{$kat_nr}' \n\t\t\t\t\t\tAND {$table10}.pic_id = {$table2}.pic_id");
} elseif ($treestatus == 'minus') {
$result2 = mysql_query("SELECT {$table10}.pic_id, {$table10}.kat_id FROM {$table10}\n\t\t\t\t\t\tWHERE ({$table10}.kat_id = '{$kat_nr}') \n\t\t\t\t\t\tAND ({$table10}.pic_id <> ALL (SELECT pic_id \n\t\t\t\t\t\tFROM {$table10} LEFT JOIN {$table4} ON ({$table10}.kat_id = {$table4}.kat_id) \n\t\t\t\t\t\tWHERE parent = '{$kat_nr}'))");
echo mysql_error();
$num2 = mysql_num_rows($result2);
}
}
} elseif (hasPermission($c_username, 'editmypics')) {
//Sonderfall Neuzugaenge: hier wird nur die Anz. der noch nicht kategorisierten Bilder ermittelt:
$result3 = mysql_query("SELECT * FROM {$table4} WHERE kat_id = '{$kat_nr}'");
$parent = mysql_result($result3, isset($i3), 'parent');
if ($parent == '0') {
//es handelt sich um die oberste Kategorie (Neuzugenge)
$result2 = mysql_query("SELECT * \n\t\t\t\t\tFROM {$table2} \n\t\t\t\t\tWHERE has_kat = '0'\n\t\t\t\t\tAND Owner = '{$id}'");
} else {
if ($treestatus == 'plus') {
$result2 = mysql_query("SELECT {$table10}.pic_id, {$table10}.kat_id, {$table2}.Owner, {$table2}.pic_id \n\t\t\t\t\t\tFROM {$table10} INNER JOIN {$table2} \n\t\t\t\t\t\tON {$table10}.kat_id = '{$kat_nr}' \n\t\t\t\t\t\tAND {$table10}.pic_id = {$table2}.pic_id \n\t\t\t\t\t\tAND {$table2}.Owner = '{$id}'");
} elseif ($treestatus == 'minus') {
$result2 = mysql_query("SELECT {$table10}.pic_id, {$table10}.kat_id, {$table2}.Owner, {$table2}.pic_id \n\t\t\t\t\t\tFROM {$table10} INNER JOIN {$table2}\n\t\t\t\t\t\tON ({$table10}.kat_id = '{$kat_nr}')\n\t\t\t\t\t\tAND {$table10}.pic_id = {$table2}.pic_id \n\t\t\t\t\t\tAND {$table2}.Owner = '{$id}' \n\t\t\t\t\t\tAND ({$table10}.pic_id <> ALL (SELECT pic_id \n\t\t\t\t\t\tFROM {$table10} LEFT JOIN {$table4} ON ({$table10}.kat_id = {$table4}.kat_id) WHERE parent = '{$kat_nr}'))");
}
}
}
echo mysql_error();
$nop = mysql_num_rows($result2);
} elseif ($modus == 'recherche') {
$stat = createStatement($bewertung);
if ($bewertung !== '6') {
//Sonderfall Neuzugaenge: hier wird nur die Anz. der noch nicht kategorisierten Bilder ermittelt:
$result3 = mysql_query("SELECT * FROM {$table4} WHERE kat_id = '{$kat_nr}'");
$parent = mysql_result($result3, isset($i3), 'parent');
if ($parent == '0') {
//es handelt sich um die oberste Kategorie (Neuzugenge)
$result2 = mysql_query("SELECT * \n\t\t\t\t\tFROM {$table2} \n\t\t\t\t\tWHERE has_kat = '0' \n\t\t\t\t\tAND {$stat}");
//echo mysql_error();
//$nop = mysql_num_rows($result2);
} else {
$result2 = mysql_query("SELECT {$table10}.pic_id, {$table10}.kat_id, {$table2}.Owner, {$table2}.pic_id \n\t\t\t\t\tFROM {$table10} INNER JOIN {$table2} \n\t\t\t\t\tON ({$table10}.kat_id = '{$kat_nr}' \n\t\t\t\t\tAND {$table10}.pic_id = {$table2}.pic_id \n\t\t\t\t\tAND {$stat})");
//echo mysql_error();
//$nop = mysql_num_rows($result2);
}
} else {
//Sonderfall Neuzugaenge: hier wird nur die Anz. der noch nicht kategorisierten Bilder ermittelt:
$result3 = mysql_query("SELECT * FROM {$table4} WHERE kat_id = '{$kat_nr}'");
$parent = mysql_result($result3, isset($i3), 'parent');
if ($parent == '0') {
//es handelt sich um die oberste Kategorie (Neuzugenge)
$result2 = mysql_query("SELECT * \n\t\t\t\t\tFROM {$table2} \n\t\t\t\t\tWHERE has_kat = '0' ");
//echo mysql_error();
//$nop = mysql_num_rows($result2);
} else {
$result2 = mysql_query("SELECT * FROM {$table10} WHERE kat_id = '{$kat_nr}'");
//$num2 = mysql_num_rows($result2);
//$nop = $nop + $num2;
//$nop = mysql_num_rows($result2);
}
}
echo mysql_error();
$nop = mysql_num_rows($result2);
}
}
return $nop;
}
function getNumberOfPictures($kat_id, $modus, $bewertung)
{
unset($username);
if ($_COOKIE['login']) {
list($c_username) = preg_split('#,#', $_COOKIE['login']);
}
//echo "Modus: ".$modus."User: "******"<BR>";
include '../../share/global_config.php';
include $sr . '/bin/share/db_connect1.php';
$kat_arr[] = $kat_id;
//Kategorie-Nummern-Container
$result0 = mysql_query("SELECT * FROM {$table1} WHERE username = '******'");
$id = mysql_result($result0, isset($i0), 'id');
$result1 = mysql_query("SELECT * FROM {$table4} WHERE parent = '{$kat_id}'");
$num1 = mysql_num_rows($result1);
if ($num1 > 0) {
for ($i1 = 0; $i1 < $num1; $i1++) {
$kat_id = mysql_result($result1, $i1, 'kat_id');
//$kat_arr[] = $kat_id;
getAllChildIds($kat_id);
}
}
$anz = count($kat_arr);
$nop = '0';
//number of pictures :-)
foreach ($kat_arr as $kat_nr) {
if ($modus == 'edit') {
$result2 = mysql_query("SELECT {$table10}.pic_id, {$table10}.kat_id, {$table2}.Owner, {$table2}.pic_id FROM {$table10} INNER JOIN {$table2} ON {$table10}.kat_id = '{$kat_nr}' AND {$table10}.pic_id = {$table2}.pic_id AND {$table2}.Owner = '{$id}'");
echo mysql_error();
$nop = mysql_num_rows($result2);
} else {
$stat = createStatement($bewertung);
if ($bewertung !== '6') {
$result2 = mysql_query("SELECT {$table10}.pic_id, {$table10}.kat_id, {$table2}.Owner, {$table2}.pic_id FROM {$table10} INNER JOIN {$table2} ON ({$table10}.kat_id = '{$kat_nr}' AND {$table10}.pic_id = {$table2}.pic_id AND {$stat})");
echo mysql_error();
$nop = mysql_num_rows($result2);
} else {
$result2 = mysql_query("SELECT * FROM {$table10} WHERE kat_id = '{$kat_nr}'");
$num2 = mysql_num_rows($result2);
$nop = $nop + $num2;
}
}
}
return $nop;
}
