0) {
return $row['version'];
} else {
return 0;
}
}
/**
* Gets the data of a Term and condition by language
* @param int $language language id
* @return array all the info of a Term and condition
*/
public static function get_last_condition ($language)
{
$legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL);
$language= Database::escape_string($language);
$sql = "SELECT * FROM $legal_conditions_table
WHERE language_id = '".$language."'
ORDER BY version DESC LIMIT 1 ";
$result = Database::query($sql);
return Database::fetch_array($result);
}
/**
* Gets the last version of a Term and condition by language
* @param int $language language id
* @return boolean | int the version or false if does not exist
*/
public static function get_last_version($language)
{
$legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL);
$language= Database::escape_string($language);
$sql = "SELECT version FROM $legal_conditions_table
WHERE language_id = '".$language."'
ORDER BY version DESC LIMIT 1 ";
$result = Database::query($sql);
if (Database::num_rows($result)>0){
$version = Database::fetch_array($result);
$version = explode(':',$version[0]);
return $version[0];
} else {
return false;
}
}
/**
* Show the last condition
* @param array with type and content i.e array('type'=>'1', 'content'=>'hola');
*
* @return string html preview
*/
public static function show_last_condition($term_preview)
{
$preview = '';
switch ($term_preview['type']) {
/*// scroll box
case 0:
$preview ='';
break;*/
// HTML
case 0:
if (!empty($term_preview['content'])) {
$preview = '
'.$term_preview['content'].'
';
}
$preview .= get_lang('ByClickingRegisterYouAgreeTermsAndConditions');
break;
// Page link
case 1:
$preview ='';
break;
default:
break;
}
return $preview;
}
/**
* Get the terms and condition table (only for maintenance)
* @param int offset
* @param int number of items
* @param int column
* @return array
*/
public static function get_legal_data($from, $number_of_items, $column)
{
$legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL);
$lang_table = Database::get_main_table(TABLE_MAIN_LANGUAGE);
$from = intval($from);
$number_of_items = intval($number_of_items);
$column = intval($column);
$sql = "SELECT version, original_name as language, content, changes, type, FROM_UNIXTIME(date)
FROM $legal_conditions_table inner join $lang_table l on(language_id = l.id) ";
$sql .= "ORDER BY language, version ASC ";
$sql .= "LIMIT $from, $number_of_items ";
$result = Database::query($sql);
$legals = array ();
$versions = array ();
while ($legal = Database::fetch_array($result)) {
// max 2000 chars
//echo strlen($legal[1]); echo ' ';
$versions[]=$legal[0];
$languages[]=$legal[1];
if (strlen($legal[2])>2000)
$legal[2]= substr($legal[2],0,2000).' ... ';
if ($legal[4]==0)
$legal[4]= get_lang('HTMLText');
elseif($legal[4]==1)
$legal[4]=get_lang('PageLink');
$legals[] = $legal;
}
return $legals;
}
/**
* Gets the number of terms and conditions available
* @return int
*/
public static function count()
{
$legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL);
$sql = "SELECT count(*) as count_result FROM $legal_conditions_table ORDER BY legal_id DESC ";
$result = Database::query($sql);
$url = Database::fetch_array($result,'ASSOC');
$result = $url['count_result'];
return $result;
}
/**
* Get type of terms and conditions
* @param int The legal id
* @param int The language id
* @return int The current type of terms and conditions
*/
public static function get_type_of_terms_and_conditions($legal_id,$language_id)
{
$legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL);
$legal_id = intval($legal_id);
$language_id = Database::escape_string($language_id);
$sql = 'SELECT type FROM '.$legal_conditions_table.' WHERE legal_id="'.$legal_id.'" AND language_id="'.$language_id.'"';
$rs = Database::query($sql);
return Database::result($rs,0,'type');
}
}