[Release] Bugless MuServer 1.00L(CHS)

[Cobain]

the files have vip system? or i have to create subserver? and what's is the name of the column for the Vips?

 

[Deadman]

No vip system in this files..

 

[DaKa]

can add DropSystem? PKClear? ResetSystem?

 

[DMichael]

yes but i want on this way if you can do it

i can do that but later..my main focus is bugs && stability

and make it POST not MSG ... ^_^ looks much better...

i can do that but later..my main focus is bugs && stability

+1 [Post] or [POST] not problem for me

good

you can change [MSG] - > [POST] ?
exam
[POST] nylanlee : messenger

i can do that but later..my main focus is bugs && stability

the files have vip system? or i have to create subserver? and what's is the name of the column for the Vips?

not have vipsystem but you can use 'ConnectMember'

No vip system in this files..

agree

can add DropSystem? PKClear? ResetSystem?

i can do that but later..my main focus is bugs && stability

 

[Raganius]

Which GM commands are working here ? Are such commands as : /drop , /trace , /accban /charban etc. work here ?

DMichael - can you please add such important function as /pkclear ?

 

[Smith]

Hello, I first want to thank you for the files. You've been working hard, so here thank you very much.
I am developing a website completely from scratch for my server, but I have a problem with the MD5. In the field memb__pwd is a varbinary, I can change it to a varchar to save passwords encrypted? Because I can not save a varchar MD5 string in a field of type varbinary.
And if you do not mind I have one more question. What security is recommended to the client? MuGuard, TAD, etc?

 

[Ant1Lamer]

Hello, I first want to thank you for the files. You've been working hard, so here thank you very much.
I am developing a website completely from scratch for my server, but I have a problem with the MD5. In the field memb__pwd is a varbinary, I can change it to a varchar to save passwords encrypted? Because I can not save a varchar MD5 string in a field of type varbinary.
And if you do not mind I have one more question. What security is recommended to the client? MuGuard, TAD, etc?

try with this go to query analyzer MuOnline table and put this and push F5 and try again and tell work or not work your site and MuEditor

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

 

[Smith]

Hi Ant1Lamer, Thanks for your query. But MuMaker gives me this error "String of binary data would be truncated. The statement has been terminated". What could it be?

 

[Deadman]

MD5

 

[Ant1Lamer]

i dont know reinstall mumaker and try it i use MuEdit and not problem

 

[Smith]

Could you please pass me the link of mu edit you use? All links I found do not work. Sorry for the inconvenience

 

[Deadman]

This is the best one for 1.0m version ,use the Thanks button!
If this one gives you the same error the problem is in the DB .. i mean MD5.

 

[DMichael]

Which GM commands are working here ? Are such commands as : /drop , /trace , /accban /charban etc. work here ?

DMichael - can you please add such important function as /pkclear ?

open message_chs.wtf and take a look in the commands

Hello, I first want to thank you for the files. You've been working hard, so here thank you very much.
I am developing a website completely from scratch for my server, but I have a problem with the MD5. In the field memb__pwd is a varbinary, I can change it to a varchar to save passwords encrypted? Because I can not save a varchar MD5 string in a field of type varbinary.
And if you do not mind I have one more question. What security is recommended to the client? MuGuard, TAD, etc?

you can change from varbinary to varchar and replace JoinServer and it will be enough, about the anticheat im working on anticheat in serverside
anyway for free one take Pinkof for paid UGK

Could you please pass me the link of mu edit you use? All links I found do not work. Sorry for the inconvenience

use MuMaker 1.03 or MuEdit 2.1 or CZF Editor 1.5

This is the best one for 1.0m version ,use the Thanks button!
If this one gives you the same error the problem is in the DB .. i mean MD5.

agree^^

 

[DMichael]

ok guys im made some "better" main:
main.rar - Solidfiles

features:
-cpu usage reduce
-remove muerror.log encryption
-allow to be launched without launcher
-website open disabled(after close main)

IP for connect in main : 127.0.0.1(edit with hexeditor or what ever is easir for you)

 

[Ant1Lamer]

this main cant be hooked with gameguard...

 

[DMichael]

this main cant be hooked with gameguard...

you have to do manualy or use other program..

 

[Raganius]

DMichael - can you please add such important function as /pkclear. i want to take that server. but without this command i cant go in public online.

 

[DMichael]

DMichael - can you please add such important function as /pkclear. i want to take that server. but without this command i cant go in public online.

yes but not atm some time later

 

[Matias-]

thank you very much, open more updates?

 

[ChildOfGod]

Project dead?!

I like to say , i use those files, there are a great files, but need /add /pkclear
Cheers!