0); } function CountRow ($conn,$db,$tabulka,$where="") { $sql="select count(*) from $tabulka"; if ($where!="") $sql.= " where $where"; $result = mysql_db_query ($db, $sql, $conn); if (!$result) return -1; list ($pocet) = mysql_fetch_array ($result); return $pocet; } function CountRowCurrentDb ($conn,$tabulka,$where="") { $sql="select count(*) from $tabulka"; if ($where!="") $sql.= " where $where"; $result = db_query ($conn, $sql); if (!$result) return -1; if (eregi("group by",$sql)) return db_num_rows($result); else return db_fetch_scalar ($result); } function CountGroupCurrentDb ($conn,$tabulka,$where="",$groupby="") { $sql="select * from $tabulka"; if ($where!="") $sql.= " where $where"; if ($groupby!="") $sql.= " group by $groupby"; $result = db_query ($conn, $sql); if (!$result) return -1; return db_num_rows ($result); } function MoveRow ($conn,$db_zdroj,$tabulka_zdroj,$conn_cil,$db_cil,$tabulka_cil,$where,$over=true) { if (CopyRow ($conn,$db_zdroj,$tabulka_zdroj,$conn_cil,$db_cil,$tabulka_cil,$where)) return DeleteRow ($conn,$db_zdroj,$tabulka_zdroj,$where); else return false; } function CopyRow ($conn,$db_zdroj,$tabulka_zdroj,$conn_cil,$db_cil,$tabulka_cil,$where,$over=true) { $chyba=0; $exists = ExistRow ($conn_cil,$db_cil,$tabulka_cil,$where); if (!$exists || $over) { if ($exists) DeleteRow ($conn_cil,$db_cil,$tabulka_cil,$where); $sql="select * from $tabulka_zdroj where $where"; //printsql ($sql); $result = mysql_db_query ($db_zdroj, $sql, $conn); if (!$result) { $chyba++; printred ("Nastala chyba při čtení dat z tabulky $tabulka_zdroj, kde $where.
\n"); } else { $num_fields = mysql_num_fields($result); $radka = mysql_fetch_array ($result); for ($i=0;$i<$num_fields;$i++) { $field_name=mysql_field_name($result, $i); $polozky.=",$field_name"; $hodnoty.=",'$radka[$i]'"; } $polozky=substr($polozky,1); $hodnoty=substr($hodnoty,1); $sql="INSERT INTO $tabulka_cil ($polozky) VALUES ($hodnoty)"; //printsql ($sql); $result = mysql_db_query ($db_cil, $sql, $conn_cil); if (!$result) { $chyba++; printred ("Nastala chyba při kopírování dat z tabulky $tabulka_zdroj, kde $where do tabulky $tabulka_cil.
\n"); } else return true; } } else return false; } function DuplicateRow ($conn,$tabulka,$where="",$except_fields=false) { $sql="select * from $tabulka where $where"; //printsql ($sql); $result = db_query ($conn,$sql); if (!$result) { $chyba++; printred ("Nastala chyba při čtení dat z tabulky $tabulka_zdroj, kde $where.
\n"); return false; } else { $num_fields = mysql_num_fields($result); $radka = db_fetch_array ($result); for ($i=0;$i<$num_fields;$i++) { $field_name=mysql_field_name($result, $i); if (is_array($except_fields)) if ($except_fields[$field_name]) $radka[$i]=$except_fields[$field_name]; $polozky.=",$field_name"; $hodnoty.=",'$radka[$i]'"; } $polozky=substr($polozky,1); $hodnoty=substr($hodnoty,1); $sql="INSERT INTO $tabulka ($polozky) VALUES ($hodnoty)"; //printsql ($sql); $result = db_query ($conn,$sql); if (!$result) { $chyba++; printred ("Nastala chyba při kopírování dat z tabulky $tabulka kde $where.
\n"); return false; } } if (!$chyba) return true; } function GetCurrentGroup ($conn,$AccessNumber,$typ="AccessNumber") { switch ($typ) { case "AccessNumber": $CurrentUser = GetCurrentUser($conn,$AccessNumber); return GetCurrentGroupFromID ($conn,$CurrentUser->group_id); break; case "group_id": $group_id=$AccessNumber; return GetCurrentGroupFromID ($conn,$group_id); break; case "group_name": $group_name=$AccessNumber; return GetCurrentGroupFromName($conn,$group_name); break; } } function GetCurrentGroupFromName($conn,$group_name) { return GetObjectWhere($conn,"skupiny","jmeno='$group_name'"); } function GetCurrentGroupFromWhere ($conn,$group_name) { return GetCurrentGroupFromName ($conn,$group_name); } function GetCurrentGroupFromID ($conn,$group_id) { return GetObjectFromID($conn,"skupiny",$group_id); } function GetCurrentUser($conn,$AccessNumber) { $sql = "SELECT *, decode(password,'piccolo') as password FROM members WHERE accessnumber='$AccessNumber'"; return db_query_object ($conn,$sql); } function GetCurrentSession($conn,$AccessNumber) { $sql = "SELECT * FROM form_session WHERE accessnumber='$AccessNumber'"; return db_query_object ($conn,$sql); } function GetUserFromID($conn,$TheID,$group_id=0) { $sql = "SELECT *, decode(password,'piccolo') as password FROM members WHERE id='$TheID'"; if ($group_id) $sql.=" and group_id=$group_id"; return db_query_object ($conn,$sql); } function GetObjectFromID($conn,$tabulka,$TheID) { $sql = "SELECT * FROM $tabulka WHERE id='$TheID'"; return db_query_object ($conn,$sql); } function GetObjectWhere($conn,$tabulka,$where) { $sql = "SELECT * FROM $tabulka WHERE $where"; return db_query_object ($conn,$sql); } function GetNewID ($conn,$table,$where="") { $sql = "SELECT Max(id) AS MaxId FROM $table"; if ($where!="") $sql=$sql." where $where"; //echo $sql; $result = db_query ($conn,$sql); if ($result==0)$MaxID=0; else { list($MaxID) = db_fetch_array($result); } return $MaxID+1; } function GetNewID_rok ($conn,$table) { return GetNewID ($conn,"$table","rok=".date('Y')); } function GetNewID_group ($conn,$table,$group_id) { return GetNewID ($conn,"$table","group_id='$group_id'"); } function ResultAll($conn,$table,$where="") { print "

$table:

"; $sql = "SELECT * FROM $table"; if ($where!="") $sql.=" where $where"; $result = db_query($conn,"SELECT * FROM $table"); print "\n"; $num_fields=mysql_num_fields($result); for ($i=0;$i<$num_fields;$i++) print ""; print "\n"; for ($r=0;$r".$radka[$i].""; print ""; } print "
".mysql_field_name($result, $i)."
"; } function DrawResult($result) { if ($result==1) print "\nPříkaz byl proveden.
\n"; else if ($result==0) print "\nPříkaz byl chybný.
\n"; else { print "\n"; $num_fields=mysql_num_fields($result); for ($i=0;$i<$num_fields;$i++) print ""; print "\n"; for ($r=0;$r".$radka[$i].""; print ""; } print "
".mysql_field_name($result, $i)."

"; } }