[Help Thread] Please post your questions here.

[dervish7]

Hello please tell me where can I get the IDs of all things and desirable tool for buffs and why I didn't define things from the dungeon

[ThunderNikk]

Originally Posted by dervish7

Hello please tell me where can I get the IDs of all things

The Arcadia.dbo.Item Resource

There are many different ways to get them. SQL queries, GM tools, manual search.

Originally Posted by dervish7

desirable tool for buffs

I wrote all of my buffs into the hidden village buffer by changing the NPCBuff.lua

Perhaps you may want to look into some of the GM tools until you learn a little bit more about working with the server files...

Originally Posted by dervish7

why I didn't define things from the dungeon

Not sure what you mean by this.

[xtremlough]

Originally Posted by dervish7

Hello please tell me where can I get the IDs of all things and desirable tool for buffs and why I didn't define things from the dungeon

Hello dervish7

here you can get a file whit all Id list (warp,item,buffs...)

or you can get the "Zoidberg GM Tool" here :

I hope it will be helpful
Have a nice day

[xtremlough]

Originally Posted by thndr

It would be fully automatic if the player logs out and goes to the web site and selects to change the race of selected character. The the website executes and SQL query, so when the player logs back into that character the race is changed.



Because as Silent Wisdom stated

"Ah then it is not a memory variable saved when the player unloads (disconnects)"

Which means the game server captain herlock does not make this variable persistent until they changed it to make it able to perform race changes.

When you log out there are certain variables that become persistent like last location, creatures summoned, among others but race is not one of them.

Maybe there is an SMP that controls this that you can rewrite. Or maybe you can recode the game server.

Silent was just pointing out the easy way to make it persistent.



Connection open or specified SQL server does not exist.

This error is generally caused by either not configuring the SQL TCP/IP for port 1433.

Or you have done every thing correctly but after setting everything up some of your SQL services are not running.

You can check your services in the SQL configuration manager where you were also supposed to configure the TCP/IP

i think i set the good port maybe at the right of the screenshoot somethings go's wrong

[ThunderNikk]

Originally Posted by xtremlough

i think i set the good port maybe at the right of the screenshoot somethings go's wrong

Yes on the right...

Your SQL server agent service is stopped and your SQL server browser service is stopped.

Right click and select start service.

[TheRainy]

Originally Posted by thndr

Yes on the right...

Your SQL server agent service is stopped and your SQL server browser service is stopped.

Right click and select start service.

That's not really right. You dont have to start SQL Server Agent Service & SQL Server Browser Service to get it working. That one is mine and it works fine:

[smoegsmoeg]

Hey, I've got two questions. I did search but couldn't find an answer.
First: I've seen that there are Pets that can buff you - but i can't find it here ( atm i used server event buffs on server start but those don't apply to pets and if I add cstate to the buffs they wont get applied at serverstart)

Second: My cards seem off - i.e. Unity of Force is +60 with a +10 card - other buff cards are off as well (compared to live server +5 i need +12 on my pserver) where can i look to fix that?

PS:
Third: Any idea why energy of gold is not working (ID: 2013204)

I'm using the 9.1 files from the how to topic
my goal is to get the server as close to the original 9.1

Thank you
cheers

[Sherock]

is it possible to find rappelz 7.4 Ar client here ?

if no ... maybe En ?

[ThunderNikk]

I posted a link to a 7.4 US client here...



I can't get an Arabic one.

[Sherock]

ok thanks

any one have the sframe that support game portal 7.4 Server files ?

[raynexcr]

Never mind guys. I set up a 9.1 server instead of the 5.2. I may re-visit the 5.2 at another time.

[Sherock]

get_os_time()

is it for only the time or date and time ?

and how to convert

[Prentis]

Is there an SQL version free or low priced ok for Rappelz (Without Day Limit)

For exemple would this be ok?.

[ThunderNikk]

I use 2012 developer, I suppose 2014 developer would be the same.

[Sherock]

null