Mercurial > hg > ywww
diff php/read/setThumbState.php @ 6:077b0a0a3e6d
remaining originals according to dependency walk
author | Robert Boland <robert@markup.co.uk> |
---|---|
date | Thu, 16 Feb 2017 22:29:02 +0000 |
parents | |
children | 385ddd7c4b55 a67bf725e87b |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/php/read/setThumbState.php Thu Feb 16 22:29:02 2017 +0000 @@ -0,0 +1,25 @@ +<?PHP +$userID = strval($_GET['userID']); +//echo $userID; +$linkList = strval($_GET['list']); +//echo $linkList; + + +include "../../../private/db.php"; + +$query1 = "select * from b_thumbstate where UserID= $userID and LinkID in ($linkList) and state <> 0"; //CALL b_setThumbState($userID, $linkList)"; +//echo $query1; +$data1 = mysqli_query($link, $query1); + +echo "<?xml version=\"1.0\"?>"; +echo "<results>"; +while($line = mysqli_fetch_assoc($data1)) { + if ($line["State"] == 1) + echo "<up>" . trim($line["LinkID"]) . "</up>"; + else if ($line["State"] == -1) + echo "<down>" . trim($line["LinkID"]) . "</down>"; +} +echo "</results>"; +mysqli_close($link); + +?> \ No newline at end of file