ecshop商品点击数的问题

2016-07-07 15:22 来源：www.chinab4c.com 作者：ecshop专家

今天我想改一下商品点击数，看到改admin/goods.php文件更改点发布时一个随机击数的方法，但问题是我的商品已经发布过的，这个方法只对新加的商品有效，请问怎么把已加的商品改变一下随机点击数？多谢指点！


我用的那个方法是这个：
打开: admin/goods.php文件.
查找:
  1. if ($is_insert)

  3. {

  5. if ($code == '')

  7. {

  9. $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .

  11. "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .

  13. "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .

  15. "seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, " .

  17. "is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type, rank_integral)" .

  19. "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .

  21. "'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', ".

  23. "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".

  25. "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".

  27. " '$warn_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', '$is_on_sale', '$is_alone_sale', ".

  29. " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$rank_integral')";

  31. }

  33. else

  35. {

  37. $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .

  39. "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .

  41. "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .

  43. "seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, is_real, " .

  45. "is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type, extension_code, rank_integral)" .

  47. "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .

  49. "'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', ".

  51. "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".

  53. "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".

  55. " '$warn_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', 0, '$is_on_sale', '$is_alone_sale', ".

  57. " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$code', '$rank_integral')";

  59. }

  61. }
复制代码

复制代码
替换成:

  1. if ($is_insert)

  3. {

  5. $rand = rand(100,500);

  7. if ($code == '')

  9. {

  11. $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .

  13. "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .

  15. "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .

  17. "seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, " .

  19. "is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type, rank_integral,click_count)" .

  21. "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .

  23. "'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', ".

  25. "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".

  27. "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".

  29. " '$warn_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', '$is_on_sale', '$is_alone_sale', ".

  31. " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$rank_integral','$rand')";

  33. }

  35. else

  37. {

  39. $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .

  41. "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .

  43. "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .

  45. "seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, is_real, " .

  47. "is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type, extension_code, rank_integral,click_count)" .

  49. "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .

  51. "'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', ".

  53. "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".

  55. "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".

  57. " '$warn_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', 0, '$is_on_sale', '$is_alone_sale', ".

  59. " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$code', '$rank_integral','$rand')";

  61. }

  63. }
复制代码

回答：
我也想知道！

感谢分享。不过改以前的可能只能手动编辑.sql再导入了。
建议用EditPlus，我昨天用它来改时间。。不过手动编辑很麻烦，唉。。