What I ran is fairly complicated, but for those who are looking at this thread and want to do the same thing, this is what I did.
1.Create a Sql update query in a php script file.
2.Run a cron job at the selected time.
$dbhost = '[A]';
$dbuser = '[B]';
$dbpass = '[C]!';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
$sql = "UPDATE wp_yop_polls ".
"SET question = '[New Poll(in most cases a question)]' ".
"WHERE id = [F]" ;
//Repeat This chunk as many times as you want for the number of answers (remove this line afterwards)
$sql = "UPDATE wp_yop_answers ".
"SET answer = '[New answer available (options)]' ".
"WHERE id = [H]" ;
$retval = mysql_query( $sql, $conn );
All the code you need to update a sql query is in this file.
Here are the parameters:
[A] -your DB Host (In the form of an ip adress, eg 22.214.171.124 )
[B] -the username for the database
[C] -the password for the database
[D] -the actual name for the database [the name you gave it when you created it]
[F] -the yop poll id (found in the shortcode, eg [yop_poll id="F"]
[H] -The hardest bit I'm afraid, in which you would have to go into your root files. Here are the steps:
1.Login in to your hosting manager, wether it be Cpanel or whatever your host provides you.
2.Navigate to SQL Database and click on 'Phpmyadmin'
3.You would be navigated to this page, where you would have to login with your username and password
4.After you login you see the name of your database on the left, click on it and you see a few dozen other links under it.
5.Click on wp_yop_answers (somewhere down the list)
6.Click 'browse' (in the navigation bar at the top)
7.After you see the table you get all the answers, and you see the ids. For the desired answer you see the id, thats your [H] value.
[NOTE: DO NOT INCLUDE THE "[ AND ]"s IN THE PLACEHOLDERS.
You'd be glad to know this is much more simpler.
Step 1.Login to your hosting manager and open 'Cron job manager'
Step 2.Click 'create cron job'
Step 3.Give whatever title you want to.
Step 4.Provide the path to the above php file in your website (for conveniance just keep it in the webroot)
Step 5.Give the frequency and time (pretty much self explanatory, just give the dates when you want it to happen or how often)
Step 6.Click and save and voula! your done. :)
Through this guide you would hopefully learn more on SQL databases and if you have any queries, feel free to ask them below.
-The EHC Team