Question MYSQL Database Insertion

///////////////////////////////// //////CREATE TOPIC FOR POST////// ///////////////////////////////// $threadid = mysql_fetch_array(mysql_query("SELECT thread FROM nscms_kunena_messages ORDER BY id DESC LIMIT 1;")); $threadid = $threadid[thread]+1; $mysqlpost1 = mysql_query("INSERT INTO `nsguild_nsjs15`.`nscms_kunena_messages` ( `id` , `parent` , `thread` , `catid` , `name` , `userid` , `email` , `subject` , `time` , `ip` , `topic_emoticon` , `locked` , `hold` , `ordering` , `hits` , `moved` , `modified_by` , `modified_time` , `modified_reason` ) VALUES (NULL , '0', '".$threadid."' , '7' , '".$poster."' , '".$poster_id."', NULL , '".$title."', '".$time."' , NULL , '0' , '0' , '0' , '0' , '0', '0', NULL, NULL, NULL);"); if(!$mysqlpost1){echo("Failed: ".mysql_error(). "<br><br>");} ///////////////////////////////// ////PARSE POST INTO MESSAGES///// ///////////////////////////////// //get message id $tmesid = mysql_fetch_array(mysql_query("SELECT id FROM nsguild_nsjs15.nscms_kunena_messages WHERE subject = '$title'")); $mysqlpost2 = mysql_query("INSERT INTO nsguild_nsjs15.nscms_kunena_messages_text( `mesid` , `message` ) VALUES ('".$tmesid[id]."','".$post."');"); if(!$mysqlpost2){echo("Failed: ".mysql_error());} ///////////////////////////////// /////////UPDATE CATEGORY///////// ///////////////////////////////// $num = mysql_fetch_array(mysql_query("SELECT numTopics FROM `nsguild_nsjs15`.`nscms_kunena_messages` WHERE id = '7'")); $numTopics = $num[numTopics]+1; $num = mysql_fetch_array(mysql_query("SELECT numPosts FROM `nsguild_nsjs15`.`nscms_kunena_messages` WHERE id = '7'")); $numPosts = $num[numPosts]+1; $mysqlpost3 = mysql_query("UPDATE `nsguild_nsjs15`.`nscms_kunena_categories` SET numTopics='".$numTopics."', numPosts='".$numPosts"',time_last_msg='".$time."' WHERE `nscms_kunena_categories`.`id` =7;");

function createTopic($row, $catid, $subject) { require_once (KPATH_SITE . '/lib/kunena.posting.class.php'); $message = new CKunenaPosting ( $this->params->get ( 'topic_owner', $row->created_by ) ); $options = array(); $fields ['subject'] = $subject; switch ($this->params->get('bbcode')) { case 'full': $fields ['message'] = "[article=full]{$row->id}[/article]"; break; case 'intro': $fields ['message'] = "[article=intro]{$row->id}[/article]"; break; case 'link': $fields ['message'] = "[article=link]{$row->id}[/article]"; break; default: $fields ['message'] = "[article]{$row->id}[/article]"; } $fields ['time'] = JFactory::getDate(isset($row->publish_up) ? $row->publish_up : 'now')->toUnix(); $success = $message->post ( $catid, $fields, $options ); if ($success) { $newMessageId = $message->save (); } // Handle errors if (! $success || ! $newMessageId) { $errors = $message->getErrors (); foreach ( $errors as $field => $error ) { $this->_app->enqueueMessage ( $field . ': ' . $error, 'error' ); } return false; } // Keep a cross reference of Threads we create through this plugin $this->createReference ( $row, $newMessageId ); // We'll need to know about the new Thread id later... $this->debug ( __FUNCTION__ . "() end" ); return $newMessageId; }