Snitz Forums 2000 - Statistics

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/Code)

Statistics

New Topic

Topic Locked

Printer Friendly

Author

Topic

Page: of 4

animedj
Junior Member

USA
190 Posts

Posted - 18 August 2000 : 11:37:33

ohh shown by posted topics... you'll need change these lines :

"FORUM_TOPICS.FORUM_ID = FORUM_FORUM.FORUM_ID " & _
"WHERE FORUM_FORUM.F_PRIVATEFORUMS = 0 " & _
"ORDER BY FORUM_TOPICS.TOPIC_ID DESC;"

by :

"FORUM_TOPICS.FORUM_ID = FORUM_FORUM.FORUM_ID " & _
"WHERE FORUM_FORUM.F_PRIVATEFORUMS = 0 " & _
"ORDER BY FORUM_TOPICS.T_LAST_POST DESC;"

Rigger82
Junior Member

USA
311 Posts

Posted - 18 August 2000 : 15:48:50

Good so far. Need the SQL that would allow me to change the line posted... to last reply on 08/05/2000 by Rigger82 [ read more ]

Also need the reply SQL that would allow me to get the most replies order while being distinct topic. You SQL gurus should get this no problem.

I can post the current code if you wish.

---------------------
Mark Christianson
Gulf War Veteran (82nd Airborne Division)
Owner/Operator of www.paratrooper.net
Rigger@paratrooper.net

gmcm
Starting Member

South Africa
34 Posts

Posted - 11 November 2000 : 13:05:12

Man - this is looking cool - I run an international military sim community at the www.666th.com br / . How can i pull the last say 5 posts and place em on the front page of my site?

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 11 November 2000 : 13:19:48

Take a look at this topic:

http://forum.snitz.com/forum/link.asp?TOPIC_ID=1660

Page: of 4

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.29 seconds.