class kDbConnection { var $error_level = 0; var $error_die_conn = false; var $error_last_code = -1; var $db_host = "10.0.3.1"; var $db_user = "mvlsz_dev"; var $db_pass = "gdhnYJA8"; var $db_name = "mvlsz_dev"; var $conn = false; var $last_query = false; var $last_trhead = false; function kDbConnection($db="", $host="", $user="", $pass="" ){ if( $db != "" ){ $db_name = $db; } if( $host != "" ){ $db_host = $host; } if( $user != "" ){ $db_user = $user; $db_pass = $pass; } } function doConnect($db="", $host="", $user="", $pass=""){ getConn($db, $host, $user, $pass); } function connect(){ if($conn){ select_db( $db ); } } function _connect( $db="", $host="", $user="", $pass="" ){ if( $host == "" ){ $host = $db_host; } if( $user == "" ){ $user = $db_user; $pass = $db_pass; } if( $db == "" ){ $db = $db_name; } $conn = @mysql_connect($host,$user,$pass) or error(0,$host,$user); $db_host = $host; $db_user = $user; $db_pass = $pass; if( $conn ){ $select_db( $db ); } } function select_db( $dbName ){ @mysql_select_db( $dbName,getConn() ) or error(1,$dbName); $db_name = $dbName; $GLOBALS["kConn"] =& getConn(); } function getConn(){ if( @get_resource_type($conn) != "mysql link" ){ _connect(); } return $conn; } function query( $sql ){ if( !($conn = getConn()) ){ return false; } select_db( $db_name ); $last_query = $sql; $result = @mysql_query($sql, $conn ) or error(2,$sql); $last_trhead = $result; return $result; } function unbuffered_query( $sql ){ if( !($conn = getConn()) ){ return false; } $last_query = $sql; $result = @mysql_unbuffered_query($sql, $conn ) or error(2,$sql); $last_trhead = $result; return $result; } function fetch( $thread = "use_last_res", $resType = "num" ){ if( !($conn = getConn()) ){ return false; } if( $last_query === false ){ return false; } if( $thread == "use_last_res" ){ $thread = $last_trhead; } if( @get_resource_type($thread) != "mysql result" ){ error(3,"fetch"); } $resType = strToLOwer($resType); switch( $resType ){ case "assoc": $row = @mysql_fetch_array( $thread, MYSQL_ASSOC ); break; case "both": $row = @mysql_fetch_array( $thread, MYSQL_BOTH ); break; default: $row = @mysql_fetch_array( $thread, MYSQL_NUM ); break; } return $row; } function assoc( $thread = "use_last_res" ){ if( !($conn = getConn()) ){ return false; } if( $last_query === false ){ return false; } if( $thread == "use_last_res" ){ $thread = $last_trhead; } if( @get_resource_type($thread) != "mysql result" ){ error(4,"assoc"); } $row = @mysql_fetch_assoc( $thread ); return $row; } function num( $thread = "use_last_res" ){ if( !($conn = getConn()) ){ return false; } if( $last_query === false ){ return false; } if( $thread == "use_last_res" ){ $thread = $last_trhead; } if( @get_resource_type($thread) != "mysql result" ){ error(5,"num"); } $num = @mysql_num_rows( $thread ); return $num; } function getNextId( $table ){ if( getConn() == false ){ return false; } $sql = "SHOW TABLE STATUS LIKE '$table' "; $res = query($sql); $row = assoc($res); $nextID = $row["Auto_increment"]; return $nextID; } function setDebugLevel($level){ $error_level = $level; } function error(){ $code = func_get_arg(0); if( $code == $error_last_code ){ return false; } $params = func_get_args(); switch( $code ){ case 0: $msg = "[Can't connect to ".$params[2]."@".$params[1]." !]"; $die = $error_die_conn; $conn = false; break; case 1: $msg = "[Can't select db ".$params[1]." !]"; $die = false; $conn = false; break; case 2: $msg = "[Wrong query: ".$params[1]." !]"; $die = false; $conn = false; $last_query = false; break; case 3: break; case 4: break; case 5: break; $msg = "[Missing thread resource! (".$params[1].")]"; $die = false; $conn = false; break; } $errorStr = "DB_ERROR (".$code.") "; switch( $error_level ){ case 1: echo $errorStr; break; case 2: echo $errorStr." - ".$msg." "; break; default: break; } if( $die){ die(); } $error_last_code = $code; } function startLockTables( $tablesStr ){ $tables = explode(",",$tablesStr ); $sqlTables = ""; foreach( $tables as $table ) { if( $sqlTables != "" ){ $sqlTables .= ", "; } $sqlTables .= $table." WRITE "; } query("LOCK TABLES ".$sqlTables); } function endLockTables(){ query("UNLOCK TABLES"); } function getSingleFieldValue( $tbl, $field, $where ){ $return = false; $sql = "SELECT $field FROM $tbl WHERE $where LIMIT 0,1"; $res = query($sql); if(num($res)!=0){ $row = fetch($res,"num"); $return = $row[0]; } return $return; } function getRecord( $tbl, $field, $where){ return getSingleFieldValue($tbl, $field, $where); } function getSingleRow( $tbl, $fields="", $where, $resType = "assoc" ){ $return = false; if( $fields == "" ){ $fields = "*"; } $sql = "SELECT $fields FROM $tbl WHERE $where LIMIT 0,1"; $res = query($sql); if( num($res) != 0 ) { $return = fetch($res, $resType); } return $return; } function getRow($tbl, $fields="", $where, $resType = "assoc"){ return getSingleRow($tbl, $fields="", $where, $resType); } function getSingleRowSql( $sql, $resType = "assoc" ){ $return = false; $sql = $sql." LIMIT 0,1"; $res = query($sql); if( num($res) != 0 ) { $return = fetch($res, $resType); } return $return; } function getRowSql( $sql, $resType = "assoc" ){ return getSingleRowSql($sql, $resType); } function sqlUpdate( $tbl, $set, $where ){ return query("UPDATE $tbl SET $set WHERE $where"); } function getDataSet($sql,$resType="assoc"){ $dataSet["sql"]=$sql; $dataSet["recordCount"]=0; dataSet["rows"]=array(); $res = query($sql); $dataSet["recordCount"] = num($res); if( $dataSet["recordCount"] != 0 ){ while($row = fetch($res,$resType)){ $dataSet["rows"][] = $row; } } return $dataSet; } } ?>
Vodafone Kupa |
Official report:
|
| Magyaro./Hungary | Hajós Alfréd Sportuszoda 50m-es 2010. augusztus 22. 11:15 hours Match ID: 9799 |
Spanyolo./Spain | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
( 3-2,
2-1,
2-4,
2-0 ) (final result) |
||||||||||||||||||||||||
|
GOALS |
|
||||||||||||||||||||||
| 7 / 3 | EXTRA PLAYER/GOALS |
5 / 3 | ||||||||||||||||||||||
| 2 / 1 | PENALTIES/GOALS |
1 / 1 | ||||||||||||||||||||||
|
|
EXCLUSION w/SUBST. |
|
||||||||||||||||||||||
|
|
Excluded |
|
|
|
|
| Kemény Dénes Dr., MÁTÉFALVY Csaba, | - | AGUILAR Rafael, |
|
|
| Referee(s): | |
| Delegate(s): | |
| Secretary(es): | Hangay Zsolt |
| Timekeeper(s): | Pék Gyula |
| Q. | Time | Event | Standing | Name | Team |
|---|---|---|---|---|---|
| I. | 08:00 | Competition sprint | Garcia Mario (2) | Spanyolo. (ESP) | |
| I. | 07:31 | Saved action shot | Perrone Felipe (10) | Spanyolo. (ESP) | |
| I. | 07:31 | Posession | Magyaro. (HUN) | ||
| I. | 07:01 | Missed center shot | Kis Gábor (11) | Magyaro. (HUN) | |
| I. | 07:01 | Posession | Spanyolo. (ESP) | ||
| I. | 06:45 | Missed action shot | Garcia Javier (12) | Spanyolo. (ESP) | |
| I. | 06:45 | Posession | Magyaro. (HUN) | ||
| I. | 06:18 | Turnover foul | Kis Gábor (11) | Magyaro. (HUN) | |
| I. | 06:07 | Steal | Hosnyánszki Norbert (6) | Magyaro. (HUN) | |
| I. | 05:38 | Exclusion centre forward | Perrone Felipe (10) | Spanyolo. (ESP) | |
| I. | 05:20 | Saved extra player | Madaras Norbert (3) | Magyaro. (HUN) | |
| I. | 05:20 | Posession | Spanyolo. (ESP) | ||
| I. | 04:52 | Missed action shot | Garcia Javier (12) | Spanyolo. (ESP) | |
| I. | 04:52 | Posession | Magyaro. (HUN) | ||
| I. | 04:31 | Missed action shot | Varga Dániel (9) | Magyaro. (HUN) | |
| I. | 04:31 | Posession | Spanyolo. (ESP) | ||
| I. | 04:09 | Missed action shot | Minguell Marc (6) | Spanyolo. (ESP) | |
| I. | 04:09 | Blocked shot | Madaras Norbert (3) | Magyaro. (HUN) | |
| I. | 04:09 | Posession | Magyaro. (HUN) | ||
| I. | 03:55 | Goal action shot | 1 : 0 | Madaras Norbert (3) | Magyaro. (HUN) |
| I. | 03:38 | Turnover foul | Sziranyi Balazs (4) | Spanyolo. (ESP) | |
| I. | 03:25 | Saved action shot | Madaras Norbert (3) | Magyaro. (HUN) | |
| I. | 03:25 | Corner throw | Magyaro. (HUN) | ||
| I. | 03:24 | Goal center shot | 2 : 0 | Hárai Balázs (12) | Magyaro. (HUN) |
| I. | 03:04 | Saved center shot | Sziranyi Balazs (4) | Spanyolo. (ESP) | |
| I. | 03:04 | Posession | Magyaro. (HUN) | ||
| I. | 02:36 | Steal | Minguell Marc (6) | Spanyolo. (ESP) | |
| I. | 02:17 | Saved action shot | Mallabach Blai (11) | Spanyolo. (ESP) | |
| I. | 02:17 | Posession | Magyaro. (HUN) | ||
| I. | 01:47 | Saved center shot | Hárai Balázs (12) | Magyaro. (HUN) | |
| I. | 01:47 | Posession | Spanyolo. (ESP) | ||
| I. | 01:18 | Penalty foul | Varga Dániel (9) | Magyaro. (HUN) | |
| I. | 01:18 | Penalty throw - goal | 2 : 1 | Molina Guillermo (5) | Spanyolo. (ESP) |
| I. | 01:01 | Exclusion in the field | Minguell Marc (6) | Spanyolo. (ESP) | |
| I. | 00:45 | Goal extra player | 3 : 1 | Hosnyánszki Norbert (6) | Magyaro. (HUN) |
| I. | 00:23 | Exclusion centre forward | Kis Gábor (11) | Magyaro. (HUN) | |
| I. | 00:12 | Goal extra player | 3 : 2 | Valles Javier (9) | Spanyolo. (ESP) |
| I. | 00:00 | Missed free throw | Madaras Norbert (3) | Magyaro. (HUN) | |
| I. | 00:00 | Blocked shot | Garcia Mario (2) | Spanyolo. (ESP) | |
| I. | 00:00 | Period End | |||
| II. | 08:00 | Competition sprint | Garcia Mario (2) | Spanyolo. (ESP) | |
| II. | 07:30 | Missed action shot | Garcia Javier (12) | Spanyolo. (ESP) | |
| II. | 07:30 | Posession | Magyaro. (HUN) | ||
| II. | 07:17 | Exclusion centre forward | Garcia Mario (2) | Spanyolo. (ESP) | |
| II. | 07:01 | Goal extra player | 4 : 2 | Kis Gábor (11) | Magyaro. (HUN) |
| II. | 06:42 | Exclusion centre forward | Bundschuh Erik (5) | Magyaro. (HUN) | |
| II. | 06:23 | Missed extra player | Perrone Felipe (10) | Spanyolo. (ESP) | |
| II. | 06:23 | Blocked shot | Szívós Márton (8) | Magyaro. (HUN) | |
| II. | 06:23 | Posession | Spanyolo. (ESP) | ||
| II. | 06:22 | Goal extra player | 4 : 3 | Gallego Ivan (7) | Spanyolo. (ESP) |
| II. | 05:52 | Saved action shot | Szívós Márton (8) | Magyaro. (HUN) | |
| II. | 05:52 | Posession | Spanyolo. (ESP) | ||
| II. | 05:34 | Steal | Hárai Balázs (12) | Magyaro. (HUN) | |
| II. | 05:08 | Steal | Gallego Ivan (7) | Spanyolo. (ESP) | |
| II. | 04:55 | Turnover foul | Espanol Albert (8) | Spanyolo. (ESP) | |
| II. | 04:27 | Penalty foul | Martin David (3) | Spanyolo. (ESP) | |
| II. | 04:27 | Penalty throw - missed | Varga Dénes (4) | Magyaro. (HUN) | |
| II. | 04:27 | Posession | Spanyolo. (ESP) | ||
| II. | 04:04 | Steal | Varga Dénes (4) | Magyaro. (HUN) | |
| II. | 03:43 | Saved action shot | Varga Dénes (4) | Magyaro. (HUN) | |
| II. | 03:43 | Posession | Spanyolo. (ESP) | ||
| II. | 03:13 | Missed action shot | Martin David (3) | Spanyolo. (ESP) | |
| II. | 03:13 | Posession | Magyaro. (HUN) | ||
| II. | 02:43 | Missed action shot | Hosnyánszki Norbert (6) | Magyaro. (HUN) | |
| II. | 02:43 | Posession | Spanyolo. (ESP) | ||
| II. | 02:24 | Turnover foul | Sziranyi Balazs (4) | Spanyolo. (ESP) | |
| II. | 02:08 | Steal | Aguilar Inaki (1) | Spanyolo. (ESP) | |
| II. | 01:46 | Missed action shot | Espanol Albert (8) | Spanyolo. (ESP) | |
| II. | 01:46 | Posession | Magyaro. (HUN) | ||
| II. | 01:19 | Steal | Garcia Javier (12) | Spanyolo. (ESP) | |
| II. | 00:59 | Saved action shot | Garcia Javier (12) | Spanyolo. (ESP) | |
| II. | 00:59 | Posession | Magyaro. (HUN) | ||
| II. | 00:30 | Goal action shot | 5 : 3 | Varga Dénes (4) | Magyaro. (HUN) |
| II. | 00:11 | Turnover foul | Valles Javier (9) | Spanyolo. (ESP) | |
| II. | 00:00 | Period End | |||
| III. | 08:00 | Competition sprint | Varga Dániel (9) | Magyaro. (HUN) | |
| III. | 07:33 | Saved action shot | Hosnyánszki Norbert (6) | Magyaro. (HUN) | |
| III. | 07:33 | Corner throw | Magyaro. (HUN) | ||
| III. | 07:21 | Saved center shot | Kis Gábor (11) | Magyaro. (HUN) | |
| III. | 07:21 | Posession | Magyaro. (HUN) | ||
| III. | 07:13 | Turnover foul | Kis Gábor (11) | Magyaro. (HUN) | |
| III. | 06:58 | Exclusion centre forward | Hosnyánszki Norbert (6) | Magyaro. (HUN) | |
| III. | 06:40 | Goal extra player | 5 : 4 | Garcia Javier (12) | Spanyolo. (ESP) |
| III. | 06:23 | Exclusion centre forward | Molina Guillermo (5) | Spanyolo. (ESP) | |
| III. | 06:07 | Saved extra player | Madaras Norbert (3) | Magyaro. (HUN) | |
| III. | 06:07 | Posession | Spanyolo. (ESP) | ||
| III. | 05:48 | Saved action shot | Mallabach Blai (11) | Spanyolo. (ESP) | |
| III. | 05:48 | Posession | Spanyolo. (ESP) | ||
| III. | 05:23 | Saved action shot | Perrone Felipe (10) | Spanyolo. (ESP) | |
| III. | 04:56 | Missed action shot | Szívós Márton (8) | Magyaro. (HUN) | |
| III. | 04:56 | Blocked shot | Garcia Javier (12) | Spanyolo. (ESP) | |
| III. | 04:56 | Posession | Spanyolo. (ESP) | ||
| III. | 04:32 | Exclusion centre forward | Szívós Márton (8) | Magyaro. (HUN) | |
| III. | 04:21 | Missed extra player | Garcia Javier (12) | Spanyolo. (ESP) | |
| III. | 04:21 | Blocked shot | Varga Dániel (9) | Magyaro. (HUN) | |
| III. | 04:21 | Posession | Magyaro. (HUN) | ||
| III. | 04:01 | Exclusion centre forward | Garcia Mario (2) | Spanyolo. (ESP) | |
| III. | 03:49 | Saved extra player | Hosnyánszki Norbert (6) | Magyaro. (HUN) | |
| III. | 03:49 | Corner throw | Magyaro. (HUN) | ||
| III. | 03:41 | Saved extra player | Hosnyánszki Norbert (6) | Magyaro. (HUN) | |
| III. | 03:41 | Posession | Magyaro. (HUN) | ||
| III. | 03:35 | Saved action shot | Madaras Norbert (3) | Magyaro. (HUN) | |
| III. | 03:35 | Posession | Spanyolo. (ESP) | ||
| III. | 03:11 | Goal center shot | 5 : 5 | Sziranyi Balazs (4) | Spanyolo. (ESP) |
| III. | 02:47 | Goal action shot | 6 : 5 | Varga Dénes (4) | Magyaro. (HUN) |
| III. | 02:18 | Missed action shot | Gallego Ivan (7) | Spanyolo. (ESP) | |
| III. | 02:18 | Blocked shot | Hárai Balázs (12) | Magyaro. (HUN) | |
| III. | 02:18 | Posession | Magyaro. (HUN) | ||
| III. | 01:57 | Exclusion centre forward | Gallego Ivan (7) | Spanyolo. (ESP) | |
| III. | 01:53 | Goal extra player | 7 : 5 | Vámos Márton (7) | Magyaro. (HUN) |
| III. | 01:21 | Missed action shot | Garcia Javier (12) | Spanyolo. (ESP) | |
| III. | 01:21 | Blocked shot | Varga Dániel (9) | Magyaro. (HUN) | |
| III. | 01:21 | Posession | Spanyolo. (ESP) | ||
| III. | 01:18 | Goal center shot | 7 : 6 | Valles Javier (9) | Spanyolo. (ESP) |
| III. | 01:00 | Steal | Minguell Marc (6) | Spanyolo. (ESP) | |
| III. | 00:43 | Goal action shot | 7 : 7 | Valles Javier (9) | Spanyolo. (ESP) |
| III. | 00:16 | Steal | Perrone Felipe (10) | Spanyolo. (ESP) | |
| III. | 00:01 | Saved action shot | Minguell Marc (6) | Spanyolo. (ESP) | |
| III. | 00:01 | Corner throw | Spanyolo. (ESP) | ||
| III. | 00:00 | Period End | |||
| IV. | 08:00 | Competition sprint | Garcia Mario (2) | Spanyolo. (ESP) | |
| IV. | 07:32 | Saved action shot | Molina Guillermo (5) | Spanyolo. (ESP) | |
| IV. | 07:32 | Corner throw | Spanyolo. (ESP) | ||
| IV. | 07:01 | Missed action shot | Martin David (3) | Spanyolo. (ESP) | |
| IV. | 07:01 | Posession | Magyaro. (HUN) | ||
| IV. | 06:40 | Turnover foul | Kis Gábor (11) | Magyaro. (HUN) | |
| IV. | 06:18 | Missed action shot | Martin David (3) | Spanyolo. (ESP) | |
| IV. | 06:18 | Posession | Magyaro. (HUN) | ||
| IV. | 05:58 | Saved action shot | Török Béla (2) | Magyaro. (HUN) | |
| IV. | 05:58 | Posession | Spanyolo. (ESP) | ||
| IV. | 05:29 | Saved free throw | Molina Guillermo (5) | Spanyolo. (ESP) | |
| IV. | 05:29 | Posession | Magyaro. (HUN) | ||
| IV. | 05:06 | Exclusion centre forward | Garcia Mario (2) | Spanyolo. (ESP) | |
| IV. | 04:46 | Saved extra player | Madaras Norbert (3) | Magyaro. (HUN) | |
| IV. | 04:46 | Corner throw | Magyaro. (HUN) | ||
| IV. | 04:39 | Steal | Valles Javier (9) | Spanyolo. (ESP) | |
| IV. | 04:24 | Steal | Hosnyánszki Norbert (6) | Magyaro. (HUN) | |
| IV. | 04:15 | Steal | Aguilar Inaki (1) | Spanyolo. (ESP) | |
| IV. | 03:52 | Missed action shot | Molina Guillermo (5) | Spanyolo. (ESP) | |
| IV. | 03:52 | Blocked shot | Szívós Márton (8) | Magyaro. (HUN) | |
| IV. | 03:52 | Posession | Spanyolo. (ESP) | ||
| IV. | 03:50 | Missed center shot | Minguell Marc (6) | Spanyolo. (ESP) | |
| IV. | 03:50 | Posession | Magyaro. (HUN) | ||
| IV. | 03:35 | Goal action shot | 8 : 7 | Madaras Norbert (3) | Magyaro. (HUN) |
| IV. | 03:06 | Missed action shot | Mallabach Blai (11) | Spanyolo. (ESP) | |
| IV. | 03:06 | Blocked shot | Bátori Bence (10) | Magyaro. (HUN) | |
| IV. | 03:06 | Posession | Magyaro. (HUN) | ||
| IV. | 02:48 | Penalty foul | Molina Guillermo (5) | Spanyolo. (ESP) | |
| IV. | 02:48 | Penalty throw - goal | 9 : 7 | Hosnyánszki Norbert (6) | Magyaro. (HUN) |
| IV. | 02:46 | Time Out | Spanyolo. (ESP) | ||
| IV. | 02:18 | Exclusion centre forward | Bundschuh Erik (5) | Magyaro. (HUN) | |
| IV. | 01:53 | Saved extra player | Molina Guillermo (5) | Spanyolo. (ESP) | |
| IV. | 01:52 | Posession | Magyaro. (HUN) | ||
| IV. | 01:25 | Saved action shot | Madaras Norbert (3) | Magyaro. (HUN) | |
| IV. | 01:25 | Posession | Spanyolo. (ESP) | ||
| IV. | 01:08 | Steal | Szívós Márton (8) | Magyaro. (HUN) | |
| IV. | 00:40 | Missed free throw | Varga Dániel (9) | Magyaro. (HUN) | |
| IV. | 00:40 | Blocked shot | Molina Guillermo (5) | Spanyolo. (ESP) | |
| IV. | 00:40 | Posession | Magyaro. (HUN) | ||
| IV. | 00:39 | Time Out | Magyaro. (HUN) | ||
| IV. | 00:10 | Missed action shot | Varga Dániel (9) | Magyaro. (HUN) | |
| IV. | 00:10 | Posession | Spanyolo. (ESP) | ||
| IV. | 00:10 | Time Out | Spanyolo. (ESP) | ||
| IV. | 00:03 | Steal | Szécsi Zoltán (1) | Magyaro. (HUN) |