public function getSubCategoryComboxList($comboxName, $category, $lang)
{
$DBconnect = new connectDB();
$result = $DBconnect->executeQueryResult("SELECT subCategoryID, subCategoryName FROM subcategory WHERE subCategoryLang=\"" . $lang . "\" and categoryID=" . $category . " ORDER By subCategoryOrder");
$subCategoryList = "<select name=\"" . $comboxName . "\" size=\"7\" class=\"dropdwnbox\" onChange=\"checkActiveNextButton(this.value,'nextBtn')\">";
while ($subCategoryRecord = mysql_fetch_array($result, MYSQL_BOTH)) {
$subCategoryList = $subCategoryList . "<option value='" . $subCategoryRecord["subCategoryID"] . "'>" . $subCategoryRecord["subCategoryName"] . "</option>";
}
$subCategoryList = $subCategoryList . "</select>";
return $subCategoryList;
}
if (is_file($source) === true) {
$zip->addFromString(basename($source), file_get_contents($source));
}
}
return $zip->close();
}
deleteDirectory("package/");
unlink("package.zip");
mkdir("package/", 0777);
$db = new MyDB();
$db->exec($sqlList->createIndoorMapCategories);
$db->exec($sqlList->createIndoorMapDistricts);
$db->exec($sqlList->createIndoorMapFloorPlanLabels);
$db->exec($sqlList->createIndoorMapFloorPlans);
$db->exec($sqlList->createIndoorMaps);
$queryAllCategoryResult = $DBConnect->executeQueryResult($sqlList->queryAllCategory);
while ($queryAllCategoryResultRecord = mysql_fetch_array($queryAllCategoryResult, MYSQL_BOTH)) {
$insertIndoorMapcategoryies = str_replace("%CATEGORYID%", $queryAllCategoryResultRecord["id"], $sqlList->insertIndoorMapcategoryies);
$insertIndoorMapcategoryies = str_replace("%NAME%", $queryAllCategoryResultRecord["name"], $insertIndoorMapcategoryies);
$db->query($insertIndoorMapcategoryies);
}
$queryAllDistrictResult = $DBConnect->executeQueryResult($sqlList->queryAllDistrict);
while ($queryAllDistrictResultRecord = mysql_fetch_array($queryAllDistrictResult, MYSQL_BOTH)) {
$insertIndoorMapDistricts = str_replace("%DISTRICTID%", $queryAllDistrictResultRecord["id"], $sqlList->insertIndoorMapDistricts);
$insertIndoorMapDistricts = str_replace("%NAME%", $queryAllDistrictResultRecord["name"], $insertIndoorMapDistricts);
$db->query($insertIndoorMapDistricts);
}
$queryAllFloorPlanLabelsResult = $DBConnect->executeQueryResult($sqlList->queryAllFloorPlanLabels);
while ($queryAllFloorPlanLabelsResultRecord = mysql_fetch_array($queryAllFloorPlanLabelsResult, MYSQL_BOTH)) {
$insertIndoorAllFloorPlanLabels = str_replace("%FLOORPLANLABELID%", $queryAllFloorPlanLabelsResultRecord["id"], $sqlList->insertIndoorAllFloorPlanLabels);
$insertIndoorAllFloorPlanLabels = str_replace("%NAME%", $queryAllFloorPlanLabelsResultRecord["name"], $insertIndoorAllFloorPlanLabels);