František Kocúrik frkosk

## Change categories for products
-- Definovanie produktov a kategórií ako reťazce
SET @product_ids = '1,2,3';
SET @category_ids = '10,20,30';

-- Definovanie predvolenej kategórie
SET @default_category_id = 10;

-- Vloženie nových kategórií pre produkty
INSERT INTO ps_category_product (id_category, id_product, position)
SELECT

## gist:936741d31425ea5b2dff5501c5d18cfd

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                frkosk
                / gist:936741d31425ea5b2dff5501c5d18cfd
            
            
              Last active
              April 23, 2024 17:00
            
              
                PRESTASHOP 1.6.X ADMIN ERROR 500
              
          
    PRESTASHOP 1.6.X ADMIN ERROR 500

A common error that could appear after you install prestashop is
Fatal error: Declaration of AdminLoginControllerCore::viewAccess() must be compatible with AdminControllerCore::viewAccess($disable = false) in /var/www/prestashop/controllers/admin/AdminLoginController.php on line 27

or, if you haven’t set prestashop into dev mode, you’ll get a 500 error.
The way to fix this is simple:


## db_clean.sql
/* Delete connections statistics report: Execute SQL Query */
TRUNCATE TABLE ps_connections;
TRUNCATE TABLE ps_connections_source;
TRUNCATE TABLE ps_connections_page;
TRUNCATE TABLE ps_guest;

/* Delete Prestashop Logs: Execute SQL Query */
TRUNCATE TABLE ps_log;

/* Delete Prestashop Referrer statistics report: Execute SQL Query */

## Byte Formatting for Google Sheets.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                frkosk
                / Byte Formatting for Google Sheets.md
            
            
              Created
              August 6, 2019 06:01
                — forked from loganvolkers/Byte Formatting for Google Sheets.md
            
              
                Byte formatting for Google Sheets
              
          
    Custom format for displaying bytes as kb, mb, gb or tb.
Response to a few places on the internet: https://productforums.google.com/forum/#!topic/docs/x_T_N-yRUYg
And here: https://stackoverflow.com/questions/1533811/how-can-i-format-bytes-a-cell-in-excel-as-kb-mb-gb-etc
Here is one that I have been using:
[<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"


## sample.js
// define setState object based on string reference

const stateNameInString = 'MyState';

const Obj = {};
Obj[stateNameInString] = 'bla bla';
this.setState(Obj);

// OR

## functions.php
<?php
function custom_recaptcha_enqueue_scripts() {
	wp_deregister_script( 'google-recaptcha' );

	$url = 'https://www.google.com/recaptcha/api.js';
	$url = add_query_arg( array(
		'onload' => 'recaptchaCallback',
		'render' => 'explicit',
	 	'hl' => 'sk-SK' ), $url );

## gist:f9091b6a044c32e7077a958847079f9e
UPDATE ps_product_shop SET wholesale_price=0.88, price=0.88 WHERE id_product IN (SELECT id_product FROM ps_product WHERE reference='19-ir8');
UPDATE ps_product SET wholesale_price=0.88, price=0.88 WHERE reference='19-ir8';

## index.html
<!DOCTYPE html>
<html lang="">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>Title Page</title>
    </head>
    <body>
      <canvas id="canvas"></canvas>

## input_checkbox_switch.html
<input class="switch" type="checkbox">

## get ID
function getID () {
  // Math.random should be unique because of its seeding algorithm.
  // Convert it to base 36 (numbers + letters), and grab the first 9 characters
  // after the decimal.
  return '_' + Math.random().toString(36).substr(2, 9);
};
	-- Definovanie produktov a kategórií ako reťazce
	SET @product_ids = '1,2,3';
	SET @category_ids = '10,20,30';

	-- Definovanie predvolenej kategórie
	SET @default_category_id = 10;

	-- Vloženie nových kategórií pre produkty
	INSERT INTO ps_category_product (id_category, id_product, position)
	SELECT
	/* Delete connections statistics report: Execute SQL Query */
	TRUNCATE TABLE ps_connections;
	TRUNCATE TABLE ps_connections_source;
	TRUNCATE TABLE ps_connections_page;
	TRUNCATE TABLE ps_guest;

	/* Delete Prestashop Logs: Execute SQL Query */
	TRUNCATE TABLE ps_log;

	/* Delete Prestashop Referrer statistics report: Execute SQL Query */
	// define setState object based on string reference

	const stateNameInString = 'MyState';

	const Obj = {};
	Obj[stateNameInString] = 'bla bla';
	this.setState(Obj);

	// OR
	<?php
	function custom_recaptcha_enqueue_scripts() {
	wp_deregister_script( 'google-recaptcha' );

	$url = 'https://www.google.com/recaptcha/api.js';
	$url = add_query_arg( array(
	'onload' => 'recaptchaCallback',
	'render' => 'explicit',
	'hl' => 'sk-SK' ), $url );
	UPDATE ps_product_shop SET wholesale_price=0.88, price=0.88 WHERE id_product IN (SELECT id_product FROM ps_product WHERE reference='19-ir8');
	UPDATE ps_product SET wholesale_price=0.88, price=0.88 WHERE reference='19-ir8';
	<!DOCTYPE html>
	<html lang="">
	<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<title>Title Page</title>
	</head>
	<body>
	<canvas id="canvas"></canvas>
	function getID () {
	// Math.random should be unique because of its seeding algorithm.
	// Convert it to base 36 (numbers + letters), and grab the first 9 characters
	// after the decimal.
	return '_' + Math.random().toString(36).substr(2, 9);
	};