A warm, friendly welcome awaits everyone at our Sunday services. The service starts at 6:30PM and usually concludes at around 8:00PM (the last Sunday in each month can last longer).

Our guest speakers  and mediums offer healing messages and give evidence from our loved ones on the higher side of life.

Healing is also available after the service.

 

There is no need to pre-book our regular Sunday Services, on all but one of our Sunday Services we hold a free will collection (there is no admission charge on the door).

The last Sunday Service in each month has a longer demonstration of  mediumship; there is also an Open Platform at 8pm where trainee mediums (if any), can practice their skills. Please note: On the last Sunday of each month, there is a charge of £2.00 on the door, and no free will collection.

Everyone is welcome to enjoy fellowship and light refreshments following the service.

{source} <?php

global $quartal;

global $curQuart;


function display_YSC_Sunday_Services($mo) {

global $quartal;

global $curQuart;

$curQuart = CurrentQuarter();//returns 1 - 4 based on current quarter
quartSetup ( $curQuart ); //sets up the Dates array for displaying the current view (DB query)

if ($mo == "1") {

        $disMo = $quartal[0][mthSet];

        $days = $quartal[0][firstDIM];

        $mthNam = $quartal[0][mthName];

    } elseif ($mo == "2") {

        $disMo = $quartal[1][mthSet];

        $days = $quartal[1][firstDIM];

        $mthNam = $quartal[1][mthName];

    } elseif ($mo == "3") {

        $disMo =$quartal[2][mthSet];

        $days = $quartal[2][firstDIM];

        $mthNam = $quartal[2][mthName];

    } else {

        $disMo = $quartal[0][mthSet];

        $days = $quartal[0][firstDIM];

        $mthNam = $quartal[0][mthName];
}
$db =& JFactory::getDBO();

$yscCurrTableYear =  date("Y");  //Get current year for DB query

 

$query = 'SELECT a.ev_id, a.catid, b.evdet_id, b.dtstart, b.dtend, b.location, b.summary
FROM X99e_jevents_vevent a, X99e_jevents_vevdetail b
WHERE a.catid =22
AND b.dtstart between UNIX_TIMESTAMP(" '. $yscCurrTableYear.'-'.$disMo.'-01") and UNIX_TIMESTAMP("'. $yscCurrTableYear.'-'.$disMo.'-'.$days.' 23:59:59")
AND a.ev_id = b.evdet_id
order by b.dtstart';

$db->setQuery( $query );

$orderitems = $db->loadObjectList();

if (count($orderitems)>0) { ?>
<div>
    <table border="1" cellspacing="0">
        <tbody class="bodycontent">
            <tr>
                <td style="width: 171px;"><strong><?php  echo $mthNam." ".$yscCurrTableYear; ?></strong></td>
                <td style="width: 280px;"><strong>Medium</strong></td>
                <td style="width: 165px;"><strong>Location</strong></td></tr>
<?php $cnt = 1;
foreach ($orderitems as $item) { ?>
            <tr class="ms_row<?php echo ($cnt%2); ?>">

<?php $number = date('d', $item->dtstart); ?>
                <td> <?php echo date('l', $item->dtstart)." ".ordinal($number); ?></td>  
                <td> <?php $DvSvcSummary = explode(" - ", $item->summary); ?>
                
<?php $speakerName = $DvSvcSummary[0]; echo $speakerName// Speaker name  ?>
<?php $speakerLoc = $DvSvcSummary[1];  ?>
<?php $speakerLocation = str_replace("from ","",$speakerLoc);  echo "</td><td>" .  $speakerLocation ?></td>
            </tr>
<?php $cnt++; } ?>
        </tbody>
    </table>
</div>
<br />
<? } else { ?> <div style="border:none;">No Items Found</div> <? } ?>

<?php } ?>


<?php

function display_CUST_YSC_Sunday_Services($mo, $cusQuartal) {

if ($cusQuartal > 0){

global $quartal;

$curQuart = $cusQuartal;
quartSetup ( $curQuart ); //sets up the Dates array for displaying the current view (DB query)

if ($mo == "1") {

        $disMo = $quartal[0][mthSet];

        $days = $quartal[0][firstDIM];

        $mthNam = $quartal[0][mthName];

    } elseif ($mo == "2") {

        $disMo = $quartal[1][mthSet];

        $days = $quartal[1][firstDIM];

        $mthNam = $quartal[1][mthName];

    } elseif ($mo == "3") {

        $disMo =$quartal[2][mthSet];

        $days = $quartal[2][firstDIM];

        $mthNam = $quartal[2][mthName];

    } else {

        $disMo = $quartal[0][mthSet];

        $days = $quartal[0][firstDIM];

        $mthNam = $quartal[0][mthName];
}
$db =& JFactory::getDBO();

$yscCurrTableYear =  date("Y");  //Get current year for DB query

$query = 'SELECT a.ev_id, a.catid, b.evdet_id, b.dtstart, b.dtend, b.location, b.summary
FROM X99e_jevents_vevent a, X99e_jevents_vevdetail b
WHERE a.catid =22
AND b.dtstart between UNIX_TIMESTAMP("'. $yscCurrTableYear.'-'.$disMo.'-01") and UNIX_TIMESTAMP("'. $yscCurrTableYear.'-'.$disMo.'-'.$days.' 23:59:59")
AND a.ev_id = b.evdet_id
order by b.dtstart';

$db->setQuery( $query );

$orderitems = $db->loadObjectList();

if (count($orderitems)>0) { ?>
<div>
    <table border="1" cellspacing="0">
        <tbody class="bodycontent">
            <tr>
                <td style="width: 171px;"><strong><?php  echo $mthNam." ".$yscCurrTableYear; ?></strong></td>
                <td style="width: 280px;"><strong>Medium</strong></td>
                <td style="width: 165px;"><strong>Location</strong></td></tr>
<?php $cnt = 1;
foreach ($orderitems as $item) { ?>
            <tr class="ms_row<?php echo ($cnt%2); ?>">

<?php $number = date('d', $item->dtstart); ?>
                <td> <?php echo date('l', $item->dtstart)." ".ordinal($number); ?></td>  
                <td> <?php $DvSvcSummary = explode(" - ", $item->summary); ?>
                
<?php $speakerName = $DvSvcSummary[0]; echo $speakerName// Speaker name  ?>
<?php $speakerLoc = $DvSvcSummary[1];  ?>
<?php $speakerLocation = str_replace("from ","",$speakerLoc);  echo "</td><td>" .  $speakerLocation ?></td>
            </tr>
<?php $cnt++; } ?>
        </tbody>
    </table>
</div>
<br />
<? } else { ?> <div style="border:none;">No Items Found</div> <? } ?>

<?php } ?>

<?php } ?>

<?php

//- - - - - - - - - - - - - - - - - - - 11

function display_CUST_Sunday_Services($mo) {

if ($cusQuartal > 0){

global $quartal;

$curQuart = $cusQuartal;
quartSetup ( $curQuart ); //sets up the Dates array for displaying the current view (DB query)

if ($mo == "1") {

        $disMo = $quartal[0][mthSet];

        $days = $quartal[0][firstDIM];

        $mthNam = $quartal[0][mthName];

    } elseif ($mo == "2") {

        $disMo = $quartal[1][mthSet];

        $days = $quartal[1][firstDIM];

        $mthNam = $quartal[1][mthName];

    } elseif ($mo == "3") {

        $disMo =$quartal[2][mthSet];

        $days = $quartal[2][firstDIM];

        $mthNam = $quartal[2][mthName];

    } else {

        $disMo = $quartal[0][mthSet];

        $days = $quartal[0][firstDIM];

        $mthNam = $quartal[0][mthName];
}
$db =& JFactory::getDBO();

$yscCurrTableYear =  date("Y");  //Get current year for DB query

$query = 'SELECT a.ev_id, a.catid, b.evdet_id, b.dtstart, b.dtend, b.location, b.summary
FROM X99e_jevents_vevent a, X99e_jevents_vevdetail b
WHERE a.catid =22
AND b.dtstart between UNIX_TIMESTAMP("'. $yscCurrTableYear.'-'.$disMo.'-01") and UNIX_TIMESTAMP("'. $yscCurrTableYear.'-'.$disMo.'-'.$days.'")
AND a.ev_id = b.evdet_id
order by b.dtstart';

$db->setQuery( $query );

$orderitems = $db->loadObjectList();

if (count($orderitems)>0) { ?>
<div>
    <table border="1" cellspacing="0">
        <tbody class="bodycontent">
            <tr>
                <td style="width: 171px;"><strong><?php  echo $mthNam." ".$yscCurrTableYear; ?></strong></td>
                <td style="width: 280px;"><strong>Medium</strong></td>
                <td style="width: 165px;"><strong>Location</strong></td></tr>
<?php $cnt = 1;
foreach ($orderitems as $item) { ?>
            <tr class="ms_row<?php echo ($cnt%2); ?>">

<?php $number = date('d', $item->dtstart); ?>
                <td> <?php echo date('l', $item->dtstart)." ".ordinal($number); ?></td>  
                <td> <?php $DvSvcSummary = explode(" - ", $item->summary); ?>
                
<?php $speakerName = $DvSvcSummary[0]; echo $speakerName// Speaker name  ?>
<?php $speakerLoc = $DvSvcSummary[1];  ?>
<?php $speakerLocation = str_replace("from ","",$speakerLoc);  echo "</td><td>" .  $speakerLocation ?></td>
            </tr>
<?php $cnt++; } ?>
        </tbody>
    </table>
</div>
<br />
<? } else { ?> <div style="border:none;">No Items Found</div> <? } ?>

<?php } ?>

<?php } ?>

<?php

//- - - - - - - - - - - - - - - - - - -11

 


//------------MORE FUNCTIONS---------------
function CurrentQuarter(){
     $n = date('n');
     if($n < 4){
          return "1";
     } elseif($n > 3 && $n <7){
          return "2";
     } elseif($n >6 && $n < 10){
          return "3";
     } elseif($n >9){
          return "4";
     }
}

function quartSetup ($i) {

//define globals
$quartal = array();
global $quartal;

$yR = "";
$yDays = "";   

     switch ( $i ) {

            case 1:

            // Get February days in current year month
            $yR = date("Y");

            $d = new DateTime(  $yR.'-02-01' );
            $yDays = $d->format( 't' );


                $quartal = array (
                    array(
                            mthSet => '01',
                            firstDIM => '31',
                            mthName => 'January',
                    ),
                    array(
                            mthSet => '02',
                            firstDIM => $yDays,
                            mthName => 'February',                
                    ),
                    array(
                            mthSet => '03',
                            firstDIM => '31',
                            mthName => 'March',
                    )
                );

            break;
                    
            case 2:
                $quartal = array (
                    array(
                            mthSet => '04',
                            firstDIM => '30',
                            mthName => 'April',
                    ),
                    array(
                            mthSet => '05',
                            firstDIM => '31',
                            mthName => 'May',                
                    ),
                    array(
                            mthSet => '06',
                            firstDIM => '30',
                            mthName => 'June',                
                    )
                );
            break;
            

              case 3:
                $quartal = array (
                    array(
                            mthSet => '07',
                            firstDIM => '31',
                            mthName => 'July',
                    ),
                    array(
                            mthSet => '08',
                            firstDIM => '31',
                            mthName => 'August',                
                    ),
                    array(
                            mthSet => '09',
                            firstDIM => '30',
                            mthName => 'September',                
                    )
                );
            break;
            
               case 4:
                $quartal = array (
                    array(
                            mthSet => '10',
                            firstDIM => '31',
                            mthName => 'October',
                    ),
                    array(
                            mthSet => '11',
                            firstDIM => '30',
                            mthName => 'November',                
                    ),
                    array(
                            mthSet => '12',
                            firstDIM => '31',
                            mthName => 'December',                
                    )
                );
            break;
    }
}

function ordinal($number) {
    $ends = array('th','st','nd','rd','th','th','th','th','th','th');
    if ((($number % 100) >= 11) && (($number%100) <= 13))
        return $number. 'th';
    else
        return $number. $ends[$number % 10];
}
 

$cusMth = 2;



// RUN run month 1 - 3 for displaying month

for($i = 1; $i <=3; ++$i) {

    display_YSC_Sunday_Services($i);

}

 

 

//USE THIS OPTION TO DISPLAY THE VISITING MEDIUMS FOR A CUSTOM QUARTAL

// THIS IS STILL IN TESTING

//IDEAL FOR GETTING THE NEXT3 MONTHS VISITING MEDIUMS!

$showNext = 1;

if ($showNext == 0){

 

if ( $curQuart < 3 and date("d") >= 14){

 

if ($curQuart <= 3){ $cusQuartal = $curQuart + 1;}else{$cusQuartal = $curQuart;}

for($i = 1; $i <= 3; ++$i) {

    display_CUST_YSC_Sunday_Services($i, $cusQuartal);

}

}else{

if ($curQuart <= 3){ $cusQuartal = $curQuart + 1;}else{$cusQuartal = $curQuart;}

for($i = 1; $i <= 1; ++$i) {

    display_CUST_YSC_Sunday_Services($i, $cusQuartal);}

}}

 

$displayAllYr = 0;

if ($displayAllYr == 1){

}

 

 

?> {/source}

 

Share this post

Submit to DeliciousSubmit to DiggSubmit to FacebookSubmit to Google PlusSubmit to StumbleuponSubmit to Twitter