How to add a "spam-setting level" to the "Personal setting" Roundcube page

[voltron81]

Hello to everybody.
I'm realizing a mail server based on ISPConfig 3 and Roundcube as webmail.

I would like to add a service to the customer roundcube webpage, so that a customer can set-up the level of spam filtering for his email(basically I want to add a slider with 10 spam levels on the "personal setting" roundcube page).

I've checked that, on ISPConfig 3, I can create "Policy record" that are stored on mysql database, exatly in "spamfilter_user" table, in the field names "policy_id", where the value of "policy_id" is the order of "Policy record" in ISPConfig page.

So, how can add on Roundcube this slider?
I don't think it's really difficult...but I'm not an expert of PHP at all!!!

Thanks
Michele

[rosali]

You really need PHP/HTML/CSS/Javascript skills for that as you will have to code a plugin.

[voltron81]

Ok, I'll try to do it with PHP, even if I'm not an expert...
If somebody can give me some suggestions... I'll really appreciate it

[voltron81]

I've found a plugin for Roundcube named "SpamAssassin User Prefs" that:
Adds a 'Spam' tab to the 'Personal Settings' to allow the user to change their SpamAssassin preferences. Preferences must be stored in a SQL database. Default preferences are used when no user preference is found.

It's working with Spamassassin database.

Do you think is simple to modify it, so that it can work with ISPConfig database?

Thanks
Michele

[JohnDoh]

you can set the database and tables the spamassassin user prefs plugin uses in the config but it only works with the spamassassin names for preferences, you will need to mod all the code to use different ones (find and replace should do it)

[voltron81]

ok so for now I'll try to use this plugin with Spamassassin...
Do you know if there is an "How-to" that explain me the steps?

I have read this: UsingSQL - Spamassassin Wiki but I think I'm still miss something...

Thanks
Michele

[voltron81]

Change of programs... I can't do it using the pure Spamassassin without ISPConfig... so I need to modify that script or create a new one... :eek:

If somebody want to help me...

[voltron81]

Hi.
Somebody can show me the right way please?

I've found in which part of the database ISPConfig write the spam policy.
I've integrated Roundcube with a slider that have 11 steps.

The only think that I've to do, and I've no idea of how to do it, is connect roundcube with dbispconfig, make a "SELECT * FROM spamfilter_users WHERE EMAIL = mail@mail.com" and then write the value of the policy in the column "policy_id".
I've already created 11 spam policy with ISPConfig and I know the policy_id of all of them.

Suggestions?
Thanks
Michele

[voltron81]

Ok I'm integrating this modification of the MySQL in roundcube.
I've create the  mysql_query($query) and 11 queries, releated with the slider.

Now what I need is create a SELECT before that basically is doig:

Code: [Select]

SELECT policy_id FROM spamfilter_users WHERE email = $roundcube_username

Somebody know where I can find the variable $roundcube_username?

Thanks
Michele

[rosali]

$_SESSION['username'] or from the user object $rcmail->user->data('username') [italic part depends on how the rcmail object was referenced].

[voltron81]

Thanks a lot,
Just this morning I found it in one of my test