Some Useful Tips To Avoid "Lag - Crash " CaptainHerlock

[TheSuperKiller]

hi every body :

we all "or alot of us :P " suffer from lag or crash of CaptainHerlock.exe .

I have some tips I found them myself ,,, and made a lot of difference

first of all , back up your database "I didn't :P " .
Then close your server "if working "

First Tip "cleaning up dumb items "

** " you may do this more than one time " I recommend do it before open your server every time .

- open your SQL .
- open Telescar .
- open table .
- go to dbo.item
- open edit rows
- u will see alot of rows ,
- go to owner_id
- Delete every row have value 0 at owner_id and stop if you see the value - changed to 1 or more

or simply execute this code :

DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0

GO

thanks trusted1234 for the code :P

Originally Posted by Anime Creature

ou should really backup your db first, because if you use this

DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0

it will also empty everything in the warehouses (storage)
=)

Second tip "Cleaning all buffs from all players " :

" you may do this more than one time " I recommend do it before open your server every time .

- open your SQL .
- open Telescar .
- open table .
- open dbo.state
- open edit rows
- Delete all rows .

or just execute this code :

DELETE FROM [Telecaster].[dbo].[State]

GO

thanks again trusted1234 for the code :P

Third Tip :

- Close Your Anti Virus .

Fourth Tip :

- Close your firewall .

Fifth Tip :

- Close all unneeded programs .

Sixth Tip :

- Close all unneeded windows services " not recommended if u don't know "

Eightieth Tip :

- Clean AutoAuctionResource from db .

just execute this code :

DELETE FROM [Telecaster].[dbo].[AutoAuctionResource]

GO

Last Tip :

- if all of these are not woking , just restore your db .



Other Tips .......
Give us your tips to add them here .

Best Wishes

TSK

[Pyrok]

There's a table in Arcadia named AutoAuction or something along those lines. Delete all the rows in it and the server will stop adding those items at startup.

[TheSuperKiller]

Originally Posted by Pyrok

There's a table in Arcadia named AutoAuction or something along those lines. Delete all the rows in it and the server will stop adding those items at startup.

AutoAuctionResourse ??
AuctionGatagoreyResouse ??

or both ?

[Pyrok]

Originally Posted by TheSuperKiller

AutoAuctionResourse ??
AuctionGatagoreyResouse ??

or both ?

I think it's just AutoAuctionResource. I'm not at home so I can't verify it for sure but I know it isn't the category one.

[trusted1234]

Originally Posted by TheSuperKiller

- Delete every row have value 0 at owner_id and stop if you see the value -

Sql query :

DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0

GO

Thx nice thread

[TheSuperKiller]

Originally Posted by trusted1234

Sql query :



Thx nice thread

nice 1 mate

[trusted1234]

And if you want delete all not precise WHERE

DELETE FROM [Telecaster].[dbo].[State]

GO

[TheSuperKiller]

Originally Posted by trusted1234

And if you want delete all not precise WHERE

I was thinking of putting it :P

[zero911]

if all of that dont work restore telecaster

[Anime Creature]

ou should really backup your db first, because if you use this

DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0

it will also empty everything in the warehouses (storage)
=)

[cranK337]

free bump

[TheSuperKiller]

Originally Posted by cranK337

free bump

is there any "paid" bumbs ?

btw : new Tips added

[TheSuperKiller]

bumb

[xeroax]

For some reason i can't restore my telecaster database. It keeps saying that something is using it, even when everything is closed. Anyone know whats wrong?