quote:

---

function DisplayUpcomingEvents
strSql = "SELECT event_id, start_date, event_title, PRIVATE, " & strDBNTSQLName & " FROM " & strTablePrefix & "EVENTS LEFT JOIN " & strMemberTablePrefix & "Members ON " & strTablePrefix & "EVENTS.added_by = " & strMemberTablePrefix & "Members.Member_ID WHERE start_date >= '" & DateToStr(date()) & "' and start_date < '" & DateToStr(DateAdd("d",30,date())) & "' Order by start_date, event_id ASC LIMIT " & intDisplay

---

quote:

---

Here's a comment from me:
Also doesn't changing the strToDate function in inc_functions.asp to accomodate the your events calendar mess it up for other parts of the site that uses that function?

- Alan

---

this is to be tested a lot, but i don't think so, as the mod i change is general, and the Date variable, either 13/04/2001 or April 13, 2001, the ASP language reads it the same..

Hoping no errors occur for the forum code itself, this will appear with the feedbacks you asked for

ps: Download error fixed.

Edited by - rkattan on 13 April 2001 15:07:02

quote:

---

I got this error both in events.asp and events_inc.asp :

quote:

---

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/Forum/events_inc.asp, line 187

---

on my code in line 187 is:

	rs.Open ssql, my_Conn
	%>

---

does anyone haveany idea?I couldn't get it work

quote:

---

I've installed the calendar (great job by the way). I've noticed that when I post a public event as admin and log in as a user that does not have admin privileges this user can still delete public events. Is this by design? If so how can I stop them from deleting public messages and limiting public message to administrators only?

Any ideas?

---

Thanks

Nope this is not by design. A normal member cannot delete another member's public event. However a moderator or admin can delete public event. Probably the 2nd account you're using has moderator status.

I wrote how to make it moderators or admin only in the zip. Follow that.

- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource

quote:

---

quote:

---

I've installed the calendar (great job by the way). I've noticed that when I post a public event as admin and log in as a user that does not have admin privileges this user can still delete public events. Is this by design? If so how can I stop them from deleting public messages and limiting public message to administrators only?

Any ideas?

---

Nope this is not by design.

---

quote:

---

Nope this is not by design. A normal member cannot delete another member's public event. However a moderator or admin can delete public event. Probably the 2nd account you're using has moderator status.

I wrote how to make it moderators or admin only in the zip. Follow that.

---

quote:

---

Figured it out, the actual line that shows and hides the delete button was remmed out.

---

Yeah you're right I didn't realize this issue before. The fix is this.
Around line 829 in events_functions.asp there are these two lines:

<%'If (mlev >= intAllowed) and (lcase(lcase(rs(strDBNTSQLNAME))) = lcase(Request.Cookies(strUniqueID & "User")("Name"))) or mlev >=3 Then%>
<%If mlev >= intAllowed or lcase(strDBNTUSerName) = lcase(rs(strDBNTSQLNAME)) Then%>

Now uncomment the first line and comment the second line, like this:

<%If (mlev >= intAllowed) and (lcase(lcase(rs(strDBNTSQLNAME))) = lcase(Request.Cookies(strUniqueID & "User")("Name"))) or mlev >=3 Then%>
<%'If mlev >= intAllowed or lcase(strDBNTUSerName) = lcase(rs(strDBNTSQLNAME)) Then%>

I will fix this in the zip too now.

quote:

---

As for the other issue, in case anyone's interested I put a value in there to check admin rights, if they exist then display the prompt to check mark weather the post is priviate or not. If no admin rights then the IsPrivateEvent automatically eqauls 1, thereby making it a private post.

Anyone see anything wrong with the way I did that? Any other suggestions?

---

Hey that's pretty clever, Vernman. I don't see any problems with doing it like that

- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource

quote:

---

***** BUG *****

The the calendar is not working well !!!

i get for each month number of days as the month, for ex, april will show 4 white days, november 11 white days... only december is OK, this is because i use UK date style, DD/MM/YYYY on my server

Fix is on events_function.asp line 11:
find this line:
dNextStart = CDate(intMonthNum + 1 & "/01/" & intYearNum)

and replace with this line:
dNextStart = CDate(MonthName(intMonthNum + 1) & " 1," & intYearNum)

Thanks...

---

You should change this in events_inc.asp too if you want to use this file, as it doesn't include events_function.asp, but uses its own GetLastDay function.

in events_inc.asp about line #320 (mine is changed, so I don't know exactly the line) inside function GetLastDay:

quote:

---

find this line:
dNextStart = CDate(intMonthNum + 1 & "/01/" & intYearNum)

and replace with this line:
dNextStart = CDate(MonthName(intMonthNum + 1) & " 1," & intYearNum)

---

Marino

quote:

---

Okay, this is probably a dumb question, but what exactly does the 'non-US dates support' addition do?

---

AFAIK the 'non-US dates support' has to be with how the server handles dates. At least for me, which I use a non US server, and need to work with "translated" MS products, I can tell you is a pain to work with dates in those products.

For example, if just type a date in a query against my SQL Server ("spanish" translated) asking for a date like 3/5/01 it will give me March, 5 2001, so the month is first. But, if I ask it for 13/5/01 it will give me May, 13 2001 as it sees that 13 is higher than the high month and it auto-translate mm/dd/yy to dd/mm/yy.

So, what this mod does is handle dates in a way the server can't "get confused" about if you are giving a mm/dd/yy or a dd/mm/yy. In US servers i think you haven't this problem as all dates are in mm/dd/yy format.

quote:

---

I have installed it, and everything looks the same as it used to, from memory anyway. I thought that what it would achieve (in part) is to change the way dates are displayed on events.asp, in the Headings where 'Upcoming Events' and 'Recent Events' are displayed. Both before and after this addition, mine still use the mm/dd/yy format, and I would prefer it if they didn't. This also applies on my default.asp where I have included the inc_functions.asp, as can be seen here. (Note, you will not be able to access my Forums Events Calendar as only Members are allowed). Also, when an event is actually being displayed, the 'Starts:' bit is also still using the mm/dd/yy format. So, what did I just actually modify in the events Mod when I added the Non US support addon?

TIA!

*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind *

---

The way to change how dates are displayed has to be with the function FormatDateTime as it uses the server date format to show the date.

I think the solution for this is to code another function (let's call it FormatDateTime2) that is able to show dates not using server defaults. And change the calls to FormatDateTime for FormatDateTime2 in events_functions.asp and events_inc.asp.

Actually I am trying to translate the forum and some mods to spanish, so I will code this function for myself. I am changing also the way the week is shown (as the week for us starts on monday, not on sunday). If you are interested, I can post the changes that should be done.

Marino


Edited by - Marino on 16 April 2001 18:53:59