打造你的YES!PPG无需安装立即免费体验ecshop构建独立网店
发新话题
打印

ecshop转换后图片路径处理办法

本主题由 bugii 于 2008-8-22 16:32 提升

ecshop转换后图片路径处理办法

引坛子里面的朋友的一条帖子:

从shopex转换过来后,ecshop的  图片地址都会是http://lwww.***.com/XXXXX.jpg
而ecshop转成功后程序copy图片路径是Ecshop/images/新建日期目录/会变为详细页面大图big_XXX.jpg  省略图图,small_XXX.jpg   原始图 original_XXX.jpg

如果是这样的问题操作数据库在XXXXX.jpg 前面加上images/日期/big_  或者images/日期/small_  或者images/日期/original_
具体操作办法见下:
1、先备份数据库,以防万一
2、先改大图的字段
mysql操作语句
update ecs_goods set goods_img =CONCAT('images/日期/big_',goods_image)
小图的操作语句
update ecs_goods set goods_thumb =CONCAT('images/日期/small_',goods_thumb)
原始图的操作语句
update ecs_goods set original_img =CONCAT('images/日期/original_',goods_image)

说明:
1、其中的日期改成生产的那个日期命名的目录名字
2、检查下你的所有数据是不是都是像上面的那种情况【ecshop转成功后程序copy图片路径是Ecshop/images/新建日期目录/会变为详细页面大图big_XXX.jpg  省略图图,small_XXX.jpg   原始图 original_XXX.jpg
3、如果不是这种情况,跟帖说明,截图
4、上面的操作语句是没有加条件的,使用者可以自己加上条件,例如从 第80条数据到 第300条数据要修改
那么在后面空格后加上 where goods_id >=80 and goods_id <=300
希望能够帮助需要帮助的人,本人属菜鸟级别,老鸟就不要笑话了,有错误的地方请指正。
本帖能申精就更好了,鼓励以后继续发布帮助文件,上次本来写两个一个很长的帮助文件,想来一个隐藏贴,(主要是让大家把帖子顶起来,也不是为了别的,只希望看帖的能回个帖而已。)居然discuz代码说我没权限,然后自动清除,很烦。后面没心情写了,今天大概的写了下。

[ 本帖最后由 flysky668 于 2008-6-16 23:52 编辑 ]
本帖最近评分记录
  • bugii 体力 +5 2008-8-22 16:32

TOP

哈哈哈,等了三四天,终于顶出你来帮忙了!顶你。。。。

希望官方人员能做一些小程序,这样就更好了。

基于SA9903B的单相电能表的设计

http://www.adgic.com/ch/2751.htm
http://www.adgic.com/ch/2752.htm
http://www.adgic.com/ch/2753.htm
http://www.adgic.com/ch/2754.htm
http://www.adgic.com/ch/2755.htm
http://www.adgic.com/ch/2756.htm
http://www.adgic.com/ch/2757.htm
http://www.adgic.com/ch/2758.htm
http://www.adgic.com/ch/2759.htm
http://www.adgic.com/ch/2760.htm
http://www.adgic.com/ch/2761.htm
http://www.adgic.com/ch/2762.htm
http://www.adgic.com/ch/2763.htm
http://www.adgic.com/ch/2764.htm
http://www.adgic.com/ch/2765.htm
http://www.adgic.com/ch/2766.htm
http://www.adgic.com/ch/2767.htm
http://www.adgic.com/ch/2768.htm
http://www.adgic.com/ch/2769.htm
http://www.adgic.com/ch/2770.htm
http://www.adgic.com/ch/2771.htm
http://www.adgic.com/ch/2772.htm
http://www.adgic.com/ch/2773.htm
http://www.adgic.com/ch/2774.htm
http://www.adgic.com/ch/2775.htm
http://www.adgic.com/ch/2776.htm
http://www.adgic.com/ch/2777.htm
http://www.adgic.com/ch/2778.htm
http://www.adgic.com/ch/2779.htm
http://www.adgic.com/ch/2780.htm
http://www.adgic.com/ch/2781.htm
http://www.adgic.com/ch/2782.htm
http://www.adgic.com/ch/2783.htm
http://www.adgic.com/ch/2784.htm
http://www.adgic.com/ch/2785.htm
http://www.adgic.com/ch/2786.htm
http://www.adgic.com/ch/2787.htm
http://www.adgic.com/ch/2788.htm
http://www.adgic.com/ch/2789.htm
http://www.adgic.com/ch/2790.htm
http://www.adgic.com/ch/2791.htm
http://www.adgic.com/ch/2792.htm
http://www.adgic.com/ch/2793.htm
http://www.adgic.com/ch/2794.htm
http://www.adgic.com/ch/2795.htm
http://www.adgic.com/ch/2796.htm
http://www.adgic.com/ch/2797.htm
http://www.adgic.com/ch/2798.htm
http://www.adgic.com/ch/2799.htm
http://www.adgic.com/ch/2800.htm
http://www.adgic.com/ch/2801.htm
http://www.adgic.com/ch/2802.htm
http://www.adgic.com/ch/2803.htm
http://www.adgic.com/ch/2804.htm
http://www.adgic.com/ch/2805.htm
http://www.adgic.com/ch/2806.htm
http://www.adgic.com/ch/2807.htm
http://www.adgic.com/ch/2808.htm
http://www.adgic.com/ch/2809.htm
http://www.adgic.com/ch/2810.htm
http://www.adgic.com/ch/2811.htm
http://www.adgic.com/ch/2812.htm
http://www.adgic.com/ch/2813.htm
http://www.adgic.com/ch/2814.htm
http://www.adgic.com/ch/2815.htm
http://www.adgic.com/ch/2816.htm
http://www.adgic.com/ch/2817.htm
http://www.adgic.com/ch/2818.htm
http://www.adgic.com/ch/2819.htm
http://www.adgic.com/ch/2820.htm
http://www.adgic.com/ch/2821.htm
http://www.adgic.com/ch/2822.htm
http://www.adgic.com/ch/2823.htm
http://www.adgic.com/ch/2824.htm
http://www.adgic.com/ch/2825.htm
http://www.adgic.com/ch/2826.htm
http://www.adgic.com/ch/2827.htm
http://www.adgic.com/ch/2828.htm
http://www.adgic.com/ch/2829.htm
http://www.adgic.com/ch/2830.htm
http://www.adgic.com/ch/2831.htm
http://www.adgic.com/ch/2832.htm
http://www.adgic.com/ch/2833.htm
http://www.adgic.com/ch/2834.htm
http://www.adgic.com/ch/2835.htm
http://www.adgic.com/ch/2836.htm
http://www.adgic.com/ch/2837.htm
http://www.adgic.com/ch/2838.htm
http://www.adgic.com/ch/2839.htm
http://www.adgic.com/ch/2840.htm
http://www.adgic.com/ch/2841.htm
http://www.adgic.com/ch/2842.htm
http://www.adgic.com/ch/2843.htm
http://www.adgic.com/ch/2844.htm
http://www.adgic.com/ch/2845.htm
http://www.adgic.com/ch/2846.htm
http://www.adgic.com/ch/2847.htm
http://www.adgic.com/ch/2848.htm
http://www.adgic.com/ch/2849.htm
http://www.adgic.com/ch/2850.htm
http://www.adgic.com/ch/2851.htm
http://www.adgic.com/ch/2852.htm
http://www.adgic.com/ch/2853.htm
http://www.adgic.com/ch/2854.htm
http://www.adgic.com/ch/2855.htm
http://www.adgic.com/ch/2856.htm
http://www.adgic.com/ch/2857.htm
http://www.adgic.com/ch/2858.htm
http://www.adgic.com/ch/2859.htm
http://www.adgic.com/ch/2860.htm
http://www.adgic.com/ch/2861.htm
http://www.adgic.com/ch/2862.htm
http://www.adgic.com/ch/2863.htm
http://www.adgic.com/ch/2864.htm
http://www.adgic.com/ch/2865.htm
http://www.adgic.com/ch/2866.htm
http://www.adgic.com/ch/2867.htm
http://www.adgic.com/ch/2868.htm
http://www.adgic.com/ch/2869.htm
http://www.adgic.com/ch/2870.htm
http://www.adgic.com/ch/2871.htm
http://www.adgic.com/ch/2872.htm
http://www.adgic.com/ch/2873.htm
http://www.adgic.com/ch/2874.htm
http://www.adgic.com/ch/2875.htm
http://www.adgic.com/ch/2876.htm
http://www.adgic.com/ch/2877.htm
http://www.adgic.com/ch/2878.htm
http://www.adgic.com/ch/2879.htm
http://www.adgic.com/ch/2880.htm
http://www.adgic.com/ch/2881.htm
http://www.adgic.com/ch/2882.htm
http://www.adgic.com/ch/2883.htm
http://www.adgic.com/ch/2884.htm
http://www.adgic.com/ch/2885.htm
http://www.adgic.com/ch/2886.htm
http://www.adgic.com/ch/2887.htm
http://www.adgic.com/ch/2888.htm
http://www.adgic.com/ch/2889.htm
http://www.adgic.com/ch/2890.htm
http://www.adgic.com/ch/2891.htm
http://www.adgic.com/ch/2892.htm
http://www.adgic.com/ch/2893.htm
http://www.adgic.com/ch/2894.htm
http://www.adgic.com/ch/2895.htm
http://www.adgic.com/ch/2896.htm
http://www.adgic.com/ch/2897.htm
http://www.adgic.com/ch/2898.htm
http://www.adgic.com/ch/2899.htm
http://www.adgic.com/ch/2900.htm
http://www.adgic.com/ch/2901.htm
http://www.adgic.com/ch/2902.htm
http://www.adgic.com/ch/2903.htm
http://www.adgic.com/ch/2904.htm
http://www.adgic.com/ch/2905.htm
http://www.adgic.com/ch/2906.htm
http://www.adgic.com/ch/2907.htm
http://www.adgic.com/ch/2908.htm
http://www.adgic.com/ch/2909.htm
http://www.adgic.com/ch/2910.htm
http://www.adgic.com/ch/2911.htm
http://www.adgic.com/ch/2912.htm
http://www.adgic.com/ch/2913.htm
http://www.adgic.com/ch/2914.htm
http://www.adgic.com/ch/2915.htm
http://www.adgic.com/ch/2916.htm
http://www.adgic.com/ch/2917.htm
http://www.adgic.com/ch/2918.htm
http://www.adgic.com/ch/2919.htm
http://www.adgic.com/ch/2920.htm
http://www.adgic.com/ch/2921.htm
http://www.adgic.com/ch/2922.htm
http://www.adgic.com/ch/2923.htm
http://www.adgic.com/ch/2924.htm
http://www.adgic.com/ch/2925.htm
http://www.adgic.com/ch/2926.htm
http://www.adgic.com/ch/2927.htm
http://www.adgic.com/ch/2928.htm
http://www.adgic.com/ch/2929.htm
http://www.adgic.com/ch/2930.htm
http://www.adgic.com/ch/2931.htm
http://www.adgic.com/ch/2932.htm
http://www.adgic.com/ch/2933.htm
http://www.adgic.com/ch/2934.htm
http://www.adgic.com/ch/2935.htm
http://www.adgic.com/ch/2936.htm
http://www.adgic.com/ch/2937.htm
http://www.adgic.com/ch/2938.htm
http://www.adgic.com/ch/2939.htm
http://www.adgic.com/ch/2940.htm
http://www.adgic.com/ch/2941.htm
http://www.adgic.com/ch/2942.htm
http://www.adgic.com/ch/2943.htm
http://www.adgic.com/ch/2944.htm
http://www.adgic.com/ch/2945.htm
http://www.adgic.com/ch/2946.htm
http://www.adgic.com/ch/2947.htm
http://www.adgic.com/ch/2948.htm
http://www.adgic.com/ch/2949.htm
http://www.adgic.com/ch/2950.htm
http://www.adgic.com/ch/2951.htm
http://www.adgic.com/ch/2952.htm
http://www.adgic.com/ch/2953.htm
http://www.adgic.com/ch/2954.htm
http://www.adgic.com/ch/2955.htm
http://www.adgic.com/ch/2956.htm
http://www.adgic.com/ch/2957.htm
http://www.adgic.com/ch/2958.htm
http://www.adgic.com/ch/2959.htm
http://www.adgic.com/ch/2960.htm
http://www.adgic.com/ch/2961.htm
http://www.adgic.com/ch/2962.htm
http://www.adgic.com/ch/2963.htm
http://www.adgic.com/ch/2964.htm
http://www.adgic.com/ch/2965.htm
http://www.adgic.com/ch/2966.htm
http://www.adgic.com/ch/2967.htm
http://www.adgic.com/ch/2968.htm
http://www.adgic.com/ch/2969.htm
http://www.adgic.com/ch/2970.htm
http://www.adgic.com/ch/2971.htm
http://www.adgic.com/ch/2972.htm
http://www.adgic.com/ch/2973.htm
http://www.adgic.com/ch/2974.htm
http://www.adgic.com/ch/2975.htm
http://www.adgic.com/ch/2976.htm
http://www.adgic.com/ch/2977.htm
http://www.adgic.com/ch/2978.htm
http://www.adgic.com/ch/2979.htm
http://www.adgic.com/ch/2980.htm
http://www.adgic.com/ch/2981.htm
http://www.adgic.com/ch/2982.htm
http://www.adgic.com/ch/2983.htm
http://www.adgic.com/ch/2984.htm
http://www.adgic.com/ch/2985.htm
http://www.adgic.com/ch/2986.htm
http://www.adgic.com/ch/2987.htm
http://www.adgic.com/ch/2988.htm
http://www.adgic.com/ch/2989.htm
http://www.adgic.com/ch/2990.htm
http://www.adgic.com/ch/2991.htm
http://www.adgic.com/ch/2992.htm
http://www.adgic.com/ch/2993.htm
http://www.adgic.com/ch/2994.htm
http://www.adgic.com/ch/2995.htm
http://www.adgic.com/ch/2996.htm
http://www.adgic.com/ch/2997.htm
http://www.adgic.com/ch/2998.htm
http://www.adgic.com/ch/2999.htm
http://www.adgic.com/ch/3000.htm

TOP

发新话题