PHP get_country_row Examples

Example #1

File: staff.php Project: CptTZ/NexusPHP-1

    echo $lang_staff['text_general_staff_note'];
    ?>
<br /><br />
<table width=100% cellspacing=0 align=center>
	<?php 
    echo $ppl;
    ?>
</table>
<?php 
    end_frame();
    //--------------------- general staff section ---------------------------//
    //--------------------- VIP section ---------------------------//
    unset($ppl);
    $res = sql_query("SELECT * FROM users WHERE class=" . UC_VIP . " AND status='confirmed' ORDER BY username") or sqlerr();
    while ($arr = mysql_fetch_assoc($res)) {
        $countryrow = get_country_row($arr['country']);
        $ppl .= "<tr><td class=embedded>" . get_username($arr['id']) . "</td><td class=embedded><img width=24 height=15 src=\"pic/flag/" . $countryrow['flagpic'] . "\" title=\"" . $countryrow['name'] . "\" style=\"padding-bottom:1px;\"></td>\n <td class=embedded> " . ($arr['showonline'] == 'yes' ? strtotime($arr['last_access']) > $dt ? $onlineimg : $offlineimg : $lang_staff['text_hidden_by_staff']) . "</td>" . "<td class=embedded><a href=sendmessage.php?receiver=" . $arr['id'] . " title=\"" . $lang_staff['title_send_pm'] . "\">" . $sendpmimg . "</a></td>" . "<td class=embedded>" . $arr['stafffor'] . "</td></tr>\n";
    }
    begin_frame($lang_staff['text_vip']);
    echo $lang_staff['text_vip_note'];
    ?>
<br /><br />
<table width=100% cellspacing=0 align=center>
	<tr>
		<td class=embedded><b><?php 
    echo $lang_staff['text_username'];
    ?>
</b></td>
		<td class=embedded><b><?php 
    echo $lang_staff['text_country'];
    ?>

Example #2

File: userdetails.php Project: CptTZ/NexusPHP

} else {
    $joindate = $user[added] . " (" . gettime($user["added"], true, false, true) . ")";
}
$lastseen = $user["last_access"];
if ($lastseen == "0000-00-00 00:00:00") {
    $lastseen = $lang_userdetails['text_not_available'];
} else {
    $lastseen .= " (" . gettime($lastseen, true, false, true) . ")";
}
$res = sql_query("SELECT COUNT(*) FROM comments WHERE user="******"SELECT COUNT(*) FROM posts WHERE userid=" . $user[id]) or sqlerr();
$arr3 = mysql_fetch_row($res);
$forumposts = $arr3[0];
$arr = get_country_row($user[country]);
$country = "<img src=\"pic/flag/" . $arr[flagpic] . "\" alt=\"" . $arr[name] . "\" style='margin-left: 8pt' />";
$arr = get_downloadspeed_row($user[download]);
$download = "<img class=\"speed_down\" src=\"pic/trans.gif\" alt=\"Downstream Rate\" title=\"" . $lang_userdetails['title_download'] . $arr[name] . "\" /> " . $arr[name];
$arr = get_uploadspeed_row($user[upload]);
$upload = "<img class=\"speed_up\" src=\"pic/trans.gif\" alt=\"Upstream Rate\" title=\"" . $lang_userdetails['title_upload'] . $arr[name] . "\" /> " . $arr[name];
$arr = get_isp_row($user[isp]);
$isp = $arr[name];
if ($user["gender"] == "Male") {
    $gender = "<img class='male' src='pic/trans.gif' alt='Male' title='" . $lang_userdetails['title_male'] . "' style='margin-left: 4pt' />";
} elseif ($user["gender"] == "Female") {
    $gender = "<img class='female' src='pic/trans.gif' alt='Female' title='" . $lang_userdetails['title_female'] . "' style='margin-left: 4pt' />";
} elseif ($user["gender"] == "N/A") {
    $gender = "<img class='no_gender' src='pic/trans.gif' alt='N/A' title='" . $lang_userdetails['title_not_available'] . "' style='margin-left: 4pt' />";
}
stdhead($lang_userdetails['head_details_for'] . $user["username"]);