’10’ – Eduguru

get the last 7 characters of a PHP string

December 8, 2018 by eduguru

get the last 7 characters of a PHP string Use substr() with a negative number for the 2nd argument. $newstring = substr($dynamicstring, -7); string substr ( string $string , int $start [, int $length ] ) If start is negative, the returned string will start at the start’th character from the end of string Example: <?php echo … Read more

Asterisk cmd MYSQL

June 6, 2014 by eduguru

This is an ADD-ON of asterisk, is not installed by default and must be downloaded and installed with the asterisk-addons package. However, in Asterisk 1.8 the addons have been integrated back into Asterisk. MYSQL(): Basic MYSQL Database Functionality (note that the help information returned from ‘show application MYSQL’ is a little misleading – what’s shown … Read more

vicidial / extras / MySQL_AST_CREATE_tables.sql

October 10, 2013 by eduguru

CREATE TABLE phones ( extension VARCHAR(100), dialplan_number VARCHAR(20), voicemail_id VARCHAR(10), phone_ip VARCHAR(15), computer_ip VARCHAR(15), server_ip VARCHAR(15), login VARCHAR(15), pass VARCHAR(10), status VARCHAR(10), active ENUM(‘Y’,’N’), phone_type VARCHAR(50), fullname VARCHAR(50), company VARCHAR(10), picture VARCHAR(19), messages INT(4), old_messages INT(4), protocol ENUM(‘SIP’,’Zap’,’IAX2′,’EXTERNAL’) default ‘SIP’, local_gmt VARCHAR(6) default ‘-5.00’, ASTmgrUSERNAME VARCHAR(20) default ‘cron’, ASTmgrSECRET VARCHAR(20) default ‘1234’, login_user VARCHAR(20), login_pass … Read more