Public Member Functions | |
| __construct (&$oConfig) | |
| isAnyPublicContent () | |
| getEntryByIdAndOwner ($iId, $iOwner, $isAdmin) | |
| getEntryById ($iId) | |
| getEntriesByAuthor ($iProfileId) | |
| getCountByAuthorAndStatus ($iProfileId, $sStatus) | |
| getEntryByUri ($sUri) | |
| getLatestFeaturedItem () | |
| getEntriesByMonth ($iYear, $iMonth, $iNextYear, $iNextMonth) | |
| deleteEntryByIdAndOwner ($iId, $iOwner, $isAdmin) | |
| markAsFeatured ($iId) | |
| activateEntry ($iId) | |
| updateMedia ($iEntryId, $aMediaAdd, $aMediaDelete, $sMediaType) | |
| insertMedia ($iEntryId, $aMedia, $sMediaType) | |
| deleteMedia ($iEntryId, $aMedia, $sMediaType) | |
| deleteEntryMediaAll ($iEntryId, $sMediaType) | |
| deleteMediaFile ($iMediaId, $sMediaType) | |
| getMediaIds ($iEntryId, $sMediaType) | |
| isMediaInUse ($iMediaId, $sMediaType) | |
| getMedia ($iEntryId, $iMediaId, $sMediaType) | |
| setThumbnail ($iEntryId, $iImageId) | |
| getForumById ($iForumId) | |
| createForum ($aDataEntry, $sUsername) | |
| deleteForum ($iEntryId) | |
| getProfileNickNameById ($iId) | |
| getProfileIdByNickName ($sNick, $isProcessDbInput=true) | |
| getSettingsCategory ($sName) | |
| getPotentialVisitors ($iProfileId) | |
| getBroadcastRecipients ($iEntryId) | |
| joinEntry ($iEntryId, $iProfileId, $isConfirmed) | |
| leaveEntry ($iEntryId, $iProfileId) | |
| isFan ($iEntryId, $iProfileId, $isConfirmed) | |
| getFansBrowse (&$aProfiles, $iEntryId, $iStart, $iMaxNum) | |
| getFans (&$aProfiles, $iEntryId, $isConfirmed, $iStart, $iMaxNum, $aFilter=array()) | |
| confirmFans ($iEntryId, $aProfileIds) | |
| removeFans ($iEntryId, $aProfileIds) | |
| removeFanFromAllEntries ($iProfileId) | |
| removeAdminFromAllEntries ($iProfileId) | |
| rejectFans ($iEntryId, $aProfileIds) | |
| getAdmins (&$aProfiles, $iEntryId, $iStart, $iMaxNum, $aFilter=array()) | |
| isGroupAdmin ($iEntryId, $iProfileId) | |
| addGroupAdmin ($iEntryId, $aProfileIds) | |
| removeGroupAdmin ($iEntryId, $aProfileIds) | |
 Public Member Functions inherited from ChWsbModuleDb | |
| __construct ($oConfig=null) | |
| getPrefix () | |
| getModulesBy ($aParams=array()) | |
| getModuleById ($iId) | |
| getModuleByUri ($sUri) | |
| isModule ($sUri) | |
| isModuleParamsUsed ($sUri, $sPath, $sPrefixDb, $sPrefixClass) | |
| getModules () | |
| getDependent ($sUri) | |
| getSettingsCategoryId ($sCatName) | |
| Public Member Functions inherited from ChWsbDb | |
| setTimezone ($sTimezone) | |
| getLink () | |
| res ($sQuery, $aBindings=[], $bReplaying=false) | |
| getAll ($sQuery, $aBindings=[], $iFetchType=PDO::FETCH_ASSOC) | |
| getRow ($sQuery, $aBindings=[], $iFetchStyle=PDO::FETCH_ASSOC) | |
| getColumn ($sQuery, $aBindings=[]) | |
| getOne ($sQuery, $aBindings=[], $iIndex=0) | |
| getFirstRow ($sQuery, $aBindings=[], $iFetchStyle=PDO::FETCH_ASSOC) | |
| getNextRow () | |
| getAllWithKey ($sQuery, $sFieldKey, $aBindings=[], $iFetchType=PDO::FETCH_ASSOC) | |
| getPairs ($sQuery, $sFieldKey, $sFieldValue, $aBindings=[]) | |
| query ($sQuery, $aBindings=[]) | |
| getNumRows ($oStmt=null) | |
| getAffectedRows ($oStmt=null) | |
| fillArray ($oStmt, $iFetchType=PDO::FETCH_ASSOC) | |
| lastId () | |
| getParam ($sName, $bCache=true) | |
| setParam ($sName, $sValue) | |
| listTables () | |
| getFields ($sTable) | |
| isFieldExists ($sTable, $sFieldName) | |
| fetchField ($mixedQuery, $iField, $aBindings=[]) | |
| getDbCacheObject () | |
| genDbCacheKey ($sName) | |
| fromCache ($sName, $sFunc) | |
| cleanCache ($sName) | |
| & | fromMemory ($sName, $sFunc) |
| cleanMemory ($sName) | |
| arrayToSQL ($a, $sDiv=',') | |
| escape ($sText, $bReal=true) | |
| implode_escape ($mixed) | |
| unescape ($mixed) | |
Public Attributes | |
| $_sTableMain = 'main' | |
| $_sTableShoutbox = '' | |
| $_sTableMediaPrefix = '' | |
| $_sFieldId = 'id' | |
| $_sFieldAuthorId = 'author_id' | |
| $_sFieldUri = 'uri' | |
| $_sFieldTitle = 'title' | |
| $_sFieldDescription = 'desc' | |
| $_sFieldTags = 'tags' | |
| $_sFieldThumb = 'thumb' | |
| $_sFieldStatus = 'status' | |
| $_sFieldFeatured = 'featured' | |
| $_sFieldCreated = 'created' | |
| $_sFieldDesc = 'desc' | |
| $_sFieldFansCount = 'fans_count' | |
| $_sTableFans = 'fans' | |
| $_sTableAdmins = 'admins' | |
| $_sFieldAllowViewTo = 'allow_view_to' | |
| $_sFieldCommentCount = 'comments_count' | |
| Public Attributes inherited from ChWsbModuleDb | |
| $_sPrefix | |
| Public Attributes inherited from ChWsbDb | |
| $port | |
| $socket | |
| $dbname | |
| $user | |
| $password | |
| $oParams = null | |
| $oDbCacheObject = null | |
Additional Inherited Members | |
| Static Public Member Functions inherited from ChWsbDb | |
| static | getInstance () |
| Protected Member Functions inherited from ChWsbDb | |
| __construct () | |
| connect () | |
| disconnect () | |
| Protected Attributes inherited from ChWsbDb | |
| $host | |
| $link | |
| $oCurrentStmt | |
| $iCurrentFetchStyle | |
| Static Protected Attributes inherited from ChWsbDb | |
| static | $instance |
Detailed Description
Base database class for modules like events/groups/store
Definition at line 13 of file ChWsbTwigModuleDb.php.
Constructor & Destructor Documentation
◆ __construct()
| ChWsbTwigModuleDb::__construct | ( | & | $oConfig | ) |
Reimplemented in ChStoreDb, ChGroupsDb, and ChEventsDb.
Definition at line 38 of file ChWsbTwigModuleDb.php.
Member Function Documentation
◆ activateEntry()
| ChWsbTwigModuleDb::activateEntry | ( | $iId | ) |
Definition at line 115 of file ChWsbTwigModuleDb.php.
◆ addGroupAdmin()
| ChWsbTwigModuleDb::addGroupAdmin | ( | $iEntryId, | |
| $aProfileIds | |||
| ) |
Definition at line 394 of file ChWsbTwigModuleDb.php.
◆ confirmFans()
| ChWsbTwigModuleDb::confirmFans | ( | $iEntryId, | |
| $aProfileIds | |||
| ) |
Definition at line 319 of file ChWsbTwigModuleDb.php.
◆ createForum()
| ChWsbTwigModuleDb::createForum | ( | $aDataEntry, | |
| $sUsername | |||
| ) |
Definition at line 199 of file ChWsbTwigModuleDb.php.
◆ deleteEntryByIdAndOwner()
| ChWsbTwigModuleDb::deleteEntryByIdAndOwner | ( | $iId, | |
| $iOwner, | |||
| $isAdmin | |||
| ) |
Reimplemented in ChStoreDb, ChGroupsDb, and ChEventsDb.
Definition at line 95 of file ChWsbTwigModuleDb.php.
◆ deleteEntryMediaAll()
| ChWsbTwigModuleDb::deleteEntryMediaAll | ( | $iEntryId, | |
| $sMediaType | |||
| ) |
Definition at line 150 of file ChWsbTwigModuleDb.php.
◆ deleteForum()
| ChWsbTwigModuleDb::deleteForum | ( | $iEntryId | ) |
Definition at line 206 of file ChWsbTwigModuleDb.php.
◆ deleteMedia()
| ChWsbTwigModuleDb::deleteMedia | ( | $iEntryId, | |
| $aMedia, | |||
| $sMediaType | |||
| ) |
Definition at line 139 of file ChWsbTwigModuleDb.php.
◆ deleteMediaFile()
| ChWsbTwigModuleDb::deleteMediaFile | ( | $iMediaId, | |
| $sMediaType | |||
| ) |
Reimplemented in ChStoreDb.
Definition at line 158 of file ChWsbTwigModuleDb.php.
◆ getAdmins()
| ChWsbTwigModuleDb::getAdmins | ( | & | $aProfiles, |
| $iEntryId, | |||
| $iStart, | |||
| $iMaxNum, | |||
$aFilter = array() |
|||
| ) |
Definition at line 378 of file ChWsbTwigModuleDb.php.
◆ getBroadcastRecipients()
| ChWsbTwigModuleDb::getBroadcastRecipients | ( | $iEntryId | ) |
Reimplemented in ChStoreDb.
Definition at line 273 of file ChWsbTwigModuleDb.php.
◆ getCountByAuthorAndStatus()
| ChWsbTwigModuleDb::getCountByAuthorAndStatus | ( | $iProfileId, | |
| $sStatus | |||
| ) |
Definition at line 71 of file ChWsbTwigModuleDb.php.
◆ getEntriesByAuthor()
| ChWsbTwigModuleDb::getEntriesByAuthor | ( | $iProfileId | ) |
Definition at line 66 of file ChWsbTwigModuleDb.php.
◆ getEntriesByMonth()
| ChWsbTwigModuleDb::getEntriesByMonth | ( | $iYear, | |
| $iMonth, | |||
| $iNextYear, | |||
| $iNextMonth | |||
| ) |
Reimplemented in ChEventsDb.
Definition at line 88 of file ChWsbTwigModuleDb.php.
◆ getEntryById()
| ChWsbTwigModuleDb::getEntryById | ( | $iId | ) |
Definition at line 61 of file ChWsbTwigModuleDb.php.
◆ getEntryByIdAndOwner()
| ChWsbTwigModuleDb::getEntryByIdAndOwner | ( | $iId, | |
| $iOwner, | |||
| $isAdmin | |||
| ) |
Definition at line 50 of file ChWsbTwigModuleDb.php.
◆ getEntryByUri()
| ChWsbTwigModuleDb::getEntryByUri | ( | $sUri | ) |
Definition at line 76 of file ChWsbTwigModuleDb.php.
◆ getFans()
| ChWsbTwigModuleDb::getFans | ( | & | $aProfiles, |
| $iEntryId, | |||
| $isConfirmed, | |||
| $iStart, | |||
| $iMaxNum, | |||
$aFilter = array() |
|||
| ) |
Definition at line 307 of file ChWsbTwigModuleDb.php.
◆ getFansBrowse()
| ChWsbTwigModuleDb::getFansBrowse | ( | & | $aProfiles, |
| $iEntryId, | |||
| $iStart, | |||
| $iMaxNum | |||
| ) |
Definition at line 302 of file ChWsbTwigModuleDb.php.
◆ getForumById()
| ChWsbTwigModuleDb::getForumById | ( | $iForumId | ) |
Definition at line 194 of file ChWsbTwigModuleDb.php.
◆ getLatestFeaturedItem()
| ChWsbTwigModuleDb::getLatestFeaturedItem | ( | ) |
Definition at line 81 of file ChWsbTwigModuleDb.php.
◆ getMedia()
| ChWsbTwigModuleDb::getMedia | ( | $iEntryId, | |
| $iMediaId, | |||
| $sMediaType | |||
| ) |
Definition at line 173 of file ChWsbTwigModuleDb.php.
◆ getMediaIds()
| ChWsbTwigModuleDb::getMediaIds | ( | $iEntryId, | |
| $sMediaType | |||
| ) |
Definition at line 163 of file ChWsbTwigModuleDb.php.
◆ getPotentialVisitors()
| ChWsbTwigModuleDb::getPotentialVisitors | ( | $iProfileId | ) |
Definition at line 254 of file ChWsbTwigModuleDb.php.
◆ getProfileIdByNickName()
| ChWsbTwigModuleDb::getProfileIdByNickName | ( | $sNick, | |
$isProcessDbInput = true |
|||
| ) |
Definition at line 240 of file ChWsbTwigModuleDb.php.
◆ getProfileNickNameById()
| ChWsbTwigModuleDb::getProfileNickNameById | ( | $iId | ) |
Definition at line 234 of file ChWsbTwigModuleDb.php.
◆ getSettingsCategory()
| ChWsbTwigModuleDb::getSettingsCategory | ( | $sName | ) |
Definition at line 249 of file ChWsbTwigModuleDb.php.
◆ insertMedia()
| ChWsbTwigModuleDb::insertMedia | ( | $iEntryId, | |
| $aMedia, | |||
| $sMediaType | |||
| ) |
Definition at line 128 of file ChWsbTwigModuleDb.php.
◆ isAnyPublicContent()
| ChWsbTwigModuleDb::isAnyPublicContent | ( | ) |
Definition at line 45 of file ChWsbTwigModuleDb.php.
◆ isFan()
| ChWsbTwigModuleDb::isFan | ( | $iEntryId, | |
| $iProfileId, | |||
| $isConfirmed | |||
| ) |
Definition at line 296 of file ChWsbTwigModuleDb.php.
◆ isGroupAdmin()
| ChWsbTwigModuleDb::isGroupAdmin | ( | $iEntryId, | |
| $iProfileId | |||
| ) |
Definition at line 389 of file ChWsbTwigModuleDb.php.
◆ isMediaInUse()
| ChWsbTwigModuleDb::isMediaInUse | ( | $iMediaId, | |
| $sMediaType | |||
| ) |
Definition at line 168 of file ChWsbTwigModuleDb.php.
◆ joinEntry()
| ChWsbTwigModuleDb::joinEntry | ( | $iEntryId, | |
| $iProfileId, | |||
| $isConfirmed | |||
| ) |
Definition at line 278 of file ChWsbTwigModuleDb.php.
◆ leaveEntry()
| ChWsbTwigModuleDb::leaveEntry | ( | $iEntryId, | |
| $iProfileId | |||
| ) |
Definition at line 287 of file ChWsbTwigModuleDb.php.
◆ markAsFeatured()
| ChWsbTwigModuleDb::markAsFeatured | ( | $iId | ) |
Definition at line 110 of file ChWsbTwigModuleDb.php.
◆ rejectFans()
| ChWsbTwigModuleDb::rejectFans | ( | $iEntryId, | |
| $aProfileIds | |||
| ) |
Definition at line 370 of file ChWsbTwigModuleDb.php.
◆ removeAdminFromAllEntries()
| ChWsbTwigModuleDb::removeAdminFromAllEntries | ( | $iProfileId | ) |
Definition at line 361 of file ChWsbTwigModuleDb.php.
◆ removeFanFromAllEntries()
| ChWsbTwigModuleDb::removeFanFromAllEntries | ( | $iProfileId | ) |
Definition at line 343 of file ChWsbTwigModuleDb.php.
◆ removeFans()
| ChWsbTwigModuleDb::removeFans | ( | $iEntryId, | |
| $aProfileIds | |||
| ) |
Definition at line 330 of file ChWsbTwigModuleDb.php.
◆ removeGroupAdmin()
| ChWsbTwigModuleDb::removeGroupAdmin | ( | $iEntryId, | |
| $aProfileIds | |||
| ) |
Definition at line 406 of file ChWsbTwigModuleDb.php.
◆ setThumbnail()
| ChWsbTwigModuleDb::setThumbnail | ( | $iEntryId, | |
| $iImageId | |||
| ) |
Definition at line 178 of file ChWsbTwigModuleDb.php.
◆ updateMedia()
| ChWsbTwigModuleDb::updateMedia | ( | $iEntryId, | |
| $aMediaAdd, | |||
| $aMediaDelete, | |||
| $sMediaType | |||
| ) |
Definition at line 122 of file ChWsbTwigModuleDb.php.
Member Data Documentation
◆ $_sFieldAllowViewTo
| ChWsbTwigModuleDb::$_sFieldAllowViewTo = 'allow_view_to' |
Definition at line 32 of file ChWsbTwigModuleDb.php.
◆ $_sFieldAuthorId
| ChWsbTwigModuleDb::$_sFieldAuthorId = 'author_id' |
Definition at line 19 of file ChWsbTwigModuleDb.php.
◆ $_sFieldCommentCount
| ChWsbTwigModuleDb::$_sFieldCommentCount = 'comments_count' |
Definition at line 33 of file ChWsbTwigModuleDb.php.
◆ $_sFieldCreated
| ChWsbTwigModuleDb::$_sFieldCreated = 'created' |
Definition at line 27 of file ChWsbTwigModuleDb.php.
◆ $_sFieldDesc
| ChWsbTwigModuleDb::$_sFieldDesc = 'desc' |
Definition at line 28 of file ChWsbTwigModuleDb.php.
◆ $_sFieldDescription
| ChWsbTwigModuleDb::$_sFieldDescription = 'desc' |
Definition at line 22 of file ChWsbTwigModuleDb.php.
◆ $_sFieldFansCount
| ChWsbTwigModuleDb::$_sFieldFansCount = 'fans_count' |
Definition at line 29 of file ChWsbTwigModuleDb.php.
◆ $_sFieldFeatured
| ChWsbTwigModuleDb::$_sFieldFeatured = 'featured' |
Definition at line 26 of file ChWsbTwigModuleDb.php.
◆ $_sFieldId
| ChWsbTwigModuleDb::$_sFieldId = 'id' |
Definition at line 18 of file ChWsbTwigModuleDb.php.
◆ $_sFieldStatus
| ChWsbTwigModuleDb::$_sFieldStatus = 'status' |
Definition at line 25 of file ChWsbTwigModuleDb.php.
◆ $_sFieldTags
| ChWsbTwigModuleDb::$_sFieldTags = 'tags' |
Definition at line 23 of file ChWsbTwigModuleDb.php.
◆ $_sFieldThumb
| ChWsbTwigModuleDb::$_sFieldThumb = 'thumb' |
Definition at line 24 of file ChWsbTwigModuleDb.php.
◆ $_sFieldTitle
| ChWsbTwigModuleDb::$_sFieldTitle = 'title' |
Definition at line 21 of file ChWsbTwigModuleDb.php.
◆ $_sFieldUri
| ChWsbTwigModuleDb::$_sFieldUri = 'uri' |
Definition at line 20 of file ChWsbTwigModuleDb.php.
◆ $_sTableAdmins
| ChWsbTwigModuleDb::$_sTableAdmins = 'admins' |
Definition at line 31 of file ChWsbTwigModuleDb.php.
◆ $_sTableFans
| ChWsbTwigModuleDb::$_sTableFans = 'fans' |
Definition at line 30 of file ChWsbTwigModuleDb.php.
◆ $_sTableMain
| ChWsbTwigModuleDb::$_sTableMain = 'main' |
Definition at line 15 of file ChWsbTwigModuleDb.php.
◆ $_sTableMediaPrefix
| ChWsbTwigModuleDb::$_sTableMediaPrefix = '' |
Definition at line 17 of file ChWsbTwigModuleDb.php.
◆ $_sTableShoutbox
| ChWsbTwigModuleDb::$_sTableShoutbox = '' |
Definition at line 16 of file ChWsbTwigModuleDb.php.
The documentation for this class was generated from the following file:
- inc/classes/ChWsbTwigModuleDb.php
