resource missing
Status: Alpha
Brought to you by:
soldevi
Menu
▾
▴
#9 resource missing
A resource is missing:
Gaolimopi, Bal'ta'ran Amorphous Gemstone.
In the db, the resource is entered as "gaolimopi", but
not as "Gaolimopi"(case typo). Dunno if this is really
the problem.
The category seems also to be a tiny wrong if we
compare it with swgcraft data:
swgres: Bal'ta'ran Crystal Amorphous Gemstone
swgcraft: Bal'ta'ran Amorphous Gemstone
Is this field entered automaticly through imports ?
Logged In: YES
user_id=1128066
The swgcraftparser.php script compensates for the discrepencies between the category names. If you look at the output from that script, it will tell you whether or not it found a matching category (FOUND or NOT FOUND).
As for looking up resource names, case sensitivity should not have any effect. MySQL ignores these discrepencies.
For example:
mysql> select * from resources where name='Idoikiam';
+------+----------+----------+----+-----+-----+-----+----+-----+-----+----+-----+-----+-----+
| id | category | name | ER | CR | CD | DR | FL | HR | MA | PE | OQ | SR | UT |
+------+----------+----------+----+-----+-----+-----+----+-----+-----+----+-----+-----+-----+
| 3795 | 6008 | Idoikiam | 0 | 695 | 999 | 692 | 0 | 603 | 966 | 0 | 999 | 794 | 753 |
+------+----------+----------+----+-----+-----+-----+----+-----+-----+----+-----+-----+-----+
1 row in set (0.08 sec)
mysql> select * from resources where name='idoikiam';
+------+----------+----------+----+-----+-----+-----+----+-----+-----+----+-----+-----+-----+
| id | category | name | ER | CR | CD | DR | FL | HR | MA | PE | OQ | SR | UT |
+------+----------+----------+----+-----+-----+-----+----+-----+-----+----+-----+-----+-----+
| 3795 | 6008 | Idoikiam | 0 | 695 | 999 | 692 | 0 | 603 | 966 | 0 | 999 | 794 | 753 |
+------+----------+----------+----+-----+-----+-----+----+-----+-----+----+-----+-----+-----+
1 row in set (0.00 sec)