abills.net.ua

Код: Выделить всё

796c796,798
<   u.ext_bill_id
---
>   b.deposit,
>   u.ext_bill_id,
>   u.expire < CURDATE()
797a800
>      LEFT JOIN bills b ON (u.bill_id = b.id)
800,801c803,804
<         AND (u.expire='0000-00-00' or u.expire > CURDATE())
<         AND (u.activate='0000-00-00' or u.activate <= CURDATE())
---
>         AND (u.expire > '0000-00-00' or u.expire <= CURDATE())
>         AND (u.activate = '0000-00-00' or u.activate <= CURDATE())
827c830,832
<      $self->{EXT_BILL_ID}
---
>      $self->{DEPOSIT},
>      $self->{EXT_BILL_ID},
>      $self->{EXPIRED}
829a835,872
>       $self->query($db, "select dv.tp_id,
>       tp.activate_price,
>       tp.age
>          FROM (dv_main dv, tarif_plans tp)
>          WHERE dv.tp_id=tp.id
>              AND dv.uid='$self->{UID}'
>          GROUP BY dv.uid;");
>
>       if ($self->{TOTAL} < 1)
>       {
>         $RAD_PAIRS{'Reply-Message'}="No TP used during auto-change";
>         return 1, \%RAD_PAIRS;
>       }
>
>       ($self->{TP_ID},$self->{TP_ACT_PRICE},$self->{TP_AGE},) = @{ $self->{list}->[0] };
>
>       my $admin = $CONF->{SYSTEM_ADMIN_ID};
>
>      if($self->{EXPIRED})
>      {
>       if($self->{TP_ACT_PRICE} > 0)
>          {
>           if ($self->{DEPOSIT} + $self->{CREDIT} < $self->{TP_ACT_PRICE})
>           {
>               $RAD_PAIRS{'Reply-Message'}="Not enough money for re-activate";
>               return 1, \%RAD_PAIRS;
>           }
>           $self->query($db, "UPDATE bills SET deposit=deposit-$self->{TP_ACT_PRICE} WHERE id='$self->{BILL_ID}';", 'do');
>           $self->query($db, "INSERT INTO fees (uid, bill_id, date, sum, dsc, ip, last_deposit, aid, vat)
>                 values ('$self->{UID}', '$self->{BILL_ID}', NOW(), '$self->{TP_ACT_PRICE}', 'RE-ACTIVATE TP',
>                 '0', '$self->{DEPOSIT}', '$CONF->{SYSTEM_ADMIN_ID}',
>                 '0');", 'do');
>           if ($self->{TP_AGE} > 0)
>           {
>               $self->query($db, "UPDATE users SET  activate=curdate(), expire=curdate() + INTERVAL $self->{TP_AGE} day WHERE uid='$self->{UID}';", 'do');
>           }
>          }
>      }