<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">I don't know why that should be. At
this point I need to write the programmer's lament: "I never
touched that bit of the code".<br>
<br>
My changes are just concerned with searching, not spot storage. <br>
<br>
Are you getting PC61 style spots? Are they mainly first or not?
This last question is because I store the first version of a spot
that comes in. There are still (too many) old DXSpider nodes out
there that do not generate PC61 instead of PC11 (and the less said
about DXSummit the better).<br>
<br>
It would be interesting to compare the output of this:<br>
<br>
<tt> grepdbg 'I [-\w]+ PC[61]1'</tt><br>
<br>
to a SQL query. <br>
<br>
I WISH SYSOPs WOULD UPDATE THEIR SOFTWARE TO THE LATEST VERSION ON
THEIR BRANCH. The mojo branch is a bit experimental, particularly
as I am stuck at home not doing very much. But if you on the
standard 'master' branch, you should update your software at least
every couple of months. It gets you some fixes that the mojo
branch work has found and also updated prefix information. The
fact that there are so many PC11 spots still being generated means
that your <u>node has not been updated since at least 2012</u>!<br>
<br>
Back to the point:<br>
<br>
This is the entire code that stores a spot. @_ contains the
expanded spot data (the spot + all the country, zone and US state
data) in separate fields. <br>
<br>
<tt>sub add</tt><tt><br>
</tt><tt>{</tt><tt><br>
</tt><tt> my $buf = join('^', @_);</tt><tt><br>
</tt><tt> $fp->writeunix($_[2], $buf);</tt><tt><br>
</tt><tt> if ($main::dbh) {</tt><tt><br>
</tt><tt> $main::dbh->begin_work;</tt><tt><br>
</tt><tt> $main::dbh->spot_insert(\@_);</tt><tt><br>
</tt><tt> $main::dbh->commit;</tt><tt><br>
</tt><tt> }</tt><tt><br>
</tt><tt> $totalspots++;</tt><tt><br>
</tt><tt> if ($_[0] <= 30000) {</tt><tt><br>
</tt><tt> $hfspots++;</tt><tt><br>
</tt><tt> } else {</tt><tt><br>
</tt><tt> $vhfspots++;</tt><tt><br>
</tt><tt> }</tt><tt><br>
</tt><tt> if ($_[3] =~ /(?:QSL|VIA)/i) {</tt><tt><br>
</tt><tt> my $q = QSL::get($_[1]) || new QSL $_[1];</tt><tt><br>
</tt><tt> $q->update($_[3], $_[2], $_[4]);</tt><tt><br>
</tt><tt> }</tt><tt><br>
</tt><tt>}<br>
<br>
</tt>Now, I am afraid that I don't run a MySQL database and am not
generally a fan because it has a nasty tendency to take every
spare piece of RAM that it can find - although that behaviour may
now have changed in the 8 years or so since I last looked at this.<br>
<br>
73 Dirk G1TLH<br>
<br>
On 03/06/2020 02:43, JMarcio S via Dxspider-support wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CANSj2WK-sY-nxakwMmkgYfvUFSLbdOcSJGZ-_iqb3Jt6LQzLuA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr"> Hi Dirk
<div> The ipaddr in the Mysql database is null, after Mojo.
Any format changes? current is: VARCHAR 40. (running DXSpider
V1.57 build 252).<br clear="all">
<div> Thank you again</div>
<div><br>
</div>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">J.Marcio PY4OG</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Dxspider-support mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Dxspider-support@tobit.co.uk">Dxspider-support@tobit.co.uk</a>
<a class="moz-txt-link-freetext" href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support">https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a>
</pre>
</blockquote>
<br>
</body>
</html>