[Help Thread] Please post your questions here.

Page 499 of 586 « First 399449489497498 499 500501509549 Last »
04/29/2019 01:48 smoegsmoeg#7471
I'll post it here as well
  • so i can't find the item ID's
    Lycan's Crossbow I know from older arcadias is 3100025 and others but with 9.5.2 some other stuff was added since 9.4 and i can't search for it.

thanks for your support
04/29/2019 02:26 ThunderNikk#7472
There is an English string resource table already in the database.
04/29/2019 15:12 Hatrick_Wildfan#7473
hi , i want to remove a field prop after adding it ..
i found this command
Code:
remove_field_prop()
but i have no idead how it works i ve tried to add a prop
Code:
add_field_prop(2203, 0, 127568,108645, 0, 10, 0, 0, 0, 1, 1, 1)
and then i want to delete it .. thanks
04/30/2019 06:27 Azreil#7474
Quote:
Originally Posted by smoegsmoeg View Post
I'll post it here as well
  • so i can't find the item ID's
    Lycan's Crossbow I know from older arcadias is 3100025 and others but with 9.5.2 some other stuff was added since 9.4 and i can't search for it.

thanks for your support
I have exported the item list from the db to a .txt file...which if you use notepad ++ makes the item numbers somewhat easy to find. The first number is the item number....and if you look at the 3rd word from the end is the description....for example: 705001 is the item number and "item_wakestone" is the description...so..going by that ..705001 is an awaken stone...probably not the easiest way to look these up...but it helps me...maybe it could help others.

Link: [Only registered and activated users can see links. Click Here To Register...]

I tried to add it as an attachment, but it said the file was too large.
05/04/2019 01:40 SilentWisdom#7475
Quote:
Originally Posted by Azreil View Post
I have exported the item list from the db to a .txt file...which if you use notepad ++ makes the item numbers somewhat easy to find. The first number is the item number....and if you look at the 3rd word from the end is the description....for example: 705001 is the item number and "item_wakestone" is the description...so..going by that ..705001 is an awaken stone...probably not the easiest way to look these up...but it helps me...maybe it could help others.

Link: [Only registered and activated users can see links. Click Here To Register...]

I tried to add it as an attachment, but it said the file was too large.
This.

This makes me so happy. To see people making the effort to help.

Makes me also wanna help:

Item Enums

The above enums will be invaluable to you if you want to do mass item selections (during table upgrades like removing dura from items etc) They basically allow you to REALLY FINE TUNE the impact of your WHERE clause.

In the SQL code below I was using it to select all item ids that were dura for a specific group, class, rank and level.

Code:
SELECT i.id, s.[value], i.[class], i.[rank], i.[enhance_id]

FROM dbo.ItemResource i
LEFT JOIN dbo.StringResource s
ON s.code = i.name_id
LEFT JOIN dbo.StringResource t
ON t.code = i.tooltip_id
WHERE i.[group] = 1 and i.[class] = 101 and i.[rank] = 7 and i.[use_min_level] = 160
AND s.value NOT LIKE '%?%' AND s.value NOT LIKE '%<%'
ORDER BY i.id ASC
BUT it can be made as easy as to just select an item by name like:

Code:
SELECT i.id, s.[value]

FROM dbo.ItemResource i
LEFT JOIN dbo.StringResource s
ON s.code = i.name_id
LEFT JOIN dbo.StringResource t
ON t.code = i.tooltip_id
WHERE s.[value] LIKE '%%' -- 1
ORDER BY i.id ASC

/*
-- <> is a placeholder and must be replaced with a real value!!!
1.
- If you know the absolute (must be correct) name of the item change s.[value] LIKE '%%' to s.[value] = ''
- If you want matches where the last word in the s.[value] matches the term change to s.[value] LIKE '% <term>'
- If you want matches where the first word in the s.[value] matches the term change to s.[value] LIKE '<term> %'
*/
Or you could select a range of items like:

Code:
SELECT i.id, s.[value], i.[class], i.[rank], i.[enhance_id]

FROM dbo.ItemResource i
LEFT JOIN dbo.StringResource s
ON s.code = i.name_id
LEFT JOIN dbo.StringResource t
ON t.code = i.tooltip_id
WHERE s.[value] LIKE '% Potion'
ORDER BY i.id ASC
And you can change the output columns to your hearts content, just change up the select statement with the columns you want and viola!

I hope this helps not only the original poster (@smoegsmoeg) but you @[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
05/05/2019 03:35 mlejnek2#7476
Fixed thanks to INK
05/06/2019 06:38 mlejnek2#7477
Looking for a On log in script ... to rebuff players/pets if they wasnt able to be on when say a world boss was killed and they missed the buffs. so need a script to give them the missed buffs to them and pets for same lvl buff and remaining time thats on the current ones so they can still enjoy the rewards that are earned by players....TYVM in advance
05/07/2019 13:49 YuhaBah#7478
Can i take tables with skill dmg formula from client with SilentWisdom or glandu2 tools?
05/08/2019 09:18 Azreil#7479
@[Only registered and activated users can see links. Click Here To Register...] Thank you for the information, this does make searching for items much simpler. If you have the time, may I msg you about a question I have about the files and client?
05/08/2019 19:07 SilentWisdom#7480
@[Only registered and activated users can see links. Click Here To Register...] sure mate, add me on disc #ismokedrow#3102
05/09/2019 07:10 Azreil#7481
Quote:
Originally Posted by SilentWisdom View Post
@[Only registered and activated users can see links. Click Here To Register...] sure mate, add me on disc #ismokedrow#3102


Disc says: that didn't work , check the spelling.
05/13/2019 16:24 swtib9#7482
Hello

I made a 9.5.2 server using this tuto [Only registered and activated users can see links. Click Here To Register...]
Worked fine with local IP
But since i want to play with friend, I tried to use hamachi. I put hamachi IP in gameserver.opt in S:io.ip_adress but when i try to join server it say me "Cannot connect to the login server. 10061

(obvisouly, i also added hamachi IP in launcher.bat

Did i have to put the new IP somewhere else?

EDIT: Tried with another client and it worked .. hum .. Sadly it's not the client i want to use because of the language.
05/13/2019 18:08 ThunderNikk#7483
Make sure the .bat file you use is pointing to the correct auth server port also.
05/13/2019 18:23 swtib9#7484
Yup, port is ok.
What is weird is that it works on my own PC (where the server is hosted) but not on a friend's pc, even if he is on the same hamachi network and with the exact same launcher than me.

With an USB Key, i used the same client and same launcher on both computer.
On mine it works
On friend's one "cannot connect to loggin server 10060"
05/13/2019 19:16 Dark Blaze#7485
Quote:
Originally Posted by swtib9 View Post
Yup, port is ok.
What is weird is that it works on my own PC (where the server is hosted) but not on a friend's pc, even if he is on the same hamachi network and with the exact same launcher than me.

With an USB Key, i used the same client and same launcher on both computer.
On mine it works
On friend's one "cannot connect to loggin server 10060"
Set the GS and auth server IP addresses to the Hamachi IP address and use it for the launcher.
Page 499 of 586 « First 399449489497498 499 500501509549 Last »