View Issue Detail

ID	Project	Category	Submitted / Last Updated
00858	UserSpice	Misc	2020-04-18 22:11:15 / 2020-07-22 20:05:52
Reported	John Williams	Assigned To	Unassigned
Priority	low	Reported	5.0.09
Status	closed fixed	Resolution Version and Commit	5.1.1 d34a67
Summary	Feature: Validation.php
Description	<p>This is very similar to unique, but it checks to see if item is in the database.</p> <p>I load a dropdown menu from database, then validate the content with database to make sure someone did not modify the selected item.</p> <p> </p> <p>Right after line 96, add the following:</p> <p> </p> <blockquote> <p>case 'is_in_database':</p> <p>$table  = is_array($rule_value) ? $rule_value[0] : $rule_value;</p> <p>$fields = is_array($rule_value) ? $rule_value[1] : [$item, '=', $value];</p> <p> </p> <p>if ($this->_db->get($table, $fields)) {</p> <p>$str = lang("VAL_EXISTS");</p> <p>$str1 = lang("VAL_DB");</p> <p>if ($this->_db->count()==0)</p> <p>$this->addError(["{$display} $str {$display}",$item]);</p> <p>} else</p> <p>$this->addError([$str1,$item]);</p> <p>break;</p> </blockquote>

November 2021

<p>I realized after I added it that I dropped it later in the file, so it won't match your location. Thanks for the rule!</p>