<?php
$arr = array(
'057.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.kharkov', 'ios' => 'https://itunes.apple.com/us/app/har-kov-city-guide/id791324172?mt=8'),
'048.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.odessa', 'ios' => 'https://itunes.apple.com/us/app/odessa-city-guide/id791324468?mt=8'),
'62.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.donetsk', 'ios' => 'https://itunes.apple.com/us/app/doneck-city-guide/id791324716?mt=8'),
'061.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.zaporojie', 'ios' => 'https://itunes.apple.com/us/app/zaporoz-e-city-guide/id791334505?l=ru&ls=1&mt=8'),
'0652.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.simferopol', 'ios' => 'https://itunes.apple.com/us/app/simferopol-city-guide/id791334772?l=ru&ls=1&mt=8'),
'0642.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.lugansk', 'ios' => 'https://itunes.apple.com/us/app/lugansk-city-guide/id791331778?l=ru&ls=1&mt=8'),
'032.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.lviv', 'ios' => 'https://itunes.apple.com/us/app/l-viv-city-guide/id791340901?l=ru&ls=1&mt=8'),
'0512.com.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.nikolaev', 'ios' => 'https://itunes.apple.com/us/app/nikolaev-city-guide/id791340923?l=ru&ls=1&mt=8'),
'0564.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.krivoirog', 'ios' => 'https://itunes.apple.com/us/app/krivoj-rog-city-guide/id791341424?l=ru&ls=1&mt=8'),
'056.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.dnepropetrovsk', 'ios' => 'https://itunes.apple.com/us/app/dnepropetrovsk-city-guide/id791331539?mt=8'),
'go31.ru'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.belgorod', 'ios' => 'https://itunes.apple.com/us/app/belgorod-city-guide/id791478926?l=ru&ls=1&mt=8'),
'0472.ua'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.cherkassi', 'ios' => 'https://itunes.apple.com/us/app/cerkassy-city-guide/id791478998?l=ru&ls=1&mt=8'),
'goroddomodedovo.ru'=>array('android' => 'https://play.google.com/store/apps/details?id=ua.com.citysites.domodedovo', 'ios' => 'https://itunes.apple.com/us/app/domodevo-city-guide/id791471674?l=ru&ls=1&mt=8')
);
foreach($arr as $k => $v ){
$s = serialize($v);
echo "UPDATE `citysites`.`cis_sites` SET `mobile_app_urls` = '".$s."' WHERE `url`.`url` = '".$k."';".PHP_EOL;
}
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 77) Position 1 = 2, Position 2 = 15
Branch analysis from position: 2
2 jumps found. (Code = 78) Position 1 = 3, Position 2 = 15
Branch analysis from position: 3
1 jumps found. (Code = 42) Position 1 = 2
Branch analysis from position: 2
Branch analysis from position: 15
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 15
filename: /in/KfPa9
function name: (null)
number of ops: 17
compiled vars: !0 = $arr, !1 = $v, !2 = $k, !3 = $s
line #* E I O op fetch ext return operands
-------------------------------------------------------------------------------------
2 0 E > ASSIGN !0, <array>
18 1 > FE_RESET_R $5 !0, ->15
2 > > FE_FETCH_R ~6 $5, !1, ->15
3 > ASSIGN !2, ~6
19 4 INIT_FCALL 'serialize'
5 SEND_VAR !1
6 DO_ICALL $8
7 ASSIGN !3, $8
20 8 CONCAT ~10 'UPDATE+%60citysites%60.%60cis_sites%60+SET+%60mobile_app_urls%60+%3D+%27', !3
9 CONCAT ~11 ~10, '%27+WHERE+%60url%60.%60url%60+%3D+%27'
10 CONCAT ~12 ~11, !2
11 CONCAT ~13 ~12, '%27%3B'
12 CONCAT ~14 ~13, '%0A'
13 ECHO ~14
18 14 > JMP ->2
15 > FE_FREE $5
21 16 > RETURN 1
Generated using Vulcan Logic Dumper, using php 8.0.0
preferences:
148.27 ms | 1386 KiB | 15 Q