/**
* 获取列表
*/
public function get_list($where = '', $filed = '')
{
$db = DbConnecter::connectMysql('share_story');
$sql = "select * from {$this->table} where {$where}";
$st = $db->query($sql);
$st->setFetchMode(PDO::FETCH_ASSOC);
$r = $st->fetchAll();
if ($filed) {
$arr = array();
foreach ($r as $k => $v) {
$arr[] = $v[$filed];
}
return $arr;
} else {
return $r;
}
}
/**
* 插入记录
*/
public function insert($data = '')
{
if (!$data) {
return 0;
}
$tmp_filed = array();
$tmp_value = array();
foreach ($data as $k => $v) {
$tmp_filed[] .= "`{$k}`";
$tmp_value[] .= "'{$v}'";
}
$tmp_filed = implode(",", $tmp_filed);
$tmp_value = implode(",", $tmp_value);
$db = DbConnecter::connectMysql('share_story');
$sql = "INSERT INTO {$this->table}(\n\t\t\t\t\t{$tmp_filed}\n\t\t\t\t) VALUES({$tmp_value})";
$st = $db->query($sql);
unset($tmp_value, $tmp_filed);
return $db->lastInsertId();
}
public function getMaxUidWithTime($day)
{
$day = $day + 0;
if ($day == 0) {
$day = 1;
}
$db = DbConnecter::connectMysql('share_passport');
$sql = "select * from passport where addtime>? order by uid asc limit 1";
$st = $db->prepare($sql);
$st->execute(array(date('Y-m-d H:i:s', time() - 86400 * $day)));
$maxuid = $st->fetch(PDO::FETCH_COLUMN);
return $maxuid;
}
private function writeDataToDb($uid, $action, $beactionid, $actionid, $ua, $addtime)
{
$actionvalue = $this->actionNameToId($action);
if (is_numeric($addtime)) {
$addtime = date('Y-m-d H:i:s');
}
try {
$db = DbConnecter::connectMysql('share_tips');
$sql = "insert into useractionlog (uid,action,beactionid,actionid,ua,addtime) values (?,?,?,?,?,?)";
$st = $db->prepare($sql);
$st->execute(array($uid, $actionvalue, $beactionid, $actionid, $ua, $addtime));
} catch (Exception $e) {
return false;
}
}
public function setUserNickname($uid, $nickname)
{
$NicknameMd5Obj = new NicknameMd5();
$existnicknameuid = $NicknameMd5Obj->checkNameIsExist($nickname);
if ($existnicknameuid > 0 && $existnicknameuid != $uid) {
$this->setError(ErrorConf::nickNameIsExist());
return false;
} else {
$NicknameMd5Obj->addOne($nickname, $uid);
}
$db = DbConnecter::connectMysql('share_user');
$sql = "update `userinfo` set nickname=? where uid={$uid} ";
$st = $db->prepare($sql);
$st->execute(array($nickname));
$this->clearUserCache($uid);
QueueManager::pushUserInfoToSearch($uid);
// 添加到审核队列
QueueManager::pushAuditTextAction($uid, 1);
QueueManager::pushUserToUpdateUserSysFriendLog($uid);
return true;
}
