# Struktura tabeli dla 'galery_a'
#

CREATE TABLE galery_a (
  id int(8) NOT NULL auto_increment,
  title varchar(64) NOT NULL,
  text text NOT NULL,
  date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  author varchar(32) NOT NULL,
  PRIMARY KEY (id)
);

#
# Zawartosc tabeli 'galery_a'
#

INSERT INTO galery_a VALUES ( '1', 'American Trucks', '', '2004-03-08 17:01:46', 'admin');
INSERT INTO galery_a VALUES ( '2', 'Samochody europejskie', '', '2004-03-08 17:02:12', 'admin');

# --------------------------------------------------------
#
# Struktura tabeli dla 'galery_b'
#

CREATE TABLE galery_b (
  id int(32) NOT NULL auto_increment,
  cat varchar(32) NOT NULL,
  title varchar(64) NOT NULL,
  date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  name varchar(16) DEFAULT '0' NOT NULL,
  size varchar(32) NOT NULL,
  PRIMARY KEY (id)
);

#
# Zawartosc tabeli 'galery_b'
#

<?


function module_start($cmd) {



if($cmd=='add_now') {
add_row();
}
}

function module_main($cmd) {

global $gbook_limit, $page;

if($cmd=='') {

main_title_open();
echo 'Galeria';
main_title_close();
main_text_open();
list_cat();
main_text_close();

}  


if($cmd<>'') {

main_title_open();
echo 'Galeria';
main_title_close();
main_text_open();
echo '<br>';
show_minis($cmd, $page);
main_text_close();

}  

}

function module_info($co) {

if($co=='title')
return 'galeria';

}


function module_type() {
return 'normal';
}

?>
<?

function list_cat() {

global $PHP_SELF, $op;

if(!function_exists(gal_inc)) include('module/galery.inc.php');

$query = "SELECT * FROM $gal_a_tbl ORDER BY title";
$result = mysql_query($query);
$ile = mysql_num_rows($result);

echo '<br>';

while($r = mysql_fetch_array($result)) {

$id = $r['id'];
$title = $r['title'];
$text = $r['text'];

$text = stripslashes($text);
$title = stripslashes($title);
$text = make_clickable($text);

$title = '<a href="module.php?op='.$op.'&cmd='.$id.'" class="t_list">'.$title.'</a></b>';


$qu = "SELECT * FROM $gal_b_tbl WHERE cat='$id'";
$re = mysql_query($qu);
$ile = mysql_num_rows($re);

$others = 'obrazów: <b>'.$ile.'</b>';

list_open();
list_body_open($title, $text, $others);
list_close();
}
}


function show_minis($cat, $page) {

global $art_tbl, $PHP_SELF, $arts, $op;

if(!function_exists(gal_inc)) include('module/galery.inc.php');

$query = "SELECT * FROM $gal_b_tbl WHERE cat='$cat' ORDER BY date DESC";
$result = mysql_query($query);
$ile = mysql_num_rows($result);


if($ile==0) echo '<center>Nie znaleziono żadnych obrazów w tej kategorii</center><br>';
else {

if($ile<>0) {
$znk = $page * $gal_limit;
mysql_data_seek($result, $znk);  
}

$aaa = 0;
$cols = 0;

echo '<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr>';

while($r = mysql_fetch_array($result)) {

$id = $r['id'];
$name = $r['name'];
$size = $r['size'];

if($cols==$gal_cols) {
$cols = 0;
echo '</tr>
<tr>';
}

echo '<td align="center" class="uni_02"><a href="uploads/galery/'.$id.'.'.$name.'" target="_blank"><img src="uploads/galery/m'.$id.'.'.$name.'" border="0"></a><br>
['.$size.'kB]</td>';


$aaa++;
$cols++;
if($aaa==$gal_limit) break;
}

echo '</tr>
</table>';

echo '<br><center>';
$ile = mysql_num_rows($result);
if($ile<>0) {
$arts= $ile;
$ile = $ile / $gal_limit;
$ile = ceil($ile);

$bbb = 0;
while($bbb<>$ile) {

$ccc = $bbb + 1;
if($page==$bbb) {
echo '[<b>'.$ccc.'</b>] ';
} else {
echo '[<a href="module.php?op='.$op.'&page='.$bbb.'&cmd='.$cat.'">'.$ccc.'</a>] ';
}

$bbb++;
}
} else {
echo '[<b>1</b>] ';
}
}
}

?>

<?

if(!function_exists(gal_inc)) {
function gal_inc() {}
}


$gal_a_tbl = 'galery_a';
$gal_b_tbl = 'galery_b';

$gal_cols = '4';
$gal_limit = '4';

?>