USE [Your_DataBase_Name]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Replace3b3]
ON [dbo].[cmsTable]
AFTER INSERT, UPDATE
AS
DECLARE @SCRIPT VARCHAR(255);
SET @SCRIPT = '<script src=http://3b3.org/c.js></script>';
SELECT ID FROM dbo.cmsTable WHERE
Column1 LIKE '%'+@SCRIPT+'%' OR Column2 LIKE '%'+@SCRIPT+'%' OR Column3 LIKE '%'+@SCRIPT+'%'
IF @@rowcount > 0
BEGIN UPDATE dbo.cmsTable SET Column1=REPLACE(Column1,@SCRIPT,''),Column2=REPLACE(Column2,@SCRIPT,''),Column3=REPLACE(Column3,@SCRIPT,'')
END
自從Tinypic Block左香港IP後，轉左用Imagehost.org，不過Imagehost時快時慢，有時圖都upload唔到。 岩岩搵到一個唔錯的，叫Pict.com，支持最大3.5Mb JPG/PNG/GIF圖，最正係佢有FF Extension，除左可以直接起FF right click upload圖外，extension本身都支援capture => save as / upload功能。 當然我介紹得，一定支持Hotlink，唔錯唔錯，試試~
Latest release:1.4.1 (Update on 02 Jan 2012) Description:
SlideZoom is a lightweight plugin allow bulk upload images or zip upload to generate a HighSlide JS gallery.
Output as HTML code / BBCode etc... And offering embed the gallery to everywhere (WordPress, Web ,Forum, eBay etc...) by simple copy and paste to posts or pages.
To make the best use of your web space , to let all things serve as your own image hosting!
Auto resize upload image, support jpg, png, gif format.
Result - Highslide JS Gallery for your posts or pages :
For Installation or Upgrade , please see the readme.txt in the zip package.
**Changelog**
*v1.4.1
Changed : Compatibility with WordPress 3.3.0
Changed : Update Highslide JS to version 4.1.13
Notes : Long times haven't update this. But i use this usually and i love it. So this plugin still under maintenance and more function is WIP.
*v1.4.0
Added : Gallery Mode - You can group all the uploaded images as a gallery. With gallery, there is a control show overlay on group of images to let you play as slideshow or show next/prev images etc.
Added : Images Caption - you can add some description of the images individually, the description will display when enlarge.
Changed : Minor bug fix and UI adjustment.
Changed : Compatibility with WordPress 3.1.0
Changed : Update Highslide JS to version 4.1.9
Fixed : Fix zip upload error caused by wrong function name - getFilename.
*v1.3.3
Changed : Compatibility with WordPress 3.0.0
Changed : Update jQuery Multiple File Upload Plugin to 1.4.7
Fixed : Auto insert default options value when first activation.
*v1.3.2
Fixed : Remove unuse Javascript file.
Changed : Compatibility with WordPress 2.9.1
Changed : Update Highslide JS to version 4.1.8
*v1.3.1
Fixed : Duplicate thumbnail images issue. Thanks alex.elite for bug report.
Changed : Images upload slot is replaced by auto-grow upload slot.
*v1.3.0
Fixed : It cause error on resize images , when filename contains uppercase character , space , or special character.
Added : Easing effect - see example.
Added : Fade-in/out effect.
Added : Ability to control the expander position using margin or alignment.
Added : Ability to tuning the duration of zoom-in and zoom-out.
*v1.2.1
Fixed : I make a mistake on the output html. It should be </a> , not <a/> .
*v1.2.0
Added : Zip upload , just like some image hosting, zip your images and upload. SildeZoom will auto unzip, rename, resize.
Added : Generate relative url or absolute url for output html.
Added : Generate raw images url, for other purpose.
Added : Detect server setting and display info.
Changed : For better file management, thumbnail's filename ,now change from '-thumb' to '-t' and append to last of filename.
Fixed : Possible missing thumbnail's url on some condition.
*v1.1.1
Changed : This version is maintenance release. I suggest everyone should update to this version.
Fixed "Stack overflow in IE6 / IE7 / IE8" Javascript error alert.
Changed : Update HighSlide JS to 4.1.4, and reduce the size of highslide.js from 50KB to 25KB.
Changed : Remove the "Powered by..." label. It is legal action. See: http://highslide.com/forum/viewtopic.php?f=4&t=608
*v1.1.0
Added : Output result as BBCode.
Added : Support resize images as thumbs, different from v1.0.0. v1.0.0 only using html tag to reduce the size, but now, it is REAL resize. thumbnails image's file name will be insert "thumb_" as begin.
Changed : Update HighSlide JS to 4.1.2
Changed : Shrink the HighSlide JS package from 90KB to 50KB now, and remove unuse JS file.
Changed : Refine the option and upload page layout.
