function createForm()
{
global $gorumroll, $jQueryLib, $fieldset_typ;
JavaScript::addInclude(GORUM_JS_DIR . $jQueryLib);
JavaScript::addInclude(GORUM_JS_DIR . "/jquery/jquery.dimensions.js");
JavaScript::addInclude(GORUM_JS_DIR . "/jquery/field.js");
JavaScript::addInclude(JS_DIR . "/fieldset_form.js");
$this->cid = $gorumroll->rollid;
// A deleteAll es cloneToSubcats mezoket csak akkor tesszuk ki, ha van ertelmuk:
getDbCount($subcatNum, array("SELECT COUNT(*) FROM @category WHERE up=#cid#", $this->cid));
if (!$subcatNum || !$this->cid) {
$fieldset_typ["attributes"]["cloneToSubcats"][] = "form invisible";
}
getDbCount($nonFixFieldNum, array("SELECT COUNT(*) FROM @customfield WHERE cid=#cid# AND columnIndex LIKE 'col_%'", $this->cid));
if (!$nonFixFieldNum) {
$fieldset_typ["attributes"]["deleteAll"][] = "form invisible";
}
parent::createForm();
}
function sortFieldForm($elementName = "")
{
global $jQueryLib, $gorumroll;
JavaScript::addInclude(GORUM_JS_DIR . $jQueryLib);
JavaScript::addInclude(GORUM_JS_DIR . "/jquery/form.js");
JavaScript::addInclude(GORUM_JS_DIR . "/jquery/jquery.center.js");
// to center the loading animation image
JavaScript::addInclude(JS_DIR . "/sort_custom_fields.js");
JavaScript::addInclude(JS_DIR . "/propagate.js");
// Propagate into all other categories:
$propagatePostfix = OverlayController::addPropagateOverlay($gorumroll->rollid, "_sorting");
// Propagate into the subcategories only:
if ($gorumroll->rollid) {
getDbCount($count, array("SELECT COUNT(*) FROM @category WHERE up=#cid#", $gorumroll->rollid));
if ($count) {
$propagatePostfix .= " " . OverlayController::addPropagateOverlay($gorumroll->rollid, "_sorting", "_subcat");
}
}
JavaScript::addOnload("\n \$('#itemfield-sortfield_form .submitfooter').append(" . G::js($propagatePostfix) . ");\n ");
$this->showHtmlList($elementName);
}
function getCount(&$count)
{
global $cookiePath, $noCookieCount;
//a kuki_count nem list-enkent tarolodik, csak egy van!
//ez lehet, hogy eleg, de neha gondot okozhat:
//pl. ketfele lista parhuzamos lapozgatasakor ket kulon ablakban
if (!$noCookieCount && isset($_COOKIE["kuki_count"]) && $_COOKIE["kuki_count"]) {
$count = $_COOKIE["kuki_count"];
} else {
$select = $this->getListSelect(TRUE);
// select only
if ($select == "") {
handleErr("No select from getSelect class:" . $this->get_table(), __FILE__, __LINE__);
}
if (is_array($select)) {
$select[0] = ereg_replace("SELECT .* FROM", "SELECT COUNT(*) FROM", $select[0]);
} else {
$select = ereg_replace("SELECT .* FROM", "SELECT COUNT(*) FROM", $select);
}
getDbCount($count, $select);
if (!$noCookieCount) {
setcookie("kuki_count", $count, 0, $cookiePath);
$_COOKIE["kuki_count"] = $count;
}
}
//echo "count:$count";
}
function getTransferData(&$_GS, $withReg = FALSE)
{
global $_GP, $_GA, $_GE;
$_S =& new AppSettings();
loadSQL($user = new User(), "SELECT email FROM @user WHERE isAdm=1 LIMIT 1");
$data = "id=" . $_GS->reg;
$data .= "&ip=" . urlencode($_SERVER["REMOTE_ADDR"]);
$data .= "&name=" . urlencode(Controller::getBaseUrl());
$data .= "&php=" . urlencode(phpversion());
$data .= "&mysql=" . urlencode(mysql_get_server_info());
$data .= "&version=" . urlencode($_GS->instver);
$data .= "&date=" . urlencode($_GS->creationtime->getDbFormat());
$data .= "&lastUpdate=" . urlencode($_GS->lastUpdate->getDbFormat());
$data .= "&systemEmail=" . urlencode($_S->adminEmail);
$data .= "&adminEmail=" . urlencode($user->email);
if (!empty($_GE)) {
$data .= "&orderEmail=" . urlencode($_GE);
}
if (!empty($_GP)) {
$data .= "&orderCode=" . urlencode($_GP);
}
if (!empty($_GA)) {
$data .= "&affiliateId=" . urlencode($_GA);
}
$branch = $this->getBranch();
$data .= "&branch={$branch}";
getDbCount($count, "SELECT COUNT(*) FROM @item");
$data .= "&itemNum={$count}";
getDbCount($count, "SELECT COUNT(*) FROM @category");
$data .= "&catNum={$count}";
$data .= "&webServer=" . (!empty($_SERVER['REQUEST_URI']) ? 'Apache' : 'IIS');
$data .= "&theme=" . urlencode($_S->defaultTheme);
$data .= "&lang=" . urlencode($_S->defaultLanguage);
$data .= "&allowSelectTheme=" . $_S->allowSelectTheme;
$data .= "&enablePermalinks=" . $_S->enablePermalinks;
$data .= "&cascadingCategorySelect=" . $_S->cascadingCategorySelect;
$data .= "&ecommerceEnabled=" . $_S->ecommerceEnabled;
$data .= "&enableCombine=" . $_S->enableCombine;
$data .= "&mainTitle=" . urlencode($_S->mainTitle);
$data .= "&mainDescription=" . urlencode($_S->mainDescription);
$data .= "&mainKeywords=" . urlencode($_S->mainKeywords);
if ($_S->ecommerceEnabled == Settings_ecommEnabled) {
$_ES =& new ECommSettings();
$data .= "&model=" . $_ES->model;
$data .= "&paypal_enabled=" . $_ES->paypal_enabled;
$data .= "&authorize_net_enabled=" . $_ES->authorize_net_enabled;
$data .= "&paypal_integrationMethod=" . $_ES->paypal_integrationMethod;
$data .= "&authorize_net_integrationMethod=" . $_ES->authorize_net_integrationMethod;
$gateways = array();
foreach (GateWay::getGateways() as $gateway) {
if ($gateway != 'paypal' && $gateway != 'authorize_net') {
$gateways[] = $gateway;
}
}
$data .= "&extraGateways=" . urlencode(implode(", ", $gateways));
}
if ($withReg) {
$data .= "&company=" . urlencode($_POST["company"]);
$data .= "&firstName=" . urlencode($_POST["firstName"]);
$data .= "&lastName=" . urlencode($_POST["lastName"]);
$data .= "&email=" . urlencode($_POST["email"]);
}
return $data;
}
function recalculateAllItemNumsCore()
{
// megszamlaljuk az osszes aktiv kozvetlen itemet:
getDbCount($count, array("SELECT COUNT(*) FROM @item WHERE cid=#this->id# AND status=1", $this->id));
$this->directItemNum = $count;
// eltaroljuk az uj directItemNum-ot:
executeQuery("UPDATE @category SET directItemNum=#count# WHERE id=#this->id#", $count, $this->id);
// betoltjuk a kozvetlen gyerekeket:
$subcats = new AppCategory();
$query = array("SELECT * FROM @category WHERE up=#this->id#", $this->id);
loadObjectsSql($subcats, $query, $subcats);
$this->itemNum = 0;
if (count($subcats)) {
foreach ($subcats as $cat) {
// ha vannak gyerekei, rekurzivan kiszamoljuk a gyerekek itemNumjat:
$cat->recalculateAllItemNumsCore();
// a sajat itemNum a gyerekek itemNumjanak osszege:
$this->itemNum += $cat->itemNum;
}
}
// a teljes itemNumhoz a directItemNumot is hozza kell szamolni:
$this->itemNum += $this->directItemNum;
// elmentjuk az itemNumot:
executeQuery("UPDATE @category SET itemNum=#this->itemNum# WHERE id=#this->id#", $this->itemNum, $this->id);
}
function updateSettingsTable()
{
global $noahVersion, $versionFooterText;
executeQueryForUpdate("\n ALTER TABLE @settings \n CHANGE `settings_blockSize` `blockSize` INT(3) NOT NULL DEFAULT '100000',\n CHANGE `settings_showExplanation` `showExplanation` TINYINT(4) NOT NULL DEFAULT '1',\n CHANGE `settings_adminEmail` `adminEmail` VARCHAR(255) NOT NULL DEFAULT '',\n CHANGE `settings_expiration` `expiration` INT(11) NOT NULL DEFAULT '30',\n CHANGE `settings_expNoticeBefore` `expNoticeBefore` INT(11) NOT NULL DEFAULT '5',\n CHANGE `settings_charLimit` `charLimit` INT(11) NOT NULL DEFAULT '10000',\n CHANGE `settings_immediateAppear` `immediateAppear` INT(11) NOT NULL DEFAULT '1',\n CHANGE `settings_maxPicSize` `maxPicSize` INT(11) NOT NULL DEFAULT '0',\n CHANGE `settings_maxPicWidth` `maxPicWidth` INT(11) NOT NULL DEFAULT '0',\n CHANGE `settings_maxPicHeight` `maxPicHeight` INT(11) NOT NULL DEFAULT '0',\n CHANGE `settings_renewal` `renewal` INT(11) NOT NULL DEFAULT '5',\n CHANGE `settings_allowModify` `allowModify` INT(11) NOT NULL DEFAULT '1',\n DROP `settings_necessaryAuthLevel`,\n DROP `settings_rangeBlockSize`,\n DROP `settings_textAreaRows`,\n DROP `settings_textAreaCols`,\n DROP `settings_headTemplate`,\n DROP `settings_upperTemplate`,\n DROP `settings_lowerTemplate`,\n DROP `settings_minPasswordLength`,\n DROP `settings_htmlTitle`,\n DROP `settings_htmlKeywords`,\n DROP `settings_htmlDescription`,\n DROP `settings_thumbnailWidth` ,\n DROP `settings_thumbnailHeight` ,\n DROP `settings_showChangePassword`,\n DROP `settings_showLogout`,\n DROP `settings_showLogin`,\n DROP `settings_showRegister`,\n DROP `settings_showMyProfile`,\n DROP `settings_showMyAds`,\n DROP `settings_showSubmitAd`,\n DROP `settings_showRecentAds`,\n DROP `settings_showMostPopularAds`,\n DROP `settings_showSearch`,\n DROP `settings_showHome`,\n ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ,\n ADD subscriptionType int(11) NOT NULL default '2',\n ADD `adminFromName` VARCHAR(255) NOT NULL DEFAULT '' AFTER adminEmail,\n ADD `menuPoints` VARCHAR( 255 ) NOT NULL AFTER `maxPicHeight` ,\n ADD `titlePrefix` VARCHAR( 255 ) NOT NULL AFTER `adminFromName`,\n ADD `smtpServer` VARCHAR( 255 ) NOT NULL AFTER `adminFromName` ,\n ADD `smtpUser` VARCHAR( 255 ) NOT NULL AFTER `smtpServer` ,\n ADD `smtpPass` VARCHAR( 255 ) NOT NULL AFTER `smtpUser`,\n ADD `fallBackNative` INT NOT NULL DEFAULT '0' AFTER `smtpPass`,\n ADD `versionFooter` TEXT NOT NULL AFTER `showExplanation`,\n ADD `helpLink` VARCHAR(255) NOT NULL AFTER menuPoints,\n ADD `defaultTheme` VARCHAR( 255 ) NOT NULL AFTER `helpLink` ,\n ADD `allowSelectTheme` INT NOT NULL DEFAULT '1' AFTER `defaultTheme` ,\n ADD `allowedThemes` TEXT NOT NULL AFTER `allowSelectTheme`,\n ADD `mainTitle` VARCHAR( 255 ) NOT NULL AFTER `titlePrefix` ,\n ADD `mainDescription` TEXT NOT NULL AFTER `mainTitle` ,\n ADD `mainKeywords` TEXT NOT NULL AFTER `mainDescription`,\n ADD `showCreatedInLists` INT NOT NULL DEFAULT '0',\n ADD `showCreatedInDetails` INT NOT NULL DEFAULT '1',\n ADD `showExpInLists` INT NOT NULL DEFAULT '0',\n ADD `showExpInDetails` INT NOT NULL DEFAULT '1',\n ADD `dateFormat` VARCHAR( 100 ) NOT NULL DEFAULT 'Y-m-d',\n ADD `enableFavorities` INT NOT NULL DEFAULT '1',\n ADD `enableRememberPassword` INT NOT NULL DEFAULT '1',\n ADD `enablePasswordReminder` INT NOT NULL DEFAULT '1',\n ADD `maxMediaSize` INT(11) NOT NULL DEFAULT '50000' after mainKeywords,\n ADD `updateCheckInterval` INT NOT NULL DEFAULT 7;", __FILE__, __LINE__);
getDbCount($count, "SELECT * FROM @settings");
$cmd = $count ? "UPDATE" : "INSERT INTO";
executeQueryForUpdate("\n {$cmd} @settings SET \n id=1, \n menuPoints='1,2,3,4,5,6,7,8,9,10,11,12', \n defaultTheme='modern', \n allowedThemes='classic,modern',\n versionFooter='{$versionFooterText}'", __FILE__, __LINE__);
$_S =& new AppSettings();
if (strstr($_S->adminEmail, "*****@*****.**") || strstr($_S->adminEmail, "*****@*****.**")) {
executeQueryForUpdate("UPDATE @settings SET adminEmail=''", __FILE__, __LINE__);
}
}
function hasExpiration()
{
static $hasExpiration = FALSE;
if ($hasExpiration !== FALSE) {
return $hasExpiration;
}
getDbCount($hasExpiration, "SELECT COUNT(*) FROM @category WHERE expirationEnabled=1");
return $hasExpiration;
}
function delete($includingRelatedCommonFields = TRUE)
{
if (load($this)) {
return;
}
// ha mar nem letezik
parent::delete();
if ($this->isCommon && $includingRelatedCommonFields) {
// ha egy common fieldet torlunk, az osszes azonos nevut torolni kell:
executeQuery("DELETE FROM @customfield WHERE columnIndex=#ci# AND cid!=#cid# AND isCommon=1", $this->columnIndex, $this->cid);
CacheManager::resetAllCache();
}
ItemSearch::deleteColumn($this);
getDbCount($count, "SELECT COUNT(*) FROM @search WHERE uid=0");
if ($count) {
Roll::setInfoText("checkCustomLists");
$this->nextAction =& new AppController("customlist/list");
}
}
