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 "
";
$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 "".mysql_field_name($result, $i)." | ";
print "
\n";
for ($r=0;$r".$radka[$i]."";
print "";
}
print "
";
}
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 "".mysql_field_name($result, $i)." | ";
print "
\n";
for ($r=0;$r".$radka[$i]."";
print "";
}
print "
";
}
}