Code: 12alarmy - Historia wersji

https://wikii.int.com.pl/index.php?action=history&feed=atom&title=Code%3A_12alarmy Code: 12alarmy - Historia wersji 2026-06-09T21:35:29Z Historia wersji tej strony wiki MediaWiki 1.23.13 https://wikii.int.com.pl/index.php?title=Code:_12alarmy&diff=11357&oldid=prev ArekG: Ukryłem adresy mailowe ;) 2014-01-16T17:56:23Z

<p>Ukryłem adresy mailowe ;)</p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← poprzednia wersja</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Wersja z 17:56, 16 sty 2014</td> </tr><tr><td colspan="2" class="diff-lineno">Linia 170:</td> <td colspan="2" class="diff-lineno">Linia 170:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'',</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'',</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#to</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#to</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'select "<<del class="diffchange diffchange-inline">zosia</del>@<del class="diffchange diffchange-inline">wega</del>.<del class="diffchange diffchange-inline">gda</del>.pl>"',</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'select "<<ins class="diffchange diffchange-inline">xxx</ins>@<ins class="diffchange diffchange-inline">yyy</ins>.<ins class="diffchange diffchange-inline">zzz</ins>.pl>"',</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#cc</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#cc</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'select "<<del class="diffchange diffchange-inline">s_dusza</del>@<del class="diffchange diffchange-inline">int</del>.<del class="diffchange diffchange-inline">com</del>.pl>"',</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'select "<<ins class="diffchange diffchange-inline">aaa</ins>@<ins class="diffchange diffchange-inline">bbb</ins>.<ins class="diffchange diffchange-inline">ccc</ins>.pl>"',</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#'',</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#'',</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#from</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#from</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'select "Powiadomienia Motlawa <no-reply@<del class="diffchange diffchange-inline">wega</del>.<del class="diffchange diffchange-inline">gda</del>.pl>"',</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'select "Powiadomienia Motlawa <no-reply@<ins class="diffchange diffchange-inline">yyy</ins>.<ins class="diffchange diffchange-inline">zzz</ins>.pl>"',</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'select "Log ulg PFRON"',</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'select "Log ulg PFRON"',</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'select \'${html_head}<H3>Operacje PFRON z niezaznaczoną opcją "wydrukowana i wysłana"</H3>\'',</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'select \'${html_head}<H3>Operacje PFRON z niezaznaczoną opcją "wydrukowana i wysłana"</H3>\'',</div></td></tr> </table>

ArekG https://wikii.int.com.pl/index.php?title=Code:_12alarmy&diff=10361&oldid=prev Sebasoul o 07:09, 2 paź 2012 2012-10-02T07:09:34Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← poprzednia wersja</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Wersja z 07:09, 2 paź 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Linia 1:</td> <td colspan="2" class="diff-lineno">Linia 1:</td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''12alarmy''' używa tabeli _db_alert do przygotowania maila.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''12alarmy''' używa tabeli <ins class="diffchange diffchange-inline">'''</ins>_db_alert<ins class="diffchange diffchange-inline">''' </ins>do przygotowania maila <ins class="diffchange diffchange-inline">przy wykorzystaniu bazy MySQL oraz basha w systemie Linux</ins>.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> </table>

Sebasoul https://wikii.int.com.pl/index.php?title=Code:_12alarmy&diff=10360&oldid=prev Sebasoul: /* struktura tabeli */ 2012-10-02T07:08:46Z

<p>‎<span dir="auto"><span class="autocomment">struktura tabeli</span></span></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← poprzednia wersja</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Wersja z 07:08, 2 paź 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Linia 4:</td> <td colspan="2" class="diff-lineno">Linia 4:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== struktura tabeli ==</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== struktura tabeli ==</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><table border=1></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><table border=1 <ins class="diffchange diffchange-inline">cellpadding=2 cellspacing=0</ins>></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><tr></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><tr></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><td bgcolor=silver class='medium'>Field</td><td bgcolor=silver class='medium'>Type</td><td bgcolor=silver class='medium'>Null</td><td bgcolor=silver class='medium'>Key</td><td bgcolor=silver class='medium'>Default</td><td bgcolor=silver class='medium'>Extra</td></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><td bgcolor=silver class='medium'>Field</td><td bgcolor=silver class='medium'>Type</td><td bgcolor=silver class='medium'>Null</td><td bgcolor=silver class='medium'>Key</td><td bgcolor=silver class='medium'>Default</td><td bgcolor=silver class='medium'>Extra</td></tr></div></td></tr> </table>

Sebasoul https://wikii.int.com.pl/index.php?title=Code:_12alarmy&diff=10359&oldid=prev Sebasoul: /* Przykładowy kod przygotowujący (skrypt SH) */ 2012-10-02T07:08:05Z

<p>‎<span dir="auto"><span class="autocomment">Przykładowy kod przygotowujący (skrypt SH)</span></span></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← poprzednia wersja</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Wersja z 07:08, 2 paź 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Linia 170:</td> <td colspan="2" class="diff-lineno">Linia 170:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'',</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'',</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#to</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#to</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">#'select concat(c.valuex," <",c.kontofk,">") from katcols c where c.typ=0 and c.colnr=5 and c.klucz=#PARAM1#',</del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'select "<zosia@wega.gda.pl>"',</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'select "<zosia@wega.gda.pl>"',</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#cc</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>#cc</div></td></tr> </table>

Sebasoul https://wikii.int.com.pl/index.php?title=Code:_12alarmy&diff=10358&oldid=prev Sebasoul o 07:07, 2 paź 2012 2012-10-02T07:07:20Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← poprzednia wersja</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Wersja z 07:07, 2 paź 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Linia 152:</td> <td colspan="2" class="diff-lineno">Linia 152:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div></tr></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div></table></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div></table></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">== Przykładowy kod przygotowujący (skrypt SH) ==</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"><pre></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#!/bin/sh</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">html_head='<HTML><HEAD> <META HTTP-EQUIV=\"Content-Type\" CONTENT=\"text/html; charset=Windows-1250\"> </HEAD><BODY>'</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">html_foot='</BODY></HTML>'</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">mysql wegasa -vvv <<EOF</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">set names utf8;</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">delete from _db_alert where guid like 'PFRON';</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">insert into _db_alert values (</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'PFRON',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">0,'daily','1',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#to</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#'select concat(c.valuex," <",c.kontofk,">") from katcols c where c.typ=0 and c.colnr=5 and c.klucz=#PARAM1#',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'select "<zosia@wega.gda.pl>"',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#cc</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'select "<s_dusza@int.com.pl>"',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#'',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#from</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'select "Powiadomienia Motlawa <no-reply@wega.gda.pl>"',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'select "Log ulg PFRON"',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'select \'${html_head}<H3>Operacje PFRON z niezaznaczoną opcją "wydrukowana i wysłana"</H3>\'',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#body</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'SELECT o.nrdokfin,up.kwota, up.ulga, o.datawystaw, o.dataplatnosci, K.nazwa \</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> FROM ulga_pfron up LEFT JOIN kontrah K ON K.GUID = up.kontrGUID LEFT JOIN opng o ON o.GUID = up.operGUID  WHERE o.nrdokfin<>"" and up.PrintSend = 0 \</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> ORDER BY datawystaw, dataplatnosci ',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#footer</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'select \'<BR><BR><B><I>Wasz Automatyczny Serwis Powiadomień</B>${html_foot}</I>\'',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"># attachment:</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"># param1:</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'',</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">''</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">);</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">EOF</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></pre></ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Kategoria: Programowanie]]</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Kategoria: Programowanie]]</div></td></tr> </table>

Sebasoul https://wikii.int.com.pl/index.php?title=Code:_12alarmy&diff=10357&oldid=prev Sebasoul: Utworzył nową stronę „'''12alarmy''' używa tabeli _db_alert do przygotowania maila. == struktura tabeli == <table border=1> <tr> <td bgcolor=silver class='medium'>Field</td><td bgcolor=s…” 2012-10-02T07:04:23Z

<p>Utworzył nową stronę „'''12alarmy''' używa tabeli _db_alert do przygotowania maila. == struktura tabeli == <table border=1> <tr> <td bgcolor=silver class='medium'>Field</td><td bgcolor=s…”</p> <p><b>Nowa strona</b></p><div>'''12alarmy''' używa tabeli _db_alert do przygotowania maila.<br /> <br /> <br /> == struktura tabeli ==<br /> <br /> <table border=1><br /> <tr><br /> <td bgcolor=silver class='medium'>Field</td><td bgcolor=silver class='medium'>Type</td><td bgcolor=silver class='medium'>Null</td><td bgcolor=silver class='medium'>Key</td><td bgcolor=silver class='medium'>Default</td><td bgcolor=silver class='medium'>Extra</td></tr><br /> <tr><br /> <td class='normal' valign='top'>guid</td><br /> <td class='normal' valign='top'>varchar(38)</td><br /> <td class='normal' valign='top'>NO</td><br /> <td class='normal' valign='top'>PRI</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>medium</td><br /> <td class='normal' valign='top'>int(11)</td><br /> <td class='normal' valign='top'>NO</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>0</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>cron</td><br /> <td class='normal' valign='top'>varchar(50)</td><br /> <td class='normal' valign='top'>NO</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>daily</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>sort</td><br /> <td class='normal' valign='top'>varchar(20)</td><br /> <td class='normal' valign='top'>NO</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>init_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>finish_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>mailto_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>mailcc_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>mailfrom_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>subject_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>header_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>body_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>footer_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>attachments_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>param1_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>param2_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>action_success_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> <tr><br /> <td class='normal' valign='top'>action_fail_sql</td><br /> <td class='normal' valign='top'>text</td><br /> <td class='normal' valign='top'>YES</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> <td class='normal' valign='top'>(NULL)</td><br /> <td class='normal' valign='top'>&nbsp;</td><br /> </tr><br /> </table><br /> <br /> <br /> <br /> [[Kategoria: Programowanie]]</div>

Sebasoul