Module

SMFinder_Query_getAllUID

Keine Erläuterungen gefunden.

<?php /* published under GPL www.gnu.org/licenses/gpl.html */
function SMFinder_Query_getAllUID($element,$searchString,$field){
  if (empty($field)){$field="status";}
  switch($element){
  case "address":
    $dbtabelle=$GLOBALS['DBTaddress'];
    break;
  case "event":
    $dbtabelle=$GLOBALS['DBTevent'];
    break;
  case "link":
    $dbtabelle=$GLOBALS['DBTlink'];
    break;
  }
  $dblink=mysql_connect($GLOBALS['dbserver'],$GLOBALS['dbuser'],$GLOBALS['dbpasswd']);
  mysql_select_db($GLOBALS['dbname'],$dblink);


  if ($field=="lastmod" OR $field=="lastchecked"){
    $anfrage="select * from `".$dbtabelle."` where `".$field."`>='".#
      $searchString."' order by `UID`";
  }elseif($searchString=="!delete"){
    #$anfrage="select * from `".$dbtabelle."` where `status` NO LIKE 'delete' order by `".$field."` asc";
    $anfrage="select * from `".$dbtabelle."` where `status` !=0 order by `".$field."` asc";
  }elseif(empty($searchString)){
    $anfrage="select * from `".$dbtabelle."` order by `".$field."` asc";
  }else{
    if ($searchString=="bookmark"){
      $anfrage="select * from `".$dbtabelle."` where `refUID` LIKE '".#
	$searchString."' order by `URL` asc";
    }else{
      $anfrage="select * from `".$dbtabelle."` where `".$field.#
	"` LIKE '%".$searchString."%' order by `".$field."` asc";
    }
  }
  if($GLOBALS['debug']){
    echo "<b>SMFinder_Query_getAllUID.php</b> ".$anfrage."<br>";
  }
  $UIDs=array();
  $stati=array();
  $names=array();
  $statusClaim=$_GET['status'];
  if ($ergebnis=mysql_query($anfrage)){
    while($SqlEntry=mysql_fetch_row($ergebnis)){
      switch($element){
      case "address":
	array_push($UIDs, $SqlEntry[2]);
	array_push($stati, $SqlEntry[1]);
	array_push($names, $SqlEntry[5]);
	break;
      case "event":
	array_push($UIDs, $SqlEntry[2]);
	array_push($stati, $SqlEntry[1]);
	if ($field=="organizer" AND empty($searchString)){
	  array_push($names, $SqlEntry[18]); #organizer
	}elseif ($field=="location" AND empty($searchString)){
	  array_push($names, $SqlEntry[17]); #location
	}else{
	  array_push($names, $SqlEntry[5]);  #summary
	}
	break;
      case "link":
	array_push($UIDs,  $SqlEntry[4]);
	array_push($stati, $SqlEntry[1]);
	array_push($names, $SqlEntry[5]);
	break;
      }
    }
  }else{
    echo "Fehler=".mysql_error()."<br>";
  }
  mysql_close($dblink);

  /* If we do not look for events of a specific organizer,
   but for a list of all organizers, we would like the 
   organizer names instead of the event titles. 
   And we need each organizer once! */
  if (($field=="organizer" OR $field=="location") AND empty($searchString)){
    include('SMFinder_Query_readAddress.php');
    for ($i=0;$i<count($names);$i++){
      if (!empty($names[$i])){
	$address=SMFinder_Query_readAddress($names[$i]);
      }
      $UIDsTmp[$i]=$names[$i];      #organizerID
      $namesTmp[$i]=$address['fn']; #organizerName
      $statiTmp[$i]=$stati[$i];
    } #i
    $UIDs="";
    $stati="";
    $names="";
    $ii=-1;
    $lastUID="";
    for ($i=0;$i<count($namesTmp);$i++){
      if ($UIDsTmp[$i]!=$lastUID  AND #
	  !empty($UIDsTmp[$i])    AND #
	  $statiTmp[$i]!="delete" AND #
	  $statiTmp[$i]!="inactive"){
	#echo "treffer: ".$UIDsTmp[$i]."<br>";
	$ii++;
	$UIDs[$ii]=$UIDsTmp[$i];
	$stati[$ii]=$statiTmp[$i];
	$names[$ii]=$namesTmp[$i];
	$lastUID=$UIDsTmp[$i];
      }
    } #i
  }
  #print_r($UIDs);echo "<p>";
  #print_r($stati);echo "<p>";
  #print_r($names);echo "<p>";

  return array($UIDs,$stati,$names);
}
?>

Index

Für die Funktionalität des SM-Finders sind viele kleine Tools notwendig. Alle Funktionen beginnen mit SMFinder_ um deren Ursprung zu kennzeichnen. Dem schließt sich die Funktionsgruppe, z.B. Geo_ an, gefolgt vom eigentlichen Namen, der die Aufgabe der Funktion widerspiegeln soll, z.B. PLZ2DB.

Der gesamte Sourcecode darf gemäß GNU General Public License weiterverbreitet werden.

Datenbanken

• Eintrag erstellen, ändern, löschen
• Hilfe, FAQ
• Datenabgleich