<?php
$sub_menu = "300800";
include_once('./_common.php');

$g5['title'] = '게시판 리카운트';
include_once('./admin.head.php');

$sql_board_qry = " select bo_table from `{$g5['board_table']}` ";
$sql_board_result = sql_query($sql_board_qry);

for ($i = 0; $row = sql_fetch_array($sql_board_result); $i++) {
    echo $row['bo_table'];
    echo "<br>";

    $g5_board_name = $row['bo_table'];

    $sql_board_count_qry = " select COUNT(*) AS CNT FROM ".$g5['write_prefix'] .  $g5_board_name;
    $sql_board_count_qry .= " where wr_is_comment = 0";
    $sql_board_count_result = sql_query($sql_board_count_qry);

    $row = sql_fetch_array($sql_board_count_result);

    echo $row['CNT'];
    echo "<br>";

    $sql_board_upd_qry = " update g5_board set ";
    $sql_board_upd_qry .= " bo_count_write = ".$row['CNT'];
    $sql_board_upd_qry .= " where bo_table = '".$g5_board_name."'";

    echo $sql_board_upd_qry;
    echo "<br>";
    echo "<br>";
    sql_query($sql_board_upd_qry);

}

include_once('./admin.tail.php');

?>


