Skip to content

Instantly share code, notes, and snippets.

View VeroLom's full-sized avatar

Nickie VeroLom

View GitHub Profile
'CREATE TABLE IF NOT EXISTS
pages (id INT NOT NULL AUTO_INCREMENT,
parent_id INT NOT NULL DEFAULT 0,
level INT NOT NULL DEFAULT 0,
lkey INT NOT NULL DEFAULT 0,
rkey INT NOT NULL DEFAULT 0,
user_id INT NOT NULL DEFAULT 0,
href VARCHAR(255) NOT NULL,
title VARCHAR(255) NOT NULL,
header VARCHAR(255) NOT NULL,
CREATE TABLE IF NOT EXISTS
pages (id INT NOT NULL AUTO_INCREMENT,
parent_id INT NOT NULL DEFAULT 0,
level INT NOT NULL DEFAULT 0,
lkey INT NOT NULL DEFAULT 0,
rkey INT NOT NULL DEFAULT 0,
user_id INT NOT NULL DEFAULT 0,
href VARCHAR(255) NOT NULL,
title VARCHAR(255) NOT NULL,
header VARCHAR(255) NOT NULL,
CREATE TABLE IF NOT EXISTS
pages (id INT NOT NULL AUTO_INCREMENT,
parent_id INT NOT NULL DEFAULT 0,
level INT NOT NULL DEFAULT 0,
lkey INT NOT NULL DEFAULT 0,
rkey INT NOT NULL DEFAULT 0,
user_id INT NOT NULL DEFAULT 0,
href VARCHAR(255) NOT NULL,
title VARCHAR(255) NOT NULL,
header VARCHAR(255) NOT NULL,
SELECT `number`, `descr`, `type`
FROM `user_contact` AS `c`, `user_contact_rel` AS `r`
WHERE `r`.`user_contact_id` = `c`.`id` AND
`r`.`user_id` = 3
ORDER BY `type`;
SELECT `number`, `descr`, `type`
FROM `user_contact` AS `contact`
JOIN `user_contact_rel` AS `rel` ON `rel`.`user_contact_id` = `contact`.`id`
WHERE `rel`.`user_id` = 3
if(defined($data->{passwd_reset})) {
if($data->{passwd_reset} eq 'on') {
$data->{passwd_reset} = 1;
} else {
$data->{passwd_reset} = 0;
}
} else {
delete $data->{passwd_reset};
}

Keybase proof

I hereby claim:

  • I am VeroLom on github.
  • I am verolom (https://keybase.io/verolom) on keybase.
  • I have a public key whose fingerprint is 96C6 BBE8 E430 A4BA 48AB F933 78EC 1028 00A0 748B

To claim this, I am signing this object:

<div class="sppb-addon sppb-addon-ajax-contact ">
<div class="sppb-addon-content">
<form class="sppb-ajaxt-contact-form">
<div class="sppb-form-group input">
<input type="text" name="name" class="input-field sppb-form-control" id="input-name" required="required" />
<label class="input-label" for="input-name">
<span class="input-label-content">Name</span>
</label>
</div>
<div class="sppb-form-group input">
@VeroLom
VeroLom / gsom-menu-main.html
Created July 20, 2017 13:12
Меню GSoM
<ul>
<li>
<a href="/programmes/">ПРОГРАММЫ ОБУЧЕНИЯ</a>
<ul>
<li>
<a href="/programmes/bachelor/">Бакалавриат</a>
<ul>
<li><a href="/programmes/bachelor/international_management/">Программа &laquo;Международный менеджмент&raquo;</a></li>
<li><a href="/programmes/bachelor/menedzhment/">Программа &laquo;Менеджмент&raquo;</a></li>
<li><a href="/programmes/bachelor/public_management/">Программа &laquo;Государственное и муниципальное управление&raquo;</a></li>
@VeroLom
VeroLom / .xs
Last active October 3, 2017 23:29
XSLT menu
<?xml version="1.0"?>
<xsl:stylesheet version="1.0">
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="udata[@module = 'content' and @method = 'menu']">
<ul>
<xsl:apply-templates select="items/item" />
</ul>
</xsl:template>
@VeroLom
VeroLom / emerge.log
Created May 1, 2018 17:45
Gentoo conflicts
localhost ~ # emerge -avu qgis
These are the packages that would be merged, in order:
Calculating dependencies... done!
[ebuild N ] dev-db/spatialite-4.3.0a::gentoo USE="geos iconv proj xls xml {-test}" 4 337 KiB
[ebuild NS ] net-libs/libsrtp-1.6.0:0/1::gentoo [2.1.0:2/1::gentoo] USE="-aesicm -console -debug -doc -libressl -openssl -static-libs -syslog {-test}" ABI_X86="(64) -32 (-x32)" 1 611 KiB
[ebuild U ] dev-python/setuptools-38.5.1::gentoo [36.5.0::gentoo] USE="{-test}" PYTHON_TARGETS="python2_7 python3_5* -pypy -pypy3 -python3_4* -python3_6" 721 KiB
[ebuild U ] dev-python/certifi-2017.11.5::gentoo [2017.7.27.1::gentoo] PYTHON_TARGETS="python2_7 python3_5* -pypy -pypy3 -python3_4* -python3_6" 322 KiB
[ebuild N ] dev-util/meson-0.45.1::gentoo PYTHON_TARGETS="python3_5 -python3_6" 1 137 KiB