Here the querys:
Code: Select all
$sql_phpbb_posts="INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, icon_id, poster_ip, post_time, post_approved, ";
$sql_phpbb_posts.="post_reported, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, ";
$sql_phpbb_posts.="post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_time, ";
$sql_phpbb_posts.="post_edit_reason, post_edit_user, post_edit_count, post_edit_locked)";
$sql_phpbb_posts.=" VALUES ('".$rand."','".$rand."','".$c."','2','0','0','".$fecha."','1',";
$sql_phpbb_posts.="'0','1','1','1','1','','".$titulo."','".$post."','','0','','','1','0','','0','0','0')";
Code: Select all
$sql_phpbb_topics="INSERT INTO phpbb_topics (topic_id, forum_id, icon_id, topic_attachment, topic_approved, topic_reported, ";
$sql_phpbb_topics.="topic_title, topic_poster, topic_time, topic_time_limit, topic_views, topic_replies, topic_replies_real, ";
$sql_phpbb_topics.="topic_status, topic_type, topic_first_post_id, topic_first_poster_name, topic_first_poster_colour, ";
$sql_phpbb_topics.="topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_poster_colour, ";
$sql_phpbb_topics.="topic_last_post_subject, topic_last_post_time, topic_last_view_time, topic_moved_id, topic_bumped, ";
$sql_phpbb_topics.="topic_bumper, poll_title, poll_start, poll_length, poll_max_options, poll_last_vote, poll_vote_change, topic_url)";
$sql_phpbb_topics.=" VALUES ('".$rand."','".$c."','0','0','1','0','".$titulo."','2','".$fecha."','0','0','0','0','0','0','0','Judy', ";
$sql_phpbb_topics.="'AA0000','0','0','Judy', 'AA0000', '', '".$fecha."', '0', '0', '0', '0', '', '0', '0', '1', '0', '0', '')";
Code: Select all
$sql_phpbb_forums="UPDATE phpbb_forums SET forum_posts='".$cant_posts."', forum_topics='".$cant_topics."', ";
$sql_phpbb_forums.="forum_last_post_id='".$rand."', forum_last_poster_id='2', forum_last_post_subject='".$titulo."', ";
$sql_phpbb_forums.="forum_last_post_time='".$fecha."', forum_last_poster_name='Judy', forum_last_poster_colour='AA0000', forum_topics_real='".$cant_topics."' WHERE forum_id='".$c."' LIMIT 1";
Thank you