|
You last visited: Today at 05:43
Advertisement
[Question] What you need (SQL Queries)
Discussion on [Question] What you need (SQL Queries) within the SRO Private Server forum part of the Silkroad Online category.
08/28/2014, 15:08
|
#1
|
elite*gold: 56
Join Date: Oct 2013
Posts: 1,165
Received Thanks: 774
|
[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
|
|
|
08/28/2014, 15:12
|
#2
|
elite*gold: 273
Join Date: Aug 2012
Posts: 4,451
Received Thanks: 2,429
|
Someone's planing to release something
Faith in sro community restored
|
|
|
08/28/2014, 15:21
|
#3
|
elite*gold: 16
Join Date: Feb 2014
Posts: 45
Received Thanks: 32
|
How i can kill u ?
DROP TABLE Syloxx?
|
|
|
08/28/2014, 15:38
|
#4
|
elite*gold: 2
Join Date: Aug 2011
Posts: 833
Received Thanks: 1,130
|
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...
|
|
|
08/28/2014, 15:59
|
#5
|
elite*gold: 56
Join Date: Oct 2013
Posts: 1,165
Received Thanks: 774
|
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?
|
|
|
08/28/2014, 16:27
|
#6
|
elite*gold: 0
Join Date: Jun 2007
Posts: 722
Received Thanks: 390
|
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..
|
|
|
08/28/2014, 18:00
|
#7
|
elite*gold: 0
Join Date: Aug 2014
Posts: 48
Received Thanks: 10
|
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?
|
|
|
08/28/2014, 19:04
|
#8
|
elite*gold: 0
Join Date: Jun 2007
Posts: 722
Received Thanks: 390
|
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.
|
|
|
08/30/2014, 23:42
|
#9
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
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..
|
|
|
09/01/2014, 00:23
|
#10
|
elite*gold: 0
Join Date: Mar 2010
Posts: 734
Received Thanks: 88
|
if some one using mBot instanly Dc
|
|
|
09/01/2014, 05:55
|
#11
|
elite*gold: 0
Join Date: Feb 2008
Posts: 962
Received Thanks: 650
|
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.
|
|
|
09/01/2014, 11:49
|
#12
|
elite*gold: 56
Join Date: Oct 2013
Posts: 1,165
Received Thanks: 774
|
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
|
|
|
09/01/2014, 12:28
|
#13
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
Quote:
Originally Posted by @$$
if some one using mBot instanly Dc
|
It's the SRO_CLIENT not the database.
|
|
|
09/02/2014, 01:07
|
#14
|
elite*gold: 0
Join Date: Mar 2010
Posts: 734
Received Thanks: 88
|
Thanks guys i got it :-)
|
|
|
 |
Similar Threads
|
[SQL] Unterschiede in den Queries
10/13/2012 - Web Development - 0 Replies
Guten Abend zusammen!
Ich bräuchte sämtliche Unterschiede im Syntax für folgende DB Systeme:
MSSQL
Oracle
PostgreSQL
SQLITE 3
CUBRID
InterBase / FireBird
MongoDB
|
New Mt2 Hairstyles queries please?
08/15/2012 - Metin2 Private Server - 1 Replies
Hey,
I need the *FULL* queries for ALL the korean hairstyles i got all of them hairstyles but few of them dont work because no queries for them were added, can u help me please if at least once in your life? thank u:)
|
Some Usefull Queries
01/16/2012 - SRO Private Server - 2 Replies
Clean Shard DB
Other Query
To Import Text Files
|
Need Queries for DB
04/29/2011 - Metin2 Private Server - 2 Replies
Anyone have?
<Item vnum="9090" hashName="'Ascia Unicorno+0'" name="Ascia Unicorno+0" type="1" subtype="0" weight="0" size="2" antiflag="312" flag="1" wearflag="16" immuneflag="0" gold="20000" buy_price="20000" limittype0="1" limitvalue0="40" limittype1="0" limitvalue1="0" applytype0="7" applyvalue0="15" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="95" value2="105" value3="103" value4="116" value5="0" socket0="0" socket1="64992" socket2="127"...
|
Queries and Quandries
04/17/2011 - General Gaming Discussion - 9 Replies
Over the last few months, I have noticed a lot of you popping in and saying things like "Is there a bot like Heavenfire?" or "Why can't yours do this feature that Heavenfire could do?" or my favorite one, "Heavenfire did this, yours is broken." Consider this first. Heavenfire was the idea of a coder who worked on Hero as it was being developed, so he had not only inside knowledge of how Hero worked, he also had access to the original designs.
The bots you see here are the result of hard work...
|
All times are GMT +1. The time now is 05:43.
|
|