hi everybody ,
I'm new member.
I have a problem looking forward to your help.
I want config to limit reset per day . Reset limit by Top 1 of Server.
For example : limit reset = 20 .
The first day, all members will be reset 20 . The following day, will count according to the reset of the top 1 + 20.
I have been guided by louis "you need to Create in the character table the Colunn ResetDay

and edit the procedures, WZ_setResetInfo and Wz_GetResetInfo"

but I cant do it
I hope someone can guide me.
Thank you.

1 - You have to set the ResetDay Default value to 0
2 - In the WZ_SetResetInfo procedure set the query to UPDATE Character SET ResetCount=@Reset, ResetDay=@ResetDay WHERE AccountID=@Account AND Name=@Name
3 - In the WZ_GetResetInfo procedure set the query to SELECT @Reset=ResetCount,@ResetDay=ResetDay,@ResetWek=0,@ResetMon=0 FROM Character WHERE AccountID=@Account AND Name=@Name

1 - You have to set the ResetDay Default value to 0
2 - In the WZ_SetResetInfo procedure set the query to UPDATE Character SET ResetCount=@Reset, ResetDay=@ResetDay WHERE AccountID=@Account AND Name=@Name
3 - In the WZ_GetResetInfo procedure set the query to SELECT @Reset=ResetCount,@ResetDay=ResetDay,@ResetWek=0,@ResetMon=0 FROM Character WHERE AccountID=@Account AND Name=@Name

If you set as Default Value 0, when you go to select character and enter with another character, the ResetDay column turns 0.

hi everybody ,
I'm new member.
I have a problem looking forward to your help.
I want config to limit reset per day . Reset limit by Top 1 of Server.
For example : limit reset = 20 .
The first day, all members will be reset 20 . The following day, will count according to the reset of the top 1 + 20.
I have been guided by louis "you need to Create in the character table the Colunn ResetDay

and edit the procedures, WZ_setResetInfo and Wz_GetResetInfo"

but I cant do it
I hope someone can guide me.
Thank you.

Here i made an example video where i show how to activate and config ResetDay, ResetWeek and ResetMonth. Also added a ResetDate column to know when was the last reset made by that character.

Video:

PD: sorry for my english haha

If you set as Default Value 0, when you go to select character and enter with another character, the ResetDay column turns 0.

Default value in the database man, for not null values, not in the procedure...

If you set as Default Value 0, when you go to select character and enter with another character, the ResetDay column turns 0.

Default value in the database man, for not null values, not in the procedure...

Si declaras así:

ALTER TABLE [MuOnline].[dbo].[Character] ADD ResetDay INT NOT NULL DEFAULT ((0))

Cuando clickeas en Seleccionar Personaje y entras con otro personaje distinto, al personaje anterior se le modifica ResetDay a 0. Me pasó en mi antiguo servidor con users online y tuve ese problema. Lo solucioné declarando:

ALTER TABLE [MuOnline].[dbo].[Character] ADD ResetDay INT

Si no prueba tu mismo.
1: añade esto >> ALTER TABLE [MuOnline].[dbo].[Character] ADD ResetDay INT NOT NULL DEFAULT ((0))
2: actualiza procedures GetReset y SetReset
3: entra al juego y crea 2 personajes
4: con el personaje1 haz 1 reset
5: revisa ResetDay de personaje1
6: entra con el personaje2
7: vuelve a revisar ResetDay del personaje1 y va a estar en 0

If you set as Default Value 0, when you go to select character and enter with another character, the ResetDay column turns 0.

Default value in the database man, for not null values, not in the procedure...

Si declaras así:

ALTER TABLE [MuOnline].[dbo].[Character] ADD ResetDay INT NOT NULL DEFAULT ((0))

Cuando clickeas en Seleccionar Personaje y entras con otro personaje distinto, al personaje anterior se le modifica ResetDay a 0. Me pasó en mi antiguo servidor con users online y tuve ese problema. Lo solucioné declarando:

ALTER TABLE [MuOnline].[dbo].[Character] ADD ResetDay INT

Si no prueba tu mismo.
1: añade esto >> ALTER TABLE [MuOnline].[dbo].[Character] ADD ResetDay INT NOT NULL DEFAULT ((0))
2: actualiza procedures GetReset y SetReset
3: entra al juego y crea 2 personajes
4: con el personaje1 haz 1 reset
5: revisa ResetDay de personaje1
6: entra con el personaje2
7: vuelve a revisar ResetDay del personaje1 y va a estar en 0

Ya verifique y aqui no sucede oO

Muito bom, parabéns!