Per vari motivi può capitare di dover ripristinare la password di accesso al pannello di controllo del vostro prestashop. Con la seguente query si è in grado di sistemare l’accesso all’amministrazione dell’ecommerce.
UPDATE ps_employee SET passwd = md5(“_COOKIE_KEY_nuovapwd“) WHERE email = “indirizzo@email.com“
Su prestashop dopo la fase di test è possibili azzerare tutti gli ordini, i clienti fittizi e i vari messaggi! Tutto ciò è possibile via sql dal proprio pannello di gestione database!
TRUNCATE TABLE `ps_customer`; TRUNCATE TABLE `ps_customer_group`; TRUNCATE TABLE `ps_address`; TRUNCATE TABLE `ps_orders`; TRUNCATE TABLE `ps_order_detail`; TRUNCATE TABLE `ps_order_discount`; TRUNCATE TABLE `ps_order_history`; TRUNCATE TABLE `ps_message`; TRUNCATE TABLE `ps_cart`; TRUNCATE TABLE `ps_cart_product`; TRUNCATE TABLE `ps_cart_discount`;
Ecco un utile link per recuperare tutte le versioni di prestashop. http://code.google.com/p/prestashop/downloads/list
| Variabile | Descrizione | Risultato |
|---|---|---|
| $base_dir | directory base | http://www.prestashop-italia.it/prestashop/ |
| $base_dir_ssl | directory base se ssl | http://www.prestashop-italia.it/prestashop/ |
| $request_uri | php that call smarty | /prestashop/smartyvar.php |
| $content_dir | prestashop | http://www.prestashop-italia.it/prestashop/ |
| $img_ps_dir | Image | http://www.prestashop-italia.it/prestashop/img/ |
| $img_cat_dir | Image | http://www.prestashop-italia.it/prestashop/img/c/ |
| $img_lang_dir | Image | http://www.prestashop-italia.it/prestashop/img/l/ |
| $img_prod_dir | Image | http://www.prestashop-italia.it/prestashop/img/p/ |
| $img_manu_dir | Image | http://www.prestashop-italia.it/prestashop/img/m/ |
| $img_sup_dir | Image | http://www.prestashop-italia.it/prestashop/img/su/ |
| $img_ship_dir | Image | http://www.prestashop-italia.it/prestashop/img/s/ |
| $img_col_dir | Image | http://www.prestashop-italia.it/prestashop/img/co/ |
| $img_dir | Image theme | http://www.prestashop-italia.it/prestashop/themes/prestashop/img/ |
| $css_dir | CSS theme | http://www.prestashop-italia.it/prestashop/themes/prestashop/css/ |
| $js_dir | JS theme | http://www.prestashop-italia.it/prestashop/themes/prestashop/js/ |
| $tpl_dir | JS theme | /var/www/html/prestashop/themes/prestashop/ |
| $modules_dir | modules | /prestashop/modules/ |
| $mail_dir | Mails | /prestashop/mails/ |
| $pic_dir | PIC theme | http://www.prestashop-italia.it/prestashop/upload/ |
| $lang_iso | lang | it |
| $come_from | From | http://www.prestashop-italia.it/prestashop/smartyvar.php |
| $shop_name | Shop | test124 |
| $cart_qties | Cart number | 1 |
| $cart | Cart array | array |
| $currencies | All Currency | Array |
| $id_currency_cookie | Id Currency | 1 |
| $languages | languages | Array |
| $cookie | cookie array | array |
| $logged | logged | 1 |
| $page_name | page name | smartyvar |
| $customerName | Customer name | test test |
| $priceDisplay | priceDisplay | 0 |
