| Author |
 Topic  |
|
SuTech
Starting Member
USA
23 Posts |
 Posted - 11 January 2001 : 14:40:22
|
Yep SR4, TTeal explained it much better.
|
 |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 January 2001 : 15:20:39
|
hmm i'll be looking at this tonight. I think it's a cookie thing.
In my code, I have a check case to display the edit buttons if you're moderator/admin. There's also a case that's check if the added_by number = the current user's id. I think this might be the problem. To see who's added the edit. I'm using the strDBNTUsername I think. I'll try to come up with fix ASAP.
Huwr, Richard, or Gor: How can I get the current user's member name or id? it's in strDBNTUsername right?
maybe i might have do add my own chkuser function to see if the user is the author of event.
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 January 2001 : 15:30:42
|
quote:
SuTech,
I get the same thing.... if I post the message as User Bob who is a normal user, I can add the message and it will show up. However, I cannot edit/delete my own message as Bob the regular user.
If I add messages and am level "x" or above (assuming moderator/admin), then I can edit/delete messages.
Something is really weird here.. :) Also, if I add messages as user Bob and other users have entered events on the same day, they all show up as user Bobs' events....
Just thought I'd mention these things.
Cheers,
Tim
http://www.free-guestbook.com
hey tim i tried it on my demo site: http://www.calvsa.net/snitz31sr4/events.asp
and it worked fine.
registered normal user, added an event. I see the buttons and can edit/delete my event.
I then log out and can't edit that event post anymore. Logged in as new normal user and also can't.
Can you try this on my demo site to see if you get same results.
Also Are you cookies set to forum or website? Mines is set to forum.
Edited by - aznknight on 12 January 2001 02:03:57 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 January 2001 : 15:50:38
|
Yes, strDBNTUserName will get you the username from the user's cookie.
You could do a check to make sure:
added_by = getMemberID(strDBNTUserName) |
|
|
|
mot
New Member
United Kingdom
70 Posts |
Posted - 11 January 2001 : 15:56:48
|
Aznknight, can I take it that the code is now SQL server compliant ?
|
|
|
|
Hopper
Junior Member
192 Posts |
Posted - 11 January 2001 : 16:36:16
|
Ahhh.. didnt even notice that, yep does the same thing for me on my forum and i had two differant people make an event on the same day. they all have the same name as the first person to post.
The problem is simple.
change lines
'if not(memberErased) then
Response.Write " - Added by " & authorname
'end if%>
to:
if not(memberErased) then
Response.Write " - Added by " & RS("M_Name")
else
Response.Write " - Added by Deleted User"
end if%>
Edited by - Hopper on 11 January 2001 17:02:53 |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 11 January 2001 : 16:49:14
|
Richard... Find 2 small problems with the Calendar.. First it's setup like yours blue/black.
when you add a event the "Day" turns white as is the background so you can't see the "Date"
Also when you add a event then mouse over it the event link turns white and blends in with the white background.
Is there anyway to just change those on the Calendar?
BTW... AWESOME JOB on the Calendar!!
Thanks
Rick |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 January 2001 : 17:11:31
|
rick, first, Alan made this mod, I can't take credit for it. And yes, Alan did do an Awesome job on this.
If you download:
http://richard.cfm-resources.com/v31sr4/events.txt
and then change the .txt to .asp you can use the one I use. Just right click on the link and choose "Save Target As" and then upload it to your server.
I had to make some modifications to the colors to get it to work with my color scheme.
Edited by - Richard Kinser on 11 January 2001 17:13:09 |
|
|
|
Matthew
New Member
USA
91 Posts |
Posted - 11 January 2001 : 17:38:07
|
Richard you sure that's the same one you use? Whenever I goto a date then go back the numbers turn white so you can't see that day anymore but it doesn't do it on your site. I'm trying to work with it right now myself.
Matt
If everything seems to be going your way, you have obviously overlooked something. |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 11 January 2001 : 17:50:00
|
Richard... Nothing changed  |
|
|
|
Matthew
New Member
USA
91 Posts |
Posted - 11 January 2001 : 17:52:09
|
Ya I just added an event on yours Richard. Thought maybe it was me messing something up. I could be original but I like your colors hehe 
Matt
If everything seems to be going your way, you have obviously overlooked something. |
|
|
|
CrAzY
New Member
USA
50 Posts |
Posted - 11 January 2001 : 21:43:18
|
Can someone help me with this one?
I try to add a new event on SR4 with SQL Server:
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
/forum/events.asp, line 526
=====
Here's line 526 and the Previous 5 lines:
If sUpdateMode = "edit" Then
sSQL = "UPDATE FORUM_EVENTS SET Start_Date = '" & cDate(Request.Form("START_DATE")) & "', End_Date = '" & enddate & "', Event_Title = '" & fixquote(Request.Form("EVENT_TITLE")) & "', Event_Details = '" & fixquote(Request.Form("EVENT_Details")) & "', date_added = '" & now() & "' WHERE Event_ID=" & Request.Form("Event_ID")
my_Conn.Execute sSQL
Else
sSQL = "INSERT INTO FORUM_EVENTS (Start_Date, End_Date, Event_Title, Event_Details, Date_Added, Added_by) Values ('" & cDate(Request.Form("START_DATE")) & "', '" & enddate & "',' " & fixquote(Request.Form("EVENT_TITLE")) & "', '" & fixquote(Request.Form("EVENT_Details")) & "', '" & now() & "', '" & memberid & "')"
my_Conn.Execute sSQL
« Nokturnal.Net »
Seize The Night
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 January 2001 : 21:43:30
|
| Sorry, just noticed... I'm going to have to change the calendar color from white to a darker color because of the hover color I use. I'm going to go through and redo it. |
|
|
|
need300z
Starting Member
14 Posts |
Posted - 11 January 2001 : 23:12:26
|
Can anyone help i'm comming up with this error on the events.asp page:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '#'.
/board/events.asp, line 625
which deals with this part of the code:
"ORDER BY Start_Date"
'Response.Write sSQL
'Open the RecordSet with a static cursor. This cursor provides bi-directional navigation
'Rs.Open sSQL, my_Conn, adOpenStatic, adLockReadOnly, adCmdText
dim rs
set rs = server.CreateObject("adodb.recordset")
rs.Open ssql, my_Conn <--- This line of code is 625
to view the error go to
Click here to view events.asp
Edited by - need300z on 11 January 2001 23:14:32 |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 12 January 2001 : 02:03:12
|
to Mod, Crazy and others using sql server.
I built this specifically for 3.1sr4 with access 2000. So this mod is not sql server compliant. Mainly because I do not have sql server locally to play with.
I know that slemieux and tteal all trying against their sql server based snitz forums, so maybe they can post the necessary changes in order for it to work on sql server.
Also just wanted to point out that I don't know what kinds of errors will pop up for MySql database users.
All I can guarantee is that it you won't get database errors using snitz31sr4 on access 2000 database. |
|
|
|
Topic |
|
Topic Locked
