Printable View
uhm, correct me if i'm wrong, but as far as i can read, this is all about deleting EMPTY accounts... so FT1FT1 tell me, what are those all procedures for if on empty account are NO characters? maybe I am a moron, but i think that "empty" means that there is nothing there. Am i right or am I wrong?
i have some kinde of erorr i have 1 acc with unredabal info maybe somone ca help me to Delete it
Server: Msg 823, Level 24, State 2, Line 23
I/O error (torn page) detected during read at offset 0x00000001334000 in file 'C:\Muserver\db\MuOnline_data.mdf'.
Connection Broken
he just included in this topic an sql proc to delete accounts empty or not including guild entry,warehouse,log file etc. "wipe clean" an account
Please need SQL code will remove all accounts that there is Blocked. Thanks
OK Mr.Quote:
Originally Posted by methodm
As all can see u r very low experiensed on DB stuff
Lets say that Someone go to your server and get an account set... then one or two character and a guild, put some items on warehouse and get into DS and BC a few times. After that he get bored and delete all characters.
Results: Your procedure will detect the account as an NO CHARACTER account but will leave orphan records inside atleast 20 tables..
One more example:
Some one setup an account using your website, it will create records in 2 tables (MEMB_INFO and MEMB_DETA) and your procedure will leave some data at MEMB_DETA since your are deleting only MEMB_INFO.
so.. use your own if u dont like mine but look at the facts
Good job u guys ... but I have a problem with delete unused accounts
CREATE PROCEDURE [dbo].[FT1WEB_DELETE_UNUSED_ACCOUNTS]
AS
DECLARE @ACC VARCHAR(10)
DECLARE LISTA CURSOR LOCAL FOR
SELECT TOP 100 PERCENT UserID
FROM dbo.LOG_UserLogin
GROUP BY UserID
HAVING (MAX(LoginTM) < DATEADD(D,-30,GETDATE()))
ORDER BY MAX(LoginTM)
OPEN LISTA
FETCH NEXT FROM LISTA INTO @ACC
WHILE @@FETCH_STATUS = 0
BEGIN
EXECUTE FT1WEB_DELETE_ACCOUNT @ACC
FETCH NEXT FROM LISTA INTO @ACC
END
CLOSE LISTA
DEALLOCATE LISTA
GO
in this code there is reference to a table called LOG_UserLogin ... my problem is I don't have that table ?!
I'm using it on a 0.97d server (the one downloaded from rz)
Thank you!
Sorry but tell me where i put that codes ;(
up! That's a must for every server
Any idea how to get in to them to change it?
okay for FT1FT1's code, i got an error
This is the first procedure error
This is the second procedureCode:Server: Msg 207, Level 16, State 3, Procedure FT1WEB_DELETE_CHARACTER, Line 9
Invalid column name 'character'.
Server: Msg 207, Level 16, State 3, Procedure FT1WEB_DELETE_ACCOUNT, Line 51
Invalid column name 'character'.
Can somone help me pelase >.<Code:Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'FT1WEB_DELETE_ACCOUNT'. The stored procedure will still be created.
Server: Msg 2714, Level 16, State 5, Procedure FT1WEB_DELETE_UNUSED_ACCOUNTS, Line 23
There is already an object named 'FT1WEB_DELETE_UNUSED_ACCOUNTS' in the database.
Cannot add rows to sysdepends for the current stored proced
somone please help me -.-""
Good day to all!
First thing is, the code works fine, but when i ran it, my sql has been running for 3daysnow. is this normal? my server is on a standby mode. no one can play yet... :(
Thanks in advance.
where is the final undisputed code?
I ask for that 2! I tried to run this code and it deleted all my 500 accounts :D <-- Probably my fault :D
nice work guys you all seem to know your stuff with sql query anyway i got one for you soon that we are on the subject i would not have a clue on how to do it yet but I need to have all my server characters inventories vaults and web vault items deleted can any of you guys help me out will be much appreciated :D
:thumbup: