Call us now! +44 (0) 2037347158 | Visit sbzsystems.co.uk
Here’s an example that has will show you how to programmatically select a TTreeView node via index number
1 2 3 4 5 6 7 8 9 | for i:=0 to TreeView1.Items.Count - 1 do begin if TreeView1.Items[i].SelectedIndex = indexno then begin TreeView1.Select(TreeView1.Items[i]); TreeView1.SetFocus; break; end; end; |
Bellow is a firebird SQL script that will help you easily to change the character set of all varchar fields of a database.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | execute block returns (fieldname char(1000),fieldlength int) as declare cur cursor for ( select T1.RDB$FIELD_NAME, T1.RDB$FIELD_LENGTH from RDB$FIELDS T1, RDB$RELATION_FIELDS T2 where T1.RDB$FIELD_TYPE = 37 and T2.RDB$VIEW_CONTEXT is null and T1.RDB$FIELD_NAME = T2.RDB$FIELD_SOURCE and T1.RDB$CHARACTER_SET_ID<>4 and not T2.RDB$RELATION_NAME like 'RDB$%' and not T2.RDB$RELATION_NAME like 'MON$%' ); begin open cur; while (1=1) do begin fetch cur into fieldname, fieldlength; update RDB$FIELDS set RDB$CHARACTER_SET_ID = 4, RDB$FIELD_LENGTH = :fieldlength*4, RDB$CHARACTER_LENGTH = :fieldlength where RDB$FIELD_NAME = :fieldname; if (row_count = 0) then leave; suspend; end close cur; end |
If each time you try to open monitor recordings on Elastix you receive the message 404 File not found!, this is a simple solution for the issue (worked for elastix-2.5.0-1): Go to
1 | /var/www/html/modules/monitoring |
and edit index.php On line 384 insert the line:
1 | $namefile=str_replace(" ","+",$namefile); |
so it will look like that:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | ... if (is_null($record) || !preg_match('/^[[:digit:]]+\.[[:digit:]]+$/', $record)) { // Missing or invalid uniqueid Header('HTTP/1.1 404 Not Found'); die("<b>404 "._tr("no_file")." </b>"); } // Check record is valid and points to an actual file $namefile=str_replace(" ","+",$namefile); $filebyUid = $pMonitoring->getAudioByUniqueId($record, $namefile); if (is_null($filebyUid) || count($filebyUid) <= 0) { // Uniqueid does not point to a record with specified file Header('HTTP/1.1 404 Not Found'); die("<b>404 "._tr("no_file")." </b>"); } ... |
save it.
Change default sip port from 5060 to something else for example 11333.
1 2 | cd /etc/asterisk nano sip_general_custom.conf |
add the following to the file:
1 | bindport=5060 |
(Change 5060 to your new port).
1 2 | amportal stop amportal start |
Don’t forget to add the new port into Fail2Ban.
1 2 | cd /etc/fail2ban nano jail.local |
Define the new port on firewall Disable unused rules and add a one with the new port Reduce […]
In order to set up the customer display of Wincor Nixdorf Ba63 and Ba64 models (BA64_Operating_Manual_english.pdf) follow these steps: 1. Install spos.exe (activate the option for RS232 device connector during EMDI installation). 2. Edit (with any notepad) the file sposbridge.ini (in EMDI installation folder) to look like the following (copy and paste):
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | [Display] hexcommands_line2=$1b$5b$32$3b$30$31$48 hexcommands_line1=$1b$5b$31$3b$30$31$48 oem=0 datafolder=C:\Users\user\AppData\Local\Temp\ epson_mode=0 keyword_change=Change keyword_total=Value only_numbers=0 ad5= ad4= ad3= ad2= * EMDI RESTAURANT * ad1= * SBZ SYSTEMS * maintext=Next Customer currencychar=€ totaltitle=Total charsperline=20 parity=Odd stopbits=1 databits=8 BaudRate=9600 Port=COM1 Title=Display |
3. User […]
TablePress cache saved on database. So in order to delete it you have to execute:
1 2 3 4 | delete FROM `wp_options` where option_name like '_transient_tablepress_c%' or option_name like '_transient_timeout_tablepress_c%' |
After a successful ubuntu installation type the following:
1 2 3 4 5 6 7 | apt-get update && apt-get -y upgrade apt-get install -y unzip cd /tmp wget --no-check-certificate -O installer.tgz "https://github.com/servisys/ispconfig_setup/tarball/master" tar zxvf installer.tgz cd *ispconfig* bash install.sh |
Source: https://www.howtoforge.com/tutorial/ispconfig-automated-install-script/
After a successful centos installation type the following:
1 2 3 | yum update yum -y install wget wget -O - http://repo.issabel.org/issabel4-netinstall.sh | bash |
Source: https://forum.issabel.org/d/1145-install-in-a-vps
If you try to install Let’s Encrypt certificate via Issabel web interface and it is failed you can installed from ssh.
1 2 | cd \etc letsencrypt certonly --standalone -d sbz-tel.freeextra.com |
If you get the message “Problem binding to port 80: Could not bind to IPv4 or IPv6.” try
1 2 3 4 | service httpd stop cd /etc letsencrypt certonly --standalone -d yourdomain.com service httpd start |
After the certification creation via ssh, you can renew it easily via web interface.
This is a simple cronJob to send automatic a custom CDR email every 10 minutes that will include all missed calls of this period. Create a php file named missed_calls.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 | <?php //error_reporting(0); /*------------------------------------------------------------------------ # copyright Copyright (C) 2018 sbzsystems.com. All Rights Reserved. # @license - http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL # Websites: https://www.sbzsystems.com -------------------------------------------------------------------------*/ header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 header('Content-Type: text/html; charset=UTF-8'); //error_reporting(0); $host = 'localhost'; $user = 'root'; $password = 'XXXXXXXX'; $db = 'asteriskcdrdb'; $logfile='/usr/local/issabel/missed_calls.log'; // Connects to your Database $link=mysqli_connect("$host", $user, $password) or die(mysqli_error($link)); mysqli_select_db($link,"$db") or die(mysqli_error($link)); mysqli_set_charset($link,'utf8'); //GET SQL TIME INTERVAL 10 MINUTE $query=" select calldate AS Timestamp, src AS CallerID from cdr where calldate > date_sub(now(), interval 1 MINUTE) /*and dst=600*/ group by CallerID, Timestamp "; $data = mysqli_query($link,$query) or die(mysqli_error($link)); //AND disposition like 'NO ANSWER' $txt=''; while($alldata = mysqli_fetch_array( $data )) { if (strlen($alldata['CallerID'])>5) { $txt=$txt. $alldata['Timestamp'].' <a href="tel:'.$alldata['CallerID'].'">'.$alldata['CallerID'].'</a><br>'; } } // mysqli_close($link); //file_put_contents($logfile, '#'.$txt.'#'.$query.'#'."\n", FILE_APPEND | LOCK_EX); if ($txt) { $to = "info@bikemall.gr"; $subject = "Missed calls"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= "From: info@bikemall.gr" . "\r\n"; mail($to,$subject,$txt,$headers); } ?> |
and store it here
1 | /usr/local/issabel |
Finally create an every minute cronjob named missed_calls.cron
1 | * * * * * root /usr/bin/php -q /usr/local/issabel/missed_calls.php |
and store it here
1 | /etc/cron.d/ |
