Deprecated: Item_Search(): Optional parameter $Keyword declared before required parameter $Wears is implicitly treated as a required parameter in /in/DigL7 on line 7
SELECT *
FROM items
WHERE appid=4
AND name LIKE '%shirt%'
AND (wear IN ('red','blue','black') )
SELECT *
FROM items
WHERE appid=13
AND name LIKE '%shoe%'
AND (wear IN ('red','green','blue','yellow','black') OR wear = '')
Deprecated: Optional parameter $Keyword declared before required parameter $Wears is implicitly treated as a required parameter in /in/DigL7 on line 7
SELECT *
FROM items
WHERE appid=4
AND name LIKE '%shirt%'
AND (wear IN ('red','blue','black') )
SELECT *
FROM items
WHERE appid=13
AND name LIKE '%shoe%'
AND (wear IN ('red','green','blue','yellow','black') OR wear = '')
Output for 8.0.0 - 8.0.30
Deprecated: Required parameter $Wears follows optional parameter $Keyword in /in/DigL7 on line 7
SELECT *
FROM items
WHERE appid=4
AND name LIKE '%shirt%'
AND (wear IN ('red','blue','black') )
SELECT *
FROM items
WHERE appid=13
AND name LIKE '%shoe%'
AND (wear IN ('red','green','blue','yellow','black') OR wear = '')
SELECT *
FROM items
WHERE appid=4
AND name LIKE '%shirt%'
AND (wear IN ('red','blue','black') )
SELECT *
FROM items
WHERE appid=13
AND name LIKE '%shoe%'
AND (wear IN ('red','green','blue','yellow','black') OR wear = '')