phpBB.de

Code: Alles auswählen

$sql="update " . USERS_TABLE . " set user_points='$leftamount', user_items='$useritems' where username='{$userdata['username']}'";

Code: Alles auswählen

	//start selection for user search
	$sql = "select * from " . USERS_TABLE . " where user_id='{$_REQUEST['searchid']}'";
	if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error Getting User Info on Inventory Page'); }
	$row = mysql_fetch_array($result);
	if (!isset($row['username'])) { message_die(GENERAL_MESSAGE, 'No Such User!'); }
	else
	{
		$itempurge = str_replace("Þ", "", $row['user_items']);
		$itemarray = explode('ß',$itempurge);
		$itemcount = count($itemarray);
		$user_items = '<br>';
     		for ($xe = 0; $xe < $itemcount; $xe++)
		{
			if ($itemarray[$xe] != NULL)
			{
				if ((${$itemarray[$xe]} != set) && ($board_config['viewinventory'] != normal)) { $useritemamount = substr_count($row['user_items'], "ß".$itemarray[$xe]."Þ"); }
				if (((${$itemarray[$xe]} != set) && ($board_config['viewinventory'] == grouped)) || ($board_config['viewinventory'] == normal))
				{
					$descsql = "select * from phpbb_shopitems where name='" . addslashes($itemarray[$xe]) . "'";
					if ( !($descresult = $db->sql_query($descsql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error Getting User Items On Inventory Page!'); }
					$descrow = mysql_fetch_array($descresult);
					if (file_exists("shop/images/$itemarray[$xe].jpg")) { $itemfilext = "jpg"; }
					elseif (file_exists("shop/images/$itemarray[$xe].png")) { $itemfilext = "png"; }
					else { $itemfilext = 'gif'; }
					$playeritems .= '<tr>
					<td class="row1"><span class="gensmall"><img src="shop/images/'.$itemarray[$xe].'.'.$itemfilext.'" title="'.$itemarray[$xe].'" alt="'.$itemarray[$xe].'"></span></td>
					<td class="row1"><span class="gensmall">'.ucwords($itemarray[$xe]).'</span></td>
					<td class="row1"><span class="gensmall">'.$descrow['ldesc'].'</td>';
				}
				if ((${$itemarray[$xe]} != "set") && ($board_config['viewinventory'] != "normal")) { $playeritems .= '<td class="row1" align="center"><span class="gensmall">'.$useritemamount.'</span></td></tr>'; ${$itemarray[$xe]} = "set"; }
				else { $playeritems .= '</tr>'; }
			}
		}
	}

Code: Alles auswählen

$itemarray