Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 05:43

  • Please register to post and access all features, it's quick, easy and FREE!

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.

Reply
 
Old   #1
 
Syloxx's Avatar
 
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
Syloxx is offline  
Thanks
1 User
Old 08/28/2014, 15:12   #2

 
鳳凰城's Avatar
 
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
鳳凰城 is offline  
Old 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?
Pci is offline  
Old 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...
Timlock is offline  
Thanks
1 User
Old 08/28/2014, 15:59   #5
 
Syloxx's Avatar
 
elite*gold: 56
Join Date: Oct 2013
Posts: 1,165
Received Thanks: 774
Quote:
Originally Posted by Timlock View Post
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 View Post
sql procedures executed upon changes in shard tables.
u mean smt like a.... trigger?
Syloxx is offline  
Old 08/28/2014, 16:27   #6
 
gigola123's Avatar
 
elite*gold: 0
Join Date: Jun 2007
Posts: 722
Received Thanks: 390
Quote:
Originally Posted by Timlock View Post
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..
gigola123 is offline  
Old 08/28/2014, 18:00   #7
 
elite*gold: 0
Join Date: Aug 2014
Posts: 48
Received Thanks: 10
Quote:
Originally Posted by gigola123 View Post
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?
Exorcī𐌔t is offline  
Old 08/28/2014, 19:04   #8
 
gigola123's Avatar
 
elite*gold: 0
Join Date: Jun 2007
Posts: 722
Received Thanks: 390
Quote:
Originally Posted by Exorcī𐌔t View Post
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.
gigola123 is offline  
Thanks
1 User
Old 08/30/2014, 23:42   #9


 
​Exo's Avatar
 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
Quote:
Originally Posted by gigola123 View Post
I said it's impossible with SQL Only, but it's possible in other way, look the exemple which I gave.
I got you..
​Exo is offline  
Old 09/01/2014, 00:23   #10
 
@$$'s Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 734
Received Thanks: 88
if some one using mBot instanly Dc
@$$ is offline  
Old 09/01/2014, 05:55   #11
 
elite*gold: 0
Join Date: Feb 2008
Posts: 962
Received Thanks: 650
Quote:
Originally Posted by @$$ View Post
if some one using mBot instanly Dc
You can do that without SQL. Simple changes to the sro_client and Gateway/Agent.
magicanoo is offline  
Old 09/01/2014, 11:49   #12
 
Syloxx's Avatar
 
elite*gold: 56
Join Date: Oct 2013
Posts: 1,165
Received Thanks: 774
Quote:
Originally Posted by @$$ View Post
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
Syloxx is offline  
Old 09/01/2014, 12:28   #13


 
​Exo's Avatar
 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
Quote:
Originally Posted by @$$ View Post
if some one using mBot instanly Dc
It's the SRO_CLIENT not the database.
​Exo is offline  
Old 09/02/2014, 01:07   #14
 
@$$'s Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 734
Received Thanks: 88
Thanks guys i got it :-)
@$$ is offline  
Reply


Similar Threads 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.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.