| Author |
 Topic  |
|
|
HarshReality
Junior Member
USA
128 Posts |
 Posted - 16 May 2002 : 14:48:20
|
Does anybody know of a Mod that will put the actual post count in a post, would work similar to the post stamp mod. have toyed with the idea but cant get it hammered out and wondering if anybody knows of a Mod anywhere.
Oh what wonders await we the ****ed in exile, for in a single act of rage I have slain what little humanity I have left and all that remains is the beast.... |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
|
|
HarshReality
Junior Member
USA
128 Posts |
Posted - 17 May 2002 : 02:28:09
|
No but that is a kewl mod, I was thinking along the lines of dayve's idea. I asked but he has been so busy I don't want to like hound at him.
http://dayve.d2g.com:8010/forum/topic.asp?TOPIC_ID=1596
if you look in the lower right of a post its labeled as "Post ID:"
that number represents the posts placment in the whole or the actual post number.
Update: Figured it out, now just have to establish how to update pre-existing posts with the number.
Oh what wonders await we the ****ed in exile, for in a single act of rage I have slain what little humanity I have left and all that remains is the beast....
Edited by - HarshReality on 17 May 2002 04:00:50 |
 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 17 May 2002 : 05:00:22
|
I had that mod installed a long time ago, from memory an extra column was inserted into _TOPICS and _REPLIES that contained the users current post count, and this was just used in conjunction with their total post count to display the info.
To update you databases with past post info your just going to have to write a script to go through and update each topic and reply for each member. If you've got a large database this could be troublesome to get working though with timeouts etc.
www.daoc-halo.com |
|
|
|
HarshReality
Junior Member
USA
128 Posts |
Posted - 17 May 2002 : 06:51:16
|
ahh the mod your talking about is the post stamp, have that already in and can be turned on or off from admin options ;).
What I have to do now is locate a script that will take all posts/topics and number them in the order they were written in the order they were written (by date) into the fields added to topics and reply (T_POST_NO and R_POST_NO) I get a headache just trying to think about it, lol
Oh what wonders await we the ****ed in exile, for in a single act of rage I have slain what little humanity I have left and all that remains is the beast.... |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 17 May 2002 : 09:34:34
|
That paritcular mod originally was supplied with a script to do just that conversion.
www.daoc-halo.com |
|
|
|
HarshReality
Junior Member
USA
128 Posts |
Posted - 18 May 2002 : 22:03:20
|
Actually no, they are 2 different mods, one (the one your talking about) was the post # and count per member the mod I just got going is for post # and count for the forum whole reguardless of member.
there are 2 areas and 2 different tables that would have to be numbered in sequence. T_POSTS and R_POSTS each would have to be ordered and numbered accordingly by date and then the numbers placed into T_POST_NO for T_POSTS and R_POST_NO for R_POSTS. I know it sounds simple but for me I can see it but doing it seems an impossibility. I guess it would be simple to organize each table and then number it by date but to do BOTH tables and have it number accordingly I cant even begin to imagine.
Oh what wonders await we the ****ed in exile, for in a single act of rage I have slain what little humanity I have left and all that remains is the beast.... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 May 2002 : 23:48:29
|
quote:
I guess it would be simple to organize each table and then number it by date but to do BOTH tables and have it number accordingly I cant even begin to imagine.
A union query can do that easily...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 May 2002 : 23:56:02
|
Ok, here you have the SQL:
SELECT FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_DATE, 'T' AS Type
FROM FORUM_TOPICS
ORDER BY T_DATE
UNION
SELECT FORUM_REPLY.REPLY_ID, FORUM_REPLY.R_DATE, 'R' AS Type
FROM FORUM_REPLY
ORDER BY T_DATE ;
This will create a recordset with all the topics and replies, ordered ascending by date, with the Type column, indicating whether each record is a topic or a reply, so that you know where did it come from.
I guess this allows you to solve your problem, no?
<edit>Forgot to mention that this will not work on the most popular database for the Linux OS, MySQL. They don't support UNIONs yet...</edit>
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 19 May 2002 00:08:55 |
|
|
| |
Topic |
|
Topic Locked
