RSS

LuxCal Forum

The place for questions, suggestions and news about the LuxCal Event Calendar

User:   Password:   Remember Me?   
LuxCal Forum / General / Problems / Luxcal calendar across another domain
Posted:  28 Sep 2013 21:00
Probably not the right subject line to describe my question but I need someone please t tell me what to call what I'm trying to do.

I have a Luxcal calendar which is used on one domain name within our village.  I have now another domain name where there is an overlap and for which I need to refer to the same calendar.  I have done this quite successfully - compare these 2 pages:

http://www.middlemarchesbenefice.org/bucknell.html - the calendar for church services - my original site

and

http://www.bedstoneandbucknell.org/bucknell_church.php - a 2 village website pulling in the same data

Now I thought it would be good to use a sidebar instead of the 'big' calendar, and then it occurred to me that perhaps I could install the sidebar and reference it to the MySQL database used with the middlemarchesbenefice site.  So far all my attempts at lateral thinking have failed and I'm really not sure of what the technical name for what I am attempting is called - or even if it's possible.

If someone can give me a steer I'd be most grateful.

Thanks as always
__________________
Graham
The Middle Marches Benefice
The villages of Bedstone & Bucknell
Posted:  29 Sep 2013 12:17   Last Edited By: grajay
I can't stop fiddling and have managed to get part way towards my goal:

http://www.bedstoneandbucknell.org/sidebar_test.php

The sidebar is almost how I want it but I seem to have lost a couple of things in the process.

1. No title - cannot remember where the config file for the sidebar lives - I thought that I might sort it with the $sbHeader entry.
2. I seem to have lost the scrolling in this sidebar

This is the code I have included

<?php
$sbHeader = 'BUCKNELL SERVICES' ;
$sbUpDays = '120' ;
include 'http://www.middlemarchesbenefice.org/luxcal_services/lcsbar.php';
?>


I'll see if I can fix the text size later.
__________________
Graham
The Middle Marches Benefice
The villages of Bedstone & Bucknell
Posted:  29 Sep 2013 19:36   Last Edited By: Roel B.
Hi Graham,

The included code looks ok.

1. No title
There is no setting to disable the sidebar title; so I don't know how you managed to "remove" it. Using the $sbHeader variable is fine, but if it's not specified, the sidebar title should default to "Upcoming Events" (from the user interface language files).

2. No scroll bar
Have a look in the css/css_sbar.php file:
- With the style div.sideBar on line 50 the side bar's containing div can be styled.
- The style div.ssb_scrollList on line 81 takes care of the scroll bar

On lines 18 - 36 of the same css/css_sbar.php file you can customize the look (colors, fonts, etc.) of the sidebar.

There is a small problem connecting to your MySQL database, so I can't "see" what's wrong. I will try again later.

OT: if you get a "Could not connect to the MySQL server " warning, the database user name or password in the lcconfig.php file are probably not correct.

Hope this helps.
Roel
Posted:  29 Sep 2013 20:26
I just tried the link http://www.bedstoneandbucknell.org/sidebar_test.php and got this error.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'middlema_grajay'@'localhost' (using password: YES) in /home/middlema/public_html/luxcal_services/common/toolbox.php on line 92
Could not connect to the MySQL server


Dan
__________________
"Little Guy"
Some own motorcycles, others ride them.

Find great LuxCal examples by Schwartz at http://www.calendarforum.dk/index.html
Posted:  30 Sep 2013 10:07
Thanks to you both.

For some obscure both databases have stopped working since yesterday when everything was just dandy.  The host company says it's down to the configuration file so I'm now going to have to reinstall both calendars and start over - sigh!
__________________
Graham
The Middle Marches Benefice
The villages of Bedstone & Bucknell
Posted:  30 Sep 2013 14:09
Having reinstalled one calendar, the issue of missing scrolling and title now seems to have resolved itself on my sidebar test page - very strange indeed.

Again thanks for your input.
__________________
Graham
The Middle Marches Benefice
The villages of Bedstone & Bucknell
Posted:  30 Sep 2013 14:48
Just one final issue.  Is it possible to filter the sidebar category displayed in much the same way as the main calendar can be filtered.  I tried adding the category filter:

<?php
$sbCatsIn = '3';
include 'http://www.middlemarchesbenefice.org/services/lcsbar.php';
?>


but that has no effect, so maybe there's another way to do it?  In hope & thanks again.
__________________
Graham
The Middle Marches Benefice
The villages of Bedstone & Bucknell
Posted:  30 Sep 2013 22:34
Yes, that should work! The 3 in your code should correspond to the category number on the admin's Category page. If so, the sidebar should only display upcoming events in that specific event category.
Roel
Posted:  30 Sep 2013 22:41
Graham,
On your test site http://www.bedstoneandbucknell.org/sidebar_test.php in the sidebar the scrollbar bottom is hidden. If this is a problem in your final solution, let me know and I will tell you how to solve this.
Roel
Posted:  01 Oct 2013 06:56   Last Edited By: grajay
Thanks Roel

I experimented with creating a new sidebar on the Middle Marches website with the filter and that worked perfectly of course.  I'm wondering if it's because I'm linking to a calendar from the Middle Marches website and perhaps breaking a few rules into the bargain?  Maybe I can find a way to link to a filtered sidebar by some other way.  I need to think laterally somehow. 

I don't see that the loss of the scrollbar off the bottom is a big issue but if there's a simple solution I'd be glad to have it if you don't mind but let me see if I can solve this filtering issue first please, as if I can't fix it I shall abandon the idea altogether.
__________________
Graham
The Middle Marches Benefice
The villages of Bedstone & Bucknell
Posted:  01 Oct 2013 09:30   Last Edited By: Roel B.
If you have your event categories correctly defined, the filtering problem should be solvable. I'm also using it in the sidebars on the LuxSoft Demo page to include and to exclude events in certain categories.

The loss of scrollbar off the bottom can be fixed as follows:
In the css/css_sbar.php file on line 81 you will find the definition of style div.ssb_scrollList. In this style you will find height:95%, with which you can experiment (for instance change it to height:90% or something in between).
Roel
Posted:  01 Oct 2013 10:03   Last Edited By: grajay
OK - height:80% worked for me - it rather caught me out as I was changing the css_sbar.php file on the Middle Marches Benefice site - silly me!.

I tried excluding categories using:

$sbCatsEx = '1,2,4,5,6,7,8';

but that didn't work either.

The code in the sidebar_test.php is now:

<?php
$sbCatsEx = '1,2,4,5,6,7,8';
include 'http://www.middlemarchesbenefice.org/services_bucknell/lcsbar1.php';
?>


Can you clarify what you mean by:

Quote:


If you have your event categories correctly defined,


I defined them within the calendar as I did before.  Certainly the filtering woks OK on the main site calendar.

Thanks
__________________
Graham
The Middle Marches Benefice
The villages of Bedstone & Bucknell
Posted:  01 Oct 2013 13:01
Hi Graham,

Unless you renamed it, on your include line it would be lcsbar.php and not lcsbar1.php

Dan
__________________
"Little Guy"
Some own motorcycles, others ride them.

Find great LuxCal examples by Schwartz at http://www.calendarforum.dk/index.html
Posted:  01 Oct 2013 15:51
Thanks Dan

Actually I've tried renaming the lcsbar.php to lcsnar1.php to see if it made any difference - it didn't.  But thanks for the reply.

I've reverted the code to:

<?php
$sbCatsEx = '1,2,4,5,6,7,8';
include 'http://www.middlemarchesbenefice.org/services_bucknell/lcsbar.php';
?>

__________________
Graham
The Middle Marches Benefice
The villages of Bedstone & Bucknell