From: <rav...@us...> - 2016-06-02 20:43:55
|
Revision: 9945 http://sourceforge.net/p/planeshift/code/9945 Author: ravna-ps Date: 2016-06-02 20:43:53 +0000 (Thu, 02 Jun 2016) Log Message: ----------- Quest validator now checks if trait name and location in "require trait" are using the proper case. Modified Paths: -------------- www/webconsole-new/quests/validatequest.php Modified: www/webconsole-new/quests/validatequest.php =================================================================== --- www/webconsole-new/quests/validatequest.php 2016-06-01 00:21:29 UTC (rev 9944) +++ www/webconsole-new/quests/validatequest.php 2016-06-02 20:43:53 UTC (rev 9945) @@ -1839,13 +1839,22 @@ $name = trim($trait[0]); $location = trim($trait[1]); - $query = sprintf("SELECT id FROM traits WHERE name = '%s' AND location = '%s'", escapeSqlString($name), escapeSqlString($location)); + $query = sprintf("SELECT name, location FROM traits WHERE name = '%s' AND location = '%s'", escapeSqlString($name), escapeSqlString($location)); $result = mysql_query2($query); if (sqlNumRows($result) < 1) { append_log("Parse Error: could not find trait name ($name) for location ($location) in the database at line $line_number"); return; } + $row = fetchSqlAssoc($result); + if (strcmp($row['name'], $name) !== 0) + { + append_log("Parse Error: trait name is case sensitive, found '$name' instead of {$row['name']}' at line $line_number"); + } + if (strcmp($row['location'], $location) !== 0) + { + append_log("Parse Error: trait location is case sensitive, found '$location' instead of {$row['location']}' at line $line_number"); + } } function validate_gender($gen) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |