Application PrepaidAuthCID

Application PrepaidAuthCID

Description

This application takes as an argument a CALLERID such as “${CALLERIDNUM}”, it will then authenticate the callerid against a database.

How it works

PrepaidAuthCID does a database lookup for the given CallerID – the standard query for this is “SELECT card.cardid, credit, tariffid, activated, startpulse, frequency, announcement, card.ccprefix, card.resellerid, card.language FROM card LEFT JOIN cid USING ( cardid ) LEFT JOIN cardtype ON card.cardtypeid = cardtype.cardtypeid WHERE cid = ‘%s’ AND activated=0 AND payed=0”.
– If it finds a valid entry, then it will:

• Set channel variables (REPAID-CARDID, PREPAID-TARIFFID, PREPAID-CREDIT, PREPAID-STARTPULSE, PREPAID-FREQUENCY, PREPAID-ANNOUNCEMENT, PREPAID-CCPREFIX, PREPAID-RESELLERID)
• Jumps to the priority + 200 where then the application PrepaidCall have to be

– If an entry exists – but the card have zero balance