osmys

[Duster]

Versiune noua 1.2 cu suport pentru oscam.srvid

https://ufile.io/hry4t

si inca cateva SQL Queriuri scrise de mine ce te poate ajuta ...
acestea se pot modifica usor la nevoile fiecaruia.

SET group_concat_max_len = 2048;
SELECT caid, provid, GROUP_CONCAT(DISTINCT chid SEPARATOR ',') AS chids, COUNT(DISTINCT(chid)) AS totalchids, COUNT(chid) AS totalecm
FROM oscamlog WHERE byreader='readername' AND (caid='09C4' OR caid='098C' OR caid='0B00') AND ecmtype='found' AND ecmtime <= 200
GROUP BY caid, provid;

SELECT caid, provid, chid,
SUM(if(ecmtime <= 100,1,0)) AS Tlt100,
SUM(if(ecmtime <= 200 AND ecmtime > 100,1,0)) AS Tlt200,
SUM(if(ecmtime <= 300 AND ecmtime > 200,1,0)) AS Tlt300,
SUM(if(ecmtime <= 400 AND ecmtime > 300,1,0)) AS Tlt400,
SUM(if(ecmtime <= 500 AND ecmtime > 400,1,0)) AS Tlt500,
SUM(if(ecmtime > 500,1,0)) AS Tgt500,
COUNT(chid) AS total,
MAX(logtime)
FROM oscamlog WHERE byreader='readername' AND (caid='09C4' OR caid='098C' OR caid='0B00') AND ecmtype='found'
GROUP BY caid, provid, chid;

SELECT caid, provid, COUNT(caid) AS total, MIN(ecmtime) AS minT, 
SUM(if(ecmtime <= 100,1,0)) AS Tlt100,
SUM(if(ecmtime <= 200 AND ecmtime > 100,1,0)) AS Tlt200,
SUM(if(ecmtime <= 300 AND ecmtime > 200,1,0)) AS Tlt300,
SUM(if(ecmtime <= 400 AND ecmtime > 300,1,0)) AS Tlt400,
SUM(if(ecmtime <= 500 AND ecmtime > 400,1,0)) AS Tlt500,
SUM(if(ecmtime > 500,1,0)) AS Tgt500,
ROUND(AVG(ecmtime)) AS average, MAX(ecmtime) AS maxT,
MAX(logtime)
FROM oscamlog WHERE ecmtype='cache3' AND logtime >= '2018-12-05' GROUP BY caid, provid;

SELECT caid, provid, COUNT(caid) AS total, SUM(if(ecmtype ='invalid' ,1,0) OR if(ecmtype='timeout',1,0)) AS notfound,
SUM(case when(ecmtype = 'cache3') then 1 ELSE 0 END) AS cache,
SUM(case when(ecmtype = 'cache2') OR (ecmtype = 'cache1') OR (ecmtype='found') then 1 ELSE 0 END) AS found, MIN(ecmtime) AS minT, 
SUM(if(ecmtime <= 100 AND ecmtype ='found',1,0)) AS Tlt100,
SUM(if(ecmtime <= 200 AND ecmtime > 100 AND ecmtype ='found',1,0)) AS Tlt200,
SUM(if(ecmtime <= 300 AND ecmtime > 200 AND ecmtype ='found',1,0)) AS Tlt300,
SUM(if(ecmtime <= 400 AND ecmtime > 300 AND ecmtype ='found',1,0)) AS Tlt400,
SUM(if(ecmtime <= 500 AND ecmtime > 400 AND ecmtype ='found',1,0)) AS Tlt500,
SUM(if(ecmtime > 500 AND ecmtype ='found',1,0)) AS Tgt500,
ROUND(AVG(ecmtime)) AS average, MAX(if(ecmtype !='timeout',ecmtime, 0)) AS maxT,
MAX(logtime)
FROM oscamlog WHERE logtime>='2018-12-05' GROUP BY caid, provid;

SET group_concat_max_len = 2048;

SELECT GROUP_CONCAT(DISTINCT concat(caid,':',provid) SEPARATOR '\n\r') AS cards 
FROM oscamlog 
WHERE (ecmtype='found' OR ecmtype='cache3') AND ecmtime <= 300;

[Duster]

New version 1.3

What's new in 1.3
-b Start process in Background.
on config.ini one new option

[osmys]
readfromend=1

readfromend=1 Start parsing log file from end of file with last line.
readfromend=0 Start parsing log file from begin with first line.


https://ufile.io/z1jb8

[costynho]

Salut,
vroiam sa ma joc azi cu osmys. Am urmat pas cu pas un tutorial facut de piccolo09 pe un alt forum:
- am copiat fisierele pe un mutant hd51;
- am dat atribut la bin;
- am modificat config.ini;
- am lansat osmys cu path din putty;
- am verificat daca ruleaza;
Pe un pc cu sistem windows am instalat heidisql dar cand vreau sa ma i la receptor imi da eroarea "Can't connect to MySQL server on 'ippadress' (10061)uery".Mentionez ca reteaua e locala.
In config.ini:
[mysql]
host=ip_hd51
port=3306
database=oscamlog
table=oscamlog
username=root
password=pass

[osmys]
readfromend=1.

Unde gresesc?

[costynho]

Sa înțeleg ca nu a mai folosit nimeni de aici osmys. E foarte util și simplifică mult lucrurile pentru cei care folosesc oscam și au locale. O să mai încerc zilele astea și, dacă reușesc, voi posta aici.

[piccolo08]

Poate ca nu au folosit

1-te conectezi la o baza de date? ( instalat mysql!?)
2-esti sigur ca folosesti porturile corect?


PS:
Intre timp "Duster" a evoluat la stadiul de "HOȚ"si "ESCROC" de la mic gainar ce era.

[costynho]

Am putea vorbi în privat?
Cât despre Duster, am citit pe forumuri. Sunt puțini care știu programare și foarte mulți care se dau știutori.