A Randomize Script for Cron Jobs/SQL

DackOfDoom

Hi,

I am trying to create a php script that I can run via cron job to update an SQL field value.

Here is what I need:

Script first randomizes a number between 10 and 20. And just to make sense, we'll call the number it chooses "X".

So then, the script will randomize "X" amount of numbers, each number ranging from 3 to 800. And each number must be separated by a comma.

Then it will insert the new values into the table.

Example:
Script randomizes X, chooses 17

Then, it must choose 17 numbers between 3-800.
So it randomly chooses:
328,48,746,574,32,47,585,482,40,474,413,363,222,554,787,872,4

(and there can be no repeats)

Then it inserts (updates) those numbers (with commas) into the SQL field

Could someone help me create a script like this?

Thank you!

etully

I think you're missing the general point of these forums. This is to provide programmers with help when they are having problems with code. This is not a group of people who are just bored and want to write code for people for free. If you write the script and it doesn't work, post what you've got written and we'll be happy to let you know if we see any problems that need fixing. If you don't know how to write the script, then you really should hire a programmer.

DackOfDoom

Ok, thanks; I'll post back when I've got a base script

devinemke

$num = rand(10, 20);
$array = range(3, 800);
$rand_keys = array_rand($array, $num);
foreach ($rand_keys as $value) {$rand_values[] = $array[$value];}
$sql = "INSERT INTO table SET field = '" . implode(',', $rand_values) . "'";
echo $sql; // just for testing

DackOfDoom

Thank you very much devinemke 🙂 So I have replaced "table" with the table name, but I'm just wondering about field

Should I just put the name of the field, and it will change the value?

Here is my current code:

<?php


$dbhost = 'localhost'; // Server address of your MySQL Server
$dbuser = 'mackenzi_jackson'; // Username to access MySQL database
$dbpass = '*********'; // Password to access MySQL database
$dbname = 'mackenzi_inv'; // Database Name


$sqlConn = mysql_connect($dbhost, $dbuser, $dbpass) or die ("Unable to connect!");
mysql_select_db($dbname) or die ("Unable to open database!");

$num = rand(15, 30);
$array = range(3, 839);
$rand_keys = array_rand($array, $num);
foreach ($rand_keys as $value) {$rand_values[] = $array[$value];}
$sql = "INSERT INTO phpbb_config SET allowed_users = '" . implode(',', $rand_values) . "'";
echo $sql; // just for testing 


?>

When I run the script, the output comes out fine:

INSERT INTO phpbb_config SET fake_online_users = '3,26,71,96,143,154,168,181,451,636,692,699,703,731,747,779'

(or whatever numbers it outputs)

But when I go check the tables, nothing has changed...

If this helps, when I go to the field to edit it manually through phpMyAdmin, and have it output the SQL command that I processed, it gives me this:

UPDATE `phpbb_config` SET `config_value` = '823,825,834,848,484,493,809,796,815' WHERE `config_name` = 'allowed_users' LIMIT 1 ;

and in PHP mode, it gives me this:

$sql = 'UPDATE `phpbb_config` SET `config_value` = \'823,825,834,848,484,493,809,796,815\' WHERE `config_name` = \'allowed_users\' LIMIT 1;';

Thanks again

DackOfDoom

Edit: ok this is really weird; I decided to see if it was the randomize script that was making things not work, but I guess not. I ran this SIMPLE script, and still it did not change the table...

<?php


$dbhost = 'localhost'; // Server address of your MySQL Server
$dbuser = 'mackenzi_jackson'; // Username to access MySQL database
$dbpass = '*********'; // Password to access MySQL database
$dbname = 'mackenzi_inv'; // Database Name


$sqlConn = mysql_connect($dbhost, $dbuser, $dbpass) or die ("Unable to connect!");
mysql_select_db($dbname) or die ("Unable to open database!");

$sqlquery = "UPDATE `phpbb_config` SET `config_value` = '34,43,94,575' WHERE `config_name` = 'fake_online_users' LIMIT 1 ;";

?>

Why didn't this one work?

devinemke

DackOfDoom wrote:
Why didn't this one work?

because you are never running the query

Kudose

Just out of curiosity -- Are you trying to fool your vistors into thinking people are "online"?

DackOfDoom

Wow... Can't believe I forgot to run the query 😛

hits self

The script is running fine now; thanks so much for the help everyone 😃

Kudose - Yes, this is the testing for a script for phpBB; it will be an addon to a mod a user made which you have to select the users online. I got a request for this on the phpBB forums.

Devinemike- May I credit you for the randomize coding in the mod?