Text only | Text with Images

SleePyCode Forums

Special Site & Other Boards => PasteBin => Topic started by: IchBin on Aug 04, 2007, 11:58 PM

Title: Paste-1186271909:v:use_geshi-1:v:type-php
Post by: IchBin on Aug 04, 2007, 11:58 PM
   global $db_prefix, $context, $user_info;
   
   if (isset($context['jump_to']))
      return;

   // Find the boards/cateogories they can see.
   $request = db_query("
      SELECT c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.childLevel
      FROM {$db_prefix}boards AS b
         LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)
      WHERE $user_info[query_see_board]", __FILE__, __LINE__);
   $context['jump_to'] = array();
   $this_cat = array('id' => -1);
   while ($row = mysql_fetch_assoc($request))
   {
      if ($this_cat['id'] != $row['ID_CAT'])
      {
         $this_cat = &$context['jump_to'][];
         $this_cat['id'] = $row['ID_CAT'];
         $this_cat['name'] = $row['catName'];
         $this_cat['boards'] = array();
      }

      $this_cat['boards'][] = array(
         'id' => $row['ID_BOARD'],
         'name' => $row['boardName'],
         'child_level' => $row['childLevel'],
         'is_current' => isset($context['current_board']) && $row['ID_BOARD'] == $context['current_board']
      );
   }
   mysql_free_result($request);


               echo '<select id="moveItTo" name="move_to" disabled="disabled">';

               foreach ($context['jump_to'] as $category){
                     foreach ($category['boards'] as $board){

                           echo '
                                    <option value="', $board['id'], '">', $board['name'], '</option>';
                     }
               }
               echo '</select>';
Title: Paste-1186272134:v:use_geshi-1:v:type-php
Post by: Guest on Aug 05, 2007, 12:02 AM
   global $db_prefix, $context, $user_info;
   
   if (isset($context['jump_to']))
      return;

   // Find the boards/cateogories they can see.
   $request = db_query("
      SELECT c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.childLevel
      FROM {$db_prefix}boards AS b
         LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)
      WHERE $user_info[query_see_board]", __FILE__, __LINE__);
   $context['jump_to'] = array();
   $this_cat = array('id' => -1);
   while ($row = mysql_fetch_assoc($request))
   {
      if ($this_cat['id'] != $row['ID_CAT'])
      {
         $this_cat = &$context['jump_to'][];
         $this_cat['id'] = $row['ID_CAT'];
         $this_cat['name'] = $row['catName'];
         $this_cat['boards'] = array();
      }

      $this_cat['boards'][] = array(
         'id' => $row['ID_BOARD'],
         'name' => $row['boardName'],
         'child_level' => $row['childLevel'],
         'is_current' => isset($context['current_board']) && $row['ID_BOARD'] == $context['current_board']
      );
   }
   mysql_free_result($request);


echo '<select id="moveItTo" name="move_to" disabled="disabled">';

   foreach ($context['jump_to'] as $category){
      foreach ($category['boards'] as $board){

         echo '<option value="', $board['id'], '">', $board['name'], '</option>';
      }
   }
echo '</select>';
Title: Paste-1186275799:v:use_geshi-1:v:type-php
Post by: Guest on Aug 05, 2007, 01:03 AM
   global $db_prefix, $context, $user_info;
   
   if (isset($context['jump_to']))
      return;

   // Find the boards/cateogories they can see.
   $request = db_query("
      SELECT c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.childLevel
      FROM {$db_prefix}boards AS b
         LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)
      WHERE $user_info[query_see_board]", __FILE__, __LINE__);
   $context['jump_to'] = array();
   $this_cat = array('id' => -1);
   while ($row = mysql_fetch_assoc($request))
   {
      if ($this_cat['id'] != $row['ID_CAT'])
      {
         $this_cat = &$context['jump_to'][];
         $this_cat['id'] = $row['ID_CAT'];
         $this_cat['name'] = $row['catName'];
         $this_cat['boards'] = array();
      }

      $this_cat['boards'][] = array(
         'id' => $row['ID_BOARD'],
         'name' => $row['boardName'],
         'child_level' => $row['childLevel'],
         'is_current' => isset($context['current_board']) && $row['ID_BOARD'] == $context['current_board']
      );
   }
   mysql_free_result($request);

echo '<form action="',$scripturl . '?' $_SERVER['QUERY_STRING'],'" method="post">';
echo '<select id="moveItTo" name="move_to">';

   foreach ($context['jump_to'] as $category){
      foreach ($category['boards'] as $board){

         echo '<option value="', $board['id'], '">', str_repeat('-', $board['child_level'] + 1), ' ', $board['name'], '</option>';
      }
   }
echo '</select>';
echo '<input type="submit" name="mySubmit" value="Submit">';
echo '</form>';
Title: Paste-1186276417:v:use_geshi-1:v:type-php
Post by: Guest on Aug 05, 2007, 01:13 AM
<?php
   global $db_prefix, $context, $user_info;
   
   if (isset($context['jump_to']))
      return;

   // Find the boards/cateogories they can see.
   $request = db_query("
      SELECT c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.childLevel
      FROM {$db_prefix}boards AS b
         LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)
      WHERE $user_info[query_see_board]", __FILE__, __LINE__);
   $context['jump_to'] = array();
   $this_cat = array('id' => -1);
   while ($row = mysql_fetch_assoc($request))
   {
      if ($this_cat['id'] != $row['ID_CAT'])
      {
         $this_cat = &$context['jump_to'][];
         $this_cat['id'] = $row['ID_CAT'];
         $this_cat['name'] = $row['catName'];
         $this_cat['boards'] = array();
      }

      $this_cat['boards'][] = array(
         'id' => $row['ID_BOARD'],
         'name' => $row['boardName'],
         'child_level' => $row['childLevel'],
         'is_current' => isset($context['current_board']) && $row['ID_BOARD'] == $context['current_board']
      );
   }
   mysql_free_result($request);

echo '<form action="',$scripturl . '?' $_SERVER['QUERY_STRING'],'" method="post">';
echo '<select id="moveItTo" name="move_to">';

   foreach ($context['jump_to'] as $category){
      foreach ($category['boards'] as $board){

         echo '<option value="', $board['id'], '">', str_repeat('-', $board['child_level'] + 1), ' ', $board['name'], '</option>';
      }
   }
echo '</select>';
echo '<input type="submit" name="mySubmit" value="Submit">';
echo '</form>';

if (isset($_POST['mySubmit'])){
   $temp = $user_info['query_see_board'];
   $user_info['query_see_board'] .= "\nAND b.id_board = " .(int) $_POST['id'];
      ssi_recentPosts();
   $user_info['query_see_board'] = $temp;
}
?>
Title: Paste-1186277356:v:use_geshi-1:v:type-php
Post by: Guest on Aug 05, 2007, 01:29 AM
<?php
   global $db_prefix, $context, $user_info;
   
   if (isset($context['jump_to']))
      return;

   // Find the boards/cateogories they can see.
   $request = db_query("
      SELECT c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.childLevel
      FROM {$db_prefix}boards AS b
         LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)
      WHERE $user_info[query_see_board]", __FILE__, __LINE__);
   $context['jump_to'] = array();
   $this_cat = array('id' => -1);
   while ($row = mysql_fetch_assoc($request))
   {
      if ($this_cat['id'] != $row['ID_CAT'])
      {
         $this_cat = &$context['jump_to'][];
         $this_cat['id'] = $row['ID_CAT'];
         $this_cat['name'] = $row['catName'];
         $this_cat['boards'] = array();
      }

      $this_cat['boards'][] = array(
         'id' => $row['ID_BOARD'],
         'name' => $row['boardName'],
         'child_level' => $row['childLevel'],
         'is_current' => isset($context['current_board']) && $row['ID_BOARD'] == $context['current_board']
      );
   }
   mysql_free_result($request);

echo '<form action="',$scripturl . '?' $_SERVER['QUERY_STRING'],'" method="post">';
echo '<select id="moveItTo" name="move_to">';

   foreach ($context['jump_to'] as $category){
      foreach ($category['boards'] as $board){

         echo '<option value="', $board['id'], '">', str_repeat('-', $board['child_level'] + 1), ' ', $board['name'], '</option>';
      }
   }
echo '</select>';
echo '<input type="submit" name="mySubmit" value="Submit">';
echo '</form>';

if (isset($_POST['mySubmit'])){
   $temp = $user_info['query_see_board'];
   $user_info['query_see_board'] .= "\nAND b.id_board = " .(int) $_POST['move_to'];
      ssi_recentPosts();
   $user_info['query_see_board'] = $temp;
}
?>
Text only | Text with Images