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

SELECT users_trf.uid, uip, startmoney, submoney, startmoney - submoney AS nb FROM `users_trf` , `plans2` WHERE plans2.id = users_trf.packet && users_trf.startmoney -2 * users_trf.submoney <0 && users_trf.startmoney - users_trf.submoney >0

SELECT users_trf.uid, uip, startmoney, submoney, startmoney - submoney AS nb, plans2.price FROM `users_trf` , `plans2` WHERE plans2.id = users_trf.packet && plans2.price > startmoney - submoney && startmoney - submoney >0

include_once ('./config.php');
include_once ('./db.class.php');

include_once ('/полный/путь/до/config.php');
include_once ('/полный/путь/до/db.class.php');

<meta http-equiv="Content-Type" content="text/html; charset=utf8" />

$ip=$_SERVER['REMOTE_ADDR'];
blablabla
$query = "SELECT * FROM `users` WHERE `ip` LIKE CONVERT( _utf8 '$ip' USING cp1251 ) COLLATE cp1251_general_ci";

SELECT * FROM users WHERE ip='$ip'

$ip=$_SERVER['REMOTE_ADDR']
blablabla
$query = "SELECT * FROM `users` WHERE `ip` LIKE CONVERT( _utf8 '$ip' USING cp1251 ) COLLATE cp1251_general_ci";

ee /usr/local/etc/rc.d/nomessage

#!/bin/sh
# PROVIDE: nomessage
# REQUIRE: LOGIN mysql

. /etc/rc.subr

name="nomessage"
rcvar=`set_rcvar`

: ${nomessage_enable="YES"}
: ${nodeny_dir="/usr/local/nodeny"}

start_cmd="${name}_start"
stop_cmd="${name}_stop"
restart_cmd="${name}_restart"
pidfile="/var/run/${name}.pid"

nomessage_start()
{
    cd $nodeny_dir
    pid_old=`cat $pidfile 2>/dev/null`
    echo -n "Starting $name..."
    perl ${name}.pl message.txt &
    sleep 2
    pid_new=`cat $pidfile 2>/dev/null`
    if [ $pid_old ] && [ $pid_old = $pid_new ];
    then
      echo "No. Already running"
    else
      echo "OK"
    fi
}

nomessage_stop()
{
    cd $nodeny_dir
    echo -n "Stopping $name..."
    pid=`cat $pidfile 2>/dev/null`
    if [ $pid ];
    then
       kill -TERM $pid;
       echo -n "Waiting pid $pid"
       while true
       do
         echo -n "..."
         if [ ! -f "$pidfile" ]; then break; fi
         sleep 1
       done
       echo "OK"
    else
       echo "$name is not running (no $pidfile)"
    fi
}

nomessage_restart()
{
    nomessage_stop    
    nomessage_start
}

load_rc_config $name
run_rc_command "$1"

cd /usr/local/etc/rc.d/
chmod 744 nomessage

Can't call method "prepare" without a package or object reference at ./nomessage.pl line 94.
 at ./nomessage.pl line 94
        main::Form_Config called at ./nomessage.pl line 353

<script type="text/javascript">
var cansubmit=0;
var sekond=20;
idinterval=setInterval("timerr();",1000);
function submitform(){
    if(cansubmit==0){
       return false;
    }else{
       return true;
    }
}
function timerr(){
     if(sekond>0){
          sec.a777.value="Осталось "+sekond+" секунд";
                  sekond--;
     }else{
          sec.a777.value="Ознакомлен";
          cansubmit=1;
    }
}
</script>

if ($p1->{'next_paket'}!='') { $packet = 'next_paket' } else { $packet = 'paket' };

$money_param2={
              paket => $p1->{$packet},

if ($p1->{'next_paket'}!='') { $packet = 'next_paket' } else { $packet = 'paket' };

$money_param2={
              paket => $p1->{next_packet}>0?$p1->{next_packet}:$p1->{$packet},

Id	User	Host	db	Command	Time	State	Info
2	root	localhost	bill	Query	5	Locked	INSERT into dblogin (mid,act,time) VALUES ( NAME_CONST('usr_id',2335),47,unix_timestamp())
3	root	localhost	bill	Query	3	Locked	INSERT into dblogin (mid,act,time) VALUES\n    ((SELECT id FROM users WHERE name= NAME_CONST('login',_cp1251'andrey' COLLATE 'cp1251_general_ci') LIMIT 1),47,unix_timestamp())
4	root	localhost	bill	Query	5	Copying to tmp table	SELECT SQL_CALC_FOUND_ROWS field_value INTO usrAdvID FROM dopdata WHERE\n        revision IN (SELECT rev FROM rev_users WHERE template_num=1 AND\n                     id IN (SELECT id FROM users WHERE id= NAME_CONST('_mid',668) OR mid= NAME_CONST('_mid',668))) AND\n        field_alias= NAME_CONST('alias_name',_cp1251'_mac' COLLATE 'cp1251_general_ci') AND field_value= NAME_CONST('stationId',_cp1251'00:e0:4d:56:87:14' COLLATE 'cp1251_general_ci')
5	root	localhost	bill	Query	5	statistics	SELECT id,ip INTO usr_id,usr_ip FROM users WHERE name= NAME_CONST('login',_cp1251'pst' COLLATE 'cp1251_general_ci')
6	root	localhost	bill	Query	5	update	INSERT into dblogin (mid,act,time) VALUES ( NAME_CONST('usr_id',1351),47,unix_timestamp())
19	bill_kernel	localhost	bill	Sleep	8		NULL
23	bill_kernel	localhost	bill	Query	6	statistics	SELECT field_alias,field_value FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1464 AND revision=(SELECT MAX(revision) FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1464)
24	bill_kernel	localhost	bill	Query	6	Sending data	SELECT field_alias,field_value FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1489 AND revision=(SELECT MAX(revision) FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1489)
25	bill_kernel	localhost	bill	Sleep	4		NULL
29	bill_kernel	localhost	bill	Query	5	Locked	UPDATE users SET auth='on' WHERE id=547 LIMIT 1
56285	bill_kernel	localhost	bill	Sleep	155		NULL
56360	bill_kernel	localhost	bill	Sleep	156		NULL
56362	bill_kernel	localhost	bill	Sleep	148		NULL
58766	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1629' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1629' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58767	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58769	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58770	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58771	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58772	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58773	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1629' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1629' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58774	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1629' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1629' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58775	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58776	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58777	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58778	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58779	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58780	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58781	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58782	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58783	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58784	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58786	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58788	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58789	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58790	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58791	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58792	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58794	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58795	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58796	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58797	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58798	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58799	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58800	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58801	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58802	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58803	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58804	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58805	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58807	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58808	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58810	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58811	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58812	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58813	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58815	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58816	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58817	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58819	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
........лимит 20000 знаков.......
59047	root	localhost	NULL	Query	0	NULL	show full processlist