Two functions collision

Anon

I have one BIG
Problem 

Anyone knows how
to make this two functions (function GetCatPath and function Get) 
to work
totaly different. Problem is that the database in this functions are not defined 
so they work
the same which mixes in scripts.php directory links categories and subcategories 
Example:
I go to scripts.php and goto add script. Categories are displayed good from
first screen 
, but when
i start to brownse in categories, subcategories from links.php starts to appear 
instead subcategories
from scripts.php. 
I did everything
else and all is ok. In the scripts.php I called functions Get, 
Parent and Cat and in links.php GetCatPath, GetParents and ViewCat. 
There is no collision in tables or in scripts except this two functions (GetCatPath
and Get). 
I am messing around with this few days and I can`t find solution.
NOTE: I am using
newlinks not links.php from standard phpnuke distribution. 
This links are better because your subcategories can have more subcategories 
and so forever. 
 
What I need this for? I develop new and more user friendly download section. 
Why to have only categories in downloads without possibility of subcategories 
and users to add their own scripts, hacks, addons and later their visitors can
 
rate their works. 
 
I also added in this new downloads few more fields in tables. Price, Version, 
Platform, Download URL, Reviews, etc. 
I was inspired from hotscripts.com and I combining downloads and links all in
 
one. Help me now and I could continue finishing addon so you could later download 
it from <a href="http://www.thebix.com">http://thebix.com</a>. 

This functions
are in mainfile.php 
 
And the problem follows:
-----------------------------------------------------------------------------------------

/******************************************************/ 
/ weblinks functions / 
/***************************************************/ 
// Returns the complete path of the category $cid 
// $cid : Chosen category 
// $links : Boolean to choose is the categories are hyperlinked or not 
// $op : To choose the operation of the categories links (if $links is True) 

(look at this
function "here is the problem" and then go to "function Get"
at the start 
of
webscripts functions section)

function GetCatPath
($cid=0, $links=False, $op="viewlink&quot😉 
{ 
global $PHP_SELF;
 $trail = ""; 
$Path = Array(); 
GetParents($Path, $cid); 
if(!empty($Path)) { 
while ( list ( $key,$Cat ) = each ($Path)) { 
$cid = stripslashes($Cat["cid"]); 
$title = stripslashes($Cat["title"]); 
if ($links) { 
$trail = "&nbsp;/&nbsp;<A HREF=\"$PHP_SELF?op=$op&cid=$cid\">$title</A>$trail"; 
} else { 
$trail = "&nbsp;/&nbsp;$title$trail"; 
} 
} 
} 
if ($links) { 
$trail = "<A HREF=\"$PHP_SELF?op=$op&cid=0\">".translate("Main&quot😉."</A>$trail"; 
} else { 
$trail = translate("Main&quot😉.$trail; 
} 
return $trail; 
}
// Returns the
lists of the parents ids of a category 
// &$Path : Array containing the parent category ids 
// $cid : Chosen category 
(database is defined all is ok with this)
function GetParents
(&$Path, $cid=0) 
{ 
$Cat=Array(); 
if ((empty($cid)) or ($cid == 0)) { return False; } 
dbconnect(); 
$result = mysql_query("SELECT cid, parentid, title FROM links_categories
WHERE cid=$cid&quot😉; 
while ($Cat = mysql_fetch_array($result)) { 
$Count = count($Path); 
$Path[$Count] = $Cat; 
GetParents($Path, $Cat["parentid"]); 
} 
return true; 
}
// Displays the
of the subcategories of $cid on two levels 
// $cid : Chosen category 
// $op : To choose the operation of the categories links 
(database is defined all is ok with this) 
function ViewCat
($cid=0, $op="viewlink&quot😉 { 
global $PHP_SELF;
 echo " 
<table border=0 cellspacing=10 cellpadding=0> 
<tr> 
<basefont size=1> 
 
";
 dbconnect(); 
$result=mysql_query("select cid, title from links_categories where
parentid=$cid order by title&quot😉; 
$count = 0;
 while(list($cid,
$title) = mysql_fetch_row($result)) { 
$result3=mysql_query("select from links_links where cid=$cid&quot😉; 
$compteur = mysql_num_rows($result3); 
echo "<td><a href=$PHP_SELF?op=$op&cid=$cid>$title</a>&nbsp;($compteur) "; 
$result2 = mysql_query("select cid, title from links_categories
where parentid=$cid order by title limit 0,3&quot😉; 
$space =0; 
while(list($cid, $stitle) = mysql_fetch_row($result2)) { 
if ($space>0) { 
echo ",&nbsp;"; 
} 
echo "<a href=$PHP_SELF?op=$op&cid=$cid"; 
echo ">$stitle</a>"; 
$space++; 
} 
if ($count<1) { echo "</td><td>&nbsp;&nbsp;&nbsp;</td>";
} 
$count++; 
if ($count==3) { 
echo "</td></tr><tr>"; 
$count = 0; 
} 
} 
$result=mysql_query("select from links_links&quot😉; 
$numrows = mysql_num_rows($result); 
echo "</TD></TR></TABLE> 
</TD></TR></TABLE></TD></TR></TABLE> 
</basefont> 
"; 
}

 
/***************************************************/ 
/ webscripts functions / 
/*****************************************************/ 
// Returns the complete path of the category $cid 
// $cid : Chosen category 
// $links : Boolean to choose is the categories are hyperlinked or not 
// $op : To choose the operation of the categories links (if $links is True) 
(this is new function I make but the database is not defined like in GetCatPath 
from above)
 function Get($cid=0,
$links=False, $op="viewlink&quot😉 
{ 
global $PHP_SELF; 
 $trail = ""; 
$Path = Array(); 
GetParents($Path, $cid); 
if(!empty($Path)) { 
while ( list ( $key,$Cat ) = each ($Path)) { 
$cid = stripslashes($Cat["cid"]); 
$title = stripslashes($Cat["title"]); 
if ($links) { 
$trail = "&nbsp;/&nbsp;<A HREF=\"$PHP_SELF?op=$op&cid=$cid\">$title</A>$trail"; 
} else { 
$trail = "&nbsp;/&nbsp;$title$trail"; 
} 
} 
} 
if ($links) { 
$trail = "<A HREF=\"$PHP_SELF?op=$op&cid=0\">".translate("Main&quot😉."</A>$trail"; 
} else { 
$trail = translate("Main&quot😉.$trail; 
} 
return $trail; 
}
// Returns the
lists of the parents ids of a category 
// &$Path : Array containing the parent category ids 
// $cid : Chosen category 
(this is new function I make and database is defined)
function Parents
(&$Path, $cid=0) 
{ 
$Cat=Array(); 
if ((empty($cid)) or ($cid == 0)) { return False; } 
dbconnect(); 
$result = mysql_query("SELECT cid, parentid, title FROM downloads_categories
WHERE cid=$cid&quot😉; 
while ($Cat = mysql_fetch_array($result)) { 
$Count = count($Path); 
$Path[$Count] = $Cat; 
GetParents($Path, $Cat["parentid"]); 
} 
return true; 
}
// Displays the
of the subcategories of $cid on two levels 
// $cid : Chosen category 
// $op : To choose the operation of the categories links 
(this is new function I make and database is defined)
function Cat($cid=0,
$op="viewlink&quot😉 { 
global $PHP_SELF;
 echo " 
<table border=0 cellspacing=10 cellpadding=0> 
<tr> 
<basefont size=1> 
 
";
 dbconnect(); 
$result=mysql_query("select cid, title from downloads_categories
where parentid=$cid order by title&quot😉; 
$count = 0;
 while(list($cid,
$title) = mysql_fetch_row($result)) { 
$result3=mysql_query("select from downloads_links where cid=$cid&quot😉; 
$compteur = mysql_num_rows($result3); 
echo "<td><a href=$PHP_SELF?op=$op&cid=$cid>$title</a>&nbsp;($compteur) "; 
$result2 = mysql_query("select cid, title from downloads_categories
where parentid=$cid order by title limit 0,3&quot😉; 
$space =0; 
while(list($cid, $stitle) = mysql_fetch_row($result2)) { 
if ($space>0) { 
echo ",&nbsp;"; 
} 
echo "<a href=$PHP_SELF?op=$op&cid=$cid"; 
echo ">$stitle</a>"; 
$space++; 
} 
if ($count<1) { echo "</td><td>&nbsp;&nbsp;&nbsp;</td>";
} 
$count++; 
if ($count==3) { 
echo "</td></tr><tr>"; 
$count = 0; 
} 
} 
$result=mysql_query("select * from downloads_links&quot😉; 
$numrows = mysql_num_rows($result); 
echo "</TD></TR></TABLE> 
</TD></TR></TABLE></TD></TR></TABLE> 
</basefont> 
"; 
} 

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

I hope you will
find solution to make this two functions (GetCatPath and Get) work differently
so 
brownsing in sub categories
in links and scripts could be normal. 
 
Thanks in advance 
Happy coding
 
Ivan Strigo