Revision history for WikkaWithphpBB3
Revision [21000]
Last edited on 2010-01-24 12:57:07 by BrianKoontz [Added versions this plugin has been tested with]Additions:
>>**Works with versions:** 1.1.6.5 through 1.2
>>::c::
>>::c::
Additions:
1) After I made these changes I can't logon as admin. Thus I opened a group in phpbb called WIKKA and modified isAdmin as followed:
You may change the phpbb database name "phpbb" and the phpbb prefix "phpbb_" into yours.
You may change the phpbb database name "phpbb" and the phpbb prefix "phpbb_" into yours.
Deletions:
You may change the phpbb database name "phpbb" into yours.
Additions:
EDIT AlexRust:
I did this today and found two problems:
1) There is the ending } missing in function LoadUser.
1) After I made these changes I can't logon as admin. Thus I opened a group in phpbb called WIKI and modified isAdmin as followed:
file: Wakka.class.php
%%(php) //returns true if user is listed in configuration list as admin
function IsAdmin($user='') {
// $adminstring = $this->config["admin_users"]; // <---
// $adminarray = explode(',' , $adminstring); // <---
// das $adminarray kann für alle User aufgebaut werden, // <---
// die zur phpbb-Gruppe Wikka gehören. // <---
$adminarray = array(); // <---
$query = "SELECT
username,
group_name
FROM
phpbb.phpbb_users u
join phpbb.phpbb_user_group ug on (u.user_id=ug.user_id)
join phpbb.phpbb_groups g on (ug.group_id=g.group_id)
where
group_name='WIKKA'
"; // <---
if ($r = $this->Query($query)) // <---
{ // <---
while ($row = mysql_fetch_assoc($r)) $adminarray[] = $row['username']; // <---
mysql_free_result($r); // <---
} // <---
if(TRUE===empty($user))
$user = $this->GetUserName();
else if(is_array($user))
$user = $user['name'];
foreach ($adminarray as $admin) {
if (trim($admin) == $user) return true;
You may change the phpbb database name "phpbb" into yours.
I did this today and found two problems:
1) There is the ending } missing in function LoadUser.
1) After I made these changes I can't logon as admin. Thus I opened a group in phpbb called WIKI and modified isAdmin as followed:
file: Wakka.class.php
%%(php) //returns true if user is listed in configuration list as admin
function IsAdmin($user='') {
// $adminstring = $this->config["admin_users"]; // <---
// $adminarray = explode(',' , $adminstring); // <---
// das $adminarray kann für alle User aufgebaut werden, // <---
// die zur phpbb-Gruppe Wikka gehören. // <---
$adminarray = array(); // <---
$query = "SELECT
username,
group_name
FROM
phpbb.phpbb_users u
join phpbb.phpbb_user_group ug on (u.user_id=ug.user_id)
join phpbb.phpbb_groups g on (ug.group_id=g.group_id)
where
group_name='WIKKA'
"; // <---
if ($r = $this->Query($query)) // <---
{ // <---
while ($row = mysql_fetch_assoc($r)) $adminarray[] = $row['username']; // <---
mysql_free_result($r); // <---
} // <---
if(TRUE===empty($user))
$user = $this->GetUserName();
else if(is_array($user))
$user = $user['name'];
foreach ($adminarray as $admin) {
if (trim($admin) == $user) return true;
You may change the phpbb database name "phpbb" into yours.
Deletions:
Additions:
switch($rank)
case 'edits':
$label= 'edits';
$query = 'SELECT COUNT(*) AS cnt, `name` FROM '.$this->GetConfigValue('table_prefix').'users, '.$this->GetConfigValue('table_prefix').'pages WHERE `name` = `user` GROUP BY name ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('pages');
break;
case 'comments':
$label= 'comments';
$query = 'SELECT COUNT(*) AS cnt, `name` FROM '.$this->GetConfigValue('table_prefix').'users, '.$this->GetConfigValue('table_prefix').'comments WHERE `name` = `user` GROUP BY name ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('comments');
break;
default:
case 'pages':
$label= 'pages owned';
$query = 'SELECT COUNT(*) AS cnt, `name` FROM '.$this->GetConfigValue('table_prefix').'users, '.$this->GetConfigValue('table_prefix').'pages WHERE `name` = `owner` AND `latest` = "Y" GROUP BY name ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('pages', "`latest` = 'Y'");
break;
}%%
switch($rank)
case 'edits':
$label= 'edits';
$query = 'SELECT COUNT(*) AS cnt, `username` AS name FROM phpbb3_users '.$this->GetConfigValue('table_prefix').'pages WHERE `username` = `user` GROUP BY username ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('pages');
break;
case 'comments':
$label= 'comments';
$query = 'SELECT COUNT(*) AS cnt, `username` AS name FROM phpbb3_users '.$this->GetConfigValue('table_prefix').'comments WHERE `username` = `user` GROUP BY username ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('comments');
break;
default:
case 'pages':
$label= 'pages owned';
$query = 'SELECT COUNT(*) AS cnt, `username` AS name FROM phpbb3_users '.$this->GetConfigValue('table_prefix').'pages WHERE `username` = `owner` AND `latest` = "Y" GROUP BY username ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('pages', "`latest` = 'Y'");
break;
}%%
case 'edits':
$label= 'edits';
$query = 'SELECT COUNT(*) AS cnt, `name` FROM '.$this->GetConfigValue('table_prefix').'users, '.$this->GetConfigValue('table_prefix').'pages WHERE `name` = `user` GROUP BY name ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('pages');
break;
case 'comments':
$label= 'comments';
$query = 'SELECT COUNT(*) AS cnt, `name` FROM '.$this->GetConfigValue('table_prefix').'users, '.$this->GetConfigValue('table_prefix').'comments WHERE `name` = `user` GROUP BY name ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('comments');
break;
default:
case 'pages':
$label= 'pages owned';
$query = 'SELECT COUNT(*) AS cnt, `name` FROM '.$this->GetConfigValue('table_prefix').'users, '.$this->GetConfigValue('table_prefix').'pages WHERE `name` = `owner` AND `latest` = "Y" GROUP BY name ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('pages', "`latest` = 'Y'");
break;
}%%
switch($rank)
case 'edits':
$label= 'edits';
$query = 'SELECT COUNT(*) AS cnt, `username` AS name FROM phpbb3_users '.$this->GetConfigValue('table_prefix').'pages WHERE `username` = `user` GROUP BY username ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('pages');
break;
case 'comments':
$label= 'comments';
$query = 'SELECT COUNT(*) AS cnt, `username` AS name FROM phpbb3_users '.$this->GetConfigValue('table_prefix').'comments WHERE `username` = `user` GROUP BY username ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('comments');
break;
default:
case 'pages':
$label= 'pages owned';
$query = 'SELECT COUNT(*) AS cnt, `username` AS name FROM phpbb3_users '.$this->GetConfigValue('table_prefix').'pages WHERE `username` = `owner` AND `latest` = "Y" GROUP BY username ORDER BY cnt DESC LIMIT '.$limit;
$total = $this->getCount('pages', "`latest` = 'Y'");
break;
}%%
Deletions:
$str .= $this->config["table_prefix"] . 'users, ' ;
$str .= $this->config["table_prefix"].'pages ';
$str .= "WHERE `name` = `owner` AND `latest` = 'Y' GROUP BY name ORDER BY cnt DESC;";%%
$str = 'SELECT Count(*) AS cnt, `username` AS name FROM phpbb3_users, ' ;
$str .= $this->config["table_prefix"].'pages ';
$str .= "WHERE `username` = `owner` AND `latest` = 'Y' GROUP BY username ORDER BY cnt DESC;";%%
Additions:
phpBB3 changed its user authentication mechanism. phpBB3 no longer stores MD5 hashes of passwords; instead it does a "true" one-way, one-time, non-recoverable hash of the password using [[http://www.openwall.com/phpass/ phpass]]. The output of the hash is different each time, so you can't just select the password in the phpBB database and do a compare against a MD5 of the submitted password anymore - you have to algorithmically compare them using phpass. They also changed how and where they indicate if a user is active or inactive.
==/actions/highscores.php==
$str = 'SELECT Count(*) AS cnt, `name` FROM ';
$str .= $this->config["table_prefix"] . 'users, ' ;
$str .= $this->config["table_prefix"].'pages ';
$str .= "WHERE `name` = `owner` AND `latest` = 'Y' GROUP BY name ORDER BY cnt DESC;";%%
Replace with:
$str = 'SELECT Count(*) AS cnt, `username` AS name FROM phpbb3_users, ' ;
$str .= $this->config["table_prefix"].'pages ';
$str .= "WHERE `username` = `owner` AND `latest` = 'Y' GROUP BY username ORDER BY cnt DESC;";%%
Configuration to disable UserRegistration is still required, either patch for 1.1.6.2 or update config setting in 1.1.6.3 (or later) see UserRegistration for more details. See the phpBB 2.x integration page for info about how to edit phpBB to force Wiki-style usernames. On my install this works fine with usernames containing spaces, no caps, etc.
==/actions/highscores.php==
$str = 'SELECT Count(*) AS cnt, `name` FROM ';
$str .= $this->config["table_prefix"] . 'users, ' ;
$str .= $this->config["table_prefix"].'pages ';
$str .= "WHERE `name` = `owner` AND `latest` = 'Y' GROUP BY name ORDER BY cnt DESC;";%%
Replace with:
$str = 'SELECT Count(*) AS cnt, `username` AS name FROM phpbb3_users, ' ;
$str .= $this->config["table_prefix"].'pages ';
$str .= "WHERE `username` = `owner` AND `latest` = 'Y' GROUP BY username ORDER BY cnt DESC;";%%
Configuration to disable UserRegistration is still required, either patch for 1.1.6.2 or update config setting in 1.1.6.3 (or later) see UserRegistration for more details. See the phpBB 2.x integration page for info about how to edit phpBB to force Wiki-style usernames. On my install this works fine with usernames containing spaces, no caps, etc.
