phpBB-support, snack och diskussioner på svenska
https://phpbb.se/forum/
http://www.phpbbhacks.com/download/2121This hack adds a new column to the "users" table in the phpBB database which contains the real names of the users.
This information is then used instead of the username wherever possible. For example, you will see "Log out [ Real Name ]" rather than "Log out [ Username ]".
The real name of user is required when they create an account and this can later be changed from the profile page if allowed by the administrator.
This hack allows administrators to define their own profile fields. There are four types of fields supported: text, text area, select box, and radio button set. All of these types support HTML, BBCode and smilies.
You can control exactly which users can use a field with a permission system similar to phpBB's forum permission system. You can control access by groups or by users and you can set a default behavior for users without any special permissions.
The hack also allows you to assign profile fields to custom template variables, meaning you can customize the way the fields show up with no knowledge of PHP. You can also use this to override default fields. (Multi-line BBCode enabled custom ranks for moderators, anyone?) You can even use this feature to let users specify a custom text color, although it requires a small modification to one template file.
Kod: Markera allt
#
#-----[ SQL ]-------------------------------------------------
#
CREATE TABLE `phpbb_xdata_fields` (
field_id smallint(5) UNSIGNED NOT NULL,
field_name varchar(255) NOT NULL default '',
field_desc text NOT NULL default '',
field_type varchar(255) NOT NULL default '',
field_order smallint(5) UNSIGNED NOT NULL default '0',
code_name varchar(255) NOT NULL default '',
field_length mediumint(8) UNSIGNED NOT NULL default '0',
field_values text NOT NULL default '',
field_regexp text NOT NULL default '',
default_auth tinyint(1) NOT NULL default '1',
display_register tinyint(1) NOT NULL default '1',
display_viewprofile tinyint(1) NOT NULL default '0',
display_posting tinyint(1) NOT NULL default '0',
handle_input tinyint(1) NOT NULL default '0',
allow_html tinyint(1) NOT NULL default '0',
allow_bbcode tinyint(1) NOT NULL default '0',
allow_smilies tinyint(1) NOT NULL default '0',
PRIMARY KEY (field_id),
UNIQUE KEY code_name (code_name)
);
CREATE TABLE `phpbb_xdata_data` (
field_id smallint(5) UNSIGNED NOT NULL,
user_id mediumint(8) UNSIGNED NOT NULL,
xdata_value text NOT NULL
);
CREATE TABLE `phpbb_xdata_auth` (
field_id smallint(5) UNSIGNED NOT NULL,
group_id mediumint(8) UNSIGNED NOT NULL,
auth_value tinyint(1) NOT NULL
);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(1, 'ICQ Number', 'special', '1', 'icq', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(2, 'AIM Address', 'special', '2', 'aim', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(3, 'MSN Messenger', 'special', '3', 'msn', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(4, 'Yahoo Messenger', 'special', '4', 'yim', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(5, 'Website', 'special', '5', 'website', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(6, 'Location', 'special', '6', 'location', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(7, 'Occupation', 'special', '7', 'occupation', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(8, 'Interests', 'special', '8', 'interests', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(9, 'Signature', 'special', '9', 'signature', 2);
Kod: Markera allt
ALTER TABLE phpbb_users ADD user_info VARCHAR(255) AFTER user_interests;
Kod: Markera allt
ALTER TABLE phpbb_users ADD user_info VARCHAR(255) AFTER user_interests;
Kod: Markera allt
ALTER TABLE phpbb_users ADD user_modell VARCHAR(255) AFTER user_interests;