<?php
# Copyright by Manuel
# Support www.ilch.de
defined (
'main'
)
or
die
(
'no direct access'
);
function
db_connect () {
define (
'CONN'
, @mysql_pconnect(DBHOST, DBUSER, DBPASS));
$db
= @mysql_select_db(DBDATE, CONN);
if
(!CONN) {
die
(
'Verbindung nicht möglich, bitte prüfen Sie ihre mySQL Daten wie Passwort, Username und Host<br />'
);
}
if
( !
$db
) {
die
(
'Kann Datenbank "'
.DBDATE.
'" nicht benutzen : '
. mysql_error(CONN));
}
}
function
db_close () {
mysql_close ( CONN );
}
function
db_query (
$query
) {
#
echo
'<br>'
.
$query
.
'<br>'
;
$query
=
str_replace
(
'prefix_'
,DBPREF,
$query
);
$erg
= mysql_query (
$query
, CONN ); #
or
die
( mysql_error(CONN) );
return
(
$erg
);
}
function
db_result (
$erg
,
$zeile
) {
return
(mysql_result (
$erg
,
$zeile
));
}
function
db_fetch_assoc (
$erg
) {
return
(mysql_fetch_assoc(
$erg
));
}
function
db_fetch_row (
$erg
) {
return
(mysql_fetch_row(
$erg
));
}
function
db_fetch_object (
$erg
) {
return
(mysql_fetch_object(
$erg
));
}
function
db_num_rows (
$erg
) {
return
(mysql_num_rows (
$erg
));
}
function
db_last_id () {
return
( mysql_insert_id (CONN));
}
function
db_count_query (
$query
) {
return
(db_result(db_query(
$query
),0));
}
function
db_make_sites (
$page
,
$where
,
$limit
,
$link
,
$table
) {
$hvmax
= 4;
$maxpage
=
''
;
if
(
empty
(
$MPL
) ) {
$MPL
=
''
; }
$resultID
= db_query (
"SELECT COUNT(*) FROM `prefix_"
.
$table
.
"` "
.
$where
);
$total
= db_result(
$resultID
,0);
if
(
$limit
<
$total
) {
$maxpage
=
$total
/
$limit
;
if
(
is_double
(
$maxpage
)) {
$maxpage
=
ceil
(
$maxpage
);
}
$ibegin
=
$page
-
$hvmax
;
$iende
=
$page
+
$hvmax
;
$vgl1
=
$iende
+
$ibegin
;
$vgl2
= (
$hvmax
* 2) + 1;
if
(
$vgl1
<=
$vgl2
) {
$iende
=
$vgl2
;
}
$vgl3
=
$maxpage
- (
$vgl2
-1);
if
(
$vgl3
<
$ibegin
) {
$ibegin
=
$vgl3
;
}
if
(
$ibegin
< 1) {
$ibegin
= 1;
}
if
(
$iende
>
$maxpage
) {
$iende
=
$maxpage
;
}
$vMPL
=
''
;
if
(
$ibegin
> 1) {
$vMPL
=
'<a href="'
.
$link
.
'&page=1">«</a> '
;
}
$MPL
=
$vMPL
.
'[ '
;
for
(
$i
=
$ibegin
;
$i
<=
$iende
;
$i
++) {
if
(
$i
==
$page
) {
$MPL
.=
$i
;
}
else
{
$MPL
.=
'<a href="'
.
$link
.
'&page='
.
$i
.
'">'
.
$i
.
'</a>'
;
}
if
(
$i
!=
$iende
) {
$MPL
.=
' | '
;
}
}
$MPL
.=
' ]'
;
if
(
$iende
<
$maxpage
) {
$MPL
.=
' <a href="'
.
$link
.
'&page='
.
$maxpage
.
'">»</a>'
;
}
}
return
$MPL
;
}
?>