Class Databaseconnect

Description
Description | Vars (details) | Methods (details)

Manage the website onto a PLICI plateform

  • author: SimpliciWeb
  • version: $Id: databaseconnect.class.php 781 2007-12-27 13:07:16Z stephanet $

Located in /core/internal_components/common/databaseconnect/databaseconnect.class.php (line 62) 

ObjectCached
   |
   --Databaseconnect
Variable Summary
Description | Vars (details) | Methods (details)
string $m_dbc_dblogin_value_for_alias
string $m_dbc_sitename_prefix_for_local
DbConnexion $m_object_dbconnexion
Format $m_object_format
array $m_website_group_slave_menu_to_hide
string $req_count
string $req_delete
string $req_get_by_dbc_dbname
string $req_get_groups
string $req_insert
string $req_select
string $req_select_by_primary_key
string $req_select_databasename
string $req_select_sitename
string $req_update
string $req_update_ecommerce
string $req_update_group
Method Summary
Description | Vars (details) | Methods (details)
Databaseconnect Databaseconnect ([bool $use_for_script = false])
bool createNewWebSite (string $p_domainename, string $p_site_reference, string $p_duplicate_template, string $p_is_ecommerce, string $p_user_name, string $p_user_prenom, string $p_user_login, string $p_user_email, string $p_host, string $p_dbname, string $p_login, string $p_pass)
bool deleteDatabaseconnect (string $p_pk_dbc_sitename,  &$r_nb_row_affected, array $r_nb_row_affected)
bool existDatabaseconnect ( &$r_is_existing, string $p_pk_dbc_sitename, bool $r_is_existing)
bool getAvailableGroup ( &$r_result, array $r_result)
void getAvailableThemes ( &$result, array $result)
bool getCountDatabaseconnect ( &$r_result_count, integer $r_result_count)
bool getDbcByDbcDbname (array $p_array_dbc_dbname,  &$r_result, array $r_result)
string getDbcSitenamePrefixForLocal ()
bool getDbcSitenamesForDbcDbname ( &$r_result, string $p_dbc_dbname, array $r_result)
bool getListDatabaseconnect ( &$r_result, [string $p_dbc_dbname = ""], [order $p_order_by = "SPECIAL"], [resource $id_sql_admin_super = ""], array $r_result)
void getListDatabaseConnectGroupedBySitename ( &$r_result, [bool $is_excluding_admin_super = true], [bool $must_get_admin_directory = true], [string $p_order_by = "bd_asc"], [resource $id_sql_admin_super = ""], array $r_result)
bool getListDatabaseNames ( &$r_result, [string $p_include_admin = 'N'], array $r_result)
bool getOneDatabaseconnect ( &$r_result, string $p_pk_dbc_sitename, array $r_result)
bool getSiteName ( &$r_result, string $p_databasename, array $r_result)
bool getThemeUsed ( &$theme_used, string $p_dbc_dbname, string $theme_used)
bool getWebSiteGroupSlave ( &$r_result, [string $p_website_selected = NULL], array $r_result)
bool insertDatabaseconnect (string $p_dbc_sitename, string $p_dbc_dbname, string $p_dbc_dblogin, string $p_dbc_dbpass, string $p_dbc_inherited_sitename, string $p_dbc_ecommerce, string $p_dbc_dbhost)
bool insertDatabaseconnectAlias (string $p_dbc_sitename, string $p_dbc_dbname)
bool isNotValidDbcDbname (string $p_value)
bool setNotInheritWebSite (string $p_dbname)
bool updateAllDatabaseconnectAvailable (string $p_dbc_available,  &$r_nb_row_affected, integer $r_nb_row_affected)
bool updateAllDatabaseconnectEcommerce (string $p_dbc_ecommerce,  &$r_nb_row_affected, integer $r_nb_row_affected)
bool updateDatabaseconnect (string $p_dbc_dbname, string $p_dbc_dblogin, string $p_dbc_dbpass, string $p_dbc_inherited_sitename, string $p_dbc_ecommerce, string $p_dbc_dbhost, string $p_pk_dbc_sitename,  &$r_nb_row_affected, integer $r_nb_row_affected)
bool updateDatabaseconnectAvailable (string $p_dbc_dbname, string $p_dbc_available,  &$r_nb_row_affected, integer $r_nb_row_affected)
bool updateDatabaseconnectEcommerce (string $p_dbc_dbname, string $p_dbc_ecommerce,  &$r_nb_row_affected, integer $r_nb_row_affected)
bool updateDatabaseconnectInheritedSiteName (string $p_dbc_dbname, string $p_dbc_inherited_sitename,  &$r_nb_row_affected, integer $r_nb_row_affected)
bool updateGroup (string $p_new_group, string $p_databasename)
bool xCopyForMakingNotInheritWebSite (string $view_dest,  &$r_result, string $view_source,  &$directory_created_by_script, string $p_site_reference, string $p_dbname, string $path_theme_elements_dest, string $path_theme_elements_orig,  &$files_created_by_script,  &$p_theme_from_plici_or_my, [string $is_after_site_created = false], array $r_result, string $directory_created_by_script, string $files_created_by_script, string $p_theme_from_plici_or_my)
bool xCreateNewWebSite (string $p_domainename, string $p_site_reference, string $p_duplicate_template, string $p_is_ecommerce, string $p_user_name, string $p_user_prenom, string $p_user_login, string $p_user_email, string $p_host, string $p_dbname, string $p_login, string $p_pass,  &$directory_created_by_script,  &$files_created_by_script, string $directory_created_by_script, string $files_created_by_script)
bool xGetWebSiteGroup ( &$r_result, string $p_condition, array $r_result)
bool xIsNotValidDbcAvailable (string $p_value)
bool xIsNotValidDbcDbhost (string $p_value)
bool xIsNotValidDbcDblogin (string $p_value)
bool xIsNotValidDbcDbpass (string $p_value)
bool xIsNotValidDbcEcommerce (string $p_value)
bool xIsNotValidDbcInheritedSitename (string $p_value)
bool xIsNotValidDbcSitename ( &$p_value, string $p_value)
void xIsNotValidNewGroup ( $p_new_group,  $p_databasename)
void xRowToArray (array $p_row,  &$r_result, array $r_result)
void xRowToArrayForScript (array $p_row,  &$r_result, array $r_result)
bool xSetNotInheritWebSite (string $p_dbname,  &$directory_created_by_script,  &$files_created_by_script, array $directory_created_by_script, array $files_created_by_script)
bool xVerifyForMakingNotInheritWebSite (string $racine_path, string $p_site_reference, string $p_dbname, string $view_dest,  &$r_result,  &$core_theme_elements,  &$path_theme_elements_orig,  &$path_theme_elements_dest,  &$p_theme_from_plici_or_my, [string $is_after_site_created = false], array $r_result, string $core_theme_elements, string $path_theme_elements_orig, string $path_theme_elements_dest, string $p_theme_from_plici_or_my)
Variables
Description | Vars (details) | Methods (details)
string $m_dbc_dblogin_value_for_alias = "ALIAS" (line 179)

String to know if a website is an alis

string $m_dbc_sitename_prefix_for_local = "local-" (line 173)

Prefix for local sitename

DbConnexion $m_object_dbconnexion = NULL (line 91)

Database Connexion object

Format $m_object_format = NULL (line 85)

Format Object

array $m_website_group_slave_menu_to_hide = array() (line 185)

Website group slave menu to hide

string $req_count = "" (line 129)

SQL Request : Count

string $req_delete = "" (line 141)

SQL Request : Delete

string $req_get_by_dbc_dbname = "" (line 123)

SQL Request : get by database name

string $req_get_groups = "" (line 160)

SQL Request : Get groups

string $req_insert = "" (line 135)

SQL Request : Insert

string $req_select = "" (line 105)

SQL Request : Select

string $req_select_by_primary_key = "" (line 99)

SQL Request : Select by primary key

string $req_select_databasename = "" (line 111)

SQL Request : Select database

string $req_select_sitename = "" (line 117)

SQL Request : Select sitename

string $req_update = "" (line 147)

SQL Request : Update

string $req_update_ecommerce = "" (line 153)

SQL Request : Update ecommerce

string $req_update_group = "" (line 167)

SQL Request :Update group

Inherited Variables

Inherited from ObjectCached

ObjectCached::$m_array_already_loader
Methods
Description | Vars (details) Methods (details)
Constructor Databaseconnect (line 193)

Constructor, init the requests and objects

Databaseconnect Databaseconnect ([bool $use_for_script = false])
  • bool $use_for_script
createNewWebSite (line 1532)

Create a new PLICI website

  • return: TRUE on error
bool createNewWebSite (string $p_domainename, string $p_site_reference, string $p_duplicate_template, string $p_is_ecommerce, string $p_user_name, string $p_user_prenom, string $p_user_login, string $p_user_email, string $p_host, string $p_dbname, string $p_login, string $p_pass)
  • string $p_domainename
  • string $p_site_reference
  • string $p_duplicate_template: 'Y','N'
  • string $p_is_ecommerce: 'Y','N'
  • string $p_user_name
  • string $p_user_prenom
  • string $p_user_login
  • string $p_user_email
  • string $p_host
  • string $p_dbname
  • string $p_login
  • string $p_pass
deleteDatabaseconnect (line 1073)

Delete a database connect information

  • return: TRUE on error
bool deleteDatabaseconnect (string $p_pk_dbc_sitename,  &$r_nb_row_affected, array $r_nb_row_affected)
  • string $p_pk_dbc_sitename
  • array $r_nb_row_affected
  • &$r_nb_row_affected
existDatabaseconnect (line 738)

Test if exist

  • return: TRUE on error
bool existDatabaseconnect ( &$r_is_existing, string $p_pk_dbc_sitename, bool $r_is_existing)
  • bool $r_is_existing
  • string $p_pk_dbc_sitename
  • &$r_is_existing
getAvailableGroup (line 2218)

Get All Available group

  • return: TRUE on error
bool getAvailableGroup ( &$r_result, array $r_result)
  • array $r_result
  • &$r_result
getAvailableThemes (line 1136)

return an array with the available themes

void getAvailableThemes ( &$result, array $result)
  • array $result
  • &$result
getCountDatabaseconnect (line 711)

Get count

  • return: TRUE on error
bool getCountDatabaseconnect ( &$r_result_count, integer $r_result_count)
  • integer $r_result_count
  • &$r_result_count
getDbcByDbcDbname (line 496)

Get database connect by sitename

  • return: TRUE on error
bool getDbcByDbcDbname (array $p_array_dbc_dbname,  &$r_result, array $r_result)
  • array $p_array_dbc_dbname
  • array $r_result
  • &$r_result
getDbcSitenamePrefixForLocal (line 386)

Get sitename prefix for local

string getDbcSitenamePrefixForLocal ()
getDbcSitenamesForDbcDbname (line 464)

Get sitename from a database name

  • return: TRUE on error
bool getDbcSitenamesForDbcDbname ( &$r_result, string $p_dbc_dbname, array $r_result)
  • array $r_result
  • string $p_dbc_dbname
  • &$r_result
getListDatabaseconnect (line 541)

Get list

  • return: TRUE on error
bool getListDatabaseconnect ( &$r_result, [string $p_dbc_dbname = ""], [order $p_order_by = "SPECIAL"], [resource $id_sql_admin_super = ""], array $r_result)
  • array $r_result
  • string $p_dbc_dbname
  • order $p_order_by
  • resource $id_sql_admin_super
  • &$r_result
getListDatabaseConnectGroupedBySitename (line 625)

return an array with dbc_sitename has an array of site_name

void getListDatabaseConnectGroupedBySitename ( &$r_result, [bool $is_excluding_admin_super = true], [bool $must_get_admin_directory = true], [string $p_order_by = "bd_asc"], [resource $id_sql_admin_super = ""], array $r_result)
  • array $r_result
  • bool $is_excluding_admin_super
  • bool $must_get_admin_directory
  • string $p_order_by
  • resource $id_sql_admin_super
  • &$r_result
getListDatabaseNames (line 676)

Get list database names

  • return: TRUE on error
bool getListDatabaseNames ( &$r_result, [string $p_include_admin = 'N'], array $r_result)
  • array $r_result
  • string $p_include_admin: 'Y','N'
  • &$r_result
getOneDatabaseconnect (line 398)

Get one

  • return: TRUE on error
bool getOneDatabaseconnect ( &$r_result, string $p_pk_dbc_sitename, array $r_result)
  • array $r_result
  • string $p_pk_dbc_sitename
  • &$r_result
getSiteName (line 2405)

Get site name for a selected database

  • return: TRUE on error
bool getSiteName ( &$r_result, string $p_databasename, array $r_result)
  • array $r_result
  • string $p_databasename
  • &$r_result
getThemeUsed (line 431)

Get theme used for a database name

  • return: TRUE on error
bool getThemeUsed ( &$theme_used, string $p_dbc_dbname, string $theme_used)
  • string $theme_used
  • string $p_dbc_dbname
  • &$theme_used
getWebSiteGroupSlave (line 2236)

Get Website group slave for current site

  • return: TRUE on error
bool getWebSiteGroupSlave ( &$r_result, [string $p_website_selected = NULL], array $r_result)
  • array $r_result
  • string $p_website_selected
  • &$r_result
insertDatabaseconnect (line 781)

Insert

  • return: TRUE on error
bool insertDatabaseconnect (string $p_dbc_sitename, string $p_dbc_dbname, string $p_dbc_dblogin, string $p_dbc_dbpass, string $p_dbc_inherited_sitename, string $p_dbc_ecommerce, string $p_dbc_dbhost)
  • string $p_dbc_sitename
  • string $p_dbc_dbname
  • string $p_dbc_dblogin
  • string $p_dbc_dbpass
  • string $p_dbc_inherited_sitename
  • string $p_dbc_ecommerce: 'Y','N'
  • string $p_dbc_dbhost
insertDatabaseconnectAlias (line 754)

Insert and force to be an ALIAS

  • return: TRUE on error
bool insertDatabaseconnectAlias (string $p_dbc_sitename, string $p_dbc_dbname)
  • string $p_dbc_sitename
  • string $p_dbc_dbname
isNotValidDbcDbname (line 317)

Parameter Integrity checker

  • return: TRUE if not valid
  • access: private
bool isNotValidDbcDbname (string $p_value)
  • string $p_value
setNotInheritWebSite (line 1247)

Set a website to doesn't herit from another web site

  • return: TRUE on error
bool setNotInheritWebSite (string $p_dbname)
  • string $p_dbname
updateAllDatabaseconnectAvailable (line 866)

Set all databases to Available or not

  • return: TRUE on error
bool updateAllDatabaseconnectAvailable (string $p_dbc_available,  &$r_nb_row_affected, integer $r_nb_row_affected)
  • string $p_dbc_available: 'Y','N'
  • integer $r_nb_row_affected
  • &$r_nb_row_affected
updateAllDatabaseconnectEcommerce (line 831)

Update all databases to ecommerce or not

  • return: TRUE on error
bool updateAllDatabaseconnectEcommerce (string $p_dbc_ecommerce,  &$r_nb_row_affected, integer $r_nb_row_affected)
  • string $p_dbc_ecommerce: 'Y','N'
  • integer $r_nb_row_affected
  • &$r_nb_row_affected
updateDatabaseconnect (line 1021)

Update database connect

  • return: TRUE on error
bool updateDatabaseconnect (string $p_dbc_dbname, string $p_dbc_dblogin, string $p_dbc_dbpass, string $p_dbc_inherited_sitename, string $p_dbc_ecommerce, string $p_dbc_dbhost, string $p_pk_dbc_sitename,  &$r_nb_row_affected, integer $r_nb_row_affected)
  • string $p_dbc_dbname
  • string $p_dbc_dblogin
  • string $p_dbc_dbpass
  • string $p_dbc_inherited_sitename
  • string $p_dbc_ecommerce
  • string $p_dbc_dbhost
  • string $p_pk_dbc_sitename
  • integer $r_nb_row_affected
  • &$r_nb_row_affected
updateDatabaseconnectAvailable (line 940)

Update database available for one database

  • return: TRUE on error
bool updateDatabaseconnectAvailable (string $p_dbc_dbname, string $p_dbc_available,  &$r_nb_row_affected, integer $r_nb_row_affected)
  • string $p_dbc_dbname
  • string $p_dbc_available: 'Y','N'
  • integer $r_nb_row_affected
  • &$r_nb_row_affected
updateDatabaseconnectEcommerce (line 978)

Update database is ecommerce for one database

  • return: TRUE on error
bool updateDatabaseconnectEcommerce (string $p_dbc_dbname, string $p_dbc_ecommerce,  &$r_nb_row_affected, integer $r_nb_row_affected)
  • string $p_dbc_dbname
  • string $p_dbc_ecommerce: 'Y','N'
  • integer $r_nb_row_affected
  • &$r_nb_row_affected
updateDatabaseconnectInheritedSiteName (line 902)

Update database to set inherited site name

  • return: TRUE on error
bool updateDatabaseconnectInheritedSiteName (string $p_dbc_dbname, string $p_dbc_inherited_sitename,  &$r_nb_row_affected, integer $r_nb_row_affected)
  • string $p_dbc_dbname
  • string $p_dbc_inherited_sitename
  • integer $r_nb_row_affected
  • &$r_nb_row_affected
updateGroup (line 2293)

Update group for one website database

  • return: TRUE on error
bool updateGroup (string $p_new_group, string $p_databasename)
  • string $p_new_group
  • string $p_databasename
xCopyForMakingNotInheritWebSite (line 1439)

Copy for making not inherited website

  • return: TRUE on error
  • access: private
bool xCopyForMakingNotInheritWebSite (string $view_dest,  &$r_result, string $view_source,  &$directory_created_by_script, string $p_site_reference, string $p_dbname, string $path_theme_elements_dest, string $path_theme_elements_orig,  &$files_created_by_script,  &$p_theme_from_plici_or_my, [string $is_after_site_created = false], array $r_result, string $directory_created_by_script, string $files_created_by_script, string $p_theme_from_plici_or_my)
  • string $view_dest
  • array $r_result
  • string $view_source
  • string $directory_created_by_script
  • string $p_site_reference
  • string $p_dbname
  • string $path_theme_elements_dest
  • string $path_theme_elements_orig
  • string $files_created_by_script
  • string $p_theme_from_plici_or_my
  • string $is_after_site_created
  • &$r_result
  • &$directory_created_by_script
  • &$files_created_by_script
  • &$p_theme_from_plici_or_my
xCreateNewWebSite (line 1612)

Create a new web site

  • return: TRUE on error
  • access: private
bool xCreateNewWebSite (string $p_domainename, string $p_site_reference, string $p_duplicate_template, string $p_is_ecommerce, string $p_user_name, string $p_user_prenom, string $p_user_login, string $p_user_email, string $p_host, string $p_dbname, string $p_login, string $p_pass,  &$directory_created_by_script,  &$files_created_by_script, string $directory_created_by_script, string $files_created_by_script)
  • string $p_domainename
  • string $p_site_reference
  • string $p_duplicate_template
  • string $p_is_ecommerce
  • string $p_user_name
  • string $p_user_prenom
  • string $p_user_login
  • string $p_user_email
  • string $p_host
  • string $p_dbname
  • string $p_login
  • string $p_pass
  • string $directory_created_by_script
  • string $files_created_by_script
  • &$directory_created_by_script
  • &$files_created_by_script
xGetWebSiteGroup (line 2254)

Return website group function of condition

  • return: TRUE on error
  • access: private
bool xGetWebSiteGroup ( &$r_result, string $p_condition, array $r_result)
  • array $r_result
  • string $p_condition
  • &$r_result
xIsNotValidDbcAvailable (line 377)

Parameter Integrity checker

  • return: TRUE if not valid
  • access: private
bool xIsNotValidDbcAvailable (string $p_value)
  • string $p_value
xIsNotValidDbcDbhost (line 367)

Parameter Integrity checker

  • return: TRUE if not valid
  • access: private
bool xIsNotValidDbcDbhost (string $p_value)
  • string $p_value
xIsNotValidDbcDblogin (line 327)

Parameter Integrity checker

  • return: TRUE if not valid
  • access: private
bool xIsNotValidDbcDblogin (string $p_value)
  • string $p_value
xIsNotValidDbcDbpass (line 337)

Parameter Integrity checker

  • return: TRUE if not valid
  • access: private
bool xIsNotValidDbcDbpass (string $p_value)
  • string $p_value
xIsNotValidDbcEcommerce (line 357)

Parameter Integrity checker

  • return: TRUE if not valid
  • access: private
bool xIsNotValidDbcEcommerce (string $p_value)
  • string $p_value
xIsNotValidDbcInheritedSitename (line 347)

Parameter Integrity checker

  • return: TRUE if not valid
  • access: private
bool xIsNotValidDbcInheritedSitename (string $p_value)
  • string $p_value
xIsNotValidDbcSitename (line 304)

Parameter Integrity checker

  • return: TRUE if not valid
  • access: private
bool xIsNotValidDbcSitename ( &$p_value, string $p_value)
  • string $p_value
  • &$p_value
xIsNotValidNewGroup (line 2186)
void xIsNotValidNewGroup ( $p_new_group,  $p_databasename)
  • $p_new_group
  • $p_databasename
xRowToArray (line 1173)

Convert a number indexed array to an fieldname indexed array

  • access: private
void xRowToArray (array $p_row,  &$r_result, array $r_result)
  • array $p_row
  • array $r_result
  • &$r_result
xRowToArrayForScript (line 1194)

Convert a number indexed array to an fieldname indexed array

  • access: private
void xRowToArrayForScript (array $p_row,  &$r_result, array $r_result)
  • array $p_row
  • array $r_result
  • &$r_result
xSetNotInheritWebSite (line 1287)

Set to not inherit website

  • return: TRUE on error
  • access: private
bool xSetNotInheritWebSite (string $p_dbname,  &$directory_created_by_script,  &$files_created_by_script, array $directory_created_by_script, array $files_created_by_script)
  • string $p_dbname
  • array $directory_created_by_script
  • array $files_created_by_script
  • &$directory_created_by_script
  • &$files_created_by_script
xVerifyForMakingNotInheritWebSite (line 1380)

Verify for making not inherited web site

  • return: TRUE on error
  • access: private
bool xVerifyForMakingNotInheritWebSite (string $racine_path, string $p_site_reference, string $p_dbname, string $view_dest,  &$r_result,  &$core_theme_elements,  &$path_theme_elements_orig,  &$path_theme_elements_dest,  &$p_theme_from_plici_or_my, [string $is_after_site_created = false], array $r_result, string $core_theme_elements, string $path_theme_elements_orig, string $path_theme_elements_dest, string $p_theme_from_plici_or_my)
  • string $racine_path
  • string $p_site_reference
  • string $p_dbname
  • string $view_dest
  • array $r_result
  • string $core_theme_elements
  • string $path_theme_elements_orig
  • string $path_theme_elements_dest
  • string $p_theme_from_plici_or_my
  • string $is_after_site_created
  • &$r_result
  • &$core_theme_elements
  • &$path_theme_elements_orig
  • &$path_theme_elements_dest
  • &$p_theme_from_plici_or_my

Inherited Methods

Inherited From ObjectCached

ObjectCached::xClearRemember()
ObjectCached::xClearRememberAll()
ObjectCached::xIsRemembered()
ObjectCached::xRemember()

Documentation generated on Tue, 25 Mar 2008 15:34:02 +0100 by phpDocumentor 1.3.2