Problem mit Newsscript

Milcho

Hallo ich hab das news script von http://www.chipmunk-scripts.com.
ich habe es nicht verändert außer den style, das eintragen funktioniert einfand frei aber das Löschen bzw bearbeiten nicht. Wenn man versucht was zu löschen oder zu Bearbeiten geht er auf die datei und das nichts passiert. Ich hoffe jmd von euch weiß warum oder hat ne idee wie man das anders schreiben kann.

Link zu meinem Script:
klick
Adminbreich:
User: Admin
pw: test
klick

Also hier die Codes der dateien

Mod.php (Admin ansieht der Einträge)

Code

<?
//CMS core 
//Core code for content management system
include "connect.php";
include "variables.php";
print "<body link=$link>";
print "<body vlink=$vlink>";
if(isset($_GET['EntryID'])) //If looking at a specific Article
  {

    print "<center><table border='0' width=90% >";
    print "<tr><td valign='top' width='75%' align='center'>


";
    print "<table border='1' width='90%' bordercolor=$borderc cellpadding='4' cellspacing='0'><tr><td bgcolor=$barcolor>";
    $EntryID=$_GET['EntryID'];
    $article="SELECT * FROM CMS_articles where EntryID='$EntryID'";
    $article2=mysql_query($article) or die("It died");
    while($r=mysql_fetch_array($article2))
      {
         print "[b]<font color=$barfont>$r[title] by $r[CMS_author] at $r[CMS_tsubmit]</font>[/b]";
         print "</td></tr>";
         print "<tr><td>


$r[body]


";
         print "Rate article, 5 being the best";
         print "<form action='../ratearticle.php' method='post'>";
         print "<input type='hidden' name='EntryID' value='$EntryID'>";
         print "<Select name='rankselect'>";
         print "<option>1</option>";
         print "<option>2</option>";
         print "<option>3</option>";
         print "<option>4</option>";
         print "<option>5</option>";
         print "</select>
";
         print "<input type='submit' name='submit' value='Vote'></form>


";
         print "[url='index.php']Back to Main[/url]
";
         print "<form action='modelete.php' method='post'>";
         print "<input type='hidden' name='id' value='$r[EntryID]'>";
         print "<input type='hidden' name='title' value='$r[title]'>";
         print "<input type='hidden' name='shortdescription' value='$r[shortdescription]'>";
         print "<input type='hidden' name='body' value='$r[body]'>";
         print "
<input type='submit' value='Delete Entry' name='submit'>";
         print "<input type='submit' value='Edit Entry' name='edit'></form>
";
         print "</td></tr>";
     }
    print "</table></td>";
    print "<td valign='top' width='25%'>


";
    print "<table border='1' cellpadding='4' cellspacing='0' bordercolor=$borderc>";
    print "<tr><td bgcolor=$barcolor>[b]<font color=$barfont>Highest rated Articles[/b]</font></td></tr>";
    print "<tr><td>";
    $rateselect="SELECT * from CMS_articles order by avgvotes DESC LIMIT 7";
    $rateselect2=mysql_query($rateselect) or die("it died");
    while($r=mysql_fetch_array($rateselect2))
      {
          $r[avgvotes] = number_format($r[avgvotes], 1, '.', '');
          print "[url='mod.php?EntryID=$r[EntryID]']$r[title][/url]($r[avgvotes])
";
      }
    print "</td></tr></table>


";
    print "<table border='1' cellpadding='4' cellspacing='0' bordercolor=$borderc>";
    print "<tr><td bgcolor=$barcolor>[b]<font color=$barfont>Most Read Articles[/b]</font></td></tr>";
    print "<tr><td>";
    $readselect="SELECT * from CMS_articles order by timesviewed DESC LIMIT 7";
    $readselect2=mysql_query($readselect) or die("it died");
    while ($r2=mysql_fetch_array($readselect2))
      {
         print "[url='mod.php?EntryID=$r2[EntryID]']$r2[title][/url]($r2[timesviewed])
";
      }
    print "</td></tr></table>


";
    print "<table border='1' cellpadding='4' cellspacing='0' bordercolor=$borderc>";
    print "<tr><td bgcolor=$barcolor>[b]<font color=$barfont>Search[/b]</font></td></tr>";
    print "<tr><td>";
    print "<form action='mod.php?submit=1' method='post'>";
    print "<input type='text' name='searchterm' length='10'>";
    print "<input type='submit' name='submit' value='search'>";
    print "</form>";
    print "</td></tr></table></center>";


    print "</td></tr></table>";
  }



else if(isset($_POST['submit'])) //if user pressed search
{
 

    $numentries=$searchnumber;
    if(!isset($_GET['start']))
    {
      $start = 0;
    }
    else
    {
      $start=$_GET['start'];
    }
    $searchterm=$_POST['searchterm'];
    print "<center><table border='0' width='90%'>";
    print "<tr><td valign='top' width='75%' align='center'>


";
    $newselect="Select * FROM CMS_articles where title LIKE '%$searchterm%' OR shortdescription LIKE '%$searchterm' OR body LIKE '%$searchterm%' order by EntryID DESC LIMIT $start, $numentries";
    $newsquery=mysql_query($newselect) or die("dies");
    while($news=mysql_fetch_array($newsquery))
      {
        print "<table border='1' bordercolor=$borderc cellpadding='4' cellspacing='0' width=90%>";
        print "<tr bgcolor=$barcolor><td><center><font color=$barfont size='2'>$news[title] at $news[CMS_tsubmit] by $news[CMS_author] </font></center></td></tr>";
        print "<tr><td>$news[shortdescription]


<center>[url='mod.php?EntryID=$news[EntryID]']Click here to read more[/url]";
        print "</td></tr></table>


";
      }
    $order="SELECT * FROM CMS_articles where title LIKE '%$searchterm%' OR shortdescription LIKE '%$searchterm%' OR body LIKE '%$searchterm%'";
    $order2=mysql_query($order);
    $d=0;
    $f=0;
    $g=1;
    if(!isset($term))
    {
      $term=$look;
    }
   print "<font color='$fontcolor'>Page:</font> ";
   while($order3=mysql_fetch_array($order2))
   {
      if($f%$numentries==0)
   {

     $term=$searchterm;


      print "[url='mod.php?searchterm=$term&submit=1&start=$d']$g[/url] ";
      $g++;
    }
    $d=$d+1;
    $f++;


   }





    print "</td>";
    print "<td valign='top' width='25%'>


";
    print "<table border='1' cellpadding='4' cellspacing='0' bordercolor=$borderc>";
    print "<tr><td bgcolor=$barcolor>[b]<font color=$barfont>Highest rated Articles[/b]</font></td></tr>";
    print "<tr><td>";
    $rateselect="SELECT * from CMS_articles order by avgvotes DESC LIMIT 7";
    $rateselect2=mysql_query($rateselect) or die("it died");
    while($r=mysql_fetch_array($rateselect2))
      {
          $r[avgvotes] = number_format($r[avgvotes], 1, '.', '');
          print "[url='mod.php?EntryID=$r[EntryID]']$r[title][/url]($r[avgvotes])
";
      }
    print "</td></tr></table>


";
    print "<table border='1' cellpadding='4' cellspacing='0' bordercolor=$borderc>";
    print "<tr><td bgcolor=$barcolor>[b]<font color=$barfont>Most Read Articles[/b]</font></td></tr>";
    print "<tr><td>";
    $readselect="SELECT * from CMS_articles order by timesviewed DESC LIMIT 7";
    $readselect2=mysql_query($readselect) or die("it died");
    while ($r2=mysql_fetch_array($readselect2))
      {
         print "[url='mod.php?EntryID=$r2[EntryID]']$r2[title][/url]($r2[timesviewed])
";
      }
    print "</td></tr></table>


";
    print "<table border='1' cellpadding='4' cellspacing='0' bordercolor=$borderc>";
    print "<tr><td bgcolor=$barcolor>[b]<font color=$barfont>Search[/b]</font></td></tr>";
    print "<tr><td>";
    print "<form action='mod.php?submit=1' method='post'>";
    print "<input type='text' name='searchterm' length='10'>";
    print "<input type='submit' name='submit' value='search'>";
    print "</form>";
    print "</td></tr></table></center>";


    print "</td></tr></table>";
}  
 
else if(!isset($_POST['submit'])) //looking at root
  {


    $numentries=$entriesonpage;
    if(!isset($_GET['start']))
    {
      $start=0;
    }
    else
    {
      $start=$_GET['start'];
    }
    print "<center><table border='0' width='90%'>";
    print "<tr><td valign='top' width='75%' align='center'>


";
    $newselect="Select * FROM CMS_articles order by EntryID DESC LIMIT $start,$numentries";
    $newsquery=mysql_query($newselect) or die("dies");
    while($news=mysql_fetch_array($newsquery))
      {
        print "<table border='1' bordercolor=$borderc cellpadding='4' cellspacing='0' width=90%>";
        print "<tr bgcolor=$barcolor><td><center><font color=$barfont size='2'>$news[title] at $news[CMS_tsubmit] by $news[CMS_author] </font></center></td></tr>";
        print "<tr><td>$news[shortdescription]


<center>[url='mod.php?EntryID=$news[EntryID]']Click here to read more[/url]";
        print "</td></tr></table>


";
      }








$order="SELECT * from CMS_articles";
$order2=mysql_query($order);
$d=0;
$f=0;
$g=1;








print "<font color='#$fontcolor'>Page:</font> ";
while($order3=mysql_fetch_array($order2))
{
if($f%$numentries==0)
  {



    print "[url='mod.php?start=$d']$g[/url] ";
    $g++;
  }
$d=$d+1;
$f++;


}






    print "</td>";
    print "<td valign='top' width='25%'>


";
    print "<table border='1' cellpadding='4' cellspacing='0' bordercolor=$borderc>";
    print "<tr><td bgcolor=$barcolor>[b]<font color=$barfont>Highest rated Articles[/b]</font></td></tr>";
    print "<tr><td>";
    $rateselect="SELECT * from CMS_articles order by avgvotes DESC LIMIT 7";
    $rateselect2=mysql_query($rateselect) or die("it died");
    while($r=mysql_fetch_array($rateselect2))
      {
          $r[avgvotes] = number_format($r[avgvotes], 1, '.', '');
          print "[url='mod.php?EntryID=$r[EntryID]']$r[title][/url]($r[avgvotes])
";
      }
    print "</td></tr></table>


";
    print "<table border='1' cellpadding='4' cellspacing='0' bordercolor=$borderc>";
    print "<tr><td bgcolor=$barcolor>[b]<font color=$barfont>Most Read Articles[/b]</font></td></tr>";
    print "<tr><td>";
    $readselect="SELECT * from CMS_articles order by timesviewed DESC LIMIT 7";
    $readselect2=mysql_query($readselect) or die("it died");
    while ($r2=mysql_fetch_array($readselect2))
      {
         print "[url='mod.php?EntryID=$r2[EntryID]']$r2[title][/url]($r2[timesviewed])
";
      }
    print "</td></tr></table>


";
    print "<table border='1' cellpadding='4' cellspacing='0' bordercolor=$borderc>";
    print "<tr><td bgcolor=$barcolor>[b]<font color=$barfont>Search[/b]</font></td></tr>";
    print "<tr><td>";
    print "<form action='mod.php?submit=1' method='post'>";
    print "<input type='text' name='searchterm' length='10'>";
    print "<input type='submit' name='submit' value='search'>";
    print "</form>";
    print "</td></tr></table></center>";

    print "</td></tr></table>";
   }
  ?>

Alles anzeigen

nach dem man da auf Bearbeiten oder Löschen klickt kommt man zu der datei "modelete.php" ab hier passiert nichts mehr. Eigentlich sollte man dann auf die datei "edit.php" wenn man den Einträg editieren möchte aber soweit kommt man leider nicht.Deswegen spare ich mir jetz diesen Code auch noch einzufügen

modelete.php

Zitat

<?
include "connect.php";
if (isset($submit)) //if delete is pressed
{
$sql="Select * from CMS_articles WHERE title='$title'";
$sql2=mysql_query($sql);
$row=mysql_fetch_array($sql2);
if(!$row)
{
print "

<font color='red'>No such entry</font>";
}
else
{
$result = "DELETE FROM CMS_articles WHERE title='$title'";
mysql_query($result);
print "Entry Deleted, Back to control panel";
}
}

else if(isset($edit)) // if edit is pressed
{
$sql="Select * from CMS_articles WHERE title='$title'";
$sql2=mysql_query($sql);
$row=mysql_fetch_array($sql2);
if(!$row)
{
print "

<font color='red'>No such entry</font>";

}
else //if entry exists
{
print"<form action='edit.php' method='post'>";
print "<input type='hidden' name='id' value='$id'>";
print "Title: <input type='text' name='title' value='$title'>
";
print "Abstract:
<textarea rows='4' name='shortdescription' cols='25'>$shortdescription</textarea>

";
print "Body:
<textarea rows='15' name='body' cols='70'>$body</textarea>

";
print "<input type='submit' name='editnow' value='edit'>";

}
}

?>

Alles anzeigen

Ich hoffe mal ich überlade ich euch net ganz mit den ganzen Code und jmd hat weiß was helfen könnt.

Mfg Milcho

chris90night

Woher hast du denn das Skript, denn es sieht schon etwas veraltet aus ...

Edit: Sry, hast ja gesagt ...
Probier doch nochmal es downzuloaden und wenn es dann nicht klappt, gibt es noch genügend andere solche Skripts

Problem mit Newsscript

Tags

Benutzer online in diesem Thema