Click on export, and choose “custom” export method.
Lets say you want to export first 20 tables only.
Open chrome or browser console [ctrl+shift+j], enter the following:
$("input[name='table_data[]']").slice(0,20).click();
For next 20, use 20,50 as arguments in slice function used above.
The customizer data is stored in table wp_options under option_name theme_mods_THEME-NAME
you can view all such settings via the following query:
SELECT * FROM `wp_options` WHERE `option_name` LIKE "theme_mods_%"
In some cases, you just want to use parent theme’s settings in newly added child theme. If that is your case too, use the following queries to utilize and close those settings for your child theme also.
update `wp_options` set `option_name`="theme_mods_YOURCHILDTHEME_backup" where `option_name`="theme_mods_YOURCHILDTHEME";
insert into `wp_options` (`option_name`,`option_value`,`autoload`) select "theme_mods_YOURCHILDTHEME",`option_value`,"yes" from `wp_options` where `option_name`="theme_mods_PARENTTHEME";
The following one is a bit risky one. If you understand what is going on here, go ahead.
delete from `wp_options` where `option_name`="theme_mods_YOURCHILDTHEME";
insert into `wp_options` (`option_name`,`option_value`,`autoload`) select "theme_mods_YOURCHILDTHEME",`option_value`,"yes" from `wp_options` where `option_name`="theme_mods_PARENTTHEME";
jQuery(document).ready(function(){var header=jQuery("header .fusion-header");var headerHeight=0; var shouldWrite=1;
jQuery(window).on("scroll",function(){
headerHeight=header.height();
console.log(headerHeight);
if(shouldWrite && headerHeight!==undefined){
jQuery("#headerjumpfixer").html(".fusion-header-wrapper.fusion-is-sticky{padding-top:"+headerHeight + "px}");
shouldWrite=0;}
});
jQuery(window).on("resize",function(){shouldWrite=1;});
});
<style id="headerjumpfixer">.fusion-header-wrapper.fusion-is-sticky{padding-top:88px}</style>
Prerequisite:
if you dont have access key, get a pair here :
https://marketplace.magento.com/customer/accessKeys/
php -d memory_limit=-1 /bin/composer create-project --repository-url=https://repo.magento.com/ magento/project-community-edition=2.2.11 ./
In the above command, you can change version/subversion of magento repo. You can also change the install directory
After the successful run of above command:
bin/magento setup:install \
--base-url=https://testmagento.domain.com \
--db-host=localhost \
--db-name=testmage_x1 \
--db-user=testmage_x1 \
--db-password=WEux3dxxxxw \
--admin-firstname=xxx \
--admin-lastname=yyy \
[email protected] \
--admin-user=admin \
--admin-password=WwKhxxxxxxEK \
--language=en_US \
--currency=USD \
--timezone=America/Chicago \
--use-rewrites=1
YOu will see Magento Admin URI: /admin_10lf7y after successful run
Next is installing sample data: totally optional
php -d memory_limit=-1 bin/magento sampledata:deploy
OPtional: install or update composer version
composer self-update --2
https://blog.packagist.com/composer-2-0-is-now-available/
https://getcomposer.org/
Reference: https://docs.nginx.com/nginx/admin-guide/security-controls/configuring-http-basic-authentication/
Requirements: apache2-utils or httpd-tools
Use htpasswd utility and create a .htpasswd file, see reference
htpasswd -c /etc/nginx/.htpasswd usernamethatyouwant
chmod 644 /etc/nginx/.htpasswd
After that, just add lines in nginx conf
location / {
auth_basic "Backend Area";
auth_basic_user_file /etc/nginx/.htpasswd; ## path to your passwd file
## ...
## xyz code
##...
proxy_pass http://127.0.0.1:4000; ## Proxy port for your app
proxy_set_header Authorization ""; ## DONT FORGET THIS. reset the auth header
include proxy.inc;
}
Restart nginx now or test first using “nginx -t”
SELECT * from wp_usermeta where `meta_key` like 'edit_%_per_page'
So probably you chose “Number of items per page” as 1000 or 200 and now the page doesnt load anymore because your database ran out of memory.
If that is the case, run the above query on phpmysql or any other way, edit the numbers and fixed!
$allowed_domains = ["https://www.YOURDOMAIN.com","https://YOURDOMAIN.com","https://staging.YOURDOMAIN.com","https://www.YOURDOMAIN.com/","https://YOURDOMAIN.com/","https://staging.YOURDOMAIN.com/"];
// echo $_SERVER['HTTP_ORIGIN'];
if (in_array($_SERVER['HTTP_ORIGIN'], $allowed_domains)) {
header('Access-Control-Allow-Origin: ' . $_SERVER['HTTP_ORIGIN']);
}
else{
if(in_array($_SERVER['HTTP_REFERER'], $allowed_domains)){
header('Access-Control-Allow-Origin: ' . $_SERVER['HTTP_REFERER']);
}
}
SetEnvIf Authorization "(.*)" HTTP_AUTHORIZATION=$1
# RewriteEngine On
# RewriteCond %{HTTP:Authorization} ^(Bearer\ )(.*)$ [NC]
# RewriteRule ^(.*) $1?access_token=%2 [QSA]
#Header set Access-Control-Allow-Origin "*"
#Header set Access-Control-Allow-Methods "GET,PUT,POST,DELETE"
#Header set Access-Control-Allow-Headers "Content-Type, Authorization"
<IfModule mod_rewrite.c>
<IfModule mod_negotiation.c>
Options -MultiViews
</IfModule>
RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://kprep.api.ozandac.com/$1 [R,L]
RewriteEngine On
# Prevent direct access to the "public" folder - redirect to root
RewriteCond %{THE_REQUEST} ^[A-Z]{3,9}\ /public/
RewriteRule ^public/(.*) /$1 [R=302,L]
# Redirect Trailing Slashes If Not A Folder...
# - but look for the file in the "public" folder
# (ensure we are not already in the "public" folder)
RewriteCond %{REQUEST_URI} !^/public/
RewriteCond %{DOCUMENT_ROOT}/public/$1 !-d
RewriteRule ^(.*)/$ /$1 [R=302,L]
# Rewrite "everything" to the "public" subdirectory if not already
# This ignores existing files/dirs in the document root
RewriteCond %{REQUEST_URI} ^/(.*)
RewriteRule !^public/ public/%1
# Handle Front Controller... (as before)
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ index.php [L]
</IfModule>
public function context() {
// rule targets specific user, if this user is different we don't need to test the rule
if ( $this->user_id != 'all' ) {
if ( $this->user_id != get_current_user_id() ) {
return false;
}
}
if($this->user_id == "all")
{
if(get_current_user_id()===0)
{
return false;
}
}
return true;
}
File: gp-limit-submissions/includes/GPLS_Rule_User.php
Plugin: https://gravitywiz.com/documentation/gravity-forms-limit-submissions