• 1190阅读
  • 2回复

[转贴]MD5加密使用RC [复制链接]

上一主题 下一主题
离线ljq614
 
发帖
783
祝福宝石
0
威望
5192
玛雅之石
300
创造宝石
157
只看楼主 倒序阅读 使用道具 楼主  发表于: 2006-08-09
首先确保你的数据库中同时存在表MEMB_INFO 和Character 如果以上这2个表在不同数据库中,你可以考虑合并数据库后,修改你原来正常使用的数据源,并指向合并后的库。
首先,我们改变 1 memb__pwd varchar 10 0

此主题相关图片如下:

然后,由于新数据库没有了收费表的问题。我们要执行以下sql角本来建立那几个收费表。
注意:打开SQL查询分析器后,在里面我们要选择数据库 muonline 执行以下角本。
-----------------------------------------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_CURR_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_CURR_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_FQNW_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_FQNW_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_LEAV_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_LEAV_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_MIDS_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_MIDS_INFO]
GO
CREATE TABLE [dbo].[VI_CURR_INFO] (
[ends_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[chek_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[used_time] [int] NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Bill_Section] [int] NULL ,
[Bill_Value] [int] NULL ,
[Bill_Hour] [int] NULL ,
[Surplus_Point] [int] NULL ,
[Surplus_Minute] [datetime] NULL ,
[Increase_Days] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[VI_FQNW_INFO] (
[appl_code] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctrl_text] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fpas_ques] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[fpas_answ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[fanw_guid] [int] NOT NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[VI_LEAV_INFO] (
[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cont_text] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctrl_text] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[appl_code] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[leav_guid] [int] NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[memb_mail] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[dist_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[prss_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[tel__numb] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[VI_MIDS_INFO] (
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[chek_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[prev_info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[modi_info] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cont_text] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mids_guid] [int] NOT NULL ,
[admin_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
------------------------------------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Bill_Section]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Bill_Section]
GO
CREATE TABLE [dbo].[T_Bill_Section] (
[Bill_Start_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Bill_End_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
-------------------------------------------
最后是换为原来的JS-JoinServer 或者用去掉加密的新版JoinServer都可以!
评价一下你浏览此帖子的感受

精彩

感动

搞笑

开心

愤怒

无聊

灌水
离线leung83820
发帖
690
祝福宝石
0
威望
0
玛雅之石
0
创造宝石
0
只看该作者 沙发  发表于: 2006-08-09
.................
离线csdj86
发帖
281
祝福宝石
0
威望
655
玛雅之石
0
创造宝石
0
只看该作者 板凳  发表于: 2006-08-09
真到最後
?是?法使用加密的JS
快速回复
限100 字节
如果您提交过一次失败了,可以用”恢复数据”来恢复帖子内容
 
上一个 下一个

      管理员联系信箱 [email protected] 所有内容均来之互联网,如侵犯您的隐私和权益,请和我们及时联系!