function StoreFile($_browserId, $_partner, $_fullname)
{
$filename = namebase($_FILES['userfile']['name']);
if (!isValidUploadFile($filename)) {
return false;
}
$fileid = md5($filename . $this->UserId . $_browserId);
$fileurid = EX_FILE_UPLOAD_REQUEST . "_" . $fileid;
$filemask = $this->UserId . "_" . $fileid;
$request = new FileUploadRequest($fileurid, $_partner);
$request->Load();
if ($request->Permission == PERMISSION_FULL) {
if (move_uploaded_file($_FILES["userfile"]["tmp_name"], PATH_UPLOADS . $request->FileMask)) {
createFileBaseFolders($_partner, false);
processResource($_partner, $this->UserId, $_fullname, 0, $_fullname, 0, 5, 3);
processResource($_partner, $fileid, $filemask, 4, $_FILES["userfile"]["name"], 0, $this->UserId, 4, $_FILES["userfile"]["size"]);
$request->Download = true;
$request->Save();
return true;
} else {
$request->Error = true;
$request->Save();
}
}
return false;
}
function receiveFile($id = FILE_ACTION_NONE)
{
global $RESPONSE, $INTERNAL;
if (isset($_POST[POST_INTERN_FILE_TYPE]) && $_POST[POST_INTERN_FILE_TYPE] == FILE_TYPE_USERFILE) {
$fid = md5($_FILES["file"]["name"] . CALLER_SYSTEM_ID . time());
$filemask = CALLER_SYSTEM_ID . "_" . $fid;
if (empty($_SERVER["HTTP_QRD_PARENT_ID"])) {
createFileBaseFolders(CALLER_SYSTEM_ID, true);
processResource(CALLER_SYSTEM_ID, CALLER_SYSTEM_ID, $INTERNAL[CALLER_SYSTEM_ID]->Fullname, 0, $INTERNAL[CALLER_SYSTEM_ID]->Fullname, 0, 4, 3);
$parentId = CALLER_SYSTEM_ID;
$rank = 4;
} else {
$parentId = $_SERVER["HTTP_QRD_PARENT_ID"];
$rank = $_SERVER["HTTP_QRD_RANK"];
}
processResource(CALLER_SYSTEM_ID, $fid, $filemask, 3, $_FILES["file"]["name"], 0, $parentId, $rank, $_FILES["file"]["size"]);
if (@move_uploaded_file($_FILES["file"]["tmp_name"], PATH_UPLOADS . $filemask)) {
$id = FILE_ACTION_SUCCEEDED;
} else {
$id = FILE_ACTION_ERROR;
}
}
$RESPONSE->SetStandardResponse($id, base64_encode($fid));
}
function appendResources($xml = "")
{
global $RESPONSE;
$rids = explode(POST_ACTION_VALUE_SPLITTER, $_POST[POST_INTERN_PROCESS_RESOURCES . "_va"]);
$html = explode(POST_ACTION_VALUE_SPLITTER, slashesStrip($_POST[POST_INTERN_PROCESS_RESOURCES . "_vb"]));
$type = explode(POST_ACTION_VALUE_SPLITTER, $_POST[POST_INTERN_PROCESS_RESOURCES . "_vc"]);
$title = explode(POST_ACTION_VALUE_SPLITTER, slashesStrip($_POST[POST_INTERN_PROCESS_RESOURCES . "_vd"]));
$disc = explode(POST_ACTION_VALUE_SPLITTER, $_POST[POST_INTERN_PROCESS_RESOURCES . "_ve"]);
$parent = explode(POST_ACTION_VALUE_SPLITTER, $_POST[POST_INTERN_PROCESS_RESOURCES . "_vf"]);
$rank = explode(POST_ACTION_VALUE_SPLITTER, $_POST[POST_INTERN_PROCESS_RESOURCES . "_vg"]);
$size = explode(POST_ACTION_VALUE_SPLITTER, $_POST[POST_INTERN_PROCESS_RESOURCES . "_vh"]);
foreach ($rids as $key => $id) {
processResource(CALLER_SYSTEM_ID, $rids[$key], base64_decode($html[$key]), $type[$key], base64_decode($title[$key]), $disc[$key], $parent[$key], $rank[$key], $size[$key]);
$xml .= "<r rid=\"" . base64_encode($rids[$key]) . "\" disc=\"" . base64_encode($disc[$key]) . "\" />\r\n";
}
$RESPONSE->SetStandardResponse(1, $xml);
}
function processTicketActions($count = 0)
{
global $GROUPS, $CONFIG;
$temporaryIds = array();
while (isset($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vc"])) {
$type = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vc"];
if ($type == "SetTicketStatus") {
$Ticket = new Ticket();
$Ticket->Id = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_va"];
if ($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"] != $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"]) {
$Ticket->Log(0, CALLER_SYSTEM_ID, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"]);
}
if (!empty($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vb"]) && $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vb"] != $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_3"]) {
$Ticket->Log(2, CALLER_SYSTEM_ID, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vb"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_3"]);
}
if ($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"] != $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_4"]) {
$Ticket->Log(3, CALLER_SYSTEM_ID, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_4"]);
}
$TicketEditor = new TicketEditor($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_va"]);
if (!empty($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vb"])) {
$TicketEditor->Editor = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vb"];
}
$TicketEditor->Status = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"];
$TicketEditor->GroupId = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"];
$TicketEditor->Save();
if ($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"] != $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_4"]) {
$Ticket->SetGroup($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"]);
}
$Ticket->Editor = $TicketEditor;
$Ticket->LoadMessages();
$Ticket->SetLastUpdate(time());
} else {
if ($type == "AddTicketEditorReply") {
$Ticket = new Ticket($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_va"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_3"]);
$Ticket->Group = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_4"];
$Ticket->Messages[0]->Id = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_6"];
$Ticket->Messages[0]->ChannelId = getId(32);
$Ticket->Messages[0]->Hash = $Ticket->GetHash(false);
$Ticket->Messages[0]->SenderUserId = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vb"];
$Ticket->Messages[0]->Type = 1;
$Ticket->Messages[0]->Email = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"];
$Ticket->Messages[0]->Text = Mailbox::FinalizeEmail($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"]);
$Ticket->Messages[0]->Subject = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_5"];
$Ticket->Messages[0]->Save($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_va"], time());
$acount = 7;
$att = array();
while (isset($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_" . $acount])) {
$att[$_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_" . $acount]] = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_" . $acount];
$Ticket->Messages[0]->ApplyAttachment($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_" . $acount++]);
}
$mailbox = Mailbox::GetById($GROUPS[$Ticket->Group]->TicketEmailOut, true);
$Ticket->SendEditorReply($mailbox, $Ticket->Messages[0]->Text, getPredefinedMessage($GROUPS[$Ticket->Group]->PredefinedMessages, $Ticket->Language), $att, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_5"]);
if (!empty($CONFIG["gl_ctor"])) {
$Ticket->LoadStatus();
$Ticket->Editor->Status = TICKET_STATUS_CLOSED;
$Ticket->Editor->Save();
}
$Ticket->SetLastUpdate(time());
} else {
if ($type == "SetTicketLanguage") {
$Ticket = new Ticket($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"]);
$Ticket->SetLanguage($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"]);
$Ticket->Log(1, CALLER_SYSTEM_ID, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"]);
$Ticket->SetLastUpdate(time());
} else {
if ($type == "DeleteTicketFromServer") {
$Ticket = new Ticket($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], "");
$Ticket->Destroy();
$Ticket->Log(7, CALLER_SYSTEM_ID, 0, 1);
$Ticket->SetLastUpdate(time());
} else {
if ($type == "AddComment") {
$Ticket = new TicketMessage($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"], "");
$Ticket->AddComment(CALLER_SYSTEM_ID, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"]);
$Ticket = new Ticket($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"], "");
$Ticket->SetLastUpdate(time());
} else {
if ($type == "LinkChat") {
if (!empty($temporaryIds[$_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"]])) {
$_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"] = $temporaryIds[$_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"]];
}
$Ticket = new Ticket($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], "");
$Ticket->LinkChat($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"], getId(32));
$Ticket->Log(5, CALLER_SYSTEM_ID, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"]);
$Ticket->SetLastUpdate(time());
} else {
if ($type == "LinkTicket") {
$Ticket = new Ticket($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], "");
$TicketSub = new Ticket($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"], "");
$counts[$Ticket->Id] = Ticket::GetMessageCount($Ticket->Id);
$counts[$TicketSub->Id] = Ticket::GetMessageCount($TicketSub->Id);
if ($counts[$Ticket->Id] > $counts[$TicketSub->Id]) {
$Ticket->LinkTicket($TicketSub->Id, getId(32));
} else {
$TicketSub->LinkTicket($Ticket->Id, getId(32));
}
$Ticket->SetLastUpdate(time());
} else {
if ($type == "EditMessage") {
$ticket = new Ticket($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"], "");
$message = new TicketMessage($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], "");
$message->Load();
$message->ChangeValue($ticket, 10, CALLER_SYSTEM_ID, $message->Fullname, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"]);
$message->ChangeValue($ticket, 11, CALLER_SYSTEM_ID, $message->Email, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_3"]);
$message->ChangeValue($ticket, 12, CALLER_SYSTEM_ID, $message->Company, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_4"]);
$message->ChangeValue($ticket, 13, CALLER_SYSTEM_ID, $message->Phone, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_5"]);
$message->ChangeValue($ticket, 14, CALLER_SYSTEM_ID, $message->Subject, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_6"]);
$message->ChangeValue($ticket, 15, CALLER_SYSTEM_ID, $message->Text, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_7"]);
$message->ApplyCustomFromPost($count, true, $ticket, CALLER_SYSTEM_ID);
$message->Save($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"], true);
$ticket->SetLastUpdate(time(), false);
} else {
if ($type == "CreateTicket") {
$Ticket = new Ticket(getObjectId("ticket_id", DATABASE_TICKETS), "");
$temporaryIds[$_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_11"]] = $Ticket->Id;
$Ticket->Messages[0]->Id = $Ticket->Id;
$Ticket->Messages[0]->ChannelId = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_4"];
$Ticket->CreationType = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_3"];
$Ticket->Group = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_6"];
$Ticket->Language = strtoupper(trim($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_10"]));
$Ticket->Messages[0]->Fullname = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"];
$Ticket->Messages[0]->Email = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"];
$Ticket->Messages[0]->Text = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"];
$Ticket->Messages[0]->Company = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_7"];
$Ticket->Messages[0]->Phone = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_8"];
$Ticket->Messages[0]->Type = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_9"];
$Ticket->Messages[0]->Subject = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_15"];
$Ticket->Messages[0]->ApplyCustomFromPost($count);
$cid = 0;
while (isset($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_" . $cid])) {
$value = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_" . $cid++];
if (strpos($value, "[att]") === 0) {
$Ticket->Messages[0]->ApplyAttachment(base64_decode(str_replace("[att]", "", $value)));
} else {
if (strpos($value, "[com]") === 0) {
$Ticket->Messages[0]->AddComment(CALLER_SYSTEM_ID, $Ticket->Id, base64_decode(str_replace("[com]", "", $value)));
}
}
}
$Ticket->Messages[0]->LoadAttachments();
if (!empty($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_4"])) {
$email = new TicketEmail($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_4"], false, "");
$email->LoadAttachments();
foreach ($email->Attachments as $rid => $res) {
if (empty($Ticket->Messages[0]->Attachments[$rid])) {
processResource(CALLER_SYSTEM_ID, $rid, "", RESOURCE_TYPE_FILE_INTERNAL, "", true, 100, 1, 0);
}
}
$email->Destroy();
}
$Ticket->Save();
$TicketEditor = new TicketEditor($Ticket->Id);
$TicketEditor->Editor = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_13"];
$TicketEditor->Status = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_12"];
$TicketEditor->GroupId = $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_14"];
$TicketEditor->Save();
$Ticket->Log(6, CALLER_SYSTEM_ID, $Ticket->Id, "");
$Ticket->SetLastUpdate(time());
} else {
if ($type == "SetEmailStatus") {
$Email = new TicketEmail($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"]);
$Email->SetStatus();
} else {
if ($type == "ForwardMessage") {
$message = new TicketMessage($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], "");
$message->Load();
$message->Forward($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_3"], $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_4"]);
$ticket = new Ticket($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_5"], "");
$ticket->Log(9, CALLER_SYSTEM_ID, $message->Id, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_2"]);
} else {
if ($type == "MoveMessageIntoTicket") {
$message = new TicketMessage($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_1"], "");
$message->Load(true);
$message->ChannelId = getId(32);
$ticket = new Ticket($_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], "");
$ticket->Load();
$ticket->Id = $message->Id = getObjectId("ticket_id", DATABASE_TICKETS);
$ticket->Messages = array();
$ticket->Messages[0] = $message;
$ticket->Save();
$ticket->Log(8, CALLER_SYSTEM_ID, $ticket->Id, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"]);
$message->SaveAttachments();
$message->SaveComments($ticket->Id);
} else {
if ($type == "DeleteAttachment") {
processResource(CALLER_SYSTEM_ID, $_POST[POST_INTERN_PROCESS_TICKET_ACTIONS . "_" . $count . "_vd_0"], "", RESOURCE_TYPE_FILE_INTERNAL, "", true, "100", "1");
}
}
}
}
}
}
}
}
}
}
}
}
}
$count++;
}
if ($count > 0) {
CacheManager::SetDataUpdateTime(DATA_UPDATE_KEY_TICKETS);
CacheManager::SetDataUpdateTime(DATA_UPDATE_KEY_EMAILS);
}
}
function up_3183_3184($_prefix, $_link)
{
global $INTERNAL, $GROUPS;
$result = @mysql_query("ALTER TABLE `" . @mysql_real_escape_string($_prefix) . "info` ADD `chat_id` INT NOT NULL DEFAULT '11700'", $_link);
if (!$result && mysql_errno() != 1060) {
return mysql_errno() . ": " . mysql_error();
}
$result = @mysql_query("ALTER TABLE `" . @mysql_real_escape_string($_prefix) . "info` ADD `ticket_id` INT NOT NULL DEFAULT '11700'", $_link);
if (!$result && mysql_errno() != 1060) {
return mysql_errno() . ": " . mysql_error();
}
$result = @mysql_query("ALTER TABLE `" . @mysql_real_escape_string($_prefix) . "chats` ADD `transcript_sent` tinyint(1) unsigned NOT NULL default '1'", $_link);
if (!$result && mysql_errno() != 1060) {
return mysql_errno() . ": " . mysql_error();
}
$result = @mysql_query("ALTER TABLE `" . @mysql_real_escape_string($_prefix) . "res` CHANGE `html` `value` longtext character set utf8 collate utf8_bin NOT NULL", $_link);
if (!$result && mysql_errno() != 1054) {
return mysql_errno() . ": " . mysql_error();
}
$result = @mysql_query("ALTER TABLE `" . @mysql_real_escape_string($_prefix) . "res` ADD `size` bigint(20) unsigned NOT NULL default '0'", $_link);
if (!$result && mysql_errno() != 1060) {
return mysql_errno() . ": " . mysql_error();
}
$dirs = array(PATH_UPLOADS_INTERNAL, PATH_UPLOADS_EXTERNAL);
$baseFolderInternal = $baseFolderExternal = false;
foreach ($dirs as $tdir) {
$subdirs = getDirectory($tdir, false, true);
foreach ($subdirs as $dir) {
if (@is_dir($tdir . $dir . "/")) {
if ($tdir == PATH_UPLOADS_INTERNAL) {
$owner = getInternalSystemIdByUserId($dir);
} else {
$owner = CALLER_SYSTEM_ID;
}
if (!isset($INTERNAL[$owner])) {
continue;
}
$files = getDirectory($tdir . $dir . "/", false, true);
foreach ($files as $file) {
if ($file != FILE_INDEX && $file != FILE_INDEX_OLD) {
if ($tdir == PATH_UPLOADS_INTERNAL) {
$parentId = $owner;
$type = 3;
if (!$baseFolderInternal) {
createFileBaseFolders($owner, true);
$baseFolderInternal = true;
}
processResource($owner, $owner, $INTERNAL[$owner]->Fullname, 0, $INTERNAL[$owner]->Fullname, 0, 4, 3);
} else {
$parentId = 5;
$owner = CALLER_SYSTEM_ID;
$type = 4;
if (!$baseFolderExternal) {
createFileBaseFolders($owner, false);
$baseFolderExternal = true;
}
}
$cfile = $tdir != PATH_UPLOADS_INTERNAL ? base64_decode($file) : $file;
$size = filesize($tdir . $dir . "/" . $file);
$fid = md5($file . $owner . $size);
$filename = $owner . "_" . $fid;
copy($tdir . $dir . "/" . $file, PATH_UPLOADS . $filename);
processResource($owner, $fid, $filename, $type, $cfile, 0, $parentId, 4, $size);
}
}
}
}
}
$sql = "CREATE TABLE `" . @mysql_real_escape_string($_prefix) . "predefined` (`id` int(11) unsigned NOT NULL,`internal_id` varchar(32) character set utf8 collate utf8_bin NOT NULL,`group_id` varchar(32) character set utf8 collate utf8_bin NOT NULL,`lang_iso` varchar(2) character set utf8 collate utf8_bin NOT NULL,`invitation` mediumtext character set utf8 collate utf8_bin NOT NULL,`welcome` mediumtext character set utf8 collate utf8_bin NOT NULL,`website_push` mediumtext character set utf8 collate utf8_bin NOT NULL,`browser_ident` tinyint(1) unsigned NOT NULL default '0',`is_default` tinyint(1) unsigned NOT NULL default '0', `auto_welcome` tinyint(1) unsigned NOT NULL default '0',PRIMARY KEY (`id`)) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin;";
$result = mysql_query($sql, $_link);
if (!$result && mysql_errno() != 1050) {
return mysql_errno() . ": " . mysql_error();
} else {
if ($result) {
$counter = 0;
foreach ($GROUPS as $gid => $group) {
@mysql_query("INSERT INTO `" . @mysql_real_escape_string($_prefix) . "predefined` (`id` ,`internal_id`, `group_id` ,`lang_iso` ,`invitation` ,`welcome` ,`website_push` ,`browser_ident` ,`is_default` ,`auto_welcome`) VALUES ('" . @mysql_real_escape_string($counter++) . "', '', '" . @mysql_real_escape_string($gid) . "', 'EN', 'Hello, my name is %name%. Do you need help? Start Live-Chat now to get assistance.', 'Hello %external_name%, my name is %name%, how may I help you?', 'Website Operator %name% would like to redirect you to this URL:\r\n\r\n%url%', '1', '1', '1');", $_link);
@mysql_query("INSERT INTO `" . @mysql_real_escape_string($_prefix) . "predefined` (`id` ,`internal_id`, `group_id` ,`lang_iso` ,`invitation` ,`welcome` ,`website_push` ,`browser_ident` ,`is_default` ,`auto_welcome`) VALUES ('" . @mysql_real_escape_string($counter++) . "', '', '" . @mysql_real_escape_string($gid) . "', 'DE', '" . utf8_encode("Guten Tag, meine Name ist %name%. Benötigen Sie Hilfe? Gerne berate ich Sie in einem Live Chat") . "', 'Guten Tag %external_name%, mein Name ist %name% wie kann ich Ihnen helfen?', '" . utf8_encode("Ein Betreuer dieser Webseite (%name%) möchte Sie auf einen anderen Bereich weiterleiten:\\r\\n\\r\\n%url%") . "', '1', '0', '1');", $_link);
}
}
}
$sql = "CREATE TABLE `" . @mysql_real_escape_string($_prefix) . "rooms` (`id` int(11) NOT NULL,`time` int(11) NOT NULL,`last_active` int(11) NOT NULL,`status` tinyint(1) NOT NULL default '0',`target_group` varchar(64) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin;";
$result = mysql_query($sql, $_link);
if (!$result && mysql_errno() != 1050) {
return mysql_errno() . ": " . mysql_error();
}
$sql = "CREATE TABLE `" . @mysql_real_escape_string($_prefix) . "posts` (`id` varchar(32) character set utf8 collate utf8_bin NOT NULL,`time` int(10) unsigned NOT NULL default '0',`micro` int(10) unsigned NOT NULL default '0',`sender` varchar(32) character set utf8 collate utf8_bin NOT NULL,`receiver` varchar(32) character set utf8 collate utf8_bin NOT NULL,`receiver_group` varchar(32) character set utf8 collate utf8_bin NOT NULL,`text` mediumtext character set utf8 collate utf8_bin NOT NULL,`received` tinyint(1) unsigned NOT NULL default '0',`persistent` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`)) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin;";
$result = mysql_query($sql, $_link);
if (!$result && mysql_errno() != 1050) {
return mysql_errno() . ": " . mysql_error();
}
$sql = "CREATE TABLE `" . @mysql_real_escape_string($_prefix) . "tickets` (`id` varchar(32) character set utf8 collate utf8_bin NOT NULL,`user_id` varchar(32) character set utf8 collate utf8_bin NOT NULL,`target_group_id` varchar(32) character set utf8 collate utf8_bin NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin;";
$result = mysql_query($sql, $_link);
if (!$result && mysql_errno() != 1050) {
return mysql_errno() . ": " . mysql_error();
}
$sql = "CREATE TABLE `" . @mysql_real_escape_string($_prefix) . "ticket_editors` (`ticket_id` int(10) unsigned NOT NULL,`internal_fullname` varchar(32) character set utf8 collate utf8_bin NOT NULL,`status` tinyint(1) unsigned NOT NULL default '1',`time` int(10) unsigned NOT NULL,PRIMARY KEY (`ticket_id`)) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin;";
$result = mysql_query($sql, $_link);
if (!$result && mysql_errno() != 1050) {
return mysql_errno() . ": " . mysql_error();
}
$sql = "CREATE TABLE `" . @mysql_real_escape_string($_prefix) . "ticket_messages` (`id` int(11) unsigned NOT NULL auto_increment,`time` int(11) unsigned NOT NULL,`ticket_id` varchar(32) character set utf8 collate utf8_bin NOT NULL,`text` mediumtext character set utf8 collate utf8_bin NOT NULL,`fullname` varchar(32) character set utf8 collate utf8_bin NOT NULL,`email` varchar(50) character set utf8 collate utf8_bin NOT NULL,`company` varchar(50) character set utf8 collate utf8_bin NOT NULL,`ip` varchar(15) character set utf8 collate utf8_bin NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin AUTO_INCREMENT=1;";
$result = mysql_query($sql, $_link);
if (!$result && mysql_errno() != 1050) {
return mysql_errno() . ": " . mysql_error();
}
$sql = "CREATE TABLE `" . @mysql_real_escape_string($_prefix) . "ratings` (`id` varchar(32) character set utf8 collate utf8_bin NOT NULL, `time` int(11) unsigned NOT NULL, `user_id` varchar(32) character set utf8 collate utf8_bin NOT NULL, `internal_id` varchar(32) character set utf8 collate utf8_bin NOT NULL, `fullname` varchar(32) character set utf8 collate utf8_bin NOT NULL, `email` varchar(50) character set utf8 collate utf8_bin NOT NULL, `company` varchar(50) character set utf8 collate utf8_bin NOT NULL, `qualification` tinyint(1) unsigned NOT NULL, `politeness` tinyint(1) unsigned NOT NULL, `comment` varchar(400) character set utf8 collate utf8_bin NOT NULL, `ip` varchar(15) character set utf8 collate utf8_bin NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin;";
$result = mysql_query($sql, $_link);
if (!$result && mysql_errno() != 1050) {
return mysql_errno() . ": " . mysql_error();
}
return TRUE;
}
function createFileBaseFolders($_owner, $_internal)
{
if ($_internal) {
processResource($_owner, 3, "%%_Files_%%", 0, "%%_Files_%%", 0, 1, 1);
processResource($_owner, 4, "%%_Internal_%%", 0, "%%_Internal_%%", 0, 3, 2);
} else {
processResource($_owner, 3, "%%_Files_%%", 0, "%%_Files_%%", 0, 1, 1);
processResource($_owner, 5, "%%_External_%%", 0, "%%_External_%%", 0, 3, 2);
}
}
function AppendPostFile($_postKey, $_userId)
{
if (!empty($_FILES[$_postKey]) && true) {
$filename = namebase($_FILES[$_postKey]['name']);
if (!isValidUploadFile($filename)) {
return $filename;
}
$fileId = getId(32);
$fileurid = $_userId . "_" . $fileId;
if (move_uploaded_file($_FILES[$_postKey]["tmp_name"], PATH_UPLOADS . $fileurid)) {
processResource("SYSTEM", $fileId, $fileurid, 3, $filename, 0, 100, $_FILES[$_postKey]["size"]);
$this->ApplyAttachment($fileId);
return $filename;
}
}
}
