$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>