Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Wed Sep 18, 2019 10:11 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 19 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: A2billing Joomla integration
PostPosted: Mon Jan 14, 2008 1:45 am 
Offline

Joined: Thu Nov 30, 2006 2:04 am
Posts: 40
Hi there

I was able to setup a scenario where a2billing users were registered as Joomla users however i am having an issue with the sessions and authentication.

Heres an overview of what I have done

1.I have joomla and a2billing on 2 seperate databases
2.I used the "MySql Auth Plugin" (http://extensions.joomla.org/component/ ... Itemid,35/ ) to allow a2billing users to automatically register on joomla through the joomla login interface.

Here are the issues
1.The a2billing login form uses different form variables eg pr_login instead of username as form field names

2.i assume the sessions should be setup differently to allow the login. (I am new to php and programming so I am unsure)

I think that a2billing can be integrated with joomla as with this type of bridge however help is needed from a veteran programmer

Thank you for your time and hope some help will come my way


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jan 15, 2008 6:59 pm 
Offline

Joined: Thu Nov 30, 2006 2:04 am
Posts: 40
Hi,

Just an update.I am using the email to login users. Thats not the issue. The real issue is that the login interface does not login to both joomla as and a2billing due to the following

1.The username form field in the login module in Joomla using SQL auth is "username" whereas the one used to login a2billing users is called "pr_login"
2.The sessions maybe an issue although if i can get the login form to post "the correct variales to a2billing,ie pr_password and pr_login, this should not be an issue

I have tried the login but the "access denied error is shown when going to the a2billing interface however if i am logged in to a2billing and log in from the joomla sql module login i am take to the a2billing interface

I have tried to incorporate a javascript in the sql joomla module in order to complete the following

1.Firstly equate the variable "username" and "password" in the joomla module login to the a2billing variables "pr_login" and "pr_passwd" or post the form directly to the a2billing customer interface login ie index2.php.
2.I would then setup the SQL module to redirect to the a2billing interface and thus the correct variable will be posted, which is what would be the case if logining in from a2billing itself, and thus the user would be logged in in both joomla nad a2billing

The issue that would remain would be to sort out and syncronise the logout buttons so that is would log the user out from both interfaces

Heres the sql query I used in the SQL login component setup in Joomla

SELECT firstname AS name, email AS username, email AS email, credit, activated, id, id_didgroup, tariff, vat, activatedbyuser FROM cc_card WHERE email = '%{user}' AND uipass = '%{pass}'

a2billing doesnt seem to use MD5 encryption fro the password.

I hope I have explained things clearly and hope that you may be able to help. i am new to progrmming thus it might be easier that it seems to do the javascript code to equate the form variable to be posted

Thanks


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jan 15, 2008 7:37 pm 
Offline
User avatar

Joined: Mon Apr 30, 2007 6:43 am
Posts: 1060
Location: Canada
Is the Joomla form a modules or a component? What is the name of the entity? mod_xxxxx or com_xxxxxx?

If you intend to you that form only for a2billing, you can hack into it and change the name of the for elements value.

Another thing. You might like it. I came across a Mambo/Joomla mambot once. It has the ability to let site administrators enter any PHP or HTML code (including forms) directly as content of a user module. The beauty of this is that you can paste the a2billing login form in there, and edit the action parameter of the form tag and you are done. The action must of course be the domain on which a2billing's customer login form will be processed. No need to manage a separate MySQL.

Regards

Edit: Replaced "... and edit the target parameter of the form tag ..." with "... and edit the action parameter of the form tag ..."


Last edited by asiby on Thu Jan 17, 2008 2:27 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject:
PostPosted: Tue Jan 15, 2008 7:53 pm 
Offline

Joined: Thu Oct 19, 2006 9:56 am
Posts: 300
Location: Athens, Greece
Just a hint: if you are planning on combining such different systems on a common database, consider using Postgres rather than MySQL.

The advantage of Postgres is that you can play around with views/rules and have instances of the same database that 'translate' into each system's native tables. Postgres gives you great flexibility in "virtual" tables and objects.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jan 15, 2008 9:00 pm 
Offline

Joined: Thu Nov 30, 2006 2:04 am
Posts: 40
Hi...Thanks for the hint..Will look into it however i have limited experience and to be honest my programming knowledge is limited. I have only worked with mysql and PHP... any help with the javascript code to submit the login form to either 2 locations or to post the variables correctly as described in my last post would be appreciated...I know that this sort of integration is not needed my most people but there are many value added servces as well as business management services that can be integrated to provide a better customer experience as well as manage the business more effectively.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jan 17, 2008 2:24 pm 
Offline
User avatar

Joined: Mon Apr 30, 2007 6:43 am
Posts: 1060
Location: Canada
Paste this code wherever you want and make sure that you replace your.customerUIdomain.com with the domain name of your A2Billing customer interface.

Code:
<script LANGUAGE="JavaScript">
<!--
   function test()
   {
      if(document.form.pr_login.value=="" || document.form.pr_password.value=="")
      {
         alert("You must enter an username and a password!");
         return false;
      }
      else
      {
         return true;
      }
   }
-->
</script>

<form name="form" method="POST" action="http://your.customerUIdomain.com/userinfo.php" onSubmit="return test()">
   <input type="hidden" name="done" value="submit_log"><br>
   <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
         <td rowspan="3" width="20"></td>
         <td valign="top">
            <label for="pr_login">Username (alias):</label><br>
            <input name="pr_login" type="text" class="form_input_text" id="pr_login">
         </td>
      </tr>
      <tr>
         <td valign="top">
            <label for="pr_password">Password :</label><br>
            <input name="pr_password" type="password" class="form_input_text" id="pr_password">
         </td>
      </tr>
      <tr>
         <td valign="top">
            <input type="submit" name="submit" value="LOGIN" class="form_input_button">&nbsp;<br>
            <br>
            <a href="http://your.customerUIdomain.com/forgotpassword.php">Forgot password?</a>
         </td>
      </tr>      
   </table>
</form>


Top
 Profile  
 
 Post subject:
PostPosted: Thu Feb 21, 2008 8:38 pm 
Offline
User avatar

Joined: Mon Apr 30, 2007 6:43 am
Posts: 1060
Location: Canada
It does, I have already tested it. It is available right now on my domain.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Feb 21, 2008 11:49 pm 
Offline

Joined: Sun Jan 20, 2008 12:00 am
Posts: 71
I'm very interested.. anyone able to get this working.. as a module?


Top
 Profile  
 
 Post subject: It is working
PostPosted: Tue Apr 08, 2008 12:54 am 
Offline

Joined: Tue Aug 28, 2007 3:21 am
Posts: 16
1) download and install mod_html
2) copy and paste asiby's code into the HTML field
3) make sure the module is published

Thats it. i got it working following those steps. Hope it works for you.
Good Luck!
David


Top
 Profile  
 
 Post subject: Re: A2billing Joomla integration
PostPosted: Thu Jan 14, 2010 5:01 pm 
Offline

Joined: Thu May 15, 2008 1:29 pm
Posts: 70
Location: Miami
I like this idea, however when a customer log in it navigate away from the joomla website. How can I use this module and open the customer page inside the website, like when using wrapper?


Top
 Profile  
 
 Post subject: Re: A2billing Joomla integration
PostPosted: Fri Jan 15, 2010 1:41 am 
Offline

Joined: Thu May 15, 2008 1:29 pm
Posts: 70
Location: Miami
What I meant is, when I use wrapper it opens inside, but if I use mod_html with asiby's code it opens in the same browser, but outside my website just like going directly to the a2b server. Is this the normal behavior of mod_html or I am doing something wrong?


Top
 Profile  
 
 Post subject: Re: A2billing Joomla integration
PostPosted: Thu Mar 25, 2010 4:02 am 
Offline

Joined: Tue Apr 21, 2009 11:00 pm
Posts: 18
I came across another addon for Joomla that is meant to bridge Joomla with many other programs. It's called JFusion http://www.jfusion.org and it currently can bridge to 12+ other applications (using Plugins for each app) right now. It comes with very detailed API instructions on how to create plugins. Anybody want to take a crack at it?


Top
 Profile  
 
 Post subject: Re: A2billing Joomla integration
PostPosted: Thu Dec 29, 2011 1:58 pm 
Offline

Joined: Wed Jun 04, 2008 7:57 pm
Posts: 13
Component for integration a2billing customer in joomla

http://magnussolution.com/es/com_magnus.zip


Top
 Profile  
 
 Post subject: Re: A2billing Joomla integration
PostPosted: Tue Jan 24, 2012 3:12 am 
Offline

Joined: Sun Jan 20, 2008 12:00 am
Posts: 71
anyone tested the magnus component?


Top
 Profile  
 
 Post subject: Re: A2billing Joomla integration
PostPosted: Sat Mar 03, 2012 8:58 pm 
Offline

Joined: Tue Jun 22, 2010 8:37 pm
Posts: 152
I did install this component but nothing appears on the admin panel.

Regards.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 19 posts ]  Go to page 1, 2  Next
Hosted Voice Broadcast


All times are UTC


Who is online

Users browsing this forum: No registered users and 3 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