LaxmiBatav

Thank you for replying so quickly! You have been great help, and as for the auto quiz i have provided a guide.

Auto Quiz

Best wishes to you too

EHC Team

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.

———-Step 1————-

<?php

//Database connection
$dbhost = '[A]';
$dbuser = '[B]';
$dbpass = '[C]!';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db('[D]',$conn);

$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 );
mysql_close($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 34.136.109.11 )
[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.
8.Done!

[NOTE: DO NOT INCLUDE THE “[ AND ]”s IN THE PLACEHOLDERS.

—————-STEP 2—————–

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

Hi YOP.

Oh, thank you so much, but i would like to know the actual php commands that occur when the button is clicked, so i can run a cron job which makes makes it automated.

Regards,

EHC Team

Thank you for answering, but they are not in there. I’ve looked.

Ok, thank you

I think that it would be done externally anyway. and i probabaly would need an expert to look at it. but after a short while of searching where the polls have been kept i have discovered them to be in my database. all we need to do is to run a sql find and search that just replaces the answer, the question and the number of answers all in one query easily.

I’m sure there is a way to set a timer on when to run that query, that’s all.

I’m sorry, but every day there is a specific poll that i want to display with the same short code, and i know there would be coding involved.
It’s just that the question and answer need to be changed.

Thanks,

nope i had to delete it

Oh, and Why do I get the message “Warning: Your backup folder MIGHT be visible to the public!”?
when, when i go (wp-content/backup-db/), it is completely empty.

oh thanks a lot for replying so soon, and thank you for resolving my problem. i appreciate your help WPyogi.

When i remove the >? at the end of my wp-config.php file, this is the error that comes up –

Warning: Cannot modify header information – headers already sent by (output started at /home/content/67/9544167/html/”blahblah”
/wp-content/plugins/redirect-to-homepage/index.php:19) in /home/content/67/9544167/html/”blahblah”/wp-includes/pluggable.php on line 897

now i have this error –
Parse error: syntax error, unexpected ‘>’ in /home/content/67/9544167/html/”blahblah”/wp-config.php on line 91

(i added the >? to the end of the wp-config.php file)

Can you please give the link to your website so we can fully analyse the problem?

https://eleventhhourcorrection.com/eleventhhourwp/