| Author |
 Topic  |
|
Gato
New Member
Brazil
92 Posts |
 Posted - 14 September 2002 : 19:31:48
|
| Has anyone done this, where the psot count of the members are upgraded counting how many replies and opics he/she hahs post, and upgrading in the post count field??? |
Get the new Gato's MultiLanguage Portal Code with 6 Languages Included and more than 70 MODs & 30 New Features
Get more information here |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 14 September 2002 : 19:43:27
|
say what? I'm lost   |
 |
 |
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 14 September 2002 : 20:28:06
|
i guess what Gato mean....
the Total Posts information shown on topic/member/profile.. pages..
ˇ@ 10 posts
"upgraded" it to..
ˇ@ 3 topic
ˇ@ 6 replies
ˇ@(1 deleted !?) |
~ . .. .. .~ .~~ |
|
|
|
Gato
New Member
Brazil
92 Posts |
Posted - 14 September 2002 : 21:01:31
|
| Yes, something like that. Because when you delete, it doesnt take out members post count, so a way to upgrade all members post count, so if it was 10 and you have deleted a topic with 3 replies of him and was his topic, it will be 6 the post count after updating it by this page... |
Get the new Gato's MultiLanguage Portal Code with 6 Languages Included and more than 70 MODs & 30 New Features
Get more information here |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 14 September 2002 : 22:06:51
|
hi~ Gato,
i have a related question about this issue before..
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=30456
and Richard also released a "alternative" code(pop_delete.asp) can update the M_POSTS value when user delete their post. if you just want to get the "real" or "still exist" posts of a member, i think this's a most easiest way to do it.
try this ~
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=6769
but it'll also lose something... if you doing this fix. 
the original idea for M_POSTS, just want to show the member have had how many posts made, no matter it's deleted or not. i think this also a important record on forum.... so it really a dilemma for me...
i have a idea and try to do it before.. keep the original M_POSTS(xxx) remain, but get the "real" posts(yyy) by another way..
xxx Posts (yyy)
i know you just can from TOPICS and REPLY table get the total posts count of one member. but it seem not so good and also "uneconomical".. so i give up this idea later. 
if someone have better way to do this mod/implement, i'll expect eagerly ! |
|
|
|
Gato
New Member
Brazil
92 Posts |
Posted - 14 September 2002 : 23:34:27
|
| thanks for the link, I think that is not so difficult but I amm not too god in using counting in dbs... |
Get the new Gato's MultiLanguage Portal Code with 6 Languages Included and more than 70 MODs & 30 New Features
Get more information here |
|
|
|
James
Average Member
USA
539 Posts |
Posted - 28 September 2002 : 16:53:38
|
quote:
Originally posted by DoraMoon
and Richard also released a "alternative" code(pop_delete.asp) can update the M_POSTS value when user delete their post. if you just want to get the "real" or "still exist" posts of a member, i think this's a most easiest way to do it.
try this ~
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=6769
Has this been updated for 3.4? And if so, do the Archive and Delete Archive features ignore post counts so that Archive features will not decrease the post count? |
*Interested in Radio Control*
*The RC Web Board - http://www.rcwebboard.com/* |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 28 September 2002 : 23:53:47
|
quote:
Originally posted by James
Has this been updated for 3.4? And if so, do the Archive and Delete Archive features ignore post counts so that Archive features will not decrease the post count?
hi~ James,
i don't think this will be "updated" to 3.4, it's not a Mod, just a alternative pop_delete.asp file for someone may need this M_POSTS count method.
but if you want to do this in 3.4, i think it's also available..
as i know, Richard's pop_delete.asp "fixed" file, just add a extra SQL statement to UPDATE the M_POSTS value when...
if Mode_Type = "DeleteReply" then
and
if Mode_Type = "DeleteTopic" then
i think you also can add these code on 3.4, just try to compare it with a original 3.3 pop_delete.asp file to see where Richard add these extra code.. and insert somewhere in 3.4 pop_delete.asp.
and regarding the Archive.. it did'nt do anything change to M_POSTS when archive or delete archived posts. but it will update the Posts count that show on default or forum pages...
(i think the "Member Posts" count is something difference with the "Posts Count" in forum...) |
|
|
|
Aquillar
Starting Member
Canada
41 Posts |
Posted - 29 September 2002 : 18:33:28
|
It's not working...lol
Error Type:
Microsoft VBScript runtime (0x800A01C2)
Wrong number of arguments or invalid property assignment: 'chkUser2'
/forums/pop_delete.asp, line 184 |
 |
|
|
|
Aquillar
Starting Member
Canada
41 Posts |
Posted - 02 November 2002 : 12:21:51
|
| ^^ Bump ^^ |
|
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 02 November 2002 : 13:45:11
|
hi~ Aquillar,
have you compared the fixed pop_delete.asp with original 3.3 file to see where Richard modified ??
there are NO "chkUser2" on 3.4 pop_delete.asp code, not sure why you'll get this strange error......
anyway, here is modified pop_delete.asp --- Decrease_M_POSTS_Count_pop_delete.zip
(base on a clean v3.4 pop_delete.asp..)
just search '##### Decreasing M_POSTS Count to know where to modify, total 6 place code add/change.
hope this helpful.. |
|
|
|
Aquillar
Starting Member
Canada
41 Posts |
Posted - 15 November 2002 : 19:53:48
|
I'm not sure what you mean, but after downloading and trying that, the post count goes down accordingly, but it doesn't get deleted, and I get this error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forums/pop_delete.asp, line 281
:S |
|
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 15 November 2002 : 20:48:02
|
hi~ Aquillar,
i seem wrong place one line code, sorry for this mistake... 
change the line.281
set rsb = my_Conn.Execute (strSql)
tReply_Author = rsb("R_AUTHOR")
do until rsb.EOF
to this...
set rsb = my_Conn.Execute (strSql)
do until rsb.EOF
tReply_Author = rsb("R_AUTHOR")
update the zip file, please try it again. thx. |
|
|
|
Aquillar
Starting Member
Canada
41 Posts |
Posted - 08 December 2002 : 11:36:07
|
| aren't those 2 the exact same thing?? |
|
|
|
|
James
Average Member
USA
539 Posts |
Posted - 08 December 2002 : 15:43:55
|
quote:
Originally posted by Aquillar
aren't those 2 the exact same thing??
Aquillar, look at DoraMoon's post again. It's the same lines, but in different places. |
*Interested in Radio Control*
*The RC Web Board - http://www.rcwebboard.com/* |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 09 December 2002 : 08:57:19
|
yes, it's really different when that line.. tReply_Author = rsb("R_AUTHOR") "outer" or "inner" the do until... loop.
i should find this BIG mistake at first time, if i'm not so lazy...
the old code will also work if all replies just the same one author. it's mean if i logout, login as another account and posting, the wrong place of that line should be obvious when i tested these code.
sorry again for my inertia mistake. i'll more carefully about this testing work next time. |
Edited by - DoraMoon on 09 December 2002 09:00:02 |
|
|
|
Topic |
|
Topic Locked
