Биллинговая система Nodeny

DROP VIEW IF EXISTS v_services;
CREATE ALGORITHM=MERGE VIEW v_services AS
    SELECT u.*, s.module, s.category, s.title, s.description, s.grp_list,
        s.price, s.auto_renew, s.no_renew, s.param 
    FROM users_services u LEFT JOIN services s ON u.service_id = s.service_id;

# cat patch.services.inet_unlim.pm
#<ACTION> file=>'services/inet_unlim.pm',hook=>'set_service'

    $actions->{set_service}{finish_count} = int $service_new->{param}{finish_count};


#<ACTION> file=>'services/inet_trinitytv.pm',hook=>'set_service',after=>'trinitytv_combo'

    $actions->{set_service}{finish_count} = int $service_new->{param}{finish_count};

#<ACTION> file=>'services/inet_megogo.pm',hook=>'set_service',after=>'megogo_combo'

    $actions->{set_service}{finish_count} = int $service_new->{param}{finish_count};