| Author |
 Topic  |
|
masterao
Senior Member
Sweden
1678 Posts |
 Posted - 08 November 2003 : 21:55:17
|
| Thanks for the praise, Astralis. Hopefully I will be able to test if it works properly on mssql in the next two weeks, if no one else has already done so. As for mysql, I hope to get some help from laser, as soon as webbo's reported error (and any future mysql errors) have been fixed. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
Edited by - masterao on 08 November 2003 22:08:00 |
 |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 08 November 2003 : 22:25:07
|
webbo, if laser's advice don't help, test with the following instead:
if boolIgnore = True then '# Member exists on the ignorelist, so we delete it.
strSql = "DELETE FROM " & strTablePrefix & "IGNORE_POSTS I where I.I_MEMBERID = " & memberID & _
" AND I.I_IGNOREID = " & intIgnoreID & ";"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
richfed, you are quite right in that it doesn't work on multiple pages. The fix for that is:
The first change in topic.asp should look like the following (the code for the mod should be inserted before calling the sub Getfirst, which is only shown on the first page  ):
'## Ignore post mod. Lets poulate the array with the ignored members ID
if strIgnorePost = "1" then
arrIgnoreMemberList = IgnoreMemberList()
end if
'## Ignore post mod
if mypage = 1 then
Call GetFirst()
end if
'## Forum_SQL
strSql = "UPDATE " & strActivePrefix & "TOPICS "
strSql = strSql & " SET T_VIEW_COUNT = (T_VIEW_COUNT + 1) "
strSql = strSql & " WHERE (TOPIC_ID = " & Topic_ID & ")"
my_conn.Execute (strSql),,adCmdText + adExecuteNoRecords
Richfed, do you have the More Stars mod (or another similar mod) installed? The error for 'getStar_Level' sounds like that. If so, pop_viewpost.asp will work if you replace getStar_Level(Member_Level, Member_Posts) with the modified getStar_Level function you use.
I'll look into the other error you recieved when Im able to test in on mssql. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
Edited by - masterao on 08 November 2003 22:48:15 |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 09 November 2003 : 01:14:09
|
Hi Jan,
Yes laser's fix worked well.
I did also run your suggestion which didn't work
The second fix of yours for multiple pages worked and so far with MySql everything seems okay
One suggestion maybe is that when a user [Un Ignore]'s another, is for the topic page to auto refresh to then show all posts after the pop_ignorelist window closes
Very good Mod |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 09 November 2003 : 05:19:41
|
quote:
Originally posted by masterao
Richfed, do you have the More Stars mod (or another similar mod) installed? The error for 'getStar_Level' sounds like that. If so, pop_viewpost.asp will work if you replace getStar_Level(Member_Level, Member_Posts) with the modified getStar_Level function you use.
I'll look into the other error you recieved when Im able to test in on mssql.
Yes ... after I posted that, I realized it was caused by the Additional Stars Mod. I think I can fix that; I had similar issues before & was able to resolve them.
Will hang tight until you learn what causes the 2nd error - on UnIgnore User.
Thanks - looks like a great Mod-to-be!
EDIT ----> I think that modified function is: getStar_Level(TMember_ID, Member_Level, Member_Posts) |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
Edited by - richfed on 09 November 2003 09:02:47 |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 09 November 2003 : 15:59:53
|
Im glad that laser's fix worked, webbo. I will add his fix along with the multiple pages fix and update the mod. I will also add the auto-refresh for topic.asp, when a member has un-ignored a user.
richfed, you are correct about the modified function (I use the same mod on my website). I will make a mention of this in the readme, so that others will be aware of it. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 09 November 2003 : 16:58:08
|
| Might the fix for Webbo's MySQL problem work for SQL Server? We both had basically the same problem, though a different error message. Do you think? |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 09 November 2003 : 18:04:14
|
| I think it might, richfed. As there is only one table used in that query, there is no need to use aliases for it. So if you could test it out, I would appreciate it . |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 10 November 2003 : 05:50:27
|
Jan -
I used your updated files and now it's all working beautifully! Multiple page threads, view post, unignore user, and refresh all work. I can find no problems! Looks like it now works on SQL Server!
Thanks! |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
Topic |
|
Topic Locked
