'RandomActsOfAmazon', 'raoe' => 'Random_Acts_Of_Etsy', 'raop' => 'RandomActsOfPolish', 'raowl' => 'RAOWL', 'raom' => 'RandomActsofMakeup', 'raoc' => 'RandomActsofCrafting', 'raowd' => 'RAoWarmDrinks', 'torg' => 'TradeOrGift', 'gob' => 'GiftsofBeauty', 'raoab' => 'RandomActsofAB', 'oldraoa' => 'Random_Acts_of_Amazon');
if(array_key_exists('reddit', $_REQUEST) && array_key_exists(trim($_REQUEST['reddit']), $reddits))
$reddit = trim($_REQUEST['reddit']);
else
$reddit = 'raoa';
$dbsocket=mysqli_connect ("localhost", "n8fq_wldb", "nq#q3%nm*hZz") or die ('I cannot connect to the database because: ' . mysql_error());
mysqli_select_db($dbsocket, 'n8fq_wldb');
$count = mysqli_num_rows(mysqli_query($dbsocket, "select * from `f_".$reddit."` where 1"));
$timeout = time()-(abs($_REQUEST['days'])*86400);
if($timeout <= 0 || $timeout >= time()-86400)
$timeout = 0;
if(array_key_exists('mingifts', $_REQUEST))
$mingifts = abs($_REQUEST['mingifts']);
else
$mingifts = 0;
$i = 0;
while(True) {
$linkquery = mysqli_query($dbsocket, sprintf("SELECT * FROM `f_%s` WHERE `Hits` = %d AND `Gifted` >= %d AND `Last` > %d ORDER BY rand() LIMIT 1", $reddit, $i, $mingifts, $timeout));
if(mysqli_num_rows($linkquery) == 1) {
$link = mysqli_fetch_assoc($linkquery);
break;
}
else
$i++;
if($i == 500) {
print "Error: No users found with less than 500 hits with given parameters, aborting.
\n";
printf("SELECT * FROM `f_%s` WHERE `Hits` = %d AND `Gifted` >= %d AND `Last` > %d ORDER BY rand() LIMIT 1", $reddit, $i, $mingifts, $timeout);
print "";
die();
}
}
mysqli_query($dbsocket, sprintf("UPDATE `f_%s` SET `Hits` = %s WHERE `Key` = %s", $reddit, abs($link['Hits'])+1, $link['Key']));
mysqli_close($dbsocket);
if(stristr($link['Link'], '?'))
$link['Link'] = $link['Link']."&sort=universal-price";
else
$link['Link'] = $link['Link']."?sort=universal-price";
?>
Random Wishlist
This wishlist belongs to: 0) { $hasgifted = "Yes"; } else { $hasgifted = "No"; }
echo "
\n";
printf("User: %s
\n", $link['User'], $link['User']);
printf("\n", $link['Link'], substr($link['Link'],0,-21));
printf("Last post: %s
\n", date("r", $link['Last']));
printf("Has gifted: %s\n", $hasgifted);
printf("Hits since last update: %s
\n", $link['Hits']);
echo "
\n";
?>
Roll again: 7 15 30 G
Back to !
Developed and hosted by /u/DersEvvak - Discussion thread
This wishlist belongs to: 0) { $hasgifted = "Yes"; } else { $hasgifted = "No"; }
echo "
\n";
printf("User: %s
\n", $link['User'], $link['User']);
printf("Link: %s
\n", $link['Link'], substr($link['Link'],0,-21));
printf("Last post: %s
\n", date("r", $link['Last']));
printf("Has gifted: %s\n", $hasgifted);
printf("Hits since last update: %s
\n", $link['Hits']);
echo "
\n";
?>
Roll again: 7 15 30 G
Back to !
Open Remote Control window!
(uses JavaScript and popups)
Developed and hosted by /u/DersEvvak - Discussion thread