Files

536 lines
7.4 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
/* $Id: mysql.php 27 2009-01-18 20:40:50Z john $ */
defined('SE_PAGE') or exit();
class SELanguageStorageMysql extends SELanguageStorage
{
//
// PRIVATE METHOD _languages()
//
function &_languages($reload=FALSE)
{
global $database;
if( $reload || empty($this->_languages) )
{
//$resource = $database->database_query("SELECT * FROM se_languages ORDER BY language_default DESC");
//if( empty($resource) || !$database->database_num_rows($resource) ) return FALSE;
$this->_languages = array();
$row=array();
$row=array(
"language_id"=>
"1",
"language_code"=>
"en",
"language_name"=>
"English",
"language_autodetect_regex"=>
"/^en/i",
"language_setlocale"=>
"",
"language_default"=>
"1"
);
$this->_languages[$row['language_id']] = $row;
/* $resource = $database->database_query("SELECT * FROM se_languages ORDER BY language_default DESC");
if( empty($resource) || !$database->database_num_rows($resource) ) return FALSE;
$this->_languages = array();
while( $row=$database->database_fetch_assoc($resource) )
{
$this->_languages[$row['language_id']] = $row;
}*/
}
return $this->_languages;
}
//
// END PRIVATE METHOD _languages()
//
//
// PUBLIC METHOD edit()
//
function edit($variable_id, $value, $language_id=NULL, $variable_type=LANGUAGE_INDEX_CUSTOM)
{
global $database;
$instance = SELanguage::_init();
if( empty($language_id) ) $language_id = SELanguage::info("language_id");
if( empty($instance->_indices[$variable_type]) ) $variable_type = LANGUAGE_INDEX_CUSTOM;
$value = str_replace("'", "\'", str_replace("\r\n", "", $value));
// VARIABLE ID IS NONZERO
if($variable_id != "0"&&trim($variable_id)!="")
{
// CHECK FOR EXISTING VALUE
$resource = $database->database_query("SELECT NULL FROM se_languagevars WHERE languagevar_id='{$variable_id}' AND languagevar_language_id='$language_id' LIMIT 1");
if( !$resource ) return FALSE;
// UPDATE EXISTING
if( $database->database_num_rows($resource) ) {
$database->database_query("UPDATE se_languagevars SET languagevar_value='$value' WHERE languagevar_id='{$variable_id}' AND languagevar_language_id='$language_id' LIMIT 1");
} else {
$database->database_query("INSERT INTO se_languagevars (languagevar_id, languagevar_language_id, languagevar_value) VALUES ('$variable_id', '$language_id', '$value')");
}
return $variable_id;
}
// CREATE A NEW VARIABLE ENTIRELY
else
{
// Insert new
$int_min = ( isset($instance->_indices[$variable_type][0]) ? $instance->_indices[$variable_type][0] : 0 );
$int_max = ( isset($instance->_indices[$variable_type][1]) ? $instance->_indices[$variable_type][1] : 0 );
$resource = $database->database_query("SELECT MAX((languagevar_id)*1)+1 FROM se_languagevars WHERE languagevar_id>=$int_min AND languagevar_id<=$int_max");
$new_id = $database->database_fetch_array($resource);
$new_id = $new_id[0];
if( !$new_id && $int_min && $int_max )
{
$new_id = $int_min;
}
elseif( !$new_id )
{
return FALSE;
}
$database->database_query("INSERT INTO se_languagevars (languagevar_id, languagevar_language_id, languagevar_value) VALUES ('$new_id', '$language_id', '$value')");
return $new_id;
}
}
//
// END PUBLIC METHOD edit()
//
//
// PUBLIC METHOD get()
//
// Gets or returns a language variable
//
function get($language_id, $lang_var_id, $sprintf_args=NULL)
{
global $database;
// No ID
if( empty($lang_var_id) )
{
return FALSE;
}
// Already loaded
//if(SE_DEBUG){mail("leprakhauns@gmail.com", "Langs", $lang_var_id);}
if( !empty($this->_language_variables[$lang_var_id]) )
{
$lang_var = $this->_language_variables[$lang_var_id];
}
// Need to get it
else
{
$sql = "SELECT languagevar_value FROM se_languagevars WHERE languagevar_id='{$lang_var_id}' AND languagevar_language_id='{$language_id}'";
$resource = $database->database_query($sql);
$row = $database->database_fetch_assoc($resource);
if( !$row['languagevar_value'] )
return FALSE;
$lang_var = $this->_language_variables[$lang_var_id] = $row['languagevar_value'];
}
// Do sprintf stuff
if( is_array($sprintf_args) )
{
$lang_var = vsprintf($lang_var, $sprintf_args);
}
return $lang_var;
}
//
// END PUBLIC METHOD get()
//
//
// PUBLIC METHOD load()
//
function load($language_id, $overwrite=FALSE)
{
global $database;
$load_keys = parent::load($language_id, $overwrite);
if( empty($load_keys) ) return;
// Make query
$sql = "SELECT languagevar_id, languagevar_value FROM se_languagevars WHERE languagevar_id IN('".join("', '", array_filter($load_keys))."')";
$sql .= " AND languagevar_language_id='{$language_id}'";
if( reset(array_filter($load_keys)) !== FALSE )
{
$resource = $database->database_query($sql);
while( $row=$database->database_fetch_assoc($resource) )
{
$this->_language_variables[$row['languagevar_id']] = $row['languagevar_value'];
}
}
}
//
// END PUBLIC METHOD load()
//
//
// PUBLIC METHOD import()
//
function import($language_id, $languagevar_array, $overwrite=FALSE)
{
global $database;
if( empty($languagevar_array) || !is_array($languagevar_array) ) return;
$sql = "SELECT languagevar_id FROM se_languagevars WHERE languagevar_language_id='{$language_id}'";
$resource = $database->database_query($sql);
$lvid_array = array();
while( $row=$database->database_fetch_assoc($resource) )
$lvid_array[] = $row['languagevar_id'];
$skipped = array();
$created = array();
$updated = array();
$failed = array();
foreach( $languagevar_array as $languagevar_id=>$languagevar_value )
{
$exists = ( in_array($languagevar_id, $lvid_array) );
if( $exists && $overwrite )
{
if( $database->database_query("UPDATE se_languagevars SET languagevar_value='".addslashes($languagevar_value)."' WHERE languagevar_language_id='{$language_id}' && languagevar_id='{$languagevar_id}'") )
$updated[] = $languagevar_id;
else
$failed[] = $languagevar_id;
}
elseif( !$exists )
{
if( $database->database_query("INSERT INTO se_languagevars (languagevar_id, languagevar_language_id, languagevar_value) VALUES ('{$languagevar_id}', '{$language_id}', '".addslashes($languagevar_value)."')") )
$created[] = $languagevar_id;
else
$failed[] = $languagevar_id;
}
else
{
$skipped[] = $languagevar_id;
}
}
return array(
'updated' => $updated,
'created' => $created,
'skipped' => $skipped,
'failed' => $failed
);
}
//
// END PUBLIC METHOD import()
//
}
?>