| |
//START COUNT
$sql_count = "SELECT COUNT(*) ID FROM tblPicture WHERE album_id = ".$_GET['id']." ";
$countresult = mysqli_query($db_connect_id,$sql_count);
$count = mysqli_result($countresult,0,0);
if ($_GET['qs'])
{
$start = $_GET['qs'];
}else{
$start = 0;
}
$antall = 9;
print "";
$sql = "SELECT * FROM tblAlbum WHERE ID = ".$_GET['id']." AND active = '1' ORDER BY name ASC";
$result = mysqli_query($db_connect_id,$sql);
while($row = mysqli_fetch_array($result))
{
print " ".$row['name']."
| ";
}
$sql = "SELECT * FROM tblPicture WHERE album_id = ".$_GET['id']." AND active = '1' ORDER BY picture ASC LIMIT $start, $antall";
$result = mysqli_query($db_connect_id,$sql);
while($row = mysqli_fetch_array($result))
{
$sum = ($toggle / 3);
if (!is_int($sum))
{
print " | ".$row['name']." |
| ";
}else{
print " | ".$row['name']." |
| ";
}
$toggle++;
}
print "
| ";
$sql_string = "SELECT count(*) as nCount FROM tblPicture WHERE album_id = ".$_GET['id']." ";
$query_result = mysqli_query($db_connect_id,$sql_string);
if ($_GET['qs'] == 0)
{
print "<";
}else if ($_GET['qs'] > $count-$antall){
print " <";
}else{
print " <";
}
print " ";
if( $row = mysqli_fetch_array($query_result))
{
$antallsider = ceil( $row['nCount'] / $antall );
$n = 1;
while ( $n <= $antallsider )
{
if ( $n > 1 )
{
print ', ';
}
if ($n == 1 + $start / $antall)
{
print ' '.$n.'';
}else{
print ' '.$n.'';
}
$n++;
}
// print ' Totalt: '.$antallsider.' sider';
// print 'Denne side: '.(1 + ($start / $antall ) );
}
print " ";
if ($_GET['qs'] == 0)
{
print " > | ";
}else if ($_GET['qs'] > $count-$antall){
print "> | ";
}else{
print " > | ";
}
//END COUNT
print " ";
?>
|
|
print ' ';
include('login/loginscript.php');
$login = $_SESSION['login'] ?? '';
if ($login != "1")
{
include('login/loginform.php');
}else{
print '
';
//se etter nye i gjestebok
$sql = "SELECT COUNT(ID) FROM 2006_mailbox WHERE toPersonID = '".$_SESSION['userID']."' AND new = '1' AND active = '1' AND private = '0'";
$countresult = mysqli_query($db_connect_id,$sql);
$count = mysqli_result($countresult,0,0);
if ($count != 0)
{
if ($count == '1')
{
$new ='ny';
}else{
$new ='nye';
}
print ''.$count .' '.$new.' i gjestebok
';
}
//se etter nye i mailboks
$sql = "SELECT COUNT(ID) FROM 2006_mailbox WHERE toPersonID = '".$_SESSION['userID']."' AND new = '1' AND active = '1' AND private = '1'";
$countresult = mysqli_query($db_connect_id,$sql);
$count = mysqli_result($countresult,0,0);
if ($count != 0)
{
if ($count == '1')
{
$new ='nytt';
}else{
$new ='nye';
}
print ''.$count .' '.$new.' førjulsbrev
';
}
print "".$_SESSION['name']." ";
print 'Min side ';
print 'Gjesteboka ';
print 'Endre opplysninger
';
$sql = "SELECT lagnavn FROM 2006_lag WHERE kontakt_id = '".$_SESSION['userID']."' LIMIT 1;";
if ( !($result = mysqli_query($db_connect_id,$sql)) ){
message_die(GENERAL_ERROR, 'Noe galt skjedde: 151465', '', __LINE__, __FILE__, $sql);
}else{
if ($row = mysqli_fetch_array($result))
{
$_SESSION['lagnavn'] = $row['lagnavn'];
}
if (($_SESSION['lagnavn'] != '') && ($_SESSION['rolle2'] == 'KONTAKT'))
{
print ''.$_SESSION['lagnavn'].' ';
print 'Vår side ';
print 'Endre opplysninger ';
print 'Våre spillere
';
if ($_SESSION['lagtype'] == 'JENTE')
{
$gjeld = '400';
}else{
$gjeld = '500';
}
if ($_SESSION['betalt'] == 'FALSE')
{
print 'Gjeld kr '.$gjeld.',- ';
}else{
print 'Gjeld kr 0,- ';
}
}else{
print "Meld på et lag ";
}
}
print "
Logg ut ";
}
print ' ';
?>
//print '
'
//include('poll/poll.php');
?>

Førjulsturneringa starter om -7002 dager!

$sql = "SELECT * FROM tblPicture ORDER BY count DESC LIMIT 10;";
$query_result = mysqli_query($db_connect_id,$sql);
print 'Mest populære bilder! ';
while($row = mysqli_fetch_array($query_result))
{
print "".substr($row['name'],0,20)." (".$row['count'].") ";
}
?>

Stian Godø / stiang.net

Kasper L Mannsverk
|
|