i am developing a rss newsbot, basicaly it will post on item fetched from an RSS per new topic on a forum.
I went an look at the data model and i got an existencial question:
the table "topics" contais a field called "last_post", while the table "posts" contains a fiels called "topic".
Ok... this a biderectional relationship... what da heck.. in wich table should i insert first a row?
If i insert a topic witch message should i relate its last message to?
If i insert a message wich topic should it belong to?
I didnt went into punbb code... but i guess i have to use mysql_insert_id() or something similar.. the problem is that both tables have forigner key on each other...
any help?
EDIT:
this is related to the above subject.... i am writing the script in php and access it using a cronjob. How should i protect my php script so nobody access it for DDoS or other malicious purpose?
Also... it doesnt sound sooooo eficient... i wil fetch news from about 150, maybe 200 feeds... the average should be like 3 new item a day.... wont it be to heavy? do php files have an execution timeout set on apache?
sorry... so many question... thanks in advance