ÇáãÓÇÚÏ ÇáÔÎÕí ÇáÑÞãí

ãÔÇåÏÉ ÇáäÓÎÉ ßÇãáÉ : ßÑÇÇÔ


eslamsaied
15-12-2017, 05:04 PM
ÇÓÊÎÏãÊ ÈÑäÇãÌ ÇáNPC æÖíÝÊ ÇíÊãÒ Ýí ÇáNPC æáãÇ ÌíÊ ÇÝÊÍ ÌÇÈáí ßÑÇÔ ããßä Íá
ÏÇ ãáÝ ÇáÏãÈ
MDMP“§±a ’Ó3Z  Ô H  H (   qj  ¨ *  8 €  è ¸ 
  ±  p!  GenuineIntelz ÿûë¿%šfuè ÷ T mÓ3Z  ^ ^ ^   0 r  ˆÿÿÿE g y p t S t a n d a r d T i m e    ; ; ç E g y p t D a y l i g h t T i m e     ; ; çÄÿÿÿh  À s%˜  ?   2 ÿÿ Vï–  \ Dê Ì Ê3  h ðý Ô ô+ …m Ì –6  àý Ôþd , y™ Ì b9 Ø Ðý ÿ�  ¥š Ì .< À Àý Ðý 0 ¥› Ì ú> t *ý ðý'  Õ� Ì ÆA <  °ý ý ä åŸ Ì ’D L �ý œý7 d É¢ Ì ^G ° €ý $þé Ü -¥ Ì *J l `ý $þù Ü § Ì öL   Pý èü   å¨ Ì ÂO L  @ý ¼þ D ý« Ì ŽR Ü 0ý Èþï 8 A* Ì ZU à àú Ìþ_
4 y® Ì &X ì  Ðú Üþw
$ *¯ Ì òZ Œ Àú *þ‡
` Ѱ Ì ¾] C @ ðÖ ¶1N’! E Š` )w À Ù� n¹çL&" ½ïþ    jD±  jD±?    " Ï` úv @
ëp
ï¸çLf" ½ïþ    jD±  jD±?    % ñ` fu * L˜ ð¸çL¬" ½ïþ    jD±  jD±?    ' a Øv à Ø“
¸çLö" ½ïþ    jD±  jD±?    " =a ív � ˯ /Û[J6# ½ïþ    @°  @°?    # _a Iw * ¯“ Ú[Jx# ½ïþ    @°  @°?    ‚a ?w Ð Ú*
)ºçL´# ½ïþ  r jD±r jD±?    " ¢a Vv À
Hä
oÚ[Jô# ½ïþ   @°  @¾!?    # Äa …v
I
·çL6$ ½ïþ    jD±  jD±?    % ça Jw � 2S Û[J|$ ½ïþ    @°  @°?    $ b Ív 
|T
¢¹çLÀ$ ½ïþ    jD±  jD±?    # 0b gv ð Bz E¸çL% ½ïþ    jD±  jD±?    " Sb w À ¸ iÚ[JB% ½ïþ    @°  @°?    " ub ˆu *Ä Ü1Å Þ¹çL‚% ½ïþ    jD±  jD±?    $ —b w p XÛ â¹çLÆ% ½ïþ    jD±  jD±?    $ »b Ýv P …� ?ºçL
& ½ïþ   jD±  jD±?    $ ßb mv ` à #ºçLN& ½ïþ   jD±  jD±?    # c �v À 7J o¹çL�& ½ïþ    jD±  jD±?    " &c Mv ð –B r¹çLÐ& ½ïþ    jD±  jD±?    % Hc Iu Ð ´? A¸çL' ½ïþ    jD±  jD±?    $ mc Eu À å} ɸçLZ' ½ïþ    jD±  jD±?    # ‘c ¥v ° ø_ K¸çLœ' ½ïþ   jD±  jD±?    % ´c �v P
ö hºçLâ' ½ïþ    jD±  jD±?    # Ùc =w ` äO ÙÚ[J$( ½ïþ    @°  @°?     üc Žt � Á8 +Û[J`( ½ïþ    @°  @°?    $ d [ p Ú4 ¸Ù[J¤( ½ïþ    @°  @°?    " @d ¤a ` 0ã ´Ù[Jä( ½ïþ    @°  @°?    % bd nu Ð l… Ù¹çL*) ½ïþ    jD±  jD±?    % ‡d Fu p <¬ ‡·çLp) ½ïþ    jD±  jD±?    % ¬d [u  ‡í ÅÙ[J¶) ½ïþ    @°  @°?    # Ñd Þs 0 oë Ú[Jø) ½ïþ    @°  @°?    # ôd cs À SV Y¸çL:* ½ïþ    jD±  jD±?    % e as p dj CÛ[J€* ½ïþ    @°  @°?    # <e 9q  2T BºçLÂ* ½ïþ    jD±  jD±?    " _e P 0 ¾õ ³·çL+ ½ïþ    jD±  jD±?    ! �e ×n ` c– ¨Ù[J@+ ½ïþ    @°  @°?    $ ¢e ¦Y  Y‰ ýÙ[J„+ ½ïþ    @°  @°?    # Æe Øs P ñm Û[JÆ+ ½ïþ    @°  @°?    % ée 1u À ! >·çL , ½ïþ    jD±  jD±?    $ f `W €! ¤! ÿ¶çLP, ½ïþ    jD±  jD±?    % 2f -u ° Lû $ºçL–, ½ïþ    jD±  jD±?    $ Wf t  ‹¥ 8Û[JÚ, ½ïþ    @°  @°?    $ {f ¶s ð `è *¹çL- ½ïþ    jD±  jD±?    # Ÿf Øn @ £Þ NÚ[J`- ½ïþ    @°  @°?     $ Âf ‘e 0 œ Û[J¤- ½ïþ    @°  @°?    æf �e Ð  Û[Jà- ½ïþ    @°  @°?    # g ¤t p ‹¿ (ºçL". ½ïþ    jD±  jD±?    $ )g >u ° û& A¿[Jf. ½ïþ    @°  @°?    $ Mg Òq  ] 6Ú[Jª. ½ïþ    @°  @°?    qg   ¼Ü ¸ëÝDæ. ½ïþ      ?    ` ‘g 6u À “E A¿[J‚/ ½ïþ    @°  @°?    & ñg w 0 ŒU ±Ù[JÊ/ ½ïþ  Ñ@R!  @°?    $ h às � »ß ’¸çL0 ½ïþ    jD±  jD±?    % ;h "t P £ ƒ¹çLT0 ½ïþ   jD±  jD±?    $ `h Ún ` Í %·çL˜0 ½ïþ    jD±  jD±?    % „h éY Àu <«t ìÚ[JÞ0 ½ïþ    ‘!   ‘! ?      ` ©h åt À øF è¸çL"1 ½ïþ    jD±  jD±?    $ i —t P DŠ ZÛ[Jf1 ½ïþ    @°  @°?    % -i ~s  u8 ¹çL¬1 ½ïþ    jD±  jD±?    # Ri �p  Íî mÚ[Jî1 ½ïþ    @°  @°?    $ ui ‹p  y öÚ[J22 ½ïþ    @°  @°?    $ ™i Ñt @ e æ·çLv2 ½ïþ    jD±  jD±?    # ½i Šp € ¬Y DÛ[J¸2 ½ïþ    @°  @°?    # ài Ds € 8 2¸çLú2 ½ïþ    jD±  jD±?    % j Ôq ` û ÖÚ[J@3 ½ïþ    @°  @°?    % (j Óo ° ª°
¼·çL†3 ½ïþ    jD±  jD±?    $ Mj  S e r v i c e P a c k 1 Ž E : \ V s r o . 1 8 8 - F u l l C l i e n t # R i 3 o \ V s r o . 1 8 8 - F u l l C l i e n t # R i 3 o \ s r o _ c l i e n t . e x e : C : \ W i n d o w s \ S y s t e m 3 2 \ n t d l l . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ k e r n e l 3 2 . d l l D C : \ W i n d o w s \ S y s t e m 3 2 \ K E R N E L B A S E . d l l : C : \ W i n d o w s \ S y s t e m 3 2 \ g d i 3 2 . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ u s e r 3 2 . d l l 6 C : \ W i n d o w s \ S y s t e m 3 2 \ l p k . d l l : C : \ W i n d o w s \ S y s t e m 3 2 \ u s p 1 0 . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ m s v c r t . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ a d v a p i 3 2 . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ s e c h o s t . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ r p c r t 4 . d l l : C : \ W i n d o w s \ S y s t e m 3 2 \ i m m 3 2 . d l l : C : \ W i n d o w s \ S y s t e m 3 2 \ m s c t f . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ s h e l l 3 2 . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ s h l w a p i . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ w i n i n e t . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ u r l m o n . d l l : C : \ W i n d o w s \ S y s t e m 3 2 \ o l e 3 2 . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ o l e a u t 3 2 . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ c r y p t 3 2 . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ m s a s n 1 . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ i e r t u t i l . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ w s 2 _ 3 2 . d l l 6 C : \ W i n d o w s \ S y s t e m 3 2 \ n s i . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ v e r s i o n . d l l : C : \ W i n d o w s \ S y s t e m 3 2 \ d d r a w . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ d c i m a n 3 2 . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ s e t u p a p i . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ c f g m g r 3 2 . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ d e v o b j . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ d w m a p i . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ I P H L P A P I . D L L < C : \ W i n d o w s \ S y s t e m 3 2 \ w i n n s i . d l l : C : \ W i n d o w s \ S y s t e m 3 2 \ w i n m m . d l l 8 C : \ W i n d o w s \ S y s t e m 3 2 \ d 3 d 9 . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ d 3 d 8 t h k . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ d s o u n d . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ p o w r p r o f . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ a p p h e l p . d l l @ C : \ W i n d o w s \ A p p P a t c h \ A c G e n r a l . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ s s p i c l i . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ u x t h e m e . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ s a m c l i . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ m s a c m 3 2 . d l l 6 C : \ W i n d o w s \ S y s t e m 3 2 \ s f c . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ s f c _ o s . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ u s e r e n v . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ p r o f a p i . d l l 6 C : \ W i n d o w s \ S y s t e m 3 2 \ m p r . d l l – E : \ V s r o . 1 8 8 - F u l l C l i e n t # R i 3 o \ V s r o . 1 8 8 - F u l l C l i e n t # R i 3 o \ G F X F i l e M a n a g e r . d l l B C : \ W i n d o w s \ S y s t e m 3 2 \ C R Y P T B A S E . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ c l b c a t q . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ M M D e v A P I . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ p r o p s y s . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ A u d i o S e s . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ n v d 3 d u m . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ m s w s o c k . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ W S H T C P I P . D L L < C : \ W i n d o w s \ S y s t e m 3 2 \ n l a a p i . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ N a p i N S P . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ p n r p n s p . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ d n s a p i . d l l < C : \ W i n d o w s \ S y s t e m 3 2 \ w i n r n r . d l l @ C : \ W i n d o w s \ S y s t e m 3 2 \ F W P U C L N T . D L L @ C : \ W i n d o w s \ S y s t e m 3 2 \ r a s a d h l p . d l l > C : \ W i n d o w s \ S y s t e m 3 2 \ d b g h e l p . d l l ?   2 ÿÿ Vï–  \Dê # �‚Wÿƒ„Zÿÿÿ| } R ÿ ÿÿ 4âÍû? «ªªþ? ½À €ý? €�@ ; # # ð×e ì \ã#  (ù s%˜   ê #  2 \Vï–  Dê # * ÿÿ �‚Wÿƒ„Zÿÿÿ | } R ÿ ÿÿ 4âÍû? «ªªþ? ½À €ý? €�@ € `Àð2
À àe 1|€ 0€  ?   2 ÿÿ …cZ \ Ù # ê÷4Wi ÿÿ ÿÿ ÿÿ ÿÿ ½ÀiìËÌŽ}Òÿÿ <¿¼@ €ÿ? ; # # P× h
<¨
<h
<<Ô ˜ Ô ´p-w F Ô #  2 \ …cZ Ù # * ÿÿ ê÷4Wi ÿÿ ÿÿ ÿÿ  ÿÿ ½À iìËÌŽ}Òÿÿ <¿¼@ €ÿ? ?   ÿÿ ; # # ô Àº¸ Dÿd´p-w F Øþd#  € ?   ÿÿ ; # # Hÿ� ð
ƒ lÿ�´p-w  ÿ�#  € ?   ÿÿ ; # # @ �ÿ· 3<ÿv@þ´p-w F Ôý#  € ?   ÿÿ ; # # 0¼. �þ+wý+w 8ÿ'ˆÿ'´p-w “ ôý'#  € ?   ÿÿ ; # #  pýt( ˆr- ¼ý´p-w F ý#  € ÿÿ ?   ÿÿ ; # #  ðý7Zú+ <ì7À <þ7´p-w F *ý7#  € ÿÿ 5 & 0 & 0 2 0 1 # { 6 9 9 4 a d 0 4 - 9 3 e f - 1 1 d 0 - a 3 c c - 0 0 a 0 c 9 2 2 3 1 9 6 } \ e m i x e d c a ?   ÿÿ ; # # w-   ( ( b. ˆÿé´p-w  (þé#  € ?   ÿÿ ; # # w-  w- ç,wˆÿù´p-w  (þù#  € ?   ÿÿ ; # # \ý  <ý   Sˆ ‘ˆý ´p-w F ìü #  € ÿÿ ?   ÿÿ ; # # p °n» ,ÿ´p-w F Àþ#  € ÿÿ ?    ÿÿ VIZ \Àöï# €ÿ? €ÿ? €ÿ? È@ ; # # ˆ À8ÿþÿÿ 18ÿï´p-w F Ìþï#   \VIZ Àöï# * ÿÿ €ÿ? €ÿ? €ÿ? È@ a‚‚! A‚¢a¢‚‚à ¢¢Ã )ã à 㠢A A‚¢¢ã D1e9) ?   ÿÿ ; # # ì�¸R ´p-w ý_
üþ_
´p-w F Ðþ_
#  € ÿÿ ?   ÿÿ ; # # à£9qˆÿw
´p-w F àþw
#  € ÿÿ ?   ÿÿ ; # # (},}ÿÿÿÿ _# ñ Ðþ‡
´p-w F ¤þ‡
#  € ÿÿ TÿZDÿZ4ÿZ$ÿZÿZÿZôþZäþZÔþZÄþZ´þZ¤þZ”þ Z„þZtþZdþZTþZDþZ4þZ$þZþZþZôýZäýZÔýZ ÄýZ´ýZ¤ýZ”ýZ„ýZtýZdýZ RSDS85Ð�ÉF¼!°]‰´  D:\vss-od\Silkroad\Client\Out\SRO_Client.pdb RSDSú( ?EÕL¦¤ì79jX ntdll.pdb RSDS9¬Ô�Ô{HŸiù2j} j kernel32.pdb RSDSÒ% õP‚ˆA·0cÖS·Ò~ kernelbase.pdb RSDSQŽ”–‡:ÅGŠi›Šp ܲ gdi32.pdb RSDSëÖÑÁT“SF‰‘*i|Ë-P user32.pdb RSDSþ“¹'D�AžµC+ŸjA lpk.pdb RSDS↗ôÅÇ©Nž|7 Úëœ usp10.pdb RSDSg’Çn SE�*�jÕ�»ù msvcrt.pdb RSDSŸ2? U°Bœñ¡ûŠ—é advapi32.pdb RSDSMñzÔÖL”'Eþcr± sechost.pdb RSDSnÅœJ-ÚCŠ&ž‡!ñ= rpcrt4.pdb RSDSD *‘ât¨JŸP)ãD‰ imm32.pdb RSDSø®=%kÛH¦N·LM/# msctf.pdb RSDSû¥UEúIN¶Z%alÙzk shell32.pdb RSDSα(áëâŒC†Fæ–qó> shlwapi.pdb RSDS’ÊÓÖiiÿA¾íw?Sûâô wininet.pdb RSDS7U¾¥ÑðfL–�¨rå urlmon.pdb RSDSñaPWš5C•ê^§ZoK ole32.pdb RSDS1ò+1jç
E¿~¿µ/¢ oleaut32.pdb RSDS4'=mêvF€—õ,6Ï� crypt32.pdb RSDS_= €$ K•:zRü2 msasn1.pdb RSDS ûÛŒ
h¯B*V]¡¹Ä iertutil.pdb RSDS¹`É@XOL€ö†î—Š3Ô ws2_32.pdb RSDSg�ZÑ®ŸsJ’4KoÒhg” nsi.pdb RSDS\N#RÄ~FF¶-V5{,”‡ version.pdb RSDSï¾}I…³$O¼jF�7†
Ú ddraw.pdb RSDS³ÄÀñœ$ªJŠQ0Ô5³e dciman32.pdb RSDS8Ì·ÆÍÂBžÛau}ý’ setupapi.pdb RSDS¨*±“/CG¯š«±¡s‚F cfgmgr32.pdb RSDSÆÄ^P\ëE–ôÏÜün devobj.pdb RSDS?ÙØš3ÜO–Çmô dwmapi.pdb RSDSáÒbñí7—B‹óŒ™®âÚ« iphlpapi.pdb RSDS[Â*÷¦O‡d”Óö¿Ñ winnsi.pdb RSDSü˜ýzÓªkO‹1¤f|N+ü winmm.pdb RSDSPëZõ+F?G—3Q]ÆS-¯ d3d9.pdb RSDS5£ÃÙ_aŽD*°×gæ· d3d8thk.pdb RSDS€G�óâeÆGŽÚi–õní dsound.pdb RSDSlöø±*ËiHºßÒ $¬ƒ powrprof.pdb RSDSܾBôöÀÓF„
)‰ŒX™Ë apphelp.pdb RSDSŠj*+)ø×J‹í))·™Ðþ AcGenral.pdb RSDS¹£Z¼×c¯M¾ Åy])\D sspicli.pdb RSDS5«ì[qç5H¦¿=*Ø‘»: UxTheme.pdb RSDSŽ
8vþ\ F�`EíEÉ� samcli.pdb RSDS^�1=Å8E¶Exðq
Q msacm32.pdb RSDS'¬Ð4“F•^¤héï· sfc.pdb RSDS¢�à“çÕ4I¬û©šVý sfc_os.pdb RSDSõGýøuÊOª`qËÌJ¸ userenv.pdb RSDS©\ÊÇå‰M›�çv³Š³ profapi.pdb RSDS=t"B%@¤ž§œç
 mpr.pdb RSDSÌËu|JD¥yÄɲ* g:\VSS-OD\JMX_Library\GFX\Out\Release\GFXFileManager\GFXF ileManager.pdb RSDSåê/æîYÙL•aB°Â cryptbase.pdb RSDSÇ § ¬›"@•¶ëÜrW CLBCatQ.pdb RSDS¦E”�>}E�Î)ÌPŒ4¹ MMDevAPI.pdb RSDS¥íÐ=åyE£7øu-{H propsys.pdb RSDS‘Ï�¨I”¨I¡†=’»/Ñ AudioSes.pdb RSDSÄ×]éÉD¤,VswÍ. d:\bld\win7_ITB_r185_85\drivers\ddraw\_out\win7_x8 6_release\nvd3dum.pdb RSDSm¼]¨M9Iºør]`Õ•¦ mswsock.pdb RSDSò/©’W“HK—•‰…að wshtcpip.pdb RSDSÄT˜L׉J—²MpúÉœó nlaapi.pdb RSDSDûÑ5k<L„‚å[(J NapiNSP.pdb RSDS½&ÐÛMD’ÓÎ�iñ pnrpnsp.pdb RSDSgîyTµâèL§(cõ|ÉZ dnsapi.pdb RSDS{¹øE…×Hˆ(œXèųÊ winrnr.pdb RSDS¥U}ë56ÙJ‡Î.6‘J¯7 fwpuclnt.pdb RSDS}œÑo(Mºà]—Wè/ rasadhlp.pdb RSDSaòkCîõJ–#Ñyå§× dbghelp.pdb  ó$˜  …k 4p-w  …l Ô ô+ …m Ôþd , y™ ÿ�  ¥š Ðý 0 ¥› ðý'  Õ� ý ä åŸ œý7 d É¢ $þé Ü -¥ $þù Ü § èü   å¨ ¼þ D ý« Èþï 8 A* Ìþ_
4 y® Üþw
$ *¯ *þ‡
` Ѱ
í 3ĉD$`SUVW¡0
í 3ÄP�D$xd£ ‹¬$Œ ‹´$ˆ 3Û‹ù‰l$ÇD$p ‰\$lf‰\$\jS‹Î‰œ$ˆ è6§! Sj‰GU�D$dP‹Îè#°! �L$XQ¹ßî èCúÿ‹Èè=äÿÿ‹PSjU�D$dP‹Î‰W è÷¯! �L$XQ¹ßî è<üÿ;Ãu"‹D$pƒør�T ‹D$\RPè,¨ÿƒÄ3Àén ‹Hj‰OS‹Î貦! jS‹ÎˆGè5¨! jS‹Î‰G‰W蕦! jS‹Î‰G ì‰$ÇD$ ‰\$ÇD$ Tèv  �I U‹ìƒìP‰D$ d¡ ‹€¤ ‰$ÇD$ ÇD$ ÇD$ Tè9 ‹$‹å]Ëÿ‰D$‰\$éÇ �¤$ �d$ ‹Ô4Ã�¤$ �d$ �T$Í.Ã�U‹ì�¤$0ýÿÿTèS ‹U‹Eƒ„$Ä ‰P Ç$  ‹ÌjQÿuè›ñÿÿPè Ì�U‹ì�¤$àüÿÿTè ƒ„$Ä �Œ$Ð ‹EÇ$  ‰A ƒa �i (0) t z r e s . È*) ˜Õ 8)0)     îî ?¸÷ ôÓ Ö íà*w«~Ë þÿÿÿ–/w¦”/wÉ()\Ô 1 $ XÖ DÖ •/wþÿÿÿ6ö.wDú.w É()    º ë3   º   E ÜÔ ¸ ºÖ ö/wë¹÷w Hº6ö.w6ö.wë¹÷wÈ() É()É() *r6wpÕ M‘/w*r6w6ö.wǹ÷wÉ() È() ¸ €)) @Õ È()àÕ íà*w›pË þÿÿÿ6ö.wDú.w È()€))  ðÕ {/w€))È()Ý/wK¹÷wÉ()U �i d l È() €))È*) ¨Õ pÖ íà*w£}Ë þÿÿÿÝ/wŒ/w �2 8)`Ö U ( ð‰. €Ö Lå  47 þÿÿÿŠŠþv3Šþv�€.  è‰. \Ö è,.w”Ù p0 p0 ¤Ö Íë/w s6w»ë/wº÷w”Ù  º ºp0  ºlÖ ´Ö Lå íà*w#}Ë þÿÿÿ»ë/w7ë/w ºÄi-w*ˆfuÿÿÿÿ º”Ù  ºøÚ üØ uñgu º <Ù ‚ñgu  ¬Ù U C : \ W i n d o w s \ s y s t e m 3 2 \ t z r e s . d l l = Ö Lå ÔT-w2kfu” ” d× H æ9 hc+ ( he+ lÜ lÜ  lØ 9 9 §i.wpc+ Ó].w×´÷w<Ù lÜ œ
<P( ,Ø Ø P( |(  <P( @ €Ö/ ( @ 9 `™/ Àªè€§èäØ  è£- B BDf/wdØ €  Ò Ó°*.  @Ø
(  pc+ pc+ kc+  ˜ÆT T ÐT Lå íà*w - XÙ  T˜ÆTXÙ ¤].wÓ].wãµ÷w ¤T TPT Ù ˜e+ )T <Ù - e+ PTíà*w˜6”Ù 1  *ògu6d+ øÚ 1 0Ä T´ ± ¤Ú ÿ pc+ � „HÒT   *ÆT*ÆT›ÆT *Ú TˆÿÿˆØ z r Lå íà*wyË þÿÿÿÓ].wàZ.w šÆT˜ÆT  Ö-.w   tj-w„ufu ÌÙ dÚ è tj-wtj-w„ufu ôÙ ˆÚ  ¤ufuò*. lÜ ô+ …m lÜ  ÜÙ „ufuLå eáguNk[þÿÿÿ¤ufuNÿv ˆÚ  TÚ LÚ oº×oc-w%šfuÿÿÿÿ Ô hæô hÚ |Ú Æ×oÿÿÿÿ Ô hæô ”Ú ô+ lÜ œÚ ‹Æ×oÿÿÿÿ Ô hæô+ °Ú ÄÚ M×oÿÿÿÿ Ô hæô+ lÜ
<œÛ PÛ ÆN×o…m œÛ H æ Ô ô+  ô+ œÛ lÜ H æhæ  Àªè�§èèæPÛ êU×o…m œÛ H æ4q-w   œÛ  –6 — pÛ PY×o…m <H æ 0 < Ý `\×olÜ œÛ H æX < 8Ý   ` € 8  ¸ * ¨ H Ô L 0   ( H ( p! p! p! qj  ¥j …k ¬F y™ p! Z ’! Ê3 §6 b9 qj 1² p! ÿÿÿÿT è<0 <Ð<H < L ðH×o    1 ±   Ì œ P    ÿ  X <hÝ *^×oÿÿÿÿT è< Ð<H <H æ8Ý  ðÝ h ç (ç hÝ *ÏþvH <0 <è<Ð< M#ƒ ÿÿÿÿT   ÄÝ Ž'.!ƒ ŒgwÜå æ æ  á    4  h æ             ç/.wE:\Vsro.188-Full Client #Ri3o\Vsro.188-Full Client #Ri3o\Dump\2N[2017-12-15 15-52-16]_51_22 _.dmp ÷°  @Þ Dé íà*wsË þÿÿÿç/.w‚..w@ Ö-.w  äç/.wdz÷w œŒ Œ  > óª  ; óª ç/.w³÷wX ÌŒ èH ` 8ýŒ@ @ ç/.wW³÷w œŒ Œþÿÿÿç/.w ÿÿóª Ö-.wx àá÷ > óª 4ß X íà*w þÿÿÿ èH ` PýŒ@ ,à hß ,à 8ê íà*wsË þÿÿÿç/.w‚..w Ö-.w [0Œ_0ŒX ŒÄb-wràfu Tà }´  ’àfu’—.ðà E:\Vsro.188-Full Client #Ri3o\Vsro.188-Full Client #Ri3o\Dump\ ient.exe T—þvN—.Y9 Ìž•*Œ8ê �à ÿÿÿÿ8ê â—wªàóXþÿÿÿ€ Y9 á ÑT  á Ê€ Ôâ ˜á  ¤ŒظÔâ Øâ K \â *ŒØKøÌv  \â € ìá÷2w € ÌDù¤’iY_Kb·¼^"FöÈL§l�³y!á¥êlf_
9¾¢ðj/_
9¾¢ðj/_
9¾¢ðj/_
9¾¢ðj/_
9¾¢ðj/_
9¾¢ðj/_
9¾¢ðj/ùxÞ29k…¼"—cÉŒv°/Í�1Œ @7¥(‡±_
9¾¢ðj/ÌÓ;.á \â `Ó;.9ü *Œèû LK '0ŒØKø¨€§_Ìkΰ ˆ
Œ äR_RANK_GOLD  ´£    refscrapofpackageitem.txt ‘SLüªuÓ‘SLüªuÓ¼Þ8 ÌA œn# cŒ    ü# \K                            $ßî |3ù                                         db-w»Žfuÿÿÿÿ!ƒ $å  å å äŽfuÿÿÿÿdb-wB>ÿvÿÿÿÿ!ƒ  Äb,  !ƒ Œgw ƒ @ € àT  !ƒ Œgw6Ž'.Ìå ÁEÒ ÿÿÿÿ-îÿv æ .’. æ        ç     Øå S÷´   `å $ 8æ â—w™òXþÿÿÿÔÿ 0w æ ã*w Ôÿ x.w æ Œá*w ç (ç ˆ.w SpË Dæ ¹q-wþÿÿÿÄÿ (ç àæ „ê Íq-wÄÿ ôæ ‹q-w ç Äÿ (ç àæ íà*w ç Äÿ où*w ç Äÿ (ç àæ íà*wð×e ç ì ÿÿÿÿ çFÿHçLç ÚFÿv¼æ '( çFÿvàç ¨|, r  P àè (ù p-w ç (ç ç (ç  À s%˜  ?   2 ÿÿ Vï–  \Dê # �‚Wÿƒ„Zÿÿÿ| } R ÿ ÿÿ 4âÍû? «ªªþ? ½À €ý? €�@ ; # # ð×e ì \ã#  (ù s%˜   ê #  2 \Vï–  Dê # * ÿÿ �‚Wÿƒ„Zÿÿÿ | } R ÿ ÿÿ 4âÍû? «ªªþ? ½À €ý? €�@ € `Àð2
À àe 1|€ 0€  4ýÿÿä 4ýÿÿÌ  †¹'.ßî ì èû ð×e  (ù ˜ ˆ@%èû d—` ° 1 ¨ +3´ # d$C K A G E  " ¶¹'.Üû 8gÓ ÀC• ì (ù 6¹'. €Îî o(îv *Á
_jinßî ^
ð×e8ü r- ÌA  ¬%Á
$ë Àõ þÿÿÿé*Œÿÿÿÿ Ø;.Z âî € K  ´éÄ Џ'.ðnŒn ,ŽÙ
Ä  ˜)Õ ˆâî mŒåî DçÁ
Ò¸'. Ȱèû dâî ô,  Äë Lâî Ô?$Äë  dâî ô,¢9ìë pâî ü* º ì+Ý  ÿÿÿÿÀÙ;.&Ø*  &¸'.  ^
ÿÿÿÿ ICADE_07"
0xffff0010 0x00000000 71 61 0x448639a9"  ¸3 å   dbe7TØ ¶2 $  RUC REÅ HT_  r004 0x0LC
71 6œX`äX`äX`  518 0x4469cddf 0x40a
f "S € _POS_HT_BARRICADE_09"
0xffff001aâî ÜÞ000 70 61 0x433504e0 0x414275dd tåî ”ç# HŠEtåî ”ç# dâî ô,^_ èÉ×
+ ðKWZ 0¨×
pâî ü*Œåî î# pâî ü*€åî ìí# c058 0x4€åî ÄåÁ
`_ ×e€åî ìí# 90fdb "S€åî $æÁ
_POS_HT_BARRICADE_11"
0xffff0002 0x00000000 69 62 0x4484* �’�141cc53 0x44695c48 0x00000000 "SÍ 8—D_POS_HT_$ãî Üä# E_12"
0x¡Ž @:E 0x00000Œàî á# 2 0x4497 û141c7d3 0x4468ce12 0x00000000 "STRUCTURE_POS_HT_BARRICADE_13"
0xffff000dâî Ìâ# 000 70 63 0x430873c0 0x4141c8d8 Ðê ¬%Á
1e 0x3fc90fdb "STRUCTURE_POS_HT_BARRICAD ø�º
ffff0003ç ¥000 71 6 E7480 0x4&ƒ ¸�T0x423823€ H¿I90fdb "STRUCTURE_POS_HT_ˆâî m�© *Upâî ¤ã# Œ ]HN à©`3 0x44851194 0x4134720b 0x448cf46c 0x00000000 "STRUCTURE `»â
BARRICADE_16"
0x$ãî ô� 0x00000Œàî 3 0x448e62ee 0x4300fcfd 0x44751332 0x00000000 "S$ Ø}û_POS_HT_^
P0Uˆ H2H PŸHí XÁDdâî ô,3 0x44974d9f 0x4134734b Lâî Ô?$56 0x00000000 "STRUCTURE_POS_HT_BARRç/.wsœ÷w œŒ Œ 0x00000 D ¹¨ 4 0x44cd5b44 0x4 A ¹¨ ç/.w¿�÷wX ÌŒ b "S èH ` hýŒ@ E_19ç/.wƒ�÷w œŒ Œþÿÿÿç/.w ÿÿ¹¨ Ö-.wx ˜á÷ D ¹¨ €ð x3fcX íà*w þÿÿÿ èH ` €ýŒ@ ffff´ð 0x0„û íà*wsË þÿÿÿç/.w‚..w Ö-.w [0Œ_0ŒX ŒÄb-wràfu *ñ �Ä  ’àfu&†.<ò  *Œ ò   ˆñ øñ eágu~—k[þÿÿÿ’àfuO—þv �Ä  <ò T—þvú….E* ¤X¤*Œ„û Üñ ÿÿÿÿ„û â—wªàóXþÿÿÿ€ E* lò ÑT lò ²Ì€ ô äò  ¤Œظ ô $ô ; ¨ó *Œ¸aø  ¨ó €  HŠEÚiŸŒ°õü 6ÎèÙ�7aÿ3hR¼1³y!á¥êlf_
9¾¢ðj/_
9¾¢ðj/_
9¾¢ðj/_
9¾¢ðj/_
9¾¢ðj/_
9¾¢ðj/_
9¾¢ðj//†…{×Ѻ¨ƒP*™)á�(h° *SØ¡3¯¸×”œ_
9¾¢ðj/¸À;.á ¨ó ,À;.9ü *Œ L; '0Œ¸aøNSIVE_04"
0xˆ
Œ001e 0x00000000 71 60 0x44a587b4 0x44ø ðó ö ƒ1· ö ðó {/· ˜1Q8# S î*'.ô Ž‹µ 5 b44ø n”µ 5 b4  àÞ  ^
 0 0xworldmap_instanceinfo.txt ü�.8
Ëü�.8
˲àÏ  eb8e5a 0x00000000 "STRUCTURE_POS_HT_DEFENSIVE_09"
0xffff0008 0x00000000 70 6Œàî 092 0x42a1f1b5 0x44eb5bd8 0x00000000 "SPäî ÌBC
POS_HT_DEFENSIVE_10"
0xffff0018 0x00000000 71 61 0x44974774 0x42a1f1a7 0x44Èàî ç
00000000 "STRUC,áî HT_DEFENSIVE_11Ôàî   017 0x00000000 ààî 4¼485€åî $æÁ
1c1ìàî üñcac7b 0x0000000xáî µURE_POS_HT_DEFEãî ,Ñ
0xèåî �Œ0x0Ôáî ¬Þ1 64 0x44971468âî ÜÞ88 0x43dcfd2e 0x00000000 "STRUCTURE_POS_HT_DEFENSIVE_16"
0xffff0025 0x00105000 70 64 0xdâî ô,0x4399e7c7 0x43ˆâî m00000000 "S% <ãî üÿl”âî ”rE_0 ‡ T÷ pâî ü*fT÷ ¤].wÓ].w|âî t# # P# 3c66Lâî ä‰# 000ð°=DçÁ
‡ @âî ?% H D"
0x¬ 0011€ 0000000 ç/.wß›÷w  èsÞ
� Ž66e " ˜ ÿ x409j¸ Ò€ãû b   øføfóf # ˜€U„ö 8�»
Xø íà*wyË þÿÿÿÓ].wàZ.w  ( # 8�»
Ö-.w" ˜ b Ìn# Ôø3"
8}»
 0�»
°÷ è,.w8�»
È÷ Hðfuz  De '( "û
ü÷ xfu '( $ãî ´˜ ¨}ûG:— /0ãî <Ô}û,ø ¨}û >— $/¨}û ò«'. ¨}û ±=YY q } ‰ • 0 2 3 i o  r l d m a  ¨}û¨}ûÝJ— *ø /Ðø ¨ÛL¨}ûAU— lù S÷´   xÞµ ù ˜1Q8#   ébµ t cµ  8ü iµ 5� ÿ  èù  ˜1Q8# Ð#  D9Ý
H D6 ˆû ü  Œ?gÿÿÿÿ 2   B*ß 2 0 <ú íà*w  C O S _ C _ P E G A S U S _ 1 0 5 0 5 0 5 ©  $ 'å k„Þ
ÐO ust #  @±= Ȱ=íà*wyË HiÞ
•Þ
àZ.w /.wÇ–÷w@ ÌŒ ŒT  l )<J-¿
D¦ m 2<J-¿ X pãû@ GC/w ˆïïH x  ° œ# øù =G Œ˜á÷þÿÿÿç/.wl 2<K-¿ Ö-.w H ö �á÷¸ú è,.w˜á÷À×÷û/Œ�á÷Ìú ä»þv Œ ˜á÷ û öè Œ éÜÉ;.À×÷÷/Œû/Œ@ àú Œ<þ Àõ�2->þÿÿÿ騥 ˜á÷˜á÷*Œû/ŒØá÷˜á÷^» Lû û/Œ˜á÷; *Œ » û/ŒÀ×÷; ð Œ Œúª'.¨û ôA´ ˆû 9Ý üû  8ü nü É 8ü B gàá÷tÉ;.ÿÿÿÿÐû ßB´ ‡_µ 8ü  6 üû €Îî o(îvßî :¹'.ßî <þ bBÓ  …V„ *Œ8ü ) ’¯'.dÛhdÛhœþ Œvfuª‹. €Œü <þ $T-wzSwü server_dep\silkroad\textdata\refscrapofpackageitem .txt ata.txt •/ À, Ø,  Œü ù- àü è,.wù-  ù- (ý vvfu ( ŒvfuΊ. ù-  À‰ w#\'.ôü ù- <þ Z;wW\'. (þ  ý ¾ð wxý ›1"wˆý õ9w Z;wºÜÍ«G\'.¨ý ïów$þ BÀ  ¼ý Ä:w $þ BÀ Øþ $þ lþ ˜/ ˆý Ôý ï†îvh BÀ BÀ Í«ºÜ $þ BÀ äý þ ¡5.Lþ Ɉîv�ˆîvõ_'.àþ Øþ È·p$  p ÿÿÿÿÿÿÿÿˆîvɈîv¾*'.,Ïî ðý †¯'.Œþ ÉWÒ ÿÿÿÿFÒ† €Îî ´ ¹ Î*'.€Îî €Îî œþ o(îv¹›P dÛhxÿ h!Ï ÿÿÿÿV�º  +yÓ ìÎî xÿ ìfÔ ÿÿÿÿ Z+ðv Vº ¾: €Îî 3„ €Îî €Îî eAº ².îvÚOîvj+ƒ ˆÿ ±   h BÀ )yÓ €  éš´ Å :"(
¬'. pýD xi+ {+ èu+ ÿÿÿÿÿÿÿÿÿÿÿÿ À  ÿ æ Äÿ H´ NÃÝ. ”ÿ E<ÿv pýÔÿ õ7/w pýo“÷w pý À8íÿv8íÿv*ÿ æ ÿÿÿÿíà*wÃ~Ë ìÿ È7/wR›´ pý R›´ pý $j-wœfuô ¢ˆi/ ô $  ìþd Äÿdeágu.`k[ \ÿdóºþvô ÿÿÿÿ �ºþvpÿd¢ºþvô ÿÿÿÿ ”ÿdÓº¸ ô ÿÿÿÿ E<ÿv Ôÿdõ7/w o“�v *ÿd ÿÿÿÿíà*wÃ~Ë ìÿdÈ7/wÀº¸ Àº¸ ÔW-wvfu Hÿ�ŠˆŒ, Fºþv $  >ôÿÿÿÿ ÿ� Äÿ�eáguNok[ |ÿ�fu N ”ÿ�þ
ƒ N E<ÿv Ôÿ�õ7/w o“du *ÿ� ÿÿÿÿíà*wÃ~Ë ìÿ�È7/wð
ƒ ð
ƒ �-( $j-wœfu@ ¦‰
( @ `ºþv$  ¦e.w èýH Äÿeágu.`k[ Xþóºþv@ ÿÿÿÿ �ºþvlþ¢ºþv@ ÿÿÿÿ 0ò ¸ @ ÿÿÿÿ ”ÿ E:\Vsro.188-Full Client #Ri3o\Vsro.188-Full Client #Ri3o\sro_client.exe E<ÿv Ôÿõ7/w o“âq *ÿ ÿÿÿÿíà*wÃ~Ë ìÿÈ7/w�ÿ· �ÿ· j-w;þ+w `¼.   3“Âq 0¼. WnöÙ«uÓ‰.A:  0¼. WnöÙ«uÓ‰.A: þ' Äÿ'íà*wÛDË  ”ÿ'E<ÿv Ôÿ'õ7/w0¼. o“Âq 0¼. *ÿ' ÿÿÿÿíà*wÃ~Ë ìÿ'È7/wý+w0¼. ý+w0¼. ( j-wÜifu pý ZŠ( äýäý$  Ì @ x…- lþ”e.w8( ç/.w«’òq œ( (  <ý* Äÿeágu¦k[ þ޼þvpýäý ÿÿÿÿ   Ì Èk( s- ¨n(  Œý0¿. Àþ þü¼þv pý ÿÿÿÿ 8þÚ¦Y Xþ ÿÿÿÿXÿ.¦Y ÿÿÿÿ Xþ8‘8‘Ì øþ$  Ì |_"(”ú  ÿ*ßÎv ( ø%Øs  PþÿÄÿeágu¦k[þÿÿÿjfu޼þv„þøþ 8‘ 8‘Ì Öˆ( 8‘©Ùs)Ží]þÿÿÿ4ÿü¼þv pý LÿÚ¦Y pÿ dÿº¦Y ˆÿ™ä¨Yÿÿÿÿ ®)¦Y 8‘éä¨Y ®ä¨Y”ÿE<ÿv8‘Ôÿõ7/w8‘o“òq 8‘ *ÿ ÿÿÿÿíà*wÃ~Ë ìÿÈ7/w¡ä¨Y8‘ ¡ä¨Y8‘ <"- j-wÜifu ðý7  Ú‰:( dþ7dþ7$  0 ÿÿÿÿÿÿÿÿ†jfu @ Pþ7 þ7,þ7 ÷*Jwxþ7Ɉîv�ˆîv ¼ý78ufÄÿ7eágu¦k[ „þ7޼þvðý7dþ7 ÿÿÿÿ  ¬þ7@ Èþ7ãbóv))ÛXþÿÿÿ�ˆîvµ‰îv Øþ7¾�îv pý ÿÿÿÿ µ‘îv˜!- @ ©’îv *þ7 d  €ÿ7!às@ ÿÿÿÿÿ  ˜!- ö  é4Ó Ÿ Ò "às às ø!às :Á  hl+   *”iï“Ð£Ì *É"1– Š{«$ˆÿ7î'às”ÿ7E<ÿv˜!- Ôÿ7õ7/w˜!- o“Òq ˜!- *ÿ7 ÿÿÿÿíà*wÃ~Ë ìÿ7È7/wá'às˜!- á'às˜!- 4j-wß,wð Üþé3“ q w- Hþù8s6wPþùTw- ° w- È5. (ƒ- (ƒ- È5.    ˜v-     8þé Äÿéíà*w{KË  ”ÿéE<ÿvw- Ôÿéõ7/ww- o“ q w- *ÿé ÿÿÿÿíà*wÃ~Ë ìÿéÈ7/wç,ww- ç,ww-  4j-wß,wô Üþù3“q w- 8s6wHþéTw- Pþé l w- Ðw- Ðw-  P6.  8þù Äÿùíà*w{KË  ”ÿùE<ÿvw- Ôÿùõ7/ww- o“q w- *ÿù ÿÿÿÿíà*wÃ~Ë ìÿùÈ7/wç,ww- ç,ww- ( j-wÜifu <ý  \ý nŠ) °ý °ý $  ` 8‘  € ‘  j-wÀ´³ÿÿÿÿÿ  ý 8‘Äÿ eágu¦k[ Ðý ޼þv<ý °ý  ô   `  üý  jfu®‰) ìý ü¼þv pý ô þ Ú¦Y $þ  ô $ÿ .¦Y ô $þ  <‘`  Èý j-wÜifu „þ  jfu6‰) øþ øþ $  ` –wîv_<)¬þ ü¼þv pý Ìþ   Pþ  Äÿ eágu¦k[þÿÿÿjfu޼þv„þ øþ  <‘ <‘` (‘ 0ÿ Üí¨Y 4ÿ ü¼þv lÿ ”-¦Yô <‘<‘ dÿ º¦Y pÿ ˆÿ  X<)ˆÿ ®)¦Y <‘éä¨Y ®ä¨Y”ÿ E<ÿv<‘Ôÿ õ7/w<‘o“ìp <‘ *ÿ  ÿÿÿÿíà*wÃ~Ë ìÿ È7/w¡ä¨Y<‘ ¡ä¨Y<‘ $j-wœfup ʈ) p D$  Ôþ Äÿeágu.`k[ Dÿóºþvp ÿÿÿÿ DXÿ¢ºþvp ÿÿÿÿ çn» p ÿÿÿÿ ”ÿ ÿÿÿÿ E<ÿvDÔÿõ7/wDo“üp D *ÿ ÿÿÿÿíà*wÃ~Ë ìÿÈ7/w°n» D °n» D ¡<$j-wœfuˆ Þˆâ& ˆ @ Ç$  À8 1 àþï Äÿïeágu.`k[ Pÿïóºþvˆ ÿÿÿÿ @ Çdÿþvˆ ÿÿÿÿ €ÿï€Pˆ ÿÿÿÿ Pˆÿïs€P”ÿïE<ÿv@ ÇÔÿïõ7/w@ Ço“
 @ Ç *ÿï ÿÿÿÿíà*wÃ~Ë ìÿïÈ7/wf€P@ Ç f€P@ Ç ¤c-wGhuÈ (ÿ_
ÿ_
ôþ_
€ÿ_
ü� €ÿ_

L È ,ÿ_
(ÿ_
$ÿ_
ÿÿÿÿ�}¸RRL�ì� ¼RötL PR �}œÌ RR¬j$ �}�}Tÿ_
Tÿ_
Äÿ_
Äÿ_
H´ >=Ü. ”ÿ_
A€Ì E<ÿv�}Ôÿ_
õ7/w�}o“º} �} *ÿ_
ÿÿÿÿíà*wÃ~Ë ìÿ_
È7/wÂÌ �} ÂÌ �} àŽ;qj-w¤9q @ÿw
   Ô à  ”ÿw
E<ÿv Ôÿw
õ7/w o“’} *ÿw
ÿÿÿÿíà*wÃ~Ë ìÿw
È7/wà£9q à£9q Tè¤c-wGhuÐ üþ‡
èþ‡
Èþ‡
 (},}ºœJ €ÿ‡
–0K Ð ÿ‡
üþ‡
8ÿ‡
ÿÿÿÿf*²$ˆ}ˆ}põhÿÿÿÿ!èL ,} pÿ‡
`#Õ ÿÿÿÿÞæL 8ÿ‡
ÿÿÿÿ 8õhÀõhötL  ÀõhœÌ 8õh8õh¬²$ ÀõhÀõhTÿ‡
Tÿ‡
Äÿ‡
Äÿ‡
H´ >=Ü. ”ÿ‡
A€Ì E<ÿvÀõhÔÿ‡
õ7/wÀõho“b} Àõh *ÿ‡
ÿÿÿÿíà*wÃ~Ë ìÿ‡
È7/wÂÌ Àõh ÂÌ Àõh  á    3 * B wÓ wÓ
Start ProgramwÓ  DISP_CHANGE_SUCCESSFULwÓ  CPSVersionCheck::OnCreate (0)wÓ  GateWay : 25.14.117.65wÓ  <Window Activate>+yÓ  Terminate Program+yÓ  <Window De-Activate>1²

Scrox
15-12-2017, 06:41 PM
ãä server_dep\silkroad\textdata\refscrapofpackageitem ÇÊÇßÏÇ ãä lines Ýì txt

eslamsaied
15-12-2017, 06:59 PM
ãÊÃßÏ ãäåÇ ÇäÇ ÚÇãáå Úáí ÈÑäÇãÌ NPC
æÌÑÈÊ ØÑíÞÉ íÏæÏí æÈÑÏæ äÝÓ ÇáãæÖæÚ
ÈÓ ÇÏíáß ãÚáæãÉ ÇÓÝ äÓíÊ ÇÐßÑåÇ æåíÇ Çäí ãÚÏá Úáí Ôßá ÇáÇÓáÍÉ Çááí ÇäÇ ÈÖíÝåÇ Ýí ÇáÇNPC ãÚÏá Ôßá ÇáÓáÇÍ äÝÓæ ÝÇ ããßä íßæä ÏÇ ÓÈÈ ¿¿

GM_Jo
15-12-2017, 07:09 PM
ÇÊÃßÏ ãä ID Ýì ÇáÏÇÊÇ Òì ÇáãíÏíÇ

æÌÑÈ ÊÑÌÚ ÇáÔßá ÇáÇÓÇÓì ÈÊÇÚ ÇáÇíÊã æÖíÝ ÇíÊã æÇÍÏ ÈÓ Ýì NPC

ãÊÖíÝÔ ÇíÊã ßÊíÑ ÚÔÇä ÊÊÃßÏ Çäß ãÇÔì ÕÍ

Scrox
15-12-2017, 10:41 PM
ÍÇÖÑÊß ÇáÈÑäÇãÌ ÈíÚãá ãÔÇßá ßÊíÑ ÝÇ ÇäÇ ÈÝÖíá Çäß ÊÖÇÝ ÇíÊã Ýì NPC ÈÇáßíæÑì Ïì ÚáÔÇä ÇáßÑÇÔ æ ÎÏ ÇáÓØæÇÑ ãä ÇáÏÇÊÇ æÍØåÇ Ýì ÇáãíÏíÇ æ Ýì ÇáßíæÑì ÊÞÏÑ ÊÓÚÑ Òì ãÇ ÇäÊ ÚÇíÒ Çì ßæíä

USE SRO_VT_SHARD
GO
DECLARE @ID int
DECLARE @INDEX int
DECLARE @CodeName varchar(128)
DECLARE @PackageName varchar(128)
DECLARE @DescSTRID varchar(128)
DECLARE @File varchar(128)
DECLARE @Price int
DECLARE @SilkPrice int
DECLARE @Gcoin int
DECLARE @Scoin int
DECLARE @Icoin int
DECLARE @Ccoin int
DECLARE @Acoin int
DECLARE @Optlvl int
DECLARE @Slot tinyint
DECLARE @TAB varchar(128)
DECLARE @Data int
DECLARE @SkipScrapOfPackageItem int = 0
DECLARE @SkipPackageItem int = 0
DECLARE @SkipPricePolicyOfItem int = 0
--- Set Variables
SET @CodeName = 'ITEM_CH_NECKLACE_11_A_RARE' -- Item CodeName in RefObjCommon
SET @Price = 1 -- Set 0 if you don't want to set Gold Price
SET @SilkPrice = 0 -- Set 0 if you don't want to set Silk Price
SET @Gcoin = 0 -- Set 0 if you don't want to set Gold Coin Price
SET @Scoin = 0 -- Set 0 if you don't want to set Silver Coin Price
SET @Icoin = 0 -- set 0 if you don't want to set Iron Coin Price
SET @Ccoin = 0 -- set 0 if you don't want to set Copper Coin Price
SET @Acoin = 0 -- set 0 if you don't want to set Arena Coin Price
SET @Optlvl = 5 -- Item Plus in npc Set 0 if you don't want plus for any item
SET @TAB = 'STORE_CH_NOVA_SET_SELLER_TAB7' -- Tab name in NPC, For _RefShopGoods
SET @PackageName = 'PACKAGE_'+@CodeName -- Do not edit if you don't know what are you doing.
--- you don't need to touch here...
IF (@CodeName = '')
BEGIN
PRINT 'You have to edit CodeName..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT(ID) FROM _RefObjCommon WHERE CodeName128 = @CodeName) < 1)
BEGIN
PRINT 'There is no item with this CodeName..!'
PRINT 'FAILED.'
RETURN
END
IF (@Price < 0)
BEGIN
PRINT 'Price is not VALID..!'
PRINT 'FAILED.'
RETURN
END
IF (@SilkPrice < 0)
BEGIN
PRINT 'Silk Price is not VALID..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT(ID) FROM _RefShopTab WHERE CodeName128 = @TAB) < 1)
BEGIN
PRINT 'TAB VALUE IS NOT VALID..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT (RefPackageItemCodeName) FROM _RefShopGoods WHERE RefPackageItemCodeName = @PackageName AND RefTabCodeName = @TAB) > 0)
BEGIN
PRINT 'There is already same item in same tab..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT (RefPackageItemCodeName) FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName = @PackageName) > 0)
BEGIN
PRINT 'There is already an entry for this item, skipping @_RefScrapOfPackageItem table..!'
SET @SkipScrapOfPackageItem = 1
END
IF ((SELECT COUNT (CodeName128) FROM _RefPackageItem WHERE CodeName128 = @PackageName) > 0)
BEGIN
PRINT 'There is already an entry for this item, skipping @_RefPackageItem table..!'
SET @SkipPackageItem = 1
END
IF ((SELECT COUNT (PaymentDevice) FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = @PackageName AND PaymentDevice = '1') > 0)
BEGIN
PRINT 'There is already an entry for this item with same PaymentDevice, skipping @_RefPricePolicyOfItem table..! (Gold)'
SET @SkipPricePolicyOfItem = 1
END
IF ((SELECT COUNT (PaymentDevice) FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = @PackageName AND PaymentDevice = '2') > 0)
BEGIN
PRINT 'There is already an entry for this item with same PaymentDevice, skipping @_RefPricePolicyOfItem table..! (Silk)'
IF (@SkipPricePolicyOfItem = 1)
BEGIN
SET @SkipPricePolicyOfItem = 3
END
ELSE
BEGIN
SET @SkipPricePolicyOfItem = 2
END
END
IF (@SilkPrice = 0) AND (@Price = 0)
BEGIN
PRINT 'You need to set a price, at least one !'
PRINT 'FAILED.'
RETURN
END
SELECT TOP 1 @ID = ID FROM _RefPackageItem ORDER BY ID DESC
SET @ID = @ID + 1
SELECT TOP 1 @INDEX = [Index] FROM _RefScrapOfPackageItem ORDER BY [Index] DESC
SET @INDEX = @INDEX + 1
SELECT TOP 1 @Slot = SlotIndex FROM _RefShopGoods WHERE RefTabCodeName = @TAB ORDER BY SlotIndex DESC
IF (@Slot = 0)
BEGIN
SET @Slot = @Slot + 1
END
ELSE IF (@Slot > 0)
BEGIN
SET @Slot = @Slot + 1
END
ELSE
BEGIN
SET @Slot = 0
END
SET @DescSTRID = 'SN_' + @CodeName + '_TT_DESC'
SELECT @File = AssocFileIcon128 FROM _RefObjCommon WHERE CodeName128 = @CodeName
IF (@CodeName LIKE '%RING%' OR @CodeName LIKE '%NECKLACE%' OR @CodeName LIKE '%ARCHEMY%')
BEGIN
SET @Data = 1
END
ELSE
BEGIN
SELECT @Data = Dur_U FROM _RefObjItem WHERE ID = (SELECT Link FROM _RefObjCommon WHERE CodeName128 = @CodeName)
END
BEGIN TRANSACTION
IF (@SkipPackageItem = 0)
BEGIN
--SET IDENTITY_INSERT _RefPackageItem ON
INSERT _RefPackageItem ([Service], Country, ID, CodeName128, SaleTag, ExpandTerm, NameStrID, DescStrID, AssocFileIcon, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @ID, @PackageName, 0, 'EXPAND_TERM_ALL', 'SN_'+@CodeName, @DescSTRID, @File, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPackageItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPackageItem !'
--SET IDENTITY_INSERT _RefPackageItem OFF
END
IF (@SkipScrapOfPackageItem = 0)
BEGIN
INSERT _RefScrapOfPackageItem (Service, Country, RefPackageItemCodeName, RefItemCodeName, OptLevel, Variance, Data, MagParamNum, MagParam1, MagParam2, MagParam3, MagParam4, MagParam5, MagParam6, MagParam7, MagParam8, MagParam9, MagParam10, MagParam11, MagParam12, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128, [Index]) VALUES (1, 15, @PackageName, @CodeName, @Optlvl, 0, @Data, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', @INDEX)
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefScrapOfPackageItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefScrapOfPackageItem !'
END
/**Gold Price***/
IF (@SkipPricePolicyOfItem = 2 OR @SkipPricePolicyOfItem = 0 AND @Price > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 1, 0, @Price, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 1 (Gold)'
END
/*** Silk Price **/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @SilkPrice > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 2, 0, @SilkPrice, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 2 (Silk)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/*****Gold Coin***/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Gcoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 512, 0, @Gcoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 512 (Gold Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/***Silver Coin***/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Scoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 256, 0, @Scoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 256 (Silver Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/****Iron Coin****/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Icoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 128, 0, @Icoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 128 (Iron Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/****Copper Coin**/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Ccoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 64, 0, @Ccoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 64 (Copper Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/****Arena Coin***/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Acoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 1024, 0, @Acoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 1024 (Arena Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/************** End Prices ***************/
INSERT _RefShopGoods (Service, Country, RefTabCodeName, RefPackageItemCodeName, SlotIndex, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @TAB, @PackageName, @Slot, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'An error happened while adding to _RefShopGoods table'
PRINT 'FAILED.'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefShopGoods, DONE!'
COMMIT TRANSACTION

æÈÚÏ ÇãÇ ÊÎáÕ Ýì Çá Database ÎÏ Çá
RefPackageItem
RefScarpOfPckageItem
RefPricePolicyOfItem
RefShop Goods
ÎÏ ßá Ïæá Copy ãä Çá Database æÍØåã Ýì Çá Media
æÇÚãá Èíåã UPDATE

eslamsaied
15-12-2017, 11:46 PM
ÊãÇã Çí Çááí íÊÚÏá Ýí ÇáßæíÑí Ïí ÈÞí

.Gamer.
16-12-2017, 02:49 AM
íÇ ÑíÓ ÇáÈÑäÇãÌ ÔÛÇá Ýí Çí ÏÇÊÇ æÔÛÇá ßæíÓ ãÝíåæÔ ãÔÇßá ÇáÚíÈ ÈíÈÞí ãä Çááí ÈíÓÊÎÏãå .. åæ ãÔ åíÔÊÛá ÚäÏ äÇÓ æäÇÓ áÇ
ËÇäíÇ ÇäÊ ãÔ ÈÊÇÎÏ ÇáãáÝÇÊ Çááí åæ ØáÚåÇáß æÊÚãáåÇ ÇãÈæÑÊ æÎáÇÕ "áÇ" ÇäÊ ÇáÍÇÌå Çááí ÚÏáÊåÇ Çæ ÖíÝÊåÇ ÈÊÝÊÍ Çá 4x txt Çááí ØáÚæáß æÊÇÎÏ ÓØæÑåÇ ãäåã æÊÍØåÇ Ýí texts ÇáÇÕáíå ÚäÏß " Ýí ÇÎÑ ÇáÊßÓÊ " æÈÚÏíä ÊÚãá ÇãÈæÑÊ ááãáÝÇÊ ÇáÇÕáíå ... ãÔ ÕÚÈå æáæ æÞÝÊ Úáíß Þæáí :toilet::bomb:

.Gamer.
16-12-2017, 02:50 AM
ÍÇÖÑÊß ÇáÈÑäÇãÌ ÈíÚãá ãÔÇßá ßÊíÑ ÝÇ ÇäÇ ÈÝÖíá Çäß ÊÖÇÝ ÇíÊã Ýì NPC ÈÇáßíæÑì Ïì ÚáÔÇä ÇáßÑÇÔ æ ÎÏ ÇáÓØæÇÑ ãä ÇáÏÇÊÇ æÍØåÇ Ýì ÇáãíÏíÇ æ Ýì ÇáßíæÑì ÊÞÏÑ ÊÓÚÑ Òì ãÇ ÇäÊ ÚÇíÒ Çì ßæíä

USE SRO_VT_SHARD
GO
DECLARE @ID int
DECLARE @INDEX int
DECLARE @CodeName varchar(128)
DECLARE @PackageName varchar(128)
DECLARE @DescSTRID varchar(128)
DECLARE @File varchar(128)
DECLARE @Price int
DECLARE @SilkPrice int
DECLARE @Gcoin int
DECLARE @Scoin int
DECLARE @Icoin int
DECLARE @Ccoin int
DECLARE @Acoin int
DECLARE @Optlvl int
DECLARE @Slot tinyint
DECLARE @TAB varchar(128)
DECLARE @Data int
DECLARE @SkipScrapOfPackageItem int = 0
DECLARE @SkipPackageItem int = 0
DECLARE @SkipPricePolicyOfItem int = 0
--- Set Variables
SET @CodeName = 'ITEM_CH_NECKLACE_11_A_RARE' -- Item CodeName in RefObjCommon
SET @Price = 1 -- Set 0 if you don't want to set Gold Price
SET @SilkPrice = 0 -- Set 0 if you don't want to set Silk Price
SET @Gcoin = 0 -- Set 0 if you don't want to set Gold Coin Price
SET @Scoin = 0 -- Set 0 if you don't want to set Silver Coin Price
SET @Icoin = 0 -- set 0 if you don't want to set Iron Coin Price
SET @Ccoin = 0 -- set 0 if you don't want to set Copper Coin Price
SET @Acoin = 0 -- set 0 if you don't want to set Arena Coin Price
SET @Optlvl = 5 -- Item Plus in npc Set 0 if you don't want plus for any item
SET @TAB = 'STORE_CH_NOVA_SET_SELLER_TAB7' -- Tab name in NPC, For _RefShopGoods
SET @PackageName = 'PACKAGE_'+@CodeName -- Do not edit if you don't know what are you doing.
--- you don't need to touch here...
IF (@CodeName = '')
BEGIN
PRINT 'You have to edit CodeName..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT(ID) FROM _RefObjCommon WHERE CodeName128 = @CodeName) < 1)
BEGIN
PRINT 'There is no item with this CodeName..!'
PRINT 'FAILED.'
RETURN
END
IF (@Price < 0)
BEGIN
PRINT 'Price is not VALID..!'
PRINT 'FAILED.'
RETURN
END
IF (@SilkPrice < 0)
BEGIN
PRINT 'Silk Price is not VALID..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT(ID) FROM _RefShopTab WHERE CodeName128 = @TAB) < 1)
BEGIN
PRINT 'TAB VALUE IS NOT VALID..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT (RefPackageItemCodeName) FROM _RefShopGoods WHERE RefPackageItemCodeName = @PackageName AND RefTabCodeName = @TAB) > 0)
BEGIN
PRINT 'There is already same item in same tab..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT (RefPackageItemCodeName) FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName = @PackageName) > 0)
BEGIN
PRINT 'There is already an entry for this item, skipping @_RefScrapOfPackageItem table..!'
SET @SkipScrapOfPackageItem = 1
END
IF ((SELECT COUNT (CodeName128) FROM _RefPackageItem WHERE CodeName128 = @PackageName) > 0)
BEGIN
PRINT 'There is already an entry for this item, skipping @_RefPackageItem table..!'
SET @SkipPackageItem = 1
END
IF ((SELECT COUNT (PaymentDevice) FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = @PackageName AND PaymentDevice = '1') > 0)
BEGIN
PRINT 'There is already an entry for this item with same PaymentDevice, skipping @_RefPricePolicyOfItem table..! (Gold)'
SET @SkipPricePolicyOfItem = 1
END
IF ((SELECT COUNT (PaymentDevice) FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = @PackageName AND PaymentDevice = '2') > 0)
BEGIN
PRINT 'There is already an entry for this item with same PaymentDevice, skipping @_RefPricePolicyOfItem table..! (Silk)'
IF (@SkipPricePolicyOfItem = 1)
BEGIN
SET @SkipPricePolicyOfItem = 3
END
ELSE
BEGIN
SET @SkipPricePolicyOfItem = 2
END
END
IF (@SilkPrice = 0) AND (@Price = 0)
BEGIN
PRINT 'You need to set a price, at least one !'
PRINT 'FAILED.'
RETURN
END
SELECT TOP 1 @ID = ID FROM _RefPackageItem ORDER BY ID DESC
SET @ID = @ID + 1
SELECT TOP 1 @INDEX = [Index] FROM _RefScrapOfPackageItem ORDER BY [Index] DESC
SET @INDEX = @INDEX + 1
SELECT TOP 1 @Slot = SlotIndex FROM _RefShopGoods WHERE RefTabCodeName = @TAB ORDER BY SlotIndex DESC
IF (@Slot = 0)
BEGIN
SET @Slot = @Slot + 1
END
ELSE IF (@Slot > 0)
BEGIN
SET @Slot = @Slot + 1
END
ELSE
BEGIN
SET @Slot = 0
END
SET @DescSTRID = 'SN_' + @CodeName + '_TT_DESC'
SELECT @File = AssocFileIcon128 FROM _RefObjCommon WHERE CodeName128 = @CodeName
IF (@CodeName LIKE '%RING%' OR @CodeName LIKE '%NECKLACE%' OR @CodeName LIKE '%ARCHEMY%')
BEGIN
SET @Data = 1
END
ELSE
BEGIN
SELECT @Data = Dur_U FROM _RefObjItem WHERE ID = (SELECT Link FROM _RefObjCommon WHERE CodeName128 = @CodeName)
END
BEGIN TRANSACTION
IF (@SkipPackageItem = 0)
BEGIN
--SET IDENTITY_INSERT _RefPackageItem ON
INSERT _RefPackageItem ([Service], Country, ID, CodeName128, SaleTag, ExpandTerm, NameStrID, DescStrID, AssocFileIcon, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @ID, @PackageName, 0, 'EXPAND_TERM_ALL', 'SN_'+@CodeName, @DescSTRID, @File, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPackageItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPackageItem !'
--SET IDENTITY_INSERT _RefPackageItem OFF
END
IF (@SkipScrapOfPackageItem = 0)
BEGIN
INSERT _RefScrapOfPackageItem (Service, Country, RefPackageItemCodeName, RefItemCodeName, OptLevel, Variance, Data, MagParamNum, MagParam1, MagParam2, MagParam3, MagParam4, MagParam5, MagParam6, MagParam7, MagParam8, MagParam9, MagParam10, MagParam11, MagParam12, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128, [Index]) VALUES (1, 15, @PackageName, @CodeName, @Optlvl, 0, @Data, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', @INDEX)
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefScrapOfPackageItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefScrapOfPackageItem !'
END
/**Gold Price***/
IF (@SkipPricePolicyOfItem = 2 OR @SkipPricePolicyOfItem = 0 AND @Price > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 1, 0, @Price, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 1 (Gold)'
END
/*** Silk Price **/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @SilkPrice > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 2, 0, @SilkPrice, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 2 (Silk)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/*****Gold Coin***/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Gcoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 512, 0, @Gcoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 512 (Gold Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/***Silver Coin***/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Scoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 256, 0, @Scoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 256 (Silver Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/****Iron Coin****/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Icoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 128, 0, @Icoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 128 (Iron Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/****Copper Coin**/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Ccoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 64, 0, @Ccoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 64 (Copper Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/****Arena Coin***/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Acoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 1024, 0, @Acoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 1024 (Arena Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/************** End Prices ***************/
INSERT _RefShopGoods (Service, Country, RefTabCodeName, RefPackageItemCodeName, SlotIndex, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @TAB, @PackageName, @Slot, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'An error happened while adding to _RefShopGoods table'
PRINT 'FAILED.'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefShopGoods, DONE!'
COMMIT TRANSACTION

æÈÚÏ ÇãÇ ÊÎáÕ Ýì Çá Database ÎÏ Çá
RefPackageItem
RefScarpOfPckageItem
RefPricePolicyOfItem
RefShop Goods
ÎÏ ßá Ïæá Copy ãä Çá Database æÍØåã Ýì Çá Media
æÇÚãá Èíåã UPDATE


ÈáÇÔ äÝÊí :) :111:

ÇÝäÏíäÇ ™Hamboka™
16-12-2017, 04:42 AM
ÎÏ ßæÈí ãä refscrapofpackageitem +refgoodshop+refpackegaitem+refpriceofpilceitem ãä data beas æ ÍØåã ßæÈí Ýí äÝÓ ÇáãáÝÇÊ Çáí Ý media ÈÓ ßáãÊ Null Çáí Ýí ÇáÇÎÑ ÇãÓÍåÇ æÇäÊ ÈÊÚãá paste

eslamsaied
16-12-2017, 09:42 AM
ÌÇÑí ÇáÊÌÑÈÉ

eslamsaied
16-12-2017, 12:07 PM
ØíÈ åæÇ áæ ÇäÇ ãÚÏá ÇáÓáÇÍ ÊãÇã ÇáÓáÇÍ D12 ÇäÇ ãÚÏá Úáíå æãÎáíå D15 åÚÏá Çíå ÈÞí Ýí ÇááíäÇÊ ÚÔÇä ÇäÇ ßÏÇ ÇáãÔßáÉ Ýí Çäí ãÚÏá Úáí ÇáÓáÇÍ
Çæ áæ ãÔ ÝÇåã ÞÕÏí ÇßÊÈáí ÇáãÓÇÑÇÊ ÈÊÇÚ Ôßá ÇáÓáÇÍ æÇäÇ åÍÇæá ÝíåÇ

eslamsaied
16-12-2017, 04:04 PM
ÍÇÖÑÊß ÇáÈÑäÇãÌ ÈíÚãá ãÔÇßá ßÊíÑ ÝÇ ÇäÇ ÈÝÖíá Çäß ÊÖÇÝ ÇíÊã Ýì NPC ÈÇáßíæÑì Ïì ÚáÔÇä ÇáßÑÇÔ æ ÎÏ ÇáÓØæÇÑ ãä ÇáÏÇÊÇ æÍØåÇ Ýì ÇáãíÏíÇ æ Ýì ÇáßíæÑì ÊÞÏÑ ÊÓÚÑ Òì ãÇ ÇäÊ ÚÇíÒ Çì ßæíä

USE SRO_VT_SHARD
GO
DECLARE @ID int
DECLARE @INDEX int
DECLARE @CodeName varchar(128)
DECLARE @PackageName varchar(128)
DECLARE @DescSTRID varchar(128)
DECLARE @File varchar(128)
DECLARE @Price int
DECLARE @SilkPrice int
DECLARE @Gcoin int
DECLARE @Scoin int
DECLARE @Icoin int
DECLARE @Ccoin int
DECLARE @Acoin int
DECLARE @Optlvl int
DECLARE @Slot tinyint
DECLARE @TAB varchar(128)
DECLARE @Data int
DECLARE @SkipScrapOfPackageItem int = 0
DECLARE @SkipPackageItem int = 0
DECLARE @SkipPricePolicyOfItem int = 0
--- Set Variables
SET @CodeName = 'ITEM_CH_NECKLACE_11_A_RARE' -- Item CodeName in RefObjCommon
SET @Price = 1 -- Set 0 if you don't want to set Gold Price
SET @SilkPrice = 0 -- Set 0 if you don't want to set Silk Price
SET @Gcoin = 0 -- Set 0 if you don't want to set Gold Coin Price
SET @Scoin = 0 -- Set 0 if you don't want to set Silver Coin Price
SET @Icoin = 0 -- set 0 if you don't want to set Iron Coin Price
SET @Ccoin = 0 -- set 0 if you don't want to set Copper Coin Price
SET @Acoin = 0 -- set 0 if you don't want to set Arena Coin Price
SET @Optlvl = 5 -- Item Plus in npc Set 0 if you don't want plus for any item
SET @TAB = 'STORE_CH_NOVA_SET_SELLER_TAB7' -- Tab name in NPC, For _RefShopGoods
SET @PackageName = 'PACKAGE_'+@CodeName -- Do not edit if you don't know what are you doing.
--- you don't need to touch here...
IF (@CodeName = '')
BEGIN
PRINT 'You have to edit CodeName..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT(ID) FROM _RefObjCommon WHERE CodeName128 = @CodeName) < 1)
BEGIN
PRINT 'There is no item with this CodeName..!'
PRINT 'FAILED.'
RETURN
END
IF (@Price < 0)
BEGIN
PRINT 'Price is not VALID..!'
PRINT 'FAILED.'
RETURN
END
IF (@SilkPrice < 0)
BEGIN
PRINT 'Silk Price is not VALID..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT(ID) FROM _RefShopTab WHERE CodeName128 = @TAB) < 1)
BEGIN
PRINT 'TAB VALUE IS NOT VALID..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT (RefPackageItemCodeName) FROM _RefShopGoods WHERE RefPackageItemCodeName = @PackageName AND RefTabCodeName = @TAB) > 0)
BEGIN
PRINT 'There is already same item in same tab..!'
PRINT 'FAILED.'
RETURN
END
IF ((SELECT COUNT (RefPackageItemCodeName) FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName = @PackageName) > 0)
BEGIN
PRINT 'There is already an entry for this item, skipping @_RefScrapOfPackageItem table..!'
SET @SkipScrapOfPackageItem = 1
END
IF ((SELECT COUNT (CodeName128) FROM _RefPackageItem WHERE CodeName128 = @PackageName) > 0)
BEGIN
PRINT 'There is already an entry for this item, skipping @_RefPackageItem table..!'
SET @SkipPackageItem = 1
END
IF ((SELECT COUNT (PaymentDevice) FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = @PackageName AND PaymentDevice = '1') > 0)
BEGIN
PRINT 'There is already an entry for this item with same PaymentDevice, skipping @_RefPricePolicyOfItem table..! (Gold)'
SET @SkipPricePolicyOfItem = 1
END
IF ((SELECT COUNT (PaymentDevice) FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = @PackageName AND PaymentDevice = '2') > 0)
BEGIN
PRINT 'There is already an entry for this item with same PaymentDevice, skipping @_RefPricePolicyOfItem table..! (Silk)'
IF (@SkipPricePolicyOfItem = 1)
BEGIN
SET @SkipPricePolicyOfItem = 3
END
ELSE
BEGIN
SET @SkipPricePolicyOfItem = 2
END
END
IF (@SilkPrice = 0) AND (@Price = 0)
BEGIN
PRINT 'You need to set a price, at least one !'
PRINT 'FAILED.'
RETURN
END
SELECT TOP 1 @ID = ID FROM _RefPackageItem ORDER BY ID DESC
SET @ID = @ID + 1
SELECT TOP 1 @INDEX = [Index] FROM _RefScrapOfPackageItem ORDER BY [Index] DESC
SET @INDEX = @INDEX + 1
SELECT TOP 1 @Slot = SlotIndex FROM _RefShopGoods WHERE RefTabCodeName = @TAB ORDER BY SlotIndex DESC
IF (@Slot = 0)
BEGIN
SET @Slot = @Slot + 1
END
ELSE IF (@Slot > 0)
BEGIN
SET @Slot = @Slot + 1
END
ELSE
BEGIN
SET @Slot = 0
END
SET @DescSTRID = 'SN_' + @CodeName + '_TT_DESC'
SELECT @File = AssocFileIcon128 FROM _RefObjCommon WHERE CodeName128 = @CodeName
IF (@CodeName LIKE '%RING%' OR @CodeName LIKE '%NECKLACE%' OR @CodeName LIKE '%ARCHEMY%')
BEGIN
SET @Data = 1
END
ELSE
BEGIN
SELECT @Data = Dur_U FROM _RefObjItem WHERE ID = (SELECT Link FROM _RefObjCommon WHERE CodeName128 = @CodeName)
END
BEGIN TRANSACTION
IF (@SkipPackageItem = 0)
BEGIN
--SET IDENTITY_INSERT _RefPackageItem ON
INSERT _RefPackageItem ([Service], Country, ID, CodeName128, SaleTag, ExpandTerm, NameStrID, DescStrID, AssocFileIcon, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @ID, @PackageName, 0, 'EXPAND_TERM_ALL', 'SN_'+@CodeName, @DescSTRID, @File, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPackageItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPackageItem !'
--SET IDENTITY_INSERT _RefPackageItem OFF
END
IF (@SkipScrapOfPackageItem = 0)
BEGIN
INSERT _RefScrapOfPackageItem (Service, Country, RefPackageItemCodeName, RefItemCodeName, OptLevel, Variance, Data, MagParamNum, MagParam1, MagParam2, MagParam3, MagParam4, MagParam5, MagParam6, MagParam7, MagParam8, MagParam9, MagParam10, MagParam11, MagParam12, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128, [Index]) VALUES (1, 15, @PackageName, @CodeName, @Optlvl, 0, @Data, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', @INDEX)
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefScrapOfPackageItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefScrapOfPackageItem !'
END
/**Gold Price***/
IF (@SkipPricePolicyOfItem = 2 OR @SkipPricePolicyOfItem = 0 AND @Price > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 1, 0, @Price, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 1 (Gold)'
END
/*** Silk Price **/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @SilkPrice > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 2, 0, @SilkPrice, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 2 (Silk)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/*****Gold Coin***/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Gcoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 512, 0, @Gcoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 512 (Gold Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/***Silver Coin***/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Scoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 256, 0, @Scoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 256 (Silver Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/****Iron Coin****/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Icoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 128, 0, @Icoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 128 (Iron Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/****Copper Coin**/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Ccoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 64, 0, @Ccoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 64 (Copper Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/****Arena Coin***/
IF (@SkipPricePolicyOfItem = 1 OR @SkipPricePolicyOfItem = 0 AND @Acoin > 0)
BEGIN
INSERT _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @PackageName, 1024, 0, @Acoin, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'AN ERROR HAPPENED WHILE ADDING TO _RefPricePolicyOfItem, Rolling back...'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefPricePolicyOfItem, PaymentDevice = 1024 (Arena Coin)'
END
ELSE
BEGIN
PRINT 'There is already silk / gold price, skipping _RefPricePolicyOfItem table...'
END
/************** End Prices ***************/
INSERT _RefShopGoods (Service, Country, RefTabCodeName, RefPackageItemCodeName, SlotIndex, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES (1, 15, @TAB, @PackageName, @Slot, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
IF (@@ERROR <> 0)
BEGIN
PRINT 'An error happened while adding to _RefShopGoods table'
PRINT 'FAILED.'
ROLLBACK TRANSACTION
RETURN
END
PRINT 'Added to _RefShopGoods, DONE!'
COMMIT TRANSACTION

æÈÚÏ ÇãÇ ÊÎáÕ Ýì Çá Database ÎÏ Çá
RefPackageItem
RefScarpOfPckageItem
RefPricePolicyOfItem
RefShop Goods
ÎÏ ßá Ïæá Copy ãä Çá Database æÍØåã Ýì Çá Media
æÇÚãá Èíåã UPDATE


http://a.up-00.com/2017/12/151342945756171.jpg

.Gamer.
16-12-2017, 04:32 PM
ãÔ ÝÇåã íÚäí Çíå ÚÏáÊ ÈÏá dg12 áí dg15 ??

eslamsaied
16-12-2017, 04:37 PM
1 15 1856 PACKAGE_ITEM_EU_SWORD_12_C_RARE 0 EXPAND_TERM_ALL SN_ITEM_EU_SWORD_12_C_RARE SN_ITEM_EU_SWORD_12_C_RARE_TT_DESC item\europe\weapon\sword_15.ddj -1 xxx -1 xxx -1 xxx -1 xxx
íÚäí ÇáÇæá ßÇä 12.ddj
ÇäÇ ÚÏáÊå æÎáíÊå 15.ddj ÚÔÇä ÇäÇ ßäÊ ãÚÏá Úáí Ôßá ÇáÓáÇÍ ÝåãÊäí
æÌÇíÈ äÝÓ ÇáßÑÇÔ æäÝÓ ÇáÓÈÈ ÇáÇæáÇäí Çä ÇáÛáØ Ýí ãáÝ refscrapofitem.txt

.Gamer.
16-12-2017, 04:40 PM
áÇ Ïå ãáæÔ ÏÚæÉ ( ÇáãÔßáå ÏáæÞÊí åÊáÇÞíåÇ 10000% Ýí RefpackageItem - RefScrapOfPackageItem ÔæÝ Çá id's ÈÊæÚåã ãÙÈæØÉ æáÇ áÃ

eslamsaied
16-12-2017, 05:23 PM
1 15 1871 PACKAGE_ITEM_SWAGGER_TITLE_01 0 EXPAND_TERM_ALL SN_ITEM_SWAGGER_TITLE_01 SN_ITEM_SWAGGER_TITLE_01_TT_DESC item\etc\mall_change_name.ddj -1 xxx -1 xxx -1 xxx -1 xxx
ØíÈ ßæÏ ÇáRefpackageItem
Ýíä ÇáID ÈÊÇÚå æÇÞÇÑäå È Çíå
1 15 PACKAGE_ITEM_SWAGGER_TITLE_01 ITEM_SWAGGER_TITLE_01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 1871
æÏÇ ßæÏ RefScrapOfPackageItem

eslamsaied
16-12-2017, 05:25 PM
åæÇ ÚÇÏí ÇáID íÊßÑÑ ¿¿ ÇÕá ÇäÇ áÞíÊ ÇáID ÈÊÇÚ ÇáÇíÊã ãÊßÑÑ Ýí ãáÝ ÇáRefpackageItem

Scrox
16-12-2017, 10:30 PM
ÈáÇÔ äÝÊí :) :111:

ÇÝÊì Ýì ÇíÉ ÈÖÈØ ÇäÇ ÔÛÇá Úáì ßíæÑì Ïì Òì ÇáÝá ÇÍÓä ãä 100 ÈÑäÇãÌ Òì Ïì æááãÑÉ ÇáÇÎÑÉ íÑÇÊ ÊÍÊÑã ÇáÝÇÙß ÇÍäÇ åäÇ ÈäÓÇÚÏ ÈÚÖ ãÔ ÈäÊÎÇäÞ :mad2:

Mr Z!dane
18-12-2017, 02:44 AM
ãÝíÔ ãÊÇÈÚå ááãæÖæÚ
##