BG03JNGJ

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