lastest topics (creator of topics) |
Post Reply ![]() |
Page <123> |
Author | ||
Matt ![]() Admin Group ![]() Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
![]() ![]() ![]() ![]() |
|
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 |
![]() ![]() ![]() ![]() |
|
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 |
![]() ![]() ![]() ![]() |
|
?
|
||
![]() |
||
Matt ![]() Admin Group ![]() Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
![]() ![]() ![]() ![]() |
|
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 |
![]() ![]() ![]() ![]() |
|
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 |
![]() ![]() ![]() ![]() |
|
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 |
![]() ![]() ![]() ![]() |
|
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 |
![]() ![]() ![]() ![]() |
|
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 |
![]() ![]() ![]() ![]() |
|
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 |
![]() ![]() ![]() ![]() |
|
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.063 seconds.