datumformaat weergeven bij bijv. user_lastvisit

[zoomer]

Support template:

• Wat is het probleem? Weergave datum in totaaloverzicht phpbb_users via phpMyAdmin
  Wanneer ontstond het probleem? 06-01-2006
  Adres van je forum: http://forum.fiatpandaclub.nl
  Geïnstalleerde mods: nvt
  Huidige template: nvt
  phpBB versie: 2.0.18
  Host: nvt
  Heb je onlangs een mod of stijl geïnstalleerd? nvt
  Heb je gezocht naar een antwoord? ja

Overige opmerkingen:

Wanneer ik via phpMyAdmin alle gegevens selecteer uit de tabel phpbb_users (select * FROM `phpbb_users`) krijg ik een overzicht van alle users. Nu ben ik vooral geinterresseerd in de datums. Echter deze worden weergegeven als bijv: 1136580429. Daar kan ik niets mee. Nu kan je dit omzetten naar een gewoon datumformaat maar ik krijg het niet voor elkaar. Wat dien ik in de SQL op te nemen om de datum/tijd-attributen duidelijk-leesbaar weer te geven?

Is er ook een php-file beschikbaar die alle gegevens genereert/ laat zien op een soortgelijke wijze als de gebruikerslijst via het forum?

Bij voorbaat dank voor de reactie(s).

Met vriendelijke groet,

Zoomer

[The Sting]

Support template:

• Wat is het probleem? Weergave datum in totaaloverzicht phpbb_users via phpMyAdmin
  Wanneer ontstond het probleem? 06-01-2006
  Adres van je forum: http://forum.fiatpandaclub.nl
  Geïnstalleerde mods: nvt
  Huidige template: nvt
  phpBB versie: 2.0.18
  Host: nvt
  Heb je onlangs een mod of stijl geïnstalleerd? nvt
  Heb je gezocht naar een antwoord? ja

Overige opmerkingen:

Wanneer ik via phpMyAdmin alle gegevens selecteer uit de tabel phpbb_users (select * FROM `phpbb_users`) krijg ik een overzicht van alle users. Nu ben ik vooral geinterresseerd in de datums. Echter deze worden weergegeven als bijv: 1136580429. Daar kan ik niets mee. Nu kan je dit omzetten naar een gewoon datumformaat maar ik krijg het niet voor elkaar. Wat dien ik in de SQL op te nemen om de datum/tijd-attributen duidelijk-leesbaar weer te geven?

Is er ook een php-file beschikbaar die alle gegevens genereert/ laat zien op een soortgelijke wijze als de gebruikerslijst via het forum?

Bij voorbaat dank voor de reactie(s).

Met vriendelijke groet,

Zoomer

Wat is je uiteindelijk doel?, maar misschien is de mod Last Visit iets voor je.

[zoomer]

Overzicht en actueel houden van ledenbestand.

[The Sting]

Overzicht en actueel houden van ledenbestand.

Zelf doe ik dat met auto delete, leden die een X dagen niet inloggen worden verwijdert. En met Last Visit kijk ik het weleens na. Maar ja dat moet per user, dus omslachtig.

Code: Selecteer alles

Hack Title:   Auto Delete Users
##   Hack Version: 1.10
##   Author:       Nivisec (support@nivisec.com)
##                 http://www.nivisec.com
##   Description:  This hack will search for
##                 users who are in-active,
##                 have 0 posts, and/or
##                 do not visit very much, and
##                 delete them.  The Admin can
##                 define the number of days
##                 before deletion happens and
##                 disable/enable each type.

[zoomer]

Bedankt.

Ik heb hier nog een handige zoek-mod gevonden:

http://www.phpbb.com/phpBB/catdb.php?mo ... id=1323619

:thumb:

[The Sting]

Bedankt.

Ik heb hier nog een handige zoek-mod gevonden:

http://www.phpbb.com/phpBB/catdb.php?mo ... id=1323619

:thumb:

:thumb: :thumb: :thumb:

[The Sting]

Bedankt.

Ik heb hier nog een handige zoek-mod gevonden:

http://www.phpbb.com/phpBB/catdb.php?mo ... id=1323619

:thumb:

Als je hem vertaalt hebt , graag.

[The Sting]

Hallo All,

Iemand een vertaling, er zitten een hoop termen in die ik forum technisch niet kan vertalen.

Code: Selecteer alles

<?php

/***************************************************************************
 *                            lang_user_search.php (English)
 *                              -------------------
 *     begin                : Sat Apr 10, 2004
 *     copyright            : (C) 2004 Adam Alkins
 *     email                : phpbb at rasadam dot com
 *	   $Id: lang_user_search.php,v 1.10 2004/12/31 05:26:54 rasadam Exp $
 *    
 *
 ****************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

$lang['Search_invalid_username'] = 'Invalid username entered to Search';
$lang['Search_invalid_email'] = 'Invalid email address entered to Search';
$lang['Search_invalid_ip'] = 'Invalid IP address entered to Search';
$lang['Search_invalid_group'] = 'Invalid Group entered to Search';
$lang['Search_invalid_date'] = 'Invalid Date entered to Search';
$lang['Search_invalid_postcount'] = 'Invalid Post Count entered to Search';
$lang['Search_invalid_userfield'] = 'Invalid Userfield data entered';
$lang['Search_invalid_lastvisited'] = 'Invalid data entered for Last Visited search';
$lang['Search_invalid_language'] = 'Invalid Language Selected';
$lang['Search_invalid_style'] = 'Invalid Style Selected';
$lang['Search_invalid_timezone'] = 'Invalid Timezone Selected';
$lang['Search_invalid_moderators'] = 'Invalid Forum Selected';
$lang['Search_invalid'] = 'Invalid Search';
$lang['Search_invalid_day'] = 'The day you entered was invalid';
$lang['Search_invalid_month'] = 'The day you entered was invalid';
$lang['Search_invalid_year'] = 'The day you entered was invalid';
$lang['Search_no_regexp'] = 'Your database does not support Regular Expression searching.';
$lang['Search_for_username'] = 'Searching usernames matching %s';
$lang['Search_for_email'] = 'Searching email addresses matching %s';
$lang['Search_for_ip'] = 'Searching IP addresses matching %s';
$lang['Search_for_date'] = 'Searching users who joined %s %d/%d/%d';
$lang['Search_for_group'] = 'Searching group members of %s';
$lang['Search_for_banned'] = 'Searching banned users';
$lang['Search_for_admins'] = 'Searching Administrators';
$lang['Search_for_mods'] = 'Searching Moderators';
$lang['Search_for_disabled'] = 'Searching for disabled users';
$lang['Search_for_disabled_pms'] = 'Searching for users with disabled Private Messages';
$lang['Search_for_postcount_greater'] = 'Searching for users with a post count greater than %d';
$lang['Search_for_postcount_lesser'] = 'Searching for users with a post count less than %d';
$lang['Search_for_postcount_range'] = 'Searching for users with a post count between %d and %d';
$lang['Search_for_postcount_equals'] = 'Searching for users with a post count value of %d';
$lang['Search_for_userfield_icq'] = 'Searching for users with a ICQ address matching %s';
$lang['Search_for_userfield_yahoo'] = 'Searching for users with a Yahoo IM address matching %s';
$lang['Search_for_userfield_aim'] = 'Searching for users with an AIM address matching %s';
$lang['Search_for_userfield_msn'] = 'Searching for users with a MSN Messenger address matching %s';
$lang['Search_for_userfield_website'] = 'Searching for users with an Website matching %s';
$lang['Search_for_userfield_location'] = 'Searching for users with a Location matching %s';
$lang['Search_for_userfield_interests'] = 'Searching for users with their Interests field matching %s';
$lang['Search_for_userfield_occupation'] = 'Searching for users with their Occupation field matching %s';
$lang['Search_for_lastvisited_inthelast'] = 'Searching for users who have visited in the last %s %s';
$lang['Search_for_lastvisited_afterthelast'] = 'Searching for users who have visited after the last %s %s';
$lang['Search_for_language'] = 'Searching for users who have set %s as their language';
$lang['Search_for_timezone'] = 'Searching for users who have set GMT %s as their timezone';
$lang['Search_for_style'] = 'Searching for users who have set %s as their style';
$lang['Search_for_moderators'] = 'Search for moderators of the Forum -> %s';
$lang['Search_users_advanced'] = 'Advanced User Search';
$lang['Search_users_explain'] = 'This Module allows you to perform advanced searches for users on a wide range of criteria. Please read the descriptions under each field to understand each search option completely.';
$lang['Search_username_explain'] = 'Here you can perform a case insensitive search for usernames. If you would like to match part of the username, use * (an asterix) as a wildcard. Checking the Regular Expressions box will allow you to search based on your regex pattern. <strong>Note:</strong> Regular Expressions will only work in MySQL, PostgreSQL and Oracle 10g+.';
$lang['Search_email_explain'] = 'Enter an expression to match a user\'s email address. This is case insensitive. If you want to do a partial match, use * (an asterix) as a wildcard. Checking the Regular Expressions box will allow you to search based on your regex pattern. <strong>Note:</strong> Regular Expressions will only work in MySQL, PostgreSQL and Oracle 10g+.';
$lang['Search_ip_explain'] = 'Search for users who made posts made by a specific ip address (xxx.xxx.xxx.xxx), wildcard (xxx.xxx.xxx.*) or range (xxx.xxx.xxx.xxx-yyy.yyy.yyy.yyy). Note: the last quad .255 is considered the range of all the IPs in that quad. If you enter 10.0.0.255, it is just like entering 10.0.0.* (No IP is assigned .255 for that matter, it is reserved). Where you may encounter this is in ranges, 10.0.0.5-10.0.0.255 is the same as "10.0.0.*" . You should really enter 10.0.0.5-10.0.0.254 .';
$lang['Search_users_joined'] = 'Users that joined';
$lang['Search_users_lastvisited'] = 'Users whom have visited';
$lang['in_the_last'] = 'in the last';
$lang['after_the_last'] = 'after the last';
$lang['Before'] = 'Before';
$lang['After'] = 'After';
$lang['Search_users_joined_explain'] = 'Search for users the join Before or After (and on) a specific date. The date format is YYYY/MM/DD.';
$lang['Search_users_groups_explain'] = 'View all members of the selected group.';
$lang['Administrators'] = 'Administrators';
$lang['Banned_users'] = 'Banned Users';
$lang['Disabled_users'] = 'Disabled Users';
$lang['Users_disabled_pms'] = 'Users with disabled PMs';
$lang['Search_users_misc_explain'] = 'Administrators - All users with Administrator powers; Moderators - All forum moderators; Banned Users - All accounts that have been banned on these forums; Disabled Users - All users with disabled accounts (either manually disabled or never verified their email address); Users with disabled PMs - Selects users who have the Private Messages priviliges removed (Done via User Management)';
$lang['Postcount'] = 'Postcount';
$lang['Equals'] = 'Equals';
$lang['Greater_than'] = 'Greater than';
$lang['Less_than'] = 'Less than';
$lang['Search_users_postcount_explain'] = 'You can search for users based on the Postcount value. You can either search by a specific value, greater than or lesser than a value or between two values. To do the range search, select "Equals" then put the beginning and ending values of the range separated by a dash (-), e.g. 10-15';
$lang['Userfield'] = 'Userfield';
$lang['Search_users_userfield_explain'] = 'Search for users based on various profile fields. Wildcards are supported using an asterix (*). Checking the Regular Expressions box will allow you to search based on your regex pattern. <strong>Note:</strong> Regular Expressions will only work in MySQL, PostgreSQL and Oracle 10g+.';
$lang['Search_users_lastvisited_explain'] = 'You can search for users based on their last login date using this search option';
$lang['Search_users_language_explain'] = 'This will display users whom have selected a specific language in their Profile';
$lang['Search_users_timezone_explain'] = 'Users who have selected a specific timezone in their profile';
$lang['Search_users_style_explain'] = 'Display users who have selected a specific style.';
$lang['Moderators_of'] = 'Moderators of';
$lang['Search_users_moderators_explain'] = 'Search for users with Moderating permissions to a specific forum. Moderating permissions are recoginised either by User Permissions or by being in a Group with the right Group Permssions.';
$lang['Regular_expression'] = 'Regular Expression?';

$lang['Manage'] = 'Manage';
$lang['Search_users_new'] = '%s yielded %d result(s). Perform <a href="%s">another search</a>.';
$lang['Banned'] = 'Banned';
$lang['Not_banned'] = 'Not Banned';
$lang['Search_no_results'] = 'No users match your selected criteria. Please try another search. If you\'re searching the username or email address fields, for partial matches you must use the wildcard * (an asterix).';
$lang['Account_status'] = 'Account Status';
$lang['Sort_options'] = 'Sort options:';
$lang['Last_visit'] = 'Last Visit';
$lang['Day'] = 'Day';

?>