Variabelen in adressenlijst
Geplaatst: 12 nov 2005, 21:13
Ik ben bezig met het aanpassen van een custom adressenlijst maar ik krijg het niet voor elkaar de variabelen onder het kopje land en provincie te laten zien, kan iemand helpen?
De variabelen zijn state en country, de pagina is hier te zien
De variabelen zijn state en country, de pagina is hier te zien
Code: Selecteer alles
<?
// Start Statsticks
//define("_BBC_PAGE_NAME", "");
define("_BBCLONE_DIR", "statstics/");
define("COUNTER", _BBCLONE_DIR."mark_page.php");
if (is_readable(COUNTER)) include_once(COUNTER);
// End Statsticks
$phpbb_root_path = "./";
/*##########################################
## STOP #
## DO NOT MODIFY ANYTHING BELOW THIS LINE #
##########################################*/
// Security Check
if ( isset($HTTP_GET_VARS['caluser']) || isset($HTTP_POST_VARS['caluser']) || isset($caluser)) {
// Failed the test... Someone tried to spoof as a user.
}
else {
// Passed.
define('IN_PHPBB', true);
}
$thisscript = basename(__FILE__);
// connect to phpbb
include_once($phpbb_root_path . 'extension.inc');
include_once($phpbb_root_path . 'common.'.$phpEx);
include_once($phpbb_root_path . 'includes/bbcode.'.$phpEx);
include_once($phpbb_root_path . 'includes/functions.'.$phpEx);
$params = array(
'sid' => 'sid',
'id' => 'id',
'cl_d' => 'cl_d',
'cl_m' => 'cl_m',
'cl_y' => 'cl_y',
'mode' => 'mode',
'action' => 'action',
'cl_h' => 'cl_h',
'cl_min' => 'cl_min',
'cl_time' => 'cl_time',
'cl_ed' => 'cl_ed',
'cl_em' => 'cl_em',
'cl_ey' => 'cl_ey',
'subject' => 'subject',
'description' => 'message',
'modify' => 'modify',
);
//echo "<pre>";
while( list($var, $param) = @each($params) )
{
//echo "P: $param , V: ".$HTTP_POST_VARS[$param]."\n";
if ( isset($HTTP_POST_VARS[$param]) || isset($HTTP_GET_VARS[$param]) ) {
$$var = ( isset($HTTP_POST_VARS[$param]) ) ? $HTTP_POST_VARS[$param] : $HTTP_GET_VARS[$param];
} else {
unset($$var);
}
}
// Start session management
$userdata = session_pagestart($user_ip, PAGE_INDEX, $session_length);
init_userprefs($userdata);
include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_addresses.' . $phpEx);
include ($phpbb_root_path . "includes/page_header.".$phpEx);
$template->set_filenames(array(
'body' => 'addresses.tpl')
);
// Create country selectbox
$country_select = "<select name=\"country_id\" class=\"input\">";
$country_select .= "<option value=\"no\">Geen land</option>";
$sql = "SELECT * ";
$sql .= "FROM ADDR_countries ";
$result2 = mysql_query($sql);
if (mysql_num_rows($result2) > 0) {
while($row2 = mysql_fetch_array($result2)){
$country_select .= "<option value=\"$row2[country_id]\">" . $row2['name'] . "</option>\r\n";
} // while
}
$country_select .= "</select>";
// End country selectbox
// Create assortment selectbox
$assort_select = "<select name=\"assort_id\">";
$assort_select .= "<option value=\"no\">".$lang['Addr_noassort']."</option>";
$sql = "SELECT * ";
$sql .= "FROM ADDR_assortiment ";
$result1 = mysql_query($sql);
if (mysql_num_rows($result1) > 0) {
while($row1 = mysql_fetch_array($result1)){
$assort_select .= "<option value=\"$row1[assort_id]\">" . $row1['name'] . "</option>\r\n";
} // while
}
$assort_select .= "</select>";
// End assortment selectbox
$state_id = $HTTP_POST_VARS['state_id'];
$state = $HTTP_POST_VARS['state'];
$assort_id = $HTTP_POST_VARS['assort_id'];
$country_id = $HTTP_POST_VARS['country_id'];
$city = $HTTP_POST_VARS['city'];
$assort = $HTTP_POST_VARS['assort'];
$name = $HTTP_POST_VARS['name'];
$special = $HTTP_POST_VARS['special'];
$form_link = $HTTP_POST_VARS['form_link'];
if (!isset($HTTP_GET_VARS['sname']) || $HTTP_GET_VARS['sname'] == "ASC") $sname = "DESC"; else $sname = "ASC";
if (!isset($HTTP_GET_VARS['scity']) || $HTTP_GET_VARS['scity'] == "DESC") $scity = "ASC"; else $scity = "DESC";
if (!isset($HTTP_GET_VARS['stel']) || $HTTP_GET_VARS['stel'] == "DESC") $stel = "ASC"; else $stel = "DESC";
if (!isset($HTTP_GET_VARS['swww']) || $HTTP_GET_VARS['swww'] == "DESC") $swww = "ASC"; else $swww = "DESC";
$template->assign_vars(array(
'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
'L_ADDR_NAME' => $lang['Addr_name'],
'L_ADDR_CITY' => $lang['Addr_city'],
'L_ADDR_WWW' => $lang['Addr_www'],
'L_ADDR_TEL' => $lang['Addr_tel'],
'L_ADDR_ASSORT' => $lang['Addr_assort'],
'L_ADDR_VOTE' => $lang['Addr_vote'],
'L_ADDR_SPECIAL' => $lang['Addr_special'],
'L_ADDR_MAIL' => $lang['Addr_mail'],
'L_ADDR_FOUND' => $lang['Addr_found'],
'L_ADDR_FIND' => $lang['Addr_find'],
'L_ADDR_NOASSORT' => $lang['Addr_noassort'],
'L_ADDR_NOCOUNTRY' => $lang['Addr_nocountry'],
'L_ADDR_SEARCH' => $lang['Addr_search'],
'L_ADDR_STATE' => $lang['Addr_state'],
'L_ADDR_PC' => $lang['Addr_pc'],
'L_ADDR_COUNTRY' => $lang['Addr_country'],
'L_ADDR_FORMLINK' => $lang['Addr_formlink'],
'L_ADDR_ADDRESSLIST' => $lang['Addresses'],
'U_ADDRESS_SEARCH' => append_sid("addresses.$phpEx"),
'U_ADDR_SNAME' => append_sid("addresses.{$phpEx}?sname=$sname"),
'U_ADDR_SCITY' => append_sid("addresses.{$phpEx}?scity=$scity"),
'U_ADDR_STEL' => append_sid("addresses.{$phpEx}?stel=$stel"),
'U_ADDR_SWWW' => append_sid("addresses.{$phpEx}?swww=$swww"),
'SELECT_ASSORT' => $assort_select,
'SELECT_COUNTRY' => $country_select,
'ADDR_STATE_ID' => $state_id,
'ADDR_STATE' => $state,
'ADDR_ASSORT_ID' => $assort_id,
'ADDR_ASSORT' => $assort,
'ADDR_NAME' => $name,
'ADDR_COUNTRY_ID' => $country_id,
'ADDR_CITY' => $city,
'ADDR_SPECIAL' => $special,
'ADDR_FORMLINK' => $formlink
)
);
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$state_id = $HTTP_POST_VARS['state_id'];
$state = $HTTP_POST_VARS['state'];
$assort_id = $HTTP_POST_VARS['assort_id'];
$country_id = $HTTP_POST_VARS['country_id'];
$city = $HTTP_POST_VARS['city'];
$assort = $HTTP_POST_VARS['assort'];
$name = $HTTP_POST_VARS['name'];
$special = $HTTP_POST_VARS['special'];
$form_link = $HTTP_POST_VARS['form_link'];
$sql = "SELECT * ";
$sql .= "FROM ADDR_states, ADDR_assortiment, ADDR_adres_assortimenten, ADDR_adressen ";
$sql .= "WHERE ADDR_adressen.state_id = ADDR_states.state_id ";
//$sql .= "AND countries.country_id = adressen.country_id ";
$sql .= "AND ADDR_assortiment.assort_id = ADDR_adres_assortimenten.assort_id ";
$sql .= "AND ADDR_adres_assortimenten.addr_id = ADDR_adressen.addr_id ";
$sql .= "AND ADDR_adressen.active = 'Y' ";
if (!empty($name)) $sql .= "AND ADDR_adressen.name LIKE '%$name%' ";
if (!empty($city)) $sql .= "AND city LIKE '%$city%' ";
if (!empty($state)) $sql .= "AND ADDR_states.name LIKE '%$state%' ";
if ($country_id != "no") $sql .= "AND ADDR_adressen.country_id = '$country_id' ";
if ($assort_id != "no") $sql .= "AND ADDR_adres_assortimenten.assort_id = '$assort_id' ";
if (!empty($special)) $sql .= "AND ADDR_adressen.special LIKE '%$special%' ";
$sql .= "GROUP BY ADDR_adres_assortimenten.addr_id ";
$sql .= "ORDER BY ADDR_adressen.name";
// $addresses = mysql_query($sql) or die (mysql_error());
// echo $sql;
}
else {
$sql = "SELECT * ";
$sql .= "FROM ADDR_states, ADDR_assortiment, ADDR_adres_assortimenten, ADDR_adressen ";
$sql .= "WHERE ADDR_assortiment.assort_id = ADDR_adres_assortimenten.assort_id ";
$sql .= "AND ADDR_adres_assortimenten.addr_id = ADDR_adressen.addr_id ";
$sql .= "AND ADDR_adressen.active = 'Y' ";
$sql .= "GROUP BY ADDR_adres_assortimenten.addr_id ";
if (isset($HTTP_GET_VARS['sname']) || isset($HTTP_GET_VARS['scity']) || isset($HTTP_GET_VARS['stel']) || isset($HTTP_GET_VARS['swww'])) {
if (isset($HTTP_GET_VARS['sname'])) $sql .= "ORDER BY ADDR_adressen.name $HTTP_GET_VARS[sname]";
if (isset($HTTP_GET_VARS['scity'])) $sql .= "ORDER BY ADDR_adressen.city $HTTP_GET_VARS[scity]";
if (isset($HTTP_GET_VARS['stel'])) $sql .= "ORDER BY ADDR_adressen.tel $HTTP_GET_VARS[stel]";
if (isset($HTTP_GET_VARS['swww'])) $sql .= "ORDER BY ADDR_adressen.www $HTTP_GET_VARS[swww]";
}
else $sql .= "ORDER BY ADDR_adressen.name";
}
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}
if ( $row = $db->sql_fetchrow($result) )
{
$i = 0;
do
{
$address_name = $row['name'];
$address_city = $row['city'];
$address_tel = $row['tel'];
if ($row['www'] == "http://") $addreses_www; else $address_www = $row['www'];
$address_id = $row['addr_id'];
$address_link = "address_info.{$phpEx}?addr_id=$address_id";
$assort_count = 0;
$sql = "SELECT * ";
$sql .= "FROM ADDR_adres_assortimenten, ADDR_assortiment ";
$sql .= "WHERE ADDR_adres_assortimenten.assort_id = ADDR_assortiment.assort_id ";
$sql .= "AND ADDR_adres_assortimenten.addr_id = '$row[addr_id]' ";
$sql .= "ORDER BY name ";
if (!($assortimenten = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}
// echo $sql;
if ($assortiment = $db->sql_fetchrow($assortimenten)) {
do {
if ($assort_count == 0) $user_assort = $assortiment['name'];
else $user_assort .= ", " . $assortiment['name'];
$assort_count++;
}
while($assortiment = $db->sql_fetchrow($assortimenten));
$db->sql_freeresult($assortimenten);
}
$sql = "SELECT * ";
$sql .= "FROM ADDR_winkelservice ";
$sql .= "WHERE addr_id = '$row[addr_id]' ";
if (!($votes = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}
if ($vote = $db->sql_fetchrow($votes)) {
$vote_count = 0;
$total = 0;
$waardering = 0;
do {
$total+=$vote['vote'];
$vote_count++;
}
while($vote = $db->sql_fetchrow($votes));
$db->sql_freeresult($votes);
$waardering = $total/$vote_count;
$vote = number_format($waardering,'1',',','');
// echo " <i>( ".$vote_count." keer gestemd )</i></td>\r\n";
}
else $vote = "Niet gevote";
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? "row1" : "row2";
$template->assign_block_vars('addressrow', array(
'ROW_NUMBER' => $i + ( $start + 1 ),
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'ROW_OVER' => 'row3',
'NAME' => $address_name,
'CITY' => $address_city,
'TEL' => $address_tel,
'WWW' => $address_www,
'ASSORT' => $user_assort,
'VOTE' => $vote,
'U_INFO_LINK' => $address_link)
);
$i++;
}
while ( $row = $db->sql_fetchrow($result) );
$db->sql_freeresult($result);
}
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>