[RELEASE]TEMPORARY (MAYBE OFFICIAL) FIX FOR SIEGE/DF ERRORS

01/13/2010 13:52 daddycool.#16
Yeah, i have tested it now... start the siege, and the date goes to year 2000 ... maybe need to remove the statement

Code:
ELSE
SELECT	@v_strtime	= '200' + CAST(CAST(@i_bin_time as int) as varchar(20))
I go test now and make some changes.
01/13/2010 14:18 Zombe#17
Quote:
Originally Posted by Darth Nerd View Post
Yeah, i have tested it now... start the siege, and the date goes to year 2000 ... maybe need to remove the statement

Code:
ELSE
SELECT	@v_strtime	= '200' + CAST(CAST(@i_bin_time as int) as varchar(20))
I go test now and make some changes.
More like change 200 to 201
01/13/2010 15:44 l2zeo#18
Quote:
Originally Posted by Darth Nerd View Post
Yeah, i have tested it now... start the siege, and the date goes to year 2000 ... maybe need to remove the statement

Code:
ELSE
SELECT	@v_strtime	= '200' + CAST(CAST(@i_bin_time as int) as varchar(20))
I go test now and make some changes.
good luck...! :handsdown:
01/17/2010 20:22 xfactorbowler#19
got it working now ;)
02/06/2010 06:23 alexzzzzz#20
I just ran it, ill post if it work for me :)

Thanks ahead of time!

oh and i translated the top part of the script...

Code:
/************************************************* *****************************
   2 Name: dbo.FN_BinDateToDateTime
   Description: Binary Date returns a DateTime format.
   Returns:
   History:
   Ver Date Author Description
   --------- ---------- --------------- ---------------- --------------------
   1.0 2006-05-05 Han Ji Wook 1. Initial creation
   2.0 2010-01-10 ADM-Cyrax/Darth Nerd
 ************************************************** ****************************/
02/09/2010 00:23 alexzzzzz#21
So far it has made the server crash whenever a DF anncouncemnt for starting or when DF starts.

xD
02/09/2010 02:47 daddycool.#22
Well, i have see a lot of pservers using this script and doesn't have these errors... maybe you need to cleanup your DB, re-run the siege script and re-check your server files configuration.
02/09/2010 03:12 xfactorbowler#23
it works fine on my server no crashes or nothin, and are you sure that all you files match for the df, could have simply not added a csv somewhere.
02/09/2010 03:19 Scotticus#24
Works fine on my server aswell LOL xD
02/21/2010 14:37 lol2k11#25
thanks dude it works .! 100%
02/21/2010 16:10 MMOPerfectionİ#26
Pfft, i know a way better fix, set the machine the servrer is hosted off
date to january 2009 :P
02/21/2010 20:13 Farmer John#27
Quote:
Originally Posted by *Cake* View Post
Pfft, i know a way better fix, set the machine the servrer is hosted off
date to january 2009 :P
You noob, give proper credit><
02/21/2010 20:56 daddycool.#28
Quote:
Originally Posted by *Cake* View Post
Pfft, i know a way better fix, set the machine the servrer is hosted off
date to january 2009 :P
If works to you, congrats... :handsdown:
02/21/2010 21:07 MMOPerfectionİ#29
Quote:
Originally Posted by Farmer John View Post
You noob, give proper credit><
ofc credit goes to Farmer John and his l33t discoveries
02/22/2010 00:22 Farmer John#30
Quote:
Originally Posted by *Cake* View Post
ofc credit goes to Farmer John and his l33t discoveries
woo, 12thx's I'm almost christian now. and yea, for some just reset ur machine's time/date back to january 1, 2009 and let it follow through as normal, then just reset as the next year passes. worked for me, but idk if for everyone.