1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
|
<?php
function updateLevelToken($oktid) {
if ($oktid=='') return false;
$token = bin2hex(openssl_random_pseudo_bytes(20));
$ip = _clientIp();
$q = "INSERT INTO levelLog_"._FELVETELI_EVE." (oktid,generalasDt,ip,token) VALUES ('%s',NOW(),'%s','%s')";
$v = array($oktid,$ip,$token);
db_Query($q,array('modul'=>'felveteli','values'=>$v,'debug'=>false),$lr);
return $token;
}
function checkLevelToken($token) {
}
function getIrasbeliEredmeny($nev,$oId,$an=null,$szuldt=null) {
$lr = @db_connect('felveteli');
if ($oId != '') {
$q = "SELECT * FROM irasbeli_eredmenyek_"._EV." WHERE nev='%s' AND oId='%s'";
$RET = db_query($q,array('modul'=>'felveteli', 'result'=>'indexed','values'=>array($nev,$oId),'debug'=>false),$lr);
} else {
$q = "SELECT * FROM irasbeli_eredmenyek_"._EV." WHERE nev='%s' AND an='%s' AND szuldt='%s'";
$RET = db_query($q,array('modul'=>'felveteli', 'result'=>'indexed','values'=>array($nev,$an,$szuldt),'debug'=>false),$lr);
}
db_close($lr);
return $RET;
}
function getFelvetelizoAdatok($nev,$oktid) {
$lr = db_connect('felveteli');
$q = "SELECT count(*) AS db FROM adatok_"._EV." WHERE (nev='$nev' or jelige='$nev') AND oktid='$oktid'";
$c = db_query($q,array('result'=>'value'),$lr);
if ($c==1) {
$q = "SELECT *,(magyar+matek)*0.8+IF(atlag<4,0,(atlag-4)*10+10) AS hozottpont,IF(matek2>0,(magyar+matek2)*0.8+IF(atlag<4,0,(atlag-4)*10+10),0) AS hozottpont2 FROM adatok_"._EV." WHERE (nev='$nev' or jelige='$nev') AND oktid='$oktid'";
$Rtmp = db_query($q,array('result'=>'indexed'),$lr);
$R = $Rtmp[0];
$q = "SELECT * FROM iskolak WHERE omkod like '%".$R['OM']."' LIMIT 1";
$Rtmp = db_query($q,array('result'=>'indexed'),$lr);
$R['iskolaAdat'] = $Rtmp[0];
} else {
$_SESSION['alert'][] = 'info:none_or_multiple:'.$c;
}
if ($lr) db_close($lr);
return $R;
}
function getSzobeli($jid, $olr = '') {
if (!is_numeric($jid)) return false;
if ($olr=='') $lr = db_connect('felveteli'); else $lr=$olr;
// 2012 // $q = "SELECT * FROM szobeli_"._EV." WHERE jid=$jid ORDER BY napdt,ido,tagozat";
$q = "SELECT * FROM szobeli_"._EV." AS sz LEFT JOIN jelentkezes"._EV." AS jel ON sz.id=jel.id AND sz.tagozat=jel.tid
WHERE sz.id=$jid ORDER BY napdt,ido,tagozat";
$R = db_query($q,array('result'=>'indexed'),$lr);
if ($olr=='') db_close($lr);
return $R;
}
function getIdeiglenesRangsor($oktid) {
if (!is_numeric($oktid)) return false;
if ($olr=='') $lr = db_connect('felveteli'); else $lr=$olr;
$q = "SELECT jid,tagozat,pont,szobeli,rangsor FROM eredmenyek_tagozatonkent_"._EV." WHERE oktid=$oktid";
$R = db_query($q,array('result'=>'indexed'),$lr);
if ($olr=='') db_close($lr);
var_dump($R);
return $R;
}
function getIdeiglenesRangsor_old($jid) {
if (!is_numeric($jid)) return false;
if ($olr=='') $lr = db_connect('felveteli'); else $lr=$olr;
$q = "SELECT jid,tagozat,szobeli,rangsor FROM eredmenyek_tagozatonkent_"._EV." WHERE jid=$jid";
$R = db_query($q,array('result'=>'indexed'),$lr);
if ($olr=='') db_close($lr);
return $R;
}
//-- RÉGI!!!
/*
function getFelvetelizoAdatok($nev,$diak = '',$oktid = '') {
if ($diak!='') $W = "diak='$diak'";
elseif($oktid!='') $W = "oktid='$oktid'";
else return false;
$lr = @db_connect('felveteli');
if (_CATEGORY=='admin')
$query = "SELECT * FROM adatok_"._EV." WHERE (nev='$nev' or jelige='$nev')";
else $query = "SELECT * FROM adatok_"._EV." WHERE (nev='$nev' or jelige='$nev') AND ".$W;
$result = @mysql_query($query,$lr);
if (($db=@mysql_num_rows($result))==0) {
$ret = false;
} elseif ($db==2) {
$ret = 'multi';
} else {
$ret = @mysql_fetch_assoc($result);
}
$r = @mysql_query("SELECT * FROM iskolak WHERE omkod='".$ret['OM']."' LIMIT 1",$lr);
if (@mysql_num_rows($r)==1) {
$ret['iskolaAdat'] = @mysql_fetch_assoc($r);
}
@mysql_close($lr);
return $ret;
}
function getSzobeliEredmeny($jid) {
$lr = @db_connect('felveteli');
// $query = "SELECT * FROM szobeli_"._EV." WHERE jid=$jid ORDER BY napdt,ido";
//2. $query = "SELECT jid,kod as tagozat, eredmeny,pont FROM jelentkezok_tagozatok WHERE jid=$jid";
$query = "SELECT jid,kod as tagozat,rangsor as eredmeny,pont,szobeli FROM eredmenyek_tagozatonkent_"._EV." WHERE jid=$jid";
$result = @mysql_query($query,$lr);
if (($db=@mysql_num_rows($result))==0) {
$ret = false;
} else {
while ($sor = @mysql_fetch_assoc($result)) {
$ret[] = $sor;
}
}
@mysql_close($lr);
return $ret;
}
*/
?>
|
