function getAdrID($group_id = 0, $search = array()) { //liefert NUR die IDs zurueck als Array!!! Beoetigt fuer die Formulare //keine suche ueber f0_9 !!!!! da wir speicher sparen wollen... nur ids! //bzw neue query testen! $ADRID = array(); $DB = new tm_DB(); $Query = "\n\t\t\t\t\t\tSELECT " . TM_TABLE_ADR . ".id\n\t\t\t\t\t\tFROM " . TM_TABLE_ADR . "\n\t\t\t\t\t"; if (isset($search['group']) && !empty($search['group'])) { $group_id = checkset_int($search['group']); } if (check_dbid($group_id)) { $Query .= "LEFT JOIN " . TM_TABLE_ADR_GRP_REF . " ON " . TM_TABLE_ADR . ".id = " . TM_TABLE_ADR_GRP_REF . ".adr_id"; } $Query .= " WHERE " . TM_TABLE_ADR . ".siteid='" . TM_SITEID . "'"; if (check_dbid($group_id)) { $Query .= " AND " . TM_TABLE_ADR_GRP_REF . ".siteid='" . TM_SITEID . "'\n\t\t\t\t\t\t AND " . TM_TABLE_ADR_GRP_REF . ".grp_id=" . checkset_int($group_id); } if (isset($search['email']) && !empty($search['email'])) { $Query .= " AND lcase(" . TM_TABLE_ADR . ".email) like lcase('" . dbesc($search['email']) . "')"; } if (isset($search['recheck']) && !empty($search['recheck'])) { $Query .= " AND " . TM_TABLE_ADR . ".recheck = " . checkset_int($search['recheck']) . ""; } if (isset($search['aktiv']) && ($search['aktiv'] === "1" || $search['aktiv'] === "0")) { //!!! we have to compare strings, weird php! argh. $Query .= " AND " . TM_TABLE_ADR . ".aktiv = " . checkset_int($search['aktiv']) . ""; } //check for status, OR if (isset($search['status']) && $search['status'] > 0) { //if is no array, let first array entry be the string, so we always have an array if (!is_array($search['status'])) { $search_status = $search['status']; $search['status'] = array(); $search['status'][0] = $search_status; } //create query $ssc = count($search['status']); if ($search['status'][0] > 0) { $Query .= " AND ("; for ($sscc = 0; $sscc < $ssc; $sscc++) { $Query .= TM_TABLE_ADR . ".status=" . checkset_int($search['status'][$sscc]); if ($sscc + 1 < $ssc) { $Query .= " OR"; } } $Query .= " )"; } } $DB->Query($Query); $ac = 0; while ($DB->next_record()) { $ADRID[$ac] = $DB->Record['id']; $ac++; } $this->DB->free(); return $ADRID; }
function getID($group_id = 0, $search = array()) { //liefert NUR die IDs in einer Gruppe zurueck als Array!!! Beoetigt fuer die Formulare $ID = array(); $DB = new tm_DB(); $Query = "\n\t\t\t\t\t\tSELECT " . $this->TM_TABLE_ITEM . ".id\n\t\t\t\t\t\tFROM " . $this->TM_TABLE_ITEM . "\n\t\t\t\t\t"; if (isset($search['group']) && !empty($search['group'])) { $group_id = checkset_int($search['group']); } if (check_dbid($group_id)) { $Query .= "LEFT JOIN " . $this->TM_TABLE_ITEM_GRP_REF . " ON " . $this->TM_TABLE_ITEM . ".id = " . $this->TM_TABLE_ITEM_GRP_REF . ".item_id"; } $Query .= " WHERE " . $this->TM_TABLE_ITEM . ".siteid='" . TM_SITEID . "'"; if (check_dbid($group_id)) { $Query .= " AND " . $this->TM_TABLE_ITEM_GRP_REF . ".siteid='" . TM_SITEID . "'\n\t\t\t\t\t\t AND " . $this->TM_TABLE_ITEM_GRP_REF . ".grp_id=" . checkset_int($group_id); } if (isset($search['url']) && !empty($search['url'])) { $Query .= " AND lcase(" . $this->TM_TABLE_ITEM . ".url) like lcase('" . dbesc($search['url']) . "')"; } if (isset($search['aktiv']) && ($search['aktiv'] === "1" || $search['aktiv'] === "0")) { //!!! we have to compare strings, weird php! argh. $Query .= " AND " . $this->TM_TABLE_ITEM . ".aktiv = " . checkset_int($search['aktiv']) . ""; } $DB->Query($Query); $c = 0; while ($DB->next_record()) { $ITEMID[$c] = $DB->Record['id']; $c++; } $this->DB->free(); return $ITEMID; }