SQL Automatic job to fix the DC bug when trying to warp PF (when winning TG).

[dordort]

Fix for the DC bug when trying to warp PF (when winning TG).

Hi there. :) This release is for servers with Tierra Gloriosa channel. when nation win on TG they are getting a prize. and this prize includes a warp to MF and PF. when you try to warp MF you can, but PF makes you to DC. why its happening? because with our game version quests can give you up to 255 WarpBField, not more. And to warp without DC to PF you must have 1023 in WarpBField (on table cabal_character_table). So, why it is happening? why you cant get the requested WarpBField for Warp to PF? Because the TG is suppose to work with a newer game version that can earn you up to 1023 on quests. But, for our luck it is not so hard to make it compatible with our game version. We only need a job to make all of the characters with 255 WarpBField to be with 1023. Remember: 255 its only characters that finished already all of their quests. and when you change them to 1023 nothing changes exept the option to warp without DC to PF. And its not a newer version, its 22 US. because i am remember you the following important thing: our server files is now very old version of chinese client. and the client that we are using with that is a little newer, the US 22. and the TG that we are using now, is compatible with the OG Planet 22 version, and in that version characters can earn up to 1023 WarpBField, but on the chinese version not yet, only 255. and because of that keep read carefully: the new Lost-Spirit and Chumpy Jun 06 Patches, including the file cabal.enc. the cabal.enc they used is the US 22 one, that newer than our server files. So, we can see that when we are using the US 22 cabal.enc file with our client, we can see the Warp point on PF when pressing TAB but we are getting DC when pressing it because we must have 1023 WarpBField, But when we are using the chinese (same with our server files version) cabal.enc (the one that used by SAUR0N in his Synch Patch) we cannot even see the PF warp point when pressing TAB. and this is the proof about what i said. because it is prooving you that out chinese version dont have the PF warp at all, and it is not compatible with the TG channel because the TG channel is giving you this warp. by the way, the job will only work on the good characters that already finished all of the game quests and earned up to 255 WarpBField. and this because when changing 255 to 1023 nothing else will change exept the option to warp PF without DC. =] so people that made all of the quests and got all of the warp points, will get the fix and can also warp to PF when win on TG channel. =]

This is the job and i will tell exactly what to do in options. :)
By the way- why job and not just to use trigger? because i tryed it already, and when using the command with trigger you cant edit the character options, none of them. i dont know exactly why its making this situation, but it is making some error and not want to allow it. =P but with the job (that will be configured by us to run every 1 minute [enough] =P) it is working perfectly and will change every 1 minute all of the 255 to 1023 to offline characters. =]

Open up Enterprise Manager.
Go to Management and make sure SQL Server Agent is enabled and starting enabled when computer starts.
Press the + on SQL Server Agent and open Jobs.
Right click ---> New Job...
General ----> Name: whatever you want.
Steps -----> New... ----> Step name: whatever you want. Database: GAMEDB. Command:

UPDATE cabal_character_table SET WarpBField = '1023' WHERE WarpBField = '255' AND Login = '0'

Shedules ------> New Shedule... Name: whatever you want. Choose Recurring. Press Change... Occurs: Daily. Every: 1 day. Occurs every: 1 Minute(s). Start date: yesterday's date. No end date. Press OK three times. Done!

Now it will be fine, just be sure that you are using the US 22 cabal.enc because as i said before the original (chinese) one dont have the PF warp at all. =\
Just use this cabal.enc and use Lost-Spirit's fix to fix the NPC's DC bugs and maligno_raziel's basic craft fix. =]

Greetings,
Dor.

I will answer only to important questions, and not noobie questions. =.=

By the way, i know that my english is kinda bad but its because i am speaking another language on my country. =] Forgive me this time xD

[MentaL]

[Cath22]

cool, one question though if i make all players have WarpBField = '1023' can it fix it, rather doing a job in SQL? to prevent database load?

[dordort]

cool, one question though if i make all players have WarpBField = '1023' can it fix it, rather doing a job in SQL? to prevent database load?

Ofcourse you can do it manualy by Query Analyzer, but don't forget that everytime someone will finish the quests that giving him WarpBField 255 so he will not be with 1023 you will need everytime to shoot it again. (the command). So, it is better to make this job because than it will take care about that and if someone will earn 255 and logout, it will change him to 1023 within 1 minute. I dont think its so high CPU Load, for me its like nothing =\ but yes you can just run this command everytime manualy but it is not recommended. only if your CPU is very wicked, because my CPU isn't the best, theres betters lol but this job does nothing to my CPU Load. it is very little.

[Cath22]

Ofcourse you can do it manualy by Query Analyzer, but don't forget that everytime someone will finish the quests that giving him WarpBField 255 so he will not be with 1023 you will need everytime to shoot it again. (the command). So, it is better to make this job because than it will take care about that and if someone will earn 255 and logout, it will change him to 1023 within 1 minute. I dont think its so high CPU Load, for me its like nothing =\ but yes you can just run this command everytime manualy but it is not recommended. only if your CPU is very wicked, because my CPU isn't the best, theres betters lol but this job does nothing to my CPU Load. it is very little.

ok thank you for the answer i will do it now. COOL solution.

[dordort]

You welcome. =]

[Rahan]

I have set 1023 when they create a new char and had no more prob with this but vrey nice the update job...thx

[LostSpirit]

I have set 1023 when they create a new char and had no more prob with this but vrey nice the update job...thx

expect them to do the quests you see the problem

@Dor

nice, good to know that people have more concern here is that the server really.

[cypher]

[mod]Verbal Warning: dordort and maxgo1 I will not support any offtopic talks in cabal online section anymore. Please do not get me wrong i do community talk and server talk but ONtopic. Consider it as a preinfraction. Ragezone Cabal Section rules will suffer some serious changes offtalks. Please do not reply to this.[/mod]