Results 1 to 4 of 4

need help with DB

This is a discussion on need help with DB within the Private Server Technical Support forums, part of the Private Servers category; so we just started up LimitlessKO.... and im having problems with Clan not working,King system is messed up, wars dont ...
Page: 1


  1. 08-28-2011, 09:43 AM #1
    rhoades990
    Guest

    Default need help with DB

    so we just started up LimitlessKO.... and im having problems with Clan not working,King system is messed up, wars dont work and crash server, and NP/Clan ranking is shot.


    ill toss out some change if i get someone to help me with this. need it asap. so post up


    my msn is [email protected]
    Reply With Quote Reply With Quote
  2. 10-07-2011, 03:13 PM #2
    AwayEnemies
    Guest

    Default

    Hello Dear rhoades990,

    For NP Ranking Open Query Analyzer,


    Code:
    TRUNCATE TABLE USER_KNIGHTS_RANK
TRUNCATE TABLE USER_PERSONAL_RANK
    After this ;

    Code:
    INSERT INTO USER_KNIGHTS_RANK VALUES ( 1, 'Gold', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 2, 'Silver', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 3, 'Silver', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 4, 'Silver', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 5, 'Mirage', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 6, 'Mirage', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 7, 'Mirage', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 8, 'Mirage', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 9, 'Mirage', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 10, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 11, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 12, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 13, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 14, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 15, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 16, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 17, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 18, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 19, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 20, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 21, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 22, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 23, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 24, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 25, 'Shadow', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 26, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 27, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 28, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 29, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 30, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 31, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 32, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 33, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 34, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 35, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 36, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 37, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 38, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 39, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 40, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 41, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 42, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 43, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 44, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 45, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 46, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 47, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 48, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 49, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 50, 'Mist', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 51, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 52, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 53, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 54, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 55, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 56, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 57, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 58, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 59, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 60, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 61, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 62, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 63, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 64, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 65, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 66, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 67, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 68, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 69, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 70, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 71, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 72, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 73, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 74, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 75, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 76, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 77, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 78, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 79, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 80, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 81, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 82, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 83, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 84, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 85, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 86, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 87, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 88, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 89, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 90, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 91, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 92, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 93, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 94, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 95, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 96, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 97, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 98, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 99, 'Training', null, null, 0, null, null, 0, 0); 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 100, 'Training', null, null, 0, null, null, 0, 0);
    --> Check Post 2
    Reply With Quote Reply With Quote
  3. 10-07-2011, 03:14 PM #3
    AwayEnemies
    Guest

    Default

    Code:
    INSERT INTO USER_PERSONAL_RANK VALUES ( 1, 'Gold',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 2, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 3, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 4, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 5, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 6, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 7, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 8, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 9, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 10, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 11, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 12, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 13, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 14, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 15, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 16, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 17, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 18, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 19, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 20, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 21, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 22, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 23, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 24, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 25, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 26, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 27, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 28, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 29, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 30, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 31, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 32, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 33, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 34, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 35, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 36, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 37, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 38, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 39, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 40, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 41, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 42, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 43, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 44, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 45, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 46, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 47, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 48, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 49, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 50, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 51, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 52, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 53, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 54, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 55, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 56, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 57, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 58, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 59, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 60, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 61, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 62, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 63, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 64, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 65, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 66, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 67, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 68, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 69, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 70, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 71, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 72, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 73, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 74, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 75, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 76, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 77, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 78, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 79, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 80, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 81, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 82, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 83, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 84, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 85, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 86, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 87, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 88, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 89, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 90, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 91, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 92, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 93, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 94, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 95, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 96, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 97, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 98, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 99, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()); 
INSERT INTO USER_PERSONAL_RANK VALUES ( 100, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
    Now your NP Ranking tables is good,
    Lets make ur procedures work ;

    Code:
    CREATE PROCEDURE  UPDATE_PERSONAL_RANK
AS
/*
Author : AKUMA
*/
DECLARE @tUpdateDate SMALLDATETIME
SET @tUpdateDate =CONVERT(VARCHAR(15) , GETDATE(),102)
SET @tUpdateDate = DATEADD(HH,DATEPART(HH,dateadd(mi, 10, GETDATE())),@tUpdateDate)
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KARUS_USER_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
DROP TABLE [dbo].[KARUS_USER_RANK] 
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[ELMORAD_USER_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
DROP TABLE [dbo].[ELMORAD_USER_RANK] 
CREATE TABLE [dbo].[KARUS_USER_RANK](
 [nRank] [int] IDENTITY(1,1) NOT NULL,
 [strUserID] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Loyalty] [int] NOT NULL,
 [LoyaltyMonthly] [int] NOT NULL,
 [nRankUp] [int] NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[ELMORAD_USER_RANK](
 [nRank] [int] IDENTITY(1,1) NOT NULL,
 [strUserID] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Loyalty] [int] NOT NULL,
 [LoyaltyMonthly] [int] NOT NULL,
 [nRankUp] [int] NOT NULL
) ON [PRIMARY]
truncate table KARUS_USER_RANK
insert  KARUS_USER_RANK
 select top 100 strUserID, Loyalty,  LoyaltyMonthly, 101
 from USERDATA
 where Nation = 1 and Authority = 1
 order by LoyaltyMonthly desc
truncate table ELMORAD_USER_RANK
insert  ELMORAD_USER_RANK
 select top 100 strUserID, Loyalty,  LoyaltyMonthly, 101
 from USERDATA
 where Nation = 2 and Authority = 1
 order by LoyaltyMonthly desc
UPDATE KARUS_USER_RANK
 Set nRankUP = R.nRank - KARUS_USER_RANK.nRank
 from USER_PERSONAL_RANK R
 where R.strKarusUserID = KARUS_USER_RANK.strUserID
UPDATE  ELMORAD_USER_RANK
 Set nRankUP = R.nRank - ELMORAD_USER_RANK.nRank
 from USER_PERSONAL_RANK R
 where R.strElmoUserID = ELMORAD_USER_RANK.strUserID
 
INSERT INTO USER_PERSONAL_RANK
 select E.nRank, R.strPosition, E.nRankUP, E.strUserID, E.LoyaltyMonthly, R.nSalary, K.nRankUP, K.strUserID, K.LoyaltyMonthly, R.nSalary, R.nSalary, @tUpdateDate
 from  ELMORAD_USER_RANK E,  KARUS_USER_RANK K, USER_PERSONAL_RANK R
 WHERE (E.nRank = K.nRank AND E.nRank = R.nRank and R.UpdateDate < @tUpdateDate)
 ORDER BY E.nRank
DELETE FROM USER_PERSONAL_RANK
WHERE UpdateDate < @tUpdateDate
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KARUS_USER_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
DROP TABLE [dbo].[KARUS_USER_RANK] 
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[ELMORAD_USER_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
DROP TABLE [dbo].[ELMORAD_USER_RANK]
    If you get some problems with executing this change "CREATE PROCEDURE UPDATE_PERSONAL_RANK" to "ALTER PROCEDURE UPDATE_PERSONAL_RANK"

    ------------------------------------------------------------
    Reply With Quote Reply With Quote
  4. 10-07-2011, 03:15 PM #4
    AwayEnemies
    Guest

    Default

    And now we're at King System,

    Code:
    -- deleting all About king system
TRUNCATE TABLE KING_BALLOT_BOX
TRUNCATE TABLE KING_ELECTION_LIST
TRUNCATE TABLE KING_SYSTEM
TRUNCATE TABLE KING_CANDIDACY_NOTICE_BOARD

-- Making Clan List for King Election(Karus)
INSERT INTO KING_ELECTION_LIST SELECT TOP 10 4,1,IDNum,Chief,0 FROM KNIGHTS WHERE Nation = 1 ORDER BY Points DESC

--  Making Clan List for King Election(El Morad)
INSERT INTO KING_ELECTION_LIST SELECT TOP 10 4,2,IDNum,Chief,0 FROM KNIGHTS WHERE Nation = 2 ORDER BY Points DESC

-- Update KING_SYSTEM
DECLARE @Day tinyint
DECLARE @Month tinyint
DECLARE @Year smallint

SET @Day = DAY(GETDATE())
SET @Month = MONTH(GETDATE())
SET @Year = YEAR(GETDATE())

INSERT INTO KING_SYSTEM VALUES(1,3,@Year,@Month,@Day,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2100000000,2100000000,NULL,NULL)
INSERT INTO KING_SYSTEM VALUES(2,3,@Year,@Month,@Day,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2100000000,2100000000,NULL,NULL)
    Thats it
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules