Suche Referer-Mod für phpBB 3.0.12

Shababa · Beitrag von **Shababa** » 04.03.2014 04:33

Guten Morgen

Nun suche ich noch einen Referer-Mod, mit dem man überprüfen kann,
von welcher Website die Gäste und User zu unserem Forum gefunden haben.

Gibt es da was für phpBB 3.0.12?
Durch die Suchfunktion habe ich nur diesen Mod gefunden, der für phpBB 3.0.x wahrscheinlich nicht gedacht ist:
http://www.sportschulekang.de/forum/dow ... etail&id=7

Am besten wäre ein Mod, wo ich vom ACP aus Zugriff hätte so ähnlich wie beim "IP Tracker".

Beste Grüße

Pfiffy · Beitrag von **Pfiffy** » 04.03.2014 08:02

Ich verwende den expCounter. Der ist zwar außerhalb von phpBB3 (also keine MOD), führt aber so ziemlich jede Statistik, die man braucht (oder nicht braucht): http://www.expblog.net/expcounter/

Grücce
Pfiffy

Charlie_M · Beitrag von **Charlie_M** » 04.03.2014 08:13

IP Tracker für PHPBB 3.0.x:
http://allround-phpbb.de/viewtopic.php?f=44&t=866

Nun suche ich noch einen Referer-Mod

Das klappt (noch) bei div. Suchmaschinen, aber seit der Umstellung auf https von Google geht's da nicht mehr, der Referer ist da nicht mehr auslesbar.

John Doe · Beitrag von **John Doe** » 04.03.2014 09:48

https://www.phpbb.com/customise/db/mod/referrers/

Screenshot: http://s20.postimg.org/u629ubuv1/ref2.png

Shababa · Beitrag von **Shababa** » 04.03.2014 11:44

Danke für eure Antworten : )

Ich hab gerade mal versucht den Mod vom letzten Beitrag von John Doe zu installieren (https://www.phpbb.com/customise/db/mod/referrers/),
nur kommt bei der Installation folgende Fehlermeldung:

Code: Alles auswählen

Referrers - Gescheitert

Datenbanktyp :: mysql4
Warnung

Einer oder mehrere Fehler sind während der angeforderten Aktion aufgetreten. Bitte erstelle eine vollständige Kopie aller aufgetretenen Fehler und bitte den Autor der Modifikation um Unterstützung.
Warnung

Es wurden neue Berechtigungen hinzugefügt. Bitte prüfe die Berechtigungseinstellungen und passe sie nach deinen Wünschen an.

Füge acp-Modul hinzu: Referrers
FEHLER: Die übergeordnete Kategorie, die für dieses Modul angegeben wurde, existiert nicht.

Füge acp-Modul hinzu: Manage referrers
FEHLER: Die übergeordnete Kategorie, die für dieses Modul angegeben wurde, existiert nicht.

Füge acp-Modul hinzu: Prune referrers
FEHLER: Die übergeordnete Kategorie, die für dieses Modul angegeben wurde, existiert nicht.

Füge neue Berechtigungsoption hinzu: a_refview
Erfolgreich

Füge neue Berechtigungsoption hinzu: a_refdel
Erfolgreich

Setze Berechtigungen für die Standard-Administrator-Rolle.
Erfolgreich

Setze Berechtigungen für die Foren-Administrator-Rolle.
Erfolgreich

Setze Berechtigungen für die Umfassender Administrator-Rolle.
Erfolgreich

Eine neue Datenbanktabelle erstellen: phpbb3_referrers
Erfolgreich

Unbekannt
Erfolgreich

Leere Cache des Forums
Erfolgreich

Leere Berechtigungs-Cache
Erfolgreich

Leere Cache des Forums
Erfolgreich

Lege neue Konfigurationsvariable an: ref_version
Erfolgreich

Scheinbar wird bei der Installation die übergeordnete Kategorie nicht gefunden (wahrscheinlich ACP --> MODs), nur ist sie ja da....

Weiß jemand, was ich da los ist und was ich jetzt machen muss?

Gruß, Shababa

Beitrag von **BNa** » 05.03.2014 18:52

Pfiffy hat geschrieben:Ich verwende den expCounter.

Auch seit über 12 Jahren treuer Fan. Also > Vorgänger + exp*.
Zumal auch die phpbb3 Titel der angesteuerten Seiten angezeigt werden, uvm..
Siehst bei uns unten als Counter <div>..

Shababa · Beitrag von **Shababa** » 06.03.2014 03:29

Ich habs jetzt geschafft diesen Referrer-Mod (https://www.phpbb.com/customise/db/mod/referrers) bei phpBB 3.0.12 zu installieren!
Und zwar sollte bei euch nach dem Ausführen der db_update.php die von mir oben bezeichnete Fehlermeldung kommen, müsst ihr folgendes tun:

1. Geht bei euch bei PHPMyAdmin in eure Datenbank
2. Klickt oben neben Struktur und Suche auf SQL
3. Dort führt ihr folgenden SQL-Befehl aus:

Code: Alles auswählen

    TRUNCATE TABLE `phpbb3_modules`;
    REPLACE INTO `phpbb3_modules` VALUES(1, 1, 1, '', 'acp', 0, 1, 60, 'ACP_CAT_GENERAL', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(2, 1, 1, '', 'acp', 1, 4, 17, 'ACP_QUICK_ACCESS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(3, 1, 1, '', 'acp', 1, 18, 39, 'ACP_BOARD_CONFIGURATION', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(4, 1, 1, '', 'acp', 1, 40, 47, 'ACP_CLIENT_COMMUNICATION', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(5, 1, 1, '', 'acp', 1, 48, 59, 'ACP_SERVER_CONFIGURATION', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(6, 1, 1, '', 'acp', 0, 61, 78, 'ACP_CAT_FORUMS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(7, 1, 1, '', 'acp', 6, 62, 67, 'ACP_MANAGE_FORUMS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(8, 1, 1, '', 'acp', 6, 68, 77, 'ACP_FORUM_BASED_PERMISSIONS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(9, 1, 1, '', 'acp', 0, 79, 102, 'ACP_CAT_POSTING', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(10, 1, 1, '', 'acp', 9, 80, 91, 'ACP_MESSAGES', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(11, 1, 1, '', 'acp', 9, 92, 101, 'ACP_ATTACHMENTS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(12, 1, 1, '', 'acp', 0, 103, 156, 'ACP_CAT_USERGROUP', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(13, 1, 1, '', 'acp', 12, 104, 135, 'ACP_CAT_USERS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(14, 1, 1, '', 'acp', 12, 136, 143, 'ACP_GROUPS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(15, 1, 1, '', 'acp', 12, 144, 155, 'ACP_USER_SECURITY', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(16, 1, 1, '', 'acp', 0, 157, 204, 'ACP_CAT_PERMISSIONS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(17, 1, 1, '', 'acp', 16, 160, 169, 'ACP_GLOBAL_PERMISSIONS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(18, 1, 1, '', 'acp', 16, 170, 179, 'ACP_FORUM_BASED_PERMISSIONS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(19, 1, 1, '', 'acp', 16, 180, 189, 'ACP_PERMISSION_ROLES', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(20, 1, 1, '', 'acp', 16, 190, 203, 'ACP_PERMISSION_MASKS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(21, 1, 1, '', 'acp', 0, 205, 218, 'ACP_CAT_STYLES', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(22, 1, 1, '', 'acp', 21, 206, 209, 'ACP_STYLE_MANAGEMENT', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(23, 1, 1, '', 'acp', 21, 210, 217, 'ACP_STYLE_COMPONENTS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(24, 1, 1, '', 'acp', 0, 219, 238, 'ACP_CAT_MAINTENANCE', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(25, 1, 1, '', 'acp', 24, 220, 229, 'ACP_FORUM_LOGS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(26, 1, 1, '', 'acp', 24, 230, 237, 'ACP_CAT_DATABASE', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(27, 1, 1, '', 'acp', 0, 239, 264, 'ACP_CAT_SYSTEM', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(28, 1, 1, '', 'acp', 27, 240, 243, 'ACP_AUTOMATION', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(29, 1, 1, '', 'acp', 27, 244, 255, 'ACP_GENERAL_TASKS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(30, 1, 1, '', 'acp', 27, 256, 263, 'ACP_MODULE_MANAGEMENT', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(31, 1, 1, '', 'acp', 0, 265, 266, 'ACP_CAT_DOT_MODS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(32, 1, 1, 'attachments', 'acp', 3, 19, 20, 'ACP_ATTACHMENT_SETTINGS', 'attach', 'acl_a_attach');
        REPLACE INTO `phpbb3_modules` VALUES(33, 1, 1, 'attachments', 'acp', 11, 93, 94, 'ACP_ATTACHMENT_SETTINGS', 'attach', 'acl_a_attach');
        REPLACE INTO `phpbb3_modules` VALUES(34, 1, 1, 'attachments', 'acp', 11, 95, 96, 'ACP_MANAGE_EXTENSIONS', 'extensions', 'acl_a_attach');
        REPLACE INTO `phpbb3_modules` VALUES(35, 1, 1, 'attachments', 'acp', 11, 97, 98, 'ACP_EXTENSION_GROUPS', 'ext_groups', 'acl_a_attach');
        REPLACE INTO `phpbb3_modules` VALUES(36, 1, 1, 'attachments', 'acp', 11, 99, 100, 'ACP_ORPHAN_ATTACHMENTS', 'orphan', 'acl_a_attach');
        REPLACE INTO `phpbb3_modules` VALUES(37, 1, 1, 'ban', 'acp', 15, 145, 146, 'ACP_BAN_EMAILS', 'email', 'acl_a_ban');
        REPLACE INTO `phpbb3_modules` VALUES(38, 1, 1, 'ban', 'acp', 15, 147, 148, 'ACP_BAN_IPS', 'ip', 'acl_a_ban');
        REPLACE INTO `phpbb3_modules` VALUES(39, 1, 1, 'ban', 'acp', 15, 149, 150, 'ACP_BAN_USERNAMES', 'user', 'acl_a_ban');
        REPLACE INTO `phpbb3_modules` VALUES(40, 1, 1, 'bbcodes', 'acp', 10, 81, 82, 'ACP_BBCODES', 'bbcodes', 'acl_a_bbcode');
        REPLACE INTO `phpbb3_modules` VALUES(41, 1, 1, 'board', 'acp', 3, 21, 22, 'ACP_BOARD_SETTINGS', 'settings', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(42, 1, 1, 'board', 'acp', 3, 23, 24, 'ACP_BOARD_FEATURES', 'features', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(43, 1, 1, 'board', 'acp', 3, 25, 26, 'ACP_AVATAR_SETTINGS', 'avatar', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(44, 1, 1, 'board', 'acp', 3, 27, 28, 'ACP_MESSAGE_SETTINGS', 'message', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(45, 1, 1, 'board', 'acp', 10, 83, 84, 'ACP_MESSAGE_SETTINGS', 'message', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(46, 1, 1, 'board', 'acp', 3, 29, 30, 'ACP_POST_SETTINGS', 'post', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(47, 1, 1, 'board', 'acp', 3, 31, 32, 'ACP_SIGNATURE_SETTINGS', 'signature', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(48, 1, 1, 'board', 'acp', 3, 33, 34, 'ACP_REGISTER_SETTINGS', 'registration', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(49, 1, 1, 'board', 'acp', 4, 41, 42, 'ACP_AUTH_SETTINGS', 'auth', 'acl_a_server');
        REPLACE INTO `phpbb3_modules` VALUES(50, 1, 1, 'board', 'acp', 4, 43, 44, 'ACP_EMAIL_SETTINGS', 'email', 'acl_a_server');
        REPLACE INTO `phpbb3_modules` VALUES(51, 1, 1, 'board', 'acp', 5, 49, 50, 'ACP_COOKIE_SETTINGS', 'cookie', 'acl_a_server');
        REPLACE INTO `phpbb3_modules` VALUES(52, 1, 1, 'board', 'acp', 5, 51, 52, 'ACP_SERVER_SETTINGS', 'server', 'acl_a_server');
        REPLACE INTO `phpbb3_modules` VALUES(53, 1, 1, 'board', 'acp', 5, 53, 54, 'ACP_SECURITY_SETTINGS', 'security', 'acl_a_server');
        REPLACE INTO `phpbb3_modules` VALUES(54, 1, 1, 'board', 'acp', 5, 55, 56, 'ACP_LOAD_SETTINGS', 'load', 'acl_a_server');
        REPLACE INTO `phpbb3_modules` VALUES(55, 1, 1, 'bots', 'acp', 29, 245, 246, 'ACP_BOTS', 'bots', 'acl_a_bots');
        REPLACE INTO `phpbb3_modules` VALUES(56, 1, 1, 'captcha', 'acp', 3, 35, 36, 'ACP_VC_SETTINGS', 'visual', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(57, 1, 0, 'captcha', 'acp', 3, 37, 38, 'ACP_VC_CAPTCHA_DISPLAY', 'img', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(58, 1, 1, 'database', 'acp', 26, 231, 232, 'ACP_BACKUP', 'backup', 'acl_a_backup');
        REPLACE INTO `phpbb3_modules` VALUES(59, 1, 1, 'database', 'acp', 26, 233, 234, 'ACP_RESTORE', 'restore', 'acl_a_backup');
        REPLACE INTO `phpbb3_modules` VALUES(60, 1, 1, 'disallow', 'acp', 15, 151, 152, 'ACP_DISALLOW_USERNAMES', 'usernames', 'acl_a_names');
        REPLACE INTO `phpbb3_modules` VALUES(61, 1, 1, 'email', 'acp', 29, 247, 248, 'ACP_MASS_EMAIL', 'email', 'acl_a_email');
        REPLACE INTO `phpbb3_modules` VALUES(62, 1, 1, 'forums', 'acp', 7, 63, 64, 'ACP_MANAGE_FORUMS', 'manage', 'acl_a_forum');
        REPLACE INTO `phpbb3_modules` VALUES(63, 1, 1, 'groups', 'acp', 14, 137, 138, 'ACP_GROUPS_MANAGE', 'manage', 'acl_a_group');
        REPLACE INTO `phpbb3_modules` VALUES(64, 1, 1, 'icons', 'acp', 10, 85, 86, 'ACP_ICONS', 'icons', 'acl_a_icons');
        REPLACE INTO `phpbb3_modules` VALUES(65, 1, 1, 'icons', 'acp', 10, 87, 88, 'ACP_SMILIES', 'smilies', 'acl_a_icons');
        REPLACE INTO `phpbb3_modules` VALUES(66, 1, 1, 'inactive', 'acp', 13, 107, 108, 'ACP_INACTIVE_USERS', 'list', 'acl_a_user');
        REPLACE INTO `phpbb3_modules` VALUES(67, 1, 1, 'jabber', 'acp', 4, 45, 46, 'ACP_JABBER_SETTINGS', 'settings', 'acl_a_jabber');
        REPLACE INTO `phpbb3_modules` VALUES(68, 1, 1, 'language', 'acp', 29, 249, 250, 'ACP_LANGUAGE_PACKS', 'lang_packs', 'acl_a_language');
        REPLACE INTO `phpbb3_modules` VALUES(69, 1, 1, 'logs', 'acp', 25, 221, 222, 'ACP_ADMIN_LOGS', 'admin', 'acl_a_viewlogs');
        REPLACE INTO `phpbb3_modules` VALUES(70, 1, 1, 'logs', 'acp', 25, 223, 224, 'ACP_MOD_LOGS', 'mod', 'acl_a_viewlogs');
        REPLACE INTO `phpbb3_modules` VALUES(71, 1, 1, 'logs', 'acp', 25, 225, 226, 'ACP_USERS_LOGS', 'users', 'acl_a_viewlogs');
        REPLACE INTO `phpbb3_modules` VALUES(72, 1, 1, 'logs', 'acp', 25, 227, 228, 'ACP_CRITICAL_LOGS', 'critical', 'acl_a_viewlogs');
        REPLACE INTO `phpbb3_modules` VALUES(73, 1, 1, 'main', 'acp', 1, 2, 3, 'ACP_INDEX', 'main', '');
        REPLACE INTO `phpbb3_modules` VALUES(74, 1, 1, 'modules', 'acp', 30, 257, 258, 'ACP', 'acp', 'acl_a_modules');
        REPLACE INTO `phpbb3_modules` VALUES(75, 1, 1, 'modules', 'acp', 30, 259, 260, 'UCP', 'ucp', 'acl_a_modules');
        REPLACE INTO `phpbb3_modules` VALUES(76, 1, 1, 'modules', 'acp', 30, 261, 262, 'MCP', 'mcp', 'acl_a_modules');
        REPLACE INTO `phpbb3_modules` VALUES(77, 1, 1, 'permission_roles', 'acp', 19, 181, 182, 'ACP_ADMIN_ROLES', 'admin_roles', 'acl_a_roles && acl_a_aauth');
        REPLACE INTO `phpbb3_modules` VALUES(78, 1, 1, 'permission_roles', 'acp', 19, 183, 184, 'ACP_USER_ROLES', 'user_roles', 'acl_a_roles && acl_a_uauth');
        REPLACE INTO `phpbb3_modules` VALUES(79, 1, 1, 'permission_roles', 'acp', 19, 185, 186, 'ACP_MOD_ROLES', 'mod_roles', 'acl_a_roles && acl_a_mauth');
        REPLACE INTO `phpbb3_modules` VALUES(80, 1, 1, 'permission_roles', 'acp', 19, 187, 188, 'ACP_FORUM_ROLES', 'forum_roles', 'acl_a_roles && acl_a_fauth');
        REPLACE INTO `phpbb3_modules` VALUES(81, 1, 1, 'permissions', 'acp', 16, 158, 159, 'ACP_PERMISSIONS', 'intro', 'acl_a_authusers || acl_a_authgroups || acl_a_viewauth');
        REPLACE INTO `phpbb3_modules` VALUES(82, 1, 0, 'permissions', 'acp', 20, 191, 192, 'ACP_PERMISSION_TRACE', 'trace', 'acl_a_viewauth');
        REPLACE INTO `phpbb3_modules` VALUES(83, 1, 1, 'permissions', 'acp', 18, 171, 172, 'ACP_FORUM_PERMISSIONS', 'setting_forum_local', 'acl_a_fauth && (acl_a_authusers || acl_a_authgroups)');
        REPLACE INTO `phpbb3_modules` VALUES(84, 1, 1, 'permissions', 'acp', 18, 173, 174, 'ACP_FORUM_MODERATORS', 'setting_mod_local', 'acl_a_mauth && (acl_a_authusers || acl_a_authgroups)');
        REPLACE INTO `phpbb3_modules` VALUES(85, 1, 1, 'permissions', 'acp', 17, 161, 162, 'ACP_USERS_PERMISSIONS', 'setting_user_global', 'acl_a_authusers && (acl_a_aauth || acl_a_mauth || acl_a_uauth)');
        REPLACE INTO `phpbb3_modules` VALUES(86, 1, 1, 'permissions', 'acp', 13, 109, 110, 'ACP_USERS_PERMISSIONS', 'setting_user_global', 'acl_a_authusers && (acl_a_aauth || acl_a_mauth || acl_a_uauth)');
        REPLACE INTO `phpbb3_modules` VALUES(87, 1, 1, 'permissions', 'acp', 18, 175, 176, 'ACP_USERS_FORUM_PERMISSIONS', 'setting_user_local', 'acl_a_authusers && (acl_a_mauth || acl_a_fauth)');
        REPLACE INTO `phpbb3_modules` VALUES(88, 1, 1, 'permissions', 'acp', 13, 111, 112, 'ACP_USERS_FORUM_PERMISSIONS', 'setting_user_local', 'acl_a_authusers && (acl_a_mauth || acl_a_fauth)');
        REPLACE INTO `phpbb3_modules` VALUES(89, 1, 1, 'permissions', 'acp', 17, 163, 164, 'ACP_GROUPS_PERMISSIONS', 'setting_group_global', 'acl_a_authgroups && (acl_a_aauth || acl_a_mauth || acl_a_uauth)');
        REPLACE INTO `phpbb3_modules` VALUES(90, 1, 1, 'permissions', 'acp', 14, 139, 140, 'ACP_GROUPS_PERMISSIONS', 'setting_group_global', 'acl_a_authgroups && (acl_a_aauth || acl_a_mauth || acl_a_uauth)');
        REPLACE INTO `phpbb3_modules` VALUES(91, 1, 1, 'permissions', 'acp', 18, 177, 178, 'ACP_GROUPS_FORUM_PERMISSIONS', 'setting_group_local', 'acl_a_authgroups && (acl_a_mauth || acl_a_fauth)');
        REPLACE INTO `phpbb3_modules` VALUES(92, 1, 1, 'permissions', 'acp', 14, 141, 142, 'ACP_GROUPS_FORUM_PERMISSIONS', 'setting_group_local', 'acl_a_authgroups && (acl_a_mauth || acl_a_fauth)');
        REPLACE INTO `phpbb3_modules` VALUES(93, 1, 1, 'permissions', 'acp', 17, 165, 166, 'ACP_ADMINISTRATORS', 'setting_admin_global', 'acl_a_aauth && (acl_a_authusers || acl_a_authgroups)');
        REPLACE INTO `phpbb3_modules` VALUES(94, 1, 1, 'permissions', 'acp', 17, 167, 168, 'ACP_GLOBAL_MODERATORS', 'setting_mod_global', 'acl_a_mauth && (acl_a_authusers || acl_a_authgroups)');
        REPLACE INTO `phpbb3_modules` VALUES(95, 1, 1, 'permissions', 'acp', 20, 193, 194, 'ACP_VIEW_ADMIN_PERMISSIONS', 'view_admin_global', 'acl_a_viewauth');
        REPLACE INTO `phpbb3_modules` VALUES(96, 1, 1, 'permissions', 'acp', 20, 195, 196, 'ACP_VIEW_USER_PERMISSIONS', 'view_user_global', 'acl_a_viewauth');
        REPLACE INTO `phpbb3_modules` VALUES(97, 1, 1, 'permissions', 'acp', 20, 197, 198, 'ACP_VIEW_GLOBAL_MOD_PERMISSIONS', 'view_mod_global', 'acl_a_viewauth');
        REPLACE INTO `phpbb3_modules` VALUES(98, 1, 1, 'permissions', 'acp', 20, 199, 200, 'ACP_VIEW_FORUM_MOD_PERMISSIONS', 'view_mod_local', 'acl_a_viewauth');
        REPLACE INTO `phpbb3_modules` VALUES(99, 1, 1, 'permissions', 'acp', 20, 201, 202, 'ACP_VIEW_FORUM_PERMISSIONS', 'view_forum_local', 'acl_a_viewauth');
        REPLACE INTO `phpbb3_modules` VALUES(100, 1, 1, 'php_info', 'acp', 29, 251, 252, 'ACP_PHP_INFO', 'info', 'acl_a_phpinfo');
        REPLACE INTO `phpbb3_modules` VALUES(101, 1, 1, 'profile', 'acp', 13, 113, 114, 'ACP_CUSTOM_PROFILE_FIELDS', 'profile', 'acl_a_profile');
        REPLACE INTO `phpbb3_modules` VALUES(102, 1, 1, 'prune', 'acp', 7, 65, 66, 'ACP_PRUNE_FORUMS', 'forums', 'acl_a_prune');
        REPLACE INTO `phpbb3_modules` VALUES(103, 1, 1, 'prune', 'acp', 15, 153, 154, 'ACP_PRUNE_USERS', 'users', 'acl_a_userdel');
        REPLACE INTO `phpbb3_modules` VALUES(104, 1, 1, 'ranks', 'acp', 13, 115, 116, 'ACP_MANAGE_RANKS', 'ranks', 'acl_a_ranks');
        REPLACE INTO `phpbb3_modules` VALUES(105, 1, 1, 'reasons', 'acp', 29, 253, 254, 'ACP_MANAGE_REASONS', 'main', 'acl_a_reasons');
        REPLACE INTO `phpbb3_modules` VALUES(106, 1, 1, 'search', 'acp', 5, 57, 58, 'ACP_SEARCH_SETTINGS', 'settings', 'acl_a_search');
        REPLACE INTO `phpbb3_modules` VALUES(107, 1, 1, 'search', 'acp', 26, 235, 236, 'ACP_SEARCH_INDEX', 'index', 'acl_a_search');
        REPLACE INTO `phpbb3_modules` VALUES(108, 1, 1, 'styles', 'acp', 22, 207, 208, 'ACP_STYLES', 'style', 'acl_a_styles');
        REPLACE INTO `phpbb3_modules` VALUES(109, 1, 1, 'styles', 'acp', 23, 211, 212, 'ACP_TEMPLATES', 'template', 'acl_a_styles');
        REPLACE INTO `phpbb3_modules` VALUES(110, 1, 1, 'styles', 'acp', 23, 213, 214, 'ACP_THEMES', 'theme', 'acl_a_styles');
        REPLACE INTO `phpbb3_modules` VALUES(111, 1, 1, 'styles', 'acp', 23, 215, 216, 'ACP_IMAGESETS', 'imageset', 'acl_a_styles');
        REPLACE INTO `phpbb3_modules` VALUES(112, 1, 1, 'update', 'acp', 28, 241, 242, 'ACP_VERSION_CHECK', 'version_check', 'acl_a_board');
        REPLACE INTO `phpbb3_modules` VALUES(113, 1, 1, 'users', 'acp', 13, 105, 106, 'ACP_MANAGE_USERS', 'overview', 'acl_a_user');
        REPLACE INTO `phpbb3_modules` VALUES(114, 1, 0, 'users', 'acp', 13, 117, 118, 'ACP_USER_FEEDBACK', 'feedback', 'acl_a_user');
        REPLACE INTO `phpbb3_modules` VALUES(115, 1, 0, 'users', 'acp', 13, 119, 120, 'ACP_USER_PROFILE', 'profile', 'acl_a_user');
        REPLACE INTO `phpbb3_modules` VALUES(116, 1, 0, 'users', 'acp', 13, 121, 122, 'ACP_USER_PREFS', 'prefs', 'acl_a_user');
        REPLACE INTO `phpbb3_modules` VALUES(117, 1, 0, 'users', 'acp', 13, 123, 124, 'ACP_USER_AVATAR', 'avatar', 'acl_a_user');
        REPLACE INTO `phpbb3_modules` VALUES(118, 1, 0, 'users', 'acp', 13, 125, 126, 'ACP_USER_RANK', 'rank', 'acl_a_user');
        REPLACE INTO `phpbb3_modules` VALUES(119, 1, 0, 'users', 'acp', 13, 127, 128, 'ACP_USER_SIG', 'sig', 'acl_a_user');
        REPLACE INTO `phpbb3_modules` VALUES(120, 1, 0, 'users', 'acp', 13, 129, 130, 'ACP_USER_GROUPS', 'groups', 'acl_a_user && acl_a_group');
        REPLACE INTO `phpbb3_modules` VALUES(121, 1, 0, 'users', 'acp', 13, 131, 132, 'ACP_USER_PERM', 'perm', 'acl_a_user && acl_a_viewauth');
        REPLACE INTO `phpbb3_modules` VALUES(122, 1, 0, 'users', 'acp', 13, 133, 134, 'ACP_USER_ATTACH', 'attach', 'acl_a_user');
        REPLACE INTO `phpbb3_modules` VALUES(123, 1, 1, 'words', 'acp', 10, 89, 90, 'ACP_WORDS', 'words', 'acl_a_words');
        REPLACE INTO `phpbb3_modules` VALUES(124, 1, 1, 'users', 'acp', 2, 5, 6, 'ACP_MANAGE_USERS', 'overview', 'acl_a_user');
        REPLACE INTO `phpbb3_modules` VALUES(125, 1, 1, 'groups', 'acp', 2, 7, 8, 'ACP_GROUPS_MANAGE', 'manage', 'acl_a_group');
        REPLACE INTO `phpbb3_modules` VALUES(126, 1, 1, 'forums', 'acp', 2, 9, 10, 'ACP_MANAGE_FORUMS', 'manage', 'acl_a_forum');
        REPLACE INTO `phpbb3_modules` VALUES(127, 1, 1, 'logs', 'acp', 2, 11, 12, 'ACP_MOD_LOGS', 'mod', 'acl_a_viewlogs');
        REPLACE INTO `phpbb3_modules` VALUES(128, 1, 1, 'bots', 'acp', 2, 13, 14, 'ACP_BOTS', 'bots', 'acl_a_bots');
        REPLACE INTO `phpbb3_modules` VALUES(129, 1, 1, 'php_info', 'acp', 2, 15, 16, 'ACP_PHP_INFO', 'info', 'acl_a_phpinfo');
        REPLACE INTO `phpbb3_modules` VALUES(130, 1, 1, 'permissions', 'acp', 8, 69, 70, 'ACP_FORUM_PERMISSIONS', 'setting_forum_local', 'acl_a_fauth && (acl_a_authusers || acl_a_authgroups)');
        REPLACE INTO `phpbb3_modules` VALUES(131, 1, 1, 'permissions', 'acp', 8, 71, 72, 'ACP_FORUM_MODERATORS', 'setting_mod_local', 'acl_a_mauth && (acl_a_authusers || acl_a_authgroups)');
        REPLACE INTO `phpbb3_modules` VALUES(132, 1, 1, 'permissions', 'acp', 8, 73, 74, 'ACP_USERS_FORUM_PERMISSIONS', 'setting_user_local', 'acl_a_authusers && (acl_a_mauth || acl_a_fauth)');
        REPLACE INTO `phpbb3_modules` VALUES(133, 1, 1, 'permissions', 'acp', 8, 75, 76, 'ACP_GROUPS_FORUM_PERMISSIONS', 'setting_group_local', 'acl_a_authgroups && (acl_a_mauth || acl_a_fauth)');
        REPLACE INTO `phpbb3_modules` VALUES(134, 1, 1, '', 'mcp', 0, 1, 10, 'MCP_MAIN', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(135, 1, 1, '', 'mcp', 0, 11, 18, 'MCP_QUEUE', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(136, 1, 1, '', 'mcp', 0, 19, 26, 'MCP_REPORTS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(137, 1, 1, '', 'mcp', 0, 27, 32, 'MCP_NOTES', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(138, 1, 1, '', 'mcp', 0, 33, 42, 'MCP_WARN', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(139, 1, 1, '', 'mcp', 0, 43, 50, 'MCP_LOGS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(140, 1, 1, '', 'mcp', 0, 51, 58, 'MCP_BAN', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(141, 1, 1, 'ban', 'mcp', 140, 52, 53, 'MCP_BAN_USERNAMES', 'user', 'acl_m_ban');
        REPLACE INTO `phpbb3_modules` VALUES(142, 1, 1, 'ban', 'mcp', 140, 54, 55, 'MCP_BAN_IPS', 'ip', 'acl_m_ban');
        REPLACE INTO `phpbb3_modules` VALUES(143, 1, 1, 'ban', 'mcp', 140, 56, 57, 'MCP_BAN_EMAILS', 'email', 'acl_m_ban');
        REPLACE INTO `phpbb3_modules` VALUES(144, 1, 1, 'logs', 'mcp', 139, 44, 45, 'MCP_LOGS_FRONT', 'front', 'acl_m_ || aclf_m_');
        REPLACE INTO `phpbb3_modules` VALUES(145, 1, 1, 'logs', 'mcp', 139, 46, 47, 'MCP_LOGS_FORUM_VIEW', 'forum_logs', 'acl_m_,$id');
        REPLACE INTO `phpbb3_modules` VALUES(146, 1, 1, 'logs', 'mcp', 139, 48, 49, 'MCP_LOGS_TOPIC_VIEW', 'topic_logs', 'acl_m_,$id');
        REPLACE INTO `phpbb3_modules` VALUES(147, 1, 1, 'main', 'mcp', 134, 2, 3, 'MCP_MAIN_FRONT', 'front', '');
        REPLACE INTO `phpbb3_modules` VALUES(148, 1, 1, 'main', 'mcp', 134, 4, 5, 'MCP_MAIN_FORUM_VIEW', 'forum_view', 'acl_m_,$id');
        REPLACE INTO `phpbb3_modules` VALUES(149, 1, 1, 'main', 'mcp', 134, 6, 7, 'MCP_MAIN_TOPIC_VIEW', 'topic_view', 'acl_m_,$id');
        REPLACE INTO `phpbb3_modules` VALUES(150, 1, 1, 'main', 'mcp', 134, 8, 9, 'MCP_MAIN_POST_DETAILS', 'post_details', 'acl_m_,$id || (!$id && aclf_m_)');
        REPLACE INTO `phpbb3_modules` VALUES(151, 1, 1, 'notes', 'mcp', 137, 28, 29, 'MCP_NOTES_FRONT', 'front', '');
        REPLACE INTO `phpbb3_modules` VALUES(152, 1, 1, 'notes', 'mcp', 137, 30, 31, 'MCP_NOTES_USER', 'user_notes', '');
        REPLACE INTO `phpbb3_modules` VALUES(153, 1, 1, 'queue', 'mcp', 135, 12, 13, 'MCP_QUEUE_UNAPPROVED_TOPICS', 'unapproved_topics', 'aclf_m_approve');
        REPLACE INTO `phpbb3_modules` VALUES(154, 1, 1, 'queue', 'mcp', 135, 14, 15, 'MCP_QUEUE_UNAPPROVED_POSTS', 'unapproved_posts', 'aclf_m_approve');
        REPLACE INTO `phpbb3_modules` VALUES(155, 1, 1, 'queue', 'mcp', 135, 16, 17, 'MCP_QUEUE_APPROVE_DETAILS', 'approve_details', 'acl_m_approve,$id || (!$id && aclf_m_approve)');
        REPLACE INTO `phpbb3_modules` VALUES(156, 1, 1, 'reports', 'mcp', 136, 20, 21, 'MCP_REPORTS_OPEN', 'reports', 'aclf_m_report');
        REPLACE INTO `phpbb3_modules` VALUES(157, 1, 1, 'reports', 'mcp', 136, 22, 23, 'MCP_REPORTS_CLOSED', 'reports_closed', 'aclf_m_report');
        REPLACE INTO `phpbb3_modules` VALUES(158, 1, 1, 'reports', 'mcp', 136, 24, 25, 'MCP_REPORT_DETAILS', 'report_details', 'acl_m_report,$id || (!$id && aclf_m_report)');
        REPLACE INTO `phpbb3_modules` VALUES(159, 1, 1, 'warn', 'mcp', 138, 34, 35, 'MCP_WARN_FRONT', 'front', 'aclf_m_warn');
        REPLACE INTO `phpbb3_modules` VALUES(160, 1, 1, 'warn', 'mcp', 138, 36, 37, 'MCP_WARN_LIST', 'list', 'aclf_m_warn');
        REPLACE INTO `phpbb3_modules` VALUES(161, 1, 1, 'warn', 'mcp', 138, 38, 39, 'MCP_WARN_USER', 'warn_user', 'aclf_m_warn');
        REPLACE INTO `phpbb3_modules` VALUES(162, 1, 1, 'warn', 'mcp', 138, 40, 41, 'MCP_WARN_POST', 'warn_post', 'acl_m_warn && acl_f_read,$id');
        REPLACE INTO `phpbb3_modules` VALUES(163, 1, 1, '', 'ucp', 0, 1, 12, 'UCP_MAIN', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(164, 1, 1, '', 'ucp', 0, 13, 22, 'UCP_PROFILE', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(165, 1, 1, '', 'ucp', 0, 23, 30, 'UCP_PREFS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(166, 1, 1, '', 'ucp', 0, 31, 42, 'UCP_PM', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(167, 1, 1, '', 'ucp', 0, 43, 48, 'UCP_USERGROUPS', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(168, 1, 1, '', 'ucp', 0, 49, 54, 'UCP_ZEBRA', '', '');
        REPLACE INTO `phpbb3_modules` VALUES(169, 1, 1, 'attachments', 'ucp', 163, 10, 11, 'UCP_MAIN_ATTACHMENTS', 'attachments', 'acl_u_attach');
        REPLACE INTO `phpbb3_modules` VALUES(170, 1, 1, 'groups', 'ucp', 167, 44, 45, 'UCP_USERGROUPS_MEMBER', 'membership', '');
        REPLACE INTO `phpbb3_modules` VALUES(171, 1, 1, 'groups', 'ucp', 167, 46, 47, 'UCP_USERGROUPS_MANAGE', 'manage', '');
        REPLACE INTO `phpbb3_modules` VALUES(172, 1, 1, 'main', 'ucp', 163, 2, 3, 'UCP_MAIN_FRONT', 'front', '');
        REPLACE INTO `phpbb3_modules` VALUES(173, 1, 1, 'main', 'ucp', 163, 4, 5, 'UCP_MAIN_SUBSCRIBED', 'subscribed', '');
        REPLACE INTO `phpbb3_modules` VALUES(174, 1, 1, 'main', 'ucp', 163, 6, 7, 'UCP_MAIN_BOOKMARKS', 'bookmarks', 'cfg_allow_bookmarks');
        REPLACE INTO `phpbb3_modules` VALUES(175, 1, 1, 'main', 'ucp', 163, 8, 9, 'UCP_MAIN_DRAFTS', 'drafts', '');
        REPLACE INTO `phpbb3_modules` VALUES(176, 1, 0, 'pm', 'ucp', 166, 32, 33, 'UCP_PM_VIEW', 'view', 'cfg_allow_privmsg');
        REPLACE INTO `phpbb3_modules` VALUES(177, 1, 1, 'pm', 'ucp', 166, 34, 35, 'UCP_PM_COMPOSE', 'compose', 'cfg_allow_privmsg');
        REPLACE INTO `phpbb3_modules` VALUES(178, 1, 1, 'pm', 'ucp', 166, 36, 37, 'UCP_PM_DRAFTS', 'drafts', 'cfg_allow_privmsg');
        REPLACE INTO `phpbb3_modules` VALUES(179, 1, 1, 'pm', 'ucp', 166, 38, 39, 'UCP_PM_OPTIONS', 'options', 'cfg_allow_privmsg');
        REPLACE INTO `phpbb3_modules` VALUES(180, 1, 0, 'pm', 'ucp', 166, 40, 41, 'UCP_PM_POPUP_TITLE', 'popup', 'cfg_allow_privmsg');
        REPLACE INTO `phpbb3_modules` VALUES(181, 1, 1, 'prefs', 'ucp', 165, 24, 25, 'UCP_PREFS_PERSONAL', 'personal', '');
        REPLACE INTO `phpbb3_modules` VALUES(182, 1, 1, 'prefs', 'ucp', 165, 26, 27, 'UCP_PREFS_POST', 'post', '');
        REPLACE INTO `phpbb3_modules` VALUES(183, 1, 1, 'prefs', 'ucp', 165, 28, 29, 'UCP_PREFS_VIEW', 'view', '');
        REPLACE INTO `phpbb3_modules` VALUES(184, 1, 1, 'profile', 'ucp', 164, 14, 15, 'UCP_PROFILE_PROFILE_INFO', 'profile_info', '');
        REPLACE INTO `phpbb3_modules` VALUES(185, 1, 1, 'profile', 'ucp', 164, 16, 17, 'UCP_PROFILE_SIGNATURE', 'signature', '');
        REPLACE INTO `phpbb3_modules` VALUES(186, 1, 1, 'profile', 'ucp', 164, 18, 19, 'UCP_PROFILE_AVATAR', 'avatar', '');
        REPLACE INTO `phpbb3_modules` VALUES(187, 1, 1, 'profile', 'ucp', 164, 20, 21, 'UCP_PROFILE_REG_DETAILS', 'reg_details', '');
        REPLACE INTO `phpbb3_modules` VALUES(188, 1, 1, 'zebra', 'ucp', 168, 50, 51, 'UCP_ZEBRA_FRIENDS', 'friends', '');
        REPLACE INTO `phpbb3_modules` VALUES(189, 1, 1, 'zebra', 'ucp', 168, 52, 53, 'UCP_ZEBRA_FOES', 'foes', '');

Danach könnt ihr diesen Mod problemlos installieren, den ihr nach der Installation im ACP unter "Benutzer und Gruppen" findet.
Dieses Thema hat sich nun für mich erledigt.

Beste Grüße,
Shababa

Gast234254 · Beitrag von **Gast234254** » 06.03.2014 06:02

Shababa hat geschrieben:Ich habs jetzt geschafft diesen Referrer-Mod (https://www.phpbb.com/customise/db/mod/referrers) bei phpBB 3.0.12 zu installieren!
Und zwar sollte bei euch nach dem Ausführen der db_update.php die von mir oben bezeichnete Fehlermeldung kommen, müsst ihr folgendes tun:
1. Geht bei euch bei PHPMyAdmin in eure Datenbank
2. Klickt oben neben Struktur und Suche auf SQL
3. Dort führt ihr folgenden SQL-Befehl aus:
---
Danach könnt ihr diesen Mod problemlos installieren, den ihr nach der Installation im ACP unter "Benutzer und Gruppen" findet.
Dieses Thema hat sich nun für mich erledigt.
Beste Grüße,
Shababa

Kann es sein das deine Datenbank noch MySQL 4 entspricht? Den ich denke das diese Änderungen nur für Datenbanktyp :: mysql4 nötig sind. Siehe Fehlermeldung:

Referrers - Gescheitert

Datenbanktyp :: mysql4
Warnung

Also nicht unbedingt ausführen. Den bei MySQL(i) 5.5.34 sind diese zusätzliche Einträge nicht notwendig.

Shababa · Beitrag von **Shababa** » 06.03.2014 13:58

Nein, meine Datenbank hat auch die Version 5.5.34,
nur möglicherweise wurde der Mod mit der alten 4er Version erstellt,
so das die Tabellen noch an SQL 4 angepasst waren.

Gruß, Shababa

Katjabrauchthilfe · Beitrag von **Katjabrauchthilfe** » 20.07.2014 18:43

John Doe hat geschrieben:https://www.phpbb.com/customise/db/mod/referrers/

Screenshot: http://s20.postimg.org/u629ubuv1/ref2.png

Hallo John Doe,

ich habe mir alles anguckt, ist genau was ich will. Doch in der View install steht nichts von phpBB 3.0.12 oder vom Automod. Kann ich es mit 3.0.12 nutzen und geht es auch mit Automod?

Liebe Grüße

Katja

phpBB.de

Suche Referer-Mod für phpBB 3.0.12

Suche Referer-Mod für phpBB 3.0.12

Re: Suche Referer-Mod für phpBB 3.0.12

Re: Suche Referer-Mod für phpBB 3.0.12

Re: Suche Referer-Mod für phpBB 3.0.12

Re: Suche Referer-Mod für phpBB 3.0.12

Re: Suche Referer-Mod für phpBB 3.0.12

Re: Suche Referer-Mod für phpBB 3.0.12

Re: Suche Referer-Mod für phpBB 3.0.12

Re: Suche Referer-Mod für phpBB 3.0.12

Re: Suche Referer-Mod für phpBB 3.0.12