ok quite a bit before it but i posted pretty much full section, cuz this hack i need, i need usergroup id's which i need to use this for so without further talkin lol
PHP Code:
// ###################### Start modify promotions #######################
if ($_REQUEST['do'] == 'modifypromotion')
{
globalize($_REQUEST, array('usergroupid' => INT));
$title = $DB_site->query_first("SELECT title FROM " . TABLE_PREFIX . "usergroup WHERE usergroupid = $usergroupid");
$promotions = array();
$getpromos = $DB_site->query("
SELECT userpromotion.*, joinusergroup.title
FROM " . TABLE_PREFIX . "userpromotion AS userpromotion
LEFT JOIN " . TABLE_PREFIX . "usergroup AS joinusergroup ON (userpromotion.joinusergroupid = joinusergroup.usergroupid)
" . iif($usergroupid, "WHERE userpromotion.usergroupid = $usergroupid") . "
");
while ($promotion = $DB_site->fetch_array($getpromos))
{
$promotions["$promotion[usergroupid]"][] = $promotion;
}
unset($promotion);
$DB_site->free_result($getpromos);
print_form_header('usergroup', 'updatepromotion');
if (isset($usergroupcache["$usergroupid"]))
{
construct_hidden_code('usergroupid', $usergroupid);
}
foreach($promotions AS $groupid => $promos)
{
print_table_header("$vbphrase[promotions]: <span style=\"font-weight:normal\">{$usergroupcache[$groupid][title]} " . construct_link_code($vbphrase['add_new_promotion'], "usergroup.php?$session[sessionurl]do=updatepromotion&usergroupid=$groupid") . "</span>", 7);
print_cells_row(array(
$vbphrase['usergroup'],
$vbphrase['promotion_type'],
$vbphrase['promotion_strategy'],
$vbphrase['reputation_level'],
$vbphrase['days_registered'],
$vbphrase['posts'],
$vbphrase['controls']
), 1);
---->1363 foreach($promos AS $promotion)
{
Hope i get help by mornin
anyone?
help