<?php $sql = "SELECT * FROM `users` WHERE `ID`='" . jb_escape_sql($_SESSION['JB_ID']) . "'"; $result = JB_mysql_query($sql); $row = mysql_fetch_array($result, MYSQL_ASSOC); $label["c_index_greeting"] = str_replace("%SITE_NAME%", JB_escape_html(JB_SITE_NAME), $label["c_index_greeting"]); $label["c_index_greeting"] = str_replace("%USERNAME%", JB_escape_html($_SESSION['JB_Username']), $label["c_index_greeting"]); $label["c_index_greeting"] = str_replace("%FIRST_NAME%", JB_escape_html($row['FirstName']), $label["c_index_greeting"]); $label["c_index_greeting"] = str_replace("%LAST_NAME%", JB_escape_html($row['LastName']), $label["c_index_greeting"]); ?> <h3 style="text-align:center"><?php echo $label["c_index_greeting"]; ?> </h3> <?php JBPLUG_do_callback('candidates_index_top', $A = false); if (JB_display_motd('U', 80)) { echo '<br>'; } $sql = "SELECT `hits`, `status` FROM `resumes_table` WHERE `user_id`='" . jb_escape_sql($_SESSION['JB_ID']) . "'"; $result = JB_mysql_query($sql); $row = mysql_fetch_array($result, MYSQL_ASSOC); $count = $row['hits']; if ($count != '') { if ($row['status'] == 'ACT') { $str = $label["c_index_resume_act"]; } else { $str = $label["c_index_resume_sus"]; } $label["c_index_views"] = str_replace("%COUNT%", $count, $label["c_index_views"]); $str = '<p style="text-align:center">' . $str . ' ' . $label["c_index_views"] . '</p>'; JB_display_info_box($label["c_index_status"], $str, 80);
$row = mysql_fetch_row($result); $users = $row[0]; $now = gmdate("Y-m-d"); $sql = "SELECT count(*) FROM `posts_table` WHERE user_id='" . jb_escape_sql($_SESSION["JB_ID"]) . "' AND expired='N' "; $result = JB_mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_row($result); $posts = $row[0]; $sql = "SELECT count(*) FROM `posts_table` WHERE user_id='" . jb_escape_sql($_SESSION["JB_ID"]) . "' AND `approved`='Y' AND expired='N' "; $result = JB_mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_row($result); $ap = $row[0]; $sql = "SELECT count(*) FROM `resumes_table` WHERE status='ACT' AND `approved`='Y' "; $result = JB_mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_row($result); $resume = $row[0]; if (JB_display_motd('E')) { echo '<p>'; } $msg = str_replace("%postcount%", $posts, $label["employer_home_stats"]); $msg = str_replace("%approvedpostcount%", $ap, $msg); $msg = str_replace("%usercount%", $users, $msg); $msg = str_replace("%resumecount%", $resume, $msg); $msg = str_replace("%SITE_NAME%", JB_SITE_NAME, $msg); // echo $msg; ?> <?php JB_render_box_top(100, $label['employer_home_status_summary']); echo $msg; ?>