Skrypt nie pobiera ID z bazy danych jesli nie został podany w QueryString
<?
If (isset ( $_GET['myid'] )) {
$_SESSION['myid']=$_GET['myid'];
$selected_id=$myid;
$_SESSION['myname']=$_GET['myname'];
$name_id=$myname;
}
else
{
if (isset($_SESSION['myid'])) {
$selected_id=$myid;
$name_id=$myname;
}
else
{
require('admin/config.php');
require('admin/mysql.php');
$db = new sql_db();
$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname);
// sprawdzenie czy kazdy id osiagnal limit wyswietlen
$sql = 'SELECT count(*) as ile FROM user_links WHERE max - act > 0';
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
if($row['ile'] == 0)
{
//wyzerowanie licznikow
$sql = 'UPDATE user_links SET act = 0';
$db->sql_query($sql);
}
//losowy wybor identyfikatora
$sql = 'SELECT * FROM user_links WHERE max - act > 0 ORDER BY RAND() LIMIT 0,1';
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$selected_id = $row['user_id'];
$name_id = $row['name'];
//aktualizacja licznika wyswietlen dla tego identyfikatora
$sql = 'UPDATE user_links SET act = act + 1, total = total + 1 WHERE id = '.$row['id'];
$db->sql_query($sql);;
$myid=$selected_id;
$myname=$name_id;
$_SESSION['arch_myid'] = $myid;
$_SESSION['arch_name'] = $myname;
}
}
if( isset( $_GET['myid'] ) ) {
$_SESSION['arch_myid'] = $_GET['myid'];
}
else
{
$_GET['name_id'] = $_SESSION['arch_myid'];
}
if( isset( $_GET['name_id'] ) ) {
$_SESSION['arch_name'] = $_GET['name_id'];
}
else
{
$_GET['name_id'] = $_SESSION['arch_name'];
}
?>