| | Create free blog ( Türkçe , Deutsch , Español )

1299 Private-Serverlar | QA Kodları | Editörler | Server Kurulumu

Private-Serverlar.NeT

Rebirth Sistemi

http://rapidshare.com/files/182748229/RebirthSheller.rar

 

İtemi Tradeye Kapatmak

update ITEM set Num = '91111111'
where Num = 'itemin Kodu'

DB Sıfırlamak [Qa]

Kod:
truncate table account_char
go
truncate table currentuser
go
truncate table deleted_userdata
go
truncate table knights
go
truncate table knights_rating
go
truncate table knights_user
go
truncate table tb_user
go
truncate table userdata
go
truncate table warehouse
go

DB Ye Usko Pelerin Ekle

Kod:
INSERT INTO [KNIGHTS_CAPE] Values (10,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (11,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (12,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (13,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (14,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (15,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (16,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (17,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (18,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (110,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (111,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (112,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (113,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (114,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (115,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (116,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (117,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (118,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (210,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (211,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (212,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (213,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (214,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (215,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (216,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (217,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (218,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (310,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (311,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (312,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (313,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (314,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (315,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (316,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (317,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (318,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (410,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (411,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (412,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (413,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (414,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (415,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (416,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (417,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (418,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (510,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (511,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (512,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (513,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (514,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (515,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (516,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (517,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (518,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (40,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (41,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (42,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (43,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (44,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (45,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (46,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (47,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (48,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (140,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (141,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (142,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (143,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (144,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (145,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (146,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (147,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (148,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (240,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (241,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (242,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (243,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (244,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (245,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (246,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (247,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (248,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (340,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (341,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (342,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (343,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (344,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (345,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (346,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (347,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (348,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (440,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (441,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (442,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (443,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (444,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (445,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (446,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (447,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (448,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (540,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (541,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (542,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (543,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (544,'green',200000000,0,1)

C++++ Çözümü [QA]

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