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 |