Onarcade Yorum - R10.net

04-05-2009, 23:41:56

TurkHizmet.Gen.TR

Merhaba Arkadaşlar..
Söyle bişey yapmak istiyorum yardımcı olabilirmisiniz acaba..
onarcade scriptini film sitesi olarak kullanıyorum.. yapılan yorumları hangi filme ait oldugunu yapmak istiyorum şu sekil..yorum yapıldıktan sonra admin paneline girince
Kullanici IP Katilim tarihi Mesaj
Guest 85.97.32.183 2009-05-04 atbakalim Uygula - Sil

Kullanıcı Adı
İp Adresi
Katilim Tarihi
Mesaj
bunların yanına birde URL diye bi bölüm ekleyip bu bölümün altına yorum un hangi linke ait oldugunu gösterebilirmiyiz acaba..

bu yorumların admin panelindeki kod yeri..

--------------------------------

<?php
if ($userStatus != '1' || $userGroup != '2' || !isset($_SESSION['userid'])) {
header ("Location: login.php");
exit();
}
$sql = mysql_query("SELECT title FROM files WHERE fileid = '$fileid' LIMIT 1");
$row = mysql_fetch_array($sql);
$filetitle = $row['title'];
?>
<center>
<a href="index.php?action=addgame">Yeni Dosya Ekle </a> | <a href="index.php?action=grabfile">Dosyayi Al </a> | <a href="index.php?action=uploadfile">Dosya Yükle </a>| <a href="index.php?action=approvecomments">Yorumlari Onayla</a>
</center> 
<table style="border: 0px; font-size: 12px; font-family: Arial; width: 100%;">
<?php if ($error == '1') { ?>
<tr>
<td align="center" colspan="4">Yorum silindi !</td>
</tr>
<?php } elseif ($error == '2') {?>
<tr>
<td align="center" colspan="4">Yorum onaylandi !</td>
</tr>
<?php } ?>
<tr>
<td align="center">Kullanici</td>
<td align="center">IP</td>
<td align="center">Katilim tarihi </td>
<td align="center">Mesaj</td>
<td></td>
</tr>
<?php
$commentnr = "0";
$comments_result = mysql_query("SELECT * FROM comments WHERE status = '0' ORDER BY commentid");
if (mysql_num_rows($comments_result)) {
while($row = mysql_fetch_array($comments_result)) {
$commentid = $row['commentid'];
$cuserid = $row['userid'];
$comment = nl2br(htmlentities($row['comment']));
$comment = bbcode($comment);
$cdate = $row['date'];
$cuserip = $row['ip'];
if ($cuserid == '0') {
$cusername = "Guest";
} else {
$sql = mysql_query("SELECT username FROM users WHERE userid = '$cuserid' LIMIT 1");
$row2 = mysql_fetch_array($sql);
$cusername = htmlentities($row2[username]);
$cusername = "<a href=\"".profileurl($cuserid,$cusername)."\" style=\"color: #003366;\">".$cusername."</a>";
}
if ($commentnr == '0') {
$rowbgcolor = "#A4D3EE";
$commentnr = "1";
} else {
$rowbgcolor = "#FFFFFF";
$commentnr = "0";
}
?>
<tr bgcolor="<?php echo $rowbgcolor; ?>">
<td align="center" valign="top"><?php echo $cusername; ?></td><td align="center" valign="top"><?php echo $cuserip; ?></td><td align="center" valign="top"><?php echo $cdate; ?></td><td valign="top"><?php echo $comment; ?></td>
<td align="center" valign="top"><a href="index.php?action=approvecomments&approve=<?p hp echo $commentid; ?>">Uygula</a> - <a onclick='return confirmDelete()' href="index.php?action=approvecomments&delete=<?ph p echo $commentid; ?>">Sil</a></td>
</tr>
<?php
}
}
?>
</table>

-------------------
yardımlarınızdan dolayı çok tsk ederim..

05-05-2009, 00:18:09

#2

Jotuxi

Hocam öncelikle onArcade'nin hangi versiyonunu kullandığını öğrenebilir miyim ? ve normal bildiğim sürümlerinde, admin panelinde yorumlar'a ait ayrı bir sayfa yok.O nedenle soruyorum.

05-05-2009, 00:28:46

#3

donanimmerkezi.com

Aşağıdakini bul

$cuserip = $row['ip'];

Sonrasına bunu ekle

$dosyaid = $row['fileid'];

Aşağıdakini bul

<td align="center" valign="top"><?php echo $cusername; ?></td><td align="center" valign="top"><?php echo $cuserip; ?></td><td align="center" valign="top"><?php echo $cdate; ?></td><td valign="top"><?php echo $comment; ?></td>
<td align="center" valign="top"><a href="index.php?action=approvecomments&approve=<?p hp echo $commentid; ?>">Uygula</a> - <a onclick='return confirmDelete()' href="index.php?action=approvecomments&delete=<?ph p echo $commentid; ?>">Sil</a></td>
</tr>

Bununla değiştir.

<td align="center" valign="top"><?php echo $cusername; ?></td><td align="center" valign="top"><?php echo $cuserip; ?></td><td align="center" valign="top"><?php echo $cdate; ?></td><td valign="top"><?php echo $comment; ?></td><td align="center" valign="top"><a href="index.php?action=approvecomments&approve=<?php echo $commentid; ?>">Approve</a> - <a onclick='return confirmDelete()' href="index.php?action=approvecomments&delete=<?php echo $commentid; ?>">Delete</a>-<a href="../file.php?f=<?php echo $dosyaid; ?>">ID</a></td>
  </tr>

05-05-2009, 00:35:51

#4

Jotuxi

Buyur hocam aşağıdaki kodları tamamen kendi comments.php dosyan ile değiştir.

comments.php

<?php
if ($userStatus != '1' || $userGroup != '2' || !isset($_SESSION['userid'])) {
header ("Location: login.php");
exit();
}
$sql = mysql_query("SELECT title FROM files WHERE fileid = '$fileid' LIMIT 1");
$row = mysql_fetch_array($sql);
$filetitle = $row['title'];
?>
<center>
<a href="index.php?action=addgame">Yeni Dosya Ekle </a> | <a href="index.php?action=grabfile">Dosyayi Al </a> | <a href="index.php?action=uploadfile">Dosya Yükle </a>| <a href="index.php?action=approvecomments">Yorumlari Onayla</a>
</center><br />
<table style="border: 0px; font-size: 12px; font-family: Arial; width: 100%;">
<?php if ($error == '1') { ?>
<tr>
<td align="center" colspan="4"><font color="red"><b>Yorum silindi !</b></font></td>
</tr>
<?php } elseif ($error == '2') {?>
<tr>
<td align="center" colspan="4"><font color="red"><b>Yorum onaylandi !</b></font></td>
</tr>
<?php } ?>
<tr>
<td align="center"><b>Kullanici</b></td>
<td align="center"><b>IP</b></td>
<td align="center"><b>Katilim tarihi </b></td>
<td align="center"><b>Mesaj</b></td>
<td align="center"><b>Yorum Adresi</b></td>
<td></td>
</tr>
<?php
$commentnr = "0";
$comments_result = mysql_query("SELECT * FROM comments WHERE status = '0' ORDER BY commentid");
if (mysql_num_rows($comments_result)) {
while($row = mysql_fetch_array($comments_result)) {
$commentid = $row['commentid'];
$cuserid = $row['userid'];
$comment = nl2br(htmlentities($row['comment']));
$comment = bbcode($comment);
$cdate = $row['date'];
$cuserip = $row['ip'];
if ($cuserid == '0') {
$cusername = "Guest";
} else {
$sql = mysql_query("SELECT username FROM users WHERE userid = '$cuserid' LIMIT 1");
$row2 = mysql_fetch_array($sql);
$cusername = htmlentities($row2[username]);
$cusername = "<a href=\"".profileurl($cuserid,$cusername)."\" style=\"color: #003366;\">".$cusername."</a>";
}
if ($commentnr == '0') {
$rowbgcolor = "#A4D3EE";
$commentnr = "1";
} else {
$rowbgcolor = "#FFFFFF";
$commentnr = "0";
}
?>
<tr bgcolor="<?php echo $rowbgcolor; ?>">
<td align="center" valign="top"><?php echo $cusername; ?></td>
<td align="center" valign="top"><?php echo $cuserip; ?></td>
<td align="center" valign="top"><?php echo $cdate; ?></td>
<td valign="top"><?php echo $comment; ?></td>
<td align="center"><a href="../file.php?f=<?php echo $fileid; ?>"><?php echo $filetitle; ?></a></td>
<td align="center" valign="top"><a href="index.php?action=approvecomments&approve=<?php echo $commentid; ?>">Uygula</a> - <a onclick='return confirmDelete()' href="index.php?action=approvecomments&delete=<?ph p echo $commentid; ?>">Sil</a></td>
</tr>
<?php
}
}
?>
</table>

Kolay gelsin..

05-05-2009, 21:20:48

#5

TurkHizmet.Gen.TR

domainmerkezi çok tsk ederim oldu

Jotuxi sanada çok tskederim ilgilendigin için..

05-05-2009, 21:25:00

#6