Open Cart Add bulk menu to bulk product

SELECT * FROM ocw8_product_to_category WHERE product_id IN

(SELECT product_id FROM `ocw8_product` WHERE model = ‘Sloppy Plate’)

INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (75,68)

INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (76,68)
GO
INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (78,68)
Go
INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (79,68)
GO
INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (80,68)
GO
INSERT INTO ocw8_product_to_category (product_id,category_id)
VALUES (81,68)
Go

OpenCart Install VQMOD to install all extensions

Lots of extention in Opencart is developed in VQMOD. To install VQMOD:

STEP 1 : Download vQmod

  1. Download VqMOD: From Here
  2. Unzip it.
  3. Upload vQmod to root directory vqmod

STEP 2 : Install vQmod

  1. After upload run the installation by running install file through :http://www.yourdomain.com/vQmod/install.

You will see vQmod INSTALLED message

 

Extension Installation

(Collected from this site: https://www.transpacific-software.com/guide_install_opencart_extensions.html )

Your vQmod is installed and you are ready to install a vQmod based extension.

STEP 3 : Download the extension

STEP 4 : Extract the file and upload the content in your root directory.

STEP 5 : Go to your admin Extensions>Modules you will see the module in the list.

  • All vQmod based extensions will have vQmod folder. This folder will add new extension files within vQmod folder already present on the server. You have to simply dump the extension files on FTP.

STEP 6 :

  • Within admin go to Extensions.
  • You will find the extension listed. You will also find Install link. Click install link to install the module.

STEP 7 :

  • After installation, click on the edit link and set the setting for a module.

STEP 8 :

  • Go to frontend to see the module working.

Fail2ban unban a IP or Unblock an IP

cd /var/log/

nano fail2ban.loga and search for banned IP address.

 

iptables –L –n

Get the banned type from the output and try the following:

fail2ban-client set ssh-iptables unbanip 192.168.1.101

 

ssh-iptables can be replaces by banned type like “pbx-gui”

 

By simplemsexchange Posted in VOIP

Perform Specific Button click event when user press Enter key in Textbox

Put your form inside an asp.net panel control and set its DefaultButton attribute with your button ID. See the code below:

 

<asp:Panel ID="Panel1" runat="server" DefaultButton="Button1">
        <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
         <ContentTemplate>
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Send" />
             </ContentTemplate>
          </asp:UpdatePanel>
</asp:Panel>