get_results(“select * from wp_posts where post_type LIKE ‘%entry%’ AND post_status = ‘publish’ order by ID”);

if ( $vfb_entries )
{

echo “* 점수는 에세이 / 봉사 의 포맷으로 표시되어 있습니다.”;
echo “

“;

$scorers = $wpdb->get_results(“select DISTINCT cuserid from _vscholar_scores ORDER BY cuserid”);
if ( $scorers )
{
foreach ( $scorers as $each )
{
$scorer = $wpdb->get_row(“select * from wp_users where ID = ‘”.$each->cuserid.”‘”);
$scorer_name = $scorer->user_login;
echo “

“;
}
}
echo “

“;

foreach ( $vfb_entries as $post )
{
$eid = $post->ID;

$vfb_entry_fname = $wpdb->get_row(“select * from wp_postmeta where post_id = “.$eid.” AND meta_key = ‘_vfb_field-3′”);
$fname = $vfb_entry_fname->meta_value;
$vfb_entry_lname = $wpdb->get_row(“select * from wp_postmeta where post_id = “.$eid.” AND meta_key = ‘_vfb_field-4′”);
$lname = $vfb_entry_lname->meta_value;

echo “

“;

$total_score1 = 0;
$total_score2 = 0;
foreach ( $scorers as $each )
{

$vfb_entry_score = $wpdb->get_row(“select * from _vscholar_scores where eid = “.$eid.” AND cuserid = “.$each->cuserid);
if ( $vfb_entry_score )
{
echo “

“;
$total_score1 = $total_score1 + $vfb_entry_score->score1;
$total_score2 = $total_score2 + $vfb_entry_score->score2;
} else {
echo “

“;
}
}

$total_score = $total_score1 + $total_score2;
echo “

“;
}

echo “

지원자\평가자$scorer_name에세이총점서비스총점합계총점
$fname $lname“.$vfb_entry_score->score1.” / “.$vfb_entry_score->score2.” $total_score1$total_score2$total_score

“;
}
else
{
?>

Not Found