| Pages: [1] 2 3 4 5 6 7 8 9 10 11 .. 11 :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
   |
Posted - 2006.08.13 00:00:00 -
[1]
Edited by: Esaam DeVries on 13/08/2006 00:04:24
I am releasing a preview version of the new pos tracker.
COMMENT
This is a developer release. It is not user friendly on the install process. I won't provide any help on installation beside SQL and php errors I am to blame for. I'm only releasing it cause it's a bit unfair to keep you waiting too long. If you want a nice and clean version then you should wait.
Please note that I did not manage to find a nice way to integrate silo and production support yet so the database scheme might change.
The mail.php is a simpler version of the one I use. It won't mail the whole corp but only the owners. I will release the real version soon (tm) (to be honest as soon as I get ride of a bug that annoys me).
KNOWN BUGS
Lots (but you can report them).
Users with special characters in their name won't be able to register.
Code sucks but I'm afraid of going full object as it might not be php 4.x compatible.
ROADMAP
User data sanitising and check (80% already done)
Support for projects (50% already done)
Support for silos and production (0% done)
ACKNOWLEDGMENT
The tracker is based on Randay's pervious work. He did a great job so he's the one to thank. If your really want to thank me then send me exotic dancers.
FILE & CHECKSUM
Link : here
MD5SUM : cba11fa57183e41d84e2c8ba5344a5c6
INSTALLATION
Untar the archive (tar -zxvf) in your folder and edit the following files :
config.php
header.php
redirect.php
mail.php
check_pos.sh
Please, be aware that mail.php and check_pos.sh should not be able to be read and executed by the web server.
Then import the create_database.sql into your database.
mysql -h ip_of_mysql_server -u user -p database_name < create_database.sql
COLORS AND ALERT LEVELS
Everything is in the config.php file
MAIL ALERT CRON JOB
edit your crontab (crontab -e) and put something like
0 */12 * * * /path_to/check_pos.sh
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
franny
Phoenix Knights
|
Posted - 2006.08.13 05:59:00 -
[2]
small annoyances
arrays
Tracking Array still missing, xxx Artillery Batterys still named xxx Projectile Batterys
database issues
you have the default alliance to Dusk and Dawn(that took me a minute to figure out as I was adding my id's thru MySQL)
tricks
don't name the POS's by just system, or you can up with your fuel tracking choices looking like
Test
Test
Test
(was slightly annoying)
other than that, looks good so far, but thats only 20 minutes of testing while pretending to be working
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.08.13 06:30:00 -
[3]
Edited by: Esaam DeVries on 13/08/2006 06:31:50
 Originally by: franny
you have the default alliance to Dusk and Dawn(that took me a minute to figure out as I was adding my id's thru MySQL)
Ah, yeah, my bad. Forgot to remove this artifact. It was back when I was adding manually users into the database. It should not be a problem for people using the tracker interface though.
In create_database.sql line 186.
change
`alliance` varchar(255) NOT NULL default 'Dusk and Dawn',
to
`alliance` varchar(255) NOT NULL default ' ',
I'm thinking about adding real system / planete / moon using eve database exports to the tracker but again, it would break everything.
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
franny
Phoenix Knights
|
Posted - 2006.08.13 09:23:00 -
[4]
easy method, probably just change system to System, Planet, Moon in the discription request area
so people think to fill in
Test P69 M69
instead of just
Test
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.08.13 16:06:00 -
[5]
Edited by: Esaam DeVries on 13/08/2006 16:08:10
sheeesh...
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.08.13 16:07:00 -
[6]
I'm getting close to something with silo and production managment.
I'm using grapviz
So a simple database extraction can give something like :
digraph G {
"Carbon Polymers" [shapefile="14343.png", fontcolor=white];
"Crystallite Alloy" [shapefile="14343.png", fontcolor=white];
"Crystalline Carbonide" [shapefile="14343.png", fontcolor=white];
"Crystaline Carbonide Reaction" [shapefile="20175.png", fontcolor=white];
"Carbon Polymers" -> "Crystaline Carbonide Reaction";
"Crystallite Alloy" -> "Crystaline Carbonide Reaction";
"Crystaline Carbonide Reaction" -> "Crystalline Carbonide";
}
Then it lead to that
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
Randay
0utbreak
|
Posted - 2006.08.13 17:34:00 -
[7]
cool, good job esaam!
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Nina Mires
Sharks With Frickin' Laser Beams
Mercenary Coalition
|
Posted - 2006.08.14 10:18:00 -
[8]
Thanks for releasing this, i'll get round to installing it.
Nina
---------
|
Utoxin
Caldari
Kydance Radiant Industries
|
Posted - 2006.08.14 19:07:00 -
[9]
As I posted over in the main thread, I have some fixes and patches you might be interested in. What's the best way to get those to you? Use this version, and make a diff?
|
Nina Mires
Sharks With Frickin' Laser Beams
Mercenary Coalition
|
Posted - 2006.08.14 21:13:00 -
[10]
bug Esaam for svn..
then we can start on the corporate hanger array fuel levels addon.
Nina
---------
|
|
|
Utoxin
Caldari
Kydance Radiant Industries
|
Posted - 2006.08.14 21:20:00 -
[11]
If there's an svn repository, I'd love access. I'm willing to submit diffs against the current copy for inspection before I get full access too. Heck, even just having the ability to check out the latest changes would be nice.
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.08.14 22:26:00 -
[12]
Edited by: Esaam DeVries on 14/08/2006 22:28:23
I opened an account on SourceForge but the Projects Registrations can take up to 2 weeks.
In the mean time, the tar.gz is the most up-to-date you can have minus a quick hack I did today for total volume calculation in the fuel calculator.
Please, keep in mind I'm not a dev "in real life" so it takes time. In fact and that might seems weird but I'm not very fond of application development (I find that the whole user data input verifications kills all the fun).
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
Utoxin
Caldari
Kydance Radiant Industries
|
Posted - 2006.08.14 22:29:00 -
[13]
Edited by: Utoxin on 14/08/2006 22:35:55
Alright. I'll get a version done up using the tarball as the base, and post a link for you. I have several bug fixes, and several new features.
The 'optimum fuel' feature that I implimented is a HUGE hit with my corp mates and myself. It makes it much easier to fill up each tower.
Next on my list of features is either a 'corp fuel hangar' option, or the silo tools. I'll see how I feel. :)
Edit: Oh. And keep in mind that I /am/ PHP/MySQL developer in real life. :) I do this stuff for a living, and I actually enjoy it a lot. If you have questions or need help figuring something out, feel free to let me know.
|
Randay
0utbreak
|
Posted - 2006.08.15 00:52:00 -
[14]
Originally by: Esaam DeVries
(I find that the whole user data input verifications kills all the fun).
zLOL. Did you notice how much work I put in on input validation? none! 
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.08.15 00:55:00 -
[15]
Originally by: Randay
Originally by: Esaam DeVries
(I find that the whole user data input verifications kills all the fun).
zLOL. Did you notice how much work I put in on input validation? none!
Yeah, and it hurted my little IT security consultant's heart a LOT :p
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
Nina Mires
Sharks With Frickin' Laser Beams
Mercenary Coalition
|
Posted - 2006.08.15 11:00:00 -
[16]
Edited by: Nina Mires on 15/08/2006 11:00:15
Might have solved the Corporate Hanger Array.
Need to check the maths and provide a way of inputting the data.
Nina
---------
|
Nina Mires
Sharks With Frickin' Laser Beams
Mercenary Coalition
|
Posted - 2006.08.15 14:42:00 -
[17]
I've temporarily setup a SVN server and branched out the code to include the additions for the corporate hanger.
svn://woody.friar.info/POS/trunk for the original release + the updated fuelcalculator.php
svn://woody.friar.info/POS/branches/andy for my current one.
Current bugs include.
* A new table needs to be created and an new entry in pos_info table. - NOT included in the svn
* When deleting the POS it doesn't delete the acutal corporate hanger array.
* Combined time calc using the fuel from both pos & hanger doesn't work.
I'll try and create the sql code to create the new table and alter statement.
Nina
---------
|
Johnathan Roark
Caldari
Quantum Industries
Prime Orbital Systems
|
Posted - 2006.08.15 15:02:00 -
[18]
It looks great. I had some problems getting the database to install.
Here is the error output i received.
Quote:
SQL query:
CREATE TABLE `pos_info` (
`pos_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`corp` varchar( 255 ) NOT NULL ,
`pos_size` tinyint( 4 ) NOT NULL ,
`pos_race` tinyint( 4 ) NOT NULL ,
`isotope` int( 11 ) NOT NULL default '0',
`oxygen` int( 11 ) NOT NULL default '0',
`mechanical_parts` int( 11 ) NOT NULL default '0',
`coolant` int( 11 ) NOT NULL default '0',
`robotics` int( 11 ) NOT NULL default '0',
`uranium` int( 11 ) NOT NULL default '0',
`ozone` int( 11 ) NOT NULL default '0',
`heavy_water` int( 11 ) NOT NULL default '0',
`strontium` int( 11 ) NOT NULL default '0',
`system` varchar( 255 ) NOT NULL ,
`sovereignty` tinyint( 1 ) NOT NULL default '0',
`status` varchar( 255 ) NOT NULL default '0',
`owner_id` int( 11 ) default NULL ,
`pos_status` tinyint( 10 ) NOT NULL default '1',
PRIMARY KEY ( `pos_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 21
We removed the last line "ENGINE = MYISAM DEFAULT CHARSET = latin1;" and it worked fine. This was running MySQL 4.0.27.
Corporation Management Improvement |
Utoxin
Caldari
Kydance Radiant Industries
|
Posted - 2006.08.15 15:23:00 -
[19]
First: That database error is because of some MySQL 5 specific features in the export that was used. remove the charset references, and (optionally) the table type references, and you'll be fine.
Now. I've finished porting my fixes and additions over to the development version. I also made some tweaks to the database layout, but nothing that will break backwards compatibility. Mostly just cleanups, and more precise field definitions that will use a little less space.
To download it, click here. And please, feel free to verify all the code before you use it. I assure you, I haven't tried to do anything sneaky.
I'm going to work on solving the special characters in names problem next, since I have a corp member who can't use it right now because of an apostrophe.
|
franny
Phoenix Knights
|
Posted - 2006.08.17 06:36:00 -
[20]
I get 'intresting' errors when I try to update to Utoxin's code
trying to add a POS, I go thru the add fine, press select structures and get this
Quote:
INSERT INTO pos_info VALUES ('NULL', 'Phoenix Knights', '1', '3', '600', '200', '300', '400', '500', '100', '700', '800', '1000', '900', 'stral', '0', '0', '0','franny'sid#' , 'False')Could not redirect; Headers already sent.
as far as I can tell, it's erroring out on the pos-tranasaction file, I backdated just that file and removed 'charters' and 'charters_needed' from the db, it works again(without charters support)
|
|
|
franny
Phoenix Knights
|
Posted - 2006.08.17 07:39:00 -
[21]
also at this point, i'm working on a revised installer and revised admin file, it's uptodate as far as the released version of Esaam's code(with Utoxin's capacity added)
if I can get the code right(I don't work with php, hell a couple weeks ago I didn't know any php at all), it should have an ADMIN id, and an added admin function for that id to set users to 3(and of course remove it)
problem is I do most of the coding on slow days at work, and the last couple I got slammed between vacation coverage and system issues(damn MVS code upgrade going to hell)
|
franny
Phoenix Knights
|
Posted - 2006.08.21 13:14:00 -
[22]
Edited by: franny on 21/08/2006 13:14:15
submitted a patch to the svn
it has the installer!!!!, the user-trans file for the installer to run(I had to hack the my_escape's out of it, it kept hanging the igb(backwards ass browser), and an admin file that allows the admin id(access lvl 4 by default) to set people's access to 0 and 3)
and it's newer than the one I sent Utoxin via email yesterday
|
Harbngr
Minmatar
Viper Intel Squad
|
Posted - 2006.08.25 08:15:00 -
[23]
This works great if I register In game and then access the site out of game. But if I try to login through the IGB even after changeing access level I still get the error that I don't have access and contact ceo.
Runnning php 5.1.2 and mysql 5.0.19
otherwise like the changes |
franny
Phoenix Knights
|
Posted - 2006.08.25 09:24:00 -
[24]
are you hitting enter or clicking login in the igb?
the hitting enter is a known bug, it for some reason doesn't register and just resets
oogb's work fine, as they understand enter
and side note, Utoxin, fix the damn User-Trans file I sent you :P , the one posted on the SVN has an extra '', in the adminreg section
|
Harbngr
Minmatar
Viper Intel Squad
|
Posted - 2006.08.25 18:07:00 -
[25]
yep hitting login.
its gotta be something on my end maybe. but the thing is when I use the demoe sites it works fine.
what version of php are you guys using?
And I gave enable the global variables in the php.ini
|
Utoxin
Caldari
Kydance Radiant Industries
|
Posted - 2006.08.25 18:08:00 -
[26]
Fine. It's fixed. :)
|
franny
Phoenix Knights
|
Posted - 2006.08.25 18:36:00 -
[27]
Edited by: franny on 25/08/2006 18:37:20
Originally by: Harbngr
yep hitting login.
its gotta be something on my end maybe. but the thing is when I use the demoe sites it works fine.
what version of php are you guys using?
And I gave enable the global variables in the php.ini
stupid forums ate my reply!
my host
Hosting OS Proprietary *nix
PHP version 4.4.1
MySQL version 4.0.24
works for me :/
|
Harbngr
Minmatar
Viper Intel Squad
|
Posted - 2006.08.25 21:29:00 -
[28]
Originally by: franny
Edited by: franny on 25/08/2006 18:37:20
Originally by: Harbngr
yep hitting login.
its gotta be something on my end maybe. but the thing is when I use the demoe sites it works fine.
what version of php are you guys using?
And I gave enable the global variables in the php.ini
stupid forums ate my reply!
my host
Hosting OS Proprietary *nix
PHP version 4.4.1
MySQL version 4.0.24
works for me :/
yea, thats what I thought. this isn't the first app I've had an issue with because of haveing the newest version. But setting the global variables fixed the other apps, or tweaking the mysql statements a little. I guess I can just try instaling an older version of php and try again. unfortunately I'm more of a networking guy then a programming one. So can just brute force my way through it. I'll try it and let you guys know.
|
Utoxin
Caldari
Kydance Radiant Industries
|
Posted - 2006.08.25 21:39:00 -
[29]
I run on MySQL 5, so that's not the source of the issue. Can you set notices enabled for the tracker, and tell me if you see anything?
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.08.25 22:31:00 -
[30]
Enabling Globals in php.ini is bad. If it's off by default it's because of this. And I can assure you, the tracker does not need globals at on.
It's not as bad as allowing the fopen() function but it's still pretty bad and I would strongly advise you of setting them to off.
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
|
|
|
|
| |
|
| Pages: [1] 2 3 4 5 6 7 8 9 10 11 .. 11 :: one page |
| First page | Previous page | Next page | Last page |