a sticy post in CMPS

[hani]

Hi
I made one post sticky in CMPS news forum, so it will show always as news # 1, but when I added posts to the forum, it bushed the sticky post down in the cmps page.

How can I keep that post always the first?

and BTW, what is the difference between CMPS and Frontpages hacks?


Thanx

Hani

[Brian]

To have your sticky threads displayed first, open your forum/modules/news.php file and look for:

PHP Code:

            ORDER BY " . iif($vboptions['stickynewsthreads'], 'sticky DESC,') . " postdateline DESC 


Replace that with:

PHP Code:

            ORDER BY sticky DESC, thread.dateline DESC 


As for the differences - http://vbadvanced.com/forum/search.php - CMPS homepage differences

[pdatotaal]

Was looking voor de same! thanks, but if looks that is must be a option that you put on/off?

[Diver]

thank you so much, i was looking for this

[dleblanc]

Originally Posted by Brian

To have your sticky threads displayed first, open your forum/modules/news.php file and look for:

" . iif($vboptions['stickynewsthreads'], 'sticky DESC,') . "

Replace that with:

sticky DESC,


As for the differences - http://vbadvanced.com/forum/search.php - CMPS homepage differences

I look this up and it has " . iif($vboptions['stickynewsthreads'], 'sticky DESC,') . " already in the news.php. So what needs to be replace where to keep the sticky on the top of the Center Block on the CMPS.

[Brian]

The code that I posted above.

[dleblanc]

Brian
I'm not sure I am understanding you correctly because I am still new at this. Below is what I done and it seems to work, is this correct.

orginal infomation:
" . iif($vboptions['stickynewsthreads'], 'sticky DESC,') . " postdateline DESC"

Change to:
" . iif($vboptions['stickynewsthreads'], 'sticky DESC,') . " sticky DESC"

[Brian]

No... Look for the first bit of code mentioned in that post and then just replace it with sticky DESC.

[dleblanc]

Sorry, I'm a little slow but I thinks I finally understood. This is what I done I replaced:

ORDER BY " . iif($vboptions['stickynewsthreads'], 'sticky DESC,') . " postdateline DESC" . iif($vboptions['shownewsattach'], ', attachmentid') . "

ORDER BY sticky DESC, postdateline DESC" . iif($vboptions['shownewsattach'], ', attachmentid') . "

Sometimes we need a little more help, but I really do appreicated the time you give us...I for one would be lost. Each time I come across one more bridge to figure out I am getting better.

[tormodg]

Hm...no offense, but a statement like "replace bla bla bla with bla bla bla" is really straightforward...

[dleblanc]

No offense taken, some of us old geezers are slow when it comes to the new technology. Remember the old were mostly self taught in computer language, thrown to the wolfs sort of speaking when it came to computers. My 27 year career has been an EMT-Paramedic and I’m sure some of my medical teaching is straight forward and would sound Greek…unless you are Greek…no offense.

With all that bla bla bla it works…I know, I know straightforward…I’m learning. (ha)

Thanks all

[oldengine]

Originally Posted by tormodg

Hm...no offense, but a statement like "replace bla bla bla with bla bla bla" is really straightforward...

I don't think it's clear at all. Especially when it has a gob of punctuation around it and it produces a database error.

// mod for sticky news
//                      ORDER BY " . iif($vboptions['stickynewsthreads'], 'sticky DESC,') . " postdateline DESC
                        ORDER BY sticky DESC, postdateline DESC
// end mod

So, I must have missed something?

Database error in vBulletin 3.0.7:

Invalid SQL: 
			SELECT IF(votenum >= 5, votenum, 0) AS votenum, IF(votenum >= 5 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
			thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie
			
  		,thread.iconid AS threadiconid, iconpath AS threadiconpath 
  		 
  		, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed  
  		
			FROM thread AS thread
			LEFT JOIN post AS post ON (post.postid = thread.firstpostid) 
  		LEFT JOIN icon USING (iconid)

[Brian]

I just modified the original post to include the whole line, so that should help to prevent someone from looking for/changing the code incorrectly.

[oldengine]

Why is my script have "postdateline" instead of "thread.dateline" - does it matter?

[Brian]

I think I accidentally copied that from a different file that I was working on. Just leave thread.dateline in there as that should work better anyways.

[oldengine]

I'm sorry for the confusion on this modification.

I like to place comments where I modify files, but in this case, those //comments were interfering with the script and thus caused the sql database error.

All sorted out and working now.