Search the Community

hello, Could any body share the script for find the duplicate and delete them.

I am getting huge errors in error log of my website. Like this [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 58 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_close() expects parameter 1 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 138 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in /home/ticket4t/public_html/management/include/connect.php on line 87 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in /home/ticket4t/public_html/management/include/connect.php on line 34 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 42 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 58 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_close() expects parameter 1 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 138 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in /home/ticket4t/public_html/management/include/connect.php on line 87 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in /home/ticket4t/public_html/management/include/connect.php on line 34 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 42 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 58 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_close() expects parameter 1 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 138 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in /home/ticket4t/public_html/management/include/connect.php on line 87 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in /home/ticket4t/public_html/management/include/connect.php on line 34 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 42 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 58 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_close() expects parameter 1 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 138 [15-Mar-2014 12:34:34 America/New_York] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in /home/ticket4t/public_html/management/include/connect.php on line 87 [15-Mar-2014 12:34:38 America/New_York] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in /home/ticket4t/public_html/management/include/connect.php on line 34 [15-Mar-2014 12:34:38 America/New_York] PHP Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 42 [15-Mar-2014 12:34:38 America/New_York] PHP Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 58 [15-Mar-2014 12:34:38 America/New_York] PHP Warning: mysql_close() expects parameter 1 to be resource, boolean given in /home/ticket4t/public_html/management/include/connect.php on line 138 [15-Mar-2014 12:34:38 America/New_York] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in /home/ticket4t/public_html/management/include/connect.php on line 87 given below is the code of connect.php Please help me to solve this problem. ------------------------------------------------------------------------------------------ <?php class dbcore { var $dblink, $dbhost, $dbuser, $dbpass, $dbname, $link, $Errno, $Error; function dbcore() { global $db_org; $this->getdblinks($db_org); } function getdblinks($pm_dbvars) { $this->dbhost = $pm_dbvars["dbhost"]; $this->dbuser = $pm_dbvars["dbuser"]; $this->dbpass = $pm_dbvars["dbpass"]; $this->dbname = $pm_dbvars["dbname"]; } function setdblinks($pm_dblink, $pm_dbhost, $pm_dbuser, $pm_dbpass, $pm_dbname) { $this->dbhost = $pm_dbhost; $this->dbuser = $pm_dbuser; $this->dbpass = $pm_dbpass; $this->dbname = $pm_dbname; } function siri_open() { global $wwwroot; $t_link = mysql_connect($this->dbhost, $this->dbuser, $this->dbpass); if(!$t_link) { // header("Location: ".$wwwroot."page-error"); $this->Errno = mysql_errno(); //$this->Error = mysql_error(); $this->error("Unable to Connect the Server".$this->dbhost); } $bool = mysql_select_db($this->dbname, $t_link); if(!$bool) { // header("Location: ".$wwwroot."page-error"); $this->Errno = mysql_errno(); //$this->Error = mysqli_error(); $this->error("Database Not Found :".$this->dbname); } return $t_link; break; } function siri_query($my_qry) { $this->link = $this->siri_open(); $qid= mysql_query ($my_qry, $this->link); $this->siri_close($this->link); if(!$qid){ $this->Errno = mysql_error(); $this->Error = mysql_error(); $this->error("Problem In Executing the Query:" . $my_qry); } return $qid; } function siri_count($my_qry) { // returns the count value. $this->link = $this->siri_open(); $qid = mysqli_query ($this->link, $my_qry); $this->siri_close($this->link); if(!$qid){ $this->Errno = mysqli_errno(); $this->Error = mysqli_error(); $this->error("Problem In Executing the Query:" . $my_qry); } $count = $this->siri_fetch_array($qid); return $count[0]; } function siri_fetch_array($qid) { return mysql_fetch_array($qid); } function siri_fetch_accos($qid) { return mysqli_fetch_assoc($qid); } function siri_real_escape_string($qid) { $this->link = $this->siri_open(); return mysqli_real_escape_string($qid); } function siri_fetch_row($qid) { return mysqli_fetch_row($qid); } function siri_fetch_object($qid) { return @mysqli_fetch_object($qid); } function siri_num_rows($qid) { $quy = mysql_num_rows($qid); return $quy; } function siri_affected_rows() { // for insert, update, delete reasons. return mysqli_affected_rows(); } function siri_insert_id() { return mysqli_insert_id($link); } function siri_insert_id1() { return mysqli_insert_id(); } function siri_free_result($qid) { mysqli_free_result($qid); } function siri_num_fields($qid) { return mysqli_num_fields($qid); } function siri_close($link) { mysql_close($link); } function error($msg) { printf("<b>Error : </b> %s<br>\n", $msg); printf("<b>MySQL Error</b>: %s (%s)<br>\n", $this->Errno, $this->Error); } function siri_fquery($qry,$val) { $qid = $this->siri_query($qry); while($re = $this->siri_fetch_array($qid)) { print"<option value=$re[0]"; ?> <?= ($val==$re[0])? "selected": "";?> <? print ">$re[1]</option>\n"; } } function siri_sinvalue($qry) { $qid = $this->siri_query($qry); $rs = $this->siri_fetch_array($qid); return $rs[1]; } function siri_drawNavigation($start,$total,$link) { if(($start%100)==0) { $j=$start/10+1; } else if($start/100>=1){ $j=intval(($start/100))*10+1; } else { $j=1; } if((intval($start/100))>1) { $temp=intval(($start/100-1))*10*10; } print "<div align=center>"; global $len; $check=$total%$len; if($check >=1 ) $lim=intval(($total/$len))+1; else $lim=intval($total/$len); print "<table cellpading=0 cellspacing=0 align=center width=100% nowrap><tr><td width=100%><table width=100% align=center ><tr><td width=100%>"; $en = $start +$len; // if($start==0 && $total>0){$start1=1;} else {$start1 = $start+1;} if($start==0){ if($total>0){ $start1=1; } else { $start1=0; } } else { $start1=$start+1; } if($en>$total) $en = $total; print "<font face=Verdana, Arial, Helvetica, sans-serif size=0 class='links1'>Showing $start1 - $en of $total <a href='$link&start=0'>Go to First Record</a> </font></td><td><!--<img src='../img/prev_button.gif' align=center>--><font face=Verdana, Arial, Helvetica, sans-serif size=1 class='links1'>" ; if($en>$len) { $en1=$start-$len; print "<a href='$link&start=$en1' class='links1'>Previous</a>" ; } else print "Previous"; print "</font>"; $temp1=1; print " <font face=Verdana, Arial, Helvetica, sans-serif size=1 class='links1'>" ; if($en<$total){ $en2=$start+$len; print "<a href='$link&start=$en2' class='links1'>Next</a>" ; } else print "Next"; print "</font></td></tr></table></td></tr></table></div>"; } function shrstr($string, $num="50") { // Check string length if grater then $num if (strlen($string) > $num) { // Shorten the string with ... $string = substr( $string, 0, $num-2); $string .= "..."; return $string; } else { // If $num is less then return $string; } } //////////////////////////////// function siri_insert_query($my_qry) { $this->link = $this->siri_open(); $qid = mysqli_query ($this->link, $my_qry); $lid = mysqli_insert_id($this->link); $this->siri_close($this->link); if(!$qid){ $this->Errno = mysql_errno(); $this->Error = mysql_error(); $this->error("Problem In Executing the Query:" . $my_qry); } return $lid; } }// end of the class ?>