网站打开空白页面

小弟遇到一个问题，这是个从数据库拉取数据 并输出xml文件到客户端的一个php程序
直接访问的话会显示

无法显示 XML 页。 使用 样式表无法查看 XML 输入。请更正错误然后单击 刷新按钮，或以后重试。

---

XML 文档必须有一个顶层元素。处理资源 'http://q60.sjqk.wanhui2.com/salegen/gamesortquery.php' 时出错。

-----------上面的情况是正常的

可是我的打开直接是空白的页面 不知道哪位老大能帮忙解决下  

附上两个php的文件

<?php
require_once '/gamesort.php';

$rankType = isset($_GET['t']) ? intval($_GET['t']) : 0;         
$curPage = isset($_GET['p']) ? intval($_GET['p']) : 1;

$memCacheKey = REGION_PREFIX . MEMCACHE_PARTITION. MEMCACHE_PREFIX . MEMCACHE_PARTITION . $rankType . MEMCACHE_PARTITION . $curPage;

$outXml = fetchXmlData($memCacheKey);
if ($outXml){
    header("content-type:text/xml;charset=utf-8");
    print $outXml;
}
else{
        header("content-type:text/xml;charset=utf-8");
        $outXmlList = cacheRankInfo($rankType);
        print $outXmlList[$memCacheKey];
}

?>

我也帮不到你...

我也帮不到你...

帮您顶

1. <?php
   
2. require_once 'config.php';
   
3. define('MEMCACHE_PREFIX', 'gamesort');
   
4. define('MEMCACHE_PARTITION', '|');
   
5. define('MEMCACHE_TIME', 600);
   
6. 
   
7. $RankPerKey = REGION_PREFIX . MEMCACHE_PARTITION. MEMCACHE_PREFIX .MEMCACHE_PARTITION;
   
8. $metaData = array(
   
9.     'page'      => 50 ,
   
10.     'order'     => '',  
    
11.     'limit'     => 50 ,
    
12. );
    
13. 
    
14. function cacheRankInfo($sortType){
    
15.     global $RankPerKey;
    
16.     $dbData = array();
    
17.     switch ($sortType)
    
18.     {
    
19.         case 1:
    
20.             $dbData = fetchBodyRank();
    
21.             break;
    
22.         case 2:
    
23.             $dbData = fetchSoulRank();
    
24.             break;
    
25.         case 3:
    
26.             $dbData = fetchTrumpRank();
    
27.             break;
    
28.         case 4:
    
29.             $dbData = fetchPetRank();
    
30.             break;
    
31.         case 5:
    
32.             $dbData = fetchGuildRank();
    
33.             break;
    
34.         case 6:
    
35.             $dbData = fetchPkRank();
    
36.             break;
    
37.         case 7:
    
38.                 $dbData = fetchFurnishmentRank();
    
39.                 break;
    
40.         case 8:
    
41.                 $dbData = fetchFortuneRank();
    
42.                 break;
    
43.         case 9:
    
44.             $dbData = fetchAbilityRank();
    
45.             break;
    
46.         case 10:
    
47.             $dbData = fetchFlypetRank();
    
48.             break;
    
49.         case 11:
    
50.             $dbData = fetchRidepetRank();
    
51.             break;
    
52.         case 12:
    
53.             $dbData = fetchChanllengeRank();
    
54.             break;
    
55.         case 13:
    
56.             $dbData = fetchRemedyRank();
    
57.             break;
    
58.         case 14:
    
59.             $dbData = fetchMonsterRank();
    
60.             break;
    
61.         case 15:
    
62.             $dbData = fetchWeaponRank();
    
63.             break;
    
64.         default:
    
65.             return;
    
66.     }
    
67.    
    
68.     //print_r($dbData);
    
69.     if(count($dbData) < 1) return;
    
70.     $perKey = $RankPerKey . $sortType . MEMCACHE_PARTITION;
    
71.     $sortData = fetchPageData($dbData, $perKey);
    
72.     //print_r($sortData);
    
73.     $shopXmlData = parseToXml($sortData);
    
74.     saveToCache($shopXmlData);
    
75.     return $shopXmlData;
    
76.     //clearCache($shopXmlData);
    
77. }
    
78. 
    
79. 
    
80. //武器排行
    
81. function fetchWeaponRank ()
    
82. {
    
83.     global $metaData;
    
84.    
    
85.     $data = array();
    
86.     $dB = dbConnect();
    
87.    
    
88.     $query = "SELECT char_oid,sort_effect_val1,sort_para FROM char_stat_sort WHERE sort_type = 15 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
    
89.     $query .= " limit ". $metaData['limit'];
    
90.     $result = $dB->query($query);  
    
91.    
    
92.     $objUidList = "";
    
93.     $rank = 0;
    
94.     $minVal = 0;
    
95.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
    
96.         $rank++;
    
97.         if($objUidList != ""){
    
98.             $objUidList = $objUidList . ",";
    
99.         }
    
100.         $objUidList = $objUidList . "'" . $row["char_oid"] . "'";
     
101.         $data[] = array(
     
102.             'rank' => $rank,
     
103.             'weapon_type' => $row['sort_para'],
     
104.             'quality' => $row['sort_effect_val1'],
     
105.             'char_oid' => $row['char_oid'],
     
106.         );
     
107.         
     
108.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
109.     }
     
110.    
     
111.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 15";
     
112.     $dB->query($query);
     
113.    
     
114.     if ($objUidList == ""){
     
115.         $dB->close();
     
116.         return array();
     
117.     }
     
118.    
     
119.     $query = "SELECT char_oid, name FROM char_data WHERE char_oid in (" . $objUidList .")";
     
120.     $result = $dB->query($query);  
     
121.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
122.         $charName[$row['char_oid']] = $row["name"];
     
123.     }
     
124.     foreach($data as $key => $row){
     
125.         $data[$key]['name'] = $charName[$row['char_oid']];
     
126.     }
     
127.    
     
128.     $dB->close();
     
129.     return $data;
     
130. }
     
131. 
     
132. //万妖窟排行
     
133. function fetchMonsterRank ()
     
134. {
     
135.     global $metaData;
     
136.    
     
137.     $data = array();
     
138.     $dB = dbConnect();
     
139.    
     
140.     $query = "SELECT char_oid,sort_effect_val1 FROM char_stat_sort WHERE sort_type = 14 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
141.     $query .= " limit ". $metaData['limit'];
     
142.     $result = $dB->query($query);  
     
143.    
     
144.     $objUidList = "";
     
145.     $rank = 0;
     
146.     $minVal = 0;
     
147.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
148.         $rank++;
     
149.         if($objUidList != ""){
     
150.             $objUidList = $objUidList . ",";
     
151.         }
     
152.         $objUidList = $objUidList . "'" . $row["char_oid"] . "'";
     
153.         $data[$row["char_oid"]]['endless'] = $row["sort_effect_val1"];
     
154.         $data[$row["char_oid"]]['rank'] = $rank;
     
155.         $data[$row["char_oid"]]['char_oid'] = $row["char_oid"];
     
156.         
     
157.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
158.     }
     
159.    
     
160.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 14";
     
161.     $dB->query($query);
     
162.    
     
163.     if ($objUidList == ""){
     
164.         $dB->close();
     
165.         return array();
     
166.     }
     
167.    
     
168.     $query = "SELECT char_oid, name FROM char_data WHERE char_oid in (" . $objUidList .")";
     
169.     $result = $dB->query($query);  
     
170.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
171.         $data[$row["char_oid"]]["name"] = $row["name"];
     
172.     }
     
173.    
     
174.     $dB->close();
     
175.     return $data;
     
176. }
     
177. 
     
178. function fetchRemedyRank ()
     
179. {
     
180.     global $metaData;
     
181.    
     
182.     $data = array();
     
183.     $dB = dbConnect();
     
184.    
     
185.     $query = "SELECT char_oid,sort_effect_val1 FROM char_stat_sort WHERE sort_type = 13 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
186.     $query .= " limit ". $metaData['limit'];
     
187.     $result = $dB->query($query);  
     
188.    
     
189.     $objUidList = "";
     
190.     $rank = 0;
     
191.     $minVal = 0;
     
192.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
193.         $rank++;
     
194.         if($objUidList != ""){
     
195.             $objUidList = $objUidList . ",";
     
196.         }
     
197.         $objUidList = $objUidList . "'" . $row["char_oid"] . "'";
     
198.         $data[$row["char_oid"]]['remedy'] = $row["sort_effect_val1"];
     
199.         $data[$row["char_oid"]]['rank'] = $rank;
     
200.         $data[$row["char_oid"]]['char_oid'] = $row["char_oid"];
     
201.         
     
202.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
203.     }
     
204.    
     
205.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 13";
     
206.     $dB->query($query);
     
207.    
     
208.     if ($objUidList == ""){
     
209.         $dB->close();
     
210.         return array();
     
211.     }
     
212.    
     
213.     $query = "SELECT char_oid, name FROM char_data WHERE char_oid in (" . $objUidList .")";
     
214.     $result = $dB->query($query);  
     
215.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
216.         $data[$row["char_oid"]]["name"] = $row["name"];
     
217.     }
     
218.    
     
219.     $dB->close();
     
220.     return $data;
     
221. }
     
222. 
     
223. function fetchChanllengeRank(){
     
224.     global $metaData;
     
225.    
     
226.     $query = "SELECT challenge_order,school,char_oid,name FROM char_challenge ORDER BY challenge_order  limit " . $metaData['limit'];
     
227. 
     
228.     $data = array();
     
229.     $dB = dbConnect();
     
230.     $result = $dB->query($query);  
     
231.    
     
232.     $rank = 0;
     
233.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
234.         $rank++;
     
235.         $data[$rank] = $row;
     
236.         $data[$rank]["rank"] = $rank;
     
237.     }
     
238.    
     
239.     $dB->close();
     
240.     return $data;
     
241. }
     
242. 
     
243. function fetchGuildRank ()
     
244. {
     
245.     global $metaData;
     
246.    
     
247.     $query = "SELECT a.*, char_oid FROM (SELECT guild_id,name as guild_name,level,leader_name as name,member_count as count FROM guild_data FORCE INDEX (level) ORDER BY LEVEL DESC, boom DESC";
     
248.     $query .= " limit ". $metaData['limit'] .") AS a LEFT JOIN char_data b ON ( a.name = b.name )";
     
249. 
     
250.     $data = array();
     
251.     $dB = dbConnect();
     
252.     $result = $dB->query($query);  
     
253.    
     
254.     $rank = 0;
     
255.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
256.         $rank++;
     
257.         $data[$rank] = $row;
     
258.         $data[$rank]["rank"] = $rank;
     
259.     }
     
260.    
     
261.     $dB->close();
     
262.     return $data;
     
263. }
     
264. 
     
265. function fetchBodyRank ()
     
266. {
     
267.     global $metaData;
     
268.    
     
269.     $data = array();
     
270.     $dB = dbConnect();
     
271.    
     
272.     $query = "SELECT object_uid,sort_effect_val1 FROM char_item_sort WHERE sort_type = 1 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
273.     $query .= " limit ". $metaData['limit'];
     
274.     $result = $dB->query($query);  
     
275.    
     
276.     $objUidList = "";
     
277.     $rank = 0;
     
278.     $minVal = 0;
     
279.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
280.         $rank++;
     
281.         if($objUidList != ""){
     
282.             $objUidList = $objUidList . ",";
     
283.         }
     
284.         $objUidList = $objUidList . "'" . $row["object_uid"] . "'";
     
285.         $data[$row["object_uid"]]['level'] = $row["sort_effect_val1"];
     
286.         $data[$row["object_uid"]]['rank'] = $rank;
     
287.         
     
288.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
289.     }
     
290.    
     
291.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 1";
     
292.     $dB->query($query);
     
293.    
     
294.     if ($objUidList == ""){
     
295.         $dB->close();
     
296.         return array();
     
297.     }
     
298.    
     
299.     $query = "SELECT a.item_uuid, a.owner_oid, b.name FROM char_items as a, char_data b WHERE a.owner_oid = b.char_oid and a.item_uuid in (" . $objUidList .")";
     
300.     $result = $dB->query($query);  
     
301. 
     
302.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
303.         $data[$row["item_uuid"]]["name"] = $row["name"];
     
304.         $data[$row["item_uuid"]]["char_oid"] = $row["owner_oid"];
     
305.         
     
306.         // 把角色ID刷到角色物品排行表
     
307.         $sql = "UPDATE char_item_sort SET char_oid = ".$row["owner_oid"]." WHERE object_uid = '".$row["item_uuid"]."'";
     
308.         $dB->query($sql);
     
309.     }
     
310.    
     
311.     // 如果肉身数据不存在，则删除排名数据
     
312.     foreach($data as $key => $rankVal){
     
313.         if (!isset($rankVal["name"])){
     
314.             $query = "DELETE FROM char_item_sort WHERE object_uid = '" . $key . "'";
     
315.             $result = $dB->query($query);
     
316.         }
     
317.     }
     
318.    
     
319.     $dB->close();
     
320.     return $data;
     
321. }
     
322. 
     
323. function fetchSoulRank ()
     
324. {
     
325.     global $metaData;
     
326.    
     
327.     $data = array();
     
328.     $dB = dbConnect();
     
329.    
     
330.     $query = "SELECT char_oid,sort_effect_val1 FROM char_stat_sort WHERE sort_type = 2 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
331.     $query .= " limit ". $metaData['limit'];
     
332.     $result = $dB->query($query);  
     
333.    
     
334.     $objUidList = "";
     
335.     $rank = 0;
     
336.     $minVal = 0;
     
337.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
338.         $rank++;
     
339.         if($objUidList != ""){
     
340.             $objUidList = $objUidList . ",";
     
341.         }
     
342.         $objUidList = $objUidList . "'" . $row["char_oid"] . "'";
     
343.         $data[$row["char_oid"]]['level'] = $row["sort_effect_val1"];
     
344.         $data[$row["char_oid"]]['rank'] = $rank;
     
345.         $data[$row["char_oid"]]['char_oid'] = $row["char_oid"];
     
346.         
     
347.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
348.     }
     
349.    
     
350.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 2";
     
351.     $dB->query($query);
     
352.    
     
353.     if ($objUidList == ""){
     
354.         $dB->close();
     
355.         return array();
     
356.     }
     
357.    
     
358.     $query = "SELECT char_oid, name FROM char_data WHERE char_oid in (" . $objUidList .")";
     
359.     $result = $dB->query($query);  
     
360.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
361.         $data[$row["char_oid"]]["name"] = $row["name"];
     
362.     }
     
363.    
     
364.     $dB->close();
     
365.     return $data;
     
366. }
     
367. 
     
368. function fetchTrumpRank ()
     
369. {
     
370.     global $metaData;
     
371.    
     
372.     $data = array();
     
373.     $dB = dbConnect();
     
374.    
     
375.     $query = "SELECT object_uid,sort_effect_val1,sort_effect_val2 FROM char_item_sort WHERE sort_type = 3 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
376.     $query .= " limit ". $metaData['limit'];
     
377.     $result = $dB->query($query);  
     
378.    
     
379.     $objUidList = "";
     
380.     $rank = 0;
     
381.     $minVal1 = 0;
     
382.     $minVal2 = 0;
     
383.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
384.         $rank++;
     
385.         if($objUidList != ""){
     
386.             $objUidList = $objUidList . ",";
     
387.         }
     
388.         $objUidList = $objUidList . "'" . $row["object_uid"] . "'";
     
389.         $data[$row["object_uid"]]['rank'] = $rank;
     
390.         $data[$row["object_uid"]]['item_uuid'] = $row["object_uid"];
     
391.         $data[$row["object_uid"]]['quality'] = $row["sort_effect_val2"];
     
392.         $data[$row["object_uid"]]['power'] = $row["sort_effect_val1"];
     
393.         
     
394.         if ($rank == $metaData['limit']) {
     
395.             $minVal1 = $row["sort_effect_val1"];
     
396.             $minVal2 = $row["sort_effect_val2"];
     
397.         }
     
398.     }
     
399.    
     
400.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal1 . ", rank_val2_min = " . $minVal2 . " where rank_type = 3";
     
401.     $dB->query($query);
     
402.    
     
403.     if ($objUidList == ""){
     
404.         $dB->close();
     
405.         return array();
     
406.     }
     
407.    
     
408.     $query = "SELECT item_uuid, owner_oid, template_oid FROM char_items WHERE item_uuid in (" . $objUidList .")";
     
409.     $result = $dB->query($query);
     
410.     $charOidList = "";
     
411.     $petOidList = "";
     
412.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
413.         if ($row["owner_oid"] < 4294967295){
     
414.             if($charOidList != ""){
     
415.                 $charOidList = $charOidList . ",";
     
416.             }
     
417.             $charOidList = $charOidList . "'" . $row["owner_oid"] . "'";
     
418.         }
     
419.         else{
     
420.             if($petOidList != ""){
     
421.                 $petOidList = $petOidList . ",";
     
422.             }
     
423.             $petOidList = $petOidList . "'" . $row["owner_oid"] . "'";
     
424.         }
     
425.         
     
426.         $data[$row["item_uuid"]]["template_oid"] = $row["template_oid"];
     
427.         $data[$row["item_uuid"]]["name"] = "";
     
428.         $data[$row["item_uuid"]]["owner_oid"] = $row["owner_oid"];
     
429.         $data[$row["item_uuid"]]["char_oid"] = $row["owner_oid"];
     
430.     }
     
431.    
     
432.     $oid2name = array();
     
433.     if($petOidList != ""){
     
434.         $query = "SELECT pet_oid, b.name FROM char_pets a, char_data b WHERE pet_oid in (" . $petOidList .") and a.char_oid = b.char_oid";
     
435.         $result = $dB->query($query);
     
436.         while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
437.             $oid2name[$row["pet_oid"]] = $row["name"];
     
438.         }
     
439.     }
     
440.    
     
441.     if($charOidList != ""){
     
442.         $query = "SELECT char_oid, name FROM char_data WHERE char_oid in (" . $charOidList .")";
     
443.         $result = $dB->query($query);  
     
444.         while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
445.             $oid2name[$row["char_oid"]] = $row["name"];
     
446.         }
     
447.     }
     
448.    
     
449.     foreach($data as $key => $rankVal){
     
450.         if(isset($oid2name[$rankVal["owner_oid"]])){
     
451.             $data[$key]["name"] = $oid2name[$rankVal["owner_oid"]];
     
452.             
     
453.             // 把角色ID刷到角色物品排行表
     
454.                 $sql = "UPDATE char_item_sort SET char_oid = ".$rankVal["owner_oid"]." WHERE object_uid = '".$rankVal["item_uuid"]."'";
     
455.                 $dB->query($sql);
     
456.         }
     
457.         else{
     
458.             // 如果法宝数据不存在，则删除排名数据
     
459.             $query = "DELETE FROM char_item_sort WHERE object_uid = '" . $key . "'";
     
460.             $result = $dB->query($query);
     
461.         }
     
462.     }
     
463. 
     
464.     $dB->close();
     
465.     return $data;
     
466. }
     
467. 
     
468. function fetchPetRank ()
     
469. {
     
470.     global $metaData;
     
471.    
     
472.     $data = array();
     
473.     $dB = dbConnect();
     
474.    
     
475.     $query = "SELECT object_uid,sort_effect_val1,sort_effect_val2 FROM char_item_sort WHERE sort_type = 4 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
476.     $query .= " limit ". $metaData['limit'];
     
477.     $result = $dB->query($query);  
     
478.    
     
479.     $objUidList = "";
     
480.     $rank = 0;
     
481.     $minVal = 500;
     
482.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
483.         $rank++;
     
484.         if($objUidList != ""){
     
485.             $objUidList = $objUidList . ",";
     
486.         }
     
487.         $objUidList = $objUidList . "'" . $row["object_uid"] . "'";
     
488.         $data[$row["object_uid"]]['rank'] = $rank;
     
489.         $data[$row["object_uid"]]['pet_oid'] = $row["object_uid"];
     
490.         $data[$row["object_uid"]]['quality'] = $row["sort_effect_val2"];
     
491.         $data[$row["object_uid"]]['power'] = $row["sort_effect_val1"];
     
492.         
     
493.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
494.     }
     
495.    
     
496.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 4";
     
497.     $dB->query($query);
     
498.    
     
499.     if ($objUidList == ""){
     
500.         $dB->close();
     
501.         return array();
     
502.     }
     
503.    
     
504.     $query = "SELECT pet_oid, b.name as name, a.name as pname,b.char_oid as char_oid FROM char_pets a, char_data b WHERE a.char_oid = b.char_oid and pet_oid in (" . $objUidList .")";
     
505.     //print_r($query);
     
506.     $result = $dB->query($query);  
     
507.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
508.         $data[$row["pet_oid"]]["name"] = $row["name"];
     
509.         $data[$row["pet_oid"]]["pet_name"] = $row["pname"];
     
510.         $data[$row["pet_oid"]]["char_oid"] = $row["char_oid"];
     
511.         
     
512.         // 把角色ID刷到角色物品排行表
     
513.         $sql = "UPDATE char_item_sort SET char_oid = ".$row["char_oid"]." WHERE object_uid = '".$row["pet_oid"]."'";
     
514.         $dB->query($sql);
     
515.     }
     
516.    
     
517.     // 如果宠物数据不存在，则删除排名数据
     
518.     foreach($data as $key => $rankVal){
     
519.         if (!isset($rankVal["name"])){
     
520.             $query = "DELETE FROM char_item_sort WHERE object_uid = '" . $key . "'";
     
521.             $result = $dB->query($query);
     
522.         }
     
523.     }
     
524.    
     
525.     $dB->close();
     
526.     return $data;
     
527. }
     
528. 
     
529. function fetchPkRank ()
     
530. {
     
531.     global $metaData;
     
532.    
     
533.     $data = array();
     
534.     $dB = dbConnect();
     
535.    
     
536.     $query = "SELECT char_oid,sort_effect_val1 FROM char_stat_sort WHERE sort_type = 6 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
537.     $query .= " limit ". $metaData['limit'];
     
538.     $result = $dB->query($query);  
     
539.    
     
540.     $objUidList = "";
     
541.     $rank = 0;
     
542.     $minVal = 0;
     
543.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
544.         $rank++;
     
545.         if($objUidList != ""){
     
546.             $objUidList = $objUidList . ",";
     
547.         }
     
548.         $objUidList = $objUidList . "'" . $row["char_oid"] . "'";
     
549.         $data[$row["char_oid"]]['pk_point'] = $row["sort_effect_val1"];
     
550.         $data[$row["char_oid"]]['rank'] = $rank;
     
551.         
     
552.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
553.     }
     
554.    
     
555.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 6";
     
556.     $dB->query($query);
     
557.    
     
558.     if ($objUidList == ""){
     
559.         $dB->close();
     
560.         return array();
     
561.     }
     
562.    
     
563.     $query = "SELECT a.char_oid, name, b.level as blevel, c.level as slevel FROM char_data a,char_body b,char_soul c WHERE a.char_oid in (" . $objUidList .") and a.char_oid = b.char_oid and a.char_oid = c.char_oid ";
     
564.     $result = $dB->query($query);  
     
565.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
566.         $data[$row["char_oid"]]["name"] = $row["name"];
     
567.         $data[$row["char_oid"]]["body_level"] = $row["blevel"];
     
568.         $data[$row["char_oid"]]["soul_level"] = $row["slevel"];
     
569.     }
     
570.    
     
571.     $dB->close();
     
572.     return $data;
     
573. }
     
574. 
     
575. function fetchFurnishmentRank(){
     
576.         global $metaData;
     
577.    
     
578.     $data = array();
     
579.     $dB = dbConnect();
     
580.    
     
581.     $query = "SELECT object_uid,sort_effect_val1, sort_effect_val2 FROM char_item_sort WHERE sort_type = 7 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
582.     $query .= " limit ". $metaData['limit'];
     
583.     $result = $dB->query($query);  
     
584.    
     
585.     $objUidList = "";
     
586.     $rank = 0;
     
587.     $minVal = 0;
     
588.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
589.         $rank++;
     
590.         if($objUidList != ""){
     
591.             $objUidList = $objUidList . ",";
     
592.         }
     
593.         $objUidList = $objUidList . "'" . $row["object_uid"] . "'";
     
594.         $data[$row["object_uid"]]['rank'] = $rank;
     
595.         $data[$row["object_uid"]]['item_uuid'] = $row["object_uid"];
     
596.         $data[$row["object_uid"]]['quality'] = $row["sort_effect_val2"];
     
597.         $data[$row["object_uid"]]['power'] = $row["sort_effect_val1"];
     
598.         
     
599.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
600.     }
     
601.    
     
602.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 7";
     
603.     $dB->query($query);
     
604.    
     
605.     if ($objUidList == ""){
     
606.         $dB->close();
     
607.         return array();
     
608.     }
     
609.    
     
610.     $query = "SELECT a.item_uuid, a.template_oid, a.owner_oid, b.name FROM char_items as a, char_data b WHERE a.owner_oid = b.char_oid and a.item_uuid in (" . $objUidList .")";
     
611.     $result = $dB->query($query);  
     
612. 
     
613.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
614.         $data[$row["item_uuid"]]["name"] = $row["name"];
     
615.         $data[$row["item_uuid"]]["char_oid"] = $row["owner_oid"];
     
616.         $data[$row["item_uuid"]]["template_oid"] = $row["template_oid"];
     
617.         
     
618.         // 把角色ID刷到角色物品排行表
     
619.         $sql = "UPDATE char_item_sort SET char_oid = ".$row["owner_oid"]." WHERE object_uid = '".$row["item_uuid"]."'";
     
620.         $dB->query($sql);
     
621.     }
     
622.     $dB->close();
     
623.     return $data;
     
624. }
     
625. 
     
626. function fetchFortuneRank(){
     
627.         global $metaData;
     
628.    
     
629.     $data = array();
     
630.     $dB = dbConnect();
     
631.    
     
632.     $query = "SELECT char_oid,sort_effect_val1 FROM char_stat_sort WHERE sort_type = 8 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
633.     $query .= " limit ". $metaData['limit'];
     
634.     $result = $dB->query($query);  
     
635.    
     
636.     $objUidList = "";
     
637.     $rank = 0;
     
638.     $minVal = 0;
     
639.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
640.         $rank++;
     
641.         if($objUidList != ""){
     
642.             $objUidList = $objUidList . ",";
     
643.         }
     
644.         $objUidList = $objUidList . "'" . $row["char_oid"] . "'";
     
645.         $data[$row["char_oid"]]['rank'] = $rank;
     
646.         $data[$row["char_oid"]]['money'] = $row["sort_effect_val1"];
     
647.         $data[$row["char_oid"]]['char_oid'] = $row["char_oid"];
     
648.         
     
649.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
650.     }
     
651.    
     
652.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 8";
     
653.     $dB->query($query);
     
654.    
     
655.     if ($objUidList == ""){
     
656.         $dB->close();
     
657.         return array();
     
658.     }
     
659.    
     
660.     $query = "SELECT char_oid, name FROM char_data WHERE char_oid in (" . $objUidList .")";
     
661.     $result = $dB->query($query);  
     
662.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
663.         $data[$row["char_oid"]]["name"] = $row["name"];
     
664.     }
     
665.    
     
666.     $dB->close();
     
667.     return $data;
     
668. }
     
669. 
     
670. function fetchAbilityRank(){
     
671.     global $metaData;
     
672.    
     
673.     $data = array();
     
674.     $dB = dbConnect();
     
675.    
     
676.     $query = "SELECT char_oid,sort_effect_val1, sort_effect_val2 FROM char_stat_sort WHERE sort_type = 9 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
677.     $query .= " limit ". $metaData['limit'];
     
678.     $result = $dB->query($query);  
     
679.    
     
680.     $objUidList = "";
     
681.     $rank = 0;
     
682.     $minVal = 0;
     
683.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
684.         $rank++;
     
685.         if($objUidList != ""){
     
686.             $objUidList = $objUidList . ",";
     
687.         }
     
688.         $objUidList = $objUidList . "'" . $row["char_oid"] . "'";
     
689.         $data[$row["char_oid"]]['rank'] = $rank;
     
690.         $data[$row["char_oid"]]['power'] = $row["sort_effect_val1"];
     
691.         $data[$row["char_oid"]]['level'] = $row["sort_effect_val2"];
     
692.         $data[$row["char_oid"]]['char_oid'] = $row["char_oid"];
     
693.         
     
694.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
695.     }
     
696.    
     
697.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 9";
     
698.     $dB->query($query);
     
699.    
     
700.     if ($objUidList == ""){
     
701.         $dB->close();
     
702.         return array();
     
703.     }
     
704.    
     
705.     $query = "SELECT char_oid, name FROM char_data WHERE char_oid in (" . $objUidList .")";
     
706.     $result = $dB->query($query);  
     
707.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
708.         $data[$row["char_oid"]]["name"] = $row["name"];
     
709.     }
     
710.    
     
711.     $dB->close();
     
712.     return $data;
     
713. }
     
714. 
     
715. //飞行宠排行
     
716. function fetchFlypetRank(){
     
717.     global $metaData;
     
718.    
     
719.     $data = array();
     
720.     $dB = dbConnect();
     
721.    
     
722.     $query = "SELECT char_oid, sort_effect_val1, sort_effect_val2 FROM char_stat_sort WHERE sort_type = 10 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
723.     $query .= " limit ". $metaData['limit'];
     
724.     $result = $dB->query($query);  
     
725.    
     
726.     $objUidList = "";
     
727.     $rank = 0;
     
728.     $minVal = 0;
     
729.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
730.         $rank++;
     
731.         if($objUidList != ""){
     
732.             $objUidList = $objUidList . ",";
     
733.         }
     
734.         $objUidList = $objUidList . "'" . $row["char_oid"] . "'";
     
735.         $data[$row["char_oid"]]['rank'] = $rank;
     
736.         $data[$row["char_oid"]]['quality'] = $row["sort_effect_val2"];
     
737.         $data[$row["char_oid"]]['char_oid'] = $row["char_oid"];
     
738.         
     
739.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
740.     }
     
741.    
     
742.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 10";
     
743.     $dB->query($query);
     
744.    
     
745.     if ($objUidList == ""){
     
746.         $dB->close();
     
747.         return array();
     
748.     }
     
749.    
     
750.     $query = "SELECT char_oid, name FROM char_data WHERE char_oid in (" . $objUidList .")";
     
751.     $result = $dB->query($query);  
     
752.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
753.         $data[$row["char_oid"]]["name"] = $row["name"];
     
754.     }
     
755.    
     
756.     $query = "SELECT char_oid, level FROM char_ride WHERE ride_type = 1 AND char_oid in (" . $objUidList .")";
     
757.     $result = $dB->query($query);  
     
758.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
759.         $data[$row["char_oid"]]["level"] = $row["level"];
     
760.     }
     
761.    
     
762.     $dB->close();
     
763.     return $data;
     
764. }
     
765. 
     
766. //坐骑排行
     
767. function fetchRidepetRank(){
     
768.     global $metaData;
     
769.    
     
770.     $data = array();
     
771.     $dB = dbConnect();
     
772.    
     
773.     $query = "SELECT char_oid, sort_effect_val1, sort_effect_val2 FROM char_stat_sort WHERE sort_type = 11 ORDER BY `sort_effect_val1` DESC , `sort_effect_val2` DESC ";
     
774.     $query .= " limit ". $metaData['limit'];
     
775.     $result = $dB->query($query);  
     
776.    
     
777.     $objUidList = "";
     
778.     $rank = 0;
     
779.     $minVal = 0;
     
780.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
781.         $rank++;
     
782.         if($objUidList != ""){
     
783.             $objUidList = $objUidList . ",";
     
784.         }
     
785.         $objUidList = $objUidList . "'" . $row["char_oid"] . "'";
     
786.         $data[$row["char_oid"]]['rank'] = $rank;
     
787.         $data[$row["char_oid"]]['quality'] = $row["sort_effect_val2"];
     
788.         $data[$row["char_oid"]]['char_oid'] = $row["char_oid"];
     
789.         
     
790.         if ($rank == $metaData['limit']) $minVal = $row["sort_effect_val1"];
     
791.     }
     
792.    
     
793.     $query = "UPDATE char_rank_params SET rank_val1_min = " . $minVal . " where rank_type = 11";
     
794.     $dB->query($query);
     
795.    
     
796.     if ($objUidList == ""){
     
797.         $dB->close();
     
798.         return array();
     
799.     }
     
800.    
     
801.     $query = "SELECT char_oid, name FROM char_data WHERE char_oid in (" . $objUidList .")";
     
802.     $result = $dB->query($query);  
     
803.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
804.         $data[$row["char_oid"]]["name"] = $row["name"];
     
805.     }
     
806.    
     
807.     $query = "SELECT char_oid, level FROM char_ride WHERE ride_type = 0 AND char_oid in (" . $objUidList .")";
     
808.     $result = $dB->query($query);  
     
809.     while ($row = $dB->fetchRow($result, MYSQL_ASSOC)) {
     
810.         $data[$row["char_oid"]]["level"] = $row["level"];
     
811.     }
     
812.    
     
813.     $dB->close();
     
814.     return $data;
     
815. }
     
816. 
     
817. function fetchPageData(&$row, $perKey){
     
818.     global $metaData;
     
819.     $curTime = time();
     
820.     $cacheData = array();
     
821.    
     
822.     $records = count($row);
     
823.     $pageAmount = ceil($records / $metaData['page']);
     
824.     $page = 0;
     
825.     $idx = 0;
     
826.     $cacheKey = $perKey . $page;
     
827.     foreach($row as $key => $rankVal){
     
828.         if (($idx % $metaData['page'] == 0)){
     
829.             $page += 1;
     
830.             $cacheKey = $perKey . $page;   
     
831.             $cacheData[$cacheKey]['attribute']['amount'] = $pageAmount;
     
832.             $cacheData[$cacheKey]['attribute']['count'] = $records;
     
833.             $cacheData[$cacheKey]['attribute']['page'] = $page;
     
834.             $cacheData[$cacheKey]['attribute']['limit'] = $metaData['limit'];
     
835.             $cacheData[$cacheKey]['attribute']['date'] = $curTime;
     
836.         }
     
837.         $cacheData[$cacheKey]['data'][] = $row[$key];
     
838.         $idx += 1;
     
839.     }
     
840.     return $cacheData;
     
841. }
     
842. ?>

复制代码

了解了解

我的也是空