lastest topics (creator of topics) |
Post Reply | Page <123> |
Author | ||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Post Options Quote Reply Posted: 30 Oct 2009 at 11:08am | |
All you need to do is simply add extra cells for the field.
Add one to the header where the above values are, and add one after the date like so:
Though, if you want the original poser and the last poster together, you will need to rename the variable to a unique ID in the code I previously posted in this thread. |
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 01 Nov 2009 at 2:32pm | |
I have now added the cells, but i dont understand the second part with the unique id you are explaying for me..
My code looks like this now with the extra cell:
Can you show me what i need to change and with what code here mate.? Edited by macpack - 01 Nov 2009 at 2:33pm |
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 07 Nov 2009 at 5:14pm | |
?
|
||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Post Options Quote Reply Posted: 08 Nov 2009 at 10:54am | |
I am afraid that you will need to replace the Powered By link.
If you do not wish to display the Powered By link, you can purchase a licence here. |
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 08 Nov 2009 at 12:35pm | |
Hey again scotty, ahh sorry i have now paided:
Transaktions-ID: *removed*
Betalningsgodkännandet för ditt köp från *removed* har skickats. Edited by Scotty32 - 13 Aug 2010 at 12:28pm |
||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Post Options Quote Reply Posted: 09 Nov 2009 at 2:01pm | |
Alter this part:
You then use these two new variables to display the Original Poster You will need to define these variables like so:
|
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 10 Nov 2009 at 6:35pm | |
yeaH it now works.. thanks bigtime mate.
and then do i get the serial lincense.?
|
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 13 Aug 2010 at 12:02pm | |
Hey Again Scotty, is is possible you can change the script so it only shows the lasted 10 post in a specific category.?
|
||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Post Options Quote Reply Posted: 14 Aug 2010 at 11:35am | |
If you want one specific forum simply add the following just before the "ORDER BY" line in the "includes/s2h_latest-topics.asp" file's SQL statement:
Change the number one to the forums ID number. if you mean a forum category (group of forums) just do the same as above but with the following code:
One being the Categorys ID though I dont know off the top of my head what the actual field is called, so if that doesnt work check the tblForum table for the category IDs field name. |
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 27 Aug 2010 at 6:01am | |
Hey Scotty, i have tryed to do what you say, but i´ll think am doing something wrong..
I have changed it, so it looks like this now:
strSQL = strSQL & "AND (" & strDbTable & "Forum.Password = '' OR " & strDbTable & "Forum.Password Is Null) " strSQL = strSQL & "AND (" & strDbTable & "Topic.Hide = " & strDBFalse & " AND " & strDbTable & "Thread.Hide = " & strDBFalse & ") " & _ strSQL = strSQL & "AND " & strDbTable & "Forum.Cat_ID = 2 " & _ "ORDER BY " & strDbTable & "Thread.Thread_ID DESC" The red one is the new changed part..
It comes out the a fault..
It Says this:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [MySQL][ODBC 3.51 Driver][mysqld-5.1.30-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'False LIMIT 10' at line You know what i can do mate.? Edited by macpack - 27 Aug 2010 at 6:12am |
||
Post Reply | Page <123> |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.092 seconds.