vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   How to manually add post to a thread (https://vborg.vbsupport.ru/showthread.php?t=326543)

Inna 07-06-2018 10:43 AM

How to manually add post to a thread
 
Hello, we've written a Python bot to gather info from other sites and post it in our forum.
As far as I know, I've told the programmer to create a thread in forum (not in phpmyadmin), so till now we have one thread+threadid, one post+postid.
I told him to insert data in `post` table like this:
Code:

INSERT INTO `post` (`postid`, `threadid`, `parentid`, `username`, `userid`, `title`, `dateline`, `pagetext`, `allowsmilie`, `showsignature`, `ipaddress`, `iconid`, `visible`, `attach`, `infraction`, `reportthreadid`, `htmlstate`) VALUES
(4, 4, 0, 'Saeed', 1, 'First Thread', 1422947684, 'The Content of the First Post', 1, 0, '192.168.0.1', 0, 1, 0, 0, 0, 'on_nl2br');

It adds the post, but I'm not sure whether to insert any more data in other tables like `datastore`, `setting`, etc.
It seems to successfully add the post. I told him it's not necessary to increase user's post count in `user` table, because we do not need the bot's post count, and the forum in which the bot is replying and sending post is hidden from other users (only admin-level users can see the forum).

Also all of my sites are run in WordPress, and I want this bot to gather data from only my sites to add it in my forum. So, there's no scraping.

Gathering data from my sites to insert into my site.

Appreciations


All times are GMT. The time now is 03:55 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02861 seconds
  • Memory Usage 1,707KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete