script to siege!

Page 2 of 3

01/01/2010 20:51 naruto820#16

Quote:

Originally Posted by Lanayru

don't thank this guy for nothing it was my friends that did it [Only registered and activated users can see links. Click Here To Register...]

ur wrong, look at the date this was releaseed and look at the date that was released.

01/01/2010 20:57 l2zeo#17

Quote:

Originally Posted by Lanayru

don't thank this guy for nothing it was my friends that did it [Only registered and activated users can see links. Click Here To Register...]

This script not work on year 2010
please fix again.:(

01/01/2010 22:31 janvier123#18

i dont think he made it

Google :)

[Only registered and activated users can see links. Click Here To Register...]
(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 Decima#19

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 augustabyron#20

Quote:

Originally Posted by janvier123

i dont think he made it

Google :)

[Only registered and activated users can see links. Click Here To Register...]
(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 GOD 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 augustabyron#21

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.
[Only registered and activated users can see links. Click Here To Register...]

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 l2zeo#22

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 Decima#23

Quote:

Originally Posted by augustabyron

Sir please look my prblm.

see the image.
[Only registered and activated users can see links. Click Here To Register...]

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 janvier123#24

Google plz,

[Only registered and activated users can see links. Click Here To Register...]

120.000 results, iam sure there is a fix in it

01/02/2010 08:43 l2zeo#25

Quote:

Originally Posted by janvier123

Google plz,

[Only registered and activated users can see links. Click Here To Register...]

120.000 results, iam sure there is a fix in it

It is so difficult...
Are you that whole query should be modified?:facepalm:

01/02/2010 08:52 Decima#26

Quote:

Originally Posted by janvier123

Google plz,

[Only registered and activated users can see links. Click Here To Register...]

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 shit lol

01/02/2010 08:54 l2zeo#27

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 shit lol

Pray good luck.
Is thought that there may be good result.:handsdown:

01/05/2010 05:27 EliteWarrior#28

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 l2zeo#29

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 EliteWarrior#30

Come on people ,i need good siege script without screwing again my database

Page 2 of 3