Revision history for ExpandedAdminBackupTool
Revision [18738]
Last edited on 2008-01-28 00:12:34 by WazoO [Modified links pointing to docs server]No Differences
Additions:
WazoO Adds -
WazoO - 9 Feb 2006
WazoO - 9 Feb 2006
Deletions:
Wazoo - 9 Feb 2006
Additions:
Code fix;
Line 64
changed to read;
echo ($menu1 != 'users')?'<a href="'.$this_link.'"><b>'.$page_name.'</b></a>'
Line 64
changed to read;
echo ($menu1 != 'users')?'<a href="'.$this_link.'"><b>'.$page_name.'</b></a>'
Additions:
As the field "login_count" and the code needed to stuff this filed isn't provided (and I've not found it described anywhere in this Wiki) I commented out some lines, modified another to drop the field from a Query ... the "Delete User" section is provided here to make it a cut/past/replace operation;
Deletions:
Additions:
%%(mysql)
Additions:
Wazoo Adds -
Until Mike gets back and updates this page, this is what I did to make this functional.
New Table needed, based on my best guess by looking at what the code was looking for;
mysql> CREATE TABLE `wikka_resetpasswords` (
-> `username` varchar(75) NOT NULL default '',
-> `password` varchar(32) NOT NULL default '',
-> PRIMARY KEY (`username`)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected (0.00 sec)
As the field "login_count" and the code needed to stuff this filed isn't provided (and I've not found it described anywhere in this Wiki) I commented out some lines, modified another to drop the field from a Query ... the "Delete User" section is provided here to make ot a cut/past/replace operation;
if ($_REQUEST['set']) {
// need database field $query = "SELECT `name`,`signuptime`,`login_count`,`email` FROM `$t_users` WHERE `password`!='Reserved Account' $order ";
$query = "SELECT `name`,`signuptime`,`email` FROM `$t_users` WHERE `password`!='Reserved Account' $order ";
// need database field "<th> # logins </th>".
if ($stat!=="0") $num = $this->LoadSingle("SELECT count(*) as n from ".$this->config["table_prefix"]."pages where owner='".$user["name"]."' AND latest = 'Y'");
// need database field "<td>".$user["login_count"]."</td>".
'</form>';
Wazoo - 9 Feb 2006
Until Mike gets back and updates this page, this is what I did to make this functional.
New Table needed, based on my best guess by looking at what the code was looking for;
mysql> CREATE TABLE `wikka_resetpasswords` (
-> `username` varchar(75) NOT NULL default '',
-> `password` varchar(32) NOT NULL default '',
-> PRIMARY KEY (`username`)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected (0.00 sec)
As the field "login_count" and the code needed to stuff this filed isn't provided (and I've not found it described anywhere in this Wiki) I commented out some lines, modified another to drop the field from a Query ... the "Delete User" section is provided here to make ot a cut/past/replace operation;
if ($_REQUEST['set']) {
// need database field $query = "SELECT `name`,`signuptime`,`login_count`,`email` FROM `$t_users` WHERE `password`!='Reserved Account' $order ";
$query = "SELECT `name`,`signuptime`,`email` FROM `$t_users` WHERE `password`!='Reserved Account' $order ";
// need database field "<th> # logins </th>".
if ($stat!=="0") $num = $this->LoadSingle("SELECT count(*) as n from ".$this->config["table_prefix"]."pages where owner='".$user["name"]."' AND latest = 'Y'");
// need database field "<td>".$user["login_count"]."</td>".
'</form>';
Wazoo - 9 Feb 2006
Additions:
Install the script below in actions (I call it wikkamanagement.php). It will work without an ftp server (although you should put the variable references into the wikka.config.php, just leave the variable names blank) and local backups can be downloaded. [note that you have to replace "percentpercent" in the code with two percent signs]
$def .= "DROP TABLE IF EXISTS `$table`;#percentpercent\n";
$def .= "\n);#percentpercent";
$insert .= ");#percentpercent\n";
$def .= "DROP TABLE IF EXISTS `$table`;#percentpercent\n";
$def .= "\n);#percentpercent";
$insert .= ");#percentpercent\n";
Deletions:
$def .= "DROP TABLE IF EXISTS `$table`;#%%\n";
$def .= "\n);#%%";
$insert .= ");#%%\n";
