Пример #1
0
function zen_address_format($zen, $data, $pre)
{
    $company = $data[$pre . 'company'];
    $name = isset($data[$pre . 'firstname']) ? $data[$pre . 'firstname'] . ' ' . $data[$pre . 'lastname'] : false;
    $street_address = $data[$pre . 'street_address'];
    $suburb = $data[$pre . 'suburb'];
    $city = $data[$pre . 'city'];
    $postcode = $data[$pre . 'postcode'];
    if (not_null($data[$pre . 'state'])) {
        $state = $data[$pre . 'state'];
    } else {
        if (not_null($data[$pre . 'zone_id'])) {
            $state = zen_get_zone_code_from_id($zen, $data[$pre . 'zone_id']);
        }
    }
    if (isset($data[$pre . 'country_id'])) {
        $country = zen_get_country($zen, $data[$pre . 'country_id']);
    } else {
        $country = $data[$pre . 'country'];
    }
    $ret = '';
    if (not_null($company)) {
        $ret .= $company . "\n";
    }
    $ret .= $name . "\n" . $street_address . "\n";
    if (not_null($suburb)) {
        $ret .= $suburb . "\n";
    }
    if (not_null($city)) {
        $ret .= $city;
    }
    if (not_null($state)) {
        $ret .= ", " . zen_get_zone_code($zen, $state);
    }
    if (not_null($postcode)) {
        $ret .= " " . $postcode . "\n";
    } else {
        $ret .= "\n";
    }
    if (not_null($country)) {
        $ret .= $country . "\n";
    }
    return $ret;
}
					$sort = $order[ $_GET['order'] ];

				$tLijstenC = mu_sort ( $tLijstenC, $sort );


				# Bouw de lijst opnieuw op
				$i = 0;
				foreach ( $tLijstenC as $lijstenC )
				{
					$tpl->newblock ( "l.lijst.row" );
					$tpl->assign ( array (
						"nr" => ++$i,
						"AK" => $lijstenC['AK'],
						"album_id" => $lijstenC['album_id'],
						"album" => inkorten ( $lijstenC['album'], 45 ),
						"jaar" => not_null ( $lijstenC['jaar'] )
					) );

					if ( $lijstenC['pos'] != $lPos )
						$tpl->assign ( "pos", $lijstenC['pos'] );

					if ( $tArtiest != $lijstenC['artiest_id'] )
					{
						$tpl->assign ( array (
							"artiest_id" => $lijstenC['artiest_id'],
							"artiest" => inkorten ( $lijstenC['artiest'], 40 )
						) );
					}

					$tArtiest = $lijstenC['artiest_id'];
					$lPos = $lijstenC['pos'];
 /** 
  * send a request
  * data sent are in order
  * a) the command
  * b) the request headers if they are defined
  * c) the request body if defined
  * @return string the server repsonse status code
  **/
 function sendCommand($command)
 {
     $this->responseHeaders = array();
     $this->responseBody = '';
     // connect if necessary
     if ($this->socket == false || feof($this->socket)) {
         if ($this->useProxy) {
             $host = $this->proxyHost;
             $port = $this->proxyPort;
         } else {
             $host = $this->url['host'];
             $port = $this->url['port'];
         }
         if (!not_null($port)) {
             $port = 80;
         }
         if (!($this->socket = fsockopen("ssl://" . $host, $port, $this->reply, $this->replyString, 10))) {
             return false;
         }
         if (not_null($this->requestBody)) {
             $this->addHeader('Content-Length', strlen($this->requestBody));
         }
         $this->request = $command;
         $cmd = $command . "\r\n";
         if (is_array($this->requestHeaders)) {
             reset($this->requestHeaders);
             while (list($k, $v) = each($this->requestHeaders)) {
                 $cmd .= $k . ': ' . $v . "\r\n";
             }
         }
         if (not_null($this->requestBody)) {
             $cmd .= "\r\n" . $this->requestBody;
         }
         // unset body (in case of successive requests)
         $this->requestBody = '';
         fputs($this->socket, $cmd . "\r\n");
         //echo $cmd . "--";
         return true;
     }
 }
Пример #4
0
		);

		if ( isset ( $_GET['order'] ) && !empty ( $order[ $_GET['order'] ] ) )
			$qAlbum .= $order[ $_GET['order'] ];
		else
			$qAlbum .= $order['album'];

		$rAlbum = $sql->query ( $qAlbum );
		if ( $sql->num_rows ( $rAlbum ) > 0 )
		{
			$i = 0;
			while ( $album = $sql->fetch_assoc ( $rAlbum ) )
			{

				$tpl->newblock ( "artiest.row" );
				$tpl->assign ( array (
					"nr" => ++$i,
					"album_id" => $album['id'],
					"album" => $album['album'],
					"jaar" => not_null ( $album['jaar'] ),

					"recensies" => not_null ( $album['recensies'] ),
					"lijsten" => not_null ( $album['lijsten'] )
				) );
			}
		}
		else
			$tpl->newblock ( "artiest.norow" );
	}
?>
Пример #5
0
				$tpl->newblock ( "album_lijst" );
				$tpl->assign ( "album_id", $_GET['album'] );

				$i = 0;

				while ( $lijst = $sql->fetch_assoc ( $rLijst ) )
				{
					$tpl->newblock ( "album_lijst.row" );
					$tpl->assign ( array (
						"nr" => ++$i,

						"lijst_id" => $lijst['lijst_id'],
						"lijst" => $lijst['omschrijving'],
						"lijst_url" => empty ( $lijst['url'] ) ? NULL : "http://www.muzieklijstjes.nl/" . $lijst['url'] . ".htm",
						"jaar" => $lijst['jaar'],

						"aBron" => inkorten ( $lijst['bron'], 10 ),
						"bron" => $lijst['bron'],

						"ak" => not_null ( $lijst['ak'] ),
						"pos" => not_null ( $lijst['pos'] ),
						"gPos" => $lijst['type'] == "gp" ? "x" : NULL,

						"canon" => $lijst['canon'] == true ? "x" : NULL
					) );
				}
			}
		}
	}
?>
Пример #6
0

		$i = 0;
		$lAK = '';
		$tArtiest = '';
		while ( $canon = $sql->fetch_assoc ( $rCanon ) )
		{
			$AK = $order [ $canon['AK'] ];

			$tpl->newblock ( "canon.row" );
			$tpl->assign ( array (
				"nr" => ++$i,
				"AK" => $canon['AK'],
				"album_id" => $canon['album_id'],
				"album" => inkorten ( $canon['album'], 45 ),
				"jaar" => not_null ( $canon['jaar'] )
			) );

			if ( $lAK != $AK )
				$tpl->assign ( "pos", $AK );

			if ( $tArtiest != $canon['artiest_id'] )
			{
				$tpl->assign ( array (
					"artiest_id" => $canon['artiest_id'],
					"artiest" => $canon['artiest']
				) );
			}

			$tArtiest = $canon['artiest_id'];
Пример #7
0
				$tpl->assign ( "n", $n );

				if ( $n > 0 )
				{
					$i = 0;
					$lArtiest = '';

					while ( $album = $sql->fetch_assoc ( $rAlbum ) )
					{
						$tpl->newblock ( "l.gp.row" );
						$tpl->assign ( array (
							"album_id" => $album['album_id'],
							"album" => $album['album'],
							"recensies" => not_null ( $album['recensies'] ),

							"nr" => ++$i,

							"artiest_id" => $lArtiest != $album['artiest_id'] ? $album['artiest_id'] : NULL,
							"artiest" => $lArtiest != $album['artiest'] ? $album['artiest'] : NULL,

							"jaar" => not_null ( $album['jaar'] )
						) );

						$lArtiest = $album['artiest'];
					}
				}
			}
		}
	}
?>
Пример #8
0
 function post_value($key = '')
 {
     if ($key != '') {
         if (isset($_POST[$key]) && not_null($_POST[$key])) {
             if (!is_array($_POST[$key])) {
                 return trim($_POST[$key]);
             } else {
                 return $_POST[$key];
             }
         } else {
             return '';
         }
     } else {
         return '';
     }
 }
Пример #9
0
function product_path($products_id)
{
    $cPath = '';
    $category_query = "select p2c.categories_id\n                       from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c\n                       where p.products_id = '" . (int) $products_id . "'\n                       and p.products_status = '1'\n                       and p.products_id = p2c.products_id limit 1";
    $category = mysql_query($category_query);
    if (mysql_num_rows($category) > 0) {
        $category = mysql_fetch_array($category, MYSQL_ASSOC);
        $categories = array();
        get_parent_categories($categories, $category['categories_id']);
        $categories = array_reverse($categories);
        $cPath = implode('_', $categories);
        if (not_null($cPath)) {
            $cPath .= '_';
        }
        $cPath .= $category['categories_id'];
    }
    return $cPath;
}
Пример #10
0
			$n = $sql->num_rows ( $rTitel );
			if ( $n > 0 )
			{
				$i = 0;
				$lArtiest = '';
				while ( $titel = $sql->fetch_assoc ( $rTitel ) )
				{
					$tpl->newblock ( "recensent_recensie" );

					$tpl->assign ( array (
						 "nr" => ++$i,
						 "nummer" => $titel['nummer'],
						 "jaar" => $titel['jaar'],
						 "tijdschrift_id" => $titel['tijdschrift_id'],
						 "lijsten" => not_null ( $titel['lijsten'] ),
						 "aTijdschrift" => substr ( $titel['tijdschrift'], 0, 1 ),
						 "tijdschrift" => $titel['tijdschrift'],

						"artiest_id" => $titel['artiest_id'],
						"artiest" => $lArtiest != $titel['artiest'] ? inkorten ( $titel['artiest'], 40 ) : NULL,

						"album_id" => $titel['album_id'],
						"album" => inkorten ( $titel['album'], 40 )
					) );

					$lArtiest = $titel['artiest'];
				}
			}
		}
	}
Пример #11
0
 function putgeo($ref_table, $ref_id, $id = NULL, $table = "maxmind")
 {
     $Herb =& get_instance();
     // uncomment for Shared Memory support
     // geoip_load_shared_mem("/usr/local/share/GeoIP/GeoIPCity.dat");
     // $gi = geoip_open("/usr/local/share/GeoIP/GeoIPCity.dat",GEOIP_SHARED_MEMORY);
     $gi = geoip_open("maxmind/GeoLiteCity.dat", GEOIP_STANDARD);
     $record = geoip_record_by_addr($gi, $_SERVER['REMOTE_ADDR']);
     if ($record == NULL) {
         return NULL;
     }
     if (is_null($id)) {
         $id = multiinsert($table, "ref_id", $ref_id, "ref_table", $ref_table, "geoip", $_SERVER['REMOTE_ADDR'], "geocountry", $record->country_code, "geocountry3", $record->country_code3, "geoname", $record->country_name, "georegion", $record->region, "geocity", $record->city, "geozip", $record->postal_code, "geolat", $record->latitude, "geolong", $record->longitude, "geodma", $record->dma_code, "geoarea", $record->area_code, "geotype", GEOIP_STANDARD, "geolang", $record->country_code);
     } else {
         if (not_null($table) && not_null($id)) {
             set($table, $id, "geoip", $_SERVER['REMOTE_ADDR']);
             set($table, $id, "geocountry", $record->country_code);
             set($table, $id, "geocountry3", $record->country_code3);
             set($table, $id, "geoname", $record->country_name);
             set($table, $id, "georegion", $record->region);
             //set($table,$id,"georegionname", $GEOIP_REGION_NAME[$record->country_code][$record->region] );
             set($table, $id, "geocity", $record->city);
             set($table, $id, "geozip", $record->postal_code);
             set($table, $id, "geolat", $record->latitude);
             set($table, $id, "geolong", $record->longitude);
             set($table, $id, "geodma", $record->dma_code);
             set($table, $id, "geoarea", $record->area_code);
             set($table, $id, "geotype", GEOIP_STANDARD);
             set($table, $id, "geolang", $record->country_code);
             set($table, $id, "ref_table", $ref_table);
             set($table, $id, "ref_id", $ref_id);
         }
     }
     $country_name = $record->country_name;
     if (isset($GEOIP_REGION_NAME)) {
         $region_name = $GEOIP_REGION_NAME[$record->country_code][$record->region];
     }
     $region_code = $record->region;
     //        $lang = $record->country_code;
     geoip_close($gi);
     return find($table, "id", $id);
 }
Пример #12
0
		$rArtiest = $sql->query ( $qArtiest );


		$n = $sql->num_rows ( $rArtiest );
		if ( $n > 0 )
		{
			$tpl->assign ( "i_artiest", $n );

			$i = 0;
			while ( $artiest = $sql->fetch_assoc( $rArtiest ) )
			{
				$tpl->newblock ( "artiest.row" );
				$tpl->assign (
					array (
						"nr" => ++$i,

						"artiest_id" => $artiest['id'],
						"artiest" => ucfirst ( $artiest['artiest'] ),

						"albums" => not_null ( $artiest['albums'] ),
						"recensies" => not_null ( $artiest['recensies'] ),
						"lijsten" => not_null ( $artiest['lijsten'] )
					)
				);
			}
		}
		else
			$tpl->newblock ( "artiest.norow" );
	}
?>
Пример #13
0
 function mysql_to_array($res)
 {
     $tab = array();
     $i = 0;
     if (not_null($res)) {
         while ($r = mysql_fetch_assoc($res)) {
             $tab[$i++] = $r;
         }
     }
     return $tab;
 }