funny songs by sakaira
Saturday, April 30, 2011
Wednesday, April 27, 2011
Errors Solved in the CSV import/export of opencart
Dear Rupak
I have a similar error to ialiendre's when I click on the export button:
Error: Table 'opn_j262cjfa6g.product' doesn't exist
Error No: 1146
SELECT * FROM `product` p inner join product_description pd on pd.product_id=p.product_id
Are you able to help me? I'm running v1.4.9.4 .
Thanks & best regards
-=============================================
The tip is that i forget to place the database prefix.
Change the following code
At model/tool/csvproduct.php replace with the codes
$query = "SELECT * FROM `". DB_PREFIX ."" . $table . "` p inner join ". DB_PREFIX ."product_description pd on pd.product_id=p.product_id";
at line no 21 or something like the $query
$query15 = "SELECT * from ". DB_PREFIX ."product_to_category ptc inner join ". DB_PREFIX ."category_description cd on cd.category_id=ptc.category_id where ptc.product_id=". $row['product_id'];
at line number 85 or something like the $query
$sql_query = "INSERT INTO ". DB_PREFIX ."product(product_id,model,quantity,price,list_price,image,stock_status_id,status,weight_class_id, length_class_id) VALUES";
$sql_query1 = "INSERT INTO ". DB_PREFIX ."product_description(product_id,name,description,language_id) VALUES";
$sql_query2 = "INSERT INTO ". DB_PREFIX ."product_to_store (product_id,store_id)VALUES";
at line no 159 to 161 or something like the $query
Thanking You
Want to play Golf with the Berni
Watch out how Berni Play golf, one of the most hilarious cartoon on the glof
Decrypt Your code
Want to decrypt the code then visit the site above.
How do i decrypt the php code?
How do i use the decryption of the code?
For all the above question the answer is
Visit the site below:
http://www.region59.net/unlockit/decoder.php
This service is designed to decrypt php-scripts that have been processed by the program SourceCop. Do not use this service to remove the protection to commercial products and for any similar actions which violate the copyright of third parties. Author services shall not be liable for the performance of the decoded scripts, as well as for any damage caused by their use.
How do i decrypt the php code?
How do i use the decryption of the code?
For all the above question the answer is
Visit the site below:
http://www.region59.net/unlockit/decoder.php
Tuesday, April 26, 2011
Php errors: Deprecated: Call-time pass-by-reference has been deprecated and its solution
Got problems with the Notice in the code you can simply remove them by pasting the line below
error_reporting (E_ALL ^ E_NOTICE);
Notice: Use of undefined constant action - assumed 'action' in D:\web\xampp\htdocs\....\....\..\.....php(1) : eval()'d code on line 43
Deprecated: Call-time pass-by-reference has been deprecated
if we get this errors then we just have to change
allow_call_time_pass_reference = off
to
allow_call_time_pass_reference = on
at php.ini file
After this don't forget to restart your xampp or wamp or means server.
Ways to find the php.ini file
Make one file and write <?php echo phpinfo(); ?>
and run it in the browser and search for the word "php.ini"
According to above mine php.ini file is included in the D:\web\xampp\php folders.
By this you will be able to get the php.ini file and change the setting as per your need.
Thanking You
Rupak Nepali
Rupak Nepali Admin Menu Management in Opencart
Rupak Nepali Admin Menu Management in Opencart
Click To Download Rupak Nepali Admin Menu Managment of Opencart
Unzip the file and copy in the respective folder then it works
The file at the admin/view/template/common/header.tpl is overridden so better to keep the back up of the file if you dont like it you can use the previous one.
If you have performed any changes in the menu then it may not work.
Thanking You
Rupak Nepali
hiding menu when no permission is given, show only the menu which have permission, menu according to the permission given in opencart.
Click To Download Rupak Nepali Admin Menu Managment of Opencart
Unzip the file and copy in the respective folder then it works
The file at the admin/view/template/common/header.tpl is overridden so better to keep the back up of the file if you dont like it you can use the previous one.
If you have performed any changes in the menu then it may not work.
Thanking You
Rupak Nepali
hiding menu when no permission is given, show only the menu which have permission, menu according to the permission given in opencart.
Sunday, April 24, 2011
How to add Special Buttons in the main menu of opencart
I would like to ceate a new button next to the "Home button" on default template. Called "Specials" and then link it to specials offers page.
Any one have any ideas on how to create it as same as the defult colors etc and link it to specials offers page.
I am learning heaps about programming etc.
=========================
Answer:
Remove this from catalog/view/template/common/header.tpl
<div class="div4"><a href="<?php echo str_replace('&', '&', $home); ?>" id="tab_home"><?php echo $text_home; ?></a>
<?php if (!$logged) { ?>
<a href="<?php echo str_replace('&', '&', $login); ?>" id="tab_login"><?php echo $text_login; ?></a>
<?php } else { ?>
<a href="<?php echo str_replace('&', '&', $logout); ?>" id="tab_logout"><?php echo $text_logout; ?></a>
<?php } ?>
<a href="<?php echo str_replace('&', '&', $account); ?>" id="tab_account"><?php echo $text_account; ?></a><a href="<?php echo str_replace('&', '&', $cart); ?>" id="tab_cart"><?php echo $text_cart; ?></a><a href="<?php echo str_replace('&', '&', $checkout); ?>" id="tab_checkout"><?php echo $text_checkout; ?></a></div>
And Paste on the same place the line below
<div class="div4">
<a href="<?php echo str_replace('&', '&', $home); ?>" id="tab_home"><?php echo $text_home; ?></a>
<a href="<?php echo str_replace('&', '&', $special); ?>"><?php echo $text_special; ?></a>
<?php if (!$logged) { ?>
<a href="<?php echo str_replace('&', '&', $login); ?>" id="tab_login"><?php echo $text_login; ?></a>
<?php } else { ?>
<a href="<?php echo str_replace('&', '&', $logout); ?>" id="tab_logout"><?php echo $text_logout; ?></a>
<?php } ?>
<a href="<?php echo str_replace('&', '&', $account); ?>" id="tab_account"><?php echo $text_account; ?></a><a href="<?php echo str_replace('&', '&', $cart); ?>" id="tab_cart"><?php echo $text_cart; ?></a>
</div>
Any one have any ideas on how to create it as same as the defult colors etc and link it to specials offers page.
I am learning heaps about programming etc.
=========================
Answer:
Remove this from catalog/view/template/common/header.tpl
<div class="div4"><a href="<?php echo str_replace('&', '&', $home); ?>" id="tab_home"><?php echo $text_home; ?></a>
<?php if (!$logged) { ?>
<a href="<?php echo str_replace('&', '&', $login); ?>" id="tab_login"><?php echo $text_login; ?></a>
<?php } else { ?>
<a href="<?php echo str_replace('&', '&', $logout); ?>" id="tab_logout"><?php echo $text_logout; ?></a>
<?php } ?>
<a href="<?php echo str_replace('&', '&', $account); ?>" id="tab_account"><?php echo $text_account; ?></a><a href="<?php echo str_replace('&', '&', $cart); ?>" id="tab_cart"><?php echo $text_cart; ?></a><a href="<?php echo str_replace('&', '&', $checkout); ?>" id="tab_checkout"><?php echo $text_checkout; ?></a></div>
And Paste on the same place the line below
<div class="div4">
<a href="<?php echo str_replace('&', '&', $home); ?>" id="tab_home"><?php echo $text_home; ?></a>
<a href="<?php echo str_replace('&', '&', $special); ?>"><?php echo $text_special; ?></a>
<?php if (!$logged) { ?>
<a href="<?php echo str_replace('&', '&', $login); ?>" id="tab_login"><?php echo $text_login; ?></a>
<?php } else { ?>
<a href="<?php echo str_replace('&', '&', $logout); ?>" id="tab_logout"><?php echo $text_logout; ?></a>
<?php } ?>
<a href="<?php echo str_replace('&', '&', $account); ?>" id="tab_account"><?php echo $text_account; ?></a><a href="<?php echo str_replace('&', '&', $cart); ?>" id="tab_cart"><?php echo $text_cart; ?></a>
</div>
Latest News module for the opencart
Click to download the Latest News Module of opencart
Unzip the files and
Copy and paste the files in their respective folders.
====================================================
FOR BACK END
====================================================
Paste the following
<li><a href="<?php echo HTTPS_SERVER . 'index.php?route=catalog/news&token=' . $this->session->data['token']; ?>">Latest News</a></li>
in the admin\view\template\common\header.tpl
below these lines
<li><a href="<?php echo $product; ?>"><?php echo $text_product; ?></a></li>
<li><a href="<?php echo $manufacturer; ?>"><?php echo $text_manufacturer; ?></a></li>
<li><a href="<?php echo $download; ?>"><?php echo $text_download; ?></a></li>
======================================================
Now open in the browser login in the admin
Give permission to the user (You can set the permission by admin only) for catalog/news
admin>> System>> Users>> User Groups>> Then select the user and click edit and check the catalog/news on both the access permission and the modify permission
======================================================
After that click on the Catalog>> Latest News
======================================================
FOR FRONT END SETTINGS
======================================================
Place "Latest News" by linking with the link
"index.php?route=information/news"
Now clicking on the link shows the latest news in the desc order
======================================================
Unzip the files and
Copy and paste the files in their respective folders.
====================================================
FOR BACK END
====================================================
Paste the following
<li><a href="<?php echo HTTPS_SERVER . 'index.php?route=catalog/news&token=' . $this->session->data['token']; ?>">Latest News</a></li>
in the admin\view\template\common\header.tpl
below these lines
<li><a href="<?php echo $product; ?>"><?php echo $text_product; ?></a></li>
<li><a href="<?php echo $manufacturer; ?>"><?php echo $text_manufacturer; ?></a></li>
<li><a href="<?php echo $download; ?>"><?php echo $text_download; ?></a></li>
======================================================
Now open in the browser login in the admin
Give permission to the user (You can set the permission by admin only) for catalog/news
admin>> System>> Users>> User Groups>> Then select the user and click edit and check the catalog/news on both the access permission and the modify permission
======================================================
After that click on the Catalog>> Latest News
======================================================
FOR FRONT END SETTINGS
======================================================
Place "Latest News" by linking with the link
"index.php?route=information/news"
Now clicking on the link shows the latest news in the desc order
======================================================
Subscribe to:
Posts (Atom)
-
Why do niggers wear wide brimmed hats? So birds won't shit on their lips. How do you stop black kids from jumping on your bed? Put Velcr...
-
php, tutorial, sql, video, css, user, login, cookies, lifeg0eson666, marcus, recck, youtube, online, science, A PHP Tutorial creating a User...
-
Building a CMS with PHP and MYSQL Pat 2 video, php tutorials video, php and mysql to make cms video
