
27/03/2009, 08:53
|
 | | | Fecha de Ingreso: octubre-2008
Mensajes: 36
Antigüedad: 16 años, 4 meses Puntos: 0 | |
Problemas con un job que cree Buenas a todos bueno tengo un problema bastate simple pero que para mi es un mundo, he creado un job para el MSSQL server para mi servidor de MuOnline que hace los siguiente: Cita: UPDATE Character
SET clevel= ('1') , experience= ('0') , resets=resets +1, MapNumber = 0, MapPosX = 125, MapPosY = 125, Money = Money - ('100000000')
WHERE clevel >= 370 AND ctlcode < 8 AND Resets <= 9 AND Money >= 100000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , resets=resets +1, MapNumber = 0, MapPosX = 125, MapPosY = 125, Money = Money - ('200000000')
WHERE clevel >= 380 AND ctlcode < 8 AND Resets >= 10 AND Resets <= 14 AND Money >= 200000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , resets=resets +1, MapNumber = 0, MapPosX = 125, MapPosY = 125, Money = Money - ('300000000')
WHERE clevel >= 390 AND ctlcode < 8 AND Resets >= 15 AND Resets <= 19 AND Money >= 300000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , resets=resets +1, MapNumber = 0, MapPosX = 125, MapPosY = 125, Money = Money - ('400000000')
WHERE clevel >= 400 AND ctlcode < 8 AND Resets >= 20 AND Resets <= 29 AND Money >= 400000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , resets=resets +1, MapNumber = 0, MapPosX = 125, MapPosY = 125, Money = Money - ('500000000')
WHERE clevel >= 400 AND ctlcode < 8 AND Resets >= 30 AND Resets <= 39 AND Money >= 500000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , resets=resets +1, MapNumber = 0, MapPosX = 125, MapPosY = 125, Money = Money - ('650000000')
WHERE clevel >= 400 AND ctlcode < 8 AND Resets >= 40 AND Money >= 650000000 Ahora os explico lo que intentaba hacer y que no me a salido como esperaba, yo quería que segun el valor de la colunma resets te exigiera un clevel y money superior, y que te sumara 1 al valor de resets pero no se porque se me suman 2 o a veces más alguien me sabria ayudar? |