Compare data from public website with local database/internal website and create html report
$30-250 USD
着払い
Scripts must be written in Python (no PHP)
For URL - [url removed, login to view]
Follow all links between
<rdf:Seq>
<rdf:li rdf:resource="[url removed, login to view]"/>
<rdf:li rdf:resource="[url removed, login to view]"/>
---cut---
</rdf:Seq>
For each link
Compare "Package" and "Unaffected versions" to local mysql database of package and version information
Sample data from [url removed, login to view]
<table class="ntable">
<tr>
<td class="infohead"><b>Package</b></td>
<td class="infohead"><b>Vulnerable versions</b></td>
<td class="infohead"><b>Unaffected versions</b></td>
<td class="infohead"><b>Architecture(s)</b></td>
</tr>
<tr>
<td class="tableinfo">dev-libs/openssl</td>
<td class="tableinfo">
<
[url removed, login to view],
<
[url removed, login to view]</td>
<td class="tableinfo">
revision >=
[url removed, login to view],
revision >=
[url removed, login to view]</td>
<td class="tableinfo">
All supported architectures
</td>
</tr>
</table>
Database Schema
CREATE TABLE pkglist (
id int(100) unsigned NOT NULL auto_increment,
pkgurl varchar(100) NOT NULL,
pkgver varchar(100) NOT NULL,
pkgdep varchar(100),
PRIMARY KEY (id)
) ENGINE=InnoDB;
Sample Query
select distinct pkgurl, pkgname, pkgver from pkglist where pkgname = 'dev-libs/openssl' and pkgver <="1.1.1";
Sample Output
+-------------------------------------------------------------------+------------------+-----------+
| pkgurl | pkgname | pkgver |
+-------------------------------------------------------------------+------------------+-----------+
| [url removed, login to view] | dev-libs/openssl | 1.0.1e-r1 |
If found, output "rdf:about" (from [url removed, login to view]), pkgurl, pkgname into html document:
Sample Output
<html lang="en">
<head>
<title>Dashboard</title>
</head>
<body>
<table class="table table-hover" border=1>
<thead>
<tr>
<th class="span2">Vuln Package</th>
<th class="span3">Vuln Images</th>
<th class="span1">Vuln Systems</th>
<th class="span4">Description</th>
</tr>
</thead>
<tr>
<td class="tableinfo">dev-libs/openssl</td>
<td class="tableinfo">
<a class="btn btn-mini" href="[url removed, login to view] ">[url removed, login to view] </a><br>
<a class="btn btn-mini" href="[url removed, login to view] ">[url removed, login to view] </a><br>
</td>
<td class="tableinfo">
#to be filled in later
</td>
<td class="tableinfo">
GLSA 201312-03 (Low): openssl<br>
<a href="[url removed, login to view]">[url removed, login to view] </a><br>
OpenSSL: Multiple Vulnerabilities<br>
</td>
</tr>
</table>
</body>
</html>
Compare part of pkgurl string with html table on this URL ([url removed, login to view]) and insert matching into existing html table (#to be filled in later from above).
Example:
Vulnerable image string to use in search == [url removed, login to view]
Sample [url removed, login to view] data
<tr class=""><td>[url removed, login to view]</td><td><a class="btn btn-mini" href="[url removed, login to view]">[url removed, login to view]</a></td>
Sample Output inserted into open html table cell
<td class="tableinfo">
[url removed, login to view]<br>
[url removed, login to view]<br>
</td>
プロジェクトID: #5197874
プロジェクトについて
アワード:
i can deliver it tonight , i have to go out in day , so the same time as you got today your project , you will get it when you wake up.
4人のフリーランサーが、平均$108 で、この仕事に入札しています。
Hi, We are experienced Python developers. This job can be done with scrapy framework. We will be glad to help. Let us talk more. Thanks
Hello. I have 8 years of design and development experience and setting this up for you will not be a problem. I am also from the US, so I am fluent in English. Send me a message so we can discuss your project in more d もっと