Сообщение от dozu4
[CODE]0 05/01/13 00;32;18 : Query : { CALL pUpdate_utsingleiteminfo_20070601( 2, 37, 2034944, 1, 268435455, 1, 0, 7, 0, 0, 3026516720, 0 ) }
1 05/01/13 00;32;18 : SQLExecDirect Returns : SQL_NO_DATA
0 04/22/13 00:00:00 : Query : select identity(int,1,1) as rank, g.serial, g.race, g.grade, g.id, r.win, r.draw, r.lose, r.score into [dbo].[tbl_GuildBattleRank20130422] from [dbo].[tbl_GuildBattleRank] as r join [dbo].[tbl_Guild] as g on r.serial = g.Serial and g.dck = 0 order by score desc, win desc, draw desc, lose
1 04/22/13 00;00:00 : SQLExecDirect Returns : SQL_NO_DATA
0 04/30/13 19;39:46 : StartDatabase : RF_World_Novus
1 04/30/13 19;39:46 : StartDatabase Success : RF_World_Novus
2 04/30/13 23;40:00 : CRFWorldDatabase Update_RaceRank(szDate(20130501)) Start!
3 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step1(szDate(201 30501)) : Start Create #tbl_PvpRankB Table
4 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step1(szDate(201 30501)) : End Create #tbl_PvpRankB Table
5 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step1(szDate(201 30501)) : Start Set Rate #tbl_PvpRankB Table
6 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step1(szDate(201 30501)) : End Set Rate #tbl_PvpRankB Table
7 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step2(szDate(201 30501)) : Start Create #tbl_PvpRankC Table
8 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step2(szDate(201 30501)) : End Create #tbl_PvpRankC Table
9 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step2(szDate(201 30501)) : Start Set Rate #tbl_PvpRankC Table
10 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step2(szDate(201 30501)) : End Set Rate #tbl_PvpRankC Table
11 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step2(szDate(201 30501)) : Start Create #tbl_PvpRankC Table
12 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step3(szDate(201 30501)) : End Create #tbl_PvpRankA Table
13 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step3(szDate(201 30501)) : Start Set Rate #tbl_PvpRankA Table
14 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step3(szDate(201 30501)) : End Set Rate #tbl_PvpRankA Table
15 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step4(szDate(201 30501)) : Start Create tbl_PvpRank20130501 Table
16 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step4(szDate(201 30501)) : End Create tbl_PvpRank20130501 Table
17 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank(szDate(20130501) ) : Start Union #tbl_PvpRankB,C,A To tbl_PvpRank20130501
18 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank(szDate(20130501) ) : End Union #tbl_PvpRankB,C,A To tbl_PvpRank20130501
19 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step5(szDate(201 30501)) : Start Set Grade tbl_PvpRank20130501
20 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step5(szDate(201 30501)) : End Set Grade tbl_PvpRank20130501
21 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step6(szDate(201 30501)) : Start drop #tbl_PvpRankB,C,A Table
22 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step_6_1(szDate( 20130501)) : Start drop #tbl_PvpRankB Table
23 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step_6_1(szDate( 20130501)) : End drop #tbl_PvpRankB Table
24 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step_6_2(szDate( 20130501)) : Start drop #tbl_PvpRankC Table
25 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step_6_2(szDate( 20130501)) : End drop #tbl_PvpRankC Table
26 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step_6_3(szDate( 20130501)) : Start drop #tbl_PvpRankA Table
27 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step_6_3(szDate( 20130501)) : End drop #tbl_PvpRankA Table
28 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step6(szDate(201 30501)) : End drop #tbl_PvpRankB,C,A Table
29 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step7(szDate(201 30501)) : Start Update Rank tbl_PvpRank20130501 Table
30 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step7(szDate(201 30501)) : End Update Rank tbl_PvpRank20130501 Table
31 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step8(szDate(201 30501)) : Start Set GuildName tbl_PvpRank20130501 Table
32 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step8(szDate(201 30501)) : End Set GuildName tbl_PvpRank20130501 Table
33 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step9(szDate(201 30501)) : Start Drop tbl_PvpRankToday Table
34 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step9(szDate(201 30501)) : End Drop tbl_PvpRankToday Table
35 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step9(szDate(201 30501)) : Start Create tbl_PvpRankToday Table
36 04/30/13 23;40:00 : CRFWorldDatabase::Update_RaceRank_Step9(szDate(201 30501)) : End Create tbl_PvpRankToday Table
37 04/30/13 23;40:00 : CRFWorldDatabase Date(20130501) : Update_RaceRank End Success!
38 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step1(char* szDate(20130501)) : Update_GuildRank Start!
39 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step1(char* szDate(20130501)) : Start Create #tbl_GuildRankTemp Table
40 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step1(char* szDate(20130501)) : Create #tbl_GuildRankTemp Table Fail NO_DATA!
41 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step1(char* szDate(20130501)) : End Create #tbl_GuildRankTemp Table
42 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step1(char* szDate(20130501)) : Start Create tbl_GuildRank20130501 Table
43 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step1(char* szDate(20130501)) : Create tbl_GuildRank20130501 Table Fail NO_DATA!
44 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step1(char* szDate(20130501)) : End Create tbl_GuildRank20130501 Table
45 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step1(char* szDate(20130501)) : Start drop table #tbl_GuildRankTemp
46 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step1(char* szDate(20130501)) : End drop table #tbl_GuildRankTemp
47 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step2(char* szDate(20130501)) : Start Update Rate
48 04/30/13 23;40:00 : CRFWorldDatabase::Update_GuildRank_Step2(char* szDate(20130501)) : End Update Rate
49 04/30/13 23;40:01 : CRFWorldDatabase::Update_GuildRank_Step3(char* szDate(20130501)) : Start Drop tbl_GuildRankToday Table
50 04/30/13 23;40;01 : CRFWorldDatabase::Update_GuildRank_Step3(char* szDate(20130501)) : End Drop tbl_GuildRankToday Table
51 04/30/13 23;40;01 : CRFWorldDatabase::Update_GuildRank_Step3(char* szDate(20130501)) : Start Create tbl_GuildRankToday Table
52 04/30/13 23;40;01 : CRFWorldDatabase::Update_GuildRank_Step3(char* szDate(20130501)) : End Create tbl_GuildRankToday Table
53 04/30/13 23;40;01 : CRFWorldDatabase::Update_GuildRank_Step3(char* szDate(20130501)) : Update_GuildRank Success
|