I don't know, I did not use it. If you are only pulling titles, etc. from your db, its explanation might be true, you can pull it from db. But my hack has advanced features like customizing the post while dragging, pulling only some part of it, marking a post as news instead of thread's first message etc. and it would require db alteration if your db is large.

OK. Ill see if I'll change the database. We'll see.

Is there a way to revert the database changes? Also will the search results be changed when you search?

Also how much faster will it be?

Yes of course. To revert it you need to delete the "news" column in "post" table. Also don't forget to revert script modifications of the advanced installation or you'll get db errors when you send a news post.

Question is not clear to me. Neither the advanced installation, nor the hack itself has nothing to do with vb's searching feature. So what do you mean?

I can not give you a maths formula but all I can say is this: it will be dramatically faster compared to basic installation considering the fact that you have a large db.

In basic installation when the scripts runs, it goes through the entire post table, checking all posts in your database and looks for the hack tags [news] in posts. Think about how long it will take if you have 100.000 posts with each 1000 characters in it.

When you apply advanced installation, hack will tag news posts in column news in database and the script will only check for the tagged messages and will not look inside the posts anymore. So the result will be returned very fast.

Hope this helps..

For step 3, exactly where do we add the VB codes?

Admin CP/Custom vB Codes/Add

Um im staff on www.animega.net and were using the main news for that site, from a category at www.tokyoforums.com I changed the serverdomain from localhost to the ip number but it says this

Warning: Access denied for user: 'vbbforums@thunder8.cwihosting.com' (Using password: YES) in /home/animega/public_html/newsconfig.php on line 25

Warning: MySQL Connection Failed: Access denied for user: 'vbbforums@thunder8.cwihosting.com' (Using password: YES) in /home/animega/public_html/newsconfig.php on line 25
Couldnt find MYSQL!

any help? or imma have to go back to coranto

As a matter of fact I didn't code the hack considering it will run remotely so don't know how it will behave in your situation. I dont think it will be a problem but I can not guarentee that either..

However your problems seems different now. Your error message indicates either one :
* username, password or IP address you entered is wrong
* Your MYSQL server you're trying to connect does not accept remote connections.

Latter is likely: Many hosting companies do not allow remote connections to their MYSQL servers so I suggest contacting them and make sure they have configured their servers to accept remote connections.. If they do they can discuss this problem with them too. Maybe they require a different username/password to connect remotely.

Upto this point your problem is not related to the hack itself. But even if you solve this problem, hack can create other problems about remote connection, I'm not sure about it.. :) Just give it a try anyway..

Is there anything that needs to be modified in your script in order for it to work on the new PHP version?

The script has been running flawlesly till today. My host (Powweb) updated the servers to PHP 4.3.0 and when you try to access my main page (where your script loads) it just sits there and never loads in.

When I remove the <?php echo news() ?> page loads fine, but of course the news doesn't show. This really sucks and worst case scenario I have to scramble to find something to work in the meantime.

Any help would be great. Site is http://www.chicagogamers.com. for now I removed the script but you can see it not working here: http://www.chicagogamers.com/index2.php

index2.php gives a 404 and as far as I can see the script runs fine in your main page. I guess you figured out a solution?