echo '添加会员失败!'; DebugStr($MyDatabase->SqlStr); exit; } //插入会员扩展数据表 $ArrField = array('uid', 'postnum', 'rvrc', 'money', 'lastvisit', 'thisvisit', 'onlineip'); $ArrValue = array($winduid, 0, $rg_regrvrc, $rg_regmoney, TIMESTAMP, TIMESTAMP, ONLINEIP); if ($MyDatabase->Insert('user_ext', $ArrField, $ArrValue)) { } else { echo '添加会员扩展数据失败!'; exit; } //更新论坛信息,最新会员,总会员数 $SqlStr = 'UPDATE `' . DB_TABLE_PRE . 'bbsinfo` SET `newmember`=\'' . $rg_name . '\',`totalmember`=`totalmember`+1 WHERE id=1'; $MyDatabase->SqlStr = $SqlStr; $MyDatabase->ExecuteQuery(); /* $ArrField=array('newmember', 'totalmember'); $ArrValue=array($rg_name, 'totalmember+1'); if($MyDatabase->Update('bbsinfo', $ArrField, $ArrValue, '`id`=1')){ }else{ echo '更新会员数据失败!'; DebugStr($MyDatabase->SqlStr); exit(); }*/ $windid = $rg_name; $windpwd = $rg_pwd; if ($rg_yz == 1) { Cookie("winduser", $winduid . "\t" . $windpwd); Cookie("ck_info", DB_CKPATH . "\t" . DB_CKDOMAIN); Cookie('lastvisit', '', 0);
<? include("Grid.class.php"); include("DB/DataBase.class.php"); include("GridSource.class.php"); include("GridPresenter.class.php"); $date = Database::ExecuteQuery("SELECT fecha FROM reservaciones LIMIT 0,1"); $concat = Database::ExecuteQuery("SELECT CONCAT(sum(nadultos), '.', sum(nninios)) FROM reservaciones WHERE id = 7"); #echo $d = $date[0][0]; #echo strlen($d); /* echo " "; echo $c = $concat[0][0]; echo "<br/>"; echo $sum = $d+$c; if(is_float($c)) echo "true"; else echo "false"; */ $sql = " SELECT resultados.Agencias , SUM(resultados.AdultosTour1)'Adultos Mayan Adventure', SUM(resultados.NiniosTour1) 'Niños Mayan Adventure' , SUM(resultados.AdultosTour2) 'Adultos Tulum Xtreme' , SUM(resultados.NiniosTour2) 'Niños Tulum Xtreme' , SUM(resultados.AdultosTour3)'Adultos Mayan Xtreme' , SUM(resultados.NiniosTour3) 'Niños Mayan Xtreme' ,
/** * 根据编号,增加一个点击 * */ function UpdateHits($id) { $CateTitle = ''; //-------------------0 $SqlStr = 'UPDATE `' . DB_TABLE_PRE . 'article`'; $SqlStr .= ' SET `hits`=`hits`+1'; $SqlStr .= ' WHERE 1=1'; $SqlStr .= ' AND `id`=' . $id; $MyDatabase = new Database(); $MyDatabase->SqlStr = $SqlStr; $MyDatabase->ExecuteQuery(); }