#!/bin/bash
#<!-- Copyright (C) 2008  Petr Simandl www.simandl.cz                          -->
#<!-- This file is part of CZFGmap.                                            -->
#<!--                                                                          -->
#<!-- CZFGmap is free software: you can redistribute it and/or modify          -->
#<!-- it under the terms of the GNU General Public License as published by     -->
#<!-- the Free Software Foundation, either version 3 of the License, or        -->
#<!-- (at your option) any later version.                                      -->
#<!--                                                                          -->
#<!-- CZFGmap is distributed in the hope that it will be useful,               -->
#<!-- but WITHOUT ANY WARRANTY; without even the implied warranty of           -->
#<!-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            -->
#<!-- GNU General Public License for more details.                             -->
#<!--                                                                          -->
#<!-- You should have received a copy of the GNU General Public License        -->
#<!-- along with CZFGmap.  If not, see <http://www.gnu.org/licenses/>.         -->

datum=`date '+%Y%m%d%H%M%S'`

outputfilen="out_node.sql"
outputfilel="out_line.sql"

#stahnem nody a linky
if [ ! -e listnodes_${datum}.txt ]
then
#    echo "neni tu ";
     wget http://mapa.czfree.net/listnodes.php -O listnodes_${datum}.txt
fi

if [ ! -e listlines_${datum}.txt ]
then
#    echo "neni tu ";
     wget http://mapa.czfree.net/listlines.php -O listlines_${datum}.txt
fi

if [ -e listnodes_${datum}.txt ]
then
#    echo "nodes do utf";
    iconv -f windows-1250 -t utf8 listnodes_${datum}.txt --output  listnodesutf.txt
fi

if [ -e listnodesutf.txt ]
then
#    echo "delam tabulku node";
cat > $outputfilen <<EOF
DROP TABLE node;
CREATE TABLE node (
  id int(10) unsigned NOT NULL auto_increment,
  lat double NOT NULL default '0',
  lon double NOT NULL default '0',
  ownerid int(10) unsigned NOT NULL default '0',
  networkid int(11) NOT NULL default '0',
  type mediumint(8) unsigned NOT NULL default '0',
  status tinyint(3) unsigned NOT NULL default '0',
  admingroup int(11) default NULL,
  ostype int(11) default NULL,
  osversion int(11) default NULL,
  name varchar(100) default NULL,
  address varchar(120) default NULL,
  urlphotos varchar(90) default NULL,
  urlhomepage varchar(60) default NULL,
  urlthread varchar(60) default NULL,
  visibilitydesc blob,
  changed_by int(10) unsigned default NULL,
  changed_on datetime default NULL,
  align int(11) default '0',
  peoplecount smallint(5) unsigned default NULL,
  machinecount smallint(5) unsigned default NULL,
  peoplehide enum('0','1') NOT NULL default '0',
  machinehide enum('0','1') NOT NULL default '0',
  ownername varchar(100) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY name (name),
  KEY lat_2 (lat),
  KEY lat_3 (lat),
  KEY id (id),
  KEY lat (lat),
  KEY lon (lon),
  KEY ownerid (ownerid),
  KEY Type (type)
) TYPE=MyISAM PACK_KEYS=0;
EOF

cat listnodesutf.txt | \
sed 's/^\[//' | \
sed 's/^\([0-9]*\)\]/\1/' | \
sed 's/\\/\\\\/' | \
sed 's/'\''/\\'\''/' | \
awk -F "\t" '{print "INSERT INTO node VALUES ("$1","$2","$3",0,1,1,"$4",1,1,1,'\''"$6"'\'','\'\'','\'\'','\'\'','\'\'','\'\'',440,'\''2008-01-01 01:01:01'\'',0,NULL,NULL,'\'\'','\'\'','\''"$5"'\'');"}' | \
uniq >> $outputfilen

fi

if [ -e listlines_${datum}.txt ]
then
#    echo "delam tabulku line";
cat > $outputfilel <<EOF
DROP TABLE line;
CREATE TABLE line (
  id1 int(10) unsigned NOT NULL default '0',
  id2 int(10) unsigned NOT NULL default '0',
  type mediumint(8) unsigned zerofill NOT NULL default '00000000',
  status tinyint(1) unsigned NOT NULL default '0',
  perm1 tinyint(1) unsigned NOT NULL default '0',
  perm2 tinyint(1) unsigned NOT NULL default '0',
  changed_by int(10) unsigned default NULL,
  changed_on datetime default NULL,
  backbone tinyint(1) unsigned NOT NULL default '0',
  inplanning tinyint(1) unsigned NOT NULL default '0',
  comment varchar(128) NOT NULL default '',
  PRIMARY KEY  (id1,id2),
  KEY id1 (id1),
  KEY id2 (id2),
  KEY last (changed_on),
  KEY backbone (backbone),
  KEY inplanning (inplanning)
) TYPE=MyISAM;
EOF

cat listlines_${datum}.txt | \
sed 's/\[\([0-9]*\)\]/\1/g' | \
awk -F "\t" '{print "INSERT INTO line VALUES ("$1","$2","$3",0,40,40,88,'\''2008-01-01 01:01:01'\'',0"$4",0,'\'\'');"}' | \
uniq >> $outputfilel

fi




<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
   <head>
      <meta http-equiv="content-type" content="text/html;charset=UTF-8">
      <meta http-equiv="generator" content="WebSVN 2.2.1" /> <!-- leave this for stats -->
      <link rel="shortcut icon" type="image/x-icon" href="./templates/BlueGrey/favicon.ico" />
      <link type="text/css" href="./templates/BlueGrey/styles.css" rel="stylesheet" media="screen">
      <!--[if lt IE 7]>
      <script type="text/javascript" src="./templates/BlueGrey/png.js"></script>
      <![endif]-->
      <script type="text/javascript" src="./templates/BlueGrey/collapse.js"></script>
      <title>
         WebSVN
            - czfgmap
            - Blame
               - Rev 9
            - /tools/gendb
      </title>

      <script type="text/javascript">
         function checkCB(chBox)
         {
            count = 0
            first = null
            f = chBox.form
            for (i = 0 ; i < f.elements.length ; i++)
            if (f.elements[i].type == 'checkbox' && f.elements[i].checked)
            {
               if (first == null && f.elements[i] != chBox)
                  first = f.elements[i]
               count += 1
            }
            
            if (count > 2) 
            {
               first.checked = false
               count -= 1
            }
         }
         
      </script>


</head>
<body>
	<table width="100%" border="0">
	  <tr>
		<td width="13%">&nbsp;</td>
		<td width="73%" align="center"><a href="http://www.jablonka.cz/"><img style="border: 0; width: 201px; height: 51px;" src="./templates/BlueGrey/logo.png" alt="jablonka.cz" /></a><a href="http://www.prosek.czf/"><img style="border: 0; width: 528px; height: 51px;" src="./templates/BlueGrey/squares.png" alt="prosek.czf" /></a></td>
		<td width="13%"><div style="float: right"><form action="?path=%2Ftools%2Fgendb&amp;repname=czfgmap&amp;rev=9" method="post" id="langform"><select name="langchoice" onchange="javascript:this.form.submit();"><option value="ca">Catal&agrave;-Valenci&agrave; - Catalan</option><option value="cs">&#268;esky - Cesky</option><option value="da">Dansk - Dansk</option><option value="nl">Dutch - Dutch</option><option value="en" selected="selected">English - English</option><option value="fi">Finnish - Finnish</option><option value="fr">Fran&ccedil;ais - Francais</option><option value="de">Deutsch - German</option><option value="he-IL">&#1506;&#1489;&#1512;&#1497;&#1514; - Hebrew</option><option value="hu">Magyar - Hungarian</option><option value="id">Bahasa Indonesia - Indonesian</option><option value="it">Italiano - Italian</option><option value="ja">&#26085;&#26412;&#35486; - Japanese</option><option value="ko">&#54620;&#44397;&#50612; - Korean</option><option value="no">Norsk - Norwegian</option><option value="pl">Polski - Polish</option><option value="pt">Portugu&ecirc;s - Portuguese</option><option value="pt-BR">Portugu&ecirc;s - Brazilian Portuguese</option><option value="ru">&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081; - Russian</option><option value="zh-CN">&#20013;&#25991; - Simplified Chinese</option><option value="sk">Sloven&#269;ina - Slovak</option><option value="sl">Sloven&#269;ina - Slovenian</option><option value="es">Espa&ntilde;ol - Spanish</option><option value="sv">Svenska - Swedish</option><option value="zh-TW">&#20013;&#25991; - Traditional Chinese</option><option value="tr">T&uuml;rk&ccedil;e - Turkish</option><option value="uz">O&euml;zbekcha - Uzbek</option></select><input type="submit" value="Go" /></form></div></td>
	  </tr>
	</table>
	<hr />
<table cellspacing="0" cellpadding="0" border="0" width="100%">
  <tr>
    <td align="left"><h1>czfgmap</h1></td>
    <td align="right"><b>Subversion Repositories:</b> <form action="form.php?" method="post" id="projectform"><select name="repname" onchange="javascript:this.form.submit();"><option value="banderdyn">banderdyn</option><option value="centos.prosek.czf">centos.prosek.czf</option><option value="crusader">crusader</option><option value="czf4bfu">czf4bfu</option><option value="czf4bfu.prosek.czf">czf4bfu.prosek.czf</option><option value="czfcentos">czfcentos</option><option value="czfgmap" selected="selected">czfgmap</option><option value="discover">discover</option><option value="fedora.prosek.czf">fedora.prosek.czf</option><option value="freenet-router">freenet-router</option><option value="ftth">ftth</option><option value="getonlineclouds">getonlineclouds</option><option value="hotsanic">hotsanic</option><option value="internet.prosek.czf">internet.prosek.czf</option><option value="is">is</option><option value="mapstats">mapstats</option><option value="meteolinger">meteolinger</option><option value="netmap">netmap</option><option value="qos">qos</option><option value="sedlo">sedlo</option><option value="sedlo.prosek.czf">sedlo.prosek.czf</option><option value="switches">switches</option><option value="vbtobb">vbtobb</option><option value="vlubnt">vlubnt</option><option value="weathermap">weathermap</option><option value="weatherstats">weatherstats</option><option value="websvn">websvn</option><option value="wifidashboard">wifidashboard</option><option value="wifimon">wifimon</option><option value="www.prosek.czf">www.prosek.czf</option><option value="xenstats">xenstats</option></select><input type="submit" value="Go" /><input type="hidden" name="selectproj" value="1" /><input type="hidden" name="op" value="form" /></form></td>
  </tr>
</table>

[<a href="listing.php?repname=czfgmap&amp;path=%2F&amp;rev=9">/</a>] [<a href="listing.php?repname=czfgmap&amp;path=%2Ftools%2F&amp;rev=9">tools/</a>] [<b>gendb</b>] - Blame information for rev <b>9</b>
<p>&nbsp;</p>

<table cellpadding="2" cellspacing="0" width="100%" class="blameTbl">
	<thead>
		<tr>
			<th class="HdrClmn"><b>Line No.</b></th>
			<th class="HdrClmn"><b>Rev</b></th>
			<th class="HdrClmn"><b>Author</b></th>
			<th class="HdrClmnEnd"><b>Line</b></th>
		</tr>
	</thead>
	<tbody>
	</tbody>
</table> 


<script type='text/javascript'>
/* <![CDATA[ */
var rev = new Array();
var a = document.getElementsByTagName('a');
for (var i = 0; i < a.length; i++) {
  if (a[i].className == 'blame-revision') {
    var id = a[i].id;
    addEvent(a[i], 'mouseover', function() { mouseover(this) } );
    addEvent(a[i], 'mouseout', function() { mouseout(this) } );
  }
}

function mouseover(a) {
  // Find the revision by using the link
  var m = /rev=(\d+)/.exec(a.href);
  var r = m[1];

  div = document.createElement('div');
  div.className = 'blame-popup';
  div.innerHTML = rev[r];
  a.parentNode.appendChild(div);
}

function mouseout(a) {
  var div = a.parentNode.parentNode.getElementsByTagName('div');
  for (var i = 0; i < div.length; i++) {
    if (div[i].className = 'blame-popup') {
      div[i].parentNode.removeChild(div[i]);
    }
  }
}

function addEvent(obj, type, func) {
  if (obj.addEventListener) {
    obj.addEventListener(type, func, false);
    return true;
  } else if (obj.attachEvent) {
    return obj.attachEvent('on' + type, func);
  } else {
    return false;
  }
}
/* ]]> */
</script>

      <p><center><font size="-1"><i><b>Powered by <a href="http://www.websvn.info/">WebSVN</a> 2.2.1</b></i></font></center>
   </body>
</html>