| Author |
 Topic  |
|
Etymon
Advanced Member
United States
2385 Posts |
 Posted - 19 July 2009 : 09:31:56
|
Also, feel free to play around with the wording for whatever suits you best. I changed it so I could understand more of what I was doing:
(Updated) by Last Post
(Popular) by Most Replies
(Newest) by First Post |
 |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 19 July 2009 : 10:22:12
|
Confused dot com...
Well Thank you so far..
Incidentally I have Access DB...
Version One:
1. Select radio button by Last Post (recent Posts)
Preview panel displays Recent Last posts
Suffix in HTML code last_post&results=10
2. Select radio button by Topic Replies (Most Popular)
Preview Panel Most Popular OK
Suffix in HTML most_popular&results=10
3. Select radio by Topic date (Mew Topics)
Preview Panel Recent last Posts
Suffix in HTML last_post&results=10
4. Select Radio by Event Date (New Events)
Preview Panel Coming Events Title but Preview list is same as Last posts
Suffix in HTML event_date&results=10
The only ouput that is generated in the preview panel that is correct is Topic Replies (Most Popular) and Last Post (Recent Posts)
Looking at Version Two:
Great idea
It appears the only preview panels to display a result is ALL Types
Selecting the other no output is generated
Because I have no POLL MOD, I would prefer to run with the Version One
I have reinstalled that version and see where we can progress the output variations.
If you would like to see the symptoms for yourself could you register an account on the forum, I will change the account to allow admin features to see for yourself..
Thank you andy |
Edited by - Andy Humm on 19 July 2009 12:04:02 |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 July 2009 : 10:22:55
|
| Ah, I have overlooked something on version #2 ... I'll get back to it later on today. |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 19 July 2009 : 10:39:33
|
okay, if you want to see results on access please feel free to have an account on my forum..
Thank you everso much for the help and input so far..
|
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 July 2009 : 11:45:23
|
| You are welcome Andy! I fixed version #2. I think. LOL! |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 July 2009 : 11:52:48
|
| Yeah, I will have to research that Andy. I am not an Access guy. I did a RIGHT JOIN in MS SQL on the CAL_EVENTS table. I'm not sure what a RIGHT JOIN equates to in Access. I'll get some sleep and look into it later. I registered for an account. |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 19 July 2009 : 12:02:55
|
That was quick, am I assuming that the version 2 links above have been amended, as the symptoms seem the same ie. not preview outputs on any other selection from ALL Types
Incidentally your account is activated and set to admin thank you
I will see what I can find too.
BFN andy |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 July 2009 : 16:10:19
|
| I replied to through a PM at your Forum. |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 19 July 2009 : 17:20:17
|
Thank you, Etymon
You mention in the PM, "It is the JOIN that I have to work on. I'll have to figure out what it is for Access" I wonder if there any Acces sql whizzes who can tie the Events Calendar Mod Upcaoming Events into the Syndicate Mod. Etymon's txt links above give the basic syndicate files and I have posted the code for the upcoming events right back at the top of this thread.
Any addition input would be greatly appreciated.. Thanks every1
Andy |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 July 2009 : 18:16:22
|
| You are welcome, Andy. I sent you another PM. Also, I am updating the link for the second version that includes the polls. As it is now, it will through a hidden error stating that F_POLLS are not found if indeed you do not have the poll mod installed. I am adding the variable strPolls. |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 July 2009 : 18:21:09
|
If I am not mistaken, I think that Ruirib is really good with MS Access. I know that he is great with JOINs!  I am not sure if he wants to be volunteered. |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 July 2009 : 18:43:43
|
For anyone who wants to take a quick glance without having to install this MOD, this is what we are dealing with (we need the correct syntax for MS Access):
Databases:
MSSQL 2005 (works)
MS Access (Does not work - produces errors below)
File:
syndicate.txt
QueryString:
syndicate.asp?type=events_only&method=new_topic&results=10&age=30&pf=y
Parameter Legend for this QueryString:
type means include only events
method means newest topics
results means how many topics
age means how many days old
pf means private forums included
Previous and Present Errors:
Previous Error - The error used to be (before adding the variable strPolls to account for if the Poll MOD is not installed):
"Join expression not supported"
Present Error - The error now is (after adding strPolls):
Microsoft JET Database Engine (0x80040E14)
Invalid SQL statement; expected 'DELETE', 'INSERT',
'PROCEDURE', 'SELECT', or 'UPDATE'.
strSql Output:
strsql = SELECT F.F_SUBJECT, T.TOPIC_ID AS REAL_TOPIC_ID, C.TOPIC_ID, T.T_AUTHOR, T.T_SUBJECT, T.T_LAST_POST, T.T_LAST_POST_REPLY_ID, T.T_REPLIES, T.T_DATE, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME FROM (((FORUM_FORUM F LEFT JOIN FORUM_TOPICS T ON F.FORUM_ID = T.FORUM_ID) RIGHT JOIN FORUM_CAL_EVENTS C ON C.TOPIC_ID = T.TOPIC_ID) LEFT JOIN FORUM_MEMBERS M ON T.T_AUTHOR = M.MEMBER_ID) LEFT JOIN FORUM_MEMBERS MEMBERS_1 ON T.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID WHERE T.T_STATUS < 2 AND T.T_DATE > '20090619174258' ORDER BY T.T_DATE DESC, T.T_LAST_POST DESC
|
Edited by - Etymon on 19 July 2009 18:48:02 |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 July 2009 : 23:13:02
|
Hey Andy, I took out the JOINs and ran it through Access' query tools. I came up with this:
SELECT F.F_SUBJECT, T.TOPIC_ID AS REAL_TOPIC_ID, C.TOPIC_ID, T.T_AUTHOR, T.T_SUBJECT, T.T_LAST_POST, T.T_LAST_POST_REPLY_ID, T.T_REPLIES, T.T_DATE, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME FROM FORUM_FORUM F, FORUM_CAL_EVENTS C, FORUM_TOPICS T, FORUM_MEMBERS M, FORUM_MEMBERS MEMBERS_1 WHERE F.FORUM_ID = T.FORUM_ID AND C.TOPIC_ID = T.TOPIC_ID AND T.T_AUTHOR = M.MEMBER_ID AND T.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID AND T.T_STATUS < 2 AND T.T_DATE > '20090619174258' ORDER BY T.T_DATE DESC, T.T_LAST_POST DESC
I ran it in SQL Server Management Studio Express 2005, and the query worked. I'll work on it some more tonight to see what I come up with.  |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 July 2009 : 23:24:10
|
| OK, it is rough, but that's getting it somewhere. I'll contact you at your forum when I have a better file to throw your way. |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 24 July 2009 : 17:41:17
|
Behind the scenes, Etymon has been burning many gallons of midnight oil, getting the syndicate mod revamped and hey presto he has come up with a very good result. My initial request was to look at getting the Events Calendar threads to be shown as a syndicate link but through his persistaence and endeavour, he has made a totally better version of the syndicate setup and output, with loads of choices. I have been overwhelmed by his assistance so far and can not thank him enough.. Thanks etymon...
I understand there are some very minor poll mod areas to look at, but I do not have this mod installed and can not check it with access db.
The two latest files are:
syndicate.asp link
setuplinks.asp link
Maybe other would like to try this latest version before a mod update is produced.. It is well worth the look.
Andy |
Edited by - Andy Humm on 24 July 2009 17:41:31 |
|
|
|
Topic |
|
Topic Locked
