MySQL queries for posting a new thread

[Darth Cow]

Hmm... the file I have it outside of the forums directory - could that be an issue? Because nothing is being displayed, unlike when I put it in the forums directory.

EDIT: Ok, so will this take care of connecting to the database, database function and other vB functions? I have no need for sessions or any of that, just the *basic* things that will allow me to insert new threads.

PHP Code:

require('./admin/config.php');

$dbservertype = strtolower($dbservertype);
$dbclassname="./admin/db_$dbservertype.php";
require($dbclassname);

$DB_site=new DB_Sql_vb;

$DB_site->appname='vBulletin';
$DB_site->appshortname='vBulletin (forum)';
$DB_site->database=$dbname;
$DB_site->server=$servername;
$DB_site->user=$dbusername;
$DB_site->password=$dbpassword;

$DB_site->connect();

$dbpassword="";
$DB_site->password="";

require('./admin/functions.php'); 


[nabeel]

yeah it could be outside of the forum directory

do you have the paths etc correct?

[Darth Cow]

Originally posted by nabeel
yeah it could be outside of the forum directory

do you have the paths etc correct?

Yes, I'm certain that I was - I was getting no error messages.

See my edit above for how I hope to solve this for the sake of simplicity.

EDIT: $foruminfo[parentlist] - how can I load this up (needed in DB query for updating a forum)?

[nabeel]

whats the

$dbpassword="";
$DB_site->password="";

for after the connect?

what are the queries you use?

I think they use $DB_site->query() etc, i just use the normal mysql_query


this is how i have mine setup

PHP Code:

    include_once("/home/vhosts/fragblast.com/httpdocs/forums/admin/db_mysql.php");
    $DB_site=new DB_Sql_vb;
    $DB_site->appname='vBulletin';
    $DB_site->appshortname='vBulletin (forum)';
    $DB_site->database="fragblast";
    $DB_site->server="localhost";
    $DB_site->user="myusername";
    $DB_site->password="mypass";
    $DB_site->connect();

    include("/home/vhosts/fragblast.com/httpdocs/forums/admin/functions.php");
    include("/home/vhosts/fragblast.com/httpdocs/forums/admin/sessions.php"); 


i didnt bother with the config.php


and the query isnt showing anything?

try doing
echo mysql_error(); to see if something did go wrong

[Darth Cow]

PHP Code:

$dbpassword="";
$DB_site->password=""; 


I think it's so you don't give out your db password accidently through a template or something .

Well, just FYI everyone, I finally got my thing working . I first created a file vbbasics.php that I put in the folder with the submissions forum, which had what I posted above. I then figured out the basic queries to do to get it working in the submit form. The final code was kinda complex and included some site specific stuff, so I doubt it would work as a hack I could submit to the hack database, though I will attach most of it .

[nabeel]

heh cool