Register for your free account! | Forgot your password?

You last visited: Today at 23:51

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

Advertisement



how i can do that

Discussion on how i can do that within the SRO Private Server forum part of the Silkroad Online category.

Closed Thread
 
Old   #1
 
Worshiper's Avatar
 
elite*gold: 208
Join Date: May 2017
Posts: 883
Received Thanks: 159
how i can do that

how i can make it not allowed to use this 2 pet together i need when anyone use fellow pet with trans get Dc


Worshiper is offline  
Old 06/05/2017, 10:04   #2
 
KingDollar's Avatar
 
elite*gold: 857
Join Date: Dec 2013
Posts: 857
Received Thanks: 679
you can do it using filter
or maybe sql procedure "not sure"
KingDollar is offline  
Old 06/05/2017, 10:37   #3
 
Worshiper's Avatar
 
elite*gold: 208
Join Date: May 2017
Posts: 883
Received Thanks: 159
i know i need sql procedure i dont like to use it from Filtir or Gaurd
Worshiper is offline  
Old 06/05/2017, 11:14   #4


 
Spidy.'s Avatar
 
elite*gold: 1
Join Date: Oct 2012
Posts: 8,423
Received Thanks: 3,239
Arrow Private SRO Main Discussions / Questions -> Private SRO Ask t…

#moved
Spidy. is offline  
Old 06/05/2017, 11:22   #5
 
Worshiper's Avatar
 
elite*gold: 208
Join Date: May 2017
Posts: 883
Received Thanks: 159
Quote:
Originally Posted by Spidy. View Post
#moved
Ok ty spidy for move you dont know how i can slove this and make when any one use fellow pet with trans take dc ?
Worshiper is offline  
Old 06/06/2017, 14:27   #6
 
elite*gold: 0
Join Date: May 2017
Posts: 108
Received Thanks: 17
LOL as alexiuns said... either u make it through the filter or make it through a sql procedure ...

both would work great .. but the sql procedure would disable the spawn but won't give DC ..
-Prestige.. is offline  
Old 06/06/2017, 14:30   #7
 
Worshiper's Avatar
 
elite*gold: 208
Join Date: May 2017
Posts: 883
Received Thanks: 159
Quote:
Originally Posted by -Prestige.. View Post
LOL as alexiuns said... either u make it through the filter or make it through a sql procedure ...

both would work great .. but the sql procedure would disable the spawn but won't give DC ..
can you help me do it from Procedure can tell me where ?
Worshiper is offline  
Old 06/14/2017, 01:25   #8
 
Worshiper's Avatar
 
elite*gold: 208
Join Date: May 2017
Posts: 883
Received Thanks: 159
Anymore idea from where i can do that in SQL ?
Worshiper is offline  
Old 06/14/2017, 03:07   #9
 
elite*gold: 0
Join Date: Apr 2016
Posts: 286
Received Thanks: 67
Using 2 proc to check this!
_AddNewCOS
_ChangeCOSState
Check using pet from _CharCOS (column State)

Or you can create new Trigger from _CharCOS table
Goodluck !
hoangphan7 is offline  
Old 06/14/2017, 03:36   #10
 
Worshiper's Avatar
 
elite*gold: 208
Join Date: May 2017
Posts: 883
Received Thanks: 159
Quote:
Originally Posted by hoangphan7 View Post
Using 2 proc to check this!
_AddNewCOS
_ChangeCOSState
Check using pet from _CharCOS (column State)

Or you can create new Trigger from _CharCOS table
Goodluck !
thank you i will try it
Worshiper is offline  
Old 06/14/2017, 16:30   #11
 
blapanda's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 757
A simple database modification won't do the trick. At the end, those spawn-items are in the same category, thus, disallowing using the same type simultaneously.

For further information: Remind of that, only one of your growth pets will get exp, while the other one being aesthetical and has not that much of a purpose.
blapanda is offline  
Old 06/14/2017, 20:52   #12
 
Worshiper's Avatar
 
elite*gold: 208
Join Date: May 2017
Posts: 883
Received Thanks: 159
Quote:
Originally Posted by blapanda View Post
A simple database modification won't do the trick. At the end, those spawn-items are in the same category, thus, disallowing using the same type simultaneously.

For further information: Remind of that, only one of your growth pets will get exp, while the other one being aesthetical and has not that much of a purpose.
as you know for now the players make bug with fellow pet with trans and get alot of gold in trade so i dont like it in my server maybe if i dont fix i will remove it
Worshiper is offline  
Old 06/14/2017, 21:13   #13
 
blapanda's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 757
Quote:
Originally Posted by [GM]Dejo View Post
as you know for now the players make bug with fellow pet with trans and get alot of gold in trade so i dont like it in my server maybe if i dont fix i will remove it
Multiple transport vehicles were an injective bug, not a database related one.
Growth pet bug was usually a glitching bug, done inside the Mogao Cave (Dunhuang Cave).

So, yeah. Use a packet filter or remove them.
blapanda is offline  
Old 06/15/2017, 13:42   #14
 
Worshiper's Avatar
 
elite*gold: 208
Join Date: May 2017
Posts: 883
Received Thanks: 159
Quote:
Originally Posted by blapanda View Post
Multiple transport vehicles were an injective bug, not a database related one.
Growth pet bug was usually a glitching bug, done inside the Mogao Cave (Dunhuang Cave).

So, yeah. Use a packet filter or remove them.
oky i will brother thank you for your time to answer me
Worshiper is offline  
Old 06/15/2017, 14:02   #15


 
Spidy.'s Avatar
 
elite*gold: 1
Join Date: Oct 2012
Posts: 8,423
Received Thanks: 3,239
#Closed
Spidy. is offline  
Closed Thread


Similar Threads Similar Threads
Question [HELP ITEM MALL]Some Avatars I can see but can't buy others I can
07/14/2013 - SRO Private Server - 0 Replies
Using a VSRO I followed this guide and ran the search query in that guide to check if the items were in the database. The search came back and it showed that the items were in the database so I skipped the step with the query to add items into the database. I moved on to the step with the query to add items into the item mall. I ran the query and set the servicetag to 1 and the saletag to 0. I tried buying the item again from the mall and it did not work. So I checked the saletag of...
PLEASE......CAN SOMEONE CAN GIVE ME AN ENGINE THAT CAN'T BE DETECTED...
12/30/2009 - Grand Chase Hacks, Bots, Cheats & Exploits - 3 Replies
...GIVE ME AN ENGINE THAT IS N0T DETECTED..... KAHIT NA PANG 5 DAYS LANG !^^...IF YOU ARE FINISH TO READ YOU CAN CLOSED THIS THREAD....>.<:):):):):)
Can someone tell me where I can get...
02/29/2008 - Conquer Online 2 - 4 Replies
a free program to record my desktop. I've seen some videos on this site, but I can't seem to find em anymore.
Who can find ProtocolVersion can teach me
02/22/2005 - Lineage 2 - 1 Replies
Who can find ProtocolVersion can teach me. Please teach me. :cry: ///////////////////////////////////////////////// //// LoginServerIP = 61.90.252.193 LoginServerPort = 2106 ProtocolVersion = *** Please teach me ///////////////////////////////////////////////// ////



All times are GMT +2. The time now is 23:51.


Powered by vBulletin®
Copyright ©2000 - 2024, 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 ©2024 elitepvpers All Rights Reserved.