kuzminT’s gists

kuzminT / postgresql-set-id-seq.sql

Created June 16, 2021 09:57 — forked from henriquemenezes/postgresql-set-id-seq.sql

PostgreSQL set Next ID Sequence Value to MAX(id) from Table

	-- Get Max ID from table
	SELECT MAX(id) FROM table;

	-- Get Next ID from table
	SELECT nextval('table_id_seq');

	-- Set Next ID Value to MAX ID
	SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));

kuzminT / pymysql_examples.py

Last active May 29, 2019 20:02

Examples for pymysql lib with python 3

	""""
	:link: https://github.com/PyMySQL/PyMySQL
	"""""

	import pymysql
	import pymysql.cursors

	connection = pymysql.connect(host="localhost",
	user="root",
	password="1234",

kuzminT / python_web_scrapping.md

Last active January 3, 2021 18:13

Scrappers, parsers, crawlers. Scrapping websites with python. Tips and usefool links

kuzminT / wp_sanitize_file_name.php

Created March 19, 2019 09:26 — forked from edirpedro/wp_sanitize_file_name.php

Translit file names to simple chars, this prevent WordPress to allow accents and special chars at file names that breaks in some server's configuration.

	/*
	* Translit file names to simple chars,
	* this prevent accents and special chars at file names.
	***********************************************************************/
	function my_sanitize_file_name($filename) {
	return remove_accents($filename);
	}
	add_filter('sanitize_file_name', 'my_sanitize_file_name');

	/*

kuzminT / functions.php

Created February 13, 2019 14:51 — forked from i-like-robots/functions.php

Wordpress custom comment form

	<?php
	/**
	* Comment form hidden fields
	*/
	function comment_form_hidden_fields()
	{
	comment_id_fields();

	if ( current_user_can( 'unfiltered_html' ) )
	{

kuzminT / autoloader.php

Last active February 8, 2019 20:40

PSR-4 autoloader example

	<?php
	/**
	* An example of a project-specific implementation.
	*
	* After registering this autoload function with SPL, the following line
	* would cause the function to attempt to load the \Foo\Bar\Baz\Qux class
	* from /path/to/project/src/Baz/Qux.php:
	*
	*
	* new \Foo\Bar\Baz\Qux;

kuzminT / JS getCookie(), setCookie(), deleteCookie()

Created February 8, 2019 11:05 — forked from akaramires/JS getCookie(), setCookie(), deleteCookie()

	// getCookie(), setCookie(), deleteCookie()


	// возвращает cookie если есть или undefined
	function getCookie(name) {

	var matches = document.cookie.match(new RegExp(
	"(?:^\|; )" + name.replace(/([\.$?\|{}\[\]\\\/\+^])/g, '\\$1') + "=([^;])"
	))
	return matches ? decodeURIComponent(matches[1]) : undefined

kuzminT / gist:793f516ef268785f8078377bb528b41f

Created February 6, 2019 09:31 — forked from ivandoric/gist:e4e46294c4d35eac0ec8

wordpress: create custom reset password page

	<?php //Add all of this tu custom page template ?>
	<?php
	global $wpdb;

	$error = '';
	$success = '';

	// check if we're in reset form
	if( isset( $_POST['action'] ) && 'reset' == $_POST['action'] )
	{

kuzminT / like-it-enqueue.php

Created January 30, 2019 13:01 — forked from shizhua/like-it-enqueue.php

Add a like button without a plugin in WordPress

	add_action( 'wp_enqueue_scripts', 'pt_like_it_scripts' );
	function pt_like_it_scripts() {
	if( is_single() ) {

	wp_enqueue_style( 'like-it', trailingslashit( plugin_dir_url( __FILE__ ) ).'css/like-it.css' );

	if (!wp_script_is( 'jquery', 'enqueued' )) {
	wp_enqueue_script( 'jquery' );// Comment this line if you theme has already loaded jQuery
	}
	wp_enqueue_script( 'like-it', trailingslashit( plugin_dir_url( __FILE__ ) ).'js/like-it.js', array('jquery'), '1.0', true );

kuzminT / 20-xdebug.ini

Last active May 1, 2019 13:41

Php tips, docs and usefool links

	## Example config for xdebug ini. Use with phpstorm ide.

	zend_extension=xdebug.so
	xdebug.remote_enable = on
	xdebug.remote_connect_back = on
	xdebug.remote_host="localhost"
	xdebug.remote_port=9010
	xdebug.idekey="PHPSTORM"
	xdebug.remote_handler=dbgp
	xdebug.remote_autostart=1

Tim kuzminT