Alles Probiert was dort Steht geht nicht mein Problemn ist ja auch net das da was hinterherhängt sind beide EXAKT gleich nur eben 6 std zu früh?
Und Online Box geht auch nur eben die news nicht der rest ist in der richtigen zeit :/
Zitat geschrieben von
Abakama
Thx, natürlich gebe ich mir mühe es umzusetzen, denn schließlich möchte ich ja das es funktioniert, und ich kann ja nicht erwarten dass mir jetzt irgendjemand die Arbeit abnimmt und mir gleich die Lösung aufm Silberteller präsentiert. Gut, ohne Tipp wäre ich verzweifelt, weil ich einfach noch nicht so gut in PHP bin, aber jetzt hat es gereicht, nochmal vielen Dank an Mairu für seine Hilfe!
Für die die das gleiche Problem haben schreibe ich hier noch meine Lösung, könnte man sicherlich besser machen, aber für mich reicht es, und immerhin funktioniert es sogar!
1. Eine neue Tabelle ic1_timedif anlegen mit den Feldern type (varshare(20)) und time (INT)
CREATE TABLE `ic1_timedif` (
`type` VARCHAR( 20 ) NOT NULL ,
`time` TIMESTAMP NOT NULL ,
PRIMARY KEY ( `type` )
);
2. Einen Eintrag mit type mysql_time und time NOW( ) erstellen.
INSERT INTO `ic1_timedif` ( `type` , `time` )
VALUES (
'mysql_time', NOW( )
);
3. Die Datei include/boxes/online.php mit einem Editor öffnen und
$dif = date('Y-m-d H:i:s', time() - 60);
durch
mysql_query('UPDATE ic1_timedif SET time = NOW( ) WHERE type=\'mysql_time\'');
$mysql_data=mysql_fetch_assoc(mysql_query('SELECT * FROM ic1_timedif WHERE type=\'mysql_time\''));
$timedif=time()-strtotime($mysql_data["time"]);
$dif = date('Y-m-d H:i:s', time() - 60-$timedif);
ersetzen.
Nun sollte die Online-Box wieder problemlos funktionieren.
MfG Abakama
Kann man das nicht auch mit dem News Machen mit dem Forum gings bei dem News hab ich die Probleme hier die lastnews_varied.php
<?php
# Copyright by Manuel
# Modifikation by Maretz.eu
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$abf = 'SELECT
a.news_kat as kate,
DATE_FORMAT(a.news_time,"%d.%m.%Y - %H:%i") as datum,
a.news_title as title,
a.news_id as id,
b.name as username,
b.id as userid
FROM prefix_news as a
LEFT JOIN prefix_user as b ON a.user_id = b.id
WHERE news_recht >= '.$_SESSION['authright'].'
ORDER BY a.news_time DESC
LIMIT 0,5';
$erg = db_query($abf);
echo'<table border="0" width="100%" cellspacing="1" cellpadding="3">';
while ($row = db_fetch_object($erg))
{
echo'<tr>';
echo'<tr><td valign="top"><b>»</b></td><td><a class="LS" href="index.php?news-'.$row->id.'">'.((strlen($row->title)<27) ? $row->title : substr($row->title,0,27).'...').'<br /><br>
<span class="LR">'.$row->datum.'</span></a></td></tr>';
}
echo'</table>';
?>
und die lastnews.php
<?php
# Copyright by Manuel
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$abf = 'SELECT *
FROM prefix_news
WHERE news_recht >= '.$_SESSION['authright'].'
ORDER BY news_time DESC
LIMIT 0,5';
$erg = db_query($abf);
echo '<table>';
while ($row = db_fetch_object($erg)) {
echo '<tr><td valign="top"><b> » </b></td><td><a class="box" href="index.php?news-'.$row->news_id.'">'.$row->news_title.'</a></td></tr>';
}
echo '</table>';
?>
Und unter ../contents
new.php
<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: News';
$hmenu = 'News';
$design = new design ( $title , $hmenu );
$design->addheader('<link rel="alternate" type="application/atom+xml" title="News (Atom)" href="index.php?news-atom" />
<link rel="alternate" type="application/rss+xml" title="News (RSS)" href="index.php?news-rss" />');
function news_find_kat ($kat) {
$katpfad = 'include/images/news/';
$katjpg = $katpfad.$kat.'.jpg';
$katgif = $katpfad.$kat.'.gif';
$katpng = $katpfad.$kat.'.png';
if ( file_exists( $katjpg ) ) {
$pfadzumBild = $katjpg;
} elseif ( file_exists ( $katgif ) ) {
$pfadzumBild = $katgif;
} elseif ( file_exists ( $katpng ) ) {
$pfadzumBild = $katpng;
}
if ( !empty( $pfadzumBild ) ) {
$kategorie = '<img style="" src="'.$pfadzumBild.'" alt="'.$kat.'">';
} else {
$kategorie = '<b>'.$kat.'</b><br /><br />';
}
return ( $kategorie );
}
if ( !is_numeric($menu->get(1)) ) {
if($menu->get(1) == 'rss' || $menu->get(1) == 'atom')
{
#ob_clean();
$feed_type = $menu->get(1);
$abf = "SELECT MAX(news_time) AS last_update FROM prefix_news";
$erg = db_query($abf);
$row = db_fetch_assoc($erg);
$last_update = str_replace(' ', 'T', $row['last_update']) . 'Z';
$abf = "SELECT
a.news_title as title,
a.news_id as id,";
$abf .= ($feed_type == 'atom') ? 'a.news_time as datum,' : "DATE_FORMAT(a.news_time,'%a, %e %b %y %H:%i:%s') as datum,";
$abf .=
"a.news_kat as kate,
a.news_text as text,
b.name as username
FROM prefix_news as a
LEFT JOIN prefix_user as b ON a.user_id = b.id
WHERE a.news_recht = 0
ORDER BY news_time DESC LIMIT 15";
$erg = db_query($abf);
$tpl = new tpl( 'news_'.$menu->get(1).'.htm' );
header('Content-type: application/' . $menu->get(1) . '+xml');
$tpl->set_ar_out(array('FEEDTITLE' => $allgAr['title'],
'UPDATED' => $last_update,
'SITEURL' => 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF'])), 0);
while ($row = db_fetch_assoc($erg))
{
if($feed_type == 'atom')
{
$Z = (date('Z') > 0 ? '+' : '').date('H:i:s', date('Z') + 23 * 3600);
$row['datum'] = str_replace(' ', 'T', $row['datum']) . $Z;
}
$a = explode('[PREVIEWENDE]', $row['text']);
$tpl->set_ar_out(array('TITLE' => $row['title'],
'TXT' => bbcode($a[0]),
'LINK' => 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']). '/index.php?news-' . $row['id'],
'AUTHOR' => $row['username'],
'DATE' => $row['datum']
), 1);
}
$tpl->out(2);
exit;
}
else
{
$design->header();
$limit = $allgAr['Nlimit'];
$page = ( $menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
$MPL = db_make_sites ($page , "WHERE news_recht >= ".$_SESSION['authright'] , $limit , '?news' , 'news' );
$anfang = ($page - 1) * $limit;
$tpl = new tpl ( 'news.htm' );
$abf = "SELECT
a.news_title as title,
a.news_id as id,
DATE_FORMAT(a.news_time,'%d. %m. %Y') as datum,
DATE_FORMAT(a.news_time,'%W') as dayofweek,
a.news_kat as kate,
a.news_text as text,
b.name as username
FROM prefix_news as a
LEFT JOIN prefix_user as b ON a.user_id = b.id
WHERE ".$_SESSION['authright']." <= a.news_recht
OR a.news_recht = 0
ORDER BY news_time DESC
LIMIT ".$anfang.",".$limit;
#echo '<pre>'.$abf.'</pre>';
$erg = db_query($abf);
while ($row = db_fetch_assoc($erg)) {
$k0m = db_query("SELECT COUNT(ID) FROM `prefix_koms` WHERE uid = ".$row['id']." AND cat = 'NEWS'");
$row['kom'] = db_result($k0m,0);
$row['kate'] = news_find_kat($row['kate']);
$row['datum'] = $lang[$row['dayofweek']].' '.$row['datum'];
if ( strpos ( $row['text'] , '[PREVIEWENDE]' ) !== FALSE ) {
$a = explode('[PREVIEWENDE]' , $row['text']);
$row['text'] = $a[0];
$row['readwholenews'] = '» <a href="index.php?news-'.$row['id'].'">'.$lang['readwholenews'].'</a> «';
} else {
$row['readwholenews'] = '';
}
$row['text'] = bbcode($row['text']);
$tpl->set_ar_out($row,0);
}
$tpl->set_out('SITELINK', $MPL,1);
unset($tpl);
}
} else {
$design->header();
$nid = escape($menu->get(1), 'integer');
$row = db_fetch_object(db_query("SELECT * FROM `prefix_news` WHERE news_id = '".$nid."'"));
if ( has_right(array($row->news_recht)) ) {
$komsOK = true;
if ( $allgAr['Ngkoms'] == 0 ) {
if ( loggedin() ) {
$komsOK = true;
} else {
$komsOK = false;
}
}
if ( $allgAr['Nukoms'] == 0 ) {
$komsOK = false;
}
# kommentar add
if ( (loggedin() OR chk_antispam ('newskom')) AND $komsOK AND !empty($_POST['name']) AND !empty($_POST['txt']) ) {
$_POST['txt'] = escape($_POST['txt'],'string');
$_POST['name'] = escape($_POST['name'],'string');
db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (".$nid.",'NEWS','".$_POST['name']."','".$_POST['txt']."')");
}
# kommentar add
# kommentar loeschen
if ($menu->getA(2) == 'd' AND is_numeric($menu->getE(2)) AND has_right(-7, 'news')) {
$kommentar_id = escape($menu->getE(2),'integer');
db_query("DELETE FROM prefix_koms WHERE uid = ".$nid." AND cat = 'NEWS' AND id = ".$kommentar_id);
}
# kommentar loeschen
$kategorie = news_find_kat($row->news_kat);
$textToShow = bbcode($row->news_text);
$textToShow = str_replace('[PREVIEWENDE]','',$textToShow);
if ( !empty($such) ) {
$textToShow = markword($textToShow,$such);
}
$tpl = new tpl ( 'news.htm' );
$ar = array (
'TEXT' => $textToShow,
'KATE' => $kategorie,
'NID' => $nid,
'uname' => $_SESSION['authname'],
'ANTISPAM' => (loggedin()?'':get_antispam ('newskom', 0)),
'NAME' => $row->news_title
);
$tpl->set_ar_out($ar, 2 );
if ($komsOK) {
$tpl->set_ar_out ( array ( 'NAME' => $row->news_title , 'NID' => $nid ), 3 );
}
$erg1 = db_query("SELECT text, name, id FROM `prefix_koms` WHERE uid = ".$nid." AND cat = 'NEWS' ORDER BY id DESC");
$ergAnz1 = db_num_rows($erg1);
if ( $ergAnz1 == 0 ) {
echo '<b>'.$lang['nocomments'].'</b>';
} else {
$zahl = $ergAnz1;
while ($row1 = db_fetch_assoc($erg1)) {
$row1['text'] = bbcode(trim($row1['text']));
if (has_right(-7, 'news')) {
$row1['text'] .= '<a href="?news-'.$nid.'-d'.$row1['id'].'"><img src="include/images/icons/del.gif" alt="löschen" border="0" title="löschen" /></a>';
}
$tpl->set_ar_out( array('NAME' => $row1['name'], 'TEXT' => $row1['text'], 'ZAHL' => $zahl ) , 4 );
$zahl--;
}
}
}
$tpl->out(5);
}
$design->footer();
?>
Zuletzt modifiziert von SuizideFF am 17.01.2013 - 16:29:04
