CP Traffic Calculation


Traffic generated from browsing the Control Panel is not included in the summary traffic. To track it, H-Sphere owners can set up custom packages.

H-Sphere System Database


The H-Sphere system database is used to store system data. In normal H-Sphere configuration, it runs on PostgreSQL server, but it may be installed on a separate Windows-based MSSQL server.

Usually, the system database is located on the same server with the Control Panel.

The system database is not used for hosting. PostgreSQL hosting server could not be installed on the same box with the system database.

The H-Sphere database is executed under the pgsql or postgres user.

System Database Settings


Database settings in hsphere.properties:

DB_DRIVER = org.postgresql.Driver
DB_URL = jdbcostgresql://127.0.0.1/hsphere – the system database name, usually hsphere
DB_USER = wwwuser – the system db user name, usually wwwuser
DB_PASSWORD = your_db_password – the system db user password
DB_NEWID = SELECT nextval(”{0}”)

Logging Into The System Database


To log into the system database:

First of you need to get Login as the cpanel user to the server where the system database is located (usually, CP server).
Then enter the hsphere database (usually, under the wwwuser user name):
# psql hsphere [user_name]

script for uploading the image


Can anyone recommend me a good free script for uploading the image.

You can make an image uploader easily with PHP. You can do:-
– Browse and upload
– Create thumbs
– Let user view their images

VACUUM Utility


The Postgres VACUUM instruction allows cleaning up the server transactions. vacuum is a time-consuming procedure; it may take up to several hours to complete!

Enter the psql server:

psql hsphere wwwuser and type in the password set in hsphere.properties.

In the psql command line, type the ‘vacuum full’ command:
vacuum full;

How create a mp3 player with php ?


I want to create a mp3 player in php.Is it possible to create a mp3 player with php ?

Yes,It’s possible. check out the bass audio library and winbinder.

U can use Flash/embed to play the music.

U can Make one with Flash/ActionScript/XML

It is impossibile with PHP. That is if you are looking to actually create a standalone MP3 player strictly out of PHP. If you are using some other method such as Flash, or integrating Media player into your script, then yes it is.

How can i do it?

winbinder is a library for creating gui applications with php, like php-gtk, only windows API specific.

thanx tertius, Can we convert it into exe or just php ???

Yes, u can convert it into exe

CP Mail Queue


The mail queue file is assigned to store unsent CP messages (e.g., trouble tickets, system notifications, mass mail, etc.) when CP is restarted – formerly, they were lost after CP restart. Mail queue location is set in hsphere.properties:

MAIL_SWP=/hsphere/local/home/cpanel/shiva/mail.swp

Changing Hosting Plan


hi,
At present i have a Starter Reseller web hosting plan from cpwebhosting.net but now i want to change plan from Starter Reseller to Professional Reseller plan. how can i do it

For changing your web hosting plan

1. Go to your control panel home.
2. Click the Change icon next to your plan name in the left hand info/control area.
3. Select your new plan and click Submit