public function xDate($DateValue = null, $DateFormat = "date")
{
$oDate = new Date($DateValue);
switch (lcase($DateFormat)) {
case "fulldatestring":
return $oDate->format("%d-%b-%Y %H:%M:%S");
break;
case "fulldate":
return $oDate->format("%d-%m-%Y %H:%M:%S");
break;
case "datetime":
return $oDate->format("%d-%m-%Y %H:%M");
break;
case "datestring":
return $oDate->format("%d %b %Y");
break;
case "date":
return $oDate->format("%d-%m-%y");
break;
case "entrystring":
return $oDate->format("%y %b %d");
break;
case "entry":
return $oDate->format("%d/%m/%y");
break;
case "monthyear":
return $oDate->format("%B %Y");
break;
case "monyear":
return $oDate->format("%b %Y");
break;
case "time":
if (len($DateValue) > 0) {
return $oDate->format("%H:%M");
}
break;
case "timesec":
return $oDate->format("%H:%M:%S");
break;
case "sql":
if (lcase(DB_TYPE) == "mysql") {
//return $oDate->format("%Y-%m-%d");
return $oDate->format("%d-%m-%y");
} elseif (lcase(DB_TYPE == "mssql")) {
return $oDate->format("%m/%y/%d");
}
break;
case "periode":
// Full Version
// return date("Ym");
// Demo Version Only
return "200506";
break;
case "periode_string":
return $oDate->format("% %b %d");
break;
case "periode_post":
return $oDate->format("%d%m");
break;
case "periodestring":
// Full Version
// return date("Ym");
// Demo Version Only
return "Mei 2005";
break;
case "file":
return $oDate->format("%Y/%m/%d");
break;
}
}
function step3()
{
$db_PREFIX = lcase(trim(@$_REQUEST['db_PREFIX']));
if ($db_PREFIX == '') {
$db_PREFIX = 'xy_';
}
$urlStr = '&loginname=' . @$_REQUEST['loginname'] . '&loginpwd=' . @$_REQUEST['loginpwd'];
?>
<form id="form1" name="form1" method="post" action="../admin/index.php?act=setAccess&webdataDir=/Templates2015/sharembweb/WebData&login=out">
<div class="pright">
<div class="pr-title"><h3>数据库设定 第三步</h3></div>
<table width="726" border="0" align="center" cellpadding="0" cellspacing="0" class="twbox">
<tbody>
<tr>
<td class="onetd"><strong>提示：</strong></td>
<td> <div class="mytipwrap">创建数据库成功。(如果不恢复数据库将退出) <a href="../index.php" class="mytip" target="_blank">访问网站首页</a><a href="../admin/index.php" class="mytip" target="_blank">登录网站后台</a> </div> </td>
</tr>
<tr>
<td colspan="2">
<iframe src="install.php?db_PREFIX=<?php
echo $db_PREFIX . $urlStr;
?>
" width="100%" height="350"></iframe>
</td>
</tr>
</tbody>
</table>
<div class="btn-box">
<input name="提交" type="submit" class="btnclick1" value="导入默认数据">
</div>
</div>
</form>
<?php
}
function handleSqlTop($sql)
{
$s = "";
$nLength = "";
$leftStr = "";
$rightStr = "";
$nRow = "";
$s = LCase($sql);
$nLength = instr($s, " top ");
$nSelect = instr(lcase($s), "select ");
if ($nLength > 0 && $nSelect > 0) {
//只允许查询有显示多少条的限制 20160408
$leftStr = mid($sql, 1, $nLength);
$rightStr = mid($sql, $nLength + 5, -1);
$rightStr = AspTrim($rightStr);
$nRow = mid($rightStr, 1, instr($rightStr, " "));
$rightStr = mid($rightStr, instr($rightStr, " "), -1);
//call echo("nRow",nRow)
//call echo("leftStr",leftStr)
//call echo("rightStr",rightStr)
$sql = $leftStr . $rightStr . " limit " . $nRow;
}
$handleSqlTop = $sql;
return @$handleSqlTop;
}
