asterisk2billing.org
http://forum.asterisk2billing.org/

A2B_entity_Password
http://forum.asterisk2billing.org/viewtopic.php?f=33&t=10931
Page 1 of 1

Author:  raykt [ Thu Sep 11, 2014 12:20 am ]
Post subject:  A2B_entity_Password

I am trying to update both cc_card and cc_sip_buddies with same password once the user changed .

SQL Query(Work)
update cc_card A1 inner join cc_sip_buddies A2 on A1.ID = A2.ID_CC_Card set A2.secret=1234,A1.uipass=1234 where A1.id=1;


For PHP,

$QUERY = "UPDATE cc_card A1 inner join cc_sip_buddis A2 on A1.ID=A2.ID_CC_Card SET A1.uipass= ".$NewPassword."',A2.secret='".$NewPassword."' WHERE ( A1.ID = ".$_SESSION["card_id"]." ) ";

When I tried it, it shows update successfully but it is not updating in..

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/