phpBB.de

Code: Alles auswählen

# ----- QUERY DATABASE ----------------------------------------
# // Change the table-prefix 'phpbb_' if your tables haves another one!!!
#
CREATE TABLE phpbb_profile_view(
user_id mediumint( 8 ) NOT NULL ,
viewername varchar( 25 ) NOT NULL ,
viewer_id mediumint( 8 ) NOT NULL ,
view_stamp int( 11 ) NOT NULL, 
counter mediumint( 8 ) NOT NULL
) TYPE = MYISAM

#
# ----- QUERY DATABASE FOR POPUP ----------------------------------------
# // Change the table-prefix 'phpbb_' if your tables haves another one!!!
#
ALTER TABLE phpbb_users ADD `user_profile_view` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL ;
ALTER TABLE phpbb_users ADD `user_last_profile_view` INT( 11 ) DEFAULT '0' NOT NULL ;

#
# ----- OR ALTER TABLE IF YOU UPDATE FROM 1.0.0 ----------------------------------------
# // You must clear up the table manually, if you want to update otherwise you will maybe risk errors
#
ALTER TABLE phpbb_profile_view ADD counter MEDIUMINT( 8 ) NOT NULL ;

#

Code: Alles auswählen

#
# ----- QUERY DATABASE ----------------------------------------
# // Change the table-prefix 'phpbb_' if your tables haves another one!!!
#
CREATE TABLE phpbb_profile_view(
user_id mediumint( 8 ) NOT NULL ,
viewername varchar( 25 ) NOT NULL ,
viewer_id mediumint( 8 ) NOT NULL ,
view_stamp int( 11 ) NOT NULL, 
counter mediumint( 8 ) NOT NULL
) TYPE = MYISAM

#
# ----- QUERY DATABASE FOR POPUP ----------------------------------------
# // Change the table-prefix 'phpbb_' if your tables haves another one!!!
#
ALTER TABLE phpbb_users ADD `user_profile_view` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL ;
ALTER TABLE phpbb_users ADD `user_last_profile_view` INT( 11 ) DEFAULT '0' NOT NULL ;

#
# ----- OR ALTER TABLE IF YOU UPDATE FROM 1.0.0 ----------------------------------------
# // You must clear up the table manually, if you want to update otherwise you will maybe risk errors
#
ALTER TABLE phpbb_profile_view ADD counter MEDIUMINT( 8 ) NOT NULL ;code]

also, ich hab das PHPMyAdmin und kenn mich da eigendlich überhaupt nicht aus.. nach dem ich jetzt da zum dritten mal reinschau und davor noch nie benutz habe. 
Also,... was und wie muss ich des jetzt machen??? kann mir einer eine schritt für schritt anleitung geben!?!?