Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 22:28

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help Thread] Please post your questions here.

Reply
 
Old   #1486
 
elite*gold: 0
Join Date: Mar 2009
Posts: 150
Received Thanks: 27
gibt es irgendwie eine schnellere metode die skillkarten aus den drops zu nehmen als JEDE einzelne ID/Karte per

USE Arcadia
UPDATE dbo.DropGroupResource
SET
drop_percentage_0x = 0 WHERE drop_item_id_0x = Item_ID

befehl raus zu nehmen ?



Makenci is online now  
Old   #1487
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Makenci View Post
gibt es irgendwie eine schnellere metode die skillkarten aus den drops zu nehmen als JEDE einzelne ID/Karte per

USE Arcadia
UPDATE dbo.DropGroupResource
SET
drop_percentage_0x = 0 WHERE drop_item_id_0x = Item_ID

befehl raus zu nehmen ?
Also spontan würde ich sagen, ja gibt es...die erfordert aber Grundwissen in C# oder einer anderen Programmiersprache in der du ein Programm schreibst.

Andernfalls nein bzw naja zumindest kannst du mit or mehrere IDs miteinander verbinden, so dass du nur ein Statement pro value hast.

UPDATE dbo.DropGroupResource
SET
drop_percentage_0x = 0
WHERE drop_item_id_0x = Item_ID1
or drop_item_id_0x = Item_ID2
or drop_item_id_0x = Item_ID3
or drop_item_id_0x = Item_ID4
to be continued

Dies musst du dann aber trotzdem für drop_percentage_00 bzw. drop_item_id_00 - drop_percentage_09 bzw. drop_percentage_09 machen.

Du würdest dir aber ein paar "UPDATE dbo.DropGroupResource SET" sparen.


c1ph3r is offline  
Old   #1488


 
elite*gold: 30
Join Date: May 2011
Posts: 4,803
Received Thanks: 3,184
Quote:
Originally Posted by c1ph3r View Post
Also spontan würde ich sagen, ja gibt es...die erfordert aber Grundwissen in C# oder einer anderen Programmiersprache in der du ein Programm schreibst.

Andernfalls nein bzw naja zumindest kannst du mit or mehrere IDs miteinander verbinden, so dass du nur ein Statement pro value hast.

UPDATE dbo.DropGroupResource
SET
drop_percentage_0x = 0
WHERE drop_item_id_0x = Item_ID1
or drop_item_id_0x = Item_ID2
or drop_item_id_0x = Item_ID3
or drop_item_id_0x = Item_ID4
to be continued

Dies musst du dann aber trotzdem für drop_percentage_00 bzw. drop_item_id_00 - drop_percentage_09 bzw. drop_percentage_09 machen.

Du würdest dir aber ein paar "UPDATE dbo.DropGroupResource SET" sparen.
Ginge es nicht einfacher, wenn man das über die Dropgroup-ID's löst, wie bei egurgle's Script von damals?
Ich weiß spontan nicht, inwiefern die Meisterklassen-Skillkarten dort gespeichert sind, dürfte aber ähnlich gehen.
Xijezu is offline  
Old   #1489
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Xijezu View Post
Ginge es nicht einfacher, wenn man das über die Dropgroup-ID's löst, wie bei egurgle's Script von damals?
Ich weiß spontan nicht, inwiefern die Meisterklassen-Skillkarten dort gespeichert sind, dürfte aber ähnlich gehen.
Welches meinst du? Das releaste ist für Epic 6.2 das erfordert grundwissen in SQL das zu überarbeiten, dann ist es einfacher das schnell selber zu schreiben. Das greift noch auf die Monsterresource zurück.

Kleiner Ausschnitt

Code:
UPDATE Arcadia.dbo.MonsterResource
set drop_percentage_07 = 1.00,
drop_item_id_07 = -453001,
drop_min_count_07 = 0.7,
drop_max_count_07 = 0.7,
drop_min_level_07 = 0.7,
drop_max_level_07 = 0.7
where (level >= 46 and level <= 75) and not (model like 'beast_bear%' or model like 'beast_ultimatebear' or drop_item_id_07 like '-20%') 
--where drop_item_id_07 = -453001 and (level >= 46 and level <= 75)


c1ph3r is offline  
Old   #1490


 
elite*gold: 30
Join Date: May 2011
Posts: 4,803
Received Thanks: 3,184
Quote:
Originally Posted by c1ph3r View Post
Welches meinst du? Das releaste ist für Epic 6.2 das erfordert grundwissen in SQL das zu überarbeiten, dann ist es einfacher das schnell selber zu schreiben. Das greift noch auf die Monsterresource zurück.

Kleiner Ausschnitt

Code:
UPDATE Arcadia.dbo.MonsterResource
set drop_percentage_07 = 1.00,
drop_item_id_07 = -453001,
drop_min_count_07 = 0.7,
drop_max_count_07 = 0.7,
drop_min_level_07 = 0.7,
drop_max_level_07 = 0.7
where (level >= 46 and level <= 75) and not (model like 'beast_bear%' or model like 'beast_ultimatebear' or drop_item_id_07 like '-20%') 
--where drop_item_id_07 = -453001 and (level >= 46 and level <= 75)
Trotz der Diskussion in Skype nochmal:
-453001, wie es in den Script von dir wäre, beinhaltet Skillkarten. Der Rest des Scripts von egurgle die anderen.
Wenn du jetzt einfach
Code:
UPDATE DropGroupResource SET drop_percentage_0x = 0 WHERE id = -453001
machen würdest, anstatt jede Skillkarte einzelnd, wäre es doch schneller & sinnvoller, oder nicht?
Xijezu is offline  
Old   #1491
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Xijezu View Post
Trotz der Diskussion in Skype nochmal:
-453001, wie es in den Script von dir wäre, beinhaltet Skillkarten. Der Rest des Scripts von egurgle die anderen.
Wenn du jetzt einfach
Code:
UPDATE DropGroupResource SET drop_percentage_0x = 0 WHERE id = -453001
machen würdest, anstatt jede Skillkarte einzelnd, wäre es doch schneller & sinnvoller, oder nicht?
Also 1. -453001 sind Necklaces R3 und 2. ja solange die DropIDs sich net aus irgendwelchen Gründen geändert haben, dann wäre das eine halbwegs gute Lösung. Muss ich dir zugestehen :P
c1ph3r is offline  
Old   #1492


 
elite*gold: 30
Join Date: May 2011
Posts: 4,803
Received Thanks: 3,184
Quote:
Originally Posted by c1ph3r View Post
Also 1. -453001 sind Necklaces R3 und 2. ja solange die DropIDs sich net aus irgendwelchen Gründen geändert haben, dann wäre das eine halbwegs gute Lösung. Muss ich dir zugestehen :P
Ich habe extra eben noch nachgeschaut, ob diese stimmen, hat sich nichts geändert, somit wäre meine Alternative wohl die bessere. ;p
Xijezu is offline  
Old   #1493
 
elite*gold: 0
Join Date: Apr 2013
Posts: 35
Received Thanks: 1
if it would aide in willingness to assist, i do have skype, just pm me if thats a route one of you would be willing to go, im not pc illiterate, just stuck, thanks.
j4ckwr4th is offline  
Old   #1494
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
Quote:
Originally Posted by j4ckwr4th View Post
if it would aide in willingness to assist, i do have skype, just pm me if thats a route one of you would be willing to go, im not pc illiterate, just stuck, thanks.
Double click RappelzCompressV2.exe

Drag the .opt files into the open dialogue box.

They should create a new .eop file in the directories that they are dragged from.

Then after you have dropped them all on the window click OK to close the window.
ThunderNikk is offline  
Thanks
1 User
Old   #1495
 
elite*gold: 0
Join Date: Apr 2013
Posts: 35
Received Thanks: 1
if i could thanks you twice i would...
i know it makes me look absolutely ridiculous, but that was exactly the error... thank you soo much
j4ckwr4th is offline  
Old   #1496
 
elite*gold: 0
Join Date: Mar 2009
Posts: 150
Received Thanks: 27
kann man das den nicht so machen ????

Makenci is online now  
Old   #1497
 
elite*gold: 0
Join Date: Nov 2012
Posts: 12
Received Thanks: 0
[Request] Mephisto ID

Can anyone provide me with the "Mephisto" spawn ID and/or Mephisto pet card ID, I have already the counter part "Lilith's" pet ID, I just cannot find the Mephisto's.


Thanks anyone who can help
NoobieQuestions is offline  
Old   #1498


 
elite*gold: 30
Join Date: May 2011
Posts: 4,803
Received Thanks: 3,184
Quote:
Originally Posted by Makenci View Post
kann man das den nicht so machen ????

Nein, das wäre falscher SQL-Syntax.

Quote:
Originally Posted by NoobieQuestions View Post
Can anyone provide me with the "Mephisto" spawn ID and/or Mephisto pet card ID, I have already the counter part "Lilith's" pet ID, I just cannot find the Mephisto's.


Thanks anyone who can help
I thought they were custom-pets, weren't they? o0
Xijezu is offline  
Old   #1499
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Xijezu View Post
I thought they were custom-pets, weren't they? o0
You're correct! These pets are custom if he found something he is dumping/stealing around in the resource files of a pserver

My opinion: These pets are custom work and shouldn't be used/dumped by another server. Create your own pet! Modelfiles are called:

demon_mephistoLv1.cob
demon_mephistoLv3.cob
demon_lilithLv1.cob
demon_lilithLv2.cob
demon_lilithLv3.cob
c1ph3r is offline  
Old   #1500
 
elite*gold: 0
Join Date: Nov 2012
Posts: 12
Received Thanks: 0
Quote:
Originally Posted by Xijezu View Post


I thought they were custom-pets, weren't they? o0
Custom pets found in korean resource files, with implanted skills, skins, evolves, skill icons, skill descriptions?

After speaking to a forum mod on us rappelz, the Lilith and Mephisto are future updates not creations of pserv devs


(or atleast that is the case with the Lilith)


NoobieQuestions is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 22:28.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.