[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

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

All the problems solved.
Thanks Twilight so much.

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.

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.

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

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 ?

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

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 :????

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

Font for chat very small. Edit? Tell me please or give me game.exe. T.T

I got a strange problem, if I use a 7 or 15 or 30 day res rune it give me bash buff ( 7 day give me lvl 1 - 15 day lvl 2 and 30 day lvl 3 ) wtf is that? :( also auto healing and untochable pot dont work :( please help

I still have some problems still
I have pictured them to help someone to answer them.

I can take pictures of any folders or documents to help.


Problem 1.

When i install the server everything loads and the first box i get this error.
http://img99.imageshack.us/img99/1166/nodatabase.png

Not sure if this is supost to happen,i have also gone into my SQL server 2005 settings and made sure it lets all Pipes and TCP access.

Im not very good with My SQL until i have the database in there and im fine with editing (Im making it for myself the server to mess around on not to make public)

So if anyone can make a small tutorial on how to add the server to a database please :)


Problem 2. Hopefully if i fix problem one this will fix this problem if not then

when i clikc "Start all server's"

They all start go to green arrow 5-10 seconds later "Session" goes onto | | (Pause) 5 seconds later all the others go to (Pause) heres a screenshot of what happends starting with 1 and ending with 2
http://img514.imageshack.us/img514/440/pause.png


Hopefully somone can help because ive tried none stop to fix these problems.

Thanks.

This is for MSSQL 2000 ProductList for the US Client from Aries Games.

insert into ProductList values('1','Premium package','PK_primm0001','3999','100075','1','100001','1','100002','1','100003','1','100004','1','100043','1','100053','1','100056','1','100049','1','100081','1','100045','1','100046','1','30246','1','30247','1','30248','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('2','Shaiya package','PK_shaiy0001','849','100001','1','100042','1','100057','1','100083','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('3','Remedy Set A package','PK_remed0001','249','100146','1','100149','1','100152','1','100155','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('4','Remedy Set B package','PK_remed0002','249','100158','1','100161','1','100149','1','100155','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('5','Blue Dragon Charm','B1_BdChrm0001','800','100072','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('6','White Tiger Charm','B1_WtChrm0001','1800','100073','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('7','Red Phoenix Charm','B1_RpChrm0001','2800','100074','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('8','Teleportation Stone','B1_Telpstn1005','200','100065','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('9','Lucky Charm','B1_Sftscrl0001','1499','100139','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('10','Termit long mantle','B2_HwgLM4801','2999','39073','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('11','Skay Long mantle','B2_HwgLM5401','2999','39074','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('12','Zubelyou Long Cape','B2_HhaLM4801','2999','39157','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('13','Bestong Long Cape','B2_HhaLM5401','2999','39158','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('14','Phukey Long Cape','B2_HpoLM4801','2999','39243','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('15','Hermit Long Cape','B2_HpoLM5401','2999','39244','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('16','Cape of the Revenge','B2_HfdLM4801','2999','24073','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('17','Cape of the Vengeance','B2_HfdLM5401','2999','24074','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('18','Cape of the Feral','B2_HraLM4801','2999','24157','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('19','Cape of the Savage','B2_HraLM5401','2999','24158','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('20','Cape of the Virtue','B2_HmfLM4801','2999','24243','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('21','Cape of the Sancitude','B2_HmfLM5401','2999','24244','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('22','Small Extraction Hammer','B1_Exthmr1000','349','100140','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('23','Large Extraction Hammer','B1_Exthmr2000','499','100141','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('24','Lucky Charm','B1_Safesc0001','1499','100139','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('25','Etein Potion','B1_etain0001','298','100001','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('26','Normal Item Pocket','B1_SpBox0001','249','100078','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('27','Hard Item Pocket','B1_SpBox0002','299','100079','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('28','Ultimate Item Pocket','B1_SpBox0003','399','100080','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('29','Uber Mystery Box','B1_UbBox0001','299','44186','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('30','Health Remedy','B1_Rehel0001','198','100002','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('31','Stamina Remedy','B1_Restm0001','198','100003','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('32','Mana Remedy','B1_Reman0001','198','100004','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('33','Clean Hit Nostrum','B1_Nosct0001','149','100005','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('34','Defense Nostrum','B1_Nosdf0001','149','100006','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('35','Wizardship Nostrum','B1_Noswz0001','149','100007','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('36','Spirit Nostrum','B1_Nossp0001','98','100008','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('37','Weapon Mastery Nostrum','B1_Noswm0001','98','100009','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('38','Knockout Nostrum','B1_Nosko0001','249','100010','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('39','Sharp Shooter Nostrum ','B1_Nosss0001','198','100011','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('40','Black Art Nostrum ','B1_Nosba0001','198','100012','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('41','Concentration Nostrum ','B1_Nosco0001','198','100013','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('42','Strength RemedyLv1 ','B1_Restr0001','149','100023','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('43','Reaction RemedyLv1','B1_Rerec0001','149','100026','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('44','Dexterity RemedyLv1 ','B1_Redex0001','149','100029','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('45','Lucky RemedyLv1','B1_Reluc0001','149','100032','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('46','Intelligence Remedy Lv1','B1_Reint0001','149','100035','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('47','Wisdom RemedyLv1 ','B1_Rewis0001','149','100038','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('48','Small Increase EXP','B1_exper0007','498','100042','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('49','Resurrection Rune','B1_regem0001','249','100044','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('50','Party Member Summon Rune','B1_Bcall0005','98','100045','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('51','Movement Rune','B1_Sroul0005','98','100046','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('52','Skill Initialization Stone...','B1_setsk0001','998','100047','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('53','Stats Initializing Stone','B1_setst0001','998','100048','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('54','Linking Hammer','B1_inche0005','298','100049','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('55','Small Eternal Endurance','B1_SIndu0007','98','100050','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('56','Prevent of Item Drop','B1_Mdrop0001','98','100112','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('57','Small Prevent of Item Drop...','B1_Sdrop0007','198','100052','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('58','Warehouse Call Rune','B1_bcall0001','198','100054','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('59','Prevent of EXP Drop','B1_Expno0001','98','100110','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('60','Small Prevent of EXP Drop','B1_Expno0002','598','100057','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('61','Repair Hammer','B1_Repai0001','98','100066','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('62','Mysterious Lapis Pocket','B1_Robag0001','298','100068','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('63','Appearance Change Scroll','B1_Cface0001','398','100070','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('64','Sex Change Scroll','B1_Cshap0001','698','100071','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('65','Double Warehouse','B1_Bactw0030','398','100075','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('66','Small Increase Drop Gold','B1_Sgold0001','298','100083','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('67','Clean Hit Nostrum Lv1','B1_Nchit1008','98','100101','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('68','Defense Nostrum Lv1','B1_Ndefc1008','98','100104','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('69','Mini Sun EXP Stone','B1_Misun0001','49','100108','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('70','Small Sun EXP Stone','B1_Sasun0001','198','100109','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('71','Mysterious Charm','B1_Mycha0001','598','100113','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('72','Big Firecracker','B1_Firec0001','25','100115','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('73','Love Firecracker','B1_Firec0002','49','100116','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('74','Jumbo Firecracker','B1_Firec0003','49','100117','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('75','SK Butterfly Firecracker','B1_Firec0004','49','100128','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('76','Huckleberry''s Power Lv1','B1_PowRT0020','49','100118','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('77','Eihcim''s Competence Lv1','B1_PowHR0020','49','100121','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('78','Ventsol''s AbilityLv1','B1_PowAP0020','49','100124','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('79','Continuous Resurrection Ru...','B1_tiregem0003','349','100129','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('80','Capital Movement Stone','B2_Mvcp0010','249','100131','10','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('81','Bootleggery Movement Stone...','B2_Mvbm0010','398','100132','10','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('82','Arena Movement Stone','B2_Mvbg0010','298','100133','10','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('83','Name Change Stone','B1_Charname0001','1998','100136','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('84','49 AP Mystery Box','B1_Mystery0001','49','100142','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('85','249 AP Mystery Box','B1_Mystery0002','249','100143','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');




This is for RunUP Client
insert into ProductList values('1','Dread Sylma Helmet','B2_DrdFhlm1037','49','16023','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('2','Dread Mithril Helmet','B2_DrdFhlm1044','79','16028','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('3','Dread Adamas Helmet','B2_DrdFhlm1051','119','16033','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('4','Dread Ebony Helmet','B2_DrdRhlm1037','49','16108','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('5','Dread Soron Helmet','B2_DrdRhlm1044','79','16113','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('6','Dread Dragon Helmet','B2_DrdRhlm1051','119','16118','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('7','Dread Wilarin Helmet','B2_DrdMhlm1037','49','16193','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('8','Dread Sephiroth Helmet','B2_DrdMhlm1044','79','16198','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('9','Dread Anor Helmet','B2_DrdMhlm1051','119','16203','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('10','Dread Legion Cap','B2_DrdFhlm2037','49','31023','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('11','Dread Mithril Cap','B2_DrdFhlm2044','79','31028','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('12','Dread Adamas Cap','B2_DrdFhlm2051','119','31033','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('13','Dread Ysilom Cap','B2_DrdRhlm2037','49','31108','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('14','Dread Tatoram Cap','B2_DrdRhlm2044','79','31113','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('15','Dread Python Cap','B2_DrdRhlm2051','119','31118','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('16','Dread Serche Cap','B2_DrdMhlm2037','49','31193','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('17','Dread Syron Cap','B2_DrdMhlm2044','79','31198','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('18','Dread Hermit Cap','B2_DrdMhlm2051','119','31203','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('19','EXP Drop Prevention (24hr)...','B1_ExpNdpt0001','35','100110','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('20','EXP Drop Prevention (24hr)...','B1_ExpNdpt0007','219','100110','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('21','EXP Drop Prevention (7day)...','B1_ExpNdst0001','199','100057','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('22','Item Drop Prevention (24hr...','B1_MiniNdb0001','19','100112','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('23','Item Drop Prevention (24hr...','B1_MiniNdb0007','119','100112','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('24','Item Drop Prevention (7day...','B1_SmllNdb0001','99','100052','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('25','Resurrection Rune (3hr)','B1_CntResr0301','29','100129','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('26','Resurrection Rune (6hr)','B1_CntResr0801','49','100130','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('27','Eternal Endurance (24hr)','B1_EtnlEnh0101','19','100111','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('28','Eternal Endurance (7day)','B1_EtnlEnh0201','99','100050','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('29','Capital Movement Stonex10','B1_CptlMov0010','30','100131','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('30','Capital Movement Stonex30','B1_CptlMov0030','70','100131','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('31','Transgender Scroll','B1_TrnsGnd0001','199','100071','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('32','Double Warehouse (30day)','B1_DblWrhs0001','99','100075','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('33','Linking Hammer Pocket','B1_MysChrm0101','9','100113','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('34','Linking Hammer Pocketx10','B1_MysChrm0110','79','100113','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('35','Black Horse Summons Stone','B2_RideHm0101','99','42009','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('36','Red Leopard Summons Stone','B2_RideEf0101','99','42010','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('37','Stone Basilisk Summons Sto...','B2_RideDe0101','99','42011','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('38','Jaguar Summons Stone','B2_RideVe0101','99','42012','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('39','Silverhorn Summons Stone','B2_RideHm0201','149','42013','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('40','Red Lion Summons Stone','B2_RideEf0201','149','42014','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('41','Blue Dragon Summons Stone','B2_RideDe0201','149','42015','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('42','Shadow Wolf Summons Stone','B2_RideVe0201','149','42016','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('43','Rasyo Mantle','B2_StrFDmt0101','199','24001','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('44','Act Mantle','B2_RecFDmt0101','199','24002','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('45','Decd Mantle','B2_DexFDmt0101','199','24005','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('46','Roser Mantle','B2_LucFDmt0101','199','24006','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('47','Rasyo Mantle','B2_StrRAmt0101','199','24086','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('48','Act Mantle','B2_RecRAmt0101','199','24087','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('49','Decd Mantle','B2_DexRAmt0101','199','24090','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('50','Roser Mantle','B2_LucRAmt0101','199','24091','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('51','Act Mantle','B2_RecMFmt0101','199','24172','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('52','Inter Mantle','B2_IntMFmt0101','199','24173','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('53','Adi Mantle','B2_WisMFmt0101','199','24174','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('54','Decd Mantle','B2_DexMFmt0101','199','24175','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('55','Rasyo Mantle','B2_StrWGmt0101','199','39001','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('56','Act Mantle','B2_RecWGmt0101','199','39002','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('57','Decd Mantle','B2_DexWGmt0101','199','39005','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('58','Roser Mantle','B2_LucWGmt0101','199','39006','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('59','Rasyo Mantle','B2_StrAHmt0101','199','39086','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('60','Act Mantle','B2_RecAHmt0101','199','39087','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('61','Decd Mantle','B2_DexAHmt0101','199','39090','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('62','Roser Mantle','B2_LucAHmt0101','199','39091','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('63','Act Mantle','B2_RecPOmt0101','199','39172','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('64','Inter Mantle','B2_IntPOmt0101','199','39173','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('65','Adi Mantle','B2_WisPOmt0101','199','39174','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('66','Decd Mantle','B2_DexPOmt0101','199','39175','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('67','Etein Potion x10','B1_EtnPotn0010','19','100001','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('68','Etein Potion x25','B1_EtnPotn0025','39','100001','25','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('69','Warehouse Rune x5','B1_WarehRun0005','15','100054','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('70','Warehouse Rune x10','B1_WarehRun0010','25','100054','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('71','Status Initializing Stone','B1_StatRst0001','299','100048','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('72','Skill Reset Stone','B1_SkllRst0001','299','100047','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('73','Appearance Changing Scroll...','B1_AprnChg0001','99','100070','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('74','Party Member Summon Rune x...','B1_PartSmn0010','15','100045','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('75','Party Member Summon Rune x...','B1_PartSmn0030','39','100045','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('76','Sun EXP Stone (12hr)','B1_SmlSuns0001','69','100109','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('77','Sun EXP Stone (12hr) x5','B1_SmlSuns0005','299','100109','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('78','Health Remedy XT Lv2','B1_HlthRmd2001','15','100096','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('79','Stamina Remedy XT Lv2','B1_StamRmd2001','12','100093','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('80','Mana Remedy XT Lv2','B1_ManaRmd2001','12','100099','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('81','Sun EXP Stone (1hr) x5','B1_MinSuns0005','39','100108','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('82','Sun EXP Stone (1hr) x10','B1_MinSuns0010','65','100108','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('83','Gold Increment (1hr) x5','B1_MinDrpg0005','19','100114','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('84','Gold Increment (1hr) x10','B1_MinDrpg0010','33','100114','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('85','Normal Item Pocket','B1_Nrmmysb0005','7','100078','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('86','Normal Item Pocket x5','B1_Nrmmysb0010','30','100078','1','100078','1','100078','1','100078','1','100078','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('87','Resurrection Rune x5','B1_ResctRn0005','49','100081','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('88','Resurrection Rune x10','B1_ResctRn0010','89','100081','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('89','Health Remedy (3hr)','B1_HlthRmd0001','19','100002','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('90','Health Remedy XT Lv1','B1_HlthRmd1001','9','100095','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('91','Stamina Remedy (3hr)','B1_StamRmd0001','16','100003','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('92','Stamina Remedy XT Lv1','B1_StamRmd1001','7','100092','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('93','Mana Remedy (3hr)','B1_ManaRmd0001','16','100004','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('94','Mana Remedy XT Lv1','B1_ManaRmd1001','7','100098','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('95','Strength Remedy Lv1 ','B1_StrtRmd1001','9','100023','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('96','Reaction Remedy Lv1','B1_RectRmd1001','9','100026','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('97','Dexterity Remedy Lv1 ','B1_DextRmd1001','9','100029','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('98','Lucky Remedy Lv1','B1_LuckRmd1001','9','100032','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('99','Intelligence Remedy Lv1','B1_IntlRmd1001','9','100035','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('100','Wisdom Remedy Lv1 ','B1_WisdRmd1001','9','100038','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('101','Strength Remedy Lv1 x3','B1_StrtRmd1003','23','100023','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('102','Reaction Remedy Lv1 x3','B1_RectRmd1003','23','100026','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('103','Dexterity Remedy Lv1 x3','B1_DextRmd1003','23','100029','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('104','Lucky Remedy Lv1 x3','B1_LuckRmd1003','23','100032','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('105','Intelligence Remedy Lv1 x3...','B1_IntlRmd1003','23','100035','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('106','Wisdom Remedy Lv1 x3','B1_WisdRmd1003','23','100038','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('107','Ritter Power TR Lv1','B1_LterPow1001','7','100118','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('108','Heliy Competence TR Lv1','B1_HelyCom1001','7','100121','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('109','Ritter Power TR Lv1 x10','B1_LterPow1010','59','100118','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('110','Heliy Competence TR Lv1 x1...','B1_HelyCom1010','59','100121','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('111','Repair Hammer x5','B1_ReprHam0005','39','100066','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('112','Repair Hammer x10','B1_ReprHam0010','69','100066','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('113','Teleportation Stone x5','B1_TeleStn0005','19','100065','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('114','Teleportation Stone x10','B1_TeleStn0010','35','100065','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('115','Chat Altogether x10','B1_ChtAllt0010','13','100064','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into ProductList values('116','Chat Altogether x30','B1_ChtAllt0030','30','100064','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');



Now everyone can stop asking for the queries.

Quote:

---

Originally Posted by Timmmeh

I still have some problems still
I have pictured them to help someone to answer them.

I can take pictures of any folders or documents to help.


Problem 1.

When i install the server everything loads and the first box i get this error.
http://img99.imageshack.us/img99/1166/nodatabase.png

---

Login with sa and execute this query
After start Install again

PHP Code:

---

IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
    EXEC sp_addlogin 'Shaiya', 'Shaiya123', 'PS_GameDefs';
END    
EXEC sp_addsrvrolemember 'Shaiya', 'sysadmin';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
    EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
    EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';

--exec PS_UserData.dbo.usp_Create_ShaiyaAccount 1, 'admin', admin123

/* Add to Game User: admin, Password: admin123 */
IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
    INSERT INTO PS_UserData.dbo.Users_Master
    (UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Point, Enpassword, Birth)
    VALUES (1,'admin', 'admin123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,0,NULL,NULL);
END 


---

How can fix error through wall and run on Cave or tomb and ruis you swimming on water ???

Quote:

---

Originally Posted by Dogo

I got a strange problem, if I use a 7 or 15 or 30 day res rune it give me bash buff ( 7 day give me lvl 1 - 15 day lvl 2 and 30 day lvl 3 ) wtf is that? :( also auto healing and untochable pot dont work :( please help

---

PLEASE can someone tell me why conty res dont work and how fix it?

thanks alot in advance

Quote:

---

Originally Posted by herovn_x36

How can fix error through wall and run on Cave or tomb and ruis you swimming on water ???

---

Files of maps should be identical on the side of the client and a server

Quote:

---

Originally Posted by Dogo

PLEASE can someone tell me why conty res dont work and how fix it?

thanks alot in advance

---

Item.SData = Items table


PS: Office..

I have a problem
1. I create guild success but when i restart my server my guild is lose.

2. I add buddy success buy when i exit game my buddy list is lose.

3. Font for chat very small. Edit? Tell me please or give me game.exe

Thank you very must

Quote:

---

Originally Posted by Twilight

Files of maps should be identical on the side of the client and a server



Item.SData = Items table


PS: Office..

---

hi Twi,
I know Item.SData is items table but i have look on all other server files, on official file and all are same as mine, I cant use any conty res 3H , 6H , and 7 - 15 - 30 day give me bash buff ( the one of war / guard - fighter / def ) and I have edit nothing on those items, also I can use double WH only in 1 char, i mean if i got 5 toon i cant activate it on other and I know in other server its possible.
And again another dam problem on my list of file on server table... didnt touch anything and now is empity
look screenshot here, please help me im getting crazy
http://img265.imageshack.us/i/shaiya0007.jpg/

http://img81.imageshack.us/i/missingfileindatabse.jpg/

Quote:

---

Originally Posted by seryi

Login with sa and execute this query
After start Install again

PHP Code:

---

IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
    EXEC sp_addlogin 'Shaiya', 'Shaiya123', 'PS_GameDefs';
END    
EXEC sp_addsrvrolemember 'Shaiya', 'sysadmin';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
    EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
    EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';

--exec PS_UserData.dbo.usp_Create_ShaiyaAccount 1, 'admin', admin123

/* Add to Game User: admin, Password: admin123 */
IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
    INSERT INTO PS_UserData.dbo.Users_Master
    (UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Point, Enpassword, Birth)
    VALUES (1,'admin', 'admin123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,0,NULL,NULL);
END 


---

---

Thankyou for the help, still having problem though making it connect to the database.
I went into "Microsoft SQL Server Managment Studio Express" because i use SQL server 2005.
I cant connect to sa

I get this error
http://img196.imageshack.us/img196/2638/canot.png



So i connect Via "windows Authecation"
click "New Query" paste in what you posted and "Executed"
and i got these error's

(Thumbnail to keep from spamming images)

http://img43.imageshack.us/img43/3618/sql.th.png

Then i install the server and firstly get this

http://img265.imageshack.us/img265/2126/new1h.th.png

When i click any key i get this.

http://img91.imageshack.us/img91/4505/new2o.th.png


Not sure what im doing wrong to be honest ive worked with all this before just doesnt seem to be easy for me.

Quote:

---

Originally Posted by amorntep

I have a problem
1. I create guild success but when i restart my server my guild is lose.

2. I add buddy success buy when i exit game my buddy list is lose.

3. Font for chat very small. Edit? Tell me please or give me game.exe my ip 203.146.215.54

Thank you very must

---

oh.... :glare:

----------------------

Quote:

---

Originally Posted by Dogo

hi Twi,
I know Item.SData is items table but i have look on all other server files, on official file and all are same as mine, I cant use any conty res 3H , 6H , and 7 - 15 - 30 day give me bash buff ( the one of war / guard - fighter / def ) and I have edit nothing on those items, also I can use double WH only in 1 char, i mean if i got 5 toon i cant activate it on other and I know in other server its possible.
And again another dam problem on my list of file on server table... didnt touch anything and now is empity
look screenshot here, please help me im getting crazy
http://img265.imageshack.us/i/shaiya0007.jpg/

http://img81.imageshack.us/i/missingfileindatabse.jpg/

---

For SQL server - create New SQL server registration (db - ok)

Possibly in your client on ID a item other effect is set

Wow... thank you very must. Twilight

2 Timmmeh:
http://www.sqlserverclub.com/essenti...ick-guide.aspx
For add account use Security In a tree

Quote:

---

Originally Posted by Twilight

oh.... :glare:

----------------------


For SQL server - create New SQL server registration (db - ok)

Possibly in your client on ID a item other effect is set

---

thank you alot Twi database is restored but i still dont know how fix res rune, i have look on items.dbo on server and item.SData on client and got same things i really stuk on it alot -_-

Quote:

---

Originally Posted by amorntep

i have a problem
1. I create guild success but when i restart my server my guild is lose.

2. I add buddy success buy when i exit game my buddy list is lose.

3. Font for chat very small. Edit? Tell me please or give me game.exe

thank you very must

---

:d::d::d::d::d::d::d:

rap up sorry (bad ENG ^^" )

... need minimap Ob Insula
Strange. In Ep 4 client it is not present.
Now my server has 109 maps (or zones)

Shaiya server use port? hacker join my server. how edit?

Quote:

---

Originally Posted by amorntep

Shaiya server use port? hacker join my server. how edit?

---

http://www.nirsoft.net/utils/cports.html
and use firewall or ddos protect tools ...
and disable login sa and default logins shaiya...a1234 and other defaults

Create SQL JOB: procedure checking your bases on breaking and receptions of the administrative rights in game.
and Create SQL JOB: All Backups DB
and more.. more...

Quote:

---

Originally Posted by Twilight

PS: Office..
http://forum.ragezone.com/attachment...1&d=1246098177
http://forum.ragezone.com/attachment...1&d=1246098253

---

How you get all map works ? I see in these pics u got map 56
In the \PSM_Client\Bin\Data\Map
I only got map 1 -> 47.svmap
How did you get 48,49,50,...and so on .svmap
PS: I saw pics of your Ep4 server, what is the client ? that was awesome :scared:
Can you teach me how to fix skill bugs in Ep4 and the strange bug that two players can't see the nicks of each other, see wrong items the other wearing, and no weapons, but when re-equip everything ok except the nicks.
And one more, can we use this tool to edit, import data to data.saf then pack it up.
If we can, how to do it ? i don't understand that language, i tried but it only extract the data.
http://c.uploadanh.com/upload/0/387/...1246147959.bmp
Opps, i think i ask you too much but i hope that you answer me.
I have to learn alot.
Thanks in advanced.
At last, srr for my bad eng.

And one more, can we use this tool to edit, import data to data.saf then pack it up.
If we can, how to do it ? i don't understand that language, i tried but it only extract the data.
http://c.uploadanh.com/upload/0/387/...1246147959.bmp
Opps, i think i ask you too much but i hope that you answer me.
I have to learn alot.
Thanks in advanced.
At last, srr for my bad eng.[/QUOTE]
right click on file you want extract and press (S) and it save file , and for reimport file right click on file you want replace and press (C), it will open a window where you can find and select the file , chose the file and press ok and al is done, close the editor and your data.saf is edited, but remember to do all time with data.sah in same folder

Quote:

---

Originally Posted by LightRitual

How you get all map works ? I see in these pics u got map 56
In the \PSM_Client\Bin\Data\Map
I only got map 1 -> 47.svmap
How did you get 48,49,50,...and so on .svmap
PS: I saw pics of your Ep4 server, what is the client ? that was awesome :scared:
Can you teach me how to fix skill bugs in Ep4 and the strange bug that two players can't see the nicks of each other, see wrong items the other wearing, and no weapons, but when re-equip everything ok except the nicks.
And one more, can we use this tool to edit, import data to data.saf then pack it up.
If we can, how to do it ? i don't understand that language, i tried but it only extract the data.

Opps, i think i ask you too much but i hope that you answer me.
I have to learn alot.
Thanks in advanced.
At last, srr for my bad eng.

---

I have no a lot of time to correct Ep 4. Passive skills and a part of others are corrected only. Ехе ep4 reads out the fifth line in the list of skills. It is necessary to increase amount of inquiry about everyone record on 4 or to finish the table of skills or read store proc. To the decision of problems Ep4 at a forum have not shown interest, therefore I have stopped the further completion.
Maps:
To existing maps I have added missing. Has changed Maps.ini

PS: I Hope who be still is engaged Ep4. I am confident that the server should be copied in the further for reception of new functions, but necessary to try.

And
http://files.filefront.com/SVMAPSrar.../fileinfo.html

Quote:

---

Originally Posted by Twilight

I have no a lot of time to correct Ep 4. Passive skills and a part of others are corrected only. Ехе ep4 reads out the fifth line in the list of skills. It is necessary to increase amount of inquiry about everyone record on 4 or to finish the table of skills or read store proc. To the decision of problems Ep4 at a forum have not shown interest, therefore I have stopped the further completion.
Maps:
To existing maps I have added missing. Has changed Maps.ini

PS: I Hope who be still is engaged Ep4. I am confident that the server should be copied in the further for reception of new functions, but necessary to try.

And
http://files.filefront.com/SVMAPSrar.../fileinfo.html

---

Hi Twi,
Im still have problem with conty res rune , untoch pot , auto healing pot , 7,15,30 day give me bash buff, i have download RunUp client and try with it but its same, I have update skill on server side with last version of USA Shaiya but still same, in every way they dosent work, I know how make some of them work i have look on my first and original items list of server side and voice range is different but my original server item list end with 100 139 ( lucky charm ) missing alot items and so for 3H , 6H conty and auto healing / untoch pot i can edit it with hand ( the range value ) but for 7 , 15 , 30 day I cant cuz i dont know wich range value insert.
Personally i think is a strange prblem because if official USA and RunUp use " range 30 " for those conty res rune it should be work on my server too :( , also I want ask if you know how remove limitation of items like Double Ware House, on my server only 1 char can activate it when in other i have try if i have 5 toon in account i can have 1 double WH in all my toon ( 1 each )
Any idea?
thanks in advance

Twilight ..
You have web php user online and more? :ott:

Quote:

---

Originally Posted by Twilight

And
http://files.filefront.com/SVMAPSrar.../fileinfo.html

---

sps Twilight
and map tool can be used to edit/add monsters/npc's ?
I see that tool show monsters ID, coordinates etc

p.s.
Map 60 (Elimental Cave2) - don't work. Tested with RunUP & US client (map data load error)

Quote:

---

Originally Posted by Dogo

Hi Twi,
Im still have problem with conty res rune , untoch pot , auto healing pot , 7,15,30 day give me bash buff, i have download RunUp client and try with it but its same, I have update skill on server side with last version of USA Shaiya but still same, in every way they dosent work, I know how make some of them work i have look on my first and original items list of server side and voice range is different but my original server item list end with 100 139 ( lucky charm ) missing alot items and so for 3H , 6H conty and auto healing / untoch pot i can edit it with hand ( the range value ) but for 7 , 15 , 30 day I cant cuz i dont know wich range value insert.
Personally i think is a strange prblem because if official USA and RunUp use " range 30 " for those conty res rune it should be work on my server too :( , also I want ask if you know how remove limitation of items like Double Ware House, on my server only 1 char can activate it when in other i have try if i have 5 toon in account i can have 1 double WH in all my toon ( 1 each )
Any idea?
thanks in advance

---

I shall think. If I find the answer - I write here

Quote:

---

Originally Posted by amorntep

Twilight ..
You have web php user online and more?

---

Ок. Attach -> Readme.txt

Quote:

---

Originally Posted by seryi

sps Twilight
and map tool can be used to edit/add monsters/npc's ?
I see that tool show monsters ID, coordinates etc

p.s.
Map 60 (Elimental Cave2) - don't work. Tested with RunUP & US client (map data load error)

---

Yes. Because RunUP clients have no map with an index 60
:D:

yeah... 65-99 won't work too :) 100-108 work

Quote:

---

Originally Posted by seryi

yeah... 65-99 won't work too :) 100-108 work

---

Probably they have other format. Other maps empty and possibly designate only areas on a map.
It is necessary as to put in order coordinates. For this purpose it is necessary geodata editor. At me it while is not present.

anw in logs it shows that have 0 mobs.. also in Map tool there is nothing :)

Quote:

---

Originally Posted by seryi

anw in logs it shows that have 0 mobs.. also in Map tool there is nothing :)

---

Yes some maps cannot have monsters, ex city =) and other ...
for open map 60 see attach...

my character is invisible inthe map, how to fix? tnx

Quote:

---

Originally Posted by nhed57

my character is invisible inthe map, how to fix? tnx

---

you character is GM.. and when you login by default you are invisible and can't be attacked
/char off - visible
/attack off - monsters can attack you

Quote:

---

Originally Posted by nhed57

my character is invisible inthe map, how to fix? tnx

---

oops... Double shot =)

u char - Admin for visible use gm command /char off
Never use a command /adminopen - all players = GM
Use values (16,***48,64,80) Status in table Users_Master.
About this we wrote on the previous pages

btw i try Guild Fix that was posted earlier.. but it doesn't work for me
Friends fix work.. it save in DB.. guilds nope =)

Quote:

---

Originally Posted by seryi

btw i try Guild + friend list Fix that was posted earlier.. but it doesn't work for me

---

stop server...
use Query Analyzer...
select PS_GameData..
open sql file and run..
start server...

All errors in:
PSM_Client\Bin\Log

PS: if errors create guilds.. i change collate
attach

i have problem about LoginStatus.

it LoginStatus=1 everytimes althoung the Character had been logout
Row LoginStatus as tinyint and set default=0
My SP ::

usp_Read_Chars_Detail2_R

Code:

---

CREATE Proc usp_Read_Chars_Detail2_R
@CharID int
AS
SET NOCOUNT ON
DECLARE @UserUID int
DECLARE @Money bigint
DECLARE @GuildID int
DECLARE @GuildLevel tinyint
DECLARE @UID varchar (18)
DECLARE @Event1 tinyint
DECLARE @Event2 tinyint
 
SET @Money = 0
SET @UserUID = (SELECT UserUID FROM Chars WHERE CharID = @CharID)
SET @GuildID = (SELECT GuildID FROM GuildChars WHERE CharID = @CharID AND Del = 0)
IF(@UserUID IS NOT NULL)
BEGIN
 SET @Money = 0
END
ELSE
BEGIN
 SET @Money = 0
END
IF(@GuildID IS NOT NULL)
BEGIN
 SET @GuildLevel = (SELECT GuildLevel FROM GuildChars WHERE CharID = @CharID AND Del = 0)
END
ELSE
BEGIN
 SET @GuildID = 0
 SET @GuildLevel = 0
END
 
SELECT @Event1=Event1, @Event2=Event2 FROM CharEvents WHERE CharID=@CharID
SELECT UserUID, CharID, CharName, Slot, Family, Grow, Hair, Face, [Size], Job, Sex, [Level],
StatPoint AS DistPoint, SkillPoint, [Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, PosZ, Hg, Vg, Cg, Og, Ig, Del,K1, K2, K3, K4,@Money AS StoredMoney, @GuildID AS GuildID, @GuildLevel AS GuildLevel,
KillLevel,
DeadLevel,
@Event1, @Event2,
DATEPART(yyyy, LeaveDate) AS LeaveDate_YYYY,
DATEPART(mm, LeaveDate) AS LeaveDate_MM,
DATEPART(dd, LeaveDate) AS LeaveDate_DD,
DATEPART(hh, LeaveDate) AS LeaveDate_HH,
DATEPART(mi, LeaveDate) AS LeaveDate_MI,
DATEPART(ss, LeaveDate) AS LeaveDate_SS
FROM Chars WHERE CharID = @CharID
UPDATE Chars SET JoinDate=GETDATE(), LoginStatus = 1 WHERE CharID=@CharID
SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID
UPDATE CHARS SET LoginStatus = 0  WHERE (CharID<>@CharID) AND (UserID=@UID)
SET NOCOUNT OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

---

And

usp_Save_Char_LeaveDate_R

Code:

---

drop procedure [dbo].[usp_Save_Char_LeaveDate_R];
CREATE Proc usp_Save_Char_LeaveDate_R
@CharID int
AS
DECLARE @UID varchar (18)
SET NOCOUNT ON
SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID
UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE UserID=@UID
SET NOCOUNT OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

---

Script PHP

PHP Code:

---

<?
$myServer = "IPadd";
$myUser = "dbuser";
$myPass = "dbpw";
$myDB = "PS_GameData";
$conn=mssql_connect($myServer,$myUser,$myPass);
if (!$conn){exit("Connection Failed: " . $conn);}
$selected = mssql_select_db($myDB, $conn) or die("Couldn't open database $myDB");
$resultx0=mssql_query("SELECT COUNT(LoginStatus) AS Online FROM CHARS WHERE (LoginStatus = 1)") or die;
$row0 = mssql_fetch_array($resultx0);
//text format
//echo "Humans:" . $row0[0];
//echo "<br>Elves:" . $row1[0];
//echo "<br>Vail:" . $row2[0];
//echo "<br>Nordein:" . $row3[0];
//echo "<br>Total:" . $row4[0];
//table format
echo '<body leftmargin=0 topmargin=0><TABLE width=100 height=40 border=0 cellspacing=0 bordercolor=#FFFF00 align=center';
echo '<body leftmargin=0 topmargin=0><table width="100" height="40" border="0" cellspacing="0" bordercolor="#dfe1db" align="center" >';
echo '<TR><TD colspan=1 height=5 bgcolor=#99CCFF align=center><font size=2 color=000000 face=Tahoma>User Online: ' . $row0[0] . '</font></TD></TR>';
echo '</TABLE></body>';
?>

---

How to solve thsi problem ?:/:

Quote:

---

Originally Posted by plemaster

i have problem about LoginStatus.

it LoginStatus=1 everytimes althoung the Character had been logout
:/:

---

Need change(enter) new(other) Character or exit from game

PS:
PHP - Bless script I did not add in archive, but I think it very simply and you can create.
My test script:

I've got a little problem.I've bought some plain gear from NPC and I can't equip it.It says: "Status isn't enough" so i cant equip that item.What do i have to do?

How to add or edit portal in a map ? If the portal isn't working ? Can we make it work ? And how ?
I think the problem in svmap file, but when i edit svmap using svmap editor i only see NPC and Mobs coordinates.
What options i need to put in Maps.ini file to make a map become Guild Ranking Battle map, cuz when i add that map in Maps.ini as same as others, everyone can enter it at anytime and when killing mobs it return no guild points ?? Also how to start Guild Ranking Battle event and how to end it. The same problems in Guild Office map, everyone can enter it and they no need to have a guild.
My Guild Warehouse have problems, when someone put items in it, the item display in the warehouse but not store in the database. Cuz of that those items disappear after relog. I check logs but there was no error ???
And one more, my guild have enough etin and guild points to upgrade guild NPCs, but when the leader of the Guild trying to upgrade, system says "failed to upgrade". Why ? And how to solve it ?
I'm asking to much today, but these were really big problems, if anyone can help me i will appreciate that very much.
Thanks in advanced.

Quote:

---

Originally Posted by Twilight

stop server...
use Query Analyzer...
select PS_GameData..
open sql file and run..
start server...

All errors in:
PSM_Client\Bin\Log

PS: if errors create guilds.. i change collate
attach

---

yeah thx I find error but it was not table... it was procedures... I chnage 3-4 and now it work.. but last with Update_GuildPointRank.. I set TotalRank to accept NULL.. now it work fine.. need to test and create another guild :)

btw all guild errors was in procedures
Cannot insert the value NULL into column.....

Does this server work with No-IP ?
If it work, list of Ports need to forward ?

Quote:

---

Originally Posted by lightritual

does this server work with no-ip ?
If it work, list of ports need to forward ?

---

1433 - for sql
game ports
30800
30810
30900
30901
30911
30912
40900

solved the "Status isnt enough" error, now i got another problem:
I just died with an UM char without res rune and i wonder how can i restore it.I opened dbo.CHARS and changed the UMreset value from False to True, but it wont reset the car.What do i have to do?

Quote:

---

Originally Posted by seryi

1433 - for sql
game ports
30800
30810
30900
30901
30911
30912
40900

---

I forwarded all the ports and change all 127.0.0.1 in my Server Manager to my No-IP
ex: example.myvnc.com
Then I reopen Server Manager, all are red X.
What's the problem ?
Or can you more details in how to make a server with No-IP
Thanks

Quote:

---

Originally Posted by Bunicul

solved the "Status isnt enough" error, now i got another problem:
I just died with an UM char without res rune and i wonder how can i restore it.I opened dbo.CHARS and changed the UMreset value from False to True, but it wont reset the car.What do i have to do?

---

in CHARS set Del to 0


LightRitual sry but I don't think you can use no-ip
you always can use Hamachi btw

Server is up and running - No dc's, no crashes = 100 % stable. What bugs me though is that i can not find a list of GM commands and explinations. I found a list of commands but as is : JUST commands (no examples or "how to use command stuff"). GM commands like for example /amove, /bmove explained OR /asummon OR /eventstart or something explained.

Furthermore the warehouse ; I can only use one grid, meaning the other possible 2 are unusable (cannot put anything inside). All that i know so far is that dwarehouse for exaple is stored in "CharApplySkills" skill "234" and sets it to "24 hours" for that CharUID.

What i am getting at is that either it has a incorrect value set SOMEwhere to "1" (one warehouse grid - which should be 3 by default) or to "0" , if we take that the warehouse starts counting at "0" OR a procedure sets it to "1" or "0" by default for all chars. As i said, the only thing that works for this is enalbling "dwarehouse" on that "CharUID" : Then only can you use the other warehouse grids 2,3,4,5 and 6.

:blushing:

any have a register page? how to make the account not a GM? or a character not a GM? without issuing a /char off or /attack off??

Quote:

---

Originally Posted by nhed57

any have a register page? how to make the account not a GM? or a character not a GM? without issuing a /char off or /attack off??

---

in PS_UserData -> Users_Master change Admin = False, AdminLevel=0 and all characters in that account will not be GM's

I'll post later reg page.

Quote:

---

Originally Posted by cyberion1985

Server is up and running - No dc's, no crashes = 100 % stable. What bugs me though is that i can not find a list of GM commands and explinations. I found a list of commands but as is : JUST commands (no examples or "how to use command stuff"). GM commands like for example /amove, /bmove explained OR /asummon OR /eventstart or something explained.
:blushing:

---

also commands I'll post later with some usage... I don't find usage for all.. but anw ;)

TY seryi, now i have an other problem.I don't know how to create a new NPC, i know just how to spawn a NPC that already exists.But the prob is i want to create a brand new NPC, a merchant for example, and i also want to know how to add items to that merchant.

what do you mean by STATUS and USERTYPE in Users_Master?

Can anyone unpack this game.exe for me, here is the link
http://www.mediafire.com/?f1vjhh2vwdq
I tried to unpack it with many version of strippers but always return some error which make the file corrupt.
Please help me.

Quote:

---

Originally Posted by Bunicul

TY seryi, now i have an other problem.I don't know how to create a new NPC, i know just how to spawn a NPC that already exists.But the prob is i want to create a brand new NPC, a merchant for example, and i also want to know how to add items to that merchant.

---

For create new NPC still dont know yet my server crash and i need restar all for look, for insert items on NPC just find where other items ID are ( use HEX editor and open NpcQuest.data ) and on free slot ( 00 00 ) add ID of new items you want in

[QUOTE=Dogo;5114095]For create new NPC still dont know yet my server crash and i need restar all for look, for insert items on NPC just find where other items ID are ( use HEX editor and open NpcQuest.data ) and on free slot ( 00 00 ) add ID of new items you want in[/QUOTE


Okay so I opened NpcQuest.Sdata and added the item id i wanted.Now what i am supposed to do?I guess i have to "insert" the new NpcQuest.Sdata file to data.saf and data.sah or one of them.
I'm still nub but need a bit of help.

Edit font in game.exe. How? :lol::lol:

Quote:

---

Originally Posted by LightRitual

Can anyone unpack this game.exe for me.

---

http://rapidshare.com/files/250348964/_game.rar.html

hi,
All fine... just can't hold green play botton on any, after a bit they go to pause mode... Plus when I try and load the game, it says "checking server, please check notice board.", any solutions?

Mr.Twilight Please help me again. Unpack this game.exe for me. And change ip 192.168.0.1
Thank you very much. :laugh:

http://rapidshare.com/files/250781141/shaiya.rar.html

Better explaination of the /set command

Example
/set Mike str 9999

Its /set Charname the stat you want to increase then the number you want your stat to be.


Now how to fix the bootlegery? All npc's on that map are in mid air . What the correct positions?

Quote:

---

Originally Posted by amorntep

Mr.Twilight Please help me again. Unpack this game.exe for me. And change ip 192.168.0.1
Thank you very much. :laugh:

http://rapidshare.com/files/250781141/shaiya.rar.html

---

nPack v1.1.800.2008 ~ [ v2.0.100 ] by NEOx (03.03.2008)
(country: TH)61.19.255.39 -> 192.168.0.1

http://rapidshare.com/files/250948673/Shaiya.rar.html

http://rapidshare.com/files/250948673/Shaiya.rar.html

Twilight this file have Trojan TR/Crypt.XPACK.Gen. Plaese post again

Quote:

---

Originally Posted by amorntep

http://rapidshare.com/files/250948673/Shaiya.rar.html

Twilight this file have Trojan TR/Crypt.XPACK.Gen. Plaese post again

---

Your initial file suspicious signatures, therefore some antiviruses the packer nPack already contains recognize as a virus
http://www.virustotal.com

Nod32 And KAV viruses it is not detected.

[QUOTE=Bunicul;5114381]

Quote:

---

Originally Posted by Dogo

For create new NPC still dont know yet my server crash and i need restar all for look, for insert items on NPC just find where other items ID are ( use HEX editor and open NpcQuest.data ) and on free slot ( 00 00 ) add ID of new items you want in[/QUOTE


Okay so I opened NpcQuest.Sdata and added the item id i wanted.Now what i am supposed to do?I guess i have to "insert" the new NpcQuest.Sdata file to data.saf and data.sah or one of them.
I'm still nub but need a bit of help.

---

ok if you have added in right position without messing up anything you must insert NpcQuest.data on your data.saf and also copy/paste it on server folder for make it effective
PSM_Client\Bin\Data
PSM_Server\ShaiyaServerPatch\Server\GameMain\PS_Game\Data

( keep always a original version of file also note where you paste it so when you need redo you can remember the way ;) )

Twi can you explain me how to import file on server? I mean I have exported a items table.dbo on my comp and converted it to .xls for faster editing, now i will reimport on server and overwrite the original one but all time i fail and got an error ( file still not changed ) , I use MSQL 2005 Enterprise Edition.
Also I have couple of question, sorry if i spam but i wont messed up server again with tons of tentative:
How ban an account?
How make GRB working?
How fix ware house? ( 2 things on this point, 1 is WH can be use only 1 page, if i activate a double WH I can activate it only in one toon and i will it on both of my toon )
thanks alot and sorry for alot questions

[QUOTE=Dogo;5115368]

Quote:

---

Originally Posted by Bunicul

ok if you have added in right position without messing up anything you must insert NpcQuest.data on your data.saf and also copy/paste it on server folder for make it effective
PSM_Client\Bin\Data
PSM_Server\ShaiyaServerPatch\Server\GameMain\PS_Game\Data

( keep always a original version of file also note where you paste it so when you need redo you can remember the way ;) )

---

The question is HOW do i "insert" NpcQuest.data on data.saf? The only tool i have "extracts" data.saf , but does not import.
Edit:I guess data.saf doesnt matter, the only thing that matter is NpcQuest.Sdata from the server folder, i'll check that asap.

Give me some information about this shaiya ps development via PM, a.s.a.p..

[QUOTE=Bunicul;5115492]

Quote:

---

Originally Posted by Dogo

The question is HOW do i "insert" NpcQuest.data on data.saf? The only tool i have "extracts" data.saf , but does not import.
Edit:I guess data.saf doesnt matter, the only thing that matter is NpcQuest.Sdata from the server folder, i'll check that asap.

---

sorry but your wrong :) data.saf matter alot , if you have a editor for extract file from data.saf it can be import too, so :
Edit your NpcQuest.data
Open Editor for data.saf ( always do in same folder of data.sah )
go in NPC folder
select NpcQuest.data
right click on it and press ( c )
it will open a window ( like a browse ) find your edited NpcQuest.data and double click
press ok
close editor
and your client is updated :)

[QUOTE=Dogo;5115522]

Quote:

---

Originally Posted by Bunicul

sorry but your wrong :) data.saf matter alot , if you have a editor for extract file from data.saf it can be import too, so :
Edit your NpcQuest.data
Open Editor for data.saf ( always do in same folder of data.sah )
go in NPC folder
select NpcQuest.data
right click on it and press ( c )
it will open a window ( like a browse ) find your edited NpcQuest.data and double click
press ok
close editor
and your client is updated :)

---

actually the tool i have is ZeroSignal's shaiya data extractor , which i use to extract the data from data.sah and data.saf. Can u tell me what editor you have and possibily zip it and upload it?
Edit:Never mind, i found phprap's tool, even though its in chinese lol.Ignore me for being such a lazy nub.
Edit2: I don't know where to add the item's id to the merchant using a hex editor and im still trying to figure out.Can you make a SS to show me where I must insert the item id? tyvm

Quote:

---

Originally Posted by Dogo

Twi can you explain me how to import file on server? I mean I have exported a items table.dbo on my comp and converted it to .xls for faster editing, now i will reimport on server and overwrite the original one but all time i fail and got an error ( file still not changed ) , I use MSQL 2005 Enterprise Edition.

---

try MS SQL Maestro

Quote:

---

Originally Posted by Twilight

try MS SQL Maestro

---

I have exported edited some value and reimporte Items table ( export to xls file reimport from xls file ) size changed alot ( 2,5 MB more ) and server wont start anymore, any suggestion for restore only this single table or how edit without risk everytime to reinstal all and lose all chnages? please help me Twi im getting mad is 3

[QUOTE=Bunicul;5115589]

Quote:

---

Originally Posted by Dogo

actually the tool i have is ZeroSignal's shaiya data extractor , which i use to extract the data from data.sah and data.saf. Can u tell me what editor you have and possibily zip it and upload it?
Edit:Never mind, i found phprap's tool, even though its in chinese lol.Ignore me for being such a lazy nub.
Edit2: I don't know where to add the item's id to the merchant using a hex editor and im still trying to figure out.Can you make a SS to show me where I must insert the item id? tyvm

---

yes I use that tool too
I post here one SS hope it will help you

[img=http://img39.imageshack.us/img39/7519/additemstonpc.th.jpg]

[QUOTE=Dogo;5116092]

Quote:

---

Originally Posted by Bunicul

yes I use that tool too
I post here one SS hope it will help you

[img=http://img39.imageshack.us/img39/7519/additemstonpc.th.jpg]

---

Thx dude that helped A LOT . I found an decimal to hexadecimal converter so i converted the item id numbers to hexa ones.Now im importing the npcquest.sdata file to see if it actually works. Ty again.

[quote=Dogo;5116066]I have exported edited some value and reimporte Items table ( export to xls file reimport from xls file ) size changed alot ( 2,5 MB more ) and server wont start anymore, any suggestion for restore only this single table or how edit without risk everytime to reinstal all and lose all chnages? please help me Twi im getting mad is 3

Quote:

---

Originally Posted by Twilight

Create new base for experiments. Create in it the duplicate of table Items. Use Maestro for imp/exp
screen - http://img.pixs.ru/images/Maestrojpg_4882529_257060.jpg
Maestro - http://www.filecrop.com/ems-ms-sql.html

---

is there anyway Twi for make and use back up of file of server? I have made one but fail to import when i have reinstalled server ( i have redo editing 1 by 1 with hand :( ) , for maestro i must wait my friend for make it running im really nub on set up SQL etc etc I can work not bad on HEX but server things is not my force

Quote:

---

Originally Posted by ZeroSignal

http://www.***********.de/forum/shaiya/

Has the Shaiya[US] Ep4 NoGG Mutliclient.

With your tools excellent work but since it's in a different language it's very difficult to use. If you make language strings part saved in Project Properties >> Settings, we can change the language strings via a config file.

---

Hi Zero, im using this EP4 NoGG Multi , all work, i can log in game, UI not bugged etc etc but i got terrible delay, i mean with this game.exe if i press attack on a mob i see game blocked for like 5/6 second and after restar ( mobs already died ) also when i open window of NPC, everything got huge delay, how i can fix that?
thanks

new shaiya section in mmorpg files :)

http://forum.ragezone.com/f557/