PHP SimpleInvoices_Db::tableExists示例

示例#1

文件： init.php 项目： CalhounGaming/simpleinvoices

error_reporting($config->debug->error_reporting);
ini_set('display_startup_errors', $config->phpSettings->display_startup_errors);
ini_set('display_errors', $config->phpSettings->display_errors);
ini_set('log_errors', $config->phpSettings->log_errors);
ini_set('error_log', $config->phpSettings->error_log);

//after config is loaded - do auth
require_once($include_dir . 'sys/include/include_auth.php');

include_once("sys/include/class/db.php");
include_once("sys/include/class/index.php");
$db = db::getInstance();

include_once("sys/include/sql_queries.php");

$install_tables_exists = SimpleInvoices_Db::tableExists("biller");
if ($install_tables_exists == true)
{
	$install_data_exists = SimpleInvoices_Db::dataExists();
}

//TODO - add this as a function in sql_queries.php or a class file
//if ( ($install_tables_exists != false) AND ($install_data_exists != false) )
if ( $install_tables_exists != false )
{
	if (SimpleInvoices_Db_Table_SQLPatchManager::getNumberOfDoneSQLPatches() > "196")
	{
        $SI_EXTENSIONS = new SimpleInvoices_Db_Table_Extensions();
        // ToDo: Watch out! This get's translated while the original doesn't!!!
        $extensions = $SI_EXTENSIONS->fetchAll();
        $DB_extensions = array();

示例#2

文件： structure.php 项目： CalhounGaming/simpleinvoices

<?php
$menu = false;


if (SimpleInvoices_Db::tableExists("billers") == false)
{
//	echo "SCHEME";
	//SQL import
	$import = new import();
	$import->file = $include_dir . "/sys/databases/mysql/structure.sql";
	$import->pattern_find = array('si_','DOMAIN-ID','LOCALE','LANGUAGE');
	$import->pattern_replace = array(TB_PREFIX,'1','en_GB','en_GB');
	//dbQuery($import->collate());
	$db->query($import->collate());
}

示例#3

文件： essential.php 项目： CalhounGaming/simpleinvoices

<?php

$menu = false;

if ( (SimpleInvoices_Db::tableExists("customers") == true) AND ($install_data_exists == false) )
{
//	echo "ESSENTIAL";
	//JSON import
	$importjson = new importjson();
	$importjson->file = $include_dir ."/sys/databases/json/essential_data.json";
	//$importjson->debug = true;
	$importjson->pattern_find = array('si_','DOMAIN-ID','LOCALE','LANGUAGE');
	$importjson->pattern_replace = array(TB_PREFIX,'1','en_GB','en_GB');
	//dbQuery($importjson->collate());
	$db->query($importjson->collate());
}

示例#4

文件： sql_patches.php 项目： CalhounGaming/simpleinvoices

		}
	$patch['128']['date'] = "200709";
	
	
	$patch['129']['name'] = "Fill user table with default values";
	$patch['129']['patch'] = "INSERT INTO `".TB_PREFIX."users` (`user_id`, `user_email`, `user_name`, `user_group`, `user_domain`, `user_password`) VALUES (NULL, '*****@*****.**', 'demo', '1', '1', MD5('demo'))";
	$patch['129']['date'] = "200709";
	
	$patch['130']['name'] = "Create auth_challenges table";
	
			if(SimpleInvoices_Db::tableExists('auth_challenges') == true)
			{
				//a do nothing patch cause the table already exists
			$patch['130']['patch'] = "select * from ".TB_PREFIX."auth_challenges";
			}
			if(SimpleInvoices_Db::tableExists('auth_challenges') == false)
			{
				$patch['130']['patch'] = "CREATE TABLE IF NOT EXISTS `".TB_PREFIX."auth_challenges` (
`challenges_key` int(11) NOT NULL,
`challenges_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP);
";
			}  
	$patch['130']['date'] = "200709";
	
	$patch['131']['name'] = "Make tax field 3 decimal places";
	$patch['131']['patch'] = "ALTER TABLE `".TB_PREFIX."tax` CHANGE `tax_percentage` `tax_percentage` DECIMAL (10,3)  NULL";
	$patch['131']['date'] = "200709";

//2008 09 26 - Beta release patches start