hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Creating a billing/help/control panel!
Reply

Forum Jump

Creating a billing/help/control panel!

Reply Post New Thread In Programming Discussion Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 11-06-2004, 03:05 PM
Captian_Spike Captian_Spike is offline
Web Hosting Master
 
Join Date: Nov 2003
Location: Canada
Posts: 881

Creating a billing/help/control panel!


Hey all,

I'm completely redesigning my billing system from scratch. The first one was good but now I want more features and it seems the way I designed the original database doesn't allow for much expansion.

So, I'm hoping I can get some input on a a new system. What are things to look out for or plan ahead for? And whats the best way to create the database?

Right now the idea is to create a user table in the database, then one for each different product I sell (ie, shared, reseller, dedicated etc.). Each product would have the user id stored with it so all the users stuff can be displayed in one place. I also want to add other stuff such as a table for extra charges, so I could add overages and other stuff to the account.

On top of this I need to intergrate a ticket system, I have no experience designing ticket systems so input on this would be helpfull. I also want to make it a intergrated control panel, but I'll get to that later.

The biggest thing is the database design, I can change coding but once users are in the database its a pain to move them. What are somethings I should know in order to make a good db design? And while I'm askin, what are feature users would like to see in a system like this?



Sponsored Links
  #2  
Old 11-06-2004, 04:42 PM
Shaw Networks Shaw Networks is offline
Hosting Specialist
 
Join Date: Sep 2003
Location: Washington, USA
Posts: 3,219
Just a suggestion, you might want to think about port in a pre-existing trouble ticket system (such as Help Center Live) with the billing system you're planning to code. Building the two from scratch and then integrating them seamlessly is a huge undertaking.

__________________
SHAW NETWORKS Simple. Professional. Reliable. Web Hosting Done Right.
Low Cost & Award-Winning: cPanel Reseller Plans 24/7/365 Live Technical Support
Website: www.shawnetworks.com Fast Response E-mail: sales @ shawnetworks.com
Sick of downtime? Fed up with excuses? Drop your host! Switch to Shaw Networks.

  #3  
Old 11-06-2004, 07:03 PM
Xlusive Xlusive is offline
WHT Addict
 
Join Date: Nov 2004
Location: Netherlands
Posts: 136
Quote:
Originally posted by IncognitoNet
Just a suggestion, you might want to think about port in a pre-existing trouble ticket system (such as Help Center Live) with the billing system you're planning to code. Building the two from scratch and then integrating them seamlessly is a huge undertaking.
I totally agree with yuo , it takes allot of time, and sometimes its the best to purchase a license

altho i have build my own billing system ( and still am developing it )

it takes allot of time , but if you want that your customers have a special ID , try

Quote:

CREATE TABLE `tablename` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` )
);

in phpmyadmin , if you are creating a customer DB

ID - INT - 10 - AUTO_INCREMENT


everytime a client registers it will get a number starting from 1 to 9999999999

10 - 9's

if you ever need help with php , i am right here


Xlusive

__________________
Professional Coder click here to contact me

Sponsored Links
Reply

Related posts from TheWhir.com
Title Type Date Posted
WHMCS Releases Version 5.2 of Web Hosting Billing Solution Web Hosting News 2013-04-14 22:35:37
ResellerClub Module Helps Resellers Provision Hosting Products through WHMCS Control Panel Web Hosting News 2012-09-06 16:17:27
Weekend Reading: Top Web Hosting Industry Stories from the Week of August 27 to 31, 2012 Web Hosting News 2012-09-01 16:02:05
Video: cPanel and Attracta Talk About Integrating SEO Tools into the Hosting Control Panel Whir Tv 2014-05-02 15:24:21
Video: Hosting Control Panel cPanel, and Billing Software WHMCS Discuss Investment, Partnership, Integration Whir Tv 2014-05-02 15:25:56


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?