phpBB to smf calendar mod

[shanny]

Hello everyone,

The phpBB to smf conversion script is great. I was able to transfer all the posts, avatars, pms, and attachments (phpBB attachment mod) smoothly. What didn't come over was the calendar posts (phpBB calendar mod). Is there a script someone can share that will allow me to import the phpBB calendar posts to the SMF calendar?

Thanks

[Herman's Mixen]

not if i know off...
but it's extremly recommended before conversion that you uninstall all mod's within phpBB
so it wil goes a little smoother !!

[shanny]

The conversion did go smoothly, although I didn't remove the phpBB mods...
I don't remember reading that...but more than likely I scanned the instructions 
I tested on my local PC first, though...

What I was wondering is if there is a separate script that will import the phpBB calendar
mod to the SMF calendar. No biggie though, we can always manually enter the events to SMF's cal.

[Herman's Mixen]

What I was wondering is if there is a separate script that will import the phpBB calendar

No there isn't so you have to do this manually

[Oldiesmann]

If you can give us a database dump of the table(s) this mod uses, we can probably write something up. I didn't even know there was a calendar hack for phpBB...

[shanny]

There looks to be two tables for the calendar in the phpBB database...

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl1
-- http://www.phpmyadmin.net [nofollow]
--
-- Host: localhost
-- Generation Time: May 26, 2005 at 07:50 PM
-- Server version: 4.0.21
-- PHP Version: 4.3.9
--
-- Database: `mamtwist`
--

-- --------------------------------------------------------

--
-- Table structure for table `phpbb_cal_config`
--

CREATE TABLE `phpbb_cal_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;


and

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl1
-- http://www.phpmyadmin.net [nofollow]
--
-- Host: localhost
-- Generation Time: May 26, 2005 at 07:43 PM
-- Server version: 4.0.21
-- PHP Version: 4.3.9
--
-- Database: `mamtwist`
--

-- --------------------------------------------------------

--
-- Table structure for table `phpbb_calendar`
--

CREATE TABLE `phpbb_calendar` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) default NULL,
  `stamp` datetime default NULL,
  `subject` varchar(255) default NULL,
  `description` blob,
  `user_id` mediumint(1) NOT NULL default '-1',
  `valid` char(3) NOT NULL default 'no',
  `eventspan` date default NULL,
  `bbcode_uid` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=107 ;

[Oldiesmann]

Ok. Should be relatively easy to convert over. What are the "valid" and "bbcode_uid" fields used for?

[shanny]

I'm not sure 

I tried browsing the table....
The row labelled valid just has 'yes' for all of the entries...
The bbcode_uid has characters in it, but looking at the calendar
there's no special formatting or anything.....

Here's a sample data entry:
INSERT INTO `phpbb_calendar` VALUES (48, 'crider', '2005-04-23 00:00:00', 'Hawg Riders Picnic', 0x44657374696e6174696f6e20544241, 14, 'yes', '2005-04-23', 'c2b87f3188');

I highlighted valid and bbcode_uid...

[[Unknown]]

Well, bbcode_uid is going to be for any bbc that happens to be in the description (which should be text not blob imho.)  The converter already handles those in posts, signatures, and the like.

[Unknown]

[Oldiesmann]

Ah. I'll take a look at this later this week then when I have more free time and see what I can do for you shanny.

[shanny]

Thanks Oldiesmann but if you don't have time it's cool 
The club has been adding events to the calendar manually
and I haven't heard too much grumbling   

But if you do have time, I'll definitely appreciate it in the event
I need it for a future conversion