phpBB.de

Code: Alles auswählen

<!-- BEGIN skillrow -->
<tr>
<td class="row1" align='center' rowspan='{skillrow.USERANZ}'>{skillrow.SKILL} / {skillrow.USERANZ}</td>

<!-- BEGIN userrow -->
<td class="row1" align='center'>{userrow.NAME}</td>
<td class="row1" align='center'>{userrow.LEVEL}</td>
<!-- END userrow -->
</tr>
<!-- END skillrow -->
</table>

Code: Alles auswählen

// get uis some skills ^^
		$sql = 'SELECT ID FROM phpbb_craftsman_skill';
		$result = $db->sql_query($sql);
		
		$skill_list = array();
		while ($row = $db->sql_fetchrow($result))
		{
			$skill_list[] = (int) $row['ID'];
		}
		$db->sql_freeresult($result);
		
		// So, did we get any users?
		if (sizeof($skill_list))
		{
			$sql = 'SELECT * 
FROM `phpbb_craftsman_skill` 
ORDER BY `phpbb_craftsman_skill`.`skill` ASC';
			$result = $db->sql_query($sql);

			$skill_cache = array();
			while ($row = $db->sql_fetchrow($result))
			{
				$skill_cache[$row['ID']] = $row;
			}
			$db->sql_freeresult($result);

			for ($i_skill = 0, $end = sizeof($skill_list); $i_skill < $end; ++$i_skill)
			{
				$skill_id = $skill_list[$i_skill];
				$row_skill =& $skill_cache[$skill_id];
				
				//------------ NAMES
					// get uis some names
					$sql = 'SELECT ID FROM phpbb_craftsman_data WHERE skill = '.$row_skill['ID'];
					$result = $db->sql_query($sql);
					
					$data_list = array();
					while ($row = $db->sql_fetchrow($result))
					{
						$data_list[] = (int) $row['ID'];
					}
					$db->sql_freeresult($result);
					
					// So, did we get any users?
					if (sizeof($data_list))
					{
						$sql = 'SELECT * FROM phpbb_craftsman_data';
						$result = $db->sql_query($sql);
			
						$data_cache = array();
						while ($row = $db->sql_fetchrow($result))
						{
							$data_cache[$row['ID']] = $row;
						}
						$db->sql_freeresult($result);
			
						for ($i_data = 0, $end = sizeof($data_list); $i_data < $end; ++$i_data)
						{
							$data_id = $data_list[$i_data];
							$row_data =& $data_cache[$data_id];
							
							$row_data['lv'] = $skill_lv_list[$row_data['lv']][2];
							
							$userrow = array_merge($arrays, array(
								'NAME' => $row_data['name'],
								'LEVEL' => $row_data['lv']
								));
							$template->assign_block_vars('userrow', $userrow);
						}
					}
					else
					{
						$userrow = array_merge($arrays, array(
							'NAME' => 'noname',
							'LEVEL' => 'n.A.'
							));
						$template->assign_block_vars('userrow', $userrow);
					//}
				$skillrow = array_merge($arrays, array(
					'SKILL' => $row_skill['skill'],
					'USERANZ' => sizeof($data_list)
					));
				$template->assign_block_vars('skillrow', $skillrow);
			}
		}
		$template_html = 'craftsman_body.html';
	}

Code: Alles auswählen

<!-- BEGIN skillrow -->
<tr>
<td class="row1" align='center' rowspan='{skillrow.USERANZ}'>{skillrow.SKILL} / {skillrow.USERANZ}</td>

</tr>
<!-- END skillrow -->
<!-- BEGIN userrow -->
<td class="row1" align='center'>{userrow.NAME}</td>
<td class="row1" align='center'>{userrow.LEVEL}</td>
<!-- END userrow -->

</table>