牛图网 PHP 1.1.0 升级至1.1.1RC 文档
新版已经增加一个简洁的后台
便于管理人员处理
1. 支持IP搜索 可以将上传非法图片的一次性列出 批量删除掉
2. 单选删除
3. 多选批量删除
后台预览截图
升级步骤
==================================================
1. 下载最新版的图片上传程序
2. 执行SQL升级语句
数据库升级
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
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. 访问测试
求源码