fgThxzU5

1function addstart($username,$days=null){
2    global $mysql_conn_postfix;
3
4    $db = new SQLite3("/usr/local/cwp/.conf/mail_stats/{$username}.db");
5    $arryCount=getUserDomains($username);
6
7    if(!file_exists("/usr/local/cwp/.conf/mail_stats/")){ shell_exec("mkdir -p /usr/local/cwp/.conf/mail_stats/"); }
8
9    $tableMigration ='CREATE TABLE IF NOT EXISTS "email_accounts" (
10        "ID"  INTEGER PRIMARY KEY AUTOINCREMENT,
11        "EMAIL"  TEXT,
12        "DOMAIN" TEXT,
13        "START_DATE" DATE,
14        "QUOTA" TEXT,
15        "MESSAGES" TEXT 
16        );';
17    $db->exec($tableMigration);
18    foreach ($arryCount as $domain){
19        $res=mysqli_query($mysql_conn_postfix, 'SELECT * FROM quota2 WHERE username LIKE "%'.$domain.'"');
20        if($res->num_rows > 0){
21            while($row=mysqli_fetch_assoc($res)){
22                $date=date("Y-m-d H:i:s");
23                $db->query("INSERT INTO email_accounts(EMAIL,DOMAIN,START_DATE,QUOTA,MESSAGES)VALUES('{$row['username']}','{$domain}','{$date}','{$row['bytes']}','{$row['messages']}')");
24            }
25        }
26    }
27
28    if($days==null){ $days=90;}
29    $date_history=date("d-m-Y",strtotime($date."- {$days} days"));
30
31    $db->query("Delete from email_accounts where START_DATE < '{$date_history}'");
32    $db->close();
33}