Pangya Season 4.9 Server Files and Database

[gigok]

So the database is now complete? I see all can play the game now...^_^

[chiosin2]

I still can't see the channels.. the logs don't show any errors and i've configured the crap out of the server files. @_@ i'm really lost right now.

[o800920]

@darkknight
i use your .bak also get Error: 3241

[tulang3587]

I'm using MSSQL 2008, so maybe there have been some subtle changes to what's acceptable. I'll look into it.

I see, I've tried the queries using 2000, then 2005 with no avail...

I'll download the 2008 version first then, hopefully I'll be able to contribute to this thread.

[darkknight]

The media family on device 'xxxx.BAK' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)


The SQL server version is different. backups are not backward compatible. For example if the backup is created using SQL2008, you cannot restore it on SQL2005. You get SQL error 3241 - Restore Headeronly is terminating abnormally.

[gigok]

Well i cant see Final Database...

[Tsukasa]

Well i cant see Final Database...

That's because there is no final database yet (unfortunately).
The main screen is as far as you get. If you are lucky you can play Family Mode. Maybe chat a little. But that's about it.

Since all the "it's so easy to fix, here's a screenshot but no word on how to do it" guys are silent and won't share any information except "it's so easy" it will probably still take a while to get a somewhat usable server configuration (if we're so lucky as to ever get this to run).

[ragezonersonexa]

As I'm not good with the database, I am starting the process of translating the client, I'll post soon a translation patch.

If you discover something, a procedure query, post it here, I believe that if all able to work together :D













Updated...

[bubbastic]

* TD_CHAR_EQUIP_S4 by crashbufao *
* USP_CHAR_EQUIP_SAVE_S4 by crashbufao

Those procedures are from me!!

Everything works for me except cardpacks (for the moment) and cauldron (missing procedure).

[Tsukasa]

* TD_CHAR_EQUIP_S4 by crashbufao *
* USP_CHAR_EQUIP_SAVE_S4 by crashbufao

That is from me to. I shared them to crashbufao and asked him to post them here for me oo;

Ah sorry, wouldn't know that from reading the posts - will correct it right away.

Edit for your edit: Incredible progress and work judging from your screenshot. Did you have to create a lot of original procedures to achieve this? How did you work around the client version issue? I'd be thrilled to know more about the way you tackled this project (for educational reasons).

ragezonersonexa, very nice job so far

[bubbastic]

@Tsukasa:
1 more post and you can send MP XD
Please contact me. I need your help to correct the cardpacks. And I can help for missing procedures ;)

@Fasa2008 can you contact me please. I want to talk to you about hexing the projectG

@ragezonersonexa : nice work so far ^^ How did you switch to scratch N°1 instead of cardremovers ?

[KS212]

Hey guys... I'm getting a problem after picking the server, it doesn't go any further. There are no errors on the server windows at all, it just doesn't do anything after picking server. On the gameserver window it does show connection from 127.0.0.1 but that's all, no error.

What's the workaround for this?

[bubbastic]

Hey guys... I'm getting a problem after picking the server, it doesn't go any further. There are no errors on the server windows at all, it just doesn't do anything after picking server. On the gameserver window it does show connection from 127.0.0.1 but that's all, no error.

What's the workaround for this?

read the logfiles in log folders and look for query failed

[ragezonersonexa]

edited

[Tsukasa]

I'll contact you right away.

By the way: For those who are interested in knowing specific item ids the Pangya EU encyclopedia has the item ids embedded in the page source (look for ItemID).

15 posts - yay.