[Guide]How to Create 9.4 Server !

07/18/2019 12:48 ThunderNikk#376
You need them.

Have you restarted your PC after installation of SQL?
07/18/2019 13:10 thefear511#377
Quote:
Originally Posted by ThunderNikk View Post
You need them.

Have you restarted your PC after installation of SQL?
already fixed i replied to him in my video comments.:handsdown:
07/18/2019 20:00 frostwolf333#378
thank you so much guys for all your help, one last thing is how can i let my friend join my server just me n him not many people
07/23/2019 23:29 frostwolf333#379
so no one knows how to make it available for other to join
all i'm asking is just one or two friends not a whole server
07/24/2019 03:41 Dark Blaze#380
Quote:
Originally Posted by frostwolf333 View Post
so no one knows how to make it available for other to join
all i'm asking is just one or two friends not a whole server
You need to allow incoming connections to the ports of the game server and auth server.
07/25/2019 07:01 frostwolf333#381
another thing how can i get the item that i have id? for example awakening stone acc
OR
location?
any gm command
07/30/2019 03:51 frostwolf333#382
so no one knows how to find an item id
i'm looking for space gear but its not in any gm tool so i acquired them but idk how to get their id number so i can just get them through code
07/30/2019 03:55 InkDevil#383
1. Search in StringResource for
Code:
where value = 'your searched item name'
or
Code:
where value LIKE '%part name of your searched item%'
2. Search in ItemResource for
Code:
where name_id = code of 1.
08/01/2019 06:39 frostwolf333#384
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
08/01/2019 09:25 Dark Blaze#385
Quote:
Originally Posted by frostwolf333 View Post
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
This should work
Code:
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%'
08/01/2019 12:53 ThunderNikk#386
Frostwolf there is an English string resource in the database.

Use that one if it is easier. Just rename the current one to StringResource_old and rename StringResource_EN to StringResource
08/02/2019 01:37 Diablo1110#387
hi guys !!
i need help plz with starting the server , captain herlock gives me the following line before closing

Error in loading lua script files.All functionality of lua is diabled.
08/02/2019 01:54 ThunderNikk#388
Quote:
Originally Posted by Diablo1110 View Post
hi guys !!
i need help plz with starting the server , captain herlock gives me the following line before closing

Error in loading lua script files.All functionality of lua is diabled.
Did you delete the ela line from your gameserver.opt?
08/02/2019 03:18 Diablo1110#389
Quote:
Originally Posted by ThunderNikk View Post
Did you delete the ela line from your gameserver.opt?
ohhhhh! i forgot!
thanks for the help.
now after i deleted it herlock error is gone but there is a new error when i choose the server (cannot connect to server).
[Only registered and activated users can see links. Click Here To Register...]
08/02/2019 04:26 ThunderNikk#390
Wrong auth port in your opt or your .bat or something.

Or some address is not set to local host and still set to someone elses address.