| |
| Spiller | Lag |
".$row['antall']."";
}
print "
";
if ($_GET['order'] == 'lag')
{
$sql = "SELECT team.*, play.* FROM players play
JOIN playerlink plli ON play.play_ID = plli.plli_fk_play
LEFT JOIN teams team ON team.team_ID = plli.plli_fk_team
WHERE plli.plli_fk_tour = '".$ProjectionTourID."'
AND play.play_firstName != ''
ORDER BY team.team_name ASC;";
}else{
$sql = "SELECT team.*, play.* FROM players play
JOIN playerlink plli ON play.play_ID = plli.plli_fk_play
LEFT JOIN teams team ON team.team_ID = plli.plli_fk_team
WHERE plli.plli_fk_tour = '".$ProjectionTourID."'
AND play.play_firstName != ''
GROUP BY play.play_firstName, play.play_lastName
ORDER BY play.play_lastName ASC, play.play_firstName ASC;";
}
if ( !($result = mysqli_query($db_connect_id,$sql)) )
{
message_die(GENERAL_ERROR, 'Kunne ikke finne informasjon om betaling', '', __LINE__, __FILE__, $sql);
}
else
{
while($row = mysqli_fetch_array($result))
{
print "| ".$navn = $row['play_lastName']." ".$row['play_firstName']." | ".$row['team_name']." | ";
}
}
?>
|
|
';
/*include('login/loginscript.php');
if ($_SESSION['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
';
if ($_SESSION['lagID'] > '1')
{
$sql = "SELECT COUNT(*) AS alle FROM 2008_person WHERE lag_id = '".$_SESSION['lagID']."'";
$result = mysqli_query($db_connect_id,$sql);
$query_result = mysqli_query($db_connect_id,$sql);
if($row = mysqli_fetch_array($query_result))
{
if ($row['alle'] == '0')
{
// denne skal ikke vise hvis laget er sletta.
print "Slett lag
";
}
}
}
$sql = "SELECT lagnavn FROM 2008_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 if ($_SESSION['lagtype'] == 'GUTT')
{
$gjeld = '500';
}
if ($_SESSION['betalt'] == 'FALSE')
{
print 'Gjeld kr '.$gjeld.',-
';
}else if ($_SESSION['betalt'] == 'TRUE')
{
print 'Gjeld kr 0,-
';
}
}else{
$sNow = date("Ymd", time());
if ($sNow >= 20081015)
{
print "Meld p� et lag
";
}
}
}
print "
Logg ut
";
}
*/
print '
';
?>
'
//include('poll/poll.php');
?>
Mest popul�re bilder!
';
while($row = mysqli_fetch_array($query_result))
{
print "".substr($row['name'],0,20)." (".$row['count'].")
";
}
*/
?>
|
|
