PlaneShift

Support => Technical Help: IN GAME bugs (after loading world) => Topic started by: Neryam on September 20, 2005, 02:38:26 pm

Title: Character Database. Can we access it?
Post by: Neryam on September 20, 2005, 02:38:26 pm

I was wondering if it would be possible to gain access to a read only account in the database, see what I want to do is to get a automatically updating list of every member in our guild on our website..

That would be fantastically cool. :P

I do know PHP and a bit of MySQL, but what is that database\'s operating system/software type thingy? Would it even be possible to do this?

If it is possible all I would need is (If its MySQL) the format of the table. (And if its not MySQL) the code to get a PHP array of the characters in our guild.. :/

Title:
Post by: Drey on September 20, 2005, 03:01:07 pm

i dont think you will get to look at the data base... then you get to learn private things, like people alts or emails.. things they might not want you to know.

Title:
Post by: DaveG on September 20, 2005, 10:25:39 pm

Not to mention the location and properties of every item, NPC, and what-have-you in the game...  :P

Title:
Post by: Stronith on September 20, 2005, 10:35:12 pm

Quote

Originally posted by Neryam what I want to do is to get a automatically updating list of every member in our guild on our website..

I think that it is possible to some degree, as I came across a guild\'s website that had a live listing of players online (all guilds).

I cannot recall the guild\'s name, but I know it was live, as I was on the list when I checked it.

Good luck.

Title:
Post by: DaveG on September 20, 2005, 11:30:33 pm

Some stuff is publicly accessible:

Character Stats (http://laanx.fragnetics.com/index.php?page=char_stats)
Guild Stats (http://laanx.fragnetics.com/index.php?page=guild_stats)
Server Stats (Soft) (http://gandalf.fragnetics.com/stats/awstats.pl?config=planeshift)
Server Stats (Hard) (http://gandalf.fragnetics.com/status/)

Title:
Post by: Leeloo on September 21, 2005, 09:05:25 am

Readonly access is not fun. I want full write access...

UPDATE players SET trias = trias*1000 WHERE username = \'Leeloo\' :P

Don\'t worry, I won\'t do a DROP SERVER.

Title:
Post by: Neryam on September 21, 2005, 10:39:11 am

Hahaha lmao :P

Really?? Some guild did that!? Ahhh must ask whoever did it O_o

Any mods or WTBs or Acraig gonna answer this question fully and concisely?? :D

Title:
Post by: Draklar on September 21, 2005, 10:57:46 am

Yeah... Wasn\'t it Blitzers that had some neat informations out of database somewhere?

Title:
Post by: lanser on September 21, 2005, 11:43:21 am

Ruby Warriors (http://ruby.tricospeb.net/) is one site and it looks like they have polled the Char_Stats page and cross referenced a guild membership db.

@Neryam I am surprised that a Guild your size doesn\'t already have a db if not it must be hard to keep track of your members :)

Title:
Post by: Drey on September 21, 2005, 12:57:03 pm

yeah, you can do some stuff not that i know how. but i dont think you need acess to the thing?

Title:
Post by: stfrn on September 21, 2005, 01:02:39 pm

Quote

I was wondering if it would be possible to gain access to a read only account in the database,

No. There are... well, pretty much no one who even has access to read any of the DB directly. Even GMs can only do what ingame commands allow, etc.

However, if you want a list, in theory that could be setup on the laanx website. However, directly accessing the game DB? Really, that\'s not practical.

Title:
Post by: Neryam on September 21, 2005, 02:07:23 pm

lanser: Broken link? :(

Yay stfrn! Yes, if possible a list would be just perfect, although will it just be static or can the info be accessed from elsewhere and displayed alsewhere? Static is fine, just wondering.

:D

I just want a list, don\'t care how it\'s done :P

Title:
Post by: lanser on September 21, 2005, 03:41:40 pm

Quote

Originally posted by Neryam
lanser: Broken link? :(

Sorry it was working when I posted because I checked :(

however you could try one of the ruby warriors in game IIRC Bobus is the leader.

*seems the whole tricospeb.net site is down atm

Title:
Post by: Rage McCloud on September 22, 2005, 01:00:15 am

In all cases i do not want anything personal on there... maybe my CHARACTERS stats or HIS life story but not mine...

Title:
Post by: Neryam on September 22, 2005, 10:08:14 am

All I want is a dynamic list of all the characters in Guild Knights, so lol don\'t worry. X( :P

Title:
Post by: lanser on September 22, 2005, 02:14:22 pm

Quote

Originally posted by lanser
Ruby Warriors (http://ruby.tricospeb.net/) is one site and it looks like they have polled the Char_Stats page and cross referenced a guild membership db.

Back online right now if you\'re still interested

*typo

Title:
Post by: Neryam on September 22, 2005, 02:58:23 pm

Yay! WHOAH that\'s exactly what I wanted!! Ive never ever seen those guys though :(

Must find out.. or stfrn can just tell me :P

Title:
Post by: Arka on September 22, 2005, 03:30:17 pm

Talk to Bobuzz - He will be able to tell you. :)

Title:
Post by: Neryam on September 22, 2005, 03:55:25 pm

Ah! Ruby Warriors!

Bobuzz or Bobus? I added both. :D

Title:
Post by: acraig on September 23, 2005, 04:41:59 am

It *might* be possible to do something like this but would probably involve something like:

laanx.fragnetics.com/char_viewer.php?name=yourchar&password=yourpassword

So I am not sure how comfortable people would be in sending their password in a url like that.  The other issue is the bandwidth usage. If people want to host this data than everytime somebody views a page it hits the laanx server for an update.

If people want this data for guild websites or something I can generate an xml document that has a list of characters.  The guild would have to be impressive enough, though, to warrent my time on it :)

----------------
Andrew

Title:
Post by: Neryam on September 23, 2005, 11:20:01 am

Well we are the largest and most active guild in PS :D Hows that :P
http://laanx.fragnetics.com/index.php?page=guild_stats Guild Knights

Thanks Acraig! Well there could be just a list of all the members in the guild, but mabye it could show who\'s online in the guild, who\'s online in all, numbr of people online, rank of the people in the guild and stuff :D lol

Title:
Post by: darkw00t on September 23, 2005, 01:08:44 pm

good idea, we are looking for a guild war but no-one seems to want to challenge (we have asked several guilds)us, even though we are at top of list member-wise they could be like a league in guild war points (a table showing points), that would be a good idea

Title:
Post by: Neryam on September 23, 2005, 01:21:22 pm

Wait.. how does this relate to.. the topic? :/

Yah and also guild activity wise :P