Inna
07-06-2018, 10:43 AM
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:
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
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:
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