Yeah, that's not how the DB entries are done :P
Code:
describe veteran_reward_templates;
+-------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------------+------+-----+---------+-------+
| claim_id | int(10) unsigned | NO | PRI | NULL | |
| name | varchar(64) | NO | | NULL | |
| item_id | int(10) unsigned | NO | | NULL | |
| charges | smallint(5) unsigned | NO | | NULL | |
| reward_slot | tinyint(3) unsigned | NO | PRI | NULL | |
+-------------+----------------------+------+-----+---------+-------+
and
Code:
describe account_rewards;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| account_id | int(10) unsigned | NO | PRI | NULL | |
| reward_id | int(10) unsigned | NO | PRI | NULL | |
| amount | int(10) unsigned | NO | | NULL | |
+------------+------------------+------+-----+---------+-------+
Entries I have
Code:
select * from veteran_reward_templates;
+----------+------------------+---------+---------+-------------+
| claim_id | name | item_id | charges | reward_slot |
+----------+------------------+---------+---------+-------------+
| 1 | Cloth Cap | 1001 | 1 | 0 |
| 2 | Tae Ew Hide Sack | 17123 | 1 | 0 |
| 2 | Cloth Cap | 1001 | 3 | 1 |
+----------+------------------+---------+---------+-------------+
Code:
select * from account_rewards;
+------------+-----------+--------+
| account_id | reward_id | amount |
+------------+-----------+--------+
| 70624 | 1 | 93 |
| 70624 | 2 | 1 |
+------------+-----------+--------+