inserting records coming from a rss feed into a cms builder

Hi moh3,

You can solve the approval problem with a "hidden" field. See [url http://www.interactivetools.com/docs/cmsbuilder/special_fieldnames.html]the documentation on special fields[/url] for more information.

For duplicates, that'll require a very specialized solution. If the RSS feed has any unique fields (I believe they usually do!) you can do a SELECT before each INSERT to make sure you haven't already added a record with that field value.

Another approach would be to keep track of the latest publish date for your RSS feed records and simply ignore anything from the feed that isn't newer than the newest date you've already added.

I hope this helps! Please let me know if you have any questions.

This sounds like very interesting plugin. Good luck!

thanks chris will the check for a record slow the site?
the idea is each time i enter this section i would fire a function to get new rss record from a remote site

my question is:
1- can you please maybe provide a code example on how
to only restrict this function for the admin

2- how would i create an simple form that has fields
for text and submit button were through this form i would enter a url and on submit fire my function which will get new rss records

3- what kind of query will can i use to check for records
and can i use any built db functions to that,any docs about the software would nice to extend it

Hi moh3,

I'm afraid we can't provide this depth of help through our free support service; however, our consulting service would be happy to help you either work through building this yourself or providing you with a complete, working example which you can modify, expand upon, or simply use as-is. Our rates are very fair. :)

Please let me know if this is something you're interested in and I can have a quote written up for you.