PageRenderTime 440ms queryTime 36ms sortTime 77ms getByIdsTime 153ms findMatchingLines 82ms

100+ results results for 'php join repo:strato1986/hawebadmin' (440 ms)

Not the results you expected?
ImageMagick.php https://gitlab.com/yousafsyed/easternglamor | PHP | 480 lines
                    
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'] = userid
                    
                
directories.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')
                    
                
edit.php https://github.com/thisduck/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']);
                    
                
twitter-timeline.php https://gitlab.com/vanafroo/voipWEB | 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\">"; 
                    
                
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 status
                    
                
phpBB.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) );
                    
178
                    
                
Matcher.php https://bitbucket.org/rybadour/todo_list_site.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(
                    
                
AnnotationDriverTest.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 an
                    
                
preprocessors.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				&nbsp;&nbsp;
                    
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			<?php
                    
                
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 be
                    
                
errors.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).'):/';
                    
186
                    
                
permissions.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)
                    
                
vardefs.php https://github.com/asakusuma/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',
                    
                
wiki_document.php https://github.com/nadavkav/MoodleTAO.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.'&amp;page='.wiki_name_convert($title).'&amp;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 ver
                    
                
OrganizationReportController.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'))
                    
                
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_id
                    
                
engine.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/openemr/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');
                    
179
                    
                
actions.class.php https://github.com/cidesa/siga-universitario.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();
                    
                
paperclip.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 maximally 
                    
                
featured.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.id
                    
                
TranslatableTest.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";	
                    
330
                    
                
NpgsqlSchema.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");
                    
151
                    
                
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"> &mdash; <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"> &mdash; <a href="<?php bp_group_member_ban_link() ?>" title="<?php _e( 'Kick and ban this member', 'buddypress' ) ?>"><?php _e( 'Kick &amp; 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
                    
277
                    
                
Cost_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 ASC
                    
                
Clinic.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]);
                    
134
                    
                
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;
                    
                
SmartyBC.class.php https://gitlab.com/A.Julien/sendstockbymail-module-prestashop | 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 *
                    
                
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 callback
                    
                
banner.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.5
                    
                
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', 
                    
                
Db.php https://github.com/weburnit/magento-lite.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    }
                    
                
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]) + "}"
                    
313 
                    
                
alias-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`';
                    
90
                    
                
Entity.php https://github.com/rgranadino/magento-mirror.git | 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
                    
342
                    
                
Pgsql.php https://github.com/kervin/kyzstudio.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.oid
                    
                
SparqlEngineDb.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)))
                    
87    
                    
                
Pgsql.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.oid
                    
                
String.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');

                    
                
Template.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}&amp;st=main&amp;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 ActiveUserScope
                    
                
Pgsql.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.oid
                    
                
resources_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' => 'سندهاي پيوست',
                    
47
                    
                
user_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.oid
                    
                
Pgsql.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.oid
                    
                
pyodbc.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
                    
                
 

Source

Language