|
You last visited: Today at 16:14
Advertisement
script to siege!
Discussion on script to siege! within the Dekaron Private Server forum part of the Dekaron category.
01/01/2010, 20:51
|
#16
|
elite*gold: 20
Join Date: Mar 2008
Posts: 964
Received Thanks: 232
|
Quote:
Originally Posted by Lanayru
don't thank this guy for nothing it was my friends that did it
|
ur wrong, look at the date this was releaseed and look at the date that was released.
|
|
|
01/01/2010, 20:57
|
#17
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
please fix again
Quote:
Originally Posted by Lanayru
don't thank this guy for nothing it was my friends that did it
|
This script not work on year 2010
please fix again.
|
|
|
01/01/2010, 22:31
|
#18
|
elite*gold: 20
Join Date: Nov 2007
Posts: 2,853
Received Thanks: 1,876
|
i dont think he made it
Google
(look at post date)
ItsNobody script (posted on: 07-14-2009, 03:25 )
chinees post: 2009-05-06 19:11
|
|
|
01/02/2010, 00:42
|
#19
|
elite*gold: 0
Join Date: Aug 2009
Posts: 1,297
Received Thanks: 928
|
first, obviously this was leeched and reposted, see the exact same script, with the exact same bug (space in the word start) on these forums from long ago, now that it is cleared up . . .
i dont think the error is in the actual siege script, but in the function that was already in the DB files that converts the date - FN_DateToShortStrDate
i could be wrong of course, but it seems to me that this function doesnt like the new year at all
**EDIT**
could be this one too - FN_BinDateToDateTime
|
|
|
01/02/2010, 00:47
|
#20
|
elite*gold: 0
Join Date: Nov 2008
Posts: 134
Received Thanks: 8
|
Quote:
Originally Posted by janvier123
i dont think he made it
Google
(look at post date)
ItsNobody script (posted on: 07-14-2009, 03:25 )
chinees post: 2009-05-06 19:11
|
who are real owner of that post it that not importance.
(please back to point of this thread)
cuz i thing we should fix this script work for 2010 and work for every year
but now,i'm still not success, waiting some *** for share idia
Mr.janvier123
could you please extract source code of procedure name "dbo.sp_siege_guild_info_u"
name "dbo.sp_siege_info_R"
name "dbo.sp_siege_defender_u"
for me,i just need too test and compare source betwin my source and your source , Thank you if you can
|
|
|
01/02/2010, 01:01
|
#21
|
elite*gold: 0
Join Date: Nov 2008
Posts: 134
Received Thanks: 8
|
Quote:
Originally Posted by Decima
first, obviously this was leeched and reposted, see the exact same script, with the exact same bug (space in the word start) on these forums from long ago, now that it is cleared up . . .
i dont think the error is in the actual siege script, but in the function that was already in the DB files that converts the date - FN_DateToShortStrDate
i could be wrong of course, but it seems to me that this function doesnt like the new year at all
**EDIT**
could be this one too - FN_BinDateToDateTime
|
Sir please look my prblm.
see the image.
actuly i run and restart my server every day and nothing wrong,
since 27-12-09 i got this error,Why ?
so i run siege script again for fix this prblm
and then i got this error msg
Msg 241, Level 16, State 1, Procedure SP_SIEGE_START_TIME_U, Line 52
Conversion failed when converting date and/or time from character string.
??? why ?
|
|
|
01/02/2010, 03:34
|
#22
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
Is it query problem? .
Quote:
Originally Posted by naruto820
ur wrong, look at the date this was releaseed and look at the date that was released.
|
Is it query problem?
It is said that solved FSG increasing this part
How did you solve?
Have been finding during almost 1 week..
Fairly hard ..ㅜㅜ
|
|
|
01/02/2010, 04:39
|
#23
|
elite*gold: 0
Join Date: Aug 2009
Posts: 1,297
Received Thanks: 928
|
Quote:
Originally Posted by augustabyron
Sir please look my prblm.
see the image.
actuly i run and restart my server every day and nothing wrong,
since 27-12-09 i got this error,Why ?
so i run siege script again for fix this prblm
and then i got this error msg
Msg 241, Level 16, State 1, Procedure SP_SIEGE_START_TIME_U, Line 52
Conversion failed when converting date and/or time from character string.
??? why ?
|
well, duh
everyone is having this problem, and everyone is aware of the error.
its because at some point the datetime conversion made a larger output, which in turn causes the the output not to fit into whatever its being inserted somewhere, in turn throwing the string error, so we have to find where it is
i dunno if that made any sense to anyone, but thats is what i have found so far
|
|
|
01/02/2010, 07:51
|
#24
|
elite*gold: 20
Join Date: Nov 2007
Posts: 2,853
Received Thanks: 1,876
|
Google plz,
120.000 results, iam sure there is a fix in it
|
|
|
01/02/2010, 08:43
|
#25
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
Quote:
Originally Posted by janvier123
Google plz,
120.000 results, iam sure there is a fix in it
|
It is so difficult...
Are you that whole query should be modified?
|
|
|
01/02/2010, 08:52
|
#26
|
elite*gold: 0
Join Date: Aug 2009
Posts: 1,297
Received Thanks: 928
|
Quote:
Originally Posted by janvier123
Google plz,
120.000 results, iam sure there is a fix in it
|
i have googled it to exhaustion. but i think i almost have it figured out, and google didnt help me for **** lol
|
|
|
01/02/2010, 08:54
|
#27
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
Quote:
Originally Posted by Decima
i have googled it to exhaustion. but i think i almost have it figured out, and google didnt help me for **** lol
|
Pray good luck.
Is thought that there may be good result.
|
|
|
01/05/2010, 05:27
|
#28
|
elite*gold: 0
Join Date: Mar 2008
Posts: 257
Received Thanks: 13
|
Damn this error is annoying i screwed up my server! From what i could find in thousands of search results in google is it has to something with 'yyyy-mm-ddThh:mm:ss'. datetime or something when we execute that code in sql it gives another code and since it is in original other language it fails xD
that my guess
EDIT:lucky i was just testing server and not luanched it,i did a clean database script of zombe hope this helps.
EDIT:Working now! But still no siege.If u dont have a live dekaron on dedicated,run the clean database script that zombe posted this one:
Code:
use account;
DELETE FROM C_IP_BAN;
DELETE FROM C_IP_PERMIT;
DELETE FROM C_IP_PWD;
DELETE FROM C_LOGINIPBLOCK_LOG;
DELETE FROM C_SEQUENCE;
DELETE FROM CP_USER_PROFILE;
DELETE FROM MB_USR_IP;
DELETE FROM MB_USR_PUN;
DELETE FROM Tbl_user;
DELETE FROM USER_CONNLOG_KEY;
DELETE FROM USER_PROFILE;
GO
use billing;
DELETE FROM bl_error_log;
DELETE FROM c_sequence;
DELETE FROM dba_online_daily;
DELETE FROM dba_online_daily_notok;
DELETE FROM Tbl_KeepId;
DELETE FROM user_account;
DELETE FROM user_account;
DELETE FROM user_charge_log;
DELETE FROM user_everyday_use_info;
DELETE FROM user_give_log;
DELETE FROM user_use_log;
DELETE FROM user_use_log_bk;
GO
use cash;
DELETE FROM bl_error_log;
DELETE FROM Tbl_Cash_zj;
DELETE FROM user_cash;
DELETE FROM user_charge_log;
DELETE FROM user_use_log;
GO
use character;
DELETE FROM C_EVENT_ITEM_OP
DELETE FROM c_restword;
DELETE FROM char_connlog;
DELETE FROM CHAR_CONNLOG_KEY;
DELETE FROM DEL_USER_CHAR_LIST;
DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
DELETE FROM GM_ITEM_MST;
DELETE FROM GUILD_CHAR_INFO;
DELETE FROM GUILD_INFO
WHERE guild_code NOT LIKE 'MASTERCODE';
DELETE FROM GUILD_INFO_SECEDE;
DELETE FROM GUILD_PEERAGE
WHERE guild_code NOT LIKE 'MASTERCODE';
DELETE FROM MSSNGR_CHAR_LIST;
DELETE FROM SIEGE_INFO;
DELETE FROM SIEGE_RESULT_LOG;
DELETE FROM user_bag
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_bag_copy;
DELETE FROM user_bag_secede;
DELETE FROM user_character
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_character_secede;
DELETE FROM USER_POSTBOX;
DELETE FROM USER_POSTBOX_SECEDE;
DELETE FROM User_Quest_Doing;
DELETE FROM user_quest_doing_secede;
DELETE FROM User_Quest_Done;
DELETE FROM user_quest_done_secede;
DELETE FROM user_skill
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_skill_secede
DELETE FROM user_slot
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_storage;
DELETE FROM user_storage_copy;
DELETE FROM USER_STORE;
DELETE FROM USER_STORE_copy;
DELETE FROM USER_STORE_SECEDE;
DELETE FROM user_suit
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_suit_copy;
DELETE FROM user_suit_secede;
GO
|
|
|
01/05/2010, 07:09
|
#29
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
although is my ideas
Quote:
Originally Posted by EliteWarrior
Damn this error is annoying i screwed up my server! From what i could find in thousands of search results in google is it has to something with 'yyyy-mm-ddThh:mm:ss'. datetime or something when we execute that code in sql it gives another code and since it is in original other language it fails xD
that my guess
EDIT:lucky i was just testing server and not luanched it,i did a clean database script of zombe hope this helps.
EDIT:Working now! But still no siege.If u dont have a live dekaron on dedicated,run the clean database script that zombe posted this one:
|
although is my ideas
Code:
set @v_strDate1=dbo.FN_BinDateToDateTime(@v_siege_start_time)
that connection is with here
Code:
SELECT @v_siege_start_time = SUBSTRING(@v_siege_start_date,4,1) * 100000000
+ SUBSTRING(@v_siege_start_date,5,2) * 1000000
+ SUBSTRING(@v_siege_start_date,7,2) * 10000
+ SUBSTRING(@v_siege_start_date,9,2) * 100
+ SUBSTRING(@v_siege_start_date,11,2)
problem does itneundeut on this part
will should like to know correctly what result appears..
someone does not inform correct solution
|
|
|
01/05/2010, 21:30
|
#30
|
elite*gold: 0
Join Date: Mar 2008
Posts: 257
Received Thanks: 13
|
Come on people ,i need good siege script without ******** again my database
|
|
|
Similar Threads
|
[RELEASE] Siege Script for every 3day,1week and twice a month
03/20/2013 - Dekaron Private Server - 25 Replies
Hit thanks if you like :)
|
Please help siege script
08/31/2010 - Dekaron Private Server - 27 Replies
when i run siege script i got this error msg.
Msg 241, Level 16, State 1, Procedure SP_SIEGE_START_TIME_U, Line 52
Conversion failed when converting date and/or time from character string.
Why i try to run siege srcipt again ? !!!
cuz i got this error.
http://upic.me/i/gb/siegeerror.jpg
|
Help Change Siege Time ( Full Script )
07/20/2010 - Dekaron Private Server - 2 Replies
hello , i got my siege time on my test server start on sunday 21:00 server time ,
can someone please tell me how to change it to saturday 21:00 ? with the full script replacement.
Thanks, Zakurin
|
All times are GMT +2. The time now is 16:14.
|
|