Skip to content

Instantly share code, notes, and snippets.

View puneetkay's full-sized avatar

Puneet Kalra puneetkay

View GitHub Profile
@puneetkay
puneetkay / my.cnf
Created June 24, 2021 19:57 — forked from fevangelou/my.cnf
Optimized my.cnf configuration for MySQL/MariaSQL (on Ubuntu, CentOS etc. servers)
# === Optimized my.cnf configuration for MySQL/MariaSQL (on Ubuntu, CentOS etc. servers) ===
#
# by Fotis Evangelou, developer of Engintron (engintron.com)
#
# ~ Updated February 2021 ~
#
#
# The settings provided below are a starting point for a 8-16 GB RAM server with 4-8 CPU cores.
# If you have different resources available you should adjust accordingly to save CPU, RAM & disk I/O usage.
#
@puneetkay
puneetkay / remove-wp-attachment-thumbs.php
Created October 24, 2017 10:54 — forked from linuslundahl/remove-wp-attachment-thumbs.php
Remove generated attachment thumbnails from wordpress database.
global $wpdb;
$query = "SELECT meta_value, meta_id FROM $wpdb->postmeta WHERE meta_key = '_wp_attachment_metadata'";
$result = $wpdb->get_results($query);
foreach ($result as $item) {
$meta = unserialize($item->meta_value);
unset($meta['sizes']);
$wpdb->update( 'wp_vira_postmeta', array('meta_value' => serialize($meta)), array('meta_id' => $item->meta_id) );
}
@puneetkay
puneetkay / uri.js
Created June 2, 2016 09:42 — forked from jlong/uri.js
URI Parsing with Javascript
var parser = document.createElement('a');
parser.href = "http://example.com:3000/pathname/?search=test#hash";
parser.protocol; // => "http:"
parser.hostname; // => "example.com"
parser.port; // => "3000"
parser.pathname; // => "/pathname/"
parser.search; // => "?search=test"
parser.hash; // => "#hash"
parser.host; // => "example.com:3000"
<?php
/**
* A helper class for use in the Symfony Framework. Although there's no restriction to use it in
* any other framework or script. Just the autoloader needs to be setup before using this class.
* Sample code for initializing XenForo from your own script:
*
* <code>
* $startTime = microtime(true);
* $xenforoRoot = '/absolute/path/to/xenforo/root/directory';
@puneetkay
puneetkay / .htaccess
Created December 29, 2013 19:58
Remove index.php from CI
AddType image/svg+xml svg svgz
AddEncoding gzip svgz
# Webfonts
AddType application/vnd.ms-fontobject eot
AddType application/x-font-ttf ttf ttc
AddType font/opentype otf
AddType application/x-font-woff woff
#Gzip
@puneetkay
puneetkay / Controller.php
Last active December 31, 2015 18:59
Get current controller and method in CI. Also, technique to get/manage dynamic global vars
<?php
class CI_Controller {
private static $instance;
public $data = array();
/**
* Constructor
*/
@puneetkay
puneetkay / jquery.center.js
Created December 13, 2013 10:42
Small jQuery plugin for center of parent or window! (Tweaked to set margin instead of position)
jQuery.fn.center = function(parent) {
if (parent) {
parent = $(this).parent();
} else {
parent = window;
}
$(this).css({
"margin-top": ((($(parent).height() - $(this).outerHeight()) / 2) + $(parent).scrollTop() + "px"),
"margin-left": ((($(parent).width() - $(this).outerWidth()) / 2) + $(parent).scrollLeft() + "px")
});
@puneetkay
puneetkay / queryString.js
Created December 13, 2013 10:43
Global JS function to get Query String
window.GetQueryString = function(q) {
return (function(a) {
if (a == "") return {};
var b = {};
for (var i = 0; i < a.length; ++i) {
var p = a[i].split('=');
if (p.length != 2) continue;
b[p[0]] = decodeURIComponent(p[1].replace(/\+/g, " "));
}
return b;
@puneetkay
puneetkay / gist:7811424
Created December 5, 2013 19:12
Tech Specs / Model
Class:
CSSParser
Functions:
1 - minifier()
2 - beautifier()
3 - parser()
Input variables:
$this->input->post('content') OR $_POST['content']
@puneetkay
puneetkay / download.php
Created October 31, 2013 12:55
Force download with php
<?php
function serve_file_resumable ($file, $contenttype = 'application/octet-stream') {
// Avoid sending unexpected errors to the client - we should be serving a file,
// we don't want to corrupt the data we send
@error_reporting(0);
// Make sure the files exists, otherwise we are wasting our time
if (!file_exists($file)) {