[Release] [Repack] Perfection Online Instant 110 PvP Files!

[shukamu]

Hey jangar ty for this realese, can u make normal monster, no ALL LV 110?
i like it.

Rep + ty

[FallDown]

i did the same Rep + Thanks :D .

[Jangan]

UPDATE
Database is finally uploaded, it took FOREVER!! to shrink a 30GB database to 100mb >.< omgee! lol


and btw, shitpvpers, keep stealing my work and claiming its theirs... so fcking pathetic.

Jangan you really are an amazing guy, you give so much to RZ and take very little back apart from the apprecieation of releasing something ofc. Really I need to talk to you on skype ;D got a sweet idea and we need to catch up!

p.s Jangan for forums mod

Thank you so much, its an honor to have you post that old friend :3

[epvp2]

Why you share u r sever Flies?

[badibatu]

Amazing release Jangan you r the krallest kral :D

Do databases work in sql server 2005 ?

[FallDown]

First of all , THANKS A LOT AGAIN :D .

but i saw in shard db _TrainingCampHonorRank
is empty , it should be like that or i should add the missing 50 rows and execute it ?

[Jangan]

First of all , THANKS A LOT AGAIN :D .

but i saw in shard db _TrainingCampHonorRank
is empty , it should be like that or i should add the missing 50 rows and execute it ?

it seems like the query i used deleted that xD yeah good noticing, just add the 50 lines you have to. and it should work just fine. I will post queries for you, if you need any explanations, just ask!


Assigning honor points based on my system.

 -- Step 2)Put the ID here
    UPDATE _TrainingCamp
        set GraduateCount = GraduateCount + 1,
            EvaluationPoint = EvaluationPoint +10
            WHERE ID = ''

-- Step 3) Put the ID here    
    UPDATE _TrainingCampMember
        set HonorPoint = HonorPoint +1
        WHERE CampID = ''    
    
-- Step 1) Put your CharName here that you want to give points to!    
SELECT DISTINCT
        _TrainingCamp.ID,
        _TrainingCampMember.CharName,
        _TrainingCamp.GraduateCount,
        _TrainingCamp.EvaluationPoint,
        _TrainingCampMember.HonorPoint
    FROM _TrainingCampMember,_TrainingCamp
    where CharName = '' -- Put your CharName here First
    and _TrainingCamp.ID = _TrainingCampMember.CampID

exec _TRAINING_CAMP_UPDATEHONORRANK 
  

and this is for auto-updating tournament ranks to match honor ranks!

 USE SRO_VT_SHARD
--- Step 1) Reset all ranks!
        UPDATE _Char
            set HwanLevel = 3
            where HwanLevel = 7
            or 
                HwanLevel = 5
            or
                HwanLevel = 4
            OR 
                HwanLevel = 15
            or 
                HwanLevel = 16
            or
                HwanLevel = 17
            or
                HwanLevel = 18
        
        UPDATE _Char
            set HwanLevel = 15
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 1)
                                    
        UPDATE _Char
            set HwanLevel = 15
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 2)
                                    
                                    UPDATE _Char
            set HwanLevel = 15
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 3)
                                    
                                    UPDATE _Char
            set HwanLevel = 15
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 4)
                                    
                            UPDATE _Char
            set HwanLevel = 15
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 5)
                                    
                                    UPDATE _Char
            set HwanLevel = 16
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 6)
                                    
                                    
        UPDATE _Char
            set HwanLevel = 16
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 7)
                
                                    
                                    
                        UPDATE _Char
            set HwanLevel = 16
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 8)    
                                    
                                    UPDATE _Char
            set HwanLevel = 16
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 9)    
                                    
                                    
                                    UPDATE _Char
            set HwanLevel = 16
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 10)    
                                    
                                    
                                    
                                    UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 11)    
                                    
                                    
                                    
                                    UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 12)    
                                    
                                    
                                    
                                    UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 13)    
                                    
                                    
                                    
                                    
                                    UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 14)    
                                    
                                    
                                    
                                    UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 15)    
        
        
        
                    UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 16)    
        
        
        UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 17)    
                                    
                                    
                                    
                                    UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 18)    
        
        
        
        
        UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 19)    
        
        
        
        
        
        UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 20)    
        
        
        UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 21)    
        
        
        UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 22)    
        
        UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 23)    
                                    
                        UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 24)    
                                    
                                    
                                    UPDATE _Char
            set HwanLevel = 17
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 25)    
                                    
                                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 26)    
                                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 27)
                                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 28)    
                                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 29)        
                                    
                                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 30)    
                                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 31)    
                                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 32)
                                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 33)    
                                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 34)    
                                    
                                        
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 35)    
                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 36)    
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 37)    
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 38)    
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 39)    
            
                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 40)    
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 41)    
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 42)
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 43)    
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 44)
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 45)    
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 46)        
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 47)        
                    UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 48)
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 49)    
                                            UPDATE _Char
            set Hwanlevel = 18
        where _Char.CharID = (SELECT 
                        _Char.CharID
                        FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                        WHERE            
                                    _Char.CharID = _TrainingCampMember.CharID
                                    and 
                                    _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID
                                    and
                                    _TrainingCampHonorRank.Ranking = 50)        
        
        SELECT 
            _TrainingCampHonorRank.Ranking,
            _Char.CharName16,
            _Char.HwanLevel
                FROM _Char,_TrainingCampMember,_TrainingCampHonorRank
                    WHERE 
                        _Char.CharID = _TrainingCampMember.CharID
                    and 
                        _TrainingCampMember.CampID = _TrainingCampHonorRank.CampID 
  

Why you share u r sever Flies?

because im not like you :D

Amazing release Jangan you r the krallest kral :D

Do databases work in sql server 2005 ?

So sorry, this is a 2008 database, you may ask someone to convert it for you!

reason i cant use 2005 or 2012 is because of the database limits :P if you are a small server, use 2005, if you are a big server, you will get forced to use 2008.

ex: atomic, salvation, xcoding.. etc...

[FallDown]

WoW Sounds AWESOME! , just one little question XD..

how me i use it ? , should i use the Agent to auto task it ?
or what 0_0 , Englight me please :P.

[Jangan]

just right click shard -> new query -> put those queries there.

[FallDown]

oh , just once 0.0 ?

i dont get it....

[egsro]

would you like to share D13 smc?

[Ichigo14000]

Ram usage ?:)

[Jangan]

Ram usage ?:)

I think atomix has a release somewhere on low ram usage certificate!

But generally since this is using atomix 1x gameserver certification:

10-100 = 4GB-8GB Ram
100-500 = 8GB-16GB Ram
500-1000+ = 16G-48GB+ Ram


You should be able to run these files with 10-50 players on 4GB ram. The DB has been seriously optimized a lot of times and increased performance!


A Good Advice:
- Right click gameserver.exe in Task Manager and set the priority to real-time!


hf!

[FallDown]

Certification error.. =.= , are you sure this is the right server.cfg + cert ?

[Jangan]

Certification error.. =.= , are you sure this is the right server.cfg + cert ?

what error do you get? can i have a screen shot?