-
Re: [SHARE] Shaiya Server with Video Guide
I already repeated some times. For revealing errors use Query Analyzer
For an example: we find errors in procedure usp_Create_Guild_E
Line for check in Query Analyzer
exec usp_Create_Guild_E 1, ' Zoo ', 1,1, ' Skunk ', 2
Error:
Cannot insert the value NULL into column ' Del ', table ' PS_GameData.dbo. Guilds'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Actions:
Table Guilds (the right key of the mouse)-> Design also we set value at field Del Default 0
The error Is corrected.
I hope to you the way for correction of similar errors is clear
-
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
Twilight
I already repeated some times. For revealing errors use Query Analyzer
For an example: we find errors in procedure usp_Create_Guild_E
Line for check in Query Analyzer
exec usp_Create_Guild_E 1, ' Zoo ', 1,1, ' Skunk ', 2
Error:
Cannot insert the value NULL into column ' Del ', table ' PS_GameData.dbo. Guilds'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Actions:
Table Guilds (the right key of the mouse)-> Design also we set value at field Del Default 0
The error Is corrected.
I hope to you the way for correction of similar errors is clear
Hi Twilight,
I have post sometime in this forum and never get an answer maybe should call it private forum... well I try to ask you directly and hope to get an answer this time, maybe you know where i can find and edit NPC ? i mean for insert new items on merchants
thanks thanks thanks
-
Re: [SHARE] Shaiya Server with Video Guide
All the problems solved.
Thanks Twilight so much.
-
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
Dogo
Hi Twilight,
I have post sometime in this forum and never get an answer maybe should call it private forum... well I try to ask you directly and hope to get an answer this time, maybe you know where i can find and edit NPC ? i mean for insert new items on merchants
thanks thanks thanks
If you haven't been answered either no1 knows the answer, or you have asked an obvious question, either of the two meaning you should try and learn the solution on your own.
Anyway, It's a flat data file in Binary on the Game Server NPCQuest.SData, It is probably necessary to edit NPCQuest.SData on the client as well.
-
Re: [SHARE] Shaiya Server with Video Guide
One more thing,
This server have Guildhouse or not ?
If this server have, how to buy one (I neither see the NPC move to Guild Office in Kello nor Gliter).
Srr for my bad eng.
-
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
LightRitual
One more thing,
This server have Guildhouse or not ?
If this server have, how to buy one (I neither see the NPC move to Guild Office in Kello nor Gliter).
Srr for my bad eng.
You have an opportunity to check up it using the official information.
http://shaiya.aeriagames.com/guide/guildranking
-
Re: [SHARE] Shaiya Server with Video Guide
I read all of them. But there is no NPC Gate Keeper which can be use to move to Guild Office where I can buy Guildhouse.
And also how to start Guild Ranking Battle.
Can you please help me ?
-
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
LightRitual
I read all of them. But there is no NPC Gate Keeper which can be use to move to Guild Office where I can buy Guildhouse.
And also how to start Guild Ranking Battle.
Can you please help me ?
Find NPC - Runa Posilr or /nmake 1 217
and Zerhark Romeo - /nmake 1 218
-
Re: [SHARE] Shaiya Server with Video Guide
Next:
Gate keepers for Office
/nmake 2 36
/nmake 2 40
/nmake 2 44
/nmake 2 36
In client RunUP destinations are not translated into English language and have names of a :????
-
Re: [SHARE] Shaiya Server with Video Guide
Quote:
Originally Posted by
ZeroSignal
If you haven't been answered either no1 knows the answer, or you have asked an obvious question, either of the two meaning you should try and learn the solution on your own.
Anyway, It's a flat data file in Binary on the Game Server NPCQuest.SData, It is probably necessary to edit NPCQuest.SData on the client as well.
Thanks Zero I have noticed NPC merchant was in NPCQuest cuz Reflax PM me that, normally i dont ask if i dont have try alot I have edit all and all work maybe i was tired and brain stuk for sometime.
Can I ask you if you know how to fix portal for new map and make GRG working?
thanks in advance
-
Re: [SHARE] Shaiya Server with Video Guide
Font for chat very small. Edit? Tell me please or give me game.exe. T.T
-
Re: [SHARE] Shaiya Server with Video Guide
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
-
Re: [SHARE] Shaiya Server with Video Guide
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.
-
Re: [SHARE] Shaiya Server with Video Guide
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.
-
Re: [SHARE] Shaiya Server with Video Guide
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
-
Re: [SHARE] Shaiya Server with Video Guide
How can fix error through wall and run on Cave or tomb and ruis you swimming on water ???
-
Re: [SHARE] Shaiya Server with Video Guide
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
-
Re: [SHARE] Shaiya Server with Video Guide
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..
-
Re: [SHARE] Shaiya Server with Video Guide
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
-
Re: [SHARE] Shaiya Server with Video Guide
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/
-
Re: [SHARE] Shaiya Server with Video Guide
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.
-
1 Attachment(s)
Re: [SHARE] Shaiya Server with Video Guide
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
-
Re: [SHARE] Shaiya Server with Video Guide
Wow... thank you very must. Twilight
-
Re: [SHARE] Shaiya Server with Video Guide
-
Re: [SHARE] Shaiya Server with Video Guide
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 -_-
