| Author |
 Topic  |
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
|
|
Morten
Junior Member
Denmark
251 Posts |
 Posted - 16 November 2001 : 23:40:32
|
This looks good!
But how can I change the values for the bars ? - my forum have about 4-8 new messages per day - that don´t really rocks the bars!
And could you explain what they acually do count ?
Best from
Morten
|
 |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 17 November 2001 : 00:11:28
|
They're calculated based on things such as average amount of replies, replies in that topic, the dime difference between each reply, when the latest reply was, the lenght of the topic and all replies (in charecters) etc etc...
----
-Eric (da_stimulator)
Stims Snitz Test area
Snitz Mod Resource
PHP Script Center -Quality PHP Scripts |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 November 2001 : 01:54:25
|
quote:
yes seems I forgot the link in my credits woops :) I updated it.
----
-Eric (da_stimulator)
Stims Snitz Test area
Snitz Mod Resource
PHP Script Center -Quality PHP Scripts
oh, dude, hope you didn't take that the wrong way. I noticed you didn't take the credit but IH and I have worked online a lot together and I recognized the mod is all. I am glad you packaged it and offered to support it.
the only thing that has stopped me from running this in the past is the overhead I think it may create but I just realized I have incorporated a personal settings mod that I can have my members turn it on or off to their liking.
____________
dayve
http://www.nineinchnailz.com/forum |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 17 November 2001 : 01:59:07
|
The only overhead I see is calling the T_MESSAGE from the table (which can be big sometimes)... I'm currently working on an alternate way of doing this.
I didnt take it the wrong way, its just that I like linking to the rightful authors of something if it does not belong to me :) IH was good enough to give me the code and permission to release it, I felt I should link to him :)
----
-Eric (da_stimulator)
Stims Snitz Test area
Snitz Mod Resource
PHP Script Center -Quality PHP Scripts |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 November 2001 : 03:24:03
|
well, I did notice that you took care of that in all the readme files... I also see that you packaged this as if it was being installed on 3.3 I HATE YOU  j/k
____________
dayve
http://www.nineinchnailz.com/forum |
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 17 November 2001 : 09:24:52
|
Hurrah!!!
I've been looking for this :)
*rushes off to install and break*
Cheers Az
-------
Eagles fly!, but weasels don't get sucked into jet engines. |
|
|
|
extrafree
New Member
54 Posts |
Posted - 17 November 2001 : 12:00:58
|
ok ok I have integrated this mode in my 3.1 forum version just with this modified.
in forum.asp find this:
'###-------ADDED FOR INFO
strSql = strSql & strActivePrefix & "TOPICS.T_DATE, "
strSql = strSql & strActivePrefix & "TOPICS.T_MESSAGE, "
strSql = strSql & strActivePrefix & "TOPICS.T_LENGTH, "
'###-------END ADDED
replace all with this:
'###-------ADDED FOR INFO
strSql = strSql & strTablePrefix & "TOPICS.T_DATE, "
strSql = strSql & strTablePrefix & "TOPICS.T_MESSAGE, "
strSql = strSql & strTablePrefix & "TOPICS.T_LENGTH, "
'###-------END ADDED
now in post_info.asp find this:
'##-------ADDED FOR TOPIC INFO
tmpUpdateLength = Len(txtMessage)
tmpSql = "SELECT T_LENGTH FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID=" & Topic_ID
set temprs = my_conn.execute(tmpSql)
tmpUpdateLength = temprs("T_LENGTH") + tmpUpdateLength
set temprs = nothing
strSql = strSql & ", T_LENGTH = " & tmpUpdateLength
'##-------END ADDED
replace all with this:
'##-------ADDED FOR TOPIC INFO
tmpUpdateLength = Len(txtMessage)
tmpSql = "SELECT T_LENGTH FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID = " & Request.Form("TOPIC_ID")
set temprs = my_conn.execute(tmpSql)
tmpUpdateLength = temprs("T_LENGTH") + tmpUpdateLength
set temprs = nothing
strSql = strSql & ", T_LENGTH = " & tmpUpdateLength
'##-------END ADDED
thats all!!
the italian golden forum
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 November 2001 : 13:04:39
|
I was just coming back to give you the 3.1 fixes and you got them already... I guess both of us have nothing to do this weekend. The things that you have edited and everyone else should make note of is:
all code showing strActivePrefix needs to be replaced with strTablePrefix
and
tmpSql = "SELECT T_LENGTH FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID=" & Topic_ID Request.Form("TOPIC_ID")
Topic_ID needs to be replaced with Request.Form("TOPIC_ID")
gonna upload mine here is a sec...
____________
dayve
http://www.nineinchnailz.com/forum |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 November 2001 : 19:37:24
|
Stim, after reviewing the code I noticed this:
Average Length = 17792.3616236162
which made me realize, each forum will have a different value so I ran a query against my forum using this little tidbit:
SELECT Avg(Len(FORUM_REPLY.R_MESSAGE))
FROM FORUM_REPLY;
and I come up with this:
Average Length = 412.853213618266
now instead of hard coding this value I wonder if it would just be better to tet Average Length every time the page is loaded for a more reliable and dynamic figure?.. Your thoughts?
____________
dayve
http://www.nineinchnailz.com/forum
Edited by - dayve on 17 November 2001 19:39:02 |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 November 2001 : 19:46:48
|
ok, maybe its me and I think I will ask IH but looks as if more hard coding is in the script that requires some definition. Look at the following:
Some numbers I don't understand (in red)
ReplyProb = int(19*rs("T_REPLIES")*2/(rs("T_VIEW_COUNT")+1))+1
ContrProb = int(10*((rs("T_LENGTH")-len(rs("T_MESSAGE")))/(rs("T_REPLIES")+1))/(AvLength/RPT))
alive = int((rs("T_REPLIES")*LI)/((intAge+intRage)/12))
Performance = int(5*((rs("T_REPLIES")*rs("T_LENGTH")) / (RPT*AvLength)))
the numbers in read don't make sense...well, to me that is...
____________
dayve
http://www.nineinchnailz.com/forum
Edited by - dayve on 17 November 2001 20:04:18 |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 17 November 2001 : 20:31:46
|
I as well dont understand them... I just wrapped it up, didnt change anything...
I'll incorperate the code change you noted when I release the next 'version' - which will not need to call T_MESSAGE from the table, making less overhead.
----
-Eric (da_stimulator)
Stims Snitz Test area
Snitz Mod Resource
PHP Script Center -Quality PHP Scripts |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 18 November 2001 : 15:45:42
|
quote:
IH set this:
Average Length = 17792.3616236162
I ran this:
SELECT Avg(Len(FORUM_REPLY.R_MESSAGE))
FROM FORUM_REPLY;
and I come up with this:
Average Length = 412.853213618266
Stim, what do you think of the above? sound legit? I made the changes on my demo forum and my bars significantly changed, I think for the better...
____________
dayve
http://www.nineinchnailz.com/forum |
|
|
|
Topic |
|
Topic Locked
