phpBB.de

Code: Alles auswählen

Unread Post Information to Database Mod

Code: Alles auswählen

1a.) 
*
*	Führe zuerst in der MySQL Datenbank folgendes aus:
*	
*	Beachte das "phpbb_" anzupassen, falls nötig!
*
*
*	CREATE TABLE phpbb_topic_read (
*	  topic_id mediumint(8) unsigned NOT NULL default '0',
*	  user_id mediumint(8) NOT NULL default '0',
*	  post_id mediumint(8) NOT NULL default '0',
*	  visit_time int(11) NOT NULL default '0',
*	  forum_id int(8) unsigned NOT NULL default '0',
*	  KEY topic_id (topic_id)
*	) TYPE=MyISAM;
*
*
*
*	1b.)
*
*	In die Tabelle mußt du jetzt noch eine 0 Zeile 
*	einfügen, diese löscht sich später wieder automatisch.
*
*	INSERT INTO phpbb_topic_read (topic_id, user_id, post_id, visit_time, forum_id) VALUES (0, 0, 0, 0, 0);

Code: Alles auswählen

Could not get Topic Read from 2 134.

DEBUG MODE

SQL Error : 1146 Table 'usr_web980_1.phpbb_topic_read' doesn't exist

SELECT visit_time, topic_id, user_id, post_id FROM phpbb_topic_read WHERE user_id = 2 AND topic_id = 134

Line : 466
File : /var/www/web980/html/phpBB2/viewforum.php 
  

Code: Alles auswählen

CREATE TABLE phpbb_topic_read (
	  topic_id mediumint(8) unsigned NOT NULL default '0',
	  user_id mediumint(8) NOT NULL default '0',
	  post_id mediumint(8) NOT NULL default '0',
	  visit_time int(11) NOT NULL default '0',
	  forum_id int(8) unsigned NOT NULL default '0',
	  KEY topic_id (topic_id)
	) TYPE=MyISAM;

Code: Alles auswählen

INSERT INTO phpbb_topic_read (topic_id, user_id, post_id, visit_time, forum_id) VALUES (0, 0, 0, 0, 0);