public static function deleteByTidUid($tid, $uid)
{
return DbUtils::getDzDbUtils(true)->query('
DELETE FROM %t
WHERE tid=%s AND uid=%s
', array('forum_activityapply', $tid, $uid));
}
public static function getAllowVisitGids()
{
return DbUtils::getDzDbUtils(true)->queryColumn('
SELECT groupid
FROM %t
WHERE allowvisit>0', array('common_usergroup'));
}
public static function getActivityInvite()
{
return DbUtils::getDzDbUtils(true)->queryAll('
SELECT *
FROM %t
', array('appbyme_activity'));
}
public static function updateApplyNumberByTid($tid)
{
return DbUtils::getDzDbUtils(true)->query('
UPDATE %t
SET applynumber=%d
WHERE tid=%d
', array('forum_activity', DzForumActivityApply::getCountByTid($tid), $tid));
}
private function _getQQinfoByOpenId($openId)
{
return DbUtils::getDzDbUtils(true)->queryRow('
SELECT *
FROM %t
WHERE conopenid=%s
', array('common_member_connect', $openId));
}
public static function getTidByPid($pid)
{
return DbUtils::getDzDbUtils(true)->queryScalar('
SELECT tid
FROM %t
WHERE pid = %d
', array('forum_post', $pid));
}
public static function getSupportTopicCount($tid)
{
return DbUtils::getDzDbUtils(true)->queryScalar('
SELECT recommend_add
FROM %t
WHERE tid = %d
', array('forum_thread', $tid));
}
public static function getModuleParam($mid)
{
return DbUtils::getDzDbUtils(true)->queryScalar('
SELECT param
FROM %t
WHERE mid=%d
', array('appbyme_portal_module', $mid));
}
public static function getAnnouncementByUid($uid)
{
return DbUtils::getDzDbUtils(true)->queryRow('
SELECT *
FROM %t
WHERE id = %d
', array('forum_announcement', $uid));
}
public static function updateReadStatus($uid)
{
DbUtils::getDzDbUtils(true)->query('
UPDATE %t
SET new=0
WHERE uid=%d AND new=1
', array('home_notification', $uid));
}
public static function getInfoByAuthorid($authorid)
{
return DbUtils::getDzDbUtils(true)->queryRow('
SELECT *
FROM %t
WHERE uid=%d
', array('common_member', $authorid));
}
protected function generateDependentData()
{
if ($this->sql != '') {
return DbUtils::getDzDbUtils(true)->queryRow($this->sql, $this->params);
} else {
throw new CException(Yii::t('yii', 'CDbCacheDependency.sql cannot be empty.'));
}
}
public static function getUserDeviceToken($uid)
{
return (string) DbUtils::getDzDbUtils(true)->queryScalar('
SELECT uvalue
FROM %t
WHERE uid=%d
AND ukey=%s
', array('appbyme_user_setting', $uid, self::KEY_DEVICE_TOKEN));
}
public static function getAPNsCertfilePassword()
{
$data = DbUtils::getDzDbUtils(true)->queryScalar('
SELECT cvalue
FROM %t
WHERE ckey = %s
', array('appbyme_config', 'certfile_apns_passphrase'));
return (string) base64_decode($data);
}
public static function getAlbumListCount($uid)
{
$count = DbUtils::getDzDbUtils(true)->queryScalar('
SELECT COUNT(*) as num
FROM %t
WHERE uid = %d
', array('home_album', $uid));
return $count + 1;
}
public static function getCountByTid($tid, $params)
{
$authorSql = isset($params['authorId']) && $params['authorId'] != 0 ? 'AND authorid=' . $params['authorId'] : '';
$sql = '
SELECT COUNT(*)
FROM %t
WHERE tid=%d AND first!=%d AND invisible>=%d ' . $authorSql;
return (int) DbUtils::getDzDbUtils(true)->queryScalar($sql, array(self::getTableName($tid), $tid, 1, 0));
}
public static function getUserBindInfo($uid, $type = self::WECHAT_TYPE)
{
return DbUtils::getDzDbUtils(true)->queryRow('
SELECT *
FROM %t
WHERE uid=%d
AND type=%d
', array('appbyme_connection', $uid, $type));
}
public static function getCommentById($id)
{
return DbUtils::getDzDbUtils(true)->queryRow('
SELECT *
FROM %t
WHERE cid=%d
LIMIT 1
', array('portal_comment', $id));
}
public static function isDsuPaulsignAvailable()
{
$count = (int) DbUtils::getDzDbUtils(true)->queryScalar('
SELECT COUNT(*)
FROM %t
WHERE identifier=%s
AND available=%d
', array('common_plugin', 'dsu_paulsign', 1));
return $count > 0;
}
private function _getNotifyInfo($uid, $type)
{
$data = DbUtils::getDzDbUtils(true)->queryAll('
SELECT *
FROM %t
WHERE uid=%d AND type=%s AND new=%d
ORDER BY dateline DESC
', array('home_notification', $uid, $type, 1));
$info = array('count' => count($data), 'time' => !empty($data) ? $data[0]['dateline'] . '000' : "0");
return $info;
}
private function _saveUserLocation($uid, $longitude, $latitude, $location)
{
// 插入用户定位开关设置
$count = (int) DbUtils::getDzDbUtils(true)->queryScalar('
SELECT COUNT(*)
FROM %t
WHERE uid=%d
AND ukey=%s
', array('appbyme_user_setting', $uid, AppbymeUserSetting::KEY_GPS_LOCATION));
if (!$count) {
AppbymeUserSetting::saveNewSettings($uid, array(AppbymeUserSetting::KEY_GPS_LOCATION => AppbymeUserSetting::VALUE_GPS_LOCATION_ON));
}
!empty($location) && SurroundingInfo::saveUserLocation($uid, $longitude, $latitude, $location);
}
public function actionPluginConfig()
{
$appbymeAppConfig = WebUtils::getDzPluginAppbymeAppConfig();
$appbymeApp = DbUtils::getDzDbUtils(true)->queryRow('
SELECT *
FROM %t
WHERE identifier=%s
', array('common_plugin', MOBCENT_DZ_PLUGIN_ID));
$unserializeKeys = array('cache_usergroup', 'forum_announcement_show', 'forum_show', 'forum_show_image', 'forum_photo_show');
foreach ($unserializeKeys as $key => $value) {
$appbymeAppConfig[$value] = unserialize($appbymeAppConfig[$value]);
}
$config = array_merge(array('appbyme_app_info' => $appbymeApp), array('appbyme_app_config' => $appbymeAppConfig));
debug($config);
// echo WebUtils::jsonEncode($config);
}
public static function getArticleCountByAid($aid)
{
return DbUtils::getDzDbUtils(true)->queryRow('
SELECT *
FROM %t
WHERE aid=%d
', array('portal_article_count', $aid));
}
private function _getUidsByGid($gid)
{
$gids = $this->_getGids($gid);
$uids = DbUtils::getDzDbUtils(true)->queryColumn('
SELECT uid
FROM %t
WHERE groupid IN (%n)
GROUP BY groupid
', array('common_member', $gids));
$uids[] = 0;
return $uids;
}
public static function updateActivityInvite($activityId, $data)
{
return DbUtils::getDzDbUtils(true)->update('appbyme_activity_invite', $data, array('activity_id' => $activityId));
}
public static function getUserFavorite($uid, $idtype = 'fid')
{
$result = DbUtils::getDzDbUtils(true)->queryAll('
SELECT id
FROM %t
WHERE uid=%d
AND idtype=%s
', array('home_favorite', $uid, $idtype));
$favoriteids = array();
foreach ($result as $res) {
$favoriteids[] = $res['id'];
}
return $favoriteids;
}
public static function getPostCount($uid)
{
return DbUtils::getDzDbUtils(true)->queryAll('
SELECT count(*) as nums
FROM %t
WHERE uid = %d
', array('home_album', $uid));
}
public static function delUserAccess($userId)
{
return DbUtils::getDzDbUtils(true)->delete('appbyme_user_access', array('user_id' => $userId));
}
public static function getUserSettingInfo($uid, $followUid)
{
return DbUtils::getDzDbUtils(true)->queryRow('
SELECT *
FROM %t
WHERE uid = %d AND followuid = %d
', array('home_follow', $uid, $followUid));
}
/**
* 获取主题封面
*
* @param int $tid
*/
public static function getTopicCover($tid)
{
$image = '';
$topicImage = DbUtils::getDzDbUtils(true)->queryRow('
SELECT *
FROM %t
WHERE tid=%d
', array('forum_threadimage', $tid));
if (!empty($topicImage)) {
require_once DISCUZ_ROOT . './source/function/function_home.php';
$image = pic_get($topicImage['attachment'], 'forum', 0, $topicImage['remote']);
}
return WebUtils::getHttpFileName($image);
}
