SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 Other Topics
 I need a way to map my game.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gabe3550
Starting Member

USA
5 Posts

Posted - 05/29/2011 :  00:29:11  Show Profile  Reply with Quote
Its just a stupid side project, but I would just like to get my foot in the right direction. I am playing an online RPG, that is SQL. I would simply like to have a way to map out the domain. The Domain is 800x800, I would just like something to give me the available data of each coordinate.

If you have any information, or anything that can help please respond or email me.

Thank you,
Gabe

slimt_slimt
Aged Yak Warrior

Switzerland
746 Posts

Posted - 05/29/2011 :  02:10:17  Show Profile  Reply with Quote
is this microsoft sql server?
which RPG game?
Go to Top of Page

gabe3550
Starting Member

USA
5 Posts

Posted - 05/29/2011 :  03:17:34  Show Profile  Reply with Quote
Glory of Rome on Facebook, takes no software to download.
Go to Top of Page

padders
Starting Member

Spain
3 Posts

Posted - 06/14/2011 :  14:54:31  Show Profile  Reply with Quote
I would also be very interested in this.Is it possible? As above, could you reply here or mail me with any advice or info please?
Go to Top of Page

gabe3550
Starting Member

USA
5 Posts

Posted - 06/16/2011 :  04:06:15  Show Profile  Reply with Quote
Is that Padders from AND?
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 06/16/2011 :  04:19:40  Show Profile  Reply with Quote
I don't understand the question. What do you mean by "map out the domain"? Can you give an example of your expected output and possibly also the input if any?

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/
Go to Top of Page

gabe3550
Starting Member

USA
5 Posts

Posted - 06/16/2011 :  06:19:46  Show Profile  Reply with Quote
Each part of the 800x800 domain has information, what type of item it is, player information, etc. Roughly about 6 items per square. I know for a fact that someone has made this already I just don't know what or how they made it with. What I would expect for the output is the listed information of each coordinate. On an excel spread sheet or a txt file. Let me know if that helps. Thanks Gabe
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 06/16/2011 :  06:35:29  Show Profile  Reply with Quote
I still don't have a clue about what you want to do but then again I'm not familiar RPG or Glory of Rome. If you want some real help post a sample table with sample data and what you want to get out of a query.

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/
Go to Top of Page

padders
Starting Member

Spain
3 Posts

Posted - 06/16/2011 :  10:17:10  Show Profile  Reply with Quote
lol yeah Gabe, looks like we are looking for the Holy Grail huh?
im a little out of my depth here to be honest but its worth a shot.
Go to Top of Page

gabe3550
Starting Member

USA
5 Posts

Posted - 06/16/2011 :  11:57:52  Show Profile  Reply with Quote
Well Between me and you Padders, I heard a rumor that UKoR has a way, and I know for a fact that TOR had em, BTW this is THE_FARMER Ex-TOR, VC of Kashyyyk. Good to meet you, and your reputation precedes you :). This is a sample output data of the mapping software I am looking to replicate.X,Y,Type,CityName,Level,Player,Glory,Alliance,Status,UserId
1,1,City,Amaranth,5,Spathic,274245,FORSAKEN,Normal,2020668
1,2,Woods,---,3,---,---,---,Normal,---
1,3,Woods,---,1,Spathic,274245,FORSAKEN,Normal,2020668
1,4,City,Colonia17JRC,1,Newbius-17JRC,70,(No Alliance),Normal,2031816
1,5,City,Colonia13NIC,1,Newbius-13NIC,80,(No Alliance),Normal,1850052
2,1,Hill,---,4,---,---,---,Normal,---
2,2,Bog,---,8,---,---,---,Normal,---
2,3,Grassland,---,6,Bellenickna,725786,HONOR_N_GLORY_2,Normal,1541021
2,4,City,Colonia19L40,1,Newbius-19L40,95,(No Alliance),Beginner Protection,2126880
2,5,Grassland,---,3,---,---,---,Normal,---
3,1,Grassland,---,3,---,---,---,Normal,---
3,2,River,---,5,---,---,---,Normal,---
3,3,River,---,5,---,---,---,Normal,---
3,4,River,---,6,---,---,---,Normal,---
3,5,River,---,4,---,---,---,Normal,---
4,1,Hill,---,4,---,---,---,Normal,---
4,2,City,Colonia18BAO,1,Newbius-18BAO,100,(No Alliance),Normal,2067504
4,3,Barbarian Camp,---,4,---,---,---,Normal,---
4,4,Hill,---,5,---,---,---,Normal,---
4,5,Mountain,---,5,---,---,---,Normal,---
5,1,City,Colonia17M80,2,Newbius-17M80,1210,(No Alliance),Normal,2035008
5,2,City,Colonia16B3O,1,Newbius-16B3O,90,(No Alliance),Normal,1973940
5,3,Mountain,---,3,---,---,---,Normal,---
5,4,City,Colonia19DYO,1,Newbius-19DYO,70,(No Alliance),Beginner Protection,2117616
5,5,City,Colonia17X7C,1,Newbius-17X7C,80,(No Alliance),Normal,2049240

Let me know if this helps Lumbago :)
Go to Top of Page

padders
Starting Member

Spain
3 Posts

Posted - 06/17/2011 :  08:25:27  Show Profile  Reply with Quote
lol thanks for the kind words man..........I didnt know ToR had it or UkR......i know for sure someone else does so i know its possible.
It would be great to take to the different world we are in.
I hope Lumbago can come up with something.....as it's all going way over my head at the moment.
Go to Top of Page

robvolk
Most Valuable Yak

USA
15668 Posts

Posted - 06/20/2011 :  06:53:14  Show Profile  Visit robvolk's Homepage  Reply with Quote
Moving this thread to Other Topics.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30242 Posts

Posted - 06/20/2011 :  08:21:05  Show Profile  Visit SwePeso's Homepage  Reply with Quote
quote:
Originally posted by gabe3550

Its just a stupid side project...

quote:
Originally posted by gabe3550

I would simply like to have a way to map out the domain.

What is the server ip-address? What is the Username and Password?

I am sure you don't want us to hack an application?



N 56°04'39.26"
E 12°55'05.63"

Edited by - SwePeso on 06/20/2011 08:21:42
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36941 Posts

Posted - 06/20/2011 :  11:53:01  Show Profile  Visit tkizer's Homepage  Reply with Quote
This is not something that would be done in "SQL". If you wanted to screen scrape the game, then you'll want to ask your question somewhere else. Or you'll need to provide better information.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.73 seconds. Powered By: Snitz Forums 2000