Register for your free account! | Forgot your password?

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

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

Advertisement



Need a Query to counting and adding some values.

Discussion on Need a Query to counting and adding some values. within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jun 2015
Posts: 64
Received Thanks: 10
Need a Query to counting and adding some values.

Hey Folks!
I will appreciate if some1 write for me that query <3

So i have 2 tables dbo.SK_Silk in SRO_VT_ACCOUNT and dbo.UniqueRanking in SRO_VT_SHARD:

dbo.SK_Silk look like that
JID ||silk_own||silk_gift||silk_point||
1300||.......500||.........0||............0||
1320||.......100||.........0||............0||

dbo.UniqueRanking looks like that:
Charname||Score||Unique1|| etc etc etc
test.........||..150||..........2|| etc etc etc
test1.......||....75||..........1|| etc etc etc

So i need a query wich adding mean getting "Score" from dbo.UniqueRanking and "+" it to "silk_own" , example -> Score from test(charname column) + silk_own(of right char). I want this guery be a global query for all users. I hope you know what i want

Thx
szokersonik is offline  
Reply


Similar Threads Similar Threads
[Release]Query fast adding item to npc.
05/21/2016 - SRO PServer Guides & Releases - 12 Replies
Today I'd like to share a query with you. This query will quickly add an item to an NPC - test it and rate it. USE ----------By Nefetis-------------- DECLARE @PRICETYPE VARCHAR (70) DECLARE @PRICE VARCHAR (70) DECLARE @TAB VARCHAR (70) DECLARE @CODENAME128 VARCHAR (70) DECLARE @OPTLEVEL VARCHAR (70)
[Query Help] Adding item to inventory
04/15/2013 - SRO Private Server - 7 Replies
Hello, a simple question , how would a query be if i want to add a specific item to a player's inventory(not a new player) .. thanks in advanced
Query for adding silk for new accounts
04/27/2012 - SRO PServer Guides & Releases - 1 Replies
Hi Guy's :mofo: $ jidque = @ mssql_fetch_array (@ mssql_query ("SELECT * FROM WHERE dbo.TB_User StrUserID = '$ user'")); jidque realjid = $ $ ; $ silkver = mssql_query ("INSERT INTO SK_Silk (JID, Silk_own) values ​​('$ realjid', '1000000 ')"); yourself who is the name of the variable $ user to record, edit account id. '1000000 'Is the amount of silk box unchecked in the record section of your website, add and change.
Requesting a query for adding new columns in db
01/28/2012 - SRO Private Server - 3 Replies
Hi i'm requesting a query to add more columns into a table, i need 3 more columns at shardservice since cleaned the db it only appears one column atm. So if anyone got one feel free to post it. Thanks in advance!
Adding Pets Query
05/03/2010 - EO PServer Hosting - 0 Replies
Ok So I Know This Is Me Being Lazy In A Way And Maybe Asking A Bit Much But What I Got To Lose Lol? Can Some 1 Make A Guide Of Just The Db Query And Actions And With What Needs To Be Put In And Changed EveryTime You Wanna Add A Pet? Cq_Action Is Whats Really Gettin Me COnfused I have Tried



All times are GMT +1. The time now is 23:57.


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.