function friendlink_update($linkid, $arr) { $sqladd = array_to_sqladd($arr); $r = db_exec("UPDATE `bbs_friendlink` SET {$sqladd} WHERE linkid='{$linkid}'"); friendlink_list_cache_delete(); return $r; }
function modlog__update($logid, $arr) { $sqladd = array_to_sqladd($arr); return db_exec("UPDATE `bbs_modlog` SET {$sqladd} WHERE logid='{$logid}'"); }
function forum__update($fid, $arr) { $sqladd = array_to_sqladd($arr); return db_exec("UPDATE `bbs_forum` SET {$sqladd} WHERE fid='{$fid}'"); }
function attach__update($aid, $arr) { $sqladd = array_to_sqladd($arr); return db_exec("UPDATE `bbs_attach` SET {$sqladd} WHERE aid='{$aid}'"); }
function ipaccess_update($ip, $arr) { $sqladd = array_to_sqladd($arr); return db_exec("UPDATE `bbs_ipaccess` SET {$sqladd} WHERE ip='{$ip}'"); }
function banip__update($banid, $arr) { $sqladd = array_to_sqladd($arr); return db_exec("UPDATE `bbs_banip` SET {$sqladd} WHERE banid='{$banid}'"); }
function online_replace($arr) { $sqladd = array_to_sqladd($arr); return db_exec("REPLACE INTO `bbs_online` SET {$sqladd}"); }
function user_update($uid, $arr) { $sqladd = array_to_sqladd($arr); return db_exec("UPDATE `test_user` SET {$sqladd} WHERE uid='{$uid}'"); }
echo "upgrade modlog:\r\n"; $modloglist = $olddb->find("SELECT * FROM {$tablepre}modlog"); foreach ($modloglist as $modlog) { $arr = array('logid' => $modlog['logid'], 'uid' => $modlog['uid'], 'tid' => $modlog['tid'], 'pid' => $modlog['pid'], 'subject' => $modlog['subject'], 'comment' => $modlog['comment'], 'create_date' => $modlog['dateline'], 'action' => $modlog['action']); $sqladd = array_to_sqladd($arr); $r = $db->exec("INSERT INTO bbs_modlog SET {$sqladd}"); echo "."; } echo "[ok]\r\n"; unset($modloglist); echo "upgrade friendlink:\r\n"; $linklist = $olddb->find("SELECT * FROM {$tablepre}friendlink"); if ($linklist) { foreach ($linklist as $link) { $arr = array('linkid' => $link['linkid'], 'type' => $link['type'], 'rank' => $link['rank'], 'create_date' => 0, 'name' => $link['sitename'], 'url' => $link['url']); $sqladd = array_to_sqladd($arr); $r = $db->exec("INSERT INTO bbs_friendlink SET {$sqladd}"); echo "."; } } echo "[ok]\r\n"; unset($linklist); echo '<a href="../">升级完成,点击进入论坛。</a>'; function set_new_dir($id, $dirpre) { $filename = "{$id}.png"; $dir = substr(sprintf("%09d", $id), 0, 3); !is_dir($dirpre . $dir) and mkdir($dirpre . $dir, 0777); return $dir . '/'; } function get_old_dir($id)
function post__update($pid, $arr) { $sqladd = array_to_sqladd($arr); return db_exec("UPDATE `bbs_post` SET {$sqladd} WHERE pid='{$pid}'"); }
function thread__update($tid, $arr) { $sqladd = array_to_sqladd($arr); return db_exec("UPDATE `bbs_thread` SET {$sqladd} WHERE tid='{$tid}'"); }
function group__update($gid, $arr) { $sqladd = array_to_sqladd($arr); return db_exec("UPDATE `bbs_group` SET {$sqladd} WHERE gid='{$gid}'"); }
function article__update($articleid, $arr) { $sqladd = array_to_sqladd($arr); return db_exec("UPDATE `bbs_article` SET {$sqladd} WHERE articleid='{$articleid}'"); }