@@ -11,7 +11,8 @@ |
||
| 11 | 11 | */ |
| 12 | 12 | namespace PH7; |
| 13 | 13 | |
| 14 | -use PH7\Framework\Mvc\Model\Engine\Db, PH7\Framework\Mvc\Model\Engine\Util\Various; |
|
| 14 | +use PH7\Framework\Mvc\Model\Engine\Db; |
|
| 15 | +use PH7\Framework\Mvc\Model\Engine\Util\Various; |
|
| 15 | 16 | |
| 16 | 17 | class ExistsCoreModel extends Framework\Mvc\Model\Engine\Model |
| 17 | 18 | { |
@@ -18,6 +18,11 @@ discard block |
||
| 18 | 18 | UPDATED = 'updatedDate DESC', |
| 19 | 19 | NAME = 'name ASC'; |
| 20 | 20 | |
| 21 | + /** |
|
| 22 | + * @param string $iForumId |
|
| 23 | + * @param integer $iOffset |
|
| 24 | + * @param integer $iLimit |
|
| 25 | + */ |
|
| 21 | 26 | public function getForum($iForumId = null, $iOffset = null, $iLimit = null, $sOrder = self::NAME) |
| 22 | 27 | { |
| 23 | 28 | $bIsLimit = isset($iOffset, $iLimit); |
@@ -36,6 +41,13 @@ discard block |
||
| 36 | 41 | return (!empty($iForumId)) ? $rStmt->fetch(\PDO::FETCH_OBJ) : $rStmt->fetchAll(\PDO::FETCH_OBJ); |
| 37 | 42 | } |
| 38 | 43 | |
| 44 | + /** |
|
| 45 | + * @param string $iMessageId |
|
| 46 | + * @param string $iProfileId |
|
| 47 | + * @param integer $iApproved |
|
| 48 | + * @param integer $iOffset |
|
| 49 | + * @param integer $iLimit |
|
| 50 | + */ |
|
| 39 | 51 | public function getMessage($iTopicId, $iMessageId = null, $iProfileId = null, $iApproved, $iOffset, $iLimit, $sSort = Db::ASC) |
| 40 | 52 | { |
| 41 | 53 | $iOffset = (int) $iOffset; |
@@ -14,6 +14,12 @@ |
||
| 14 | 14 | |
| 15 | 15 | const CACHE_GROUP = 'db/sys/mod/game', CACHE_TIME = 93312000; |
| 16 | 16 | |
| 17 | + /** |
|
| 18 | + * @param string $sTitle |
|
| 19 | + * @param string $iGameId |
|
| 20 | + * @param integer $iOffset |
|
| 21 | + * @param integer $iLimit |
|
| 22 | + */ |
|
| 17 | 23 | public function get($sTitle = null, $iGameId = null, $iOffset, $iLimit, $sOrder = SearchCoreModel::NAME) |
| 18 | 24 | { |
| 19 | 25 | $iOffset = (int) $iOffset; |
@@ -15,6 +15,9 @@ discard block |
||
| 15 | 15 | |
| 16 | 16 | const CACHE_GROUP = 'db/sys/core/like'; |
| 17 | 17 | |
| 18 | + /** |
|
| 19 | + * @param string $sKey |
|
| 20 | + */ |
|
| 18 | 21 | public function select($sKey) |
| 19 | 22 | { |
| 20 | 23 | $this->cache->start(self::CACHE_GROUP, 'select' . $sKey, 3600*168); |
@@ -32,6 +35,9 @@ discard block |
||
| 32 | 35 | return $oData; |
| 33 | 36 | } |
| 34 | 37 | |
| 38 | + /** |
|
| 39 | + * @param string $sKey |
|
| 40 | + */ |
|
| 35 | 41 | public function update($sKey, $fLastIp) |
| 36 | 42 | { |
| 37 | 43 | $rStmt = Db::getInstance()->prepare('UPDATE' . Db::prefix('Likes') . 'SET votes = votes + 1 , lastVote = NOW() , lastIp =:lastIp WHERE keyId =:key'); |
@@ -40,6 +46,10 @@ discard block |
||
| 40 | 46 | return $rStmt->execute(); |
| 41 | 47 | } |
| 42 | 48 | |
| 49 | + /** |
|
| 50 | + * @param string $sKey |
|
| 51 | + * @param string $fLastIp |
|
| 52 | + */ |
|
| 43 | 53 | public function insert($sKey, $fLastIp) |
| 44 | 54 | { |
| 45 | 55 | $rStmt = Db::getInstance()->prepare('INSERT INTO' . Db::prefix('Likes') . 'SET keyId =:key ,votes=1 , lastVote = NOW(), lastIp =:lastIp'); |
@@ -13,6 +13,9 @@ |
||
| 13 | 13 | class MailCoreModel extends Framework\Mvc\Model\Engine\Model |
| 14 | 14 | { |
| 15 | 15 | |
| 16 | + /** |
|
| 17 | + * @param string $iProfileId |
|
| 18 | + */ |
|
| 16 | 19 | public static function countUnreadMsg($iProfileId) |
| 17 | 20 | { |
| 18 | 21 | $rStmt = Db::getInstance()->prepare('SELECT COUNT(status) AS unread FROM' . Db::prefix('Messages') . 'WHERE recipient = :recipient AND status = \'1\' AND NOT FIND_IN_SET(\'recipient\', toDelete)'); |
@@ -18,6 +18,12 @@ |
||
| 18 | 18 | CREATED = 'createdDate', |
| 19 | 19 | UPDATED = 'updatedDate'; |
| 20 | 20 | |
| 21 | + /** |
|
| 22 | + * @param string $iProfileId |
|
| 23 | + * @param string $iAlbumId |
|
| 24 | + * @param integer $iOffset |
|
| 25 | + * @param integer $iLimit |
|
| 26 | + */ |
|
| 21 | 27 | public function album($iProfileId = null, $iAlbumId = null, $iApproved = 1, $iOffset, $iLimit, $sOrder = self::CREATED) |
| 22 | 28 | { |
| 23 | 29 | $this->cache->start(self::CACHE_GROUP, 'album' . $iProfileId . $iAlbumId . $iApproved . $iOffset . $iLimit . $sOrder, static::CACHE_TIME); |
@@ -15,6 +15,10 @@ discard block |
||
| 15 | 15 | |
| 16 | 16 | const CACHE_GROUP = 'db/sys/core/rating', CACHE_TIME = 604800; |
| 17 | 17 | |
| 18 | + /** |
|
| 19 | + * @param integer $iId |
|
| 20 | + * @param string $sTable |
|
| 21 | + */ |
|
| 18 | 22 | public function getVote($iId, $sTable) |
| 19 | 23 | { |
| 20 | 24 | $this->cache->start(self::CACHE_GROUP, 'getVote' . $iId . $sTable, static:: |
@@ -38,6 +42,10 @@ discard block |
||
| 38 | 42 | return $iData; |
| 39 | 43 | } |
| 40 | 44 | |
| 45 | + /** |
|
| 46 | + * @param integer $iId |
|
| 47 | + * @param string $sTable |
|
| 48 | + */ |
|
| 41 | 49 | public function getScore($iId, $sTable) |
| 42 | 50 | { |
| 43 | 51 | $this->cache->start(self::CACHE_GROUP, 'getScore' . $iId . $sTable, static:: |
@@ -61,6 +69,10 @@ discard block |
||
| 61 | 69 | return $fData; |
| 62 | 70 | } |
| 63 | 71 | |
| 72 | + /** |
|
| 73 | + * @param integer $iId |
|
| 74 | + * @param string $sTable |
|
| 75 | + */ |
|
| 64 | 76 | public function updateVotes($iId, $sTable) |
| 65 | 77 | { |
| 66 | 78 | |
@@ -73,6 +85,10 @@ discard block |
||
| 73 | 85 | return $rStmt->execute(); |
| 74 | 86 | } |
| 75 | 87 | |
| 88 | + /** |
|
| 89 | + * @param integer $iId |
|
| 90 | + * @param string $sTable |
|
| 91 | + */ |
|
| 76 | 92 | public function updateScore($fScore, $iId, $sTable) |
| 77 | 93 | { |
| 78 | 94 | $sTable = Various::checkTable($sTable); |
@@ -7,7 +7,8 @@ |
||
| 7 | 7 | */ |
| 8 | 8 | namespace PH7; |
| 9 | 9 | |
| 10 | -use PH7\Framework\Mvc\Model\Engine\Db, PH7\Framework\Mvc\Model\Engine\Util\Various; |
|
| 10 | +use PH7\Framework\Mvc\Model\Engine\Db; |
|
| 11 | +use PH7\Framework\Mvc\Model\Engine\Util\Various; |
|
| 11 | 12 | |
| 12 | 13 | // Abstract Class |
| 13 | 14 | class RatingCoreModel extends Framework\Mvc\Model\Engine\Model |
@@ -142,6 +142,9 @@ |
||
| 142 | 142 | return $this->totalComments('Game', $iDay); |
| 143 | 143 | } |
| 144 | 144 | |
| 145 | + /** |
|
| 146 | + * @param string $sTable |
|
| 147 | + */ |
|
| 145 | 148 | protected function totalComments($sTable, $iDay = 0) |
| 146 | 149 | { |
| 147 | 150 | CommentCore::checkTable($sTable); |
@@ -56,7 +56,7 @@ discard block |
||
| 56 | 56 | * @param string $sEmail |
| 57 | 57 | * @param string $sPassword |
| 58 | 58 | * @param string $sTable Default 'Members' |
| 59 | - * @return mixed (boolean "true" or string "message") |
|
| 59 | + * @return string|boolean (boolean "true" or string "message") |
|
| 60 | 60 | */ |
| 61 | 61 | public function login($sEmail, $sPassword, $sTable = 'Members') |
| 62 | 62 | { |
@@ -388,6 +388,7 @@ discard block |
||
| 388 | 388 | * |
| 389 | 389 | * @param integer iProfileId |
| 390 | 390 | * @param integer $iStatus Values: 0 = Offline, 1 = Online, 2 = Busy, 3 = Away |
| 391 | + * @param integer $iProfileId |
|
| 391 | 392 | * @return void |
| 392 | 393 | */ |
| 393 | 394 | public function setUserStatus($iProfileId, $iStatus) |
@@ -528,7 +529,7 @@ discard block |
||
| 528 | 529 | * |
| 529 | 530 | * @param string $sEmail User's email address. |
| 530 | 531 | * @param string $sTable Default 'Members' |
| 531 | - * @return mixed (object | boolean) Returns the data member (email, username, firstName, hashValidation) on success, otherwise returns false if there is an error. |
|
| 532 | + * @return string (object | boolean) Returns the data member (email, username, firstName, hashValidation) on success, otherwise returns false if there is an error. |
|
| 532 | 533 | */ |
| 533 | 534 | public function getHashValidation($sEmail, $sTable = 'Members') |
| 534 | 535 | { |
@@ -682,7 +683,7 @@ discard block |
||
| 682 | 683 | * |
| 683 | 684 | * @param integer $iProfileId |
| 684 | 685 | * @param integer $iApproved (1 = approved | 0 = pending | NULL = approved and pending) Default NULL |
| 685 | - * @return object The Avatar (SQL alias is pic), profileId and approvedAvatar |
|
| 686 | + * @return string The Avatar (SQL alias is pic), profileId and approvedAvatar |
|
| 686 | 687 | */ |
| 687 | 688 | public function getAvatar($iProfileId, $iApproved = null) |
| 688 | 689 | { |
@@ -936,7 +937,7 @@ discard block |
||
| 936 | 937 | * @param string $sOrder |
| 937 | 938 | * @param integer $iOffset |
| 938 | 939 | * @param integer $iLimit |
| 939 | - * @return mixed (object | integer) object for the users list returned or integer for the total number users returned. |
|
| 940 | + * @return integer (object | integer) object for the users list returned or integer for the total number users returned. |
|
| 940 | 941 | */ |
| 941 | 942 | public function getGeoProfiles($sCountry, $sCity, $bCount, $sOrder, $iOffset, $iLimit) |
| 942 | 943 | { |
@@ -10,12 +10,11 @@ |
||
| 10 | 10 | */ |
| 11 | 11 | namespace PH7; |
| 12 | 12 | |
| 13 | -use |
|
| 14 | -PH7\Framework\Mvc\Model\Engine\Db, |
|
| 15 | -PH7\Framework\Mvc\Model\DbConfig, |
|
| 16 | -PH7\Framework\Mvc\Model\Engine\Util\Various, |
|
| 17 | -PH7\Framework\Date\CDateTime, |
|
| 18 | -PH7\Framework\Security\Security; |
|
| 13 | +use PH7\Framework\Mvc\Model\Engine\Db; |
|
| 14 | +use PH7\Framework\Mvc\Model\DbConfig; |
|
| 15 | +use PH7\Framework\Mvc\Model\Engine\Util\Various; |
|
| 16 | +use PH7\Framework\Date\CDateTime; |
|
| 17 | +use PH7\Framework\Security\Security; |
|
| 19 | 18 | |
| 20 | 19 | // Abstract Class |
| 21 | 20 | class UserCoreModel extends Framework\Mvc\Model\Engine\Model |