| 1 |
<?php |
<?php |
| 2 |
// $Id: contact.module,v 1.62 2004/11/17 00:41:19 drumm Exp $ |
// $Id: contact.module,v 1.63 2004/11/17 19:27:53 drumm Exp $ |
| 3 |
|
|
| 4 |
define('SOURCES_FORM', 0); |
define('SOURCES_FORM', 0); |
| 5 |
define('SOURCES_FORM_ADMIN', 1); |
define('SOURCES_FORM_ADMIN', 1); |
| 931 |
$form = _contact_get_form(); |
$form = _contact_get_form(); |
| 932 |
$and = array(); |
$and = array(); |
| 933 |
if ($edit['mail']) { |
if ($edit['mail']) { |
| 934 |
$and[] = 'c.mail LIKE \'%'. check_query($edit['mail']) .'%\''; |
$and[] = 'c.mail LIKE \'%'. db_escape_string($edit['mail']) .'%\''; |
| 935 |
} |
} |
| 936 |
foreach ($form->fields as $field) { |
foreach ($form->fields as $field) { |
| 937 |
if ($edit[$field->name]) { |
if ($edit[$field->name]) { |
| 939 |
$or = array(); |
$or = array(); |
| 940 |
foreach ($edit[$field->name] as $value) { |
foreach ($edit[$field->name] as $value) { |
| 941 |
if ($value) { |
if ($value) { |
| 942 |
$or[] = 'f'. $field->ffid .' LIKE \'%'. check_query($value) .'%\''; |
$or[] = 'f'. $field->ffid .' LIKE \'%'. db_escape_string($value) .'%\''; |
| 943 |
} |
} |
| 944 |
} |
} |
| 945 |
if (count($or) > 0) { |
if (count($or) > 0) { |
| 947 |
} |
} |
| 948 |
} |
} |
| 949 |
else { |
else { |
| 950 |
$and[] = 'j'. $field->ffid .'.data LIKE \'%'. check_query($edit[$field->name]) .'%\''; |
$and[] = 'j'. $field->ffid .'.data LIKE \'%'. db_escape_string($edit[$field->name]) .'%\''; |
| 951 |
} |
} |
| 952 |
} |
} |
| 953 |
} |
} |
| 954 |
if ($edit['sources']) { |
if ($edit['sources']) { |
| 955 |
foreach ($edit['sources'] as $csid) { |
foreach ($edit['sources'] as $csid) { |
| 956 |
$or[] = 'd.csid = \''. check_query($csid) .'\''; |
$or[] = 'd.csid = \''. db_escape_string($csid) .'\''; |
| 957 |
} |
} |
| 958 |
$and[] = '('. implode(' OR ', $or) .')'; |
$and[] = '('. implode(' OR ', $or) .')'; |
| 959 |
} |
} |