SMF Support > Converting to SMF

Snitz 3.4.03 to SMF

<< < (12/13) > >>

Radianation:
My mistake. It was a post in the child board.

Radianation:
Well, if anybody wants to assist with this... Here are the tables and how I think they match up.

smf_calendar

(Populate SMF_CALENDAR from Snitz table forum_topics)
ID_EVENT -> Auto Increment
eventDate -> T_EVENT_DATE
ID_BOARD -> FORUM_ID (might be CAT_ID instead. I'm not sure)
ID_TOPIC -> TOPIC_ID
title -> T_SUBJECT
ID_MEMBER -> T_AUTHOR

I think these are correct.

[Unknown]:
INSERT INTO smf_calendar
   (eventDate, ID_BOARD, ID_TOPIC, title, ID_MEMBER)
SELECT T_EVENT_DATE, FORUM_ID, TOPIC_ID, T_SUBJECT, T_AUTHOR
FROM FORUM_TOPICS
WHERE IFNULL(T_EVENT_DATE, '0000-00-00') != '0000-00-00';

That's a guess on the WHERE clause, but you can get that I'm sure.

-[Unknown]

Radianation:
There is a field T_ISEVENT in the forum_topics that is either 1 or 0. If it's 1 then the topic is also an event. If it's 0 or blank then it's not. This would be a good way to check?

[Unknown]:
INSERT INTO smf_calendar
   (eventDate, ID_BOARD, ID_TOPIC, title, ID_MEMBER)
SELECT T_EVENT_DATE, FORUM_ID, TOPIC_ID, T_SUBJECT, T_AUTHOR
FROM FORUM_TOPICS
WHERE T_ISEVENT;

That's a guess on the WHERE clause, but you can get that I'm sure.

-[Unknown]

Navigation

[0] Message Index

[#] Next page

[*] Previous page