Author Archive

Rewrite Express Engine Urls

<IfModule mod_rewrite.c>

# Enable Rewrite Engine
# ------------------------------
RewriteEngine On
RewriteBase /

# Redirect index.php Requests
# ------------------------------
RewriteCond %{THE_REQUEST} ^GET.*index\.php [NC]
RewriteCond %{THE_REQUEST} !/system/.*
RewriteRule (.*?)index\.php/*(.*) /$1$2 [R=301,L]

# Standard ExpressionEngine Rewrite
# ------------------------------
RewriteCond $1 !\.(css|js|gif|jpe?g|png) [NC]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /index.php/$1 [L]

</IfModule>

Add Mysql Database Table Using WordPress Theme or Plugin (Works with multisite)

global $senormedia_jal_db_version;
$senormedia_jal_db_version = '1.0';

function senormedia_jal_install() {
	global $wpdb;
	global $senormedia_jal_db_version;

	$table_name = $wpdb->prefix.'_subscriptions';
	$charset_collate = $wpdb->get_charset_collate();

	$sql = "CREATE TABLE $table_name (
    subscribe_id int(11) NOT NULL auto_increment,
		site_id  varchar(500)  NOT NULL,
    email  varchar(500)  NOT NULL,
    status	varchar(256)	NOT NULL,
    url	varchar(256)	NOT NULL,
    date timestamp NOT NULL default CURRENT_TIMESTAMP,
		PRIMARY KEY  (subscribe_id)
	) $charset_collate;";

	require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
	$eeor = dbDelta( $sql );

	add_option( 'senormedia_jal_db_version', $senormedia_jal_db_version );
}

register_activation_hook( __FILE__, 'senormedia_jal_install' );

function myplugin_update_db_check_senormedia() {
    global $senormedia_jal_db_version;
    if ( get_site_option( 'senormedia_jal_db_version' ) != $senormedia_jal_db_version ) {
        senormedia_jal_install();
    }
}
add_action( 'plugins_loaded', 'myplugin_update_db_check_senormedia' );

How to delete all unpublished commands on Drupal using sql

DELETE c, rcb, dcb
FROM
    comment AS c
JOIN field_revision_comment_body AS rcb ON (c.cid = rcb.entity_id)
JOIN field_data_comment_body AS dcb ON (rcb.entity_id = dcb.entity_id)
WHERE
    c. STATUS = 0

or

DELETE FROM field_data_comment_body USING field_data_comment_body JOIN comment ON comment.cid=field_data_comment_body.entity_id AND comment.status=0
DELETE FROM field_revision_comment_body USING field_revision_comment_body JOIN comment ON comment.cid=field_revision_comment_body.entity_id AND comment.status=0
DELETE FROM comment WHERE status=0

Thank you pkosenko

https://www.drupal.org/forum/general/general-discussion/2010-05-16/mass-delete-spam-comments#comment-10964889

Execute bash script from URL on Linux command line

source <(curl -s https://senormedia.com/bash.sh)
bash <(curl -s https://senormedia.com/bash.sh)

Install with curl as well pass arguments

curl -s https://senormedia.com/bash.sh | bash -s arg1 arg2
Flag "-s" makes shell read from stdin.
bash <(wget -qO- https://senormedia.com/bash.sh)
wget -O - https://senormedia.com/bash.sh| bash

Install firmware Linux Debian Buster or Stretch

Go to link https://www.debian.org/releases/stable/armel/ch06s04.html.en

extract zip

open terminal in folder or cd into directory of firmware tar

sudo dpkg -i *.deb

basically, what this does is fills in the rest of the name in place of the * character. You may encounter an error saying dependencies not met, if you see this then you can run

sudo apt-get install -f

View Some Of Our Services