createrankexpinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Game Info
#
#  FileName    : CreateRankEXPInfo.sql
#  Description : Rank Exp 沥焊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.09.04    厘全芒        脚痹 颇老 积己 
#
# 2002.09.11    厘全芒        珐欧 蔼 傈搁 荐沥 
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS RankEXPInfo;

CREATE TABLE RankEXPInfo (
  RankType      tinyint unsigned NOT NULL default 0,   # 0: Slayer, 1: Vampire
  Level 		int(11) NOT NULL default 0,
  GoalExp 		int(11) NOT NULL default '0',
  AccumExp 	int(11) NOT NULL default '0',

  PRIMARY KEY  (RankType, Level)

) TYPE=MyISAM;


################################################################################
# 牢郸胶 积己



################################################################################
# Sequence 积己



################################################################################
# 鼻茄 汲沥 



################################################################################
# 单捞磐 持扁


### 浇饭捞绢 ###
INSERT INTO RankEXPInfo VALUES(0,  1,     10700,      10700);
INSERT INTO RankEXPInfo VALUES(0,  2,     22300,      33000);
INSERT INTO RankEXPInfo VALUES(0,  3,     45500,      78500);
INSERT INTO RankEXPInfo VALUES(0,  4,     88400,     166900);
INSERT INTO RankEXPInfo VALUES(0,  5,    171400,     338300);
INSERT INTO RankEXPInfo VALUES(0,  6,    310200,     648500);
INSERT INTO RankEXPInfo VALUES(0,  7,    542400,    1190900);
INSERT INTO RankEXPInfo VALUES(0,  8,    927400,    2118300);
INSERT INTO RankEXPInfo VALUES(0,  9,   1467200,    3585500);
INSERT INTO RankEXPInfo VALUES(0, 10,   2308600,    5894100);
INSERT INTO RankEXPInfo VALUES(0, 11,   3302600,    9196700);
INSERT INTO RankEXPInfo VALUES(0, 12,   4493300,   13690000);
INSERT INTO RankEXPInfo VALUES(0, 13,   6021000,   19711000);
INSERT INTO RankEXPInfo VALUES(0, 14,   7633700,   27344700);
INSERT INTO RankEXPInfo VALUES(0, 15,   9637400,   36982100);
INSERT INTO RankEXPInfo VALUES(0, 16,  11587600,   48569700);
INSERT INTO RankEXPInfo VALUES(0, 17,  13556000,   62125700);
INSERT INTO RankEXPInfo VALUES(0, 18,  15620900,   77746600);
INSERT INTO RankEXPInfo VALUES(0, 19,  16987700,   94734300);
INSERT INTO RankEXPInfo VALUES(0, 20,  18388200,  113122500);
INSERT INTO RankEXPInfo VALUES(0, 21,  19903900,  133026400);
INSERT INTO RankEXPInfo VALUES(0, 22,  21544600,  154571000);
INSERT INTO RankEXPInfo VALUES(0, 23,  23320600,  177891600);
INSERT INTO RankEXPInfo VALUES(0, 24,  25243000,  203134600);
INSERT INTO RankEXPInfo VALUES(0, 25,  27323700,  230458300);
INSERT INTO RankEXPInfo VALUES(0, 26,  29430100,  259888400);
INSERT INTO RankEXPInfo VALUES(0, 27,  31606800,  291495200);
INSERT INTO RankEXPInfo VALUES(0, 28,  33893800,  325389000);
INSERT INTO RankEXPInfo VALUES(0, 29,  36132900,  361521900);
INSERT INTO RankEXPInfo VALUES(0, 30,  38501400,  400023300);
INSERT INTO RankEXPInfo VALUES(0, 31,  40923700,  440947000);
INSERT INTO RankEXPInfo VALUES(0, 32,  43434900,  484381900);
INSERT INTO RankEXPInfo VALUES(0, 33,  46100300,  530482200);
INSERT INTO RankEXPInfo VALUES(0, 34,  48929100,  579411300);
INSERT INTO RankEXPInfo VALUES(0, 35,  51931500,  631342800);
INSERT INTO RankEXPInfo VALUES(0, 36,  54981700,  686324500);
INSERT INTO RankEXPInfo VALUES(0, 37,  58125900,  744450400);
INSERT INTO RankEXPInfo VALUES(0, 38,  61403700,  805854100);
INSERT INTO RankEXPInfo VALUES(0, 39,  64675200,  870529300);
INSERT INTO RankEXPInfo VALUES(0, 40,  68104400,  938633700);
INSERT INTO RankEXPInfo VALUES(0, 41,  71537600, 1010171300);
INSERT INTO RankEXPInfo VALUES(0, 42,  75033700, 1085205000);
INSERT INTO RankEXPInfo VALUES(0, 43,  78641600, 1163846600);
INSERT INTO RankEXPInfo VALUES(0, 44,  82179200, 1246025800);
INSERT INTO RankEXPInfo VALUES(0, 45,  85855300, 1331881100);
INSERT INTO RankEXPInfo VALUES(0, 46,  89472800, 1421353900);
INSERT INTO RankEXPInfo VALUES(0, 47,  93105900, 1514459800);
INSERT INTO RankEXPInfo VALUES(0, 48,  96886300, 1611346100);
INSERT INTO RankEXPInfo VALUES(0, 49, 100820200, 1712166300);
INSERT INTO RankEXPInfo VALUES(0, 50, 104914000, 1817080300);


#轨颇捞绢
INSERT INTO RankEXPInfo VALUES(1,  1,     10700,      10700);
INSERT INTO RankEXPInfo VALUES(1,  2,     22300,      33000);
INSERT INTO RankEXPInfo VALUES(1,  3,     45500,      78500);
INSERT INTO RankEXPInfo VALUES(1,  4,     88400,     166900);
INSERT INTO RankEXPInfo VALUES(1,  5,    171400,     338300);
INSERT INTO RankEXPInfo VALUES(1,  6,    310200,     648500);
INSERT INTO RankEXPInfo VALUES(1,  7,    542400,    1190900);
INSERT INTO RankEXPInfo VALUES(1,  8,    927400,    2118300);
INSERT INTO RankEXPInfo VALUES(1,  9,   1467200,    3585500);
INSERT INTO RankEXPInfo VALUES(1, 10,   2308600,    5894100);
INSERT INTO RankEXPInfo VALUES(1, 11,   3302600,    9196700);
INSERT INTO RankEXPInfo VALUES(1, 12,   4493300,   13690000);
INSERT INTO RankEXPInfo VALUES(1, 13,   6021000,   19711000);
INSERT INTO RankEXPInfo VALUES(1, 14,   7633700,   27344700);
INSERT INTO RankEXPInfo VALUES(1, 15,   9637400,   36982100);
INSERT INTO RankEXPInfo VALUES(1, 16,  11587600,   48569700);
INSERT INTO RankEXPInfo VALUES(1, 17,  13556000,   62125700);
INSERT INTO RankEXPInfo VALUES(1, 18,  15620900,   77746600);
INSERT INTO RankEXPInfo VALUES(1, 19,  16987700,   94734300);
INSERT INTO RankEXPInfo VALUES(1, 20,  18388200,  113122500);
INSERT INTO RankEXPInfo VALUES(1, 21,  19903900,  133026400);
INSERT INTO RankEXPInfo VALUES(1, 22,  21544600,  154571000);
INSERT INTO RankEXPInfo VALUES(1, 23,  23320600,  177891600);
INSERT INTO RankEXPInfo VALUES(1, 24,  25243000,  203134600);
INSERT INTO RankEXPInfo VALUES(1, 25,  27323700,  230458300);
INSERT INTO RankEXPInfo VALUES(1, 26,  29430100,  259888400);
INSERT INTO RankEXPInfo VALUES(1, 27,  31606800,  291495200);
INSERT INTO RankEXPInfo VALUES(1, 28,  33893800,  325389000);
INSERT INTO RankEXPInfo VALUES(1, 29,  36132900,  361521900);
INSERT INTO RankEXPInfo VALUES(1, 30,  38501400,  400023300);
INSERT INTO RankEXPInfo VALUES(1, 31,  40923700,  440947000);
INSERT INTO RankEXPInfo VALUES(1, 32,  43434900,  484381900);
INSERT INTO RankEXPInfo VALUES(1, 33,  46100300,  530482200);
INSERT INTO RankEXPInfo VALUES(1, 34,  48929100,  579411300);
INSERT INTO RankEXPInfo VALUES(1, 35,  51931500,  631342800);
INSERT INTO RankEXPInfo VALUES(1, 36,  54981700,  686324500);
INSERT INTO RankEXPInfo VALUES(1, 37,  58125900,  744450400);
INSERT INTO RankEXPInfo VALUES(1, 38,  61403700,  805854100);
INSERT INTO RankEXPInfo VALUES(1, 39,  64675200,  870529300);
INSERT INTO RankEXPInfo VALUES(1, 40,  68104400,  938633700);
INSERT INTO RankEXPInfo VALUES(1, 41,  71537600, 1010171300);
INSERT INTO RankEXPInfo VALUES(1, 42,  75033700, 1085205000);
INSERT INTO RankEXPInfo VALUES(1, 43,  78641600, 1163846600);
INSERT INTO RankEXPInfo VALUES(1, 44,  82179200, 1246025800);
INSERT INTO RankEXPInfo VALUES(1, 45,  85855300, 1331881100);
INSERT INTO RankEXPInfo VALUES(1, 46,  89472800, 1421353900);
INSERT INTO RankEXPInfo VALUES(1, 47,  93105900, 1514459800);
INSERT INTO RankEXPInfo VALUES(1, 48,  96886300, 1611346100);
INSERT INTO RankEXPInfo VALUES(1, 49, 100820200, 1712166300);
INSERT INTO RankEXPInfo VALUES(1, 50, 104914000, 1817080300);


## 酒快胶磐胶
INSERT INTO RankEXPInfo VALUES(2,  1,     10700,      10700);
INSERT INTO RankEXPInfo VALUES(2,  2,     22300,      33000);
INSERT INTO RankEXPInfo VALUES(2,  3,     45500,      78500);
INSERT INTO RankEXPInfo VALUES(2,  4,     88400,     166900);
INSERT INTO RankEXPInfo VALUES(2,  5,    171400,     338300);
INSERT INTO RankEXPInfo VALUES(2,  6,    310200,     648500);
INSERT INTO RankEXPInfo VALUES(2,  7,    542400,    1190900);
INSERT INTO RankEXPInfo VALUES(2,  8,    927400,    2118300);
INSERT INTO RankEXPInfo VALUES(2,  9,   1467200,    3585500);
INSERT INTO RankEXPInfo VALUES(2, 10,   2308600,    5894100);
INSERT INTO RankEXPInfo VALUES(2, 11,   3302600,    9196700);
INSERT INTO RankEXPInfo VALUES(2, 12,   4493300,   13690000);
INSERT INTO RankEXPInfo VALUES(2, 13,   6021000,   19711000);
INSERT INTO RankEXPInfo VALUES(2, 14,   7633700,   27344700);
INSERT INTO RankEXPInfo VALUES(2, 15,   9637400,   36982100);
INSERT INTO RankEXPInfo VALUES(2, 16,  11587600,   48569700);
INSERT INTO RankEXPInfo VALUES(2, 17,  13556000,   62125700);
INSERT INTO RankEXPInfo VALUES(2, 18,  15620900,   77746600);
INSERT INTO RankEXPInfo VALUES(2, 19,  16987700,   94734300);
INSERT INTO RankEXPInfo VALUES(2, 20,  18388200,  113122500);
INSERT INTO RankEXPInfo VALUES(2, 21,  19903900,  133026400);
INSERT INTO RankEXPInfo VALUES(2, 22,  21544600,  154571000);
INSERT INTO RankEXPInfo VALUES(2, 23,  23320600,  177891600);
INSERT INTO RankEXPInfo VALUES(2, 24,  25243000,  203134600);
INSERT INTO RankEXPInfo VALUES(2, 25,  27323700,  230458300);
INSERT INTO RankEXPInfo VALUES(2, 26,  29430100,  259888400);
INSERT INTO RankEXPInfo VALUES(2, 27,  31606800,  291495200);
INSERT INTO RankEXPInfo VALUES(2, 28,  33893800,  325389000);
INSERT INTO RankEXPInfo VALUES(2, 29,  36132900,  361521900);
INSERT INTO RankEXPInfo VALUES(2, 30,  38501400,  400023300);
INSERT INTO RankEXPInfo VALUES(2, 31,  40923700,  440947000);
INSERT INTO RankEXPInfo VALUES(2, 32,  43434900,  484381900);
INSERT INTO RankEXPInfo VALUES(2, 33,  46100300,  530482200);
INSERT INTO RankEXPInfo VALUES(2, 34,  48929100,  579411300);
INSERT INTO RankEXPInfo VALUES(2, 35,  51931500,  631342800);
INSERT INTO RankEXPInfo VALUES(2, 36,  54981700,  686324500);
INSERT INTO RankEXPInfo VALUES(2, 37,  58125900,  744450400);
INSERT INTO RankEXPInfo VALUES(2, 38,  61403700,  805854100);
INSERT INTO RankEXPInfo VALUES(2, 39,  64675200,  870529300);
INSERT INTO RankEXPInfo VALUES(2, 40,  68104400,  938633700);
INSERT INTO RankEXPInfo VALUES(2, 41,  71537600, 1010171300);
INSERT INTO RankEXPInfo VALUES(2, 42,  75033700, 1085205000);
INSERT INTO RankEXPInfo VALUES(2, 43,  78641600, 1163846600);
INSERT INTO RankEXPInfo VALUES(2, 44,  82179200, 1246025800);
INSERT INTO RankEXPInfo VALUES(2, 45,  85855300, 1331881100);
INSERT INTO RankEXPInfo VALUES(2, 46,  89472800, 1421353900);
INSERT INTO RankEXPInfo VALUES(2, 47,  93105900, 1514459800);
INSERT INTO RankEXPInfo VALUES(2, 48,  96886300, 1611346100);
INSERT INTO RankEXPInfo VALUES(2, 49, 100820200, 1712166300);
INSERT INTO RankEXPInfo VALUES(2, 50, 104914000, 1817080300);