Yes, I completely undid everything... I think I had everything right except importing the .sql file... Had to do full uninstall cuz it trashed my forums... I couldn't created new forums, couldn't post... got db errors... The errors referenced the table I created... No surprise since I had never manually created one before and winged it... I know myphpadmin is supposed to be able to import the file, but couldn't make it happen... Will do full install again after i'm sure i understand how to do that and it's late enough none of my users will be on the board... any help appreciated... was looking for a script specifically like this for both my vb and for wallpaper I'm making for my wife's dtop...

let me re-say that... I know for sure I had evrything correct... Uninstalling it was a breeze... Working backwards everything was exactly where it should be and didn't take long at all... (By the way, your notes with the line numbers and stuff are the best I've used...) I've had to rebuild my board from scratch over the last 3 days, and I've done at least a dozen hacks in the last couple days... Every one of them worked on the first attempt... Even so, yours was the clearest despite the fact I failed first time out, lol....

So your problem was just with importing the database stuff?

correct... what are the verbatim step for importing the .sql file via phpmyadmin when the table (newsforum or whatever it was called - sorry, don't have the documentation on the screen, but obviously you know the name, lol) doesn't exist to begin with... I tried the obvious, clicking on the choose button and navigating to the file on my hd and it would try and execute the file, but it couldn't load the info as there was no table to load it into...

In the instructions, in this section: III. Database Modifications, you need to do all the stuff listed in there. The first thing is an ALTER TABLE statement. What you do is copy the entire line(s) and paste it into the Query textarea (window) in phpMyAdmin, then hit Go. Now since you say there was no table to load the stuff from the file into, you probably missed the next part, which starts with CREATE TABLE forumnews (. Copy that entire section, from that line through ) TYPE=MyISAM;, paste that into the Query window, and Go. Make sure you have done the three queries after that as well (if you're not sure if you did or didn't, you can check by going to your admin cp, vBulletin Options page, and look for a section called "Forum News"; it will probably be the last section). After you have done all that, then you should try to import the sources.sql file, by doing just what you said you did the first time.

You're absolutly right... I went thru those directions at least a dozen times and somehow missed ever even reading that paragraph every single time.... Unbelievable... The one below... speechless... Thanks!

<CREATE TABLE forumnews (
forumnewsid smallint(5) NOT NULL auto_increment,
xmlsource char(100) NOT NULL default '0',
title char(250) NOT NULL default '0',
PRIMARY KEY (forumnewsid)
) TYPE=MyISAM;>

JJR512,

This is a great hack, as usual from yourself. :)

Just a question - is it possible to create my own keyword to search Moreover with so that I can have my own news category?

Installed in minutes this time, thanks!

I got a small problem & don't know how to fix:

I installed the hack with the add-on at the same time, however I go into my admin CP & I see a blank area under "Forum News". First thing I checked was the settinggroup queries... sure enough I put in the wrong number. Removed the three entries & tried them with the correct number - still nothing.

I've triple checked my PHP & everything looks the same. Any ideas?

What is the settinggroupid number of the Forum News settinggroup? Did you put this same number in the appropriate spots for the two settings?