Hello
I have downloaded the report dead lnk plgn from this site http://www.seditio.org/page.php?id=21
But it dont seems to work 100% anymore I cant report any think with it because it dont save it into datebase .
All so I cant go to the admin page it wll stay on the normale default page
Is there someone around here that is willing to help me out
<?PHP
/* ====================
Land Down Under - Website engine
Copyright Neocrome
http://www.neocrome.net
[BEGIN_SED]
File=plugins/report/report.php
Version=801
Updated=2007-mei-26
Type=Plugin
Author=Mcsnakes
Description=Report plugin
[END_SED]
[BEGIN_SED_EXTPLUGIN]
Code=report
Part=main
File=report
Hooks=standalone
Tags=
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]
==================== */
if (!defined('SED_CODE') || !defined('SED_PLUG')) { die('Wrong URL.'); }
$cfg_subject[1] = "";
$sql = mysql_query("SELECT COUNT(*) FROM sed_contact");
$total = mysql_result($sql,0,"COUNT(*)");
$plugin_title = $L['plu_title'];
if ($usr['isadmin']){
$plugin_subtitle = "<a href='plug.php?e=report&sub=admin'>".$L['plu_subtitle']."</a> ".$L['plu_total']." ".$total.""; }
if (isset($sub)){
if($sub=='admin') {
if ($usr['isadmin']){
$plugin_body .="<table class='cells' width='100%'>";
$plugin_body .="<tr>";
$plugin_body .="<td>ID</td>";
$plugin_body .="<td>".$L['plu_name']."</td>";
$plugin_body .="<td>".$L['plu_email']."</td>";
$plugin_body .="<td>".$L['plu_type']."</td>";
$plugin_body .="<td>".$L['plu_admin']."</td>";
$plugin_body .="</tr>";
$sql = mysql_query("SELECT * FROM sed_contact ORDER BY 'contact_id' DESC");
while ($row = mysql_fetch_array($sql))
{
$jj++;
$id = $row["contact_id"];
$name = $row["contact_name"];
$email = $row["contact_email"];
$type = $row["contact_title"];
$plugin_body .="<tr>";
$plugin_body .="<td>".$id."</td>";
$plugin_body .="<td><a href='plug.php?e=report&sub=view&id=".$id."'>".$name."</a></td>";
$plugin_body .="<td><a href='mailto:".$email."'>".$email."</a></td>";
$plugin_body .="<td>".$type."</td>";
$plugin_body .="<td><a href='plug.php?e=report&sub=delete&id=".$id."'>".$L['plu_delete']."</a></td>";
$plugin_body .="</tr>";
}
$plugin_body .="</table>";
}else{
$plugin_body .= "".$L['plu_error'].""; }
}
if($sub=='view') {
$sql = mysql_query("SELECT * FROM sed_contact WHERE contact_id='$id'");
while ($row = mysql_fetch_array($sql))
{
$jj++;
$id = $row["contact_id"];
$name = $row["contact_name"];
$email = $row["contact_email"];
$type = $row["contact_title"];
$text = $row["contact_text"];
$plugin_body .="<table class='cells' width='100%'>";
$plugin_body .="<tr>";
$plugin_body .="<td>ID</td>";
$plugin_body .="<td>".$L['plu_name']."</td>";
$plugin_body .="<td>".$L['plu_email']."</td>";
$plugin_body .="<td>".$L['plu_type']."</td>";
$plugin_body .="<td>".$L['plu_admin']."</td>";
$plugin_body .="</tr>";
$plugin_body .="<tr>";
$plugin_body .="<td>".$id."</td>";
$plugin_body .="<td><a href='plug.php?e=report&sub=admin&id=".$id."'>".$name."</a></td>";
$plugin_body .="<td><a href='mailto:".$email."'>".$email."</a></td>";
$plugin_body .="<td>".$type."</td>";
$plugin_body .="<td><a href='plug.php?e=report&sub=delete&id=".$id."'>".$L['plu_delete']."</a></td>";
$plugin_body .="</tr>";
$plugin_body .="</table>";
$plugin_body .="<table class='cells' width='100%'>";
$plugin_body .="<tr>";
$plugin_body .="<td>".$L['plu_text']."</td>";
$plugin_body .="</tr>";
$plugin_body .="<tr>";
$plugin_body .="<td>".$text."</td>";
$plugin_body .="</tr>";
$plugin_body .="</table>";
}
}
if($sub=='delete') {
if ($usr['isadmin']){
$sql = mysql_query("DELETE FROM sed_contact WHERE contact_id='$id'");
if (mysql_affected_rows()>0)
{ $plugin_body .= "".$L['plu_deleted'].""; }
else
{ $plugin_body .= "".$L['plu_nofind'].""; }
}else{
$plugin_body .= "".$L['plu_error']."";
}
}
if($sub=='send') {
$name = sed_import('name','P','STX');
$email = sed_import('email','P','STX');
$type = sed_import('type','P','STX');
$text = sed_import('text','P','STX');
mysql_query("INSERT INTO sed_contact (contact_name, contact_email, contact_title, contact_text) VALUES ('".$name."','".$email."','".$cfg_subject[$sender_subject]."','".$text."')");
$plugin_body .= "".$L['plu_message']."";
}
}else{
$form_name = "<input type=\"text\" class=\"text\" name=\"name\" value=\"".sed_cc($name)."\" size=\"24\" maxlength=\"24\" />";
$form_email = "<input type=\"text\" class=\"text\" name=\"email\" value=\"".sed_cc($email)."\" size=\"24\" maxlength=\"64\" />";
$form_text = "<textarea name=\"text\" rows=\"4\" cols=\"56\">".sed_cc($text)."</textarea>";
$plugin_body .= "<table class=\"cells\">";
$plugin_body .= "<form action=\"plug.php?e=report&sub=send\" method=\"post\">";
$plugin_body .= "<tr><td>".$L['plu_name']."</td> <td>".$form_name."</td></tr>";
$plugin_body .= "<tr><td>".$L['plu_email']."</td> <td>".$form_email."</td></tr>";
foreach ($cfg_subject as $k => $v)
{
$selected = ($k == $sender_subject) ? "selected=\"selected\"" : '';
$plugin_body .= "<option value=\"".$k."\" $selected>".$v."</option>\n";
}
$plugin_body .= "</select>";
$plugin_body .= "</td></tr>";
$plugin_body .= "<tr><td>".$L['plu_text']."</td> <td>".$form_text."</td></tr>";
$plugin_body .= "<tr><td><input type=\"submit\" value=\"".$L['plu_send']."\"></td> <td></td></tr></table></form>";
}
?>
