.... I need Backup!

Quit being dramatic. They do nothing.

Sparks wrote:We need a mass cleanup of bot accounts soon to be honest, that counter is rising rapidly every day.

I don't think you realize how long that would take.

Omniary: fuck you anglerfish can't smell
Dr. Trialtrex21: how you know bitch
Omniary: it probably could smell you though
could probably smell your fucking dank ass nasty powersuit structure gel trog ass enslaved protein bullshit sloshing in your suit from a mile away

Trialtrex21 wrote:

Sparks wrote:We need a mass cleanup of bot accounts soon to be honest, that counter is rising rapidly every day.

I don't think you realize how long that would take.

I have been poking around on some sql code lately, so depending on how he types in the search and show criteria, it should only show bot account, which can then be quick and easily truncated ( deleted ) from the database.

Getting rid of spam account is pretty easy on my part.

Sparks wrote:I have been poking around on some sql code lately,

Sparks you know code? Or are you just poking around on the sql database?

Sparks wrote: which can then be quick and easily truncated ( deleted ) from the database.

Seems like a strategy.

mrpeanut188 wrote:

Sparks wrote:I have been poking around on some sql code lately,

Sparks you know code? Or are you just poking around on the sql database?

Sparks wrote: which can then be quick and easily truncated ( deleted ) from the database.

Seems like a strategy.

SELECT * FROM Usertable
WHERE Username IS mrpeanut188


Results:

Username Password AccountID
mrpeanut188 ********* 152


Or like this:

SELECT Username FROM Usertable
WHERE Username IS mrpeanut188


Results:

Username
mrpeanut188

At least thats how my SQL classes went.

Sparks wrote:

mrpeanut188 wrote:

Sparks wrote:I have been poking around on some sql code lately,

Sparks you know code? Or are you just poking around on the sql database?

Sparks wrote: which can then be quick and easily truncated ( deleted ) from the database.

Seems like a strategy.

SELECT * FROM Usertable
WHERE Username IS mrpeanut188


Results:

Username Password AccountID
mrpeanut188 ********* 152


Or like this:

SELECT Username FROM Usertable
WHERE Username IS mrpeanut188


Results:

Username
mrpeanut188

At least thats how my SQL classes went.

Thank you sparks for hinting us how many digits Peanut's password has.

And about that Soulzarath, I don't have access to the site's database, I don't even know if it has a table named Username.
The amount of stars i put in my post was a random number, just to show how the result could have looked like.

Sparks wrote:And about that Soulzarath, I don't have access to the site's database, I don't even know if it has a table named Username.
The amount of stars i put in my post was a random number, just to show how the result could have looked like.

........

Some men just want to watch the world burn.