[Guide]How to Create 9.4 Server !

[ThunderNikk]

You need them.

Have you restarted your PC after installation of SQL?

[thefear511]

Originally Posted by ThunderNikk

You need them.

Have you restarted your PC after installation of SQL?

already fixed i replied to him in my video comments.

[frostwolf333]

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

[frostwolf333]

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

[Dark Blaze]

Originally Posted by frostwolf333

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.

[frostwolf333]

another thing how can i get the item that i have id? for example awakening stone acc
OR
location?
any gm command

[frostwolf333]

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

[InkDevil]

1. Search in StringResource for

where value = 'your searched item name'

or

where value LIKE '%part name of your searched item%'

2. Search in ItemResource for

where name_id = code of 1.

[frostwolf333]

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

[Dark Blaze]

Originally Posted by frostwolf333

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

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%'

[ThunderNikk]

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

[Diablo1110]

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.

[ThunderNikk]

Originally Posted by Diablo1110

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?

[Diablo1110]

Originally Posted by ThunderNikk

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).

[ThunderNikk]

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.