Help please

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Python
Forum Newbie
Posts: 1
Joined: Sun May 23, 2004 4:00 pm

Help please

Post by Python »

Well because the question os too long to type it out again im not gonna so see it at http://www.devdreams.com/viewtopic.php?p=1905#1905

then come back here and reply.

so what can i do?
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

Are you sure you have a database with all the correct information? and just so everyone can see it easier here:
Im modifying a script so that I can set up the scripts on this site into manageable categories.

I have downloaded a freeware script. Now originally the main page of this script(where the categories are shown) is named index.php

I want to move this file and all the others into the main directory but I cant because there is already a file called index.php

Id like to rename it to be scripts.php

Here is the code for the category page which I want to rename to scripts.php

Code: Select all

<?
error_reporting(E_ALL & ~E_NOTICE);
ini_set("session.use_trans_sid",false);
session_register("sid");

if (is_file("install.php") && !is_file("config.php")) {include "install.php";die();}

if (version_compare(phpversion(), "4.2.0", ">=")) $ob=TRUE; else $ob=FALSE;

if ($ob) {ob_start();ob_implicit_flush(0);}
require "config.php";
require "lang/".$LANGFILE;
if ($ob) {ob_clean();ob_implicit_flush(1);}

if (is_file("install.php")) die($LANG["remove_install"]);

$o=$_GET["o"];
$c=$_GET["c"];
$defaultorder=intval($cat["defaultorder"]);
if ($defaultorder<0 || $defaultorder>3) $defaultorder=0;
if (($o<0 && $o>3) || !isset($o)) $o=$defaultorder;

function ShowParts($cid) {
   GLOBAL $cat,$TMPL,$db;

   $r=mysql_query("SELECT name,cid,count FROM ".$db["prefix"]."cat WHERE parent='$cid' ORDER BY name") or die(mysql_error());
   $num=0;
   $cnt=mysql_num_rows($r);
   if ($cnt==0) return;
   print $TMPL["partstop"];
   for ($i=0;$i<$cnt;$i++) {
      $num++;
      if ($num==1) print $TMPL["partsdelimtop"];

      $template=$TMPL["partsbit"];
      $template=str_replace("%CTITLE",mysql_result($r,$i,0),$template);
      $template=str_replace("%CID",mysql_result($r,$i,1),$template);
      $template=str_replace("%CCOUNT",mysql_result($r,$i,2),$template);
      print $template;
      if ($num==$cat["rows"]) {print $TMPL["partsdelimbottom"];$num=0;}
      }
   print $TMPL["partsbottom"];
   }

function ShowCat($cid,$best=0) {
   GLOBAL $start,$pp,$o,$sid,$LANG,$TMPL,$db;

   if ($best==1) $bestsql="AND moder_vote=10"; else $bestsql="AND moder_vote!=10";

   if ($o==0) $order="ORDER BY gin DESC,gout DESC";
   if ($o==1) $order="ORDER BY title";
   if ($o==2) $order="ORDER BY moder_vote DESC, gout DESC";
   if ($o==3) $order="ORDER BY insert_date DESC";


   if ($cid!=0) $Q="SELECT lid,url,title,description,gin,gout,moder_vote,resfield1,resfield2,resfield3 FROM ".$db["prefix"]."main WHERE type=1 $bestsql AND cat1=$cid $order LIMIT $start,$pp;";
   else $Q="SELECT lid,url,title,description,gin,gout,moder_vote,resfield1,resfield2,resfield3 FROM ".$db["prefix"]."main WHERE type=1 $bestsql $order LIMIT $start,$pp;";
   $r=mysql_query($Q) or die(mysql_error());
   $cnt=mysql_num_rows($r);
   if ($cnt==0 && $best!=1) print $LANG["linksnotfound"];

   while ($ar=mysql_fetch_array($r)) {
      $admin="";
      if (isset($sid)) {
         $admin.="<font color=gray size=-3> [<a href=admin/edit.php?lid=".$ar["lid"]."&type=255 class=slink>".$LANG["edit"]."</a>]";
         $admin.="[<a href=admin/moveto.php?lid=".$ar["lid"]."&type=1&to=2 class=slink>".$LANG["delete"]."</a>] [";
         for ($j=1;$j<11;$j++) {
            if ($j==$ar["moder_vote"]) $admin.="<B>".$j."</B> ";
            else $admin.="<a href=admin/vote.php?lid=".$ar["lid"]."&vote=$j&type=255 class=slink>".$j."</a> ";
            }
         $admin.="]</font>";
         }

      $template=($best==1)?$TMPL["bestlinksbit"]:$TMPL["linksbit"];
      $template=str_replace("%ID",$ar["lid"],$template);
      $template=str_replace("%TITLE",$ar["title"],$template);
      $template=str_replace("%GIN",$ar["gin"],$template);
      $template=str_replace("%GOUT",$ar["gout"],$template);
      $template=str_replace("%MODERVOTE",$ar["moder_vote"],$template);
      $template=str_replace("%DESC",$ar["description"],$template);
      $template=str_replace("%URL",$ar["url"],$template);
      $template=str_replace("%BEST","<img src=./cat/star.gif width=15 height=16 hspace=3>",$template);
      $template=str_replace("%BROKENTEXT",$LANG["broken"],$template);
      $template=str_replace("%RESFIELD1",$ar["resfield1"],$template);
      $template=str_replace("%RESFIELD2",$ar["resfield2"],$template);
      $template=str_replace("%RESFIELD3",$ar["resfield3"],$template);
      $template=str_replace("%ADMINIFACE",$admin,$template);
      print $template;
      }
   if ($best!=1) {
      if ($cid!=0) return(mysql_result(mysql_query("SELECT count(*) FROM ".$db["prefix"]."main WHERE type=1 $bestsql AND cat1=$cid;"),0,0));
      else return(mysql_result(mysql_query("SELECT count(*) FROM ".$db["prefix"]."main WHERE type=1 $bestsql;"),0,0));
      }
   }

$c=intval($c);
$start=intval($start);
$pp=10;
   $cid=$c;$l="";
   do {
      $r=mysql_query("SELECT parent,name,cid FROM ".$db["prefix"]."cat WHERE cid='$cid';") or die(mysql_error());
      if (mysql_num_rows($r)==1) {
         $id=mysql_result($r,0,2);
         $title=mysql_result($r,0,1);
         if ($cid==$c)
            $l=mysql_result($r,0,1).$l;
         else
            $l="<a class=bold href=./?c=".$id.">".$title."</a> &raquo; ".$l;
         $cid=mysql_result($r,0,0);
         }
      else $cid=0;
      } while ($cid!=0);
   $r=mysql_query("SELECT name FROM ".$db["prefix"]."cat WHERE cid='$c';") or die(mysql_error());
   if (mysql_num_rows($r)!=0) $title=mysql_result($r,0,0)." / ".$CATNAME;
   else $title=$CATNAME;

   include "_top.php";

   $template=$TMPL["bmenu"];
   $template=str_replace("%MODERATORSTEXT",$LANG["moderators"],$template);
   $template=str_replace("%ADDLINKTEXT",$LANG["addlink"],$template);
   $template=str_replace("%MAINTEXT",$LANG["main"],$template);
   print $template;

   $template=$TMPL["brokenscript"];
   $template=str_replace("%YESTEXT",$LANG["yes"],$template);
   $template=str_replace("%NOTEXT",$LANG["no"],$template);
   $template=str_replace("%BROKENSURETEXT",$LANG["brokensure"],$template);
   print $template;

   $sform=$TMPL["searchform"];
   $sform=str_replace("%SEARCHTEXT",$LANG["search"],$sform);
   $sform=str_replace("%QUERYTEXT",$q,$sform);
   print $sform;
   
   $template=$TMPL["catname"];
   $template=str_replace("%MAINTEXT",$CATNAME,$template);
   $template=str_replace("%OTHERTEXT",$l,$template);
   print $template;

   ShowParts($c);

   if ($o==0) $sortbypop="<B>".$LANG["popuarity"]."</B>"; else $sortbypop="<a href=./?o=0&c=$c>".$LANG["popuarity"]."</a>";
   if ($o==1) $sortbytitle="<B>".$LANG["title"]."</B>"; else $sortbytitle="<a href=./?o=1&c=$c>".$LANG["title"]."</a>";
   if ($o==2) $sortbymoder="<B>".$LANG["modervote"]."</B>"; else $sortbymoder="<a href=./?o=2&c=$c>".$LANG["modervote"]."</a>";
   if ($o==3) $sortbyin="<B>".$LANG["sortbyin"]."</B>"; else $sortbyin="<a href=./?o=3&c=$c>".$LANG["sortbyin"]."</a>";

   $template=$TMPL["sortby"];
   $template=str_replace("%SORTBYPOP",$sortbypop,$template);
   $template=str_replace("%SORTBYTITLE",$sortbytitle,$template);
   $template=str_replace("%SORTBYMODER",$sortbymoder,$template);
   $template=str_replace("%SORTBYIN",$sortbyin,$template);
   $template=str_replace("%SORTBYTEXT",$LANG["sortby"],$template);
   print $template;


   if (intval($c)==0 && $cat["shownew"]==1) {
      $newlinkstop=$TMPL["newlinkstop"];
      $newlinkstop=str_replace("%NEWLINKSTEXT",$LANG["newlinks"],$newlinkstop);
      print $newlinkstop;
      $r=mysql_query("SELECT lid,title,description,resfield1,resfield2,resfield3 FROM ".$db["prefix"]."main WHERE type=1 ORDER by lid DESC LIMIT ".$cat["shownewcount"].";");
      while ($ar=mysql_fetch_array($r)) {
         if (strlen($ar["description"])>75) $ar["description75"]=substr($ar["description"],0,75)."..."; else $ar["description75"]=$ar["description"];

         $template=$TMPL["newlinkstbit"];
         $template=str_replace("%ID",$ar["lid"],$template);
         $template=str_replace("%TITLE",$ar["title"],$template);
         $template=str_replace("%GIN",$ar["gin"],$template);
         $template=str_replace("%GOUT",$ar["gout"],$template);
         $template=str_replace("%MODERVOTE",$ar["moder_vote"],$template);
         $template=str_replace("%DESC75",$ar["description75"],$template);
         $template=str_replace("%DESC",$ar["description"],$template);
         $template=str_replace("%URL",$ar["url"],$template);
         $template=str_replace("%RESFIELD1",$ar["resfield1"],$template);
         $template=str_replace("%RESFIELD2",$ar["resfield2"],$template);
         $template=str_replace("%RESFIELD3",$ar["resfield3"],$template);
         print $template;
         }
      print $TMPL["newlinkstbottom"];
      }

   if ($cat["linksatmain"]==1 || $c!=0) {
      print $TMPL["linkstop"];
      ShowCat($c,1);
      print str_replace("%NUM",(1+$start),$TMPL["linksmiddle"]);
      $total=ShowCat($c);
      print $TMPL["linksbottom"];
      print "<P>".$LANG["linkcount"].": <B>$total</B></P>";
      }

if ($total>$pp) {
   print "<center>";
   if ($start!=0) print "<a href=./?c=$c&o=$o&start=0><<</a> | ";
   else print "<< | ";
   $sstart=$start-60; if ($sstart<0) $sstart=0;
   $send=$start+60;if ($send>$total) $send=$total;
   for ($i=$sstart;$i<$send;$i+=$pp) {
      if ($start==$i)
         print "<b>".($i+1)."</b>";
      else
         print "<a href=./?c=$c&o=$o&start=$i>".($i+1)."</a>";
      print " | ";
      }
   if ($start==$i-$pp)
      print ">>";
   else
      print "<a href=./?c=$c&o=$o&start=".($total-$pp).">>></a>";
   print "</center>";
   }


$template=$TMPL["bmenu"];
$template=str_replace("%MODERATORSTEXT",$LANG["moderators"],$template);
$template=str_replace("%ADDLINKTEXT",$LANG["addlink"],$template);
$template=str_replace("%MAINTEXT",$LANG["main"],$template);
print $template;

include "_bottom.php";
?>
No go to http://www.devdreams.com/scripts/scripts.php

Thats where the renamed version is just for testing. But when you click on a category it tries to load
Code:
/scripts/?c=3
(or whatever number) and of course cant find it because that folder has no index. So what in the above code can I change so that it questions the scripts.php fileinstead of index.php

Please only reply if you are able to help.

Thanks
Do yow know how to copy and paste?
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

hhmm i just looked at the page and everything looks fine to me.
Post Reply