[ Noticia ]
[ Noticia ]
[ Noticia ]
[ Noticia ]
[ Noticia ]
[ Noticia ]
http://i41.tinypic.com/de1boh.png/ Nome: Nome Do Mu
Versao: Versao Do Mu
Experiencia: Experiencia do Mu
Site:Site Do Mu

Xat Top Mu Online



Parcerias

Image and video hosting by TinyPic Image and video hosting by TinyPic Image and video hosting by TinyPic Image and video hosting by TinyPic

domingo, 29 de novembro de 2009

O que é MD5

O que é MD5 ?
Muitas pessoas ja me perguntaram o que é md5!
Então vamos a Respota!
O que é MD5 ?
MD5 é um esquema de encriptação de dados, em que transforma o dado em um codigo.
Para que serve ?
Serve para:
Exemplo: Quando você cria um login e senha, utilizando um programa/site com md5, o programa/site ira converter a senha para um codigo especifico, criptografado, e armazena-lo no seu banco de dados.
Vantagens ?
Os servidores com base na versão 99.6XT utilizam MD5 para aumentar a segurança. isso tambem aumenta a segurança dos sites de Muonline.
Desvantagens ?

Colocar um site em md5 apenas complica um pouco mais o seu desenvolvimento, e a grande maioria dos sites de muonline são sem md5. então pra evitar mais trabalho com o site, alguns desenvolvedores retiram o md5 dos seus servidores, substituindo arquivos, tabelas e procedimentos do banco de dados, diminuindo a segurança geral, tanto do site quanto do servidor.
Dica:
Faça seu Site sem MD5!
Retirando MD5 de seu servido., apenas rode está query
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MANG_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MANG_INFO]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MEMB_INFO]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_OUT]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MEMB_OUT]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MembInfoModify]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MembInfoModify]
GO

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_MIDS_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_MIDS_INFO]
GO

CREATE TABLE [dbo].[MANG_INFO] (
[mang_guid] [int] NOT NULL ,
[mang___id] [nvarchar] (15) COLLATE Polish_CI_AS NOT NULL ,
[mang__pwd] [nvarchar] (15) COLLATE Polish_CI_AS NOT NULL ,
[mang_name] [nvarchar] (20) COLLATE Polish_CI_AS NOT NULL ,
[mail_addr] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,
[levl_name] [nvarchar] (30) COLLATE Polish_CI_AS NULL ,
[part_name] [nvarchar] (30) COLLATE Polish_CI_AS NULL ,
[auth_code] [nvarchar] (30) COLLATE Polish_CI_AS NULL ,
[appl_days] [nvarchar] (8) COLLATE Polish_CI_AS NOT NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,
[Group_code] [nvarchar] (2) COLLATE Polish_CI_AS NULL ,
[dep_code] [nvarchar] (4) COLLATE Polish_CI_AS NOT NULL ,
[perm] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MEMB_INFO] (
[memb_guid] [int] IDENTITY (1, 1) NOT NULL ,
[memb___id] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb__pwd] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb_name] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[sno__numb] [char] (13) COLLATE Polish_CI_AS NOT NULL ,
[post_code] [char] (6) COLLATE Polish_CI_AS NULL ,
[addr_info] [varchar] (50) COLLATE Polish_CI_AS NULL ,
[addr_deta] [varchar] (50) COLLATE Polish_CI_AS NULL ,
[tel__numb] [varchar] (20) COLLATE Polish_CI_AS NULL ,
[phon_numb] [varchar] (15) COLLATE Polish_CI_AS NULL ,
[mail_addr] [varchar] (50) COLLATE Polish_CI_AS NULL ,
[fpas_ques] [varchar] (50) COLLATE Polish_CI_AS NULL ,
[fpas_answ] [varchar] (50) COLLATE Polish_CI_AS NULL ,
[job__code] [char] (2) COLLATE Polish_CI_AS NULL ,
[appl_days] [datetime] NULL ,
[modi_days] [datetime] NULL ,
[out__days] [datetime] NULL ,
[true_days] [datetime] NULL ,
[mail_chek] [char] (1) COLLATE Polish_CI_AS NULL ,
[bloc_code] [char] (1) COLLATE Polish_CI_AS NOT NULL ,
[ctl1_code] [char] (1) COLLATE Polish_CI_AS NOT NULL ,
[adminaccess] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MEMB_OUT] (
[out__guid] [int] NOT NULL ,
[memb_guid] [int] NOT NULL ,
[sno__numb] [nvarchar] (7) COLLATE Polish_CI_AS NULL ,
[memb_name] [nvarchar] (15) COLLATE Polish_CI_AS NULL ,
[appl_days] [smalldatetime] NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MembInfoModify] (
[Number] [int] NOT NULL ,
[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb__pwd] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (13) COLLATE Polish_CI_AS NOT NULL ,
[tel__numb] [nvarchar] (20) COLLATE Polish_CI_AS NULL ,
[phon_numb] [nvarchar] (15) COLLATE Polish_CI_AS NULL ,
[mail_addr] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,
[fpas_ques] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,
[fpas_answ] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,
[bloc_code] [nvarchar] (1) COLLATE Polish_CI_AS NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[VI_CURR_INFO] (
[ends_days] [nvarchar] (8) COLLATE Polish_CI_AS NULL ,
[chek_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,
[used_time] [int] NULL ,
[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Polish_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 Polish_CI_AS NOT NULL ,
[ctrl_text] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,
[fpas_ques] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,
[fpas_answ] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Polish_CI_AS NOT NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[fanw_guid] [int] NOT NULL ,
[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Polish_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[VI_MIDS_INFO] (
[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Polish_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Polish_CI_AS NOT NULL ,
[chek_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,
[prev_info] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,
[modi_info] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[cont_text] [ntext] COLLATE Polish_CI_AS NOT NULL ,
[mids_guid] [int] NOT NULL ,
[admin_name] [nvarchar] (10) COLLATE Polish_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE MEMB_INFO ALTER COLUMN memb__pwd VARCHAR(10) NOT NULL
GO

0 comentários:

Postar um comentário