These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
Previous page12
 

SMF Fitting Display Tool
Author
Previous Topic Next Topic
Erwin Krym'L
Bitslix
Lolsec Fockel
#21 - 2013-04-09 17:01:49 UTC  |  Edited by: Erwin Krym'L
Chiyo Miharu wrote:
hello again

I recreated the database tables needed by the mod out of the retribution 1.1-84566 static data export.

here is a little test from my forum
http://eve.tetriac.de/index.php?topic=492.msg720#msg720


the 3 tables I updated are:
EFTCharges
EFTmodules
EFTShips

you can download the .sql files i exported with phpmyadmin here:
http://eve.tetriac.de/dbupdated.zip

hope this helps ^^

edit:
the problem with the ' still exists



Thanks for the data export. I'll give them a try soon.

Here are the changes i made to »Subs.php« in order to compile a link with shipDNA for the IGB:
Modifications to Subs.php to include ShipDNA
(Edit: If it says, it took too long to render that page.... just reload it Blink)

And for the problem with the ' i think a call to »mysql_real_escape_string($shipType) should do the trick:
Escape itemname in db-query
(I currently have this included in my forum's working copy ... not encountered any new problems so far)




MrCue wrote:
You are welcome to use our tool
http://eve.battleclinic.com/jquery_loadout_demo.php


Have you thought of also including ShipDNA to your tool?
Your tool would definitely have the big advantage, to stop us having to worry about updating our database tables regularly... Roll
MrCue
Alpha Quadrant Industries
#22 - 2013-04-09 18:06:53 UTC
Erwin Krym'L wrote:
Have you thought of also including ShipDNA to your tool?
Your tool would definitely have the big advantage, to stop us having to worry about updating our database tables regularly... Roll


It supports all of the formats (except for file upload) that the BC fitting tool does.

I've added an example of adding the DNA, you need only change the contents of the div.

The advantage of using the EFT format over the DNA one is

1.) People are most likely to post in EFT format
2.) If the plugin fails (or theres no javascript) then it falls back to just displaying readable text.
Erwin Krym'L
Bitslix
Lolsec Fockel
#23 - 2013-04-10 09:12:01 UTC
I rather thought of the ShipDNA as an output, so that users may open the according fitting panel ingame, when the certain site has been added to the IGBs "trusted sites".
Tonto Auri
Vhero' Multipurpose Corp
#24 - 2013-04-10 22:18:59 UTC  |  Edited by: Tonto Auri
MrCue wrote:
You are welcome to use our tool
http://eve.battleclinic.com/jquery_loadout_demo.php

I've tried it, followed the example by a letter, but all I got was "Unhandled Error: Undefined variable: $jq".
There: http://eve.rootdir.org/evefit/fitting.html
nvm... found this topic with correct code example.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Chiyo Miharu
Imperial Academy
Amarr Empire
#25 - 2013-04-19 16:02:16 UTC  |  Edited by: Chiyo Miharu
the mysql_real_escape_string hasn't worked for me.
i found a fix which is working fine:

edit:
the forum doesn't like code so here is a link:
http://eve.tetriac.de/fixforapostrophe.txt

Im not good in php so it would be nice if someone else can check if this is ok or maybe causing security problems.


there is also an error in the sql export i posted a few weeks ago.

the subsystems in the EFTmodules table field "location" has to be "SubSystem"
In my export it was "Subsystem" (like in the eve static datadump)
this error is messing up t3 fits posted in the forum.

So here is the link to download the corrected .sql files to fix this error:
http://eve.tetriac.de/dbupdated2.zip


hope this helps ^^
Erwin Krym'L
Bitslix
Lolsec Fockel
#26 - 2013-04-21 11:40:52 UTC
Dammit! I should have come to that by myself, as I use the str_replace method in my Character Linking Mod Shocked
Nevertheless, thanks for the work on the static db dump...
Linuz Vip
M4gnum P.I.
#27 - 2013-05-07 13:54:39 UTC  |  Edited by: Linuz Vip
Hi everyone,

I followed instructions here arround, to install it;

My issue is that all items goes out the Fit picture Shocked
please see here : http://les-baleines-sous-graviers.net/index.php?topic=162.0

I'm looking your help to solve the issue.
Thanks

Edit 1: In fact Item are answering to this section : //When there are items unknown, list them separately
No I checked it and we can see that's true on my post (see my forum link)

Edit 2: DB need something more ? I used dbupdated2.zip to create tables and add items,
It seems not

Edit 3: hmm DB is ok, seems it's in Subs.php code file
I double checked, it use original EFTmod + modifications for ShipDNA

So, I don't see, jscript issue ?
Please help me.
Thanks
Linuz Vip
M4gnum P.I.
#28 - 2013-05-07 17:12:39 UTC  |  Edited by: Linuz Vip
I need help.

Ok, here we go ! haha Big smile
I found the issue.

It was missing changes in index.template.php
In fact changes were applied to the default theme file, but not on the theme I use.

I'm so happy.

Thanks
Asooka Thano
Perkone
Caldari State
#29 - 2013-05-21 08:28:09 UTC
i found some old Names in the Database

Replaced them with the actuall ones

Example:

prototype 100mn Microwarpdrive

here is the download link:

http://www1.datafilehost.com/d/b8ac4e6c
Asooka Thano
Perkone
Caldari State
#30 - 2013-05-21 11:43:40 UTC
Round nr. 2

Added Corax, Algos, Venture, Talwar & Dragoon

Workd over the Shield Rigs & Shield Hardener

Here The New Update

http://www1.datafilehost.com/d/9b99e716
Chiyo Miharu
Imperial Academy
Amarr Empire
#31 - 2013-05-21 13:18:43 UTC
Chiyo Miharu wrote:
the mysql_real_escape_string hasn't worked for me.
i found a fix which is working fine:

edit:
the forum doesn't like code so here is a link:
http://eve.tetriac.de/fixforapostrophe.txt

Im not good in php so it would be nice if someone else can check if this is ok or maybe causing security problems.


there is also an error in the sql export i posted a few weeks ago.

the subsystems in the EFTmodules table field "location" has to be "SubSystem"
In my export it was "Subsystem" (like in the eve static datadump)
this error is messing up t3 fits posted in the forum.

So here is the link to download the corrected .sql files to fix this error:
http://eve.tetriac.de/dbupdated2.zip


hope this helps ^^


All the database updates up to retribution 1.1 i have already made. Feel free to use the database dumps in the link above ^^
Asooka Thano
Perkone
Caldari State
#32 - 2013-05-21 14:39:02 UTC
Hi Chiyo

sorry for that but on my server it has not uploaded them so i inserted them by myself

was a bit wired but it looks like it was an server error in the datacenter

keep on with this nice tool Big smile

it is a great help for my newbie corp
Reileen Kawahara
Bio-Tech Research
#33 - 2013-06-22 18:13:19 UTC  |  Edited by: Reileen Kawahara
Has anyone got the full package download link, seems there are bits around all over the place.

Looks an awesome mod and willing to pay for a working version that is up to date.

Edit: Have it all up and running now, thanks to all who have so far had an input in this mod.
Previous page12