1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:

		$start = (int) $request->variable('start', 0);
		$cat = (int) $request->variable('select', 1);
		
		// Abfrage welche cat
		
				$sql = "SELECT * FROM phpbb_1smilies WHERE category = '".$cat."'  ORDER BY smiley_id ASC";
		$result1 = $db->sql_query($sql);		
		while ($row1 = $db->sql_fetchrow($result1))
		{
			$smileyid = $row1['smiley_id'];

			 
			 // Abfragen welche smilie in Favoriten
			 $sql = 'SELECT * FROM phpbb_1smilies_favoriten WHERE smilieid = ' . (int)$row1['smiley_id'] . ' ';
			$result2 = $db->sql_query($sql);
		    $abfr = $db->sql_fetchrow($result2);
			$smilieid = $abfr['smilieid'];

// zum testen
 if (mysqli_num_rows($result2)> 0)	
{
  echo "ja";
}
// ende	 
                              $template->assign_block_vars('smilies', array(
				'SMILEY_CODE'		=> $row1['code'],
				'SMILEY_EMOTION'	=> $row1['emotion'],
				'SMILEY_WIDTH'		=> $row1['smiley_width'],
				'SMILEY_HEIGHT'		=> $row1['smiley_height'],
				'STATUS'		     => $smilieid,
				'SMILEY_SRC'		=> generate_board_url() . '/' . $config['smilies_path'] . '/' . $row1['smiley_url'],
			));
				
		}

1:
2:
3:

$cat = (int) $request->variable('select', 1);