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) {