Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server > SRO PServer Guides & Releases
You last visited: Today at 11:20

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

Advertisement



Largest Collection Of Queries For PSRO Development [[ Updated ]]

Discussion on Largest Collection Of Queries For PSRO Development [[ Updated ]] within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: May 2011
Posts: 365
Received Thanks: 380
Post Largest Collection Of Queries For PSRO Development [[ Updated ]]

A query to set item price/currency

A query to change account ID.

A query to edit mastery level.

A query to edit spawn place of a unique/mob


A query to enable D12~13

A query to clean logs. (Default logs-You gotta add any other tables for new systems and so)


A query to clean SHARD.

A query to clean accounts from db.

Media Pk2 Script

Query to get codes from media.
For Itemdataxxx.txt
For Characterdataxxx.txt

Adding new HWAN (TitleNames)

A query to add new spots for uniques.

A query for Privileged IP.

A query to edit level of a character.

A query to remove all player's Pk Stat.

A query to remove pk by charname.

A query to give items to a player.

A query to change MaxmiumStuck Amount

A query to add new drops to a unique or a mob.

A query to reset skills for a player.

A query to search an item in a char.

A query to add teleports.

A query to send all characters to Jangan(Can be edited to the pos.you like).

A query to edit Job Exp Rates.

A query to remove item from Db[ByCode].

A query to disable EU items(For old school svs)


A query to remove MSG limit(20-->unlimited).

A query to add honor buffs to a char(has to get honor enabled first).

A query to ban by char name.

A query to fix FGW Envy/Unique Spawns.

A query that pays FortressWar Gold @ Storage.
After you run this query set the gold amount here and run this one.

Query to insert lines to a table from a "txt" file.

Query to disable alchemy materials.

Query to change 'Stone' Success Rate.

Query to fix "Purification" pill bug.

Query to increase mob spawn rate(DONT USE IT WITH 1 GS)

*Can be edited to decrease / remove spawn rate too.
//Hint *2

Add new 'NPC'[Store]

Add a new tab to "NPC"

Add a new group"NPC"

Query to add an item to all characters.


Query to add a union limit.

Query to add a guild members limit
Gonna add every single query that is going to be released on any sro forums here..
Will be updated 'continuously'.

Regards.
Learning Squirrel.*

You can always press Thanks if i helped.
khaledlollol is offline  
Thanks
57 Users
Old 02/10/2014, 08:31   #2

 
Haxor's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 3,777
Received Thanks: 1,455
#Approved
Haxor is offline  
Thanks
1 User
Old 02/10/2014, 10:06   #3
 
elite*gold: 0
Join Date: May 2011
Posts: 365
Received Thanks: 380
Quote:
Originally Posted by Haxor View Post
#Approved
Thanks for approving
khaledlollol is offline  
Old 02/10/2014, 12:21   #4
 
matrixasd2's Avatar
 
elite*gold: 0
Join Date: Oct 2007
Posts: 522
Received Thanks: 134
useful Query's For Beginner .
matrixasd2 is offline  
Thanks
1 User
Old 02/10/2014, 12:24   #5
 
elite*gold: 0
Join Date: May 2011
Posts: 365
Received Thanks: 380
Quote:
Originally Posted by matrixasd2 View Post
useful Query's For Beginner .
That's why i am working on this collection i will add every query working for vsro files the ones that worth Maybe one day i get my thread @ Sticky Threads
khaledlollol is offline  
Thanks
1 User
Old 02/10/2014, 14:08   #6
 
elite*gold: 41
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,195
keep going
Crue* is offline  
Thanks
3 Users
Old 02/10/2014, 18:45   #7
 
bxxb's Avatar
 
elite*gold: 0
Join Date: Jan 2010
Posts: 696
Received Thanks: 148
I'm glad that you still give a **** about this ****** community all the respect man : P and keep going with the good work
bxxb is offline  
Thanks
2 Users
Old 02/10/2014, 20:48   #8
 
Justin1337*'s Avatar
 
elite*gold: 480
Join Date: Jan 2012
Posts: 655
Received Thanks: 579
Thanks a lot dude.
Justin1337* is offline  
Thanks
1 User
Old 02/11/2014, 00:34   #9
 
elite*gold: 0
Join Date: May 2011
Posts: 365
Received Thanks: 380
Thanks you all


Quote:
Originally Posted by bxxb View Post
I'm glad that you still give a **** about this ****** community all the respect man : P and keep going with the good work
Well i am still on of it so why don't i cooperate with smth beside this helps me learning,i am new to the dev-things so this helps alot

#Updated#
Adding few more querys
khaledlollol is offline  
Old 02/12/2014, 13:35   #10
 
elite*gold: 0
Join Date: May 2011
Posts: 365
Received Thanks: 380
Updated Again.
khaledlollol is offline  
Thanks
1 User
Old 02/12/2014, 18:28   #11
 
KingDollar's Avatar
 
elite*gold: 857
Join Date: Dec 2013
Posts: 857
Received Thanks: 679
nice collection for beginners
KingDollar is offline  
Thanks
1 User
Old 02/12/2014, 22:46   #12
 
elite*gold: 0
Join Date: May 2011
Posts: 365
Received Thanks: 380
Quote:
Originally Posted by Alexiuns* View Post
nice collection for beginners
There's always beginners
khaledlollol is offline  
Thanks
1 User
Old 02/13/2014, 03:07   #13
 
Justin1337*'s Avatar
 
elite*gold: 480
Join Date: Jan 2012
Posts: 655
Received Thanks: 579
Add these =)
Justin1337* is offline  
Old 02/14/2014, 08:47   #14
 
elite*gold: 0
Join Date: May 2011
Posts: 365
Received Thanks: 380
Quote:
Originally Posted by Justin1337* View Post
Add these =)
Thanks for co-operating <3

If there's any query you would like me to add to this collection you can PM/Write a comment with it.
Will be tested and added directly ^_^.
khaledlollol is offline  
Thanks
2 Users
Old 02/14/2014, 20:36   #15
 
Justin1337*'s Avatar
 
elite*gold: 480
Join Date: Jan 2012
Posts: 655
Received Thanks: 579
Quote:
Originally Posted by khaledlollol View Post
Thanks for co-operating <3

If there's any query you would like me to add to this collection you can PM/Write a comment with it.
Will be tested and added directly ^_^.
Ok bro, will do. =)
Justin1337* is offline  
Reply


Similar Threads Similar Threads
Star Wars: The Old Republic EA's Largest Ever Development Project
03/20/2010 - Gaming News - EN - 2 Replies
Star Wars: The Old Republic is one of the most ambitious MMORPG projects in quite some time and EA chief banker Eric Brown isn't hiding the fact that the project is EA's largest undertaking ever. Eurogamer reports that the chief banker stated in a meeting with Wedbush Morgan Securities in New York that the MMORPG is the "largest ever development project, period, in the history of the company". That's quite a statement when compared to some of EA's other projects, including MMORPGs such as...



All times are GMT +1. The time now is 11:20.


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.