From 05cd10ac470512a35ac392856baabe8b0619add5 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Sun, 6 Sep 2020 12:06:53 +0200
Subject: Rev: 4678

---
 .../config/module-naplo/config-pl.php.example      |  4 ++++
 .../config/module-naplo/config-vmg.php.example     |  5 +++++
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 .../include/modules/naplo/export/kretaOrarend.php  | 25 +++++++++++++++++-----
 .../private/naplo/export/kretaOrarend-pre.php      | 14 +++++++++---
 .../www/skin/classic/module-naplo/html/base.phtml  |  8 +++----
 .../module-naplo/html/export/kretaOrarend.phtml    |  1 +
 7 files changed, 45 insertions(+), 14 deletions(-)

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-naplo/config/module-naplo/config-pl.php.example b/mayor-orig/mayor-naplo/config/module-naplo/config-pl.php.example
index 97988330..9a075903 100644
--- a/mayor-orig/mayor-naplo/config/module-naplo/config-pl.php.example
+++ b/mayor-orig/mayor-naplo/config/module-naplo/config-pl.php.example
@@ -137,6 +137,10 @@
     define('_JELES_ATLAG', 4.75);
     define('_JELES_LEGGYENGEBB_JEGY', 3);
 
+    // A kréta órarend exportban használt hetirend típusok a Kréta adatszótára szerint...
+    global $kretaHETIREND;
+    $kretaHETIREND = array(1 => 'A hét', 2 => 'B hét', 3 => 'Minden hét');
+
 */
 
 ?>
\ No newline at end of file
diff --git a/mayor-orig/mayor-naplo/config/module-naplo/config-vmg.php.example b/mayor-orig/mayor-naplo/config/module-naplo/config-vmg.php.example
index 1eb19228..ae181515 100644
--- a/mayor-orig/mayor-naplo/config/module-naplo/config-vmg.php.example
+++ b/mayor-orig/mayor-naplo/config/module-naplo/config-vmg.php.example
@@ -112,6 +112,11 @@
     define('_JELES_ATLAG', 4.75);
     define('_JELES_LEGGYENGEBB_JEGY', 3);
 
+    // A kréta órarend exportban használt hetirend típusok a Kréta adatszótára szerint...
+    global $kretaHETIREND;
+    $kretaHETIREND = array(1 => 'A hét', 2 => 'B hét', 3 => 'Minden hét');
+
+
 */
 
 ?>
\ No newline at end of file
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index d197bb6d..3c4089ce 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4675
+4678
diff --git a/mayor-orig/mayor-naplo/www/include/modules/naplo/export/kretaOrarend.php b/mayor-orig/mayor-naplo/www/include/modules/naplo/export/kretaOrarend.php
index 48cf5f52..0c458ea8 100644
--- a/mayor-orig/mayor-naplo/www/include/modules/naplo/export/kretaOrarend.php
+++ b/mayor-orig/mayor-naplo/www/include/modules/naplo/export/kretaOrarend.php
@@ -6,12 +6,23 @@
 
 	$lr = db_connect('naplo');
 	// orarendiOra - tankor
+	// Így több hetes órarend esetén mindent külön felvesz az egyes hetekre, nem használja a "Minden hétre" lehetőséget...
 	$q = "SELECT * from orarendiOra 
 		LEFT JOIN orarendiOraTankor USING (tanarId, targyJel, osztalyJel)
 		LEFT JOIN ".__INTEZMENYDBNEV.".terem USING (teremId)
+		WHERE orarendiOra.tolDt <= '%s' AND '%s' <= orarendiOra.igDt
 		ORDER BY tanarId, het, nap, ora";
-	$v = array();
-	$ADAT['orak'] = db_query($q, array('fv' => 'getOrarendAdat', 'result'=>'indexed','value'=>$v), $lr);
+	// A hetek összegét kérdezzük le, ez egy hetes órarend esetén nem változtat semmit
+	// Kéthetes órarendnél 1 -> A hét, 2 -> B hét, 1+2=3 -> Minden hét
+	// Más esetekben már nem lesz jó...
+	$q = "select sum(het) as het,nap,ora,tanarId,osztalyJel,targyJel,teremId,leiras,tankorId from orarendiOra
+		LEFT JOIN orarendiOraTankor USING (tanarId, targyJel, osztalyJel)
+		LEFT JOIN ".__INTEZMENYDBNEV.".terem USING (teremId)
+		WHERE orarendiOra.tolDt <= '%s' AND '%s' <= orarendiOra.igDt
+		group by nap,ora,tanarId,osztalyJel,targyJel,teremId,leiras,tankorId
+		ORDER BY tanarId, het, nap, ora";
+	$v = array($ADAT['dt'], $ADAT['dt']);
+	$ADAT['orak'] = db_query($q, array('fv' => 'getOrarendAdat', 'result'=>'indexed','values'=>$v), $lr);
 	$q = "SELECT tankorId, tankorNev, targyNev, kretaTargyNev, csoportNev FROM ".__INTEZMENYDBNEV.".tankor 
 		LEFT JOIN ".__INTEZMENYDBNEV.".tankorSzemeszter USING (tankorId) 
 		LEFT JOIN ".__INTEZMENYDBNEV.".targy USING (targyId)
@@ -20,14 +31,18 @@
 		WHERE tanev=".__TANEV." AND szemeszter=1";
 
 	$v = array();
-	$ADAT['tankor'] = db_query($q, array('fv' => 'getOrarendAdat/tankor', 'result'=>'assoc','keyfield'=>'tankorId','value'=>$v), $lr);
+	$ADAT['tankor'] = db_query($q, array('fv' => 'getOrarendAdat/tankor', 'result'=>'assoc','keyfield'=>'tankorId','values'=>$v), $lr);
 	foreach ($ADAT['tankor'] as $_tankorId => $T) {
 	    $M = explode(' ', $T['csoportNev']);
 
 
-	    if (strpos($T['csoportNev'],',') !== false) $ADAT['t2osztaly'][$_tankorId] = '';
+	    // Ha van a csoportnévben vessző vagy aláhúzás, akkor több osztályhoz tartozik, 
+	    // pl: "9.a, 9.b tnf", "11. inf_A", "12.inf_E"
+	    if (strpos($T['csoportNev'],',') !== false || strpos($T['csoportNev'],'_') !== false) $ADAT['t2osztaly'][$_tankorId] = '';
 	    else $ADAT['t2osztaly'][$_tankorId] = $M[0];
-
+	    // Ha nincs benne szóköz és aláhúzás sem, akkor egy osztály jele valójában a MaYoR csoportnév 
+	    // csoportot jelöl pl:	"12.inf_E", "9.a csop1", "7.a, 7.b tnl"
+	    // osztályt jelöl pl: 	"8.b"
 	    if (strpos($T['csoportNev'],' ') === false && strpos($T['csoportNev'],'_') === false) $ADAT['t2csoport'][$_tankorId] = '';
 	    else $ADAT['t2csoport'][$_tankorId] = $T['csoportNev'];
 	}
diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend-pre.php
index 65b52e40..b9af3e72 100644
--- a/mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend-pre.php
+++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend-pre.php
@@ -12,7 +12,8 @@
 	Helyiség: 		a tanóra helyisége (ha nincs ilyen nevű helyiség a rendszerben, akkor ez rögzítésre kerül)
 
 
-	- A Heti rend - a config_xyz.php-ben: felsorolja az orarendiHet --> Kréta "Hetirend" típusú adatszótárának elemeit
+	- A Heti rend - a config_xyz.php-ben: $kretaHETIREND felsorolja az orarendiHet --> Kréta "Hetirend" típusú adatszótárának elemeit
+	    a lekérdezés a hetek összegét veszi: 1 --> A hét, 2 --> B hét, 1+2=3 --> Minden hét
 	- Minden tárgynál be van írva a kretaTargyNev
 	- Feltételezzük, hogy minden tankör pontosan egy csoportba tartozik bele, s a csoportok a Kréta csoportoknak/osztályoknak megfelelők
 	- A csoportok elnevezésében feltételezések:
@@ -32,11 +33,11 @@ if (!__NAPLOADMIN && !__VEZETOSEG) {
     require_once('include/modules/naplo/share/targy.php');
     require_once('include/modules/naplo/share/file.php');
 
+    $dt = $ADAT['dt'] = readVariable($_POST['dt'], 'date');
     if ($action == "kretaOrarendExport") {
 	$ADAT['tanar'] = getTanarok(array('result'=>'assoc'));
 	$ADAT['export'] = getOrarendAdat($ADAT);
     
-
         $ADAT['formatum'] = readVariable($_POST['formatum'], 'enum', null, array('csv','ods','xml'));
         if ($ADAT['formatum'] == 'xml') $ADAT['mime'] = 'application/vnd.ms-excel';
         if (isset($ADAT['formatum'])) {
@@ -48,6 +49,13 @@ if (!__NAPLOADMIN && !__VEZETOSEG) {
 
     }
 
-
+        $TOOL['datumSelect'] = array(
+            'tipus'=>'sor', 'post'=>array('formatum'),
+            'paramName' => 'dt', 
+            'tolDt' => date('Y-m-d', strtotime('last Monday', strtotime($_TANEV['kezdesDt']))),
+            'igDt' => $_TANEV['zarasDt'],
+            'override' => true
+        );
+	getToolParameters();
 
 }
diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/base.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/base.phtml
index cd9ec7cc..0c5f7937 100644
--- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/base.phtml
+++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/base.phtml
@@ -3,7 +3,6 @@
     if (_RIGHTS_OK !== true) die();
 
     require_once('include/share/date/names.php');
-
     if (_RUNLEVEL!=='cron') putEszkozSor();
 
     function putUjIntezmeny() {
@@ -61,10 +60,11 @@
 	    if ($showHelp) echo '<span id="toolBarHelpButton" class="onClickHideShow">?</span>';
 	echo '</td>'."\n";
 	reset($TOOL); 
-	foreach ( $TOOL as $tool => $params ) {
 
+	foreach ( $TOOL as $tool => $params ) {
 //	    if ( function_exists( $func = "put$tool" ) && $params['tipus']=='cella') {
 	    if ( isset($params['tipus']) && $params['tipus']=='cella') {
+
 		if (isset($params['title'])) $title = '__'.$params['title'];
 		else $title = '__'.nagybetus($tool).'TITLE';
 
@@ -274,9 +274,8 @@
     }
 
     function putForrasSelect() {
-
 	global $TOOL;
-	putToolFormStart('forrasSelect');
+	putToolFormStart('forrasSelect','forras');
 	    echo '<select name="'.$TOOL['forrasSelect']['paramName'].'" class="onChangeSubmit">';
 		echo '<option value=""> - </option>'."\n";
 		$SEL = array($TOOL['forrasSelect']['paramValue'] => ' selected="selected" ');
@@ -285,7 +284,6 @@
 		}
 	    echo '</select>';
 	putToolFormStop();
-
     }
 
     function putIntezmenySelect() {
diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/export/kretaOrarend.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/export/kretaOrarend.phtml
index 7ffeccad..c1d40d25 100644
--- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/export/kretaOrarend.phtml
+++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/export/kretaOrarend.phtml
@@ -4,6 +4,7 @@
 
         formBegin(array('action'=>href('index.php?page=naplo&sub=export&f=kretaOrarend'), 'class'=>"export"));
         echo '<input type="hidden" name="action" value="kretaOrarendExport" />'."\n";
+	echo '<input type="hidden" name="dt" value="'.$ADAT['dt'].'" />'."\n";
 
         echo '<fieldset><legend>Kréta - Órarend export</legend>'."\n";
         echo '<table>'."\n";
-- 
cgit v1.2.3


From 847eb4a21606966ac5573c6ed6df878eff93841a Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Thu, 10 Sep 2020 13:20:03 +0200
Subject: Rev: 4680

---
 mayor-orig/mayor-base/log/mayor-base.rev           |  2 +-
 .../www/include/backend/ads/session/base.php       |  2 +-
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |  2 +-
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |  2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |  2 +-
 .../log/mayor-installer-sulix.rev                  |  2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |  2 +-
 .../log/mayor-locales-de_DE.rev                    |  2 +-
 .../log/mayor-locales-en_US.rev                    |  2 +-
 .../log/mayor-locales-jp_JP.rev                    |  2 +-
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 .../policy/private/naplo/intezmeny/osztaly-pre.php | 15 ++++++++++++-
 .../www/policy/private/naplo/intezmeny/osztaly.php |  5 ++++-
 .../module-naplo/html/intezmeny/osztaly.phtml      | 21 +++++++++++++++++
 mayor-orig/mayor-portal/log/mayor-portal.rev       |  2 +-
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |  2 +-
 mayor-orig/md5sum                                  | 26 +++++++++++-----------
 mayor-orig/rev.txt                                 |  2 +-
 rev.txt                                            |  2 +-
 19 files changed, 67 insertions(+), 30 deletions(-)

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-base/www/include/backend/ads/session/base.php b/mayor-orig/mayor-base/www/include/backend/ads/session/base.php
index 3a727c3b..edb47858 100644
--- a/mayor-orig/mayor-base/www/include/backend/ads/session/base.php
+++ b/mayor-orig/mayor-base/www/include/backend/ads/session/base.php
@@ -138,7 +138,7 @@
 
 	$userDn = ADSuserAccountToDn($userAccount, $toPolicy);
 	if (in_array($group, $AUTH[$toPolicy]['categories'])) {
-	    if (strpos($userDn, ',ou='.ekezettelen($group).',') !== false) return true;
+	    if (strpos(kisbetus($userDn), ',ou='.ekezettelen($group).',') !== false) return true;
 # Ha nincs megfelelő ou-ban, akkor nézzük a csoport tagságot - így berakható időszakosan akárki pl a titkárság kategóriába...
 #	    else return false;
 	}
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php
index 9222a0c8..62d0f384 100644
--- a/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php
+++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php
@@ -19,6 +19,7 @@ require_once('include/modules/naplo/share/tankorDiakModifier.php');
 require_once('include/modules/naplo/share/hianyzasModifier.php');
 require_once('include/modules/naplo/share/jegyModifier.php');
 require_once('include/modules/naplo/share/jegy.php');
+require_once('include/modules/naplo/share/kereso.php');
 require_once('include/share/net/upload.php');
 
 define('FILE_UPLOAD_DIR',_DOWNLOADDIR.'/private/naplo/upload/');
@@ -116,7 +117,19 @@ if (isset($osztalyId)) {
 	$ADAT['diakok'] = getDiakok(array('tanev' => $tanev));
 }
 
-if ($action == 'osztalyAdatModositas' && __NAPLOADMIN) {
+
+if ($action == 'oidEllenor' && __NAPLOADMIN===true) {
+
+    // --TODO
+    $_re = str_replace(' ',"\n",str_replace('\r','\n',$_POST['oidtxt']));
+    $oidxp = explode("\n",str_replace(' ',"\n",str_replace('\r','\n',$_POST['oidtxt'])));
+    $ADAT['oidtxt'] = $_re;
+    for($i=0; $i<count($oidxp); $i++) {
+	$_oid = $oidxp[$i];
+        $ADAT['oidCheck'][$_oid] = getDiakokByPattern($_oid);
+    }
+
+} elseif ($action == 'osztalyAdatModositas' && __NAPLOADMIN) {
 
 	$leiras = readVariable($_POST['leiras'], 'string');
 	$ofoTanarId = readVariable($_POST['ofoTanarId'], 'id');
diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly.php
index 20ca97a5..a1c51b8c 100644
--- a/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly.php
+++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly.php
@@ -12,7 +12,8 @@
 
 	// Osztályhoz rendelés
 	if (isset($ADAT['osztalyId']) && ($ADAT['osztalyAdat']["kezdoTanev"]<=$ADAT['tanev'] && $ADAT['osztalyAdat']["vegzoTanev"]>=$ADAT['tanev'])) {
-		
+	
+
 	    putOsztalyAdatokForm($ADAT);
 
 	    if ($ADAT['osztalyJellegek'][ $ADAT['osztalyAdat']['osztalyJellegId'] ]['kovOsztalyJellegId'] != 0) { // NyEK évfolyam
@@ -24,6 +25,8 @@
     	    }
     	    putUjTagForm($ADAT);
 
+	    if (__NAPLOADMIN ===true) putOidEllenor($ADAT);
+
 	    if (__NAPLOADMIN) {
     		if ($fileName == '') {
             	    putFileSelectForm('naplo_intezmeny:diak',array('osztalyId','tanev'));
diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/osztaly.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/osztaly.phtml
index b476482c..44af95fb 100644
--- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/osztaly.phtml
+++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/osztaly.phtml
@@ -423,5 +423,26 @@ function putOsztalyJellegek($ADAT,$osztalyJellegId) {
 
 }
 
+function putOidEllenor($ADAT) {
+
+	formBegin(array('class'=>'osztalyForm'));
+	echo '<input type="hidden" name="action" value="oidEllenor" />';
+	echo '<input type="hidden" name="osztalyId" value="'.$ADAT['osztalyId'].'" />';
+	echo '<input type="hidden" name="osztalyId" value="'.$ADAT['osztalyId'].'" />';
+
+	echo '<h1>'._OIDELLENOR.'</h1>';
+	
+	var_dump($ADAT['oidCheck']);
+
+	echo '<textarea name="oidtxt" rows="10">';
+	    echo $ADAT['oidtxt'];
+	echo '</textarea>';
+
+	echo '<br/><input type="submit" value="'._OK.'" />';
+
+	formEnd();
+
+}
+
 
 ?>
\ No newline at end of file
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4678
+4680
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index ceb87b49..a4b66494 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4678
-ae37f4627dc0b9d59b8f7d02f6a36567  mayor-fenntarto-rev4678.tgz
-8701623ef3593718cdc4e916cb9beb45  mayor-installer-sulix-rev4678.tgz
-67af2c56005638e1e987413d22429ac0  mayor-wiki-rev4678.tgz
-2d9568b5e406bb195ad41b8a17616445  mayor-installer-rev4678.tgz
-9cbef6c69c497940efaf9b32a7c9d542  mayor-portal-rev4678.tgz
-b7e19d4216b5bab9f6e3d39f88b96eb4  mayor-felveteli-rev4678.tgz
-2aece1e47be886e15341154afc3ef82f  mayor-jatek-rev4678.tgz
-0a1e9519b2c195ad2cfd53698e1edd83  mayor-locales-jp_JP-rev4678.tgz
-17b9730d7e0766198c0f0d536fda000d  mayor-locales-de_DE-rev4678.tgz
-0a6684550a20f620b6e590feed384d68  mayor-locales-en_US-rev4678.tgz
-417c3c4ec00fe453667175ed3b0dd435  mayor-naplo-rev4678.tgz
-8f7e80787a56704f86db4101ad727229  mayor-base-rev4678.tgz
+Revision 4680
+2adbe6892159370933630427685df89c  mayor-fenntarto-rev4680.tgz
+d12171381221c6da70355cac5edd40db  mayor-installer-sulix-rev4680.tgz
+a927f2c159b6967bbe164d62093eb29d  mayor-wiki-rev4680.tgz
+573f950dc80937ac4ef84925395124bc  mayor-installer-rev4680.tgz
+d8331f6f3fab928c0b63fd81f6d96c80  mayor-portal-rev4680.tgz
+1922b6d82fd3442a2302f236db7762d2  mayor-felveteli-rev4680.tgz
+eaf37db5261e944960739a8189c683d4  mayor-jatek-rev4680.tgz
+75a0246fda3ebfcf818f2d37b2ee252c  mayor-locales-jp_JP-rev4680.tgz
+a2c562ba77ded498a38be164592d1cf9  mayor-locales-de_DE-rev4680.tgz
+eb8c5997b1bf68d17e70684ed41ad2d0  mayor-locales-en_US-rev4680.tgz
+4cd73545ae83ce4a2ec4ead62d793813  mayor-naplo-rev4680.tgz
+4e0e32b4ec5359c77b50748e5a805de6  mayor-base-rev4680.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index 3c4089ce..e9f0a693 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4678
+4680
diff --git a/rev.txt b/rev.txt
index 3c4089ce..e9f0a693 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4678
+4680
-- 
cgit v1.2.3


From dc2b3d12c866d02833def3704cbb0725e04ca7a1 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Thu, 10 Sep 2020 13:45:03 +0200
Subject: Rev: 4681

---
 mayor-orig/mayor-base/log/mayor-base.rev           |  2 +-
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |  2 +-
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |  2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |  2 +-
 .../log/mayor-installer-sulix.rev                  |  2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |  2 +-
 .../log/mayor-locales-de_DE.rev                    |  2 +-
 .../log/mayor-locales-en_US.rev                    |  2 +-
 .../log/mayor-locales-jp_JP.rev                    |  2 +-
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 .../policy/private/naplo/intezmeny/osztaly-pre.php |  2 +-
 .../module-naplo/html/intezmeny/osztaly.phtml      | 22 ++++++++++++++++--
 mayor-orig/mayor-portal/log/mayor-portal.rev       |  2 +-
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |  2 +-
 mayor-orig/md5sum                                  | 26 +++++++++++-----------
 mayor-orig/rev.txt                                 |  2 +-
 rev.txt                                            |  2 +-
 17 files changed, 48 insertions(+), 30 deletions(-)

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php
index 62d0f384..0acd5f0f 100644
--- a/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php
+++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php
@@ -125,7 +125,7 @@ if ($action == 'oidEllenor' && __NAPLOADMIN===true) {
     $oidxp = explode("\n",str_replace(' ',"\n",str_replace('\r','\n',$_POST['oidtxt'])));
     $ADAT['oidtxt'] = $_re;
     for($i=0; $i<count($oidxp); $i++) {
-	$_oid = $oidxp[$i];
+	$_oid = trim($oidxp[$i]);
         $ADAT['oidCheck'][$_oid] = getDiakokByPattern($_oid);
     }
 
diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/osztaly.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/osztaly.phtml
index 44af95fb..01a9b0d8 100644
--- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/osztaly.phtml
+++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/osztaly.phtml
@@ -432,8 +432,26 @@ function putOidEllenor($ADAT) {
 
 	echo '<h1>'._OIDELLENOR.'</h1>';
 	
-	var_dump($ADAT['oidCheck']);
-
+	if (is_array($ADAT['oidCheck'])) {
+	    echo '<table>';
+	    foreach($ADAT['oidCheck'] as $oId=>$DA) {
+	      for ($i=0; $i<count($DA); $i++) {
+		$D = $DA[$i];
+		echo '<tr>';
+		echo '<td>'.$oId.'</td>';
+		echo '<td class="diakAdat diakNev" data-diakid="'.$D['diakId'].'">'.$D['diakId'].'</td>';
+		echo '<td class="diakAdat diakNev" data-diakid="'.$D['diakId'].'">'.$D['diakNev'].'</td>';
+		echo '<td>'.$D['oId'].'</td>';
+		echo '<td>';
+		    if ($ADAT['osztalyAdat']['osztalyJel']!=$D['osztalyJel']) {echo '!!!!!!!';}
+		    //echo '72455076207';
+		    echo $D['osztalyJel'];
+		echo '</td>';
+		echo '</tr>';
+	      }
+	    }
+	    echo '</table>';
+	}
 	echo '<textarea name="oidtxt" rows="10">';
 	    echo $ADAT['oidtxt'];
 	echo '</textarea>';
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index e9f0a693..ee67738f 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4680
+4681
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index a4b66494..7c9ee0ee 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4680
-2adbe6892159370933630427685df89c  mayor-fenntarto-rev4680.tgz
-d12171381221c6da70355cac5edd40db  mayor-installer-sulix-rev4680.tgz
-a927f2c159b6967bbe164d62093eb29d  mayor-wiki-rev4680.tgz
-573f950dc80937ac4ef84925395124bc  mayor-installer-rev4680.tgz
-d8331f6f3fab928c0b63fd81f6d96c80  mayor-portal-rev4680.tgz
-1922b6d82fd3442a2302f236db7762d2  mayor-felveteli-rev4680.tgz
-eaf37db5261e944960739a8189c683d4  mayor-jatek-rev4680.tgz
-75a0246fda3ebfcf818f2d37b2ee252c  mayor-locales-jp_JP-rev4680.tgz
-a2c562ba77ded498a38be164592d1cf9  mayor-locales-de_DE-rev4680.tgz
-eb8c5997b1bf68d17e70684ed41ad2d0  mayor-locales-en_US-rev4680.tgz
-4cd73545ae83ce4a2ec4ead62d793813  mayor-naplo-rev4680.tgz
-4e0e32b4ec5359c77b50748e5a805de6  mayor-base-rev4680.tgz
+Revision 4681
+15c2a2e023f8d05716b1baed93973bdc  mayor-fenntarto-rev4681.tgz
+46aa3cf4b5efa5ee0ca4cf78d8cc1eaf  mayor-installer-sulix-rev4681.tgz
+a014e0b2366869b03f60954498f55e63  mayor-wiki-rev4681.tgz
+754361c37b37ae4cc9cf9e6f8d647c7d  mayor-installer-rev4681.tgz
+4d879e5cf7746acd5f12d84bee8717a8  mayor-portal-rev4681.tgz
+393e2c0e36081ba94e8b547b6ed03a7c  mayor-felveteli-rev4681.tgz
+8b4e6e23d43ffba1a2e351200a03fd47  mayor-jatek-rev4681.tgz
+b42789275534e1b605ce8611fef58534  mayor-locales-jp_JP-rev4681.tgz
+af3e34234540ba2adddd58bb844e8baa  mayor-locales-de_DE-rev4681.tgz
+77483820d31eab179c30146544683ccf  mayor-locales-en_US-rev4681.tgz
+76f0f3df73e4fc536bd2075e5ecfb5d7  mayor-naplo-rev4681.tgz
+456ef5dcce3b8420acceff4170d38ff7  mayor-base-rev4681.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index e9f0a693..ee67738f 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4680
+4681
diff --git a/rev.txt b/rev.txt
index e9f0a693..ee67738f 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4680
+4681
-- 
cgit v1.2.3


From 4151aba7656fb165c54f9b77553ce96f75a52d51 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Tue, 22 Sep 2020 14:30:03 +0200
Subject: Rev: 4683

---
 mayor-orig/mayor-base/log/mayor-base.rev           |  2 +-
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |  2 +-
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |  2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |  2 +-
 .../log/mayor-installer-sulix.rev                  |  2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |  2 +-
 .../log/mayor-locales-de_DE.rev                    |  2 +-
 .../log/mayor-locales-en_US.rev                    |  2 +-
 .../log/mayor-locales-jp_JP.rev                    |  2 +-
 .../install/module-naplo/mysql/intezmeny.sql       | 12 +++++-----
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 .../mayor-naplo/update/pre004682-1-intezmeny.sql   | 17 ++++++++++++++
 mayor-orig/mayor-portal/log/mayor-portal.rev       |  2 +-
 .../classic/module-portal/html/hirek/egyhir.phtml  |  8 +++++++
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |  2 +-
 mayor-orig/md5sum                                  | 26 +++++++++++-----------
 mayor-orig/rev.txt                                 |  2 +-
 rev.txt                                            |  2 +-
 18 files changed, 58 insertions(+), 33 deletions(-)
 create mode 100644 mayor-orig/mayor-naplo/update/pre004682-1-intezmeny.sql

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql b/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql
index 1912a862..8254eb20 100644
--- a/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql
+++ b/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql
@@ -68,10 +68,10 @@ CREATE TABLE `telephely` (
 
 CREATE TABLE `szulo` (
   `szuloId` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `nevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
+  `nevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '',
   `csaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
   `utonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
-  `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
+  `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '',
   `szuleteskoriCsaladinev` varchar(32) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
   `szuleteskoriUtonev` varchar(32) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
   `nem` enum('fiú','lány') COLLATE utf8_hungarian_ci DEFAULT NULL,
@@ -102,10 +102,10 @@ CREATE TABLE `diak` (
   `adoazonosito` bigint(10) unsigned zerofill DEFAULT NULL,
   `szemelyiIgazolvanySzam` varchar(16) COLLATE utf8_hungarian_ci DEFAULT NULL,
   `tartozkodasiOkiratSzam` varchar(16) COLLATE utf8_hungarian_ci DEFAULT NULL,
-  `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
+  `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '',
   `viseltCsaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
   `viseltUtonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
-  `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
+  `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '',
   `szuleteskoriCsaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
   `szuleteskoriUtonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
   `szuletesiHely` varchar(32) COLLATE utf8_hungarian_ci DEFAULT NULL,
@@ -263,7 +263,7 @@ CREATE TABLE `tanar` (
   `oId` bigint(20) unsigned DEFAULT NULL,
   `beDt` date DEFAULT NULL,
   `kiDt` date DEFAULT NULL,
-  `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT NULL,
+  `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '',
   `viseltCsaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
   `viseltUtonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
   `szuletesiHely` varchar(16) COLLATE utf8_hungarian_ci DEFAULT NULL,
@@ -271,7 +271,7 @@ CREATE TABLE `tanar` (
   `dn` varchar(128) COLLATE utf8_hungarian_ci DEFAULT NULL,
   `szuleteskoriUtonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
   `szuleteskoriCsaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
-  `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
+  `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '',
   `hetiMunkaora` decimal(3,1) DEFAULT '0.0',
   `NEKAzonosito` varchar(16) COLLATE utf8_hungarian_ci DEFAULT NULL,
   `statusz` enum('határozatlan idejű','határozott idejű','tartósan távol','jogviszonya lezárva','külső óraadó') COLLATE utf8_hungarian_ci DEFAULT 'határozatlan idejű',
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-naplo/update/pre004682-1-intezmeny.sql b/mayor-orig/mayor-naplo/update/pre004682-1-intezmeny.sql
new file mode 100644
index 00000000..121f2c88
--- /dev/null
+++ b/mayor-orig/mayor-naplo/update/pre004682-1-intezmeny.sql
@@ -0,0 +1,17 @@
+DELIMITER $$
+DROP PROCEDURE IF EXISTS upgrade_database_4682 $$
+
+CREATE PROCEDURE upgrade_database_4682()
+BEGIN
+SET NAMES utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE `tanar` MODIFY `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '';
+ALTER TABLE `tanar` MODIFY `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '';
+ALTER TABLE `szulo` MODIFY `nevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '';
+ALTER TABLE `szulo` MODIFY `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '';
+ALTER TABLE `diak` MODIFY `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '';
+ALTER TABLE `diak` MODIFY `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '';
+
+END $$
+DELIMITER ;
+CALL upgrade_database_4682();
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
index c75b2756..afebf8bc 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
@@ -27,6 +27,7 @@
 	formBegin();
 
 	    if (__HIREKADMIN===true) {
+		    echo '<script src="//cdn.ckeditor.com/4.14.0/standard/ckeditor.js"></script>';
 
 		    echo '<table class="egyhirdetail" cellspacing="1">';
 		    echo '<tr><th colspan="3">'._BEALLITASOK.'</th></tr>';
@@ -135,6 +136,13 @@
 	
 	echo '</div>';
 
+	echo '<script type="text/javascript">';
+	echo "
+   CKEDITOR.replace('txt', {
+      uiColor: '#eeeeee'
+    });
+";
+	echo '</script>';
 
 	if (__HIREKADMIN===true) {
 	echo '<hr/>';
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index ee67738f..44f34c74 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4681
+4683
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index 7c9ee0ee..b0ed190b 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4681
-15c2a2e023f8d05716b1baed93973bdc  mayor-fenntarto-rev4681.tgz
-46aa3cf4b5efa5ee0ca4cf78d8cc1eaf  mayor-installer-sulix-rev4681.tgz
-a014e0b2366869b03f60954498f55e63  mayor-wiki-rev4681.tgz
-754361c37b37ae4cc9cf9e6f8d647c7d  mayor-installer-rev4681.tgz
-4d879e5cf7746acd5f12d84bee8717a8  mayor-portal-rev4681.tgz
-393e2c0e36081ba94e8b547b6ed03a7c  mayor-felveteli-rev4681.tgz
-8b4e6e23d43ffba1a2e351200a03fd47  mayor-jatek-rev4681.tgz
-b42789275534e1b605ce8611fef58534  mayor-locales-jp_JP-rev4681.tgz
-af3e34234540ba2adddd58bb844e8baa  mayor-locales-de_DE-rev4681.tgz
-77483820d31eab179c30146544683ccf  mayor-locales-en_US-rev4681.tgz
-76f0f3df73e4fc536bd2075e5ecfb5d7  mayor-naplo-rev4681.tgz
-456ef5dcce3b8420acceff4170d38ff7  mayor-base-rev4681.tgz
+Revision 4683
+5ab848461fcb7c8f0e675e0ba565dfb6  mayor-fenntarto-rev4683.tgz
+acab3f4d1dc57153e4737352e0b2513e  mayor-installer-sulix-rev4683.tgz
+67c861aee289395a3cb38590d67ce66a  mayor-wiki-rev4683.tgz
+6f0f8a265ca71ed5eedd44b33856b3b0  mayor-installer-rev4683.tgz
+f1d56379fd6d7ac8086be051d95e4da5  mayor-portal-rev4683.tgz
+e37c44fb0101398b91fe7c3371399672  mayor-felveteli-rev4683.tgz
+0eff173e22c1dbdb55b53f65eecbaf94  mayor-jatek-rev4683.tgz
+b2c987867d7f4b0c5e2cb6727ec3c9b7  mayor-locales-jp_JP-rev4683.tgz
+11dd8efcac7603550dd6db72476e2a26  mayor-locales-de_DE-rev4683.tgz
+180cebdc87e92c057e8870d8f3b77b91  mayor-locales-en_US-rev4683.tgz
+1d142f81e335acfe4a50fe626a6c864a  mayor-naplo-rev4683.tgz
+7a2430870a191b80dc09cba2322b4b0d  mayor-base-rev4683.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index ee67738f..44f34c74 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4681
+4683
diff --git a/rev.txt b/rev.txt
index ee67738f..44f34c74 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4681
+4683
-- 
cgit v1.2.3


From a5ac3d0ab4015ed2683706cd0677ce6ce159f0ed Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Wed, 21 Oct 2020 20:35:04 +0200
Subject: Rev: 4691

---
 mayor-orig/mayor-base/log/mayor-base.rev           |   2 +-
 mayor-orig/mayor-base/www/include/base/mysql.php   |   4 +-
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |   2 +-
 .../www/static/hu_HU/felveteli/felveteli.2020.html | 107 +++++++++++++++++++++
 .../www/static/hu_HU/felveteli/felveteli.html      | 105 +-------------------
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |   2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |   2 +-
 .../log/mayor-installer-sulix.rev                  |   2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |   2 +-
 .../log/mayor-locales-de_DE.rev                    |   2 +-
 .../log/mayor-locales-en_US.rev                    |   2 +-
 .../log/mayor-locales-jp_JP.rev                    |   2 +-
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |   2 +-
 mayor-orig/mayor-portal/log/mayor-portal.rev       |   2 +-
 .../www/policy/private/portal/portal/portal.php    |   1 +
 .../classic/module-portal/html/hirek/egyhir.phtml  |   5 +-
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |   2 +-
 mayor-orig/md5sum                                  |  26 ++---
 mayor-orig/rev.txt                                 |   2 +-
 rev.txt                                            |   2 +-
 20 files changed, 144 insertions(+), 132 deletions(-)
 create mode 100644 mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.2020.html

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-base/www/include/base/mysql.php b/mayor-orig/mayor-base/www/include/base/mysql.php
index 819fdcd0..e4322dc8 100644
--- a/mayor-orig/mayor-base/www/include/base/mysql.php
+++ b/mayor-orig/mayor-base/www/include/base/mysql.php
@@ -91,11 +91,11 @@
 			mysqli_set_charset($lr, "utf8");
 			mysqli_query($lr, "SET NAMES utf8");
 			mysqli_query($lr, "SET collation_connection='utf8_hungarian_ci'");
-			mysqli_query($lr, "SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))");
+			mysqli_query($lr, "SET SESSION sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''),'NO_ZERO_DATE',''))");
 		    } else {
 			mysql_query("SET NAMES utf8", $lr);
 			mysql_query("SET collation_connection='utf8_hungarian_ci'", $lr);
-                        mysql_query("SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))", $lr);
+                        mysql_query("SET SESSION sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''),'NO_ZERO_DATE',''))", $lr);
 		    }
 		} else {
 		    $_SESSION['alert'][] = "message:sql_select_db_failure:db_connect/${SET['fv']}:$modul:".$MYSQL_DATA[$modul]['db'];
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.2020.html b/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.2020.html
new file mode 100644
index 00000000..13dd5cfa
--- /dev/null
+++ b/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.2020.html
@@ -0,0 +1,107 @@
+<div class="felveteli">
+<h1>Középiskolai felvételi</h1>
+<h2>2020/2021-es tanév</h2>
+
+<div style="margin-top: 6px; text-align:center;">
+  <a style="font-weight: bold; font-size: 16px; color: #837389;" href="/vmg/felveteli/FT2020.pdf">
+    Felvételi Tájékoztató 2020/2021 [PDF]
+  </a>
+</div>
+<!--
+<h3>Gyakran Ismételt Kérdések</h3>
+<p>
+<ul>
+<li><a class="gyik" href="index.php?page=felveteli&f=felveteli-gyik">Gy.I.K.</a></li>
+<li><a href="index.php?page=felveteli&f=pontszamito">Pontszámító Kalkulátor</a></li>
+</ul>
+</p>
+-->
+<h3>Letölthető dokumentumok</h3>
+<ul>
+<li>
+<a href="/vmg/felveteli/FT2020.pdf">A Városmajori Gimnázium Felvételi Tájékoztatója 2020/2021</a> (.pdf)
+</li><li style="">
+<a href="https://www.oktatas.hu/kozneveles/kozepfoku_felveteli_eljaras/kozepfoku_felveteli_eljaras_informacioi">
+Oktatási Hivatal Tájékoztatója a középfokú beiskolázási határidőkről, időpontokról
+</a> (oktatas.hu)</li>
+</ul>
+
+<h3>Fontos dátumok</h3>
+
+<dl>
+<dt  >2019. október 17.</dt>
+<dd  >
+A felvételi tájékoztató megjelenése.
+</dd>
+
+ <dt  >2019. november 11. 18:00 </dt>
+ <dd  >Tájékoztató értekezletet a felvételi eljárás rendjéről, induló osztályokról</dd>
+
+ <dt >2019. november 11-15.</dt>
+ <dd>Iskola bemutatkozás és nyílt órák (előzetes jelentkezéssel!)</dd>
+
+ <dt  >2019. december 6.<code class="hatarido icon-time"></code></dt>
+ <dd  >Jelentkezési határidő az egységes követelmények szerint tartott
+ a felvételi eljárást megelőző írásbeli felvételi vizsgára.
+ </dd>
+
+ <dt  >2020. január 18. 10<sup>00</sup> <code class="icon-child"></code></dt>
+ <dd  >Írásbeli felvételi vizsgák az érintett 6 évfolyamos gimnáziumokban. (2x45 perc) </dd>
+
+ <dt  >2020. január 18. 10<sup>00</sup> <code class="icon-child"></code></dt>
+ <dd  >Írásbeli felvételi a nyolcadik évfolyamok számára a felvételi eljárást 
+ megelőző írásbeli vizsgát szervező középiskolákban. (2x45 perc)</dd>
+
+ <dt   >2020. január 25. 8:00-16:00 <code class="hat icon-camera"> 6</code> <code class="negy icon-camera"> 4-5</code></dt>
+ <dd   >A felvételi eljárást megelőző központi írásbeli dolgozatok megtekintése négyévfolyamos, hatévfolyamos és a nyelvi előkészítős képzésre jelentkezőknek</dd>
+
+ <dt>2020. február 19. <code class="hatarido icon-time"></code></dt>
+ <dd>Tanulói Jelentkezési Lapok és Tanulói Adatlapok leadási határideje </dd>
+
+ <dt>2020. február 24. - 2020. március 13. <code class="icon-child"></code></dt>
+ <dd>Szóbeli beszélgetések a kiírás szerint.</dd>
+
+ <dt>2020. március 16.</dt>
+ <dd>Ideiglenes felvételi jegyzék közzététele.</dd>
+
+</dl>
+
+<h3 id="kiemelt">Kiemelt adatok</h3>
+
+<dl>
+<dt>Az iskola rövid neve és címe:</dt>
+<dd>Városmajori Gimnázium<br/>
+    1122. Budapest, Városmajor u. 71.<br/>
+    Tel: 214-1554; Fax: 214-1479<br/>
+    Telephely kódja: 001<br/> 
+</dd>
+<dt>A gimnázium központi azonosító kódja:</dt>
+<dd style="font-family: monospace; font-size:20px">035242</dd>
+
+
+<dt>A 2019/2020-es tanévben indítandó tanulócsoportok azonosító számai:</dt>
+<dd>
+<style type="text/css">
+    a {}
+    table.tagozatok td { height: 2em; }
+    table.tagozatok a:before { content: "☞ "; font-size: 1.4em; }
+    table.tagozatok a:hover { text-decoration: underline; }
+    table.tagozatok tr:hover td { color:cornflowerblue;  }
+</style>
+
+<table class="tagozatok">
+<tr><th>Az osztály jele</th><th>megnevezése</th><th>kódja</th></tr>
+<tr><td>7.&nbsp;A</td><td><a href="index.php?page=felveteli&f=hatevfolyamos">általános egyedi tantervű osztály (angol)</a></td><td>0710</td></tr>
+<tr><td>7.&nbsp;B</td><td><a href="index.php?page=felveteli&f=hatevfolyamos">általános egyedi tantervű osztály (német)</a></td><td>0720</td></tr>
+<tr><td>9.&nbsp;C</td><td><a href="index.php?page=felveteli&f=enek">ének-zene speciális tantervű csoport (angol)</a></td><td>0930</td></tr>
+<tr><td>9.&nbsp;C</td><td><a href="index.php?page=felveteli&f=human">magyar egyedi tantervű csoport (angol)</a></td><td>0934</td></tr>
+<tr><td>9.&nbsp;D</td><td><a href="index.php?page=felveteli&f=matematika">matematika tehetséggondozó csoport (angol)</a></td><td>0940</td></tr>
+<tr><td>9.&nbsp;D</td><td><a href="index.php?page=felveteli&f=fizika">fizika egyedi tantervű csoport (angol)</a></td><td>0942</td></tr>
+<tr><td>9/Ny.&nbsp;E</td><td><a href="index.php?page=felveteli&f=otevfolyamos">általános tantervű (nyelvi előkészítős, 1+4 évfolyamos) csoport (német)</a></td><td>0850</td></tr>
+<tr><td>9/Ny.&nbsp;E</td><td><a href="index.php?page=felveteli&f=otevfolyamos">általános tantervű (nyelvi előkészítős, 1+4 évfolyamos) csoport (spanyol)</a></td><td>0855</td></tr>
+</table>
+</dd>
+
+</dl>
+
+</div>
diff --git a/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.html b/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.html
index 13dd5cfa..d8acbde8 100644
--- a/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.html
+++ b/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.html
@@ -1,107 +1,10 @@
 <div class="felveteli">
 <h1>Középiskolai felvételi</h1>
-<h2>2020/2021-es tanév</h2>
+<h2>2021/2022-es tanév</h2>
 
 <div style="margin-top: 6px; text-align:center;">
-  <a style="font-weight: bold; font-size: 16px; color: #837389;" href="/vmg/felveteli/FT2020.pdf">
-    Felvételi Tájékoztató 2020/2021 [PDF]
+  <a style="font-weight: bold; font-size: 16px; color: #837389;" href="/vmg/felveteli/FT2021.pdf">
+    Felvételi Tájékoztató 2021/2022 [PDF]
   </a>
 </div>
-<!--
-<h3>Gyakran Ismételt Kérdések</h3>
-<p>
-<ul>
-<li><a class="gyik" href="index.php?page=felveteli&f=felveteli-gyik">Gy.I.K.</a></li>
-<li><a href="index.php?page=felveteli&f=pontszamito">Pontszámító Kalkulátor</a></li>
-</ul>
-</p>
--->
-<h3>Letölthető dokumentumok</h3>
-<ul>
-<li>
-<a href="/vmg/felveteli/FT2020.pdf">A Városmajori Gimnázium Felvételi Tájékoztatója 2020/2021</a> (.pdf)
-</li><li style="">
-<a href="https://www.oktatas.hu/kozneveles/kozepfoku_felveteli_eljaras/kozepfoku_felveteli_eljaras_informacioi">
-Oktatási Hivatal Tájékoztatója a középfokú beiskolázási határidőkről, időpontokról
-</a> (oktatas.hu)</li>
-</ul>
-
-<h3>Fontos dátumok</h3>
-
-<dl>
-<dt  >2019. október 17.</dt>
-<dd  >
-A felvételi tájékoztató megjelenése.
-</dd>
-
- <dt  >2019. november 11. 18:00 </dt>
- <dd  >Tájékoztató értekezletet a felvételi eljárás rendjéről, induló osztályokról</dd>
-
- <dt >2019. november 11-15.</dt>
- <dd>Iskola bemutatkozás és nyílt órák (előzetes jelentkezéssel!)</dd>
-
- <dt  >2019. december 6.<code class="hatarido icon-time"></code></dt>
- <dd  >Jelentkezési határidő az egységes követelmények szerint tartott
- a felvételi eljárást megelőző írásbeli felvételi vizsgára.
- </dd>
-
- <dt  >2020. január 18. 10<sup>00</sup> <code class="icon-child"></code></dt>
- <dd  >Írásbeli felvételi vizsgák az érintett 6 évfolyamos gimnáziumokban. (2x45 perc) </dd>
-
- <dt  >2020. január 18. 10<sup>00</sup> <code class="icon-child"></code></dt>
- <dd  >Írásbeli felvételi a nyolcadik évfolyamok számára a felvételi eljárást 
- megelőző írásbeli vizsgát szervező középiskolákban. (2x45 perc)</dd>
-
- <dt   >2020. január 25. 8:00-16:00 <code class="hat icon-camera"> 6</code> <code class="negy icon-camera"> 4-5</code></dt>
- <dd   >A felvételi eljárást megelőző központi írásbeli dolgozatok megtekintése négyévfolyamos, hatévfolyamos és a nyelvi előkészítős képzésre jelentkezőknek</dd>
-
- <dt>2020. február 19. <code class="hatarido icon-time"></code></dt>
- <dd>Tanulói Jelentkezési Lapok és Tanulói Adatlapok leadási határideje </dd>
-
- <dt>2020. február 24. - 2020. március 13. <code class="icon-child"></code></dt>
- <dd>Szóbeli beszélgetések a kiírás szerint.</dd>
-
- <dt>2020. március 16.</dt>
- <dd>Ideiglenes felvételi jegyzék közzététele.</dd>
-
-</dl>
-
-<h3 id="kiemelt">Kiemelt adatok</h3>
-
-<dl>
-<dt>Az iskola rövid neve és címe:</dt>
-<dd>Városmajori Gimnázium<br/>
-    1122. Budapest, Városmajor u. 71.<br/>
-    Tel: 214-1554; Fax: 214-1479<br/>
-    Telephely kódja: 001<br/> 
-</dd>
-<dt>A gimnázium központi azonosító kódja:</dt>
-<dd style="font-family: monospace; font-size:20px">035242</dd>
-
-
-<dt>A 2019/2020-es tanévben indítandó tanulócsoportok azonosító számai:</dt>
-<dd>
-<style type="text/css">
-    a {}
-    table.tagozatok td { height: 2em; }
-    table.tagozatok a:before { content: "☞ "; font-size: 1.4em; }
-    table.tagozatok a:hover { text-decoration: underline; }
-    table.tagozatok tr:hover td { color:cornflowerblue;  }
-</style>
-
-<table class="tagozatok">
-<tr><th>Az osztály jele</th><th>megnevezése</th><th>kódja</th></tr>
-<tr><td>7.&nbsp;A</td><td><a href="index.php?page=felveteli&f=hatevfolyamos">általános egyedi tantervű osztály (angol)</a></td><td>0710</td></tr>
-<tr><td>7.&nbsp;B</td><td><a href="index.php?page=felveteli&f=hatevfolyamos">általános egyedi tantervű osztály (német)</a></td><td>0720</td></tr>
-<tr><td>9.&nbsp;C</td><td><a href="index.php?page=felveteli&f=enek">ének-zene speciális tantervű csoport (angol)</a></td><td>0930</td></tr>
-<tr><td>9.&nbsp;C</td><td><a href="index.php?page=felveteli&f=human">magyar egyedi tantervű csoport (angol)</a></td><td>0934</td></tr>
-<tr><td>9.&nbsp;D</td><td><a href="index.php?page=felveteli&f=matematika">matematika tehetséggondozó csoport (angol)</a></td><td>0940</td></tr>
-<tr><td>9.&nbsp;D</td><td><a href="index.php?page=felveteli&f=fizika">fizika egyedi tantervű csoport (angol)</a></td><td>0942</td></tr>
-<tr><td>9/Ny.&nbsp;E</td><td><a href="index.php?page=felveteli&f=otevfolyamos">általános tantervű (nyelvi előkészítős, 1+4 évfolyamos) csoport (német)</a></td><td>0850</td></tr>
-<tr><td>9/Ny.&nbsp;E</td><td><a href="index.php?page=felveteli&f=otevfolyamos">általános tantervű (nyelvi előkészítős, 1+4 évfolyamos) csoport (spanyol)</a></td><td>0855</td></tr>
-</table>
-</dd>
-
-</dl>
-
-</div>
+</div>
\ No newline at end of file
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/mayor-portal/www/policy/private/portal/portal/portal.php b/mayor-orig/mayor-portal/www/policy/private/portal/portal/portal.php
index 1640b057..6e9d1cc3 100644
--- a/mayor-orig/mayor-portal/www/policy/private/portal/portal/portal.php
+++ b/mayor-orig/mayor-portal/www/policy/private/portal/portal/portal.php
@@ -3,6 +3,7 @@
     global $skin;
 
     /* $skinnek lennie kell */                                                                                                                                                                             
+
     if (defined('_POLICY') && defined('__PORTAL_CODE') && file_exists('policy/'._POLICY.'/portal/portal/portal_'.__PORTAL_CODE.'.'.$skin.'.php') ) {                                                       
         require('policy/'._POLICY.'/portal/portal/portal_'.__PORTAL_CODE.'.'.$skin.'.php');                                                                                                                
     } elseif (file_exists('policy/'._POLICY.'/portal/portal/portal_'.demo.'.'.$skin.'.php')) {                                                                                                             
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
index afebf8bc..b8e0f7ee 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
@@ -27,7 +27,7 @@
 	formBegin();
 
 	    if (__HIREKADMIN===true) {
-		    echo '<script src="//cdn.ckeditor.com/4.14.0/standard/ckeditor.js"></script>';
+		    echo '<script src="//cdn.ckeditor.com/4.14.0/standard/ckeditor.js" charset="utf-8"></script>';
 
 		    echo '<table class="egyhirdetail" cellspacing="1">';
 		    echo '<tr><th colspan="3">'._BEALLITASOK.'</th></tr>';
@@ -139,7 +139,8 @@
 	echo '<script type="text/javascript">';
 	echo "
    CKEDITOR.replace('txt', {
-      uiColor: '#eeeeee'
+      uiColor: '#eeeeee',
+      entities_latin : false
     });
 ";
 	echo '</script>';
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index 44f34c74..54f5b275 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4683
+4691
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index b0ed190b..052b0a58 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4683
-5ab848461fcb7c8f0e675e0ba565dfb6  mayor-fenntarto-rev4683.tgz
-acab3f4d1dc57153e4737352e0b2513e  mayor-installer-sulix-rev4683.tgz
-67c861aee289395a3cb38590d67ce66a  mayor-wiki-rev4683.tgz
-6f0f8a265ca71ed5eedd44b33856b3b0  mayor-installer-rev4683.tgz
-f1d56379fd6d7ac8086be051d95e4da5  mayor-portal-rev4683.tgz
-e37c44fb0101398b91fe7c3371399672  mayor-felveteli-rev4683.tgz
-0eff173e22c1dbdb55b53f65eecbaf94  mayor-jatek-rev4683.tgz
-b2c987867d7f4b0c5e2cb6727ec3c9b7  mayor-locales-jp_JP-rev4683.tgz
-11dd8efcac7603550dd6db72476e2a26  mayor-locales-de_DE-rev4683.tgz
-180cebdc87e92c057e8870d8f3b77b91  mayor-locales-en_US-rev4683.tgz
-1d142f81e335acfe4a50fe626a6c864a  mayor-naplo-rev4683.tgz
-7a2430870a191b80dc09cba2322b4b0d  mayor-base-rev4683.tgz
+Revision 4691
+71107f2d0381381d16916e473db42dba  mayor-fenntarto-rev4691.tgz
+a80ee713915cb729bf44f9c831f3e74a  mayor-installer-sulix-rev4691.tgz
+a0777d620e206b07b6e3565864a58fec  mayor-wiki-rev4691.tgz
+a58f5bd16055fc5f168b39a70052de05  mayor-installer-rev4691.tgz
+512a43eb1223ecec3b81ea1eda4c16f6  mayor-portal-rev4691.tgz
+21a67636b6d1d0c2ca040d1210901aaf  mayor-felveteli-rev4691.tgz
+1d2ff3b0f71141f6e3c916c749eab426  mayor-jatek-rev4691.tgz
+f5490a7abb4629401ac267ec0e23a9ac  mayor-locales-jp_JP-rev4691.tgz
+d9d56f15c55aaca9e5e6447455e8b593  mayor-locales-de_DE-rev4691.tgz
+b03f1fa2e742a0d3245a1c1b719dbd6f  mayor-locales-en_US-rev4691.tgz
+5b7345dd3db4f2aa184d4440beb7bd5e  mayor-naplo-rev4691.tgz
+6b1cef87715c325d36a3d24e66378cbf  mayor-base-rev4691.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index 44f34c74..54f5b275 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4683
+4691
diff --git a/rev.txt b/rev.txt
index 44f34c74..54f5b275 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4683
+4691
-- 
cgit v1.2.3


From c279e479aa9c943fd0fc2b396638a5208c78cfb9 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Wed, 28 Oct 2020 11:35:04 +0100
Subject: Rev: 4695

---
 mayor-orig/mayor-base/log/mayor-base.rev           |  2 +-
 .../mayor-base/www/skin/classic/base/css/base.css  |  3 +-
 .../www/skin/default/base/html/base.phtml          |  5 +-
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |  2 +-
 .../include/menu/public/hu_HU/module-felveteli.php |  4 ++
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |  2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |  2 +-
 .../log/mayor-installer-sulix.rev                  |  2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |  2 +-
 .../log/mayor-locales-de_DE.rev                    |  2 +-
 .../log/mayor-locales-en_US.rev                    |  2 +-
 .../log/mayor-locales-jp_JP.rev                    |  2 +-
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 .../install/mayor-portal/mysql/mayor-portal.sql    | 18 ++++--
 mayor-orig/mayor-portal/log/mayor-portal.rev       |  2 +-
 .../update/rev004693-1-mayor_portal.sql            | 32 +++++++++++
 .../www/include/modules/portal/hirek/egyhir.php    |  9 ++-
 .../www/include/modules/portal/share/hirek.php     |  2 +-
 .../www/policy/private/portal/hirek/egyhir-pre.php |  1 +
 .../policy/private/portal/hirek/hirekAdmin-pre.php | 35 +++++++++++-
 .../www/policy/private/portal/hirek/hirekAdmin.php |  6 +-
 .../classic/module-portal/css/hirek/egyhir.css     | 34 +++++++++--
 .../classic/module-portal/css/hirek/hirekAdmin.css | 15 ++++-
 .../www/skin/classic/module-portal/css/portal.css  |  6 +-
 .../classic/module-portal/html/hirek/egyhir.phtml  | 35 ++++++++----
 .../module-portal/html/hirek/hirekAdmin.phtml      | 66 +++++++++++++++++-----
 .../classic/module-portal/html/share/doboz.phtml   |  3 +-
 .../module-portal/javascript/portal.jquery.min.js  | 29 ++++++++++
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |  2 +-
 mayor-orig/md5sum                                  | 26 ++++-----
 mayor-orig/rev.txt                                 |  2 +-
 rev.txt                                            |  2 +-
 32 files changed, 282 insertions(+), 75 deletions(-)
 create mode 100644 mayor-orig/mayor-portal/update/rev004693-1-mayor_portal.sql

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-base/www/skin/classic/base/css/base.css b/mayor-orig/mayor-base/www/skin/classic/base/css/base.css
index 54b53fb8..4ee80f46 100644
--- a/mayor-orig/mayor-base/www/skin/classic/base/css/base.css
+++ b/mayor-orig/mayor-base/www/skin/classic/base/css/base.css
@@ -102,7 +102,8 @@
 	padding-left: 140px; 
     }
 
-    #nav li { position: relative; }
+    #nav li { position: relative;  }
+    #nav li:first { white-space: nowrap; }
     #nav > li { float: left; z-index: 20; text-align: center; padding: 0;
 /*	    background-color: #3fa79c;  */
 	    background-color: #3496B9;
diff --git a/mayor-orig/mayor-base/www/skin/default/base/html/base.phtml b/mayor-orig/mayor-base/www/skin/default/base/html/base.phtml
index 19dfa38e..78a5dea8 100644
--- a/mayor-orig/mayor-base/www/skin/default/base/html/base.phtml
+++ b/mayor-orig/mayor-base/www/skin/default/base/html/base.phtml
@@ -137,7 +137,8 @@ function includeJS($page,$sub,$f,$skin) {
 		    echo '<script language="JavaScript" type="text/javascript"  charset="utf-8" src="'.$_f.'?ver='._MAYORREV.'"></script>'."\n";
 		}
 	    }
-	    if (__RICH_TEXT_EDITOR===true && $f == 'egyhir') {
+/*
+	    if (__RICH_TEXT_EDITOR===true && $f == 'egyhir') { // disabled
 		// Koschtit Image Gallery
 		if ($page == 'portal') {
 		    //require_once('skin/classic/share/javascript/koschtit/ki_include.php');
@@ -147,7 +148,7 @@ function includeJS($page,$sub,$f,$skin) {
 		    <script src="skin/classic/share/javascript/tiny_mce/tiny_mce.js" type="text/javascript"></script>
 		    <script src="skin/classic/module-portal/javascript/hirek/egyhir.php?lang='.$lang.'" type="text/javascript"></script>';
 	    }
-
+*/
 	//	if (file_exists(($_f="skin/$skin/base/javascript/jstorage.min.js")) ) {
 	//	echo '<script language="JavaScript" type="text/javascript"  charset="utf-8" src="'.$_f.'?ver='._MAYORREV.'"></script>'."\n";
 	//    }	    
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-felveteli/www/include/menu/public/hu_HU/module-felveteli.php b/mayor-orig/mayor-felveteli/www/include/menu/public/hu_HU/module-felveteli.php
index 4fa2aa1d..953cc817 100644
--- a/mayor-orig/mayor-felveteli/www/include/menu/public/hu_HU/module-felveteli.php
+++ b/mayor-orig/mayor-felveteli/www/include/menu/public/hu_HU/module-felveteli.php
@@ -1,5 +1,7 @@
 <?php
 
+if (in_array(__PORTAL_CODE,array('vmg','kos'))) {
+
     if (__PORTAL_CODE=='kos' || $sub == 'kos') {
 	$MENU['felveteli'] = array(
     	    array('txt' => 'Felvételi (általános iskola)', 'url' => 'index.php?page=felveteli&sub=kos')
@@ -45,4 +47,6 @@
         array('txt' => '6.', 'url' => 'index.php?page=felveteli&sub=tajekoztato/20082009&f=6'),
     );
 */
+
+}
 ?>
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql b/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql
index 842760b7..61655882 100644
--- a/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql
+++ b/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql
@@ -61,13 +61,23 @@ SET character_set_client = @saved_cs_client;
 
 DROP TABLE IF EXISTS `kategoriak`;
 CREATE TABLE `kategoriak` (
-  `id` mediumint(8) unsigned NOT NULL default '0',
-  `leiras` varchar(70) NOT NULL default '',
+  `id` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `leiras` varchar(70) NOT NULL DEFAULT '',
   `precode` text,
-  `postcode` text
+  `postcode` text,
+  UNIQUE KEY `id` (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=1;
 
-
+DROP TABLE IF EXISTS `hirKategoria`;
+CREATE TABLE `hirKategoria` (
+  `hirId` int(10) unsigned NOT NULL,
+  `kategoriaId` mediumint(8) unsigned NOT NULL,
+  PRIMARY KEY (`hirId`,`kategoriaId`),
+  KEY `hirKategoria_FKIndex1` (`hirId`),
+  KEY `hirKategoria_FKIndex2` (`kategoriaId`),
+  CONSTRAINT `hirKategoria_ibfk_1` FOREIGN KEY (`hirId`) REFERENCES `hirek` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `hirKategoria_ibfk_2` FOREIGN KEY (`kategoriaId`) REFERENCES `kategoriak` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
 --
 -- Table structure for table `linkek`
 --
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/mayor-portal/update/rev004693-1-mayor_portal.sql b/mayor-orig/mayor-portal/update/rev004693-1-mayor_portal.sql
new file mode 100644
index 00000000..5b36028d
--- /dev/null
+++ b/mayor-orig/mayor-portal/update/rev004693-1-mayor_portal.sql
@@ -0,0 +1,32 @@
+DELIMITER $$
+DROP PROCEDURE IF EXISTS upgrade_database_4693 $$
+
+CREATE PROCEDURE upgrade_database_4693()
+BEGIN
+SET NAMES utf8 COLLATE utf8_hungarian_ci;
+
+IF NOT EXISTS (SELECT * FROM information_schema.STATISTICS WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='kategoriak' AND COLUMN_NAME='id') THEN
+    ALTER TABLE `kategoriak` ADD UNIQUE INDEX (id);
+END IF;
+
+ALTER TABLE `hirek` ENGINE = InnoDB;
+ALTER TABLE `kategoriak` ENGINE = InnoDB;
+
+IF NOT EXISTS (SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='hirKategoria') THEN
+CREATE TABLE `hirKategoria` (
+ `hirId` int(10) unsigned NOT NULL,
+ `kategoriaId` mediumint(8) unsigned NOT NULL,
+  PRIMARY KEY (`hirId`,`kategoriaId`),
+  KEY `hirKategoria_FKIndex1` (`hirId`),
+  KEY `hirKategoria_FKIndex2` (`kategoriaId`),
+  CONSTRAINT `hirKategoria_ibfk_1` FOREIGN KEY (`hirId`) REFERENCES `hirek` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `hirKategoria_ibfk_2` FOREIGN KEY (`kategoriaId`) REFERENCES `kategoriak` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci ;
+END IF;
+
+-- hirek.cid --> hirKategoria kapcsolo
+INSERT IGNORE INTO hirKategoria SELECT hirek.id as hirId,hirek.cid AS kategoriaId from hirek where hirek.cid!=0;
+
+END $$
+DELIMITER ;
+CALL upgrade_database_4693();
diff --git a/mayor-orig/mayor-portal/www/include/modules/portal/hirek/egyhir.php b/mayor-orig/mayor-portal/www/include/modules/portal/hirek/egyhir.php
index c93a81bd..1c5c8bc9 100644
--- a/mayor-orig/mayor-portal/www/include/modules/portal/hirek/egyhir.php
+++ b/mayor-orig/mayor-portal/www/include/modules/portal/hirek/egyhir.php
@@ -13,7 +13,7 @@
 	$flag = intval($DATA['flag']);
 	$class = intval($DATA['class']);
 	$lang = (in_array($DATA['lang'],$LANGUAGES)) ? $DATA['lang'] : _DEFAULT_LANG;
-	if ($DATA['cid']>0) $cid = $DATA['cid'];
+	if ($DATA['cid']>0) $cid = $DATA['cid']; // -- TODO!!!!
 	$csoport = $DATA['csoport'];
 	if ($hirId!='' && __HIREKADMIN == false ) {
 	    $q = "SELECT owner FROM hirek WHERE owner='%s'";
@@ -41,6 +41,13 @@
 	    }
 	} else $q = '';
 	if ($q!='') $r = db_query($q,array('modul'=>'portal','result'=>'insert','values'=>$v));
+	if (is_array($DATA['kategoriaId'])) {
+	    for ($i=0; $i<count($DATA['kategoriaId']); $i++) {
+		$q = "INSERT IGNORE INTO `hirKategoria` (hirId,kategoriaId) VALUES (%u,%u)";
+		$v = array($hirId,$DATA['kategoriaId'][$i]);
+		db_query($q,array('modul'=>'portal','result'=>'insert','values'=>$v));
+	    }
+	}
 	return $r;
     }
 
diff --git a/mayor-orig/mayor-portal/www/include/modules/portal/share/hirek.php b/mayor-orig/mayor-portal/www/include/modules/portal/share/hirek.php
index d7db431e..0de316b6 100644
--- a/mayor-orig/mayor-portal/www/include/modules/portal/share/hirek.php
+++ b/mayor-orig/mayor-portal/www/include/modules/portal/share/hirek.php
@@ -42,7 +42,7 @@
 	} else $WHERE = '';
 
 	if ($SET['all']===true) $WHERE = ''; 
-	$q = "SELECT * FROM hirek $WHERE ORDER BY kdt DESC,vdt DESC".$L;
+	$q = "SELECT hirek.*, hirek.id AS hirId, GROUP_CONCAT(kategoriaId) AS hirkategoriak FROM hirek LEFT JOIN hirKategoria ON (hirek.id=hirId) $WHERE GROUP BY hirek.id ORDER BY kdt DESC,vdt DESC".$L;
 	$HIREK['szovegek'] = db_query($q, array('modul'=>'portal','result'=>'indexed'));
 	return $HIREK;
     }
diff --git a/mayor-orig/mayor-portal/www/policy/private/portal/hirek/egyhir-pre.php b/mayor-orig/mayor-portal/www/policy/private/portal/hirek/egyhir-pre.php
index 0d5cbf71..ef18e58c 100644
--- a/mayor-orig/mayor-portal/www/policy/private/portal/hirek/egyhir-pre.php
+++ b/mayor-orig/mayor-portal/www/policy/private/portal/hirek/egyhir-pre.php
@@ -26,6 +26,7 @@ if (_RIGHTS_OK !== true) die();
         $DATA['flag']= readVariable($_POST['flag'],'numeric',null);
         $DATA['class']= readVariable($_POST['class'],'numeric',null);
         $DATA['cid']= readVariable($_POST['cid'],'numeric',null);
+        $DATA['kategoriaId']= readVariable($_POST['kategoriaId'],'id',null);
         $DATA['lang'] = readVariable($_POST['lang'],'strictstring',$LANGUAGES);
 	$DATA['owner'] = _USERACCOUNT;
 	if (is_array($_POST['csoport'])) {
diff --git a/mayor-orig/mayor-portal/www/policy/private/portal/hirek/hirekAdmin-pre.php b/mayor-orig/mayor-portal/www/policy/private/portal/hirek/hirekAdmin-pre.php
index 630c9cbd..1e51b811 100644
--- a/mayor-orig/mayor-portal/www/policy/private/portal/hirek/hirekAdmin-pre.php
+++ b/mayor-orig/mayor-portal/www/policy/private/portal/hirek/hirekAdmin-pre.php
@@ -6,6 +6,39 @@
     }
 
     require_once('include/modules/portal/share/hirek.php');
-    $HIREK = getHirek(array('all'=>true)); // minden nyelvű hír
 
+    if ($action=='kategoriaSzerkeszt') {
+	$_id = readVariable($_POST['id'],'id');
+	if (is_numeric($_id)) {
+	    $_leiras = readVariable($_POST['leiras'],'string');
+	    $_precode = readVariable($_POST['precode'],'html');
+	    $_postcode = readVariable($_POST['postcode'],'html');
+	    $q = "INSERT INTO kategoriak (id,leiras,precode,postcode) VALUES (%u,'%s','%s','%s')";
+	    $v = array($_id,$_leiras,$_precode,$_postcode);
+	    db_query($q,array('modul'=>'portal','values'=>$v));
+	}
+	$KATEGORIAIDK = readVariable($_POST['kategoriaId'],'id');
+	for ($i=0; $i<count($KATEGORIAIDK); $i++) {
+	    $_id = $KATEGORIAIDK[$i];
+	    $_leiras = readVariable($_POST['leiras_'.$_id],'string');
+	    $_precode = readVariable($_POST['precode_'.$_id],'string');
+	    $_postcode = readVariable($_POST['postcode_'.$_id],'string');
+	    $q = "UPDATE kategoriak SET leiras='%s',precode='%s',postcode='%s' WHERE id=%u";
+	    $v = array($_leiras,$_precode,$_postcode,$_id);
+	    db_query($q,array('modul'=>'portal','values'=>$v));
+	}
+	$KATEGORIAIDK = readVariable($_POST['kategoriaTorlendo'],'id');
+	for ($i=0; $i<count($KATEGORIAIDK); $i++) {
+	    $_id = $KATEGORIAIDK[$i];
+	    $q = "DELETE FROM kategoriak WHERE id=%u";
+	    $v = array($_id);
+	    db_query($q,array('modul'=>'portal','values'=>$v));
+	}
+    } 
+
+
+    $ADAT = getHirek(array('all'=>true)); // minden nyelvű hír
+    $ADAT['kategoriak'] = getKategoriak();
+    $ADAT['kategoriaId2txt'] = reindex($ADAT['kategoriak'],array('id'));
+dump($ADAT['kategoriaId2txt']);
 ?>
diff --git a/mayor-orig/mayor-portal/www/policy/private/portal/hirek/hirekAdmin.php b/mayor-orig/mayor-portal/www/policy/private/portal/hirek/hirekAdmin.php
index 2474b23e..909018dc 100644
--- a/mayor-orig/mayor-portal/www/policy/private/portal/hirek/hirekAdmin.php
+++ b/mayor-orig/mayor-portal/www/policy/private/portal/hirek/hirekAdmin.php
@@ -1,5 +1,7 @@
 <?php
 
-    global $HIREK;
-    putHirek($HIREK['szovegek']);
+    global $ADAT;
+
+    putKategoriaSzerkeszto($ADAT['kategoriak']);
+    putHirek($ADAT);
 ?>
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/hirek/egyhir.css b/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/hirek/egyhir.css
index 8be4a7c3..1ea5cb6d 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/hirek/egyhir.css
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/hirek/egyhir.css
@@ -3,40 +3,62 @@
 
     div.egyhir {
 	margin-left: 50px;
+	margin-right:50px;
     }
 
     div.egyhir form {
 	font-weight: bold;
+	margin-bottom: 40px;
+	border-bottom: solid 1px #eee;
     }
 
     div.egyhir label {
-
+	padding-right: 1em;
     }
 
     div.egyhir input {
-	background-color: white;
+/*	background-color: white;
 	border: solid 1px #667766;
-    }
+*/    }
 
     div.egyhir textarea {
 	width: 80%;
 	height: 300px;
+/*
 	border: solid 1px #667766;	
 	background-color: white;
+*/
     }
 
     table.egyhirdetail {
 	background-color: #eeeeee;
-	border-bottom: solid 2px #667766;
     }
     table.egyhirdetail td {
 	border: solid 1px #667766;
+	line-height: 2em;
+	padding: 0.4em;
     }
     table.egyhirdetail th {
-	background-color: #667766;
+	background-color: cornflowerblue;
 	color: white;
 	height:30px;
-	border-bottom: solid 2px #001100;
     }
 
     .mceEditor iframe { border: blue 1px solid; }
+
+    #pic, #cim { line-height: 1.4em; margin-bottom:1em;}
+
+span.kategoriaSelector { border-radius: 4px; padding: 2px 4px; background-color: white; border: solid 1px black; font-weight:normal;
+cursor: pointer;
+-webkit-transition : 100ms ease-out;
+  -moz-transition : 100ms ease-out;
+  -o-transition : 100ms ease-out;
+  transition : 100ms ease-out;
+ }
+
+span.kategoriaSelector.selected { background-color: #d64161; color:white; }
+span.kategoriaSelector.modified { background-color: #878f99; color:white; border-color:white; }
+span.kategoriaSelector.selected.modified { background-color: #6b5b95; color:white;  border-color: black;}
+span.kategoriaSelector:hover { border: solid 1px #6b5b95; background-color: #ff7b25; color:white; }
+span.kategoriaSelector.selected:hover { background-color: #878f99; color:white; }
+
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/hirek/hirekAdmin.css b/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/hirek/hirekAdmin.css
index 9e05068d..347cd17f 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/hirek/hirekAdmin.css
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/hirek/hirekAdmin.css
@@ -10,15 +10,24 @@
 
     table.hAdmin {
 	background-color: #445560;
-	
+	width:90%;	
     }
     table.hAdmin tr td {
-	background-color: #eeeeee;
+	background-color: #eee;
+    	padding: 2px 4px;
+	line-height: 1.6em;
+    }
+    table.hAdmin tr:hover td {
+	outline: solid 1px #d64161;
+	background-color: #fff;
     }
 
+    table.hAdmin tr td.latszik {
+	background-color: #d64161; color:white;
+    }
 
     table.hAdmin tr.unk td {
-	background-color: #993456;
+	background-color: #feb236;
     }
     table.hAdmin tr.old td {
 	background-color: #999999;
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/portal.css b/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/portal.css
index cc128d4f..5152e545 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/portal.css
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/portal.css
@@ -86,8 +86,10 @@ hr {display: none;}
 
     table.portalMain div.dobozTart a { color: black }
 
-
-
+    
+    div.static h1 { margin: 20px;}
+    div.static p { margin-left: 26px; margin-right:26px; margin-bottom: 1.2rem; font-size: 14px; line-height:1.6em;}
+    
 @media (max-width: 850px) {
   .bal, .jobb {
     display: none;
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
index b8e0f7ee..f24068ca 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
@@ -30,7 +30,10 @@
 		    echo '<script src="//cdn.ckeditor.com/4.14.0/standard/ckeditor.js" charset="utf-8"></script>';
 
 		    echo '<table class="egyhirdetail" cellspacing="1">';
-		    echo '<tr><th colspan="3">'._BEALLITASOK.'</th></tr>';
+		    echo '<tr><th colspan="3">';
+			echo _BEALLITASOK;
+			if ($HIR['owner']!='') echo ' ('.$HIR['owner'].')';
+		    echo '</th></tr>';
 		    echo '<tr><td style="text-align:right">';
 
 		    echo _TOLDT.': <input type="text" name="kdt" id="kdt" value="'.$HIR['kdt'].'" class="datetime" /><br/>';	
@@ -40,21 +43,34 @@
 		echo '<td>';
 
 		    reset($LANGUAGES);
-		    echo '<select name="lang">';
-		    for($i=0; $i<count($LANGUAGES); $i++) {
+
+		    if (count($LANGUAGES) == 1) {
+			echo '<input type="hidden" name="lang" value="'.$LANGUAGES[0].'" />';
+		    } else {
+			echo '<select name="lang">';
+			for($i=0; $i<count($LANGUAGES); $i++) {
 			//echo '<input type="checkbox" name="policies" value="'.$LANGUAGES[$i].'" />';
 			$_CHK = ($LANGUAGES[$i]==$HIR['lang']) ? ' selected="selected" ':'';
 			echo '<option value="'.$LANGUAGES[$i].'" '.$_CHK.'/>';
 			echo $LANGUAGES[$i];
 			echo '</option>';
+			}
+			echo '</select>';
 		    }
-		    echo '</select>';
-	
 		    _putKategoriak($ADAT,$HIR['cid']);
 
 	    	echo '</td>';
-		echo '<td>';
-		    echo $HIR['owner'];
+		echo '<td style="line-height:2em; max-width: 300px">';
+		    // ujfajta kategoria kezelés
+		    $SELECTED_HIRKATEGORIAK = explode(',',$HIR['hirkategoriak']);
+		    for ($i=0; $i<count($ADAT['kategoriak']); $i++) {
+			$_D = $ADAT['kategoriak'][$i];
+			$_SEL = (in_array($_D['id'],$SELECTED_HIRKATEGORIAK)) ? ' selected ':''; 
+		
+			echo '<span class="kategoriaSelector '.$_SEL.'" id="kategoriaSelector_'.$_D['id'].'" data-kategoriaid="'.$_D['id'].'">'.$_D['leiras'].'</span> ';
+		    }
+		    echo '<span id="kategoriaSelectorContainer"></span>';
+		    // -------------------------
 		echo '</td>';
 		echo '</tr>';
 
@@ -67,7 +83,6 @@
 		    $_CHK = ($FLAGS[$i]==$HIR['flag']) ? ' checked="checked" ':'';
 		    echo '<input type="radio" id="F'.$i.'" name="flag" value="'.$FLAGS[$i].'" '.$_CHK.'/>';
 		    echo '<label for="F'.$i.'">';
-		    echo '&nbsp;&nbsp;&nbsp;&nbsp;';
 		    echo $FLAGSS[$i];
 		    echo '('.$FLAGS[$i].')';
 		    echo '</label>';
@@ -124,8 +139,8 @@
 	    echo "\n".'<textarea name="txt" id="txt" class="wysiwyg" rows="10" cols="80">'.htmlspecialchars($HIR['txt']).'</textarea>'."\n";
 
 	    echo '<br/>';
-	    echo _KEP;
-	    echo '<input type="text" name="pic" id="pic" size="128" value="'.$HIR['pic'].'" /><br/>';
+	    echo _KEP.': ';
+	    echo '<input type="text" name="pic" id="pic" size="128" value="'.$HIR['pic'].'" placeholder="https://"/><br/>';
 	    echo '<input type="submit" value="'._ROGZIT.'" />';
 	    echo '<input type="hidden" name="action" value="save" />';
 	    echo '<input type="hidden" name="hirId" value="'.($HIR['id']).'" />';
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/hirekAdmin.phtml b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/hirekAdmin.phtml
index 6dc5900d..1f55154a 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/hirekAdmin.phtml
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/hirekAdmin.phtml
@@ -1,27 +1,55 @@
 <?php
 
-    function putHirek($ADAT) {
+    function putKategoriaSzerkeszto($ADAT) {
+	if (!in_array(__PORTAL_CODE,array('vmg','kanizsay'))) return false;
+	formBegin();
+	echo '<table align="center">';
+
+	    for ($i=0; $i<count($ADAT); $i++) {
+		$D = $ADAT[$i];
+		echo '<tr>';
+		echo '<td><input type="hidden" name="kategoriaId[]" value="'.$D['id'].'" />';
+		    echo '<input type="checkbox" name="kategoriaTorlendo[]" value="'.$D['id'].'" title="Törlöm!" />';
+		    echo $D['id'];
+		echo '</td>';
+//		echo '<td>'.$D['leiras'].'</td>';
+		echo '<td><input type="text" name="leiras_'.$D['id'].'" value="'.$D['leiras'].'" placeholder="leírás" /></td>';
+		echo '<td><input type="text" name="precode_'.$D['id'].'" value="'.htmlentities($D['precode']).'" placeholder="precode" /></td>';
+		echo '<td><input type="text" name="postcode_'.$D['id'].'" value="'.htmlentities($D['postcode']).'" placeholder="postcode" /></td>';
+		echo '<td>'.$D['precode'].'</td>';
+		echo '<td>'.$D['postcode'].'</td>';
+		echo '</tr>';
+	    }
 
-/*
-    hideShowContainer
-    onClickHideShow
-    openable
-*/
+	    echo '<tr>';
+		echo '<td><input type="text" name="id" value="" placeholder="id" /></td>';
+		echo '<td><input type="text" name="leiras" value="" placeholder="leírás" /></td>';
+		echo '<td><input type="text" name="precode" value="" placeholder="precode" /></td>';
+		echo '<td><input type="text" name="postcode" value="" placeholder="postcode" /></td>';
+	    echo '</tr>';
+	    echo '<tr><th colspan="4">';
+	    echo '<input type="hidden" name="action" value="kategoriaSzerkeszt" />';
+	    echo '<input type="submit">';
+	    echo '</th></tr>';
+	    echo '</table>';
+	formEnd();
+    }
 
+    function putHirek($ADAT) {
 	$CLASS = array(1=>'külső hír',2=>'kis hír',6=>'csak belső',0=>'ISMERETLEN');
 	$FLAGS = array(0=>'nem látszik', 1=>'látszik', 2=>2, 3=>3);
 	$now = time();
-	echo '<table class="hAdmin hideShowContainer" align="center">';
-	echo '<tr><th colspan="5"><button type="button" class="onClickHideShow">+++</button></th></tr>'."\n";
-	for ($i=0; $i<count($ADAT); $i++) {
-	    $D = $ADAT[$i];
+	echo '<table class="hAdmin hideShowContainer" align="center" cellspacing="1">';
+	echo '<tr><td colspan="7"><button type="button" class="onClickHideShow">Mindent mutass!</button></td></tr>'."\n";
+	for ($i=0; $i<count($ADAT['szovegek']); $i++) {
+	    $D = $ADAT['szovegek'][$i];
 	    if ($D['class']==0) $_class='class="unk"'; else 
 	    if (strtotime($D['vdt'])<$now || $D['flag']==0) $_class='class="old openable" style="display: none"'; else $_class="";
 
 	    echo '<tr '.$_class.'>';
-	    echo '<td>';
-		echo $D['lang'];
-	    echo '</td>';
+	    // echo '<td>';
+		// echo $D['lang'];
+	    // echo '</td>';
 
 	    echo '<td>';
 		echo '<a href="'.href('index.php?page=portal&sub=hirek&f=egyhir&hirId='.$D['id']).'">';
@@ -36,10 +64,20 @@
 		echo ' '.$D['csoport'];
 	    echo '</td>';
 	    echo '<td>';
-		echo $D['owner'];
+		if ($D['hirkategoriak']!='') {
+		    $_K = explode(',',$D['hirkategoriak']);
+		    for($j=0; $j<count($_K); $j++) {
+			echo ' '.$ADAT['kategoriaId2txt'][$_K[$j]][0]['leiras'];
+		    }
+		}
 	    echo '</td>';
 	    echo '<td>';
+		echo $D['owner'];
+	    echo '</td>';
+	    echo '<td style="white-space: nowrap">';
 		echo $D['kdt'];
+	    echo '</td>';
+	    echo '<td style="white-space: nowrap">';
 		echo $D['vdt'];
 	    echo '</td></tr>';
 	    echo "\n\n";
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/share/doboz.phtml b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/share/doboz.phtml
index 7c903e27..8c8ded7b 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/share/doboz.phtml
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/share/doboz.phtml
@@ -22,8 +22,9 @@
 	    $bgcolor =  ($SET['background-color']=='') ? '#eeeeee' : $SET['background-color'] ;
 	    $width = ($SET['width']=='') ? '100%':$SET['width'];
 	    if ($SET['header-link']!='') $cime = '<a href="'.$SET['header-link'].'">'.$cime.'</a>';
+	    if (isset($SET['header-css']) && $SET['header-css']!='') $_style = $SET['header-css'];
 	    echo '<div class="doboz">';
-		echo '<div class="dobozCim" style="width: '.$width.'; background-color: '.$SET['header-color'].'"><span>'.$cime.'</span></div>';
+		echo '<div class="dobozCim" style="width: '.$width.'; background-color: '.$SET['header-color'].'; '.$_style.'"><span>'.$cime.'</span></div>';
 		echo '<div class="dobozTart" style="background-color: '.$bgcolor.'">'.$bele.'</div>';
 	    echo '</div>';
 
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/javascript/portal.jquery.min.js b/mayor-orig/mayor-portal/www/skin/classic/module-portal/javascript/portal.jquery.min.js
index 0969c5c7..41d70923 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/javascript/portal.jquery.min.js
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/javascript/portal.jquery.min.js
@@ -10,4 +10,33 @@ $(function() {
 	}
     });
 
+    $('span.kategoriaSelector').click(function() {
+	$(this).toggleClass('selected');
+	$(this).toggleClass('modified');	
+	$('#kategoriaSelectorContainer').html('');
+       $('span.kategoriaSelector.selected').each(function() {
+       $('<input />', { 
+           type: 'hidden', 
+           name: 'kategoriaId[]', 
+           value: $(this).data('kategoriaid')
+       }).appendTo($('#kategoriaSelectorContainer')); 
+	});
+    });
+
+
+/*
+   myForm.on('submit', function(e) {
+       //e.preventDefault();
+       $('span.kategoriaSelector.selected').each(function() {
+       $('<input />', { 
+           type: 'text',
+           name: 'kategoriaId[]',
+           value: $(this).data('kategoriaid')
+       }).appendTo(myForm); // append each input to the form     
+      });
+
+       //myForm.submit(); // submit the form
+   });
+*/
+
 });
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index 54f5b275..9bce5583 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4691
+4695
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index 052b0a58..39f0774c 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4691
-71107f2d0381381d16916e473db42dba  mayor-fenntarto-rev4691.tgz
-a80ee713915cb729bf44f9c831f3e74a  mayor-installer-sulix-rev4691.tgz
-a0777d620e206b07b6e3565864a58fec  mayor-wiki-rev4691.tgz
-a58f5bd16055fc5f168b39a70052de05  mayor-installer-rev4691.tgz
-512a43eb1223ecec3b81ea1eda4c16f6  mayor-portal-rev4691.tgz
-21a67636b6d1d0c2ca040d1210901aaf  mayor-felveteli-rev4691.tgz
-1d2ff3b0f71141f6e3c916c749eab426  mayor-jatek-rev4691.tgz
-f5490a7abb4629401ac267ec0e23a9ac  mayor-locales-jp_JP-rev4691.tgz
-d9d56f15c55aaca9e5e6447455e8b593  mayor-locales-de_DE-rev4691.tgz
-b03f1fa2e742a0d3245a1c1b719dbd6f  mayor-locales-en_US-rev4691.tgz
-5b7345dd3db4f2aa184d4440beb7bd5e  mayor-naplo-rev4691.tgz
-6b1cef87715c325d36a3d24e66378cbf  mayor-base-rev4691.tgz
+Revision 4695
+8006f6a2333f838cf1c3a4c464aed480  mayor-fenntarto-rev4695.tgz
+0413e87eaa2472d46297b1b1e67964c9  mayor-installer-sulix-rev4695.tgz
+7b1958ba242c788088f8e0fa8b19ac06  mayor-wiki-rev4695.tgz
+ce7a02daded0bc1a5b9379455fe7d497  mayor-installer-rev4695.tgz
+31a165054c79b9638a9d31cdaedb2f28  mayor-portal-rev4695.tgz
+d4f27043abc3a93c21d8939bd1ecb2e5  mayor-felveteli-rev4695.tgz
+93cab4f2a25ecae24063f2a189884046  mayor-jatek-rev4695.tgz
+2d3becd23208144f80333ee7855359d3  mayor-locales-jp_JP-rev4695.tgz
+9bd9f2a196265369cf9edc46c17adf51  mayor-locales-de_DE-rev4695.tgz
+620f79072f95112bc578085c4bb0829b  mayor-locales-en_US-rev4695.tgz
+c869569cb053d07c3b3fc97f47c7a86e  mayor-naplo-rev4695.tgz
+79f3aac8fcfb484b28f30467c7056505  mayor-base-rev4695.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index 54f5b275..9bce5583 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4691
+4695
diff --git a/rev.txt b/rev.txt
index 54f5b275..9bce5583 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4691
+4695
-- 
cgit v1.2.3


From 5d168373f8d3de040dd0f696f2f783958b1304de Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Thu, 19 Nov 2020 14:20:03 +0100
Subject: Rev: 4710

---
 mayor-orig/mayor-base/log/mayor-base.rev           |  2 +-
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |  2 +-
 .../www/static/hu_HU/felveteli/felveteli.html      |  6 ++---
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |  2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |  2 +-
 .../log/mayor-installer-sulix.rev                  |  2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |  2 +-
 .../log/mayor-locales-de_DE.rev                    |  2 +-
 .../log/mayor-locales-en_US.rev                    |  2 +-
 .../log/mayor-locales-jp_JP.rev                    |  2 +-
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 .../include/modules/naplo/share/oraModifier.php    |  5 +++--
 .../www/include/modules/naplo/share/tanar.php      |  6 +++--
 .../policy/private/naplo/intezmeny/valtas-pre.php  |  2 ++
 .../module-naplo/html/intezmeny/valtas.phtml       | 15 ++++++++++++-
 mayor-orig/mayor-portal/log/mayor-portal.rev       |  2 +-
 .../www/include/modules/portal/hirek/egyhir.php    |  3 +++
 .../www/include/modules/portal/share/hirek.php     |  4 +++-
 .../policy/private/portal/portal/portal-pre.php    |  8 ++++++-
 .../www/policy/public/portal/portal/portal-pre.php |  9 +++++++-
 .../www/skin/classic/module-portal/css/portal.css  |  9 +++++++-
 .../classic/module-portal/html/hirek/egyhir.phtml  |  2 +-
 .../module-portal/html/hirek/hirekAdmin.phtml      |  2 +-
 .../classic/module-portal/html/share/hirek.phtml   | 18 ++++++++++++++-
 .../module-portal/javascript/portal.jquery.min.js  |  9 ++++++++
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |  2 +-
 mayor-orig/md5sum                                  | 26 +++++++++++-----------
 mayor-orig/rev.txt                                 |  2 +-
 rev.txt                                            |  2 +-
 29 files changed, 110 insertions(+), 42 deletions(-)

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.html b/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.html
index d8acbde8..4d68ac34 100644
--- a/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.html
+++ b/mayor-orig/mayor-felveteli/www/static/hu_HU/felveteli/felveteli.html
@@ -3,8 +3,8 @@
 <h2>2021/2022-es tanév</h2>
 
 <div style="margin-top: 6px; text-align:center;">
-  <a style="font-weight: bold; font-size: 16px; color: #837389;" href="/vmg/felveteli/FT2021.pdf">
-    Felvételi Tájékoztató 2021/2022 [PDF]
+  <a style="font-weight: bold; font-size: 16px; color: #837389;" href="/vmg/felveteli/FT2021b.pdf" title="Fissítve: 2020. november 9.">
+    Felvételi Tájékoztató 2021/2022 (.pdf)
   </a>
 </div>
-</div>
\ No newline at end of file
+</div>
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-naplo/www/include/modules/naplo/share/oraModifier.php b/mayor-orig/mayor-naplo/www/include/modules/naplo/share/oraModifier.php
index 625b6b13..031ad51e 100644
--- a/mayor-orig/mayor-naplo/www/include/modules/naplo/share/oraModifier.php
+++ b/mayor-orig/mayor-naplo/www/include/modules/naplo/share/oraModifier.php
@@ -36,8 +36,9 @@
 	return ($_TANEV['szemeszter'][1]['statusz'] == 'aktív') // Csak aktív szemeszterbe írhatunk
                 && (
                     ((__VEZETOSEG || __NAPLOADMIN) && $Feladat && $haladasiOraAdat['eredet']=='órarend')
-                    || $time <= time()
-                )       // A jövőbeli órák nem írhatók be, kivéve, ha az előírt tanári feladat (pl versenyfelügyelet)!
+                    || $time <= time()  // A jövőbeli órák nem írhatók be, kivéve, ha az előírt tanári feladat (pl versenyfelügyelet)!
+		    || $time >= time()   // Pandemic Release
+                )       
                 && (
                     // Az admin bármikor módosíthat - de csak vezetői utasításra teszi!
                     __NAPLOADMIN
diff --git a/mayor-orig/mayor-naplo/www/include/modules/naplo/share/tanar.php b/mayor-orig/mayor-naplo/www/include/modules/naplo/share/tanar.php
index 5e23e4ec..0a931863 100644
--- a/mayor-orig/mayor-naplo/www/include/modules/naplo/share/tanar.php
+++ b/mayor-orig/mayor-naplo/www/include/modules/naplo/share/tanar.php
@@ -66,9 +66,11 @@
 	} elseif ($SET['mkId'] == '') {
 	    if (count($where) > 0) $W = 'WHERE ' . implode(' AND ',$where);
 	    $q = "SELECT tanarId, TRIM(CONCAT_WS(' ',viseltNevElotag, ViseltCsaladiNev, viseltUtoNev)) AS tanarNev, statusz,
-		    hetiKotelezoOraszam,hetiLekotottMinOraszam,hetiLekotottMaxOraszam,hetiKotottMaxOraszam,hetiMunkaora
+		    hetiKotelezoOraszam,hetiLekotottMinOraszam,hetiLekotottMaxOraszam,hetiKotottMaxOraszam,hetiMunkaora 
 			$extraAttrs
-		FROM ".__INTEZMENYDBNEV.".tanar $W ORDER BY CONCAT_WS(' ', ViseltCsaladiNev, viseltUtoNev)";
+		FROM ".__INTEZMENYDBNEV.".tanar 
+--		LEFT JOIN ".__INTEZMENYDBNEV.".tanarKepesites USING (tanarId) LEFT JOIN ".__INTEZMENYDBNEV.".kepesitesTargy USING (kepesitesId)
+		$W ORDER BY CONCAT_WS(' ', ViseltCsaladiNev, viseltUtoNev)";
 	} else {
 	    if (count($where) > 0) $W = 'AND ' . implode(' AND ',$where);
 	    $q = "SELECT tanar.tanarId AS tanarId, TRIM(CONCAT_WS(' ',viseltNevElotag, ViseltCsaladiNev, viseltUtoNev)) AS tanarNev, statusz,
diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/valtas-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/valtas-pre.php
index 8c0d870c..fb04a3ca 100644
--- a/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/valtas-pre.php
+++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/valtas-pre.php
@@ -5,6 +5,7 @@
     require_once('include/modules/naplo/share/intezmenyek.php');
     require_once('include/modules/naplo/share/szemeszter.php');
     require_once('include/modules/naplo/share/tanar.php');
+    require_once('include/modules/naplo/share/targy.php');
     require_once('include/modules/naplo/share/osztaly.php');
     require_once('include/modules/naplo/share/munkakozosseg.php');
 
@@ -40,6 +41,7 @@
 	}
     }
     $ADAT['tanarok'] = getTanarok(array('extraAttrs'=>'titulus,statusz,besorolas','telephelyId'=>__TELEPHELYID));
+    $ADAT['targyak'] = getTargyak(array('arraymap'=>array('targyId')));
     $lr = db_connect('naplo_intezmeny');
     for($i=0; $i<count($ADAT['tanarok']); $i++) {
 	$_tanarId = $ADAT['tanarok'][$i]['tanarId'];
diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/valtas.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/valtas.phtml
index 756ec408..6811b588 100644
--- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/valtas.phtml
+++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/intezmeny/valtas.phtml
@@ -13,7 +13,7 @@ function putTanarLista($ADAT) {
 	    if ($T['titulus']!='') echo '<div class="titulus">'.$T['titulus'].'</div>';
 	    if ($T['statusz']=='külső óraadó') echo '<div class="titulus">'.$T['statusz'].'</div>';
 	    if ($T['besorolas']=='Gyakornok') echo '<div class="titulus">'.kisbetus($T['besorolas']).'</div>';
-//	    if ($T['besorolas']=='Mesterpedagógus') echo '<div class="titulus">'.kisbetus($T['besorolas']).'</div>';
+	    if ($T['besorolas']=='Mesterpedagógus') echo '<div class="titulus">'.kisbetus($T['besorolas']).'</div>';
 
 	    $osztalyai = ($ADAT['tanarOsztaly'][$T['tanarId']]);
 	    for ($j=0; $j<count($osztalyai); $j++) {
@@ -28,6 +28,19 @@ function putTanarLista($ADAT) {
 		    echo $munkakozossegei[$j]['munkakozossegNev']. ' munkaközösség-vezető';
 		echo '</div>';
 	    }
+
+/*
+	    $targyai = explode(',',$T['kepesitesTargyIdk']);
+	    if (count($targyai)>0) {
+		echo '<div class="" style="color:#aaa; font-size:smaller">';
+		for ($j=0; $j<count($targyai); $j++) {
+		    $_targyId = $targyai[$j];
+		    echo ' '.$ADAT['targyak'][$_targyId][0]['targyNev'].' ';
+		}
+		echo '</div>';
+	    }
+*/
+
 	echo '</td>';
 	if (($i+1) % 3 == 0 && $i!=count($ADAT['tanarok'])-1) echo '</tr><tr>';
     }
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/mayor-portal/www/include/modules/portal/hirek/egyhir.php b/mayor-orig/mayor-portal/www/include/modules/portal/hirek/egyhir.php
index 1c5c8bc9..652c18ae 100644
--- a/mayor-orig/mayor-portal/www/include/modules/portal/hirek/egyhir.php
+++ b/mayor-orig/mayor-portal/www/include/modules/portal/hirek/egyhir.php
@@ -41,6 +41,9 @@
 	    }
 	} else $q = '';
 	if ($q!='') $r = db_query($q,array('modul'=>'portal','result'=>'insert','values'=>$v));
+	$q = "DELETE FROM `hirKategoria` WHERE hirId=%u";
+	$v = array($hirId);
+	db_query($q,array('modul'=>'portal','result'=>'delete','values'=>$v));
 	if (is_array($DATA['kategoriaId'])) {
 	    for ($i=0; $i<count($DATA['kategoriaId']); $i++) {
 		$q = "INSERT IGNORE INTO `hirKategoria` (hirId,kategoriaId) VALUES (%u,%u)";
diff --git a/mayor-orig/mayor-portal/www/include/modules/portal/share/hirek.php b/mayor-orig/mayor-portal/www/include/modules/portal/share/hirek.php
index 0de316b6..7b59782a 100644
--- a/mayor-orig/mayor-portal/www/include/modules/portal/share/hirek.php
+++ b/mayor-orig/mayor-portal/www/include/modules/portal/share/hirek.php
@@ -13,7 +13,7 @@
 	return $r;
     }
 
-    function getHirek($SET = array('all'=>true,'tolDt'=>'', 'igDt'=>'', 'id' => '', 'flag'=>array(), 'class'=>array(), 'cid'=>array(), 'limit'=>'', 'lang'=>'hu_HU') ) {
+    function getHirek($SET = array('all'=>true,'tolDt'=>'', 'igDt'=>'', 'id' => '', 'flag'=>array(), 'class'=>array(), 'cid'=>array(), 'limit'=>'', 'lang'=>'hu_HU', 'kategoria'=>array()) ) {
 
 	$tolDt = $SET['tolDt']; $igDt = $SET['igDt'];
 	if ($tolDt!='') $W[] = "kdt<='$tolDt'";
@@ -21,6 +21,8 @@
 	if (count($SET['flag'])>0) $W[] = "flag IN (".implode(',',$SET['flag']).")";
 	if (count($SET['class'])>0) $W[] = "class IN (".implode(',',$SET['class']).")";
 	if (count($SET['cid'])>0) $W[] = "cid IN (".implode(',',$SET['cid']).")";
+	if (is_array($SET['kategoria']) && count($SET['kategoria'])>0 && !is_null($SET['kategoria'][0])) 
+	    $W[] = "kategoriaId IN (".implode(',',$SET['kategoria']).")";
 	if ($SET['lang']!='')  $W[] = "lang='".$SET['lang']."'";
 
 	if ($SET['limit']!='') $L = ' LIMIT '.$SET['limit'];
diff --git a/mayor-orig/mayor-portal/www/policy/private/portal/portal/portal-pre.php b/mayor-orig/mayor-portal/www/policy/private/portal/portal/portal-pre.php
index dc4e79d5..d8026e35 100644
--- a/mayor-orig/mayor-portal/www/policy/private/portal/portal/portal-pre.php
+++ b/mayor-orig/mayor-portal/www/policy/private/portal/portal/portal-pre.php
@@ -5,7 +5,13 @@
     require_once('include/modules/portal/share/kerdoiv.php');
     require_once('include/modules/session/groupInfo.php');
 
-    $ADAT['hirek'] = getHirek(array('cid'=>array(0),'tolDt'=>date('Y-m-d H:i:s'), 'igDt'=>date('Y-m-d H:i:s'),'flag'=>array(1),'class'=>array(1,6),'csoport'=>$AUTH['my']['categories']));
+    $ADAT['kategoriak'] = getKategoriak();
+    for ($i=0; $i<count($ADAT['kategoriak']); $i++) {
+        $RESTRICTKATEGORIA[] = intval($ADAT['kategoriak'][$i]['id']);
+    }
+    $kategoriaId = readVariable($_GET['kategoriaId'],'id',null,$RESTRICTKATEGORIA);
+    $ADAT['kategoriaId'] = $kategoriaId;
+    $ADAT['hirek'] = getHirek(array('kategoria'=>array($kategoriaId),'cid'=>array(0),'tolDt'=>date('Y-m-d H:i:s'), 'igDt'=>date('Y-m-d H:i:s'),'flag'=>array(1),'class'=>array(1,6),'csoport'=>$AUTH['my']['categories']));
     $ADAT['kerdoiv'] = getKerdoiv(_POLICY);
 
     $ev=date('Y');$honap=date('m');$nap=date('d');
diff --git a/mayor-orig/mayor-portal/www/policy/public/portal/portal/portal-pre.php b/mayor-orig/mayor-portal/www/policy/public/portal/portal/portal-pre.php
index d02f5484..44906949 100644
--- a/mayor-orig/mayor-portal/www/policy/public/portal/portal/portal-pre.php
+++ b/mayor-orig/mayor-portal/www/policy/public/portal/portal/portal-pre.php
@@ -14,7 +14,14 @@
 //    $ADAT['nevnap']['ma'] = getNevnap(date('m'),date('d'));
 //    $ADAT['nevnap']['holnap'] = getNevnap(date('m'),date('d')+1);
 
-    $FILTER=array('tolDt'=>date('Y-m-d H:i:s'), 'igDt'=>date('Y-m-d H:i:s'),'flag'=>array(1),'class'=>array(1));
+    $ADAT['kategoriak'] = getKategoriak();
+    for ($i=0; $i<count($ADAT['kategoriak']); $i++) {
+        $RESTRICTKATEGORIA[] = intval($ADAT['kategoriak'][$i]['id']);
+    }
+    $kategoriaId = readVariable($_GET['kategoriaId'],'id',null,$RESTRICTKATEGORIA);
+    $ADAT['kategoriaId'] = $kategoriaId;
+
+    $FILTER=array('tolDt'=>date('Y-m-d H:i:s'), 'igDt'=>date('Y-m-d H:i:s'),'flag'=>array(1),'class'=>array(1),'kategoria'=>array($kategoriaId));
     if (defined('__PORTAL_RESTRICT_CID')) 
 	$FILTER['cid'] = explode(',',__PORTAL_RESTRICT_CID);
 
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/portal.css b/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/portal.css
index 5152e545..9ea85cbc 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/portal.css
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/css/portal.css
@@ -68,6 +68,13 @@
 
     div.egyHir span.tag { background-color: #bbb; padding: 0px 4px; margin: 0px 2px; border-radius:2px; color:white;}
 
+    div.egyHirmeta a { color: #aaa; border-bottom: dotted 1px #bbb}
+    div.egyHirmeta a:hover { color: #444; border-bottom: solid 1px #bbb}
+
+    h2.hirKategoriaSelected { text-align: center; padding-left:22px; padding-right:22px; color: #7d96a0 ; text-decoration: underline solid #eee; font-weight:100; letter-spacing:2px; font-size: 24px; font-variant:small-caps}
+    h2.hirKategoriaSelected a  { display:none; color: #d64161; padding-left: 6px; font-size:14px;}
+    h2.hirKategoriaSelected:hover { padding-right:0px;}
+    h2.hirKategoriaSelected:hover a { display: inline-block;}
 
 div.egyHir:after {
   clear: both;
@@ -87,7 +94,7 @@ hr {display: none;}
     table.portalMain div.dobozTart a { color: black }
 
     
-    div.static h1 { margin: 20px;}
+    div.static h1 { margin: 20px; }
     div.static p { margin-left: 26px; margin-right:26px; margin-bottom: 1.2rem; font-size: 14px; line-height:1.6em;}
     
 @media (max-width: 850px) {
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
index f24068ca..e3a31005 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/egyhir.phtml
@@ -57,7 +57,7 @@
 			}
 			echo '</select>';
 		    }
-		    _putKategoriak($ADAT,$HIR['cid']);
+		    // _putKategoriak($ADAT,$HIR['cid']);
 
 	    	echo '</td>';
 		echo '<td style="line-height:2em; max-width: 300px">';
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/hirekAdmin.phtml b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/hirekAdmin.phtml
index 1f55154a..a995e638 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/hirekAdmin.phtml
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/hirek/hirekAdmin.phtml
@@ -40,7 +40,7 @@
 	$FLAGS = array(0=>'nem látszik', 1=>'látszik', 2=>2, 3=>3);
 	$now = time();
 	echo '<table class="hAdmin hideShowContainer" align="center" cellspacing="1">';
-	echo '<tr><td colspan="7"><button type="button" class="onClickHideShow">Mindent mutass!</button></td></tr>'."\n";
+	echo '<tr><th colspan="7"><button type="button" class="onClickHideShow"> + Mindent mutass! + </button></th></tr>'."\n";
 	for ($i=0; $i<count($ADAT['szovegek']); $i++) {
 	    $D = $ADAT['szovegek'][$i];
 	    if ($D['class']==0) $_class='class="unk"'; else 
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/share/hirek.phtml b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/share/hirek.phtml
index 37812ac0..5a1c26b5 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/share/hirek.phtml
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/html/share/hirek.phtml
@@ -9,6 +9,16 @@
 	    }
 
 	} else {
+
+	  $KATEGORIAID2LEIRAS = (reindex($ADAT['kategoriak'],array('id')));
+
+	  if ($ADAT['kategoriaId']>0 && $KATEGORIAID2LEIRAS[$ADAT['kategoriaId']][0]['leiras']!='') {
+		echo '<h2 class="hirKategoriaSelected">';
+		    echo ucfirst($KATEGORIAID2LEIRAS[$ADAT['kategoriaId']][0]['leiras']);
+		    echo '<a href="'.href('index.php?page=portal&f=portal&sub=portal').'" class="icon-remove-sign"></a>';
+		echo '</h2>';
+	  }
+
 	  for ($i=0; $i<count($ADAT['hirek']['szovegek']); $i++) {
 
 	    $D = $ADAT['hirek']['szovegek'][$i];
@@ -34,7 +44,13 @@
 			for ($j=0; $j<count($CSOPORT); $j++) echo '<span class="tag">'.$CSOPORT[$j].'</span>';
 			//echo '</span>';
 		    }
-
+		    if ($D['hirkategoriak']!='') {
+			$D['kategoriaIdk'] = explode(',',$D['hirkategoriak']);
+			for ($j=0; $j<count($D['kategoriaIdk']); $j++ ) {
+			    echo ' · ';
+			    echo '<a href="'.href('index.php?page=portal&sub=portal&f=portal&kategoriaId='.$D['kategoriaIdk'][$j]).'" class="hirkategoriaLeiras">'.$KATEGORIAID2LEIRAS[$D['kategoriaIdk'][$j]][0]['leiras'].'</a>';
+			}
+		    }
 		echo '</div>';
 	    }
 	    echo '<div class="hir">';
diff --git a/mayor-orig/mayor-portal/www/skin/classic/module-portal/javascript/portal.jquery.min.js b/mayor-orig/mayor-portal/www/skin/classic/module-portal/javascript/portal.jquery.min.js
index 41d70923..55364674 100644
--- a/mayor-orig/mayor-portal/www/skin/classic/module-portal/javascript/portal.jquery.min.js
+++ b/mayor-orig/mayor-portal/www/skin/classic/module-portal/javascript/portal.jquery.min.js
@@ -23,6 +23,15 @@ $(function() {
 	});
     });
 
+	$('#kategoriaSelectorContainer').html('');
+       $('span.kategoriaSelector.selected').each(function() {
+       $('<input />', { 
+           type: 'hidden', 
+           name: 'kategoriaId[]', 
+           value: $(this).data('kategoriaid')
+       }).appendTo($('#kategoriaSelectorContainer')); 
+	});
+
 
 /*
    myForm.on('submit', function(e) {
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index 9bce5583..de4ba040 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4695
+4710
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index 39f0774c..c59d4b06 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4695
-8006f6a2333f838cf1c3a4c464aed480  mayor-fenntarto-rev4695.tgz
-0413e87eaa2472d46297b1b1e67964c9  mayor-installer-sulix-rev4695.tgz
-7b1958ba242c788088f8e0fa8b19ac06  mayor-wiki-rev4695.tgz
-ce7a02daded0bc1a5b9379455fe7d497  mayor-installer-rev4695.tgz
-31a165054c79b9638a9d31cdaedb2f28  mayor-portal-rev4695.tgz
-d4f27043abc3a93c21d8939bd1ecb2e5  mayor-felveteli-rev4695.tgz
-93cab4f2a25ecae24063f2a189884046  mayor-jatek-rev4695.tgz
-2d3becd23208144f80333ee7855359d3  mayor-locales-jp_JP-rev4695.tgz
-9bd9f2a196265369cf9edc46c17adf51  mayor-locales-de_DE-rev4695.tgz
-620f79072f95112bc578085c4bb0829b  mayor-locales-en_US-rev4695.tgz
-c869569cb053d07c3b3fc97f47c7a86e  mayor-naplo-rev4695.tgz
-79f3aac8fcfb484b28f30467c7056505  mayor-base-rev4695.tgz
+Revision 4710
+cb8cda74ec914985cfc33eeb1c0f600b  mayor-fenntarto-rev4710.tgz
+fce4128a082128b51ccd3c1f7da49d16  mayor-installer-sulix-rev4710.tgz
+57cf545c827177cc44b1b976799235e0  mayor-wiki-rev4710.tgz
+6093ef06efd2db548e5e6478e277df76  mayor-installer-rev4710.tgz
+6020d68cd542a943247ae84e62f82271  mayor-portal-rev4710.tgz
+bfeaeacfbb2e08af566791a15d22e94f  mayor-felveteli-rev4710.tgz
+92806a3648b8ae4d97cf4931539bc2ac  mayor-jatek-rev4710.tgz
+77ecb781efc6202022fbc0c88c339944  mayor-locales-jp_JP-rev4710.tgz
+52e12bcaca7f74a4be364bc52babfd3c  mayor-locales-de_DE-rev4710.tgz
+91ef318a14aed435ef505255cefde6d0  mayor-locales-en_US-rev4710.tgz
+b54133612c87fd2c3de6094485296e19  mayor-naplo-rev4710.tgz
+1386d084c17d51d0fd101f37c37b02bd  mayor-base-rev4710.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index 9bce5583..de4ba040 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4695
+4710
diff --git a/rev.txt b/rev.txt
index 9bce5583..de4ba040 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4695
+4710
-- 
cgit v1.2.3


From eba77eabc9b033ef3b904eec7737bc997db37596 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Wed, 25 Nov 2020 13:30:04 +0100
Subject: Rev: 4712

---
 mayor-orig/mayor-base/log/mayor-base.rev           |  2 +-
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |  2 +-
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |  2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |  2 +-
 .../log/mayor-installer-sulix.rev                  |  2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |  2 +-
 .../log/mayor-locales-de_DE.rev                    |  2 +-
 .../log/mayor-locales-en_US.rev                    |  2 +-
 .../log/mayor-locales-jp_JP.rev                    |  2 +-
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 .../private/naplo/haladasi/hazifeladat-pre.php     |  3 ++-
 .../policy/private/naplo/tools/getOraAdat-pre.php  |  4 +++-
 .../www/skin/classic/module-naplo/css/naplo.css    |  7 ++++++
 .../module-naplo/html/haladasi/hazifeladat.phtml   |  6 ++++-
 .../install/mayor-portal/mysql/mayor-portal.sql    |  2 +-
 mayor-orig/mayor-portal/log/mayor-portal.rev       |  2 +-
 .../update/rev004710-1-mayor_portal.sql            | 12 ++++++++++
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |  2 +-
 mayor-orig/md5sum                                  | 26 +++++++++++-----------
 mayor-orig/rev.txt                                 |  2 +-
 rev.txt                                            |  2 +-
 21 files changed, 57 insertions(+), 31 deletions(-)
 create mode 100644 mayor-orig/mayor-portal/update/rev004710-1-mayor_portal.sql

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/haladasi/hazifeladat-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/haladasi/hazifeladat-pre.php
index 86ca57a0..a973e454 100644
--- a/mayor-orig/mayor-naplo/www/policy/private/naplo/haladasi/hazifeladat-pre.php
+++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/haladasi/hazifeladat-pre.php
@@ -80,7 +80,8 @@
 	}
 	if ($oraId>0 && $ADAT['oraAdat']['oraBeirhato']===true ) {
 	    $leiras = readVariable($_POST['oraLeiras'],'string');
-	    updateHaladasiNaploOra($oraId, $leiras);
+	    $cimkeId = readVariable($_POST['cimkeId'],'string');
+	    updateHaladasiNaploOra($oraId, $leiras, $cimkeId);
 	}
     } elseif (__TANAR===true && $action=='lattam') {
 	$lr = db_connect('naplo');
diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/tools/getOraAdat-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/tools/getOraAdat-pre.php
index 064bc796..308e7b4f 100644
--- a/mayor-orig/mayor-naplo/www/policy/private/naplo/tools/getOraAdat-pre.php
+++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/tools/getOraAdat-pre.php
@@ -25,7 +25,8 @@
 	$dolgozatBeirhato = $oraBeirhato;
 	if ($oraBeirhato===true && $action=='oraBeiras') {
 	    $leiras = readVariable($_POST['leiras'], 'string');
-	    updateHaladasiNaploOra($oraId,$leiras);
+	    $cimkeId = readVariable($_POST['cimkeId'], 'id');
+	    updateHaladasiNaploOra($oraId,$leiras,$cimkeId);
 	}
 	$_JSON['oraAdat'] = $ORAADAT = getOraAdatById($oraId);
 	if ($ORAADAT['hazifeladatId']>0) {
@@ -56,6 +57,7 @@
 	        <input class="mayorToken" type="hidden" name="mayorToken" value="'.$_SESSION['mayorToken'].'" />
 	        <input type="hidden" name="action" value="oraBeiras" />
 	        <input type="hidden" name="oraId" value="'.$oraId.'" />
+	        <input type="hidden" name="cimkeId" value="'.$_JSON['oraAdat']['cimkeId'].'" />
 	        <textarea name="leiras" style="margin-top:8px; width:99%; height:100px;">'. supertext($_JSON['oraAdat']['leiras']).'</textarea>';
 	    $oraForm .= '<button type="button" class="setOraAdat mentes" value="mentés" data-oraid="'.$oraId.'"><span class="icon-ok"></span> MENTÉS </button>';
 	    $oraForm .= '</form>';
diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/naplo.css b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/naplo.css
index f12a5b14..c88905c2 100644
--- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/naplo.css
+++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/naplo.css
@@ -251,6 +251,13 @@
     div.arckepContainer.szulo span {background-color: #40e0d0; }
     div.arckepContainer.diak span {background-color: #6495ed; }
 
+    span.cimke { margin:0px 1px; border-radius: 2px; font-size:xx-small; color:white; padding: 0px 2px 0px 2px;  background-color:#ddd; }
+    span.cimke_0 { background-color: #4caf50; }
+    span.cimke_1 { background-color: red; }
+    span.cimke_2 { background-color: orange; }
+    span.cimke_3 { background-color: #3f51b5; }
+    span.cimke_4 { background-color: #673ab7; }
+
 @media (max-width: 764px) {
 
     #toolBarTitle {display:;}
diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml
index 419fbc49..dd9c3687 100644
--- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml
+++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml
@@ -8,8 +8,11 @@
 	    echo ($ADAT['oraAdat']['dt']).' ('.$ADAT['oraAdat']['dt'].'), '.$ADAT['oraAdat']['ora'].'. '._ORA;
 	    echo '</span>';
 	    echo ' – <span class="tankorNev tankorAdat" data-tankorid="'.$ADAT['oraAdat']['tankorId'].'">'.$ADAT['oraAdat']['tankorNev'].'</span>';
+	    if ($ADAT['oraAdat']['cimkeLeiras']!='') {
+		echo ' – '.'<span class="cimke cimke_'.(intval($ADAT['oraAdat']['cimkeId'])%5).'">'.$ADAT['oraAdat']['cimkeLeiras'].'</span>';
+	    }
 	    echo ' – <span class="tanarNev" data-tanarid="'.$ADAT['oraAdat']['ki'].'">'.$ADAT['oraAdat']['kiCn'].'</span>';
-	    // echo '<p>'.$ADAT['oraAdat']['leiras'].'</p>';
+
 
 	echo '</fieldset>'."\n";
 
@@ -124,6 +127,7 @@ echo '<style type="text/css">
 	    if ($skin != 'ajax') formBegin(array('class'=>'hazifeladat'));
 	    echo '<input type="hidden" name="action" value="hazifeladatBeiras"/>';
 	    echo '<input type="hidden" name="oraId" value="'.$ADAT['oraAdat']['oraId'].'"/>';
+	    echo '<input type="hidden" name="cimkeId" value="'.$ADAT['oraAdat']['cimkeId'].'"/>';
 	    echo '<input type="hidden" name="hazifeladatId" value="'.$ADAT['hazifeladatId'].'"/>';
 
 	    echo '<fieldset class="adatok"><legend>'.ucfirst(_TANANYAG).'</legend>'."\n";
diff --git a/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql b/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql
index 61655882..f53e34a7 100644
--- a/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql
+++ b/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql
@@ -41,7 +41,7 @@ CREATE TABLE `hirek` (
   `lang` varchar(5) default 'hu_HU',
   `cim` text,
   `txt` text,
-  `owner` varchar(10) default NULL,
+  `owner` varchar(255) default NULL,
   `flag` tinyint(3) unsigned NOT NULL default '0',
   `cid` tinyint(3) unsigned NOT NULL default '0',
   `pic` varchar(20) default NULL,
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/mayor-portal/update/rev004710-1-mayor_portal.sql b/mayor-orig/mayor-portal/update/rev004710-1-mayor_portal.sql
new file mode 100644
index 00000000..5ac98672
--- /dev/null
+++ b/mayor-orig/mayor-portal/update/rev004710-1-mayor_portal.sql
@@ -0,0 +1,12 @@
+DELIMITER $$
+DROP PROCEDURE IF EXISTS upgrade_database_4710 $$
+
+CREATE PROCEDURE upgrade_database_4710()
+BEGIN
+SET NAMES utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE `hirek` MODIFY `owner` varchar(255) DEFAULT NULL;
+
+END $$
+DELIMITER ;
+CALL upgrade_database_4710();
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index de4ba040..acbf96c3 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4710
+4712
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index c59d4b06..a2be5a7a 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4710
-cb8cda74ec914985cfc33eeb1c0f600b  mayor-fenntarto-rev4710.tgz
-fce4128a082128b51ccd3c1f7da49d16  mayor-installer-sulix-rev4710.tgz
-57cf545c827177cc44b1b976799235e0  mayor-wiki-rev4710.tgz
-6093ef06efd2db548e5e6478e277df76  mayor-installer-rev4710.tgz
-6020d68cd542a943247ae84e62f82271  mayor-portal-rev4710.tgz
-bfeaeacfbb2e08af566791a15d22e94f  mayor-felveteli-rev4710.tgz
-92806a3648b8ae4d97cf4931539bc2ac  mayor-jatek-rev4710.tgz
-77ecb781efc6202022fbc0c88c339944  mayor-locales-jp_JP-rev4710.tgz
-52e12bcaca7f74a4be364bc52babfd3c  mayor-locales-de_DE-rev4710.tgz
-91ef318a14aed435ef505255cefde6d0  mayor-locales-en_US-rev4710.tgz
-b54133612c87fd2c3de6094485296e19  mayor-naplo-rev4710.tgz
-1386d084c17d51d0fd101f37c37b02bd  mayor-base-rev4710.tgz
+Revision 4712
+58c3a908ac6c47b264d9c97c050bd3bd  mayor-fenntarto-rev4712.tgz
+8e8360e59413398833af2d1c25cdb99a  mayor-installer-sulix-rev4712.tgz
+20e4bddd751039d937afa56d99959869  mayor-wiki-rev4712.tgz
+dde325efee1db53bb4c4388b4002df58  mayor-installer-rev4712.tgz
+4d7b12a7fcf3229c757c008104021fd2  mayor-portal-rev4712.tgz
+08123717b7ceed610968b0b6cc78cded  mayor-felveteli-rev4712.tgz
+2efc50b93cd5b9a849fd063a6a8b4523  mayor-jatek-rev4712.tgz
+637d3e4edffc6840a831e41d84443b92  mayor-locales-jp_JP-rev4712.tgz
+37e9bc8b52a7d83176bd660611d466ad  mayor-locales-de_DE-rev4712.tgz
+a3b30626e585c285ca6635169219b2ec  mayor-locales-en_US-rev4712.tgz
+38c4be37ac4d964ecc81deadb74c6553  mayor-naplo-rev4712.tgz
+0cb609ef44637d0ed42f3f22afb29e08  mayor-base-rev4712.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index de4ba040..acbf96c3 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4710
+4712
diff --git a/rev.txt b/rev.txt
index de4ba040..acbf96c3 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4710
+4712
-- 
cgit v1.2.3


From 5da1f06dce90826029f42c5e214f1e66f8dae0da Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Thu, 26 Nov 2020 16:25:04 +0100
Subject: Rev: 4713

---
 mayor-orig/mayor-base/log/mayor-base.rev           |  2 +-
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |  2 +-
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |  2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |  2 +-
 .../log/mayor-installer-sulix.rev                  |  2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |  2 +-
 .../log/mayor-locales-de_DE.rev                    |  2 +-
 .../log/mayor-locales-en_US.rev                    |  2 +-
 .../log/mayor-locales-jp_JP.rev                    |  2 +-
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 .../module-naplo/html/haladasi/hazifeladat.phtml   |  3 ++-
 mayor-orig/mayor-portal/log/mayor-portal.rev       |  2 +-
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |  2 +-
 mayor-orig/md5sum                                  | 26 +++++++++++-----------
 mayor-orig/rev.txt                                 |  2 +-
 rev.txt                                            |  2 +-
 16 files changed, 29 insertions(+), 28 deletions(-)

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml
index dd9c3687..00077ba0 100644
--- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml
+++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml
@@ -131,7 +131,8 @@ echo '<style type="text/css">
 	    echo '<input type="hidden" name="hazifeladatId" value="'.$ADAT['hazifeladatId'].'"/>';
 
 	    echo '<fieldset class="adatok"><legend>'.ucfirst(_TANANYAG).'</legend>'."\n";
-		if ($ADAT['oraAdat']['oraId']>0 && strtotime(date('Y-m-d'))>=strtotime($ADAT['oraAdat']['dt']) && $ADAT['oraAdat']['oraBeirhato']===true) {
+//		if ($ADAT['oraAdat']['oraId']>0 && strtotime(date('Y-m-d'))>=strtotime($ADAT['oraAdat']['dt']) && $ADAT['oraAdat']['oraBeirhato']===true) {
+		if ($ADAT['oraAdat']['oraId']>0 && $ADAT['oraAdat']['oraBeirhato']===true ) {
 		    echo '<input type="text" name="oraLeiras" value="'.$ADAT['oraAdat']['leiras'].'" style="width:70%">';
 		    echo '<input type="submit">';
 		} else {
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4712
+4713
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index a2be5a7a..8cf1cb8b 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4712
-58c3a908ac6c47b264d9c97c050bd3bd  mayor-fenntarto-rev4712.tgz
-8e8360e59413398833af2d1c25cdb99a  mayor-installer-sulix-rev4712.tgz
-20e4bddd751039d937afa56d99959869  mayor-wiki-rev4712.tgz
-dde325efee1db53bb4c4388b4002df58  mayor-installer-rev4712.tgz
-4d7b12a7fcf3229c757c008104021fd2  mayor-portal-rev4712.tgz
-08123717b7ceed610968b0b6cc78cded  mayor-felveteli-rev4712.tgz
-2efc50b93cd5b9a849fd063a6a8b4523  mayor-jatek-rev4712.tgz
-637d3e4edffc6840a831e41d84443b92  mayor-locales-jp_JP-rev4712.tgz
-37e9bc8b52a7d83176bd660611d466ad  mayor-locales-de_DE-rev4712.tgz
-a3b30626e585c285ca6635169219b2ec  mayor-locales-en_US-rev4712.tgz
-38c4be37ac4d964ecc81deadb74c6553  mayor-naplo-rev4712.tgz
-0cb609ef44637d0ed42f3f22afb29e08  mayor-base-rev4712.tgz
+Revision 4713
+ce702c78ab1e2f4cc031757497de783a  mayor-fenntarto-rev4713.tgz
+f8f436cbfda29f04f4f9d6d45096ed2b  mayor-installer-sulix-rev4713.tgz
+8c02ce059544cdea9de78844e2301ca7  mayor-wiki-rev4713.tgz
+2e8da272ceb62adcab9ebd892db87bc8  mayor-installer-rev4713.tgz
+50b92c062c3980ceb8703c75528124c9  mayor-portal-rev4713.tgz
+0dc99f57b5c2ce5850451ae6d8f9c6b1  mayor-felveteli-rev4713.tgz
+dbe1d335412f36acf16aae503180c154  mayor-jatek-rev4713.tgz
+4f165a284865baf556b6fc83a622da7a  mayor-locales-jp_JP-rev4713.tgz
+42558feb4dd9bd06ff0cdaa37ee0c668  mayor-locales-de_DE-rev4713.tgz
+8ec41cb9c101c60dc9c8576d1ac1c931  mayor-locales-en_US-rev4713.tgz
+ff759af5c9d054cfb59fe5db3bc4a247  mayor-naplo-rev4713.tgz
+bfc0ee9cf71c3fc76b4bc409deb53063  mayor-base-rev4713.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index acbf96c3..b9dafcc3 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4712
+4713
diff --git a/rev.txt b/rev.txt
index acbf96c3..b9dafcc3 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4712
+4713
-- 
cgit v1.2.3


From 6096375432ff70c57cb832cd4fcbb031eeaa3765 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Wed, 6 Jan 2021 18:25:04 +0100
Subject: Rev: 4715

---
 mayor-orig/mayor-base/log/mayor-base.rev           |  2 +-
 .../include/backend/mysql/session/accountInfo.php  |  6 ++---
 .../www/include/backend/mysql/session/base.php     |  2 +-
 .../backend/mysql/session/createAccount.php        |  2 +-
 .../include/backend/mysql/session/createGroup.php  |  4 ++--
 .../backend/mysql/session/search/searchAccount.php |  8 +++----
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |  2 +-
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |  2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |  2 +-
 .../log/mayor-installer-sulix.rev                  |  2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |  2 +-
 .../log/mayor-locales-de_DE.rev                    |  2 +-
 .../log/mayor-locales-en_US.rev                    |  2 +-
 .../log/mayor-locales-jp_JP.rev                    |  2 +-
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 mayor-orig/mayor-portal/log/mayor-portal.rev       |  2 +-
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |  2 +-
 mayor-orig/md5sum                                  | 26 +++++++++++-----------
 mayor-orig/rev.txt                                 |  2 +-
 rev.txt                                            |  2 +-
 20 files changed, 38 insertions(+), 38 deletions(-)

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-base/www/include/backend/mysql/session/accountInfo.php b/mayor-orig/mayor-base/www/include/backend/mysql/session/accountInfo.php
index 113e380b..5643f0af 100644
--- a/mayor-orig/mayor-base/www/include/backend/mysql/session/accountInfo.php
+++ b/mayor-orig/mayor-base/www/include/backend/mysql/session/accountInfo.php
@@ -140,7 +140,7 @@
 	    $_THESE = '*';
 	    $v = array();
 	}
-	$q = "SELECT $_THESE FROM groups WHERE groupCn='%s' AND policy='%s'";
+	$q = "SELECT $_THESE FROM `groups` WHERE groupCn='%s' AND policy='%s'";
 
 	array_push($v, $groupCn, $toPolicy);
 	$A = db_query($q, array('fv' => 'mysqlGetGroupInfo', 'modul' => $modul, 'result' => 'record', 'values' => $v), $lr);
@@ -185,7 +185,7 @@
 	$lr = db_connect($modul, array('fv' => 'mysqlChangeGroupInfo'));
         if (!$lr) return false;
 
-	$q = "SELECT gid FROM groups WHERE groupCn='%s' AND policy='%s'";
+	$q = "SELECT gid FROM `groups` WHERE groupCn='%s' AND policy='%s'";
 	$v = array($groupCn, $toPolicy);
 	$gid = db_query($q, array('fv' => 'mysqlChangeGroupInfo', 'modul' => $modul, 'result' => 'value', 'values' => $v), $lr);
 	if ($gid === false) { db_close($lr); return false; }
@@ -241,7 +241,7 @@
 			    $v = array($attr);
 			}
                     }
-		    $q = "UPDATE groups SET $W WHERE groupCn='%s' AND policy='%s'";
+		    $q = "UPDATE `groups` SET $W WHERE groupCn='%s' AND policy='%s'";
 		    array_push($v, $groupCn, $toPolicy);
 		    db_query($q, array('fv' => 'mysqlChangeGroupInfo', 'modul' => $modul, 'values' => $v), $lr);
         	}
diff --git a/mayor-orig/mayor-base/www/include/backend/mysql/session/base.php b/mayor-orig/mayor-base/www/include/backend/mysql/session/base.php
index 35272ff8..2964957b 100644
--- a/mayor-orig/mayor-base/www/include/backend/mysql/session/base.php
+++ b/mayor-orig/mayor-base/www/include/backend/mysql/session/base.php
@@ -32,7 +32,7 @@
 	}
 
 	// Az gid lekérdezése
-	$q = "SELECT gid FROM groups WHERE groupCn = '%s' AND policy = '%s'";
+	$q = "SELECT gid FROM `groups` WHERE groupCn = '%s' AND policy = '%s'";
 	$v = array($groupCn, $toPolicy);
 	$gid = db_query($q, array('fv' => 'mysqlMemberOf', 'modul' => $modul, 'result' => 'value', 'values' => $v), $lr);
 	if ($gid === false) {
diff --git a/mayor-orig/mayor-base/www/include/backend/mysql/session/createAccount.php b/mayor-orig/mayor-base/www/include/backend/mysql/session/createAccount.php
index 25ff9132..4f34aea6 100644
--- a/mayor-orig/mayor-base/www/include/backend/mysql/session/createAccount.php
+++ b/mayor-orig/mayor-base/www/include/backend/mysql/session/createAccount.php
@@ -79,7 +79,7 @@
 		$category = $SET['groups'][$i];
 		$groupCn = kisbetus(ekezettelen($category));
 		if ($category == '') continue;
-		$q = "SELECT gid FROM groups WHERE groupCn='%s'";
+		$q = "SELECT gid FROM `groups` WHERE groupCn='%s'";
 		$gid = db_query($q, array('fv' => 'mysqlCreateAccount', 'modul' => $modul, 'result' => 'value', 'values' => array($groupCn)), $lr);
 		if ($gid === false || is_null($gid)) { // --FIXME -- ez jó így BENCE radyx
 		    if ($SET['createGroup']) {
diff --git a/mayor-orig/mayor-base/www/include/backend/mysql/session/createGroup.php b/mayor-orig/mayor-base/www/include/backend/mysql/session/createGroup.php
index d1bc4f7b..495af44d 100644
--- a/mayor-orig/mayor-base/www/include/backend/mysql/session/createGroup.php
+++ b/mayor-orig/mayor-base/www/include/backend/mysql/session/createGroup.php
@@ -16,14 +16,14 @@
         if (!$lr) return false;
 
 	// cn ütközés ellenőrzése
-	$q = "SELECT COUNT(*) FROM groups WHERE policy='%s' AND groupCn='%s'";
+	$q = "SELECT COUNT(*) FROM `groups` WHERE policy='%s' AND groupCn='%s'";
 	$v = array($toPolicy, $groupCn);
 	$num = db_query($q, array('fv' => 'mysqlCreateGroup', 'modul' => $modul, 'result' => 'value', 'values' => $v), $lr);
 	if ($num === false) { db_close($lr); return false; }
 	if ($num > 0) { $_SESSION['alert'][] = 'message:multi_uid:'.$groupCn; db_close($lr); return false; }
 
 	// csoport felvétel
-	$q = "INSERT INTO groups (groupCn, groupDesc, policy) VALUES ('%s', '%s','%s')";
+	$q = "INSERT INTO `groups` (groupCn, groupDesc, policy) VALUES ('%s', '%s','%s')";
 	$v = array($groupCn, $groupDesc, $toPolicy);
 	$gid = db_query($q, array('fv' => 'mysqlCreateGroup', 'modul' => $modul, 'result' => 'insert', 'values' => $v), $lr);
 	if ($gid === false) { db_close($lr); return false; }
diff --git a/mayor-orig/mayor-base/www/include/backend/mysql/session/search/searchAccount.php b/mayor-orig/mayor-base/www/include/backend/mysql/session/search/searchAccount.php
index fa4584b0..ef249342 100644
--- a/mayor-orig/mayor-base/www/include/backend/mysql/session/search/searchAccount.php
+++ b/mayor-orig/mayor-base/www/include/backend/mysql/session/search/searchAccount.php
@@ -64,7 +64,7 @@
     	if (!$lr) return false;
 	// Keresés
 	if ($attr == 'member') {
-	    $q = "SELECT `".implode('`,`', array_fill(0, count($searchAttrs), '%s'))."` FROM groups LEFT JOIN members 
+	    $q = "SELECT `".implode('`,`', array_fill(0, count($searchAttrs), '%s'))."` FROM `groups` LEFT JOIN members 
 		ON members.gid=groups.gid
 		LEFT JOIN accounts USING (uid)
 		WHERE gid IN 
@@ -72,7 +72,7 @@
 		AND groups.policy='%s'";
 	    $v = array_merge($searchAttrs, array($pattern, $toPolicy, $toPolicy));
 	} else {
-	    $q = "SELECT DISTINCT `".implode('`,`', array_fill(0, count($searchAttrs), '%s'))."` FROM groups LEFT JOIN members 
+	    $q = "SELECT DISTINCT `".implode('`,`', array_fill(0, count($searchAttrs), '%s'))."` FROM `groups` LEFT JOIN members 
 		ON members.gid=groups.gid
 		LEFT JOIN accounts USING (uid)
 		WHERE `%s` LIKE '%%%s%%' AND groups.policy='%s'";
@@ -122,7 +122,7 @@
 
 	    $homeDirectory = $ret['homeDirectory']; // de nem használjuk semmire...
 	    // A user csoport törlése
-	    $q = "DELETE FROM groups WHERE gid=%u";
+	    $q = "DELETE FROM `groups` WHERE gid=%u";
 	    $v = array($ret['uid']);
 	    $r = db_query($q, array('fv' => 'mysqlDeleteAccount', 'modul' => $modul, 'values' => $v), $lr);
 	    if (!$r) { db_close($lr); return false; }
@@ -155,7 +155,7 @@
         }
 
         // csoport törlése
-	$q = "DELETE FROM groups WHERE policy='%s' AND groupCn='%s'";
+	$q = "DELETE FROM `groups` WHERE policy='%s' AND groupCn='%s'";
 	$v = array($toPolicy, $groupCn);
 	$r = db_query($q, array('fv' => 'mysqlDeleteGroup', 'modul' => "$toPolicy auth", 'values' => $v));
 
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4713
+4715
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index 8cf1cb8b..0808638e 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4713
-ce702c78ab1e2f4cc031757497de783a  mayor-fenntarto-rev4713.tgz
-f8f436cbfda29f04f4f9d6d45096ed2b  mayor-installer-sulix-rev4713.tgz
-8c02ce059544cdea9de78844e2301ca7  mayor-wiki-rev4713.tgz
-2e8da272ceb62adcab9ebd892db87bc8  mayor-installer-rev4713.tgz
-50b92c062c3980ceb8703c75528124c9  mayor-portal-rev4713.tgz
-0dc99f57b5c2ce5850451ae6d8f9c6b1  mayor-felveteli-rev4713.tgz
-dbe1d335412f36acf16aae503180c154  mayor-jatek-rev4713.tgz
-4f165a284865baf556b6fc83a622da7a  mayor-locales-jp_JP-rev4713.tgz
-42558feb4dd9bd06ff0cdaa37ee0c668  mayor-locales-de_DE-rev4713.tgz
-8ec41cb9c101c60dc9c8576d1ac1c931  mayor-locales-en_US-rev4713.tgz
-ff759af5c9d054cfb59fe5db3bc4a247  mayor-naplo-rev4713.tgz
-bfc0ee9cf71c3fc76b4bc409deb53063  mayor-base-rev4713.tgz
+Revision 4715
+43fdcbb79107f40fc3120c57db417c4b  mayor-fenntarto-rev4715.tgz
+391093a3387a8ee3b79138fb010fbb7f  mayor-installer-sulix-rev4715.tgz
+122579371c590ad98e90f3407594cfa2  mayor-wiki-rev4715.tgz
+1ff2a02bc1b4b9c2781f98cc59760880  mayor-installer-rev4715.tgz
+a01109b8c8ad5240a9bace962f8f8fc5  mayor-portal-rev4715.tgz
+914440be442874ecc05078524270d735  mayor-felveteli-rev4715.tgz
+fd7d743f8212b7327098231f4bed480e  mayor-jatek-rev4715.tgz
+2fc85c4d675f2cc19007ad334c6e821b  mayor-locales-jp_JP-rev4715.tgz
+9137d63cd72829caadc5e4a0904b45a9  mayor-locales-de_DE-rev4715.tgz
+505bba3d3f63b1eed0e95b04bff71ce1  mayor-locales-en_US-rev4715.tgz
+a094cc484b6c9c2fb391eef4794117fd  mayor-naplo-rev4715.tgz
+65448272b6e696a2f7db451664345822  mayor-base-rev4715.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index b9dafcc3..a29b5fa9 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4713
+4715
diff --git a/rev.txt b/rev.txt
index b9dafcc3..a29b5fa9 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4713
+4715
-- 
cgit v1.2.3


From fb24a50c54d5776468e49def08aea44c4077eb47 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Wed, 20 Jan 2021 14:00:03 +0100
Subject: Rev: 4716

---
 mayor-orig/mayor-base/log/mayor-base.rev           |  2 +-
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |  2 +-
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |  2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |  2 +-
 .../log/mayor-installer-sulix.rev                  |  2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |  2 +-
 .../log/mayor-locales-de_DE.rev                    |  2 +-
 .../log/mayor-locales-en_US.rev                    |  2 +-
 .../log/mayor-locales-jp_JP.rev                    |  2 +-
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 .../mayor-naplo/update/pre004715-1-intezmeny.sql   | 12 ++++++++++
 mayor-orig/mayor-portal/log/mayor-portal.rev       |  2 +-
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |  2 +-
 mayor-orig/md5sum                                  | 26 +++++++++++-----------
 mayor-orig/rev.txt                                 |  2 +-
 rev.txt                                            |  2 +-
 16 files changed, 39 insertions(+), 27 deletions(-)
 create mode 100644 mayor-orig/mayor-naplo/update/pre004715-1-intezmeny.sql

(limited to 'mayor-orig/mayor-naplo')

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-naplo/update/pre004715-1-intezmeny.sql b/mayor-orig/mayor-naplo/update/pre004715-1-intezmeny.sql
new file mode 100644
index 00000000..485aab2a
--- /dev/null
+++ b/mayor-orig/mayor-naplo/update/pre004715-1-intezmeny.sql
@@ -0,0 +1,12 @@
+DELIMITER $$
+DROP PROCEDURE IF EXISTS upgrade_database_4715 $$
+
+CREATE PROCEDURE upgrade_database_4715()
+BEGIN
+SET NAMES utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE zaroJegy MODIFY `megjegyzes` enum('dicséret','figyelmeztető','') COLLATE utf8_hungarian_ci DEFAULT NULL;
+
+END $$
+DELIMITER ;
+CALL upgrade_database_4715();
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index 0808638e..5531868f 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4715
-43fdcbb79107f40fc3120c57db417c4b  mayor-fenntarto-rev4715.tgz
-391093a3387a8ee3b79138fb010fbb7f  mayor-installer-sulix-rev4715.tgz
-122579371c590ad98e90f3407594cfa2  mayor-wiki-rev4715.tgz
-1ff2a02bc1b4b9c2781f98cc59760880  mayor-installer-rev4715.tgz
-a01109b8c8ad5240a9bace962f8f8fc5  mayor-portal-rev4715.tgz
-914440be442874ecc05078524270d735  mayor-felveteli-rev4715.tgz
-fd7d743f8212b7327098231f4bed480e  mayor-jatek-rev4715.tgz
-2fc85c4d675f2cc19007ad334c6e821b  mayor-locales-jp_JP-rev4715.tgz
-9137d63cd72829caadc5e4a0904b45a9  mayor-locales-de_DE-rev4715.tgz
-505bba3d3f63b1eed0e95b04bff71ce1  mayor-locales-en_US-rev4715.tgz
-a094cc484b6c9c2fb391eef4794117fd  mayor-naplo-rev4715.tgz
-65448272b6e696a2f7db451664345822  mayor-base-rev4715.tgz
+Revision 4716
+0f149dad48a74cdfd6db3ce36573b331  mayor-fenntarto-rev4716.tgz
+7e22010b99732f93605b078d36e69081  mayor-installer-sulix-rev4716.tgz
+2d5749d97df238b72eab1bf77ec6a271  mayor-wiki-rev4716.tgz
+afad598f7355efbca1f13c554fb7e964  mayor-installer-rev4716.tgz
+9d6d2711f8e2c8179011790fe573c045  mayor-portal-rev4716.tgz
+b7b2abdc8a6d7d8b38d92b6a28fa6ac4  mayor-felveteli-rev4716.tgz
+42ed1ddcfd864bef749cfa062495c5d3  mayor-jatek-rev4716.tgz
+b3388a5cb6503038338f51c1526e862c  mayor-locales-jp_JP-rev4716.tgz
+91a9afd725673ff17d817f0772341f12  mayor-locales-de_DE-rev4716.tgz
+dfca36e6a631328724b05dc7318e124f  mayor-locales-en_US-rev4716.tgz
+6730ac88c50aa7282647e4e81f0864d9  mayor-naplo-rev4716.tgz
+c184a7209b582c9b97489c9c938fe145  mayor-base-rev4716.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4715
+4716
diff --git a/rev.txt b/rev.txt
index a29b5fa9..7e1fd933 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4715
+4716
-- 
cgit v1.2.3