VB系统编程 - VB源码,VB技术文章,二级VB教程,API函数手册,VB脚本手册,.NET图书

cachelist = $cachelist; $discuz->init_cron = false; $discuz->init_setting = true; $discuz->init_user = false; $discuz->init_session = false; $discuz->init(); require_once DISCUZ_ROOT . './api/manyou/Manyou.php'; class My extends Manyou { function onSiteGetAllUsers($from, $userNum, $friendNum = 2000, $isExtra) { $totalNum = getcount('common_member', ''); $sql = 'SELECT s.* FROM %s s ORDER BY s.uid LIMIT %d, %d'; $sql = sprintf($sql, DB::table('common_member'), $from, $userNum); $query = DB::query($sql); $spaces = $uIds = array(); while($row = DB::fetch($query)) { $spaces[$row['uid']] = $row; $uIds[] = $row['uid']; } $users = $this->getUsers($uIds, $spaces, true, $isExtra, true, $friendNum, true); $result = array('totalNum' => $totalNum, 'users' => $users ); return $result; } function onSiteGetUpdatedUsers($num) { $totalNum = getcount('common_member_log', ''); $users = array(); if ($totalNum) { $sql = sprintf('SELECT uid, action FROM %s ORDER BY dateline LIMIT %d', DB::table('common_member_log'), $num); $query = DB::query($sql); $deletedUsers = $userLogs = $uIds = array(); $undeletedUserIds = array(); while($row = DB::fetch($query)) { $uIds[] = $row['uid']; if ($row['action'] == 'delete') { $deletedUsers[] = array('uId' => $row['uid'], 'action' => $row['action'], ); } else { $undeletedUserIds[] = $row['uid']; } $userLogs[$row['uid']] = $row; } $updatedUsers = $this->getUsers($undeletedUserIds, false, true, true, false); foreach($updatedUsers as $k => $v) { $updatedUsers[$k]['action'] = $userLogs[$v['uId']]['action']; $updatedUsers[$k]['updateType'] = 'all'; } $users = array_merge($updatedUsers, $deletedUsers); if ($uIds) { $sql = sprintf('DELETE FROM %s WHERE uid IN (%s)', DB::table('common_member_log'), dimplode($uIds)); DB::query($sql); } } $result = array('totalNum' => $totalNum, 'users' => $users); return $result; } function onSiteGetUpdatedFriends($num) { $friends = array(); $totalNum = getcount('home_friendlog', ''); if ($totalNum) { $sql = sprintf('SELECT * FROM %s ORDER BY dateline LIMIT %d', DB::table('home_friendlog'), $num); $query = DB::query($sql); while ($friend = DB::fetch($query)) { $friends[] = array('uId' => $friend['uid'], 'uId2' => $friend['fuid'], 'action' => $friend['action'] ); $sql = sprintf('DELETE FROM %s WHERE uid = %d AND fuid = %d', DB::table('home_friendlog'), $friend['uid'], $friend['fuid']); DB::query($sql); } } $result = array('totalNum' => $totalNum, 'friends' => $friends ); return $result; } function onSiteGetStat($beginDate = null, $num = null, $orderType = 'ASC') { $sql = 'SELECT * FROM ' . DB::table('common_stat'); if ($beginDate) { $sql .= sprintf(' WHERE daytime >= %d', $beginDate); } $sql .= " ORDER BY daytime $orderType"; if ($num) { $sql .= " LIMIT $num "; } $query = DB::query($sql); $result = array(); $fields = array('login' => 'loginUserNum', 'doing' => 'doingNum', 'blog' => 'blogNum', 'pic' => 'photoNum', 'poll' => 'pollNum', 'event' => 'eventNum', 'share' => 'shareNum', 'thread' => 'threadNum', 'docomment' => 'doingCommentNum', 'blogcomment' => 'blogCommentNum', 'piccomment' => 'photoCommentNum', 'pollcomment' => 'pollCommentNum', 'eventcomment' => 'eventCommentNum', 'sharecomment' => 'shareCommentNum', 'pollvote' => 'pollUserNum', 'eventjoin' => 'eventUserNum', 'post' => 'postNum', 'wall' => 'wallNum', 'poke' => 'pokeNum', 'click' => 'clickNum', ); while($row = DB::fetch($query)) { $stat = array('date' => $row['daytime']); foreach($row as $k => $v) { if (array_key_exists($k, $fields)) { $stat[$fields[$k]] = $v; } } $result[] = $stat; } return $result; } function onUsersGetInfo($uIds, $fields = array(), $isExtra = false) { $users = $this->getUsers($uIds, false, true, $isExtra, false); $result = array(); if ($users) { if ($fields) { foreach($users as $key => $user) { foreach($user as $k => $v) { if (in_array($k, $fields)) { $result[$key][$k] = $v; } } } } } if (!$result) { $result = $users; } return $result; } function onUsersGetFriendInfo($uId, $num = MY_FRIEND_NUM_LIMIT, $isExtra = false) { $users = $this->getUsers(array($uId), false, true, $isExtra, true, $num, false, true); $where = array('uid' => $uId); $totalNum = getcount('home_friend', $where); $friends = $users[0]['friends']; unset($users[0]['friends']); $result = array('totalNum' => $totalNum, 'friends' => $friends, 'me' => $users[0], ); return $result; } function onUsersGetExtraInfo($uIds) { $result = $this->getExtraByUsers($uIds); return $result; } function onUsersGetFormHash($uId, $userAgent) { global $_G; $uId = intval($uId); if (!$uId) { return false; } $sql = sprintf('SELECT * FROM %s WHERE uid = %s', DB::table('common_member'), $uId); $member = DB::fetch_first($sql); $_G['username'] = $member['username']; $_G['uid'] = $member['uid']; $_G['authkey'] = md5($_G['config']['security']['authkey'] . $userAgent); return formhash(); } function onFriendsGet($uIds, $friendNum = MY_FRIEND_NUM_LIMIT) { $result = array(); if ($uIds) { foreach($uIds as $uId) { $result[$uId] = $this->_getFriends($uId, $friendNum); } } return $result; } function onFriendsAreFriends($uId1, $uId2) { $query = DB::query("SELECT uid FROM ".DB::table('home_friend')." WHERE uid='$uId1' AND fuid='$uId2'"); $result = false; if($friend = DB::fetch($query)) { $result = true; } return $result; } function onUserApplicationAdd($uId, $appId, $appName, $privacy, $allowSideNav, $allowFeed, $allowProfileLink, $defaultBoxType, $defaultMYML, $defaultProfileLink, $version, $displayMethod, $displayOrder = null, $userPanelArea = null, $canvasTitle = null, $isFullscreen = null , $displayUserPanel = null, $additionalStatus = null) { global $_G; $res = $this->getUserSpace($uId); if (!$res) { return new ErrorResponse('1', "User($uId) Not Exists"); } $sql = sprintf('SELECT appid FROM %s WHERE uid = %d AND appid = %d', DB::table('home_userapp'), $uId, $appId); $query = DB::query($sql); $row = DB::fetch($query); if ($row['appid']) { $errCode = '170'; $errMessage = 'Application has been already added'; return new ErrorResponse($errCode, $errMessage); } switch($privacy) { case 'public': $privacy = 0; break; case 'friends': $privacy = 1; break; case 'me': $privacy = 3; break; case 'none': $privacy = 5; break; default: $privacy = 0; } $narrow = ($defaultBoxType == 'narrow') ? 1 : 0; $setarr = array('uid' => $uId, 'appid' => $appId, 'appname' => $appName, 'privacy' => $privacy, 'allowsidenav' => $allowSideNav, 'allowfeed' => $allowFeed, 'allowprofilelink' => $allowProfileLink, 'narrow' => $narrow ); if ($displayOrder !== null) { $setarr['displayorder'] = $displayOrder; } $maxMenuOrder = DB::result_first("SELECT MAX(menuorder) FROM ".DB::table('home_userapp')." WHERE uid='$uId'"); $setarr['menuorder'] = ++$maxMenuOrder; DB::insert('home_userapp', $setarr); $fields = array('uid' => $uId, 'appid' => $appId, 'profilelink' => $defaultProfileLink, 'myml' => $defaultMYML ); $result = DB::insert('home_userappfield', $fields, 1); updatecreditbyaction('installapp', $uId, array(), $appId); require_once libfile('function/cache'); updatecache('userapp'); DB::query("UPDATE ".DB::table('common_member_status')." SET lastactivity='$_G[timestamp]' WHERE uid='$uId'"); $displayMethod = ($displayMethod == 'iframe') ? 1 : 0; $this->refreshApplication($appId, $appName, $version, $userPanelArea, $canvasTitle, $isFullscreen, $displayUserPanel, $displayMethod, $narrow, null, null, $additionalStatus); return 1; } function onUserApplicationRemove($uId, $appIds) { $sql = sprintf('DELETE FROM %s WHERE uid = %d AND appid IN (%s)', DB::table('home_userapp'), $uId, dimplode($appIds)); $res = DB::query($sql); $result = DB::affected_rows(); $sql = sprintf('DELETE FROM %s WHERE uid = %d AND appid IN (%s)', DB::table('home_userappfield'), $uId, dimplode($appIds)); $res = DB::query($sql); updatecreditbyaction('installapp', $uId, array(), $appId, -1); require_once libfile('function/cache'); updatecache('userapp'); return $result; } function onUserApplicationUpdate($uId, $appIds, $appName, $privacy, $allowSideNav, $allowFeed, $allowProfileLink, $version, $displayMethod, $displayOrder = null, $userPanelArea = null, $canvasTitle = null, $isFullscreen = null, $displayUserPanel = null) { switch($privacy) { case 'public': $privacy = 0; break; case 'friends': $privacy = 1; break; case 'me': $privacy = 3; break; case 'none': $privacy = 5; break; default: $privacy = 0; } $where = sprintf('uid = %d AND appid IN (%s)', $uId, dimplode($appIds)); $setarr = array( 'appname' => $appName, 'privacy' => $privacy, 'allowsidenav' => $allowSideNav, 'allowfeed' => $allowFeed, 'allowprofilelink' => $allowProfileLink ); if ($displayOrder !== null) { $setarr['displayorder'] = $displayOrder; } DB::update('home_userapp', $setarr, $where); $result = DB::affected_rows(); $displayMethod = ($displayMethod == 'iframe') ? 1 : 0; if (is_array($appIds)) { foreach($appIds as $appId) { $this->refreshApplication($appId, $appName, $version, $userPanelArea, $canvasTitle, $isFullscreen, $displayUserPanel, $displayMethod, null, null, null, null); } } return $result; } function onUserApplicationGetInstalled($uId) { $sql = sprintf('SELECT appid FROM %s WHERE uid = %d', DB::table('home_userapp'), $uId); $query = DB::query($sql); $result = array(); while ($userApp = DB::fetch($query)) { $result[] = $userApp['appid']; } return $result; } function onUserApplicationGet($uId, $appIds) { $sql = sprintf('SELECT * FROM %s WHERE uid = %d AND appid IN (%s)', DB::table('home_userapp'), $uId, dimplode($appIds)); $query = DB::query($sql); $result = array(); while($userApp = DB::fetch($query)) { switch($userApp['privacy']) { case 0: $privacy = 'public'; break; case 1: $privacy = 'friends'; break; case 3: $privacy = 'me'; break; case 5: $privacy = 'none'; break; default: $privacy = 'public'; } $result[] = array( 'appId' => $userApp['appid'], 'privacy' => $privacy, 'allowSideNav' => $userApp['allowsidenav'], 'allowFeed' => $userApp['allowfeed'], 'allowProfileLink' => $userApp['allowprofilelink'], 'displayOrder' => $userApp['displayorder'] ); } return $result; } function onFeedPublishTemplatizedAction($uId, $appId, $titleTemplate, $titleData, $bodyTemplate, $bodyData, $bodyGeneral = '', $image1 = '', $image1Link = '', $image2 = '', $image2Link = '', $image3 = '', $image3Link = '', $image4 = '', $image4Link = '', $targetIds = '', $privacy = '', $hashTemplate = '', $hashData = '', $specialAppid=0) { $res = $this->getUserSpace($uId); if (!$res) { return new ErrorResponse('1', "Uv class="hidden_news_content" id="news_content_12">在文本框中实现由加减号输入数据下面的例子以输入日期为例，向你演示如何用加号或减号来向文本框中输入数据。本例的关键是使用VB的DateAdd()函数。该函数允许你加减日期、月份及年。代码创建一个新工程在窗体中添加...

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

[阅读全文]

栏目导航

本类热门