Skip to content

Instantly share code, notes, and snippets.

View VeroLom's full-sized avatar

Nickie VeroLom

View GitHub Profile

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:

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};
}
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
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,