<?

include_once("./_common.php");

$ss_name = "ss_score_{$bo_table}_{$wr_id}";

if (get_session($ss_name)) die('d');

$write_table = $g4['write_prefix'].$bo_table;

$good = $field;

$field = "wr_".$field;

$sql = " update $write_table set $field = $field + 1 where wr_id = '$wr_id' ";

sql_query($sql);

sql_query(" insert $g4[board_good_table] set bo_table = '$bo_table', wr_id = '$wr_id', mb_id = '$member[mb_id]', bg_flag = '$good', bg_datetime = '$g4[time_ymdhis]' ");

// 불당팩 - 추천수에 따라서 베스트글 등록 - 추천뒤에 있어야 갯수를 제대로 반영

if ($board[bo_list_good] > 0) {

$sql = " select count(*) as cnt from $g4[board_good_table] where bo_table='$bo_table' and wr_id='$wr_id' and bg_flag = 'good' ";

$list_good = sql_fetch($sql);

if ($list_good[cnt] >= $board[bo_list_good]) {

// UPDATE를 먼저하고 오류가 발생시 insert를 실행

$sql = " update $g4[good_list_table] set good = $list_good[cnt] where bo_table='$bo_table' and wr_id='$wr_id' ";

$result = sql_query($sql, FALSE);

if ( mysql_affected_rows() == 0 ) {

$sql = " insert $g4[good_list_table] ( mb_id, gr_id, bo_table, wr_id, wr_datetime, gl_datetime, good) values ( '$write[mb_id]','$board[gr_id]' , '$bo_table', '$wr_id', '$write[wr_datetime]', '$g4[time_ymdhis]', '$list_good[cnt]' ) ";

$result = sql_query($sql);

}

}

}

if ($board[bo_list_nogood] > 0) {

$sql = " select count(*) as cnt from $g4[board_good_table] where bo_table='$bo_table' and wr_id='$wr_id' and bg_flag = 'nogood' ";

$list_nogood = sql_fetch($sql);

if ($list_nogood[cnt] >= $board[bo_list_nogood]) {

// UPDATE를 먼저하고 오류가 발생시 insert를 실행

$sql = " update $g4[good_list_table] set nogood = $list_nogood[cnt] where bo_table='$bo_table' and wr_id='$wr_id' ";

$result = sql_query($sql, FALSE);

if ( mysql_affected_rows() == 0 ) {

$sql = " insert $g4[good_list_table] ( mb_id, gr_id, bo_table, wr_id, wr_datetime, gl_datetime, nogood) values ( '$write[mb_id]','$board[gr_id]' , '$bo_table', '$wr_id', '$write[wr_datetime]', '$g4[time_ymdhis]', '$list_nogood[cnt]' ) ";

$result = sql_query($sql);

}

}

}

$sql = " select wr_good, wr_nogood from $write_table where wr_id = '$wr_id' ";

$row = sql_fetch($sql);

set_session($ss_name, TRUE);

echo $row[wr_good].",".$row[wr_nogood];

?>