牛图网 图片上传程序 PHP 1.1.0 升级至1.1.1RC 文档 和后台截图

牛图网 PHP 1.1.0 升级至1.1.1RC 文档

新版已经增加一个简洁的后台
便于管理人员处理
1. 支持IP搜索 可以将上传非法图片的一次性列出 批量删除掉
2. 单选删除
3. 多选批量删除

后台预览截图

升级步骤
==================================================
1. 下载最新版的图片上传程序
2. 执行SQL升级语句

数据库升级

ALTER TABLE  `images` CHANGE  `id`  `id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ;
ALTER TABLE  `images` CHANGE  `rfilename`  `file_rname` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '';
ALTER TABLE  `images` CHANGE  `filename`  `file_name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '';
ALTER TABLE  `images` CHANGE  `filesize`  `file_size` INT( 11 ) NOT NULL DEFAULT  '0';
ALTER TABLE  `images` CHANGE  `filepath`  `file_path` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE  `images` CHANGE  `date`  `file_adate` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE  `images` CHANGE  `fileext`  `file_ext` VARCHAR( 4 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE  `images` CHANGE  `lastaccessed`  `file_last` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE  `images` CHANGE  `userip`  `file_userip` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '';
ALTER TABLE  `images` CHANGE  `totalviews`  `file_views` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE  `images` DROP  `description` ;
ALTER TABLE  `images` ADD  `file_status` INT( 1 ) NOT NULL DEFAULT  '0';

CREATE TABLE IF NOT EXISTS `tags` (
  `tagId` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`tagId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `tags_map` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `relId` int(11) NOT NULL DEFAULT '0',
  `typeId` int(11) NOT NULL DEFAULT '0',
  `tagId` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `relId` (`relId`),
  KEY `tagId` (`tagId`),
  KEY `typeId` (`typeId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `tags_type` (
  `typeId` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(3) NOT NULL DEFAULT '',
  `longName` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`typeId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

3. 访问测试