New Posts New Posts RSS Feed - lastest topics (creator of topics)
  FAQ FAQ  Forum Search   Register Register  Login Login

lastest topics (creator of topics)
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post Topic: lastest topics (creator of topics)
    Posted: 13 Sep 2010 at 11:21pm
thank you very very much my friend.
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Post Options Post Options   Quote Matt Quote  Post ReplyReply Direct Link To This Post Posted: 13 Sep 2010 at 11:15pm
If you want to show from more than one category it would be:

"AND (" & strDbTable & "Forum.Cat_ID = 1 OR " & strDbTable & "Forum.Cat_ID = 2 OR " & strDbTable & "Forum.Cat_ID = 3 OR " & strDbTable & "Forum.Cat_ID = 3) " & _


Obviously changing the ID numbers to the ones you want.
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post Posted: 13 Sep 2010 at 10:39pm

Hey again scotty,

How can i show exempel 4 cats in this script.?


Now it only shows 1 forum cat if i change it to:
  "AND " & strDbTable & "Forum.Cat_ID = 3 " & _


But how can i change it, so i can show 4 different Forum Cats.?

Regards
André
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post Posted: 27 Aug 2010 at 3:35pm
Perfect now it works mate... Thanks you very very much for the big help you always give me, and thanks for the time..
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Post Options Post Options   Quote Matt Quote  Post ReplyReply Direct Link To This Post Posted: 27 Aug 2010 at 12:33pm
take out the ' strSQL = strSQL & ' part of the red section, it shouldnt be there
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Post Options Post Options   Quote Matt Quote  Post ReplyReply Direct Link To This Post 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:

    strSQL = strSQL & "AND " & strDbTable & "Forum.Forum_ID = 1 " & _


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:

    strSQL = strSQL & "AND " & strDbTable & "Forum.Cat_ID = 1 " & _


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.
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post 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.? TongueTongue
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post Posted: 10 Nov 2009 at 6:35pm
yeaH it now works.. thanks bigtime mate.
and then do i get the serial lincense.?
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Post Options Post Options   Quote Matt Quote  Post ReplyReply Direct Link To This Post Posted: 09 Nov 2009 at 2:01pm
Alter this part:


strSQL = "SELECT " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Username FROM " & strDbTable & "Thread, " & strDbTable & "Author WHERE " & strDbTable & "Thread.Topic_ID = " & lngS2HLTTopicID & " AND " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID ORDER BY " & strDbTable & "Thread.Thread_ID ASC"                  
rsCommon.Open strSQL, adoCon
if NOT rsCommon.EOF or NOT rsCommon.BOF then
intS2HLTOrgAuthorID    = rsCommon("Author_ID")
strS2HLTOrgAuthorName    = rsCommon("Username")   
End if   
rsCommon.Close


You then use these two new variables to display the Original Poster

You will need to define these variables like so:

....
 Dim intS2HLTLimit
 Dim strS2HLTForumPath
 Dim strS2HLTSerialNumber

 Dim intS2HLTOrgAuthorID
 Dim strS2HLTOrgAuthorName
Back to Top
 Post Reply Post Reply Page  123>
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.