100+ results results for 'php join repo:ealexandru/jobeet' (389 ms)
1<?php 2/** 42 if (is_array($color)) { 43 $color = "rgb(" . join(',', $color) . ")"; 44 } 237 * @throws \Exception 238 * @SuppressWarnings(PHPMD.CyclomaticComplexity) 239 * @SuppressWarnings(PHPMD.NPathComplexity) 332 if (!class_exists('\Imagick', false)) { 333 throw new \Exception("Required PHP extension 'Imagick' was not loaded."); 334 }Country.php https://gitlab.com/jslee1/PrestaShop | PHP | 417 lines
1<?php 2/** 9 * It is also available through the world-wide-web at this URL: 10 * http://opensource.org/licenses/osl-3.0.php 11 * If you did not receive a copy of the license and are unable to 22 * @copyright 2007-2015 PrestaShop SA 23 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 24 * International Registered Trademark & Property of PrestaShop SA 127 FROM `'._DB_PREFIX_.'country` c '.Shop::addSqlAssociation('country', 'c').' 128 LEFT JOIN `'._DB_PREFIX_.'country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = '.(int)$id_lang.') 129 LEFT JOIN `'._DB_PREFIX_.'zone` z ON (z.`id_zone` = c.`id_zone`) 151 FROM `'._DB_PREFIX_.'country` c 152 LEFT JOIN `'._DB_PREFIX_.'country_shop` cs ON (cs.`id_country`= c.`id_country`) 153 LEFT JOIN `'._DB_PREFIX_.'country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = '.(int)$id_lang.') 321 '.Shop::addSqlAssociation('country', 'c', false).' 322 LEFT JOIN `'._DB_PREFIX_.'state` s ON (s.`id_country` = c.`id_country`) 323 LEFT JOIN `'._DB_PREFIX_.'country_lang` cl ON (c.`id_country` = cl.`id_country`)auth_tkt.py https://bitbucket.org/eaviles/gobierno.git | Python | 380 lines
1# (c) 2005 Ian Bicking and contributors; written for Paste (http://pythonpaste.org) 2# Licensed under the MIT license: http://www.opensource.org/licenses/mit-license.php 3########################################################################## 89 self.ip = ip 90 self.tokens = ','.join(tokens) 91 self.user_data = user_data 176def encode_ip_timestamp(ip, timestamp): 177 ip_chars = ''.join(map(chr, map(int, ip.split('.')))) 178 t = int(timestamp) 182 t & 0xff) 183 ts_chars = ''.join(map(chr, ts)) 184 return ip_chars + ts_chars 275 self.secret, cookie_value, remote_addr) 276 tokens = ','.join(tokens) 277 environ['REMOTE_USER'] = useriddirectories.php https://github.com/projectfork/Projectfork.git | PHP | 420 lines
1<?php 2/** 82 83 // Join over the users for the checked out user. 84 $query->select('uc.name AS editor') 84 $query->select('uc.name AS editor') 85 ->join('LEFT', '#__users AS uc ON uc.id = a.checked_out'); 86 86 87 // Join over the asset groups. 88 $query->select('ag.title AS access_level') 88 $query->select('ag.title AS access_level') 89 ->join('LEFT', '#__viewlevels AS ag ON ag.id = a.access'); 90 90 91 // Join over the users for the author. 92 $query->select('ua.name AS author_name')twitter-timeline.php https://gitlab.com/vanafroo/landingpage | PHP | 470 lines
1<?php 2 26 'twitter_timeline', 27 /** This filter is documented in modules/widgets/facebook-likebox.php */ 28 apply_filters( 'jetpack_widget_name', esc_html__( 'Twitter Timeline', 'jetpack' ) ), 63 public function admin_scripts( $hook ) { 64 // This is still 'widgets.php' when managing widgets via the Customizer. 65 if ( 'widgets.php' === $hook ) { 83 if ( isset( $instance['title'] ) ) { 84 /** This filter is documented in core/src/wp-includes/default-widgets.php */ 85 echo $args['before_title'] . apply_filters( 'widget_title', $instance['title'] ) . $args['after_title']; 108 if ( ! empty( $instance['chrome'] ) && is_array( $instance['chrome'] ) ) { 109 echo ' data-chrome="' . esc_attr( join( ' ', $instance['chrome'] ) ) . '"'; 110 } 145 146 /** This action is documented in modules/widgets/social-media-icons.php */ 147 do_action( 'jetpack_bump_stats_extras', 'widget', 'twitter_timeline' );index.php https://github.com/shamilcm/wireus.git | PHP | 291 lines
4 5<?php 6 8 if($_SESSION['authuser']!=1) 9 header("Location:../index.php"); 10 ?> 44 45<?php 46 include('../lib/header.php'); 54 <div id="pageleft"> 55 <?php 56 include('../lib/connectionfile.php'); 104 <div id="pagehead"> 105 <?php 106 echo "<div id=\"pagetitle\">";edit.php https://github.com/eric-brechemier/wordpress.git | PHP | 294 lines
29 30 if ( strpos($sendback, 'post.php') !== false ) 31 $sendback = admin_url($post_new_file); 40 } else { 41 wp_redirect( admin_url("edit.php?post_type=$post_type") ); 42 } 114 $submenu_file = "edit.php?post_type=$post_type"; 115 $post_new_file = "post-new.php?post_type=$post_type"; 116} else { 163<?php screen_icon(); ?> 164<h2><?php echo esc_html( $post_type_object->labels->name ); ?> <a href="<?php echo $post_new_file ?>" class="button add-new-h2"><?php echo esc_html($post_type_object->labels->add_new); ?></a> <?php 165if ( isset($_REQUEST['s']) && $_REQUEST['s'] ) 170if ( isset($_REQUEST['posted']) && $_REQUEST['posted'] ) : $_REQUEST['posted'] = (int) $_REQUEST['posted']; ?> 171<div id="message" class="updated"><p><strong><?php _e('This has been saved.'); ?></strong> <a href="<?php echo get_permalink( $_REQUEST['posted'] ); ?>"><?php _e('View Post'); ?></a> | <a href="<?php echo get_edit_post_link( $_REQUEST['posted'] ); ?>"><?php _e('Edit Post'); ?></a></p></div> 172<?php $_SERVER['REQUEST_URI'] = remove_query_arg(array('posted'), $_SERVER['REQUEST_URI']);class-cp-user-relationships.php https://gitlab.com/clusterpress/clusterpress | PHP | 543 lines
1<?php 2/** 324 $in = array_map( 'esc_sql', $in ); 325 $in = '"' . join( '","', $in ) . '"'; 326 return "{$field_name} IN ({$in})"; 341 $in = wp_parse_id_list( $in ); 342 $in = join( ',', $in ); 343 387 $type = 'results'; 388 $column = join( ', ', $column ); 389 } 417 418 $sql['where'] = 'WHERE ' . join( ' AND ', $sql['where'] ); 419 420 if ( 'col' === $type ) { 421 return $wpdb->get_col( join( ' ', $sql ) ); 422 }facebook.php https://github.com/copongcopong/CakePHP-Facebook-Plugin.git | PHP | 425 lines
1<?php 2/** 20 */ 21 var $__fbShareScript = 'http://static.ak.fbcdn.net/connect.php/js/FB.Share'; 22 62 * @param array of options 63 * - show-faces bool Show pictures of the user's friends who have joined your application 64 * - width int The width of the plugin in pixels 176 else { 177 $retval = $this->Html->link($options['label'], 'http://www.facebook.com/sharer.php', array('share_url' => $url, 'type' => $options['type'], 'name' => $options['anchor'])); 178 $retval .= $this->Html->script($this->__fbShareScript); 380 appId : '{$appId}', 381 session : {$session}, // don't refetch the session when PHP already has it 382 status : true, // check login statusphpBB.php https://bitbucket.org/adatux_/uakami.git | PHP | 538 lines
1<?php 2 3/** 4 * Implementation of phpBB converter. 5 */ 5 */ 6class phpBB extends BBP_Converter_Base { 7 function __construct() { 119 'from_fieldname' => 'post_text', 120 'join_tablename' => 'topics', 121 'join_type' => 'INNER', 121 'join_type' => 'INNER', 122 'join_expression' => 'USING (topic_id) WHERE posts.post_id = topics.topic_first_post_id', 123 'to_type' => 'topic', 198 'from_fieldname' => 'tagtext', 199 'join_tablename' => 'tagcontent', 200 'join_type' => 'INNER',shortcodes.php https://github.com/sharpmachine/wakeupmedia.com.git | PHP | 334 lines
1<?php 2/** 176 $tagnames = array_keys($shortcode_tags); 177 $tagregexp = join( '|', array_map('preg_quote', $tagnames) ); 178AnnotationDriverTest.php https://bitbucket.org/iiic/iszp.git | PHP | 340 lines
1<?php 2 7 8require_once __DIR__ . '/../../TestInit.php'; 9 116 */ 117 public function testJoinTablesWithMappedSuperclassForAnnotationDriver() 118 { 252 * @MappedSuperclass 253 * @InheritanceType("JOINED") 254 * @DiscriminatorMap({"test" = "ColumnWithoutType"}) 262 * @Entity 263 * @InheritanceType("JOINED") 264 * @DiscriminatorMap({"parent" = "AnnotationParent", "child" = "AnnotationChild"})reindex.php https://github.com/karpenoktem/punbb.git | PHP | 267 lines
89<!DOCTYPE html> 90<html lang="<?php $lang_common['lang_identifier'] ?>" dir="<?php echo $lang_common['lang_direction'] ?>"> 91<head> 104 105<?php 106 229 <div class="sf-box text"> 230 <label for="fld<?php echo ++$forum_page['fld_count'] ?>"><span><?php echo $lang_admin_reindex['Posts per cycle'] ?></span> <small><?php echo $lang_admin_reindex['Posts per cycle info'] ?></small></label><br /> 231 <span class="fld-input"><input type="number" id="fld<?php echo $forum_page['fld_count'] ?>" name="i_per_page" size="7" maxlength="7" value="100" /></span> 236 <div class="sf-box text"> 237 <label for="fld<?php echo ++$forum_page['fld_count'] ?>"><span class="fld-label"><?php echo $lang_admin_reindex['Starting post'] ?></span> <small><?php echo $lang_admin_reindex['Starting post info'] ?></small></label><br /> 238 <span class="fld-input"><input type="number" id="fld<?php echo $forum_page['fld_count'] ?>" name="i_start_at" size="7" maxlength="7" value="<?php echo (isset($first_id)) ? $first_id : 0 ?>" /></span> 244 <span class="fld-input"><input type="checkbox" id="fld<?php echo ++$forum_page['fld_count'] ?>" name="i_empty_index" value="1" checked="checked" /></span> 245 <label for="fld<?php echo $forum_page['fld_count'] ?>"><?php echo $lang_admin_reindex['Empty index'] ?></label> 246 </div>README.md https://github.com/elrond79/pymel.git | Markdown | 289 lines
9 - graphviz: using an OS package manager like `yum`, `apt-get`, or `brew`, or 10 on windows, from an [installer](http://www.graphviz.org/Download_windows.php) 11 - python dependencies: 55 pymelPath = r'E:\Projects\Dev\_work\pymel' # ...or wherever YOUR pymel version is installed 56 pymelInit = os.path.join(pymelPath, 'pymel', '__init__.py') 57 if not os.path.isfile(pymelInit): 156 pymelPath = r'/Volumes/sv-dev01/devRepo/chad/pymel' # ...or wherever YOUR pymel version is installed 157 if not os.path.isfile(os.path.join(pymelPath, 'pymel', '__init__.py')): 158 raise RuntimeError('invalid pymel path: %s' % pymelPath) 210 pymelPath = r'/Volumes/sv-dev01/devRepo/chad/pymel' # ...or wherever YOUR pymel version is installed 211 if not os.path.isfile(os.path.join(pymelPath, 'pymel', '__init__.py')): 212 raise RuntimeError('invalid pymel path: %s' % pymelPath) 233 pymelPath = r'/Volumes/sv-dev01/devRepo/chad/pymel' # ...or wherever YOUR pymel version is installed 234 if not os.path.isfile(os.path.join(pymelPath, 'pymel', '__init__.py')): 235 raise RuntimeError('invalid pymel path: %s' % pymelPath)postMash.php https://gitlab.com/Gashler/sg | PHP | 345 lines
82 foreach ($pageposts as $page): //list pages, [the 'li' ID must be pm_'page ID'] ?> 83 <li id="pm_<?php echo $page->ID; ?>"<?php if($page->post_status == "draft"){ echo ' class="remove"'; } //if page is draft, add class remove ?>> 84 <span style="float:right;"> 98 id:<?php echo $page->ID;?> 99 [<a href="<?php echo get_bloginfo('wpurl').'/wp-admin/post.php?action=edit&post='.$page->ID; ?>" title="Edit This Post">edit</a>] 100 <?php if($switchDraftToPublishFeature): ?> 145 <select name='m'> 146 <option<?php selected( $m, 0 ); ?> value='0'><?php _e('Show all dates'); ?></option> 147 <?php 284 if ( $in_same_cat || !empty($excluded_categories) ) { 285 $join = " INNER JOIN $wpdb->term_relationships AS tr ON p.ID = tr.object_id INNER JOIN $wpdb->term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id"; 286 309 310 $join = apply_filters( "get_{$adjacent}_post_join", $join, $in_same_cat, $excluded_categories ); 311 $where = apply_filters( "get_{$adjacent}_post_where", $wpdb->prepare("WHERE p.menu_order $op %s AND p.post_type = 'post' AND p.post_status = 'publish' $posts_in_ex_cats_sql", $current_menu_order), $in_same_cat, $excluded_categories );ASTNode.php https://gitlab.com/yousafsyed/easternglamor | PHP | 540 lines
1<?php 2/** 4 * 5 * PHP Version 5 6 * 39 * @copyright 2008-2015 Manuel Pichler. All rights reserved. 40 * @license http://www.opensource.org/licenses/bsd-license.php BSD License 41 * @since 0.9.6 49 * @copyright 2008-2015 Manuel Pichler. All rights reserved. 50 * @license http://www.opensource.org/licenses/bsd-license.php BSD License 51 * @since 0.9.6 322 323 $this->metadata = join(':', $metadata); 324 } 508 /** 509 * The magic sleep method will be called by PHP's runtime environment right 510 * before an instance of this class gets serialized. It should return anpreprocessors.py https://gitlab.com/Haritiana/Python-Markdown | Python | 346 lines
50 def run(self, lines): 51 source = '\n'.join(lines) 52 source = source.replace(util.STX, "").replace(util.ETX, "") 131 def _equal_tags(self, left_tag, right_tag): 132 if left_tag[0] in ['?', '@', '%']: # handle PHP, etc. 133 return True 163 left_tag, left_index, attrs = \ 164 self._get_left_tag(''.join(items[i:])) 165 right_tag, data_index = self._get_right_tag( 165 right_tag, data_index = self._get_right_tag( 166 left_tag, left_index, ''.join(items[i:])) 167 right_listindex = \ 182 right_listindex = i + 1 183 placeholder = self.markdown.htmlStash.store('\n\n'.join( 184 items[i:right_listindex]))menus-sync.php https://gitlab.com/woxiprogrammers/infinia-wordpress | PHP | 272 lines
63 <tr> 64 <th scope="row" class="check-column"><input type="checkbox" name="sync[menu_translation][<?php echo $menu_id ?>][<?php echo $language ?>]" value="<?php echo esc_attr( $name ) ?>"/></th> 65 <td><?php echo $lang_details[ 'display_name' ]; ?></td> 154 ?> 155 <input type="text" name="sync[menu_translations][<?php echo $menu_id ?>][<?php echo $l[ 'code' ] ?>]" class="icl_msync_add" value="<?php 156 echo esc_attr( $menu[ 'name' ] ) . ' - ' . $l[ 'display_name' ] ?>"/> 163 ?> 164 <input type="hidden" name="sync[menu_options][<?php echo $menu_id ?>][<?php echo $l[ 'code' ] ?>][auto_add]" value="<?php echo esc_attr( $menu[ 'translations' ][ $l[ 'code' ] ][ 'auto_add' ] ); ?>"/> 165 <?php 184 ?> 185 <input id="icl_msync_sync" type="submit" class="button-primary" value="<?php _e( 'Sync', 'sitepress' ); ?>"<?php if ( !$need_sync ): ?> disabled="disabled"<?php endif; ?> /> 186 195 ?> 196 <input id="icl_msync_sync" type="submit" class="button-primary" value="<?php _e( 'Nothing Sync', 'sitepress' ); ?>"<?php if ( !$need_sync ): ?> disabled="disabled"<?php endif; ?> /> 197 <?phpMatcher.php https://bitbucket.org/Kichrum/kohana-auth.git | PHP | 308 lines
40 * @license http://www.opensource.org/licenses/BSD-3-Clause The BSD 3-Clause License 41 * @link http://github.com/sebastianbergmann/phpunit-mock-objects 42 * @since File available since Release 1.0.0 61 */ 62class PHPUnit_Framework_MockObject_Matcher implements PHPUnit_Framework_MockObject_Matcher_Invocation 63{ 149 $builder = $invocation->object 150 ->__phpunit_getInvocationMocker() 151 ->lookupId($this->afterMatchBuilderId); 153 if (!$builder) { 154 throw new PHPUnit_Framework_Exception( 155 sprintf( 295 296 catch (PHPUnit_Framework_ExpectationFailedException $e) { 297 throw new PHPUnit_Framework_ExpectationFailedException(Main.php https://gitlab.com/Skull3x/SpectatorPlus | PHP | 237 lines
1<?php 2namespace Ad5001\SpectatorPlus; 9use pocketmine\event\player\PlayerQuitEvent; 10use pocketmine\event\player\PlayerJoinEvent; 11use pocketmine\event\player\PlayerChatEvent; 159 160 public function onPlayerJoin(PlayerJoinEvent $event) { 161 if(isset($this->quitedplayers[$event->getPlayer()->getName()])) {article.php https://bitbucket.org/eternaware/joomus.git | PHP | 323 lines
1<?php 2/** 94 95 // Join on category table. 96 $query->select('c.title AS category_title, c.alias AS category_alias, c.access AS category_access'); 96 $query->select('c.title AS category_title, c.alias AS category_alias, c.access AS category_access'); 97 $query->join('LEFT', '#__categories AS c on c.id = a.catid'); 98 98 99 // Join on user table. 100 $query->select('u.name AS author'); 100 $query->select('u.name AS author'); 101 $query->join('LEFT', '#__users AS u on u.id = a.created_by'); 102 102 103 // Join on contact table 104 $subQuery = $db->getQuery(true);xbmc_alshain.php https://bitbucket.org/kaigoh/xbmc-php.git | PHP | 312 lines
1<?php 2 5 +-----------------------------------------------+ 6 | XBMC PHP Library - (C) Kai Gohegan, 2010 | 7 +-----------------------------------------------+ 8 9 A PHP library for interacting with XBMC using 10 JSON-RPC and XBMC's HTTP-API. Inspiration was 10 JSON-RPC and XBMC's HTTP-API. Inspiration was 11 drawn from Jason Bryant-Greene's php-json-rpc 12 (https://bitbucket.org/jbg/php-json-rpc/src). 76 $xbmcHttp->COMMAND('arg1,arg2'); 77 $xbmcHttp->ExecBuiltIn("Notification(XBMC-PHP, Hello!)"); 78 78 79 The arguments may also be passed as array. The values will be joined 80 recursively and wrapped with parenthenses. All parameters will beerrors.lang.php https://bitbucket.org/speedealing/speedealing.git | PHP | 146 lines
56 'ErrorFieldsRequired' => 'Bazı gerekli alanlar doldurulmamış.', 57 'ErrorFailedToCreateDir' => 'Dizin oluşturulamadı. Web sunucusu kullanıcısının Speedealing belgeleri dizinine yazma izinlerini denetleyin. Eğer bu parametre <b>guvenli_mod</b> bu PHP üzerinde etkinleştirilmişse, Speedealing php dosyalarının web sunucusu kullanıcısına (ya da grubuna) sahip olduğunu denetleyin.', 58 'ErrorNoMailDefinedForThisUser' => 'Bu kullanıcı için tanımlı posta yok', 63 'ErrorDirNotFound' => '<b>%s</b> dizini bulunamadı (Hatalı yol, yanlış izinler ya da PHP openbasedir tarafından erişim reddedilmiş ya da güvenli_mod parametresi olabilir)', 64 'ErrorFunctionNotAvailableInPHP' => '<b>%s</b> işlevi bu özellik için gereklidir ama bu özellik PHP nin bu sürümü/kurulumu için geçerli değildir.', 65 'ErrorDirAlreadyExists' => 'Bu isimli bir dizin zaten var.', 114 'ErrorLoginDisabled' => 'Hesabınız engellendi', 115 'ErrorFailedToRunExternalCommand' => 'Dış komut çalıştırılamıyor. PHP sunucunuz tarafından kullanılabilir ve çalıştırılabilir olup olmadığını kontrol edin. PHP <b>Güvenli Mod</b> etkinse, komutun <b>safe_mode_exec_dir</b> parametresiyle tanımlanmış bir dizin içinde olup olmadığını kontrol edin.', 116 'ErrorFailedToChangePassword' => 'Parola değiştirilemedi', 126 'ErrorFileRequired' => 'It takes a package Speedealing file', 127 'ErrorPhpCurlNotInstalled' => 'The PHP CURL is not installed, this is essential to talk with Paypal', 128 'ErrorFailedToAddToMailmanList' => 'Failed to add record to Mailman list or SPIP base', 133 'WarningMandatorySetupNotComplete' => 'Mandatory setup parameters are not yet defined', 134 'WarningSafeModeOnCheckExecDir' => 'Uyarı, PHP seçeneği <b>güvenli_mode</b> açıktır, böylece komut php parametresi <b>güvenli_mode_exec_dir</b> tarafından bildirilen bir dizine saklanabilir.', 135 'WarningAllowUrlFopenMustBeOn' => '<b>allow_url_fopen</b> Parametresi <b>php.ini</b> dosyalayıcısında bu modülün tam olarak çalışması için <b>on</b> ye ayarlanmalıdır. Bu dosyayı el ile değiştirmeniz gerekir.',FindingTable.php https://bitbucket.org/openfisma-ondemand/openfisma.git | PHP | 395 lines
1<?php 2/** 85 'label' => 'Creator', 86 'join' => array( 87 'model' => 'User', 116 'label' => 'Finding_Point_of_Contact', 117 'join' => array( 118 'model' => 'User', 143 'label' => 'Finding_Point_of_Contact_Organization', 144 'join' => array( 145 'model' => 'Organization', 171 'label' => 'Organization/System', 172 'join' => array( 173 'model' => 'Organization', 182 'label' => 'Parent Organization', 183 'join' => array( 184 'model' => 'Organization',Collection.php https://bitbucket.org/dnejedly/eaparts.git | PHP | 333 lines
58 /** 59 * Store strong mode flag that determine if needed for inner join or left join of linked products 60 * 87 /** 88 * Enable strong mode for inner join of linked products 89 * 108 /** 109 * Initialize collection parent product and add limitation join 110 * 225 ); 226 $joinType = 'join'; 227 if ($this->getProduct() && $this->getProduct()->getId()) { 231 } else { 232 $joinType = 'joinLeft'; 233 $joinCondition[] = $adapter->quoteInto('links.product_id = ?', $productId);BaseIndustryQuery.php https://gitlab.com/Isaki/le331.fr | PHP | 397 lines
334 * @param string $relationAlias optional alias for the relation 335 * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join' 336 * 338 */ 339 public function joinCompany($relationAlias = null, $joinType = Criteria::INNER_JOIN) 340 { 345 $join = new ModelJoin(); 346 $join->setJoinType($joinType); 347 $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias); 348 if ($previousJoin = $this->getPreviousJoin()) { 349 $join->setPreviousJoin($previousJoin); 350 } 369 * to be used as main alias in the secondary query 370 * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join' 371 *plain.class.php https://github.com/godber/PHXdata-Website.git | PHP | 328 lines
1<?php 2/** 102 // prepare user line 103 $groups = join(',',$grps); 104 $userline = join(':',array($user,$pass,$name,$mail,$groups))."\n"; 144 145 $groups = join(',',$userinfo['grps']); 146 $userline = join(':',array($newuser, $userinfo['pass'], $userinfo['name'], $userinfo['mail'], $groups))."\n"; 184 185 $pattern = '/^('.join('|',$deleted).'):/'; 186permissions.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 511 lines
1<?php 2if( !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' ); 4* 5* @version $Id: permissions.php 6053 2012-06-05 12:36:21Z Milbo $ 6* @package VirtueMart 10* @copyright Copyright (C) 2010-2011 Virtuemart Team - All rights reserved. 11* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php 12* VirtueMart is free software. This version may have been modified pursuant 15* other free or open source software licenses. 16* See /administrator/components/com_virtuemart/COPYRIGHT.php for copyright notices and details. 17* 118 /* If the registration type is neither "no registration" nor "optional registration", 119 there *must* be a related Joomla! user, we can join */ 120 if (VmConfig::get('vm_registration_type') != 'NO_REGISTRATION' 264 FROM `#__virtuemart_vmusers` `au` 265 LEFT JOIN `#__virtuemart_userinfos` `u` 266 ON (au.virtuemart_user_id = u.virtuemart_user_id)BadBotBlocker.php https://gitlab.com/ebrjose/comcebu | PHP | 453 lines
1<?php 2namespace AIOSEO\Plugin\Common\Tools; 36 'myprintscreen.com', 37 'joinandplay.me', 38 'fbfreegifts.com', 136 'panscient.com', 137 'PHP/5.{', 138 'ProPowerBot/2.14', 352 } 353 $hosts = join( '|', $hosts ); 354 if ( preg_match( '/' . $hosts . '/i', $hostname ) ) {SfPropelBehaviorI18n.php https://github.com/bigcalm/urlcatcher.git | PHP | 352 lines
126 $foreignKey = $this->getI18nTable()->getBehavior('symfony_i18n_translation')->getForeignKey(); 127 $refPhpName = $foreignKey->getRefPhpName() ? $foreignKey->getRefPhpName() : $this->getI18nTable()->getPhpName(); 128 152{ 153 \$this->getCurrent{$refPhpName}(\$culture)->set{\$column->getPhpName()}(\$value); 154 return \$this; 206 $foreignKey = $this->getI18nTable()->getBehavior('symfony_i18n_translation')->getForeignKey(); 207 $refPhpName = $foreignKey->getRefPhpName() ? $foreignKey->getRefPhpName() : $this->getI18nTable()->getPhpName(); 208 $join = in_array($this->getBuildProperty('propel.useLeftJoinsInDoJoinMethods'), array(true, null), true) ? 'LEFT' : 'INNER'; 212 213 foreach (sfMixer::getCallables('Base{$this->getTable()->getPhpName()}:doSelectJoin:doSelectJoin') as \$sf_hook) 214 { 241 */ 242static public function doSelectWithI18n(Criteria \$criteria, \$culture = null, \$con = null, \$join_behavior = Criteria::{$join}_JOIN) 243{AesbePropostaDadosEntity.php https://gitlab.com/sejainfo/aesbe | PHP | 662 lines
1<?php 2 194 * @ORM\ManyToOne(targetEntity="Application\Entity\AesbeMaterialEntity") 195 * @ORM\JoinColumns({ 196 * @ORM\JoinColumn(name="co_material", referencedColumnName="co_material") 204 * @ORM\ManyToOne(targetEntity="Application\Entity\AesbeModalidadeLicitacaoEntity") 205 * @ORM\JoinColumns({ 206 * @ORM\JoinColumn(name="co_modalidade", referencedColumnName="co_modalidade") 214 * @ORM\ManyToOne(targetEntity="Application\Entity\AesbePropostaEntity") 215 * @ORM\JoinColumns({ 216 * @ORM\JoinColumn(name="co_proposta", referencedColumnName="co_proposta") 224 * @ORM\ManyToOne(targetEntity="Application\Entity\AesbeFornecedorEntity") 225 * @ORM\JoinColumns({ 226 * @ORM\JoinColumn(name="co_fornecedor", referencedColumnName="co_fornecedor")messages.php https://github.com/dannyrealfox/Fu-Chi--Future-Chinatown.git | PHP | 365 lines
1<?php defined('SYSPATH') or die('No direct script access.'); 2/** 4 * 5 * PHP version 5 6 * LICENSE: This source file is subject to LGPL license 176 'total_items' => ORM::factory('message') 177 ->join('reporter','message.reporter_id','reporter.id') 178 ->where($filter) 183 $messages = ORM::factory('message') 184 ->join('reporter','message.reporter_id','reporter.id') 185 ->where('service_id', $service_id) 192 $this->template->content->count_all = ORM::factory('message') 193 ->join('reporter','message.reporter_id','reporter.id') 194 ->where('service_id', $service_id) 199 $this->template->content->count_trusted = ORM::factory('message') 200 ->join('reporter','message.reporter_id','reporter.id') 201 ->where('service_id', $service_id)wiki_document.php https://github.com/nadavkav/Moodle-RTL--Shenkar-Translation-Team-.git | PHP | 280 lines
1<?php 2/** 17* Functions for iterating and retrieving the necessary records are now also included 18* in this file, rather than mod/wiki/lib.php 19*/ 23*/ 24require_once("$CFG->dirroot/search/documents/document.php"); 25require_once("$CFG->dirroot/mod/wiki/lib.php"); 76 77 return $CFG->wwwroot.'/mod/wiki/view.php?wid='.$wikiId.'&page='.wiki_name_convert($title).'&version='.$version; 78} //wiki_make_link 80/** 81* rescued and converted from ewikimoodlelib.php 82* retrieves latest version of a page 129 /* select * from wiki_pages 130 inner join 131 (select wiki_pages.pagename, max(wiki_pages.version) as verOrganizationReportController.php https://bitbucket.org/areeves42/openfisma.git | PHP | 332 lines
1<?php 2/** 63 ->from('Organization o') 64 ->leftJoin('o.System s') 65 ->leftJoin('o.OrganizationType orgType') 65 ->leftJoin('o.OrganizationType orgType') 66 ->leftJoin('o.UserRole ur') 67 ->leftJoin('ur.Role r') 67 ->leftJoin('ur.Role r') 68 ->leftJoin('ur.User u') 69 ->andWhere('orgType.nickname = ?', array('system')) 131 ) 132 ->innerJoin('o.System systemData') 133 ->innerJoin('o.OrganizationType orgType') 133 ->innerJoin('o.OrganizationType orgType') 134 ->leftJoin('Organization bureau') 135 ->andWhere('orgType.nickname = ?', array('system'))vardefs.php https://github.com/phpbugs/sugarcrm_dev.git | PHP | 358 lines
1<?php 2if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); 186 'link' => 'revisions', 187 'join_name' => 'document_revisions', 188 'vname'=>'LBL_LAST_REV_CREATE_DATE',fetch.php https://github.com/mchurchward/moodle.git | PHP | 283 lines
89 'name' => new external_value(PARAM_ALPHANUM, 'Name of the filter', VALUE_REQUIRED), 90 'jointype' => new external_value(PARAM_INT, 'Type of join for filter values', VALUE_REQUIRED), 91 'values' => new external_multiple_structure( 99 ), 100 'jointype' => new external_value(PARAM_INT, 'Type of join to join all filters together', VALUE_REQUIRED), 101 'firstinitial' => new external_value( 149 * @param array $filters The filters that will be applied in the request. 150 * @param string $jointype The join type. 151 * @param string $firstinitial The first name initial to filter on 154 * @param int $pagesize The number of records. 155 * @param string $jointype The join type. 156 * @param bool $resetpreferences Whether it is resetting table preferences or not. 181 'filters' => $filters, 182 'jointype' => $jointype, 183 'firstinitial' => $firstinitial,OAIDAO.inc.php https://github.com/mcrider/pkpUpgradeTestSuite.git | PHP | 487 lines
1<?php 2 3/** 4 * OAIDAO.inc.php 5 * 12 * 13 * $Id: OAIDAO.inc.php,v 1.20 2005/09/06 01:55:29 kevin Exp $ 14 */ 120 FROM published_articles pa, issues i, journals j, articles a 121 LEFT JOIN sections s ON s.section_id = a.section_id 122 WHERE pa.article_id = a.article_id AND j.journal_id = a.journal_id 171 FROM published_articles pa, issues i, journals j, articles a 172 LEFT JOIN sections s ON s.section_id = a.section_id 173 WHERE pa.article_id = a.article_id AND j.journal_id = a.journal_id 220 FROM published_articles pa, issues i, journals j, articles a 221 LEFT JOIN sections s ON s.section_id = a.section_id 222 WHERE pa.article_id = a.article_id AND j.journal_id = a.journal_idengine.php https://github.com/ankitagarwal/moodle.git | PHP | 391 lines
1<?php 2// This file is part of Moodle - http://moodle.org/ 78 if ($usercontexts && is_array($usercontexts)) { 79 // Join all area contexts into a single array and implode. 80 $allcontexts = array(); 149 // Sorry for the hack, but it does not seem that we will have a solution for 150 // this soon (https://bugs.mysql.com/bug.php?id=78485). 151 if ($filters->q === '*') {verify.php https://github.com/bradymiller/openemr.git | PHP | 197 lines
65 $sql = "SELECT ll.lang_id, " . "IF(LENGTH(ld.definition),ld.definition,ll.lang_description) AS trans_lang_description, " . "ll.lang_description " . 66 "FROM lang_languages AS ll " . "LEFT JOIN lang_constants AS lc ON lc.constant_name = ll.lang_description " . 67 "LEFT JOIN lang_definitions AS ld ON ld.cons_id = lc.cons_id AND " . "ld.lang_id = ? " . 88<head> 89 <title><?php echo xlt('New Patient'); ?> | <?php echo xlt('Register'); ?></title> 90 <meta name="description" content="Developed By sjpadgett@gmail.com" /> 129 <div class="text-center setup-content" id="step-1"> 130 <legend class="bg-primary text-white"><?php echo xlt('Contact Information') ?></legend> 131 <div class="jumbotron"> 131 <div class="jumbotron"> 132 <?php if ($GLOBALS['language_menu_login'] && (count($result3) != 1)) { ?> 133 <div class="form-group"> 191 </div> 192 <button type="submit" id="verifyBtn" class="btn btn-primary pull-right mb-5" type="button" disabled="disabled"><?php echo xlt('Verify Email') ?></button> 193 </div>ReportSubscriber.php https://gitlab.com/e0/mautic | PHP | 335 lines
1<?php 2/** 168 $qb->from(MAUTIC_TABLE_PREFIX . 'leads', 'l'); 169 $qb->leftJoin('l', MAUTIC_TABLE_PREFIX . 'users', 'u', 'u.id = l.owner_id'); 170 175 $qb->from(MAUTIC_TABLE_PREFIX . 'lead_points_change_log', 'lp') 176 ->leftJoin('lp', MAUTIC_TABLE_PREFIX . 'leads', 'l', 'l.id = lp.lead_id') 177 ->leftJoin('l', MAUTIC_TABLE_PREFIX . 'users', 'u', 'u.id = l.owner_id'); 177 ->leftJoin('l', MAUTIC_TABLE_PREFIX . 'users', 'u', 'u.id = l.owner_id'); 178 $event->addIpAddressLeftJoin($qb, 'lp'); 179paperclip.rb https://github.com/palladius/lovd-by-less.git | Ruby | 244 lines
8# Copyright:: Copyright (c) 2008 thoughtbot, inc. 9# License:: MIT License (http://www.opensource.org/licenses/mit-license.php) 10# 56 path = [options[:image_magick_path], command].compact 57 File.join(*path) 58 end 95 # geometry strings at the ImageMagick website 96 # (http://www.imagemagick.org/script/command-line-options.php#resize). Paperclip 97 # also adds the "#" option (e.g. "50x50#"), which will resize the image to fit maximallyfeatured.php https://github.com/eosc/EosC-2.3.git | PHP | 153 lines
1<?php 2/* 18<!-- featured_products //--> 19<?php 20if(FEATURED_PRODUCTS_DISPLAY == 'true') 48 49$featured_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, NULL as specstat, NULL as specials_new_products_price, p.products_price, pd.products_name from " . TABLE_PRODUCTS . " p left join " . TABLE_FEATURED . " f using(products_id) left join " . TABLE_PRODUCTS_DESCRIPTION . " pd using(products_id) where p.products_status = '1' and f.status = '1' and pd.language_id = '" . (int)$languages_id . "' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); 50} else { 51$info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name)); 52$featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, NULL as specstat, NULL as specials_new_products_price, p.products_price, pd.products_name from " . TABLE_PRODUCTS . " p left join " . TABLE_FEATURED . " f using(products_id) left join " . TABLE_PRODUCTS_DESCRIPTION . " pd using(products_id), " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' and pd.language_id = '" . (int)$languages_id . "' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); 53}SetTest.php https://gitlab.com/yousafsyed/easternglamor | PHP | 295 lines
1<?php 2/** 11 12class SetTest extends \PHPUnit_Framework_TestCase 13{ 14 /** 15 * @var \PHPUnit_Framework_MockObject_MockObject|Set 16 */ 19 /** 20 * @var \PHPUnit_Framework_MockObject_MockObject 21 */ 24 /** 25 * @var \PHPUnit_Framework_MockObject_MockObject 26 */ 29 /** 30 * @var \PHPUnit_Framework_MockObject_MockObject 31 */Bounce.php https://gitlab.com/virtualrealms/d7civicrm | PHP | 304 lines
1<?php 2/* 128 FROM $bounce 129 INNER JOIN $queue 130 ON $bounce.event_queue_id = $queue.id 130 ON $bounce.event_queue_id = $queue.id 131 INNER JOIN $job 132 ON $queue.job_id = $job.id 132 ON $queue.job_id = $job.id 133 INNER JOIN $mailing 134 ON $job.mailing_id = $mailing.id 200 FROM $contact 201 INNER JOIN $queue 202 ON $queue.contact_id = $contact.id 202 ON $queue.contact_id = $contact.id 203 INNER JOIN $email 204 ON $queue.email_id = $email.idTranslatableTest.php https://github.com/Atlantic18/DoctrineExtensions.git | PHP | 245 lines
1<?php 2 66 ->select('p, t') 67 ->join('p.translations', 't') 68 ->getQuery() 84 ->select('p, t') 85 ->join('p.translations', 't') 86 ->getQuery() 208 ->select('p, t') 209 ->join('p.translations', 't') 210 ->getQuery() 226 ->select('p, t') 227 ->join('p.translations', 't') 228 ->getQuery()forms_ca.php https://bitbucket.org/pombredanne/spip-zone-treemap.git | PHP | 222 lines
1<?php 2// This is a SPIP language file -- Ceci est un fichier langue de SPIP 55 'champ_specifiant' => 'Aquest camp qualifica la dada (classificació, filtre, descripció)', 56 'champ_table_jointure_type' => 'Tipus de taula per les connexions', 57 'champ_type_date' => 'Data', 59 'champ_type_fichier' => 'Fitxer per descarregar', 60 'champ_type_joint' => 'Connexió amb una altra taula', 61 'champ_type_ligne' => 'Línia de text',index.py https://gitlab.com/xiaok/SaltAdmin | Python | 237 lines
14 Str += random.sample(CharLib,1) 15 return ''.join(Str) 16 67 # 这里要从公网去解析 68 url = "http://int.dpool.sina.com.cn/iplookup/iplookup.php?format=json&ip=" + LoginHost 69 response = urllib2.urlopen(url) 124 select U.id,U.username,U.nickname,U.loginfo,L.id as LID,L.ip,L.date from login_logs as L 125 left join users as U on L.uid=U.id 126 where U.id="%s" and L.token="%s" and L.status="yes" and L.expiry>now() and U.status="yes"''' % (uid,token)) 138 if d.loginfo != d.LID: 139 g2 = db.query('''select L.ip,L.date from users as U left join login_logs as L on U.loginfo=L.id where U.id="%s"''' % uid) 140 d = g2[0] 166 try: 167 getSQL = db.query('''select u.id,u.username,u.password,u.nickname,u.status,L.ip,L.location,L.date from users as u left join login_logs as L on u.loginfo=L.id where username="%s" and password=md5("%s")''' % (getPost.username,getPost.password)) 168 except:delete.php https://github.com/AndyRixon/LayerBulletin.git | PHP | 344 lines
190 191 include 'scripts/php/auto_cache.php'; 192 250 251 INNER JOIN ' . $db_prefix . 'polls_votes pv 252 ON p.id = pv.poll_id 261 262 include 'scripts/php/auto_cache.php'; 263 269 270 template_hook('forums/delete.template.php', 'form_1'); 271 lb_redirect('index.php?forum=' . $forum_id, 'forum/' . $forum_title . '-' . $redirect); 328 329 include "scripts/php/auto_cache.php"; 330NpgsqlSchema.cs https://github.com/iainlane/mono.git | C# | 286 lines
7// npgsql-general@gborg.postgresql.org 8// http://gborg.postgresql.org/project/npgsql/projdisplay.php 9// 149 150 getDatabases.Append("SELECT d.datname AS database_name, u.usename AS owner, pg_catalog.pg_encoding_to_char(d.encoding) AS encoding FROM pg_catalog.pg_database d LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid"); 151actions.class.php https://github.com/cidesa/roraima.git | PHP | 281 lines
1<?php 2 8 * @author $Author:lhernandez $ <desarrollo@cidesa.com.ve> 9 * @version SVN: $Id:actions.class.php 32379 2009-09-01 16:59:06Z lhernandez $ 10 * 11 * @copyright Copyright 2007, Cide S.A. 12 * @license http://opensource.org/licenses/gpl-2.0.php GPLv2 13 */ 33 $c = new Criteria(); 34 $c->addJoin(FordismetperpryaccmetPeer::CODPRO,ForencpryaccespmetPeer::CODPRO); 35 $c->addJoin(FordismetperpryaccmetPeer::CODACCESP,ForencpryaccespmetPeer::CODACCESP); 35 $c->addJoin(FordismetperpryaccmetPeer::CODACCESP,ForencpryaccespmetPeer::CODACCESP); 36 $c->addJoin(FordismetperpryaccmetPeer::CODMET,ForencpryaccespmetPeer::CODMET); 37 $c->Setdistinct();class.hooks.php https://github.com/Dykam/Garden.git | PHP | 202 lines
1<?php if (!defined('APPLICATION')) exit(); 2/* 31 $Sender->SQL->From('Comment') 32 ->Join('Discussion d', 'c.DiscussionID = d.DiscussionID') 33 ->Delete('Comment c', array('d.InsertUserID' => $UserID)); 91 public function SearchController_Search_Handler($Sender) { 92 include_once(dirname(__FILE__).DS.'..'.DS.'models'.DS.'class.vanillasearchmodel.php'); 93 $SearchModel = new VanillaSearchModel(); 189 $Explicit = TRUE; 190 $Validation = new Gdn_Validation(); // This is going to be needed by structure.php to validate permission names 191 include(PATH_APPLICATIONS . DS . 'vanilla' . DS . 'settings' . DS . 'structure.php'); 193 $ApplicationInfo = array(); 194 include(CombinePaths(array(PATH_APPLICATIONS . DS . 'vanilla' . DS . 'settings' . DS . 'about.php'))); 195 $Version = ArrayValue('Version', ArrayValue('Vanilla', $ApplicationInfo, array()), 'Undefined');bp-groups-ajax.php https://github.com/alvaropereyra/shrekcms.git | PHP | 271 lines
94 <div class="item"> 95 <div class="item-title"><a href="<?php echo bp_get_group_permalink( $group ) ?>" title="<?php echo bp_get_group_name( $group ) ?>"><?php echo bp_get_group_name( $group ) ?></a></div> 96 <div class="item-meta"> 142 <h5><?php bp_group_member_link() ?></h5> 143 <span class="activity"><?php bp_group_member_joined_since() ?></span> 144 187 188 <h5><?php bp_group_member_link() ?> <?php _e( '(banned)', 'buddypress' ) ?> <span class="small"> — <a href="<?php bp_group_member_unban_link() ?>" title="<?php _e( 'Kick and ban this member', 'buddypress' ) ?>"><?php _e( 'Remove Ban', 'buddypress' ) ?></a> </h5> 189 <?php else : ?> 191 <?php bp_group_member_avatar_mini() ?> 192 <h5><?php bp_group_member_link() ?> <span class="small"> — <a href="<?php bp_group_member_ban_link() ?>" title="<?php _e( 'Kick and ban this member', 'buddypress' ) ?>"><?php _e( 'Kick & Ban', 'buddypress' ) ?></a> | <a href="<?php bp_group_member_promote_link() ?>" title="<?php _e( 'Promote this member', 'buddypress' ) ?>"><?php _e( 'Promote to Moderator', 'buddypress' ) ?></a></span></h5> 193 261 if ( 'public' == $group->status ) { 262 echo '<a id="group-' . attribute_escape( $group->id ) . '" class="join-group" rel="join" title="' . __( 'Join Group', 'buddypress' ) . '" href="' . wp_nonce_url( bp_get_group_permalink( $group ) . '/join', 'groups_join_group' ) . '">' . __( 'Join Group', 'buddypress' ) . '</a>'; 263 } else if ( 'private' == $group->status ) {SoftwareRenderer.js https://bitbucket.org/krris/3d-bin-packing.git | JavaScript | 590 lines
208 'buffer[ offset + 3 ] = material.opacity * 255;', 209 ].join('\n'); 210 217 'buffer[ offset + 3 ] = material.opacity * 255;', 218 ].join('\n'); 219 230 'buffer[ offset + 3 ] = 255;' 231 ].join('\n'); 232 275 // https://gist.github.com/2486101 276 // explanation: http://pouet.net/topic.php?which=8760&page=1 277Cost_Utils.php https://gitlab.com/kath.de/cibedo_cibedo.de | PHP | 481 lines
1<?php 2/** 280 281 LEFT JOIN {$wpdb->postmeta} 282 ON ( post_id = ID AND meta_key = '_EventCost' )Config.php https://bitbucket.org/webpolis/liiv.git | PHP | 514 lines
1<?php 2/* 22 */ 23require_once CKFINDER_CONNECTOR_LIB_DIR . "/Core/AccessControlConfig.php"; 24/** 26 */ 27require_once CKFINDER_CONNECTOR_LIB_DIR . "/Core/ResourceTypeConfig.php"; 28/** 30 */ 31require_once CKFINDER_CONNECTOR_LIB_DIR . "/Core/ThumbnailsConfig.php"; 32/** 34 */ 35require_once CKFINDER_CONNECTOR_LIB_DIR . "/Core/ImagesConfig.php"; 36 234 if (is_array($this->_hideFolders) && $this->_hideFolders) { 235 $folderRegex = join("|", $this->_hideFolders); 236 $folderRegex = strtr($folderRegex, array("?" => "__QMK__", "*" => "__AST__", "|" => "__PIP__"));allfunctions.php https://gitlab.com/Toldierone/Compounds-mirror | PHP | 372 lines
1<?php 2$mysqli = new mysqli("localhost", "username", "password", "database"); 33 session_unset(); 34 header("Location: index.php"); 35 exit; 46 if (!$GLOBALS['userinfo']['user_id']) { 47 header("Location: index.php"); 48 exit; 52 if ($GLOBALS['userinfo']['stasismode']) { 53 header("Location: userinfo.php"); 54 exit; 56 if (!$GLOBALS['userinfo']['alliance_id']) { 57 header("Location: index.php"); 58 exit; 149FROM resourcedefs rd 150LEFT JOIN resources r ON r.resource_id = rd.resource_id AND r.user_id = '{$_SESSION['user_id']}' 151ORDER BY resource_id ASCClinic.php https://gitlab.com/jeamar1234/medicloud | PHP | 242 lines
1<?php 2 79 $clinicData = DB::table('clinic') 80 ->join('clinic_types_detail', 'clinic.ClinicID', '=', 'clinic_types_detail.ClinicID') 81 ->join('clinic_types', 'clinic_types_detail.ClinicTypeID', '=', 'clinic_types.ClinicTypeID') 102 $clinicData = DB::table('clinic') 103 ->join('clinic_types_detail', 'clinic.ClinicID', '=', 'clinic_types_detail.ClinicID') 104 ->join('clinic_types', 'clinic_types_detail.ClinicTypeID', '=', 'clinic_types.ClinicTypeID') 150 $clinicData = DB::table('clinic') 151 ->join('clinic_insurence_company', 'clinic.ClinicID', '=', 'clinic_insurence_company.ClinicID') 152 //->join('insurance_company', 'clinic_insurence_company.InsuranceID', '=', 'insurance_company.CompanyID') 199 $clinicData = DB::table('clinic') 200 ->join('user', 'clinic.ClinicID', '=', 'user.Ref_ID') 201 ->select('clinic.ClinicID','clinic.Name as CLName','clinic.Clinic_Type','clinic.Description','clinic.Custom_title','clinic.Website','clinic.image as CLImage','clinic.Address as CLAddress','clinic.State as CLState','clinic.City as CLCity','clinic.Postal as CLPostal','clinic.Phone','clinic.Lat as CLLat','clinic.Lng as CLLng','clinic.Clinic_Price',aes.py https://github.com/xbmcspain/addons.git | Python | 258 lines
1#/* - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - */ 2#/* AES implementation in Python, based on the PHP implementation by */ 3#/* (c) Chris Veness 2005-2011 www.movable-type.co.uk/scripts */ 141#/* - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - */ 142#/* AES counter (CTR) mode implementation in Python, based on the PHP implementation by */ 143#/* (c) Chris Veness 2005-2011 www.movable-type.co.uk/scripts */ 213 214 ciphertxt[b] = ''.join(cipherByte) 215 215 216 return b64encode(ctrTxt + ''.join(ciphertxt)) 217 254# plaintxtByte[i] = chr(plaintxtByte[i]) 255# plaintxt.append(''.join(plaintxtByte)) 256#postgresql.php https://gitlab.com/ricardosanchez/prueba | PHP | 641 lines
74 // Special case for joins 75 foreach ($this->join as $join) 76 { 76 { 77 $query .= (string) $join; 78 } 128 // Workaround for special case of JOIN with UPDATE 129 foreach ($this->join as $join) 130 { 130 { 131 $joinElem = $join->getElements(); 132 132 133 $joinArray = explode($onWord, $joinElem[0]); 134SmartyBC.class.php https://gitlab.com/fiesta-framework/Documentation | PHP | 467 lines
1<?php 2/** 3 * Project: Smarty: the PHP compiling template engine 4 * File: SmartyBC.class.php 5 * SVN: $Id: $ 16 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA 17 * For questions, help, comments, discussion, etc., please join the 18 * Smarty mailing list. Send a blank e-mail to 30 */ 31require_once(dirname(__FILE__) . '/Smarty.class.php'); 32 55 // register {php} tag 56 $this->registerPlugin('block', 'php', 'smarty_php_tag'); 57 } 452/** 453 * Smarty {php}{/php} block function 454 *COLLADAMaxSceneGraphCreator.cpp https://bitbucket.org/ZhangJingGuo/opencollada.git | C++ | 406 lines
14for details please see LICENSE file or the website 15http://www.opensource.org/licenses/mit-license.php 16*/ 111 RefResult res = newImportNode->Reference(getDummyObject()); 112 if ( node->getType() == COLLADAFW::Node::JOINT ) 113 {joined_enquiry.php https://gitlab.com/msdusad/all_ones | PHP | 209 lines
12 echo '<script>alert("Data has been deleted!");</script>'; 13 echo '<script>window.location="joined_enquiry.php";</script>'; 14} 16 17<?php include("header.php");?> 18<div style="clear:both;"></div> 98 <td><a href="updatestatus.php?uid=<?= $fetch['id']; ?>"style="color:#000;"><?php echo $fetch['enq_status'];?></a></td> 99 <td><a href="joined_enquiry.php?did=<?= $fetch['id'];?>"><img src="img/DeleteRed.png" width="20" height="20"></a></td> 100 </tr> 182 <td><?php echo $fetch['country'];?></td> 183 <td><?php echo $fetch['country_code'];?>-<?php echo $fetch['contact'];?></td> 184 <td><?php echo $fetch['enq_type'];?></td> 188 <td><a href="updatestatus.php?uid=<?= $fetch['id']; ?>" style="color:#fff;"><?php echo $fetch['enq_status'];?></a></td> 189 <td><a href="joined_enquiry.php?did=<?= $fetch['id'];?>"><img src="img/DeleteRed.png" width="20" height="20"></a></td> 190 </tr>index.php https://github.com/rsinger/Jangle.git | PHP | 384 lines
1<?php 2 2 3require 'lib/jangle.php'; 4require 'lib/spyc.php5'; 4require 'lib/spyc.php5'; 5require 'lib/models.php'; 6 17} 18$request_uri = $config["base_uri"]."/".join($path,"/"); 19if(preg_match("/\/$/", $url["path"])) { 226 } 227 $url .= join($query_args,"&"); 228 } else {umeditor.config.js https://gitlab.com/0072016/0072016-mmzrb- | JavaScript | 257 lines
71 toString: function(){ 72 return this.protocol + ( this.stack.concat( [''] ) ).join( this.separator ); 73 } 139 //图片上传配置区 140 ,imageUrl:"../admin/upload.php?infImgUpload=1" //图片上传提交地址 141 ,imagePath:URL //图片修正地址,引用了fixedImagePath,如有特殊需求,可自行配置thread.js https://github.com/canercandan/agat-engine.git | JavaScript | 423 lines
69 } 70 Cookie.set("multiquote", new_post_ids.join("|")); 71 }, 77 this.spinner = new ActivityIndicator("body", {image: imagepath + "/spinner_big.gif"}); 78 new Ajax.Request('xmlhttp.php?action=get_multiquoted&load_all=1', {method: 'get', onComplete: function(request) {Thread.multiQuotedLoaded(request); }}); 79 return false; 151 form.setAttribute("method", "post"); 152 form.setAttribute("action", "editpost.php?action=deletepost&delete=1"); 153 form.setAttribute("style", "display: none;"); 190 { 191 MyBB.popupWindow("report.php?pid="+pid, "reportPost", 400, 300) 192 }, 207 this.spinner = new ActivityIndicator("body", {image: imagepath + "/spinner_big.gif"}); 208 new Ajax.Request('xmlhttp.php?action=edit_post&do=get_post&pid='+pid, {method: 'get', onComplete: function(request) { Thread.quickEditLoaded(request, pid); }}); 209 return false;jquery.uploadify.v2.1.0.js https://github.com/kidakaka/canvas-lms.git | JavaScript | 258 lines
33 uploader : 'uploadify.swf', // The path to the uploadify swf file 34 script : 'uploadify.php', // The path to the uploadify backend upload script 35 expressInstall : null, // The path to the express install swf file 60 pagePath.pop(); 61 pagePath = pagePath.join('/') + '/'; 62 var data = {};index.php https://github.com/sebbacon/theyworkforyou.git | PHP | 251 lines
63 } else { 64 include_once 'api_' . $method . '.php'; 65 api_call_user_func_or_error('api_' . $method, null, 'API call not yet functional', 'api'); 75 '". Possible functions are: ' . 76 join(', ', array_keys($methods)) ); 77 } else { 92 $PAGE->stripe_start(); 93 include_once 'api_' . $method . '.php'; 94 print '<p align="center"><strong>http://www.theyworkforyou.com/api/' . $method . '</strong></p>'; 112<label for="output_xml">XML</label> 113<input id="output_php" type="radio" name="output" value="php"<? if (get_http_var('output')=='php') print ' checked'?>> 114<label for="output_php">Serialised PHP</label> 177<li><strong>xml</strong>. XML. The root element is twfy.</li> 178<li><strong>php</strong>. Serialized PHP, that can be turned back into useful information with the unserialize() command. Quite useful in Python as well, using <a href="http://hurring.com/code/python/serialize/">PHPUnserialize</a>.</li> 179<li><strong>js</strong>. A JavaScript object. You can provide a callbackbanner.php https://bitbucket.org/bekket/lviveurorent.git | PHP | 461 lines
1<?php 2/** 2/** 3 * @version $Id: banner.php 19343 2010-11-03 18:12:02Z ian $ 4 * @package Joomla 6 * @copyright Copyright (C) 2005 - 2010 Open Source Matters. All rights reserved. 7 * @license GNU/GPL, see LICENSE.php 8 * Joomla! is free software. This version may have been modified pursuant 11 * other free or open source software licenses. 12 * See COPYRIGHT.php for copyright notices and details. 13 */ 95 . ' FROM #__banner AS b' 96 . ' LEFT JOIN #__categories AS cc ON cc.id = b.catid' 97 . $where 106 . ' FROM #__banner AS b' 107 . ' INNER JOIN #__bannerclient AS c ON c.cid = b.cid' 108 . ' LEFT JOIN #__categories AS cc ON cc.id = b.catid'class-wp-filesystem-base.php https://gitlab.com/endomorphosis/reservationtelco | PHP | 321 lines
1<?php 2/** 198 //Lets try that folder: 199 $newdir = trailingslashit(path_join($base, $key)); 200 if ( $this->verbose ) 222 * 223 * From the PHP documentation page for fileperms() 224 * 224 * 225 * @link http://docs.php.net/fileperms 226 * @since 2.5 277 * Converts '-rw-r--r--' to 0644 278 * From "info at rvgate dot nl"'s comment on the PHP documentation for chmod() 279 * 279 * 280 * @link http://docs.php.net/manual/en/function.chmod.php#49614 281 * @since 2.5Db.php https://github.com/gryzz/crystal_magento.git | PHP | 415 lines
1<?php 2/** 9 * It is also available through the world-wide-web at this URL: 10 * http://opensource.org/licenses/osl-3.0.php 11 * If you did not receive a copy of the license and are unable to 23 * @copyright Copyright (c) 2010 Magento Inc. (http://www.magentocommerce.com) 24 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 25 */ 154 $this->_read->quoteIdentifier($table), 155 join(",\n ", $foreignKeys) 156 ); 215 } 216 return '('.join(',', $rowData).')'; 217 }vardefs.php https://github.com/xno/sugarcrm_dev.git | PHP | 458 lines
1<?php 2/********************************************************************************* 147 'operator' => 'subquery', 148 'subquery' => 'SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE', 149 'db_field' => array( 443 'relationship_type'=>'many-to-many', 444 'join_table'=> 'email_addr_bean_rel', 'join_key_lhs'=>'bean_id', 'join_key_rhs'=>'email_address_id', 445 'relationship_role_column'=>'bean_module', 451 'relationship_type'=>'many-to-many', 452 'join_table'=> 'email_addr_bean_rel', 'join_key_lhs'=>'bean_id', 'join_key_rhs'=>'email_address_id', 453 'relationship_role_column'=>'primary_address',wp_posts.php https://gitlab.com/meixnertobias/thaimaidaiproductionwp | PHP | 348 lines
1<?php 2defined('WYSIJA') or die('Restricted access'); 45 * SELECT A.ID, A.post_title, A.post_content, A.post_date FROM `wp_posts` A 46 * LEFT JOIN `wp_term_relationships` B ON (A.ID = B.object_id) 47 * LEFT JOIN `wp_term_taxonomy` C ON (C.term_taxonomy_id = B.term_taxonomy_id) 128 129 $query = sprintf('SELECT DISTINCT %s FROM `[wp]' . $this->table_name . '` A ', join(', ', $post_fields)); 130 136 if((isset($args['category']) && !empty($args['category'])) || (isset($args['not_category']) && !empty($args['not_category']))) { 137 $query_joins = 'JOIN `[wp]term_relationships` B ON (A.ID = B.object_id) '; 138 $query_joins .= 'JOIN `[wp]term_taxonomy` C ON (C.term_taxonomy_id = B.term_taxonomy_id) '; 139 140 $query .= $query_joins; 141 142 if($args['is_search_query'] === true) { 143 $count_query .= $query_joins; 144 }autoptimizeBase.php https://gitlab.com/hop23typhu/list-theme | PHP | 317 lines
1<?php 2if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly 14 15 //Joins and optimizes collected things 16 abstract public function minify(); 38 } 39 } else if ((strpos($url,'//')===false) && (strpos($url,parse_url(AUTOPTIMIZE_WP_SITE_URL,PHP_URL_HOST))===false)) { 40 $url = AUTOPTIMIZE_WP_SITE_URL.$url; 43 // first check; hostname wp site should be hostname of url 44 $thisHost=@parse_url($url,PHP_URL_HOST); 45 if ($thisHost!==parse_url(AUTOPTIMIZE_WP_SITE_URL,PHP_URL_HOST)) { 59 if (!empty($this->cdn_url)) { 60 $multidomains[]=parse_url($this->cdn_url,PHP_URL_HOST); 61 } 66 if (in_array($thisHost,$multidomains)) { 67 $url=str_replace($thisHost, parse_url(AUTOPTIMIZE_WP_SITE_URL,PHP_URL_HOST), $url); 68 } else {util.py https://bitbucket.org/verilab/tanto.git | Python | 426 lines
4# This module is part of Mako and is released under 5# the MIT License: http://www.opensource.org/licenses/mit-license.php 6 189 if self.encoding: 190 return self.delim.join(self.data).encode(self.encoding, 191 self.errors) 192 else: 193 return self.delim.join(self.data) 194 311 keys.sort() 312 return "{" + ", ".join(["%r: %r" % (k, d[k]) for k in keys]) + "}" 313alias-class.cpp https://gitlab.com/Blueprint-Marketing/hhvm | C++ | 374 lines
10 | http://www.php.net/license/3_01.txt | 11 | If you did not receive a copy of the PHP license and are unable to | 12 | obtain it through the world-wide-web, please send a note to | 12 | obtain it through the world-wide-web, please send a note to | 13 | license@php.net so we can mail you a copy immediately. | 14 +----------------------------------------------------------------------+ 26 27namespace HPHP { namespace jit { 28 78 auto const specialized = specialized_classes(unit); 79 auto const joined = boost::join(generic_classes(), specialized); 80 113 for (auto c1 : joined) { 114 for (auto c2 : joined) { 115 if (c1 == c2) EXPECT_TRUE(c1 <= c2);PropelPager.php https://github.com/1989gaurav/Propel.git | PHP | 597 lines
1<?php 2 15 * 16 * require_once 'propel/util/PropelPager.php'; 17 * require_once 'PEACH/Propel/Poem/poemPeer.php'; 21 * 22 * // with join 23 * $pager = new PropelPager($c, 'poemPeer', 'doSelectJoinPoemUsers', 1, 50); 24 * 25 * // without Join 26 * 221 * Sets the Count method. 222 * This is set based on the Peer method, for example if Peer method is doSelectJoin*() then the 223 * count method will be doCountJoin*(). 246 $countMethod = 'doCount'; 247 } elseif ( ($pos = stripos($selectMethod, 'doSelectJoin')) === 0) { 248 $countMethod = 'doCount' . substr($selectMethod, strlen('doSelect'));AdminApPageBuilderPositions.php https://gitlab.com/ptisky/API_prestashop | PHP | 398 lines
1<?php 2/** 16 17require_once(_PS_MODULE_DIR_.'appagebuilder/classes/ApPageBuilderPositionsModel.php'); 18 39 $this->order_way = 'DESC'; 40 $this->_join = ' 41 INNER JOIN `'._DB_PREFIX_.'appagebuilder_positions_shop` ps ON (ps.`id_appagebuilder_positions` = a.`id_appagebuilder_positions`)';translated-object.php https://gitlab.com/hop23typhu/bryepoxy | PHP | 272 lines
1<?php 2 259 * Returns ids of objects in a language similarly to get_objects_in_term for a taxonomy 260 * faster than get_objects_in_term as it avoids a JOIN 261 *ReplaceSource.js https://gitlab.com/ahmad.jamal/sally | JavaScript | 471 lines
1/* 2 MIT License http://www.opensource.org/licenses/mit-license.php 3 Author Tobias Koppers @sokra 99 result.push(current); 100 return result.join(""); 101 }test.php https://gitlab.com/LisovyiEvhenii/ismextensions | PHP | 305 lines
1<?php 2/** 9 * It is also available through the world-wide-web at this URL: 10 * http://opensource.org/licenses/osl-3.0.php 11 * If you did not receive a copy of the license and are unable to 23 * @copyright Copyright (c) 2006-2016 X.commerce, Inc. and affiliates (http://www.magento.com) 24 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 25 */ 25 */ 26include "lib/Varien/Object.php"; 27 51 $actions = $this->getOrderActions(); 52 $actions = join(', ', array_keys($actions)); 53 #echo "<tr><td>$orderStatus</td><td>$paymentStatus</td><td>$shippingStatus</td><td>$refundStatus</td><td>$returnStatus</td><td>$adminStatus</td><td>$frontendStatus</td><td>$actions</td></tr>";Hooks.php https://bitbucket.org/blackriver/openx.git | PHP | 253 lines
1<?php 2 26*/ 27require_once MAX_PATH . '/lib/OX/Admin/UI/Event/EventDispatcher.php'; 28require_once MAX_PATH . '/lib/OX/Admin/UI/Event/EventContext.php'; 32 * 33 * Allows registration of event listeners in the form of {@link http://www.php.net/manual/en/language.pseudo-types.php#language.types.callback callback} 34 * and when informed of an event it will pass the event to registered listeners. 82 * 83 * @param PHP callback $callback 84 */ 118 * 119 * @param PHP callback $callback 120 */ 149 if (!empty($aStrings)) { 150 $result = join('\n', $aStrings); 151 }store.php https://gitlab.com/alexprowars/bitrix | PHP | 415 lines
1<?php 2 167 UserTable::class, 168 Main\ORM\Query\Join::on('this.USER_ID', 'ref.ID') 169 ), 179 UserTable::class, 180 Main\ORM\Query\Join::on('this.MODIFIED_BY', 'ref.ID') 181 ),Abstract.php https://bitbucket.org/acidel/buykoala.git | PHP | 287 lines
1<?php 2/** 9 * It is also available through the world-wide-web at this URL: 10 * http://opensource.org/licenses/osl-3.0.php 11 * If you did not receive a copy of the license and are unable to 23 * @copyright Copyright (c) 2011 Magento Inc. (http://www.magentocommerce.com) 24 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 25 */ 189 ->from(array('l' => $this->getTable('catalog/product_relation')), 'parent_id') 190 ->join( 191 array('cs' => $this->getTable('core/store')), 193 array()) 194 ->join( 195 array('i' => $idxTable),blog_user.php https://gitlab.com/Rad1calDreamer/honey | PHP | 433 lines
1<? 2require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/blog/general/blog_user.php"); 3 264 265 "USER_LOGIN" => array("FIELD" => "U.LOGIN", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (B.USER_ID = U.ID)"), 266 "USER_NAME" => array("FIELD" => "U.NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (B.USER_ID = U.ID)"), 266 "USER_NAME" => array("FIELD" => "U.NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (B.USER_ID = U.ID)"), 267 "USER_LAST_NAME" => array("FIELD" => "U.LAST_NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (B.USER_ID = U.ID)"), 268 "USER_SECOND_NAME" => array("FIELD" => "U.SECOND_NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (B.USER_ID = U.ID)"), 268 "USER_SECOND_NAME" => array("FIELD" => "U.SECOND_NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (B.USER_ID = U.ID)"), 269 "USER_EMAIL" => array("FIELD" => "U.EMAIL", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (B.USER_ID = U.ID)"), 270 "USER" => array("FIELD" => "U.LOGIN,U.NAME,U.LAST_NAME,U.SECOND_NAME,U.EMAIL,U.ID", "WHERE_ONLY" => "Y", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (B.USER_ID = U.ID)"), 271 272 "GROUP_GROUP_ID" => array("FIELD" => "U2UG.USER_GROUP_ID", "TYPE" => "int", "FROM" => "INNER JOIN b_blog_user2user_group U2UG ON (B.USER_ID = U2UG.USER_ID)"), 273 "GROUP_BLOG_ID" => array("FIELD" => "U2UG.BLOG_ID", "TYPE" => "int", "FROM" => "INNER JOIN b_blog_user2user_group U2UG ON (B.USER_ID = U2UG.USER_ID)"),QueryInterface.php https://gitlab.com/Griffolion/Game-Embargo-Tracker | PHP | 255 lines
1<?php 2/** 164 * Adds an additional WHERE condition to the existing one. 165 * The new condition and the existing one will be joined using the 'AND' operator. 166 * @param string|array $condition the new WHERE condition. Please refer to [[where()]] 175 * Adds an additional WHERE condition to the existing one. 176 * The new condition and the existing one will be joined using the 'OR' operator. 177 * @param string|array $condition the new WHERE condition. Please refer to [[where()]] 197 * Adds an additional WHERE condition to the existing one ignoring empty parameters. 198 * The new condition and the existing one will be joined using the 'AND' operator. 199 * @param array $condition the new WHERE condition. Please refer to [[where()]] 208 * Adds an additional WHERE condition to the existing one ignoring empty parameters. 209 * The new condition and the existing one will be joined using the 'OR' operator. 210 * @param array $condition the new WHERE condition. Please refer to [[where()]]blogger.php https://bitbucket.org/pastor399/newcastleunifc.git | PHP | 323 lines
1<?php 2/** 4 * @copyright Copyright (C) 2010 Stack Ideas Private Limited. All rights reserved. 5 * @license GNU/GPL, see LICENSE.php 6 * 10 * other free or open source software licenses. 11 * See COPYRIGHT.php for copyright notices and details. 12 */ 15 16require_once( dirname( __FILE__ ) . DIRECTORY_SEPARATOR . 'parent.php' ); 17 73 74 require_once( EBLOG_HELPERS . DIRECTORY_SEPARATOR . 'helper.php' ); 75 $config = EasyBlogHelper::getConfig(); 88 $query .= ' FROM `#__users` AS `a`'; 89 $query .= ' INNER JOIN `#__easyblog_users` AS `b` ON a.`id` = b.`id`'; 90Entity.php https://gitlab.com/LisovyiEvhenii/ismextensions | PHP | 354 lines
210 $joinArrAttr = array(); 211 $joinArrAttr['attribute'] = isset($joinAttr['attribute']) ? $joinAttr['attribute'] : null; 212 $joinArrAttr['alias'] = isset($joinAttr['attribute']) ? str_replace('/','_',$joinAttr['attribute']):null; 213 $joinArrAttr['bind'] = isset($joinAttr['bind']) ? $joinAttr['bind'] : null; 214 $joinArrAttr['joinType'] = isset($joinAttr['joinType']) ? $joinAttr['joinType'] : null; 215 $joinArrAttr['storeId'] = isset($joinAttr['storeId']) ? $joinAttr['storeId'] : $this->getStoreId(); 215 $joinArrAttr['storeId'] = isset($joinAttr['storeId']) ? $joinAttr['storeId'] : $this->getStoreId(); 216 $this->_joinAttr[] = $joinArrAttr; 217 } 256 257 if (isset($this->_joinAttr) && is_array($this->_joinAttr)) { 258 foreach ($this->_joinAttr as $val) { 278 $joinFields = $this->_joinField; 279 if (isset($joinFields) && is_array($joinFields)) { 280 foreach ($joinFields as $field) {tracks.php https://github.com/rietn/minima.git | PHP | 461 lines
1<?php 2/** 2/** 3 * @version $Id: tracks.php 20267 2011-01-11 03:44:44Z eddieajau $ 4 * @copyright Copyright (C) 2005 - 2011 Open Source Matters, Inc. All rights reserved. 95 96 require_once JPATH_COMPONENT.'/helpers/banners.php'; 97 109 110 // Join with the banners 111 $query->join('LEFT','`#__banners` as b ON b.id=a.banner_id'); 113 114 // Join with the client 115 $query->join('LEFT','`#__banner_clients` as cl ON cl.id=b.cid'); 117 118 // Join with the category 119 $query->join('LEFT','`#__categories` as cat ON cat.id=b.catid');pagination.rst https://github.com/markstory/cakephp-docs.git | ReStructuredText | 341 lines
42 43You can also include other :php:meth:`~Model::find()` options, such as 44``fields``:: 61is: ``conditions``, ``fields``, ``order``, ``limit``, ``page``, ``contain``, 62``joins``, and ``recursive``. In addition to the aforementioned keys, any 63additional keys will also be passed directly to the model find methods. This 97additional information is set to ``$this->request->params['paging']``, and is 98used by :php:class:`PaginatorHelper` for creating links. 99:php:meth:`PaginatorComponent::paginate()` also adds 327It's very easy to incorporate Ajax functionality into pagination. 328Using the :php:class:`JsHelper` and :php:class:`RequestHandlerComponent` you can 329easily add Ajax pagination to your application. See :ref:`ajax-pagination` for 340 :title lang=en: Pagination 341 :keywords lang=en: order array,query conditions,php class,web applications,headaches,obstacles,complexity,programmers,parameters,paginate,designers,cakephp,satisfaction,developers 342SparqlEngineDb.php https://github.com/drobbins/s3db.git | PHP | 391 lines
1<?php 2require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngine.php'; 2require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngine.php'; 3require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngineDb/Offsetter.php'; 4require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngineDb/QuerySimplifier.php'; 4require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngineDb/QuerySimplifier.php'; 5require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngineDb/ResultConverter.php'; 6require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngineDb/SqlGenerator.php'; 6require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngineDb/SqlGenerator.php'; 7require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngineDb/SqlMerger.php'; 8 12* letting the database system do all the hard work like 13* selecting, joining, filtering and ordering results. 14* 167 { 168 require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngineDb/PreparedStatement.php'; 169 require_once RDFAPI_INCLUDE_DIR . 'sparql/SparqlEngineDb/Preparator.php';loan_list.php https://github.com/awriel/s3st15_matoa.git | PHP | 205 lines
1<?php 2/** 29// main system configuration 30require '../../../sysconfig.inc.php'; 31// IP based access limitation 31// IP based access limitation 32require LIB_DIR.'ip_based_access.inc.php'; 33do_checkIP('smc'); 35// start the session 36require SENAYAN_BASE_DIR.'admin/default/session.inc.php'; 37require SENAYAN_BASE_DIR.'admin/default/session_check.inc.php'; 40 41require SIMBIO_BASE_DIR.'simbio_GUI/form_maker/simbio_form_table_AJAX.inc.php'; 42require SIMBIO_BASE_DIR.'simbio_GUI/table/simbio_table.inc.php'; 42require SIMBIO_BASE_DIR.'simbio_GUI/table/simbio_table.inc.php'; 43require SIMBIO_BASE_DIR.'simbio_GUI/paging/simbio_paging.inc.php'; 44require SIMBIO_BASE_DIR.'simbio_DB/simbio_dbop.inc.php';view.py https://github.com/cwallenpoole/PyFram-Tutorial.git | Python | 404 lines
20 could otherwise break the DOM. It is meant to parallel the strip_tags function 21 that is in PHP. 22 ''' 71 result = ['{0}="{1}"'.format(*x) if len(x) == 2 else x for x in attrs] 72 return ' '.join(result) 73 85 self.error("The following tag(s) remain unclosed: {0}".\ 86 format(', '.join(self.open_tags))) 87Pgsql.php https://github.com/grjones/qframe.git | PHP | 336 lines
1<?php 2/** 19 * @license http://framework.zend.com/license/new-bsd New BSD License 20 * @version $Id: Pgsql.php 22789 2010-08-03 19:01:10Z ramon $ 21 */ 26 */ 27require_once 'Zend/Db/Adapter/Pdo/Abstract.php'; 28 101 { 102 // @todo use a better query with joins instead of subqueries 103 $sql = "SELECT c.relname AS table_name " 164 FROM pg_attribute AS a 165 JOIN pg_class AS c ON a.attrelid = c.oid 166 JOIN pg_namespace AS n ON c.relnamespace = n.oid 166 JOIN pg_namespace AS n ON c.relnamespace = n.oid 167 JOIN pg_type AS t ON a.atttypid = t.oid 168 LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oidString.php https://github.com/joshbhamilton/todophp.git | PHP | 440 lines
1<?php 2/** 2/** 3 * Lithium: the most rad php framework 4 * 5 * @copyright Copyright 2011, Union of RAD (http://union-of-rad.org) 6 * @license http://opensource.org/licenses/mit-license.php The MIT License 7 */ 65 66 return join('-', array( 67 bin2hex(substr($uuid, 0, 4)), 154 * 155 * @link http://php.net/manual/en/function.hash.php PHP Manual: `hash()` 156 * @link http://php.net/manual/en/function.hash-hmac.php PHP Manual: `hash_hmac()` 156 * @link http://php.net/manual/en/function.hash-hmac.php PHP Manual: `hash_hmac()` 157 * @link http://php.net/manual/en/function.hash-algos.php PHP Manual: `hash_algos()` 158 * @param string $string The string to hash.cat_msproduct_get.php https://gitlab.com/ptisky/API_prestashop | PHP | 311 lines
1<?php 2/** 49 FROM `'._DB_PREFIX_.'tax_rules_group` trg 50 LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (trg.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = '.(int)SCI::getDefaultCountryId().' AND tr.`id_state` = 0) 51 LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = tr.`id_tax`) 267 $sql.=" FROM "._DB_PREFIX_."product_shop ps 268 ".((!empty($sc_agent->id_employee))?" INNER JOIN "._DB_PREFIX_."employee_shop es ON (es.id_shop = ps.id_shop AND es.id_employee = '".(int)$sc_agent->id_employee."') ":"").""; 269 sc_ext::readCustomMsProductGridConfigXML('SQLSelectDataLeftJoin');Pgsql.php https://github.com/rgranadino/magento-mirror.git | PHP | 336 lines
1<?php 2/** 19 * @license http://framework.zend.com/license/new-bsd New BSD License 20 * @version $Id: Pgsql.php 22788 2010-08-03 18:29:55Z ramon $ 21 */ 26 */ 27#require_once 'Zend/Db/Adapter/Pdo/Abstract.php'; 28 101 { 102 // @todo use a better query with joins instead of subqueries 103 $sql = "SELECT c.relname AS table_name " 164 FROM pg_attribute AS a 165 JOIN pg_class AS c ON a.attrelid = c.oid 166 JOIN pg_namespace AS n ON c.relnamespace = n.oid 166 JOIN pg_namespace AS n ON c.relnamespace = n.oid 167 JOIN pg_type AS t ON a.atttypid = t.oid 168 LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oidTemplate.php https://github.com/rgranadino/magento-mirror.git | PHP | 395 lines
1<?php 2/** 9 * It is also available through the world-wide-web at this URL: 10 * http://opensource.org/licenses/osl-3.0.php 11 * If you did not receive a copy of the license and are unable to 23 * @copyright Copyright (c) 2011 Magento Inc. (http://www.magentocommerce.com) 24 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 25 */ 114 115 Mage::throwException(join("\n", $errorMessages)); 116 }SqlServerGrammar.php https://gitlab.com/Pasantias/pasantiasASLG | PHP | 344 lines
1<?php 2 297 298 // If the query has any "join" clauses, we will setup the joins on the builder 299 // and compile them so we can attach them to this update, as update queries 299 // and compile them so we can attach them to this update, as update queries 300 // can get join statements to attach to other tables when they're needed. 301 if (isset($query->joins)) { 301 if (isset($query->joins)) { 302 $joins = ' '.$this->compileJoins($query, $query->joins); 303 } else { 303 } else { 304 $joins = ''; 305 } 311 312 if (! empty($joins)) { 313 return trim("update {$alias} set {$columns} from {$table}{$joins} {$where}");Collection.php https://bitbucket.org/kdms/sh-magento.git | PHP | 376 lines
1<?php 2/** 51 /** 52 * Array with joined tables 53 * 55 */ 56 protected $_joinFlags = array(); 57 65 parent::_initSelect(); 66 $this->_joinFields(); 67 $this->_setIdFieldName('tag_relation_id'); 71 /** 72 * Set flag about joined table. 73 * setFlag method must be used in future. 79 */ 80 public function setJoinFlag($table) 81 {polls.php https://github.com/Bigjoos/U-232-V1.git | PHP | 391 lines
1<?php 2/** 27 $query = sql_query("SELECT * FROM polls 28 LEFT JOIN poll_voters ON polls.pid = poll_voters.poll_id 29 AND poll_voters.user_id = {$CURUSER['id']} 260 { 261 window.location = \"{$TBDEV['baseurl']}/index.php?pollid={$pid}&mode=show&st=main\"; 262 } 264 { 265 window.location = \"{$TBDEV['baseurl']}/index.php?pollid={$pid}&st=main\"; 266 } 268 </script> 269 <form action='{$TBDEV['baseurl']}/polls_take_vote.php?pollid={$pid}&st=main&addpoll=1' method='post'> 270 <div class='roundedCorners' style='text-align: left; width: 80%; border: 1px solid black; padding: 5px;'>CHANGELOG.md https://gitlab.com/abdulhamid909/backupbantuapasaja | Markdown | 414 lines
47###v6.7.3 - 2016-03-02 48 - Fix eager load multiple column sorting where other columns are being ignored when join statement already exists. 49 - Refactor redundant else order by statement. 50 - Call eager loads only when required when filtering and ordering. 51 - Extract eager loaded column join statement handler. 52 105 - PR #381. Credits to @ikerasLT. 106 - Fix implementation conflicts when using builder and join statements. 107 - Fix cs and doc blocks. 152###v6.1.2 153 - Fix possible conflict with Laravel helpers.php file auto-loading. Fix #330. 154 - Update dataTable service class stub. 164 - Provides DataTable Service. 165 - Provides artisan command for creating a service. php artisan datatables:make UsersDataTable 166 - Provides artisan command for creating a DataTable scope. php artisan datatables:scope ActiveUserScopePgsql.php https://github.com/Doap/iCms---intelligent-Content-management-system.git | PHP | 336 lines
1<?php 2/** 19 * @license http://framework.zend.com/license/new-bsd New BSD License 20 * @version $Id: Pgsql.php 22788 2010-08-03 18:29:55Z ramon $ 21 */ 26 */ 27require_once 'Zend/Db/Adapter/Pdo/Abstract.php'; 28 101 { 102 // @todo use a better query with joins instead of subqueries 103 $sql = "SELECT c.relname AS table_name " 164 FROM pg_attribute AS a 165 JOIN pg_class AS c ON a.attrelid = c.oid 166 JOIN pg_namespace AS n ON c.relnamespace = n.oid 166 JOIN pg_namespace AS n ON c.relnamespace = n.oid 167 JOIN pg_type AS t ON a.atttypid = t.oid 168 LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oidresources_zh_CN.properties https://bitbucket.org/LANJr4D/sc-android.git | Properties File | 304 lines
59cancel=&取消 60chatRoomAlreadyJoined=已加入聊天室 {0}. 61chatRoomConfiguration=聊天室 {0} 属性配置 64chatRoomConfigFormSubmitFailed=提交聊天室 {0} 配置失败, 发生错误. 65chatRoomUserJoined=已加入 {0} 66chatRoomUserLeft=已离开 {0} 72chatRoomNotConnected=您需要先登录, 然后才能进入聊天室 {0}. 73chatRoomNotJoined=您需要先进入聊天室, 然后才能做进一步操作. 74chatRoomOptions=聊天室选项 126failedToCreateChatRoom=创建聊天室 {0} 失败. 127failedToJoinChatRoom=加入聊天室 {0} 失败. 128ffcStatus=可以聊天了 133font=字体 134haveToBeConnectedToJoin=您必须先登录上服务器才能加入聊天室, 请登录后重试. 135haveToBeConnectedToLeave=您必须先登录上服务器才能退出聊天室.local_fa.php https://bitbucket.org/pombredanne/spip-zone-treemap.git | PHP | 224 lines
1<?php 2if (!defined("_ECRIRE_INC_VERSION")) return; 45 'document' => 'سند', 46 'documents_joints' => 'سندهاي پيوست', 47user_lang.php https://github.com/JamieLomas/pyrocms.git | PHP | 213 lines
1<?php 2 26$lang['user_name_label'] = 'Naam'; 27$lang['user_joined_label'] = 'Lid sinds'; 28$lang['user_last_visit_label'] = 'Laatste bezoek';edit.php https://gitlab.com/Gashler/sg | PHP | 342 lines
1<?php 2/** 9/** WordPress Administration Bootstrap */ 10require_once( dirname( __FILE__ ) . '/admin.php' ); 11 15if ( 'attachment' === $typenow ) { 16 if ( wp_redirect( admin_url( 'upload.php' ) ) ) { 17 exit; 41 if ( ! empty( $_REQUEST[ $_redirect ] ) ) { 42 wp_redirect( admin_url( 'edit-comments.php?p=' . absint( $_REQUEST[ $_redirect ] ) ) ); 43 exit; 48if ( 'post' != $post_type ) { 49 $parent_file = "edit.php?post_type=$post_type"; 50 $submenu_file = "edit.php?post_type=$post_type"; 50 $submenu_file = "edit.php?post_type=$post_type"; 51 $post_new_file = "post-new.php?post_type=$post_type"; 52} else {Collection.php https://gitlab.com/crazybutterfly815/magento2 | PHP | 347 lines
1<?php 2/** 14 * Sales Rules resource collection model. 15 * @SuppressWarnings(PHPMD.CouplingBetweenObjects) 16 */ 126 * @use $this->addWebsiteGroupDateFilter() 127 * @SuppressWarnings(PHPMD.UnusedFormalParameter) 128 * @return $this 137 if (!$this->getFlag('validation_filter')) { 138 /* We need to overwrite joinLeft if coupon is applied */ 139 $this->getSelect()->reset(); 146 if (strlen($couponCode)) { 147 $select->joinLeft( 148 ['rule_coupons' => $this->getTable('salesrule_coupon')], 224 $connection = $this->getConnection(); 225 $this->getSelect()->joinInner( 226 ['customer_group_ids' => $this->getTable($entityInfo['associations_table'])],Tag.php https://github.com/rgranadino/magento-mirror.git | PHP | 432 lines
1<?php 2/** 9 * It is also available through the world-wide-web at this URL: 10 * http://opensource.org/licenses/osl-3.0.php 11 * If you did not receive a copy of the license and are unable to 23 * @copyright Copyright (c) 2011 Magento Inc. (http://www.magentocommerce.com) 24 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 25 */ 176 ) 177 ->join(array('store' => $this->getTable('core/store')), 178 'store.store_id = main.store_id AND store.store_id > 0', 180 ) 181 ->join(array('product_website' => $this->getTable('catalog/product_website')), 182 'product_website.website_id = store.website_id AND product_website.product_id = main.product_id', 196 ) 197 ->join(array('store' => $this->getTable('core/store')), 198 'store.store_id = main.store_id AND store.store_id > 0',class.FixtureBuilder.php https://github.com/dagda/ThinkUp.git | PHP | 346 lines
1<?php 2/** 193 } 194 $sql .= sprintf(" (%s) VALUES", join(',', array_keys($this->columns) )); 195 $values = array_values($this->columns);Pgsql.php https://bitbucket.org/Dal-Papa/is-340-publish-base.git | PHP | 336 lines
1<?php 2/** 19 * @license http://framework.zend.com/license/new-bsd New BSD License 20 * @version $Id: Pgsql.php 24593 2012-01-05 20:35:02Z matthew $ 21 */ 26 */ 27require_once 'Zend/Db/Adapter/Pdo/Abstract.php'; 28 101 { 102 // @todo use a better query with joins instead of subqueries 103 $sql = "SELECT c.relname AS table_name " 164 FROM pg_attribute AS a 165 JOIN pg_class AS c ON a.attrelid = c.oid 166 JOIN pg_namespace AS n ON c.relnamespace = n.oid 166 JOIN pg_namespace AS n ON c.relnamespace = n.oid 167 JOIN pg_type AS t ON a.atttypid = t.oid 168 LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oidPgsql.php https://github.com/StefanRHRO/SCRM.git | PHP | 336 lines
1<?php 2/** 19 * @license http://framework.zend.com/license/new-bsd New BSD License 20 * @version $Id: Pgsql.php 23775 2011-03-01 17:25:24Z ralph $ 21 */ 26 */ 27require_once 'Zend/Db/Adapter/Pdo/Abstract.php'; 28 101 { 102 // @todo use a better query with joins instead of subqueries 103 $sql = "SELECT c.relname AS table_name " 164 FROM pg_attribute AS a 165 JOIN pg_class AS c ON a.attrelid = c.oid 166 JOIN pg_namespace AS n ON c.relnamespace = n.oid 166 JOIN pg_namespace AS n ON c.relnamespace = n.oid 167 JOIN pg_type AS t ON a.atttypid = t.oid 168 LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oidpyodbc.py https://gitlab.com/ztane/sqlalchemy | Python | 260 lines
4# This module is part of SQLAlchemy and is released under 5# the MIT License: http://www.opensource.org/licenses/mit-license.php 6 158 '0' * (abs(value.adjusted()) - 1), 159 "".join([str(nint) for nint in value.as_tuple()[1]])) 160 165 (value < 0 and '-' or ''), 166 "".join([str(s) for s in _int]), 167 "0" * (value.adjusted() - (len(_int) - 1))) 171 (value < 0 and '-' or ''), 172 "".join( 173 [str(s) for s in _int][0:value.adjusted() + 1]), 173 [str(s) for s in _int][0:value.adjusted() + 1]), 174 "".join( 175 [str(s) for s in _int][value.adjusted() + 1:]))Template.php https://bitbucket.org/sevenly/magento-ce.git | PHP | 395 lines
1<?php 2/** 9 * It is also available through the world-wide-web at this URL: 10 * http://opensource.org/licenses/osl-3.0.php 11 * If you did not receive a copy of the license and are unable to 23 * @copyright Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com) 24 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 25 */ 114 115 Mage::throwException(join("\n", $errorMessages)); 116 }LimitTestCase.php https://github.com/robertleeplummerjr/bluebox.git | PHP | 329 lines
66 $this->assertEqual($q->getSqlQuery(), 67 "SELECT p.id AS p__id, p.name AS p__name FROM photo p LEFT JOIN phototag p2 ON (p.id = p2.photo_id) LEFT JOIN tag t ON t.id = p2.tag_id WHERE p.id IN (SELECT DISTINCT p3.id FROM photo p3 LEFT JOIN phototag p4 ON (p3.id = p4.photo_id) LEFT JOIN tag t2 ON t2.id = p4.tag_id WHERE t2.id = ? ORDER BY p3.id DESC LIMIT 100) AND t.id = ? ORDER BY p.id DESC"); 68 } 97 $this->assertEqual($q->getSqlQuery(), 98 'SELECT e.id AS e__id, p.id AS p__id, p.phonenumber AS p__phonenumber, p.entity_id AS p__entity_id FROM entity e LEFT JOIN phonenumber p ON e.id = p.entity_id WHERE e.id IN (SELECT DISTINCT e2.id FROM entity e2 LEFT JOIN phonenumber p2 ON e2.id = p2.entity_id WHERE (e2.type = 0) LIMIT 5) AND (e.type = 0)'); 99 224 225 $this->assertEqual($q->getSqlQuery(), 'SELECT e.id AS e__id, e.name AS e__name, e.loginname AS e__loginname, e.password AS e__password, e.type AS e__type, e.created AS e__created, e.updated AS e__updated, e.email_id AS e__email_id, p.id AS p__id, p.phonenumber AS p__phonenumber, p.entity_id AS p__entity_id FROM entity e LEFT JOIN phonenumber p ON e.id = p.entity_id WHERE e.id IN (SELECT DISTINCT e2.id FROM entity e2 LEFT JOIN phonenumber p2 ON e2.id = p2.entity_id WHERE e2.name = ? AND (e2.type = 0) LIMIT 5) AND e.name = ? AND (e.type = 0)'); 226 294 295 $this->assertEqual($q->getSqlQuery(), "SELECT e.id AS e__id, e.name AS e__name, e.loginname AS e__loginname, e.password AS e__password, e.type AS e__type, e.created AS e__created, e.updated AS e__updated, e.email_id AS e__email_id FROM entity e LEFT JOIN groupuser g ON (e.id = g.user_id) LEFT JOIN entity e2 ON e2.id = g.group_id AND e2.type = 1 WHERE e2.name = ? AND (e.type = 0) ORDER BY e.id DESC LIMIT 5"); 296 $this->manager->setAttribute(Doctrine::ATTR_QUERY_LIMIT, Doctrine::LIMIT_RECORDS); 313 314 $this->assertEqual($q->getSqlQuery(), "SELECT p.id AS p__id, p.name AS p__name, t.id AS t__id, t.tag AS t__tag FROM photo p LEFT JOIN phototag p2 ON (p.id = p2.photo_id) LEFT JOIN tag t ON t.id = p2.tag_id WHERE p.id IN (SELECT DISTINCT p3.id FROM photo p3 LEFT JOIN phototag p4 ON (p3.id = p4.photo_id) LEFT JOIN tag t2 ON t2.id = p4.tag_id ORDER BY t2.id DESC LIMIT 10) ORDER BY t.id DESC"); 315 }string-util.cpp https://github.com/tstarling/hiphop-php.git | C++ | 461 lines
2 +----------------------------------------------------------------------+ 3 | HipHop for PHP | 4 +----------------------------------------------------------------------+ 6 +----------------------------------------------------------------------+ 7 | This source file is subject to version 3.01 of the PHP license, | 8 | that is bundled with this package in the file LICENSE, and is | 9 | available through the world-wide-web at the following url: | 10 | http://www.php.net/license/3_01.txt | 11 | If you did not receive a copy of the PHP license and are unable to | 12 | obtain it through the world-wide-web, please send a note to | 13 | license@php.net so we can mail you a copy immediately. | 14 +----------------------------------------------------------------------+ 16 17#include "hphp/runtime/base/string-util.h" 18#include <algorithm>enrol.php https://github.com/kpike/moodle.git | PHP | 356 lines
1<?php 2 20 * 21 * This file must be named enrol.php because current MNet framework has the 22 * filename hardcoded in XML-RPC path and we want to be compatible with 24 * map XMP-RPC calls to whatever file, function, class or methods. Once this 25 * is fixed, this file will be probably renamed to mnetlib.php (which could 26 * be a common name of a plugin library containing functions/methods callable 44 * and 2.0 peers. The API version might become a part of class name but it is 45 * not neccessary due to how xml-rcp methods are/will be mapped to php methods. 46 */ 61 global $CFG, $DB; 62 require_once($CFG->libdir.'/filelib.php'); 63 75 FROM {enrol} e 76 INNER JOIN {course} c ON c.id = e.courseid 77 INNER JOIN {course_categories} cat ON cat.id = c.category