Index: ava/sql-vyuka/licence.txt =================================================================== --- java/sql-vyuka/licence.txt (revision 23:6bbbd371e813) +++ (revision ) @@ -1,1 +1,0 @@ -../../licence/agpl-3.0.txt Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/Html.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/Html.java (revision 12:1b10a6565e8c) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/Html.java (revision 12:1b10a6565e8c) @@ -0,0 +1,14 @@ +package cz.frantovo.sql.vyuka; + +/** + * + * @author fiki + */ +public class Html { + + /** Escapuje HTML značky v textu. */ + public static String escapuj(String text) { + /** TODO: dopsat! */ + return text; + } +} Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/ajax/Ajax.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/ajax/Ajax.java (revision 16:9acb74ac7346) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/ajax/Ajax.java (revision 16:9acb74ac7346) @@ -0,0 +1,32 @@ +package cz.frantovo.sql.vyuka.ajax; + +import cz.frantovo.sql.vyuka.dao.HistorieDAO; +import cz.frantovo.sql.vyuka.dao.PiskovisteDAO; +import cz.frantovo.sql.vyuka.dto.Uzivatel; +import cz.frantovo.sql.vyuka.dto.VysledekSQL; + +/** + * Pomocník servletu. Vrací HTML části stránek. + * @author fiki + */ +public class Ajax { + + /** + * @return Historie SQL příkazů daného uživatele. + */ + public String getHistorie(Uzivatel uzivatel) { + HistorieDAO h = new HistorieDAO(); + VysledekSQL v = h.nactiHistorii(uzivatel); + return v.getHtml(); + } + + /** + * Vykoná zadaný SQL příkaz v databázi. + * @return Výsledek dotazu – tabulka, hláška nebo chyba. + */ + public String geSQLVysledek(String sql, Uzivatel uzivatel) { + PiskovisteDAO p = new PiskovisteDAO(); + VysledekSQL v = p.vykonejSQL(sql, uzivatel); + return v.getHtml(); + } +} Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/ajax/Servlet.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/ajax/Servlet.java (revision 14:d08769933940) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/ajax/Servlet.java (revision 14:d08769933940) @@ -0,0 +1,128 @@ +package cz.frantovo.sql.vyuka.ajax; + +import cz.frantovo.sql.vyuka.dto.Uzivatel; +import java.io.IOException; +import java.io.PrintWriter; +import javax.servlet.ServletException; +import javax.servlet.http.HttpServlet; +import javax.servlet.http.HttpServletRequest; +import javax.servlet.http.HttpServletResponse; + +/** + * Servlet pro vyřizování AJAXových požadavků. + * @author fiki + */ +public class Servlet extends HttpServlet { + + private static final long serialVersionUID = 9102108273105288056L; + + private enum akce { + + /** Provede SQL dotaz. */ + vykonat, + /** Vypíše historii SQL příkazů daného uživatele. */ + historie, + /** Nápověda – průvodce */ + napoveda, + /** Vypíše nějaké nepotřebné informace. */ + test, + /** Pokud je požadovaná akce nesmysl. */ + chyba + } + + /** + * Processes requests for both HTTP GET and POST methods. + * @param request servlet request + * @param response servlet response + * @throws ServletException if a servlet-specific error occurs + * @throws IOException if an I/O error occurs + */ + protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { + + /** Používáme pouze UTF-8 */ + response.setContentType("text/html;charset=UTF-8"); + request.setCharacterEncoding("UTF-8"); + + PrintWriter out = response.getWriter(); + + try { + + akce parametrAkce = akce.chyba; + try { + parametrAkce = akce.valueOf(request.getParameter("akce")); + } catch (Exception e) { + /** Chyba nebo podvržený AJAXový požadavek → zobrazíme chybovou hlášku */ + } + + + Ajax a = new Ajax(); + + Uzivatel uzivatel = new Uzivatel(request.getRequestedSessionId(), request.getRemoteHost()); + + switch (parametrAkce) { + case vykonat: + out.println(a.geSQLVysledek(request.getParameter("sql"), uzivatel)); + break; + case historie: + out.println(a.getHistorie(uzivatel)); + break; + case napoveda: + out.println("

Nápověda bude…

"); + break; + case test: + out.println("

AJAX jede!

"); + out.println("
    "); + out.println("
  1. Metoda: " + request.getMethod() + "
    2. "); + out.println("
  2. Host: " + request.getRemoteHost() + "
    3. "); + out.println("
  3. Adresa: " + request.getRemoteAddr() + "
    4. "); + out.println("
  4. Akce: " + request.getParameter("akce") + "
    5. "); + out.println("
  5. SQL: " + request.getParameter("sql") + "
    6. "); + out.println("
  6. Sezení: " + request.getRequestedSessionId() + "
    7. "); + out.println("
  7. URL: " + request.getRequestURL().toString() + "
    8. "); + out.println("
"); + break; + case chyba: + out.println("

chyba

"); + break; + } + } finally { + out.close(); + } + } + + // + /** + * Handles the HTTP GET method. + * @param request servlet request + * @param response servlet response + * @throws ServletException if a servlet-specific error occurs + * @throws IOException if an I/O error occurs + */ + @Override + protected void doGet(HttpServletRequest request, HttpServletResponse response) + throws ServletException, IOException { + processRequest(request, response); + } + + /** + * Handles the HTTP POST method. + * @param request servlet request + * @param response servlet response + * @throws ServletException if a servlet-specific error occurs + * @throws IOException if an I/O error occurs + */ + @Override + protected void doPost(HttpServletRequest request, HttpServletResponse response) + throws ServletException, IOException { + processRequest(request, response); + } + + /** + * Returns a short description of the servlet. + * @return a String containing servlet description + */ + @Override + public String getServletInfo() { + return "Servlet pro zpracování AJAXových požadavků."; + }// +} Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/HistorieDAO.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/HistorieDAO.java (revision 26:5844d64930de) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/HistorieDAO.java (revision 16:9acb74ac7346) @@ -59,8 +59,7 @@ Tabulka t = new Tabulka(); - String[] zahlavi = {"historie.kdy", "historie.prikaz"}; + String[] zahlavi = {"Kdy", "SQL příkaz"}; t.setZahlavi(zahlavi); - t.setZahlaviTip("historie.zahlaviTip"); - t.setLokalizovat(true); + Connection db = getSpojeni(DATABAZE.APLIKACE); Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/PiskovisteDAO.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/PiskovisteDAO.java (revision 30:d65581701671) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/PiskovisteDAO.java (revision 19:2ffdd7be6d5e) @@ -46,5 +46,4 @@ } - long casPred = System.currentTimeMillis(); ps = db.prepareStatement(sql); boolean isRS = ps.execute(); @@ -60,5 +59,4 @@ v.getTabulky().add(zpracujVysledek(rs)); } - long dobaProvadeni = System.currentTimeMillis() - casPred; /** Varování */ @@ -76,5 +74,4 @@ } - v.getHlasky().add(new Hlaska("SQL příkaz byl proveden úspěšně, během " + dobaProvadeni + " ms.", Typ.OK)); } catch (SQLException e) { Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/TipyDAO.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/TipyDAO.java (revision 29:4b6ab4ba1a95) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/TipyDAO.java (revision 16:9acb74ac7346) @@ -1,43 +1,13 @@ package cz.frantovo.sql.vyuka.dao; -import java.sql.Connection; -import java.sql.PreparedStatement; -import java.sql.ResultSet; -import java.util.logging.Level; - /** - * Rady, tipy, odkazy, citáty… pro zobrazování uživatelům. + * * @author fiki */ public class TipyDAO extends VyukaSuperDAO { - private enum SQL { - - NAHODNY_TIP - } - - /** - * @return Náhodný tip načtený z databáze - */ public String getTip() { - Connection db = getSpojeni(DATABAZE.APLIKACE); - if (db == null) { - log.log(Level.SEVERE, "Databáze je null."); - return null; - } else { - PreparedStatement ps = null; - ResultSet rs = null; - try { - ps = db.prepareStatement(getSQL(SQL.NAHODNY_TIP)); - rs = ps.executeQuery(); - rs.next(); - return rs.getString("text"); - } catch (Exception e) { - log.log(Level.SEVERE, "Chyba při hledání náhodného tipu.", e); - return null; - } finally { - zavri(db, ps, rs); - } - } + /** TODO: Tipy brát z databáze. */ + return "Stejně vám něco doporučíme."; } } Index: ava/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/TipyDAO.sql.xml =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/TipyDAO.sql.xml (revision 29:4b6ab4ba1a95) +++ (revision ) @@ -1,12 +1,0 @@ - - - - - - - Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/Hlaska.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/Hlaska.java (revision 25:97bb16063d9e) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/Hlaska.java (revision 12:1b10a6565e8c) @@ -1,3 +1,5 @@ package cz.frantovo.sql.vyuka.dto; + +import cz.frantovo.sql.vyuka.Html; /** @@ -5,16 +7,9 @@ * @author fiki */ -public class Hlaska { +public class Hlaska implements HtmlObjekt { - public enum Typ { - - OK, - Tip, - Varovani, - Chyba - } private String text; private Typ typ; - private boolean escapovat = true; + private boolean escapovat; /** @@ -39,4 +34,14 @@ this.typ = typ; this.escapovat = true; + } + + public String getHtml() { + String hodnota; + if (isEscapovat()) { + hodnota = Html.escapuj(text); + } else { + hodnota = text; + } + return "

" + hodnota + "

"; } @@ -64,3 +69,11 @@ this.escapovat = escapovat; } + + public enum Typ { + + OK, + Tip, + Varovani, + Chyba + } } Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/HtmlObjekt.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/HtmlObjekt.java (revision 12:1b10a6565e8c) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/HtmlObjekt.java (revision 12:1b10a6565e8c) @@ -0,0 +1,10 @@ +package cz.frantovo.sql.vyuka.dto; + +/** + * HTML objekt. + * @author fiki + */ +public interface HtmlObjekt { + + public String getHtml(); +} Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/Tabulka.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/Tabulka.java (revision 26:5844d64930de) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/Tabulka.java (revision 16:9acb74ac7346) @@ -1,4 +1,5 @@ package cz.frantovo.sql.vyuka.dto; +import cz.frantovo.sql.vyuka.Html; import java.util.ArrayList; import java.util.Collection; @@ -8,11 +9,54 @@ * @author fiki */ -public class Tabulka { +public class Tabulka implements HtmlObjekt { private String[] zahlavi; - private String zahlaviTip; private Collection hodnoty = new ArrayList(); - /** Zda se má lokalizovat záhlaví tabulky a její tip. */ - private boolean lokalizovat = false; + + public String getHtml() { + + if (getZahlavi() == null || getHodnoty() == null || getZahlavi().length < 1) { + return "

Chybná tabulka

"; + } else { + + StringBuffer html = new StringBuffer(); + + html.append(""); + + + html.append(""); + html.append(""); + for (String z : getZahlavi()) { + html.append(""); + } + html.append(""); + html.append(""); + + + html.append(""); + for (Object[] hh : getHodnoty()) { + html.append(""); + for (Object h : hh) { + html.append(formatujBunku(h)); + } + html.append(""); + } + html.append(""); + + html.append("
" + Html.escapuj(z) + "
"); + + + return html.toString(); + } + } + + private String formatujBunku(Object o) { + /** TODO: podporovat i jiné typy */ + if (o instanceof Integer) { + return "" + Html.escapuj(String.valueOf(o)) + ""; + } else { + return "" + Html.escapuj(String.valueOf(o)) + ""; + } + } public String[] getZahlavi() { @@ -24,30 +68,6 @@ } - public String getZahlaviTip() { - return zahlaviTip; - } - - public void setZahlaviTip(String zahlaviTip) { - this.zahlaviTip = zahlaviTip; - } - public Collection getHodnoty() { return hodnoty; } - - /** - * Zda se má lokalizovat záhlaví tabulky a její tip. - * @return the lokalizovat - */ - public boolean isLokalizovat() { - return lokalizovat; - } - - /** - * Zda se má lokalizovat záhlaví tabulky a její tip. - * @param lokalizovat the lokalizovat to set - */ - public void setLokalizovat(boolean lokalizovat) { - this.lokalizovat = lokalizovat; - } } Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/Uzivatel.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/Uzivatel.java (revision 24:dceaaefb1946) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/Uzivatel.java (revision 13:96e711f3ef48) @@ -13,7 +13,4 @@ this.idSezeni = idSezeni; this.ipAdresa = ipAdresa; - } - - public Uzivatel() { } Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/VysledekSQL.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/VysledekSQL.java (revision 25:97bb16063d9e) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dto/VysledekSQL.java (revision 12:1b10a6565e8c) @@ -5,9 +5,8 @@ /** - * Výsledek SQL dotazu. - * Obsahuje tabulky a hlášky. + * Výsledek SQL dotazu * @author fiki */ -public class VysledekSQL { +public class VysledekSQL implements HtmlObjekt { private Collection tabulky = new ArrayList(); @@ -21,3 +20,17 @@ return hlasky; } + + public String getHtml() { + StringBuffer html = new StringBuffer(); + + for (Tabulka t : tabulky) { + html.append(t.getHtml()); + } + + for (Hlaska h : hlasky) { + html.append(h.getHtml()); + } + + return html.toString(); + } } Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/preklady_cs.properties =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/preklady_cs.properties (revision 24:dceaaefb1946) +++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/preklady_cs.properties (revision 18:e7a5763c789c) @@ -14,15 +14,2 @@ vychozi.vysledek=V\u00EDtejte v programu SQL v\u00FDuka! vychozi.napoveda=Tady bude n\u00E1pov\u011Bda - -js.nepodporovany=V\u00E1\u0161 prohl\u00ED\u017Ee\u010D nepodporuje AJAX. Po\u0159i\u010Fte si m\u00E9n\u011B zastaral\u00FD prohl\u00ED\u017Ee\u010D, nejl\u00E9pe Firefox. -js.probihaSQL=Prob\u00EDh\u00E1 zpracov\u00E1n\u00ED SQL p\u0159\u00EDkazu\u2026 -js.probihaHistorie=Na\u010D\u00EDt\u00E1 se historie\u2026 - -licence.program=Program je vyd\u00E1n pod licenc\u00ED: -licence.agpl=GNU Affero GPL -licence.zdrojaky=Zdrojov\u00E9 k\u00F3dy ke sta\u017Een\u00ED: - -vysledek.razeniTip=Chce\u0161 set\u0159\u00EDdit v\u00FDsledek podle n\u011Bjak\u00E9ho sloupce? Co takhle ORDER BY sloupec. -historie.kdy=Kdy -historie.prikaz=SQL p\u0159\u00EDkaz -historie.zahlaviTip=Posledn\u00ED proveden\u00E9 SQL p\u0159\u00EDkazy. Index: ava/sql-vyuka/src/java/cz/frantovo/sql/vyuka/web/Ajax.java =================================================================== --- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/web/Ajax.java (revision 25:97bb16063d9e) +++ (revision ) @@ -1,52 +1,0 @@ -package cz.frantovo.sql.vyuka.web; - -import cz.frantovo.sql.vyuka.dao.HistorieDAO; -import cz.frantovo.sql.vyuka.dao.PiskovisteDAO; -import cz.frantovo.sql.vyuka.dto.Uzivatel; -import cz.frantovo.sql.vyuka.dto.VysledekSQL; - -/** - * Webová beana, která poskytuje data Ajaxovému JSPčku. - * @author fiki - */ -public class Ajax { - - private final Uzivatel uzivatel = new Uzivatel(); - private String sqlPrikaz; - - /** - * Nastaví informace o klientovi (uživateli). - * @param ipAdresa IP adresa, ze které přišel HTTP požadavek - * @param ipPresmerovano HTTP hlavička x-forwarded-for (přidává proxy). - * @param idSezeni javovská HTTP relace - */ - public void setKlient(String ipAdresa, String ipPresmerovano, String idSezeni) { - if ("127.0.0.1".equals(ipAdresa) && ipPresmerovano != null) { - uzivatel.setIpAdresa(ipPresmerovano); - } else { - uzivatel.setIpAdresa(ipAdresa); - } - uzivatel.setIdSezeni(idSezeni); - } - - public void setSqlPrikaz(String sqlPrikaz) { - this.sqlPrikaz = sqlPrikaz; - } - - /** - * @return Historie SQL příkazů daného uživatele. - */ - public VysledekSQL getHistorie() { - HistorieDAO h = new HistorieDAO(); - return h.nactiHistorii(uzivatel); - } - - /** - * Vykoná zadaný SQL příkaz v databázi. - * @return Výsledek dotazu – tabulka, hláška nebo chyba. - */ - public VysledekSQL getSQLVysledek() { - PiskovisteDAO p = new PiskovisteDAO(); - return p.vykonejSQL(sqlPrikaz, uzivatel); - } -} Index: java/sql-vyuka/web/WEB-INF/casti/aplikace.jspx =================================================================== --- java/sql-vyuka/web/WEB-INF/casti/aplikace.jspx (revision 23:6bbbd371e813) +++ java/sql-vyuka/web/WEB-INF/casti/aplikace.jspx (revision 20:47de9e8ce93e) @@ -6,17 +6,17 @@ -

-

-
- +
+

+ +
- +

@@ -28,5 +28,5 @@ rows="100" cols="1000" - onkeypress="javascript:zpracujTabulatory(event);"> + onkeypress="javascript:checkTab(event);">
- + + + + +

- +

+ +

+
- - -
- - - -
Index: ava/sql-vyuka/web/WEB-INF/casti/napoveda.jspx =================================================================== --- java/sql-vyuka/web/WEB-INF/casti/napoveda.jspx (revision 23:6bbbd371e813) +++ (revision ) @@ -1,16 +1,0 @@ - -

- -

-

- - . -

-

- - sql-vyuka-src.zip - . -

- Index: ava/sql-vyuka/web/WEB-INF/casti/vitejte.jspx =================================================================== --- java/sql-vyuka/web/WEB-INF/casti/vitejte.jspx (revision 23:6bbbd371e813) +++ (revision ) @@ -1,7 +1,0 @@ - -

- -

- Index: ava/sql-vyuka/web/ajax.jspx =================================================================== --- java/sql-vyuka/web/ajax.jspx (revision 29:4b6ab4ba1a95) +++ (revision ) @@ -1,112 +1,0 @@ - - - - - - - - request.setCharacterEncoding("UTF-8"); - ajax.setKlient(request.getRemoteAddr(), request.getHeader("x-forwarded-for"), request.getRequestedSessionId()); - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - -
- - - - - - - - -
- - - - - -

- -

- - - - - - - - -

TODO: nápověda.

- - - - Index: java/sql-vyuka/web/hlavni.js =================================================================== --- java/sql-vyuka/web/hlavni.js (revision 24:dceaaefb1946) +++ java/sql-vyuka/web/hlavni.js (revision 20:47de9e8ce93e) @@ -16,13 +16,11 @@ return new ActiveXObject("Microsoft.XMLHTTP"); } else { - alert(document.lokalizace.nepodporovany.value); + alert("Váš prohlížeč nepodporuje AJAX. Pořiďte si méně zastaralý prohlížeč, nejlépe Firefox."); return null; } } - /** Náš AJAXový objekt. */ var ajax = getXmlHttpRequestObject(); - /** @@ -34,9 +32,8 @@ } - /** * Zobrazí text na požadovaném místě. - * @param text text k zobrazení. V případě formulářů prostý text, v ostatních případech HTML text. - * @param kde id prvku, do kterého se má text vypsat. + * @param text text k zobrazení + * @param kde id prvku, do kterého se má text vypsat **/ function zobraz(text, kde) { @@ -50,14 +47,47 @@ } +/** + * Zobrazí text ve výstupním poli. + * @param text HTML text k zobrazení + **/ +function zobrazVystup(text) { + zobraz(text, vystupniPole); +} + +/** + * Zobrazí text ve vstupním poli. + * Požijeme pro načtení SQL příkazu z historie. + * @param text prostý text k zobrazení + **/ +function zobrazVstup(text) { + zobraz(text, vstupniPole); +} + +/** + * Zobrazí text ve vstupním poli. + * Požijeme pro načtení SQL příkazu z historie. + * @param text prostý text k zobrazení + **/ +function zobrazStav(text) { + zobraz(text, stavovePole); +} + +/** + * Zobrazí text ve poli pro nápovědu. + * @param text text k zobrazení + **/ +function zobrazNapovedu(text) { + zobraz(text, napovedniPole); +} /** Jednoduchá AJAXová funkce, načte obsah souboru a zobrazí ho ve výstupním okně. */ function ajaxVykonatSQL() { if (ajax.readyState == 4 || ajax.readyState == 0) { - zobraz(document.lokalizace.probihaSQL.value, stavovePole); - ajax.open("POST", 'ajax.jspx?akce=vykonat&sql=' + encodeURIComponent(getSQL()), true); + zobrazStav('Probíhá zpracování SQL příkazu…'); + ajax.open("POST", 'ajax?akce=vykonat&sql=' + encodeURIComponent(getSQL()), true); ajax.onreadystatechange = function() { if (ajax.readyState == 4) { - zobraz(ajax.responseText, vystupniPole); - zobraz('', stavovePole); + zobrazVystup(ajax.responseText); + zobrazStav(''); } }; @@ -70,10 +100,8 @@ function ajaxZobrazitHistorii() { if (ajax.readyState == 4 || ajax.readyState == 0) { - zobraz(document.lokalizace.probihaHistorie.value, stavovePole); - ajax.open("POST", 'ajax.jspx?akce=historie', true); + ajax.open("POST", 'ajax?akce=historie', true); ajax.onreadystatechange = function() { if (ajax.readyState == 4) { - zobraz(ajax.responseText, vystupniPole); - zobraz('', stavovePole); + zobrazVystup(ajax.responseText); } }; Index: java/sql-vyuka/web/index.jsp =================================================================== --- java/sql-vyuka/web/index.jsp (revision 23:6bbbd371e813) +++ java/sql-vyuka/web/index.jsp (revision 14:d08769933940) @@ -1,6 +1,6 @@ - <%@page contentType="text/html" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> + Index: ava/sql-vyuka/web/licence.txt =================================================================== --- java/sql-vyuka/web/licence.txt (revision 23:6bbbd371e813) +++ (revision ) @@ -1,1 +1,0 @@ -../../../licence/agpl-3.0.txt Index: java/sql-vyuka/web/styl.css =================================================================== --- java/sql-vyuka/web/styl.css (revision 22:e56b79cc18a9) +++ java/sql-vyuka/web/styl.css (revision 20:47de9e8ce93e) @@ -203,7 +203,2 @@ font-style: italic; } - -/** Skrytý formulář sloužící pro lokalizaci JavaScriptu */ -#lokalizace { - display: none; -} Index: java/sql-vyuka/web/vstupniPole.js =================================================================== --- java/sql-vyuka/web/vstupniPole.js (revision 22:e56b79cc18a9) +++ java/sql-vyuka/web/vstupniPole.js (revision 15:8632e6037843) @@ -3,5 +3,5 @@ var tab = "\t"; -function zpracujTabulatory(evt) { +function checkTab(evt) { var t = evt.target; Index: icence/agpl-3.0.tex =================================================================== --- licence/agpl-3.0.tex (revision 23:6bbbd371e813) +++ (revision ) @@ -1,705 +1,0 @@ -\documentclass[11pt]{article} - -\title{GNU AFFERO GENERAL PUBLIC LICENSE} -\date{Version 3, 19 November 2007} - -\begin{document} -\maketitle - -\begin{center} -{\parindent 0in - -Copyright \copyright\ 2007 Free Software Foundation, Inc. \texttt{http://fsf.org/} - -\bigskip -Everyone is permitted to copy and distribute verbatim copies of this - -license document, but changing it is not allowed.} - -\end{center} - -\renewcommand{\abstractname}{Preamble} -\begin{abstract} -The GNU Affero General Public License is a free, copyleft license -for software and other kinds of works, specifically designed to ensure -cooperation with the community in the case of network server software. - -The licenses for most software and other practical works are -designed to take away your freedom to share and change the works. By -contrast, our General Public Licenses are intended to guarantee your -freedom to share and change all versions of a program--to make sure it -remains free software for all its users. - -When we speak of free software, we are referring to freedom, not -price. Our General Public Licenses are designed to make sure that you -have the freedom to distribute copies of free software (and charge for -them if you wish), that you receive source code or can get it if you -want it, that you can change the software or use pieces of it in new -free programs, and that you know you can do these things. - -Developers that use our General Public Licenses protect your rights -with two steps: (1) assert copyright on the software, and (2) offer -you this License which gives you legal permission to copy, distribute -and/or modify the software. - -A secondary benefit of defending all users' freedom is that -improvements made in alternate versions of the program, if they -receive widespread use, become available for other developers to -incorporate. Many developers of free software are heartened and -encouraged by the resulting cooperation. However, in the case of -software used on network servers, this result may fail to come about. -The GNU General Public License permits making a modified version and -letting the public access it on a server without ever releasing its -source code to the public. - -The GNU Affero General Public License is designed specifically to -ensure that, in such cases, the modified source code becomes available -to the community. It requires the operator of a network server to -provide the source code of the modified version running there to the -users of that server. Therefore, public use of a modified version, on -a publicly accessible server, gives the public access to the source -code of the modified version. - -An older license, called the Affero General Public License and -published by Affero, was designed to accomplish similar goals. This is -a different license, not a version of the Affero GPL, but Affero has -released a new version of the Affero GPL which permits relicensing under -this license. - -The precise terms and conditions for copying, distribution and -modification follow. -\end{abstract} - -\begin{center} -{\Large \sc Terms and Conditions} -\end{center} - - -\begin{enumerate} - -\addtocounter{enumi}{-1} - -\item Definitions. - -``This License'' refers to version 3 of the GNU Affero General Public License. - -``Copyright'' also means copyright-like laws that apply to other kinds of -works, such as semiconductor masks. - -``The Program'' refers to any copyrightable work licensed under this -License. Each licensee is addressed as ``you''. ``Licensees'' and -``recipients'' may be individuals or organizations. - -To ``modify'' a work means to copy from or adapt all or part of the work -in a fashion requiring copyright permission, other than the making of an -exact copy. The resulting work is called a ``modified version'' of the -earlier work or a work ``based on'' the earlier work. - -A ``covered work'' means either the unmodified Program or a work based -on the Program. - -To ``propagate'' a work means to do anything with it that, without -permission, would make you directly or secondarily liable for -infringement under applicable copyright law, except executing it on a -computer or modifying a private copy. Propagation includes copying, -distribution (with or without modification), making available to the -public, and in some countries other activities as well. - -To ``convey'' a work means any kind of propagation that enables other -parties to make or receive copies. Mere interaction with a user through -a computer network, with no transfer of a copy, is not conveying. - -An interactive user interface displays ``Appropriate Legal Notices'' -to the extent that it includes a convenient and prominently visible -feature that (1) displays an appropriate copyright notice, and (2) -tells the user that there is no warranty for the work (except to the -extent that warranties are provided), that licensees may convey the -work under this License, and how to view a copy of this License. If -the interface presents a list of user commands or options, such as a -menu, a prominent item in the list meets this criterion. - -\item Source Code. - -The ``source code'' for a work means the preferred form of the work -for making modifications to it. ``Object code'' means any non-source -form of a work. - -A ``Standard Interface'' means an interface that either is an official -standard defined by a recognized standards body, or, in the case of -interfaces specified for a particular programming language, one that -is widely used among developers working in that language. - -The ``System Libraries'' of an executable work include anything, other -than the work as a whole, that (a) is included in the normal form of -packaging a Major Component, but which is not part of that Major -Component, and (b) serves only to enable use of the work with that -Major Component, or to implement a Standard Interface for which an -implementation is available to the public in source code form. A -``Major Component'', in this context, means a major essential component -(kernel, window system, and so on) of the specific operating system -(if any) on which the executable work runs, or a compiler used to -produce the work, or an object code interpreter used to run it. - -The ``Corresponding Source'' for a work in object code form means all -the source code needed to generate, install, and (for an executable -work) run the object code and to modify the work, including scripts to -control those activities. However, it does not include the work's -System Libraries, or general-purpose tools or generally available free -programs which are used unmodified in performing those activities but -which are not part of the work. For example, Corresponding Source -includes interface definition files associated with source files for -the work, and the source code for shared libraries and dynamically -linked subprograms that the work is specifically designed to require, -such as by intimate data communication or control flow between those -subprograms and other parts of the work. - -The Corresponding Source need not include anything that users -can regenerate automatically from other parts of the Corresponding -Source. - -The Corresponding Source for a work in source code form is that -same work. - -\item Basic Permissions. - -All rights granted under this License are granted for the term of -copyright on the Program, and are irrevocable provided the stated -conditions are met. This License explicitly affirms your unlimited -permission to run the unmodified Program. The output from running a -covered work is covered by this License only if the output, given its -content, constitutes a covered work. This License acknowledges your -rights of fair use or other equivalent, as provided by copyright law. - -You may make, run and propagate covered works that you do not -convey, without conditions so long as your license otherwise remains -in force. You may convey covered works to others for the sole purpose -of having them make modifications exclusively for you, or provide you -with facilities for running those works, provided that you comply with -the terms of this License in conveying all material for which you do -not control copyright. Those thus making or running the covered works -for you must do so exclusively on your behalf, under your direction -and control, on terms that prohibit them from making any copies of -your copyrighted material outside their relationship with you. - -Conveying under any other circumstances is permitted solely under -the conditions stated below. Sublicensing is not allowed; section 10 -makes it unnecessary. - -\item Protecting Users' Legal Rights From Anti-Circumvention Law. - -No covered work shall be deemed part of an effective technological -measure under any applicable law fulfilling obligations under article -11 of the WIPO copyright treaty adopted on 20 December 1996, or -similar laws prohibiting or restricting circumvention of such -measures. - -When you convey a covered work, you waive any legal power to forbid -circumvention of technological measures to the extent such circumvention -is effected by exercising rights under this License with respect to -the covered work, and you disclaim any intention to limit operation or -modification of the work as a means of enforcing, against the work's -users, your or third parties' legal rights to forbid circumvention of -technological measures. - -\item Conveying Verbatim Copies. - -You may convey verbatim copies of the Program's source code as you -receive it, in any medium, provided that you conspicuously and -appropriately publish on each copy an appropriate copyright notice; -keep intact all notices stating that this License and any -non-permissive terms added in accord with section 7 apply to the code; -keep intact all notices of the absence of any warranty; and give all -recipients a copy of this License along with the Program. - -You may charge any price or no price for each copy that you convey, -and you may offer support or warranty protection for a fee. - -\item Conveying Modified Source Versions. - -You may convey a work based on the Program, or the modifications to -produce it from the Program, in the form of source code under the -terms of section 4, provided that you also meet all of these conditions: - \begin{enumerate} - \item The work must carry prominent notices stating that you modified - it, and giving a relevant date. - - \item The work must carry prominent notices stating that it is - released under this License and any conditions added under section - 7. This requirement modifies the requirement in section 4 to - ``keep intact all notices''. - - \item You must license the entire work, as a whole, under this - License to anyone who comes into possession of a copy. This - License will therefore apply, along with any applicable section 7 - additional terms, to the whole of the work, and all its parts, - regardless of how they are packaged. This License gives no - permission to license the work in any other way, but it does not - invalidate such permission if you have separately received it. - - \item If the work has interactive user interfaces, each must display - Appropriate Legal Notices; however, if the Program has interactive - interfaces that do not display Appropriate Legal Notices, your - work need not make them do so. -\end{enumerate} -A compilation of a covered work with other separate and independent -works, which are not by their nature extensions of the covered work, -and which are not combined with it such as to form a larger program, -in or on a volume of a storage or distribution medium, is called an -``aggregate'' if the compilation and its resulting copyright are not -used to limit the access or legal rights of the compilation's users -beyond what the individual works permit. Inclusion of a covered work -in an aggregate does not cause this License to apply to the other -parts of the aggregate. - -\item Conveying Non-Source Forms. - -You may convey a covered work in object code form under the terms -of sections 4 and 5, provided that you also convey the -machine-readable Corresponding Source under the terms of this License, -in one of these ways: - \begin{enumerate} - \item Convey the object code in, or embodied in, a physical product - (including a physical distribution medium), accompanied by the - Corresponding Source fixed on a durable physical medium - customarily used for software interchange. - - \item Convey the object code in, or embodied in, a physical product - (including a physical distribution medium), accompanied by a - written offer, valid for at least three years and valid for as - long as you offer spare parts or customer support for that product - model, to give anyone who possesses the object code either (1) a - copy of the Corresponding Source for all the software in the - product that is covered by this License, on a durable physical - medium customarily used for software interchange, for a price no - more than your reasonable cost of physically performing this - conveying of source, or (2) access to copy the - Corresponding Source from a network server at no charge. - - \item Convey individual copies of the object code with a copy of the - written offer to provide the Corresponding Source. This - alternative is allowed only occasionally and noncommercially, and - only if you received the object code with such an offer, in accord - with subsection 6b. - - \item Convey the object code by offering access from a designated - place (gratis or for a charge), and offer equivalent access to the - Corresponding Source in the same way through the same place at no - further charge. You need not require recipients to copy the - Corresponding Source along with the object code. If the place to - copy the object code is a network server, the Corresponding Source - may be on a different server (operated by you or a third party) - that supports equivalent copying facilities, provided you maintain - clear directions next to the object code saying where to find the - Corresponding Source. Regardless of what server hosts the - Corresponding Source, you remain obligated to ensure that it is - available for as long as needed to satisfy these requirements. - - \item Convey the object code using peer-to-peer transmission, provided - you inform other peers where the object code and Corresponding - Source of the work are being offered to the general public at no - charge under subsection 6d. - \end{enumerate} - -A separable portion of the object code, whose source code is excluded -from the Corresponding Source as a System Library, need not be -included in conveying the object code work. - -A ``User Product'' is either (1) a ``consumer product'', which means any -tangible personal property which is normally used for personal, family, -or household purposes, or (2) anything designed or sold for incorporation -into a dwelling. In determining whether a product is a consumer product, -doubtful cases shall be resolved in favor of coverage. For a particular -product received by a particular user, ``normally used'' refers to a -typical or common use of that class of product, regardless of the status -of the particular user or of the way in which the particular user -actually uses, or expects or is expected to use, the product. A product -is a consumer product regardless of whether the product has substantial -commercial, industrial or non-consumer uses, unless such uses represent -the only significant mode of use of the product. - -``Installation Information'' for a User Product means any methods, -procedures, authorization keys, or other information required to install -and execute modified versions of a covered work in that User Product from -a modified version of its Corresponding Source. The information must -suffice to ensure that the continued functioning of the modified object -code is in no case prevented or interfered with solely because -modification has been made. - -If you convey an object code work under this section in, or with, or -specifically for use in, a User Product, and the conveying occurs as -part of a transaction in which the right of possession and use of the -User Product is transferred to the recipient in perpetuity or for a -fixed term (regardless of how the transaction is characterized), the -Corresponding Source conveyed under this section must be accompanied -by the Installation Information. But this requirement does not apply -if neither you nor any third party retains the ability to install -modified object code on the User Product (for example, the work has -been installed in ROM). - -The requirement to provide Installation Information does not include a -requirement to continue to provide support service, warranty, or updates -for a work that has been modified or installed by the recipient, or for -the User Product in which it has been modified or installed. Access to a -network may be denied when the modification itself materially and -adversely affects the operation of the network or violates the rules and -protocols for communication across the network. - -Corresponding Source conveyed, and Installation Information provided, -in accord with this section must be in a format that is publicly -documented (and with an implementation available to the public in -source code form), and must require no special password or key for -unpacking, reading or copying. - -\item Additional Terms. - -``Additional permissions'' are terms that supplement the terms of this -License by making exceptions from one or more of its conditions. -Additional permissions that are applicable to the entire Program shall -be treated as though they were included in this License, to the extent -that they are valid under applicable law. If additional permissions -apply only to part of the Program, that part may be used separately -under those permissions, but the entire Program remains governed by -this License without regard to the additional permissions. - -When you convey a copy of a covered work, you may at your option -remove any additional permissions from that copy, or from any part of -it. (Additional permissions may be written to require their own -removal in certain cases when you modify the work.) You may place -additional permissions on material, added by you to a covered work, -for which you have or can give appropriate copyright permission. - -Notwithstanding any other provision of this License, for material you -add to a covered work, you may (if authorized by the copyright holders of -that material) supplement the terms of this License with terms: - \begin{enumerate} - \item Disclaiming warranty or limiting liability differently from the - terms of sections 15 and 16 of this License; or - - \item Requiring preservation of specified reasonable legal notices or - author attributions in that material or in the Appropriate Legal - Notices displayed by works containing it; or - - \item Prohibiting misrepresentation of the origin of that material, or - requiring that modified versions of such material be marked in - reasonable ways as different from the original version; or - - \item Limiting the use for publicity purposes of names of licensors or - authors of the material; or - - \item Declining to grant rights under trademark law for use of some - trade names, trademarks, or service marks; or - - \item Requiring indemnification of licensors and authors of that - material by anyone who conveys the material (or modified versions of - it) with contractual assumptions of liability to the recipient, for - any liability that these contractual assumptions directly impose on - those licensors and authors. - \end{enumerate} - -All other non-permissive additional terms are considered ``further -restrictions'' within the meaning of section 10. If the Program as you -received it, or any part of it, contains a notice stating that it is -governed by this License along with a term that is a further -restriction, you may remove that term. If a license document contains -a further restriction but permits relicensing or conveying under this -License, you may add to a covered work material governed by the terms -of that license document, provided that the further restriction does -not survive such relicensing or conveying. - -If you add terms to a covered work in accord with this section, you -must place, in the relevant source files, a statement of the -additional terms that apply to those files, or a notice indicating -where to find the applicable terms. - -Additional terms, permissive or non-permissive, may be stated in the -form of a separately written license, or stated as exceptions; -the above requirements apply either way. - -\item Termination. - -You may not propagate or modify a covered work except as expressly -provided under this License. Any attempt otherwise to propagate or -modify it is void, and will automatically terminate your rights under -this License (including any patent licenses granted under the third -paragraph of section 11). - -However, if you cease all violation of this License, then your -license from a particular copyright holder is reinstated (a) -provisionally, unless and until the copyright holder explicitly and -finally terminates your license, and (b) permanently, if the copyright -holder fails to notify you of the violation by some reasonable means -prior to 60 days after the cessation. - -Moreover, your license from a particular copyright holder is -reinstated permanently if the copyright holder notifies you of the -violation by some reasonable means, this is the first time you have -received notice of violation of this License (for any work) from that -copyright holder, and you cure the violation prior to 30 days after -your receipt of the notice. - -Termination of your rights under this section does not terminate the -licenses of parties who have received copies or rights from you under -this License. If your rights have been terminated and not permanently -reinstated, you do not qualify to receive new licenses for the same -material under section 10. - -\item Acceptance Not Required for Having Copies. - -You are not required to accept this License in order to receive or -run a copy of the Program. Ancillary propagation of a covered work -occurring solely as a consequence of using peer-to-peer transmission -to receive a copy likewise does not require acceptance. However, -nothing other than this License grants you permission to propagate or -modify any covered work. These actions infringe copyright if you do -not accept this License. Therefore, by modifying or propagating a -covered work, you indicate your acceptance of this License to do so. - -\item Automatic Licensing of Downstream Recipients. - -Each time you convey a covered work, the recipient automatically -receives a license from the original licensors, to run, modify and -propagate that work, subject to this License. You are not responsible -for enforcing compliance by third parties with this License. - -An ``entity transaction'' is a transaction transferring control of an -organization, or substantially all assets of one, or subdividing an -organization, or merging organizations. If propagation of a covered -work results from an entity transaction, each party to that -transaction who receives a copy of the work also receives whatever -licenses to the work the party's predecessor in interest had or could -give under the previous paragraph, plus a right to possession of the -Corresponding Source of the work from the predecessor in interest, if -the predecessor has it or can get it with reasonable efforts. - -You may not impose any further restrictions on the exercise of the -rights granted or affirmed under this License. For example, you may -not impose a license fee, royalty, or other charge for exercise of -rights granted under this License, and you may not initiate litigation -(including a cross-claim or counterclaim in a lawsuit) alleging that -any patent claim is infringed by making, using, selling, offering for -sale, or importing the Program or any portion of it. - -\item Patents. - -A ``contributor'' is a copyright holder who authorizes use under this -License of the Program or a work on which the Program is based. The -work thus licensed is called the contributor's ``contributor version''. - -A contributor's ``essential patent claims'' are all patent claims -owned or controlled by the contributor, whether already acquired or -hereafter acquired, that would be infringed by some manner, permitted -by this License, of making, using, or selling its contributor version, -but do not include claims that would be infringed only as a -consequence of further modification of the contributor version. For -purposes of this definition, ``control'' includes the right to grant -patent sublicenses in a manner consistent with the requirements of -this License. - -Each contributor grants you a non-exclusive, worldwide, royalty-free -patent license under the contributor's essential patent claims, to -make, use, sell, offer for sale, import and otherwise run, modify and -propagate the contents of its contributor version. - -In the following three paragraphs, a ``patent license'' is any express -agreement or commitment, however denominated, not to enforce a patent -(such as an express permission to practice a patent or covenant not to -sue for patent infringement). To ``grant'' such a patent license to a -party means to make such an agreement or commitment not to enforce a -patent against the party. - -If you convey a covered work, knowingly relying on a patent license, -and the Corresponding Source of the work is not available for anyone -to copy, free of charge and under the terms of this License, through a -publicly available network server or other readily accessible means, -then you must either (1) cause the Corresponding Source to be so -available, or (2) arrange to deprive yourself of the benefit of the -patent license for this particular work, or (3) arrange, in a manner -consistent with the requirements of this License, to extend the patent -license to downstream recipients. ``Knowingly relying'' means you have -actual knowledge that, but for the patent license, your conveying the -covered work in a country, or your recipient's use of the covered work -in a country, would infringe one or more identifiable patents in that -country that you have reason to believe are valid. - -If, pursuant to or in connection with a single transaction or -arrangement, you convey, or propagate by procuring conveyance of, a -covered work, and grant a patent license to some of the parties -receiving the covered work authorizing them to use, propagate, modify -or convey a specific copy of the covered work, then the patent license -you grant is automatically extended to all recipients of the covered -work and works based on it. - -A patent license is ``discriminatory'' if it does not include within -the scope of its coverage, prohibits the exercise of, or is -conditioned on the non-exercise of one or more of the rights that are -specifically granted under this License. You may not convey a covered -work if you are a party to an arrangement with a third party that is -in the business of distributing software, under which you make payment -to the third party based on the extent of your activity of conveying -the work, and under which the third party grants, to any of the -parties who would receive the covered work from you, a discriminatory -patent license (a) in connection with copies of the covered work -conveyed by you (or copies made from those copies), or (b) primarily -for and in connection with specific products or compilations that -contain the covered work, unless you entered into that arrangement, -or that patent license was granted, prior to 28 March 2007. - -Nothing in this License shall be construed as excluding or limiting -any implied license or other defenses to infringement that may -otherwise be available to you under applicable patent law. - -\item No Surrender of Others' Freedom. - -If conditions are imposed on you (whether by court order, agreement or -otherwise) that contradict the conditions of this License, they do not -excuse you from the conditions of this License. If you cannot convey a -covered work so as to satisfy simultaneously your obligations under this -License and any other pertinent obligations, then as a consequence you may -not convey it at all. For example, if you agree to terms that obligate you -to collect a royalty for further conveying from those to whom you convey -the Program, the only way you could satisfy both those terms and this -License would be to refrain entirely from conveying the Program. - -\item Remote Network Interaction; Use with the GNU General Public License. - -Notwithstanding any other provision of this License, if you modify the -Program, your modified version must prominently offer all users interacting -with it remotely through a computer network (if your version supports such -interaction) an opportunity to receive the Corresponding Source of your -version by providing access to the Corresponding Source from a network -server at no charge, through some standard or customary means of -facilitating copying of software. This Corresponding Source shall include -the Corresponding Source for any work covered by version 3 of the GNU -General Public License that is incorporated pursuant to the following -paragraph. - -Notwithstanding any other provision of this License, you have permission to -link or combine any covered work with a work licensed under version 3 of -the GNU General Public License into a single combined work, and to convey -the resulting work. The terms of this License will continue to apply to -the part which is the covered work, but the work with which it is combined -will remain governed by version 3 of the GNU General Public License. - -\item Revised Versions of this License. - -The Free Software Foundation may publish revised and/or new versions of -the GNU Affero General Public License from time to time. Such new versions will -be similar in spirit to the present version, but may differ in detail to -address new problems or concerns. - -Each version is given a distinguishing version number. If the -Program specifies that a certain numbered version of the GNU Affero General -Public License ``or any later version'' applies to it, you have the -option of following the terms and conditions either of that numbered -version or of any later version published by the Free Software -Foundation. If the Program does not specify a version number of the -GNU Affero General Public License, you may choose any version ever published -by the Free Software Foundation. - -If the Program specifies that a proxy can decide which future -versions of the GNU Affero General Public License can be used, that proxy's -public statement of acceptance of a version permanently authorizes you -to choose that version for the Program. - -Later license versions may give you additional or different -permissions. However, no additional obligations are imposed on any -author or copyright holder as a result of your choosing to follow a -later version. - -\item Disclaimer of Warranty. - -\begin{sloppypar} - THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY - APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE - COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM ``AS IS'' - WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, - INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF - MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE - RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU. - SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL - NECESSARY SERVICING, REPAIR OR CORRECTION. -\end{sloppypar} - -\item Limitation of Liability. - - IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN - WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MODIFIES - AND/OR CONVEYS THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR - DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL - DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE PROGRAM - (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED - INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE - OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS), EVEN IF SUCH - HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH - DAMAGES. - -\item Interpretation of Sections 15 and 16. - -If the disclaimer of warranty and limitation of liability provided -above cannot be given local legal effect according to their terms, -reviewing courts shall apply local law that most closely approximates -an absolute waiver of all civil liability in connection with the -Program, unless a warranty or assumption of liability accompanies a -copy of the Program in return for a fee. - -\begin{center} -{\Large\sc End of Terms and Conditions} - -\bigskip -How to Apply These Terms to Your New Programs -\end{center} - -If you develop a new program, and you want it to be of the greatest -possible use to the public, the best way to achieve this is to make it -free software which everyone can redistribute and change under these terms. - -To do so, attach the following notices to the program. It is safest -to attach them to the start of each source file to most effectively -state the exclusion of warranty; and each file should have at least -the ``copyright'' line and a pointer to where the full notice is found. - -{\footnotesize -\begin{verbatim} - - -Copyright (C) - -This program is free software: you can redistribute it and/or modify -it under the terms of the GNU Affero General Public License as published by -the Free Software Foundation, either version 3 of the License, or -(at your option) any later version. - -This program 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 Affero General Public License for more details. - -You should have received a copy of the GNU Affero General Public License -along with this program. If not, see . -\end{verbatim} -} - -Also add information on how to contact you by electronic and paper mail. - -If your software can interact with users remotely through a computer -network, you should also make sure that it provides a way for users to -get its source. For example, if your program is a web application, its -interface could display a ``Source'' link that leads users to an archive -of the code. There are many ways you could offer source, and different -solutions will be better for different programs; see section 13 for the -specific requirements. - -You should also get your employer (if you work as a programmer) or -school, if any, to sign a ``copyright disclaimer'' for the program, if -necessary. For more information on this, and how to apply and follow -the GNU AGPL, see \texttt{http://www.gnu.org/licenses/}. - -\end{enumerate} - -\end{document} - -%%% Local Variables: -%%% mode: latex -%%% TeX-master: t -%%% End: - Index: icence/agpl-3.0.txt =================================================================== --- licence/agpl-3.0.txt (revision 23:6bbbd371e813) +++ (revision ) @@ -1,661 +1,0 @@ - GNU AFFERO GENERAL PUBLIC LICENSE - Version 3, 19 November 2007 - - Copyright (C) 2007 Free Software Foundation, Inc. - Everyone is permitted to copy and distribute verbatim copies - of this license document, but changing it is not allowed. - - Preamble - - The GNU Affero General Public License is a free, copyleft license for -software and other kinds of works, specifically designed to ensure -cooperation with the community in the case of network server software. - - The licenses for most software and other practical works are designed -to take away your freedom to share and change the works. By contrast, -our General Public Licenses are intended to guarantee your freedom to -share and change all versions of a program--to make sure it remains free -software for all its users. - - When we speak of free software, we are referring to freedom, not -price. Our General Public Licenses are designed to make sure that you -have the freedom to distribute copies of free software (and charge for -them if you wish), that you receive source code or can get it if you -want it, that you can change the software or use pieces of it in new -free programs, and that you know you can do these things. - - Developers that use our General Public Licenses protect your rights -with two steps: (1) assert copyright on the software, and (2) offer -you this License which gives you legal permission to copy, distribute -and/or modify the software. - - A secondary benefit of defending all users' freedom is that -improvements made in alternate versions of the program, if they -receive widespread use, become available for other developers to -incorporate. Many developers of free software are heartened and -encouraged by the resulting cooperation. However, in the case of -software used on network servers, this result may fail to come about. -The GNU General Public License permits making a modified version and -letting the public access it on a server without ever releasing its -source code to the public. - - The GNU Affero General Public License is designed specifically to -ensure that, in such cases, the modified source code becomes available -to the community. It requires the operator of a network server to -provide the source code of the modified version running there to the -users of that server. Therefore, public use of a modified version, on -a publicly accessible server, gives the public access to the source -code of the modified version. - - An older license, called the Affero General Public License and -published by Affero, was designed to accomplish similar goals. This is -a different license, not a version of the Affero GPL, but Affero has -released a new version of the Affero GPL which permits relicensing under -this license. - - The precise terms and conditions for copying, distribution and -modification follow. - - TERMS AND CONDITIONS - - 0. Definitions. - - "This License" refers to version 3 of the GNU Affero General Public License. - - "Copyright" also means copyright-like laws that apply to other kinds of -works, such as semiconductor masks. - - "The Program" refers to any copyrightable work licensed under this -License. Each licensee is addressed as "you". "Licensees" and -"recipients" may be individuals or organizations. - - To "modify" a work means to copy from or adapt all or part of the work -in a fashion requiring copyright permission, other than the making of an -exact copy. The resulting work is called a "modified version" of the -earlier work or a work "based on" the earlier work. - - A "covered work" means either the unmodified Program or a work based -on the Program. - - To "propagate" a work means to do anything with it that, without -permission, would make you directly or secondarily liable for -infringement under applicable copyright law, except executing it on a -computer or modifying a private copy. Propagation includes copying, -distribution (with or without modification), making available to the -public, and in some countries other activities as well. - - To "convey" a work means any kind of propagation that enables other -parties to make or receive copies. Mere interaction with a user through -a computer network, with no transfer of a copy, is not conveying. - - An interactive user interface displays "Appropriate Legal Notices" -to the extent that it includes a convenient and prominently visible -feature that (1) displays an appropriate copyright notice, and (2) -tells the user that there is no warranty for the work (except to the -extent that warranties are provided), that licensees may convey the -work under this License, and how to view a copy of this License. If -the interface presents a list of user commands or options, such as a -menu, a prominent item in the list meets this criterion. - - 1. Source Code. - - The "source code" for a work means the preferred form of the work -for making modifications to it. "Object code" means any non-source -form of a work. - - A "Standard Interface" means an interface that either is an official -standard defined by a recognized standards body, or, in the case of -interfaces specified for a particular programming language, one that -is widely used among developers working in that language. - - The "System Libraries" of an executable work include anything, other -than the work as a whole, that (a) is included in the normal form of -packaging a Major Component, but which is not part of that Major -Component, and (b) serves only to enable use of the work with that -Major Component, or to implement a Standard Interface for which an -implementation is available to the public in source code form. A -"Major Component", in this context, means a major essential component -(kernel, window system, and so on) of the specific operating system -(if any) on which the executable work runs, or a compiler used to -produce the work, or an object code interpreter used to run it. - - The "Corresponding Source" for a work in object code form means all -the source code needed to generate, install, and (for an executable -work) run the object code and to modify the work, including scripts to -control those activities. However, it does not include the work's -System Libraries, or general-purpose tools or generally available free -programs which are used unmodified in performing those activities but -which are not part of the work. For example, Corresponding Source -includes interface definition files associated with source files for -the work, and the source code for shared libraries and dynamically -linked subprograms that the work is specifically designed to require, -such as by intimate data communication or control flow between those -subprograms and other parts of the work. - - The Corresponding Source need not include anything that users -can regenerate automatically from other parts of the Corresponding -Source. - - The Corresponding Source for a work in source code form is that -same work. - - 2. Basic Permissions. - - All rights granted under this License are granted for the term of -copyright on the Program, and are irrevocable provided the stated -conditions are met. This License explicitly affirms your unlimited -permission to run the unmodified Program. The output from running a -covered work is covered by this License only if the output, given its -content, constitutes a covered work. This License acknowledges your -rights of fair use or other equivalent, as provided by copyright law. - - You may make, run and propagate covered works that you do not -convey, without conditions so long as your license otherwise remains -in force. You may convey covered works to others for the sole purpose -of having them make modifications exclusively for you, or provide you -with facilities for running those works, provided that you comply with -the terms of this License in conveying all material for which you do -not control copyright. Those thus making or running the covered works -for you must do so exclusively on your behalf, under your direction -and control, on terms that prohibit them from making any copies of -your copyrighted material outside their relationship with you. - - Conveying under any other circumstances is permitted solely under -the conditions stated below. Sublicensing is not allowed; section 10 -makes it unnecessary. - - 3. Protecting Users' Legal Rights From Anti-Circumvention Law. - - No covered work shall be deemed part of an effective technological -measure under any applicable law fulfilling obligations under article -11 of the WIPO copyright treaty adopted on 20 December 1996, or -similar laws prohibiting or restricting circumvention of such -measures. - - When you convey a covered work, you waive any legal power to forbid -circumvention of technological measures to the extent such circumvention -is effected by exercising rights under this License with respect to -the covered work, and you disclaim any intention to limit operation or -modification of the work as a means of enforcing, against the work's -users, your or third parties' legal rights to forbid circumvention of -technological measures. - - 4. Conveying Verbatim Copies. - - You may convey verbatim copies of the Program's source code as you -receive it, in any medium, provided that you conspicuously and -appropriately publish on each copy an appropriate copyright notice; -keep intact all notices stating that this License and any -non-permissive terms added in accord with section 7 apply to the code; -keep intact all notices of the absence of any warranty; and give all -recipients a copy of this License along with the Program. - - You may charge any price or no price for each copy that you convey, -and you may offer support or warranty protection for a fee. - - 5. Conveying Modified Source Versions. - - You may convey a work based on the Program, or the modifications to -produce it from the Program, in the form of source code under the -terms of section 4, provided that you also meet all of these conditions: - - a) The work must carry prominent notices stating that you modified - it, and giving a relevant date. - - b) The work must carry prominent notices stating that it is - released under this License and any conditions added under section - 7. This requirement modifies the requirement in section 4 to - "keep intact all notices". - - c) You must license the entire work, as a whole, under this - License to anyone who comes into possession of a copy. This - License will therefore apply, along with any applicable section 7 - additional terms, to the whole of the work, and all its parts, - regardless of how they are packaged. This License gives no - permission to license the work in any other way, but it does not - invalidate such permission if you have separately received it. - - d) If the work has interactive user interfaces, each must display - Appropriate Legal Notices; however, if the Program has interactive - interfaces that do not display Appropriate Legal Notices, your - work need not make them do so. - - A compilation of a covered work with other separate and independent -works, which are not by their nature extensions of the covered work, -and which are not combined with it such as to form a larger program, -in or on a volume of a storage or distribution medium, is called an -"aggregate" if the compilation and its resulting copyright are not -used to limit the access or legal rights of the compilation's users -beyond what the individual works permit. Inclusion of a covered work -in an aggregate does not cause this License to apply to the other -parts of the aggregate. - - 6. Conveying Non-Source Forms. - - You may convey a covered work in object code form under the terms -of sections 4 and 5, provided that you also convey the -machine-readable Corresponding Source under the terms of this License, -in one of these ways: - - a) Convey the object code in, or embodied in, a physical product - (including a physical distribution medium), accompanied by the - Corresponding Source fixed on a durable physical medium - customarily used for software interchange. - - b) Convey the object code in, or embodied in, a physical product - (including a physical distribution medium), accompanied by a - written offer, valid for at least three years and valid for as - long as you offer spare parts or customer support for that product - model, to give anyone who possesses the object code either (1) a - copy of the Corresponding Source for all the software in the - product that is covered by this License, on a durable physical - medium customarily used for software interchange, for a price no - more than your reasonable cost of physically performing this - conveying of source, or (2) access to copy the - Corresponding Source from a network server at no charge. - - c) Convey individual copies of the object code with a copy of the - written offer to provide the Corresponding Source. This - alternative is allowed only occasionally and noncommercially, and - only if you received the object code with such an offer, in accord - with subsection 6b. - - d) Convey the object code by offering access from a designated - place (gratis or for a charge), and offer equivalent access to the - Corresponding Source in the same way through the same place at no - further charge. You need not require recipients to copy the - Corresponding Source along with the object code. If the place to - copy the object code is a network server, the Corresponding Source - may be on a different server (operated by you or a third party) - that supports equivalent copying facilities, provided you maintain - clear directions next to the object code saying where to find the - Corresponding Source. Regardless of what server hosts the - Corresponding Source, you remain obligated to ensure that it is - available for as long as needed to satisfy these requirements. - - e) Convey the object code using peer-to-peer transmission, provided - you inform other peers where the object code and Corresponding - Source of the work are being offered to the general public at no - charge under subsection 6d. - - A separable portion of the object code, whose source code is excluded -from the Corresponding Source as a System Library, need not be -included in conveying the object code work. - - A "User Product" is either (1) a "consumer product", which means any -tangible personal property which is normally used for personal, family, -or household purposes, or (2) anything designed or sold for incorporation -into a dwelling. In determining whether a product is a consumer product, -doubtful cases shall be resolved in favor of coverage. For a particular -product received by a particular user, "normally used" refers to a -typical or common use of that class of product, regardless of the status -of the particular user or of the way in which the particular user -actually uses, or expects or is expected to use, the product. A product -is a consumer product regardless of whether the product has substantial -commercial, industrial or non-consumer uses, unless such uses represent -the only significant mode of use of the product. - - "Installation Information" for a User Product means any methods, -procedures, authorization keys, or other information required to install -and execute modified versions of a covered work in that User Product from -a modified version of its Corresponding Source. The information must -suffice to ensure that the continued functioning of the modified object -code is in no case prevented or interfered with solely because -modification has been made. - - If you convey an object code work under this section in, or with, or -specifically for use in, a User Product, and the conveying occurs as -part of a transaction in which the right of possession and use of the -User Product is transferred to the recipient in perpetuity or for a -fixed term (regardless of how the transaction is characterized), the -Corresponding Source conveyed under this section must be accompanied -by the Installation Information. But this requirement does not apply -if neither you nor any third party retains the ability to install -modified object code on the User Product (for example, the work has -been installed in ROM). - - The requirement to provide Installation Information does not include a -requirement to continue to provide support service, warranty, or updates -for a work that has been modified or installed by the recipient, or for -the User Product in which it has been modified or installed. Access to a -network may be denied when the modification itself materially and -adversely affects the operation of the network or violates the rules and -protocols for communication across the network. - - Corresponding Source conveyed, and Installation Information provided, -in accord with this section must be in a format that is publicly -documented (and with an implementation available to the public in -source code form), and must require no special password or key for -unpacking, reading or copying. - - 7. Additional Terms. - - "Additional permissions" are terms that supplement the terms of this -License by making exceptions from one or more of its conditions. -Additional permissions that are applicable to the entire Program shall -be treated as though they were included in this License, to the extent -that they are valid under applicable law. If additional permissions -apply only to part of the Program, that part may be used separately -under those permissions, but the entire Program remains governed by -this License without regard to the additional permissions. - - When you convey a copy of a covered work, you may at your option -remove any additional permissions from that copy, or from any part of -it. (Additional permissions may be written to require their own -removal in certain cases when you modify the work.) You may place -additional permissions on material, added by you to a covered work, -for which you have or can give appropriate copyright permission. - - Notwithstanding any other provision of this License, for material you -add to a covered work, you may (if authorized by the copyright holders of -that material) supplement the terms of this License with terms: - - a) Disclaiming warranty or limiting liability differently from the - terms of sections 15 and 16 of this License; or - - b) Requiring preservation of specified reasonable legal notices or - author attributions in that material or in the Appropriate Legal - Notices displayed by works containing it; or - - c) Prohibiting misrepresentation of the origin of that material, or - requiring that modified versions of such material be marked in - reasonable ways as different from the original version; or - - d) Limiting the use for publicity purposes of names of licensors or - authors of the material; or - - e) Declining to grant rights under trademark law for use of some - trade names, trademarks, or service marks; or - - f) Requiring indemnification of licensors and authors of that - material by anyone who conveys the material (or modified versions of - it) with contractual assumptions of liability to the recipient, for - any liability that these contractual assumptions directly impose on - those licensors and authors. - - All other non-permissive additional terms are considered "further -restrictions" within the meaning of section 10. If the Program as you -received it, or any part of it, contains a notice stating that it is -governed by this License along with a term that is a further -restriction, you may remove that term. If a license document contains -a further restriction but permits relicensing or conveying under this -License, you may add to a covered work material governed by the terms -of that license document, provided that the further restriction does -not survive such relicensing or conveying. - - If you add terms to a covered work in accord with this section, you -must place, in the relevant source files, a statement of the -additional terms that apply to those files, or a notice indicating -where to find the applicable terms. - - Additional terms, permissive or non-permissive, may be stated in the -form of a separately written license, or stated as exceptions; -the above requirements apply either way. - - 8. Termination. - - You may not propagate or modify a covered work except as expressly -provided under this License. Any attempt otherwise to propagate or -modify it is void, and will automatically terminate your rights under -this License (including any patent licenses granted under the third -paragraph of section 11). - - However, if you cease all violation of this License, then your -license from a particular copyright holder is reinstated (a) -provisionally, unless and until the copyright holder explicitly and -finally terminates your license, and (b) permanently, if the copyright -holder fails to notify you of the violation by some reasonable means -prior to 60 days after the cessation. - - Moreover, your license from a particular copyright holder is -reinstated permanently if the copyright holder notifies you of the -violation by some reasonable means, this is the first time you have -received notice of violation of this License (for any work) from that -copyright holder, and you cure the violation prior to 30 days after -your receipt of the notice. - - Termination of your rights under this section does not terminate the -licenses of parties who have received copies or rights from you under -this License. If your rights have been terminated and not permanently -reinstated, you do not qualify to receive new licenses for the same -material under section 10. - - 9. Acceptance Not Required for Having Copies. - - You are not required to accept this License in order to receive or -run a copy of the Program. Ancillary propagation of a covered work -occurring solely as a consequence of using peer-to-peer transmission -to receive a copy likewise does not require acceptance. However, -nothing other than this License grants you permission to propagate or -modify any covered work. These actions infringe copyright if you do -not accept this License. Therefore, by modifying or propagating a -covered work, you indicate your acceptance of this License to do so. - - 10. Automatic Licensing of Downstream Recipients. - - Each time you convey a covered work, the recipient automatically -receives a license from the original licensors, to run, modify and -propagate that work, subject to this License. You are not responsible -for enforcing compliance by third parties with this License. - - An "entity transaction" is a transaction transferring control of an -organization, or substantially all assets of one, or subdividing an -organization, or merging organizations. If propagation of a covered -work results from an entity transaction, each party to that -transaction who receives a copy of the work also receives whatever -licenses to the work the party's predecessor in interest had or could -give under the previous paragraph, plus a right to possession of the -Corresponding Source of the work from the predecessor in interest, if -the predecessor has it or can get it with reasonable efforts. - - You may not impose any further restrictions on the exercise of the -rights granted or affirmed under this License. For example, you may -not impose a license fee, royalty, or other charge for exercise of -rights granted under this License, and you may not initiate litigation -(including a cross-claim or counterclaim in a lawsuit) alleging that -any patent claim is infringed by making, using, selling, offering for -sale, or importing the Program or any portion of it. - - 11. Patents. - - A "contributor" is a copyright holder who authorizes use under this -License of the Program or a work on which the Program is based. The -work thus licensed is called the contributor's "contributor version". - - A contributor's "essential patent claims" are all patent claims -owned or controlled by the contributor, whether already acquired or -hereafter acquired, that would be infringed by some manner, permitted -by this License, of making, using, or selling its contributor version, -but do not include claims that would be infringed only as a -consequence of further modification of the contributor version. For -purposes of this definition, "control" includes the right to grant -patent sublicenses in a manner consistent with the requirements of -this License. - - Each contributor grants you a non-exclusive, worldwide, royalty-free -patent license under the contributor's essential patent claims, to -make, use, sell, offer for sale, import and otherwise run, modify and -propagate the contents of its contributor version. - - In the following three paragraphs, a "patent license" is any express -agreement or commitment, however denominated, not to enforce a patent -(such as an express permission to practice a patent or covenant not to -sue for patent infringement). To "grant" such a patent license to a -party means to make such an agreement or commitment not to enforce a -patent against the party. - - If you convey a covered work, knowingly relying on a patent license, -and the Corresponding Source of the work is not available for anyone -to copy, free of charge and under the terms of this License, through a -publicly available network server or other readily accessible means, -then you must either (1) cause the Corresponding Source to be so -available, or (2) arrange to deprive yourself of the benefit of the -patent license for this particular work, or (3) arrange, in a manner -consistent with the requirements of this License, to extend the patent -license to downstream recipients. "Knowingly relying" means you have -actual knowledge that, but for the patent license, your conveying the -covered work in a country, or your recipient's use of the covered work -in a country, would infringe one or more identifiable patents in that -country that you have reason to believe are valid. - - If, pursuant to or in connection with a single transaction or -arrangement, you convey, or propagate by procuring conveyance of, a -covered work, and grant a patent license to some of the parties -receiving the covered work authorizing them to use, propagate, modify -or convey a specific copy of the covered work, then the patent license -you grant is automatically extended to all recipients of the covered -work and works based on it. - - A patent license is "discriminatory" if it does not include within -the scope of its coverage, prohibits the exercise of, or is -conditioned on the non-exercise of one or more of the rights that are -specifically granted under this License. You may not convey a covered -work if you are a party to an arrangement with a third party that is -in the business of distributing software, under which you make payment -to the third party based on the extent of your activity of conveying -the work, and under which the third party grants, to any of the -parties who would receive the covered work from you, a discriminatory -patent license (a) in connection with copies of the covered work -conveyed by you (or copies made from those copies), or (b) primarily -for and in connection with specific products or compilations that -contain the covered work, unless you entered into that arrangement, -or that patent license was granted, prior to 28 March 2007. - - Nothing in this License shall be construed as excluding or limiting -any implied license or other defenses to infringement that may -otherwise be available to you under applicable patent law. - - 12. No Surrender of Others' Freedom. - - If conditions are imposed on you (whether by court order, agreement or -otherwise) that contradict the conditions of this License, they do not -excuse you from the conditions of this License. If you cannot convey a -covered work so as to satisfy simultaneously your obligations under this -License and any other pertinent obligations, then as a consequence you may -not convey it at all. For example, if you agree to terms that obligate you -to collect a royalty for further conveying from those to whom you convey -the Program, the only way you could satisfy both those terms and this -License would be to refrain entirely from conveying the Program. - - 13. Remote Network Interaction; Use with the GNU General Public License. - - Notwithstanding any other provision of this License, if you modify the -Program, your modified version must prominently offer all users -interacting with it remotely through a computer network (if your version -supports such interaction) an opportunity to receive the Corresponding -Source of your version by providing access to the Corresponding Source -from a network server at no charge, through some standard or customary -means of facilitating copying of software. This Corresponding Source -shall include the Corresponding Source for any work covered by version 3 -of the GNU General Public License that is incorporated pursuant to the -following paragraph. - - Notwithstanding any other provision of this License, you have -permission to link or combine any covered work with a work licensed -under version 3 of the GNU General Public License into a single -combined work, and to convey the resulting work. The terms of this -License will continue to apply to the part which is the covered work, -but the work with which it is combined will remain governed by version -3 of the GNU General Public License. - - 14. Revised Versions of this License. - - The Free Software Foundation may publish revised and/or new versions of -the GNU Affero General Public License from time to time. Such new versions -will be similar in spirit to the present version, but may differ in detail to -address new problems or concerns. - - Each version is given a distinguishing version number. If the -Program specifies that a certain numbered version of the GNU Affero General -Public License "or any later version" applies to it, you have the -option of following the terms and conditions either of that numbered -version or of any later version published by the Free Software -Foundation. If the Program does not specify a version number of the -GNU Affero General Public License, you may choose any version ever published -by the Free Software Foundation. - - If the Program specifies that a proxy can decide which future -versions of the GNU Affero General Public License can be used, that proxy's -public statement of acceptance of a version permanently authorizes you -to choose that version for the Program. - - Later license versions may give you additional or different -permissions. However, no additional obligations are imposed on any -author or copyright holder as a result of your choosing to follow a -later version. - - 15. Disclaimer of Warranty. - - THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY -APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT -HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY -OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, -THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR -PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM -IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF -ALL NECESSARY SERVICING, REPAIR OR CORRECTION. - - 16. Limitation of Liability. - - IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING -WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MODIFIES AND/OR CONVEYS -THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY -GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE -USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF -DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD -PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS), -EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF -SUCH DAMAGES. - - 17. Interpretation of Sections 15 and 16. - - If the disclaimer of warranty and limitation of liability provided -above cannot be given local legal effect according to their terms, -reviewing courts shall apply local law that most closely approximates -an absolute waiver of all civil liability in connection with the -Program, unless a warranty or assumption of liability accompanies a -copy of the Program in return for a fee. - - END OF TERMS AND CONDITIONS - - How to Apply These Terms to Your New Programs - - If you develop a new program, and you want it to be of the greatest -possible use to the public, the best way to achieve this is to make it -free software which everyone can redistribute and change under these terms. - - To do so, attach the following notices to the program. It is safest -to attach them to the start of each source file to most effectively -state the exclusion of warranty; and each file should have at least -the "copyright" line and a pointer to where the full notice is found. - - - Copyright (C) - - This program is free software: you can redistribute it and/or modify - it under the terms of the GNU Affero General Public License as published by - the Free Software Foundation, either version 3 of the License, or - (at your option) any later version. - - This program 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 Affero General Public License for more details. - - You should have received a copy of the GNU Affero General Public License - along with this program. If not, see . - -Also add information on how to contact you by electronic and paper mail. - - If your software can interact with users remotely through a computer -network, you should also make sure that it provides a way for users to -get its source. For example, if your program is a web application, its -interface could display a "Source" link that leads users to an archive -of the code. There are many ways you could offer source, and different -solutions will be better for different programs; see section 13 for the -specific requirements. - - You should also get your employer (if you work as a programmer) or school, -if any, to sign a "copyright disclaimer" for the program, if necessary. -For more information on this, and how to apply and follow the GNU AGPL, see -. Index: icence/licence.txt =================================================================== --- licence/licence.txt (revision 23:6bbbd371e813) +++ (revision ) @@ -1,12 +1,0 @@ -Program UpozorneniEmailem (Upozornění emailem – Nezapomeň!) vydávám pod licencí: -GNU Affero General Public License, verze 3 - - viz agpl-3.0.txt - viz http://www.fsf.org/licensing/licenses/agpl-3.0.html - - -František Kučera - - http://frantovo.cz/blog - http://frantovo.cz/ - franta-hg@frantovo.cz Index: ql/schéma.sql =================================================================== --- sql/schéma.sql (revision 29:4b6ab4ba1a95) +++ (revision ) @@ -1,133 +1,0 @@ --- --- PostgreSQL database dump --- - --- Started on 2009-05-31 22:35:00 CEST - -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = off; -SET check_function_bodies = false; -SET client_min_messages = warning; -SET escape_string_warning = off; - --- --- TOC entry 10 (class 2615 OID 16788) --- Name: sqlvyukaaplikace; Type: SCHEMA; Schema: -; Owner: - --- - -CREATE SCHEMA sqlvyukaaplikace; - - -SET search_path = sqlvyukaaplikace, pg_catalog; - --- --- TOC entry 1579 (class 1259 OID 16797) --- Dependencies: 10 --- Name: historie_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: - --- - -CREATE SEQUENCE historie_seq - INCREMENT BY 1 - NO MAXVALUE - NO MINVALUE - CACHE 1; - - -SET default_tablespace = ''; - -SET default_with_oids = false; - --- --- TOC entry 1578 (class 1259 OID 16789) --- Dependencies: 1848 1849 10 --- Name: historie; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: --- - -CREATE TABLE historie ( - id numeric DEFAULT nextval('historie_seq'::regclass) NOT NULL, - datum timestamp with time zone DEFAULT now(), - sql text, - id_sezeni character varying(255), - ip_adresa character varying(255) -); - - --- --- TOC entry 1580 (class 1259 OID 16813) --- Dependencies: 10 --- Name: tip_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: - --- - -CREATE SEQUENCE tip_seq - INCREMENT BY 1 - NO MAXVALUE - NO MINVALUE - CACHE 1; - - --- --- TOC entry 1581 (class 1259 OID 16815) --- Dependencies: 1850 10 --- Name: tip; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: --- - -CREATE TABLE tip ( - id numeric DEFAULT nextval('tip_seq'::regclass) NOT NULL, - text character varying(512) NOT NULL -); - - --- --- TOC entry 1859 (class 0 OID 0) --- Dependencies: 1581 --- Name: TABLE tip; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - --- - -COMMENT ON TABLE tip IS 'Rady, tipy, odkazy a citáty… které budeme zobrazovat uživateli v náhodném pořadí.'; - - --- --- TOC entry 1860 (class 0 OID 0) --- Dependencies: 1581 --- Name: COLUMN tip.text; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - --- - -COMMENT ON COLUMN tip.text IS 'HTML text. Bude vložen do

odstavce

. → Pozor na validitu.'; - - --- --- TOC entry 1852 (class 2606 OID 16796) --- Dependencies: 1578 1578 --- Name: historie_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: --- - -ALTER TABLE ONLY historie - ADD CONSTRAINT historie_pk PRIMARY KEY (id); - - --- --- TOC entry 1854 (class 2606 OID 16823) --- Dependencies: 1581 1581 --- Name: tip_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: --- - -ALTER TABLE ONLY tip - ADD CONSTRAINT tip_pk PRIMARY KEY (id); - - --- --- TOC entry 1856 (class 2606 OID 16825) --- Dependencies: 1581 1581 --- Name: tip_uq; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: --- - -ALTER TABLE ONLY tip - ADD CONSTRAINT tip_uq UNIQUE (text); - - --- Completed on 2009-05-31 22:35:01 CEST - --- --- PostgreSQL database dump complete --- -