Recent changes to 1: add a time fieldhttps://sourceforge.net/p/packet2sql/feature-requests/1/2001-09-26T13:33:52ZRecent changes to 1: add a time fieldadd a time field2001-09-26T13:33:52Z2001-09-26T13:33:52ZSteve Schupphttps://sourceforge.net/u/schuppy/https://sourceforge.netf45875fd378378d20bcc40bc1651ee959fce9f45<div class="markdown_content"><p>I made a change to packet2sql i thought you might be interested in. I added a field, called <br />
packet_time, so i can store the date and time seperately. This means that you can do sql queries <br />
which group by the date; to get a one week summary you could:<br />
select count(*) as count, packet_date, interface, chain, sourcehost,destport<br />
from logged_packets<br />
where interface = &quot;ppp0&quot;<br />
and chain = &quot;input&quot;<br />
and packet_date = &quot;2001-09-26&quot;<br />
group by sourcehost<br />
order by packet_date DESC LIMIT 7;</p>
<p>The diffs are:<br />
# diff packet2sql-2.1.0/src/PacketSieve.cpp PacketSieve.cpp<br />
177,178c177,178<br />
&lt; &lt;&lt; (nday&lt;10?&quot;0&quot;:&quot;&quot;) &lt;&lt; nday &lt;&lt; &quot;',&quot; &lt;&lt; endl<br />
&lt; &lt;&lt; setw(8) &lt;&lt; &quot;'&quot; &lt;&lt; stime &lt;&lt; &quot;',&quot; &lt;&lt; endl<br />
---<br />
&gt; &lt;&lt; (nday&lt;10?&quot;0&quot;:&quot;&quot;) &lt;&lt; nday &lt;&lt; &quot; &quot;<br />
&gt; &lt;&lt; stime &lt;&lt; &quot;',&quot; &lt;&lt; endl<br />
# diff packet2sql-2.1.0/sql/logged_packets-ddl.sql logged_packets-ddl.sql<br />
8,9c8<br />
&lt; packet_date date not null,<br />
&lt; packet_time time not null,<br />
---<br />
&gt; packet_date timestamp,<br />
24c23<br />
&lt; PRIMARY KEY (packet_date, packet_time, id, sourcehost, desthost));<br />
---<br />
&gt; PRIMARY KEY (packet_date, id, sourcehost, desthost));</p>
<p>Im not sure if it was possible to do this with the database in the previous form, but i found it easier <br />
this way - and it made for some interesting queries, so i thought i would share :)</p></div>