z gory thxplik catalog.php
[php]<?php
require "./wolf.inc";
function list_records() {
global $user_tablename;
global $default_sort_order, $default_order_by, $records_per_page;
global $sort_order, $order_by, $cur_page;
global $PHP_SELF;
$link_id = db_connect();
if(!$link_id) error_message('Wystapil blad podczas laczenia z baza danych!');
$query = "SELECT count(*) FROM $user_tablename";
$result = mysql_query($query);
if(!$result) error_message('Wystapil blad podczas pobierania danych z tabeli!');
$query_data = mysql_fetch_rows($result);
$total_num_user = $query_data[0];
if(!$total_num_user) error_message('Brak uzytkownikow w katalogu!');
$page_num = $cur_page +1;
$total_num_page = $last_page_num = ceil($total_num_user/$records_per_page);
html_header();
echo "<CENTER><H3>Odnaleziono $total_num_user uzytkownikow. Aktualnie jest wyswietlana strona $page_num z $last_page_num.</H3></CENTER>\n";
if(empty($order_by)) {
$order_by_str = "ORDER BY $defaul_order_by";
$order_by = $default_order_by;
}
else $order_by_str = "ORDER BY $order_by";
if(empty($sort_order)) {
$sort_order_str = $org_sort_order = $default_sort_order;
$sort_order = 'DESC';
}
else {
$sort_order_str = $org_sort_order = $sort_order;
if($sort_order =='DESC') $sort_order = 'ASC';
else $sort_order = 'DESC';
}
if(empty($cur_page)) {
$cur_page = 0;
}
$limit_str = "LIMIT" . $cur_page * $records_per_page . ", $records_per_page";
$query = "SELECT Nick, Postac, Druzyna, Exp, Nazwa_post, Country FROM $user_tablename $order_by-str $sort_order_str $limit_str";
$result = mysql_query($query);
if(!$result) error_message('Wystapil blad podczas wyciagania danych z tabeli!');
?>
<DIV ALIGN="CENTER">
<TABLE BORDER="1" WIDTH="90%" CELLPADDING="2">
<TR>
<TH WIDTH="15%" NOWRAP>
<A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=Nick"; ?>">Nick
</A>
</TH>
<TH WIDTH="15%" NOWRAP>
<A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=Nazwa_post"; ?>">Nazwa postaci
</A>
</TH>
<TH WIDTH="12%" NOWRAP>
<A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=Exp"; ?>">Doswiadczenie
</A>
</TH>
<TH WIDTH="15%" NOWRAP>
<A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=Druzyna"; ?>">Druzyna
</A>
</TH>
<TH WIDTH="15%" NOWRAP>
<A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=Postac"; ?>">Postac
</A>
</TH>
<TH WIDTH="15%" NOWRAP>
<A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=Country"; ?>">Kraj
</A>
</TH>
<TH WIDTH="13%" NOWRAP>Inne informacje</TH>
</TR>
<?php
while($query_data = mysql_fetch_array($result)) {
$Nick = $query_data["Nick"];
$Nazwa_post= $query_data["Nazwa_post"];
$Exp = $query_data["Exp"];
$Druzyna = $query_data["Druzyna"];
$Postac = $query_data["Postac"];
$Country= $query_data["Country"];
echo "<TR>\n";
echo "<TD WIDTH=\"15%\" ALIGN=\"CENTER\">$Nick</TD>\n";
echo "<TD WIDTH=\"15%\" ALIGN=\"CENTER\">$Nazwa_post</TD>\n";
echo "<TD WIDTH=\"12%\" ALIGN=\"CENTER\">$Exp</TD>\n";
echo "<TD WIDTH=\"15%\" ALIGN=\"CENTER\">$Druzyna</TD>\n";
echo "<TD WIDTH=\"15%\" ALIGN=\"CENTER\">$Postac</TD>\n";
echo "<TD WIDTH=\"15%\" ALIGN=\"CENTER\">$Country</TD>\n";
echo "<TD WIDTH=\"13%\" ALIGN=\"CENTER\"><A HREF=\"javascript:open.window('$PHP_SELF?action=view_record&Nick=$Nick'):\">Wiecej</A></TD>\n";
echo "</TR>\n";
}
?>
</TABLE>
</DIV>
<?php
echo "<BR>\n";
echo"<strong><CENTER>";
if($page_num>1){
$prev_page = $cur_page - 1;
echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=0\">[Pierwsza]</A>";
echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=$prev_page\">[Poprzednia]</A>";
if($page_num < $total_num_page) {
$next_page = $cur_page + 1;
$last_page = $total_num_page - 1;
echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=$next_page\">[Nastepna]</A>";
echo "<A HEF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=$last_page\">[Ostatnia]</A>";
}
echo"</STRONG></CENTER>";
html_footer()
}
function view_record() {
global $user_tabelname;
global $Nick;
global $PHP_SELF;
if(empty($Nick)) error_message('Nie udnaloziono tego uzytkownika w bazie danych!');
$link_id = db_connect();
if(!$link_id) error_message('Blad bazy danych!');
$query = "SELECT Miasto, Gadu, IRC, Mail, Kom, Lacze, Postac, Druzyna, Exp, Nazwa_post, Time, Weekends, Country FROM $user_tablename WHERE Nick = '$Nick'";
$result = mysql_query($query);
if(!$result) error_message('Wystapil blad podczas pobierania danych!');
$query_data = mysql_fetch_array($result);
$Nick = $query_data["Nick"];
$Miasto = $query_data["Miasto"];
$Gadu = $query_data["Gadu"];
$IRC = $query_data["IRC"];
$Mail = $query_data["Mail"];
$Kom = $query_data["Kom"];
$Lacze = $query_data["Lacze"];
$Postac= $query_data["Postac"];
$Druzyna = $query_data["Druzyna"];
$Doswiadczenie = $query_data["Exp"];
$Nazwa_post = $query_data["Nazwa_post"];
$Time = $query_data["Time"];
$Weekends = $query_data["Weekends"];
$Country = $query_data["Country"];
html_header();
echo "<CENTER><H3>Inofrmacjeo uzytkowniku $Nick - $Postac, $Nazwa_post</H3></CENTER>";
?>
<DIV ALIGN="CENTER">
<TABLE BORDER="1" WIDTH="90%" CELLPADDING="2">
<TR>
<TH WIDTH="40%">Nick</TH>
<TD WIDTH="60%"><?php echo $Nick; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Nazwa postaci w grze</TH>
<TD WIDTH="60%"><?php echo $Nazwa_post; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Srednie doswiadczenie, ktore zdobywa uzytkownik podczas 1 mapy</TH>
<TD WIDTH="60%"><?php echo $Exp; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Klasa postaci, ktora preferuje uzytkownik</TH>
<TD WIDTH="60%"><?php echo $Postac; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Druzyna, ktora preferuje gracz</TH>
<TD WIDTH="60%"><?php echo $Druzyna; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Adres e-mail</TH>
<TD WIDTH="60%"><?php echo "A HREF=\"mailto:$Mail;">$Mail ; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Numer telefonu komorkowego</TH>
<TD WIDTH="60%"><?php echo $Kom; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Numer ICQ</TH>
<TD WIDTH="60%"><?php echo $IRC; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Numer Gadu-Gadu</TH>
<TD WIDTH="60%"><?php echo $Gadu; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Predkosc lacza uzytkownika</TH>
<TD WIDTH="60%"><?php echo $Lacze; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Ile dziennie spedza czasu przed komputerem (grajac)</TH>
<TD WIDTH="60%"><?php echo $Time; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Czy ma wolne weekendy, by brac udzial w turniejach</TH>
<TD WIDTH="60%"><?php echo $Weekends; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Miasto</TH>
<TD WIDTH="60%"><?php echo $Miasto; ?></TD>
</TR>
<TR>
<TH WIDTH="40%">Kraj</TH>
<TD WIDTH="60%"><?php echo $Country; ?></TD>
</TR>
</TABLE>
</DIV>
<?php
}
html_footer();
}
switch($action) {
case "view_record";
view_record();
break;
default;
list_records();
brea}
?>
[/php]
plik wolf.inc
[php]<?php
$default_sort_order = 'ASC';
$default_order_by = 'Nick';
$records_per_page = 30;
$user_tablename = 'wolf_confirm';
$new_win_width = 600;
$new_win_height = 400;
$MYSQL_ERRNO = '';
$MYSQL_ERROR = '';
function db_connect () {
global $MYSQL_ERRNO, MYSQL_ERROR;
$link_id = mysql_connect;
if(!link_id) {
$MYSQL_ERRNO = 0;
$MYSQL_ERROR = "Nie udalo sie nawiazac polaczenia";
return 0;
}
else return $link_id;
}
function html_header() {
global $new_win_width, $new_win_height;
?>
<HTML>
<HEAD>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
<!--
function open_window(url) {
var NEW_WIN = null;
NEW_WIN = window.open ("", "Przegladarka danych uzytkownikow", "toolbar=no,width="+<?php echo $new_win_width; ?>+", height="+<?php echo $new_win_height;?>+",directories=no,status=no,"+"scrollbars=no,resize=no,menubar=no");
NEW_WIN.location.href = url;
}
//-->
</SCRIPT>
<TITLE>Przegladarka danych uzytkownikow</TITLE>
</HEAD>
<BODY>
<?php
}
function html_footer() {
?>
</BODY>
</HTML>
<?php
}
function error_message($msg) {
html_header();
echo "<SCRIPT>alert(\"Blad: $msg\");history.go(-1)</SCRIPT>";
html_footer();
exit;
}
?> [/php]
