ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / centosnipponia / public_html / ticketing.nipponia.com / include / upgrader / streams / core

<?php

/*
 * Add all indexes we've implemented over time. Check if exists
 * to avoid errors.
 */
class AddIndexMigration extends MigrationTask {
    var $description = "Add indexes accumulated over time";
    var $indexes = array(
        'department:flags',
        'draft:staff_id',
        'draft:namespace',
        'file:type',
        'file:created',
        'file:size',
        'form:type',
        'form_field:form_id',
        'form_field:sort',
        'queue:staff_id',
        'queue:parent_id',
        'staff:isactive',
        'staff:onvacation',
        'task:flags',
        'ticket:ticket_pid',
        'team_member:staff_id',
        'user:default_email_id',
        'user:name'
    );

function run($max_time) {
        global $ost;

foreach ($this->indexes as $index) {
            list($t, $i) = explode(':', $index);

// Check if INDEX already exists via SHOW INDEX
            $sql = sprintf("SHOW INDEX FROM `%s` WHERE `Column_name` = '%s' AND `Key_name` != 'PRIMARY'",
                    TABLE_PREFIX.$t, $i);

// Hardfail if we cannot check if exists
            if(!($res=db_query($sql)))
                return $this->error('Unable to query DB for Add Index migration!');

$count = db_num_rows($res);

if (!$count || ($count && ($count == 0))) {
                // CREATE INDEX if not exists
                $create = sprintf('CREATE INDEX `%s` ON `%s`.`%s` (`%s`)',
                        $i, DBNAME, TABLE_PREFIX.$t, $i);

if(!($res=db_query($create))) {
                    $message = "Unable to create index `$i` on `".TABLE_PREFIX.$t."`.";
                    // Log the error but don't send the alert email
                    $ost->logError('Upgrader: Add Index Migrater', $message, false);
                }
            }
        }

//add permissions to staff
        foreach (Staff::objects() as $staff) {
            $perms = array();
            foreach ($staff->getPermissionInfo() as $value => $setting)
                $perms[] = $value;

array_push($perms, 'visibility.departments', 'visibility.agents');
            $staff->updatePerms($perms);
            $staff->save();
        }

//add 2fa template
        foreach (array('email2fa-staff') as $type) {
             $i18n = new Internationalization();
             $tpl = $i18n->getTemplate("templates/page/{$type}.yaml");
             if (!($page = $tpl->getData()))
                 // No such template on disk
                 continue;

if ($id = db_result(db_query('select id from '.PAGE_TABLE
                     .' where `type`='.db_input($type))))
                 // Already have a template for the content type
                 continue;

$sql = 'INSERT INTO '.PAGE_TABLE.' SET type='.db_input($type)
                 .', name='.db_input($page['name'])
                 .', body='.db_input($page['body'])
                 .', notes='.db_input($page['notes'])
                 .', created=NOW(), updated=NOW(), isactive=1';
             db_query($sql);
         }

// See if there are missing events that should be added to the database
         $event_type = array('login', 'logout', 'message', 'note');
         foreach($event_type as $eType) {
             $sql = sprintf("SELECT * FROM `%s` WHERE name = '%s'",
                     TABLE_PREFIX.'event', $eType);

$res=db_query($sql);
             $count = db_num_rows($res);

if($count > 0) {
                 $message = "Event '$eType' already exists.";
                 $ost->logError('Upgrader: Add Events', $message, false);
             } else {
                 // Add event
                 $sql = sprintf("INSERT INTO `%s` (`id`, `name`, `description`)
                        VALUES
                        ('','%s',NULL)",
                         TABLE_PREFIX.'event', $eType);

if(!($res=db_query($sql))) {
                     $message = "Unable to add $eType event to `".TABLE_PREFIX.'event'."`.";
                     $ost->logError('Upgrader: Add Events', $message, false);
                 }
             }
         }
    }
}
return 'AddIndexMigration';

[+] ..
[-] 16fcef4a-d51f303a.patch.sql [edit]
[-] e2b4e5cb-f0d2e14d.cleanup.sql [edit]
[-] 61c9d5d7-6de40a4d.patch.sql [edit]
[-] 15af7cd3-98ae1ed2.patch.sql [edit]
[-] ed60ba20-934954de.patch.sql [edit]
[-] 32de1766-852ca89e.patch.sql [edit]
[-] 5cd0a25a-2d590ffa.task.php [edit]
[-] e2b4e5cb-f0d2e14d.task.php [edit]
[-] 740428f9-8aeda901.patch.sql [edit]
[-] 9ef33a06-8f99b8bf.patch.sql [edit]
[-] 8f99b8bf-03ff59bf.patch.sql [edit]
[-] 852ca89e-740428f9.patch.sql [edit]
[-] 9f3b454c-c0fd16f4.patch.sql [edit]
[-] 36f6b328-5cd0a25a.task.php [edit]
[-] e7038ce9-ddbe2e76.patch.sql [edit]
[-] c0fd16f4-d959a00e.patch.sql [edit]
[-] 00ff231f-9f3b454c.patch.sql [edit]
[-] 98ae1ed2-e342f869.task.php [edit]
[-] 15b30765-dd0022fb.task.php [edit]
[-] d51f303a-dad45ca2.patch.sql [edit]
[-] d51f303a-dad45ca2.task.php [edit]
[-] 6de40a4d-1b0fce99.patch.sql [edit]
[-] c37e1656-e2b4e5cb.task.php [edit]
[-] 15719536-dd0022fb.patch.sql [edit]
[-] 2e20a0eb-98ae1ed2.patch.sql [edit]
[-] 5cd0a25a-2d590ffa.cleanup.sql [edit]
[-] 435c62c3-2e7531a2.cleanup.sql [edit]
[-] 70921d5c-26fd79dc.patch.sql [edit]
[-] 98ae1ed2-e342f869.patch.sql [edit]
[-] 1da1bcba-15b30765.patch.sql [edit]
[-] 03ff59bf-b26f29a6.patch.sql [edit]
[-] add62892-c37e1656.patch.sql [edit]
[-] b26f29a6-1ee831c8.task.php [edit]
[-] 9143a511-0d6099a6.cleanup.sql [edit]
[-] 15b30765-dd0022fb.cleanup.sql [edit]
[-] e2b4e5cb-f0d2e14d.patch.sql [edit]
[-] 1b0fce99-ed60ba20.patch.sql [edit]
[-] 934954de-f1ccd3bb.task.php [edit]
[-] c00511c7-7be60a84.patch.sql [edit]
[-] 26fd79dc-00c949a6.patch.sql [edit]
[-] 1ee831c8-36f6b328.cleanup.sql [edit]
[-] e7038ce9-ddbe2e76.task.php [edit]
[-] dad45ca2-61c9d5d7.cleanup.sql [edit]
[-] 61c9d5d7-6de40a4d.task.php [edit]
[-] c2d2fabf-aa4664af.patch.sql [edit]
[-] 0d6099a6-98ad7d55.cleanup.sql [edit]
[-] 9143a511-0d6099a6.patch.sql [edit]
[-] 934b8db8-ad9d0a5f.patch.sql [edit]
[-] 98ad7d55-934b8db8.patch.sql [edit]
[-] 87d4a323-4bd47d94.patch.sql [edit]
[-] dd0022fb-f4da0c9b.patch.sql [edit]
[-] cce1ba43-e7dfe821.patch.sql [edit]
[-] 36f6b328-5cd0a25a.patch.sql [edit]
[-] dad45ca2-61c9d5d7.task.php [edit]
[-] 8aeda901-16fcef4a.task.php [edit]
[-] 8f99b8bf-03ff59bf.cleanup.sql [edit]
[-] bbb021fb-49478749.patch.sql [edit]
[-] ad9d0a5f-0ca85857.patch.sql [edit]
[-] f0d2e14d-83a22ba2.patch.sql [edit]
[-] 03ff59bf-b26f29a6.cleanup.sql [edit]
[-] f8856d56-abe9c0cb.patch.sql [edit]
[-] 0d6099a6-98ad7d55.patch.sql [edit]
[-] e342f869-c00511c7.patch.sql [edit]
[-] 00c949a6-8b923d61.patch.sql [edit]
[-] 00c949a6-8b923d61.task.php [edit]
[-] dad45ca2-61c9d5d7.patch.sql [edit]
[-] f0d2e14d-83a22ba2.task.php [edit]
[-] e6978154-cc6d1b03.patch.sql [edit]
[-] 86707325-526c601b.patch.sql [edit]
[-] c00511c7-7be60a84.cleanup.sql [edit]
[-] b26f29a6-1ee831c8.cleanup.sql [edit]
[-] 4bd47d94-e7038ce9.cleanup.sql [edit]
[-] 934954de-f1ccd3bb.patch.sql [edit]
[-] 1ee831c8-36f6b328.task.php [edit]
[-] d0e37dca-1da1bcba.patch.sql [edit]
[-] ddbe2e76-add62892.patch.sql [edit]
[-] f1ccd3bb-f5692e24.patch.sql [edit]
[-] 36f6b328-5cd0a25a.cleanup.sql [edit]
[-] b19dc97d-435c62c3.patch.sql [edit]
[-] abe9c0cb-bbb021fb.patch.sql [edit]
[-] 87d4a323-4bd47d94.task.php [edit]
[-] f1ccd3bb-f5692e24.task.php [edit]
[-] 1ee831c8-36f6b328.patch.sql [edit]
[-] cc6d1b03-914098f4.patch.sql [edit]
[-] f5692e24-4323a6a8.task.php [edit]
[-] b26f29a6-1ee831c8.patch.sql [edit]
[-] aee589ab-98ae1ed2.patch.sql [edit]
[-] 60fcbee1-f8856d56.patch.sql [edit]
[-] 8b923d61-9b5550da.patch.sql [edit]
[-] 86707325-526c601b.cleanup.sql [edit]
[-] 914098f4-87d4a323.patch.sql [edit]
[-] 435c62c3-2e7531a2.patch.sql [edit]
[-] 2d590ffa-9143a511.patch.sql [edit]
[-] 8f99b8bf-03ff59bf.task.php [edit]
[-] 49478749-c2d2fabf.patch.sql [edit]
[-] aa4664af-b19dc97d.patch.sql [edit]
[-] f5692e24-4323a6a8.patch.sql [edit]
[-] f1ccd3bb-f5692e24.cleanup.sql [edit]
[-] 0ca85857-86707325.patch.sql [edit]
[-] 4bd47d94-e7038ce9.patch.sql [edit]
[-] 26fd79dc-00c949a6.cleanup.sql [edit]
[-] 526c601b-cce1ba43.patch.sql [edit]
[-] 522e5b78-02decaa2.patch.sql [edit]
[-] 15b30765-dd0022fb.patch.sql [edit]
[-] d959a00e-32de1766.patch.sql [edit]
[-] 9b5550da-e6978154.patch.sql [edit]
[-] 4bd47d94-e7038ce9.task.php [edit]
[-] 934b8db8-ad9d0a5f.task.php [edit]
[-] f0d2e14d-83a22ba2.cleanup.sql [edit]
[-] c37e1656-e2b4e5cb.patch.sql [edit]
[-] 435c62c3-2e7531a2.task.php [edit]
[-] 5cd0a25a-2d590ffa.patch.sql [edit]
[-] 8aeda901-16fcef4a.patch.sql [edit]
[-] 98ae1ed2-e342f869.cleanup.sql [edit]
[-] 26fd79dc-00c949a6.task.php [edit]
[-] 0d6099a6-98ad7d55.task.php [edit]
[-] 2e7531a2-d0e37dca.patch.sql [edit]
[-] 4323a6a8-9ef33a06.patch.sql [edit]
[-] e7dfe821-70921d5c.patch.sql [edit]
[-] f4da0c9b-00ff231f.patch.sql [edit]
[-] 02decaa2-60fcbee1.patch.sql [edit]
[-] 7be60a84-522e5b78.patch.sql [edit]
[-] c00511c7-7be60a84.task.php [edit]
[-] 9143a511-0d6099a6.task.php [edit]
[-] 83a22ba2-5fb92bef.patch.sql [edit]
[-] a67ba35e-98ae1ed2.patch.sql [edit]