ilch Forum » Ilch Clan 1.1 » Module und Modifikationen » News mit Avatar

Geschlossen
  1. #31
    User Pic
    Lord|Schirmer Administrator
    Registriert seit
    21.03.2007
    Beiträge
    7.634
    Beitragswertungen
    1193 Beitragspunkte
    Nein, nur die Zeile 240 ersetzen!
    rules :: doku :: faq :: linkus
    0 Mitglieder finden den Beitrag gut.
  2. #32
    User Pic
    -=NLNF=-Keule Mitglied
    Registriert seit
    13.05.2009
    Beiträge
    58
    Beitragswertungen
    0 Beitragspunkte
    Hi Lord,

    also funktioniert hat es nur leider wurde mir vom Newsposter nur nen rotes Kreuz angezeigt und eigendlich wollte ich das Avatar nicht in der News haben sondern nur in den Kommentaren von den News. Was müsste ich da abändern?

    Danke für Deine Hilfe !!! zwinker

    Besten Gruss
    Keule
    0 Mitglieder finden den Beitrag gut.
  3. #33
    User Pic
    OloX Hall Of Fame
    Registriert seit
    25.02.2006
    Beiträge
    990
    Beitragswertungen
    23 Beitragspunkte
    Hey -=NLNF=-Keule
    externer Link
    funzt 100pro zwinker

    MfG OloX


    Zuletzt modifiziert von OloX am 10.05.2010 - 16:01:34
    PHP, JavaScript, CSS
    0 Mitglieder finden den Beitrag gut.
  4. #34
    User Pic
    -=NLNF=-Keule Mitglied
    Registriert seit
    13.05.2009
    Beiträge
    58
    Beitragswertungen
    0 Beitragspunkte
    Moin OloX,

    ich habe dieses einfach mal kopiert und es funzt. Leider war meins ja schon modifiziert und da hat sich natürlich alles breit gemacht was ich schon alles umgeschrieben habe. Was müsste ich den genau kopieren damit alles so bleibt wie es bei mir jetzt ist. Ich brauche das Avatar auch nur in den Kommentaren. Kannst Du mir da helfen? lachen
    0 Mitglieder finden den Beitrag gut.
  5. #35
    User Pic
    OloX Hall Of Fame
    Registriert seit
    25.02.2006
    Beiträge
    990
    Beitragswertungen
    23 Beitragspunkte
    Poste einfach deine PHP/HTM, dann bau ich es dir ein zwinker
    MfG OloX
    PHP, JavaScript, CSS
    0 Mitglieder finden den Beitrag gut.
  6. #36
    User Pic
    -=NLNF=-Keule Mitglied
    Registriert seit
    13.05.2009
    Beiträge
    58
    Beitragswertungen
    0 Beitragspunkte
    <?php
    // Copyright by: Manuel Staechele
    // Support: www.ilch.de
    // Modded by Mairu für News Extended
    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);
    }
    // Schaut ob ein Name so oder ähnlich in der Datenbank vorhanden ist
    // gibt true zurück falls der Name noch nicht verwendet ist
    function checkName($name) {
        if (db_count_query("SELECT COUNT(name) FROM prefix_user WHERE name LIKE '$name'")) {
            return false;
        } else {
            return true;
        }
    }
    
    function checkKomName($name) {
        $resp = new xajaxResponse();
        if (checkName($name) OR loggedin()) {
            $resp->script('document.forms["komform"].submit();');
        } else {
            $resp->assign('komname', 'value' , '');
            $resp->alert('Dieser Name ist bereits an einen User vergeben, benutze bitte einen anderen.');
            $resp->script("document.getElementById('komname').focus();");
        }
        return $resp;
    }
    // xajax für namencheck
    $xajax = new xajax();
    $xajax->configureMany(array('decodeUTF8Input' => true ,'characterEncoding' => 'ISO-8859-1', 'requestURI' => 'admin.php?news-ajax'));
    $xajax->register(XAJAX_FUNCTION, 'checkKomName');
    $xajax->processRequest();
    
    if ($menu->get(1) == 'ajax') {
        exit();
    }
    
    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';
    
            $tn_id = intval(@db_result($news_opts = db_query("SELECT v1 FROM prefix_allg WHERE k = 'news' LIMIT 1"), 0));
    
            $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,
          a.html
        FROM prefix_news as a
        LEFT JOIN prefix_user as b ON a.user_id = b.id
        WHERE (a.news_recht | 1) = a.news_recht AND a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND a.news_id != $tn_id AND a.`archiv` != 1 AND (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP())
        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' => $row['html'] ? $a[0] : 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);
    
            // Topnews ausgeben
            $tn_id = intval(@db_result($news_opts = db_query("SELECT v1, v2 FROM prefix_allg WHERE k = 'news' LIMIT 1"), 0, 0));
            $tn_koms = @db_result($news_opts, 0, 1);
            $tn_sql = db_query("SELECT news_title, news_text, news_kat, news_recht, news_groups, html FROM prefix_news WHERE news_id = $tn_id AND `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP())");
            if (db_num_rows($tn_sql) > 0) {
                $tn_r = db_fetch_object($tn_sql);
    
    			$dontShow = false;
    			if ((pow(2, abs($_SESSION['authright'])) | $tn_r->news_recht) != $tn_r->news_recht) {
    				$dontShow = true;
    			}
    			if ($dontShow) {
    				foreach($_SESSION['authgrp'] as $id => $bool) {
    					if ($bool and (pow(2, abs($id)) | $tn_r->news_groups) == $tn_r->news_groups) {
    						$dontShow = false;
    						break;
    					}
    				}
    			}
            	if (!$dontShow) {
    				$tn_tpl = new tpl ('news/top');
    				$tn_tpl->set('title', $tn_r->news_title);
    				$tn_tpl->set('koms', $tn_koms == '1' ? '<br /><a href="index.php?news-' . $tn_id . '">' . db_count_query("SELECT COUNT(id) FROM prefix_koms WHERE uid = $tn_id AND cat = 'NEWS'") . ' ' . $lang['comments'] . ' </a>' : '');
                    if (strpos ($tn_r->news_text , '[PREVIEWENDE]') !== false) {
                        $a = explode('[PREVIEWENDE]' , $tn_r->news_text);
                        $tn_r->news_text = $a[0];
                        $tn_tpl->set('readwholenews', '<a href="index.php?news-' . $tn_id . '" alt="mehr lesen" title="mehr lesen"><img src="include/images/icons/news/more.gif" alt="mehr lesen" border="0"></a>');
                    } else {
                        $tn_tpl->set('readwholenews', '');
                    }
                    $tn_tpl->set('kate', news_find_kat($tn_r->news_kat));
                    $tn_tpl->set_out('txt', $tn_r->html ? $tn_r->news_text : bbcode($tn_r->news_text), 0);
    				unset($tn_tpl);
            	}
            }
    
    		//Kategorie einschränken
    		if ($menu->get(1) != '' and ($menu->getA(1) != 'p' or $menu->getE(1) == 0)) {
    			$kats = $katssql = array();  #collect given kats
    			$i = 1;
    			while($kat = escape($menu->get($i), 'string')){
    				$kats[] = $kat;
    				$katssql[] = '"' . $kat . '"';
    				$i++;
    			}
    			$news_kat = 'news_kat IN ('.implode(',', $katssql).') AND';
    			$katmpl = '-'.implode('-', $kats);
    			$page = $menu->getE('p');
    			if ($page < 1) {
    				$page = 1;
    			}
    			$katmpl = str_replace('-p'.$page, '', $katmpl);
    		} else {
    			$news_kat = $katmpl = '';
    			$page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1);
    		}
    
            $anfang = ($page - 1) * $limit;
    		//Gruppenrechte
    		$groups = getGroupRights();
    
    		$MPL = db_make_sites ($page , "WHERE (((" . pow(2, abs($_SESSION['authright'])) . " | news_recht) = news_recht) OR
    			(news_groups != 0 AND ((news_groups ^ $groups) != (news_groups | $groups)))) AND $news_kat `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id != $tn_id AND archiv != 1 AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP())" , $limit , '?news'.$katmpl , 'news');
            // Normale News
            $tpl = new tpl ('news/news.htm');
    
            $abf = "SELECT
          a.news_title as title,
          a.news_id as id,
          DATE_FORMAT(a.news_time,'%d. %m. %Y - %H:%i Uhr') as datum,
          DATE_FORMAT(a.news_time,'%W') as dayofweek,
          a.news_kat as kate,
          a.news_text as text,
          b.name as username,
          c.name as editorname,
          a.html,
          a.edit_time,
          a.klicks,
          b.id as uid
        FROM prefix_news as a
        LEFT JOIN prefix_user as b ON a.user_id = b.id
        LEFT JOIN prefix_user as c ON a.editor_id = c.id
        WHERE (((" . pow(2, abs($_SESSION['authright'])) . " | a.news_recht) = a.news_recht) OR
    	      (a.news_groups != 0 AND ((a.news_groups ^ $groups) != (a.news_groups | $groups)))) AND $news_kat
    		a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND news_id != $tn_id AND a.`archiv` != 1 AND
    		(a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP())
        ORDER BY a.news_time DESC
        LIMIT " . $anfang . "," . $limit;
    
            // echo '<pre>'.$abf.'</pre>';
            $erg = db_query($abf);
        	if (db_num_rows($erg) == 0 and !empty($news_kat)) {
        		echo 'Keine News in dieser Kategorie gefunden.<br />
        			<a href="index.php?news">News&uuml;bersichtsseite aufrufen</a>';
        		$design->footer(1);
        	}
            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'] . '" alt="mehr lesen" title="mehr lesen"><img src="include/images/icons/news/more.gif" alt="mehr lesen" border="0"></a>';
                } else {
                    $row['readwholenews'] = '';
                }
                $row['klicks'] = '<img src="include/images/icons/news/counter.gif" alt="' . $row['klicks'] . ' mal gelesen" title="' . $row['klicks'] . ' mal gelesen" border="0">';
                if (!$row['html']) {
                    $row['text'] = bbcode($row['text']);
                }
                {
               
                    $row['edit'] .= '</i>';
                }
                $tpl->set_ar_out($row, 0);
            }
            $tpl->set_out('SITELINK', $MPL, 1);
            unset($tpl);
        }
    } else {
        $design->header();
        $xajax->printJavascript();
    
        $nid = escape($menu->get(1), 'integer');
        $erg = db_query("SELECT * FROM `prefix_news` WHERE `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id = '" . $nid . "'");
        if (db_num_rows($erg) == 0) {
            $dontShow = true;
    	} else {
    		$dontShow = false;
    		$row = db_fetch_object($erg);
    		if ((pow(2, abs($_SESSION['authright'])) | $row->news_recht) != $row->news_recht) {
    			$dontShow = true;
    		}
    		if ($dontShow) {
    			foreach($_SESSION['authgrp'] as $id => $bool) {
    				if ($bool and (pow(2, abs($id)) | $row->news_groups) == $row->news_groups) {
    					$dontShow = false;
    					break;
    				}
    			}
    		}
    	}
    
    	if ($dontShow) {
    		echo 'News existiert nicht oder Sie haben keine Rechte sie zu sehen.  <a href="javascript:history.back();">zur&uuml;ck</a>';
    		$design->footer(1);
    	}
    
        $komsOK = true;
        if ($allgAr['Ngkoms'] == 0) {
            if (loggedin()) {
                $komsOK = true;
            } else {
                $komsOK = false;
            }
        }
        if ($allgAr['Nukoms'] == 0) {
            $komsOK = false;
        }
    
        $kom_info = '';
        // 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');
            if (checkName($_POST['name']) or loggedin()) {
                if (loggedin()) {
                    $_POST['name'] = $_SESSION['authname'];
                }
                db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (" . $nid . ",'NEWS','" . $_POST['name'] . "','" . $_POST['txt'] . "')");
            } else {
                $kom_info = '<span style="color:red;">Dieser Name ist bereits an einen User vergeben, benutze bitte einen anderen.</span><br />';
            }
        }
        // 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 = $row->html ? $row->news_text : bbcode($row->news_text);
        $textToShow = str_replace('[PREVIEWENDE]', '', $textToShow);
        if (!empty($such)) {
            $textToShow = markword($textToShow, $such);
        }
        // klicks zaehlen
        db_query("UPDATE prefix_news SET klicks = klicks + 1 WHERE news_id = " . $nid);
    
        $tpl = new tpl ('news/news.htm');
        $ar = array (
            'TEXT' => $textToShow,
            'KATE' => $kategorie,
            'NID' => $nid,
            'uname' => $_SESSION['authname'],
            'ANTISPAM' => (loggedin()?'':get_antispam ('newskom', 0)),
            'NAME' => $row->news_title,
            'info' => $kom_info
            );
        $tpl->set_ar_out($ar, 2);
    
        if ($komsOK) {
            $tpl->set_ar_out (array ('NAME' => $row->news_title , 'NID' => $nid, 'style' => loggedin() ? 'style="display:none;"' : ''), 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="javascript:delkom(' . $nid . ',' . $row1['id'] . ')"><img src="include/images/icons/del.gif" alt="l&ouml;schen" border="0" title="l&ouml;schen" /></a>';
                }
                $tpl->set_ar_out(array('NAME' => $row1['name'], 'TEXT' => $row1['text'], 'ZAHL' => $zahl) , 4);
                $zahl--;
            }
        }
        $tpl->out(5);
    }
    
    $design->footer();
    
    ?>



    <img src="include/designs/shooterbase/images/news_top.jpg" width="567" height="27">
    <table background="include/designs/shooterbase/images/news_bg.jpg" width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="newsbg">
    <tr>
    <td width="10"></td>
    <td>
    <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0">
        <tr>
          <td class="smalfont">{datum} - <strong><a href="index.php?news-{id}">{title}</a></strong></td>
          </tr>
    <table width="98%"  border="0" cellspacing="0" cellpadding="2">
    
        <tr>
          <td><hr style="height: 0px; border: dotted #000000 0px; border-top-width: 1px; " /></td>
          </tr>
    </table>
    
    
    
      <table width="100%" border="0" align="center" cellpadding="1" cellspacing="0" class="cbg1">
        <tr>
          <td align="center">{kate}</td>
        </tr>
    
      </table>
    
    
      <table width="98%"  border="0" cellspacing="0" cellpadding="2">
        <tr>
    	  <td>{text}</td>
    	</tr>
        <tr>
    	  <td><hr style="height: 0px; border: dotted #000000 0px; border-top-width: 1px; " /></td>
    	</tr>
     </table>
     <table width="98%"  border="0" cellspacing="0" cellpadding="1">
        <tr>
    
          <td align="left" width="60%" class="smalfont">Geschrieben von <strong>{username}</strong>{edit}</td>
          <td align="right" width="40%">
            <div align="right">{readwholenews}
            </div></td>
          </td>
    	  <td width="10"></td>
        </tr>
      </table>
    </td></tr></table>
    <img src="include/designs/shooterbase/images/news_bt.jpg" width="567" height="25">
    <br />
    <br />
    {EXPLODE}
    <br />
    <br /><center>{SITELINK}</center>
    
    
    {EXPLODE}
    <script language="JavaScript" type="text/javascript">
    function delkom (NID, ID) {
    var Check = confirm("Kommentar wirklich löschen?")
    if (Check == true) window.open("index.php?news-"+NID+"-d"+ID,"_self");
    }</script>
    <!-- News Kommentare und Mehr lesen -->
    <table width="100%" cellpadding="5" cellspacing="1" border="0">
      <tr class="Chead">
        <th height="25"><b>{NAME}</b></th>
      </tr>
      <tr>
        <td height="25">{_lang_message}</td>
      </tr>
    
        <tr>
          <td align="center">{KATE}</td>
        </tr>
    
    
      <tr>
        <td >
          <div style="float:left; padding-left:10px; ">{TEXT}</div><br style="clear:both; " />
          <p></p>
          <a href="javascript:history.back(1)"><b>&laquo;</b>{_lang_back}</a> </td>
      </tr>
    
      <tr>
        <td height="25">{_lang_commentsfor} {NAME}</td>
      </tr>
      <tr>
        <td>
    
    	    {EXPLODE}
    	    <form action="index.php?news-{NID}" method="POST">
            <fieldset>
              <legend>{_lang_writecomment}</legend>
              <input type="text" name="name" value="{uname}" /> &nbsp; {ANTISPAM} &nbsp; <input type="submit" value="{_lang_enter}"><br />
              <textarea style="width: 98%" cols="50" rows="2" name="txt"></textarea><br />
            </fieldset>
          </form>
          <br />
          {EXPLODE}
    
          <span class="Cmite"># <b>{ZAHL}</b> von {NAME}</span>
          <br />{TEXT}<br /><br />
    
          {EXPLODE}
          <br />
          <a href="javascript:history.back(1)"><b>&laquo;</b> {_lang_back}</a>
    
        </td>
      </tr>
    </table>


    Bei mir ist leider auch der Button gelöscht der anzeigt wieviel Kommentare zu einer News abgegeben wurden. Kannst Du mir diesen auch wieder einbinden? Das wär echt Super lächeln

    Großes Danke erstmal für Deine Hilfe, ich weiss schon warum ich wieder zu Ilch gewechselt bin. Die Community ist unschlagbar !!!(Y)

    externer Link


    Zuletzt modifiziert von -=NLNF=-Keule am 11.05.2010 - 00:05:16
    0 Mitglieder finden den Beitrag gut.
  7. #37
    User Pic
    OloX Hall Of Fame
    Registriert seit
    25.02.2006
    Beiträge
    990
    Beitragswertungen
    23 Beitragspunkte
    Sorry, das es erst heute kommt sauer
    include/contents/news/news.php
    <?php
    // Copyright by: Manuel Staechele
    // Support: www.ilch.de
    // Modded by Mairu für News Extended
    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);
    }
    // Schaut ob ein Name so oder ähnlich in der Datenbank vorhanden ist
    // gibt true zurück falls der Name noch nicht verwendet ist
    function checkName($name) {
        if (db_count_query("SELECT COUNT(name) FROM prefix_user WHERE name LIKE '$name'")) {
            return false;
        } else {
            return true;
        }
    }
     
    function checkKomName($name) {
        $resp = new xajaxResponse();
        if (checkName($name) OR loggedin()) {
            $resp->script('document.forms["komform"].submit();');
        } else {
            $resp->assign('komname', 'value' , '');
            $resp->alert('Dieser Name ist bereits an einen User vergeben, benutze bitte einen anderen.');
            $resp->script("document.getElementById('komname').focus();");
        }
        return $resp;
    }
    // xajax für namencheck
    $xajax = new xajax();
    $xajax->configureMany(array('decodeUTF8Input' => true ,'characterEncoding' => 'ISO-8859-1', 'requestURI' => 'admin.php?news-ajax'));
    $xajax->register(XAJAX_FUNCTION, 'checkKomName');
    $xajax->processRequest();
     
    if ($menu->get(1) == 'ajax') {
        exit();
    }
     
    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';
     
            $tn_id = intval(@db_result($news_opts = db_query("SELECT v1 FROM prefix_allg WHERE k = 'news' LIMIT 1"), 0));
     
            $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,
          a.html
        FROM prefix_news as a
        LEFT JOIN prefix_user as b ON a.user_id = b.id
        WHERE (a.news_recht | 1) = a.news_recht AND a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND a.news_id != $tn_id AND a.`archiv` != 1 AND (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP())
        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' => $row['html'] ? $a[0] : 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);
     
            // Topnews ausgeben
            $tn_id = intval(@db_result($news_opts = db_query("SELECT v1, v2 FROM prefix_allg WHERE k = 'news' LIMIT 1"), 0, 0));
            $tn_koms = @db_result($news_opts, 0, 1);
            $tn_sql = db_query("SELECT news_title, news_text, news_kat, news_recht, news_groups, html FROM prefix_news WHERE news_id = $tn_id AND `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP())");
            if (db_num_rows($tn_sql) > 0) {
                $tn_r = db_fetch_object($tn_sql);
     
                $dontShow = false;
                if ((pow(2, abs($_SESSION['authright'])) | $tn_r->news_recht) != $tn_r->news_recht) {
                    $dontShow = true;
                }
                if ($dontShow) {
                    foreach($_SESSION['authgrp'] as $id => $bool) {
                        if ($bool and (pow(2, abs($id)) | $tn_r->news_groups) == $tn_r->news_groups) {
                            $dontShow = false;
                            break;
                        }
                    }
                }
                if (!$dontShow) {
                    $tn_tpl = new tpl ('news/top');
                    $tn_tpl->set('title', $tn_r->news_title);
                    $tn_tpl->set('koms', $tn_koms == '1' ? '<br /><a href="index.php?news-' . $tn_id . '">' . db_count_query("SELECT COUNT(id) FROM prefix_koms WHERE uid = $tn_id AND cat = 'NEWS'") . ' ' . $lang['comments'] . ' </a>' : '');
                    if (strpos ($tn_r->news_text , '[PREVIEWENDE]') !== false) {
                        $a = explode('[PREVIEWENDE]' , $tn_r->news_text);
                        $tn_r->news_text = $a[0];
                        $tn_tpl->set('readwholenews', '<a href="index.php?news-' . $tn_id . '" alt="mehr lesen" title="mehr lesen"><img src="include/images/icons/news/more.gif" alt="mehr lesen" border="0"></a>');
                    } else {
                        $tn_tpl->set('readwholenews', '');
                    }
                    $tn_tpl->set('kate', news_find_kat($tn_r->news_kat));
                    $tn_tpl->set_out('txt', $tn_r->html ? $tn_r->news_text : bbcode($tn_r->news_text), 0);
                    unset($tn_tpl);
                }
            }
     
            //Kategorie einschränken
            if ($menu->get(1) != '' and ($menu->getA(1) != 'p' or $menu->getE(1) == 0)) {
                $kats = $katssql = array();  #collect given kats
                $i = 1;
                while($kat = escape($menu->get($i), 'string')){
                    $kats[] = $kat;
                    $katssql[] = '"' . $kat . '"';
                    $i++;
                }
                $news_kat = 'news_kat IN ('.implode(',', $katssql).') AND';
                $katmpl = '-'.implode('-', $kats);
                $page = $menu->getE('p');
                if ($page < 1) {
                    $page = 1;
                }
                $katmpl = str_replace('-p'.$page, '', $katmpl);
            } else {
                $news_kat = $katmpl = '';
                $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1);
            }
     
            $anfang = ($page - 1) * $limit;
            //Gruppenrechte
            $groups = getGroupRights();
     
            $MPL = db_make_sites ($page , "WHERE (((" . pow(2, abs($_SESSION['authright'])) . " | news_recht) = news_recht) OR
                (news_groups != 0 AND ((news_groups ^ $groups) != (news_groups | $groups)))) AND $news_kat `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id != $tn_id AND archiv != 1 AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP())" , $limit , '?news'.$katmpl , 'news');
            // Normale News
            $tpl = new tpl ('news/news.htm');
     
            $abf = "SELECT
          a.news_title as title,
          a.news_id as id,
          DATE_FORMAT(a.news_time,'%d. %m. %Y - %H:%i Uhr') as datum,
          DATE_FORMAT(a.news_time,'%W') as dayofweek,
          a.news_kat as kate,
          a.news_text as text,
          b.name as username,
          c.name as editorname,
          a.html,
          a.edit_time,
          a.klicks,
          b.id as uid
        FROM prefix_news as a
        LEFT JOIN prefix_user as b ON a.user_id = b.id
        LEFT JOIN prefix_user as c ON a.editor_id = c.id
        WHERE (((" . pow(2, abs($_SESSION['authright'])) . " | a.news_recht) = a.news_recht) OR
              (a.news_groups != 0 AND ((a.news_groups ^ $groups) != (a.news_groups | $groups)))) AND $news_kat
            a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND news_id != $tn_id AND a.`archiv` != 1 AND
            (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP())
        ORDER BY a.news_time DESC
        LIMIT " . $anfang . "," . $limit;
     
            // echo '<pre>'.$abf.'</pre>';
            $erg = db_query($abf);
            if (db_num_rows($erg) == 0 and !empty($news_kat)) {
                echo 'Keine News in dieser Kategorie gefunden.<br />
                    <a href="index.php?news">News&uuml;bersichtsseite aufrufen</a>';
                $design->footer(1);
            }
            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'] . '" alt="mehr lesen" title="mehr lesen"><img src="include/images/icons/news/more.gif" alt="mehr lesen" border="0"></a>';
                } else {
                    $row['readwholenews'] = '';
                }
                $row['klicks'] = '<img src="include/images/icons/news/counter.gif" alt="' . $row['klicks'] . ' mal gelesen" title="' . $row['klicks'] . ' mal gelesen" border="0">';
                if (!$row['html']) {
                    $row['text'] = bbcode($row['text']);
                }
                {
               
                    $row['edit'] .= '</i>';
                }
                $tpl->set_ar_out($row, 0);
            }
            $tpl->set_out('SITELINK', $MPL, 1);
            unset($tpl);
        }
    } else {
        $design->header();
        $xajax->printJavascript();
     
        $nid = escape($menu->get(1), 'integer');
        $erg = db_query("SELECT * FROM `prefix_news` WHERE `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id = '" . $nid . "'");
        if (db_num_rows($erg) == 0) {
            $dontShow = true;
        } else {
            $dontShow = false;
            $row = db_fetch_object($erg);
            if ((pow(2, abs($_SESSION['authright'])) | $row->news_recht) != $row->news_recht) {
                $dontShow = true;
            }
            if ($dontShow) {
                foreach($_SESSION['authgrp'] as $id => $bool) {
                    if ($bool and (pow(2, abs($id)) | $row->news_groups) == $row->news_groups) {
                        $dontShow = false;
                        break;
                    }
                }
            }
        }
     
        if ($dontShow) {
            echo 'News existiert nicht oder Sie haben keine Rechte sie zu sehen.  <a href="javascript:history.back();">zur&uuml;ck</a>';
            $design->footer(1);
        }
     
        $komsOK = true;
        if ($allgAr['Ngkoms'] == 0) {
            if (loggedin()) {
                $komsOK = true;
            } else {
                $komsOK = false;
            }
        }
        if ($allgAr['Nukoms'] == 0) {
            $komsOK = false;
        }
     
        $kom_info = '';
        // 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');
            if (checkName($_POST['name']) or loggedin()) {
                if (loggedin()) {
                    $_POST['name'] = $_SESSION['authname'];
                }
                db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (" . $nid . ",'NEWS','" . $_POST['name'] . "','" . $_POST['txt'] . "')");
            } else {
                $kom_info = '<span style="color:red;">Dieser Name ist bereits an einen User vergeben, benutze bitte einen anderen.</span><br />';
            }
        }
        // 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 = $row->html ? $row->news_text : bbcode($row->news_text);
        $textToShow = str_replace('[PREVIEWENDE]', '', $textToShow);
        if (!empty($such)) {
            $textToShow = markword($textToShow, $such);
        }
        // klicks zaehlen
        db_query("UPDATE prefix_news SET klicks = klicks + 1 WHERE news_id = " . $nid);
     
        $tpl = new tpl ('news/news.htm');
        $ar = array (
            'TEXT' => $textToShow,
            'KATE' => $kategorie,
            'NID' => $nid,
            'uname' => $_SESSION['authname'],
            'ANTISPAM' => (loggedin()?'':get_antispam ('newskom', 0)),
            'NAME' => $row->news_title,
            'info' => $kom_info
            );
        $tpl->set_ar_out($ar, 2);
     
        if ($komsOK) {
            $tpl->set_ar_out (array ('NAME' => $row->news_title , 'NID' => $nid, 'style' => loggedin() ? 'style="display:none;"' : ''), 3);
        }
        $erg1 =  db_query("SELECT `a`.`text`, `a`.`name`, `a`.`id`, `b`.`id` AS `userid`, `b`.`name` AS `username`, `b`.`avatar`
                          FROM `prefix_koms` AS `a`
                         LEFT JOIN `prefix_user` AS `b` ON `a`.`name` = `b`.`name`    
                          WHERE `a`.`uid` = " . $nid . " AND `a`.`cat` = 'NEWS' ORDER BY `a`.`id` DESC");
            $ergAnz1 = db_num_rows($erg1);
            if ( $ergAnz1 == 0 ) {
              echo '<b>'.$lang['nocomments'].'</b>';
            } else {
              $zahl = $ergAnz1;
              while ($row1 = db_fetch_assoc($erg1)) {
           
            $username = empty($row1['userid']) ? '<em>Gast:</em> '.$row1['name'] : '<a href="index.php?user-details-'.$row1['userid'].'">'.$row1['username'].'</a>';
            $komavatar = (empty($row1['userid']) ? '' : (!empty($row1['avatar']) && file_exists($row1['avatar']) ? '<a href="index.php?user-details-'.$row1['userid'].'"><img src="'.$row1['avatar'].'" border="0" alt="'.$row1['username'].'" title="'.$row1['username'].'"></a>' : '<img src="include/images/avatars/wurstegal.jpg" alt="Kein Avatar" />'));     
           
            $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&ouml;schen" border="0" title="l&ouml;schen" /></a>';
            }
            $tpl->set_ar_out( array('NAME' => $username,
                                    'AVATAR' => $komavatar,
                                    'TEXT' => $row1['text'],
                                    'ZAHL' => $zahl ) , 4 );
            $zahl--;
            }
        }
        $tpl->out(5);
    }
     
    $design->footer();
     
    ?>


    include/templates/news/news.htm
    <img src="include/designs/shooterbase/images/news_top.jpg" width="567" height="27">
    <table background="include/designs/shooterbase/images/news_bg.jpg" width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="newsbg">
    <tr>
    <td width="10"></td>
    <td>
    <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0">
        <tr>
          <td class="smalfont">{datum} - <strong><a href="index.php?news-{id}">{title}</a></strong></td>
          </tr>
    <table width="98%"  border="0" cellspacing="0" cellpadding="2">
     
        <tr>
          <td><hr style="height: 0px; border: dotted #000000 0px; border-top-width: 1px; " /></td>
          </tr>
    </table>
     
     
     
      <table width="100%" border="0" align="center" cellpadding="1" cellspacing="0" class="cbg1">
        <tr>
          <td align="center">{kate}</td>
        </tr>
     
      </table>
     
     
      <table width="98%"  border="0" cellspacing="0" cellpadding="2">
        <tr>
          <td>{text}</td>
        </tr>
        <tr>
          <td><hr style="height: 0px; border: dotted #000000 0px; border-top-width: 1px; " /></td>
        </tr>
     </table>
     <table width="98%"  border="0" cellspacing="0" cellpadding="1">
        <tr>
     
          <td align="left" width="60%" class="smalfont">Geschrieben von <strong>{username}</strong>{edit}</td>
          <td align="right" width="40%">
            <div align="right"><a href="index.php?news-{id}" alt="Kommentare ({kom})" title="Kommentare ({kom})"><img src="include/images/icons/news/comments.gif" alt="Kommentare ({kom})" border="0"></a>&nbsp;{readwholenews}
            </div></td>
          </td>
          <td width="10"></td>
        </tr>
      </table>
    </td></tr></table>
    <img src="include/designs/shooterbase/images/news_bt.jpg" width="567" height="25">
    <br />
    <br />
    {EXPLODE}
    <br />
    <br /><center>{SITELINK}</center>
     
     
    {EXPLODE}
    <script language="JavaScript" type="text/javascript">
    function delkom (NID, ID) {
    var Check = confirm("Kommentar wirklich löschen?")
    if (Check == true) window.open("index.php?news-"+NID+"-d"+ID,"_self");
    }</script>
    <!-- News Kommentare und Mehr lesen -->
    <table width="100%" cellpadding="5" cellspacing="1" border="0">
      <tr class="Chead">
        <th height="25"><b>{NAME}</b></th>
      </tr>
      <tr>
        <td height="25">{_lang_message}</td>
      </tr>
     
        <tr>
          <td align="center">{KATE}</td>
        </tr>
     
     
      <tr>
        <td >
          <div style="float:left; padding-left:10px; ">{TEXT}</div><br style="clear:both; " />
          <p></p>
          <a href="javascript:history.back(1)"><b>&laquo;</b>{_lang_back}</a> </td>
      </tr>
     
      <tr>
        <td height="25">{_lang_commentsfor} {NAME}</td>
      </tr>
      <tr>
        <td>
     
            {EXPLODE}
            <form action="index.php?news-{NID}" method="POST">
            <fieldset>
              <legend>{_lang_writecomment}</legend>
              <input type="text" name="name" value="{uname}" /> &nbsp; {ANTISPAM} &nbsp; <input type="submit" value="{_lang_enter}"><br />
              <textarea style="width: 98%" cols="50" rows="2" name="txt"></textarea><br />
            </fieldset>
          </form>
          <br />
          {EXPLODE}
     
          <div style="float:left; margin:4px; width:20%; padding:2px 4px 2px 2px; border-right:4px solid #fe9500;"><span class="Cmite"># <b>{ZAHL}</b> von {NAME}</span><br/> <div style="height:7px;"></div><span style="text-align:center; display:block;">{AVATAR}</span></div>
          <div style="float:left; margin:4px; width:70%; padding:3px;">{TEXT}</div>
          <br style="clear:both;">
          <div style="background:#2a2a2a; padding:1px; margin:2px 0 2px 0; width:100%"></div> 
     
          {EXPLODE}
          <br />
          <a href="javascript:history.back(1)"><b>&laquo;</b> {_lang_back}</a>
     
        </td>
      </tr>
    </table>


    MfG OloX


    Zuletzt modifiziert von OloX am 11.05.2010 - 21:24:32
    PHP, JavaScript, CSS
    0 Mitglieder finden den Beitrag gut.
  8. #38
    User Pic
    -=NLNF=-Keule Mitglied
    Registriert seit
    13.05.2009
    Beiträge
    58
    Beitragswertungen
    0 Beitragspunkte
    SUPER GEIL lächeln

    Funktionierte sofort ohne Probleme. Haaach ist das schön, dass haut mich glatt weg. Ist es möglich das der Text neben dem Roten Balken ist. Würde noch besser aussehen glaube ich.

    Kannst Du mir sagen wie Du das genau gemacht hast. Das würde mich brennend Interessieren. zwinker

    Großes Danke nochmal !!!
    0 Mitglieder finden den Beitrag gut.
  9. #39
    User Pic
    OloX Hall Of Fame
    Registriert seit
    25.02.2006
    Beiträge
    990
    Beitragswertungen
    23 Beitragspunkte
    Einfaches HTML zwinker
    Ich habe die news.htm von oben noch einmal bearbeitet, jetzt müsste alles passen zwinker

    MfG OloX
    PHP, JavaScript, CSS
    0 Mitglieder finden den Beitrag gut.
  10. #40
    User Pic
    -=NLNF=-Keule Mitglied
    Registriert seit
    13.05.2009
    Beiträge
    58
    Beitragswertungen
    0 Beitragspunkte
    Danke Danke Danke ... das sieht mal richtig geil aus. Jetzt werde ich mich morgen mal ranmachen und sehen wie Du das gemacht hast. Nen bissel will ich ja auch lernen zwinker

    P.S. Danke das Du auch gleich an die Farbe von dem Balken gedacht hast. ^^

    Besten Gruss
    Keule
    0 Mitglieder finden den Beitrag gut.
  11. #41
    User Pic
    Kazuya Suzuhara Mitglied
    Registriert seit
    31.01.2010
    Beiträge
    59
    Beitragswertungen
    0 Beitragspunkte
    ZitatZitat geschrieben von OloX

    Sorry, das es erst heute kommt sauer
    include/contents/news/news.php
    <?php
    // Copyright by: Manuel Staechele
    // Support: www.ilch.de
    // Modded by Mairu für News Extended
    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);
    }
    // Schaut ob ein Name so oder ähnlich in der Datenbank vorhanden ist
    // gibt true zurück falls der Name noch nicht verwendet ist
    function checkName($name) {
        if (db_count_query("SELECT COUNT(name) FROM prefix_user WHERE name LIKE '$name'")) {
            return false;
        } else {
            return true;
        }
    }
     
    function checkKomName($name) {
        $resp = new xajaxResponse();
        if (checkName($name) OR loggedin()) {
            $resp->script('document.forms["komform"].submit();');
        } else {
            $resp->assign('komname', 'value' , '');
            $resp->alert('Dieser Name ist bereits an einen User vergeben, benutze bitte einen anderen.');
            $resp->script("document.getElementById('komname').focus();");
        }
        return $resp;
    }
    // xajax für namencheck
    $xajax = new xajax();
    $xajax->configureMany(array('decodeUTF8Input' => true ,'characterEncoding' => 'ISO-8859-1', 'requestURI' => 'admin.php?news-ajax'));
    $xajax->register(XAJAX_FUNCTION, 'checkKomName');
    $xajax->processRequest();
     
    if ($menu->get(1) == 'ajax') {
        exit();
    }
     
    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';
     
            $tn_id = intval(@db_result($news_opts = db_query("SELECT v1 FROM prefix_allg WHERE k = 'news' LIMIT 1"), 0));
     
            $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,
          a.html
        FROM prefix_news as a
        LEFT JOIN prefix_user as b ON a.user_id = b.id
        WHERE (a.news_recht | 1) = a.news_recht AND a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND a.news_id != $tn_id AND a.`archiv` != 1 AND (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP())
        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' => $row['html'] ? $a[0] : 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);
     
            // Topnews ausgeben
            $tn_id = intval(@db_result($news_opts = db_query("SELECT v1, v2 FROM prefix_allg WHERE k = 'news' LIMIT 1"), 0, 0));
            $tn_koms = @db_result($news_opts, 0, 1);
            $tn_sql = db_query("SELECT news_title, news_text, news_kat, news_recht, news_groups, html FROM prefix_news WHERE news_id = $tn_id AND `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP())");
            if (db_num_rows($tn_sql) > 0) {
                $tn_r = db_fetch_object($tn_sql);
     
                $dontShow = false;
                if ((pow(2, abs($_SESSION['authright'])) | $tn_r->news_recht) != $tn_r->news_recht) {
                    $dontShow = true;
                }
                if ($dontShow) {
                    foreach($_SESSION['authgrp'] as $id => $bool) {
                        if ($bool and (pow(2, abs($id)) | $tn_r->news_groups) == $tn_r->news_groups) {
                            $dontShow = false;
                            break;
                        }
                    }
                }
                if (!$dontShow) {
                    $tn_tpl = new tpl ('news/top');
                    $tn_tpl->set('title', $tn_r->news_title);
                    $tn_tpl->set('koms', $tn_koms == '1' ? '<br /><a href="index.php?news-' . $tn_id . '">' . db_count_query("SELECT COUNT(id) FROM prefix_koms WHERE uid = $tn_id AND cat = 'NEWS'") . ' ' . $lang['comments'] . ' </a>' : '');
                    if (strpos ($tn_r->news_text , '[PREVIEWENDE]') !== false) {
                        $a = explode('[PREVIEWENDE]' , $tn_r->news_text);
                        $tn_r->news_text = $a[0];
                        $tn_tpl->set('readwholenews', '<a href="index.php?news-' . $tn_id . '" alt="mehr lesen" title="mehr lesen"><img src="include/images/icons/news/more.gif" alt="mehr lesen" border="0"></a>');
                    } else {
                        $tn_tpl->set('readwholenews', '');
                    }
                    $tn_tpl->set('kate', news_find_kat($tn_r->news_kat));
                    $tn_tpl->set_out('txt', $tn_r->html ? $tn_r->news_text : bbcode($tn_r->news_text), 0);
                    unset($tn_tpl);
                }
            }
     
            //Kategorie einschränken
            if ($menu->get(1) != '' and ($menu->getA(1) != 'p' or $menu->getE(1) == 0)) {
                $kats = $katssql = array();  #collect given kats
                $i = 1;
                while($kat = escape($menu->get($i), 'string')){
                    $kats[] = $kat;
                    $katssql[] = '"' . $kat . '"';
                    $i++;
                }
                $news_kat = 'news_kat IN ('.implode(',', $katssql).') AND';
                $katmpl = '-'.implode('-', $kats);
                $page = $menu->getE('p');
                if ($page < 1) {
                    $page = 1;
                }
                $katmpl = str_replace('-p'.$page, '', $katmpl);
            } else {
                $news_kat = $katmpl = '';
                $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1);
            }
     
            $anfang = ($page - 1) * $limit;
            //Gruppenrechte
            $groups = getGroupRights();
     
            $MPL = db_make_sites ($page , "WHERE (((" . pow(2, abs($_SESSION['authright'])) . " | news_recht) = news_recht) OR
                (news_groups != 0 AND ((news_groups ^ $groups) != (news_groups | $groups)))) AND $news_kat `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id != $tn_id AND archiv != 1 AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP())" , $limit , '?news'.$katmpl , 'news');
            // Normale News
            $tpl = new tpl ('news/news.htm');
     
            $abf = "SELECT
          a.news_title as title,
          a.news_id as id,
          DATE_FORMAT(a.news_time,'%d. %m. %Y - %H:%i Uhr') as datum,
          DATE_FORMAT(a.news_time,'%W') as dayofweek,
          a.news_kat as kate,
          a.news_text as text,
          b.name as username,
          c.name as editorname,
          a.html,
          a.edit_time,
          a.klicks,
          b.id as uid
        FROM prefix_news as a
        LEFT JOIN prefix_user as b ON a.user_id = b.id
        LEFT JOIN prefix_user as c ON a.editor_id = c.id
        WHERE (((" . pow(2, abs($_SESSION['authright'])) . " | a.news_recht) = a.news_recht) OR
              (a.news_groups != 0 AND ((a.news_groups ^ $groups) != (a.news_groups | $groups)))) AND $news_kat
            a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND news_id != $tn_id AND a.`archiv` != 1 AND
            (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP())
        ORDER BY a.news_time DESC
        LIMIT " . $anfang . "," . $limit;
     
            // echo '<pre>'.$abf.'</pre>';
            $erg = db_query($abf);
            if (db_num_rows($erg) == 0 and !empty($news_kat)) {
                echo 'Keine News in dieser Kategorie gefunden.<br />
                    <a href="index.php?news">News&uuml;bersichtsseite aufrufen</a>';
                $design->footer(1);
            }
            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'] . '" alt="mehr lesen" title="mehr lesen"><img src="include/images/icons/news/more.gif" alt="mehr lesen" border="0"></a>';
                } else {
                    $row['readwholenews'] = '';
                }
                $row['klicks'] = '<img src="include/images/icons/news/counter.gif" alt="' . $row['klicks'] . ' mal gelesen" title="' . $row['klicks'] . ' mal gelesen" border="0">';
                if (!$row['html']) {
                    $row['text'] = bbcode($row['text']);
                }
                {
               
                    $row['edit'] .= '</i>';
                }
                $tpl->set_ar_out($row, 0);
            }
            $tpl->set_out('SITELINK', $MPL, 1);
            unset($tpl);
        }
    } else {
        $design->header();
        $xajax->printJavascript();
     
        $nid = escape($menu->get(1), 'integer');
        $erg = db_query("SELECT * FROM `prefix_news` WHERE `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id = '" . $nid . "'");
        if (db_num_rows($erg) == 0) {
            $dontShow = true;
        } else {
            $dontShow = false;
            $row = db_fetch_object($erg);
            if ((pow(2, abs($_SESSION['authright'])) | $row->news_recht) != $row->news_recht) {
                $dontShow = true;
            }
            if ($dontShow) {
                foreach($_SESSION['authgrp'] as $id => $bool) {
                    if ($bool and (pow(2, abs($id)) | $row->news_groups) == $row->news_groups) {
                        $dontShow = false;
                        break;
                    }
                }
            }
        }
     
        if ($dontShow) {
            echo 'News existiert nicht oder Sie haben keine Rechte sie zu sehen.  <a href="javascript:history.back();">zur&uuml;ck</a>';
            $design->footer(1);
        }
     
        $komsOK = true;
        if ($allgAr['Ngkoms'] == 0) {
            if (loggedin()) {
                $komsOK = true;
            } else {
                $komsOK = false;
            }
        }
        if ($allgAr['Nukoms'] == 0) {
            $komsOK = false;
        }
     
        $kom_info = '';
        // 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');
            if (checkName($_POST['name']) or loggedin()) {
                if (loggedin()) {
                    $_POST['name'] = $_SESSION['authname'];
                }
                db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (" . $nid . ",'NEWS','" . $_POST['name'] . "','" . $_POST['txt'] . "')");
            } else {
                $kom_info = '<span style="color:red;">Dieser Name ist bereits an einen User vergeben, benutze bitte einen anderen.</span><br />';
            }
        }
        // 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 = $row->html ? $row->news_text : bbcode($row->news_text);
        $textToShow = str_replace('[PREVIEWENDE]', '', $textToShow);
        if (!empty($such)) {
            $textToShow = markword($textToShow, $such);
        }
        // klicks zaehlen
        db_query("UPDATE prefix_news SET klicks = klicks + 1 WHERE news_id = " . $nid);
     
        $tpl = new tpl ('news/news.htm');
        $ar = array (
            'TEXT' => $textToShow,
            'KATE' => $kategorie,
            'NID' => $nid,
            'uname' => $_SESSION['authname'],
            'ANTISPAM' => (loggedin()?'':get_antispam ('newskom', 0)),
            'NAME' => $row->news_title,
            'info' => $kom_info
            );
        $tpl->set_ar_out($ar, 2);
     
        if ($komsOK) {
            $tpl->set_ar_out (array ('NAME' => $row->news_title , 'NID' => $nid, 'style' => loggedin() ? 'style="display:none;"' : ''), 3);
        }
        $erg1 =  db_query("SELECT `a`.`text`, `a`.`name`, `a`.`id`, `b`.`id` AS `userid`, `b`.`name` AS `username`, `b`.`avatar`
                          FROM `prefix_koms` AS `a`
                         LEFT JOIN `prefix_user` AS `b` ON `a`.`name` = `b`.`name`    
                          WHERE `a`.`uid` = " . $nid . " AND `a`.`cat` = 'NEWS' ORDER BY `a`.`id` DESC");
            $ergAnz1 = db_num_rows($erg1);
            if ( $ergAnz1 == 0 ) {
              echo '<b>'.$lang['nocomments'].'</b>';
            } else {
              $zahl = $ergAnz1;
              while ($row1 = db_fetch_assoc($erg1)) {
           
            $username = empty($row1['userid']) ? '<em>Gast:</em> '.$row1['name'] : '<a href="index.php?user-details-'.$row1['userid'].'">'.$row1['username'].'</a>';
            $komavatar = (empty($row1['userid']) ? '' : (!empty($row1['avatar']) && file_exists($row1['avatar']) ? '<a href="index.php?user-details-'.$row1['userid'].'"><img src="'.$row1['avatar'].'" border="0" alt="'.$row1['username'].'" title="'.$row1['username'].'"></a>' : '<img src="include/images/avatars/wurstegal.jpg" alt="Kein Avatar" />'));     
           
            $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&ouml;schen" border="0" title="l&ouml;schen" /></a>';
            }
            $tpl->set_ar_out( array('NAME' => $username,
                                    'AVATAR' => $komavatar,
                                    'TEXT' => $row1['text'],
                                    'ZAHL' => $zahl ) , 4 );
            $zahl--;
            }
        }
        $tpl->out(5);
    }
     
    $design->footer();
     
    ?>


    include/templates/news/news.htm
    <img src="include/designs/shooterbase/images/news_top.jpg" width="567" height="27">
    <table background="include/designs/shooterbase/images/news_bg.jpg" width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="newsbg">
    <tr>
    <td width="10"></td>
    <td>
    <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0">
        <tr>
          <td class="smalfont">{datum} - <strong><a href="index.php?news-{id}">{title}</a></strong></td>
          </tr>
    <table width="98%"  border="0" cellspacing="0" cellpadding="2">
     
        <tr>
          <td><hr style="height: 0px; border: dotted #000000 0px; border-top-width: 1px; " /></td>
          </tr>
    </table>
     
     
     
      <table width="100%" border="0" align="center" cellpadding="1" cellspacing="0" class="cbg1">
        <tr>
          <td align="center">{kate}</td>
        </tr>
     
      </table>
     
     
      <table width="98%"  border="0" cellspacing="0" cellpadding="2">
        <tr>
          <td>{text}</td>
        </tr>
        <tr>
          <td><hr style="height: 0px; border: dotted #000000 0px; border-top-width: 1px; " /></td>
        </tr>
     </table>
     <table width="98%"  border="0" cellspacing="0" cellpadding="1">
        <tr>
     
          <td align="left" width="60%" class="smalfont">Geschrieben von <strong>{username}</strong>{edit}</td>
          <td align="right" width="40%">
            <div align="right"><a href="index.php?news-{id}" alt="Kommentare ({kom})" title="Kommentare ({kom})"><img src="include/images/icons/news/comments.gif" alt="Kommentare ({kom})" border="0"></a>&nbsp;{readwholenews}
            </div></td>
          </td>
          <td width="10"></td>
        </tr>
      </table>
    </td></tr></table>
    <img src="include/designs/shooterbase/images/news_bt.jpg" width="567" height="25">
    <br />
    <br />
    {EXPLODE}
    <br />
    <br /><center>{SITELINK}</center>
     
     
    {EXPLODE}
    <script language="JavaScript" type="text/javascript">
    function delkom (NID, ID) {
    var Check = confirm("Kommentar wirklich löschen?")
    if (Check == true) window.open("index.php?news-"+NID+"-d"+ID,"_self");
    }</script>
    <!-- News Kommentare und Mehr lesen -->
    <table width="100%" cellpadding="5" cellspacing="1" border="0">
      <tr class="Chead">
        <th height="25"><b>{NAME}</b></th>
      </tr>
      <tr>
        <td height="25">{_lang_message}</td>
      </tr>
     
        <tr>
          <td align="center">{KATE}</td>
        </tr>
     
     
      <tr>
        <td >
          <div style="float:left; padding-left:10px; ">{TEXT}</div><br style="clear:both; " />
          <p></p>
          <a href="javascript:history.back(1)"><b>&laquo;</b>{_lang_back}</a> </td>
      </tr>
     
      <tr>
        <td height="25">{_lang_commentsfor} {NAME}</td>
      </tr>
      <tr>
        <td>
     
            {EXPLODE}
            <form action="index.php?news-{NID}" method="POST">
            <fieldset>
              <legend>{_lang_writecomment}</legend>
              <input type="text" name="name" value="{uname}" /> &nbsp; {ANTISPAM} &nbsp; <input type="submit" value="{_lang_enter}"><br />
              <textarea style="width: 98%" cols="50" rows="2" name="txt"></textarea><br />
            </fieldset>
          </form>
          <br />
          {EXPLODE}
     
          <div style="float:left; margin:4px; width:20%; padding:2px 4px 2px 2px; border-right:4px solid #fe9500;"><span class="Cmite"># <b>{ZAHL}</b> von {NAME}</span><br/> <div style="height:7px;"></div><span style="text-align:center; display:block;">{AVATAR}</span></div>
          <div style="float:left; margin:4px; width:70%; padding:3px;">{TEXT}</div>
          <br style="clear:both;">
          <div style="background:#2a2a2a; padding:1px; margin:2px 0 2px 0; width:100%"></div> 
     
          {EXPLODE}
          <br />
          <a href="javascript:history.back(1)"><b>&laquo;</b> {_lang_back}</a>
     
        </td>
      </tr>
    </table>


    MfG OloX


    Zuletzt modifiziert von OloX am 11.05.2010 - 21:24:32


    Also habe die zwei dateien versucht so zu übernehmen, aber irgendwie bekomm ich da nur eine Fehlermeldung.
    Folgend Fehlermeldung erhalte ich:
    MySQL Error:
    1267 : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german1_ci,IMPLICIT) for operation '='
    in Query:
    SELECT `a`.`text`, `a`.`name`, `a`.`id`, `b`.`id` AS `userid`, `b`.`name` AS `username`, `b`.`avatar` FROM `ic1_koms` AS `a` LEFT JOIN `ic1_user` AS `b` ON `a`.`name` = `b`.`name` WHERE `a`.`uid` = 3 AND `a`.`cat` = 'NEWS' ORDER BY `a`.`id` DESC
    Debug backtrace:
    	@ mysql.php:32 -- debug_bt()
    	@ mysql.php:50 -- db_check_error(...)
    	@ news.php:332 -- db_query(...)
    	@ news.php:21 -- require_once(...)
    	@ index.php:35 -- require_once(...)
    
    Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in E:\server\xampp\htdocs\ilchclan_dev\include\includes\func\db\mysql.php on line 71


    Was mache ich denn falsch das das einfach net klappt.

    Schonmal im vorraus Danke

    Seite läuft auf einem lokalen Testserver.
    Scriptversion 1.1O
    news extended 1.4a
    0 Mitglieder finden den Beitrag gut.
  12. #42
    User Pic
    she Mitglied
    Registriert seit
    13.11.2010
    Beiträge
    1.115
    Beitragswertungen
    82 Beitragspunkte
    ic1_koms alles auf latin1_swedish_ci setzen. via phpMyadmin ^^ dann bekommst du den Fehler nicht mehr.
    Google+ shelfinger.eu
    Das Wissen verfolgt mich - doch ich bin schneller!
    0 Mitglieder finden den Beitrag gut.
  13. #43
    User Pic
    Kazuya Suzuhara Mitglied
    Registriert seit
    31.01.2010
    Beiträge
    59
    Beitragswertungen
    0 Beitragspunkte
    ZitatZitat geschrieben von she

    ic1_koms alles auf latin1_swedish_ci setzen. via phpMyadmin ^^ dann bekommst du den Fehler nicht mehr.


    Bis auf ID und UID sind sie alle auf latin1_swedish_ci und ID sowie UID lassen sich net auf latin1_swedish_ci setzen

    Hab grad mal geschaut also die
    ic1_koms -> latin1_swedish_ci
    ic1_news -> latin1_swedish_ci
    ic1_user -> latin1_german_ci

    könnte es daran liegen wenn ja was müßte ich verändern?


    Zuletzt modifiziert von Kazuya Suzuhara am 05.12.2010 - 19:54:01
    0 Mitglieder finden den Beitrag gut.
  14. #44
    User Pic
    she Mitglied
    Registriert seit
    13.11.2010
    Beiträge
    1.115
    Beitragswertungen
    82 Beitragspunkte
    wenn du my.cnf ran kommst kannst du dort die kollation ändern. Ansonsten muss du die Tabelle nochmal löschen zu mindest die ic1_user. Mach ein Backup ändere latin1_german_ci auf latin1_swedisch_ci füge das Backup von ic1_user ein.
    Google+ shelfinger.eu
    Das Wissen verfolgt mich - doch ich bin schneller!
    0 Mitglieder finden den Beitrag gut.
  15. #45
    User Pic
    Kazuya Suzuhara Mitglied
    Registriert seit
    31.01.2010
    Beiträge
    59
    Beitragswertungen
    0 Beitragspunkte
    ZitatZitat geschrieben von she

    wenn du my.cnf ran kommst kannst du dort die kollation ändern. Ansonsten muss du die Tabelle nochmal löschen zu mindest die ic1_user. Mach ein Backup ändere latin1_german_ci auf latin1_swedisch_ci füge das Backup von ic1_user ein.


    okay danke habe das soweit verstanden andersherum das man die
    ic1_koms -> latin1_swedish_ci in ic1_koms -> latin1_german_ci ist wohl nicht möglich?
    Das wären dann weniger einträge die zu ändern wären -> oder ist Kollation latin1_swedish_ci standard oder sogar besser
    0 Mitglieder finden den Beitrag gut.
  16. #46
    User Pic
    she Mitglied
    Registriert seit
    13.11.2010
    Beiträge
    1.115
    Beitragswertungen
    82 Beitragspunkte
    Das ist egal wie rum du es machst. Hauptsache es ist bei einer Query die gleiche Kollation.
    Google+ shelfinger.eu
    Das Wissen verfolgt mich - doch ich bin schneller!
    0 Mitglieder finden den Beitrag gut.
  17. #47
    User Pic
    Kazuya Suzuhara Mitglied
    Registriert seit
    31.01.2010
    Beiträge
    59
    Beitragswertungen
    0 Beitragspunkte
    ZitatZitat geschrieben von she

    Das ist egal wie rum du es machst. Hauptsache es ist bei einer Query die gleiche Kollation.


    Okay ich danke dir
    0 Mitglieder finden den Beitrag gut.
  18. #48
    User Pic
    swenieboy Mitglied
    Registriert seit
    19.03.2009
    Beiträge
    232
    Beitragswertungen
    0 Beitragspunkte
    Hallo ...
    funkt super aber wie bekomme ich da jetzt noch eine zeit rein wann ein com geschrieben wurde ... kann mir bitte da jemand helfen ?


    Zuletzt modifiziert von swenieboy am 18.03.2011 - 21:32:12
    0 Mitglieder finden den Beitrag gut.
Geschlossen

Zurück zu Module und Modifikationen

Optionen: Bei einer Antwort zu diesem Thema eine eMail erhalten