function switchcategories ($id, $value){
global $db_users;
$sql = "update $db_users set max_categories = '$value' where selector = '$id' limit 1";
mysql_query($sql) or die(mysql_error());
}
function switchmemberships ($selector, $flag, $section, $job)
{
global $db_users;
global $db_images;
global $db_offers;
global $db_category;
global $db_subcategory;
global $db_subsubcategory;
if ($section == "admin") $folder = "../"; else $folder = "";
include ($folder . "./conf/memberships.php");
$logo_enabled = "def_" . $flag . "_logo";
$banner_enabled = "def_" . $flag . "_banner";
$banner2_enabled = "def_" . $flag . "_banner2";
$images_enabled = "def_" . $flag . "_images";
$set_images = "def_" . $flag . "_setimages";
$products_enabled = "def_" . $flag . "_products";
$set_products = "def_" . $flag . "_setproducts";
$sql = "SELECT selector, flag, category, prices, images FROM $db_users
WHERE selector = '$selector' LIMIT 1";
$r = mysql_query ($sql);
if ( !$r ) error ( "mySQL error", mysql_error() );
$f = mysql_fetch_array ( $r );
if ( $$logo_enabled != "YES" )
{
@unlink ( $folder . "./logo/$selector.gif" );
@unlink ( $folder . "./logo/$selector.bmp" );
@unlink ( $folder . "./logo/$selector.jpg" );
@unlink ( $folder . "./logo/$selector.png" );
}
if ( ( $$banner_enabled != "YES" ) or (( $def_onlypaid == "YES" ) and ( $flag == "D" )) )
{
@unlink ( $folder . "./banner/$selector.gif" );
@unlink ( $folder . "./banner/$selector.bmp" );
@unlink ( $folder . "./banner/$selector.jpg" );
@unlink ( $folder . "./banner/$selector.png" );
}
if ( ( $$banner2_enabled != "YES" ) or (( $def_onlypaid == "YES" ) and ($flag == "D" ) ) )
{
@unlink ( $folder . "./banner2/$selector.gif" );
@unlink ( $folder . "./banner2/$selector.bmp" );
@unlink ( $folder . "./banner2/$selector.jpg" );
@unlink ( $folder . "./banner2/$selector.png" );
}
if ( ( $def_onlypaid == "YES" ) and ( $flag == "D" ) and ( $f[flag] != "D" ) and ($job == "cron") )
{
$category = explode (":", $f[category]);
for ($index = 0; $index < count ( $category ); $index++)
{
$new_cat = explode ("#", $category[$index]);
if ($new_cat[0] != $prev_cat)
mysql_query("UPDATE $db_category SET fcounter = fcounter-1 where selector=$new_cat[0]") or die (mysql_error());
if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[1] != $prev_subcat))
mysql_query("UPDATE $db_subcategory SET fcounter = fcounter-1 where catsel=$new_cat[0] and catsubsel=$new_cat[1]") or die (mysql_error());
if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[2] != "") and ($new_cat[2] != "0"))
mysql_query("UPDATE $db_subsubcategory SET fcounter = fcounter-1 where catsel=$new_cat[0] and catsubsel=$new_cat[1] and catsubsubsel=$new_cat[2]") or die (mysql_error());
$prev_cat=$new_cat[0];
$prev_subcat=$new_cat[1];
}
}
$sql = "SELECT * FROM $db_images where firmselector = '$selector'";
$ra = mysql_query ($sql );
if (!$ra) error ("mySQL error", mysql_error() . $sql );
$results_amount_images = mysql_numrows ( $ra );
if ( (( $def_onlypaid == "YES" ) and ( $flag == "D") ) or ($$images_enabled != "YES") or ( $results_amount_images > $$set_images ) )
{
for ( $i2=0; $i2<$results_amount_images; $i2++ )
{
$fa = mysql_fetch_array ( $ra );
@unlink($folder . "./gallery/$fa[num].gif");
@unlink($folder . "./gallery/$fa[num].bmp");
@unlink($folder . "./gallery/$fa[num].jpg");
@unlink($folder . "./gallery/$fa[num].png");
@unlink($folder . "./gallery/$fa[num]-small.gif");
@unlink($folder . "./gallery/$fa[num]-small.bmp");
@unlink($folder . "./gallery/$fa[num]-small.jpg");
@unlink($folder . "./gallery/$fa[num]-small.png");
}
mysql_query("DELETE FROM $db_images where firmselector='$selector'");
}
if ( ( ( $def_onlypaid == "YES" ) and ( $flag == "D" ) ) or ( $$images_enabled != "YES" ) )
$imageSQL = ", images = 0";
else
$imageSQL = ", images = " . $$set_images;
$sql = "SELECT * FROM $db_offers where firmselector = '$selector'";
$ra = mysql_query ( $sql );
if ( !$ra ) error ( "mySQL Errors", mysql_error() + $sql );
$results_amount_products = mysql_numrows ( $ra );
if ( ( ( $def_onlypaid == "YES" ) and ($flag == "D") ) or ( $results_amount_products > $$set_products ) )
{
for ( $i3=0; $i3<$results_amount_products; $i3++ )
{
$fa = mysql_fetch_array ( $ra );
@unlink($folder . "./offer/$fa[num].gif");
@unlink($folder . "./offer/$fa[num].bmp");
@unlink($folder . "./offer/$fa[num].jpg");
@unlink($folder . "./offer/$fa[num].png");
@unlink($folder . "./offer/$fa[num]-small.gif");
@unlink($folder . "./offer/$fa[num]-small.bmp");
@unlink($folder . "./offer/$fa[num]-small.jpg");
@unlink($folder . "./offer/$fa[num]-small.png");
}
mysql_query("DELETE FROM $db_offers where firmselector='$selector'");
}
if ( ( ( $def_onlypaid == "YES" ) and ( $flag == "D" ) ) or ( $$products_enabled != "YES" ) )
$productSQL = ", prices = 0";
else
$productSQL = ", prices = " . $$set_products;
if ($flag != "D")
$date_upgrade = date ("Y-m-d");
else
$date_upgrade = "0";
$date_changed = date ("Y-m-d");
mysql_query ( "UPDATE $db_users SET flag='$flag', comment='Membership downgraded automatically from $f[flag] to $flag on $date_changed', date_upgrade='$date_upgrade' $productSQL $imageSQL WHERE selector='$selector'" ) or die (mysql_error());
}
function update_categories ($oldflag, $flag, $oldcategories, $newcategories, $section)
{
global $db_category;
global $db_subcategory;
global $db_subsubcategory;
if ($section == "admin") $folder = "../"; else $folder = "";
include ($folder . "./conf/memberships.php");
if ( ( ( $def_onlypaid == "YES" ) and ($oldflag != "D") ) or ( $def_onlypaid != "YES" ) )
{
$category = explode (":", $oldcategories);
for ($index = 0; $index < count ( $category ); $index++)
{
$new_cat = explode ("#", $category[$index]);
if ( $new_cat[0] != $prev_cat )
mysql_query ("UPDATE $db_category SET fcounter = fcounter-1 where selector=$new_cat[0]");
if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[1] != $prev_subcat))
mysql_query ("UPDATE $db_subcategory SET fcounter = fcounter-1 where catsel=$new_cat[0] and catsubsel=$new_cat[1]");
if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[2] != "") and ($new_cat[2] != "0"))
mysql_query ("UPDATE $db_subsubcategory SET fcounter = fcounter-1 where catsel=$new_cat[0] and catsubsel=$new_cat[1] and catsubsubsel=$new_cat[2]");
$prev_cat=$new_cat[0];
$prev_subcat=$new_cat[1];
}
}
unset($prev_cat);
unset($prev_subcat);
$index_category = 1;
for ($index = 0; $index < count ( $newcategories ); $index++)
{
if ($newcategories[$index] != "") {
$category_index[$index_category] = $newcategories[$index];$index_category++;
if ( ( ( $def_onlypaid == "YES" ) and ( $flag != "D" ) ) or ( $def_onlypaid != "YES" ) )
{
$new_cat = explode ("#", $newcategories[$index]);
if ($new_cat[0] != $prev_cat)
mysql_query ("UPDATE $db_category SET fcounter = fcounter+1 where selector=$new_cat[0]");
if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[1] != $prev_subcat))
mysql_query ("UPDATE $db_subcategory SET fcounter = fcounter+1 where catsel=$new_cat[0] and catsubsel=$new_cat[1]");
if (($new_cat[1] != "") and ($new_cat[1] != "0") and ($new_cat[2] != "") and ($new_cat[2] != "0"))
mysql_query ("UPDATE $db_subsubcategory SET fcounter = fcounter+1 where catsel=$new_cat[0] and catsubsel=$new_cat[1] and catsubsubsel=$new_cat[2]");
}
$prev_cat=$new_cat[0];
$prev_subcat=$new_cat[1];
}
}
@ $category = join(":", $category_index);
return $category;
}
?> include ("includes/common_header.php"); ?>
">
echo "$def_style"; ?>
title ($incomingline); ?>
include ("includes/js.php"); ?>
|
include ("includes/top_line.php"); ?>
|
">
include ( "menu.inc" ); ?>
if ( $def_banner2_allowed == "YES" ) include ("banner.php"); ?>
if ($def_top_categories_show == "YES") include ("topcats.php"); ?>
if ($def_last10show == "YES") include ("last.php"); ?>
|
NOTE: * Required Fields
Contact Form
|
include ("help.php"); ?>
if ( $def_banner2_allowed == "YES" ) include ("banner.php"); ?>
if ($def_featured_show == "YES") include("featured.php"); ?>
if ($def_top10show == "YES") include("top.php"); ?>
|
|
pixel.gif" alt="">
|
BodyMindExpo.com
All Rights Reserved.
All logos and trademarks in this site are property
of their respective owners.
website design and web development by Visionx Media Solutions
|
|