Hello! I'm interested in what direct MySQL queries would be necesary to add a new thread in the preset forum of my choice, without worrying about any verification, ect. It can be just like a thread made by a Guest, however, it would need to be put into a forum with access for only mods/admins. We (at MTGnews.com) are trying to update our news submissions forms to make new threads for reported news in a special forum. We can format everything into whatever format. I've been trying to edit the newthread.php and what not to do some, but there are several files that need to be edited to allow posting as such and it's a pain largely because we don't want to have to log users out of our forums or cause any other difficulties. Unfortunately, it's not exactly clear what the necessary info is for the queries to insert a new thread/post with a guest acount is, nor how to how to execute them. Maybe someone more experienced with vB knows how to do this? Thanks!
Darth Cow, please go to this page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.
Ok, well here's the issue then. I know that we're liscensed, however only the webmaster has the liscense stuff. Before I ask for it, is it possible to have multiple users on these forums on the same liscense? Wouldn't want to lock him out or something...
Thanks, but there's a couple of issues - I want to make a new thread, not reply to an old one and the redirection needs to take you elsewhere, since the news submissions will be going to a hidden form (for non-mods). That's why I was looking for the specific MySQL queries, because I figured that just might be easier then editing newthread.php .
You basically need two things, INSERT INTO thread and INSERT INTO post. Then you need to updateforumcount() for the forum, and if you are posting as a user, you need to update that user's information (lastpost, total posts, etc.).
Most of the things in newthread.php are NOT expendable.
Originally posted by FireFly You basically need two things, INSERT INTO thread and INSERT INTO post. Then you need to updateforumcount() for the forum, and if you are posting as a user, you need to update that user's information (lastpost, total posts, etc.).
Most of the things in newthread.php are NOT expendable.
Thanks! I seem to have gotten it down to what I figure is the minimum. However, I have one other concern - how do I allow the echoing or leaving of PHP when I'm requiring global.php? Is there anyway to turn off template processing for a page, so that I can just load database/functions/config features that you need to get it basically functioning? I want to be able to do non-vBulletin template powered echoing of information and includes. Thanks
07-19-2002, 08:07 PM
MySQL queries for posting a new thread
Linear Mode
