$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";
