PHP dbRunSQL Examples

Example #1

File: install.php Project: ratmir-by/icms-calendar

function upgrade_component_calendar()
{
    $inCore = cmsCore::getInstance();
    $inDB = cmsDatabase::getInstance();
    include PATH . '/includes/dbimport.inc.php';
    dbRunSQL(PATH . '/components/calendar/update.sql', $inConf->db_prefix);
    return true;
}

Example #2

File: install.php Project: kovalevsc/icms-usermaps

function upgrade_component_usermaps()
{
    $inCore = cmsCore::getInstance();
    $inDB = cmsDatabase::getInstance();
    $inConf = cmsConfig::getInstance();
    include $_SERVER['DOCUMENT_ROOT'] . '/includes/dbimport.inc.php';
    dbRunSQL($_SERVER['DOCUMENT_ROOT'] . '/components/usermaps/update.sql', $inConf->db_prefix);
    return true;
}

Example #3

File: install.php Project: 4uva4ek/svato

function install_component_battleways()
{
    $inCore = cmsCore::getInstance();
    //подключаем ядро
    $inDB = cmsDatabase::getInstance();
    //подключаем базу данных
    $inConf = cmsConfig::getInstance();
    include $_SERVER['DOCUMENT_ROOT'] . '/includes/dbimport.inc.php';
    dbRunSQL($_SERVER['DOCUMENT_ROOT'] . '/components/battleways/install.sql', $inConf->db_prefix);
    return true;
}

Example #4

File: install.php Project: 4uva4ek/svato

function install_component_wishes()
{
    $inCore = cmsCore::getInstance();
    //подключаем ядро
    $inDB = cmsDatabase::getInstance();
    //подключаем базу данных
    $inConf = cmsConfig::getInstance();
    include $_SERVER['DOCUMENT_ROOT'] . '/includes/dbimport.inc.php';
    dbRunSQL($_SERVER['DOCUMENT_ROOT'] . '/components/wishes/install.sql', $inConf->db_prefix);
    $sql = "select * from `cms_comment_targets` where `target`='wishes';";
    $result = $inDB->query($sql);
    if (!$inDB->num_rows($result)) {
        $inDB->query("INSERT INTO `cms_comment_targets` (`id`, `target`, `component`, `title`) VALUES (NULL, 'wishes', 'wishes', 'Хотелки-Умелки');");
    }
    return true;
}