TRIGGER for MapCodes

[magraopb]

seeing the TRIGGER of Honor Chumpy on 10, I swapped a few things to work on mapcodes


Execute in GameDB

CREATE TRIGGER [MapCodes] ON [dbo].[cabal_character_table]
FOR UPDATE
AS
begin
update cabal_character_table set WarpBField = '1023' where WarpBField < '1023'
update cabal_character_table set MapsBField = '1023' where MapsBField < '1023'
end


worked perfectly for me, if someone finds something wrong answer

 

[cypher]

it will suck if you have many characters... it will lag like hell you will see!

 

[D e v i L]

Yeah better change it in the database so it's automatic whenever you create a new character... =)

 

[magraopb]

which way you recommended not to lag cypher?

 

[chumpywumpy]

Cypher is right, this is a bad idea. I don't even like the idea of using it for honour but it is the best workaround we have for the cheat engine exploit for now.

Firstly a new char will not see the mapcodes right away they will have to create the char, log out and then back in to see the maps. Test it and you will see what i mean.

Also the bigger your char table gets the slower your DB will perform as Cypher says. Your DB will be constantly re-updating all of the chars every time any char entry is updated and eventually it will bring the DB server to it's knees. The better way of doing this is in the new char templates as the chars will be created with all maps and won't need to re-login and the DB will not be constantly re-updating vales as once you have the mapcodes it isn't like the value changes.

http://forum.ragezone.com/f460/how-to-auto-give-new-players-premium-stats-mapcodes-etc-452000/

 

[magraopb]

Ok chumpywumpy, i use a job for map codes, this job:

update dbo.cabal_character_table set WarpBfield=1023, MapsBField=1023

but is give-me a lag.
I see your post and try to do it

 

[cypher]

the best way is to edit the character templates as chumpy said.

 

[magraopb]

yes, i go make this, the table account.dbo.cabal_newCharData_table stores different types of character to be created, if i change the camps 'WarpBfield' and 'MapsBField' to 1023 in account.dbo.cabal_newCharData_table all players receive all map codes and no have lag, i'm correct?


EDIT

I was thinking, I can also put honor 10 with this method correct?

 

[cypher]

yes it will work!

 

[magraopb]

OK thanks for atention, i go make all mapcodes and honour 10 in this way

 

[chumpywumpy]

You can use these templates for lots of other things too and it is the best way to auto give chars stuff. john_d posted some interesting ideas about using the templates tables i am definitely going to experiment with.

http://forum.ragezone.com/f460/how-to-make-use-of-character-templates-544565/

 

[magraopb]

Ok thanks chumpy for your help and other members

 

[FaUZaNeVVa]

Man, why my Char SP never increasing. I mean how to make SP auto-increase as I see on any PServer. Please help Me.

Is this working?

update dbo.cabal_newCharData_table set WarpBField='511', MapsBField='511', Alz='1000000', SP='5000', Lev='10'

 

[cypher]

well i might not be too much informed of this but isn`t the max sp controlled by the lvling up quests?

 

[Yamachi]

well i might not be too much informed of this but isn`t the max sp controlled by the lvling up quests?

Yes, it is.