| T O P I C R E V I E W |
| Webbo |
Posted - 14 October 2012 : 15:56:08
Is it possible to create a page where a member can put in their name and enter a number relevant to their post count to find that particular post?
Eg:
Member name [Bill] (member's name)
Post No. [1] (Search criteria where 1 is the number of the post that they are searching for)
Result to show either the post within the thread or a link to the thread where the post was made
|
| 11 L A T E S T R E P L I E S (Newest First) |
| Carefree |
Posted - 06 November 2012 : 03:11:40
quote:
Originally posted by Etymon
1) Create a table (and related code) that tracks that sort of thing.
MemberID TopicID ReplyID PostID
23915 70326 4005333 2767
or ...
2) Add related code and a column to each of the the topics and reply tables (such as PostID) that tracks the post # of the post author. 
That would work, but would be a pain to calculate all the topics & replies in chronological order for each member if the board has been active for any length of time. |
| Etymon |
Posted - 05 November 2012 : 04:54:58
1) Create a table (and related code) that tracks that sort of thing.
MemberID TopicID ReplyID PostID
23915 70326 4005333 2767
or ...
2) Add related code and a column to each of the the topics and reply tables (such as PostID) that tracks the post # of the post author.
|
| Carefree |
Posted - 31 October 2012 : 10:18:19
Help yourself, Webbo. I'm glad it gave you a starting point. |
| Webbo |
Posted - 31 October 2012 : 02:24:51
Thanks Carefree, it works well with non archived posts but a definate starting point.
I'll have a look at it later to add an additional search for archived replies, perhaps even combining the topics version as well
Now look what you've started  |
| Carefree |
Posted - 29 October 2012 : 06:18:48
Here's one which is based upon replies only. There are a couple of little enhancements to the topic version above. The post/reply requested is shown in the hilite font color and links to replies on subsequent pages will jump directly to them.
|
| Carefree |
Posted - 16 October 2012 : 04:21:06
Yes - or since I didn't include replies, 150th topic. In order to include replies in order, the routines have to be rewritten to sort the dates from both tables. |
| HuwR |
Posted - 16 October 2012 : 02:22:31
it would show the 150th post of what remained after deletions? |
| Webbo |
Posted - 15 October 2012 : 17:19:35
Hi Carefree, that works well finding the Topics that a member has started by number, however is it possible to modify it so that it finds Posts by number?
Good point HuwR. Would a search then return an error because the post could not be found or do you mean that it would show the 150th post of what remained after deletions? |
| Carefree |
Posted - 15 October 2012 : 17:05:01
Took that into consideration - it's only going to count/display existing posts. So if a post is deleted, the member's count is likely to be off. |
| HuwR |
Posted - 15 October 2012 : 11:12:28
The only problem here is that your post count may not actually match the number of posts in the database, when a post is deleted the members post count is not changed so you could have a post count of 300 but there are only 200 of your posts in the database so the two values would not match, so what is your 150th post ? |
| Carefree |
Posted - 15 October 2012 : 00:44:55
Yes, that wouldn't be difficult. The problem would be in remembering which post number to check LOL. I'll write it for you later today.
Here you go. This is untested, but it should work.
|
