function getDataListName($type,$code)
{
global $db;
global $GLOBAL_CONFIG;
$query = "SELECT DETAIL_NAME FROM {$GLOBAL_CONFIG['DB_TITLE']}_datalist WHERE TYPE = '{$type}' AND CODE = '{$code}' LIMIT 0,1";
$res = $db->sql_query($query);
if ($datalist = $db->sql_fetchrow($res))
{
return $datalist['DETAIL_NAME'];
}
else
{
return false;
}
}
function listDataListAsRadio($id,$type,$separator="
")
{
global $db;
global $GLOBAL_CONFIG;
$query = "SELECT * FROM {$GLOBAL_CONFIG['DB_TITLE']}_datalist WHERE TYPE = '{$type}' ORDER BY PRIORITY ASC";
$res = $db->sql_query($query);
$output = "";
$i = 0;
while ($datalist = $db->sql_fetchrow($res))
{
$output .= ($i > 0) ? $separator : "";
$output .= " ";
$output .= "\r\n";
++$i;
}
return $output;
}
function listDataListAsOption($id,$type)
{
global $db;
global $GLOBAL_CONFIG;
$query = "SELECT * FROM {$GLOBAL_CONFIG['DB_TITLE']}_datalist WHERE TYPE = '{$type}' ORDER BY PRIORITY ASC";
$res = $db->sql_query($query);
$output = "";
$i = 0;
while ($datalist = $db->sql_fetchrow($res))
{
$output .= ($i > 0) ? $separator : "";
$output .= "\r\n";
++$i;
}
return $output;
}
function listDataListIdAsJsArray($id,$type)
{
global $db;
global $GLOBAL_CONFIG;
$query = "SELECT * FROM {$GLOBAL_CONFIG['DB_TITLE']}_datalist WHERE TYPE = '{$type}' ORDER BY PRIORITY ASC";
$res = $db->sql_query($query);
$output = "";
$i = 0;
while ($datalist = $db->sql_fetchrow($res))
{
$output .= "ary_{$id}[{$i}] = '{$id}_{$datalist['CODE']}'; ";
++$i;
}
return $output;
}
?>
$DB_CONFIG = array();
$DB_CONFIG['TYPE'] = "mysql4";
$DB_TYPE = $DB_CONFIG['TYPE'];
// -----------------------------------------------------------------
// SETTINGS FOR DEV SERVER
// -----------------------------------------------------------------
if (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == "on") {
$HTTP='https://';
} else {
$HTTP='http://';
}
$DB_CONFIG['DEV']['SERVER'] = "localhost";
$DB_CONFIG['DEV']['USER'] = "soyjoy";
$DB_CONFIG['DEV']['PASSWD'] = "h3u28gve";
$DB_CONFIG['DEV']['DBNAME'] = "soyjoy";
$GLOBAL_CONFIG['DEV']['ROOT_URL'] = $HTTP.$_SERVER['HTTP_HOST'].'/'; // The home URL for the website (with "/" at the end)
$GLOBAL_CONFIG['DEV']['DB_TITLE'] = "soyjoy_dev";
$GLOBAL_CONFIG['DEV']['DOC_ROOT'] = "_dev/"; // The home URL for the website (with "/" at the end)
$GLOBAL_CONFIG['DEV']['ADMIN_ROOT'] = $GLOBAL_CONFIG['DEV']['DOC_ROOT']."_admin/";
//'_dev/_admin/'
// -----------------------------------------------------------------
// SETTINGS FOR UAT SERVER
// -----------------------------------------------------------------
$DB_CONFIG['UAT']['SERVER'] = "localhost";
$DB_CONFIG['UAT']['USER'] = "soyjoy";
$DB_CONFIG['UAT']['PASSWD'] = "h3u28gve";
$DB_CONFIG['UAT']['DBNAME'] = "soyjoy";
$GLOBAL_CONFIG['UAT']['ROOT_URL'] = $HTTP.$_SERVER['HTTP_HOST'].'/'; // The home URL for the website (with "/" at the end)
$GLOBAL_CONFIG['UAT']['DB_TITLE'] = "soyjoy_uat";
$GLOBAL_CONFIG['UAT']['DOC_ROOT'] = "_uat/"; // The home URL for the website (with "/" at the end)
$GLOBAL_CONFIG['UAT']['ADMIN_ROOT'] = $GLOBAL_CONFIG['UAT']['DOC_ROOT']."_admin/";
// -----------------------------------------------------------------
// SETTINGS FOR PROD SERVER
// -----------------------------------------------------------------
$DB_CONFIG['PROD']['SERVER'] = "localhost";
$DB_CONFIG['PROD']['USER'] = "soyjoy";
$DB_CONFIG['PROD']['PASSWD'] = "h3u28gve";
$DB_CONFIG['PROD']['DBNAME'] = "soyjoy";
$GLOBAL_CONFIG['PROD']['ROOT_URL'] = $HTTP.$_SERVER['HTTP_HOST'].'/'; // The home URL for the website (with "/" at the end)
$GLOBAL_CONFIG['PROD']['DB_TITLE'] = "soyjoy_prod";
$GLOBAL_CONFIG['PROD']['DOC_ROOT'] = ""; // The home URL for the website (with "/" at the end)
$GLOBAL_CONFIG['PROD']['ADMIN_ROOT'] = $GLOBAL_CONFIG['PROD']['DOC_ROOT']."_admin/";
// -----------------------------------------------------------------
// SELECT THE SERVER PUBLISH STATUS
// -----------------------------------------------------------------
$GLOBAL_CONFIG['PUBLISH_STATUS'] = "PROD";
$DB_CONFIG['SERVER'] = $DB_CONFIG[$GLOBAL_CONFIG['PUBLISH_STATUS']]['SERVER'];
$DB_CONFIG['USER'] = $DB_CONFIG[$GLOBAL_CONFIG['PUBLISH_STATUS']]['USER'] ;
$DB_CONFIG['PASSWD'] = $DB_CONFIG[$GLOBAL_CONFIG['PUBLISH_STATUS']]['PASSWD'];
$DB_CONFIG['DBNAME'] = $DB_CONFIG[$GLOBAL_CONFIG['PUBLISH_STATUS']]['DBNAME'];
$GLOBAL_CONFIG['ROOT_URL'] = $GLOBAL_CONFIG[$GLOBAL_CONFIG['PUBLISH_STATUS']]['ROOT_URL'];
$GLOBAL_CONFIG['DB_TITLE'] = $GLOBAL_CONFIG[$GLOBAL_CONFIG['PUBLISH_STATUS']]['DB_TITLE'];
$GLOBAL_CONFIG['DOC_ROOT'] =$GLOBAL_CONFIG[$GLOBAL_CONFIG['PUBLISH_STATUS']]['DOC_ROOT'];
$GLOBAL_CONFIG['ADMIN_ROOT'] =$GLOBAL_CONFIG[$GLOBAL_CONFIG['PUBLISH_STATUS']]['ADMIN_ROOT'];
// -----------------------------------------------------------------
// GLOBAL FILE LOCATIONS
// -----------------------------------------------------------------
/*
$imgLocation['NEWS'] = "../../images.news";
$imgLocation['STATICS'] = "../../images.statics";
$imgLocation['PRODUCT'] = "../../images.product";
$imgLocation['PRODUCT_CTG'] = "../../images.product_ctg";
$fileLocation['NEWS'] = "../../files.news";
$fileLocation['EVENT'] = "../../files.event";
$fileLocation['DOWNLOAD'] = "../../files.download";
$fileLocation['FILEMANAGER'] = "../../files.filemanager";
$BODY_ONLOAD = (!isset($BODY_ONLOAD))?"":$BODY_ONLOAD;
*/
?>
// Declare Constants
define('BEGIN_TRANSACTION',1);
define('END_TRANSACTION',2);
//echo "{$DB_CONFIG['SERVER']},{$DB_CONFIG['USER']},{$DB_CONFIG['PASSWD']},{$DB_CONFIG['DBNAME']}";
// Connection string for MYSQL4
$db = new sql_db($DB_CONFIG['SERVER'], $DB_CONFIG['USER'],$DB_CONFIG['PASSWD'],$DB_CONFIG['DBNAME'],false);
$db->in_transaction = false;
$db->sql_query("SET NAMES 'utf8'");
//$db->sql_query("SET CHARACTER SET utf8");
?>