C / C++ / MFC

Quote:

Input : arr[] : {1, 2, 3, 4, 5}
ranges[] = { {0, 2}, {0, 3} }
index : 1
Output : 3
Explanation : After first given rotation {0, 2}
arr[] = {3, 1, 2, 4, 5}
After second rotation {0, 3}
arr[] = {4, 3, 1, 2, 5}
After all rotations we have element 3 at given
index 1.

// CPP code to rotate an array
// and answer the index query
#include <bits/stdc++.h>
using namespace std;

// Function to compute the element at
// given index
int findElement(int arr[], int ranges[][2],
               int rotations, int index)
{
    for (int i = rotations - 1; i >= 0; i--) {

        // Range[left...right]
        int left = ranges[i][0];
        int right = ranges[i][1];

        // Rotation will not have any effect
        if (left <= index && right >= index) {
            if (index == left)
                index = right;
            else
                index--;
        }
    }

    // Returning new element
    return arr[index];
}

// Driver
int main()
{
    int arr[] = { 1, 2, 3, 4, 5 };

    // No. of rotations
    int rotations = 2;

    // Ranges according to 0-based indexing
    int ranges[rotations][2] = { { 0, 2 }, { 0, 3 } };

    int index = 1;

    cout << findElement(arr, ranges, rotations, index);

    return 0;

}

Quote:

and the authors logic:

<?php

$id = $_GET['id'];

if ($id) {
  $sql = "SELECT * FROM forum_sub_cats WHERE id = ?;";

  if(!mysqli_stmt_prepare($stmt, $sql)) {
           echo "SQL error";
        } else {
          mysqli_stmt_bind_param($stmt, "i", $id);
          mysqli_stmt_execute($stmt);
          $result = mysqli_stmt_get_result($stmt);
          $resultCheck = mysqli_num_rows($result);
          $admin_user_level = $admin_user_level + '1';
          if ($resultCheck < 1) {
          	 echo "The forum you are trying to create a topic on, does not exist\n";
          } else {
          	   $row1 = mysqli_fetch_assoc($result);
          	   if ($row1['admin'] == 1 && $admin_user_level == 0) {
                  echo "You are not an administrator, therefore you cannot post on this forum!\n";
          	   } else {
          	   	if (!$_POST['submit']) {
          	   echo "<table border=\"0\" cellspacing=\"3\" cellpadding=\"3\">\n";
          	   echo "<form method=\"POST\" action=\"./forum_main.php?act=create&id=".$id."\">\n";
          	   echo "<tr><td>Form Sub Category</td><td><select name=\"cat\">\n";

          	   $sql2 = "SELECT * FROM forum_cats WHERE admin < ?;";
               
              
          	   if(!mysqli_stmt_prepare($stmt, $sql2)) {
		           echo "SQL error";
		        } else {
		          mysqli_stmt_bind_param($stmt, "i", $admin_user_level);
		          mysqli_stmt_execute($stmt);
		          $result2 = mysqli_stmt_get_result($stmt);
		          while ($row = mysqli_fetch_assoc($result2)) {
                   $row = $row['id'];
                  
		          	$sql3 = "SELECT * FROM forum_sub_cats WHERE cid = ?;";
	                  	
	                 if(!mysqli_stmt_prepare($stmt, $sql3)) {
		                echo "SQL error";
		            } else {
		                mysqli_stmt_bind_param($stmt, "i", $row);
		                mysqli_stmt_execute($stmt);
		                $result3 = mysqli_stmt_get_result($stmt);
		                
		                  echo "<option value=\"0\">".$row['name']."</option>\n";
		               	   while ($row2 = mysqli_fetch_assoc($result3)) {
		               	   	  $selected = ($row2['id'] == $id) ? "SELECTED": "";
		               	   	 
			               	   echo "<option value=\"".$row2['id']."\"".$selected.">     ".$row2['name']."</option>\n";

		               	   }