Plume CMS 1.2.2 : Vue détaillée de lib.sql.php

Classe: SQL - X-Ref

This class regroups a set of static methods used to create
the SQL queries used in the manager to select a set of
resources.
All the classes needing SQL queries against the main tables should
use these methods. If needed the queries can be refactored. The goal
is to be able to provide some abstraction for a possible port to
another RDBMS.

getUser($id) X-Ref

Get a user by its user id.

param: int User id
return: string Ready to use SQL

getWebsiteLevels($user_id) X-Ref

Get website levels for a user

param: int User id
return: string Ready to use SQL

getWebsite($id) X-Ref

Get a website by its id.

param: string Website id
return: string Ready to use SQL

getResourceByIdentifier($id, $catid='', $website='') X-Ref

Get a resource by its identifier.
If the identifier is only composed of digits it is considered as
being the 'resource_id' else the 'identifier'.
If the category id is empty, the left join is using the main
category for the link.

param: mixed Identifier or resource id
param: int Category id ('')
param: string Website id ('')
return: string Ready to use SQL

getResourceByPath($path, $website='') X-Ref

Get a resource by its path.
The path do not include the category path.

param: string Path
param: string Website id - all the websites if not provided ('')
return: string Ready to use SQL

getCommentById($id, $resource_id='') X-Ref

Get comment by id.
If a resource id is given, the comment must be associated to the given
resource.

param: int Id of the comment.
param: int Id of the resource ('')
return: string Ready to use SQL

getComments($website_id='', $resource_id='', $status='', $order='ASC', $limit=0) X-Ref

Get comments for a given website.
Left join on the associated resources, if no website id is given, all
the comments are returned.

param: string Website id ('')
param: string Resource id ('')
param: int Status ('')
param: string Modification date order of the comments ('ASC')
param: int Limit (0)
return: string Ready to use SQL

getCategoryByPath($path, $website='') X-Ref

Get a category by path.

param: string Path
param: string Website id - all the websites if not provided ('')
return: string Ready to use SQL

getCategoryById($id) X-Ref

Get a category by its id.

param: int Id
return: string Ready to use SQL

getOnlineResourceInCat($res, $cat, $website) X-Ref

Get an online resource in a category.

If first parameter is not an integer, it is considered as the path.

param: mixed Resource path or id
param: string Category path
param: string Website id
return: string Ready to use SQL

getResources($main_category=true) X-Ref

Get resources.

Get all the basic data, if the category returned is the main category.
a WHERE clause is already open.
Can be used to then further limit by website, id or user.

param: bool Associated to the main category (true)
return: string Ready to use SQL

getResourcesInCat($id) X-Ref

Get resources in a category.

param: id Category id
return: string Ready to use SQL

getLastResources($website='', $type='', $category='', $limit='') X-Ref

Get the last resources.

param: string Website id ('')
param: string Type of resource ('')
param: int Category id ('')
param: int Maximum number of results ('')
return: string Ready to use SQL

Poids:	379 lignes (12 kb)
Inclus ou requis:	0 fois
Référencé:	0 fois
Nécessite:	0 fichiers

Code source de Plume CMS 1.2.2

/manager/inc/ -> lib.sql.php (sommaire)

Définit 1 class

Généré le : Mon Nov 26 11:57:01 2007	par Balluche grâce à PHPXref 0.7