viniciusvj
Honrado XPZ
[glow=red,2,300]Ate ja vi um aki no xpz mas não achei acho que zero la o topico.
Quem tiver ajuda ai...[/glow]
disponível
Quem tiver ajuda ai...[/glow]
Skipp Redirect 2.8.0018
v2.8.0029
disponível
Query de mudar pontuação Maxima! Quem puder ajuda to as ordis.
- Thread starter viniciusvj
- Data de Início
- Status
faahemohcx
Usuário XPZ
Voou postar as 2 Querys, 32k e 65k.
[glow=red,2,300]32k[/glow]
BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @name = N'[uncategorized (Local)]'
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'PutosMayor')
IF (@JobID IS NOT NULL)
BEGIN
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @JobID) AND (server_id <> 0)))
BEGIN
RAISERROR (N'Unable to import job ''PutosMayor'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
EXECUTE msdb.dbo.sp_delete_job @job_name = N'PutosMayor'
SELECT @JobID = NULL
END
BEGIN
EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'PutosMayor', @owner_login_name = N'sa', @description = N'No description available.', @category_name = N'[uncategorized (Local)]', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'FixStats', @command = N'update character set strength = 32767 where (strength > 32767 or strength < 0)
update character set dexterity = 32767 where (dexterity > 32767 or dexterity < 0)
update character set vitality = 32767 where (vitality > 32767 or vitality < 0)
update character set energy = 32767 where (energy > 32767 or energy < 0)
Update character set leadership=32767 where (leadership > 32767 or leadership < 0)
Alter table character alter column Strength smallint null
Alter table character alter column Dexterity smallint null
Alter table character alter column Vitality smallint null
Alter table character alter column Energy smallint null
Alter table character alter column Leadership smallint null
', @database_name = N'MuOnline', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'sss', @enabled = 1, @freq_type = 4, @active_start_date = 20090903, @active_start_time = 0, @freq_interval = 1, @freq_subday_type = 8, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:
[glow=red,2,300]65K[/glow]
BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @name = N'[uncategorized (Local)]'
-- Delete the job with the same name (if it exists)
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'Puntos Mayor')
IF (@JobID IS NOT NULL)
BEGIN
-- Check if the job is a multi-server job
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @JobID) AND (server_id <> 0)))
BEGIN
-- There is, so abort the script
RAISERROR (N'Unable to import job ''Puntos Mayor'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
-- Delete the [local] job
EXECUTE msdb.dbo.sp_delete_job @job_name = N'Puntos Mayor'
SELECT @JobID = NULL
END
BEGIN
-- Add the job
EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'Puntos Mayor', @owner_login_name = N'sa', @description = N'No description available.', @category_name = N'[uncategorized (Local)]', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
-- Add the job steps
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'FIXEALOS65K', @command = N'Update character set Strength = 65536 + Strength where Strength < 0
Update character set Dexterity = 65536 + Dexterity where Dexterity < 0
Update character set Vitality = 65536 + Vitality where Vitality < 0
Update character set Energy = 65536 + Energy where Energy < 0
Update character set Leadership = 65536 + Leadership where Leadership < 0', @database_name = N'MuOnline', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
-- Add the job schedules
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'SHUDLE', @enabled = 1, @freq_type = 4, @active_start_date = 20090202, @active_start_time = 0, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
-- Add the Target Servers
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:
Após ter rodado à query correspondente ao seu gosto, vá no Enterprise Manager, MuOnline, Character - botao direito, design table. Procure :
[glow=red,2,300]Para 32k[/glow]
Strength smallint 2 marcado Default Value 0
Dexterity smallint 2 marcado Default Value 0
Vitality smallint 2 marcado Default Value 0
Energy smallint 2 marcado Default Value 0
Leadership smallint 2 marcado Default Value 0
[glow=red,2,300]Para 65k[/glow]
Strength int 4 marcado Default Value 0
Dexterity int 4 marcado Default Value 0
Vitality int 4 marcado Default Value 0
Energy int 4 marcado Default Value 0
Leadership int 4 marcado Default Value 0
[glow=red,2,300]32k[/glow]
BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @name = N'[uncategorized (Local)]'
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'PutosMayor')
IF (@JobID IS NOT NULL)
BEGIN
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @JobID) AND (server_id <> 0)))
BEGIN
RAISERROR (N'Unable to import job ''PutosMayor'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
EXECUTE msdb.dbo.sp_delete_job @job_name = N'PutosMayor'
SELECT @JobID = NULL
END
BEGIN
EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'PutosMayor', @owner_login_name = N'sa', @description = N'No description available.', @category_name = N'[uncategorized (Local)]', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'FixStats', @command = N'update character set strength = 32767 where (strength > 32767 or strength < 0)
update character set dexterity = 32767 where (dexterity > 32767 or dexterity < 0)
update character set vitality = 32767 where (vitality > 32767 or vitality < 0)
update character set energy = 32767 where (energy > 32767 or energy < 0)
Update character set leadership=32767 where (leadership > 32767 or leadership < 0)
Alter table character alter column Strength smallint null
Alter table character alter column Dexterity smallint null
Alter table character alter column Vitality smallint null
Alter table character alter column Energy smallint null
Alter table character alter column Leadership smallint null
', @database_name = N'MuOnline', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'sss', @enabled = 1, @freq_type = 4, @active_start_date = 20090903, @active_start_time = 0, @freq_interval = 1, @freq_subday_type = 8, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:
[glow=red,2,300]65K[/glow]
BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @name = N'[uncategorized (Local)]'
-- Delete the job with the same name (if it exists)
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'Puntos Mayor')
IF (@JobID IS NOT NULL)
BEGIN
-- Check if the job is a multi-server job
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @JobID) AND (server_id <> 0)))
BEGIN
-- There is, so abort the script
RAISERROR (N'Unable to import job ''Puntos Mayor'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
-- Delete the [local] job
EXECUTE msdb.dbo.sp_delete_job @job_name = N'Puntos Mayor'
SELECT @JobID = NULL
END
BEGIN
-- Add the job
EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'Puntos Mayor', @owner_login_name = N'sa', @description = N'No description available.', @category_name = N'[uncategorized (Local)]', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
-- Add the job steps
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'FIXEALOS65K', @command = N'Update character set Strength = 65536 + Strength where Strength < 0
Update character set Dexterity = 65536 + Dexterity where Dexterity < 0
Update character set Vitality = 65536 + Vitality where Vitality < 0
Update character set Energy = 65536 + Energy where Energy < 0
Update character set Leadership = 65536 + Leadership where Leadership < 0', @database_name = N'MuOnline', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
-- Add the job schedules
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'SHUDLE', @enabled = 1, @freq_type = 4, @active_start_date = 20090202, @active_start_time = 0, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
-- Add the Target Servers
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:
Após ter rodado à query correspondente ao seu gosto, vá no Enterprise Manager, MuOnline, Character - botao direito, design table. Procure :
[glow=red,2,300]Para 32k[/glow]
Strength smallint 2 marcado Default Value 0
Dexterity smallint 2 marcado Default Value 0
Vitality smallint 2 marcado Default Value 0
Energy smallint 2 marcado Default Value 0
Leadership smallint 2 marcado Default Value 0
[glow=red,2,300]Para 65k[/glow]
Strength int 4 marcado Default Value 0
Dexterity int 4 marcado Default Value 0
Vitality int 4 marcado Default Value 0
Energy int 4 marcado Default Value 0
Leadership int 4 marcado Default Value 0
Editado por um moderador:
viniciusvj
Honrado XPZ
vlw ja dei meu karma!
disponível
Skipp Redirect 2.8.0018
v2.8.0029
disponível
faahemohcx
Usuário XPZ
Obrigado 
qualquer coisa.. posta ae que eu tento ajudar '-'
qualquer coisa.. posta ae que eu tento ajudar '-'
Editado por um moderador:
- Status