to use landscape for your own convenience.' ; echo '
'; } // MEMO - max_file_size : '1gb', - set below for upload // Get the current logged in user. $ruser = JFactory::getUser(); $id = $ruser->get('id'); // Prepare the empty array // $items = array(); // Prepare the database connection $db = JFactory::getDBO(); // $db->setQuery("SELECT COUNT(`SubmissionId`) FROM #__rsform_submissions WHERE `UserId`='".$id."' AND FormId='90' "); $db->setQuery("SELECT COUNT(`SubmissionId`) FROM #__rsform_submissions WHERE `UserId`='".$id."' AND (FormId='96' OR FormId='105') AND paid='1' AND SubmissionId IN (SELECT SubmissionId FROM #__rsform_submission_values WHERE `FieldName` = 'status' AND `FieldValue` = 'confirmed')"); $db->execute(); if (intval($db->loadResult()) > 0) { // Keep this if you'd like a "Please select" option, otherwise comment or remove it // $items[] = "|Please Select[c]"; // Run the SQL query and store it in $results // $sql = "SELECT id, name_en FROM #__countrylist_land ORDER by name_en ASC;"; // $sql = "SELECT country, countryunique FROM #__rsform_submissions GROUP BY country ORDER by country ASC;"; // $sql = "SELECT SubmissionId FROM #__rsform_submissions WHERE `UserId`='".$id."' AND FormId='90'"; $sql = "SELECT SubmissionId,bannername FROM #__rsform_submissions WHERE `UserId`='".$id."' AND (FormId='96' OR FormId='105') AND paid='1' AND SubmissionId IN (SELECT SubmissionId FROM #__rsform_submission_values WHERE `FieldName` = 'status' AND `FieldValue` = 'confirmed') ORDER BY SubmissionId ASC"; // $sql = "SELECT FieldValue FROM #__rsform_submission_values WHERE `FieldValue`='".$id."' AND FormId='87'"; $db->setQuery($sql); $riding = $db->loadObjectList(); ?> SubmissionId; // and add empty value to array to allow mainpage $checkids = array_merge($allowedids, array('')); // Second get query from URL state=7647673 // $uri= JFactory::getURI(); // 2025-12-28 17-15 - https://joomla.stackexchange.com/questions/4294/get-the-current-joomla-url $uri= \Joomla\CMS\Uri\Uri::getInstance(); $subcall=str_replace("state=","",$uri->getQuery()); // Third check if query in allowed array if( !in_array($subcall,$checkids) ) { // echo "id not exists - redirect somehow !"; header("Location: https://altumprime.com/warning"); exit(); } if (isset($_GET['state'])) { $db->setQuery("SELECT CONCAT(UserId,FormId,SubmissionId) FROM #__rsform_submissions WHERE `UserId`='".$id."' AND (FormId='96' OR FormId='105') AND `SubmissionId`='".$subcall."' "); $db->execute(); $subs = $db->loadResult(); // $subcall = $_GET['state']; $date=date('Y-m-d H:i:s'); // $database = JFactory::getDBO(); // Grab the value from the database. // $sql->setQuery("SELECT `id` FROM `clientsap` WHERE `user_id`='".$id."'"); // $sql = "SELECT CONCAT(UserId,FormId,SubmissionId) FROM #__rsform_submissions WHERE `UserId`='".$id."' AND (FormId='96' OR FormId='105') AND `SubmissionId`='".$subcall."'"; $db->setQuery("INSERT INTO article_spec_visits (`ArticleId`,`DateVisit`,`UserId`,`SubsId`) VALUES ('$article->id','$date','$id','$subs')"); $db->execute(); $db->setQuery("SELECT COUNT(`SubmissionId`) FROM article_spec_visits WHERE `UserId`='".$id."' AND ArticleId='87756' AND `SubsId`='".$subs."' AND DATE(`DateVisit`) = CURDATE()"); $db->execute(); $visits = $db->loadResult(); echo "You see report for Submission ID $subcall" ; echo "
"; echo "
ATTENTION ! For safety reasons this page allows only 5 visits/uploads a day for every Submission ID - this is your visit $visits
Altum Datafeeds database updates every 12 hours.
"; echo "Your datafeed unique ID: $subs - $recordered records as ordered and according to General Datafeed Terms
"; if (intval($uploadvar) === 1) { echo "Original file name: $origfile
"; } if (intval($uploadvar) === 2) { $sql = "SELECT httpdf FROM clientsap WHERE `datafeedid`='".$subs."' "; $db->setQuery($sql); $httpdf = $db->loadResult(); echo "Your HTTP datafeed registered source: $httpdf
"; } if (intval($uploadvar) === 3) { $sql = "SELECT ftphost FROM clientsap WHERE `datafeedid`='".$subs."' "; $db->setQuery($sql); $ftphost = $db->loadResult(); $sql = "SELECT ftpfile FROM clientsap WHERE `datafeedid`='".$subs."' "; $db->setQuery($sql); $ftpfile = $db->loadResult(); echo "Your FTP datafeed registered source: $ftphost - $ftpfile
"; } // echo "Your ID: $shortlink
"; echo "Your datafeed status : $dfstatus
" ; // echo "Your datafeed unique ID: $subs
form $form
"; if (intval($feedst) === 7) { if(!empty($shortlink)) { echo "Control Search ALL your products by your own unique ID
"; } // 2022-11-03 11-09 commented search by HASH - too long and scaring // else { // echo "Search ALL your products by your unique hash ID
"; // } echo "Control Search by your Root Domain $rrd OR by Unique Datafeed ID $subs
"; } echo "Subscription PayPal ID Profile: $ppid
"; // https://www.w3schools.com/pHP/func_string_strtoupper.asp // echo strtoupper("Hello WORLD!"); // echo strtoupper($dformat); echo "Registered datafeed extension: "; echo strtoupper($dformat); echo "
"; if (intval($uploadvar) !== 1) { echo "Registered archive extension: "; echo $extarch; echo "
"; } echo "
"; echo "Tools:
"; /* BEGIN PHP BLOCK COMMENT WHEN PRODUCTION function generateRandomString($length = 12) { $characters = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'; $charactersLength = strlen($characters); $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, $charactersLength - 1)]; } return $randomString; } ob_start(); //Start output buffer to move ECHO to VARIABLE echo "I-"; echo generateRandomString(); echo "
"; $ppfalse = ob_get_contents(); //Grab output ECHO ob_end_clean(); //Discard output buffer echo "$ppfalse" ; */ // echo "Change Datafeed Extension - one-time Setup Fee 15 USD
"; if (intval($form) == 96) { echo "Change datafeed details for free - Edit serviceable countries
"; } elseif (intval($form) == 105) { echo "Change datafeed details for free - Edit serviceable countries
"; } echo "Change datafeed details - Replace other Datafeed Details and Subscription - ReInstall fee 10 USD
"; echo "Invoice - usually better download invoice from your PayPal account, but if necessary you also can Request Invoice
"; // echo "Update Existing Datafeed Subscription - ReInstall fee 10 USD
"; // echo "To delete datafeed you should log in to your PayPal account and cancel Subscription ID Profile: $ppid
After the notice from PayPal all your data associated with datafeed $subs will be deleted during 48 hours." ; echo "Delete this datafeed - Delete Datafeed and Subscription
"; echo "
"; // $upvar = $db->loadResult(); if (intval($uploadvar) == 1) { // echo "UPLOADVAR"; echo ""; echo ""; // echo ""; echo ""; echo ''; } } else { echo '
Sorry, but you have reached max 5 daily visits/uploads for this Submission ID. Come back tomorrow.'; } } } else { echo "
You have to login or you have no yet confirmed subscription to place datafeed at AltumPrime.
" ; echo 'SUBSCRIBE HERESee LIVE EXAMPLE'; } ?> {/source}