isp.points triggers

checkmail_cron.php

<?php
ob_start();

require_once("include/config.php");
require_once(S_DIR_INC . "functions.php");
require_once(S_DIR_INC . "class.db.php");
require_once(S_DIR_INC . "class.news.php");
require_once(S_DIR_INC . "class.secure.php");
require_once(S_DIR_INC . "class.page.php");

    $dbisp = NEW DB("127.0.0.1","login","password","isp");
    $dbok = $dbisp->IsOpen;
    $dberror_no = $dbisp->error_no;
    $res = $dbisp->Query("select login, password, active from points where login <> ''");
    while($row = $res->fetch_assoc())
    {
        $login    = $row['login'];
        $password = $row['password'];
        if(!isset($login) or ($login == ""))
            continue;
        if(!isset($password) or ($password == ""))
            continue;
        $active = $row['active'];
#       $active0 = $row['active'];
#       if($active0 == 1) { $active = 0; }
#       else { $active = 1; };

        if(isset($login)){
            $result1 = $dbisp->Query("select login from mailusers  where login like '$login@%'");
            //print "select login from mailusers  where login like '$login@%'" ;
            //echo "\n";
            $count = $result1->num_rows;
            if($count > 0){
                #print $login." ".$active." "."\n";
                $ok = $dbisp->Query("update  mailusers  set pwd = '$password', expired=$active where login like '$login@%'");
            }else{
                $ok = $dbisp->Query("insert into mailusers(login,pwd,expired, maildir) values('$login@icn.od.ua','$password',$active,'icn.od.ua/$login/')");
            };
        };
    };

?>

insert.sql

DROP TRIGGER IF EXISTS after_points_insert;
CREATE TRIGGER after_points_insert
AFTER INSERT ON TABLE points FOR EACH ROW
INSERT INTO mailusers(login,pwd,expired, maildir) VALUES(CONCAT(NEW.login,'@icn.od.ua'),NEW.password,NEW.active,CONCAT('icn.od.ua/',NEW.login, '/');

update.sql

DROP TRIGGER IF EXISTS after_points_update;
CREATE TRIGGER after_points_update
AFTER UPDATE ON points for EACH ROW
update  mailusers  set pwd = NEW.password , expired=NEW.active where login like CONCAT(NEW.login,'@%');