Mini Mods - Advent Calendar 2010

Two years ago and xmas is knocking on the door (again).

Based on the 2008 advent-calendar, here comes the vB4 version.

What is it ?
It's a simply Advent Calendar. I've filled it with images,music and videos (youtube or myvideo).
Each day (there are only 24 ) can have an image url or data (data like: <object ....).

How does it works ?
Like an advent calendar. I've created an simply template with an iframe in it. In this frame you will see a background-picture, doors (is the word correct ?) (calendar days) and - if you set it to on - snowflakes.
This calendar can only use on december and a day will only open if it's the correct day or an earlier day.
Example: it's 7th of december, so you can open all day include the 7th.
Each day will give a popup window (you can change the size for each day).
If you try to open a calendar day on a later date it will give you an error (confirm script) - this can also, when a day is "empty".
Empty means:
You have entered an image-url but selected "data" (in admincp) or you selected "image" but the image-url is empty.
After install all 24 days are filled will "funny movies", "pictures", "flash" or "music". You can change everything you like.

There are a few settings (is online, snowflakes on/of and count of snowflakes).
Also there are only 2 permissions:
- the permission to use the calendar
- the permission to test the calendar

If you set a usergroup to test the calendar, the users can see and click all the days of the calendar - that's necessary for testing !

Some technical
The iframe-size is set to 1024x768 and can changed in the template adventcalendar.
All images, javascript and the background html lies in: images/advent.
If you wanna change the backgound-image, change "images/advent/wallpaper.jpg".
The snowflake image can also changed (images/advent/snowflake.gif)

Installation
There is NO installation READ.ME !
Simply upload all files and import the product.

You can see the images here (advent calendar of 2008):
https://vborg.vbsupport.ru/showthrea...18#post1657818

After installing, setting the Calendar online and set the usergroup permissions, you will find a new Link under "community"

[Anopheles]

Hmmmh, no answers?

[Jaydee 2]

With a little bit modification it's still running in 4.2.2 and in the year 2014 as well.

At the behest of the forum owner many thanks for that - and from me merry christmas, a happy new year and best regards from Germany,
J?rg

[Mr_Devlin]

The db-changes wil not happen, tables will not being created, check your SQL-syntax, seems to be outdated

Datenbankfehler in vBulletin 4.1.9:

Invalid SQL:
SELECT * FROM adventcalendar_days ORDER BY adventcalendar_daysid ASC;

Referrer : https://xxx/login.php?do=login
lendar_days ORDER BY adventcalendar_daysid ASC;

MySQL-Fehler : Table 'XXX.adventcalendar_days' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Saturday, 21.11.2015 @ 13:13:30
Datum : Saturday, 21.11.2015 @ 13:13:30
Skript : http://xxx/admincp/adventcalendar_admin.php
IP-Adresse : xxxx
Benutzername : xxx
Klassenname : vB_Database_MySQLi
MySQL-Version : 6.0.11-alpha-community

PHP Code:

$db->hide_errors();

                $db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `adventpermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");

                $db->query("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "adventcalendar_days`;");
                $db->query("CREATE TABLE `" . TABLE_PREFIX . "adventcalendar_days` (
                  `adventcalendar_daysid` int(11) NOT NULL auto_increment,
                  `active` smallint(1) NOT NULL default '0',
                  `image` text NOT NULL,
                  `data` text NOT NULL,
                  `bitfield` int(4) NOT NULL default '0',
                  `pwidth` int(4) NOT NULL default '0',
                  `pheight` int(4) NOT NULL default '0',
                  PRIMARY KEY  (`adventcalendar_daysid`)
                ) TYPE=MyISAM;"); 


Any help about this issue?

[ProFifaLeagues]

Originally Posted by Mr_Devlin

The db-changes wil not happen, tables will not being created, check your SQL-syntax, seems to be outdated

PHP Code:

$db->hide_errors();

                $db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `adventpermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");

                $db->query("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "adventcalendar_days`;");
                $db->query("CREATE TABLE `" . TABLE_PREFIX . "adventcalendar_days` (
                  `adventcalendar_daysid` int(11) NOT NULL auto_increment,
                  `active` smallint(1) NOT NULL default '0',
                  `image` text NOT NULL,
                  `data` text NOT NULL,
                  `bitfield` int(4) NOT NULL default '0',
                  `pwidth` int(4) NOT NULL default '0',
                  `pheight` int(4) NOT NULL default '0',
                  PRIMARY KEY  (`adventcalendar_daysid`)
                ) TYPE=MyISAM;"); 


Any help about this issue?

Just tried this now and had the same issue mate

[Dragonsys]

The error you posted does not correspond to the code you posted.
Just create the DB Table(s) manually.

Chances are the table was not created due to this:

 TYPE=MyISAM

[MrD]

Hi,
change TYPE=MyISAM to TYPE=InnoDB

[elikkha]

Originally Posted by Jaydee 2

With a little bit modification it's still running in 4.2.2 and in the year 2014 as well.

Hello

Anyway to have a new version for VB4 ?

Impossible to create table, what is this modification please ?

Thanks for any help