exit; } $savesql->ExecuteNoneQuery("Update #@__config set `config_value`='{$v}' where `config_name`='{$k}' "); } $savesql->SetQuery("Select `config_name`,`config_value` From `#@__config` order by `id` asc"); $savesql->Execute(); if ($savesql->GetTotalRow() <= 0) { $savesql->Close(); ShowMsg("成功保存变量但从数据库读取所有数据时失败,无法更新配置文件!", "javascript:;"); exit; } @copy($configfile, $configfile_bak); $fp = @fopen($configfile, 'w'); @flock($fp, 3); @fwrite($fp, "<" . "?php\r\n") or die("配置文件'{$configfile}'不支持写入,本次操作无效!<a href='system_basic.php'>返回</a>"); while ($row = $savesql->GetArray()) { $row['value'] = str_replace("'", "\\'", $row['config_value']); fwrite($fp, "\${$row['config_name']} = '" . $row['config_value'] . "';\r\n"); } fwrite($fp, "?>"); fclose($fp); $message = "成功修改了系统配置文件config_base.php"; $logindate = getdatetimemk(time()); $loginip = getip(); $username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]); $savesql->Close(); WriteNote($message, $logindate, $loginip, $username); ShowMsg("成功更改系统配置!", "system_basic.php"); exit; } ?>
<?php require_once(dirname(__FILE__)."/config.php"); CheckPurview('sys_Data'); //获取系统存在的表信息 $otherTables = Array(); $dedeSysTables = Array(); $channelTables = Array(); $dsql = new DedeSql(false); $dsql->SetQuery("Select addtable From #@__channeltype"); $dsql->Execute(); while($row = $dsql->GetObject()){ $channelTables[] = $row->addtable; } $dsql->SetQuery("Show Tables"); $dsql->Execute('t'); while($row = $dsql->GetArray('t')){ if(ereg("^{$cfg_dbprefix}",$row[0])||in_array($row[0],$channelTables)) { $dedeSysTables[] = $row[0]; } else{ $otherTables[] = $row[0]; } } function TjCount($tbname,$dsql){ $row = $dsql->GetOne("Select count(*) as dd From $tbname"); return $row['dd']; } $mysql_version = $dsql->GetVersion(); $mysql_versions = explode(".",trim($mysql_version)); $mysql_version = $mysql_versions[0].".".$mysql_versions[1];
fwrite($fp,$row['body']); fclose($fp); } $dsql->Close(); ShowMsg("成功更新一个页面!",$fileurl); exit(); } /*---------------------- function __makeAll(); -------------------*/ else if($dopost=="makeall") { require_once(dirname(__FILE__)."/../include/inc_arcpart_view.php"); $dsql->ExecuteNoneQuery("update #@__sgpage set uptime='".time()."'"); $row = $dsql->Execute('meoutside',"Select * From #@__sgpage "); while($row = $dsql->GetArray('meoutside')) { $fileurl = $cfg_cmspath."/".$row['filename']; $filename = $cfg_basedir.$cfg_cmspath."/".$row['filename']; if($row['ismake']==1) { $pv = new PartView(); $pv->SetTemplet($row['body'],"string"); $pv->SaveToHtml($filename); } else { $fp = fopen($filename,"w") or die("创建:{$filename} 失败,可能是没有权限!"); fwrite($fp,$row['body']); fclose($fp); }
<tr bgcolor="#FFFFFF"> <td colspan="2" align="center" class="mma"> <table width="98%" border="0" cellspacing="0" cellpadding="0"> <?php if(!isset($dsql) || !is_object($dsql)){ $dsql = new DedeSql(false); } $addQuery = ""; if(!empty($channelid)){ $channelid = ereg_replace("[^0-9]","",$channelid); $addQuery = " And channelid='$channelid' "; } $userNumID = ereg_replace("[^0-9]","",$userNumID); $dsql->SetQuery("Select * From #@__member_arctype where memberid='$userNumID' $addQuery order by rank desc; "); $dsql->Execute(); while($menurow = $dsql->GetArray()) { if($menurow['channelid']==1) $tf = '<img src="img/dd/exe.gif" width="16" height="16">'; else $tf='<img src="img/dd/image.gif" width="16" height="16">'; ?> <tr> <td align="right" class="mmbb" height="24" width="30%" style="padding-right:6px"><?php echo $tf?></td> <td class="mmbb"> <a href='member_archives.php?uid=<?php echo $uid?>&channelid=<?php echo $menurow['channelid']?>&mtype=<?php echo $menurow['aid']?>'><?php echo $menurow['typename']?></a> </td> </tr> <?php } ?> </table> </td>
} //检测数据库是否存在附加表,不存在则新建一个 $tabsql = "CREATE TABLE IF NOT EXISTS `{$row['addtable']}`( `aid` int(11) NOT NULL default '0',\r\n `typeid` int(11) NOT NULL default '0',\r\n "; if($mysql_version < 4.1) $tabsql .= " PRIMARY KEY (`aid`), KEY `".$trueTable."_index` (`typeid`)\r\n) TYPE=MyISAM; "; else $tabsql .= " PRIMARY KEY (`aid`), KEY `".$trueTable."_index` (`typeid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=".$cfg_db_language."; "; $dsql->ExecuteNoneQuery($tabsql); //检测附加表里含有的字段 $fields = array(); $rs = $dsql->SetQuery("show fields from `{$row['addtable']}`"); $dsql->Execute('a'); while($nrow = $dsql->GetArray('a',MYSQL_ASSOC)){ $fields[ strtolower($nrow['Field']) ] = $nrow['Type']; } //修改字段配置信息 $dfvalue = $vdefault; $isnull = ($isnull==1 ? "true" : "false"); $mxlen = $maxlength; $fieldname = strtolower($fname); //检测被修改的字段类型,并更新数据表 $fieldinfos = GetFieldMake($dtype,$fieldname,$dfvalue,$mxlen); $ntabsql = $fieldinfos[0]; $buideType = $fieldinfos[1];
<?php require(dirname(__FILE__)."/config.php"); CheckPurview('sys_Data'); if(empty($dopost)) $dopost = ""; AjaxHead(); $dsql = new DedeSql(false); echo "<a href='#' onclick='javascript:HideObj(\"_mydatainfo\")'>[<u>关闭</u>]</a>\r\n<xmp>"; if($dopost=="viewinfo") //查看表结构 { if(empty($tablename)) echo "没有指定表名!"; else{ $dsql->SetQuery("SHOW CREATE TABLE ".$dsql->dbName.".".$tablename); $dsql->Execute(); $row2 = $dsql->GetArray(); $ctinfo = $row2[1]; echo trim($ctinfo); } $dsql->Close(); exit(); } else if($dopost=="opimize") //优化表 { if(empty($tablename)) echo "没有指定表名!"; else{ $dsql->ExecuteNoneQuery("OPTIMIZE TABLE `$tablename` "); $dsql->Close(); echo "执行优化表: $tablename OK!"; } exit(); } else if($dopost=="repair") //修复表
function pr_str_replace($str) { $dsql = new DedeSql(false); $dsql->SetQuery("SELECT * FROM `#@__str_replace`"); $dsql->Execute(); while ($row = $dsql->GetArray()) { if ($row['interconvert'] == 1) { $str = str_replace($row['find'], "@@@@", $str); $str = str_replace($row['replace'], $row['find'], $str); $str = str_replace("@@@@", $row['replace'], $str); } else { if ($row['interconvert'] == 0) { $str = str_replace($row['find'], $row['replace'], $str); } } } return $str; }
//更新栏目 /*------------------- function _4_MakeCatalog() --------------------*/ else if($step==4) { $dsql = new DedeSql(false); $mkvalue = intval($mkvalue); $typeids = array(); $adminID = $cuserLogin->getUserID(); $mkcachefile = DEDEADMIN."/../data/mkall_cache_{$adminID}.php"; if($mkvalue<=0) { $dsql->SetQuery("Select ID From `#@__arctype` "); $dsql->Execute(); while($row = $dsql->GetArray()) $typeids[] = $row['ID']; }else { if($uptype=='time') $query = "Select typeid From `#@__full_search` where uptime>='{$mkvalue}' group by typeid"; else $query = "Select typeid From `#@__full_search` where aid>='{$mkvalue}' group by typeid"; $dsql->SetQuery($query); $dsql->Execute(); while($row = $dsql->GetArray()){ if(!isset($typeids[$row['typeid']])) $typeids[$row['typeid']] = 1; } foreach($typeids as $v){ $vs = SpGetTopIDS($v); foreach($vs as $vv){ if(!isset($typeids[$vv])) $typeids[$row[$vv]] = 1; } } } $fp = fopen($mkcachefile,'w') or die("无法写入缓存文件:{$mkcachefile} 所以无法更新栏目!");
$dsql->ExecuteNoneQuery("Insert into #@__syspassport Values('$pp_regurl','cfg_pp_regurl'); "); $dsql->ExecuteNoneQuery("Insert into #@__syspassport Values('$pp_loginurl','cfg_pp_loginurl'); "); $dsql->ExecuteNoneQuery("Insert into #@__syspassport Values('$pp_exiturl','cfg_pp_exiturl'); "); $dsql->ExecuteNoneQuery("Insert into #@__syspassport Values('$pp_editsafeurl','cfg_pp_editsafeurl'); "); $dsql->ExecuteNoneQuery("Insert into #@__syspassport Values('$pp_name','cfg_pp_name'); "); $dsql->ExecuteNoneQuery("Insert into #@__syspassport Values('$pp_indexurl','cfg_pp_indexurl'); "); $dsql->ExecuteNoneQuery("Insert into #@__syspassport Values('$pp_type','cfg_pp_type'); "); $dsql->Close(); $fp = fopen(dirname(__FILE__)."/../include/config_passport.php","w") or die("写入文件 ../include/config_passport.php 失败!"); fwrite($fp,'<'.'?php '); fwrite($fp,"\r\n"); foreach($GLOBALS as $k=>$v){ if(ereg('^pp_',$k)){ $v = str_replace("'","`",stripslashes($v)); fwrite($fp,'$cfg_'.$k." = '".$v."';\r\n"); } } fwrite($fp,'?'.'>'); fclose($fp); ShowMsg("成功更改通行证设置!","sys_passport.php"); exit(); } $dsql = new DedeSql(false); $dsql->SetQuery("Select * From #@__syspassport "); $dsql->Execute(); while($row = $dsql->GetArray()){ $$row['varname'] = $row['value']; } require_once(dirname(__FILE__)."/templets/sys_passport.htm"); ClearAllLink(); ?>
<?php require_once(dirname(__FILE__)."/config.php"); $db = new DedeSql(false); if(empty($action)){ $smalltypes = array(); $sql = "select typename, ID, smalltypes from #@__arctype where smalltypes<>''"; $db->SetQuery($sql); $db->Execute(); $typesinfo = $types =array(); while($row = $db->GetArray()) { $row['smalltypes'] = explode(',',$row['smalltypes']); foreach($row['smalltypes'] as $smalltypeid) { $typesinfo[$smalltypeid][] = $row['typename']; $types[$smalltypeid][] = $row['ID']; } } $sql = "select * from #@__smalltypes order by disorder asc, id asc"; $db->SetQuery($sql); $db->Execute(); while($smalltype = $db->GetArray()) { $smalltype['types'] = $smalltype['relatetype'] = ''; if(!empty($typesinfo[$smalltype['id']]) && is_array($typesinfo[$smalltype['id']])) { $smalltype['relatetype'] = implode(', ', $typesinfo[$smalltype['id']]); $smalltype['types'] = urlencode(implode(', ', $types[$smalltype['id']])); } $smalltypes[] = $smalltype; }
$add_icon = ereg_replace("[^0-9]","",$add_icon); $add_titles = cn_substr($add_titles,15); $db->ExecuteNoneQuery("INSERT INTO #@__scores(integral,icon,titles,isdefault) VALUES('$integral','$add_icon','$add_titles','$add_isdefault')"); } foreach($_POST as $rk=>$rv){ if(ereg('-',$rk)) { $ID = ereg_replace("[^1-9]","",$rk); $fildes = ereg_replace("[^a-z]","",$rk); $k = $$rk; if(empty($k)) $k = 0; $sql = $fildes."='".$k."'"; $db->ExecuteNoneQuery("UPDATE #@__scores SET ".$sql." WHERE id='{$ID}'"); if(ereg('Ids-',$rk)) { if($k) $db->ExecuteNoneQuery("DELETE FROM #@__scores WHERE id='$ID'"); } } } } $Scores = array(); $db->SetQuery("SELECT * FROM #@__scores ORDER BY id ASC"); $db->Execute(); while($rs = $db->GetArray()) array_push ($Scores,$rs); require_once(dirname(__FILE__)."/templets/member_scores.htm"); $db->Close(); ClearAllLink(); ?>
$msg = "成功删除一个附件!"; $dsql->ExecuteNoneQuery("Delete From #@__uploads where aid='".$aid."'"); } $dsql->Close(); ShowMsg($msg,$backurl); exit(); }else{ $ids = explode(',',$ids); $idquery = ""; foreach($ids as $aid){ if($idquery=="") $idquery .= " where aid='$aid' "; else $idquery .= " Or aid='$aid' "; } $dsql->SetQuery("Select aid,url From #@__uploads $idquery "); $dsql->Execute(); while($myrow=$dsql->GetArray()){ $truefile = $cfg_basedir.$myrow['url']; $rs = 0; if(!file_exists($truefile)||$myrow['url']=="") $rs = 1; else $rs = @unlink($truefile); if($rs==1){ $dsql->ExecuteNoneQuery("Delete From #@__uploads where aid='".$myrow['aid']."'"); } } $dsql->Close(); ShowMsg('成功删除选定的文件!',$backurl); exit(); } } /*-------------------------------- function __save_edit() //保存更改
require_once(DEDEINC."/arc.partview.class.php"); $timestamp = time(); if(empty($tag)) { $tag = ''; } if(empty($action)) { // 获取所有分类 $arctype_sql = "select id,typename from `#@__arctype` where ispart=2 order by id asc"; $db = new DedeSql(); $db->SetQuery($arctype_sql); $db->Execute(); $arctype_list = array(); while($arr = $db->GetArray()) $arctype_list[$arr['id']] = $arr['typename']; $orderby = empty($orderby) ? 'id' : eregi_replace('[^a-z]','',$orderby); $orderway = isset($orderway) && $orderway == 'asc' ? 'asc' : 'desc'; if(!empty($tag)) { $where = " where tag like '%$tag%'"; } else { $where = ''; } $neworderway = ($orderway == 'desc' ? 'asc' : 'desc'); $query = "Select * from `#@__tagindex` left join `#@__tagindex_ex` using(id) $where order by $orderby $orderway"; $dlist = new DataListCP(); $tag = stripslashes($tag);
else if(!empty($channelid)) { $query = " Select * From #@__channeltype where ID='$channelid'"; $cInfos = $dsql->GetOne($query); $channelid = $cInfos['ID']; $addtable = $cInfos['addtable']; } //获取小分类 $smalltypes = ''; if(is_array($typeinfo) && !empty($typeinfo['smalltypes'])) { $sql = "select * from #@__smalltypes where id in($typeinfo[smalltypes]);"; $dsql->SetQuery($sql); $dsql->Execute(); while($smalltype = $dsql->GetArray()){ $smalltypes .= '<option value="'.$smalltype['id'].'">'.$smalltype['name']."</option>\n"; } } //////////////////////地区数据处理s///////////////////////////// $dsql->SetQuery("select * from #@__area"); $dsql->Execute(); $toparea = $subarea = array(); while($sector = $dsql->GetArray()) { if($sector['reid'] == 0){ $toparea[] = $sector; }else{ $subarea[] = $sector; } }
<?php //require_once(dirname(__FILE__)."./../include/config_base.php"); require_once(dirname(__FILE__)."./../member/config.php"); $dsql = new DedeSql(false); $areas = $sectors = $topsectors = $subsectors = array(); $dsql->setquery("select id, name, reid from #@__sectors order by disorder desc,id asc"); $dsql->Execute(); while($row = $dsql->GetArray()) { if($row['reid'] == 0){ $topsectors[] = $row; }else{ $subsectors[] = $row; } } foreach($topsectors as $topsector){ $sectors[] = $topsector; foreach($subsectors as $key => $subsector){ if($subsector['reid'] == $topsector['id']){ $sectors[] = $subsector; unset($subsectors[$key]); } } } //////////////////////地区数据处理s///////////////////////////// $sql = "select * from #@__area order by disorder asc,id asc"; $dsql->SetQuery($sql); $dsql->Execute();
<?php require_once(dirname(__FILE__)."/config.php"); $db = new DedeSql(false); if(empty($action)){ $sectors = $topsectors = $subsectors = array(); $sectorscache = ''; $sql = "select * from #@__area order by disorder asc, id asc"; $db->SetQuery($sql); $db->Execute(); while($row = $db->GetArray()) { if($row['reid'] == 0) { $topsectors[] = $row; }else { $subsectors[] = $row; } } foreach($topsectors as $topsector) { $sectors[] = $topsector; $sectorscache .= '<option value="'.$topsector['id'].'">|- '.$topsector['name'].'</option>'; foreach($subsectors as $subsector) { if($subsector['reid'] == $topsector['id']) { $sectors[] = $subsector; } }
$row = $dsql->GetOne($tjQuery); $totalnum = $row['dd']; } if($totalnum > 0){ $addquery = ""; if($sid!=0) $addquery = " And maintable.ID>='$sid' "; if($eid!=0) $addquery = " And maintable.ID<='$eid' "; $fquery = " Select maintable.ID,maintable.title,maintable.description,addtable.{$rpfield} as body From $maintable maintable left join {$addtable} addtable on addtable.aid=maintable.ID where maintable.channel='{$channel}' $addquery limit $startdd,$pagesize ; "; $dsql->SetQuery($fquery); $dsql->Execute(); while($row=$dsql->GetArray()) { $body = $row['body']; $description = $row['description']; if(strlen($description)>10 || $description=='-') continue; $bodytext = preg_replace("/#p#|#e#|副标题|分页标题/isU","",Html2Text($body)); if(strlen($bodytext) < $msize) continue; $des = trim(addslashes(cn_substr($bodytext,$dsize))); if(strlen($des)<3) $des = "-"; $dsql->ExecuteNoneQuery("Update $maintable set description='{$des}' where ID='{$row['ID']}';"); $dsql->ExecuteNoneQuery("Update #@__full_search set addinfos='{$des}' where aid='{$row['ID']}';"); } //返回进度信息 $startdd = $startdd + $pagesize; if($totalnum > $startdd){ $tjlen = ceil( ($startdd/$totalnum) * 100 );
if(isset(${'check_'.$startID})){ if($pname!='') $query = "update #@__member_type set pname='$pname',money='$money',rank='$rank',exptime='$exptime' where aid='$aid'"; } else{ $query = "Delete From #@__member_type where aid='$aid' "; } if($query!=''){ $dsql->ExecuteNoneQuery($query); } } //增加新记录 if(isset($check_new) && $pname_new!=''){ $query = "Insert Into #@__member_type(rank,pname,money,exptime) Values('{$rank_new}','{$pname_new}','{$money_new}','{$exptime_new}');"; $dsql->ExecuteNoneQuery($query); } header("Content-Type: text/html; charset={$cfg_ver_lang}"); echo "<script> alert('成功更新会员产品分类表!'); </script>"; } $arcranks = array(); $dsql->SetQuery("Select * From #@__arcrank where rank>10 "); $dsql->Execute(); while($row=$dsql->GetArray()){ $arcranks[$row['rank']] = $row['membername']; } $times = array(); $dsql->SetQuery("Select * From #@__member_time order by mday asc "); $dsql->Execute(); while($row=$dsql->GetArray()){ $times[$row['mday']] = $row['tname']; } require_once(dirname(__FILE__)."/templets/member_type.htm"); ClearAllLink(); ?>