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
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
insertNewCategory()  : int
Insert a new Category
updateCategory()  : mixed
Update the category tables

Methods

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)

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