[Question] What you need (SQL Queries)

Hey Guys,

I'm just bored and I have no idea what I could "code", so what do you need (SQL Queries).

I´ll release simple queries / optimization for free.

Syloxx

Someone's planing to release something

Faith in sro community restored

How i can kill u ?
DROP TABLE Syloxx?

sql table data change monitor. sql procedures executed upon changes in shard tables.

or

I have another sql project if your interested... its just time consuming. Its just creation of a bunch of select/update/insert queries i have not had the time to complete...

Quote:

Originally Posted by Timlock I have another sql project if your interested... its just time consuming. Its just creation of a bunch of select/update/insert queries i have not had the time to complete...

what kind of sql project ?

Quote:

Originally Posted by Timlock sql procedures executed upon changes in shard tables.

u mean smt like a.... trigger? :D

Quote:

Originally Posted by Timlock sql table data change monitor. sql procedures executed upon changes in shard tables. or I have another sql project if your interested... its just time consuming. Its just creation of a bunch of select/update/insert queries i have not had the time to complete...

In sql it's impossible to make a project like that O.O you can also make a prog which will loop on EVERY table of the database or listen EVERY query made on all table of the database, it's will consume just TOO MUCH. And there is trigger for that :') ... so..

Quote:

Originally Posted by gigola123 In sql it's impossible to make a project like that O.O you can also make a prog which will loop on EVERY table of the database or listen EVERY query made on all table of the database, it's will consume just TOO MUCH. And there is trigger for that :') ... so..

Nothing is impossible it's all about is it worth it?
And ye there's already a ready to use trigger so why bothering yourself with creating something already made?

Quote:

Originally Posted by Exorcī𐌔t Nothing is impossible it's all about is it worth it? And ye there's already a ready to use trigger so why bothering yourself with creating something already made?

I said it's impossible with SQL Only, but it's possible in other way, look the exemple which I gave.

Quote:

Originally Posted by gigola123 I said it's impossible with SQL Only, but it's possible in other way, look the exemple which I gave.

I got you..

if some one using mBot instanly Dc

Quote:

Originally Posted by @$$ if some one using mBot instanly Dc

You can do that without SQL. Simple changes to the sro_client and Gateway/Agent.

Quote:

Originally Posted by @$$ if some one using mBot instanly Dc

keep X-Trap enabled and u´ll get after 10min a DC

Reason:

mbot disable X-Trap and after a check "hey yo is X-Trap running" the client wont response and u´ll get a dc

and its with SQL btw not possible

Quote:

Originally Posted by @$$ if some one using mBot instanly Dc

It's the SRO_CLIENT not the database.

Thanks guys i got it :-)