Some Useful Tips To Avoid "Lag - Crash " CaptainHerlock

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 :D

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 :

Quote:

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

thanks trusted1234 for the code :P

Quote:

Originally Posted by Anime Creature ou should really backup your db first, because if you use this Code: 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 :

Quote:

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

thanks again trusted1234 for the code :P

Third Tip :

- Close Your Anti Virus :D .

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 :

Quote:

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 . :D

Best Wishes

TSK

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.

Quote:

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 ?

Quote:

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.

Quote:

Originally Posted by TheSuperKiller - Delete every row have value 0 at owner_id and stop if you see the value -

Sql query :

Quote:

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

Thx nice thread :)

Quote:

Originally Posted by trusted1234 Sql query : Thx nice thread :)

nice 1 mate :)

And if you want delete all not precise WHERE ;)

Quote:

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

Quote:

Originally Posted by trusted1234 And if you want delete all not precise WHERE ;)

I was thinking of putting it :P

if all of that dont work restore telecaster

ou should really backup your db first, because if you use this
it will also empty everything in the warehouses (storage)
=)

free bump :p

Quote:

Originally Posted by cranK337 free bump :p

is there any "paid" bumbs ? :pimp:

btw : new Tips added

bumb

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?