[Mod] Memberlist / Mitgliederliste > for/für v 1.7.x

[anderitor]

Can you tell me what this mean?

DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE user_id NOT IN ('-1') ORDER BY username ASC LIMIT 0, 30
Unknown column 'username' in 'order clause'

Thank you

[TheOracle]

It means you're probably using mySQL 5 and you need to apply some patches from this forum in order to get rid of this error message.

Simply search for : mySQL 5 and results should be returned to you.

[V@no]

Can you tell me what this mean?

DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE user_id NOT IN ('-1') ORDER BY username ASC LIMIT 0, 30
Unknown column 'username' in 'order clause'

Thank you

That means that either you've modifyed memberlist.php and made a misstake - with that nobody can help you, since nobody could possible know what modifications you've made, or you have an intgration with a forum, which causing this error.
And since you've provided no usefull information, the answer to your question is:
You are trying to sort members list by 'username' field, but there is no such field in default 4images.

It means you're probably using mySQL 5 and you need to apply some patches from this forum in order to get rid of this error message.

Simply search for : mySQL 5 and results should be returned to you.

maybe you should just be quiet, if you want to stay here

[TheOracle]

Perhaps my response was a little bit too pushed ... what I meant is since there are many topics regarding the ' where clause ' issue and that many of your answers refers to mySQL 5 (based on this error), then it was clairly that patches needed to be installed.

[V@no]

And that related to the topic/problem anderitor has HOW?
STOP THE SPAM!

[Fragezeichen]

after fixing mysql5 the same problem are to.it dosent change anything,i get the error message

DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE user_id NOT IN ('-1') ORDER BY username ASC LIMIT 0, 30
Unknown column 'username' in 'order clause'

[TheOracle]

I don't think this error has shown since you installed the memberlist MOD ... I have just searched for many relations for : ORDER BY username and hasn't come up with anything ...

Could you show the actual codings on where exacly this has been coded (if so, which file was it ?) ?

[V@no]

That means that either you've modifyed memberlist.php and made a misstake - with that nobody can help you, since nobody could possible know what modifications you've made, or you have an intgration with a forum, which causing this error.
And since you've provided no usefull information, the answer to your question is:
You are trying to sort members list by 'username' field, but there is no such field in default 4images.

[Fragezeichen]

the only thing that workswell are show members email,other parts dont work.
so there,if needful i want open memberlist code,possible some one can help me please?

Code: [Select]

<?php 
/**************************************************************************
 *                                                                        *
 *    4images - A Web Based Image Gallery Management System               *
 *    ----------------------------------------------------------------    *
 *                                                                        *
 *             File: memberlist.php (MOD)                                 *
 *        Copyright: (C) 2002 Jan Sorgalla                                *
 *            Email: jan@4homepages.de                                    *
 *              Web: http://www.4homepages.de                             *
 *    Scriptversion: 1.0 for 4images 1.7 & phpBB 2.0.2                    *
 *                                                                        *
 *    Never released without support from: Nicky (http://www.nicky.net)   *
 *                                                                        *
 **************************************************************************
 *                                                                        *
 *    Dieses Script ist KEINE Freeware. Bitte lesen Sie die Lizenz-       *
 *    bedingungen (http://www.4homepages.de/4images/lizenz.php) fr       *
 *    weitere Informationen.                                              *
 *    ---------------------------------------------------------------     *
 *    This script is NOT freeware! Please read the Copyright Notice       *
 *    (http://www.4homepages.de/4images/lizenz_e.php) for further         *
 *    information.                                                        *
 *                                                                        *
 *************************************************************************/

$templates_used = 'memberlist,memberlist_sort';
$main_template = 'memberlist';

define('GET_CACHES', 1);
define('ROOT_PATH', './');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
include(ROOT_PATH.'includes/page_header.php');

//----------------------------
//---- Set user per page -----
//----------------------------
$user_per_page = 10;

//----------------------------
//---- Uncomment -------------
//----------------------------

/*
if ($user_info['user_level'] == GUEST || $user_info['user_level'] == USER_AWAITING) {
  show_error_page($lang['no_permission']);
  exit;
}
*/

//----------------------------
//---- Sort ------------------
//----------------------------

if(isset($HTTP_POST_VARS['order']))
{
$sort_order = ($HTTP_POST_VARS['order'] == 'ASC') ? 'ASC' : 'DESC';
}
else if(isset($HTTP_GET_VARS['order']))
{
$sort_order = ($HTTP_GET_VARS['order'] == 'ASC') ? 'ASC' : 'DESC';
}
else
{
$sort_order = 'ASC';
}

$mode_types_text = array($lang['lang_sort_username'], $lang['lang_sort_joindate'], $lang['lang_sort_useremail'],  $lang['lang_sort_homepage']);
$mode_types = array('username', 'user_regdate', 'user_email', 'user_website');

$select_sort_mode = '<select class="select" name="mode">';
for($i = 0; $i < count($mode_types_text); $i++)
{
$selected = ( $mode == $mode_types[$i] ) ? ' selected="selected"' : '';
$select_sort_mode .= '<option value="' . $mode_types[$i] . '"' . $selected . '>' . $mode_types_text[$i] . '</option>';
}
$select_sort_mode .= '</select>';

$select_sort_order = '<select class="select" name="order">';
if($sort_order == 'ASC')
{
$select_sort_order .= '<option value="ASC" selected="selected">' . $lang['lang_sort_asc'] . '</option><option value="DESC">' . $lang['lang_sort_desc'] . '</option>';
}
else
{
$select_sort_order .= '<option value="ASC">' . $lang['lang_sort_asc'] . '</option><option value="DESC" selected="selected">' . $lang['lang_sort_desc'] . '</option>';
}
$select_sort_order .= '</select>';

$site_template->register_vars(array(
'lang_select_sort_method' => $lang['lang_select_sort_method'],
'lang_select_sort_order' => $lang['lang_select_sort_order'],
'select_sort_method' => $select_sort_mode,
'select_sort_order_form' => $select_sort_order,
'mode_action' => $site_sess->url(ROOT_PATH."memberlist.php"))
);
$userlist = $site_template->parse_template(memberlist_sort);
if ( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
{
$mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];

switch( $mode )
{
case 'user_regdate':
$order_by = "user_regdate $sort_order";
break;
case 'username':
$order_by = "username $sort_order";
break;
case 'user_email':
$order_by = "user_email $sort_order";
break;
case 'user_website':
$order_by = "user_website $sort_order";
break;
default:
$order_by = "username $sort_order";
break;
}
}
else
{
$order_by = "username $sort_order";
}

$sql = "SELECT COUNT(*) AS total_user 
       FROM ".USERS_TABLE." 
       WHERE user_id NOT IN ('-1')";
//--------------------------------
//------ User Search -------------
//--------------------------------
$filter = "";
if ((isset($HTTP_GET_VARS['search']) && $HTTP_GET_VARS['search']) || (isset($HTTP_POST_VARS['search']) && $HTTP_POST_VARS['search']))
{
  $filter = $site_sess->get_session_var("memberlistfilter");
}
else
{
  $site_sess->drop_session_var("memberlistfilter");
}
if (isset($HTTP_GET_VARS['filter']) || isset($HTTP_POST_VARS['filter']))
{
   $filter = (isset($HTTP_POST_VARS['filter'])) ? $HTTP_POST_VARS['filter'] : $HTTP_GET_VARS['filter'];
}
if ($filter)
{
  $filter_db = str_replace("*", "%", str_replace("**", "*", $filter));
  if ($filter_db && $filter_db != "%")
  {
    $condition =  " AND ".get_user_table_field("", "user_name")." LIKE '".addslashes($filter_db)."'";
    $ltr = "";
    $user_search = "search=1";
    $site_sess->set_session_var("memberlistfilter", $filter);
  }
}
$site_template->register_vars(array(
    "filter" => $filter,
    "filter_url" => $site_sess->url(ROOT_PATH."memberlist.php"),
    "lang_filter" => $lang['search']
));
//--------------------------------
//------ End User Search ---------
//--------------------------------

$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {
   $user_cache[$row['user_id']]['total_user'] = $row['total_user'];
}
$site_db->free_result();

$num_rows_all = (isset($user_cache[$user_id]['total_user'])) ? $user_cache[$user_id]['total_user'] : 0;
$link_arg = $site_sess->url(ROOT_PATH."memberlist.php?mode=$mode&order=$sort_order");
include(ROOT_PATH.'includes/user_paging.php');
$getpaging = new Paging($page, $user_per_page, $num_rows_all, $link_arg);
$offset = $getpaging->get_offset();

$site_template->register_vars(array(
  "paging" => $getpaging->get_paging(),
  "paging_stats" => $getpaging->get_paging_stats()
));

$sql = "SELECT * 
       FROM ".USERS_TABLE." 
       WHERE user_id NOT IN ('-1') 
       ORDER BY $order_by 
       LIMIT $offset, $user_per_page";
$result = $site_db->query($sql);
  $userlist .="\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\n<tr>\n<td class=\"bordercolor\">\n";
  $userlist .="<table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"1\">\n";
  $userlist .="<tr>\n<td class=\"head2\" align=\"center\">".$lang['user_name']."</td>\n<td class=\"head2\" align=\"center\">".$lang['join_date']."</td>\n<td class=\"head2\" align=\"center\">".$lang['email']."</td>\n<td class=\"head2\" align=\"center\">".$lang['homepage']."</td>\n<td class=\"head2\" align=\"center\">".$lang['lang_total_user_images']."</td>\n</tr>\n";
  $count = 0;
  $bgcolor = 0;
  while ($user_row = $site_db->fetch_array($result)){
  $username = "";
  $user_regdate = "";
  $user_email = "";
  $user_email_save = "";
  $user_mailform_link = "";
  $user_email_button = "";
  $total_user_images = "";
    $user_profile_link = (!empty($url_show_profile)) ? preg_replace("/{user_id}/", $user_row['user_id'], $url_show_profile) : ROOT_PATH."member.php?action=showprofile&amp;".URL_USER_ID."=".$user_row['user_id'];
    $username = "<a href=\"".$site_sess->url($user_profile_link)."\">".htmlspecialchars($user_row['username'])."</a>";
    $user_website = (isset($user_row['user_website'])) ? format_url($user_row['user_website']) : REPLACE_EMPTY;
    if (!empty($user_website) && $user_website != REPLACE_EMPTY) {
      $user_website_button = "<a href=\"".$user_website."\" target=\"_blank\"><img src=\"".get_gallery_image("homepage.gif")."\" border=\"0\" alt=\"".$user_website."\" /></a>";
    }
    else {
      $user_website_button = REPLACE_EMPTY;
    }
    if (!empty($user_row['user_email']) && (!isset($user_row['user_viewemail']) || (isset($user_row['user_viewemail']) && $user_row['user_viewemail'] == '1'))) {
      $user_email = $user_row['user_email'];
      $user_email_save = str_replace("@", " at ", $user_row['user_email']);
      if (!empty($url_mailform)) {
        $user_mailform_link = $site_sess->url(preg_replace("/{user_id}/", $user_row['user_id'], $url_mailform));
      }
      else {
        $user_mailform_link = $site_sess->url(ROOT_PATH."member.php?action=mailform&amp;".URL_USER_ID."=".$user_row['user_id']);
      }
      $user_email_button = "<a href=\"".$user_mailform_link."\"><img src=\"".get_gallery_image("email.gif")."\" border=\"0\" alt=\"".$user_email_save."\" /></a>";
    }
    $user_regdate = (isset($user_row['user_regdate'])) ? format_date($config['date_format'], $user_row['user_regdate']) : REPLACE_EMPTY;
      $sql = "SELECT COUNT(*) AS total_user_images  
              FROM ".USERS_TABLE." u, ".IMAGES_TABLE." i 
              WHERE u.user_id = i.user_id 
              AND i.user_id=".$user_row['user_id']."";
      $row = $site_db->query_firstrow($sql);
      $total_user_images = $row['total_user_images'];


    if ($count == 0) {
      $row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;
      $userlist .= "<tr class=\"imagerow".$row_bg_number."\">\n";
    }
    $userlist .= "<td valign=\"top\" align=\"center\">".$username."</td>\n";
    $userlist .= "<td valign=\"top\" align=\"center\">".$user_regdate."</td>\n";
    $userlist .= "<td valign=\"top\" align=\"center\">".$user_email_button."</td>\n";
    $userlist .= "<td valign=\"top\" align=\"center\">".$user_website_button."</td>";
    $userlist .= "<td valign=\"top\" align=\"center\">".$total_user_images."</td>";
    $userlist .= "\n</tr>\n";
  }
  $userlist .= "</table>\n";
  $userlist .= "</td>\n</tr>\n</table>\n";
$site_template->register_vars("userlist", $userlist);
unset($userlist);
//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator'];
$clickstream .= $lang['lang_userlist_title'];
$clickstream .= $config['category_separator'].$lang['lang_userlist_page'].$page."</span>";
//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
  "msg" => $msg,
  "clickstream" => $clickstream,
  "lang_userlist_title" => $lang['lang_userlist_title']
));
$site_template->print_template($site_template->parse_template($main_template));
include(ROOT_PATH.'includes/page_footer.php');
?>

[V@no]

Are you using some sort of integration? Or maybe you used to use one? have you tryed to change the sorting, like sort by date, etc?

P.S. just replace username with user_name

[Fragezeichen]

..just use copy`n paste 
what ever,after tra-la-laing 10 hours and following some mods im very pisst off but happy to be finish
problem was defently by memberlist,cause using 4image 1.7.1 there change some words,much more as only username.
sorry to say.
donty worry,seach is now bloody working,yipeah

damed errors allready contained,possible someone could check?
http://beepnclub.fo.funpic.de/4images/memberlist.php?sessionid=11f0abe195697049b2ef72d5ae3d07c8

[TheOracle]

what ever,after tra-la-laing 10 hours and following some mods im very pisst of but happy to be finish

I didn't had to take 10 hours actually. A little tip: Make the replacements with a batch process from a software like : Advanced Find & Replace software. Your 10 hours will only become a matter of seconds in the end (for the exact same results).

[insane]

http://p4ddy-online.de.vu/4images/
acc: test pw: test

i think there where the "»" is shown (upper left), there should be the link to the memberlist.php - but it isn't
how can i fix this?

[insane]

Die Main.php müsste korrekt sein.
Ich weiß ehrlich gesagt nicht wie ich den Code in die user_logininfo richtig einbringen soll, im moment sieht sie so aus:

Code: [Select]

<table width="100%" border="0" cellpadding="4" cellspacing="0">
  <tr>
    <td valign="top" align="left">
  {lang_loggedin_msg}<br /><br />
      &raquo; <a href="{url_lightbox}">{lang_lightbox}</a><br />
  &raquo; <a href="{url_control_panel}">{lang_control_panel}</a><br />
      &raquo; <a href="{url_logout}">{lang_logout}</a><br />
      &raquo; <a href="{url_userlist}">{lang_userlist_title}</a>
&raquo; <a href="{url_sitemap}">{lang_sitemap}</a></td>
  </tr>
</table>
Der Aufruf über den Link direkt zur memberlist.php funktioniert auch einwandfrei

[insane]

Oh ok die Änderung is irgendwie flöten gegangen, hätte ich auch vorher ma nachschauen können
Danke dir!