Oppsss, sorry about being a tard on the URLs...I should have caught that . I know I saw an email addy some were to send you a donation, I'd like to send one if I can find the addy again.

Also, one of my users asked if it was possible to have new PMs show up on the front page. Maybe some thing under where it show what subscribes threads have been updated. Like this...


Is that possible?

Just edit the VBINDEX template.

I opened up that template and I think I figured out where to edit it, but I'm not sure what to put in there to make the new PMs show up. I'm way new at this code/hack stuff.

Thanks for your help.

The HTML/variables can be found in the navbar and global.php.

So, is this the bit of coade that I need to insert?

Hi,

I'm helping CrankN while he's at work. I downloaded a fresh copy, removed and replaced all the files. I went to the admin cp, pasted http://www.ourdomain.net/folder/admincp/vbiupgrade.php and hit Enter. It started to load, "Processing complete...proceed" flashed at the top of the page, then the page went blank. The side menu of the admin cp shows but the main right side is plain white. It looks like a path problem to me. We don't have /forum/ and I'm wondering if the install is looking for that or not. If not, have you got any ideas what might be causing this and what I can do to complete it?

Thanks,
Janice

Is there anyway to make this appear when you go to http://www.lvlzero.uni.cc?

Also could I make the news go in decending order?

Never mind on the PM thing. It's already show at the top of the page :o

My users have found a problem though. If you click on the "go to last post" icon, it brings up a Page can not be displayed error. It's been verified on diferent computers and networks.

Any thoughts?

I am a little concerned about at least 2 of the queries.

In the GET NEWS query I see this...
now, if you are already doing and IN clause, there is no need to do a NOT IN clause. It's more overhead for absolutely nothing.

Now in the GET LATEST THREADS there is a similar issue..
Here we see open=1 and open <> 10. You don't use both. You are already looking for 1, so <>10 will again be useless overhead.

For this NOT IN, I had more NOT IN id's than I would have IN id's, so I changed this to an IN statement and hardcoded my id's. I think only 5 instead of 30 or so I want to exclude. I think this could be made an option.

One last thing, I added indexes on dateline for post and thread and it made a significant increase in speed for my db with 100,000+ threads and over 1.5million posts.

Went from the vbIndex loading in 30s to about 3s with all these changes.

Your milage may vary, but I think it's worth a shot.

When I try to enable news on my vbindex, it gives me this error:

-------------------------
Database error in vBulletin 3.0.1:

Invalid SQL:
## GET NEWS ##
SELECT thread.*,thread.iconid AS threadiconid, threadpost.pagetext AS pagetext,
threadpost.attach AS attachcount,


IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
LEFT JOIN post AS threadpost ON (thread.firstpostid = threadpost.postid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')


WHERE forumid IN (http://www.my domain.com/forums/forumdisplay.php?t=15)
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (0)
AND thread.open <> 10
AND thread.visible = '1'


ORDER BY thread.dateline DESC
LIMIT 4
mysql error: You have an error in your SQL syntax near '://www.my domain.com/forums/forumdisplay.php?t=15)
AND deletionlog.primar' at line 14

mysql error number: 1064
--------------------------------------------------------

What do I do??????
Thanks in advance for your help!!!