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

perl -MCPAN -e 'install "LWP::UserAgent"'

apachectl restart

cpan DBD::mysql

ls -la /usr/local/www/apache22/cgi-bin/stat.pl

mysql> DESCRIBE notifications;
+---------+---------------------+------+-----+---------+----------------+
| Field   | Type                | Null | Key | Default | Extra          |
+---------+---------------------+------+-----+---------+----------------+
| id      | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| created | int(10) unsigned    | NO   | MUL | NULL    |                |
| uid     | bigint(20)          | NO   | MUL | 0       |                |
| url     | varchar(255)        | NO   |     |         |                |
| msg     | varchar(255)        | NO   |     |         |                |
| sent    | enum('yes','no')    | NO   | MUL | no      |                |
| tries   | tinyint(3) unsigned | NO   |     | 0       |                |
| type    | varchar(255)        | NO   |     |         |                |
+---------+---------------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)

mysql> DESCRIBE notifications_users;
+---------+------------------+------+-----+---------+----------------+
| Field   | Type             | Null | Key | Default | Extra          |
+---------+------------------+------+-----+---------+----------------+
| id      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| updated | int(10) unsigned | NO   | MUL | NULL    |                |
| uid     | bigint(20)       | NO   | MUL | 0       |                |
| reg_id  | varchar(255)     | NO   | UNI |         |                |
+---------+------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

169	stat.pl
1242	calls.pm::Require_web_mod
1235	calls.pm::Require_mod
1235	calls.pm
78	start_admin.pl
26	_op.pl::go
123	_op.pl::go
1085	_o_tickets.pl::addsub_remove_ticket
197	Db.pm::do_all
181	Db.pm::rollback

169	stat.pl
1242	calls.pm::Require_web_mod
1235	calls.pm::Require_mod
1235	calls.pm
78	start_admin.pl
26	_op.pl::go
123	_op.pl::go
1086	_o_tickets.pl::addsub_remove_ticket
587	calls.pm::Error
466	calls.pm::Exit
420	calls.pm::Render

 perl nokernel.pl -m=notifications -v
Start. Flag -h for help

loading /usr/local/nodeny/sat.cfg

Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.014981 sec

SELECT * FROM config ORDER BY time DESC LIMIT 1
Строк: 1. Время выполнения sql: 0.0001 сек

loading kernel::_notifications.pm

Start

SELECT * FROM notifications_users
Строк: 16. Время выполнения sql: 0.0003 сек

user -> registration_id:
{
  '577' => [
    'dSj4xZCBL0c:APA91bGDxMGPkFKuuACO6csNY-47yhM76hvR12fpwtpcYyqXYytfTkbD3mC5Aa-2v5K-RpmRXVS46pjd-aDS7AsxxR2ShAgGH8a0AxN6taS8HfaMKI6eravyUE5SzZC097vs6TRmL6YF',
    'dOzWZmFOXzE:APA91bFwTCHCV4miTz7wKFhQLTVTBlSUuxsTYb1y1Zg-OpoWOV7-DOzd_5248ObAWcAc8_2J0XebrtKWfMaaKEijlraZfRIB0PlM1s1HBseZgX6Re7Y0uWoJukngOuQy98W1OqI7_vmF',
    'd5VOKVMgLoY:APA91bE0vWb7c3J_FOjbCKLcjRVOWZNObiRj1EqjSCtikGat9bz-IRgLlE0PQ5Eu4yzFeZc03_jwAgPvNatTwxvcpvLRwmJrgppSZZfACwLCAbo0whShj2DvMWwOU-Sri8-Rxe9VgiZ0',
    'fQmYECVJOHk:APA91bE7c0tiIkF3lNvT8-XofT2YxtCA0PjsCpnqGQz5QRex6AQpLaahD4thJO3RSe3gd9WLOaUPGG5vKhK0gD0d5SsEvFG6AzQDMdm8XNgE4EjjaaRAZD_57-bD3707UZoh8pA4Ej_T',
    'dN8L8fDLFc8:APA91bFU0A5AO3V1jE1sDSNoKsMfOKXPuZpr7ionnAyQ_Bl-NOeX3JhGR_VYIa5SpQ6GvBJ0M7g4UjeumSWi7KhesxpoHa_EpwN9kYLJF-7Z4iil4jbZgPoroZ4DEb6iGOhjg7jbmZYK',
    'f6aA-HbtrJs:APA91bFLhZYnzRgHRIDqKIU3TE2j26qVGbr_dCzOX-v4ru_j8z3---SL4poHkW1m644GMb-NEIPRPTkVJ7JWhoWHBedZ7DvTgWBj-SP62iCysTXviLYvJH0zLhMglCjOBK-FJgbjCD9Y'
  ],
  '594' => [
    'fM1keMg2cok:APA91bFz0Lwky7ZVFh219D2Kh2yV7xA5tjXulIC95NkATUm_D6HkYB44mH2aXV9xJG8ALhiFzl4LhMfRBl660cqzsx6pGd3JTHwPCmzNpQSkCpAnIYHkHJGUh5VH-elJOzzm2ztzOEtN'
  ],
  '579' => [
    'fYmgu7emQvw:APA91bHt51inb29B8XGQiw7evWfz0YQO0-1_DNhpkaC7GtVvfJmofcVBnCqcyz9madEJrKRPmBwQzmLEj3hyzbXfUlg_5Lbc5Q9ePefepANcIFn9uV8g_L8YInb6d0qv2HKSxTlT7FxI',
    'e-NdOCj38JU:APA91bEr9SJ5WvB77qPnShMRmtnw0bnowwgzBn0ToU-WU_G4lKFFPgzy1zsrCSKF4FWrquqAdNImT-UiyGhAtjraqBUF2in4jIInRDMF-84STGjdu0r0XKCcEEamaqCzgY-uu6bZTu4t',
    'cQFVAUvBhLY:APA91bHuAPpfGT951DN1mqyIu4tFeCtls-ZA0VtsnO46kiao99_sNqIbuT65x1Jbhmny5818_cia9BZqnsfGl7_I7Ft_IHwydGs6wieHD3F6rZbpdCrC4EJwiKTdBnpSzwDXrIEAFxXF',
    'cbk6Jo26LfQ:APA91bHmPJlnKv-TiY6TR2p_2yds1yWeBGYg_lRs35Xbx0Y-2CK-Tx2WIoqOeCGuQ-DlyR7jXLHeKcc2y7DHL7y45kyooec_lIZIgfD9f74S4J5q2rWh6ktE7XsOJw7WQ8083NNu_Fd2',
    'dWxqHkKfBS8:APA91bHaSs7EEuUudSzCIyNm8C7xQB5yH2ZHwOOvSmfAzm27LqY_Uc9DVYBgnvwEy7QRo046jsl_Jwcs2NyPzpeVoupT4fqPLjdEhXwuqD0DMuIV2iw4NzNYg234k2r85TS6_NtZ_aqK',
    'feaab1BfAwM:APA91bEBtddSW1Mzp18nX36p1G3xi4gRbhjUouopgBeM8fHTMoR_zkgpRc6nnNQVpVX-QWV7_LeArlcc0Qlzlvthi-GfKUg9SbAnqFoJmc2FeCEeLN-y45r_gRmvF9NxP5akNxssOiEG',
    'fvHaltcb5bY:APA91bHXw8HsFvMk9dCQZ1RhsO1Fb-E9TiRUxAkZuMOEQdsY_9F0BiugXlU8JA98Dc1rcJVIv9cblN3oECSYg5nvoFYTKdzuJcgJjiX0McJ4sPPWmGPAJwbQ9U93Ei740c85mHluXnav',
    'eXTTzB2uClM:APA91bF4LqC7ugcuXlUCyEfY0A52mPVLG_fDwJede-ORWPgj_CC2AGoHMKKd0msimatQjZwYeyUDvuT79UAFkm4_yI1Rm8zCFDJ05GlklbfyEpxanMFTkrbQN3s3BICOvaHIMNf5Xt-y',
    'dnpky8J7HFw:APA91bHvHLy7m4nIQlRIiQHfiy1kTJtdKeHkni2n-St003hPF-1SHy1-T2FJ0r3h9WpdlSS8QNh-1bme-jm9ia_qDYVXljokOetwS4Wc8MTN2K0142vxiM06u2l4P5VkFtO2hr_77Z6Q'
  ]
};


SELECT * FROM notifications WHERE sent='no' AND tries<10
Строк: 7. Время выполнения sql: 0.0003 сек

POST _h t tp s://gcm-h t tp.googleapis.com/gcm/send
Authorization: key=AIzaSyBpjUzoqzgtFUqdb1YboJWCOgLKGVXsyAo
Ao
User-Agent: NodenyAgent
Content-Length: 1417
Content-Type: application/json

{"registration_ids":["fYmgu7emQvw:APA91bHt51inb29B8XGQiw7evWfz0YQO0-1_DNhpkaC7GtVvfJmofcVBnCqcyz9madEJrKRPmBwQzmLEj3hyzbXfUlg_5Lbc5Q9ePefepANcIFn9uV8g_L8YInb6d0qv2HKSxTlT7FxI","e-NdOCj38JU:APA91bEr9SJ5WvB77qPnShMRmtnw0bnowwgzBn0ToU-WU_G4lKFFPgzy1zsrCSKF4FWrquqAdNImT-UiyGhAtjraqBUF2in4jIInRDMF-84STGjdu0r0XKCcEEamaqCzgY-uu6bZTu4t","cQFVAUvBhLY:APA91bHuAPpfGT951DN1mqyIu4tFeCtls-ZA0VtsnO46kiao99_sNqIbuT65x1Jbhmny5818_cia9BZqnsfGl7_I7Ft_IHwydGs6wieHD3F6rZbpdCrC4EJwiKTdBnpSzwDXrIEAFxXF","cbk6Jo26LfQ:APA91bHmPJlnK...
(+ 905 more bytes not shown)
HTTP/1.1 200 OK
Cache-Control: private, max-age=0
Connection: close
Date: Tue, 19 Jul 2016 03:35:37 GMT
Accept-Ranges: none
Server: GSE
Vary: Accept-Encoding
Content-Type: application/json; charset=UTF-8
Expires: Tue, 19 Jul 2016 03:35:37 GMT
Alt-Svc: quic=":443"; ma=2592000; v="36,35,34,33,32,31,30,29,28,27,26,25"
Alternate-Protocol: 443:quic
Client-Date: Tue, 19 Jul 2016 02:14:44 GMT
Client-Peer: 216.58.209.170:443
Client-Response-Num: 1
Client-SSL-Cert-Issuer: /C=US/O=Google Inc/CN=Google Internet Authority G2
Client-SSL-Cert-Subject: /C=US/ST=California/L=Mountain View/O=Google Inc/CN=*.googleapis.com
Client-SSL-Cipher: AES128-SHA
Client-SSL-Socket-Class: IO::Socket::SSL
X-Content-Type-Options: nosniff
X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block

{"multicast_id":8425864579289012651,"success":0,"failure":9,"canonical_ids":0,"results":[{"error":"NotRegistered"},{"error":"MismatchSenderId"},{"error":"NotRegistered"},{"error":"NotRegistered"},{"error":"NotRegistered"},{"error":"NotRegistered"},{"error":"NotRegistered"},{"error":"NotRegistered"},{"error":"NotRegistered"}]}
response content: {"multicast_id":8425864579289012651,"success":0,"failure":9,"canonical_ids":0,"results":[{"error":"NotRegistered"},{"error":"MismatchSenderId"},{"error":"NotRegistered"},{"error":"NotRegistered"},{"error":"NotRegistered"},{"error":"NotRegistered"},{"error":"NotRegistered"},{"error":"NotRegistered"},{"error":"NotRegistered"}]}

UPDATE notifications SET tries=tries+1 WHERE id='51'
Строк: 1. Время выполнения sql: 0.0010 сек

end

1. DELETE from tickets;
2. DELETE FROM changes WHERE tbl = "tickets";

$cfg::ticket_img_valid_ext = 'jpg|jpeg|png|gif';

#<ACTION> file=>'web/user/message.pl',hook=>'new',after=>'tickets'

Can't locate object method "fields" via package "Data" at /usr/local/nodeny/web/_o_tickets.pl line 883.
Compilation failed in require at /usr/local/nodeny/web/calls.pm line 1412.

26.07.2018 08:37:48 [stat.pl(170) stat.pl::__ANON__(30) stat.pl(30) stat.pl::Hard_exit(89) stat.pl(92)]

 svn di --summarize
M       htdocs/index.html
M       sat.cfg

Can't locate object method "fields" via package "Data" at /usr/local/nodeny/web/_o_tickets.pl line 903.
Compilation failed in require at /usr/local/nodeny/web/calls.pm line 1414.

31.03.2020 09:00:26 [stat.pl(179) stat.pl::__ANON__(30) stat.pl(30) stat.pl::Hard_exit(89) stat.pl(90)]
Can't call method "form" on an undefined value at /usr/local/nodeny/web/_o_tickets.pl line 909.
Compilation failed in require at /usr/local/nodeny/web/calls.pm line 1463.

transform-origin: top left;

cat /tmp/nodeny_1610223194_9400614.log