Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Tool] MSSQL Commands

http://kalserverace.com
Loyal Member
Joined
Sep 12, 2006
Messages
477
Reaction score
17
4 MSSQL Scripts.

Just like to say Thank you to DarkZONE for telling me some of this info.
(DB cleaner and Log cleaner)

Ask if you need any help.

PS: Remove "SA" and replace it with your own DB's name.

IP Checker - Checks if a players IP address is in the Server more than 1x.
PHP:
SELECT ip, acct_name count
FROM ip_log
GROUP BY ip, acct_name
HAVING count(*) > 1
ORDER BY ip

AUTH/DB Cleaner - This restores your AUTH/DB Tables back before your server started.
PHP:
TRUNCATE TABLE "banned_ips"
TRUNCATE TABLE "BuffRemain"
TRUNCATE TABLE "Event"
TRUNCATE TABLE "Friend"
TRUNCATE TABLE "Guild"
TRUNCATE TABLE "GuildAlliance"
TRUNCATE TABLE "GuildCastle"
TRUNCATE TABLE "GuildMember"
TRUNCATE TABLE "GuildWar"
TRUNCATE TABLE "Item"
TRUNCATE TABLE "ItemRestored"
TRUNCATE TABLE "Log"
TRUNCATE TABLE "Mail"
TRUNCATE TABLE "MLM"
TRUNCATE TABLE "MLMMsg"
TRUNCATE TABLE "NameChanged"
TRUNCATE TABLE "PKBulletin"
TRUNCATE TABLE "Player"
TRUNCATE TABLE "PlayerDeleted"
TRUNCATE TABLE "Quest"
TRUNCATE TABLE "ReservedName"
TRUNCATE TABLE "Shortcut"
TRUNCATE TABLE "Skill"
TRUNCATE TABLE "Statistics"
TRUNCATE TABLE "Teleport"
TRUNCATE TABLE "user_ips"
TRUNCATE TABLE "AuthStatistics"
TRUNCATE TABLE "CLogin"
TRUNCATE TABLE "CNum"
TRUNCATE TABLE "ExpTable"
TRUNCATE TABLE "GuildRank"
TRUNCATE TABLE "IP"
TRUNCATE TABLE "iplog"
TRUNCATE TABLE "ItemBuy"
TRUNCATE TABLE "ItemBuy_backup"
TRUNCATE TABLE "ItemDetail"
TRUNCATE TABLE "ItemInfo"
TRUNCATE TABLE "Log"-
TRUNCATE TABLE "Login"
TRUNCATE TABLE "LoginDeleted"
TRUNCATE TABLE "NMLogin"
TRUNCATE TABLE "NMLogin2"
TRUNCATE TABLE "Notice"
TRUNCATE TABLE "PrizeWinner"
TRUNCATE TABLE "Rank"
TRUNCATE TABLE "ResetPK"
TRUNCATE TABLE "Statistics"

Log Cleaner - You know them 1GB files? well this cleans them out.
PHP:
To Clear Logs.

Use Master
go

Backup Log [SA] with truncate_only
go

Use [SA]
go

DBCC shrinkfile ([SA_Log], 2)
go

-- data
Use Master
go

Backup Log [SA] with truncate_only
go

Use [SA]
go

DBCC shrinkfile ([SA_Data], 1)
go

-- Get fileid
use [SA]
go

select * from sysfiles

DB Back up to more than 1 file at a time.
PHP:
BACKUP DATABASE [SA] TO
DISK = N'C:\databace\SA.bak',  
DISK = N'C:\SA.bak',  
DISK = N'D:\SA.bak' 

WITH INIT, FORMAT,  NAME = N'SA-Full Database Backup', 
SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
 
Arrogant Wizard
Loyal Member
Joined
Mar 30, 2007
Messages
745
Reaction score
34
Re: [Release] / [Tool] MSSQL Commands

AUTH/DB Cleaner - This restores your AUTH/DB Tables back before your server started.
No, it trunicates your tables. Restore means to restore data in them, not delete data.

And you should explain precisely WHAT log you're cleaning. Because the transaction log you're cleaning then removes the ability to do a rollback.
 
Experienced Elementalist
Joined
Sep 29, 2006
Messages
247
Reaction score
0
Re: [Release] / [Tool] MSSQL Commands

No, it trunicates your tables. Restore means to restore data in them, not delete data.

And you should explain precisely WHAT log you're cleaning. Because the transaction log you're cleaning then removes the ability to do a rollback.

Father-DeathArt :-DD hehe... GURU of MSSQL etc...
 
http://kalserverace.com
Loyal Member
Joined
Sep 12, 2006
Messages
477
Reaction score
17
Re: [Release] / [Tool] MSSQL Commands

hey hey hey... i was told it was some logs... thats it.
 
Arrogant Wizard
Loyal Member
Joined
Mar 30, 2007
Messages
745
Reaction score
34
Re: [Release] / [Tool] MSSQL Commands

lol.. you're releasing SQL scripts, not knowing what they do...
 
Junior Spellweaver
Joined
Nov 18, 2006
Messages
184
Reaction score
10
Re: [Release] / [Tool] MSSQL Commands

hes right ace if some 1 was to run the log cleaner on there db with out knowing what the hell it does it will duck it up
 
Kal Craker
Joined
Apr 29, 2006
Messages
173
Reaction score
6
Re: [Release] / [Tool] MSSQL Commands

ty ace ;) ya and dont use that if u dont know what to do :D
 
http://kalserverace.com
Loyal Member
Joined
Sep 12, 2006
Messages
477
Reaction score
17
Re: [Release] / [Tool] MSSQL Commands

ty ace ;) ya and dont use that if u dont know what to do :D

sooo right... last night was fun... LOL... restoring a fucked up DB useing the MDFs... LOL...

and thank you.
 
Back
Top