PHP NextendFilesystem::fileexists方法代码示例

 function generateOptions(&$xml)
 {
     $template = (string) $this->_xml;
     $cssfile = NextendFilesystem::translateToMediaPath(str_replace(DIRECTORY_SEPARATOR, '/', dirname($this->_form->_xmlfile)) . '/style.');
     $css = NextendCss::getInstance();
     if (NextendFilesystem::fileexists($cssfile . 'less')) {
         $css->enableLess();
         $cssfile .= 'less';
         $css->addCssFile(array($cssfile, $cssfile, array('id' => 'body')));
     } else {
         $cssfile .= 'css';
         $css->addCssFile($cssfile);
     }
     $prefix = NextendXmlGetAttribute($this->_xml, 'prefix');
     $this->_values = array();
     $html = '';
     foreach ($xml->option as $option) {
         $v = NextendXmlGetAttribute($option, 'value');
         $this->_values[] = $v;
         if ($v != -1) {
             $info = pathinfo($v);
             $class = $prefix . basename($v, '.' . $info['extension']);
             $html .= '
             <div class="nextend-radio-option nextend-imagelist-option' . $this->isSelected($v) . '">
                 ' . str_Replace('{image}', NextendUri::pathToUri($v), str_Replace('{class}', $class, $template)) . '
             </div>';
         } else {
             $html .= '<div class="nextend-radio-option' . $this->isSelected($v) . '">' . (string) $option . '</div>';
         }
     }
     return $html;
 }

function nextendimportpath($file)
{
    $file .= '.php';
    if (NextendFilesystem::fileexists($file)) {
        require_once $file;
        return true;
    }
    return false;
}

 function addCSS()
 {
     parent::addCSS();
     $css = NextendCss::getInstance();
     end($css->_cssFiles);
     $last = key($css->_cssFiles);
     $override = str_replace(WP_PLUGIN_DIR, get_template_directory(), $css->_cssFiles[$last][1]);
     if (NextendFilesystem::fileexists($override)) {
         $css->_cssFiles[$last][1] = $override;
     }
 }

 function auth()
 {
     $folder = NextendRequest::getVar('folder');
     if ($folder) {
         $authfile = NextendFilesystem::pathToAbsolutePath($folder) . 'auth.php';
         if (NextendFilesystem::fileexists($authfile)) {
             require_once $authfile;
             if (function_exists('nextend_api_auth_flow')) {
                 nextend_api_auth_flow();
             }
         }
     }
     exit;
 }

 function subform()
 {
     $response = array();
     if (!isset($_POST['data'])) {
         echo json_encode(array('error' => 'Post not OK!'));
         exit;
     }
     if (get_magic_quotes_gpc() || nextendIsWordPress()) {
         $_POST['data'] = stripslashes($_POST['data']);
     }
     $data = json_decode($_POST['data'], true);
     $configurationXmlFile = rtrim(NextendFilesystem::getBasePath(), DIRECTORY_SEPARATOR) . DIRECTORY_SEPARATOR . $data['xml'];
     if (NextendFilesystem::fileexists($configurationXmlFile)) {
         nextendimport('nextend.css.css');
         nextendimport('nextend.javascript.javascript');
         $css = NextendCSS::getInstance();
         $js = NextendJavascript::getInstance();
         $js->loadLibrary('dojo');
         nextendimport('nextend.form.form');
         $form = new NextendForm();
         $form->loadArray($data['orig']);
         $form->loadArray(array($data['name'] => $data['value']));
         $form->loadXMLFile($configurationXmlFile);
         ob_start();
         $subform = $form->getSubform($data['tab'], $data['name']);
         $subform->initAjax($data['control_name']);
         echo $subform->renderForm();
         echo "<style>";
         echo $css->generateAjaxCSS($data['loadedCSS']);
         echo "</style>";
         $scripts = $js->generateAjaxJs($data['loadedJSS']);
         $html = ob_get_clean();
         $response = array('html' => $html, 'scripts' => $scripts);
     } else {
         $response = array('error' => 'Configuration file not found');
     }
     echo json_encode($response);
     exit;
 }

 function NextendSliderCache($slider)
 {
     nextendimportsmartslider2('nextend.smartslider.check');
     nextendimport('nextend.css.css');
     nextendimport('nextend.javascript.javascript');
     nextendimport('nextend.fonts.google');
     $this->slider = $slider;
     $sliderid = $slider->_sliderid;
     $recache = false;
     $cached = json_decode(NextendSmartSliderStorage::get('slidercache' . $sliderid), true);
     if (nextendIsWordpress()) {
         $time = current_time('timestamp');
     } else {
         $time = time();
     }
     nextendimportsmartslider2('nextend.smartslider.admin.models.slides');
     $slidesModel = new NextendSmartsliderAdminModelSlides(null);
     $slides = $slidesModel->getSlides($sliderid, '');
     $slideexpire = null;
     foreach ($slides as $s) {
         $publish_up = strtotime($s['publish_up']);
         if ($publish_up && $publish_up > $time && ($slideexpire == null || $publish_up < $slideexpire)) {
             $slideexpire = $publish_up;
         }
         $publish_down = strtotime($s['publish_down']);
         if ($publish_down && $publish_down > $time && ($slideexpire == null || $publish_down < $slideexpire)) {
             $slideexpire = $publish_down;
         }
     }
     if (is_array($cached)) {
         if (NextendSmartSliderStorage::get('sliderchanged' . $sliderid) == 1) {
             $recache = true;
         } else {
             if (isset($cached['time']) && isset($cached['expire']) && $cached['time'] < time() - $cached['expire'] * 60 * 60) {
                 $recache = true;
             } else {
                 if (isset($cached['slideexpire']) && $cached['slideexpire'] < $time) {
                     $recache = true;
                 }
             }
         }
     } else {
         $recache = true;
     }
     if (!$recache) {
         $data = $cached['data'];
         if (isset($data['css'])) {
             if (!NextendFilesystem::fileexists(NextendFilesystem::absoluteURLToPath($data['css']))) {
                 $recache = true;
             }
         } else {
             $recache = true;
         }
         if (!isset($data['libraries']) || !isset($data['libraries']['jquery']) || !isset($data['libraries']['jquery']['jsfiles']) || count($data['libraries']['jquery']['jsfiles']) == 0) {
             $recache = true;
         }
     }
     //$recache = true;
     if ($recache) {
         $data = $this->render();
         $cached = array('time' => time(), 'data' => $data);
         if ($this->slider->_generatorParams->get('enabled', 0)) {
             $generatorcached = json_decode(NextendSmartSliderStorage::get('generator' . $sliderid), true);
             if (is_array($generatorcached)) {
                 $cached['time'] = $generatorcached['time'];
                 $cached['expire'] = $this->slider->_generatorParams->get('cachetime', '24');
             }
         }
         if ($slideexpire) {
             $cached['slideexpire'] = $slideexpire;
         }
         NextendSmartSliderStorage::set('slidercache' . $sliderid, json_encode($cached));
         NextendSmartSliderStorage::set('sliderchanged' . $sliderid, '0');
     }
     $this->cssurl = $data['css'];
     if (nextendIsWordPress()) {
         add_action('nextend_css', array($this, 'addCSS'));
     } elseif (nextendIsMagento()) {
         Nextend_SmartSlider2_Model_Observer::$sliders[] = array($this, 'addCSS');
     } else {
         $this->addCSS();
     }
     $js = NextendJavascript::getInstance();
     foreach ($data['js']['core'] as $j) {
         $js->addJsFile($j);
     }
     if (isset($data['libraries']) && count($data['libraries'])) {
         foreach ($data['libraries'] as $library => $jss) {
             $js->loadLibrary($library);
             if (!empty($jss['js'])) {
                 $js->addLibraryJs($library, $jss['js']);
             }
             if (count($jss['jsfiles'])) {
                 foreach ($jss['jsfiles'] as $j) {
                     $js->addLibraryJsFile($library, $j);
                 }
             }
         }
     }
     if (isset($data['fonts']) && count($data['fonts'])) {
//.........这里部分代码省略.........

 function fetchElement($name, $value, &$node, $control_name)
 {
     $html = '';
     jimport('nextend.library');
     nextendimport('nextend.css.css');
     nextendimport('nextend.javascript.javascript');
     $css = NextendCss::getInstance();
     $js = NextendJavascript::getInstance();
     $css->addCssLibraryFile('common.css');
     $css->addCssLibraryFile('window.css');
     $css->addCssLibraryFile('configurator.css');
     $configurationXmlFile = JPATH_SITE . $node->attributes('xml');
     if (NextendFilesystem::fileexists($configurationXmlFile)) {
         $js->loadLibrary('dojo');
         $js->addLibraryJsLibraryFile('dojo', 'dojo/window.js');
         $js->addLibraryJsAssetsFile('dojo', 'window.js');
         $js->addLibraryJs('dojo', '
             new NextendWindow({
               button: dojo.byId("nextend-configurator-button"),
               node: dojo.byId("nextend-configurator-lightbox"),
               save: dojo.byId("nextend-configurator-save"),
               message: dojo.byId("nextend-configurator-message"),
               onHide: function(){
                 this.message.innerHTML = "Now you should save the module settings to apply changes!";
               }
             });
         ');
         $html .= '<div id="nextend-configurator-lightbox" class="gk_hack nextend-window ' . $node->attributes('identifier') . '">';
         $html .= '<div class="gk_hack nextend-window-container">';
         $html .= '<div class="gk_hack nextend-topbar"><div class="gk_hack nextend-topbar-logo"></div>';
         $manual = $node->attributes('manual');
         if ($manual != "") {
             $html .= '<a href="' . $manual . '" target="_blank" class="gk_hack nextend-topbar-button nextend-topbar-manual">Manual</a>';
         }
         $support = $node->attributes('support');
         if ($support != "") {
             $html .= '<a href="' . $support . '" target="_blank" class="gk_hack nextend-topbar-button nextend-topbar-support">Support</a>';
         }
         $html .= '<div id="nextend-configurator-save" class="nextend-window-save"><div class="NextendWindowSave">APPLY</div></div>';
         $html .= '</div>';
         $html .= '<div class="gk_hack nextend-window-container-inner">';
         $html .= '<fieldset id="nextend-configurator-panels" class="gk_hack panelform">';
         $html .= '<div id="menu-pane" class="gk_hack pane-sliders">';
         nextendimport('nextend.form.form');
         $form = new NextendForm();
         $form->loadArray($this->_parent->toArray());
         $form->set('manual', $manual);
         $form->set('support', $support);
         $form->loadXMLFile($configurationXmlFile);
         ob_start();
         $form->render($control_name);
         $html .= ob_get_clean();
         $html .= '</div>';
         $html .= '</fieldset>';
         $html .= '</div>';
         $html .= '</div>';
         $html .= '</div>';
         $html .= '<a id="nextend-configurator-button" class="nextend-configurator-button" href="#">Configure<span></span></a>
                   <span id="nextend-configurator-message">&nbsp;</span>';
         $js->addLibraryJsAssetsFile('dojo', 'form.js');
         $js->addLibraryJs('dojo', '
             new NextendForm({
               container: "nextend-configurator-lightbox",
               data: ' . json_encode($form->_data) . ',
               xml: "' . NextendFilesystem::toLinux(NextendFilesystem::pathToRelativePath($configurationXmlFile)) . '",
               control_name: "' . $control_name . '",
               url: "' . JUri::current() . '",
               loadedJSS: ' . json_encode($js->generateArrayJs()) . ',
               loadedCSS: ' . json_encode($css->generateArrayCSS()) . '
             });
         ', true);
         return $html;
     } else {
         return NextendText::_("Not found xml configuration: ") . $configurationXmlFile;
     }
     return "asd";
     return '<input type="hidden" name="' . $control_name . '[' . $name . ']" id="' . $control_name . $name . '" value="' . $value . '" ' . $class . ' />';
 }

<?php

defined('NEXTENDLIBRARY') or die;
$dir = dirname(__FILE__) . DIRECTORY_SEPARATOR;
foreach (NextendFilesystem::folders($dir) as $folder) {
    $file = $dir . $folder . DIRECTORY_SEPARATOR . $folder . '.php';
    if (NextendFilesystem::fileexists($file)) {
        require_once $file;
    }
}

 function importlocalAction()
 {
     if ($this->canDo('slider.create')) {
         $path = NEXTEND_SMART_SLIDER2_ASSETS . 'admin/smart/';
         if (NextendRequest::getInt('full', 0)) {
             $path .= 'full_smart/';
         } else {
             $path .= 'free_smart/';
         }
         $filepath = $path . basename(NextendRequest::getVar('slider', '')) . '.smart';
         if (NextendFilesystem::fileexists($filepath)) {
             $sliderid = $this->importFile($filepath);
             header('LOCATION: ' . $this->route('controller=sliders&view=sliders_slider&action=dashboard&sliderid=' . $sliderid));
             exit;
         } else {
             NextendMessage::error(NextendText::_('Error'), NextendText::_('The .smart file not found!'));
         }
         $this->display('default', 'create');
     } else {
         $this->noaccess();
     }
 }

 function ss2_css_image_replace($ms)
 {
     global $zip;
     if (substr($ms[1], 0, 2) == '//') {
         $ms[1] = 'http:' . $ms[1];
     }
     $path = NextendFilesystem::absoluteURLToPath($ms[1]);
     if (NextendFilesystem::fileexists($path)) {
         if (nextendIsJoomla()) {
             $rel = str_replace('plugins/', 'images/', NextendFilesystem::pathToRelativePath($path));
         } else {
             if (nextendIsWordpress()) {
                 $rel = str_replace(NEXTEND_SMART_SLIDER2 . 'plugins/', 'images/', $path);
             }
         }
         $zip->addFile(NextendFilesystem::readFile($path), $rel);
         return 'url(' . $rel . ')';
     }
 }

function nextend_configuration_box($object, $box)
{
    $configurationXmlFile = $box['args']['xml'];
    if (NextendFilesystem::fileexists($configurationXmlFile)) {
        nextendimport('nextend.css.css');
        nextendimport('nextend.javascript.javascript');
        $css = NextendCss::getInstance();
        $js = NextendJavascript::getInstance();
        $css->addCssLibraryFile('wordpress/removeslug.css');
        $css->addCssLibraryFile('common.css');
        $css->addCssLibraryFile('window.css');
        $css->addCssLibraryFile('configurator.css');
        $js->loadLibrary('dojo');
        $js->addLibraryJsLibraryFile('dojo', 'dojo/window.js');
        $js->addLibraryJsAssetsFile('dojo', 'window.js');
        nextendimport('nextend.form.form');
        $control_name = 'nextend';
        $form = new NextendForm();
        $data = get_post_meta($object->ID, 'nextend_configuration', true);
        $form->loadArray($data);
        $form->loadXMLFile($configurationXmlFile);
        require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . 'themes' . DIRECTORY_SEPARATOR . 'loadplugin.php';
        ?>
        <div id="nextend-configurator-wp" class="accordionmenu">
            <div class="gk_hack nextend-topbar"><div class="gk_hack nextend-topbar-logo"></div>
                <?php 
        $manual = 'http://www.nextendweb.com/wiki/accordion-menu-documentation/';
        if ($manual != "") {
            ?>
                    <a href="<?php 
            echo $manual;
            ?>
" target="_blank" class="gk_hack nextend-topbar-button nextend-topbar-manual">Manual</a>
                    <?php 
        }
        $support = 'http://www.nextendweb.com/accordion-menu/#support';
        if ($support != "") {
            ?>
                    <a href="<?php 
            echo $support;
            ?>
" target="_blank" class="gk_hack nextend-topbar-button nextend-topbar-support">Support</a>
                    <?php 
        }
        ?>
                
                <?php 
        if (defined('NEXTENDACCORDIONMENULITE')) {
            ?>
                    <a href="http://www.nextendweb.com/accordion-menu/" target="_blank" class="gk_hack nextend-topbar-button nextend-topbar-getpro">Get PRO</a>
                <?php 
        }
        ?>
                
                <div id="nextend-configurator-save" onclick="jQuery('#publish').trigger('click');" class="nextend-window-save"><div class="NextendWindowSave">SAVE</div></div>
		<div id="nextend-configurator-cancel" onclick="document.location.href='<?php 
        echo admin_url('edit.php?post_type=accordion_menu');
        ?>
';"
		class="nextend-window-cancel"><div class="NextendWindowCancel">CANCEL</div></div>
            </div>
            <?php 
        $form->set('manual', $manual);
        $form->set('support', $support);
        $form->render($control_name);
        $js->addLibraryJsAssetsFile('dojo', 'form.js');
        $js->addLibraryJs('dojo', '
                new NextendForm({
                  container: "nextend-configurator-wp",
                  data: ' . json_encode($form->_data) . ',
                  xml: "' . NextendFilesystem::toLinux(NextendFilesystem::pathToRelativePath($configurationXmlFile)) . '",
                  control_name: "' . $control_name . '",
                  url: "' . site_url('/wp-admin/admin-ajax.php?action=nextend') . '",
                  loadedJSS: ' . json_encode($js->generateArrayJs()) . ',
                  loadedCSS: ' . json_encode($css->generateArrayCSS()) . '
                });
            ', true);
        ?>
        </div>
        <?php 
    }
}

 protected function getInput()
 {
     $html = '';
     jimport('nextend.library');
     NextendText::l('common');
     nextendimport('nextend.css.css');
     nextendimport('nextend.javascript.javascript');
     $css = NextendCss::getInstance();
     $js = NextendJavascript::getInstance();
     $css->addCssLibraryFile('common.css');
     $css->addCssLibraryFile('window.css');
     $css->addCssLibraryFile('configurator.css');
     $attribs = $this->element->attributes();
     $configurationXmlFile = JPATH_SITE . (string) $attribs->xml;
     if (NextendFilesystem::fileexists($configurationXmlFile)) {
         $js->loadLibrary('dojo');
         $js->addLibraryJsLibraryFile('dojo', 'dojo/window.js');
         $js->addLibraryJsAssetsFile('dojo', 'window.js');
         $js->addLibraryJs('dojo', '
             new NextendWindow({
               button: dojo.byId("nextend-configurator-button"),
               node: dojo.byId("nextend-configurator-lightbox"),
               save: dojo.byId("nextend-configurator-save"),
               message: dojo.byId("nextend-configurator-message"),
               onHide: function(){
                 this.message.innerHTML = "' . NextendText::_('Now_you_should_save_the_module_settings_to_apply_changes') . '";
               }
             });
         ');
         $html .= '<div id="nextend-configurator-lightbox" class="gk_hack nextend-window ' . (string) $attribs->identifier . '">';
         $html .= '<div class="gk_hack nextend-window-container">';
         $html .= '<div class="gk_hack nextend-topbar"><div class="gk_hack nextend-topbar-logo"></div>';
         $manual = (string) $attribs->manual;
         if ($manual != "") {
             $html .= '<a href="' . $manual . '" target="_blank" class="gk_hack nextend-topbar-button nextend-topbar-manual">' . NextendText::_('Manual') . '</a>';
         }
         $support = (string) $attribs->support;
         if ($support != "") {
             $html .= '<a href="' . $support . '" target="_blank" class="gk_hack nextend-topbar-button nextend-topbar-support">' . NextendText::_('Support') . '</a>';
         }
         $html .= '<div id="nextend-configurator-save" class="nextend-window-save"><div class="NextendWindowSave">' . NextendText::_('APPLY') . '</div></div>';
         $html .= '</div>';
         $html .= '<div class="gk_hack nextend-window-container-inner">';
         $html .= '<fieldset id="nextend-configurator-panels" class="gk_hack panelform">';
         $html .= '<div id="menu-pane" class="gk_hack pane-sliders">';
         nextendimport('nextend.form.form');
         $form = new NextendForm();
         $form->loadArray($this->value);
         $form->set('manual', $manual);
         $form->set('support', $support);
         $form->loadXMLFile($configurationXmlFile);
         ob_start();
         $form->render($this->name);
         $html .= ob_get_clean();
         $html .= '</div>';
         $html .= '</fieldset>';
         $html .= '</div>';
         $html .= '</div>';
         $html .= '</div>';
         $html .= '<a id="nextend-configurator-button" class="nextend-configurator-button" href="#">' . NextendText::_('Configure') . '<span></span></a>
                   <span id="nextend-configurator-message">&nbsp;</span>';
         $js->addLibraryJsAssetsFile('dojo', 'form.js');
         $js->addLibraryJs('dojo', '
             new NextendForm({
               container: "nextend-configurator-lightbox",
               data: ' . json_encode($form->_data) . ',
               xml: "' . NextendFilesystem::toLinux(NextendFilesystem::pathToRelativePath($configurationXmlFile)) . '",
               control_name: "' . $this->name . '",
               url: "' . JUri::current() . '",
               loadedJSS: ' . json_encode($js->generateArrayJs()) . ',
               loadedCSS: ' . json_encode($css->generateArrayCSS()) . '
             });
         ', true);
         $doc = JFactory::getDocument();
         $doc->_script = str_replace("jQuery('select').chosen({", "jQuery('select:not(.nextend-select)').chosen({", $doc->_script);
         return $html;
     } else {
         return NextendText::_("Not_found_xml_configuration") . $configurationXmlFile;
     }
 }

function nextend_settings_page()
{
    ?>
<div>
<h2>Nextend Global Settings</h2>
<?php 
    if (isset($_POST['nextend'])) {
        update_option('nextend_config', $_POST['nextend']);
    }
    ?>
<div id="nextend_configuration" class="postbox" style="margin: 0 20px 0 0;">
<form method="post" id="nextend-settings" action="<?php 
    echo admin_url("options-general.php?page=nextend_settings_page");
    ?>
">
<?php 
    $configurationXmlFile = NEXTENDLIBRARY . 'wordpress/configuration.xml';
    if (NextendFilesystem::fileexists($configurationXmlFile)) {
        nextendimport('nextend.css.css');
        nextendimport('nextend.javascript.javascript');
        $css = NextendCss::getInstance();
        $js = NextendJavascript::getInstance();
        $css->addCssLibraryFile('wordpress/removeslug.css');
        $css->addCssLibraryFile('common.css');
        $css->addCssLibraryFile('window.css');
        $css->addCssLibraryFile('configurator.css');
        $js->loadLibrary('dojo');
        $js->addLibraryJsLibraryFile('dojo', 'dojo/window.js');
        $js->addLibraryJsAssetsFile('dojo', 'window.js');
        nextendimport('nextend.form.form');
        $control_name = 'nextend';
        $form = new NextendForm();
        $data = get_option('nextend_config');
        global $nextend;
        foreach ($nextend as $k => $v) {
            if (!isset($data[$k])) {
                $data[$k] = $v;
            }
        }
        $form->loadArray($data);
        $form->loadXMLFile($configurationXmlFile);
        ?>
        <div id="nextend-configurator-wp">
            <div class="gk_hack nextend-topbar"><div class="gk_hack nextend-topbar-logo"></div>
                <?php 
        $manual = 'http://www.nextendweb.com/wiki/';
        if ($manual != "") {
            ?>
                    <a href="<?php 
            echo $manual;
            ?>
" target="_blank" class="gk_hack nextend-topbar-button nextend-topbar-manual">Manual</a>
                    <?php 
        }
        $support = 'http://www.nextendweb.com/accordion-menu/#support';
        if ($support != "") {
            ?>
                    <a href="<?php 
            echo $support;
            ?>
" target="_blank" class="gk_hack nextend-topbar-button nextend-topbar-support">Support</a>
                    <?php 
        }
        ?>
                
                <?php 
        if (defined('NEXTENDACCORDIONMENULITE')) {
            ?>
                    <a href="http://www.nextendweb.com/accordion-menu/" target="_blank" class="gk_hack nextend-topbar-button nextend-topbar-getpro">Get PRO</a>
                <?php 
        }
        ?>
                
                <div id="nextend-configurator-save" onclick="njQuery('#nextend-settings').submit();" class="nextend-window-save"><div class="NextendWindowSave">SAVE</div></div>
            </div>
            <?php 
        $form->render($control_name);
        $js->addLibraryJsAssetsFile('dojo', 'form.js');
        $js->addLibraryJs('dojo', '
                new NextendForm({
                  container: "nextend-configurator-wp",
                  data: ' . json_encode($form->_data) . ',
                  xml: "' . NextendFilesystem::toLinux(NextendFilesystem::pathToRelativePath($configurationXmlFile)) . '",
                  control_name: "' . $control_name . '",
                  url: "' . site_url('/wp-admin/admin-ajax.php?action=nextend') . '",
                  loadedJSS: ' . json_encode($js->generateArrayJs()) . ',
                  loadedCSS: ' . json_encode($css->generateArrayCSS()) . '
                });
            ', true);
        ?>
        </div>
        <?php 
    }
    ?>
</div>
</form>
</div>
<?php 
}

 function getData($number)
 {
     nextendimport('nextend.database.database');
     $db = NextendDatabase::getInstance();
     $data = array();
     $category = array_map('intval', explode('||', $this->_data->get('k2itemssourcecategory', '')));
     $query = 'SELECT ';
     $query .= 'con.id, ';
     $query .= 'con.title, ';
     $query .= 'con.alias, ';
     $query .= 'con.introtext, ';
     $query .= 'con.fulltext, ';
     $query .= 'con.catid, ';
     $query .= 'cat.name AS cat_title, ';
     $query .= 'cat.alias AS cat_alias, ';
     $query .= 'con.created_by, ';
     $query .= 'usr.name AS created_by_alias, ';
     $query .= 'con.hits, ';
     $query .= 'con.image_caption, ';
     $query .= 'con.image_credits, ';
     $query .= 'con.extra_fields ';
     $query .= 'FROM #__k2_items AS con ';
     $query .= 'LEFT JOIN #__users AS usr ON usr.id = con.created_by ';
     $query .= 'LEFT JOIN #__k2_categories AS cat ON cat.id = con.catid ';
     $query .= 'WHERE con.catid IN (' . implode(',', $category) . ') ';
     $sourceuserid = intval($this->_data->get('k2itemssourceuserid', ''));
     if ($sourceuserid) {
         $query .= 'AND con.created_by = ' . $sourceuserid . ' ';
     }
     if ($this->_data->get('k2itemssourcepublished', 1)) {
         $jnow = JFactory::getDate();
         $now = version_compare(JVERSION, '1.6.0', '<') ? $jnow->toMySQL() : $jnow->toSql();
         $query .= "AND con.published = 1 AND (con.publish_up = '0000-00-00 00:00:00' OR con.publish_up < '" . $now . "') AND (con.publish_down = '0000-00-00 00:00:00' OR con.publish_down > '" . $now . "') ";
     }
     $query .= 'AND con.trash = 0 ';
     if ($this->_data->get('k2itemssourcefeatured', 0)) {
         $query .= 'AND con.featured = 1 ';
     }
     $language = $this->_data->get('k2itemssourcelanguage', '*');
     if ($language) {
         $query .= 'AND con.language = ' . $db->quote($language) . ' ';
     }
     $order = NextendParse::parse($this->_data->get('k2itemsorder1', 'con.title|*|asc'));
     if ($order[0]) {
         $query .= 'ORDER BY ' . $order[0] . ' ' . $order[1] . ' ';
         $order = NextendParse::parse($this->_data->get('k2itemsorder2', 'con.title|*|asc'));
         if ($order[0]) {
             $query .= ', ' . $order[0] . ' ' . $order[1] . ' ';
         }
     }
     $query .= 'LIMIT 0, ' . $number . ' ';
     $db->setQuery($query);
     $result = $db->loadAssocList();
     $this->loadExtraFields();
     require_once JPATH_SITE . '/components/com_k2/helpers/utilities.php';
     require_once JPATH_SITE . '/components/com_k2/models/item.php';
     $k2item = new K2ModelItem();
     for ($i = 0; $i < count($result); $i++) {
         $result[$i]['url'] = 'index.php?option=com_k2&view=item&id=' . $result[$i]['id'] . ':' . $result[$i]['alias'];
         $result[$i]['categoryurl'] = 'index.php?option=com_k2&view=itemlist&task=category&id=' . $result[$i]['catid'] . ':' . $result[$i]['cat_alias'];
         $result[$i]['thumbnail'] = $result[$i]['image'] = "media/k2/items/cache/" . md5("Image" . $result[$i]['id']) . "_XL.jpg";
         if (!NextendFilesystem::fileexists(JPATH_SITE . '/' . $result[$i]['image'])) {
             $result[$i]['thumbnail'] = $result[$i]['image'] = '';
         }
         $result[$i]['description'] = $result[$i]['introtext'];
         $result[$i]['url_label'] = 'View article';
         $result[$i]['author_name'] = $result[$i]['created_by_alias'];
         $result[$i]['author_url'] = '#';
         $item = (object) $result[$i];
         $extras = $k2item->getItemExtraFields($result[$i]['extra_fields'], $item);
         if (is_array($extras) && count($extras) > 0) {
             foreach ($extras as $field) {
                 $result[$i]['extra' . $field->id . '_' . preg_replace("/\\W|_/", "", $this->extraFields[$field->id]['group_name'] . '_' . $this->extraFields[$field->id]['name'])] = $field->value;
             }
         }
     }
     return $result;
 }