Code: Select all
<?
mysql_connect ('localhost', 'admin', 'password') ;
mysql_select_db ('phpbb');
$date = date("Ymj");
$u = array(1,2,3,4,5,6,7,8,9,10,01,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36);
// shuffle array
srand((float)microtime()*1000000);
shuffle($u);
// 1-36
for ($i = 1; $i <= 36; $i++){
$g = 0;
$result = mysql_query("SELECT id,url,text FROM zlinks WHERE cat=$i");
$cnt = mysql_num_rows($result);
$rw = mysql_fetch_row($result);
$abb = ( $cnt + $rw[0] );
$add = ( $abb - $cnt );
// rand
srand ((double) microtime( )*1000000);
$z = rand($add,$abb);
$t = mysql_query("SELECT id,url,text FROM zlinks WHERE id=$z");
$row[$i] = mysql_fetch_row($t);
$zid[$i] = $row[$i][0];
$zurl[$i] = $row[$i][1];
$ztxt[$i] = $row[$i][2];
$zni[$i] = $u[$g];
$query[$i] = "INSERT lNTO zlink1 (id, oid, date, url, text) VALUES ('$zni[$i]', '$zid[$i]', '$date', '$zurl[$i]', '$ztxt[$i]')";
mysql_query($query[$i]);
$g++;
}
?>