添加对应时间LOGINLOG表的SQL语句!
自己改一下日期就行了
//nageboard
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050501]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050501]
GO
CREATE TABLE [dbo].[itemtrade050501] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO 织梦好,好织梦
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050502]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050502]
GO
CREATE TABLE [dbo].[itemtrade050502] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050503]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050503]
GO
CREATE TABLE [dbo].[itemtrade050503] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050504]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050504]
GO
CREATE TABLE [dbo].[itemtrade050504] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO 内容来自dedecms
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050505]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050505]
GO
CREATE TABLE [dbo].[itemtrade050505] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO dedecms.com
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050506]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050506]
GO
CREATE TABLE [dbo].[itemtrade050506] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO 织梦内容管理系统
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050507]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050507]
GO
CREATE TABLE [dbo].[itemtrade050507] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050508]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050508]
GO
CREATE TABLE [dbo].[itemtrade050508] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050509]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050509]
GO
CREATE TABLE [dbo].[itemtrade050509] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO 织梦内容管理系统
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade0505010]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade0505010]
GO
CREATE TABLE [dbo].[itemtrade0505010] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO
织梦好,好织梦
//nagemember
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200551]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200551]
GO
CREATE TABLE [dbo].[Loginlog_200551] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200552]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200552]
GO
CREATE TABLE [dbo].[Loginlog_200552] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL 织梦好,好织梦
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200553]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200553]
GO
CREATE TABLE [dbo].[Loginlog_200553] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200554]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200554]
GO
CREATE TABLE [dbo].[Loginlog_200554] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
织梦内容管理系统
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200555]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200555]
GO
CREATE TABLE [dbo].[Loginlog_200555] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO copyright dedecms
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200556]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200556]
GO
CREATE TABLE [dbo].[Loginlog_200556] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200557]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200557]
GO
CREATE TABLE [dbo].[Loginlog_200557] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO 本文来自织梦
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200558]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200558]
GO
CREATE TABLE [dbo].[Loginlog_200558] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO
织梦内容管理系统
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200559]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200559]
GO
CREATE TABLE [dbo].[Loginlog_200559] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_2005510]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_2005510]
GO
CREATE TABLE [dbo].[Loginlog_2005510] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
dedecms.com
清空数据的 织梦好,好织梦
还有一些自己添加吧,很简单照抄就行,看哪个没用添加进来 本文来自织梦
use nage
DELETE FROM [dbo].[CharInfo]
DELETE FROM [dbo].[charname_1]
DELETE FROM [dbo].[friend]
DELETE FROM [dbo].[giveItem4event]
DELETE FROM [dbo].[RoundRank_1]
DELETE FROM [dbo].[RoundRank_3]
DELETE FROM [dbo].[RoundRank_4]
DELETE FROM [dbo].[RoundRank_5]
本文来自织梦
use NageBoard
DELETE FROM [dbo].[EventBoard]
DELETE FROM [dbo].[FreeBoard]
DELETE FROM [dbo].[NotiBoard] 织梦内容管理系统
use NageManager
DELETE FROM [dbo].[ManagerTable]
use NageMember
DELETE FROM [dbo].[charname]
DELETE FROM [dbo].[charname_1]
DELETE FROM [dbo].[charname_2]
DELETE FROM [dbo].[charname_3]
DELETE FROM [dbo].[charname_4]
DELETE FROM [dbo].[chr_log_info]
DELETE FROM [dbo].[chr_log_info_plus]
DELETE FROM [dbo].[Chr_Log_Info_static]
DELETE FROM [dbo].[Item_to_Game]
DELETE FROM [dbo].[Itemlog_test]
DELETE FROM [dbo].[Itemlog_to_Game]
DELETE FROM [dbo].[login_log]
DELETE FROM [dbo].[nage_admin_log]
DELETE FROM [dbo].[OGB_TB_LOGIN_LOG]
DELETE FROM [dbo].[OGB_TB_USER_EXCEPTION]
dedecms.com
1.76精品传奇_1.76天下毁灭_1.76复古传奇_英雄合击_中变靓装传奇_无忧传奇
传奇花屏补丁,花屏补丁,土城花屏补丁,盟重土城花屏补丁下载,土城花屏补丁下载,沙巴克花屏补丁,传奇土城花屏补丁下载
网站每天发布最新、最好的传奇版本下载和与传奇服务端配套开区传奇模版,网游技术教程全部免费下载!
无忧网络是目前唯一家所有的传奇服务端,传奇私服花屏补丁,盟重花屏补丁和传奇客户端下载都经过站长亲自测试并配有真实测试图!
所有的工具软件和传奇版本在发布之前,都会经过站长亲自测试,保证chuanqisf可以进入游戏,所有软件都无毒无插件!
本站声明:本站所有技术资料与下载资源均为网络搜集整理,并不代表本站的观点与立场,如有侵犯您的权益,请来信指出,本站将立即改正Copyright © 2002-2014 无忧网络 版权所有蜀ICP备09041899号