" . mysql_num_rows($hData) . " total result rows retrieved.
";
echo "\n";
if ($rActions == null) $rActions = array();
if ($title != "") echo "$title";
echo "\t\n";
$fields = mysql_num_fields($hData);
$names = array();
for ($k = 0; $k < $fields; $k++) {
$names[$k] = mysql_field_name($hData, $k);
echo "\t\t| " . $names[$k] . " | \n";
} echo "\t
\n";
while ($data = mysql_fetch_array($hData)) {
if ($i++ > $maximum) {
echo "| (listing discontinued at $maximum rows) |
";
break;
} echo "\t\n";
for ($k = 0; $k < $fields; $k++) {
$fieldValue = (strlen($data[$k]) < 500 ? htmlspecialchars($data[$k]) : htmlspecialchars(substr($data[$k], 0, 500)) . " .....");
if ($rActions[$names[$k]] != "") {
$url = $rActions[$names[$k]];
for ($i = 0; $i < $fields; $i++) {
$url = str_replace('$' . $names[$k], $data[$k], $url);
} echo "\t\t| " . $fieldValue . " | \n";
} else {
echo "\t\t" . $fieldValue . " | \n";
}
} echo "\t
\n";
} echo "
\n";
}
function printArray($rArray, $ignoreNumericIndeces = true, $useIndexing = false, $asRow = false, $keysMatching = "") {
if (!is_array($rArray)) {
echo "printArray: nothing to print\n";
return;
} echo "\n";
$arrayCount = count($rArray);
if ($arrayCount < 1) {
echo "| (no values) |
\n";
return;
} if ($useIndexing) {
if ($asRow) {
echo "";
for ($i = 0; $i < $arrayCount; $i++) {
echo "\t| $i | \n";
} echo "
\n\n";
for ($i = 0; $i < $arrayCount; $i++) {
echo "\t" . $rArray[$i] . " | \n";
} echo "\n";
} else {
for ($i = 0; $i < $arrayCount; $i++) {
echo "";
echo "\t\t| $i | \n";
echo "\t\t" . $rArray[$i] . " | \n";
echo "
\n";
}
}
} else {
if ($asRow) {
echo "";
foreach ($rArray as $index => $value) {
if ($ignoreNumericIndeces) {
$i = intval($index);
if ($i > 0 && $i < $arrayCount) continue;
if ($index == "0") continue;
} echo "\t\t| $index | \n";
} echo "
\n\n";
foreach ($rArray as $index => $value) {
if ($ignoreNumericIndeces) {
$i = intval($index);
if ($i > 0 && $i < $arrayCount) continue;
if ($index == "0") continue;
} if ($keysMatching != "") if (!eregi($keysMatching, $index)) continue;
echo "\t| $value | \n";
} echo "
\n";
} else {
foreach ($rArray as $index => $value) {
if ($ignoreNumericIndeces) {
$i = intval($index);
if ($i > 0 && $i < $arrayCount) continue;
if ($index == "0") continue;
} if ($keysMatching != "") if (!eregi($keysMatching, $index)) continue;
echo "";
echo "\t\t| $index | \n";
echo "\t\t$value | \n";
echo "
\n";
}
}
} echo "
\n";
}
function printObject(&$rObject) {
print "\n\n";
print_r($rObject);
echo "\n";
print "\n";
}
function cellValue($value) {
return $value == "" ? " " : $value;
}
function isInArray($value, $theArray) {
if (count($theArray) == 0) return false;
foreach ($theArray as $element) {
if ($value == $element) return true;
} return false;
}
function make_seed() {
list($usec, $sec) = explode(' ', microtime());
return (float) $sec + ((float) $usec * 100000);
}
function IsValidEmail($email) {
return( eregi("@", $email) && eregi("\\.", $email) );
}
function DateString($theString, $input = "MySQL") {
if ($input == "MySQL") {
return intval(substr($theString, 5, 2)) . "/" . intval(substr($theString, 8, 2)) . "/" . intval(substr($theString, 0, 4));
}
}
function getHomeURL() {
global $HTTP_HOST, $PHP_SELF;
return "http://" . $HTTP_HOST . substr($PHP_SELF, 0, strpos($PHP_SELF, "/", 1));
}
function SQL_AutoExecutor($transID = 0, $AutoClean = false) {
global $PHP_SELF;
$successful = 0;
$UNsuccessful = 0;
$hSQLs = mysql_query("SELECT ID, cmd FROM sql WHERE transID='$transID' AND executed='N' ORDER BY ID");
while ($rSQL = mysql_fetch_array($hSQLs)) {
if (mysql_query($rSQL['cmd'])) {
$successful++;
if ($AutoClean) {
mysql_query("DELETE FROM sql WHERE ID=" . $rSQL['ID']);
} else {
mysql_query("UPDATE sql SET executed='Y', successful='Y' WHERE ID=" . $rSQL['ID']);
}
} else {
$UNsuccessful++;
LogError($rSQL['cmd']);
$errID = GetLastInsertID("err");
mysql_query("UPDATE sql SET executed='Y', successful='N', ref3='$errID' WHERE ID=" . $rSQL['ID']);
}
} return $successful;
}
function array_add(&$array, $value) {
$array[] = $value;
end($array);
$newKey = key($array);
reset($array);
return $newKey;
}
function HiddenFields($FieldList, $ValueList = null, $appendName = "", $separator = "", $FieldNamesPrepend = "", $stripRequestSlashes = false) {
if (!is_array($FieldList)) $FieldList = array($FieldList);
$fieldString = "";
if (isset($ValueList)) {
if (!is_array($ValueList)) $ValueList = array($ValueList);
if (@isset($g_Debugging) && $g_Debugging) echo "using VALUELIST...
";
foreach ($FieldList as $fieldName => $fieldValue) {
$fieldString .= "" . $separator;
}
} else {
if (@isset($g_Debugging) && $g_Debugging) {
echo "using REQUEST...
";
DumpInfo($FieldList, "HiddenFields");
} foreach ($FieldList as $fieldName) {
$fieldName = $FieldNamesPrepend . $fieldName;
if (is_array($_POST[$fieldName])) {
if (@isset($g_Debugging) && $g_Debugging) echo "is_array(HTTP_POST_VARS:$fieldName)
";foreach ($_POST[$fieldName] as $fieldValue) {
if ($stripRequestSlashes) $fieldValue = stripslashes($fieldValue);
$fieldString .= "" . $separator;
}
} elseif (is_array($_GET[$fieldName])) {
if (@isset($g_Debugging) && $g_Debugging) echo "is_array(HTTP_GET_VARS:$fieldName)
";
foreach ($_GET[$fieldName] as $fieldValue) {
if ($stripRequestSlashes) $fieldValue = stripslashes($fieldValue);
$fieldString .= "" . $separator;
}
} else {
$fieldValue = $_POST[$fieldName] != "" ? $_POST[$fieldName] : $_GET[$fieldName];
if (@isset($g_Debugging) && $g_Debugging) echo "REGULAR:$fieldValue
";
if ($stripRequestSlashes) $fieldValue = stripslashes($fieldValue);
$fieldString .= "" . $separator;
}
}
} if (@isset($g_Debugging) && $g_Debugging) echo "!!!!!!!" . htmlspecialchars($fieldString) . "
\n";
return $fieldString;
}
function QueryString($FieldList, $leadingChar = "&", $stripRequestSlashes = false) {
$paramString = $leadingChar;
foreach ($FieldList as $name) {
$fieldValue = "";
if (isset($_GET[$name])) {
$fieldValue = $_GET[$name];
if ($stripRequestSlashes) $fieldValue = stripslashes($fieldValue);
} elseif (isset($_POST[$name])) {
$fieldValue = $_POST[$name];
if ($stripRequestSlashes) $fieldValue = stripslashes($fieldValue);
} elseif (isset($GLOBALS[$name])) {
$fieldValue = $GLOBALS[$name];
} $paramString .= urlencode($name) . "=" . urlencode($fieldValue) . "&";
} $paramString = substr($paramString, 0, strlen($paramString) - 1);
return $paramString;
}
function RequestFieldNames($pattern = ".", $bRemovePattern = false) {
$rMatches = array();
$POST_FieldNames = array_keys($_POST);
$GET_FieldNames = array_keys($_GET);
MatchingKeys($POST_FieldNames, $rMatches, $pattern, $bRemovePattern);
MatchingKeys($GET_FieldNames, $rMatches, $pattern, $bRemovePattern);
return $rMatches;
}
function MatchingKeys(&$CheckArray, &$KeysArray, $pattern, $bRemovePattern = false) {
for ($i = 0; $i < count($CheckArray); $i++) {
if (eregi($pattern, $CheckArray[$i])) {
if ($bRemovePattern) {
$KeysArray[] = eregi_replace($pattern, "", $CheckArray[$i]);
} else {
$KeysArray[] = $CheckArray[$i];
}
}
}
}
function AVD($theArray, $theKey, $theDefault = "") {
return $theArray[$theKey] != "" ? $theArray[$theKey] : $theDefault;
}
function DumpInfo($obj, $msg = "") {
echo "" . ($msg != "" ? $msg . " -- " : "") . "DumpInfo:
";
var_dump($obj);
echo "
";
}
function ScriptedEmailLink($email, $text = "", $subject = "", $body = "", $extraAnchorParms = "") {
if ($text == "") {
$text = str_replace("@", "@", $email);
$text = str_replace(".", ".", $text);
$text = str_replace("'", "'", $text);
$text = str_replace("\"", '"',$text); } $parts = split("@",$email); if( count($parts) < 2 ) { return "$text";
} else {
return "$text";
}
}
function WriteLn($text) {
echo $text . "
\n";
}
function WriteHidden($text) {
if (is_array($text)) {
echo "";
} else {
echo "";
}
}
function AdjustColorHTML($HtmlColor, $percent, $adjCode = "B") {
$htmlcol = strlen($HtmlColor) > 6 ? substr($HtmlColor, 1, 6) : $HtmlColor;
if (strlen($htmlcol) != 6) return $HtmlColor;
$adj = strtoupper(substr($adjCode, 0, 1));
$r1 = hexdec(substr($htmlcol, 0, 2));
$g1 = hexdec(substr($htmlcol, 2, 2));
$b1 = hexdec(substr($htmlcol, 4, 2));
if ($adjCode == "C") {
} elseif ($adjCode == "R") {
} elseif ($adjCode == "G") {
} elseif ($adjCode == "B") {
} else {
} $r2 = hexdec($r2);
if (strlen($r2) < 2) $r2 = "0" . $r2;
$g2 = hexdec($g2);
if (strlen($g2) < 2) $g2 = "0" . $g2;
$b2 = hexdec($b2);
if (strlen($b2) < 2) $b2 = "0" . $b2;
return "#" . $r2 . $g2 . $b2;
}
function MoneyFormat($amount, $bDollarSign = true) {
if ($bDollarSign) {
return "\$" . sprintf("%0.2f", $amount);
} else {
return sprintf("%0.2f", $amount);
}
}
function LimitChars($fieldValue, $maxlength, $fullHover = true, $isHTML = true, $elipsis = "...", $css_class = "text", $css_style = "") {
if (strlen($fieldValue) <= $maxlength) return $isHTML ? htmlspecialchars($fieldValue) : $fieldValue;
$shortVal = substr($fieldValue, 0, $maxlength) . $elipsis;
if (!$fullHover) return $isHTML ? htmlspecialchars($shortVal) : $shortVal;
return "" . htmlspecialchars($shortVal) . "";
}
function Buffering_Start() {
ob_start();
}
function & Buffering_Stop() {
$contents = ob_get_contents();
ob_end_clean();
}
function & Run_Buffered($code) {
Buffering_Start();
eval($code);
$contents = & Buffering_Stop();
return $contents;
}