· 8 years ago · Jul 22, 2018, 10:24 PM
1USE [MuOnline]
2GO
3DROP PROCEDURE [dbo].[VERIFICAR_ITENS]
4GO
5DROP PROCEDURE [dbo].[chat_atualizar]
6GO
7DROP PROCEDURE [dbo].[WZ_GetMasterResetInfo]
8GO
9DROP PROCEDURE [dbo].[WZ_GetResetInfo]
10GO
11DROP PROCEDURE [dbo].[WZ_SetMasterResetInfo]
12GO
13DROP PROCEDURE [dbo].[WZ_SetResetInfo]
14GO
15DROP TABLE [dbo].[MK_Quest]
16GO
17DROP TABLE [dbo].[MK_MEDALHAS]
18GO
19DROP TABLE [dbo].[MK_Chat_online]
20GO
21DROP PROCEDURE [dbo].[EVENTO_ITENS]
22GO
23DROP PROCEDURE [dbo].[WZ_CS_ModifyTaxRate]
24GO
25DROP PROCEDURE [dbo].[WZ_GetAccountLevel]
26GO
27DROP TABLE [dbo].[MK_Chat_staff]
28GO
29DROP TABLE [dbo].[MK_DV]
30GO
31DROP TABLE [dbo].[MK_Reputacao]
32GO
33DROP TABLE [dbo].[MK_Server]
34GO
35DROP TABLE [dbo].[TOP_Diario]
36GO
37DROP TABLE [dbo].[TOP_Mensal]
38GO
39DROP TABLE [dbo].[TOP_Semanal]
40GO
41DROP TABLE [dbo].[MK_Mensagens]
42GO
43DROP TABLE [dbo].[MK_Mudar_Mail]
44GO
45DROP TABLE [dbo].[MK_Murkut_News]
46GO
47DROP TABLE [dbo].[MK_Online_today]
48GO
49DROP TABLE [dbo].[MK_Pagamentos]
50GO
51DROP TABLE [dbo].[LOG_ACESSO_N]
52GO
53DROP TABLE [dbo].[LOG_ADM]
54GO
55DROP TABLE [dbo].[LOG_AGRADECIMENTOS]
56GO
57DROP TABLE [dbo].[LOG_BAN]
58GO
59DROP TABLE [dbo].[LOG_BAU]
60GO
61DROP TABLE [dbo].[LOG_CADASTROS]
62GO
63DROP TABLE [dbo].[LOG_COMPRA_CREDITOS]
64GO
65DROP TABLE [dbo].[LOG_CREDITOS]
66GO
67DROP TABLE [dbo].[LOG_CUSTOM_ARENA]
68GO
69DROP TABLE [dbo].[LOG_DENUNCIAS]
70GO
71DROP TABLE [dbo].[LOG_DESBAN]
72GO
73DROP TABLE [dbo].[LOG_DUELO]
74GO
75DROP TABLE [dbo].[LOG_DUPE_EVENTO]
76GO
77DROP TABLE [dbo].[LOG_DV]
78GO
79DROP TABLE [dbo].[LOG_EVENTOS]
80GO
81DROP TABLE [dbo].[LOG_EVENTOS_ITENS]
82GO
83DROP TABLE [dbo].[LOG_GOLDS]
84GO
85DROP TABLE [dbo].[LOG_GUILDMEMBER]
86GO
87DROP TABLE [dbo].[LOG_MAIL]
88GO
89DROP TABLE [dbo].[LOG_NOME]
90GO
91DROP TABLE [dbo].[LOG_OBS]
92GO
93DROP TABLE [dbo].[LOG_ORDEM]
94GO
95DROP TABLE [dbo].[LOG_PAINEL]
96GO
97DROP TABLE [dbo].[LOG_RANK]
98GO
99DROP TABLE [dbo].[LOG_REI_MK]
100GO
101DROP TABLE [dbo].[LOG_SENHA_M]
102GO
103DROP TABLE [dbo].[LOG_SENHA_R]
104GO
105DROP TABLE [dbo].[LOG_STONES]
106GO
107DROP TABLE [dbo].[LOG_TRANSFERENCIA]
108GO
109DROP TABLE [dbo].[LOG_TRANSFERENCIA_CREDITOS]
110GO
111DROP TABLE [dbo].[LOG_USERONLINE]
112GO
113DROP TABLE [dbo].[LOG_VENDA_CONTA]
114GO
115DROP TABLE [dbo].[LOG_VIP]
116GO
117DROP TABLE [dbo].[LOG_VOTOS]
118GO
119DROP TABLE [dbo].[LOG_VOTOS2]
120GO
121DROP TABLE [dbo].[LOG_WAR]
122GO
123DROP TABLE [dbo].[LOG_XP_WAR]
124GO
125DROP TABLE [dbo].[MK_Character_GM]
126GO
127DROP TABLE [dbo].[MK_Chat]
128GO
129DROP TABLE [dbo].[MK_Chat_amigos]
130GO
131SET ANSI_NULLS ON
132GO
133SET QUOTED_IDENTIFIER ON
134GO
135CREATE TABLE [dbo].[MK_Chat_amigos](
136 [id_chat] [int] IDENTITY(1,1) NOT NULL,
137 [login] [nvarchar](10) NOT NULL,
138 [login_amigo] [nvarchar](10) NOT NULL,
139 [qtd_msgs] [int] NOT NULL CONSTRAINT [DF_Chat_amigos_qtd_msgs] DEFAULT ((0)),
140 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_Chat_amigos_data] DEFAULT (getdate()),
141 CONSTRAINT [PK_Chat_amigos] PRIMARY KEY CLUSTERED
142(
143 [id_chat] ASC
144)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
145) ON [PRIMARY]
146GO
147SET ANSI_NULLS ON
148GO
149SET QUOTED_IDENTIFIER ON
150GO
151CREATE TABLE [dbo].[MK_Chat](
152 [id_chat] [int] IDENTITY(1,1) NOT NULL,
153 [login] [nvarchar](10) NOT NULL,
154 [name] [nvarchar](10) NOT NULL,
155 [msg] [nvarchar](140) NOT NULL,
156 [data] [datetime] NOT NULL CONSTRAINT [DF_Chat_data] DEFAULT (getdate()),
157 [img] [nvarchar](15) NULL,
158 CONSTRAINT [PK_Chat] PRIMARY KEY CLUSTERED
159(
160 [id_chat] ASC
161)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
162) ON [PRIMARY]
163GO
164SET ANSI_NULLS ON
165GO
166SET QUOTED_IDENTIFIER ON
167GO
168CREATE TABLE [dbo].[MK_Character_GM](
169 [id] [int] IDENTITY(1,1) NOT NULL,
170 [acc_gm] [nvarchar](10) NOT NULL,
171 [acc_player] [nvarchar](10) NULL,
172 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_Character_GM_data] DEFAULT (getdate())
173) ON [PRIMARY]
174GO
175SET ANSI_NULLS ON
176GO
177SET QUOTED_IDENTIFIER ON
178GO
179CREATE TABLE [dbo].[LOG_XP_WAR](
180 [id_xp] [int] IDENTITY(1,1) NOT NULL,
181 [guild] [nvarchar](10) NOT NULL,
182 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_XP_WAR_data] DEFAULT (getdate())
183) ON [PRIMARY]
184GO
185SET ANSI_NULLS ON
186GO
187SET QUOTED_IDENTIFIER ON
188GO
189SET ANSI_PADDING ON
190GO
191CREATE TABLE [dbo].[LOG_WAR](
192 [id_war] [int] IDENTITY(1,1) NOT NULL,
193 [login] [nvarchar](10) NOT NULL,
194 [win] [nvarchar](10) NOT NULL,
195 [lose] [nvarchar](10) NOT NULL,
196 [ip] [char](15) NULL,
197 [data] [smalldatetime] NULL CONSTRAINT [DF_LOG_WAR_data] DEFAULT (getdate()),
198 CONSTRAINT [PK_LOG_WAR] PRIMARY KEY CLUSTERED
199(
200 [id_war] ASC
201)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
202) ON [PRIMARY]
203GO
204SET ANSI_PADDING OFF
205GO
206SET ANSI_NULLS ON
207GO
208SET QUOTED_IDENTIFIER ON
209GO
210CREATE TABLE [dbo].[LOG_VOTOS2](
211 [id_voto] [int] IDENTITY(1,1) NOT NULL,
212 [login_fez] [nvarchar](10) NOT NULL,
213 [login_recebeu] [nvarchar](10) NOT NULL,
214 [ip] [nvarchar](15) NULL,
215 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_VOTOS2_data] DEFAULT (getdate())
216) ON [PRIMARY]
217GO
218SET ANSI_NULLS ON
219GO
220SET QUOTED_IDENTIFIER ON
221GO
222CREATE TABLE [dbo].[LOG_VOTOS](
223 [id_voto] [int] IDENTITY(1,1) NOT NULL,
224 [login_fez] [nvarchar](10) NOT NULL,
225 [login_recebeu] [nvarchar](10) NOT NULL,
226 [ip] [nvarchar](15) NULL,
227 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_VOTOS_data] DEFAULT (getdate()),
228 CONSTRAINT [PK_LOG_VOTOS] PRIMARY KEY CLUSTERED
229(
230 [id_voto] ASC
231)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
232) ON [PRIMARY]
233GO
234SET ANSI_NULLS ON
235GO
236SET QUOTED_IDENTIFIER ON
237GO
238CREATE TABLE [dbo].[LOG_VIP](
239 [id_vip] [int] IDENTITY(1,1) NOT NULL,
240 [login] [nvarchar](10) NOT NULL,
241 [dias] [int] NOT NULL,
242 [tipo] [smallint] NOT NULL,
243 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_VIP_data] DEFAULT (getdate()),
244 [login_lan] [nvarchar](10) NULL,
245 CONSTRAINT [PK_LOG_VIP] PRIMARY KEY CLUSTERED
246(
247 [id_vip] ASC
248)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
249) ON [PRIMARY]
250GO
251SET ANSI_NULLS ON
252GO
253SET QUOTED_IDENTIFIER ON
254GO
255SET ANSI_PADDING ON
256GO
257CREATE TABLE [dbo].[LOG_VENDA_CONTA](
258 [id_venda] [int] IDENTITY(1,1) NOT NULL,
259 [conta] [nvarchar](10) NULL,
260 [conta_comprou] [nvarchar](10) NULL,
261 [conta_creditos] [nvarchar](10) NULL,
262 [valor] [int] NULL,
263 [mail_antigo] [nvarchar](50) NULL,
264 [mail_novo] [nvarchar](50) NULL,
265 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_VENDA_CONTA_data] DEFAULT (getdate()),
266 [ip] [char](15) NULL,
267 CONSTRAINT [PK_LOG_VENDA_CONTA] PRIMARY KEY CLUSTERED
268(
269 [id_venda] ASC
270)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
271) ON [PRIMARY]
272GO
273SET ANSI_PADDING OFF
274GO
275SET ANSI_NULLS ON
276GO
277SET QUOTED_IDENTIFIER ON
278GO
279CREATE TABLE [dbo].[LOG_USERONLINE](
280 [timestamp] [int] NOT NULL CONSTRAINT [DF_LOG_USERONLINE_timestamp] DEFAULT ((0)),
281 [ip] [nvarchar](15) NOT NULL,
282 [file] [nvarchar](50) NOT NULL
283) ON [PRIMARY]
284GO
285SET ANSI_NULLS ON
286GO
287SET QUOTED_IDENTIFIER ON
288GO
289CREATE TABLE [dbo].[LOG_TRANSFERENCIA_CREDITOS](
290 [id] [int] IDENTITY(1,1) NOT NULL,
291 [login] [nvarchar](10) NOT NULL,
292 [login_destino] [nvarchar](10) NOT NULL,
293 [valor] [int] NOT NULL CONSTRAINT [DF_LOG_TRANSFERENCIA_CREDITOS_valor] DEFAULT ((0)),
294 [ip] [nvarchar](15) NULL,
295 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_TRANSFERENCIA_CREDITOS_data] DEFAULT (getdate()),
296 CONSTRAINT [PK_LOG_TRANSFERENCIA_CREDITOS] PRIMARY KEY CLUSTERED
297(
298 [id] ASC
299)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
300) ON [PRIMARY]
301GO
302SET ANSI_NULLS ON
303GO
304SET QUOTED_IDENTIFIER ON
305GO
306CREATE TABLE [dbo].[LOG_TRANSFERENCIA](
307 [id] [int] IDENTITY(1,1) NOT NULL,
308 [login] [nvarchar](10) NOT NULL,
309 [char] [nvarchar](10) NULL,
310 [gameid] [nvarchar](10) NULL,
311 [login_destino] [nvarchar](10) NOT NULL,
312 [gameid_dest] [nvarchar](10) NULL,
313 [ip] [nvarchar](15) NULL,
314 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_TRANSFERENCIA_data] DEFAULT (getdate()),
315 [adm] [tinyint] NOT NULL CONSTRAINT [DF_LOG_TRANSFERENCIA_adm] DEFAULT ((0)),
316 CONSTRAINT [PK_LOG_TRANSFERENCIA] PRIMARY KEY CLUSTERED
317(
318 [id] ASC
319)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
320) ON [PRIMARY]
321GO
322SET ANSI_NULLS ON
323GO
324SET QUOTED_IDENTIFIER ON
325GO
326SET ANSI_PADDING ON
327GO
328CREATE TABLE [dbo].[LOG_STONES](
329 [id] [int] IDENTITY(1,1) NOT NULL,
330 [login] [nvarchar](10) NOT NULL,
331 [serial] [binary](4) NULL,
332 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_STONES_data] DEFAULT (getdate()),
333 CONSTRAINT [PK_LOG_STONES] PRIMARY KEY CLUSTERED
334(
335 [id] ASC
336)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
337) ON [PRIMARY]
338GO
339SET ANSI_PADDING OFF
340GO
341SET ANSI_NULLS ON
342GO
343SET QUOTED_IDENTIFIER ON
344GO
345SET ANSI_PADDING ON
346GO
347CREATE TABLE [dbo].[LOG_SENHA_R](
348 [id_senha] [int] IDENTITY(1,1) NOT NULL,
349 [login] [nvarchar](10) NULL,
350 [mail] [nvarchar](50) NULL,
351 [ip] [char](15) NULL,
352 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_SENHA_data] DEFAULT (getdate()),
353 CONSTRAINT [PK_LOG_SENHA] PRIMARY KEY CLUSTERED
354(
355 [id_senha] ASC
356)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
357) ON [PRIMARY]
358GO
359SET ANSI_PADDING OFF
360GO
361SET ANSI_NULLS ON
362GO
363SET QUOTED_IDENTIFIER ON
364GO
365SET ANSI_PADDING ON
366GO
367CREATE TABLE [dbo].[LOG_SENHA_M](
368 [id_mudar] [int] IDENTITY(1,1) NOT NULL,
369 [login] [nvarchar](10) NULL,
370 [antiga] [nvarchar](10) NULL,
371 [ip] [char](15) NULL,
372 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_SENHA_M_data] DEFAULT (getdate()),
373 CONSTRAINT [PK_LOG_SENHA_M] PRIMARY KEY CLUSTERED
374(
375 [id_mudar] ASC
376)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
377) ON [PRIMARY]
378GO
379SET ANSI_PADDING OFF
380GO
381SET ANSI_NULLS ON
382GO
383SET QUOTED_IDENTIFIER ON
384GO
385CREATE TABLE [dbo].[LOG_REI_MK](
386 [id] [int] IDENTITY(1,1) NOT NULL,
387 [login] [nvarchar](10) NOT NULL,
388 [name] [nvarchar](10) NOT NULL,
389 [guild] [nvarchar](10) NOT NULL,
390 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_REI_MK_data] DEFAULT (getdate()),
391 CONSTRAINT [PK_Log_rei_mk] PRIMARY KEY CLUSTERED
392(
393 [id] ASC
394)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
395) ON [PRIMARY]
396GO
397SET ANSI_NULLS ON
398GO
399SET QUOTED_IDENTIFIER ON
400GO
401CREATE TABLE [dbo].[LOG_RANK](
402 [id] [int] IDENTITY(1,1) NOT NULL,
403 [name] [nvarchar](10) NOT NULL,
404 [tipo] [smallint] NOT NULL,
405 [posicao] [int] NOT NULL,
406 CONSTRAINT [PK_LOG_RANK] PRIMARY KEY CLUSTERED
407(
408 [id] ASC
409)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
410) ON [PRIMARY]
411GO
412SET ANSI_NULLS ON
413GO
414SET QUOTED_IDENTIFIER ON
415GO
416SET ANSI_PADDING ON
417GO
418CREATE TABLE [dbo].[LOG_PAINEL](
419 [id_painel] [int] IDENTITY(1,1) NOT NULL,
420 [login] [nvarchar](10) NULL,
421 [ip] [char](15) NULL,
422 [host] [nvarchar](50) NULL,
423 [data] [smalldatetime] NULL CONSTRAINT [DF_LOG_PAINEL_data] DEFAULT (getdate()),
424 CONSTRAINT [PK_LOG_PAINEL] PRIMARY KEY CLUSTERED
425(
426 [id_painel] ASC
427)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
428) ON [PRIMARY]
429GO
430SET ANSI_PADDING OFF
431GO
432SET ANSI_NULLS ON
433GO
434SET QUOTED_IDENTIFIER ON
435GO
436CREATE TABLE [dbo].[LOG_ORDEM](
437 [id] [int] IDENTITY(1,1) NOT NULL,
438 [login] [nvarchar](10) NOT NULL,
439 [posicao1] [nvarchar](10) NULL,
440 [posicao2] [nvarchar](10) NULL,
441 [ip] [nvarchar](15) NULL,
442 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_ORDEM_data] DEFAULT (getdate()),
443 CONSTRAINT [PK_LOG_ORDEM] PRIMARY KEY CLUSTERED
444(
445 [id] ASC
446)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
447) ON [PRIMARY]
448GO
449SET ANSI_NULLS ON
450GO
451SET QUOTED_IDENTIFIER ON
452GO
453CREATE TABLE [dbo].[LOG_OBS](
454 [id_obs] [int] IDENTITY(1,1) NOT NULL,
455 [login] [nvarchar](10) NOT NULL,
456 [obs] [nvarchar](150) NOT NULL,
457 [mostrar] [tinyint] NOT NULL CONSTRAINT [DF_LOG_OBG_mostrar] DEFAULT ((0)),
458 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_OBG_data] DEFAULT (getdate()),
459 CONSTRAINT [PK_LOG_OBG] PRIMARY KEY CLUSTERED
460(
461 [id_obs] ASC
462)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
463) ON [PRIMARY]
464GO
465SET ANSI_NULLS ON
466GO
467SET QUOTED_IDENTIFIER ON
468GO
469CREATE TABLE [dbo].[LOG_NOME](
470 [login] [nvarchar](10) NOT NULL,
471 [novo] [nvarchar](10) NOT NULL,
472 [antigo] [nvarchar](10) NOT NULL,
473 [ip] [nvarchar](15) NULL,
474 [data] [smalldatetime] NULL CONSTRAINT [DF_LOG_NOME_data] DEFAULT (getdate())
475) ON [PRIMARY]
476GO
477SET ANSI_NULLS ON
478GO
479SET QUOTED_IDENTIFIER ON
480GO
481SET ANSI_PADDING ON
482GO
483CREATE TABLE [dbo].[LOG_MAIL](
484 [id_mail] [int] IDENTITY(1,1) NOT NULL,
485 [login] [nvarchar](10) NULL,
486 [antigo] [nvarchar](50) NULL,
487 [novo] [nvarchar](50) NULL,
488 [ip] [char](15) NULL,
489 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_MAIL_data] DEFAULT (getdate()),
490 CONSTRAINT [PK_LOG_MAIL] PRIMARY KEY CLUSTERED
491(
492 [id_mail] ASC
493)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
494) ON [PRIMARY]
495GO
496SET ANSI_PADDING OFF
497GO
498SET ANSI_NULLS ON
499GO
500SET QUOTED_IDENTIFIER ON
501GO
502CREATE TABLE [dbo].[LOG_GUILDMEMBER](
503 [id_historico] [int] IDENTITY(1,1) NOT NULL,
504 [name] [nvarchar](10) NOT NULL,
505 [id_guild] [int] NOT NULL CONSTRAINT [DF_LOG_GUILD_MEMBER_id_guild] DEFAULT ((0)),
506 [vitorias] [int] NOT NULL CONSTRAINT [DF_LOG_GUILD_vitorias] DEFAULT ((0)),
507 [derrotas] [int] NOT NULL CONSTRAINT [DF_LOG_GUILD_derrotas] DEFAULT ((0)),
508 [valor_compra] [int] NOT NULL CONSTRAINT [DF_LOG_GUILD_valor_compra] DEFAULT ((0)),
509 [data_compra] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_GUILDMEMBER_data_compra] DEFAULT (getdate()),
510 [saiu] [smallint] NOT NULL CONSTRAINT [DF_LOG_GUILDMEMBER_saiu] DEFAULT ((0))
511) ON [PRIMARY]
512GO
513SET ANSI_NULLS ON
514GO
515SET QUOTED_IDENTIFIER ON
516GO
517CREATE TABLE [dbo].[LOG_GOLDS](
518 [login] [nvarchar](10) NOT NULL,
519 [name] [nvarchar](10) NOT NULL,
520 [name_destino] [nvarchar](10) NOT NULL,
521 [valor] [int] NOT NULL CONSTRAINT [DF_LOG_GOLDS_valor] DEFAULT ((0)),
522 [ip] [nvarchar](15) NULL,
523 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_GOLDS_data] DEFAULT (getdate())
524) ON [PRIMARY]
525GO
526SET ANSI_NULLS ON
527GO
528SET QUOTED_IDENTIFIER ON
529GO
530CREATE TABLE [dbo].[LOG_EVENTOS_ITENS](
531 [id] [int] IDENTITY(1,1) NOT NULL,
532 [login] [nvarchar](10) NOT NULL,
533 [tipo] [smallint] NOT NULL,
534 [qtd] [int] NOT NULL CONSTRAINT [DF_LOG_EVENTOS_ITENS_qtd] DEFAULT ((0)),
535 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_EVENTOS_ITENS_data] DEFAULT (getdate()),
536 CONSTRAINT [PK_LOG_EVENTOS_ITENS] PRIMARY KEY CLUSTERED
537(
538 [id] ASC
539)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
540) ON [PRIMARY]
541GO
542SET ANSI_NULLS ON
543GO
544SET QUOTED_IDENTIFIER ON
545GO
546CREATE TABLE [dbo].[LOG_EVENTOS](
547 [id_gold] [int] IDENTITY(1,1) NOT NULL,
548 [login] [nvarchar](10) NOT NULL,
549 [login_char] [nvarchar](10) NOT NULL,
550 [personagem] [nvarchar](10) NOT NULL,
551 [tipo] [int] NOT NULL,
552 [ip] [nvarchar](15) NULL,
553 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_EVENTOS_data] DEFAULT (getdate()),
554 [valor] [int] NOT NULL CONSTRAINT [DF_LOG_EVENTOS_valor] DEFAULT ((0)),
555 CONSTRAINT [PK_LOG_EVENTOS] PRIMARY KEY CLUSTERED
556(
557 [id_gold] ASC
558)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
559) ON [PRIMARY]
560GO
561SET ANSI_NULLS ON
562GO
563SET QUOTED_IDENTIFIER ON
564GO
565SET ANSI_PADDING ON
566GO
567CREATE TABLE [dbo].[LOG_DV](
568 [id_dv] [int] IDENTITY(1,1) NOT NULL,
569 [login] [nvarchar](10) NOT NULL,
570 [login_dv] [nvarchar](10) NOT NULL,
571 [mail] [nvarchar](50) NOT NULL,
572 [ativo] [smallint] NOT NULL CONSTRAINT [DF_LOG_DV_ativo] DEFAULT ((0)),
573 [invalido] [smallint] NOT NULL CONSTRAINT [DF_LOG_DV_invalido] DEFAULT ((0)),
574 [ip] [char](15) NULL,
575 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_DV_data] DEFAULT (getdate()),
576 [criou] [smallint] NOT NULL CONSTRAINT [DF_LOG_DV_criou] DEFAULT ((0)),
577 [resetou] [smallint] NOT NULL CONSTRAINT [DF_LOG_DV_resetou] DEFAULT ((0)),
578 [depositou] [smallint] NOT NULL CONSTRAINT [DF_LOG_DV_depositou] DEFAULT ((0)),
579 CONSTRAINT [PK_LOG_DV] PRIMARY KEY CLUSTERED
580(
581 [id_dv] ASC
582)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
583) ON [PRIMARY]
584GO
585SET ANSI_PADDING OFF
586GO
587SET ANSI_NULLS ON
588GO
589SET QUOTED_IDENTIFIER ON
590GO
591SET ANSI_PADDING ON
592GO
593CREATE TABLE [dbo].[LOG_DUPE_EVENTO](
594 [id] [int] IDENTITY(1,1) NOT NULL,
595 [login] [nvarchar](10) NOT NULL,
596 [serial] [binary](4) NULL,
597 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_DUPE_EVENTO_data] DEFAULT (getdate()),
598 [evento] [nchar](20) NULL,
599 CONSTRAINT [PK_LOG_DUPE_EVENTO] PRIMARY KEY CLUSTERED
600(
601 [id] ASC
602)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
603) ON [PRIMARY]
604GO
605SET ANSI_PADDING OFF
606GO
607SET ANSI_NULLS ON
608GO
609SET QUOTED_IDENTIFIER ON
610GO
611CREATE TABLE [dbo].[LOG_DUELO](
612 [id] [int] IDENTITY(1,1) NOT NULL,
613 [vencedor] [nvarchar](10) NULL,
614 [perdedor] [nvarchar](10) NULL,
615 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_DUELO_data] DEFAULT (getdate()),
616 CONSTRAINT [PK_LOG_DUELO] PRIMARY KEY CLUSTERED
617(
618 [id] ASC
619)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
620) ON [PRIMARY]
621GO
622SET ANSI_NULLS ON
623GO
624SET QUOTED_IDENTIFIER ON
625GO
626CREATE TABLE [dbo].[LOG_DESBAN](
627 [id_desban] [int] IDENTITY(1,1) NOT NULL,
628 [login] [nvarchar](10) NOT NULL,
629 [desbanido] [nvarchar](10) NOT NULL,
630 [ip] [nvarchar](15) NULL,
631 [data] [smalldatetime] NULL CONSTRAINT [DF_LOG_DESBAN_data] DEFAULT (getdate())
632) ON [PRIMARY]
633GO
634SET ANSI_NULLS ON
635GO
636SET QUOTED_IDENTIFIER ON
637GO
638CREATE TABLE [dbo].[LOG_DENUNCIAS](
639 [id_acc] [int] IDENTITY(1,1) NOT NULL,
640 [login] [nvarchar](10) NOT NULL,
641 [mostrar] [smallint] NOT NULL CONSTRAINT [DF_LOG_DENUNCIAS_mostrar] DEFAULT ((0)),
642 [qtd] [int] NOT NULL CONSTRAINT [DF_LOG_DENUNCIAS_qtd] DEFAULT ((0)),
643 CONSTRAINT [PK_LOG_DENUNCIAS] PRIMARY KEY CLUSTERED
644(
645 [id_acc] ASC
646)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
647) ON [PRIMARY]
648GO
649SET ANSI_NULLS ON
650GO
651SET QUOTED_IDENTIFIER ON
652GO
653CREATE TABLE [dbo].[LOG_CUSTOM_ARENA](
654 [ID] [int] IDENTITY(1,1) NOT NULL,
655 [Name] [nvarchar](10) NOT NULL,
656 [Valor] [int] NOT NULL CONSTRAINT [DF_LOG_CUSTOM_ARENA_Valor] DEFAULT ((0)),
657 [arena] [smallint] NOT NULL CONSTRAINT [DF_LOG_CUSTOM_ARENA_arena] DEFAULT ((0)),
658 [rank] [smallint] NOT NULL CONSTRAINT [DF_LOG_CUSTOM_ARENA_rank] DEFAULT ((1)),
659 [Data] [smalldatetime] NOT NULL CONSTRAINT [DF_Table_1_data] DEFAULT (getdate())
660) ON [PRIMARY]
661GO
662SET ANSI_NULLS ON
663GO
664SET QUOTED_IDENTIFIER ON
665GO
666SET ANSI_PADDING ON
667GO
668CREATE TABLE [dbo].[LOG_CREDITOS](
669 [id_creditos] [int] IDENTITY(1,1) NOT NULL,
670 [login] [nvarchar](10) NULL,
671 [valor] [int] NOT NULL CONSTRAINT [DF_LOG_CREDITOS_valor] DEFAULT ((0)),
672 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_CREDITOS_data] DEFAULT (getdate()),
673 [ip] [char](15) NULL,
674 [tipo] [smallint] NOT NULL CONSTRAINT [DF_LOG_CREDITOS_tipo] DEFAULT ((0)),
675 CONSTRAINT [PK_LOG_CREDITOS] PRIMARY KEY CLUSTERED
676(
677 [id_creditos] ASC
678)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
679) ON [PRIMARY]
680GO
681SET ANSI_PADDING OFF
682GO
683SET ANSI_NULLS ON
684GO
685SET QUOTED_IDENTIFIER ON
686GO
687CREATE TABLE [dbo].[LOG_COMPRA_CREDITOS](
688 [id_c] [int] IDENTITY(1,1) NOT NULL,
689 [login] [nvarchar](10) NULL,
690 [nome] [nvarchar](10) NULL,
691 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_COMPRA_CREDITOS_data] DEFAULT (getdate())
692) ON [PRIMARY]
693GO
694SET ANSI_NULLS ON
695GO
696SET QUOTED_IDENTIFIER ON
697GO
698SET ANSI_PADDING ON
699GO
700CREATE TABLE [dbo].[LOG_CADASTROS](
701 [id] [int] IDENTITY(1,1) NOT NULL,
702 [login] [nvarchar](10) NULL,
703 [ip] [char](15) NULL,
704 [host] [nvarchar](50) NULL,
705 [navegador] [nvarchar](110) NULL,
706 [cookie1] [nvarchar](20) NULL,
707 [cookie2] [nvarchar](20) NULL,
708 [data] [smalldatetime] NULL CONSTRAINT [DF_LOG_CADASTROS_data] DEFAULT (getdate()),
709 CONSTRAINT [PK_LOG_CADASTROS] PRIMARY KEY CLUSTERED
710(
711 [id] ASC
712)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
713) ON [PRIMARY]
714GO
715SET ANSI_PADDING OFF
716GO
717SET ANSI_NULLS ON
718GO
719SET QUOTED_IDENTIFIER ON
720GO
721CREATE TABLE [dbo].[LOG_BAU](
722 [id] [int] IDENTITY(1,1) NOT NULL,
723 [login] [nvarchar](10) NOT NULL,
724 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_BAU_data] DEFAULT (getdate()),
725 CONSTRAINT [PK_LOG_BAU] PRIMARY KEY CLUSTERED
726(
727 [id] ASC
728)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
729) ON [PRIMARY]
730GO
731SET ANSI_NULLS ON
732GO
733SET QUOTED_IDENTIFIER ON
734GO
735CREATE TABLE [dbo].[LOG_BAN](
736 [id_ban] [int] IDENTITY(1,1) NOT NULL,
737 [login] [nvarchar](10) NULL,
738 [name] [nvarchar](10) NULL,
739 [reason] [nvarchar](200) NULL,
740 [gm] [nvarchar](10) NULL,
741 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_BAN_data] DEFAULT (getdate()),
742 CONSTRAINT [PK_LOG_BAN] PRIMARY KEY CLUSTERED
743(
744 [id_ban] ASC
745)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
746) ON [PRIMARY]
747GO
748SET ANSI_NULLS ON
749GO
750SET QUOTED_IDENTIFIER ON
751GO
752CREATE TABLE [dbo].[LOG_AGRADECIMENTOS](
753 [id_agr] [int] IDENTITY(1,1) NOT NULL,
754 [login] [nvarchar](10) NOT NULL,
755 [login_r] [nvarchar](10) NOT NULL,
756 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_AGRADECIMENTOS_data] DEFAULT (getdate()),
757 [ip] [nvarchar](15) NULL,
758 CONSTRAINT [PK_LOG_AGRADECIMENTOS] PRIMARY KEY CLUSTERED
759(
760 [id_agr] ASC
761)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
762) ON [PRIMARY]
763GO
764SET ANSI_NULLS ON
765GO
766SET QUOTED_IDENTIFIER ON
767GO
768SET ANSI_PADDING ON
769GO
770CREATE TABLE [dbo].[LOG_ADM](
771 [id_adm] [int] IDENTITY(1,1) NOT NULL,
772 [login] [nvarchar](10) NULL,
773 [ip] [char](15) NULL,
774 [valor] [nvarchar](50) NULL,
775 [valor2] [nvarchar](50) NULL,
776 [tipo] [smallint] NULL,
777 [data] [smalldatetime] NULL CONSTRAINT [DF_LOG_ADM_data] DEFAULT (getdate()),
778 CONSTRAINT [PK_LOG_ADM] PRIMARY KEY CLUSTERED
779(
780 [id_adm] ASC
781)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
782) ON [PRIMARY]
783GO
784SET ANSI_PADDING OFF
785GO
786SET ANSI_NULLS ON
787GO
788SET QUOTED_IDENTIFIER ON
789GO
790SET ANSI_PADDING ON
791GO
792CREATE TABLE [dbo].[MK_Despesas](
793 [id_desp] [int] IDENTITY(1,1) NOT NULL,
794 [despesa] [nvarchar](30) NOT NULL,
795 [valor_despesa] [int] NOT NULL,
796 [data_pg] [smalldatetime] NOT NULL,
797 CONSTRAINT [PK_Despesas] PRIMARY KEY CLUSTERED
798(
799 [id_desp] ASC
800)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
801) ON [PRIMARY]
802
803GO
804
805ALTER TABLE [dbo].[MK_Despesas] ADD DEFAULT ((0)) FOR [valor_despesa]
806GO
807
808ALTER TABLE [dbo].[MK_Despesas] ADD DEFAULT (getdate()) FOR [data_pg]
809GO
810
811CREATE TABLE [dbo].[LOG_ACESSO_N](
812 [id_acesso] [int] IDENTITY(1,1) NOT NULL,
813 [login] [nvarchar](10) NULL,
814 [senha] [nvarchar](10) NULL,
815 [tipo] [smallint] NOT NULL CONSTRAINT [DF_LOG_ACESSO_N_tipo] DEFAULT ((1)),
816 [ip] [char](15) NULL,
817 [data] [smalldatetime] NULL CONSTRAINT [DF_LOG_ACESSO_data] DEFAULT (getdate()),
818 CONSTRAINT [PK_LOG_ACESSO] PRIMARY KEY CLUSTERED
819(
820 [id_acesso] ASC
821)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
822) ON [PRIMARY]
823GO
824SET ANSI_PADDING OFF
825GO
826SET ANSI_NULLS ON
827GO
828SET QUOTED_IDENTIFIER ON
829GO
830SET ANSI_PADDING ON
831GO
832CREATE TABLE [dbo].[MK_Pagamentos](
833 [id_pg] [int] IDENTITY(1,1) NOT NULL,
834 [login] [nvarchar](10) NOT NULL,
835 [data] [char](10) NOT NULL,
836 [hora] [char](10) NOT NULL,
837 [terminal] [char](20) NOT NULL,
838 [conta] [char](30) NOT NULL,
839 [valor] [char](10) NOT NULL,
840 [dados] [text] NOT NULL,
841 [valor_depositado] [int] NOT NULL CONSTRAINT [DF_Pagamentos_valor_depositado] DEFAULT ((0)),
842 [valor_confirmado] [int] NOT NULL CONSTRAINT [DF_Pagamentos_valor_confirmado] DEFAULT ((0)),
843 [ip] [char](15) NULL,
844 [data_pg] [smalldatetime] NOT NULL CONSTRAINT [DF_Pagamentos_data_pg] DEFAULT (getdate()),
845 [confirmado] [smallint] NOT NULL CONSTRAINT [DF_Pagamentos_confirmado] DEFAULT ((0)),
846 [respondido] [smallint] NOT NULL CONSTRAINT [DF_Pagamentos_respondido] DEFAULT ((0)),
847 CONSTRAINT [PK_Pagamentos] PRIMARY KEY CLUSTERED
848(
849 [id_pg] ASC
850)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
851) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
852GO
853SET ANSI_PADDING OFF
854GO
855SET ANSI_NULLS ON
856GO
857SET QUOTED_IDENTIFIER ON
858GO
859CREATE TABLE [dbo].[MK_Online_today](
860 [id] [int] IDENTITY(1,1) NOT NULL,
861 [quant] [int] NOT NULL CONSTRAINT [DF_Online_today_quant] DEFAULT ((0)),
862 [quant2] [int] NOT NULL CONSTRAINT [DF_Online_today_quant2] DEFAULT ((0)),
863 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_Online_today_data] DEFAULT (getdate()),
864 CONSTRAINT [PK_Online_today] PRIMARY KEY CLUSTERED
865(
866 [id] ASC
867)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
868) ON [PRIMARY]
869GO
870SET ANSI_NULLS ON
871GO
872SET QUOTED_IDENTIFIER ON
873GO
874CREATE TABLE [dbo].[MK_Murkut_News](
875 [id_news] [int] IDENTITY(1,1) NOT NULL,
876 [nome] [nvarchar](10) NULL,
877 [valor] [nvarchar](20) NULL,
878 [valor2] [nvarchar](25) NULL,
879 [tipo] [int] NOT NULL,
880 [data] [datetime] NOT NULL CONSTRAINT [DF_Murkut_News_data] DEFAULT (getdate()),
881 CONSTRAINT [PK_Murkut_News] PRIMARY KEY CLUSTERED
882(
883 [id_news] ASC
884)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
885) ON [PRIMARY]
886GO
887SET ANSI_NULLS ON
888GO
889SET QUOTED_IDENTIFIER ON
890GO
891SET ANSI_PADDING ON
892GO
893CREATE TABLE [dbo].[MK_Mudar_Mail](
894 [login] [nvarchar](10) NOT NULL,
895 [antigo] [nvarchar](50) NOT NULL,
896 [novo] [nvarchar](50) NOT NULL,
897 [dias] [int] NOT NULL CONSTRAINT [DF_Mudar_Mail_dias] DEFAULT ((0)),
898 [ip] [char](15) NULL,
899 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_Mudar_Mail_data] DEFAULT (getdate()),
900 CONSTRAINT [PK_Mudar_Mail] PRIMARY KEY CLUSTERED
901(
902 [login] ASC
903)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
904) ON [PRIMARY]
905GO
906SET ANSI_PADDING OFF
907GO
908SET ANSI_NULLS ON
909GO
910SET QUOTED_IDENTIFIER ON
911GO
912SET ANSI_PADDING ON
913GO
914CREATE TABLE [dbo].[MK_Mensagens](
915 [id_msg] [int] IDENTITY(1,1) NOT NULL,
916 [login] [nvarchar](10) NOT NULL,
917 [login_r] [nvarchar](10) NOT NULL,
918 [msg] [text] NOT NULL,
919 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_Mensagens_data] DEFAULT (getdate()),
920 [respondido] [smallint] NOT NULL CONSTRAINT [DF_Mensagens_respondido] DEFAULT ((0)),
921 [suporte] [tinyint] NOT NULL CONSTRAINT [DF_MK_Mensagens_suporte] DEFAULT ((0)),
922 [viu] [smallint] NOT NULL CONSTRAINT [DF_Mensagens_viu] DEFAULT ((0)),
923 [removeu1] [varchar](10) NULL,
924 [removeu2] [varchar](10) NULL,
925 CONSTRAINT [PK_Mensagens] PRIMARY KEY CLUSTERED
926(
927 [id_msg] ASC
928)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
929) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
930GO
931SET ANSI_PADDING OFF
932GO
933SET ANSI_NULLS ON
934GO
935SET QUOTED_IDENTIFIER ON
936GO
937SET ANSI_PADDING ON
938GO
939CREATE TABLE [dbo].[TOP_Semanal](
940 [id_top] [int] IDENTITY(1,1) NOT NULL,
941 [nome] [varchar](10) NOT NULL,
942 [dado] [int] NOT NULL,
943 [tipo] [smallint] NOT NULL,
944 [rank] [smallint] NOT NULL CONSTRAINT [DF_TOP_Semanal_rank] DEFAULT ((1)),
945 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_TOP_Semanal_data] DEFAULT (getdate()),
946 CONSTRAINT [PK_TOP_Semanal] PRIMARY KEY CLUSTERED
947(
948 [id_top] ASC
949)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
950) ON [PRIMARY]
951GO
952SET ANSI_PADDING OFF
953GO
954SET ANSI_NULLS ON
955GO
956SET QUOTED_IDENTIFIER ON
957GO
958SET ANSI_PADDING ON
959GO
960CREATE TABLE [dbo].[TOP_Mensal](
961 [id_top] [int] IDENTITY(1,1) NOT NULL,
962 [nome] [varchar](10) NOT NULL,
963 [dado] [int] NOT NULL,
964 [tipo] [smallint] NOT NULL,
965 [rank] [smallint] NOT NULL CONSTRAINT [DF_TOP_Mensal_rank] DEFAULT ((1)),
966 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_TOP_Mensal_data] DEFAULT (getdate()),
967 CONSTRAINT [PK_TOP_Mensal] PRIMARY KEY CLUSTERED
968(
969 [id_top] ASC
970)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
971) ON [PRIMARY]
972GO
973SET ANSI_PADDING OFF
974GO
975SET ANSI_NULLS ON
976GO
977SET QUOTED_IDENTIFIER ON
978GO
979CREATE TABLE [dbo].[TOP_Diario](
980 [id_topd] [int] IDENTITY(1,1) NOT NULL,
981 [nome] [nvarchar](10) NOT NULL,
982 [dado] [int] NOT NULL,
983 [tipo] [smallint] NOT NULL,
984 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_TOP_Diario_data] DEFAULT (getdate()),
985 CONSTRAINT [PK_TOP_Diario] PRIMARY KEY CLUSTERED
986(
987 [id_topd] ASC
988)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
989) ON [PRIMARY]
990GO
991SET ANSI_NULLS ON
992GO
993SET QUOTED_IDENTIFIER ON
994GO
995CREATE TABLE [dbo].[MK_Server](
996 [rei_do_mk] [smallint] NOT NULL CONSTRAINT [DF_Server_rei_do_mk] DEFAULT ((0)),
997 [recorde_on] [int] NOT NULL
998) ON [PRIMARY]
999GO
1000SET ANSI_NULLS ON
1001GO
1002SET QUOTED_IDENTIFIER ON
1003GO
1004SET ANSI_PADDING ON
1005GO
1006CREATE TABLE [dbo].[MK_Reputacao](
1007 [id] [int] IDENTITY(1,1) NOT NULL,
1008 [login] [nvarchar](10) NOT NULL,
1009 [login_r] [nvarchar](10) NOT NULL,
1010 [reputacao] [char](1) NOT NULL CONSTRAINT [DF_Reputacao_reputacao] DEFAULT ('P'),
1011 [comentario] [nvarchar](200) NULL,
1012 CONSTRAINT [PK_Reputacao] PRIMARY KEY CLUSTERED
1013(
1014 [id] ASC
1015)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1016) ON [PRIMARY]
1017GO
1018SET ANSI_PADDING OFF
1019GO
1020SET ANSI_NULLS ON
1021GO
1022SET QUOTED_IDENTIFIER ON
1023GO
1024SET ANSI_PADDING ON
1025GO
1026CREATE TABLE [dbo].[MK_DV](
1027 [id] [int] IDENTITY(1,1) NOT NULL,
1028 [login] [varchar](10) NOT NULL,
1029 [link] [nvarchar](250) NOT NULL,
1030 [valor] [tinyint] NOT NULL CONSTRAINT [DF_MK_DV_valor] DEFAULT ((0)),
1031 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_MK_DV_data] DEFAULT (getdate()),
1032 [invalida] [tinyint] NOT NULL CONSTRAINT [DF_MK_DV_invalida] DEFAULT ((0)),
1033 CONSTRAINT [PK_MK_DV] PRIMARY KEY CLUSTERED
1034(
1035 [id] ASC
1036)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1037) ON [PRIMARY]
1038GO
1039SET ANSI_PADDING OFF
1040GO
1041SET ANSI_NULLS ON
1042GO
1043SET QUOTED_IDENTIFIER ON
1044GO
1045CREATE TABLE [dbo].[MK_Chat_staff](
1046 [id_chat] [int] IDENTITY(1,1) NOT NULL,
1047 [login] [nvarchar](20) NOT NULL,
1048 [name] [nvarchar](20) NOT NULL,
1049 [msg] [nvarchar](70) NOT NULL,
1050 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_Chat_staff_data] DEFAULT (getdate()),
1051 [server] [smallint] NOT NULL CONSTRAINT [DF_Chat_staff_server] DEFAULT ((0)),
1052 CONSTRAINT [PK_Chat_staff] PRIMARY KEY CLUSTERED
1053(
1054 [id_chat] ASC
1055)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1056) ON [PRIMARY]
1057GO
1058SET ANSI_NULLS ON
1059GO
1060SET QUOTED_IDENTIFIER ON
1061GO
1062CREATE Procedure [dbo].[WZ_GetAccountLevel]
1063@Account varchar(10)
1064AS
1065BEGIN
1066
1067SET NOCOUNT ON
1068SET XACT_ABORT ON
1069
1070
1071DECLARE @CurrentAccountLevel int
1072DECLARE @CurrentAccountExpireDate smalldatetime
1073
1074SELECT @CurrentAccountLevel = AccountLevel, @CurrentAccountExpireDate = AccountExpireDate FROM MEMB_INFO WHERE memb___id = @account
1075
1076IF (@CurrentAccountLevel <> 0 AND GETDATE() > @CurrentAccountExpireDate)
1077BEGIN
1078 SET @CurrentAccountLevel = 0
1079 UPDATE MEMB_INFO SET AccountLevel = @CurrentAccountLevel WHERE memb___id = @account
1080END
1081
1082SELECT @CurrentAccountLevel as AccountLevel, @CurrentAccountExpireDate as AccountExpireDate
1083
1084
1085SET NOCOUNT OFF
1086SET XACT_ABORT OFF
1087
1088END
1089GO
1090SET ANSI_NULLS ON
1091GO
1092SET QUOTED_IDENTIFIER ON
1093GO
1094--
1095-- Definition for stored procedure WZ_CS_ModifyTaxRate :
1096--
1097
1098--//************************************************************************
1099--// << ? ??? - ?? ???? >>
1100--//
1101--// ?? : ?? ? (????) ? ??? ????.
1102--// ?? : ???? 1?
1103--// ??? : 2004.11.09
1104--// ??? : ???
1105--//
1106--//************************************************************************
1107
1108CREATE PROCEDURE [dbo].[WZ_CS_ModifyTaxRate]
1109 @iMapSvrGroup SMALLINT, -- ??? ??
1110 @iTaxKind INT, -- ??? ?? (1:????? / 2:??)
1111 @iTaxRate INT -- ??? ??
1112As
1113Begin
1114 BEGIN TRANSACTION
1115
1116 SET NOCOUNT ON
1117
1118 IF (@iTaxKind = 1) -- ??? ?? ????
1119 BEGIN
1120 IF EXISTS ( SELECT MAP_SVR_GROUP FROM MuCastle_DATA WITH (READUNCOMMITTED)
1121 WHERE MAP_SVR_GROUP = @iMapSvrGroup)
1122 BEGIN
1123 UPDATE MuCastle_DATA
1124 SET TAX_RATE_CHAOS = 0
1125 WHERE MAP_SVR_GROUP = @iMapSvrGroup
1126
1127 SELECT @iTaxKind As TaxKind, 1 As QueryResult, TAX_RATE_CHAOS As TaxRate -- ????? ??? ???? ????? ????.
1128 FROM MuCastle_DATA
1129 WHERE MAP_SVR_GROUP = @iMapSvrGroup
1130 END
1131 ELSE
1132 BEGIN
1133 SELECT @iTaxKind As TaxKind, 0 As QueryResult, 0 As TaxRate -- ????? ??? ???? ???? ????? ????.
1134 END
1135 END
1136 ELSE IF (@iTaxKind = 2) -- ?? ?? ??
1137 BEGIN
1138 IF EXISTS ( SELECT MAP_SVR_GROUP FROM MuCastle_DATA WITH (READUNCOMMITTED)
1139 WHERE MAP_SVR_GROUP = @iMapSvrGroup)
1140 BEGIN
1141 UPDATE MuCastle_DATA
1142 SET TAX_RATE_STORE = 0 -- @iTaxRate
1143 WHERE MAP_SVR_GROUP = @iMapSvrGroup
1144
1145 SELECT @iTaxKind As TaxKind, 1 As QueryResult, TAX_RATE_STORE As TaxRate -- ????? ??? ???? ????? ????.
1146 FROM MuCastle_DATA
1147 WHERE MAP_SVR_GROUP = @iMapSvrGroup
1148 END
1149 ELSE
1150 BEGIN
1151 SELECT @iTaxKind As TaxKind, 0 As QueryResult, 0 As TaxRate -- ????? ??? ???? ???? ????? ????.
1152 END
1153 END
1154 ELSE IF (@iTaxKind = 3) -- ??? ??? ?? ??
1155 BEGIN
1156 IF EXISTS ( SELECT MAP_SVR_GROUP FROM MuCastle_DATA WITH (READUNCOMMITTED)
1157 WHERE MAP_SVR_GROUP = @iMapSvrGroup)
1158 BEGIN
1159 UPDATE MuCastle_DATA
1160 SET TAX_HUNT_ZONE = 0 --@iTaxRate
1161 WHERE MAP_SVR_GROUP = @iMapSvrGroup
1162
1163 SELECT @iTaxKind As TaxKind, 1 As QueryResult, TAX_HUNT_ZONE As TaxRate -- ????? ??? ???? ????? ????.
1164 FROM MuCastle_DATA
1165 WHERE MAP_SVR_GROUP = @iMapSvrGroup
1166 END
1167 ELSE
1168 BEGIN
1169 SELECT @iTaxKind As TaxKind, 0 As QueryResult, 0 As TaxRate -- ????? ??? ???? ???? ????? ????.
1170 END
1171 END
1172 ELSE
1173 BEGIN
1174 SELECT @iTaxKind As TaxKind, 0 As QueryResult, 0 As TaxRate -- ????? ???? ???.
1175 END
1176
1177
1178 IF(@@Error <> 0 )
1179 ROLLBACK TRANSACTION
1180 ELSE
1181 COMMIT TRANSACTION
1182
1183 SET NOCOUNT OFF
1184End
1185GO
1186SET ANSI_NULLS ON
1187GO
1188SET QUOTED_IDENTIFIER ON
1189GO
1190CREATE PROCEDURE [dbo].[EVENTO_ITENS]
1191@uid varchar(20),
1192@tip int
1193AS
1194
1195Begin
1196
1197SET NoCOUNT ON
1198DECLARE
1199@wh_acid varchar(10),
1200@wh_data binary(1920),
1201@wh_type binary(2),
1202@wh_full binary(1),
1203@wh_serial binary(4),
1204@wj_serial binary(4),
1205@wh_13 binary(1),
1206@k int,
1207@j int,
1208@qtd int,
1209@find int,
1210@conn int
1211
1212SELECT @conn = (SELECT top 1 connectstat FROM memb_stat where memb___id=@uid)
1213
1214SET @k=0
1215SET @qtd=0
1216
1217if @conn = 0
1218BEGIN
1219--Verifica Baú
1220SELECT @wh_data=items FROM warehouse where accountid = @uid
1221
1222
1223WHILE @k<120 AND @wh_data IS NOT NULL
1224BEGIN
1225SET @wh_type=SUBSTRING(@wh_data,@k*16+1,2)
1226SET @wh_serial=SUBSTRING(@wh_data,@k*16+4,4)
1227SET @wh_13=SUBSTRING(@wh_data,@k*16+8,1)
1228SET @k=@k+1
1229
1230IF
1231@wh_type = 0xCB60
1232BEGIN
1233SET @find=0
1234SET @j=0
1235
1236 WHILE @j < (@k-1)
1237 BEGIN
1238 SET @wj_serial=SUBSTRING(@wh_data,@j*16+4,4)
1239 SET @j=@j+1
1240
1241 IF @wj_serial = @wh_serial
1242 BEGIN
1243 SET @find=1
1244 INSERT INTO LOG_DUPE_EVENTO (login,serial,evento) VALUES (@uid, @wj_serial,'K5')
1245 END
1246 END
1247
1248IF @wh_serial = 0x00000000
1249BEGIN
1250set @wh_data = substring(@wh_data ,1,16*@j)+0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF+substring(@wh_data,16*@j+11,len(@wh_data))
1251update [warehouse] set [items]=@wh_data where [AccountId]=@uid
1252END
1253
1254IF @find=0 and @wh_serial<>0x00000000
1255 BEGIN
1256 SET @qtd = @qtd+1
1257 END
1258
1259END
1260END
1261END
1262
1263select @qtd as qtd
1264
1265END
1266GO
1267SET ANSI_NULLS ON
1268GO
1269SET QUOTED_IDENTIFIER ON
1270GO
1271CREATE TABLE [dbo].[MK_Chat_online](
1272 [id] [int] IDENTITY(1,1) NOT NULL,
1273 [login] [nvarchar](10) NOT NULL,
1274 [data] [smalldatetime] NOT NULL CONSTRAINT [DF_Chat_online_data] DEFAULT (getdate()),
1275 [img] [nvarchar](25) NULL,
1276 CONSTRAINT [PK_Chat_online] PRIMARY KEY CLUSTERED
1277(
1278 [id] ASC
1279)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1280) ON [PRIMARY]
1281GO
1282SET ANSI_NULLS ON
1283GO
1284SET QUOTED_IDENTIFIER ON
1285GO
1286CREATE TABLE [dbo].[MK_MEDALHAS](
1287 [id] [int] IDENTITY(1,1) NOT NULL,
1288 [login] [nvarchar](10) NOT NULL,
1289 [Name] [nvarchar](10) NOT NULL,
1290 [medal_evento] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_evento] DEFAULT ((0)),
1291 [medal_resets] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_resets] DEFAULT ((0)),
1292 [medal_mresets] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_mresets] DEFAULT ((0)),
1293 [medal_tempo] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_tempo] DEFAULT ((0)),
1294 [medal_sresets] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_sresets] DEFAULT ((0)),
1295 [medal_smresets] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_smresets] DEFAULT ((0)),
1296 [medal_pk] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_pk] DEFAULT ((0)),
1297 [medal_exp] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_exp] DEFAULT ((0)),
1298 [medal_gm] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_gm] DEFAULT ((0)),
1299 [medal_reputacao] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_reputacao] DEFAULT ((0)),
1300 [medal_evento_m] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_evento_m] DEFAULT ((0)),
1301 [medal_resets_m] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_resets_m] DEFAULT ((0)),
1302 [medal_mresets_m] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_mresets_m] DEFAULT ((0)),
1303 [medal_tempo_m] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_tempo_m] DEFAULT ((0)),
1304 [medal_pk_m] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_pk_m] DEFAULT ((0)),
1305 [medal_ds] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_ds] DEFAULT ((0)),
1306 [medal_ds_s] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_ds_s] DEFAULT ((0)),
1307 [medal_rei] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_rei] DEFAULT ((0)),
1308 [medal_duel_semanal] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1_5] DEFAULT ((0)),
1309 [medal_duel] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel] DEFAULT ((0)),
1310 [medal_missao] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1] DEFAULT ((0)),
1311 [medal_bc] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1_1] DEFAULT ((0)),
1312 [medal_vip] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1_2] DEFAULT ((0)),
1313 [medal_contribuinte] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1_3] DEFAULT ((0)),
1314 [medal_rei_conquistas] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1_4] DEFAULT ((0)),
1315 [medal_bc_s] [tinyint] NOT NULL CONSTRAINT [DF_MK_MEDALHAS_medal_bc_s] DEFAULT ((0)),
1316 [medal_hr] [tinyint] NOT NULL CONSTRAINT [DF_MK_MEDALHAS_medal_hr] DEFAULT ((0)),
1317 [medal_hr_m] [tinyint] NOT NULL CONSTRAINT [DF_MK_MEDALHAS_medal_hr_m] DEFAULT ((0)),
1318 [medal_cc_s] [tinyint] NOT NULL CONSTRAINT [DF_MK_MEDALHAS_medal_cc_s] DEFAULT ((0)),
1319 [medal_joias] [tinyint] NOT NULL CONSTRAINT [DF_MK_MEDALHAS_medal_joias] DEFAULT ((0)),
1320 CONSTRAINT [PK_LOginName] PRIMARY KEY CLUSTERED
1321(
1322 [login] ASC,
1323 [Name] ASC
1324)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1325) ON [PRIMARY]
1326GO
1327SET ANSI_NULLS ON
1328GO
1329SET QUOTED_IDENTIFIER ON
1330GO
1331CREATE TABLE [dbo].[MK_Quest](
1332 [Name] [nvarchar](10) NOT NULL,
1333 [quest1] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest1] DEFAULT ((0)),
1334 [quest2] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest2] DEFAULT ((0)),
1335 [quest3] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest3] DEFAULT ((0)),
1336 [quest4] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest4] DEFAULT ((0)),
1337 [quest5] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest5] DEFAULT ((0)),
1338 [quest6] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest6] DEFAULT ((0)),
1339 [quest7] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest7] DEFAULT ((0)),
1340 [quest8] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest8] DEFAULT ((0)),
1341 [quest9] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest9] DEFAULT ((0)),
1342 [quest10] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest10] DEFAULT ((0)),
1343 [quest11] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest11] DEFAULT ((0)),
1344 [quest12] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest12] DEFAULT ((0)),
1345 [quest13] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest13] DEFAULT ((0)),
1346 [quest14] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest14] DEFAULT ((0)),
1347 [quest15] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest15] DEFAULT ((0)),
1348 [quest16] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest16] DEFAULT ((0)),
1349 [quest17] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest17] DEFAULT ((0)),
1350 [quest18] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest18] DEFAULT ((0)),
1351 [quest19] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest19] DEFAULT ((0)),
1352 [quest20] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest20] DEFAULT ((0)),
1353 [nivel] [smallint] NOT NULL CONSTRAINT [DF_Quest_nivel] DEFAULT ((0)),
1354 [quest21] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest21] DEFAULT ((0)),
1355 [quest22] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest22] DEFAULT ((0)),
1356 [quest23] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest23] DEFAULT ((0)),
1357 [quest24] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest24] DEFAULT ((0)),
1358 [quest25] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest25] DEFAULT ((0)),
1359 [quest26] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest26] DEFAULT ((0)),
1360 [quest27] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest27] DEFAULT ((0)),
1361 [quest28] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest28] DEFAULT ((0)),
1362 [quest29] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest29] DEFAULT ((0)),
1363 [quest30] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest30] DEFAULT ((0)),
1364 [quest31] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest31] DEFAULT ((0)),
1365 [quest32] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest32] DEFAULT ((0)),
1366 [quest33] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest33] DEFAULT ((0)),
1367 [quest34] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest34] DEFAULT ((0)),
1368 [quest35] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest35] DEFAULT ((0)),
1369 CONSTRAINT [PK_Quest] PRIMARY KEY CLUSTERED
1370(
1371 [Name] ASC
1372)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1373) ON [PRIMARY]
1374GO
1375SET ANSI_NULLS ON
1376GO
1377SET QUOTED_IDENTIFIER ON
1378GO
1379CREATE Procedure [dbo].[WZ_SetResetInfo]
1380@Account varchar(10),
1381@Name varchar(10),
1382@Reset int,
1383@ResetDay int,
1384@ResetWek int,
1385@ResetMon int
1386AS
1387BEGIN
1388
1389SET NOCOUNT ON
1390SET XACT_ABORT ON
1391
1392SET @Reset = 1
1393
1394UPDATE Character SET ResetCount=ResetCount+@Reset, reset_diario = reset_diario +@Reset, reset_semanal = reset_semanal +@Reset, reset_mensal = reset_mensal+@Reset
1395 WHERE AccountID=@Account AND Name=@Name
1396
1397SET NOCOUNT OFF
1398SET XACT_ABORT OFF
1399
1400END
1401GO
1402SET ANSI_NULLS ON
1403GO
1404SET QUOTED_IDENTIFIER ON
1405GO
1406CREATE Procedure [dbo].[WZ_SetMasterResetInfo]
1407@Account varchar(10),
1408@Name varchar(10),
1409@Reset int,
1410@MasterReset int,
1411@MasterResetDay int,
1412@MasterResetWek int,
1413@MasterResetMon int
1414AS
1415BEGIN
1416
1417SET NOCOUNT ON
1418SET XACT_ABORT ON
1419
1420set @Reset = 1
1421
1422UPDATE Character SET MasterResetCount=MasterResetCount+@Reset,mresets_diario=mresets_diario+@Reset, mresets_semanal = mresets_semanal +@Reset, mreset_mensal = mreset_mensal+@Reset, exp_war = exp_war +30
1423 WHERE AccountID=@Account AND Name=@Name
1424
1425UPDATE CashShopData SET WCoinP = WCoinP + 10, GoblinPoint = GoblinPoint+30 WHERE AccountID=@Account
1426
1427SET NOCOUNT OFF
1428SET XACT_ABORT OFF
1429
1430END
1431GO
1432SET ANSI_NULLS ON
1433GO
1434SET QUOTED_IDENTIFIER ON
1435GO
1436CREATE Procedure [dbo].[WZ_GetResetInfo]
1437@Account varchar(10),
1438@Name varchar(10)
1439AS
1440BEGIN
1441
1442SET NOCOUNT ON
1443SET XACT_ABORT ON
1444
1445DECLARE @Reset int
1446DECLARE @ResetDay int
1447DECLARE @ResetWek int
1448DECLARE @ResetMon int
1449
1450SELECT @Reset=ResetCount,@ResetDay=0,@ResetWek=0,@ResetMon=0 FROM Character WHERE AccountID=@Account AND Name=@Name
1451
1452SELECT @Reset AS Reset,@ResetDay AS ResetDay,@ResetWek AS ResetWek,@ResetMon AS ResetMon
1453
1454SET NOCOUNT OFF
1455SET XACT_ABORT OFF
1456
1457END
1458GO
1459SET ANSI_NULLS ON
1460GO
1461SET QUOTED_IDENTIFIER ON
1462GO
1463CREATE Procedure [dbo].[WZ_GetMasterResetInfo]
1464@Account varchar(10),
1465@Name varchar(10)
1466AS
1467BEGIN
1468
1469SET NOCOUNT ON
1470SET XACT_ABORT ON
1471
1472DECLARE @MasterReset int
1473DECLARE @MasterResetDay int
1474DECLARE @MasterResetWek int
1475DECLARE @MasterResetMon int
1476
1477SELECT @MasterReset=MasterResetCount,@MasterResetDay=0,@MasterResetWek=0,@MasterResetMon=0 FROM Character WHERE AccountID=@Account AND Name=@Name
1478
1479SELECT @MasterReset AS MasterReset,@MasterResetDay AS MasterResetDay,@MasterResetWek AS MasterResetWek,@MasterResetMon AS MasterResetMon
1480
1481SET NOCOUNT OFF
1482SET XACT_ABORT OFF
1483
1484END
1485GO
1486SET ANSI_NULLS ON
1487GO
1488SET QUOTED_IDENTIFIER ON
1489GO
1490CREATE proc [dbo].[chat_atualizar]
1491@acc varchar(10)
1492as
1493begin
1494
1495IF not exists (Select login from MK_chat_online where login = @acc)
1496 INSERT INTO MK_Chat_online (login) VALUES (@acc)
1497ELSE
1498 UPDATE MK_Chat_online set data = (getdate()) where login = @acc
1499
1500end
1501GO
1502SET ANSI_NULLS ON
1503GO
1504SET QUOTED_IDENTIFIER ON
1505GO
1506CREATE PROCEDURE [dbo].[VERIFICAR_ITENS]
1507@uid varchar(20),
1508@type binary(2)
1509AS
1510
1511Begin
1512
1513SET NoCOUNT ON
1514DECLARE
1515@wh_acid varchar(10),
1516@wh_data binary(3840),
1517@wh_type binary(2),
1518@wh_full binary(1),
1519@wh_serial binary(4),
1520@wj_serial binary(4),
1521@wh_13 binary(1),
1522@k int,
1523@j int,
1524@qtd int,
1525@find int,
1526@conn int
1527
1528SELECT @conn = (SELECT top 1 connectstat FROM memb_stat where memb___id=@uid)
1529
1530SET @k=0
1531SET @qtd=0
1532SET @find=0
1533
1534if @conn = 0
1535BEGIN
1536--Verifica Baú
1537SELECT @wh_data=items FROM warehouse where accountid = @uid
1538
1539WHILE @k<120 AND @wh_data IS NOT NULL
1540BEGIN
1541SET @wh_type=SUBSTRING(@wh_data,@k*16+1,2)
1542SET @k=@k+1
1543
1544 IF
1545 @wh_type <> @type
1546 and @wh_type <> 0xFFFF
1547 BEGIN
1548 SET @find = 1
1549 END
1550END
1551
1552SET @k=0
1553
1554--Verifica Baú
1555IF @find = 0
1556BEGIN
1557
1558WHILE @k<120 AND @wh_data IS NOT NULL
1559BEGIN
1560SET @wh_type=SUBSTRING(@wh_data,@k*16+1,2)
1561SET @wh_serial=SUBSTRING(@wh_data,@k*16+4,4)
1562SET @wh_13=SUBSTRING(@wh_data,@k*16+8,1)
1563SET @k=@k+1
1564
1565IF
1566@wh_type = @type
1567BEGIN
1568SET @find=0
1569SET @j=0
1570
1571 WHILE @j < (@k-1)
1572 BEGIN
1573 SET @wj_serial=SUBSTRING(@wh_data,@j*16+4,4)
1574 SET @j=@j+1
1575
1576 IF @wj_serial = @wh_serial
1577 BEGIN
1578 SET @find=1
1579 INSERT INTO LOG_DUPE_EVENTO (login,serial,evento) VALUES (@uid, @wj_serial,'K5')
1580 END
1581 END
1582
1583set @wh_data = substring(@wh_data ,1,16*@j)+0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF+substring(@wh_data,16*@j+17,len(@wh_data))
1584
1585IF @find=0 and @wh_serial<>0x00000000
1586 BEGIN
1587 SET @qtd = @qtd+1
1588 END
1589
1590END
1591END
1592END
1593 IF @qtd >= 120
1594 BEGIN
1595 update [warehouse] set [items]=@wh_data where [AccountId]=@uid
1596
1597 if @type = 0x0E00
1598 begin
1599 declare @nome varchar(10)
1600 select @nome = dbo.fn_char_forte(@uid)
1601 if exists (select login from mk_medalhas where login = @uid and name = @nome)
1602 UPDATE MK_MEDALHAS SET medal_joias=1 where name = @nome
1603 ELSE
1604 INSERT INTO MK_MEDALHAS (login,name,medal_joias) VALUES (@uid,@nome,1)
1605 end
1606 END
1607END
1608
1609select @qtd as qtd, @find as find
1610
1611END
1612GO
1613ALTER TABLE [dbo].[MK_MEDALHAS] WITH CHECK ADD CONSTRAINT [FK_MK_MEDALHAS_Character] FOREIGN KEY([Name])
1614REFERENCES [dbo].[Character] ([Name])
1615ON UPDATE CASCADE
1616ON DELETE CASCADE
1617GO
1618ALTER TABLE [dbo].[MK_MEDALHAS] CHECK CONSTRAINT [FK_MK_MEDALHAS_Character]
1619GO
1620ALTER TABLE [dbo].[MK_Quest] WITH CHECK ADD CONSTRAINT [fk_name_char] FOREIGN KEY([Name])
1621REFERENCES [dbo].[Character] ([Name])
1622ON UPDATE CASCADE
1623ON DELETE CASCADE
1624GO
1625ALTER TABLE [dbo].[MK_Quest] CHECK CONSTRAINT [fk_name_char]
1626GO
1627
1628
1629CREATE Procedure [dbo].[PREMIAR_TOPS]
1630@Account varchar(10),
1631@Name varchar(10),
1632@WC int,
1633@WP int,
1634@GP int,
1635@XP int,
1636@VIP1 int,
1637@VIP2 int,
1638@VIP3 int,
1639@EVENTOS int
1640AS
1641BEGIN
1642
1643SET NOCOUNT ON
1644SET XACT_ABORT ON
1645
1646IF @WC > 0 or @WP > 0 or @GP > 0
1647BEGIN
1648UPDATE CashShopData
1649 SET WCoinC = WCoinC + @WC, WCoinP = WCoinP + @WP, GoblinPoint = GoblinPoint + @GP where AccountID = @Account
1650END
1651
1652IF @WC > 0
1653BEGIN
1654 insert into log_creditos ( login, valor, ip, tipo ) values (@Account,@WC,'1','6')
1655END
1656
1657IF @EVENTOS > 0 or @XP > 0
1658BEGIN
1659UPDATE Character
1660 SET exp_war = exp_war + @XP, eventos = eventos + @EVENTOS where Name = @Name and AccountID = @Account
1661END
1662
1663IF @VIP1 > 0
1664BEGIN
1665 -- ADD VIP NA CONTA VIP_AL1
1666 update memb_info set AccountExpireDate = AccountExpireDate+@VIP1 where memb___id = @Account and accountlevel = 1
1667 -- ADD VIP NA CONTA VIP_AL0
1668 update memb_info set accountlevel = 1, AccountExpireDate = (getdate())+@VIP1 where memb___id = @Account and accountlevel = 0
1669
1670 if (select COUNT(*) from MEMB_INFO where memb___id = @Account and AccountLevel = 1) > 0
1671 Insert into log_vip (login,dias,tipo) values (@Account,@VIP1,'6' )
1672END
1673
1674if @VIP2 > 0
1675BEGIN
1676 -- ADD VIP NA CONTA VIP_AL2
1677 update memb_info set AccountExpireDate = AccountExpireDate+@VIP2 where memb___id = @Account and accountlevel = 2
1678
1679 if (select COUNT(*) from MEMB_INFO where memb___id = @Account and AccountLevel = 2) > 0
1680 Insert into log_vip (login,dias,tipo) values (@Account,@VIP2,'7' )
1681END
1682
1683if @VIP3 > 0
1684BEGIN
1685 -- ADD VIP NA CONTA VIP_AL3
1686 update memb_info set AccountExpireDate = AccountExpireDate+@VIP3 where memb___id = @Account and accountlevel = 3
1687
1688 if (select COUNT(*) from MEMB_INFO where memb___id = @Account and AccountLevel = 3) > 0
1689 Insert into log_vip (login,dias,tipo) values (@Account,@VIP3,'8' )
1690END
1691
1692
1693CREATE Procedure [dbo].[PREMIAR_TOPS_MEDALHAS]
1694@Account varchar(10),
1695@Name varchar(10),
1696@MEDALHA int
1697AS
1698BEGIN
1699
1700SET NOCOUNT ON
1701SET XACT_ABORT ON
1702
1703IF @MEDALHA = 1
1704BEGIN
1705 if exists (select login from mk_medalhas where login = @Account and name = @name)
1706 UPDATE MK_MEDALHAS SET medal_sresets=1 where name = @name
1707 ELSE
1708 INSERT INTO MK_MEDALHAS (login,name,medal_sresets) VALUES (@Account,@name,1)
1709END
1710
1711IF @MEDALHA = 2
1712BEGIN
1713 if exists (select login from mk_medalhas where login = @Account and name = @name)
1714 UPDATE MK_MEDALHAS SET medal_smresets=1 where name = @name
1715 ELSE
1716 INSERT INTO MK_MEDALHAS (login,name,medal_smresets) VALUES (@Account,@name,1)
1717END
1718
1719IF @MEDALHA = 3
1720BEGIN
1721 if exists (select login from mk_medalhas where login = @Account and name = @name)
1722 UPDATE MK_MEDALHAS SET medal_tempo=1 where name = @name
1723 ELSE
1724 INSERT INTO MK_MEDALHAS (login,name,medal_tempo) VALUES (@Account,@name,1)
1725END
1726
1727IF @MEDALHA = 4
1728BEGIN
1729 if exists (select login from mk_medalhas where login = @Account and name = @name)
1730 UPDATE MK_MEDALHAS SET medal_evento=1 where name = @name
1731 ELSE
1732 INSERT INTO MK_MEDALHAS (login,name,medal_evento) VALUES (@Account,@name,1)
1733END
1734
1735IF @MEDALHA = 5
1736BEGIN
1737 if exists (select login from mk_medalhas where login = @Account and name = @name)
1738 UPDATE MK_MEDALHAS SET medal_pk=1 where name = @name
1739 ELSE
1740 INSERT INTO MK_MEDALHAS (login,name,medal_pk) VALUES (@Account,@name,1)
1741END
1742
1743IF @MEDALHA = 6
1744BEGIN
1745 if exists (select login from mk_medalhas where login = @Account and name = @name)
1746 UPDATE MK_MEDALHAS SET medal_hr=1 where name = @name
1747 ELSE
1748 INSERT INTO MK_MEDALHAS (login,name,medal_hr) VALUES (@Account,@name,1)
1749END
1750
1751IF @MEDALHA = 7
1752BEGIN
1753 if exists (select login from mk_medalhas where login = @Account and name = @name)
1754 UPDATE MK_MEDALHAS SET medal_ds_s=1 where name = @name
1755 ELSE
1756 INSERT INTO MK_MEDALHAS (login,name,medal_ds_s) VALUES (@Account,@name,1)
1757END
1758
1759IF @MEDALHA = 8
1760BEGIN
1761 if exists (select login from mk_medalhas where login = @Account and name = @name)
1762 UPDATE MK_MEDALHAS SET medal_bc_s=1 where name = @name
1763 ELSE
1764 INSERT INTO MK_MEDALHAS (login,name,medal_bc_s) VALUES (@Account,@name,1)
1765END
1766
1767IF @MEDALHA = 9
1768BEGIN
1769 if exists (select login from mk_medalhas where login = @Account and name = @name)
1770 UPDATE MK_MEDALHAS SET medal_cc_s=1 where name = @name
1771 ELSE
1772 INSERT INTO MK_MEDALHAS (login,name,medal_cc_s) VALUES (@Account,@name,1)
1773END
1774
1775IF @MEDALHA = 10
1776BEGIN
1777 if exists (select login from mk_medalhas where login = @Account and name = @name)
1778 UPDATE MK_MEDALHAS SET medal_duel_semanal=1 where name = @name
1779 ELSE
1780 INSERT INTO MK_MEDALHAS (login,name,medal_duel_semanal) VALUES (@Account,@name,1)
1781END
1782
1783IF @MEDALHA = 11
1784BEGIN
1785 if exists (select login from mk_medalhas where login = @Account and name = @name)
1786 UPDATE MK_MEDALHAS SET medal_resets_m=1 where name = @name
1787 ELSE
1788 INSERT INTO MK_MEDALHAS (login,name,medal_resets_m) VALUES (@Account,@name,1)
1789END
1790
1791IF @MEDALHA = 12
1792BEGIN
1793 if exists (select login from mk_medalhas where login = @Account and name = @name)
1794 UPDATE MK_MEDALHAS SET medal_mresets_m=1 where name = @name
1795 ELSE
1796 INSERT INTO MK_MEDALHAS (login,name,medal_mresets_m) VALUES (@Account,@name,1)
1797END
1798
1799
1800IF @MEDALHA = 13
1801BEGIN
1802 if exists (select login from mk_medalhas where login = @Account and name = @name)
1803 UPDATE MK_MEDALHAS SET medal_tempo_m=1 where name = @name
1804 ELSE
1805 INSERT INTO MK_MEDALHAS (login,name,medal_tempo_m) VALUES (@Account,@name,1)
1806END
1807
1808IF @MEDALHA = 14
1809BEGIN
1810 if exists (select login from mk_medalhas where login = @Account and name = @name)
1811 UPDATE MK_MEDALHAS SET medal_evento_m=1 where name = @name
1812 ELSE
1813 INSERT INTO MK_MEDALHAS (login,name,medal_evento_m) VALUES (@Account,@name,1)
1814END
1815
1816IF @MEDALHA = 15
1817BEGIN
1818 if exists (select login from mk_medalhas where login = @Account and name = @name)
1819 UPDATE MK_MEDALHAS SET medal_pk_m=1 where name = @name
1820 ELSE
1821 INSERT INTO MK_MEDALHAS (login,name,medal_pk_m) VALUES (@Account,@name,1)
1822END
1823
1824IF @MEDALHA = 16
1825BEGIN
1826 if exists (select login from mk_medalhas where login = @Account and name = @name)
1827 UPDATE MK_MEDALHAS SET medal_hr_m=1 where name = @name
1828 ELSE
1829 INSERT INTO MK_MEDALHAS (login,name,medal_hr_m) VALUES (@Account,@name,1)
1830END
1831
1832
1833
1834
1835INSERT INTO MK_SERVER (REI_DO_MK,recorde_on) VALUES (0,0)
1836GO