$ucnts = '';
}
$get_country = explode(':', $ucnts);
if (array_key_exists(1, $get_country)) {
$gcty = $get_country[1];
} else {
$gcty = '';
}
if ($gcty != '') {
array_push($unique_countries_array, $gcty);
}
}
$unique_countries_array_unique = array_unique($unique_countries_array);
foreach ($unique_countries_array_unique as $ucau) {
$no_in_country = array_keys($unique_countries_array, $ucau);
array_push($country_count_array, count($no_in_country) . '%' . country_code_to_country($ucau) . '%' . $ucau);
}
natsort($country_count_array);
$country_count_array = array_reverse($country_count_array);
if (count($opens_array) == 0) {
echo '
<tr>
<td>' . _('No opens yet!') . '</td>
<td>0</td>
<td></td>
</tr>
<script type="text/javascript">
$("#countries-container").html("<span class=\'badge\'>' . _('No opens yet!') . '</span>");
$("#countries-container").css("margin-top", "155px");
$("#countries-container").css("margin-left", "180px");
$("#countries-container").css("margin-bottom", "-155px");
//connect to database
include 'dbconnect.php';
//check that user has a valid cookie, redirect if no valid cookie
include 'php_common/cookiecheck.php';
//get user's country
$userService = new UserService();
$countryCode = $userService->getUserCountryCode($userid);
//for each country, extract the number of gyms
$stmt = $db->prepare("SELECT * FROM gyms");
$stmt->execute();
$gym_country_num = array();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$gym_country_num[strtolower($row['countryCode'])]++;
}
include 'php_dataquery/getCountryNameFromCode.php';
$countryName = country_code_to_country($countryCode);
?>
<!DOCTYPE HTML>
<html>
<head>
<title>Climbing Tracker</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Latest compiled and minified CSS -->
<link rel="icon" href="images/favicon.ico" type="image/x-icon">
<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="style.php/mycss.scss">
<script src="http://ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
$link_array = array();
while ($row = mysqli_fetch_array($r2)) {
$clicks = $row['clicks'];
$link = $row['link'];
$clicks_array = explode(',', $clicks);
if (in_array($id, $clicks_array)) {
$click_count++;
array_push($link_array, $link);
}
}
for ($y = 0; $y < count($link_array); $y++) {
$links_clicked .= strlen($link_array[$y]) > 32 ? substr($link_array[$y], 0, 32) . '..<br/>' : $link_array[$y] . '<br/>';
}
}
if ($s_id != '') {
$cty = country_code_to_country($country);
if ($cty == '') {
$cty = _('Not detected');
}
echo '
<tr>
<td><a href="' . get_app_info('path') . '/report?i=' . $app . '&c=' . $campaign_id . '" title="' . _('View report for') . ' ' . $title . '">' . $title . '</a></td>
<td>' . $open_count . '</td>
';
if (count($link_array) == 0) {
echo '<td>0</td>';
} else {
echo '<td><a href="javascript:void(0)" title="' . _('Links clicked') . '" data-content="' . $links_clicked . '" id="click-links-' . $campaign_id . '" style="text-decoration:underline;">' . $click_count . '</a></td>';
}
echo '
<td>' . $cty . '</td>
?>
</a></li>
<li class="list-group-item"><b>Address:</b> <?php
echo $result['address'];
?>
</li>
<li class="list-group-item"><b>City:</b> <?php
echo $result['city'];
?>
</li>
<li class="list-group-item"><b>State:</b> <?php
echo $result['state'];
?>
</li>
<li class="list-group-item"><b>Country:</b> <?php
echo country_code_to_country($result['countryCode']);
?>
</li>
</ul>
</div>
</div>
<div class="tab-pane fade" id="gym-ranking">
<div class="container">
<div><h3 id="ranking-header">Boulder Rankings</h3></div>
<?php
genRankingTable('boulder', $gym_options, $userid, $gymid);
?>
?>
" name="company_zip" id="company_zip" size="10" class=""/>
<label for="company_zip">ZIP Code</label>
</div>
</div>
<!-- .field-group -->
<div class="field-group">
<div class="field">
<select name="company_country">
<?php
if (!isset($editdata['company_country']) or empty($editdata['company_country'])) {
echo '<option value="" selected="selected">Select Country</option>';
} else {
echo '<option value="' . $editdata['company_country'] . '" selected="selected">' . country_code_to_country($editdata['company_country']) . '</option>';
}
?>
<option value="United States">United States</option>
<option value="United Kingdom">United Kingdom</option>
<option value="Afghanistan">Afghanistan</option>
<option value="Albania">Albania</option>
<option value="Algeria">Algeria</option>
<option value="American Samoa">American Samoa</option>
<option value="Andorra">Andorra</option>
<option value="Angola">Angola</option>
<option value="Anguilla">Anguilla</option>
<option value="Antarctica">Antarctica</option>
<option value="Antigua and Barbuda">Antigua and Barbuda</option>
<option value="Argentina">Argentina</option>
<option value="Armenia">Armenia</option>
echo $event_result['address'];
?>
</h4>
<h4 class="event-details"><b>City: </b><?php
echo $event_result['city'];
?>
</h4>
<h4 class="event-details"><b>State: </b><?php
echo $event_result['state'];
?>
</h4>
<h4 class="event-details"><b>Country: </b><?php
echo country_code_to_country($event_result['countryCode']);
?>
</h4>
</div>
<?php
$website_URL = cleanURL($event_result['event_website']);
$facebook_URL = cleanURL($event_result['event_facebook']);
?>
<div class="col-xs-12 col-sm-6">
<?php
if ($event_result['event_startdate'] == $event_result['event_enddate']) {
?>
<h4 class="event-details"><b>Date: </b><?php
echo date("l, F j, Y", date_format($startdate, 'U'));
} else {
echo $user_detail['company_zip'];
?>
" name="company_zip" id="company_zip" size="10" class="" />
<label for="company_zip">ZIP Code</label>
</div>
</div> <!-- .field-group -->
<div class="field-group">
<div class="field">
<select name="company_country">
<?php
if (empty($user_detail[company_country])) {
echo '<option value="" selected="selected">Select Country</option>';
} else {
echo '<option value="' . $user_detail['company_country'] . '" selected="selected">' . country_code_to_country($user_detail['company_country']) . '</option>';
}
?>
<option value="United States">United States</option>
<option value="United Kingdom">United Kingdom</option>
<option value="Afghanistan">Afghanistan</option>
<option value="Albania">Albania</option>
<option value="Algeria">Algeria</option>
<option value="American Samoa">American Samoa</option>
<option value="Andorra">Andorra</option>
<option value="Angola">Angola</option>
<option value="Anguilla">Anguilla</option>
<option value="Antarctica">Antarctica</option>
<option value="Antigua and Barbuda">Antigua and Barbuda</option>
<option value="Argentina">Argentina</option>
<option value="Armenia">Armenia</option>