i get error for enter NICKNAME and dbo.USP_NICKNAME_UPDATE not found
how can i save ~ i try to use the code for page 5 but not work
THANK~I SAVE
other error ~can't see the sever list how can i do
i get error for enter NICKNAME and dbo.USP_NICKNAME_UPDATE not found
how can i save ~ i try to use the code for page 5 but not work
THANK~I SAVE
other error ~can't see the sever list how can i do
Last edited by o800920; 13-12-10 at 12:57 PM.
update serve state query failed (game serve) D: help me please
luizhill, you've finally hit ntreev's questionable programming.
Yes, ever since today some of their badly-written conversions for dates are triggering errors.
You have to fix it in *every* stored procedure in the databases.
*** EDIT 3: You don't have to. Simply set the language for the user in the database to English and it should work as well. ***
How to do it?
Let's take Pangya_S4_TH's [ProcUpdateServerState]...
Running the procedure with test data will reveal a problem on line 171 (which happens to be at the very end of the file).
Looking at the line you should notice two CONVERT() statements... Now, you can find out which of these statements is defect by doing the following steps:
Copy each statement into a new query and select it (SELECT CONVERT(...)) and execute it. If the return values are kosher - it's all good. Or not? You also have to take a look at the table structure. Notice that the first of the two values is expected to be a datetime. Why they even convert a datetime to datetime is beyond me, but changing it to use a datetime directly will help:
[...]@ParanUser, GETDATE(), CONVERT(VARCHAR(16)[...]
Rinse and repeat for every other stored procedure and custom data type and you're good to go.
Last edited by Tsukasa; 13-12-10 at 06:52 PM. Reason: PS: I like editing
not got it . do not know much about sql 2005 D: ;'(
Note: As a cheapo fix for those who don't want to wait you can also set the date of the machine the SQL server runs on to -1 week from now and it should work again. But that's really not feasonable or acceptable workaround ;)
anyone have a solution for query or something? . for (update serve state query failed) sorry my bad english =/
1.can someone teach me where can add cookies and pang and make gm account
2.where can i find the @UID , uid=userid??
Tsukasa thank you friend i'm have problem in serve version D: do not create room
Okay, quick fix that should also work: If you don't want to edit all procedures, you can also set the language for the user you connect with (i.e. sa) to English and it shouldn't complain anymore. I think this is the best way.
luizhill: You need to hex your ProjectG.exe and replace the version 582.00 with 582.05 :)
Last edited by Tsukasa; 13-12-10 at 06:51 PM.
Tsukasa thank you :D perfect
thanks to all who contribute and fix query and tips. thanks!
Question 1 : Can i make room and start the game in one player only?
Question 2 : This server and client works without internet connection? Cuz when i shutdown the internet connection, client wont start.
Last edited by gigok; 14-12-10 at 01:20 AM.
Can anyone help me to create the server? Please add me on messenger henrique_r_moura@hotmail.com
I need help!
Does this work with the latest version of pangya TH? (582.06 i think it is)
account when I create the same game, just after choosing nickname and change hair color, clothing character ... does not appear to enter the server ...
more, when I create the same account by sql (pangya_member_info) appears normal and to get in, but without character, and nothing bat.
Can someone please help? I'm desperate
've reinstalled the server are 10x
(I ran all the fixes)
@Tsukasa
Originally Posted by gigok
