I`m trying to develop a jsp program for a top guild anyone know the protocol or how to get the guild name form database?
Printable View
I`m trying to develop a jsp program for a top guild anyone know the protocol or how to get the guild name form database?
Quite a few servers got scripts for that already.
why yes theres no java protocol for it but there is a database decompression command, but its still in development and atm i can only get it working with the server offline. gotta be careful you dont screw the database.
Theres loads of potential for all sorts of projects that use the server logs and database. I remember a never finished project long ago that had a world map webpage with the locations of every player on it using the movement logs in the world2.log file. Its a shame that project was never released actually but it did inspire many people including me to look to create things from logs.
or as tw is once a week (unless you changed it) just add it to the site with top TW faction (takes 2 mins to update)
doing it manually is ok for a week or two, but after that it gets tiresome and really annoying...
Its a shame theres no mention of any names in the log files, but you can get guild captures from exportcitylist command.
Perhaps you could make it display the IDs automatically with TW activities and then make a database linking ID to name which you update yourself when theres a new guild around.
i can get the name of the guild owner automatic but i need to find a way to get the guild name auto i`ve seen it somewhere on a ru forum but it was for sale and the guy never replay back.
maybe somebody could make or has made a new java protocol for it, but as current there isn't one.
Like i said one way you can get it is by decompression using gamedbd.conv
Example
Code:fid,name,level,masterid,masterrole,member_size
1,"DevaStaff",2,3040,2,31
2,"TheDemonS",2,3600,2,71
3,"FugiTiveS",1,3953,2,12
8,"Untamed",2,0,2,0
9,"OWN3D!",0,0,2,0
10,"English",2,3137,2,9
12,"Devotion",2,3824,2,13
13,"¡Ô¡Æ¡Ç¡ÌY¡Ô",2,17973,2,5
14,"Br@sil",2,9137,2,2
15,"FrienDz`",2,160260,2,32
16,"DarK_MaSS",0,2432,2,1
18,"Kor'inth",0,4194,2,29
19,"Brasil",2,818,2,9
20,"CalciuM",2,4752,2,26
21,"RockStar",2,1361,2,17
22,"Armagedon",2,9138,2,50
23,"Support",0,7760,2,4
24,"0WN3DBr!!",2,0,2,0
25,"¡ïSkaterS¡ï",2,37072,2,1
27,"Eternals",2,4689,2,8
32,"Po!Son",0,10336,2,1
34,"Fenix",2,47888,2,18
35,"Speku's",0,1184,2,1
36,"RedSkull",0,7649,2,2
37,"¡îCOVENANT",2,1792,2,41
54,"Phoenix",0,5616,2,2
55,"Reality¡ï",2,0,2,0
56,"UniteD",2,4466,2,98
57,"REDBULL",2,8192,2,4
59,"Shinigami",2,0,2,0
60,"DreamZ",0,16689,2,3
62,"Alliance",2,0,2,0
63,"Memoire",0,59377,2,1
64,"¡ÞWANTED¡Þ",2,13712,2,1
65,"7SouLs",2,25040,2,1
67,"MaXimUs",2,9552,2,1
68,"NewGamE",1,18304,2,1
its asking for a lib can you please share it?
libdb_cxx-4.2.so
---------- Post added at 12:23 PM ---------- Previous post was at 12:09 PM ----------
./gamedbd.conv: error while loading shared libraries: libdb_cxx-4.2.so: cannot open shared object file: No such file or directory
Use the search function, theres already a thread on database editing development although nobody is really looking into it anymore except me so the thread is pretty old.
http://forum.ragezone.com/f452/berke...editor-737835/
but be warned using this with your server online might not be the best idea.
Quote:
Originally Posted by Adriana
http://forum.ragezone.com/f452/berke...5/#post6245739 my particular post here would be of the most help to Adriana...Quote:
Originally Posted by rbb138
you dont need alien for it btw, just open the rpm and pull out the library file then upload it.
Well at that time I didn't know about rpm2cpio because I rarely had trouble finding a .deb most of the time. Took me a bit to find that but the rpm2cpio method did work for me and you. I would upload it if I were at home but currently I'm out in (pretty much) the middle of nowhere using my slow as hell cell phone internet on laptop (5 kilobytes/s ftw .-.)Quote:
Originally Posted by rbb138
For anybody who has no idea what we are talking about, heres the library files, put them in /lib/ on ur server.
With this you can export your database into a decompressed format readable with a hex editor (no tools to edit it just yet).
It will also enable you to run the listfaction command to show guild names.
This needs serious development before it is of any use.
The column types and counts are hard to read and the size of an entry is randomly different sometimes without any other data to make it so.
Still there must be some way of getting it parsed into an editable format.
Thank you very much i`l let you know what i got as soon as i figure out how to make a automated program to decrypt it and re-crypt maybe i can patch the gamedbd into reading uncompressed database.
Wish me luck.
thx rbb, i realy need this, has been search it anywhere, but i didn't find it, finaly got from you :thumbup:Quote:
Originally Posted by rbb138
We need more people looking into this to get them working.
One idea was we could import the database into mysql for easy editing.
Maybe one day we can use this to find duplicate guid1/2 numbers and trace duped items.
Or install new TW territories without needing to wipe the TW map, or fill the auction house with so much cubi it never needs to be refilled.
Lots to gain in this.
How did you pull the names? I popped the whole process but not the name of the players or clans, how to solve?Quote:
Originally Posted by rbb138
read the thread and you will find out.
you have to use gamedbd.conv for it not normal gamedbd.elf
I did all the installation, what happens:
root @ ubuntu: / PWServer / gamedbd #. / gamedbd.conv gamesys.conf listfaction
read from storage status compress, compress = 1
fid, name, level, masterid, masterrole, member_size
root @ ubuntu: / PWServer / gamedbd #
By giving the command (without the. Conv):
root @ ubuntu: / PWServer / gamedbd #. / gamedbd gamesys.conf listfaction
It appears all but the clan name.
you need to run this command first (With the server offline!) to export the database to a decompressed format.
Code:./gamedbd.conv gamesys.conf decompressdb
I have this error.
err : Storage::Storage(Config):Db:open: Invalid argument