function get_days_with_color($how_long)
{
$days = count_days($how_long, time());
if ($days < 1) {
$lastlogin = '******' . $days . '</font>';
} else {
if ($days < 8) {
$lastlogin = '******' . $days . '</font>';
} else {
if ($days < 15) {
$lastlogin = '******' . $days . '</font>';
} else {
if ($days < 22) {
$lastlogin = '******' . $days . '</font>';
} else {
if ($days < 29) {
$lastlogin = '******' . $days . '</font>';
} else {
if ($days < 61) {
$lastlogin = '******' . $days . '</font>';
} else {
$lastlogin = '******' . $days . '</font>';
}
}
}
}
}
}
return $lastlogin;
}
function get_days_with_color($how_long)
{
$days = count_days($how_long, time());
if ($days < 1) {
$lastlogin = '******' . $days . '</span>';
} elseif ($days < 8) {
$lastlogin = '******' . $days . '</span>';
} elseif ($days < 15) {
$lastlogin = '******' . $days . '</span>';
} elseif ($days < 22) {
$lastlogin = '******' . $days . '</span>';
} elseif ($days < 29) {
$lastlogin = '******' . $days . '</span>';
} elseif ($days < 61) {
$lastlogin = '******' . $days . '</span>';
} else {
$lastlogin = '******' . $days . '</span>';
}
return $lastlogin;
}
}
}
if (!$messages_are_limited) {
if (empty($row['silence_time']) or $row['silence_time'] + $row['silence_length'] < time()) {
$db->execute("\n\t\t\t\t\t\tINSERT INTO arrowchat_chatroom_messages (\n\t\t\t\t\t\t\tchatroom_id,\n\t\t\t\t\t\t\tuser_id,\n\t\t\t\t\t\t\tusername,\n\t\t\t\t\t\t\tmessage,\n\t\t\t\t\t\t\tglobal_message,\n\t\t\t\t\t\t\tis_mod,\n\t\t\t\t\t\t\tis_admin,\n\t\t\t\t\t\t\tsent\n\t\t\t\t\t\t) \n\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t'" . $db->escape_string($chatroomid) . "', \n\t\t\t\t\t\t\t'" . $db->escape_string($userid) . "', \n\t\t\t\t\t\t\t'" . $db->escape_string($username) . "',\n\t\t\t\t\t\t\t'" . $db->escape_string($s_message) . "',\n\t\t\t\t\t\t\t'0',\n\t\t\t\t\t\t\t'" . $db->escape_string($chatroom_mod) . "',\n\t\t\t\t\t\t\t'" . $db->escape_string($chatroom_admin) . "',\n\t\t\t\t\t\t\t'" . time() . "'\n\t\t\t\t\t\t)\n\t\t\t\t\t");
$last_id = $db->last_insert_id();
// Update message history totals
$result = $db->execute("\n\t\t\t\t\t\tSELECT sent\n\t\t\t\t\t\tFROM arrowchat_chatroom_messages\n\t\t\t\t\t\tORDER BY id DESC\n\t\t\t\t\t\tLIMIT 1, 1\n\t\t\t\t\t");
$date = time();
$insert_date = date('Ymd', $date);
if ($row = $db->fetch_array($result)) {
$last_date = date('Ymd', $row['sent']);
if ($last_date != $insert_date && !empty($last_date)) {
$date1 = strtotime($last_date);
$date2 = strtotime($insert_date);
$days = count_days($date1, $date2);
for ($i = 0; $i < $days; $i++) {
$db->execute("\n\t\t\t\t\t\t\t\t\tINSERT INTO arrowchat_graph_log (\n\t\t\t\t\t\t\t\t\t\tdate,\n\t\t\t\t\t\t\t\t\t\tchat_room_messages\n\t\t\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t\t\t'" . date('Ymd', $date1 + 86400 * $i) . "',\n\t\t\t\t\t\t\t\t\t\t'0'\n\t\t\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\t\t\tON DUPLICATE KEY \n\t\t\t\t\t\t\t\t\t\tUPDATE chat_room_messages = chat_room_messages\n\t\t\t\t\t\t\t\t");
}
}
$db->execute("\n\t\t\t\t\t\t\tINSERT INTO arrowchat_graph_log (\n\t\t\t\t\t\t\t\tdate,\n\t\t\t\t\t\t\t\tchat_room_messages\n\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t'" . $db->escape_string($insert_date) . "',\n\t\t\t\t\t\t\t\t'1'\n\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\tON DUPLICATE KEY \n\t\t\t\t\t\t\t\tUPDATE chat_room_messages = (chat_room_messages + 1)\n\t\t\t\t\t\t");
} else {
$db->execute("\n\t\t\t\t\t\t\tINSERT INTO arrowchat_graph_log (\n\t\t\t\t\t\t\t\tdate,\n\t\t\t\t\t\t\t\tchat_room_messages\n\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t'" . $db->escape_string($insert_date) . "',\n\t\t\t\t\t\t\t\t'1'\n\t\t\t\t\t\t\t) \n\t\t\t\t\t\t");
}
if ($push_on == 1) {
$arrowpush->publish(array('channel' => 'chatroom' . $chatroomid, 'message' => array('chatroommessage' => array("id" => $last_id, "name" => $username, "message" => $s_message, "userid" => $userid, "sent" => time(), "global" => '0', "mod" => $chatroom_mod, "admin" => $chatroom_admin, "chatroomid" => $chatroomid))));
}
echo $last_id;
} else {
$silence_time = $row['silence_time'] + $row['silence_length'] - time();
$silence_message = $language[164] . $silence_time . $language[165];
} else {
$arenateam_data = mysql_fetch_row($query);
$query = mysql_query("SELECT arenateamid, rating, games, wins, played, wins2, rank FROM arena_team_stats WHERE arenateamid = '{$arenateam_id}'");
$arenateamstats_data = mysql_fetch_row($query);
$members = mysql_query("\n\t\t\t\tSELECT DISTINCT arena_team_member.guid,characters.name,\n\t\t\t\tcharacters.name, SUBSTRING_INDEX(SUBSTRING_INDEX(characters.data, ' ', " . (CHAR_DATA_OFFSET_LEVEL + 1) . "), ' ', -1) AS level,\n\t\t\t\tarena_team_member.played_week, arena_team_member.wons_week, arena_team_member.played_season, arena_team_member.wons_season\n\t\t\t\tFROM arena_team_member,characters\n\t\t\t\tLEFT JOIN arena_team_member k1 ON k1.guid = characters.guid\n\t\t\t\tWHERE arena_team_member.arenateamid = '{$arenateam_id}' AND arena_team_member.guid = characters.guid");
@($total_members = mysql_num_rows($members));
@($losses_week = $arenateamstats_data[4] - $arenateamstats_data[3]);
@($winperc_week = $arenateamstats_data[4] / $arenateamstats_data[3] * 100);
@($losses_season = $arenateamstats_data[6] - $arenateamstats_data[5]);
@($winperc_season = $arenateamstats_data[6] / $arenateamstats_data[5] * 100);
echo "\n\t\t\t\t<center>\n\t\t\t\t<p class=\"title\">{$lang_arenateam['arenateam']}</p><br />\n\t\t\t\t<table class=\"lined\" style=\"width: 910px;\">\n\t\t\t\t\t<tr class=\"bold\">\n\t\t\t\t\t\t<td colspan=\"11\">{$arenateam_data['1']}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t <td colspan=\"11\">{$lang_arenateam['tot_members']}: {$total_members}</td>\n\t\t\t\t </tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan=\"3\">{$lang_arenateam['this_week']}</td>\n\t\t\t\t\t <td colspan=\"2\">{$lang_arenateam['games_played']} : {$arenateamstats_data['3']}</td>\n\t\t\t\t\t <td colspan=\"2\">{$lang_arenateam['games_won']} : {$arenateamstats_data['4']}</td>\n\t\t\t\t <td colspan=\"2\">{$lang_arenateam['games_lost']} : {$losses_week}</td>\n\t\t\t\t <td colspan=\"2\">{$lang_arenateam['ratio']} : {$winperc_week} %</td>\n\t\t\t\t </tr>\n\t\t\t\t <tr>\n\t\t\t\t\t\t<td colspan=\"3\">{$lang_arenateam['this_season']}</td>\n\t\t\t\t\t <td colspan=\"2\">{$lang_arenateam['games_played']} : {$arenateamstats_data['5']}</td>\n\t\t\t\t\t <td colspan=\"2\">{$lang_arenateam['games_won']} : {$arenateamstats_data['6']}</td>\n\t\t\t\t <td colspan=\"2\">{$lang_arenateam['games_lost']} : {$losses_season}</td>\n\t\t\t\t <td colspan=\"2\">{$lang_arenateam['ratio']} : {$winperc_season} %</td>\n\t\t\t\t </tr>\n\t\t\t\t <tr>\n\t\t\t\t <td colspan=\"11\">{$lang_arenateam['standings']} {$arenateamstats_data[7]} ( {$arenateamstats_data[2]})</td>\n\t\t\t\t </tr>\n\t\t\t\t <tr>\n\t\t\t\t\t<th width=\"21%\">{$lang_arenateam['name']}</th>\n\t\t\t\t <th width=\"3%\">Race</th>\n\t\t\t\t\t<th width=\"3%\">Class</th>\n\t\t\t\t\t<th width=\"3%\">{$lang_arenateam['level']}</th>\n\t\t\t\t\t<th width=\"15%\">Last Login (Days)</th>\n\t\t\t\t\t<th width=\"3%\">Online</th>\n\t\t\t\t\t<th width=\"12%\">{$lang_arenateam['played_week']}</th>\n\t\t\t\t\t<th width=\"12%\">{$lang_arenateam['wons_week']}</th>\n\t\t\t\t\t<th width=\"12%\">{$lang_arenateam['played_season']}</th>\n\t\t\t\t\t<th width=\"12%\">{$lang_arenateam['wons_season']}</th>\n\t\t\t\t </tr>";
while ($member = mysql_fetch_row($members)) {
$query = mysql_query("SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', " . (CHAR_DATA_OFFSET_LEVEL + 1) . "), ' ', -1) AS level, mid(lpad( hex( CAST(substring_index(substring_index(data,' '," . (CHAR_DATA_OFFSET_SEX + 1) . "),' ',-1) as unsigned) ),8,'0'),4,1) as gender FROM `characters` WHERE `name` = '{$member['1']}';");
$online = mysql_fetch_row($query);
$accid = $online[3];
$llogin = count_days($online[4], time());
$level = $online[5];
echo " <tr>\n\t\t\t\t\t\t<td>{$member['1']}</td>\n\t\t\t\t\t\t<td><img src='images/races/{$online[0]}-{$online[6]}.gif' onmousemove='toolTip(\"" . get_player_race($online[0]) . "\",\"item_tooltip\")' onmouseout='toolTip()' /></td>\n\t\t\t\t\t\t<td><img src='images/classes/{$online[1]}.gif' onmousemove='toolTip(\"" . get_player_class($online[1]) . "\",\"item_tooltip\")' onmouseout='toolTip()' /></td>\n\t\t\t\t\t\t<td>{$level}</td>\n\t\t\t\t\t\t<td>{$llogin}</td>\n\t\t\t\t\t\t<td>" . ($online[2] ? "<img src=\"images/online.gif\" alt=\"\" />" : "-") . "</td>\n\t\t\t\t\t\t<td>{$member['4']}</td>\n\t\t\t\t\t\t<td>{$member['5']}</td>\n\t\t\t\t\t\t<td>{$member['6']}</td>\n\t\t\t\t\t\t<td>{$member['7']}</td>\n\t\t\t\t\t</tr>";
}
echo "</table><br />";
}
mysql_close();
break;
default:
mysql_connect($characters[1]['host'], $characters[1]['user'], $characters[1]['password']) or die(mysql_error());
mysql_select_db($characters[1]['db']) or die(mysql_error());
$query_1 = mysql_query("SELECT count(*) FROM arena_team");
$all_record = mysql_result($query_1, 0);
$query = mysql_query("SELECT arena_team.arenateamid AS atid, arena_team.name AS atname, arena_team.captainguid AS lguid, arena_team.type AS attype,\n\t\t\t(SELECT name FROM `characters` WHERE guid = lguid) AS l_name,(SELECT COUNT(*) FROM arena_team_member WHERE arenateamid = atid) AS tot_chars,\n\t\t\trating AS atrating, games as atgames, wins as atwins\n\t\t\tFROM arena_team, arena_team_stats\n\t\t\tWHERE arena_team.arenateamid = arena_team_stats.arenateamid");
$this_page = mysql_num_rows($query);
echo "<center><table class=\"lined\">\n\t\t <tr>\n\t\t\t<th width=\"5%\">{$lang_arenateam['id']}</th>\n\t\t\t<th width=\"22%\">{$lang_arenateam['arenateam_name']}</th>\n\t\t\t<th width=\"10%\">{$lang_arenateam['captain']}</th>\n\t\t\t<th width=\"7%\">{$lang_arenateam['type']}</th>\n\t\t\t<th width=\"7%\">{$lang_arenateam['members']}</th>\n\t\t\t<th width=\"7%\">{$lang_arenateam['arenateam_online']}</th>\n\t\t\t<th width=\"7%\">{$lang_arenateam['rating']}</th>\n\t\t\t<th width=\"7%\">{$lang_arenateam['games']}</th>\n\t\t\t<th width=\"7%\">{$lang_arenateam['wins']}</th>\n\t\t\t</tr>";
</option>
<?php
}
?>
</select> <?php
echo $this->lang->line('days');
?>
</h5></b></li>-->
<li>
<?php
echo $this->lang->line('Job Type: (Make up to 5 selections.)');
?>
<!--OPTION LIST-->
<?php
//calculate no of days to open
$no_of_days = count_days($postSimilarall->created, $postSimilarall->enddate) - 1;
$res = explode(',', $postSimilarall->project_categories);
if (isset($groupsWithCategories) and count($groupsWithCategories) > 0) {
foreach ($groupsWithCategories as $groupsWithCategory) {
if ($groupsWithCategory['num_categories'] > 0) {
?>
<p><u><?php
echo $groupsWithCategory['group_name'];
?>
</u></p>
<div id="selProgrammingOptions">
<table>
<?php
$i = 0;
foreach ($groupsWithCategory['categories']->result() as $category) {
}
if (isset($preview)) {
$preview = $preview->row();
echo '<h3><p><b>' . $this->lang->line('Please click the link for view Preview Project') . '</b>';
?>
<b><a href="<?php
echo site_url('project/previewProject/' . $preview->id);
?>
" target="_blank" style="color:green;" ><?php
echo $this->lang->line('Preview');
?>
</a></b></p></h3 > <?php
}
//Calculate the no of days open the porject
if (isset($enddate) and isset($created)) {
$no_of_days = count_days($created, $enddate) - 1;
}
?>
<?php
$this->load->view('project/draftControll');
?>
<p><?php
echo $this->lang->line('Note');
?>
</p>
<h3><span class="clsFileManager"><?php
echo $this->lang->line('Account Login Details...');
?>
</span></h3>
/**
* calculate the consolidate bids details after 12 hr and send email to the buyer
*
* @access private
* @param nil
* @return void
*/
function bidConsolidate()
{
//Get all users details
$projects = $this->skills_model->getProjects();
foreach ($projects->result() as $res) {
$records = '';
$diff = count_days($res->created, get_est_time());
if ($diff > 0) {
$projectid = $res->id;
$projectname = $res->project_name;
//Get all bids details for the project
$bid_condition = array('bids.project_id' => $projectid);
$bids = $this->skills_model->getBids($bid_condition);
if (isset($bids) and count($bids->result()) > 0) {
$i = 1;
$records .= '<table border="1"><tr><th align="center">Sl.No</th><th width="300">Project Name</th> <th width="250">Username</th> <th width="100" align="center">Bid Amount</th> <th width="250" align="center">Bid Post Time</th></tr>';
foreach ($bids->result() as $bids) {
$user_condition = array('users.id' => $bids->user_id);
$users = $this->user_model->getUsers($user_condition);
$user = $users->row();
$records .= '<tr><td align="center">' . $i++ . '</td><td>' . $res->project_name . '</td><td>' . $user->user_name . '</td><td align="center">' . '$ ' . $bids->bid_amount . '</td><td align="center">' . get_datetime($bids->bid_time) . '</td></tr>';
}
$records .= '</table>';
$user_condition = array('users.id' => $res->creator_id);
$creator = $this->user_model->getUsers($user_condition);
$creator = $creator->row();
//Send Mail to project creator
$conditionUserMail = array('email_templates.type' => 'consolidate_bids');
$result = $this->email_model->getEmailSettings($conditionUserMail);
$rowUserMailConent = $result->row();
//Update the details
$splVars = array("!projectname" => '<a href="' . site_url('project/view/' . $res->id) . '">' . $res->project_name . '</a>', "!username" => $creator->user_name, "!contact_url" => site_url('contact'), "!site_url" => site_url(), '!site_name' => $this->config->item('site_title'), '!records' => $records);
$mailSubject = strtr($rowUserMailConent->mail_subject, $splVars);
$mailContent = strtr($rowUserMailConent->mail_body, $splVars);
$toEmail = $creator->email;
$fromEmail = $this->config->item('site_admin_mail');
$this->email_model->sendHtmlMail($toEmail, $fromEmail, $mailSubject, $mailContent);
}
}
}
}
$member_total = mysql_query("SELECT COUNT(*) AS nombre FROM guild_member WHERE guildid='{$id}'") or die(mysql_error());
$member_total = mysql_fetch_array($member_total);
$member_total = $member_total['nombre'];
echo "\n\t\t\t\t\t\t<h2>{$guilde['1']}</h2>\n\t\t\t\t\t\t<TABLE class=\"lined\" width=\"99%\" border=\"1\" cellpadding=\"2\" cellspacing=\"0\" align=\"center\">\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td colspan=\"11\" align=\"center\">Date de création: {$guilde['4']}</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td colspan=\"11\" align=\"center\">Info: {$guilde['2']}</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td colspan=\"11\" align=\"center\">Nombre total de membres: {$member_total}</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<th>ID</th>\n\t\t\t\t\t\t\t\t<th>Nom</th>\n\t\t\t\t\t\t\t\t<th>Race</th>\n\t\t\t\t\t\t\t\t<th>Class</th>\n\t\t\t\t\t\t\t\t<th>Niveau</th>\n\t\t\t\t\t\t\t\t<th>Rang</th>\n\t\t\t\t\t\t\t\t<th>Note Membre</th>\n\t\t\t\t\t\t\t\t<th>Note Office</th>\n\t\t\t\t\t\t\t\t<th>Dernière connexion</th>\n\t\t\t\t\t\t\t\t<th>En Ligne</th>\n\t\t\t\t\t\t\t</tr>";
if (mysql_num_rows($members_info) < 1) {
echo "<tr><td colspan=\"10\">Il n y a aucun membre dans cette guilde !</td></tr>";
} else {
while ($member = mysql_fetch_row($members_info)) {
$members_info2 = mysql_query("SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', " . (CHAR_DATA_OFFSET_LEVEL + 1) . "), ' ', -1) AS level, mid(lpad( hex( CAST(substring_index(substring_index(data,' '," . (CHAR_DATA_OFFSET_SEX + 1) . "),' ',-1) as unsigned) ),8,'0'),4,1) as gender FROM `characters` WHERE `name` = '{$member['2']}'") or die(mysql_error());
$member2 = mysql_fetch_row($members_info2);
$accid = $member2[3];
$race = $member2[0];
$class = $member2[1];
$online = $member2[2];
$gender = $member2[6];
$lastlogin = count_days($member2[4], time());
$rang = $member[4];
$rang2 = $member[1];
echo "<tr><td align=\"center\">";
echo $member[0];
echo "</td><td align=\"center\">";
echo "<a href=\"armurerie-select.php?perso={$member['2']}\">{$member['2']}</a>";
echo "</td><td align=\"center\">";
echo "<img src='images/races/{$race}-{$gender}.gif' />";
echo "</td><td align=\"center\">";
echo "<img src='images/classes/{$class}.gif' />";
echo "</td><td align=\"center\">";
echo $member[3];
echo "</td><td align=\"center\">";
echo "{$rang} ({$rang2})";
echo "</td><td align=\"center\">";
}
$id = intval(@$_REQUEST['arenateam']);
$arenateam_data = $cDB->selectRow("SELECT * FROM `arena_team` WHERE arenateamid = ?d", $id);
$arenateam_stats = $cDB->selectRow("SELECT * FROM `arena_team_stats` WHERE arenateamid = ?d", $id);
$arenateam_member = $cDB->selectPage($total_members, "SELECT * FROM `arena_team_member` WHERE arenateamid = ?d", $id);
if (!$arenateam_data) {
echo "{$lang['not_found']}";
}
if ($arenateam_data and $arenateam_stats and $arenateam_member) {
$losses_week = $arenateam_stats['games_week'] - $arenateam_stats['wins_week'];
$winperc_week = $arenateam_stats['games_week'] ? round($arenateam_stats['wins_week'] / $arenateam_stats['games_week'] * 100) : 0;
$losses_season = $arenateam_stats['games_season'] - $arenateam_stats['wins_season'];
$winperc_season = $arenateam_stats['games_season'] ? round($arenateam_stats['wins_season'] / $arenateam_stats['games_season'] * 100) : 0;
$type = $arenateam_data['type'];
$back = $arenateam_data['BackgroundColor'] + 0 & 0xffffff;
$emblem = $arenateam_data['EmblemStyle'];
$ecolor = $arenateam_data['EmblemColor'] + 0 & 0xffffff;
$border = $arenateam_data['BorderStyle'];
$bcolor = $arenateam_data['BorderColor'] + 0 & 0xffffff;
$emblem_image = "images/player_info/arena_ico.php?type={$type}&back={$back}&emblem={$emblem}&ecolor={$ecolor}&border={$border}&bcolor={$bcolor}";
echo "\n <table class=report width=100%>\n <tr>\n <td colspan=10 class=head>{$arenateam_data['name']} - {$arenateam_stats['rating']}</td>\n </tr>\n <tr>\n <td colspan=2>" . $lang['arena_this_week'] . "</td>\n <td colspan=2>" . $lang['arena_played'] . ": {$arenateam_stats['games_week']}</td>\n <td colspan=2>" . $lang['arena_wins'] . ": {$arenateam_stats['wins_week']}</td>\n <td colspan=2>" . $lang['arena_lose'] . ": {$losses_week}</td>\n <td colspan=2>" . $lang['arena_win_pct'] . ": {$winperc_week} %</td>\n </tr>\n <tr>\n <td colspan=2>" . $lang['arena_total_stat'] . "</td>\n <td colspan=2>" . $lang['arena_played'] . ": {$arenateam_stats['games_season']}</td>\n <td colspan=2>" . $lang['arena_wins'] . ": {$arenateam_stats['wins_season']}</td>\n <td colspan=2>" . $lang['arena_lose'] . ": {$losses_season}</td>\n <td colspan=2>" . $lang['arena_win_pct'] . ": {$winperc_season} %</td>\n </tr>\n <tr>\n <td colspan=5 align=center>" . $lang['arena_team_leader'] . ": " . getCharacterName($arenateam_data['captainguid']) . "</td>\n <td colspan=5 align=center>" . $lang['arena_members_count'] . ": {$total_members}</td>\n </tr>\n <tr>\n\t<th>" . $lang['player_level'] . "</th>\n\t<th>" . $lang['player_name'] . "</th>\n <th>" . $lang['player_race'] . "</th>\n\t<th>" . $lang['player_class'] . "</th>\n\t<th>" . $lang['last_login'] . "</th>\n\t<th>" . $lang['online'] . "</th>\n\t<th>" . $lang['arena_week_games'] . "</th>\n\t<th>" . $lang['arena_wins'] . "</th>\n\t<th>" . $lang['arena_season_games'] . "</th>\n\t<th>" . $lang['arena_wins'] . "</th>\n </tr>\n ";
foreach ($arenateam_member as $player) {
$fields = "`name`,\n `race`,\n `class`,\n `online`,\n `account`,\n `logout_time`,\n SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', " . (UNIT_FIELD_LEVEL + 1) . "), ' ', -1) AS level,\n (SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', " . (UNIT_FIELD_BYTES_0 + 1) . "),' ',-1)/(256*256)) & 255 AS gender";
if ($char = getCharacter($player['guid'], $fields)) {
$llogin = count_days($char['logout_time'], time());
echo "\n <tr>\n <td align=center>{$char['level']}</td>\n <td><a href=\"?player={$player['guid']}\">{$char['name']}</a></td>\n <td class=prace><img width=32 src='" . getRaceImage($char['race'], $char['gender']) . "'/></td>\n <td class=pclass><img width=32 src='" . getClassImage($char['class']) . "'/></td>\n <td align=center>{$llogin}</td>\n <td align=center>" . ($char['online'] > 0 ? "+" : "-") . "</td>\n <td align=center>{$player['played_week']}</td>\n <td align=center>{$player['wons_week']}</td>\n <td align=center>{$player['played_season']}</td>\n <td align=center>{$player['wons_season']}</td>\n </tr>";
}
}
echo "</table>";
echo "\n <table width=100% border=0 cellspacing=0 cellpadding=0>\n <tr>\n <td> <img src={$emblem_image}></td>\n <td align=right><img src={$emblem_image}> </td>\n </tr>\n </table>";
}
?>
</p>
<p><?php
echo $this->lang->line('Tip');
?>
</p>
</li>
<li>
<?php
echo $this->lang->line('Job Type: (Make up to 5 selections.)');
?>
<!--OPTION LIST-->
<?php
//calculate no of days to open
$no_of_days = count_days($draft->created, $draft->enddate) - 1;
$res = explode(',', $draft->project_categories);
if (isset($groupsWithCategories) and count($groupsWithCategories) > 0) {
foreach ($groupsWithCategories as $groupsWithCategory) {
if ($groupsWithCategory['num_categories'] > 0) {
?>
<p><u><?php
echo $groupsWithCategory['group_name'];
?>
</u></p>
<div id="selProgrammingOptions">
<table>
<?php
$i = 0;
foreach ($groupsWithCategory['categories']->result() as $category) {
