'$date' and Active='Y' order by Name"; //echo $q; $res = $mysqli->query($q); for ($row_no = 0; $row_no<=$res->num_rows - 1; $row_no++) { $res->data_seek($row_no); $row = $res->fetch_assoc(); $selected=''; if ($HID==$row['PRKey']) { $selected='selected'; $HUNT=$row['Name']; $PROX=$row['Proximity']; $RESOURCEURL=$row['ResourceURL']; $KEEPSCORE=$row['KeepScore']; } $GROUPSELECT.=""; } $TITLE="Hidden:Live Game"; if ($HUNT<>'') { $game=$HUNT; $TITLE="Hidden:Live Game for $HUNT"; } //include "twitter.php"; //include '../twitterEPI/EpiCurl.php'; //include '../twitterEPI/EpiOAuth.php'; //include '../twitterEPI/EpiTwitter.php'; $ip=IP(); $SCRIPTVARS=""; $loggedin=false; $email=''; $usersource=''; $username=''; $pic=''; if (@$_GET['u'] && @$_GET['v']) { // get values from database after twitter include "connecthunts.php"; $username=$_GET['u']; $userid=$_GET['u']; $v=$_GET['v']; $VALIDATOR=$v; $q="select PRKey,Contact,Email,Company,Location,Website,Phone from Merchants where Validator='$v' and PRKey=$userid"; $res = $mysqli->query($q); if (!$res) { echo $q.$mysqli->error; exit; } if ($res->num_rows==0) { echo "Merchant/Vendor Bookmark No Longer Valid. BookMark only successful after login! Cannot be used after logout."; exit; } else { $loggedin=true; $res->data_seek(0); $row = $res->fetch_assoc(); $contact=$row['Contact']; $userid=$row['PRKey']; $email=$row['Email']; $phone=$row['Phone']; $company=$row['Company']; $location=$row['Location']; $website=$row['Website']; $username=$row['PRKey']; $VV="?u=$username&v=$v"; } $mysqli->close(); $loggedin=true; $SCRIPTVARS=""; } echo "$SCRIPTVARS"; $REF=''; include "merchantheader.php"; ?>