You need them.
Have you restarted your PC after installation of SQL?
Have you restarted your PC after installation of SQL?
where value = 'your searched item name'
where value LIKE '%part name of your searched item%'
where name_id = code of 1.
This should workQuote:
how do u search
i right click
then choose script table as
select to
new query editor window
then add that line of code at the end right?
edit:
i already used
where upper(name) like upper('name_item%')
but now i have to search for all names and all values are in arabic n when i try to search in arabic it returns empty tables
USE [Arcadia] SELECT ir.id, sr.[value] FROM dbo.ItemResource AS ir JOIN dbo.StringResource AS sr ON ir.name_id = sr.code WHERE sr.[value] LIKE '%item name here%'
ohhhhh! i forgot!Quote:
Did you delete the ela line from your gameserver.opt?