SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/*
select tt=dbo.ufnGetMessageFromLine('<tr class=''dbg-1''><td><span>Book: The Powers Below</span></td><td> : </td><td>《深渊之神》</td></tr>','E')
*/
CREATE Function [dbo].[ufnGetMessageFromLine]
(
@strOri nvarchar(1000),
@Type varchar(10)
)
RETURNS nvarchar(1000)
AS
begin
declare @intLen int
declare @Sql nvarchar(1000)
select @intLen=1 --where : locates
DoLoop:
select @intLen =@intLen +1
while substring(@strOri,@intLen,21)<>'</td><td> : </td><td>' and @intLen<len(@strOri)
begin
select @intLen =@intLen +1
end
--if substring(@strOri,1,@intLen-1) not like '%</td><td> ' goto DoLoop
--Return ltrim(rtrim(substring(@strOri,1,@intLen-1)))
if substring(@Type,1,1)='E'
Begin
select @strOri=substring(@strOri,1,@intLen-1)
select @strOri=replace(@strOri,'<tr class=''dbg-1''><td><span>','')
select @strOri=replace(@strOri,'<tr class=''dbg1''><td><span>','')
select @strOri=replace(@strOri,'</span>','')
select @strOri=replace(@strOri,'"','"')
select @strOri=replace(@strOri,''','''')
select @strOri=replace(@strOri,'""','')
Return ltrim(rtrim(@strOri))
end
if substring(@Type,1,1)='C'
Begin
select @strOri=substring(@strOri,@intLen,1000)
select @strOri=replace(@strOri,'</td><td> : </td><td>','')
select @strOri=replace(@strOri,'</td></tr>','')
select @strOri=replace(@strOri,'"','"')
select @strOri=replace(@strOri,''','''')
select @strOri=replace(@strOri,'""','')
Return ltrim(rtrim(@strOri))
end
Return 'NotFind'
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE TABLE [dbo].[From1117File_U_Temp] (
[Name] [nvarchar] (1000) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ItemName] (
[PageNo] [int] NULL ,
[EName] [nvarchar] (400) COLLATE Chinese_PRC_Stroke_CI_AS NULL ,
[CName] [nvarchar] (400) COLLATE Chinese_PRC_Stroke_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Live_ItemName] (
[SeqId] [int] IDENTITY (1, 1) NOT NULL ,
[PageNo] [int] NULL ,
[EName] [nvarchar] (400) COLLATE Chinese_PRC_Stroke_CI_AS NULL ,
[CName] [nvarchar] (400) COLLATE Chinese_PRC_Stroke_CI_AS NULL ,
[ItemNo] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Live_ItemName] WITH NOCHECK ADD
CONSTRAINT [PK_Live_ItemName] PRIMARY KEY CLUSTERED
(
[SeqId]
) ON [PRIMARY]
GO
CREATE INDEX [IX_ItemName_Ename] ON [dbo].[ItemName]([EName]) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/*
uspTransDataFrom1117File
uspLive_ItemName_Addition
执行前请先执行上面两个SP
*/
CREATE PROCEDURE [dbo].[uspEditHtml_U19]
AS
exec uspGet_U19_ItemName_FromEXCEL
exec uspLive_ItemName_Addition
declare @htmlA varchar(1000)
declare @htmlA2 varchar(1000)
declare @htmlB varchar(1000)
declare @htmlC varchar(1000)
select @htmlA='<A class=q3 href="http://www.wowhead.com/?item=',
@htmlA2='<A class=q2 href="http://www.wowhead.com/?item=',
@htmlB='</A><a href="javascript:;" onclick="g_getIngameLink(''ff1eff00'', ''item:',
@htmlC=':0:0:0:0:0:0:0'', ''Acolyte\''s Sacrificial Robes'')">getlink</a>'
if object_id('tempdb..#My_U19') is not null drop table #My_U19
CREATE TABLE [dbo].[#My_U19] (
[SeqId] [int] IDENTITY (1, 1) NOT NULL ,
[MyEditHtml] [nvarchar] (1000) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
[type] [nvarchar] (1000) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
[level] [int] NULL ,
[cSource2] [nvarchar] (1000) COLLATE Chinese_PRC_Stroke_CI_AS NULL
) ON [PRIMARY]
insert #My_U19 values(N'<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">','',100,'')
insert #My_U19 values(N'<html xmlns="http://www.w3.org/1999/xhtml">','',100,'')
insert #My_U19 values(N'<head>','',100,'')
insert #My_U19 values(N'<title>U19_AllItem(武林外传出品)</title>','',100,'')
insert #My_U19 values(N'<SCRIPT src="http://www.wowhead.com/widgets/power.js"></SCRIPT>',''�
WOW中英文翻译表&U29装备库（最终版）
需积分: 49 143 浏览量
2008-07-25
10:21:33
上传
评论
收藏 623KB 7Z 举报
WOW中英文翻译表&U29装备库（最终版） （1122个子文件） 
U29_AllItem.htm 49KB
729.html 8KB 336.html 8KB 279.html 8KB 672.html 8KB 728.html 8KB 335.html 8KB 723.html 7KB 330.html 7KB 466.html 7KB 851.html 7KB 690.html 7KB 297.html 7KB 859.html 7KB 458.html 7KB 773.html 7KB 380.html 7KB 691.html 7KB 298.html 7KB 440.html 7KB 832.html 7KB 833.html 7KB 439.html 7KB 448.html 7KB 841.html 7KB 457.html 7KB 834.html 7KB 541.html 7KB 934.html 7KB 727.html 7KB 334.html 7KB 850.html 7KB 542.html 7KB 770.html 7KB 935.html 7KB 547.html 7KB 722.html 7KB 329.html 7KB 941.html 7KB 549.html 7KB 377.html 7KB 441.html 7KB 506.html 7KB 942.html 7KB 671.html 7KB 278.html 7KB 899.html 7KB 938.html 7KB 489.html 7KB 545.html 7KB 885.html 7KB 940.html 7KB 548.html 7KB 492.html 7KB 882.html 7KB 943.html 7KB 376.html 7KB 550.html 7KB 886.html 7KB 493.html 7KB 507.html 7KB 331.html 7KB 724.html 7KB 900.html 7KB 730.html 7KB 337.html 7KB 939.html 7KB 328.html 7KB 721.html 7KB 774.html 7KB 546.html 7KB 544.html 7KB 901.html 7KB 769.html 7KB 508.html 7KB 937.html 7KB 884.html 7KB 379.html 7KB 407.html 7KB 491.html 7KB 955.html 7KB 936.html 7KB 381.html 7KB 800.html 7KB 1116.html 7KB 543.html 7KB 772.html 7KB 447.html 7KB 944.html 7KB 926.html 7KB 977.html 7KB 562.html 7KB 374.html 7KB 787.html 7KB 618.html 7KB 540.html 7KB 512.html 7KB 533.html 7KB 584.html 7KB 887.html 7KB共 1122 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
评论0
最新资源