Hallo,
ist es möglich, einen Link aus dem Contenbereich (z.B.:..../index.php?liga-l2 in eine selfpage einzubinden, damit dann z.B. hier die Tabelle , angezeigt wird?
Wie müsste ich es da eingeben?
verwendete ilchClan Version: 1.1
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||




<iframe src="index.php?liga-l2" />




$design->heder();und
design->$footer();entfernen

defined ('main') or die ('no direct access');
$sql = db_query("SELECT a.name AS lname, b.name AS sname, b.id AS sid, a.green, a.red FROM prefix_liga_league a INNER JOIN prefix_liga_season b ON a.id = b.lid WHERE a.id = $lid AND ".($sid == 0 ? 'b.status = 1' : 'b.id = '.$sid));
if (db_num_rows($sql) != 1) {
leagueError('Es gibt keine aktive Saison','Es kann keine Tabelle angezeigt werden, da die Saison noch nicht gestartet wurde.');
}
$leagueInfo = db_fetch_assoc($sql);
$sid = $leagueInfo['sid'];
$title = $allgAr['title'] . " :: {$leagueInfo['lname']} :: {$leagueInfo['sname']} :: Tabelle";
$hmenu = "{$leagueInfo['lname']} <b> » </b> {$leagueInfo['sname']} <b> » </b> Tabelle";
$design = new design ($title , $hmenu);
$design->header();
$tpl = new tpl('liga/table');
$tpl->set_out('title', $hmenu, 0);
$rang = 0;
$sql = db_query("SELECT a.tid, a.lid, a.points, a.opoints, a.s, a.u, a.n, (a.s*3+a.u) as punkte, (a.s + a.u + a.n) as spiele, b.name FROM `prefix_liga_table` a
INNER JOIN `prefix_liga_team` b ON a.tid = b.id INNER JOIN prefix_liga_season c ON a.sid = c.id
WHERE a.lid = $lid AND c.id = $sid
ORDER BY punkte DESC, (a.points - a.opoints) DESC, a.points DESC");
$anz = db_num_rows($sql);
$class = 'Cnorm';
while ($row = db_fetch_assoc($sql)) {
$rang++;
$class = $class == 'Cmite' ? 'Cnorm' : 'Cmite';
$row['class'] = $class;
$row['rang'] = $rang;
$row['style'] = ($rang <= $leagueInfo['green'] ? 'style="background-color:green;"' : (($rang >= ($anz - $leagueInfo['red'] + 1)) ? 'style="background-color:red;"' : ''));
$tpl->set_ar_out($row, 1);
}
$tpl->out(2);
$design->footer();
?>










<?php
defined ('main') or die ('no direct access');
$sql = db_query("SELECT a.name AS lname, b.name AS sname, b.id AS sid, a.green, a.red FROM prefix_liga_league a INNER JOIN prefix_liga_season b ON a.id = b.lid WHERE a.id = $lid AND ".($sid == 0 ? 'b.status = 1' : 'b.id = '.$sid));
if (db_num_rows($sql) != 1) {
leagueError('Es gibt keine aktive Saison','Es kann keine Tabelle angezeigt werden, da die Saison noch nicht gestartet wurde.');
}
$leagueInfo = db_fetch_assoc($sql);
$sid = $leagueInfo['sid'];
if (!$menu->exists('nodesign')) {
$title = $allgAr['title'] . " :: {$leagueInfo['lname']} :: {$leagueInfo['sname']} :: Tabelle";
$hmenu = "{$leagueInfo['lname']} <b> » </b> {$leagueInfo['sname']} <b> » </b> Tabelle";
$design = new design ($title , $hmenu);
$design->header();
}
$tpl = new tpl('liga/table');
$tpl->set_out('title', $hmenu, 0);
$rang = 0;
$sql = db_query("SELECT a.tid, a.lid, a.points, a.opoints, a.s, a.u, a.n, (a.s*3+a.u) as punkte, (a.s + a.u + a.n) as spiele, b.name FROM `prefix_liga_table` a
INNER JOIN `prefix_liga_team` b ON a.tid = b.id INNER JOIN prefix_liga_season c ON a.sid = c.id
WHERE a.lid = $lid AND c.id = $sid
ORDER BY punkte DESC, (a.points - a.opoints) DESC, a.points DESC");
$anz = db_num_rows($sql);
$class = 'Cnorm';
while ($row = db_fetch_assoc($sql)) {
$rang++;
$class = $class == 'Cmite' ? 'Cnorm' : 'Cmite';
$row['class'] = $class;
$row['rang'] = $rang;
$row['style'] = ($rang <= $leagueInfo['green'] ? 'style="background-color:green;"' : (($rang >= ($anz - $leagueInfo['red'] + 1)) ? 'style="background-color:red;"' : ''));
$tpl->set_ar_out($row, 1);
}
$tpl->out(2);
if (!$menu->exists('nodesign')) {
$design->footer();
}
?>

if (!$menu->exists('nodesign')) {
$title = $allgAr['title'] . " :: {$leagueInfo['lname']} :: {$leagueInfo['sname']} :: Tabelle";
$hmenu = "{$leagueInfo['lname']} <b> » </b> {$leagueInfo['sname']} <b> » </b> Tabelle";
$design = new design ($title , $hmenu);
$design->header();
}
if (!$menu->exists('nodesign')) {
$design->footer();
}


MySQL Error: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'AND b.status = 1\' at line 1 in Query: SELECT a.name AS lname, b.name AS sname, b.id AS sid, a.green, a.red FROM ic1_liga_league a INNER JOIN ic1_liga_season b ON a.id = b.lid WHERE a.id = AND b.status = 1 Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ TestSeite.php:4 -- db_query(...) @ self.php:71 -- require_once(...) @ index.php:24 -- require_once(...) Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /...../includes/func/db/mysql.php on line 71 Fatal error: Call to undefined function leagueError() in /...../contents/selfbp/selfp/TestSeite.php on line 6

| Geschlossen | ||
![]() |
Zurück zu Allgemein | |