Skip to content

Instantly share code, notes, and snippets.

@trofimovdigital
trofimovdigital / Bitrix - Serialize fields
Created October 24, 2020 12:19 — forked from zetrider/Bitrix - Serialize fields
Преобразование сериализованных массивов в базе данных Битрикс после изменения кодировки
<?
/* Массив таблиц и стобцов с сериализованными данными которые удалось найти */
$arDB = array(
'b_component_params' => 'PARAMETERS',
'b_event' => 'C_FIELDS',
'b_event_log' => 'DESCRIPTION',
'b_event_message' => 'ADDITIONAL_FIELD',
'b_group' => 'SECURITY_POLICY',
'b_iblock_element_property' => 'VALUE',
'b_iblock_fields' => 'DEFAULT_VALUE',
#!/bin/bash
# path to PEM or CRT file
IN="/path-to-cert/file.crt"
OUT="$(openssl x509 -inform PEM -subject_hash_old -in $IN | head -1).0"
cat $IN > $OUT
openssl x509 -inform PEM -text -in $IN -out /dev/null >> $OUT
# adb root
#!/bin/bash
# Compiled by following instructions on https://wiki.cacert.org/FAQ/ImportRootCert
ADB="/home/christian/android-sdk-linux/platform-tools/adb"
ROOT_CRT="cacert-root.crt"
INT_CRT="cacert-class3.crt"
curl -o "$ROOT_CRT" "https://www.cacert.org/certs/root.crt"
curl -o "$INT_CRT" "https://www.cacert.org/certs/class3.crt"