/**
* @return Boolean
* @param String $table
* @param String $where
* @desc See if a field match sql query is in the DB
*/
function existence_complex($table, $where)
{
$row = dbs::selrecord('*', $table, $where, '0', '0');
if (dbs::numrecords($row)) {
return true;
}
return false;
}
if (!isset($start)) {
// record number to start the query from
$start = 0;
}
// limit the number of records returned
$end = 10;
if ($mode == 'preview') {
$check = dbs::selrecord('*', $table, $sql, '0', '0');
$count = dbs::numrecords($check);
$result = dbs::selrecord('*', $table, $sql, 'name ASC LIMIT ' . $start . ',' . $end, '0');
$final = dbs::numrecords($result);
} else {
$check = dbs::selrecord('*', $table, '0', '0', '0');
$count = dbs::numrecords($check);
$result = dbs::selrecord('*', $table, '0', 'name ASC LIMIT ' . $start . ',' . $end, '0');
$final = dbs::numrecords($result);
}
if ($count > 0) {
hr(2);
?>
<tr>
<td class="bodybold">GROUPNAME</td><td class="bodybold" align="right">ACTIONS</td>
</tr>
<?php
while ($row = dbs::fetchrecord($result)) {
hr(2);
?>
<tr>
<td valign="top" class="bodybold" title="ID: <?php
echo $row[$key];
?>
/**
* @return Array
* @param unknown $name
* @param unknown $dbfield
* @param unknown $displayfield
* @param unknown $current
* @param unknown $populate
* @param unknown $populatevalues
* @param unknown $where
* @param unknown $orderby
* @desc returns all data for a select box populated from a db table or array
*/
function getdata_select_extra($name, $dbfield, $displayfield, $current, $populate, $populatevalues, $where, $orderby)
{
$index = 0;
if (!is_array($populate)) {
// populate from table
if ($siteid && !$where) {
$where = 'siteid=' . $s_siteid;
} elseif ($where && $siteid) {
$where = ' AND siteid=' . $s_siteid;
}
$rows = dbs::selrecord($dbfield . ',' . $displayfield, $populate, $where, $orderby, '0');
if (dbs::numrecords($rows) != 0) {
// No results returned
while ($row = dbs::fetchrecord($rows)) {
if (preg_match("/,/", $displayfield)) {
$display = '';
$displays = explode(",", $displayfield);
for ($i = 0; $i < count($displays); $i++) {
$display .= $row[$displays[$i]] . '&%&';
}
} else {
$display = $row[$displayfield];
}
$resultpackage[$index] = formdata::select_createpackage($row[$dbfield], $current, $display);
$index++;
}
} else {
$resultpackage = false;
}
} else {
// populate from an array
if (sizeof($populate) != 0) {
// no results returned
$popvalsindex = 0;
foreach ($populate as $element) {
if ($populatevalues) {
// an array has been provided to populate values
$resultpackage[$index] = formdata::select_createpackage($element, $current, $populatevalues[$popvalsindex]);
} else {
// use the populate array as the values and the display values
$resultpackage[$index] = formdata::select_createpackage($element, $current, $element);
}
$index++;
$popvalsindex++;
}
} else {
$resultpackage = false;
}
}
// all setup data goes here in the last element
$resultpackage[$index]['optionname'] = $name;
return $resultpackage;
}
