HEADER

Hi wingnut110,

That's what the confuzzled.nl code is for . . .

Bob

Hiya Bob,

Ya, I understand that. What i meant, and should have said rather is that i cannot get it to actually write to the fireboard tables. It's just not getting there. I can execute the sql queries from the code on my database and it writes the info to the fb tables. I'm thinking it may be not connecting to the database?

Here is the code that I have now..

Code:

$value) { // capitalize the first letter of each field $key = ucfirst($key); //make the title bold $key = "[b]".$key."[/b]"; //make it part of the msg string $msg = $msg." ".$key." : ".$value." “; } // get rid of the submit button bit at the end $msg_array = explode("[b]Button", $msg); $msg = $msg_array[0]; /* $msg = substr($msg, 0, -3); */ // Because I'm lazy ... $msg=str_replace(" “,”\n\n”,$msg); // Create the new topic $create_thread = "INSERT INTO `joomla`.`jos_fb_messages` SET id=NULL, parent=0, thread=0, catid=43, name='$author', userid=328, email=NULL, subject='$subject', time=$date, ip=NULL"; mysql_query($create_thread) or die(mysql_error()); // Figure out what the correct threadid is of that new topic $mesid=mysql_insert_id(); // Set the thread id to the same as the message id, as it's the first in the thread // Note: this solves the order problem in the forum $set_thread="update jos_fb_messages set thread=id where id=$mesid"; mysql_query($set_thread) or die(mysql_error()); // Tell the forum that there's a new latest message // Note: this solves the problem where the new message isn't showing up as the latest message in the forum // Note: it's the categories table because FB sees categories and forums as the same thing $set_forum="update jos_fb_categories set id_last_msg=$mesid where id=43"; mysql_query($set_forum) or die(mysql_error()); // Stick the $msg variable into the body of the topic $insert_msg="INSERT INTO `joomla`.`jos_fb_messages_text` SET mesid=$mesid, message='$msg'"; mysql_query($insert_msg) or die(mysql_error()); ?>

I did a little investigation and changed the catid, userid and such... like I said, works as individual sql queries, just not all together.. not sure if it's not connecting to the database, if chronoforms just dont like doing it this way, or maybe it's just put together incorrectly.

Hi wingnut110,

Ok, we'll clean this up a bit and turn it into Joomla-style code on the way. Which version of Joomla are you using? (1.0.x and 1.5 have different code syntaxes.)

Bob

Hi Bob,

I am using joomla 1.0.12 Thank you for your patience and help I know just enough about this stuff to be dangerous..lol but I guess this is how one learns


Luke

Hi Luke,

Here's a re-written version for Joomla 1.0.x. I've added a few comments prefixed '::'.

Code:

$value) { // capitalize the first letter of each field $key = ucfirst($key); //make the title bold $key = "[b]".$key."[/b]"; //make it part of the msg string $msg = "$msg $key : $value"; } // get rid of the submit button bit at the end $msg_array = explode("[b]Button", $msg); $msg = $msg_array[0]; /* $msg = substr($msg, 0, -3); */ // Because I'm lazy ... // :: I'm not sure this is correct - needs testing $msg = str_replace("\n","\n\n",$msg); // Create the new topic $sql = " INSERT INTO #__fb_messages SET id=NULL, parent=0, thread=0, catid=$catid, name='$author', userid=$userid, email=NULL, subject='$subject', time=$date, ip=NULL"; $database->setQuery($sql); if ( !$database->query() ) { echo ""; } // Figure out what the correct threadid is of that new topic $mesid = $database->insertid; // Set the thread id to the same as the message id, // as it's the first in the thread // Note: this solves the order problem in the forum $sql = " UPDATE #__fb_messages SET thread=id WHERE id=$mesid"; $database->setQuery($sql); if ( !$database->query() ) { echo ""; } // Tell the forum that there's a new latest message // Note: this solves the problem where the new message // isn't showing up as the latest message in the forum // Note: it's the categories table because FB sees // categories and forums as the same thing $sql = " UPDATE #__fb_categories SET id_last_msg=$mesid WHERE id=$catid"; $database->setQuery($sql); if ( !$database->query() ) { echo ""; } // Stick the $msg variable into the body of the topic $sql = " INSERT INTO #__fb_messages_text SET mesid=$mesid, message='$msg'"; $database->setQuery($sql); if ( !$database->query() ) { echo ""; } ?>

I've pulled some variables into a config block at the beginning and have changed all the database code to use Joomla syntax. I have one query with the line

Code:

$msg = str_replace("\n","\n\n",$msg);

which is doing some newline cleanup. It was broken in confuzzled's example because it included a newline character of some kind. This may need tweaking to give a tidy result. Not tested so may need some debugging. Bob

Hiya Bob,

Thank you for your rework
It is now creating a thread in the correct place, and the topic is correct, although the message body is not getting there. The forum post shows this error in the message body:

Warning: Invalid argument supplied for foreach() in /home/.randie/jasmindria/knightsoftheroseguild.com/components/com_fireboard/template/default/view.php on line 1871

the code is writing to the jos_fb_messages, it is updating the jos_fb_categories, but its not writing to the jos_fb_messages_text .

I am assuming the problem lies in

// Stick the $msg variable into the body of the topic
$sql = "
INSERT INTO #__fb_messages_text
SET mesid=$mesid, message='$msg'";
$database->setQuery($sql);
if ( !$database->query() ) {
echo "";


also, not exactly sure why you changed

$_POST['armory'] = "LINK";

to

$_POST[$fieldname] = "LINK";

armory is the field name.. just curious

thank you for your help it's getting there!