Hilfe bei MySQL

Probleme bei der regulären Arbeiten mit phpBB, Fragen zu Vorgehensweisen oder Funktionsweise sowie sonstige Fragen zu phpBB im Allgemeinen.
Forumsregeln
phpBB 2.0 hat das Ende seiner Lebenszeit überschritten
phpBB 2.0 wird nicht mehr aktiv unterstützt. Insbesondere werden - auch bei Sicherheitslücken - keine Patches mehr bereitgestellt. Der Einsatz von phpBB 2.0 erfolgt daher auf eigene Gefahr. Wir empfehlen einen Umstieg auf phpBB 3.1, welches aktiv weiterentwickelt wird und für welches regelmäßig Updates zur Verfügung gestellt werden.
Antworten
Florian_Mueller

Hilfe bei MySQL

Beitrag von Florian_Mueller »

########################################################
## Mod Title: Last Visit Mod
## Mod Version: 1.2.4
## Author: Niels Chr. Rød Denmark < ncr@db9.dk > http://mods.db9.dk
##
## This mod is for phpBB2 ver 2.0.2
##
## Description: This mod will enable logning of the users last visit time,
## after this mod, users can see when another user have last visited
## the board, this is shown in the correspondings users profile.
## This mod support, user level and hidden users
## Admin will always be able to see other users last visit, regardless of the settings
## if board config is "off", then only admin can see the information
## if board is "on", then all users kan se other users last visit
## except hidden users, who will still be "hidden"
## This mod, will also display the number of reg/hidden and guest users today on the index page
##
##
##
## Installation Level: Easy
## Installation Time: 10-15 Minutes
## Files To Edit: 6
## language/subsilver/lang_main.php
## includes/usercp_viewprofile.php
## includes/sessions.php
## index.php
## templates/subsilver/index_body.tpl
## templates/subsilver/profile_view_body.tpl
## Include files: 1
## db_update.php
##
## History:
## 0.9.0. - initial BETA for RC-2
## 1.0.0. - initial release for RC-2
## 1.0.10. - History started, change in how timezones are handled
## 1.0.11. - corrected a typo in how timezones are handled
## 1.0.12. - corection to follow phpBB2 coding guidelines
## 1.0.13. - Now includes the number of users witch have visited the board the last hour
## 1.0.14. - fixed that the language part was missing from the last hour addition
## 1.0.15. - added extra feature, that how meny guest visited the board today are also countet
## 1.0.16. - missed something in the page_header.php file
## 1.0.17. - moved some changes from page_header.php over to index.php, for incresed performance
## 1.0.18. - fixed session.php that guest users are reset from the "today list"
## 1.0.19. - guest was still beeing reset, new change to session.php $dato
## 1.2.0. - BETA for phpBB2 version 2.0.2.
## 1.2.1. - typo, missed a comma in session.php
## 1.2.2. - fixed that guest users was not counted rigth if mixed timezones
## 1.2.3. - removed som added code in session.php
## 1.2.4. - add, posibilty to log guest users time
##
##############################################################
## This MOD is released under the GPL License.
## Intellectual Property is retained by the MOD Author(s) listed above
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/
##############################################################
## Authors Notes:
##
## Instead of runing the SQL commands your self, I have also included a db_update.php file
## if you are loged in as ADMIN, you can run this file, witch will do the neasessary changes to the DB
## the file will by it self put prefix on your tables, else
## if you are using a prefix to you DB tabels then you have to add this to
## the [ADD SQL] commands, e.g. "phpbb_users" instead of just "users" - ONLY
## in the initial [ADD SQL] commands, not in the php code !
##
##
## The most important thing to keep in mind is, take your time, make
## sure you are finding the correct lines to modify, then take care to paste the new code.
## Please also keep in mind, if you are using more than one language file or theme at your
## site, you will need to edit the corrosponding files for each occurrence. Good Luck!
#################################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
## and the Database
#################################################################


#
#-----[ ADD SQL ]------------------------------------------
#
SQL-query:
ALTER TABLE users ADD user_lastlogon INT (11) DEFAULT '0'

#
#-----[ ADD SQL ]------------------------------------------
#
SQL-query:
UPDATE users SET user_lastlogon=user_lastvisit

#
#-----[ ADD SQL ]------------------------------------------
#
SQL-query:
INSERT INTO config (config_name, config_value) VALUES ('hidde_last_logon', '0')
Wie mache ich das ??? HILFEEEE?!?!!?!

Ich schaff das net....
Benutzeravatar
itst
Ehrenadmin
Beiträge: 7418
Registriert: 21.08.2001 02:00
Wohnort: Büttelborn bei Darmstadt
Kontaktdaten:

Beitrag von itst »

Instead of runing the SQL commands your self, I have also included a db_update.php file if you are loged in as ADMIN, you can run this file, witch will do the neasessary changes to the DB.

Auf deutsch: logg Dich als Admin ein und gib folgende URL in die Adresszeile Deines Browsers ein: http://www.domain.de/pfad/zu/phpBB/db_update.php

Danach die db_update.php löschen!
Sascha A. Carlin,
phpBB.de Ehrenadministrator
:o
Florian_Mueller

Beitrag von Florian_Mueller »

jetzt hab ich PArt eins und zwei installiert und wenn ich mich anmelden will, per Login kommt

Code: Alles auswählen

phpBB : Kritischer Fehler 

Error updating last visit time 
Florian_Mueller

Beitrag von Florian_Mueller »

Code: Alles auswählen

phpBB : Kritischer Fehler 

Error updating last visit time

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' user_lastlogon = 1039453768 WHERE user_id = 2' at line 2

UPDATE phpbb_users SET user_session_time = 1039453768, user_session_page = 0, user_lastvisit = 1039453754, , user_lastlogon = 1039453768 WHERE user_id = 2

Line : 165
File : /home/www/wev155/html/Forum/includes/sessions.php
Benutzeravatar
saerdnaer
Ehemaliges Teammitglied
Beiträge: 4268
Registriert: 21.04.2001 02:00

Beitrag von saerdnaer »

zeile 160 - 170 deiner includes/sessions.php bitte...

ah
Florian_Mueller

Beitrag von Florian_Mueller »

ist schon okay, hat sich alles zum positiven gewendet :)
Antworten

Zurück zu „phpBB 2.0: Administration, Benutzung und Betrieb“