| Author |
 Topic  |
|
dayve
Forum Moderator
USA
5820 Posts |
 Posted - 18 November 2001 : 16:05:25
|
IH just confirmed that the value for Average Length is indeed hard coded so I would use the SQL statement I provided. I think I am gonna take a chance and dynamically read the value and monitor performance on my board but for now I am changing my hard coded value...
btw, anyone needed to get this value can take the SQL statement I noted above and plug it into an Access Query or better yet, if you cannot download your database because the size is too big, just plug the query into Table Editor fro 2eNetWorx which is a must have tool for remote administration of your database.
____________
dayve
http://www.nineinchnailz.com/forum
Edited by - dayve on 18 November 2001 16:07:03 |
 |
|
|
Raichelle
Junior Member
370 Posts |
Posted - 18 November 2001 : 21:37:03
|
well i have not added this mod on my forum yet since my domain been down forever i guess thanks to hostonce but anyways i saw it on dayve forum (which is one of the best snitz forum ) and it looks really great
add on request if you could add these
When someone clicked on the graphs can it open like a little pop up window like the pager window and on that page it show everyone that posted on that topic and also you can click on there name which will open there profile page.
I saw this on vbulletin which was great.
good mod though I am going add this as soon as my domain is back up
rai 
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 18 November 2001 : 21:49:46
|
NOOOOOOOO you blew my cover!!!
I'm currently working on that one!!! AND Im also adding where you can see who VIEWED the topic - I too saw it on a vbulliten but I'm making it better.
If you wanna see the progress so far, check out my forums http://yapit.cjb.net
----
-Eric (da_stimulator)
Stims Snitz Test area
Snitz Mod Resource
PHP Script Center -Quality PHP Scripts |
|
|
|
Raichelle
Junior Member
370 Posts |
Posted - 18 November 2001 : 22:13:07
|
oooo
great great job
those where one of the feature on the new vbulletin that had me wanting to use my vbulletin forum instead of snitz but then am like naw am sure one of you guys can do something
so far all the the features on vbulletin i wanted on my snitz forum been created except for the birthday on the front forum and also the referer feature but the birday one is being worked on i noticed and now hopefully someone will work on the referer mod
can't wait for what you are working on right now to be released another great addon
lovely rai
|
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 21 November 2001 : 13:46:10
|
Raichelle,
I have packaged up the birthday mod, (from the assorted garble in the birthdate topic).
You can have it as it stands if you want, but I personally think it's a bit "rough around the edges"
Back to the topic in hand, did we ever discover what the hard coded red items are?
Cheers Az
-------
Eagles fly!, but weasels don't get sucked into jet engines. |
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 21 November 2001 : 14:04:57
|
Hmm,
Unless I'm missing something here, I went away and calculated my average length, but could not the average length = anywhere in the code.
Am I missing something very obvious?
Cheers Az
-------
Eagles fly!, but weasels don't get sucked into jet engines. |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 21 November 2001 : 14:14:05
|
search for AvLength
it shows right after this:
tempLength = Len(rs("T_MESSAGE"))
____________
dayve
http://www.nineinchnailz.com/forum
Edited by - dayve on 21 November 2001 14:14:50 |
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 21 November 2001 : 14:24:17
|
okies, that was a tad obvious - sorry about that..
Thanks tho' Az
-------
Eagles fly!, but weasels don't get sucked into jet engines. |
|
|
|
fickle
New Member
83 Posts |
Posted - 21 November 2001 : 18:53:23
|
i was wanting to implement this mod.. however, i was looking at your *.asp files which have the modifications in it.. and cause of that i opted not to do the modifications. reason being is that it seems that you have a couple of mods already on those files. i dont want to replace the files with yours just in case i dont have those mods.
is there another way of installing?
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 21 November 2001 : 19:07:23
|
I dont know what files you are talking about. Each file that has the prefix readme_ has explicit instructions on how to install, they are not a program within themselves.
dbs_topicinfo.asp you need to upload to do database changes
The rest are image files...
The entire content of each readme is not to be replaced in your original files, - just follow the directions implied inside of the files prefixed with readme_
----
-Eric | Mod Resource | Test Area
Sleep: A completely inadequate substitute for caffeine
http://phpscriptcenter.com -Quality PHP Scripts |
|
|
|
Kenno
Average Member
Cambodia
846 Posts |
Posted - 22 November 2001 : 11:25:46
|
quote:
btw, anyone needed to get this value can take the SQL statement I noted above and plug it into an Access Query or better yet, if you cannot download your database because the size is too big, just plug the query into Table Editor fro 2eNetWorx which is a must have tool for remote administration of your database.
____________
dayve
http://www.nineinchnailz.com/forum
Edited by - dayve on 18 November 2001 16:07:03
Can you explain in a bit more details how can we do it?
÷§÷ KhmerSite.net ÷§÷ |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 22 November 2001 : 17:15:02
|
quote:
quote:
btw, anyone needed to get this value can take the SQL statement I noted above and plug it into an Access Query or better yet, if you cannot download your database because the size is too big, just plug the query into Table Editor fro 2eNetWorx which is a must have tool for remote administration of your database.
____________
dayve
http://www.nineinchnailz.com/forum
Edited by - dayve on 18 November 2001 16:07:03
Can you explain in a bit more details how can we do it?
÷§÷ KhmerSite.net ÷§÷
explain Using the Query in Access or the remote table editor from 2eNetWorx?
____________
dayve
http://www.nineinchnailz.com/forum |
|
|
|
Kenno
Average Member
Cambodia
846 Posts |
Posted - 22 November 2001 : 18:54:09
|
Explain Using the Query in Access, please.
÷§÷ KhmerSite.net ÷§÷ |
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 22 November 2001 : 18:57:09
|
Dayve,
Do you use Access?
Just pondering...
Az
-------
Eagles fly!, but weasels don't get sucked into jet engines. |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 22 November 2001 : 19:19:20
|
quote:
Dayve,
Do you use Access?
Just pondering...
Az
-------
Eagles fly!, but weasels don't get sucked into jet engines.
for my current version of 3.1, yes, but for 3.3 I am going to use SQL 2000
____________
dayve
http://www.nineinchnailz.com/forum |
|
|
|
Topic |
|
Topic Locked
