<div dir="auto">Super gut! Danke für die Map!<div dir="auto">Genau so mach mers! :)</div></div><div class="gmail_extra"><br><div class="gmail_quote">Am 12.07.2017 13:38 schrieb "Adrian Schmutzler" <<a href="mailto:mail@adrianschmutzler.de">mail@adrianschmutzler.de</a>>:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="DE" link="blue" vlink="purple"><div class="m_7381858480118165467WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Hallo,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">da das php-script bis auf die Datenbank-Anbindung portabel ist, hab ich die neuen Positionen schnell hardgecoded:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="http://www.adrianschmutzler.net/hoodteilung.php" target="_blank">http://www.adrianschmutzler.<wbr>net/hoodteilung.php</a><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Das Script ist auch im Anhang, kann also jeder mit php selber rumbasteln. (Es ist tatsächlich nur diese eine Datei notwendig).<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Die in Christians Mail nicht genannten Hoods habe ich anhand des Monitorings gesetzt:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="https://github.com/asdil12/fff-monitoring/blob/576c8dd0c0ff0802a15cc795db3a4cb187ad49c0/ffmap/db/hoods.py" target="_blank">https://github.com/asdil12/<wbr>fff-monitoring/blob/<wbr>576c8dd0c0ff0802a15cc795db3a4c<wbr>b187ad49c0/ffmap/db/hoods.py</a><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Grüße<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Adrian<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> franken-dev [mailto:<a href="mailto:franken-dev-bounces@freifunk.net" target="_blank">franken-dev-bounces@<wbr>freifunk.net</a>] <b>On Behalf Of </b>Mister Crumble<br><b>Sent:</b> Montag, 10. Juli 2017 15:44<br><b>To:</b> franken-dev <<a href="mailto:franken-dev@freifunk.net" target="_blank">franken-dev@freifunk.net</a>><br><b>Subject:</b> Simulation Hoodtrennung extremo.<u></u><u></u></span></p><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Hallo, nachdem die alte Voronoimap, die Christian und ich als Hoodsimulation benutzt haben nicht mehr gibt hatte ich folgenden Idee.<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Unter <u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><a href="http://keyserver.freifunk-franken.de/fff/voronoimap.php" target="_blank">http://keyserver.freifunk-<wbr>franken.de/fff/voronoimap.php</a><u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">gibt es bereits eine Map die die Daten aus einer Mysql tabelle lädt.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">wäre es nicht einfach möglich die Hood Tabelle zu Kopieren in Hoods2 und die voronoimap in voro2.php umzubenenn und dort dann einfach nur<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><span class="m_7381858480118165467gmail-pl-s1"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e">       </span></span><span class="m_7381858480118165467gmail-pl-smi"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e">$rs</span></span><span class="m_7381858480118165467gmail-pl-s1"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e"> </span></span><span class="m_7381858480118165467gmail-pl-k"><span style="font-size:9.0pt;font-family:Consolas;color:#d73a49">=</span></span><span class="m_7381858480118165467gmail-pl-s1"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e"> </span></span><span class="m_7381858480118165467gmail-pl-smi"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e">$db</span></span><span class="m_7381858480118165467gmail-pl-k"><span style="font-size:9.0pt;font-family:Consolas;color:#d73a49">-></span></span><span class="m_7381858480118165467gmail-pl-s1"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e">prepare ( </span></span><span class="m_7381858480118165467gmail-pl-pds"><span style="font-size:9.0pt;font-family:Consolas;color:#032f62">"</span></span><span class="m_7381858480118165467gmail-pl-k"><span style="font-size:9.0pt;font-family:Consolas;color:#d73a49">SELECT</span></span><span class="m_7381858480118165467gmail-pl-s1"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e"> </span></span><span class="m_7381858480118165467gmail-pl-k"><span style="font-size:9.0pt;font-family:Consolas;color:#d73a49">*</span></span><span class="m_7381858480118165467gmail-pl-s1"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e"> </span></span><span class="m_7381858480118165467gmail-pl-k"><span style="font-size:9.0pt;font-family:Consolas;color:#d73a49">FROM</span></span><span class="m_7381858480118165467gmail-pl-s1"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e"> </span></span><span class="m_7381858480118165467gmail-pl-s"><span style="font-size:9.0pt;font-family:Consolas;color:#032f62">`hoods2`</span></span><span class="m_7381858480118165467gmail-pl-pds"><span style="font-size:9.0pt;font-family:Consolas;color:#032f62">"</span></span><span class="m_7381858480118165467gmail-pl-s1"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e"> );</span></span><u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">abzufragen?<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Quellcode:<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">"<a href="https://github.com/FreifunkFranken/VPNkeyXchange/blob/master/voronoimap.php" target="_blank">https://github.com/<wbr>FreifunkFranken/VPNkeyXchange/<wbr>blob/master/voronoimap.php</a><u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Oder steckt da noch mehr hinter dieser Map?<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">MFG Christoph Süpke<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">P.S: ich bin gerne bereit in Hoods2 die neuen Hoods einzupflegen wie Christian sie vorgeschlagen hat<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div><br>--<br>
franken-dev mailing list<br>
<a href="mailto:franken-dev@freifunk.net">franken-dev@freifunk.net</a><br>
<a href="http://lists.freifunk.net/mailman/listinfo/franken-dev-freifunk.net" rel="noreferrer" target="_blank">http://lists.freifunk.net/<wbr>mailman/listinfo/franken-dev-<wbr>freifunk.net</a><br>
<br></blockquote></div></div>