May
30
2012
dedecms自动更新一级栏目的排序
dedecms自动更新一级栏目的排序
<?php
require_once (dirname ( __FILE__ ) . '/core/include/common.inc.php');
$dsql = "select * from dede_arctype where topid='0'";
$db->SetQuery ( $dsql );
$db->Execute ();
$i = 1;
while ( $row = $db->GetArray () ) {
$dsql = "update dede_arctype set sortrank='{$i}' where id='{$row['id']}'";
if($db->ExecuteNoneQuery($dsql)){
echo "成功更新ID {$row['id']} {$row['typename']}={$row['sortrank']}<hr/>";
}
else{
echo $dsql.'<hr/>';
}
$i ++;
}
?>
微信扫一扫，打赏作者吧～
最活跃的读者