| Author |
Topic |
|
gabe3550
Starting Member
5 Posts |
 Posted - 2011-05-29 : 00:29:11
|
| 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
746 Posts |
Posted - 2011-05-29 : 02:10:17
|
| is this microsoft sql server?which RPG game? |
 |
|
|
gabe3550
Starting Member
5 Posts |
Posted - 2011-05-29 : 03:17:34
|
| Glory of Rome on Facebook, takes no software to download. |
|
|
|
padders
Starting Member
3 Posts |
Posted - 2011-06-14 : 14:54:31
|
| 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? |
|
|
|
gabe3550
Starting Member
5 Posts |
Posted - 2011-06-16 : 04:06:15
|
| Is that Padders from AND? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-06-16 : 04:19:40
|
| 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?- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
gabe3550
Starting Member
5 Posts |
Posted - 2011-06-16 : 06:19:46
|
| 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 |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-06-16 : 06:35:29
|
| 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.- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
padders
Starting Member
3 Posts |
Posted - 2011-06-16 : 10:17:10
|
| 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. |
|
|
|
gabe3550
Starting Member
5 Posts |
Posted - 2011-06-16 : 11:57:52
|
| 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,UserId1,1,City,Amaranth,5,Spathic,274245,FORSAKEN,Normal,20206681,2,Woods,---,3,---,---,---,Normal,---1,3,Woods,---,1,Spathic,274245,FORSAKEN,Normal,20206681,4,City,Colonia17JRC,1,Newbius-17JRC,70,(No Alliance),Normal,20318161,5,City,Colonia13NIC,1,Newbius-13NIC,80,(No Alliance),Normal,18500522,1,Hill,---,4,---,---,---,Normal,---2,2,Bog,---,8,---,---,---,Normal,---2,3,Grassland,---,6,Bellenickna,725786,HONOR_N_GLORY_2,Normal,15410212,4,City,Colonia19L40,1,Newbius-19L40,95,(No Alliance),Beginner Protection,21268802,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,20675044,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,20350085,2,City,Colonia16B3O,1,Newbius-16B3O,90,(No Alliance),Normal,19739405,3,Mountain,---,3,---,---,---,Normal,---5,4,City,Colonia19DYO,1,Newbius-19DYO,70,(No Alliance),Beginner Protection,21176165,5,City,Colonia17X7C,1,Newbius-17X7C,80,(No Alliance),Normal,2049240Let me know if this helps Lumbago :) |
|
|
|
padders
Starting Member
3 Posts |
Posted - 2011-06-17 : 08:25:27
|
| 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. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-20 : 06:53:14
|
| Moving this thread to Other Topics. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-06-20 : 08:21:05
|
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" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
I need a way to map my game.