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).
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).
Appreciations
Comment