help with "modxLinkList.php"

#more code above

$tblsc = $dbase.".".$table_prefix."site_content";
    $tbldg = $dbase.".".$table_prefix."document_groups";

    // modify field names to use sc. table reference
    $fields = 'sc.'.implode(',sc.',preg_replace("/^\s/i","",explode(',',$fields)));
    $sort = 'sc.'.implode(',sc.',preg_replace("/^\s/i","",explode(',',$sort)));

	// Connecting, selecting database
	$link = mysql_connect($database_server, $database_user, $database_password) or die('Could not connect: ' . mysql_error());
	$dbase = str_replace('`', '', $dbase);
	mysql_select_db($dbase) or die('Could not select database');

    $sql = "SELECT DISTINCT $fields FROM $tblsc sc
      LEFT JOIN $tbldg dg on dg.document = sc.id
      WHERE sc.published=1 AND sc.deleted=0
      ORDER BY $sort $dir;";

#More code below

			// get document groups for current user
			if ($docgrp= $modx->getUserDocGroups())
			$docgrp= implode(",", $docgrp);
			$access= ($modx->isFrontend() ? "sc.privateweb=0" : "1='" . $_SESSION['mgrRole'] . "' OR sc.privatemgr=0") .
			(!$docgrp ? "" : " OR dg.document_group IN ($docgrp)");

	
		$sql= "SELECT DISTINCT $fields FROM $tblsc sc
		LEFT JOIN $tbldg dg on dg.document = sc.id
		WHERE sc.published=1 AND sc.deleted=1
		AND ($access) GROUP BY sc.id ORDER BY $sort $dir;";

 require_once '../../../manager/includes/protect.inc.php'; 
 include_once ("../../../manager/includes/config.inc.php");
 include_once(MODX_BASE_PATH."manager/includes/document.parser.class.inc.php");
 $modx = new DocumentParser;

<?php
require_once '../../../manager/includes/protect.inc.php';
include_once ("../../../manager/includes/config.inc.php");
include_once(MODX_BASE_PATH."manager/includes/document.parser.class.inc.php");
$modx = new DocumentParser;
#include_once "../../../manager/includes/config.inc.php";


$allpages = getAllPages();
foreach($allpages as $page){
    $caption = ($page['pagetitle'])?htmlspecialchars($page['pagetitle'],ENT_QUOTES):htmlspecialchars($page['menutitle'],ENT_QUOTES);
	$list .=($list!='')?",\n":"\n";
	$list.= "[\"".$caption." (".$page['id'].")"."\", \"[\"+\"~".$page['id']."~\"+\"]\"]";
}   

$output = "var tinyMCELinkList = new Array(\n". $list .");";

echo $output;



 function getAllPages($id=0, $sort='menuindex', $dir='ASC', $fields='pagetitle, id, menutitle, editedby') {
    global $database_type;
    global $database_server;
    global $database_user;
    global $database_password;    
	global $dbase;
	global $table_prefix;



    $tblsc = $dbase.".".$table_prefix."site_content";
    $tbldg = $dbase.".".$table_prefix."document_groups";

    // modify field names to use sc. table reference
    $fields = 'sc.'.implode(',sc.',preg_replace("/^\s/i","",explode(',',$fields)));
    $sort = 'sc.'.implode(',sc.',preg_replace("/^\s/i","",explode(',',$sort)));

	// Connecting, selecting database
	$link = mysql_connect($database_server, $database_user, $database_password) or die('Could not connect: ' . mysql_error());
	$dbase = str_replace('`', '', $dbase);
	mysql_select_db($dbase) or die('Could not select database');

 // get document groups for current user
			if ($docgrp= $modx->getUserDocGroups())
			$docgrp= implode(",", $docgrp);
			$access= ($modx->isFrontend() ? "sc.privateweb=0" : "1='" . $_SESSION['mgrRole'] . "' OR sc.privatemgr=0") .
			(!$docgrp ? "" : " OR dg.document_group IN ($docgrp)");

	
		$sql= "SELECT DISTINCT $fields FROM $tblsc sc
		LEFT JOIN $tbldg dg on dg.document = sc.id
		WHERE sc.published=1 AND sc.deleted=1
		AND ($access) GROUP BY sc.id ORDER BY $sort $dir;";


/*
    $sql = "SELECT DISTINCT $fields FROM $tblsc sc
      LEFT JOIN $tbldg dg on dg.document = sc.id
      WHERE sc.published=1 AND sc.deleted=0
      ORDER BY $sort $dir;";
 */
    $result = mysql_query($sql) or die('Query failed: ' . mysql_error());
    $resourceArray = array();
    for($i=0;$i<@mysql_num_rows($result);$i++)  {
      array_push($resourceArray,mysql_fetch_assoc($result));
    }
	// Free resultset
	mysql_free_result($result);
	
	// Closing connection
	mysql_close($link);
	
	sort($resourceArray);

    return $resourceArray;
}
?>

function getAllPages($id=0, $sort='menuindex', $dir='ASC', $fields='pagetitle, id, menutitle, editedby') {
    global $modx;
    global $database_type;
    global $database_server;
    global $database_user;
    global $database_password;    
    global $dbase;
    global $table_prefix;

...

  $sql = "SELECT DISTINCT $fields FROM $tblsc sc
      LEFT JOIN $tbldg dg on dg.document = sc.id
      WHERE sc.published=1 AND sc.deleted=0
      ORDER BY $sort $dir;";

  $sql = "SELECT DISTINCT $fields FROM $tblsc sc
      LEFT JOIN $tbldg dg on dg.document = sc.id
      WHERE sc.published=1 AND sc.deleted=0 AND sc.editedby = 2
      ORDER BY $sort $dir;";

 
$usid = $modx->getLoginUserID( );

 $sql = "SELECT DISTINCT $fields FROM $tblsc sc
      LEFT JOIN $tbldg dg on dg.document = sc.id
      WHERE sc.published=1 AND sc.deleted=0 AND sc.editedby = $usid
      ORDER BY $sort $dir;";