skin.board.webclap/_extend.php

<?php
$g5['clap_table'] = G5_TABLE_PREFIX . 'clap';

// database table check only admin (request reduce)
if ($is_admin) {
  if (!sql_table_exists($g5['clap_table'])) {
    sql_query(" CREATE TABLE IF NOT EXISTS `{$g5['clap_table']}` (
      `cl_id` int(11) NOT NULL AUTO_INCREMENT,
      `cl_ip` varchar(255)  NOT NULL default '',
      `cl_date` datetime NULL,
      `cl_cnt` int(11) NOT NULL default 1,
      `cl_val` varchar(255) NOT NULL default '',
      PRIMARY KEY (`cl_id`)
    ) ENGINE = MyISAM  DEFAULT CHARSET=utf8;", false);
  }
}

$last = date("Y-m-d", strtotime("today -30 day"));

$be = sql_fetch("SELECT cl_id,cl_date FROM {$g5['clap_table']} WHERE cl_cnt > 1 AND date_format(cl_date, '%Y-%m-%d') <= '{$last}' ORDER BY cl_date LIMIT 1");

if ($be['cl_id']) {
  $last = date("Y-m-d", strtotime($be['cl_date']));
}

$sum = sql_fetch("SELECT sum(cl_cnt) as sum FROM {$g5['clap_table']} WHERE date_format(cl_date, '%Y-%m-%d') <= '{$last}'");

if ($sum['sum']) {
  $cnt = $sum['sum'];
  sql_query("DELETE FROM {$g5['clap_table']} WHERE date_format(cl_date, '%Y-%m-%d') <= '{$last}'");
  sql_query("INSERT INTO {$g5['clap_table']} SET cl_cnt = '{$cnt}', cl_date = '" . G5_TIME_YMD . "', cl_val=1");
}