function MakeCSVRecord($a_column_list, $a_vars)
{
$s_rec = "";
$n_columns = count($a_column_list);
for ($ii = 0; $ii < $n_columns; $ii++) {
list($s_col_name, $s_format) = $this->_GetColumn($a_column_list[$ii]);
/*
* if a column is specified it must be included, even if there
* is no data for it.
*/
$s_value = GetFieldValue($s_col_name, $a_vars, $this->_cIntSep);
if (isset($this->_sCleanFunc)) {
$s_func = $this->_sCleanFunc;
$s_value = $s_func($s_value);
}
$s_value = $this->_Format($s_value, $s_format);
if ($ii > 0) {
/*
* prepend the separator from the second field onwards
*/
$s_rec .= $this->_cSep;
}
$s_rec .= $s_value;
}
return $s_rec;
}
$addsql = '';
if (!empty($dede_fields)) {
$fieldarr = explode(';', $dede_fields);
if (is_array($fieldarr)) {
foreach ($fieldarr as $field) {
if ($field == '') {
continue;
}
$fieldinfo = explode(',', $field);
if ($fieldinfo[1] == 'htmltext' || $fieldinfo[1] == 'textdata') {
${$fieldinfo[0]} = filterscript(stripslashes(${$fieldinfo[0]}));
${$fieldinfo[0]} = addslashes(${$fieldinfo[0]});
${$fieldinfo[0]} = GetFieldValue(${$fieldinfo[0]}, $fieldinfo[1], 0, 'add', '', 'member');
${$fieldinfo[0]} = empty(${$fieldinfo[0]}) ? $diyco[$fieldinfo[0]] : ${$fieldinfo[0]};
} else {
${$fieldinfo[0]} = GetFieldValue(${$fieldinfo[0]}, $fieldinfo[1], 0, 'add', '', 'diy', $fieldinfo[0]);
${$fieldinfo[0]} = empty(${$fieldinfo[0]}) ? $diyco[$fieldinfo[0]] : ${$fieldinfo[0]};
}
$addsql .= !empty($addsql) ? ',`' . $fieldinfo[0] . "`='" . ${$fieldinfo[0]} . "'" : '`' . $fieldinfo[0] . "`='" . ${$fieldinfo[0]} . "'";
}
}
}
$query = "UPDATE `{$diy->table}` SET {$addsql} WHERE id={$id}";
if ($dsql->ExecuteNoneQuery($query)) {
$goto = "diy_list.php?action=list&diyid={$diy->diyid}";
showmsg('编辑成功', $goto);
} else {
showmsg('编辑成功', '-1');
}
}
}
function GetFieldValueA($dvalue,$dtype,$aid=0,$job='add',$addvar='')
{
return GetFieldValue($dvalue,$dtype,$aid,$job,$addvar,'member');
}
//require_once '../inc/admin_secure.inc.php';
$msg = deQueueMsg();
$var_clear = true;
function generateRandomString($length = 15)
{
$characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
$charactersLength = strlen($characters);
$randomString = '';
for ($i = 0; $i < $length; $i++) {
$randomString .= $characters[rand(0, $charactersLength - 1)];
}
return $randomString;
}
$emailFlag = false;
if (!empty($_POST)) {
$num = GetFieldValue('name', 'users', "email ='" . $_POST['email'] . "'");
if ($num) {
echo "exist";
exit;
} else {
$string = generateRandomString();
$name = $_POST['name'];
$email = $_POST['email'];
$pass1 = $_POST['password'];
$phone = $_POST['phone'];
$pass = md5($pass1);
$sql_insert = "insert into users (name,email,password,phone,active,code) VALUES ( " . " '{$name}', '{$email}', '{$pass}', '{$phone}', 0 , '{$string}' )";
$sql_res = Query($sql_insert);
if ($sql_res) {
$msg = 'success';
$emailFlag = true;
<?php
include_once 'inc/config.inc.php';
include_once 'inc/class.phpmailer.php';
//require_once '../inc/admin_secure.inc.php';
$msg = deQueueMsg();
$var_clear = true;
if (!empty($_GET)) {
$email = $_GET['e'];
$key = $_GET['k'];
$num = GetFieldValue('name', 'users', "email ='" . $email . "' and code ='" . $key . "'");
if ($num) {
$update = "update users SET code = '' where email = '" . $email . "'";
$update_res = Query($update);
?>
<!DOCTYPE html>
<!--[if IE 8]><html class="ie ie8"> <![endif]-->
<!--[if IE 9]><html class="ie ie9"> <![endif]-->
<!--[if gt IE 9]><!--> <html> <!--<![endif]-->
<head>
<?php
include_once 'head.php';
?>
<title>We provide Combo packages for Best Day Tours in Singapore and Attractions</title>
<meta name="keywords" content="Singapore Day Tours, Singapore Attractions, Singapore Best Tours, Singapore Island Tours, Singapore City Tours, Singapore Private Tours, Singapore Family Tours, Singapore Adventure Tours, Singapore Couple Tours, Singapore Nature Tours">
<meta name="description" content="We brings best Travel deals for Singapore. We have Singapore best Day Tours & Attractions, short stay in Singapore. Our Professional can provide the best advice to visitors.">
<style>
.dropdown-menu {
<?php
include_once 'inc/config.inc.php';
include_once 'inc/class.phpmailer.php';
//require_once '../inc/admin_secure.inc.php';
$msg = deQueueMsg();
$var_clear = true;
if (!empty($_GET)) {
$email = $_GET['e'];
$key = $_GET['k'];
$num = GetFieldValue('name', 'users', "email ='" . $email . "'");
if ($num) {
$update = "update users SET active = 1 where email = '" . $email . "' and code = '" . $key . "'";
$update_res = Query($update);
header("Location: index.php");
exit;
} else {
header("Location: 404.php");
exit;
}
}
function SubstituteValueWorker($a_matches, $s_repl, $b_html = true)
{
global $aSubstituteErrors, $aSubstituteValues, $SPECIAL_VALUES;
$b_insert_br = true;
// option to put "<br />" tags before newlines in HTML templates
$s_name = $a_matches[0];
assert(strlen($s_name) > 1 && $s_name[0] == '$');
$s_name = substr($s_name, 1);
if (($i_len = strlen($s_name)) > 0 && $s_name[0] == '{') {
assert($s_name[$i_len - 1] == '}');
$s_name = substr($s_name, 1, -1);
//
// grab any processing options
//
$a_args = explode(":", $s_name);
$s_name = $a_args[0];
if (($n_args = count($a_args)) > 1) {
for ($ii = 1; $ii < $n_args; $ii++) {
switch ($a_args[$ii]) {
case "nobr":
$b_insert_br = false;
break;
}
}
}
}
$s_value = "";
if (IsFieldSet($s_name, $aSubstituteValues) && !TestFieldEmpty($s_name, $aSubstituteValues, $s_mesg)) {
if (is_array($aSubstituteValues[$s_name])) {
//
// note that the separator can include HTML special chars
//
$s_value = implode($SPECIAL_VALUES['template_list_sep'], $b_html ? ArrayHTMLSpecialChars($aSubstituteValues[$s_name]) : $aSubstituteValues[$s_name]);
} else {
$s_value = GetFieldValue($s_name, $aSubstituteValues);
if ($b_html) {
$s_value = htmlspecialchars($s_value);
}
}
if ($b_html && $b_insert_br) {
//
// Insert HTML line breaks before newlines.
//
$s_value = nl2br($s_value);
}
} elseif (isset($SPECIAL_VALUES[$s_name])) {
$s_value = $b_html ? htmlspecialchars((string) $SPECIAL_VALUES[$s_name]) : (string) $SPECIAL_VALUES[$s_name];
} elseif (isset($s_repl)) {
//
// If a replacement value has been specified use it, and
// don't call htmlspecialchars. This allows the use
// of HTML tags in a replacement string.
//
$s_value = $s_repl;
} else {
$aSubstituteErrors[] = GetMessage(MSG_FLD_NOTFOUND, array("FIELD" => $s_name));
}
return $s_value;
}
