| Author |
 Topic  |
|
bobby131313
Senior Member
USA
1163 Posts |
 Posted - 14 February 2008 : 18:05:39
|
OK, cool, didn't think of that, looks good. 
Now it will only pull from the active table right?
So if I stay fairly tightly archived at 90 days, all setting it to 6 months is going to do is get me a lot of "Where the heck are my posts from 4-5 months ago?" ... Correct?< |
Switch the order of your title tags |
Edited by - bobby131313 on 14 February 2008 18:11:22 |
 |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 14 February 2008 : 21:15:47
|
quote:
Originally posted by bobby131313
Now it will only pull from the active table right?
So if I stay fairly tightly archived at 90 days, all setting it to 6 months is going to do is get me a lot of "Where the heck are my posts from 4-5 months ago?" ... Correct?
Right. Nothing from the archives.
From all the copy and pasting I did, there are a couple of references to the archive table left in the code, but they don't mean squat (just more clean up  ).< |
_-/Cripto9t\-_ |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 14 February 2008 : 21:44:24
|
One more bug that I noticed with my announcement post. This only occurs on a second save as a draft...
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' D_MESSAGE = '<font size=\"3\">[url=\"http://www.coincommunity.com/forum/user_sp' at line 1
/forum/inc_draft_info.asp, line 247
Interesting...
< |
Switch the order of your title tags |
Edited by - bobby131313 on 14 February 2008 22:43:51 |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 14 February 2008 : 21:49:03
|
I got the SQL to write..
UPDATE FORUM_DRAFTS SET FORUM_ID = 71, CAT_ID = , D_MESSAGE = '[url=\"http://www.coincommunity.com/forum/user_space.asp\"]No your CCF![/url] This may be the biggest new toy yet! Your own personal \"MySpace\" right here. Recent Topics First things first..... you can now see at a glance the last 2 months worth of topics that you posted in! This does not mean that you posted in it in the last 2 months... it means that you posted in it and someone has posted in it in the last 2 months. Cool huh? Two months worth of your active topics at your fingertips. Drafts You can now save drafts of all your posts. In addition to the \"post\" button, you will now see a \"Save as Draft\" button. Great for when your in the middle of a long post and realize the cat''s in the dryer. Or you want to wait to review it when you''re in a better mood. o|| Or you just want to save a good reply that you think you may need again. BookmarkingYou will see at the top of every topic and every reply a new icon,  , click it and you can bookmark the topic or reply. You can also bookmark pages outside coin community by clicking the Add My CCF Bookmarks link on the bookmark page. You''re allowed 100 bookmarks at any one time! Friends List You have another new icon above every post,  , click it to add that user to your buddy list. There''s 3 different levels of friends... Gold, Silver, and Copper. Have all your contact info together in one place. You can have 100 friends at any given time. There is a direct link to your My CCF page in the top menu now. Profile, Subscription, and Member List links have been moved to your My CCF page, since they can only be used by members anyway. If you see any bugs, be sure post in the support forum and to copy and paste any error messages you may get. Enjoy!  ', D_LAST_EDIT = '20080214214922', D_LAST_EDITBY = 2, D_IP = '71.200.32.85', D_SUBJECT = 'Your CCF, no My CCF ...' WHERE DRAFT_ID = 4< |
Switch the order of your title tags |
Edited by - bobby131313 on 14 February 2008 22:43:44 |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 14 February 2008 : 21:56:14
|
OK, previous was when you try to save the draft again.
Below is what happens when I tried to post the same post after saving as a draft and opening it again..
SELECT C.CAT_MODERATION, C.CAT_SUBSCRIPTION, C.CAT_NAME , F.F_MODERATION, F.F_SUBSCRIPTION FROM FORUM_CATEGORY C, FORUM_FORUM F WHERE C.CAT_ID = AND F.FORUM_ID = 71
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND F.FORUM_ID = 71' at line 1
/forum/post_info.asp, line 318 < |
Switch the order of your title tags |
Edited by - bobby131313 on 14 February 2008 22:43:37 |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 15 February 2008 : 00:10:07
|
I would love to say the problem was technical, but it was a loose nut between the seat and the monitor. 
When I did the first forum (that worked like a charm) I forgot the comments on 2 of the edits in post.asp, naturally when I copied the edits over to the other forum I searched for the comments......
Sorry. < |
Switch the order of your title tags |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 15 February 2008 : 06:57:42
|
Funny how that happens some times.  < |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 16 February 2008 : 17:45:45
|
I've just added this to my forum, using a MySql database, and it works well
The only problem I have with it is that with the options 'Bookmarks' and 'Friends' it shows the following error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: "Today 10:10:18 PM"]'
/forum/user_space.asp, line 1306
Sometime ago I added a Mod that changed the dates for a post made today to 'Today' and a post made yesterday to 'Yesterday' instead of the default dates and this is causing the mismatch
I'll have a look into how to get around this but if you have any ideas in the meantime I'd be greatful
Edit: This is the Mod for reference but unfortunately no longer available: http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=49255< |
Edited by - Webbo on 16 February 2008 17:53:43 |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 16 February 2008 : 18:07:56
|
Fix is in inc_function_common.asp around line 940. Search for....
' For any page that needs the actual date, add the file name to the above case statement.
Add user_space.asp to the list and the error will stop.
I plan on investigating adding the today/yesterday to this mod but haven't yet.< |
Switch the order of your title tags |
Edited by - bobby131313 on 16 February 2008 18:08:32 |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 16 February 2008 : 18:16:18
|
Brilliant Bobby 
I was half way to tearing the reaminder of my hair out trying to find where I made the changes in the files years ago < |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 16 February 2008 : 18:41:32
|
A useful addition would be to add the Private Messaging link to the Friends section 
Just taking a quick look at it we'd need to incorporate the following into user_space.asp:
#1: M.M_PMRECEIVE,
#2: If mlev > 2 and (Reply_MemberPM = "1" and strPMStatus = "1") Then
if Trim(Reply_MemberPM) <> "" then
Response.Write " <a href=""privatesend.asp?method=Topic&mname=" & ChkString(Reply_MemberName,"display") & """>" & getCurrentIcon(strIconPmprivatemessage2,"Send " & ChkString(Reply_MemberName,"display") & " a Private Message","align=""absmiddle"" hspace=""0""") & "</a>" & vbNewLine
#1 somewhere around Line 259 but tied in with the current coding
#2 at line 840 or thereabouts
Any ideas?
< |
Edited by - Webbo on 16 February 2008 19:09:48 |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 17 February 2008 : 07:52:51
|
quote:
Originally posted by Webbo
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: "Today 10:10:18 PM"]'
/forum/user_space.asp, line 1306
On line 1306 change this part
chkDate(eDate,"",true)
to thisStrToDate(eDate)
Line should now look like thisif DateDiff("d",StrToDate(eDate),strForumTimeAdjust) <= intIsNew then blnDate = true
That looks like a better way to go anyway ,
so it will be the first change for the next update.< |
_-/Cripto9t\-_ |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 23 February 2008 : 03:46:01
|
There's a discrepency in the coding for the 'Friends' add on
In the file pop_userspace.asp it allows you to choose levels of friends as A, B, or C
Yet in the 'Friends' panel in 'Your Space' it shows those freinds as levels 1, 2, or 3
This is easily fixed by replacing line 467 in pop_userspace.asp with the following:
Response.Write "<b>Level:</b> 1. <input type=""radio"" name=""level"" value=""0"" checked /> 2. <input type=""radio"" name=""level"" value=""1"" /> 3. <input type=""radio"" name=""level"" value=""2"" /><br />"
Any news on adding the Private Message link to the Freinds section?< |
|
|
|
Topic |
|
User Space 1.1.02 (last update 02/14/08)
