';
$result = mysql_query($sQuery) or die("Query failed");
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$_SESSION[ 'order_id' ] = '';
$_SESSION[ 'cyb_subscription_id' ] = '';
$_SESSION[ 'subscription_status' ] = '';
if( strlen( $row[ 'order_id' ] ) == 0 )
{
//$sCreate = 'true';
//$sUpdate = 'false';
//print 'Gallery Owner: false
';
}
else
{
//$sCreate = 'false';
//$sUpdate = 'true';
$_SESSION[ 'order_id' ] = $row[ 'order_id' ];
$_SESSION[ 'cyb_subscription_id' ] = $row[ 'cyb_subscription_id' ];
$_SESSION[ 'subscription_status' ] = $row[ 'subscription_status' ];
//print 'order_id: ' . $_SESSION[ 'order_id' ] . '
';
}
if( $_SESSION[ 'subscription_status' ] == 'ACCEPT' )
{
$_SESSION[ $_SESSION[ 'owner_type' ] ] = true;
}
else
{
$_SESSION[ $_SESSION[ 'owner_type' ] ] = false;
}
if( $_SESSION[ 'subscription_type' ] == 'hosting' )
{
$sQuery = "
select distinct hs.domain, hs.username
from orders o,
hosting_subscription hs
where o.customer_id = " . $_SESSION[ 'customer_id' ] . "
and o.order_id = hs.order_id
";
//print $sQuery . '
';
$result = mysql_query($sQuery) or die("Query failed");
//$row = mysql_fetch_array($result, MYSQL_ASSOC);
//$_SESSION[ 'hosting_current_domain' ] = $row[ 'domain' ];
$i = 0;
$_SESSION[ 'hosting_current_domains' ] = '';
$_SESSION[ 'hosting_current_usernames' ] = '';
while( $row = mysql_fetch_array($result, MYSQL_ASSOC) )
{
//alert( $row[ 'domain' ] );
$_SESSION[ 'hosting_current_domains' ][ $i ] = $row[ 'domain' ];
$_SESSION[ 'hosting_current_usernames' ][ $i ] = $row[ 'username' ];
$i++;
}
}
?>