public function filterArgument($argument, $argumentType, $value)
{
if ($argumentType == 'array') {
return explode(',', $value);
}
return $argumentType == 'int' ? intval($value) : ACloudSysCoreS::sqlEscape($value);
}
public function getForumsByRange($startId, $endId)
{
list($startId, $endId) = array(intval($startId), intval($endId));
if ($startId < 0 || $startId > $endId || $endId < 1) {
return array();
}
$sql = sprintf("SELECT * FROM %s WHERE isshow = 1 AND fid >= %s AND fid <= %s", ACloudSysCoreS::sqlMetadata('{{bbs_forum}}'), ACloudSysCoreS::sqlEscape($startId), ACloudSysCoreS::sqlEscape($endId));
$query = Wind::getComponent('db')->query($sql);
$result = $query->fetchAll(null, PDO::FETCH_ASSOC);
if (!ACloudSysCoreS::isArray($result)) {
return array();
}
return $this->buildForumData($result);
}
public function getIdsFromTable($startId, $endId)
{
list($tableName, $primaryKey) = $this->getPrimaryKeyAndTable();
$result = $tmpResult = array();
$sql = sprintf("SELECT %s FROM %s WHERE %s >= %s AND %s <= %s", ACloudSysCoreS::sqlMetaData($primaryKey), ACloudSysCoreS::sqlMetaData('{{' . $tableName . '}}'), ACloudSysCoreS::sqlMetaData($primaryKey), ACloudSysCoreS::sqlEscape($startId), ACloudSysCoreS::sqlMetaData($primaryKey), ACloudSysCoreS::sqlEscape($endId));
$query = Wind::getComponent('db')->query($sql);
$tmpResult = $query->fetchAll(null, PDO::FETCH_ASSOC);
if (!ACloudSysCoreS::isArray($tmpResult)) {
return array();
}
foreach ($tmpResult as $value) {
$result[] = $value[$primaryKey];
}
return $result;
}
public function buildClause($arrays, $expr = null)
{
if (!is_array($arrays) && !$expr) {
return '';
}
$sets = " SET ";
if ($expr) {
foreach ($expr as $v) {
$sets .= " " . $v . ",";
}
}
if ($arrays) {
foreach ($arrays as $k => $v) {
$sets .= " " . ACloudSysCoreS::sqlMetadata($k) . " = " . ACloudSysCoreS::sqlEscape($v) . ",";
}
}
$sets = trim($sets, ",");
return $sets ? $sets : '';
}
public function getForumsByRange($startId, $endId)
{
list($startId, $endId) = array(intval($startId), intval($endId));
if ($startId < 0 || $startId > $endId || $endId < 1) {
return array();
}
$sql = sprintf("SELECT * FROM %s WHERE isshow = 1 AND fid >= %s AND fid <= %s", ACloudSysCoreS::sqlMetadata('{{bbs_forum}}'), ACloudSysCoreS::sqlEscape($startId), ACloudSysCoreS::sqlEscape($endId));
$query = Wind::getComponent('db')->query($sql);
$result = $query->fetchAll('fid', PDO::FETCH_ASSOC);
$fids = array_keys($result);
$forumDomain = $this->_getDomainDs()->fetchByTypeAndId('forum', $fids);
$data = array();
foreach ($result as $k => $v) {
$v['domain'] = '';
if (isset($forumDomain[$k])) {
$v['domain'] = $forumDomain[$k]['domain'];
}
$data[] = $v;
}
if (!ACloudSysCoreS::isArray($data)) {
return array();
}
return $this->buildForumData($data);
}
public function delete($ekey)
{
return $this->query(sprintf("DELETE FROM %s WHERE ekey = %s", $this->tablename, ACloudSysCoreS::sqlEscape($ekey)));
}
public function getsByAppId($appId)
{
return $this->fetchAll(sprintf("SELECT * FROM %s WHERE app_id = %s ", $this->tablename, ACloudSysCoreS::sqlEscape($appId)));
}
private function getDataByPrimaryKeyRange($tableSetting, $start, $end)
{
$generalDataService = ACloudSysCoreCommon::loadSystemClass('generaldata', 'config.service');
$dataSql = sprintf('SELECT * FROM %s WHERE %s >= %s AND %s <= %s', ACloudSysCoreS::sqlMetadata($tableSetting['name']), ACloudSysCoreS::sqlMetadata($tableSetting['primary_key']), ACloudSysCoreS::sqlEscape($start), ACloudSysCoreS::sqlMetadata($tableSetting['primary_key']), ACloudSysCoreS::sqlEscape($end));
return $generalDataService->executeSql($dataSql);
}
public function deleteSqlLogByTimestamp($startTime, $endTime)
{
return $this->query(sprintf("DELETE FROM %s WHERE created_time >= %s AND created_time <= %s", $this->tablename, ACloudSysCoreS::sqlEscape($startTime), ACloudSysCoreS::sqlEscape($endTime)));
}
public function getUsersByRange($startId, $endId)
{
list($startId, $endId) = array(intval($startId), intval($endId));
if ($startId < 0 || $startId > $endId || $endId < 1) {
return array();
}
$result = $members = array();
$sql = sprintf("SELECT u.* FROM %s u WHERE u.uid >= %s AND u.uid <= %s", ACloudSysCoreS::sqlMetadata('{{user}}'), ACloudSysCoreS::sqlEscape($startId), ACloudSysCoreS::sqlEscape($endId));
$query = Wind::getComponent('db')->query($sql);
$result = $query->fetchAll('uid', PDO::FETCH_ASSOC);
if (!ACloudSysCoreS::isArray($result)) {
return array();
}
$query = Wind::getComponent('db')->query(sprintf("SELECT ud.* FROM %s ud WHERE ud.uid >= %s AND ud.uid <= %s", ACloudSysCoreS::sqlMetadata('{{user_data}}'), ACloudSysCoreS::sqlEscape($startId), ACloudSysCoreS::sqlEscape($endId)));
$userData = $query->fetchAll('uid', PDO::FETCH_ASSOC);
$query = Wind::getComponent('db')->query(sprintf("SELECT ui.* FROM %s ui WHERE ui.uid >= %s AND ui.uid <= %s", ACloudSysCoreS::sqlMetadata('{{user_info}}'), ACloudSysCoreS::sqlEscape($startId), ACloudSysCoreS::sqlEscape($endId)));
$userInfo = $query->fetchAll('uid', PDO::FETCH_ASSOC);
foreach ($result as $key => $value) {
$result[$key] = array_merge($value, $userData[$value['uid']], $userInfo[$value['uid']]);
}
$siteUrl = ACloudSysCoreCommon::getGlobal('g_siteurl', $_SERVER['SERVER_NAME']);
foreach ($result as $member) {
$member['memberurl'] = 'http://' . $siteUrl . '/index.php?m=space&uid=' . $member['uid'];
$member['icon'] = Pw::getAvatar($member['uid']);
$members[$member['uid']] = $member;
}
return $this->filterMemberFields($members);
}
public function getThreadsByModifiedTime($startTime, $endTime, $page, $perpage)
{
list($startTime, $endTime, $page, $perpage) = array(intval($startTime), intval($endTime), intval($page), intval($perpage));
if ($startTime < 1 || $endTime < 1 || $startTime > $endTime || $page < 1 || $perpage < 1) {
return array();
}
$offset = ($page - 1) * $perpage;
$sql = sprintf("SELECT t.* FROM %s t WHERE t.fid != 0 AND t.ischeck = 1 AND t.modified_time >= %s AND t.modified_time <= %s %s", ACloudSysCoreS::sqlMetadata('{{bbs_threads}}'), ACloudSysCoreS::sqlEscape($startTime), ACloudSysCoreS::sqlEscape($endTime), ACloudSysCoreS::sqlLimit($offset, $perpage));
$query = Wind::getComponent('db')->query($sql);
$result = $query->fetchAll(null, PDO::FETCH_ASSOC);
if (!ACloudSysCoreS::isArray($result)) {
return array();
}
$result = $this->getContentAndForumInfo($result);
return $this->_buildThreadData($result);
}
public function get($name)
{
return $this->fetchOne(sprintf("SELECT * FROM %s WHERE name = %s", $this->tablename, ACloudSysCoreS::sqlEscape($name)));
}
