Posted on by

Changing the Length of the Private ID

Participants Database uses a “private id” value as a key for users to edit their own record. The plugin uses a short 5-character code for this purpose, it’s not meant to be airtight security, just something impractical to guess.

Some administrators may want to use a larger term for their install, and it’s possible to do this with a filter. Using the filter “pdb-private_id_length” you can set a new length for your private ids. This length is used when the ID is generated, so any existing IDs will not be affected.

Here is an example of the filter in use:

That file should be uploaded into your plugins directory, then activated in the main Plugin page in the WP admin. You can also download a zip file of the plugin here… then upload and install it on the plugins page using “add plugin.”

Enabling Larger Values

To use lengths greater than 9 characters, you will need to alter the database. The database sets the datatype of the private_id column as a VARCHAR(9). Using phpMyAdmin (or a similar tool) you can change that length to whatever value you need. This database tool is often found in the hosting control panel.

You will need to make sure you are editing the correct database (many sites will have more than one) and then find the table. In most installs the table will be named wp_participants_database, although the prefix may be different for you. Go to the “structure” tab for the table and find the “private_id” column. You can change the datatype there, you really only need to change the value that follows the VARCHAR.

Leave a Reply
You have to agree to the comment policy.

Leave a Reply
You have to agree to the comment policy.