Re: bbsync broken – plugin like it? BB 1.0
I’m just trying ghetto solutions at the moment just to see if I can actually get something to work.
$SQLtopic_id = 3;
$SQLtopic_title = 'Test';
$SQLtopic_slug = 'topic-test-slug';
$SQLtopic_poster = '1';
$SQLtopic_poster_name = 'admin';
$SQLtopic_last_poster = 1;
$SQLtopic_last_poster_name = 'admin';
$SQLtopic_start_time;
$SQLtopic_topic_time;
$SQLtopic_forum_id = 1;
$SQLtopic_topic_status = 0;
$SQLtopic_open = 1;
$SQLtopic_last_post_id = 1;
$SQLtopic_topic_sticky = 0;
$SQLtopic_posts = 1;
$SQLtopic_tag_count = 0;
//$SQLtopic_id, $SQLtopic_title, $SQLtopic_slug, $SQLtopic_poster, $SQLtopic_poster_name, $SQLtopic_last_poster, $SQLtopic_last_poster_name, $SQLtopic_start_time, $SQLtopic_topic_time, $SQLtopic_forum_id, $SQLtopic_topic_status, $SQLtopic_open, $SQLtopic_last_post_id, $SQLtopic_topic_sticky, $SQLtopic_posts, $SQLtopic_tag_count
// set database server access variables:
$host = “”;
$user = “”;
$pass = “”;
$db = “”;
// open connection
$connection = mysql_connect($host, $user, $pass) or die (“Unable to connect!”);
// select database
mysql_select_db($db) or die (“Unable to select database!”);
mysql_query(“INSERT INTO bb_topics (topic_id
, topic_title
, topic_slug
, topic_poster
, topic_poster_name
, topic_last_poster
, topic_last_poster_name
, topic_start_time
, topic_time
, forum_id
, topic_status
, topic_open
, topic_last_post_id
, topic_sticky
, topic_posts
, tag_count
)
VALUES ($SQLtopic_id, $SQLtopic_title, $SQLtopic_slug, $SQLtopic_poster, $SQLtopic_poster_name, $SQLtopic_last_poster, $SQLtopic_last_poster_name, $SQLtopic_start_time, $SQLtopic_topic_time, $SQLtopic_forum_id, $SQLtopic_topic_status, $SQLtopic_open, $SQLtopic_last_post_id, $SQLtopic_topic_sticky, $SQLtopic_posts, $SQLtopic_tag_count)”);
mysql_close($connection);
Adds nothing to the database.