Search Engine: Elastic

Article ID: 117876, created on Oct 11, 2013, last review on May 6, 2014

  • Applies to:
  • Odin Business Automation Standard 4.3


According to chapter "Applying Skins" of PBA-S 4.3 Provider's Guide:

Only XP-style skins can be applied to provider's and reseller's users.
Only the Panel Theme based skins can be applied to customers.

Verify custom skin based on "Panel Theme" exists and enabled in Reseller's Control Panel:

RCC > Top > Marketing Director > Brand Manager > Skins

The customer's skin may be changed through Provider's Panel (PCC) or Reseller's Panel (RCC) usual way:


For many customers skin may be changed in the database. Here are the steps:

  1. Verify id of new reseller's skin in the database:

    mysql> select skin_id, title, owner_id from cu_skin where owner_id=<RES_ID>;
    | skin_id | title                  | owner_id |
    | SKIN_ID | Reseller's Panel Theme |   RES_ID |
    1 row in set (0.00 sec)

    Where RES_ID is Reseller's ID.

  2. Dump the person table before modifying it:

    ~# mysqldump aspc --extended-insert=false --tables person > person.dump.`date +%F.%s`.sql
  3. Change skin to SKIN_ID for all customer of reseller RES_ID using the following query:

    mysql> update person set skin_id=<SKIN_ID> where person_id in (select person_id from person_account where account_no in(select account_no from account where vendor=<RES_ID>));

    Run command hspc-sql on the server as root to login to PBA-S database.

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 807e9c1dc97aefd951b912a17e50c428 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF