Documentation

GallerySql
in package

SQL layer of the gallery module

Contains methods to read and save date from and to the database.

Tags
author

Cloudrexx Development Team info@cloudrexx.com

author

Stefan Heinemann

subpackage

module_gallery

Table of Contents

Methods

__construct()  : mixed
deleteAccessIds()  : mixed
Delete all Access ids from the database
getAccessGroups()  : array<string|int, mixed>
Select all group ids that are assigned to a category
getAllGroups()  : array<string|int, mixed>
getCategoriesArray()  : array<string|int, mixed>
Get an array with the categories
getPictureCategory()  : int
Get the category id of a picture
getPrivileges()  : array<string|int, mixed>
Return the access id and the protected info of a category
insertAccessId()  : bool
Insert an access id
insertNewCategory()  : int
Insert a new Category
updateCategory()  : mixed
Update the category tables

Methods

deleteAccessIds()

Delete all Access ids from the database

public deleteAccessIds(int $access_id) : mixed
Parameters
$access_id : int

getAccessGroups()

Select all group ids that are assigned to a category

public getAccessGroups([mixed $type = "frontend" ][, mixed $access_id = false ][, int $intCategoryId = false ]) : array<string|int, mixed>
Parameters
$type : mixed = "frontend"
$access_id : mixed = false
$intCategoryId : int = false
Return values
array<string|int, mixed>

getAllGroups()

public getAllGroups([mixed $groupType = "frontend" ]) : array<string|int, mixed>
Parameters
$groupType : mixed = "frontend"
Tags
desc

gets all frontend groups as an array

Return values
array<string|int, mixed>

getCategoriesArray()

Get an array with the categories

public getCategoriesArray(int $langId[, mixed $pid = -1 ]) : array<string|int, mixed>
Parameters
$langId : int
$pid : mixed = -1
Return values
array<string|int, mixed>

getPictureCategory()

Get the category id of a picture

public getPictureCategory(int $id) : int
Parameters
$id : int
Return values
int

getPrivileges()

Return the access id and the protected info of a category

public getPrivileges(int $id[, flag $type = "frontend" ]) : array<string|int, mixed>
Parameters
$id : int
$type : flag = "frontend"
Return values
array<string|int, mixed> —

(access_id, protected)

insertAccessId()

Insert an access id

public insertAccessId(int $access_id, int $group_id) : bool
Parameters
$access_id : int
$group_id : int

group id

Return values
bool

insertNewCategory()

Insert a new Category

public insertNewCategory(int $pid, int $status, int $comment, int $voting, int $frontendProtected, mixed $backendProtected, mixed $frontend_access_id, mixed $backend_access_id) : int
Parameters
$pid : int
$status : int
$comment : int
$voting : int
$frontendProtected : int
$backendProtected : mixed
$frontend_access_id : mixed
$backend_access_id : mixed
Return values
int

updateCategory()

Update the category tables

public updateCategory(int $id, int $pid, int $status, int $comment, int $voting, int $frontendProtected, mixed $backendProtected, mixed $frontend_access_id, mixed $backend_access_id) : mixed
Parameters
$id : int
$pid : int
$status : int
$comment : int
$voting : int
$frontendProtected : int
$backendProtected : mixed
$frontend_access_id : mixed
$backend_access_id : mixed 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results