About RanLog

[dexter833]

Dear RAN Developers,

My RanLog Database is so heavy now.
What will happen if I will delete my existing RanLog DB
and replace with fresh empty new RanLog DB?

Pls help sir! Thank You

 

[PrinceOfPersia]

Dear RAN Developers,

My RanLog Database is so heavy now.
What will happen if I will delete my existing RanLog DB
and replace with fresh empty new RanLog DB?

Pls help sir! Thank You

You delete you ranlog anytime when your server is offline.
Just replace it with a fresh one.

 

[dexter833]

Then sir if my existing RanLog DB will be deleted.
What will happen to the items and money of the players?
It will disappear or lost sir?

 

[denvee]

just run this query i think it will clear out the logs and not delete it..

USE RanLog
Truncate table "ItemList"
Truncate table "LogAction"
Truncate table "LogExchangeFlag"
Truncate table "LogHackProgram"
Truncate table "LogItemExchange"
Truncate table "LogItemMax"
Truncate table "LogMakeType"
Truncate table "LogServerState"
Truncate table "SKillList"

thats what i use every maintenance and my ranlog is only 4mb..2mb if shrink

 

[dexter833]

@denvee

Sir but still Ok to delete the existing RanLog DB?
Theres no error at in game if I will delete RanLog DB and replace with new one? It will nnot affect in game characters?
Because honestly sir I dont know how to configure the code you gave

 

[tearhear18]

@denvee

Sir but still Ok to delete the existing RanLog DB?
Theres no error at in game if I will delete RanLog DB and replace with new one? It will nnot affect in game characters?
Because honestly sir I dont know how to configure the code you gave

Open your Sql then New Query
Paste this codes:
USE RanLog
Truncate table "ItemList"
Truncate table "LogAction"
Truncate table "LogExchangeFlag"
Truncate table "LogHackProgram"
Truncate table "LogItemExchange"
Truncate table "LogItemMax"
Truncate table "LogMakeType"
Truncate table "LogServerState"
Truncate table "SKillList"

then execute ^_^ DONE

 

[denvee]

@denvee

Sir but still Ok to delete the existing RanLog DB?
Theres no error at in game if I will delete RanLog DB and replace with new one? It will nnot affect in game characters?
Because honestly sir I dont know how to configure the code you gave

you will not loose anything ingame... but you will get alot of errors in your server files.... like cannot find blah blah in DB blah blah....

trust me i did this once and i regreted it... do not delete ranlog.