Probleem met adressenlijst
Geplaatst: 20 okt 2005, 20:38
Voor mijn forum heb ik een adressenlijst laten bouwen echter voordat die helemaal klaar was zijn de makers er mee gestopt. Ik hoop dat iemand mij met de laatste problemen kan helpen.
Het grootste probleem is dat na het verplaatsen van de forumdirectory naar de root de adressen niet meer gevonden kunnen worden, wel in het ACP trouwens. Waar kan het probleem zitten? De adressenlijst staat hier.
Het grootste probleem is dat na het verplaatsen van de forumdirectory naar de root de adressen niet meer gevonden kunnen worden, wel in het ACP trouwens. Waar kan het probleem zitten? De adressenlijst staat hier.
Code: Selecteer alles
<?
$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);
?>Code: Selecteer alles
<?
$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);
// Start session management
$gen_simple_header = TRUE;
$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.php");
$template->set_filenames(array(
'body' => 'address_info.tpl')
);
if (!isset($addr_id)) {
if (isset($HTTP_GET_VARS['addr_id'])) $addr_id = $HTTP_GET_VARS['addr_id'];
elseif (isset($HTTP_POST_VARS['addr_id'])) $addr_id = $HTTP_POST_VARS['addr_id'];
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$usr_id = $userdata['user_id'];
$sql = "SELECT * ";
$sql .= "FROM ADDR_winkelservice ";
$sql .= "WHERE addr_id = '$addr_id' ";
$sql .= "AND user_id = '$usr_id' ";
$sql .= "LIMIT 1";
$resultaat = mysql_query($sql);
$rate = $HTTP_POST_VARS['vote'];
if (mysql_num_rows($resultaat) < 1 ) {
$sql = "INSERT INTO ADDR_winkelservice SET ";
$sql .= "addr_id = '$addr_id', ";
$sql .= "user_id = '$usr_id', ";
$sql .= "vote = '$rate'";
}
else {
$sql = "UPDATE ADDR_winkelservice SET ";
$sql .= "vote = '$rate' ";
$sql .= "WHERE addr_id = '$addr_id' ";
$sql .= "AND user_id = '$usr_id' ";
$sql .= "LIMIT 1";
}
mysql_query($sql);
}
if ($addr_id < 1) echo "<span class=\"gen\">Adres niet gevonden.</span>\r\n";
else {
$sql = "SELECT ADDR_adressen.name AS company, ADDR_countries.name AS country, ADDR_states.name AS state, eshop, ";
$sql .= "pc, city, form_link, www, mail, tel, addr, special, ADDR_adressen.addr_id AS comp_id ";
$sql .= "FROM ADDR_adressen, ADDR_states, ADDR_countries ";
$sql .= "WHERE ADDR_adressen.state_id = ADDR_states.state_id ";
$sql .= "AND ADDR_countries.country_id = ADDR_adressen.country_id ";
$sql .= "AND ADDR_adressen.addr_id = '$addr_id' ";
$sql .= "LIMIT 1";
$adressen = mysql_query($sql);
// echo $sql;
if (mysql_num_rows($adressen) < 1) {
echo "<span class=\"gen\">Adres niet gevonden.</span>\r\n";
exit;
}
else {
$adres = mysql_fetch_array($adressen);
}
}
if($adres['form_link'] != "http://" && $adres['form_link'] > "") $formlink = $adres['form_link'];
else $formlink = "";
$assort = "";
$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 = '$adres[comp_id]' ";
$sql .= "ORDER BY name ";
$assortimenten = mysql_query($sql);
// echo $sql;
if (mysql_num_rows($assortimenten) > 0) {
while($assortiment = mysql_fetch_array($assortimenten)){
if ($assort_count == 0) $assort .= $assortiment['name'];
else $assort .= ", " . $assortiment['name'];
$assort_count++;
} // while
}
$sql = "SELECT * ";
$sql .= "FROM ADDR_winkelservice ";
$sql .= "WHERE addr_id = '$adres[comp_id]' ";
$votes = mysql_query($sql);
if (mysql_num_rows($votes) > 0) {
$vote_count = 0;
$total = 0;
$waardering = 0;
while($vote = mysql_fetch_array($votes)){
$total+=$vote['vote'];
$vote_count++;
} // while
$waardering = $total/$vote_count;
$votes = number_format($waardering,'1',',','');
}
else {
$votes = 0;
$vote_count = 0;
}
if ($userdata['user_id'] > 0) {
$your_voting = "<tr class=\"row1\"><form action=\"address_info.$phpEx\" method=\"post\">";
$your_voting .= "<td class=\"gen\">".$lang["Addr_your_vote"].": </td>\r\n";
$your_voting .= "<td class=\"gen\">";
$sql = "SELECT * ";
$sql .= "FROM ADDR_winkelservice ";
$sql .= "WHERE addr_id = '$adres[comp_id]' ";
$sql .= "AND user_id = '$userdata[user_id]' ";
$sql .= "LIMIT 1";
$usr_votes = mysql_query($sql);
if (mysql_num_rows($usr_votes) > 0 ) $usr_vote = mysql_fetch_array($usr_votes);
$your_voting .= "<select name=\"vote\">";
for ($i=1;$i<=10;$i+=0.5) {
$i_dec = number_format($i,'1','.','');
$your_voting .= "<option value=\"". $i. "\" ";
if (isset($usr_vote) && $i_dec == $usr_vote['vote']) $your_voting .= "SELECTED";
if (!isset($usr_vote) && $i == 5) $your_voting .= "SELECTED";
$your_voting .= ">".number_format($i,'1',',',''). "</option>";
}
$your_voting .= "</select> <input class=\"mainoption\" type=\"submit\" value=\"".$lang['Addr_submit_vote']."\" name=\"actie\">";
$your_voting .= "</td>\r\n";
$your_voting .= "<input type=\"hidden\" name=\"addr_id\" value=\"".$addr_id."\"";
$your_voting .= "</form></tr>";
$reaction = "<tr class=\"row1\" height=\"25\"><td class=\"gen\" colspan=\"2\" align=\"center\"><br><input class=\"mainoption\" type=\"button\" value=\"Foutieve informatie melden\" onClick=\"window.open('address_reaction_form.{$phpEx}?addr_id=$addr_id','reaction','scrollbars=no ,width=430,height=480')\"></b></td></tr>";
}
if ($adres['eshop'] == "Y") $eshop = "<tr class=\"row1\" height=\"25\"><td class=\"gen\" colspan=\"2\"><b>".$lang["Addr_eshop_message"]."</b></td></tr>";
else $eshop = "";
$name = $adres['company'];
$addr = $adres['addr'];
$pc = $adres['pc'];
$city = $adres['city'];
$state = $adres['state'];
$country = $adres['country'];
$www = $adres['www'];
$mail = $adres['mail'];
$tel = $adres['tel'];
$special = $adres['special'];
$template->assign_vars(array(
'NAME' => $name,
'ADDR' => $addr,
'PC' => $pc,
'CITY' => $city,
'STATE' => $state,
'COUNTRY' => $country,
'WWW' => $www,
'MAIL' => $mail,
'TEL' => $tel,
'ESHOP' => $eshop,
'SPECIAL' => $special,
'FORMLINK' => $formlink,
'ASSORT' => $assort,
'ADDR_ID' => $addr_id,
'VOTE_RIM_DETAIL_SELECT' => $rim_detail_select,
'VOTE_BRAKE_DETAIL_SELECT' => $brake_detail_select,
'PRICE_INPUT' => $price_input,
'VOTES' => $votes,
'VOTE_COUNT' => $vote_count,
'YOUR_VOTING' => $your_voting,
'REACTION' => $reaction,
'U_ADDRES_INFO' => "address_info.{$phpEx}?addr_id=$addr_id"
));
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>