$contents_serverclass .= "\$" . "this->conapi = mysql_connect(\"" . $glb_dbhost . "\",\"" . $glb_dbuser . "\",\"" . $glb_dbpass . "\") or die(mysql_error());\r\n"; $contents_serverclass .= "mysql_select_db(\"" . $glb_dbname . "\",\$" . "this->conapi) or die(mysql_error());\r\n}\r\n}\r\n?>"; $fp = fopen($serverclass, "a+"); fwrite($fp, $contents_serverclass); fclose($fp); // FCK editor $handle = fopen($fckeditor, "rb"); $contents = fread($handle, filesize($fckeditor)); fclose($handle); $contents = str_replace('FCK_IMAGE_UPLOAD_DIRECTORY', $fckeditor_path . 'fckeditorimages/', $contents); $fp = fopen($fckeditor, 'w'); fwrite($fp, $contents); fclose($fp); //------------------------UPDATE THE DB---------------------------------// $sqlquery = @fread(@fopen($schemafile, 'r'), @filesize($schemafile)); $sqlquery = ServerConfig::splitsqlfile($sqlquery, ";"); for ($i = 0; $i < sizeof($sqlquery); $i++) { mysql_query($sqlquery[$i], $connection); } /************************* Code for all Ticket Entry to Statics TABLE **************/ $total_ticket_sql = "select * from sptbl_tickets"; $total_ticket_total = mysql_query($total_ticket_sql); while ($row = mysql_fetch_array($total_ticket_total)) { $ticket_ids = $row['nTicketId']; $postDate = $row['dPostDate']; $checkSql = "select * from sptbl_ticket_statistics where ticket_id = '" . $ticket_ids . "'"; $checkTicket = mysql_query($checkSql); if (mysql_num_rows($checkTicket) == 0) { $total_unattempted_sql = "select sptb.*,sptbr.* from sptbl_tickets sptb INNER JOIN sptbl_replies sptbr ON sptbr.nTicketId = sptb.nTicketId where sptb.nTicketId = '" . $ticket_ids . "' GROUP BY sptbr.nTicketId"; $total_unattempted_time = mysql_query($total_unattempted_sql); $total_revolved_sql = "select * from (select sptb.*,sptbr.dDate,sptbr.nTicketId as ntick from sptbl_tickets sptb INNER JOIN sptbl_replies sptbr ON sptbr.nTicketId = sptb.nTicketId where sptb.nTicketId = '" . $ticket_ids . "' AND sptb.vStatus = 'closed' ORDER BY sptbr.dDate ASC) as temp GROUP BY temp.ntick";