https://interactivetools.com/forum/forum-search.php?k=user%3Acarl2 Tue, 21 Apr 2026 06:30:57 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2204932#post2204932 ]]> Thu, 17 Jun 2010 14:31:32 -0700 forum-posts.php?postNum=2204932#post2204932 https://interactivetools.com/forum/forum-posts.php?postNum=2204928#post2204928
I've attached a plugin you can use that will add this functionality. You will need to add some information at the top: the table and field name that you want to reset, and the value to reset it to. For example, if you want to set the value of 'paid' to '0' on all records in the 'accounts' table, add this near the top where the comments tell you to:

array( 'tableName' => 'accounts', 'fieldName' => 'paid', 'resetValue' => 0 )

Once you have enabled the plugin, in the 'Advanced Commands' section, there will be the option to set the fields on all records.

Right now it will only make the option available to admins. If you wanted to have a 'super admin', then you could add a checkbox field to your Accounts section called 'super_admin' and change the check on line 27 to

if ( !$CURRENT_USER['super_admin'] ) return;

Let me know if this works for you or if you have any problems getting it to work!

Carl
]]> Thu, 17 Jun 2010 12:35:17 -0700 forum-posts.php?postNum=2204928#post2204928 https://interactivetools.com/forum/forum-posts.php?postNum=2204907#post2204907
A 'super-admin' user would be more convoluted and would require changes to your database and so on, though. However I can certainly make it only accessible to admin users.

Alternatively if you really don't want anyone but one user to have access, it could just be a standalone script with some obscure URL. So you or your client would visit /some_script_name.php to perform the update. You could also automate that with a cronjob.

Carl
]]> Wed, 16 Jun 2010 13:09:34 -0700 forum-posts.php?postNum=2204907#post2204907 https://interactivetools.com/forum/forum-posts.php?postNum=2204890#post2204890
I've had a look into this and I could make a plugin that adds something to the 'Advanced Command' dropdown on the table list page. That way you or your client could manually reset the field. Would that be okay for you?

Carl
]]> Tue, 15 Jun 2010 18:10:07 -0700 forum-posts.php?postNum=2204890#post2204890