vb.org Archive - mYvBindex v3.1

I've got an idea, and I would like to know if it would be easy to implement either in a hack or future release.

Simply - if I sticky something in my news forum, I'd like to sticky it on the home page as well - so it displays at the top.

Whadda ya think?

Tigga

07-14-2003 04:52 PM

Intex - If you'll look for this line of code:

PHP Code:


		
			
$pollquery = "WHERE forumid='$pollsforum' AND thread.pollid!='0' ORDER BY poll.pollid DESC LIMIT 1";

And change it to:

PHP Code:


		
			
$pollquery = "WHERE forumid='$pollsforum' AND thread.pollid!='0' ORDER BY thread.sticky DESC, poll.pollid DESC LIMIT 1";

That should work, but if you have any problems let me know.

Heffe2000 - Um... You'll have to be a little more specific. How exactly is the "picture of the day" determined? Where would it come from?

RS25com - If you'll look for this bit of code:

PHP Code:


		
			
ORDER BY thread.threadid DESC $newsmax");

And change it to:

PHP Code:


		
			
ORDER BY thread.sticky DESC, thread.threadid DESC $newsmax");

That should do the trick. :)

lalo landa

07-14-2003 05:33 PM

Little bug....

in myvbindex.php find:

PHP Code:


		
			
,thread.dateline,views,thread.iconid,votenum,votetotal,postid,

and remplace for this:

PHP Code:


		
			
,thread.dateline,thread.views,thread.iconid,votenum,votetotal,postid,

miss the "views" alias.

I have problems with the poll...

Work fine when i chose RAND but... if i chose a forum id... the myvbindex.php gets null

Why?

RS25com

07-14-2003 05:38 PM

Hey, thanks for the Sticky Code - it works GREAT!

Man, your hack is the best. I tried to install that "other" one and it didn't work at all, and I couldn't get suport.

YOU ROCK.

Thanks!

-James

Tigga

07-14-2003 05:41 PM

lalo landa - I'm not sure what you mean by the little bug... And the poll part should work fine if you haven't changed any of the code.

RS25com - "that other one" LOL! ;)

RS25com

07-14-2003 05:51 PM

You know it!

BTW, if you want to see the fruits of your labor, go to www.rs25.com and enjoy. :)

BTW, your "Troubleshooting/FAQ" section in your install file is EXCELLENT. You addressed every issue I had.

lalo landa

07-14-2003 05:58 PM

Ops!!.. with RAND i have the problem too.. some times...

I think this problem is with data from the polls...

Intex

07-14-2003 07:19 PM

Tigga - Thx for that worked a treat. I guess I should have been able to work that one out for myself after looking back at how to make news threads stay at the top :(.

Anyway thx. again - you're a star :).

pixelpunk

07-14-2003 11:25 PM

How can I put the frontpage poll where the new threads show up and remove the new threads completely?

Tigga

07-14-2003 11:29 PM

RS25com - Nice site and thanks for the compliments. :)

Intex - Thanks. :)

pixelpunk - I have no idea what you're trying to say...

All times are GMT. The time now is 01:32 AM.

Page 149 of 218

149

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02803 seconds Memory Usage 1,744KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: