Vice City: Multiplayer

Server Development => Scripting and Server Management => Topic started by: Nothing on Jul 09, 2015, 10:04 AM

Title: Database
Post by: Nothing on Jul 09, 2015, 10:04 AM
There is ANy Way To Remove All Old Accounts From Database File.
Title: Re: Database
Post by: Mashreq on Jul 09, 2015, 11:00 AM
Add this on your onScriptLoad event.

QuerySQL( db, "DELETE FROM Your_Table_Name" );
Title: Re: Database
Post by: FarisDon on Jul 09, 2015, 12:21 PM
Quote from: Mashreq on Jul 09, 2015, 11:00 AMAdd this on your onScriptLoad event.

QuerySQL( db, "DELETE FROM Your_Table_Name" );
Well i think everytime he open the server.exe will delete his new accounts ._. no?
Title: Re: Database
Post by: KAKAN on Jul 09, 2015, 12:33 PM
Download SQLiteBrowser and ten open ur db files then delete them
Title: Re: Database
Post by: Mashreq on Jul 09, 2015, 12:47 PM
The way in what i meant is that he would add the code once to onscriptload and remove it when the tables gets empty.
Title: Re: Database
Post by: [VSS]Shawn on Jul 09, 2015, 06:36 PM
Nice English
Title: Re: Database
Post by: . on Jul 09, 2015, 06:52 PM
Yeah, select the database file however you want (mouse click or keyboard keys). Keep the Shift key on your keyboard, pressed. And while keeping the shift key pressed, press the 'Del' on your keyboard as well. Not the 'Delete' one (that works too but it's risky). Press 'Yes' on the next dialog. And then select how old the accounts you want to delete on the next dialog.
Title: Re: Database
Post by: EK.IceFlake on Jul 09, 2015, 07:10 PM
Quote from: S.L.C on Jul 09, 2015, 06:52 PMYeah, select the database file however you want (mouse click or keyboard keys). Keep the Shift key on your keyboard, pressed. And while keeping the shift key pressed, press the 'Del' on your keyboard as well. Not the 'Delete' one (that works too but it's risky). Press 'Yes' on the next dialog. And then select how old the accounts you want to delete on the next dialog.
LOL!!! It's going to permanently delete the database file. The easiest way: PM NE.CrystalBlue and ta-daa! (And yeah, he PMed me)