4images Forum & Community
Welcome, Guest. Please login or register.
Did you miss your activation email?
May 25, 2018, 06:42:04 PM

Login with username, password and session length
Search:     Advanced search
Togle to toolbar
Translate this page with =>
Translate this page >
* Home Help Search Login Register
 
+  4images Forum & Community
|-+  4images Modifications / Modifikationen
| |-+  Mods & Plugins (Releases & Support) (Moderators: mawenzi, Rembrandt)
| | |-+  [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: «« « 1 ... 16 17 18 19 [20] 21 22 23 24 ... 34 » »» Print
Current Topic Rating: *****
Author Topic: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x  (Read 480659 times)
anderitor
Newbie
*
Offline Offline

Posts: 18

Thank You
-Given: 0
-Receive: 0


View Profile
« Reply #285 on: January 26, 2006, 03:27:51 PM »

Hallo Leute,

helft mir bitte. Ist wirklich dringend.

Danke

english:

Help me, please. It´s very important.
Logged
TheOracle
Hero Member
*****
Offline Offline

Posts: 875

Thank You
-Given: 0
-Receive: 3


View Profile
« Reply #286 on: January 26, 2006, 03:34:03 PM »

If the field is already existent, it shouldn't be that big of a deal actually. Does it cause you problems when using the memberlist MOD during the actions from memberlist.php file ?
Logged
anderitor
Newbie
*
Offline Offline

Posts: 18

Thank You
-Given: 0
-Receive: 0


View Profile
« Reply #287 on: January 26, 2006, 09:47:40 PM »

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
Logged
TheOracle
Hero Member
*****
Offline Offline

Posts: 875

Thank You
-Given: 0
-Receive: 3


View Profile
« Reply #288 on: January 26, 2006, 10:21:20 PM »

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. Wink
Logged
ivan
4images Moderator
4images Guru
*****
Offline Offline

Posts: 2279

Thank You
-Given: 4
-Receive: 31


View Profile WWW
« Reply #289 on: January 26, 2006, 10:38:56 PM »

Hallo Leute,

helft mir bitte. Ist wirklich dringend.

Danke

english:

Help me, please. It´s very important.

hallo, siehe hier

http://www.4homepages.de/forum/index.php?topic=10184.15
Logged

greetings / grüsse
ivan

Facebook Fan Page | Follow Twitter

Blog: Reisen Blog
Bilder Gallery: Bilder Gallery
V@no
If you don't tell me what to do, I won't tell you where you should go :)
Administrator
4images Guru
*****
Offline Offline

Posts: 17849

Thank You
-Given: 47
-Receive: 565

mmm PHP...


View Profile WWW
« Reply #290 on: January 27, 2006, 01:33:14 AM »

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. Wink
maybe you should just be quiet, if you want to stay here Rolling Eyes
Logged

Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)
TheOracle
Hero Member
*****
Offline Offline

Posts: 875

Thank You
-Given: 0
-Receive: 3


View Profile
« Reply #291 on: January 27, 2006, 01:39:49 AM »

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.
Logged
V@no
If you don't tell me what to do, I won't tell you where you should go :)
Administrator
4images Guru
*****
Offline Offline

Posts: 17849

Thank You
-Given: 47
-Receive: 565

mmm PHP...


View Profile WWW
« Reply #292 on: January 27, 2006, 01:48:08 AM »

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

Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)
Fragezeichen
Jr. Member
**
Offline Offline

Posts: 58

Thank You
-Given: 2
-Receive: 0


View Profile
« Reply #293 on: January 29, 2006, 04:15:59 PM »

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'
Logged
TheOracle
Hero Member
*****
Offline Offline

Posts: 875

Thank You
-Given: 0
-Receive: 3


View Profile
« Reply #294 on: January 29, 2006, 04:31:39 PM »

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 ?) ?
Logged
V@no
If you don't tell me what to do, I won't tell you where you should go :)
Administrator
4images Guru
*****
Offline Offline

Posts: 17849

Thank You
-Given: 47
-Receive: 565

mmm PHP...


View Profile WWW
« Reply #295 on: January 29, 2006, 05:26:30 PM »

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.
Logged

Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)
Fragezeichen
Jr. Member
**
Offline Offline

Posts: 58

Thank You
-Given: 2
-Receive: 0


View Profile
« Reply #296 on: January 30, 2006, 01:03:12 PM »

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?

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
<?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++ % == 0) ? 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');
?>
« Last Edit: January 30, 2006, 02:37:54 PM by V@no » Logged
V@no
If you don't tell me what to do, I won't tell you where you should go :)
Administrator
4images Guru
*****
Offline Offline

Posts: 17849

Thank You
-Given: 47
-Receive: 565

mmm PHP...


View Profile WWW
« Reply #297 on: January 30, 2006, 02:38:31 PM »

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
Logged

Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)
Fragezeichen
Jr. Member
**
Offline Offline

Posts: 58

Thank You
-Given: 2
-Receive: 0


View Profile
« Reply #298 on: January 30, 2006, 10:19:30 PM »

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

damed errors allready contained,possible someone could check?
http://fotzenclub.fo.funpic.de/4images/memberlist.php?sessionid=11f0abe195697049b2ef72d5ae3d07c8
Logged
TheOracle
Hero Member
*****
Offline Offline

Posts: 875

Thank You
-Given: 0
-Receive: 3


View Profile
« Reply #299 on: January 30, 2006, 10:24:15 PM »

Quote  [Expand]

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). Wink
Logged
Pages: «« « 1 ... 16 17 18 19 [20] 21 22 23 24 ... 34 » »» Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.066 seconds with 20 queries.
Post your comments here