Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 11:18 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Ratecard on userinfo.php
PostPosted: Sun Apr 20, 2008 1:05 pm 
Offline

Joined: Wed Jan 02, 2008 12:22 pm
Posts: 11
Hi dear community,
I'm trying to find out the variable for my customer's ratecard and display it on unserinfo.php
I tried to echo $mytariff_id , but doesnt seem to be correct.
Any of you has an idea ?
Thanks.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Apr 20, 2008 2:24 pm 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
You need to modify the SQL select on line 15 to pull in the information that you require:
Code:
$QUERY = "SELECT  username, credit, lastname, firstname, address, city, state, country, zipcode, phone, email, fax, lastuse, activated, currency, cc_tariffgroup.tariffgroupname FROM cc_card LEFT JOIN cc_tariffgroup ON cc_card.tariff = cc_tariffgroup.id WHERE username = '".$_SESSION["pr_login"]."' AND uipass = '".$_SESSION["pr_password"]."'";
Now the tariff group name will be available in $customer_info[15]


Top
 Profile  
 
 Post subject: great
PostPosted: Sun Apr 20, 2008 4:07 pm 
Offline

Joined: Wed Jan 02, 2008 12:22 pm
Posts: 11
thanks Stavros.
tested and worked succesfully ! :)


Top
 Profile  
 
 Post subject:
PostPosted: Fri Feb 13, 2009 9:47 am 
Offline

Joined: Fri Jan 23, 2009 10:43 am
Posts: 28
hi,which SQL must be edited?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 
VoIP Billing solution


All times are UTC


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group