Advertisement
Guest User

Untitled

a guest
Apr 6th, 2013
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.28 KB | None | 0 0
  1. $query = mysql_query("SELECT
  2. `entry`,
  3. `RewChoiceItemId1`,
  4. `RewChoiceItemId2`,
  5. `RewChoiceItemId3`,
  6. `RewChoiceItemId4`,
  7. `RewChoiceItemId5`,
  8. `RewChoiceItemId6`
  9. FROM
  10. `quest_template` WHERE `entry` IN (". $QueryString .");", $connection) or die(mysql_error());
  11. $result = mysql_fetch_array($query);
  12. print_r($result);
  13.  
  14. while($result = mysql_fetch_array($query))
  15. {
  16. echo "<br/>". $result['entry'];
  17. $CHAR_ARRAY['QuestList'][$result['entry']]['Reward1'] = $result['RewChoiceItemId1'];
  18. $CHAR_ARRAY['QuestList'][$result['entry']]['Reward2'] = $result['RewChoiceItemId2'];
  19. $CHAR_ARRAY['QuestList'][$result['entry']]['Reward3'] = $result['RewChoiceItemId3'];
  20. $CHAR_ARRAY['QuestList'][$result['entry']]['Reward4'] = $result['RewChoiceItemId4'];
  21. $CHAR_ARRAY['QuestList'][$result['entry']]['Reward5'] = $result['RewChoiceItemId5'];
  22. $CHAR_ARRAY['QuestList'][$result['entry']]['Reward6'] = $result['RewChoiceItemId6'];
  23. }
  24. QUERY:
  25. MYSQL: SELECT
  26. `entry`,
  27. `RewChoiceItemId1`,
  28. `RewChoiceItemId2`,
  29. `RewChoiceItemId3`,
  30. `RewChoiceItemId4`,
  31. `RewChoiceItemId5`,
  32. `RewChoiceItemId6`
  33. FROM
  34. `quest_template` WHERE `entry` IN (104, 12214, 12855, 24500)
  35. ANSWER:
  36. Array
  37. (
  38. [CharName] => Умбра
  39. [CharGUID] => 5255714
  40. [CharClass] => 2
  41. [CharRace] => 11
  42. [CharLevel] => 80
  43. [CharGender] => 1
  44. [CharArenaP] => 1340
  45. [CharHonorP] => 75000
  46. [RealmName] => Myth
  47. [RealmID] => 1
  48. [QuestList] => Array
  49. (
  50. [12214] => Array
  51. (
  52. [Reward1] => 0
  53. [Reward2] => 0
  54. [Reward3] => 0
  55. [Reward4] => 0
  56. [Reward5] => 0
  57. [Reward6] => 0
  58. )
  59.  
  60. [12855] => Array
  61. (
  62. [Reward1] => 0
  63. [Reward2] => 0
  64. [Reward3] => 0
  65. [Reward4] => 0
  66. [Reward5] => 0
  67. [Reward6] => 0
  68. )
  69.  
  70. [24500] => Array
  71. (
  72. [Reward1] => 0
  73. [Reward2] => 0
  74. [Reward3] => 0
  75. [Reward4] => 0
  76. [Reward5] => 0
  77. [Reward6] => 0
  78. )
  79.  
  80. )
  81.  
  82. )
  83.  
  84. While cycle ignore:
  85. [0] => 104
  86. [entry] => 104
  87. [1] => 1172
  88. [RewChoiceItemId1] => 1172
  89. [2] => 1557
  90. [RewChoiceItemId2] => 1557
  91. [3] => 5240
  92. [RewChoiceItemId3] => 5240
  93. [4] => 0
  94. [RewChoiceItemId4] => 0
  95. [5] => 0
  96. [RewChoiceItemId5] => 0
  97. [6] => 0
  98. [RewChoiceItemId6] => 0
  99.  
  100. don`t know why =/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement