Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function handler_categories ($purpose=null, $dbResource=null, $siteLanguage=null, $data=null) {
- switch($purpose) {
- case 'general_data':
- $select = mysql_query("SELECT id,category_alias,category_name,category_name_$siteLanguage FROM gab_sys_categories",$dbResource);
- while($fetch = mysql_fetch_row($select)) {
- $categoryIds[] = $fetch[0];
- $categoryAli[] = $fetch[1];
- $categoryNam[] = $fetch[2];
- $categoryLan[] = $fetch[3];
- }
- $generalArray[0] = $categoryIds;
- $generalArray[1] = $categoryAli;
- $generalArray[2] = $categoryNam;
- $generalArray[3] = $categoryLan;
- return $generalArray;
- break;
- case 'report_error':
- switch($siteLanguage) {
- case'it': $error = 'Nessuna categoria selezionata'; break;
- case'es': $error = 'Ninguna categoría disponible'; break;
- case'fr': $error = 'Pas de catégorie disponible'; break;
- case'en': $error = 'No categories selected'; break;
- default: $error = 'No data availables in this language'; break;
- }
- return $error;
- break;
- // Si parte da qui..
- case 'report_category_name':
- $tableParams = array('category_name','id');
- break;
- case 'report_category_language_name':
- $tableParams = array("category_name_$siteLanguage",'id');
- break;
- /**/
- }
- if (isset($tableParams)) {
- $selectCategoryName = mysql_query("SELECT {$tableParams[0]} AS columnResult FROM gab_sys_categories WHERE {$tableParams[1]}='$data'",$dbResource);
- return mysql_result($selectCategoryName,0,'columnResult');
- }
- // Nothing matched
- return 0;
- }
- ?>
Add Comment
Please, Sign In to add comment