Pangya Season 4.9 Server Files and Database

Page 18 of 31 FirstFirst ... 8101112131415161718192021222324252628 ... LastLast
Results 256 to 270 of 459
  1. 10-12-10 #256
    outlawzzbr
    Enthusiast outlawzzbr is offline
    MemberRank
    Dec 2010 Join Date
    30Posts

    angry Database Error

    HELP PLEASE!

    I'm having problems with the databases(INI3Bill_DB, ini3_py_account, Pangya_S4_TH) I put the code in Query Analyzer, F5 Grip (to perform the task), and these errors:

    http://img690.imageshack.us/img690/5870/erro1n.png

    http://img263.imageshack.us/img263/2893/erro2u.png

    http://img146.imageshack.us/img146/9426/erro3.png

    PS : Sorry for English but I'm from Brazil and used Google translator! Please HELP
  2. 10-12-10 #257
    Tsukasa
    Deny everything. Tsukasa is offline
    MemberRank
    Jun 2005 Join Date
    Net SlumLocation
    558Posts

    Re: Database Error

    Quote Originally Posted by outlawzzbr View Post
    HELP PLEASE!

    I'm having problems with the databases(INI3Bill_DB, ini3_py_account, Pangya_S4_TH) I put the code in Query Analyzer, F5 Grip (to perform the task), and these errors:

    http://img690.imageshack.us/img690/5870/erro1n.png

    http://img263.imageshack.us/img263/2893/erro2u.png

    http://img146.imageshack.us/img146/9426/erro3.png

    PS : Sorry for English but I'm from Brazil and used Google translator! Please HELP
    You're using SQL Server 2000, right?
    The queries you're trying to execute were created using SQL Server 2005, some other queries in this thread even with SQL Server 2008.

    So I would advise that you upgrade or install an additional SQL Server 2008 instance.
  3. 10-12-10 #258
    outlawzzbr
    Enthusiast outlawzzbr is offline
    MemberRank
    Dec 2010 Join Date
    30Posts

    thumbs up Re: Database Error

    Quote Originally Posted by Tsukasa View Post
    You're using SQL Server 2000, right?
    The queries you're trying to execute were created using SQL Server 2005, some other queries in this thread even with SQL Server 2008.

    So I would advise that you upgrade or install an additional SQL Server 2008 instance.
    I will download the SQL Server 2008, then post results!

    Thanks!
  4. 11-12-10 #259
    wellan17
    Apprentice wellan17 is offline
    MemberRank
    Jun 2008 Join Date
    19Posts

    Re: Pangya Season 4.9 Server Files and Database

    is not adding friends and cards do not work any fix?
  5. 11-12-10 #260
    fasa2008
    Member fasa2008 is offline
    MemberRank
    Dec 2008 Join Date
    94Posts

    Re: Pangya Season 4.9 Server Files and Database

    Well I bring to you the first tutorial on Unlock, change price and status of the items ...

    Red - Price of Item in shop. IN hEX

    Yellow – Item cokkies or pangs

    Brown - Enabled in the shop with the tag = Hot > 21, New > 11, Normal > 01 or 03.




    Thanks to all who thank me, gave work to do ... xD
    Last edited by fasa2008; 11-12-10 at 06:28 AM.
  6. 11-12-10 #261
    outlawzzbr
    Enthusiast outlawzzbr is offline
    MemberRank
    Dec 2010 Join Date
    30Posts

    angry Help - SQL SERVER 2008 R2

    PLEASE - Someone pass me a tutorial on how to install SQL SERVER 2008 R2 ?
  7. 11-12-10 #262
    chiosin2
    LoLonYou chiosin2 is offline
    MemberRank
    Aug 2008 Join Date
    Katipunan_AvenueLocation
    306Posts

    Re: Pangya Season 4.9 Server Files and Database

    @outlawzzbr i used SQL 2005 and it worked just fine.

    i used monk's DB's added a user monk and then made it work.
    i also used some fixes made by tsukasa/fasa2008/bubbastic

    ^^ though there are still unanswered questions out there. but its better than nothing.
  8. 11-12-10 #263
    outlawzzbr
    Enthusiast outlawzzbr is offline
    MemberRank
    Dec 2010 Join Date
    30Posts

    ! DB Pangya_S4_TH with problem

    Quote Originally Posted by chiosin2 View Post
    @outlawzzbr i used SQL 2005 and it worked just fine.

    i used monk's DB's added a user monk and then made it work.
    i also used some fixes made by tsukasa/fasa2008/bubbastic

    ^^ though there are still unanswered questions out there. but its better than nothing.
    The DBs ini3_py_account and INI3Bill_DB worked perfectly, but the DB Pangya_S4_TH still with this problem, look:

    Spoiler:
    Msg 15007, Level 16, State 1, Line 3
    'payletter' is not a valid login or you do not have permission.
    Msg 15007, Level 16, State 1, Line 3
    'Pangya_TH' is not a valid login or you do not have permission.
    Msg 15007, Level 16, State 1, Line 3
    'ini3webstat' is not a valid login or you do not have permission.
    Msg 15007, Level 16, State 1, Line 3
    'ini3web' is not a valid login or you do not have permission.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Item' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Item' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Item' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 1921, Level 16, State 1, Line 3
    Invalid filegroup 'Pangya_S4_TH_Mail' specified.
    Msg 208, Level 16, State 1, Procedure UVW_USER_ITEM, Line 13
    Invalid object name 'DBO.PangYa_Character_Information'.
    Msg 208, Level 16, State 1, Procedure UVW_ENCHANT_PANG, Line 27
    Invalid object name 'PANGYA_ITEM_WAREHOUSE'.
    Msg 1767, Level 16, State 0, Line 3
    Foreign key 'FK_TD_MAIL_LOG_RET_TA_MAIL_SENDERR_ACC_ERR_CD' references invalid table 'dbo.TA_MAIL_SENDERR_ACC'.
    Msg 1750, Level 16, State 0, Line 3
    Could not create constraint. See previous errors.
    Msg 4917, Level 16, State 0, Line 1
    Constraint 'FK_TD_MAIL_LOG_RET_TA_MAIL_SENDERR_ACC_ERR_CD' does not exist.
    Msg 4916, Level 16, State 0, Line 1
    Could not enable or disable the constraint. See previous errors.


    PRINT : http://img826.imageshack.us/img826/7637/erro1h.png

    HELP ME?
  9. 11-12-10 #264
    chiosin2
    LoLonYou chiosin2 is offline
    MemberRank
    Aug 2008 Join Date
    Katipunan_AvenueLocation
    306Posts

    Re: Pangya Season 4.9 Server Files and Database

    look a few pages back i posted the same problem.. ^^

    first thing you do is this.

    -create a new log in named Monk (i'm assuming your using Monk's Databases)
    -create 3 new filegroups names Pangya_S4_Th_Card/Pangya_S4_Th_gLog/Pangya_S4_Th_Item

    and then execute it again.. it should work fine now.. ^^
  10. 11-12-10 #265
    outlawzzbr
    Enthusiast outlawzzbr is offline
    MemberRank
    Dec 2010 Join Date
    30Posts

    smile Re: Pangya Season 4.9 Server Files and Database

    Quote Originally Posted by chiosin2 View Post
    look a few pages back i posted the same problem.. ^^

    first thing you do is this.

    -create a new log in named Monk (i'm assuming your using Monk's Databases)
    -create 3 new filegroups names Pangya_S4_Th_Card/Pangya_S4_Th_gLog/Pangya_S4_Th_Item

    and then execute it again.. it should work fine now.. ^^
    Forgive the ignorance but how do they create filegroups?
  11. 11-12-10 #266
    MentaL
    ...[ White Rabbit ]... MentaL is offline
      Administrator  Rank
    Jan 2001 Join Date
    31,636Posts

    Re: Pangya Season 4.9 Server Files and Database

    look
  12. 11-12-10 #267
    fasa2008
    Member fasa2008 is offline
    MemberRank
    Dec 2008 Join Date
    94Posts

    Re: Pangya Season 4.9 Server Files and Database

    Quote Originally Posted by outlawzzbr View Post
    Forgive the ignorance but how do they create filegroups?
    sorry
    Last edited by fasa2008; 11-12-10 at 08:38 PM.
  13. 11-12-10 #268
    MentaL
    ...[ White Rabbit ]... MentaL is offline
      Administrator  Rank
    Jan 2001 Join Date
    31,636Posts

    Re: Pangya Season 4.9 Server Files and Database

    Quote Originally Posted by fasa2008 View Post
    Are you Brazilian friend? Post your question in RZBR ... I resolve
    How about do not POST on rzbr because its using my name ILLEGALLY. We do not support nor allow replica ragezone websites, especially ones who abuse my trademark.
  14. 11-12-10 #269
    fasa2008
    Member fasa2008 is offline
    MemberRank
    Dec 2008 Join Date
    94Posts

    Re: Pangya Season 4.9 Server Files and Database

    Quote Originally Posted by MentaL View Post
    How about do not POST on rzbr because its using my name ILLEGALLY. We do not support nor allow replica ragezone websites, especially ones who abuse my trademark.
    The same topic is here has there. Since the User up there because it is Brazilian not get help there that would be easier for him to understand I'm not the owner of RZBR ... Sorry I did not post anything else ... xD
  15. 11-12-10 #270
    Tsukasa
    Deny everything. Tsukasa is offline
    MemberRank
    Jun 2005 Join Date
    Net SlumLocation
    558Posts

    Re: Pangya Season 4.9 Server Files and Database

    Quote Originally Posted by fasa2008 View Post
    Well I bring to you the first tutorial on Unlock, change price and status of the items ...

    Red - Price of Item in shop. IN hEX

    Yellow – Item cokkies or pangs

    Brown - Enabled in the shop with the tag = Hot > 21, New > 11, Normal > 01 or 03.


    Thanks to all who thank me, gave work to do ... xD
    Thanks a lot for the guide. There are still a few things I'd like to understand. For instance in the blocks 6248-6251 (right after price value of the Zigzag Hairband) there is some value... any idea what that does? Same goes for 6264-6267, 6270 and the area 6280-6294... If anyone has any insight what these values do, I'd be most thankful for some feedback.

    Just to add to the understanding of the file format: A record in Part.iff is always 512blocks long. First records starts at an offset of 8, preceeded by two uint32 values indicating the total number of items in the file and the iff version (I assume) that is always 11 decimal.


« Previous Thread | Next Thread »

Advertisement