Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
superpayo
Timmeh, did you find out if hamachi works to conect to server?
Still havent got passed question 1. I think it may be because its not connecting to my SQL database when i install the server says its because "Remote connection defult is set to only take in somet" so i changed it but still not working :\
asoon as i get it up and running with 127.0.0.1 i will try using a hamachi IP and running it all.
Re: [SHARE] Shaiya Server with Video Guide
Re: [SHARE] Shaiya Server with Video Guide
please anyone can tell me where i can find NPC for edit them and insert items on shop? please answer me I never received answer on this forum lol please and thanks
Re: [SHARE] Shaiya Server with Video Guide
http://c.uploadanh.com/upload/0/375/...1245941308.bmp
Can anyone upload the stored procedure 'usp_Insert_Action_Log_E' for me ?
And how to fix Guild store procedure, everytime I restart my server, all Guilds disappear, i check my database and i see that the Guilds Table is empty so i think that my problem is the store Guild procedure.
Srr for my bad eng.
Thanks in advanced.
1 Attachment(s)
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
LightRitual
Can anyone upload the stored procedure 'usp_Insert_Action_Log_E' for me ?
PS_GameLog -> Attach
Re: [SHARE] Shaiya Server with Video Guide
I already repeated some times. For revealing errors use Query Analyzer
For an example: we find errors in procedure usp_Create_Guild_E
Line for check in Query Analyzer
exec usp_Create_Guild_E 1, ' Zoo ', 1,1, ' Skunk ', 2
Error:
Cannot insert the value NULL into column ' Del ', table ' PS_GameData.dbo. Guilds'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Actions:
Table Guilds (the right key of the mouse)-> Design also we set value at field Del Default 0
The error Is corrected.
I hope to you the way for correction of similar errors is clear
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
Twilight
I already repeated some times. For revealing errors use Query Analyzer
For an example: we find errors in procedure usp_Create_Guild_E
Line for check in Query Analyzer
exec usp_Create_Guild_E 1, ' Zoo ', 1,1, ' Skunk ', 2
Error:
Cannot insert the value NULL into column ' Del ', table ' PS_GameData.dbo. Guilds'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Actions:
Table Guilds (the right key of the mouse)-> Design also we set value at field Del Default 0
The error Is corrected.
I hope to you the way for correction of similar errors is clear
Hi Twilight,
I have post sometime in this forum and never get an answer maybe should call it private forum... well I try to ask you directly and hope to get an answer this time, maybe you know where i can find and edit NPC ? i mean for insert new items on merchants
thanks thanks thanks
Re: [SHARE] Shaiya Server with Video Guide
All the problems solved.
Thanks Twilight so much.
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
Dogo
Hi Twilight,
I have post sometime in this forum and never get an answer maybe should call it private forum... well I try to ask you directly and hope to get an answer this time, maybe you know where i can find and edit NPC ? i mean for insert new items on merchants
thanks thanks thanks
If you haven't been answered either no1 knows the answer, or you have asked an obvious question, either of the two meaning you should try and learn the solution on your own.
Anyway, It's a flat data file in Binary on the Game Server NPCQuest.SData, It is probably necessary to edit NPCQuest.SData on the client as well.
Re: [SHARE] Shaiya Server with Video Guide
One more thing,
This server have Guildhouse or not ?
If this server have, how to buy one (I neither see the NPC move to Guild Office in Kello nor Gliter).
Srr for my bad eng.
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
LightRitual
One more thing,
This server have Guildhouse or not ?
If this server have, how to buy one (I neither see the NPC move to Guild Office in Kello nor Gliter).
Srr for my bad eng.
You have an opportunity to check up it using the official information.
http://shaiya.aeriagames.com/guide/guildranking
Re: [SHARE] Shaiya Server with Video Guide
I read all of them. But there is no NPC Gate Keeper which can be use to move to Guild Office where I can buy Guildhouse.
And also how to start Guild Ranking Battle.
Can you please help me ?
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
LightRitual
I read all of them. But there is no NPC Gate Keeper which can be use to move to Guild Office where I can buy Guildhouse.
And also how to start Guild Ranking Battle.
Can you please help me ?
Find NPC - Runa Posilr or /nmake 1 217
and Zerhark Romeo - /nmake 1 218
Re: [SHARE] Shaiya Server with Video Guide
Next:
Gate keepers for Office
/nmake 2 36
/nmake 2 40
/nmake 2 44
/nmake 2 36
In client RunUP destinations are not translated into English language and have names of a :????
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
ZeroSignal
If you haven't been answered either no1 knows the answer, or you have asked an obvious question, either of the two meaning you should try and learn the solution on your own.
Anyway, It's a flat data file in Binary on the Game Server NPCQuest.SData, It is probably necessary to edit NPCQuest.SData on the client as well.
Thanks Zero I have noticed NPC merchant was in NPCQuest cuz Reflax PM me that, normally i dont ask if i dont have try alot I have edit all and all work maybe i was tired and brain stuk for sometime.
Can I ask you if you know how to fix portal for new map and make GRG working?
thanks in advance