Auto "Age 15" bug fix SQL job.

[xphire]

Well, i decided to make a SQL job to fix the the age 15 bug bug. It is a really simple script but i know a lot of people need this. If you do not know how to make a SQL job, please use the search function to learn how to

Script:

USE MuOnline
UPDATE MEMB_INFO
Set sno__numb = 1
WHERE sno__numb > 1

Enjoy

 

[DestructiO]

Re: [Release]Auto "Age 15" bug fix SQL job.

good work

 

[xphire]

Re: [Release]Auto "Age 15" bug fix SQL job.

good work

Thanks, i just made it in about lets see, 1 minute

 

[DestructiO]

Re: [Release]Auto "Age 15" bug fix SQL job.

Thanks, i just made it in about lets see, 1 minute

you made it for 1 minute,then very good job

 

[xphire]

Re: [Release]Auto "Age 15" bug fix SQL job.

you mad it for 1 minute,then very good job

thanks, i have other scripts that teleport people out of silent map, and stuff.

 

[SHANG]

Re: [Release]Auto "Age 15" bug fix SQL job.

We have to setup this as MSSQL Job per time ?

i think it have to be like this:

USE MuOnline
UPDATE MEMB_INFO
Set sno__numb = '1'
WHERE sno__numb > '1'

 

[xphire]

Re: [Release]Auto "Age 15" bug fix SQL job.

We have to setup this as MSSQL Job per time ?

i think it have to be like this:

USE MuOnline
UPDATE MEMB_INFO
Set sno__numb = '1'
WHERE sno__numb > '1'

Yes, you have to make the SQL job every 1 minute, and no, it can be like how i posted, you only need the '' when you are adding text in.

 

[SHANG]

Re: [Release]Auto "Age 15" bug fix SQL job.

lol, try running this:

USE MuOnline
UPDATE MEMB_INFO
Set sno__numb = 1
WHERE sno__numb > 1

in your SQL Query analyser.. it cant Run..

Even the stats fixer is created with ' '

 

[xphire]

Re: [Release]Auto "Age 15" bug fix SQL job.

lol, try running this:

USE MuOnline
UPDATE MEMB_INFO
Set sno__numb = 1
WHERE sno__numb > 1

in your SQL Query analyser.. it cant Run..

Even the stats fixer is created with ' '

Okay, you are supposed to make a JOB, it will not work if you just run it in SQL query analyzer.

 

[nigthkill]

Re: [Release]Auto "Age 15" bug fix SQL job.

thx friend