acp_portal_menu.php | searchcode

/Portal_XL50_Premod-3.0.8/phpBB3/includes/acp/acp_portal_menu.php

https://github.com/Lucky65/phpBB-Portal-XL-5.0-italian
PHP | 251 lines | 203 code | 28 blank | 20 comment | 19 complexity | c0d12b0281cb7b7dcf5cad8752e322e4 MD5 | raw file

<?php
/** 
*
* @name acp_portal_menu.php
* @package phpBB3 Portal XL
* @version $Id: acp_portal_menu.php,v 1.1.1.1 2009/05/15 05:14:21 damysterious Exp $
*
* @copyright (c) 2007, 2009  Portal XL Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License 
*
*/

/**
* @package acp
*/
class acp_portal_menu
{
	var $u_action;

	function main($id, $mode)
	{
		global $db, $user, $auth, $template, $cache;
		global $config, $portal_config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

		$user->add_lang('mods/acp_portal_xl_menu');
		$this->tpl_name = 'portal_xl/acp_portal_menu';
		$this->page_title = 'ACP_PORTAL_MENU';

		// Set up general vars
		$action = request_var('action', '');
		$action = (isset($_POST['edit'])) ? 'edit' : $action;
		$action = (isset($_POST['add'])) ? 'add' : $action;
		$action = (isset($_POST['save'])) ? 'save' : $action;
		$menu_id = request_var('id', 0);
		$menu_order = request_var('id', 0);
        $ord = request_var('ord',0);
        $ord2 = request_var('ord2',0);
        $id = request_var('id',0);
        $id2 = request_var('id2',0);		
		$table = PORTAL_MENU_TABLE;		

		switch ($action)
		{	

		case 'save':
                $menu_id     	= request_var('id', '', true);		
				$menu_img 		= request_var('menu_img', '', true);
				$menu_name 		= request_var('menu_name', '', true);
				$menu_url 		= request_var('menu_url', '', true);
				$menu_view 		= request_var('menu_view', '', true);
				$menu_order 	= request_var('menu_order', '', true);
				$menu_open		= request_var('menu_open', '', true);
				
        $sqlnews = 'SELECT MAX(menu_order) as total_menu_order
               FROM ' . PORTAL_MENU_TABLE . '
               WHERE menu_order ';
                    $resultnews = $db->sql_query($sqlnews);
                    $total_menu_order = (int) $db->sql_fetchfield('total_menu_order');
                    $db->sql_freeresult($resultnews);
                    if($menu_order) { $menu_order = $menu_order; } 
					else 
					{
                    $menu_order = $total_menu_order + 1;           
                    } 					
				
				$sql_ary 		= array(
					'menu_id'       => $menu_id, 
					'menu_img'		=> $menu_img,
                    'menu_name'		=> $menu_name,
					'menu_url'		=> $menu_url,
                    'menu_view'		=> $menu_view,
                    'menu_order'	=> $menu_order,					
                    'menu_open'		=> $menu_open,					
				);

				if ($menu_id)
				{
				    $sql = 'UPDATE ' . PORTAL_MENU_TABLE  . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . " WHERE menu_id = $menu_id";
				    $message = $user->lang['MENU_UPDATED'];
				}
				else
				{
				     $sql = 'INSERT INTO ' . PORTAL_MENU_TABLE  . ' ' . $db->sql_build_array('INSERT', $sql_ary);
				     $message = $user->lang['MENU_ADDED'];
				}
				$db->sql_query($sql);

				$cache->destroy('menu');

				trigger_error($message . adm_back_link($this->u_action));

			break;

			case 'delete':
				if ($menu_id)
				{
					$sql = 'DELETE FROM ' . PORTAL_MENU_TABLE . "
						WHERE menu_id = $menu_id";
					$db->sql_query($sql);

					$cache->destroy('menu');

					trigger_error($user->lang['MENU_REMOVED'] . adm_back_link($this->u_action));
				}
				else
				{
					trigger_error($user->lang['MUST_SELECT_MENU'] . adm_back_link($this->u_action), E_USER_WARNING);
				}

			break;

			case 'edit':
			case 'add':
			
				$sql = "SELECT *
					FROM $table
					ORDER BY menu_name ASC";
				$result = $db->sql_query($sql);
				while ($row = $db->sql_fetchrow($result))
				{
 				          if ($action == 'edit' && $menu_id == $row['menu_id'])
					{
						$menu_img = $row;
						$menu_name = $row;
						$menu_url = $row;
						$menu_view = $row;
						$menu_order = $row;						
						$menu_open = $row;						
					}
				}
				$db->sql_freeresult($result);

				/*
				* Get all icons we need from their directory
				*/
				if ($dir = opendir($phpbb_root_path . 'portal/images/icon_menu')) {
					$block_images = array();
					while (($file = readdir($dir)) !== false) {
						if (preg_match('#^[^&\'"<>]+\.(?:gif|png|jpe?g)$#i', $file)) {
							$block_images[$file] = array(
								'file'	=> $file,
								'name'	=> ucfirst(str_replace('_', ' ', preg_replace('#^(.*)\..*$#', '\1', $file))),
							);
						}
    				}
    				closedir($dir);
					asort($block_images);
				}

				foreach ($block_images as $images)
				{
						$template->assign_block_vars('file_name', array(
							'S_MENU_IMG' 		=> $images['file'],
							'S_MENU_IMG_NAME' 	=> $images['name'],
							));
				}				
				unset($block_images);

				/*
				* Get all icons for preview we need from their directory
				*/
				if ($dir = opendir($phpbb_root_path . 'portal/images/icon_menu')) {
					$imagescontent = array();
					while (($file = readdir($dir)) !== false) {
						if (preg_match('#^[^&\'"<>]+\.(?:gif|png|jpe?g)$#i', $file)) {
							$imagescontent[$file] = array(
								'file'	=> $file,
								'name'	=> ucfirst(str_replace('_', ' ', preg_replace('#^(.*)\..*$#', '\1', $file))),
							);
						}
    				}
    				closedir($dir);
					asort($imagescontent);
				}
				
				foreach ($imagescontent as $images)
				{
						$template->assign_block_vars('img_file_name_icon', array(
          					'S_BLOCK_FILE_NAME'  => $images['name'],
        					'S_BLOCK_FILE_ICON'  => '<img src="' . $phpbb_root_path . 'portal/images/icon_menu/' . $images['file'] . '" title="' . $images['name'] . '" height="15" width="15" alt="' . $images['name'] . '" />'
							));
				}				
				unset($imagescontent);

				$template->assign_vars(array(
					'S_EDIT'	 	=> true,
					'U_BACK'	 	=> $this->u_action,
					'U_ACTION'	 	=> $this->u_action . '&amp;id=' . $menu_id,
					'MENU_ORDER' 	=> (isset($menu_order['menu_order'])) ? $menu_order['menu_order'] : '',					
					'MENU_IMG'	 	=> (isset($menu_img['menu_img'])) ? $menu_img['menu_img'] : '',
					'MENU1_IMG'	 	=> $row['menu_img'],
					'S_IMAGE_FILE'	=> $row['menu_img'],
					'MENU_NAME'	 	=> (isset($menu_name['menu_name'])) ? $menu_name['menu_name'] : '',
					'MENU_URL'	 	=> (isset($menu_url['menu_url'])) ? $menu_url['menu_url'] : '',
					'MENU_VIEW'	 	=> (isset($menu_view['menu_view'])) ? $menu_view['menu_view'] : '',
					'MENU_OPEN'	 	=> (isset($menu_open['menu_open'])) ? $menu_open['menu_open'] : '',
					));
				return;
			break;
			
            case 'move_down':
            case 'move_up':

            $sql = 'UPDATE ' . PORTAL_MENU_TABLE  . ' SET menu_order=' . $ord .' + '. $ord2 .' - menu_order WHERE menu_id = ' . $id .' OR menu_id = ' . $id2 . '';
            if( !($result = $db->sql_query($sql)) )
            $db->sql_query($sql); 
            $cache->destroy('menu_order');	
			break;
		}			
		
		$template->assign_vars(array(
			'U_ACTION'		=> $this->u_action)
		);

		$sql = 'SELECT *
			FROM ' . PORTAL_MENU_TABLE  . '
			ORDER BY menu_order ASC ';
		$result = $db->sql_query($sql);
		{
			$nb_menu = 0 ;		
			while ( $row = $db->sql_fetchrow($result) )		
             {
                $menu_block[$nb_menu]['menu_id'] 		=  $row['menu_id'] ;
                $menu_block[$nb_menu]['menu_order'] 	=  $row['menu_order'] ;
                $menu_block[$nb_menu]['menu_view'] 		=  $row['menu_view'] ;
                $menu_block[$nb_menu]['menu_url'] 		=  $row['menu_url'] ;
                $menu_block[$nb_menu]['menu_name'] 		=  $row['menu_name'] ;
                $menu_block[$nb_menu]['menu_img'] 		=  $row['menu_img'] ;					
                $menu_block[$nb_menu]['menu_open'] 		=  $row['menu_open'] ;				
                $nb_menu ++ ;
             }
			for ( $portal_menu_block = 0 ; $portal_menu_block < $nb_menu ; $portal_menu_block ++)	
			$template->assign_block_vars('menu', array(				
				'MENU_ORDER'   	=>  $menu_block[$portal_menu_block]['menu_order'],
				'MENU_VIEW'     =>  $menu_block[$portal_menu_block]['menu_view'],
				'MENU_URL'      =>  $menu_block[$portal_menu_block]['menu_url'],				
				'MEU_NAME'      =>  $menu_block[$portal_menu_block]['menu_name'],
				'MENU_IMG'      =>  $menu_block[$portal_menu_block]['menu_img'],	
				'MENU_OPEN'     =>  $menu_block[$portal_menu_block]['menu_open'],	
				'S_IMAGE_FILE'	=>  $menu_block[$portal_menu_block]['menu_img'],
                'U_MOVE_UP'     =>  $this->u_action . '&amp;action=move_up&amp;idnone=' . $menu_block[$portal_menu_block]['menu_id']."&amp;id2="  . $menu_block[$portal_menu_block - 1]['menu_id'] . "&amp;id=" .  $menu_block[$portal_menu_block]['menu_id']. "&amp;ord=" .  $menu_block[$portal_menu_block]['menu_order'] . "&amp;ord2=" .  $menu_block[$portal_menu_block - 1]['menu_order'],
                'U_MOVE_DOWN'   =>  $this->u_action . '&amp;action=move_down&amp;idnone=' . $menu_block[$portal_menu_block]['menu_id']."&amp;id2="  . $menu_block[$portal_menu_block + 1]['menu_id']  . "&amp;id=" .  $menu_block[$portal_menu_block]['menu_id'] . "&amp;ord=" .  $menu_block[$portal_menu_block]['menu_order'] . "&amp;ord2=" .  $menu_block[$portal_menu_block + 1]['menu_order'],				
                'U_DELETE'     	=>  $this->u_action . '&amp;action=delete&amp;id2=' . $menu_block[$portal_menu_block]['menu_id']."&amp;id="  . $menu_block[$portal_menu_block]['menu_id'],
                'U_EDIT'        =>  $this->u_action . '&amp;action=edit&amp;id2=' . $menu_block[$portal_menu_block]['menu_id']."&amp;id="  . $menu_block[$portal_menu_block]['menu_id'])					
            );	
		}
		$db->sql_freeresult($result);
	}
}

?>