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
теи като не намерих такъв пост като моя проблем реших да попитам имал ли я някой и как го е решил и той е следния всичко стартира както трябва влизам в сървара до ацц и пас ползвам от тест ацц-тата си като не ми дава да правя рег без да вкарам кода по долу поставен и като ползвам тест ацц-то пиша ацц и пас-а те са еднакви и ми изписва грешна парола сменям паролата правя я 5, 6 цифрена , буквена i смесено дори не същия е проблема слагам кода по долу в анализера промяната е само една дава ми да си правя ацц и проблема с влизането в което и да е ацц остава един и сащ няма влизане грешна парола някой има ли идея от кво е при полойение че съм проверявал за ип или забравено нещо за едитване ...няма и няма моля помогнете ако някой знае да сподели ?! Благодаря Ви
Code: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
след поста които направих в 5 часа продалйих опитите да оправя грешката която ми показва ресторнах на ново сървара без да вкарвам кода пробвах да направя ацц от сайта показва че е готово а не го създава и от едитора пробвах и там не ми дава да го създам реших да погледна в датабазата и ми се видяха ти 2 допълнителни (pwd2 и 3) пасове някак непознати написах парола тест оригиналната е някакви символи в едитора не ми дава да я променя и само с тея дет едитнах реших да пробвам на това ацц дет съм едитнал тестовото и ме вкара без проблем и реших да променя поста си за да решим проблема заедно незнам кода по долу върши ли ми някаква работа моля помогнете
Password: DarksTeam.net
Dataserve1 , Dataserver 2 error
Not Working gameserver but gameserer.ini edited !!