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; }
$result0 = mysql_query("SELECT * FROM {$table1} WHERE id = '{$uid}' AND aktiv = '1'"); $username = mysql_result($result0, isset($i0), 'username'); $language = mysql_result($result0, isset($i0), 'language'); if (array_key_exists('pic_id', $_GET)) { $pic_id = $_GET['pic_id']; } if (array_key_exists('kat_id', $_GET)) { $kat_id = $_GET['kat_id']; } if (array_key_exists('mod', $_GET)) { $mod = $_GET['mod']; } if (array_key_exists('s_m', $_GET)) { $s_m = $_GET['s_m']; } $stat = createStatement($bewertung); //echo $stat; $base_file = 'recherche2'; switch ($mod) { case 'zeit': include $sr . '/bin/share/functions/ajax_functions.php'; echo "<BODY onLoad=\"getTimeTreeview('0','zeit','J','{$bewertung}')\">"; break; case 'kat': include $sr . '/bin/share/functions/ajax_functions.php'; echo "<BODY onLoad=\"getKatTreeview('0','0','kat','{$bewertung}','recherche','recherche2')\">"; break; } echo "\n\t<CENTER>\n\t<DIV Class='klein'>\n\t<div class='page' id='page'>\n\t\n\t\t<div class='head' id='head'>\n\t\t\tpic2base :: Datensatz-Recherche <span class='klein'>(User: {$username}; eingestellte Bewertung: " . showBewertung($bewertung) . ")</span>\n\t\t</div>\n\t\t\n\t\t<div class='navi' id='navi'>\n\t\t\t<div class='menucontainer'>"; createNavi2_1($uid); echo "</div>\n\t\t</div>";
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; }