Register for your free account! | Forgot your password?

You last visited: Today at 15:02

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


[VSRO188] Reworked Auto-Equipment [QUERIES]

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Aug 2008
Posts: 53
Received Thanks: 42
[VSRO188] Reworked Auto-Equipment [QUERIES]

First of all, credits go to DePiedra for creating this. Although I found many, many bugs within his queries and decided to rework it and actually make it work.

This system adds NORMAL +4 gears to chars with added Str/int blues. These can be changed in the procedure & trigger.

Let's go

### Table ###

Create this table which contains the gear which will be given to the chars on level up:


### Table contents ###

The table contains 2D-9D normal gears. You can always add new gears to the table if you wish to reward players with different gears (sox for instance).


### Procedure ###

Execute the following query to create the required procedure:

### Trigger ###

Execute the following query to create a trigger on _Char table, which gives chars specific gears based on their level. I based it on lvl 13-99, you can always change this.


That's it

If you need help customizing it, feel free to contact me.



brklol is offline  
Thanks
5 Users
Old 03/26/2017, 00:34   #2
 
elite*gold: 950
Join Date: Aug 2015
Posts: 1,721
Received Thanks: 957
nice query m8


B1Q is online now  
Old 03/26/2017, 00:40   #3
 
elite*gold: 0
Join Date: Aug 2008
Posts: 53
Received Thanks: 42
Quote:
Originally Posted by B1QB0SS :3 View Post
nice query m8
nice you read through it that fast?
brklol is offline  
Thanks
1 User
Old 03/26/2017, 11:58   #4
 
elite*gold: 15
Join Date: Nov 2016
Posts: 451
Received Thanks: 112
nice work dud but are you sure he is completed ?


JekaBlue is offline  
Old 03/26/2017, 12:56   #5
 
elite*gold: 40
Join Date: Jul 2010
Posts: 64
Received Thanks: 6
works
lordshreck is offline  
Old 03/26/2017, 18:10   #6
 
elite*gold: 0
Join Date: Aug 2008
Posts: 53
Received Thanks: 42
Quote:
Originally Posted by JekaBlue View Post
nice work dud but are you sure he is completed ?
I had issues before but fixed them and tested on pretty much all levels.. so should be workin. tell me if u find any bugs
brklol is offline  
Old 03/26/2017, 22:20   #7
 
elite*gold: 15
Join Date: Nov 2016
Posts: 451
Received Thanks: 112
I add it into my test server but it,s not working idk why ?
JekaBlue is offline  
Old 03/27/2017, 00:00   #8
 
elite*gold: 0
Join Date: Aug 2008
Posts: 53
Received Thanks: 42
Quote:
Originally Posted by JekaBlue View Post
I add it into my test server but it,s not working idk why ?
Any errors? is your char lvl 13++?
brklol is offline  
Old 03/27/2017, 17:21   #9
 
elite*gold: 0
Join Date: Feb 2009
Posts: 366
Received Thanks: 89
Quote:
Originally Posted by JekaBlue View Post
I add it into my test server but it,s not working idk why ?
it works very well but u didnt insert the required Lines to _ItemPoolAutoEquipment for all items .
nemo08 is offline  
Old 03/30/2017, 13:09   #10
 
elite*gold: 0
Join Date: Aug 2008
Posts: 53
Received Thanks: 42
updated, fixed an issue with lvl 18-20 gear
brklol is offline  
Old 03/30/2017, 17:04   #11
 
elite*gold: 0
Join Date: Feb 2017
Posts: 26
Received Thanks: 8
well, at least a trigger wont be that big deal causing a serious lag
like in the case of massively calling _AddLogChar
Mangetsu|| is offline  
Old 04/03/2017, 18:36   #12
 
elite*gold: 0
Join Date: Oct 2014
Posts: 166
Received Thanks: 25
bolts have bug bolts change to shield pleaase fix fast and how i can change normal set to sun
revldo1 is offline  
Old 04/03/2017, 19:59   #13
 
elite*gold: 54
Join Date: Mar 2010
Posts: 311
Received Thanks: 54
System bad

Trigger = Bug _char

khaleed2010 is offline  
Old 04/10/2017, 05:57   #14
 
elite*gold: 0
Join Date: Mar 2013
Posts: 57
Received Thanks: 4
Thanks
nour_eldin is offline  
Old 08/13/2017, 12:18   #15
 
elite*gold: 0
Join Date: Mar 2009
Posts: 102
Received Thanks: 14
thank you
but i have a problem
its work but when the char get lvl 13++ stuck no cant use return.rev cant move any help


Donjiwan is offline  
Reply


Similar Threads
[VSRO188] (Job)Coin/Gift reward system [QUERIES]
04/08/2017 - SRO PServer Guides & Releases - 13 Replies
Hi guys, I've been working on this for a while. This system currently rewards players on unique kills, converts job contribution into coins/giftsilk, on completion of certain quests. To use the reward on unique kill, I personally use Evangelion gameserver (Thanks cherno) as it records unique kills to a table in SRO_VT_ACCOUNT. So I based my procedures/triggers on Evangelion. Downloads links will be provided on the bottom of the post. Requirements: - If you want to use (MY) unique...
Maul-Online D11 / Auto System / Auto Equipment / Uniuqe Rank / Auto Event Fun
01/26/2015 - SRO PServer Advertising - 5 Replies
Welcome to Maul-Online official thread! I'm proud to finally present to you the server we spent long time working hard on just to keep it well-established Maul-Online online is based on Vsro files Server Will lunched 22/01/2015 Server : Online We Are Here To Represent To You A Server Which Is The Best Old School Server With The Old iSro Features .
Maul-Online D11 / Auto System / Auto Equipment / Uniuqe Rank / Auto Event Fun
01/25/2015 - SRO PServer Advertising - 51 Replies
http://i.epvpimg.com/pcfKe.jpg Welcome to Maul-Online official I'm proud to finally present to you the server we spent long time thread! working hard on just to keep it well-established Online-Online online is based on Vsro files Server is lunched 22/01/2015 Server time : Online http://i.epvpimg.com/V53Ge.png



All times are GMT +1. The time now is 15:02.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.