| Author |
 Topic  |
|
randykirkpatrick
New Member
73 Posts |
 Posted - 23 May 2003 : 21:26:30
|
Mike,
It's ok i know you are a busy person just as we all are.
Randy K |
Edited by - randykirkpatrick on 23 May 2003 21:26:45 |
 |
|
|
randykirkpatrick
New Member
73 Posts |
Posted - 28 June 2003 : 07:10:13
|
Mike,
Anything on this yet? |
Thank you
Randy K |
|
|
|
randykirkpatrick
New Member
73 Posts |
Posted - 09 July 2003 : 07:05:30
|
| I guess this is a dead topic? |
Thank you
Randy K |
|
|
|
The Impact
Junior Member
Australia
398 Posts |
Posted - 09 July 2003 : 08:56:15
|
n8pbn, I am trying to add all the code onto my forum but I think that you need to specify the code and line numbers which have to be changed from a clean forum with only the events calendar because the first step In Topic.asp Find This code (1247 with both Events Calendar and Polls installed)
if AdminAllowed = 1 and ArchiveView <> "true" then
Response.Write " <tr>" & vbNewLine & _
" <td colspan=""3""><font face=""" & strDefaultFontFace & """ color=""" & strForumFontColor & """ size=""" & strFooterFontSize & """><b>Admins/Moderators:</b> <a href=""javascript:openPollWindow('pop_poll.asp?TOPIC_ID=" & Topic_ID & "&p=wv','300','300')"">See who voted</a></font></td>" & vbNewLine & _
" </tr>" & vbNewLine
end ifis asking for you to look for some code which is only in people's code if they have the Poll MOD. |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 14 July 2003 : 11:06:00
|
I agree with you. It was released as is because I had several people wanting the code. If and when I have time I will create a real non beta package.
I have promised an upgrade to this mod but the summer has been keeping me busy. So the next release may not be until this fall  . I will try to include a clean install instructions at that time. |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
jeffery
Junior Member
USA
176 Posts |
Posted - 17 July 2003 : 12:44:26
|
I have made some adjustments and slight improvements if anyone is interested. I have made it so you can select which events allow registration and will now display a signup icon on the event calendar in monthly, weekly, daily and event list if the event allows signup.
Anyone familiar with this code I need some help adding more to this mod. I'm not very familiar with data access but I think I almost have this.
I am trying to create a listing for each user they can view which events they are signed up for. The code I have so far looks like this:
strSQL = "SELECT T_SUBJECT, TOPIC_ID"
strSQL = strSQL & " FROM " & strMemberTablePrefix & "TOPICS INNER JOIN " & strMemberTablePrefix & "SIGNUP ON"
strSQL = strSQL & " " & strMemberTablePrefix & "SIGNUP.E_TOPIC_ID=" & strMemberTablePrefix & "TOPICS.TOPIC_ID"
strSQL = strSQL & " WHERE " & strMemberTablePrefix & "SIGNUP.E_MEMBER_ID = " & MemberID
set rsREG = my_Conn.Execute (strSql)
If rsREG.EOF or rsREG.BOF then
Err_Msg = Err_Msg & "You are not registered for any events"
Else
response.write " You are registered with the following events:<br><br>"
response.write "<A href=""topic.asp?TOPIC_ID=" & rsREG("TOPIC_ID") & """>" & rsREG("T_SUBJECT") & "</a>"
End If
rsREG.close
set rsREG = nothing
But this is not returning what I want. It only returns one record out of several. Anyone familiar with signup and the sql JOIN fuction have any ideas? Any help appreciated. I will share any tweaks I've made so far. |
www.thomasforum.com |
Edited by - jeffery on 17 July 2003 14:40:49 |
|
|
|
jeffery
Junior Member
USA
176 Posts |
Posted - 17 July 2003 : 14:39:29
|
Nevermind, I think I got it
strSQL = "SELECT T_SUBJECT, TOPIC_ID"
strSQL = strSQL & " FROM " & strMemberTablePrefix & "TOPICS INNER JOIN " & strMemberTablePrefix & "SIGNUP ON"
strSQL = strSQL & " " & strMemberTablePrefix & "SIGNUP.E_TOPIC_ID=" & strMemberTablePrefix & "TOPICS.TOPIC_ID"
strSQL = strSQL & " WHERE " & strMemberTablePrefix & "SIGNUP.E_MEMBER_ID = " & MemberID
set rsCHK = my_Conn.Execute(strSql)
If rsCHK.EOF or rsCHK.BOF then
response.write " You are not signup for any events<br><br>"
else
response.write " You are registered with the following events:<br><br>"
set rsREG = my_Conn.Execute (strSql)
while NOT rsREG.EOF
response.write "<A href=""topic.asp?TOPIC_ID=" & rsREG("TOPIC_ID") & """>" & rsREG("T_SUBJECT") & "</a><br>"
rsREG.MoveNext
wend
rsREG.close
set rsREG = nothing
end if
strSQL = ""
set rsCHK = nothing
It's amazing what you can learn playing with this forum. If an original purpose of snitz was to teach people ASP then it seems to be working  |
www.thomasforum.com |
Edited by - jeffery on 17 July 2003 14:40:07 |
|
|
|
fadius
Starting Member
9 Posts |
Posted - 16 August 2003 : 01:21:20
|
In the instructions for setting this up, it states:
"In Topic.asp Find This code (1247 with both Events Calendar and Polls installed)" WHere do I find the poll MOD. ALso, My topic.asp does not have this many lines and does not contain the line the instructions tell me to look for.
if AdminAllowed = 1 and ArchiveView <> "true" then
Response.Write " <tr>" & vbNewLine & _
" <td colspan=""3""><font face=""" & strDefaultFontFace & """ color=""" & strForumFontColor & """ size=""" & strFooterFontSize & """><b>Admins/Moderators:</b> <a href=""javascript:openPollWindow('pop_poll.asp?TOPIC_ID=" & Topic_ID & "&p=wv','300','300')"">See who voted</a></font></td>" & vbNewLine & _
" </tr>" & vbNewLine
end if
Response.Write " </table>" & vbNewLine & _
" </td>" & vbNewLine & _
" </tr>" & vbNewLine & _
"</table>" & vbNewLine
end if
end if
Response.Write " </td>" & vbNewLine
Please help as I really want to get this MOD working with the calander. |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 18 August 2003 : 09:03:08
|
First you do not need the Poll Mod installed to use this Mod. However you do need Current Events Installed.
You can find the Poll Mod here: http://www.snitzbitz.com/mods/details.asp?Version=All&mid=76
You will need to find the code in your topic.asp file that matches the code in the readme file. The line numbers will not match if you do not have the same mods installed as I do. So do not worry if you have less. The next release of this mod will reference line numbers based on the current Snitz Forum and the Events Calendar Mod only.
If you are still having problems you can email me and I'll try to help. |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
fadius
Starting Member
9 Posts |
Posted - 18 August 2003 : 16:08:22
|
| Just downloaded the Polls Mod Thank you. When you say Current Events, do you mean the Most recent version of the events calander? |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
|
|
Netz
Starting Member
Denmark
25 Posts |
Posted - 20 August 2003 : 15:10:17
|
Hi all,
For us "none-code" peeps but clever enuf to copy paste [:-)]
Could I have a round up of the situation plz.
I downloaded the "Sign up MOD" for the 1. post here.
Then read all the answers / discussions and got the new eventlist.asp from David (Great site BTW) ...
Then all dressed up and happy to start. I got my editor fired up and rock'n'roll on the radio, cold Herbashake ready and ...
UPS find line 1247 With Calendar and Poll installed  .. I just spent two days trying to get those two MODS to work together...
(Se other cry for help http://forum.snitz.com/forum/topic.asp?TOPIC_ID=46988&SearchTerms=vs,poll )
The help hasn't reached me yet  So I decided to uninstall the POLL MOD.... Can't signup work without the POLL Mod??
And If Yes ... Plz describe how and what to do next...
I am all ready and eager to COPY paste 
My situation: Running the latest Snitz with the Security Patchs
The NEW Recurring Calender... That I NEED BADLY
The signup is also "just the thing I need"
WHEN can we expect the NEW version with all the nice ideas and add on that all the nice peeps here made or suggested 
Thankx for all helpful souls
Here is my Topic.asp
PLEASE HURRY http://www.bizplanet.dk/forum/topic_netz.txt
|
A wise man don't know everything. But he knows who to ask :)
Be the best you can be
http://www.Bizworld.dk - Work From Home - The Smart way
Stay Healthy: http://www.herbalcenter.dk |
Edited by - Netz on 20 August 2003 17:49:16 |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 21 August 2003 : 09:44:09
|
You do not need the poll mod for this to work. I developed this for my site and had several people ask me for the code. So I quickly put the code together and some instructions. Since I had the poll mod installed that is where the line numbers fell. The next version will be based on the base forum with only the Events Mod installed.
I was giving out dates of when to expect the next version but i kept missing them . So now I will only say expect something soon. |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
Netz
Starting Member
Denmark
25 Posts |
Posted - 22 August 2003 : 11:46:53
|
Hi n8pbm,
It's not that I need the POLL mod, but I can't get them to work together, so there must be a different between
Event Calender and the version I installed "Event Calendar Recurring " !! The ideel situation is to get Snitz to work
with both Event Calendar Recurring and the signup and finally
the Poll mod all together in the family
Hope you find the time soon to get the "thorough" version ready ....
Have a fantastic day |
A wise man don't know everything. But he knows who to ask :)
Be the best you can be
http://www.Bizworld.dk - Work From Home - The Smart way
Stay Healthy: http://www.herbalcenter.dk |
Edited by - Netz on 22 August 2003 11:47:58 |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 05 September 2003 : 21:47:55
|
Ok i have finally had a chance to update the mod. The readme is completely re-written using line numbers from a clean install of the forum with only the Events Calendar installed. I still have a few features that I want to add but thought I should release something
Thanks to everyone that was patiently waiting and those that provided feedback to fix all my novice coding.
I hope this version is greatly improved from the last one |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
Topic |
|
Topic Locked
