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);
?>
