[Adjusting Database]Step 1 : Removing empty accounts

[LastThief*]

Hey guys how're you doing ?.I hope you're all fine.
Since I'm still developing the SQLDev (Yea I didn't post the progress yet) I'm programming database cleaner php based so here is the first function that I've coded

PHP Code:

<?php
function CleanDBACC()
{
$query = $this->Query("DELETE FROM TB_User WHERE NOT EXISTS (SELECT * FROM  SR_ShardCharNames WHERE SR_ShardCharNames.UserJID=TB_User.JID)");
if(...//
}
?>

Here we go that query

DELETE FROM TB_User WHERE NOT EXISTS (SELECT * FROM SR_ShardCharNames WHERE SR_ShardCharNames.UserJID=TB_User.JID)

You can execute it to clean useless accounts from database and have clean database to prevent some lags ;p


If you copied don't forget to credit me

Ciao,
LastThief

[AceSpace]

Originally Posted by LastThief*

Hey guys how're you doing ?.I hope you're all fine.
Since I'm still developing the SQLDev (Yea I didn't post the progress yet) I'm programming database cleaner php based so here is the first function that I've coded

<?php
function CleanDBACC()
{
$query = $this->Query("DELETE FROM TB_User WHERE NOT EXISTS (SELECT * FROM  SR_ShardCharNames WHERE SR_ShardCharNames.UserJID=TB_User.JID)");
if(...//
}
?>

Here we go that query



You can execute it to clean useless accounts from database and have clean database to prevent some lags ;p


If you copied don't forget to credit me

Ciao,
LastThief

Thanks, Could you edit the code like

[•ᵔBeGodOfWarᵔ•]

Oh, thanks ! Very useful ..

[BestOnWorld]

thanks

[FoxRayz]

Thanks, You're delivering good stuff as always