Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = mysql_query("SELECT
- `entry`,
- `RewChoiceItemId1`,
- `RewChoiceItemId2`,
- `RewChoiceItemId3`,
- `RewChoiceItemId4`,
- `RewChoiceItemId5`,
- `RewChoiceItemId6`
- FROM
- `quest_template` WHERE `entry` IN (". $QueryString .");", $connection) or die(mysql_error());
- $result = mysql_fetch_array($query);
- print_r($result);
- while($result = mysql_fetch_array($query))
- {
- echo "<br/>". $result['entry'];
- $CHAR_ARRAY['QuestList'][$result['entry']]['Reward1'] = $result['RewChoiceItemId1'];
- $CHAR_ARRAY['QuestList'][$result['entry']]['Reward2'] = $result['RewChoiceItemId2'];
- $CHAR_ARRAY['QuestList'][$result['entry']]['Reward3'] = $result['RewChoiceItemId3'];
- $CHAR_ARRAY['QuestList'][$result['entry']]['Reward4'] = $result['RewChoiceItemId4'];
- $CHAR_ARRAY['QuestList'][$result['entry']]['Reward5'] = $result['RewChoiceItemId5'];
- $CHAR_ARRAY['QuestList'][$result['entry']]['Reward6'] = $result['RewChoiceItemId6'];
- }
- QUERY:
- MYSQL: SELECT
- `entry`,
- `RewChoiceItemId1`,
- `RewChoiceItemId2`,
- `RewChoiceItemId3`,
- `RewChoiceItemId4`,
- `RewChoiceItemId5`,
- `RewChoiceItemId6`
- FROM
- `quest_template` WHERE `entry` IN (104, 12214, 12855, 24500)
- ANSWER:
- Array
- (
- [CharName] => Умбра
- [CharGUID] => 5255714
- [CharClass] => 2
- [CharRace] => 11
- [CharLevel] => 80
- [CharGender] => 1
- [CharArenaP] => 1340
- [CharHonorP] => 75000
- [RealmName] => Myth
- [RealmID] => 1
- [QuestList] => Array
- (
- [12214] => Array
- (
- [Reward1] => 0
- [Reward2] => 0
- [Reward3] => 0
- [Reward4] => 0
- [Reward5] => 0
- [Reward6] => 0
- )
- [12855] => Array
- (
- [Reward1] => 0
- [Reward2] => 0
- [Reward3] => 0
- [Reward4] => 0
- [Reward5] => 0
- [Reward6] => 0
- )
- [24500] => Array
- (
- [Reward1] => 0
- [Reward2] => 0
- [Reward3] => 0
- [Reward4] => 0
- [Reward5] => 0
- [Reward6] => 0
- )
- )
- )
- While cycle ignore:
- [0] => 104
- [entry] => 104
- [1] => 1172
- [RewChoiceItemId1] => 1172
- [2] => 1557
- [RewChoiceItemId2] => 1557
- [3] => 5240
- [RewChoiceItemId3] => 5240
- [4] => 0
- [RewChoiceItemId4] => 0
- [5] => 0
- [RewChoiceItemId5] => 0
- [6] => 0
- [RewChoiceItemId6] => 0
- don`t know why =/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement