| zerobytes |
| Valuable expert |
 |
|
| Joined: Aug 30, 2008 |
| Posts: 199 |
|
|
|
 |
|
 |
|
Untested
| Code: |
<?
define ( 'INSTALL','true');
define ( 'DEBUG','true');
error_reporting ( E_ALL );
ini_set ( "display_errors",1 );
include_once 'app/lib/crypto.php';
if(isset($_GET['info']) &&$_GET['info'] == 1){
echo '<div align="center" style="width:100%; height:50px; background-color:#CCCCCC; margin-bottom:10px;">';
echo "<h2><a href=\"install.php\">Return to the FormBoss Install Screen</a></h2>";
echo '</div>';
phpinfo();
die();
}
$preflight = "";
if(get_magic_quotes_gpc()){
$preflight = "<li>Your server is set with magic_quotes_gpc, an unnecessary and soon to be depreciated variable. Please disable this in your php.ini with( magic_quotes_gpc = Off ) for best results.</li>";
}
if(ini_get('output_buffering') == false){
$preflight = "<li>Your server doesn't have output_buffering enabled. This is not a problem, but for best performance and reliability with FormBoss, it is advisable that you enable it in your php.ini file with the default value of 4096.</li>";
}
if(ini_get('safe_mode') == true){
$preflight = "<li>Your server has safe_mode enabled, which usually means the install process will fail (FormBoss will not be able to create files and folders). To fix this set safe_mode=0 in your php.ini file. In fact, this feature is DEPRICIATED as of PHP 5.3, and it's use is not encouraged.</li>";
}
$common_options = ini_get_all();
ob_start();
phpinfo();
$phpinfo = ob_get_contents();ob_end_clean();
if(strpos($phpinfo,'MYSQLI_SOCKET') != 0){
$start = strpos($phpinfo,'<td class="e">MYSQLI_SOCKET </td>') +strlen('<td class="e">MYSQLI_SOCKET </td><td class="v">');
$end = strpos($phpinfo,'</td>',$start);
$defaults_mysql_socket_base = trim(substr($phpinfo,$start,$end -$start));
}else {
$defaults_mysql_socket_base = '';
}
$defaults_mysql_socket = isset($common_options['mysqli.default_socket']['local_value']) ?$common_options['mysqli.default_socket']['local_value'] : '';
if($defaults_mysql_socket == ""){
$defaults_mysql_socket = isset($common_options['mysql.default_socket']['local_value']) ?
$common_options['mysql.default_socket']['local_value'] : '';
}
if($defaults_mysql_socket == ""){
$defaults_mysql_socket = isset($common_options['pdo_mysql.default_socket']['local_value']) ?
$common_options['pdo_mysql.default_socket']['local_value'] : '';
}
$defaults_mysql_port = isset($common_options['mysqli.default_port']['local_value']) ?$common_options['mysqli.default_port']['local_value'] : '';
$defaults_timezone = $common_options['date.timezone']['local_value'];
class moduleCheck {
public $Modules;
function __construct() {
ob_start ();
phpinfo ( INFO_MODULES );
$data = ob_get_contents ();
ob_end_clean ();
$data = strip_tags ( $data,'<h2><th><td>');
$data = preg_replace ( '/<th[^>]*>([^<]+)<\/th>/',"<info>\\1</info>",$data );
$data = preg_replace ( '/<td[^>]*>([^<]+)<\/td>/',"<info>\\1</info>",$data );
$vTmp = preg_split ( '/(<h2>[^<]+<\/h2>)/',$data,-1,PREG_SPLIT_DELIM_CAPTURE );
$vModules = array ();
$count = count ( $vTmp );
for($i = 1;$i <$count;$i += 2) {
if (preg_match ( '/<h2>([^<]+)<\/h2>/',$vTmp [$i],$vMat )) {
$moduleName = trim ( $vMat [1] );
$vTmp2 = explode ( "\n",$vTmp [$i +1] );
foreach ( $vTmp2 as $vOne ) {
$vPat = '<info>([^<]+)<\/info>';
$vPat3 = "/$vPat\s*$vPat\s*$vPat/";
$vPat2 = "/$vPat\s*$vPat/";
if (preg_match ( $vPat3,$vOne,$vMat )) {
$vModules [$moduleName] [trim ( $vMat [1] )] = array (trim ( $vMat [2] ),trim ( $vMat [3] ) );
}elseif (preg_match ( $vPat2,$vOne,$vMat )) {
$vModules [$moduleName] [trim ( $vMat [1] )] = trim ( $vMat [2] );
}
}
}
}
$this->Modules = $vModules;
}
public function isLoaded($moduleName) {
if ($this->Modules [$moduleName]) {
return true;
}
return false;
}
public function getModuleSetting($moduleName,$setting = '') {
if ($this->isLoaded ( $moduleName ) == false) {
return 'Module not loaded';
}
if ($this->Modules [$moduleName] [$setting]) {
return $this->Modules [$moduleName] [$setting];
}elseif (empty ( $setting )) {
return $this->Modules [$moduleName];
}
return 'Setting not found';
}
public function listModules() {
foreach ( $this->Modules as $moduleName =>$values ) {
$onlyModules [] = $moduleName;
}
return $onlyModules;
}
}
function test_write_output() {
$pass = true;
if(is_writable('output/test/')){
$handle = fopen ( 'output/test/test.txt','wb');
if ($handle) {
$test = 'test';
if (fwrite ( $handle,$test )) {
fclose ( $handle );
unlink ( 'output/test/test.txt');
}else {
$pass = false;
}
}else {
$pass = false;
}
delete_directory ( 'output/test/');
}else {
$pass = false;
}
return $pass;
}
function test_write_xml() {
$pass = true;
if(is_writable('output/xml/')){
$handle = fopen ( 'output/xml/test.txt','wb');
if ($handle) {
$test = 'test';
if (fwrite ( $handle,$test )) {
fclose ( $handle );
unlink ( 'output/xml/test.txt');
}else {
$pass = false;
}
}else {
$pass = false;
}
}else {
$pass = false;
}
return $pass;
}
function delete_directory($dirname) {
$dir_handle = 0;
if (is_dir ( $dirname ))
$dir_handle = opendir ( $dirname );
if (!$dir_handle)
return false;
while ( $file = readdir ( $dir_handle ) ) {
if ($file != "."&&$file != "..") {
if (!is_dir ( $dirname ."/".$file ))
unlink ( $dirname ."/".$file );
else
delete_directory ( $dirname .'/'.$file );
}
}
closedir ( $dir_handle );
if (@rmdir ( $dirname )) {
return true;
}else {
return false;
}
}
function execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port,$multi = false){
$e_message = '';
if($db_vendor == 'mysql'){
$dsn = $db_vendor .":unix_socket=".$db_mysql_socket .";host=".$db_hostname .";dbname=".$db_catalog .";port={$db_mysql_port};";
try{
$conn = new PDO ( $dsn,$db_username,$db_password );
}catch(PDOException $e){
$e_message = "Error 244: ".$e->getMessage () ."\n";
return;
}
$e_message = '';
try {
$sth = $conn->prepare ( $sql );
if ($conn->errorCode () != '00000') {
if (DEBUG) {
$e_message = "Database Error 255: ".implode ( ': ',$conn->errorInfo () ) ."\n";
}
}
$sth->execute ();
}catch ( PDOException $e ) {
echo $e;
}
if ($conn->errorCode () != '00000') {
if (DEBUG) {
$e_message = "Error 266: ".implode ( ': ',$conn->errorInfo () ) ."\n";
}
}
if ($sth->errorCode () != '00000') {
if (DEBUG) {
$e_message = "Error 273: ".implode ( ': ',$sth->errorInfo () ) ."\n";
}
}
}
if($db_vendor == 'mysqli'){
$dbh = new mysqli($db_hostname,$db_username,$db_password,$db_catalog);
if ($dbh->connect_error) {
$e_message = 'Error 284: ('.$dbh->connect_errno .') '.$dbh->connect_error;
}
if($multi){
$result = $dbh->multi_query($sql);
if($dbh->errno){
$e_message = 'Error 303: '.$dbh->errno .": ".$dbh->error;
}
$dbh->close();
}else {
$stmt = $dbh->prepare($sql);
if($dbh->errno <>0){
die('SQL ERROR 315: '.$dbh->errno .": ".$dbh->error);
}
$stmt->execute();
if($dbh->errno){
$e_message = 'Error 322: '.$dbh->errno .": ".$dbh->error;
}
$stmt->close();
$dbh->close();
}
}
sleep ( 1 );
return $e_message;
}
if (isset ( $_POST ['install'] )) {
$debug = 0;
$error = 0;
$e_message = '';
$installed_error = 0;
$db_vendor = isset ( $_POST ['db_vendor'] ) ?$_POST ['db_vendor'] : '';
$clean = isset ( $_POST ['clean'] ) &&$_POST ['clean'] == 1 ?'DROP TABLE IF EXISTS fb_admin, fb_job_entries, fb_job_entries_tmp, fb_jobs, fb_demo, fb_images, fb_auth, fb_files, fb_comments, fb_states, fb_countries, fb_formblocks;': '';
$clean_mssql = isset ( $_POST ['clean'] ) &&$_POST ['clean'] == 1 ?'DROP TABLE fb_admin, fb_job_entries, fb_job_entries_tmp, fb_jobs, fb_demo, fb_images, fb_auth, fb_files, fb_comments, fb_states, fb_countries, fb_formblocks;': '';
$db_username = isset ( $_POST ['db_username'] ) ?$_POST ['db_username'] : '';
$db_password = isset ( $_POST ['db_password'] ) ?$_POST ['db_password'] : '';
$db_hostname = isset ( $_POST ['db_hostname'] ) ?$_POST ['db_hostname'] : '';
$db_mysql_socket = isset ( $_POST ['db_mysql_socket'] ) ?$_POST ['db_mysql_socket'] : '';
$db_mysql_port = isset ( $_POST ['db_mysql_port'] ) ?$_POST ['db_mysql_port'] : '';
$db_procedures = isset ( $_POST ['sql_procedures'] ) ?$_POST ['sql_procedures'] : '0';
$db_catalog = isset ( $_POST ['db_catalog'] ) ?$_POST ['db_catalog'] : '';
$password_salt = isset ( $_POST ['password_salt'] ) ?$_POST ['password_salt'] : '';
$ac_username = isset ( $_POST ['ac_username'] ) ?$_POST ['ac_username'] : '';
$ac_password = isset ( $_POST ['ac_password'] ) ?$_POST ['ac_password'] : '';
$ac_email = isset ( $_POST ['ac_email'] ) ?$_POST ['ac_email'] : '';
$ac_timezone = isset ( $_POST ['ac_timezone'] ) ?$_POST ['ac_timezone'] : '';
$ac_key = isset ( $_POST ['ac_key'] ) ?$_POST ['ac_key'] : '';
if ($db_vendor == '') {
$error = 1;
}
if ($db_username == '') {
$error = 1;
}
if ($db_password == '') {
$error = 1;
}
if ($db_hostname == '') {
$error = 1;
}
if ($db_catalog == '') {
$error = 1;
}
if ($password_salt == '') {
$error = 1;
}
if ($ac_username == '') {
$error = 1;
}
if ($ac_password == '') {
$error = 1;
}
if ($ac_email == '') {
$error = 1;
}
if ($ac_timezone == '') {
$error = 1;
}
if ($ac_key == '') {
$error = 1;
}
if ($error == 0) {
if (!version_compare ( PHP_VERSION,"5.1.4",">=")) {
die ( 'Install Error: PHP 5.1.4 or higher required!');
}
try {
if ($db_vendor == 'mysql') {
if (extension_loaded('pdo')) {
if (extension_loaded('pdo_mysql')) {
try {
$dsn = $db_vendor .":unix_socket=".$db_mysql_socket .";host=".$db_hostname .";dbname=".$db_catalog .";port={$db_mysql_port};";
$conn = new PDO ( $dsn,$db_username,$db_password );
}catch ( PDOException $e ) {
$conn = false;
$e_message .= 'ERROR 299: Could not connect to the MySQL Database. Please double check your Username, Password, Host, and if need be, MySQL Socket Path settings. Also be sure the Database has been created, and the database user has permission to access that database.';
$e_message .= '<br/><br/>SQL Debug Message: '.$e->getMessage();
$e_message .= '<br/><br/>SQL Debug Message: '.$e->getTraceAsString();
}
}else {
$conn = false;
$error = 1;
$e_message .= 'INSTALL ERROR 307: FormBoss Requires the PHP_PDO_MYSQL Extension. Please install this extension and run the installer again.<br/>';
}
}else {
$conn = false;
$error = 1;
$e_message .= 'INSTALL ERROR 314: FormBoss requires the PHP_PDO extension when MySQL Via PDO is selected For Database Vendor. Please install this extension and run the installer again.<br/>';
}
}
if(!function_exists('mysqli_error_bypass')){
function mysqli_error_bypass($errno,$errstr,$errfile,$errline){}
}
if($db_vendor == 'mysqli'){
if (extension_loaded('mysqli')) {
set_error_handler("mysqli_error_bypass");
try{
$conn = new mysqli($db_hostname,$db_username,$db_password,$db_catalog);
}catch(Exception $e){
}
restore_error_handler();
if (mysqli_connect_error()) {
$conn = false;
$e_message = 'ERROR 299: Could not connect to the MySQL Database. Please double check your Username, Password, Host, and if need be, MySQL Socket Path settings. Also be sure the Database has been created, and the database user has permission to access that database.';
$e_message .= '<br/><br/>SQL Debug Message: '.mysqli_connect_errno() .') '.mysqli_connect_error();
}
}else {
$conn = false;
$error = 1;
$e_message .= 'INSTALL ERROR 423: If Using MySQL via MySQLi for your Database Vendor, FormBoss Requires the MYSQLi Extension. Please install this extension and run the installer again. Alternativly, you can also try using the MySQL via PDO option.<br/>';
}
}
if ($db_vendor == 'mssql') {
if (extension_loaded('sqlsrv')) {
sqlsrv_configure ( "LogSubsystems",SQLSRV_LOG_SYSTEM_ALL );
sqlsrv_configure ( "LogSeverity",SQLSRV_LOG_SEVERITY_ALL );
$conn = sqlsrv_connect ( $db_hostname,array ('UID'=>$db_username,'PWD'=>$db_password,'Database'=>$db_catalog,'TraceOn'=>false,'TraceFile'=>'C:\sqlsrv_trace.txt') );
if ($conn == FALSE) {
$error = 1;
$e_message .= 'Error 324: Could not connect to the MSSQL Database. Please double check your Username, Password, and Host settings.';
print 'Connection failed! Below is a detailed debug report of the connection attempt:<br />';
print '<pre>'.print_r ( sqlsrv_errors (),true ) .'</pre>';
die ();
}
}else {
$conn = false;
$error = 1;
$e_message .= 'INSTALL ERROR 332: FormBoss Requires the SQL Server Extension (php_sqlsrv_ts.dll or php_sqlsrv.dll). Please install this extension and run the installer again.<br/>';
}
}
if ($conn) {
if ($db_vendor == 'mysql') {
$version = $conn->getAttribute ( constant ( "PDO::ATTR_SERVER_VERSION") );
$major = explode ( '.',$version );
if ($major [0] >= 5) {
$e_message .= '';
}else {
$error = 1;
$e_message .= 'Fatal Install Error: MySQL 5.0 or higher required. This should be an easy fix, as almost all hosting companies support MySQL 5 or higher.';
echo $e_message;
die ();
}
}
if($db_vendor == 'mysqli'){
$version = $conn->server_version;
$major = substr($version,0,1);
if ($major >= 5) {
$e_message .= '';
}else {
$error = 1;
$e_message .= 'Fatal Install Error: MySQL 5.0 or higher required. This should be an easy fix, as almost all hosting companies support MySQL 5 or higher.';
echo $e_message;
die ();
}
}
}else {
$error = 1;
}
}catch ( PDOException $e ) {
if ($debug) {
die ( "DB Error 354: ".$e->getTrace () .$e->getTraceAsString () ."<br/>");
}else {
$e_message .= 'Database driver not installed.';
}
}
if ($conn !== FALSE) {
if (version_compare ( PHP_VERSION,"5.1.4",">=")) {
switch ($db_vendor) {
case 'mysql':
$call = 'CALL ';
$backslash_escape = 0;
break;
case 'mysqli':
$call = 'CALL ';
$backslash_escape = 0;
break;
case 'mssql':
$call = 'EXECUTE ';
$backslash_escape = 1;
break;
}
$config_data = "<?php
\$app_version = '2.0';
// db
define('DB_TYPE', '{$db_vendor}'); // mysql = PDO :: mysqli = MySQLi :: mssql = SQL Server
define('DB_HOST', '{$db_hostname}');
define('MYSQL_SOCKET', '{$db_mysql_socket}'); // E.G. /tmp/mysql.sock or /var/run/mysqld/mysqld.sock
define('MYSQL_PORT', '{$db_mysql_port}'); // E.G. 3306 || This can be blank in most cases
define('DB_USER', '{$db_username}');
define('DB_PASS', '{$db_password}');
define('DB_CATALOG', '{$db_catalog}');
// Build 612 - Lets us define if our MySQL server allows for ESCAPE CHARACTERS
// Leaving as 0 means your job code has all back slashes escaped, this the default for MySQL.
// Setting to 1 means your MySQL server has an sql_mode of NO_BACKSLASH_ESCAPES, or you are running MSSQL.
define('NO_BACKSLASH_ESCAPES', '{$backslash_escape}');
// Procedures
define('EXECUTE_STRING', '{$call}'); // 'EXECUTE ' for MSSQL :: 'CALL ' for MySQL
define('USE_PROCEDURES', '{$db_procedures}'); // 0 or 1
define('SALT', '{$password_salt}');
// app
define('DEBUG', '0');
define('DEBUG_DETAIL', '0');
define('USER_MODE', 'DATABASE'); // DATABASE or FLATFILE <- DEPRICIATED DO NOT CHANGE FROM DATABASE
// need to change your timezone? http://us2.php.net/timezones
define('TIMEZONE', '{$ac_timezone}');
// Build 640 - Compatibility Change
if(function_exists('date_default_timezone_set')) {
date_default_timezone_set(TIMEZONE);
} else {
ini_set('date.timezone', TIMEZONE);
}
// Build 624 - Set Directory Write Permission Level - Not Needed On Windows
define('DIRECTORY_MOD', 0755); // Octal based UNIX permission level e.g. 0755, 0777
// Build 624 - Set File Write Permission Level - Not Needed On Windows
define('FILE_MOD', 0644); // Octal based UNIX permission level e.g. 0644, 0664
// Build 633
define('ENCODE_PW', 1);
// Build 700 - Add the values below to block that module from loading into the editor.
\$excluded_form_modules = array(''); // Use: ecomm to block the ecomm module from loading in the editor.
\$excluded_confirmation_modules = array(''); // Use: confirm-ecomm to block the ecomm confirmation module.
// UPDATES
// 638 :: By Default
?>";
$config_move_data = "<?php
// constants
\$app_version = '2.0';
// Change to 1 to see debug info if you run into problems executing your query
// (may need to look at html page source to see error).
if(!isset(\$debug)) { \$debug = 0; }
\$db_type = '{$db_vendor}'; // mysql = PDO :: mysqli = MySQLi :: mssql = SQL Server
\$db_host = '{$db_hostname}';
\$mysql_socket = '{$db_mysql_socket}'; // E.G. /tmp/mysql.sock or /var/run/mysqld/mysqld.sock
\$mysql_port = '{$db_mysql_port}'; // E.G. 3306 || This can be blank in most cases
\$use_procedures = '{$db_procedures}'; // 0 or 1
\$db_user = '{$db_username}';
\$db_pass = '{$db_password}';
\$db_catalog = '{$db_catalog}';
// need to change your timezone? http://us2.php.net/timezones
if(!defined('TIMEZONE')) { define('TIMEZONE', '{$ac_timezone}'); }
// Build 640 - Compatibility Change
if(function_exists('date_default_timezone_set')) {
date_default_timezone_set(TIMEZONE);
} else {
ini_set('date.timezone', TIMEZONE);
}
// Build 624 - Set Directory Write Permission Level - Not Needed On Windows
if(!defined('DIRECTORY_MOD')) { define('DIRECTORY_MOD', 0755); } // Octal based UNIX permission level e.g. 0755, 0777
// Build 624 - Set File Write Permission Level - Not Needed On Windows
if(!defined('FILE_MOD')) { define('FILE_MOD', 0644); } // Octal based UNIX permission level e.g. 0644, 0664
?>";
@delete_directory ( 'output/test/');
@chmod ( 'app/config.php',0755 );
@chmod ( 'app/movefiles/config.php',0755 );
@mkdir ( 'output/test/',0755 );
if (test_write_output () &&test_write_xml ()) {
if (@!file_put_contents ( 'app/config.php',$config_data )) {
$error = 1;
$e_message .= 'Could not write to app/config.php. Check permissions and try again!';
}
if (@!file_put_contents ( 'app/movefiles/config.php',$config_move_data )) {
$error = 1;
$e_message .= "\nCould not write to app/movefiles/config.php. Check permissions and try again!";
}
if(strlen($ac_password) >20){
$error = 1;
$e_message .= "\nYour User Password Cannot Contain More Than 20 Characters.<br/>Please shorten your password and try again.";
}
$user_password = strip_tags ( md5 ( $password_salt .$ac_password ) );
$crypt = new encryption_class();
$key = 'H@Sju45534Be!ssjgh';
$password = $ac_password;
$pswdlen = 16;
$adj = 1.75;
$crypt->setAdjustment($adj);
$mod = 3;
$crypt->setModulus($mod);
$encrypt_result = $crypt->encrypt($key,$password,$pswdlen);
$enc_errors = $crypt->errors;
$ac_password_encrypted = $encrypt_result;
if(count($enc_errors) != 0){
$error = 1;
$e_message .= "\nYour User Password contains invalid characters. You cannot use the Backslash (\\), Single Quote ('), or Double Quote (\"). Please remove or replace any of these characters and try again.";
}
if(substr_count($password_salt,'\'') != 0 ||substr_count($password_salt,'\\') != 0 ||substr_count($password_salt,'"') != 0){
$error = 1;
$e_message .= "\nYour Password Salt Value contains invalid characters. You cannot use the Backslash (\\), Single Quote ('), or Double Quote (\"). Please remove or replace any of these characters and try again.";
}
if ($db_vendor == 'mysql'||$db_vendor == 'mysqli') {
if($clean != ''){
$sql = "
{$clean}";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
}
$sql = "
CREATE TABLE `fb_admin` (
`user_id` INT(11) NOT NULL AUTO_INCREMENT,
`user_name` VARCHAR(20) DEFAULT NULL,
`user_pass` VARCHAR(50) DEFAULT NULL,
`pwd` VARCHAR(100) DEFAULT NULL,
`user_email` VARCHAR(50) DEFAULT NULL,
`user_privilege` INT(11) DEFAULT '0',
PRIMARY KEY (`user_id`)
) ENGINE=INNODB CHARSET=utf8 COLLATE utf8_general_ci;";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE `fb_auth`(
id INT (11) NOT NULL AUTO_INCREMENT,
auth VARCHAR (255) DEFAULT NULL,
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci;";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE `fb_jobs` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`job_name` VARCHAR(50) DEFAULT NULL,
`created` VARCHAR(12) DEFAULT NULL,
`created_ts` DATETIME DEFAULT NULL,
`last_edit` VARCHAR(12) DEFAULT NULL,
`last_edit_ts` DATETIME DEFAULT NULL,
`user_id` INT(11) DEFAULT NULL,
`job_xml` LONGTEXT,
PRIMARY KEY (`id`),
INDEX IDX_job_name (`job_name`),
INDEX IDX_user_id (`user_id`)
) ENGINE=INNODB CHARSET=utf8 COLLATE utf8_general_ci;";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE `fb_job_entries` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`job_id` INT(11) NOT NULL,
`ts` INT(11) DEFAULT NULL,
`name` VARCHAR(255) DEFAULT NULL,
`label` VARCHAR (255) DEFAULT NULL,
`entry_value` TEXT,
`file_data` LONGBLOB,
`file_mime` VARCHAR(50) DEFAULT NULL,
`file_name` VARCHAR(255) DEFAULT NULL,
`entry_key` VARCHAR(50) DEFAULT NULL,
`entry_type` VARCHAR(20) DEFAULT NULL,
`remote_ip` VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX index1 USING BTREE (`job_id`),
INDEX IDX_ts USING BTREE (`ts`),
INDEX IDX_entry_key USING BTREE (`entry_key`),
CONSTRAINT `fb_job_entries_FK1` FOREIGN KEY (`job_id`) REFERENCES `fb_jobs` (`id`) ON DELETE CASCADE
) ENGINE=INNODB CHARSET=utf8 COLLATE utf8_general_ci;
";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE fb_job_entries_tmp(
id INT(11) NOT NULL AUTO_INCREMENT,
job_id INT(11) NOT NULL,
ts INT(11) DEFAULT NULL,
name VARCHAR(255) DEFAULT NULL,
label VARCHAR(255) DEFAULT NULL,
entry_value TEXT DEFAULT NULL,
file_data LONGBLOB DEFAULT NULL,
file_mime VARCHAR(50) DEFAULT NULL,
file_name VARCHAR(255) DEFAULT NULL,
entry_key VARCHAR(50) DEFAULT NULL,
fb_entry_id VARCHAR(255) DEFAULT NULL,
entry_type VARCHAR(20) DEFAULT NULL,
remote_ip VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (id),
INDEX IDX_entry_key (entry_key),
INDEX IDX_ts (ts),
INDEX index1 (job_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci;";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE fb_demo(
id INT (11) NOT NULL AUTO_INCREMENT,
name VARCHAR (50) DEFAULT NULL,
age INT (11) DEFAULT NULL,
email VARCHAR (50) DEFAULT NULL,
pwd BLOB DEFAULT NULL,
image LONGBLOB DEFAULT NULL,
ts DATETIME DEFAULT NULL,
bigtext LONGTEXT DEFAULT NULL,
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci;";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE fb_images(
image_id INT (11) NOT NULL AUTO_INCREMENT,
entry_id INT (11) DEFAULT NULL,
image_caption LONGTEXT DEFAULT NULL,
image_name VARCHAR (100) DEFAULT NULL,
image_mime VARCHAR (40) DEFAULT NULL,
image_size INT (11) DEFAULT NULL,
image_data LONGBLOB DEFAULT NULL,
image_thumb LONGBLOB DEFAULT NULL,
PRIMARY KEY (image_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci;";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE fb_files(
file_id INT (11) NOT NULL AUTO_INCREMENT,
entry_id INT (11) DEFAULT NULL,
file_caption LONGTEXT DEFAULT NULL,
file_name VARCHAR (100) DEFAULT NULL,
file_mime VARCHAR (40) DEFAULT NULL,
file_size INT (11) DEFAULT NULL,
file_data LONGBLOB DEFAULT NULL,
file_thumb LONGBLOB DEFAULT NULL,
PRIMARY KEY (file_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 30720
CHARACTER SET utf8
COLLATE utf8_general_ci;";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE fb_formblocks(
id INT(11) NOT NULL AUTO_INCREMENT,
user_id INT(11) DEFAULT NULL,
name VARCHAR(255) DEFAULT NULL,
category VARCHAR(255) DEFAULT NULL,
description VARCHAR(255) DEFAULT NULL,
layout VARCHAR(255) DEFAULT NULL,
pagetype INT(11) DEFAULT NULL,
content LONGTEXT DEFAULT NULL,
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 6553
CHARACTER SET utf8
COLLATE utf8_general_ci;";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE fb_comments(
id INT (11) NOT NULL AUTO_INCREMENT,
ts DATETIME DEFAULT NULL,
name VARCHAR (50) DEFAULT NULL,
email VARCHAR (100) DEFAULT NULL,
website VARCHAR (100) DEFAULT NULL,
`comment` LONGTEXT DEFAULT NULL,
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci;";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE fb_states(
state_id SMALLINT(6) NOT NULL AUTO_INCREMENT COMMENT 'PK: Unique state ID',
state VARCHAR(32) NOT NULL COMMENT 'State name with first letter capital',
state_abbr VARCHAR(8) DEFAULT NULL COMMENT 'Optional state abbreviation (US is 2 capital letters)',
PRIMARY KEY (state_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 321
CHARACTER SET utf8
COLLATE utf8_general_ci;";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "INSERT INTO fb_states VALUES
(1, 'Alabama', 'AL'),
(2, 'Alaska', 'AK'),
(3, 'Arizona', 'AZ'),
(4, 'Arkansas', 'AR'),
(5, 'California', 'CA'),
(6, 'Colorado', 'CO'),
(7, 'Connecticut', 'CT'),
(8, 'Delaware', 'DE'),
(9, 'District of Columbia', 'DC'),
(10, 'Florida', 'FL'),
(11, 'Georgia', 'GA'),
(12, 'Hawaii', 'HI'),
(13, 'Idaho', 'ID'),
(14, 'Illinois', 'IL'),
(15, 'Indiana', 'IN'),
(16, 'Iowa', 'IA'),
(17, 'Kansas', 'KS'),
(18, 'Kentucky', 'KY'),
(19, 'Louisiana', 'LA'),
(20, 'Maine', 'ME'),
(21, 'Maryland', 'MD'),
(22, 'Massachusetts', 'MA'),
(23, 'Michigan', 'MI'),
(24, 'Minnesota', 'MN'),
(25, 'Mississippi', 'MS'),
(26, 'Missouri', 'MO'),
(27, 'Montana', 'MT'),
(28, 'Nebraska', 'NE'),
(29, 'Nevada', 'NV'),
(30, 'New Hampshire', 'NH'),
(31, 'New Jersey', 'NJ'),
(32, 'New Mexico', 'NM'),
(33, 'New York', 'NY'),
(34, 'North Carolina', 'NC'),
(35, 'North Dakota', 'ND'),
(36, 'Ohio', 'OH'),
(37, 'Oklahoma', 'OK'),
(38, 'Oregon', 'OR'),
(39, 'Pennsylvania', 'PA'),
(40, 'Rhode Island', 'RI'),
(41, 'South Carolina', 'SC'),
(42, 'South Dakota', 'SD'),
(43, 'Tennessee', 'TN'),
(44, 'Texas', 'TX'),
(45, 'Utah', 'UT'),
(46, 'Vermont', 'VT'),
(47, 'Virginia', 'VA'),
(48, 'Washington', 'WA'),
(49, 'West Virginia', 'WV'),
(50, 'Wisconsin', 'WI'),
(51, 'Wyoming', 'WY');";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "CREATE TABLE fb_countries (
iso CHAR(2) NOT NULL PRIMARY KEY,
name VARCHAR(80) NOT NULL,
printable_name VARCHAR(80) NOT NULL,
iso3 CHAR(3),
numcode SMALLINT
);";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "INSERT INTO fb_countries VALUES
('AF','AFGHANISTAN','Afghanistan','AFG','004')
,('AL','ALBANIA','Albania','ALB','008')
,('DZ','ALGERIA','Algeria','DZA','012')
,('AS','AMERICAN SAMOA','American Samoa','ASM','016')
,('AD','ANDORRA','Andorra','AND','020')
,('AO','ANGOLA','Angola','AGO','024')
,('AI','ANGUILLA','Anguilla','AIA','660')
,('AQ','ANTARCTICA','Antarctica',NULL,NULL)
,('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028')
,('AR','ARGENTINA','Argentina','ARG','032')
,('AM','ARMENIA','Armenia','ARM','051')
,('AW','ARUBA','Aruba','ABW','533')
,('AU','AUSTRALIA','Australia','AUS','036')
,('AT','AUSTRIA','Austria','AUT','040')
,('AZ','AZERBAIJAN','Azerbaijan','AZE','031')
,('BS','BAHAMAS','Bahamas','BHS','044')
,('BH','BAHRAIN','Bahrain','BHR','048')
,('BD','BANGLADESH','Bangladesh','BGD','050')
,('BB','BARBADOS','Barbados','BRB','052')
,('BY','BELARUS','Belarus','BLR','112')
,('BE','BELGIUM','Belgium','BEL','056')
,('BZ','BELIZE','Belize','BLZ','084')
,('BJ','BENIN','Benin','BEN','204')
,('BM','BERMUDA','Bermuda','BMU','060')
,('BT','BHUTAN','Bhutan','BTN','064')
,('BO','BOLIVIA','Bolivia','BOL','068')
,('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070')
,('BW','BOTSWANA','Botswana','BWA','072')
,('BV','BOUVET ISLAND','Bouvet Island',NULL,NULL)
,('BR','BRAZIL','Brazil','BRA','076')
,('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL)
,('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096')
,('BG','BULGARIA','Bulgaria','BGR','100')
,('BF','BURKINA FASO','Burkina Faso','BFA','854')
,('BI','BURUNDI','Burundi','BDI','108')
,('KH','CAMBODIA','Cambodia','KHM','116')
,('CM','CAMEROON','Cameroon','CMR','120')
,('CA','CANADA','Canada','CAN','124')
,('CV','CAPE VERDE','Cape Verde','CPV','132')
,('KY','CAYMAN ISLANDS','Cayman Islands','CYM','136')
,('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140')
,('TD','CHAD','Chad','TCD','148')
,('CL','CHILE','Chile','CHL','152')
,('CN','CHINA','China','CHN','156')
,('CX','CHRISTMAS ISLAND','Christmas Island',NULL,NULL)
,('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL)
,('CO','COLOMBIA','Colombia','COL','170')
,('KM','COMOROS','Comoros','COM','174')
,('CG','CONGO','Congo','COG','178')
,('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180')
,('CK','COOK ISLANDS','Cook Islands','COK','184')
,('CR','COSTA RICA','Costa Rica','CRI','188')
,('CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384')
,('HR','CROATIA','Croatia','HRV','191')
,('CU','CUBA','Cuba','CUB','192')
,('CY','CYPRUS','Cyprus','CYP','196')
,('CZ','CZECH REPUBLIC','Czech Republic','CZE','203')
,('DK','DENMARK','Denmark','DNK','208')
,('DJ','DJIBOUTI','Djibouti','DJI','262')
,('DM','DOMINICA','Dominica','DMA','212')
,('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214')
,('EC','ECUADOR','Ecuador','ECU','218')
,('EG','EGYPT','Egypt','EGY','818')
,('SV','EL SALVADOR','El Salvador','SLV','222')
,('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226')
,('ER','ERITREA','Eritrea','ERI','232')
,('EE','ESTONIA','Estonia','EST','233')
,('ET','ETHIOPIA','Ethiopia','ETH','231')
,('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238')
,('FO','FAROE ISLANDS','Faroe Islands','FRO','234')
,('FJ','FIJI','Fiji','FJI','242')
,('FI','FINLAND','Finland','FIN','246')
,('FR','FRANCE','France','FRA','250')
,('GF','FRENCH GUIANA','French Guiana','GUF','254')
,('PF','FRENCH POLYNESIA','French Polynesia','PYF','258')
,('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories',NULL,NULL)
,('GA','GABON','Gabon','GAB','266')
,('GM','GAMBIA','Gambia','GMB','270')
,('GE','GEORGIA','Georgia','GEO','268')
,('DE','GERMANY','Germany','DEU','276')
,('GH','GHANA','Ghana','GHA','288')
,('GI','GIBRALTAR','Gibraltar','GIB','292')
,('GR','GREECE','Greece','GRC','300')
,('GL','GREENLAND','Greenland','GRL','304')
,('GD','GRENADA','Grenada','GRD','308')
,('GP','GUADELOUPE','Guadeloupe','GLP','312')
,('GU','GUAM','Guam','GUM','316')
,('GT','GUATEMALA','Guatemala','GTM','320')
,('GN','GUINEA','Guinea','GIN','324')
,('GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624')
,('GY','GUYANA','Guyana','GUY','328')
,('HT','HAITI','Haiti','HTI','332')
,('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands',NULL,NULL)
,('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336')
,('HN','HONDURAS','Honduras','HND','340')
,('HK','HONG KONG','Hong Kong','HKG','344')
,('HU','HUNGARY','Hungary','HUN','348')
,('IS','ICELAND','Iceland','ISL','352')
,('IN','INDIA','India','IND','356')
,('ID','INDONESIA','Indonesia','IDN','360')
,('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364')
,('IQ','IRAQ','Iraq','IRQ','368')
,('IE','IRELAND','Ireland','IRL','372')
,('IL','ISRAEL','Israel','ISR','376')
,('IT','ITALY','Italy','ITA','380')
,('JM','JAMAICA','Jamaica','JAM','388')
,('JP','JAPAN','Japan','JPN','392')
,('JO','JORDAN','Jordan','JOR','400')
,('KZ','KAZAKHSTAN','Kazakhstan','KAZ','398')
,('KE','KENYA','Kenya','KEN','404')
,('KI','KIRIBATI','Kiribati','KIR','296')
,('KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408')
,('KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410')
,('KW','KUWAIT','Kuwait','KWT','414')
,('KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417')
,('LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418')
,('LV','LATVIA','Latvia','LVA','428')
,('LB','LEBANON','Lebanon','LBN','422')
,('LS','LESOTHO','Lesotho','LSO','426')
,('LR','LIBERIA','Liberia','LBR','430')
,('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434')
,('LI','LIECHTENSTEIN','Liechtenstein','LIE','438')
,('LT','LITHUANIA','Lithuania','LTU','440')
,('LU','LUXEMBOURG','Luxembourg','LUX','442')
,('MO','MACAO','Macao','MAC','446')
,('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807')
,('MG','MADAGASCAR','Madagascar','MDG','450')
,('MW','MALAWI','Malawi','MWI','454')
,('MY','MALAYSIA','Malaysia','MYS','458')
,('MV','MALDIVES','Maldives','MDV','462')
,('ML','MALI','Mali','MLI','466')
,('MT','MALTA','Malta','MLT','470')
,('MH','MARSHALL ISLANDS','Marshall Islands','MHL','584')
,('MQ','MARTINIQUE','Martinique','MTQ','474')
,('MR','MAURITANIA','Mauritania','MRT','478')
,('MU','MAURITIUS','Mauritius','MUS','480')
,('YT','MAYOTTE','Mayotte',NULL,NULL)
,('MX','MEXICO','Mexico','MEX','484')
,('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583')
,('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498')
,('MC','MONACO','Monaco','MCO','492')
,('MN','MONGOLIA','Mongolia','MNG','496')
,('MS','MONTSERRAT','Montserrat','MSR','500')
,('MA','MOROCCO','Morocco','MAR','504')
,('MZ','MOZAMBIQUE','Mozambique','MOZ','508')
,('MM','MYANMAR','Myanmar','MMR','104')
,('NA','NAMIBIA','Namibia','NAM','516')
,('NR','NAURU','Nauru','NRU','520')
,('NP','NEPAL','Nepal','NPL','524')
,('NL','NETHERLANDS','Netherlands','NLD','528')
,('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530')
,('NC','NEW CALEDONIA','New Caledonia','NCL','540')
,('NZ','NEW ZEALAND','New Zealand','NZL','554')
,('NI','NICARAGUA','Nicaragua','NIC','558')
,('NE','NIGER','Niger','NER','562')
,('NG','NIGERIA','Nigeria','NGA','566')
,('NU','NIUE','Niue','NIU','570')
,('NF','NORFOLK ISLAND','Norfolk Island','NFK','574')
,('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580')
,('NO','NORWAY','Norway','NOR','578')
,('OM','OMAN','Oman','OMN','512')
,('PK','PAKISTAN','Pakistan','PAK','586')
,('PW','PALAU','Palau','PLW','585')
,('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied',NULL,NULL)
,('PA','PANAMA','Panama','PAN','591')
,('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598')
,('PY','PARAGUAY','Paraguay','PRY','600')
,('PE','PERU','Peru','PER','604')
,('PH','PHILIPPINES','Philippines','PHL','608')
,('PN','PITCAIRN','Pitcairn','PCN','612')
,('PL','POLAND','Poland','POL','616')
,('PT','PORTUGAL','Portugal','PRT','620')
,('PR','PUERTO RICO','Puerto Rico','PRI','630')
,('QA','QATAR','Qatar','QAT','634')
,('RE','REUNION','Reunion','REU','638')
,('RO','ROMANIA','Romania','ROM','642')
,('RU','RUSSIAN FEDERATION','Russian Federation','RUS','643')
,('RW','RWANDA','Rwanda','RWA','646')
,('SH','SAINT HELENA','Saint Helena','SHN','654')
,('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659')
,('LC','SAINT LUCIA','Saint Lucia','LCA','662')
,('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666')
,('VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670')
,('WS','SAMOA','Samoa','WSM','882')
,('SM','SAN MARINO','San Marino','SMR','674')
,('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678')
,('SA','SAUDI ARABIA','Saudi Arabia','SAU','682')
,('SN','SENEGAL','Senegal','SEN','686')
,('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro',NULL,NULL)
,('SC','SEYCHELLES','Seychelles','SYC','690')
,('SL','SIERRA LEONE','Sierra Leone','SLE','694')
,('SG','SINGAPORE','Singapore','SGP','702')
,('SK','SLOVAKIA','Slovakia','SVK','703')
,('SI','SLOVENIA','Slovenia','SVN','705')
,('SB','SOLOMON ISLANDS','Solomon Islands','SLB','090')
,('SO','SOMALIA','Somalia','SOM','706')
,('ZA','SOUTH AFRICA','South Africa','ZAF','710')
,('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL)
,('ES','SPAIN','Spain','ESP','724')
,('LK','SRI LANKA','Sri Lanka','LKA','144')
,('SD','SUDAN','Sudan','SDN','736')
,('SR','SURINAME','Suriname','SUR','740')
,('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744')
,('SZ','SWAZILAND','Swaziland','SWZ','748')
,('SE','SWEDEN','Sweden','SWE','752')
,('CH','SWITZERLAND','Switzerland','CHE','756')
,('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760')
,('TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158')
,('TJ','TAJIKISTAN','Tajikistan','TJK','762')
,('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834')
,('TH','THAILAND','Thailand','THA','764')
,('TL','TIMOR-LESTE','Timor-Leste',NULL,NULL)
,('TG','TOGO','Togo','TGO','768')
,('TK','TOKELAU','Tokelau','TKL','772')
,('TO','TONGA','Tonga','TON','776')
,('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780')
,('TN','TUNISIA','Tunisia','TUN','788')
,('TR','TURKEY','Turkey','TUR','792')
,('TM','TURKMENISTAN','Turkmenistan','TKM','795')
,('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796')
,('TV','TUVALU','Tuvalu','TUV','798')
,('UG','UGANDA','Uganda','UGA','800')
,('UA','UKRAINE','Ukraine','UKR','804')
,('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784')
,('GB','UNITED KINGDOM','United Kingdom','GBR','826')
,('US','UNITED STATES','United States','USA','840')
,('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands',NULL,NULL)
,('UY','URUGUAY','Uruguay','URY','858')
,('UZ','UZBEKISTAN','Uzbekistan','UZB','860')
,('VU','VANUATU','Vanuatu','VUT','548')
,('VE','VENEZUELA','Venezuela','VEN','862')
,('VN','VIET NAM','Viet Nam','VNM','704')
,('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092')
,('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850')
,('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876')
,('EH','WESTERN SAHARA','Western Sahara','ESH','732')
,('YE','YEMEN','Yemen','YEM','887')
,('ZM','ZAMBIA','Zambia','ZMB','894')
,('ZW','ZIMBABWE','Zimbabwe','ZWE','716');";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$installed_error = 1;
}
$sql = "DROP PROCEDURE IF EXISTS `fb_add_user`;
CREATE DEFINER=CURRENT_USER PROCEDURE `fb_add_user`(IN in_user_name VARCHAR(20), IN in_user_email VARCHAR(50), IN in_user_pass VARCHAR(50), IN in_pwd VARCHAR(20), IN in_user_privilege INT)
BEGIN
SET @message = '';
SELECT COUNT(user_name) FROM fb_admin WHERE user_name = in_user_name INTO @n_ct;
SELECT COUNT(user_email) FROM fb_admin WHERE user_email = in_user_email INTO @e_ct;
IF @n_ct <> 0 AND @e_ct <> 0 THEN
SELECT 'Notice: User Name and Email already exist.' INTO @message;
ELSEIF @n_ct <> 0 THEN
SELECT 'Notice: User Name already exists.' INTO @message;
ELSEIF @e_ct <> 0 THEN
SELECT 'Notice: User Email already exists.' INTO @message;
END IF;
IF @message = '' THEN
INSERT INTO fb_admin (user_name, user_pass, pwd, user_email, user_privilege)
VALUES (in_user_name, in_user_pass, in_pwd, in_user_email, in_user_privilege);
SELECT 'User Added.' INTO @message;
SELECT @message AS e_message;
ELSE
SELECT @message AS e_message;
END IF;
END;
DROP PROCEDURE IF EXISTS `fb_admin_get_authentication`;
CREATE DEFINER=CURRENT_USER PROCEDURE `fb_admin_get_authentication`(IN in_user_name VARCHAR(20), IN in_user_pass VARCHAR(50))
BEGIN
SELECT user_name, user_id, user_email, user_privilege, fb_auth.auth FROM fb_admin, fb_auth
WHERE user_name = in_user_name AND user_pass = in_user_pass;
END;
DROP PROCEDURE IF EXISTS `fb_admin_get_password_reminder`;
CREATE DEFINER=CURRENT_USER PROCEDURE `fb_admin_get_password_reminder`(IN in_user_name VARCHAR(20), IN in_user_email VARCHAR(50))
BEGIN
SELECT user_name, user_email, pwd FROM fb_admin
WHERE user_name = in_user_name AND user_email = in_user_email;
END;
DROP PROCEDURE IF EXISTS fb_insert_entry;
CREATE DEFINER=CURRENT_USER PROCEDURE `fb_insert_entry`(IN in_entry_key VARCHAR(50), IN in_job_id INT, IN in_name VARCHAR(255), IN in_label VARCHAR(255), IN in_value TEXT, IN in_ts INT, IN in_jobname VARCHAR(50), IN in_remote_ip VARCHAR(50))
BEGIN
-- create job row if not exists
DECLARE ct INT;
SELECT COUNT(id) INTO ct FROM fb_jobs WHERE id = in_job_id;
IF ct = 0 THEN
INSERT INTO fb_jobs (id, job_name) VALUES (in_job_id, in_jobname);
END IF;
INSERT INTO fb_job_entries(entry_key, job_id, ts, name, label, entry_value, remote_ip)
VALUES (
in_entry_key,
in_job_id,
in_ts,
in_name,
in_label,
in_value,
in_remote_ip
);
END;
DROP PROCEDURE IF EXISTS `fb_insert_file`;
CREATE DEFINER=CURRENT_USER PROCEDURE `fb_insert_file`(IN in_entry_key VARCHAR(50), IN in_job_id INT, IN in_name VARCHAR(255), IN in_value LONGBLOB, IN in_file_mime VARCHAR(50), IN in_ts INT, IN in_jobname VARCHAR(50), IN in_field_name VARCHAR(255), IN in_label VARCHAR(255))
BEGIN
-- create job row if not exists
DECLARE ct INT;
DECLARE last_id INT;
DECLARE qs VARCHAR(255);
SELECT COUNT(id) INTO ct FROM fb_jobs WHERE id = in_job_id;
IF ct = 0 THEN
INSERT INTO fb_jobs (id, job_name) VALUES (in_job_id, in_jobname);
END IF;
INSERT INTO fb_job_entries(job_id, entry_key) VALUES (in_job_id, in_entry_key);
SET last_id = LAST_INSERT_ID();
SET qs = CONCAT('lib/get_file.php?id=', last_id);
UPDATE fb_job_entries
SET
ts = in_ts,
name = in_field_name,
label = in_label,
entry_value = qs,
file_data = in_value,
file_mime = in_file_mime,
file_name = in_name,
entry_type = 'File'
WHERE id = last_id;
END;
DROP PROCEDURE IF EXISTS `fb_insert_image`;
CREATE DEFINER=CURRENT_USER PROCEDURE `fb_insert_image`(IN in_entry_key VARCHAR(50), IN in_job_id INT, IN in_name VARCHAR(255), IN in_value LONGBLOB, IN in_file_mime VARCHAR(50), IN in_ts INT, IN in_jobname VARCHAR(50), IN in_field_name VARCHAR(255), IN in_label VARCHAR(255))
BEGIN
-- create job row if not exists
DECLARE ct INT;
DECLARE last_id INT;
DECLARE qs VARCHAR(255);
SELECT COUNT(id) INTO ct FROM fb_jobs WHERE id = in_job_id;
IF ct = 0 THEN
INSERT INTO fb_jobs (id, job_name) VALUES (in_job_id, in_jobname);
END IF;
INSERT INTO fb_job_entries(job_id, entry_key) VALUES (in_job_id, in_entry_key);
SET last_id = LAST_INSERT_ID();
SET qs = CONCAT('lib/get_image.php?id=', last_id);
UPDATE fb_job_entries
SET
ts = in_ts,
name = in_field_name,
label = in_label,
entry_value = qs,
file_data = in_value,
file_mime = in_file_mime,
file_name = in_name,
entry_type = 'Image'
WHERE id = last_id;
END;
DROP PROCEDURE IF EXISTS `fb_get_file`;
CREATE DEFINER=CURRENT_USER PROCEDURE `fb_get_file`(IN in_id INT)
BEGIN
SELECT file_data, file_mime, file_name FROM fb_job_entries WHERE id = in_id;
END;
DROP PROCEDURE IF EXISTS `fb_get_image`;
CREATE DEFINER=CURRENT_USER PROCEDURE `fb_get_image`(IN in_id INT)
BEGIN
SELECT file_data, file_mime, file_name FROM fb_job_entries WHERE id = in_id;
END;
DROP PROCEDURE IF EXISTS `fb_update_login`;
CREATE DEFINER=CURRENT_USER PROCEDURE `fb_update_login`(IN in_user_id INT,
IN in_user_name VARCHAR(20),
IN in_user_email VARCHAR(50),
IN in_user_pass VARCHAR(50),
IN in_pwd VARCHAR(20))
BEGIN
SET @message = '';
SELECT COUNT(user_name) FROM fb_admin WHERE user_name = in_user_name INTO @n_ct;
SELECT COUNT(user_email) FROM fb_admin WHERE user_email = in_user_email INTO @e_ct;
IF in_user_pass = 'null'
THEN
IF @n_ct = 0
THEN
UPDATE fb_admin
SET user_name = in_user_name
WHERE user_id = in_user_id;
END IF;
IF @e_ct = 0
THEN
UPDATE fb_admin
SET user_email = in_user_email
WHERE user_id = in_user_id;
END IF;
IF @n_ct <> 0 AND @e_ct <> 0 THEN
SELECT 'Notice: User name and email already exist and were not changed.' INTO @message;
ELSEIF @n_ct <> 0 THEN
SELECT 'Notice: User name already exists and was not changed.' INTO @message;
ELSEIF @e_ct <> 0 THEN
SELECT 'Notice: User email already exists and was not changed.' INTO @message;
END IF;
ELSE
UPDATE fb_admin
SET user_pass = in_user_pass,
pwd = in_pwd
WHERE user_id = in_user_id;
SELECT 'Your password has been changed.' INTO @message;
END IF;
SELECT @message AS e_message;
END;
";
if($db_procedures == 1){
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port,true);
if($val != ''){
$error = 1;
$e_message .= "<br/>Error 1081: Stored Procedure Creation Error: \n";
}
sleep ( 2 );
}
if($db_procedures == 1){
$sql = "call fb_get_file(1);";
$val = execute_mysql_sql($db_vendor,$db_mysql_socket,$db_hostname,$db_catalog,$db_username,$db_password,$sql,$db_mysql_port);
if($val != ''){
$error = 1;
$e_message .= "<br/><br/>ERROR 802: The installer could not create and/or properly execute the MySQL stored procedures! Please make sure the Database user {$db_username} has: CREATE ROUTINE ALTER ROUTINE and EXECUTE privileges. You may also want to make sure the FormBoss database tables were successfully created. <br/>Please resolve this error and click the Install button again.";
}
}
?> |
ZeroBytes |
|
Discussions
Tools
Content
Info
Membership:
Latest: 
New Today: 0
New Yesterday: 0
Overall: 9144
People Online:
Visitors: 96
Members: 0
Total: 96
