PrivateSniper Posted January 13, 2012 Share Posted January 13, 2012 (edited) Hi everyone, I decided it would be nice to have a database of my guild/clan characters, levels, skills etc. so I started writing a php code (initially just for my own use) and have packaged it on google code. Installation should be as quick as typing your details in. I have only just released it, so consider it beta and any feedback would be welcome. here's the link:swtor-character-db Edited January 13, 2012 by PrivateSniper Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 13, 2012 Author Share Posted January 13, 2012 I have just posted v1.0 final (there was some bugs in previous code, now should all be resolved) - still have a few changes to make in the coming updates. Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 14, 2012 Author Share Posted January 14, 2012 If anyone is interested in using the software and would like to see a demo first, I have it running for my small clan of friends, http://www.tf2clan.co.uk/swtor. I will be working on sorting the tables hopefully using javascript, aswell as looking into the possibility of enabling people to create their own characters and further administration pages. So stay tuned for updates. If anyone has any feedback or suggestions either post on googlecode or pm me here. Link to comment Share on other sites More sharing options...
Stesc Posted January 14, 2012 Share Posted January 14, 2012 Well, it looks like it gets the job done. Now you just gotta make it pretty! =D Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 14, 2012 Author Share Posted January 14, 2012 Yea , any suggestions on how I can do that would be welcomed, for my own small community it does all I need, but any improvements I can make is not only a good learning exercise for me, but also good for those who use it Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 14, 2012 Author Share Posted January 14, 2012 I have added a logo instead of plain text as step one into improving the aesthetics of the db app, here's my first draft (obviously clans/guilds could create their own logo in place of this one). http://i259.photobucket.com/albums/hh309/PrivateSniper/swtordb-withlogo.jpg I will still be looking at additional visual upgrades, will try and get another release out tomorrow Link to comment Share on other sites More sharing options...
Vickzy Posted January 14, 2012 Share Posted January 14, 2012 Great initiative but I wonder, is this data pulled from somewhere or is it simply a database which you edit yourself? Link to comment Share on other sites More sharing options...
Stesc Posted January 14, 2012 Share Posted January 14, 2012 Great initiative but I wonder, is this data pulled from somewhere or is it simply a database which you edit yourself? Good question. I just automatically assumed it did, but now that I think of it, this is a very valid question. Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 15, 2012 Author Share Posted January 15, 2012 Vickzy, the data is manually entered, afaik there is no way of viewing your characters out of game such as an armory style system, all other apps currently rely on manually entered info, perhaps one day in the future it may be possible to poll the data from somewhere. Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 15, 2012 Author Share Posted January 15, 2012 (edited) Version 1.1 has been released, I have decided to use sourceforge from now on for project hosting, with a link to google code as a backup, links in sig changes password field input is hidden on login page, still visible on installation screen for verification."pretty-fied" layout, consistent accross all pages, new header logo includedheader included on each page with links if logged in or out download v1.1 Edited January 15, 2012 by PrivateSniper Link to comment Share on other sites More sharing options...
Vickzy Posted January 15, 2012 Share Posted January 15, 2012 Vickzy, the data is manually entered, afaik there is no way of viewing your characters out of game such as an armory style system, all other apps currently rely on manually entered info, perhaps one day in the future it may be possible to poll the data from somewhere. Great initiative non the less. Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 15, 2012 Author Share Posted January 15, 2012 thanks Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 15, 2012 Author Share Posted January 15, 2012 v1.1b has been released (yes on a weekend I can hammer out the updates lol) Changes Selection lists on the add and edit character screen are now polled from the internal database instead of hand-typedEdit character screen will now "remember" the characters race, class, advanced class, and all 3 skillsFurther improved consistency (added a footer and added header on more pages) Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 16, 2012 Author Share Posted January 16, 2012 The next version will hopefully be out by the end of the week time permitting. I already have javascript table sorting which can be seen on my live site. I will be adding support for honor and social ranks in the database. Also in either this version or the next I plan to add customizable columns on the front page, for example my site will hide skills 2,3 and their levels, but show the honor rank instead. Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 19, 2012 Author Share Posted January 19, 2012 (edited) Version 1.2 is now out, I have tested it till my eyes exploded looking through all the code. Any issues let me know but I think it should be fine if upgrading from a previous version index should prompt you to visit admin/upgrade.php which creates and amends necessary tables. adminsare now able to customise which columns are available on the screen.honor, social and alignments are additional options available on characters.top bar has been changed to link only to the admin index which has all the linksAlso added Investigation which was missing Edited January 19, 2012 by PrivateSniper Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 21, 2012 Author Share Posted January 21, 2012 I have uploaded a fixed version 1.2 onto SF, seems the level column was not displaying regardless of the setting. Next I will work on allowing members to register, admins can then assign the members necessary permission to create their characters, and a my account type page. How many people are actually using the script? would be nice to get a list of sites using it then I can feature them on the project home page Link to comment Share on other sites More sharing options...
Ancagalon Posted January 21, 2012 Share Posted January 21, 2012 (edited) Le message que vous avez entré est trop court. Veuillez l'allonger à au moins 5 caractères. Edited December 15, 2014 by Ancagalon Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 21, 2012 Author Share Posted January 21, 2012 (edited) if it's saying password is wrong it's probably because your database might have more than one entry for the admin account, the code presently just checks that there is only one result and disallows login if not, though I will be looking at implementing more validation further down the line. do you have phpMyAdmin? if so just login and delete one of the duplicated rows and this should sort it. also i'm working on allowing users to register and role based permissions soon. Edited January 21, 2012 by PrivateSniper Link to comment Share on other sites More sharing options...
Ancagalon Posted January 21, 2012 Share Posted January 21, 2012 (edited) Le message que vous avez entré est trop court. Veuillez l'allonger à au moins 5 caractères. Edited December 15, 2014 by Ancagalon Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 21, 2012 Author Share Posted January 21, 2012 well my first thought would be are you 100% sure your typing in the right password (it would be case sensitive). have you created any characters yet? if not I would make sure you have v1.2 (only just uploaded a fixed version of it today), drop all tables and re-run the setup routine. Link to comment Share on other sites More sharing options...
Ancagalon Posted January 21, 2012 Share Posted January 21, 2012 (edited) Le message que vous avez entré est trop court. Veuillez l'allonger à au moins 5 caractères. Edited December 15, 2014 by Ancagalon Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 21, 2012 Author Share Posted January 21, 2012 to be honest I have no experience with plesk, I was thinking of prefixing the tables for this script, but with my hosting I just made an entire new db for it anyway to keep it seperate from my wordpress and ipboard Link to comment Share on other sites More sharing options...
Ancagalon Posted January 21, 2012 Share Posted January 21, 2012 (edited) Le message que vous avez entré est trop court. Veuillez l'allonger à au moins 5 caractères. Edited December 15, 2014 by Ancagalon Link to comment Share on other sites More sharing options...
PrivateSniper Posted January 21, 2012 Author Share Posted January 21, 2012 the next update is going to add user registration and roles, so you will be able to manually assign your user to the admin role in the db and login with that Link to comment Share on other sites More sharing options...
Ancagalon Posted January 21, 2012 Share Posted January 21, 2012 (edited) Le message que vous avez entré est trop court. Veuillez l'allonger à au moins 5 caractères. Edited December 15, 2014 by Ancagalon Link to comment Share on other sites More sharing options...
Recommended Posts