PHP JB_display_motdの例

コード例 #1

ファイル: index.php プロジェクト: vinothtimes/phpdoc

<?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);

コード例 #2

ファイル: index.php プロジェクト: vinothtimes/dchqtest

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