vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   mYvBindex v3.1 (https://vborg.vbsupport.ru/showthread.php?t=44691)

Zachery 11-30-2003 11:19 PM

Quote:

Originally Posted by jarvis
I have a question about the $getnewposts routine and am not enough of a coder to get past my self-inflicted mySQL errors. ;)

Anyways, I mirror some Usenet groups on our fourms and would like to have the getnewposts routine in myvbindex not count these posts during the welcome tasks.

PHP Code:

$getnewposts=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$bbuserinfo[lastvisit]'"); 

I would think that I should be able to add a WHERE forumid!=XX somewhere in that statement, but have not been able to get that to work.

Any suggestions? Thanks for the awesome hack, as I've continued to use it for almost a year now (and have hacked it up a bit myself for graphics ;) )

Thanks again!!

try searching for it, i belive its been done before :D

jarvis 11-30-2003 11:38 PM

Try searching this thread? If so, I did and did not see anything that jumps out at me. I have been successful at excluding my usenet forums from the "Latest Posts" area, but have not been able to figure out how to exclude the count from the usenet forums in the welecome text, i.e. 500 New Posts since Last Visit, when there may have only been 50 in the registered forums.

I may be confusing you even more, but hopefully not. Thanks! :D

eclectica 11-30-2003 11:51 PM

I am running vBulletin 2.3.3. I set my news forums to be forum #5 and forum #7. I found what appears to be a bug in the hack. I allow unregistered guests to post in forums 5 and 7. When they reply to a post in forum 5, it is their post that appears on the index page rather than the first post of the thread. If a registered member replies in the thread, it works okay. Also, when unregistered guests reply in forum 7, it appears properly.

So the bug specifically only affects the threads in one of my two news forums, and only happens when guests reply in the threads.

The actual details of how I got both forums working is written in post #1879.

Zachery 11-30-2003 11:52 PM

Quote:

Originally Posted by jarvis
Try searching this thread? If so, I did and did not see anything that jumps out at me. I have been successful at excluding my usenet forums from the "Latest Posts" area, but have not been able to figure out how to exclude the count from the usenet forums in the welecome text, i.e. 500 New Posts since Last Visit, when there may have only been 50 in the registered forums.

I may be confusing you even more, but hopefully not. Thanks! :D

oh im sorry :\ mmm im not exactly sure how to do that :\ sorry

nycunderground 12-01-2003 01:19 AM

blah i wanted to check out vb3 version but for some reason cant download it :(

Zachery 12-01-2003 04:04 AM

please read the announcments at vbulletin.nl :)

Neogen 12-01-2003 12:43 PM

lo all need help
i tried to install a shoutbox hack onto the portal, however it does not work so i removed everything asociated with it an d now for some reason news posted in the forums is no longer showing up on the portal!!

Please help me LOL

Thanks
Neogen

MindTrix 12-01-2003 02:09 PM

Neogen, Is that after a new install of the portal or have you been running it for some time now?

Tigga 12-01-2003 04:51 PM

Jarvis - Unfortunatly there's really not a good way to exclude forums from the new posts query. The post table does not contain a column for the forumid that the post is in (only a threadid), so there's really not a way to only exclude certain forums using that query. It *may* be possible if the thread table was joined, but I'm really not sure. I'll take a look a little later and if I come up with something I'll let you know. ;)


eclectica - I tried taking a look at your site to test the problem you're describing, but I didn't see any current posts from forum 5 on your homepage. I would almost bet money though that something else in the news query had to be changed... Specifically, the statement in there that says "WHERE isnews = 'Y'". If that is there, or if it's not there and you're unsure of how to add it back, please post the entire news query here so I can have a look at it. Unless I'm missing something though, there's no way it should be able to display a reply to a thread since only the first post in a thread will have a 'Y' in the isnews column.



Neogen - Was it working before? Have you tried downloading the file from here and uploading the clean/unhacked version? Have you upgraded your vBulletin to a new version lately and perhaps forgotten to make the change to newthread.php?

Neogen 12-01-2003 06:08 PM

it was working perfect before mate working very nice. went to install the shoutbox that is linked to from the 1st post in this forum, tried to install and it did not work, i have managed to get the news back linking to the portals by trying the workaround provided a couple pages before.
Now i would like to know how to reintergrate the shoutbox and I would like to know if there are any other things that I can add to it as I really like this portal and after wasting a load of cash on Virtuanews i want to stick with this one.
If anyone fancies helping me then my MSN is : imallways@hotmail.com and I will allways give full credit to anyone helping

Thanks
Neogen


All times are GMT. The time now is 11:40 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02517 seconds
  • Memory Usage 1,747KB
  • 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
  • (1)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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