Bi kaç kod buldum ama çalıştıramadım.
<?
$mesaj_sayisi = "10"; // görünmesini istediğiniz mesaj sayısı
// Unix Tarihini Normal Tarihe Çevirme Fonksiyonu
function unix2date($string){
$string = date("d.m.Y H:i:s",$string);
return $string;
}
echo '<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="23" colspan="3" bgcolor="#E9E9E9">Forumda
Yazılan Son 10 Mesaj </td>
</tr>
<tr>
<td width="68%"><strong>Konu</strong></td>
<td width="15%"><strong>Kimden</strong></td>
<td width="17%"><strong>Tarih</strong></td>
</tr>';
// BAĞLANIYORUZ
$sorgu = mysql_query("
SELECT *
FROM smf_messages,smf_members
WHERE smf_messages.ID_MEMBER = smf_members.ID_MEMBER
ORDER BY smf_messages.ID_MSG DESC
LIMIT $mesaj_sayisi");
while($r=mysql_fetch_array($sorgu)) {
$msgno = (int)$r['ID_MSG'];
$msg = $r['subject'];
$topicno = (int)$r['ID_TOPIC'];
$userid =(int)$r['ID_MEMBER'];
$username = $r['memberName'];
$title = $r['title'];
$tarih = unix2date($r['posterTime']);
echo '<tr><td><a href="forum/index.php/topic,'.$topicno.'.msg'.$msgno.'/topicseen.html#msg'.$msgno.'"
target="_blank">'.$msg.'</a></td>
<td><a href="forum/index.php?action=profile;u='.$userid.'" target="_blank">'.$username.'</a></td>
<td>'.$tarih.'</td>
</tr>';
}Warning: mysql_query() [function.mysql-query]: Access denied for user 'evil'@'localhost' (using password: NO) in /home/evil/public_html/aaaa.php on line 29Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/evil/public_html/aaaa.php on line 29
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/evil/public_html/aaaa.php on line 31
Hatalarını veriyor..
function forum_enson () {
$quer = mysql_query("SELECT ID_MSG,ID_TOPIC,ID_BOARD,subject,ID_MEMBER FROM smf_messages");
$i = 0;
while ($i <= mysql_num_rows($quer)) {
@mysql_data_seek($quer,$i);
$sonuc["$i"] = mysql_fetch_array($quer);
$i ++;
}
function siralabea ($a,$b) {
if ($a[0]==$b[0]) return 0;
return ($b[0] > $a[0]) ? 1 : -1;
}
if ($sonuc) {
usort($sonuc,'siralabea');
$q = 0;
foreach ($sonuc as $sorgu) {
if ($sorgu[0]) {
if ($q <= 20) {
$qtr = mysql_query("SELECT memberName FROM smf_members WHERE ID_MEMBER = '$sorgu[4]'");
@mysql_data_seek($qtr,1);
$uye = mysql_fetch_array($qtr);
$pst = $sorgu[3].' ('.$uye[0].')';
$pst2 = $sorgu[3].' ('.$uye[0].')';
if (strlen($pst) > 25) { $pst = substr($pst,0,25).'...'; }
else { $pst = $pst; }
$temp .= '
<img src="resim/ikon5.gif" /> <a title="'.$pst2.'" href="http://www.xxxx.com/forum/index.php?topic='.$sorgu[1].'.msg'.$sorgu[0].'#msg'.$sorgu[0].'">'.$pst.'</a><br />
';
}
$q ++;
}
}Bu kod da aşağıdaki hatayı veriyor.
Parse error: syntax error, unexpected $end in /home/evil/public_html/aaaa.php on line 34
yardımcı olursanız sevinirim.
