회원 포인트를 초기화 시켜 일괄적으로 포인트를 부여하려 합니다.

</p>

<p><?php

$sub_menu = "200210";

include_once("./_common.php");</p>

<p>auth_check($auth[$sub_menu], "r");</p>

<p>// 테이블 락을 걸고

$sql = " LOCK TABLES $g5[member_table] WRITE, $g5[point_table] WRITE ";

sql_query($sql);</p>

<p>$sql = " select mb_id, sum(po_point) as sum_point from $g5[point_table] group by mb_id order by mb_id ";

$result = sql_query($sql);

for ($i=0; $row=sql_fetch_array($result); $i++) {

    $sql = " update $g5[member_table]

                set mb_point = '$row[sum_point]'

              where mb_id = '$row[mb_id]' ";

 sql_query($sql);

}</p>

<p>sql_query(" delete from $g5[point_table] ");</p>

<p>sql_query(" alter table $g5[point_table] auto_increment=1 ");</p>

<p>$count = 0;

$sql = " select mb_id, mb_point from $g5[member_table] order by mb_id ";

$result = sql_query($sql);

for ($i=0; $row=sql_fetch_array($result); $i++) {

    $sql = " insert $g5[point_table]

                set mb_id = '$row[mb_id]',

                    po_datetime = '$g5[time_ymdhis]',

                    po_content = '기존회원 포인트지급',

                    po_point = '$row[mb_point]' ";

    sql_query($sql);

    $count++;

}</p>

<p>sql_query(" update g5_point set po_point = '2000'; ");</p>

<p>// 테이블 락을 풀고

$sql = " UNLOCK TABLES ";

sql_query($sql);</p>

<p>echo "<span size=5>총 {$count}건의 회원포인트 내역이 정리 되었습니다.</span>";

?>

<p><input type=button value='포인트 페이지로' onClick="javascript:self.location='./point_list.php'"></p>

<p>