/**
* 格式化用户信息输出
**/
public function formatUserInfo(&$userinfo)
{
$ainfo = Core_User::getUserOtherInfo();
$userinfo['star'] = $ainfo['star'][intval($userinfo['star'])];
$userinfo['blood'] = $ainfo['blood'][intval($userinfo['blood'])];
$userinfo['perfession'] = $ainfo['star'][intval($userinfo['perfession'])];
$userinfo['money'] = $ainfo['money'][intval($userinfo['money'])];
$userinfo['part'] = $ainfo['part'][intval($userinfo['part'])];
$userinfo['marry'] = $ainfo['marry'][intval($userinfo['marry'])];
$userinfo['interest'] = $ainfo['interest'][intval($userinfo['interest'])];
$userinfo['style'] = $ainfo['style'][intval($userinfo['style'])];
$userinfo['province'] = $ainfo['province'][intval($userinfo['province'])];
}
public function init()
{
$this->initdb();
if (!isset($this->reqs->uname)) {
die('TODO EXCEPTION:' . __FILE__ . ':' . __LINE__);
}
$uid = Core_User::name2id($this->reqs->uname);
// Profile
$dbup = Core_Dao::factory(array('name' => 'user_profile'));
$item = $dbup->getByID($uid);
if (!isset($item['id'])) {
die('TODO EXCEPTION:' . __FILE__ . ':' . __LINE__);
}
$this->user = new Core_Object();
$this->user->profile = $item;
// Products
$dbua = Core_Dao::factory(array('name' => 'user_apps'));
$where = array('uid' => $uid, 'isfrontend' => 1);
$items = $dbua->getList($where, array(), 100);
if (count($items) == 0) {
die('TODO EXCEPTION:' . __FILE__ . ':' . __LINE__);
}
$this->user->apps = $items;
}
public function debugAction()
{
try {
if (isset($GLOBALS['config']['database2'])) {
$dbsrc = Zend_Db::factory($GLOBALS['config']['database2']['adapter'], $GLOBALS['config']['database2']['params']);
} else {
throw new Exception('Can not connect to db-server');
}
} catch (Exception $e) {
$e->getMessage();
}
$dbentry = Core_Dao::factory(array('name' => 'data_entry'));
$dbtermuser = Core_Dao::factory(array('name' => 'taxonomy_term_user'));
$db = $dbentry->getAdapter();
$rs = $dbsrc->query("SELECT a.*,u.username from kit_node a,kit_user u WHERE a.userid = u.userid ORDER BY nodeid LIMIT 99999")->fetchAll();
foreach ($rs as $val) {
$uid = Core_User::name2id($val['username']);
$set = array('id' => $val['nodeid'], 'uid' => $uid, 'uname' => $val['username'], 'cat' => $val['treeid'], 'type' => $val['module'], 'status' => $val['status'], 'title' => $val['title'], 'terms' => $val['terms'], 'created' => $val['created'], 'updated' => $val['modified'], 'published' => $val['created']);
$dbentry->insert($set);
}
$rs = $dbsrc->query("SELECT * from kit_node_revision ORDER BY nodeid LIMIT 99999")->fetchAll();
$counter = 0;
foreach ($rs as $val) {
$str = @mb_convert_encoding($val['body'], 'UTF-8', mb_detect_encoding($val['body'], "auto", TRUE));
if ($str === FALSE || $str === NULL || $str == "") {
$counter++;
}
if (strlen(time($str)) < 10) {
$counter++;
}
$set = array('summary' => $val['summary'], 'content' => $str);
try {
$dbentry->update($set, array('id' => $val['nodeid']));
} catch (Exception $e) {
$counter++;
}
}
echo $counter;
$dbtype = Core_Dao::factory(array('name' => 'data_type'));
$rs = $dbsrc->query("SELECT * from kit_system_module ORDER BY moduleid LIMIT 99999")->fetchAll();
foreach ($rs as $val) {
$title = @mb_convert_encoding($val['name'], 'UTF-8', mb_detect_encoding($val['name'], "auto", TRUE));
$description = @mb_convert_encoding($val['description'], 'UTF-8', mb_detect_encoding($val['description'], "auto", TRUE));
$set = array('id' => $val['submodule'], 'title' => $title, 'summary' => $description, 'created' => $val['created'], 'updated' => $val['modified'], 'isfrontend' => $val['isfrontend'], 'isbackend' => $val['isbackend'], 'isenabled' => $val['isenabled'], 'isuserenabled' => $val['isuserenabled'], 'isrequired' => $val['isrequired']);
$dbtype->insert($set);
}
$rs = $dbsrc->query("SELECT a.*,u.username from kit_node_tree a,kit_user u WHERE a.userid = u.userid ORDER BY treeid LIMIT 99999")->fetchAll();
$counter = 0;
foreach ($rs as $val) {
$str = @mb_convert_encoding($val['name'], 'UTF-8', mb_detect_encoding($val['name'], "auto", TRUE));
$uid = Core_User::name2id($val['username']);
$set = array('id' => $val['treeid'], 'uid' => $uid, 'pid' => $val['parentid'], 'title' => $str, 'created' => $val['created'], 'updated' => $val['modified'], 'weight' => $val['ordering'], 'app' => $val['module']);
try {
$dbtermuser->insert($set);
} catch (Exception $e) {
$counter++;
}
}
echo $counter;
$dbuser = Core_Dao::factory(array('name' => 'user'));
$dbuserp = Core_Dao::factory(array('name' => 'user_profile'));
$rs = $dbsrc->query("SELECT * from kit_user ORDER BY userid LIMIT 99999")->fetchAll();
foreach ($rs as $val) {
$name = @mb_convert_encoding($val['name'], 'UTF-8', mb_detect_encoding($val['name'], "auto", TRUE));
$content = @mb_convert_encoding($val['aboutme'], 'UTF-8', mb_detect_encoding($val['aboutme'], "auto", TRUE));
$home_name = @mb_convert_encoding($val['home_name'], 'UTF-8', mb_detect_encoding($val['home_name'], "auto", TRUE));
$uid = Core_User::name2id($val['username']);
$set = array('id' => $uid, 'uname' => $val['username'], 'pass' => $val['password'], 'email' => $val['email'], 'name' => $name, 'created' => $val['created'], 'updated' => $val['modified']);
$dbuser->insert($set);
$set = array('id' => $uid, 'gender' => $val['gender'], 'birthday' => $val['birthday'], 'name' => $name, 'address' => $val['address'], 'content' => $content, 'uname' => $val['username'], 'home_name' => $home_name, 'created' => $val['created'], 'updated' => $val['modified']);
$dbuserp->insert($set);
}
$dbusera = Core_Dao::factory(array('name' => 'user_apps'));
$rs = $dbsrc->query("SELECT a.*,u.username from kit_user_module a,kit_user u WHERE a.userid = u.userid ORDER BY id LIMIT 99999")->fetchAll();
foreach ($rs as $val) {
$uid = Core_User::name2id($val['username']);
$set = array('id' => $val['id'], 'uid' => $uid, 'app' => $val['submodule'], 'title' => $val['name'], 'isfrontend' => $val['isfrontend'], 'isbackend' => $val['isbackend'], 'isenabled' => $val['isenabled'], 'created' => $val['created'], 'updated' => $val['modified']);
$dbusera->insert($set);
}
}
