Tópico: [Web Site] Site Daldegam + Template Cedrico + Avatar + Rankings Fix + Painel
Ver um Único Post
Antigo 16-11-2010, 06:43 AM   #1 (permalink)
Banido
 
Avatar de kakarojeta
 
Registrado em: May 2010
Localização: index.php
Posts: 455
Agradeceu: 142
Agradecido 192 Vezes em 125 Posts
Achei Ruim:
Acharam ruim Vezes em Posts
Meu Sistema
Rate Designer: Iniciante
Meu Estado:
Enviar mensagem via Windows Live Messenger para kakarojeta Enviar mensagem via Skype para kakarojeta
Nome Real: Thiago S.

Inventório de kakarojeta

Padrão Site Daldegam + Template Cedrico + Avatar + Rankings Fix + Painel
Bom pessoal...
caiu na rede ja, o q eu fiz, foi fixar e postar!

O que foi fixado?
*Mudar Avatar
*Rankings Index
*Limpar PK
*Template Completa
*Menu da template
*e mais coisas simples ^^

Prints da WebSite
Spoiler

WebSite
[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

Painel do Usuário
[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

Painel GameMaster
[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

Painel Admin
[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]


Query pra executar a Web
Spoiler
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webBanneds](
[name] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[datebegin] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL,
[dateend] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL,
[type] [smallint] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object: Table [dbo].[webCash] Script Date: 02/16/2094 17:14:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webCash](
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[amount] [int] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object: Table [dbo].[webComplaints] Script Date: 02/16/2009 17:14:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webComplaints](
[id] [int] IDENTITY(1,1) NOT NULL,
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[image] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[description] [text] COLLATE Latin1_General_CI_AS NOT NULL,
[date] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[ip] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[status] [smallint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object: Table [dbo].[webLogBuyCash] Script Date: 02/16/2009 17:15:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webLogBuyCash](
[id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[username] [varchar](12) COLLATE Chinese_PRC_CI_AS NOT NULL,
[cash] [int] NULL,
[banco] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[nterminal] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ntransferencia] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[agencia_acolhedora] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[nsequencia] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ctr] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[caixa_eletronico] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[nenvelope] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ndocumento] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ncontrole] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[noperador] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[data] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[hora] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[pago_em] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[anexo] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[comentario] [text] COLLATE Chinese_PRC_CI_AS NULL,
[valor] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[status] [int] NOT NULL CONSTRAINT [DF_webLogBuyCash_status] DEFAULT ((0)),
[comentario_adm] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object: Table [dbo].[webLogBuyVips] Script Date: 02/16/2009 17:15:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webLogBuyVips](
[id] [int] IDENTITY(1,1) NOT NULL,
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[type] [smallint] NOT NULL,
[cashAmount] [int] NOT NULL,
[days] [smallint] NOT NULL,
[date] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object: Table [dbo].[webNotices] Script Date: 02/16/2009 17:15:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webNotices](
[id] [smallint] IDENTITY(1,1) NOT NULL,
[subject] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[content] [text] COLLATE Latin1_General_CI_AS NOT NULL,
[date] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object: Table [dbo].[webPrevilegy] Script Date: 02/16/2009 17:15:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webPrevilegy](
[id] [smallint] IDENTITY(1,1) NOT NULL,
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[previlegy] [smallint] NOT NULL CONSTRAINT [DF_webPrevilegy_previlegy] DEFAULT ((0))
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[webPwdHashWrite]
@login VARCHAR(10),
@senha VARCHAR(10)
AS
BEGIN

DECLARE @Hash BINARY(16);
EXEC master..XP_MD5_EncodeKeyVal @senha, @login, @Hash OUT;
UPDATE MuOnline.dbo.MEMB_INFO SET memb__pwd = @senha WHERE memb___id = @login;

END

/****** Object: Table [dbo].[webRecord] Script Date: 02/16/2009 17:15:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webRecord](
[record] [smallint] NOT NULL CONSTRAINT [DF_webRecord_record] DEFAULT ((0)),
[date] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object: Table [dbo].[webTickets] Script Date: 02/16/2009 17:16:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webTickets](
[id] [int] IDENTITY(1,1) NOT NULL,
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[character] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[sector] [varchar](20) COLLATE Latin1_General_CI_AS NOT NULL,
[subject] [varchar](30) COLLATE Latin1_General_CI_AS NOT NULL,
[description] [text] COLLATE Latin1_General_CI_AS NOT NULL,
[date] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL,
[ip] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[status] [smallint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object: Table [dbo].[webTicketsAnswers] Script Date: 02/16/2009 17:16:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webTicketsAnswers](
[id] [int] NOT NULL,
[description] [text] COLLATE Latin1_General_CI_AS NOT NULL,
[answerBy] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[date] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[webVerifyLogin]
@login VARCHAR(10),
@senha VARCHAR(10),
@md5 int
AS
BEGIN
DECLARE @Valid int;
SET @Valid = 0;

IF @md5 = 1
BEGIN
DECLARE @Hash BINARY(16);
EXEC master..XP_MD5_EncodeKeyVal @senha, @login, @Hash OUT;
SELECT @Valid = 1 FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = @login AND memb__pwd = @Hash;
END
IF @md5 = 0
BEGIN
SELECT @Valid = 1 FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = @login AND memb__pwd = @Senha;
END

SELECT @Valid;
END

/****** Object: Table [dbo].[webVips] Script Date: 02/16/2009 17:16:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webVips](
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[type] [smallint] NOT NULL,
[datebegin] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL,
[dateend] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object: Table [dbo].[MEMB_INFO] Script Date: 02/16/2094 17:11:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MEMB_INFO](
[data] [smalldatetime] NULL,
[aniversario] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


DOWNLOAD
[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]


Senha: [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]


Spoiler

Créditos:
Leandro Daldegam (site original)
Victor Pereira (Template)
Sherlock (liberar template)
Junior Land (fixar rankings, fixar add foto no painel, fixar painel, entre outros)

Arquivos Anexados
Tipo de Arquivo: txt query.txt (7.4 KB, 97 visualizações) Baixar
kakarojeta está offline  
Links Patrocinados