Freelancer Community Network
Reminder: Internet Explorer 6 or below are NOT supported.
HomeHome
ForumForum
WikiWiki
DownloadsDownloads
ForgeForge
Multiplayer Connection Tutorial
Collapse/Expand Donations
Monthly costs: -30€
Income (ads): +5€
Donations (last month): +30€

Current balance: -190€
(last updated 04/2017)

Please make a donation if you want to help keeping The-Starport online:

Bitcoin address:
Thanks!
Collapse/Expand Random Image
Collapse/Expand Login
Username:

Password:

Remember me



Lost Password?

Register now!
Collapse/Expand Chat
Collapse/Expand Who's Online
34 user(s) are online (12 user(s) are browsing Forum)

Members: 0
Guests: 34

more...
Collapse/Expand Links
Collapse/Expand Advertisement
There are currently 35 users playing Freelancer on 44 servers.
May. 26, 2017

Browsing this Thread:   1 Anonymous Users



 Bottom   Previous Topic   Next Topic  Register To Post



FLStat data extraction tool
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1753
Offline
I have updated Dan Tascau's FLStat again. It now has more columns, less bugs and predefined SQLite queries. You can copy the entire current list as CSV. Ship Details are more concise. Blank items (which includes most items not available to the player) aren't shown by default. Reading the ini files is a lot quicker.

Posted on: 2014/3/31 13:29
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2008/12/26 16:55
From Xarania
Group:
Registered Users
Senior Members
Posts: 806
Offline
Thanks

Posted on: 2014/3/31 15:08
Open in new window
http://freexlr.forumotion.net - FL-XLR MOD http://www.smfweb.com/forums/MERCHQ - [MERC]
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1664
Offline
Oh, thx, will check

Posted on: 2014/4/1 11:32
Open Sirius Mod
Top
Re: FLStat data extraction tool
Not too shy to talk
Joined:
2011/8/3 19:16
Group:
Registered Users
Posts: 70
Offline
Thanks.

Engclass plugin, this it works :
"hp_fighter_power_special_"
"hp_elite_power_special_"
"hp_freighter_power_special_"
"hp_fighter_engine_special_"
"hp_elite_engine_special_"
"hp_freighter_engine_special_"

not work :
"xxx_engine "
"xxx_power "

Posted on: 2014/4/3 14:41
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1753
Offline
Fixed, along with a few other improvements.

Posted on: 2014/4/23 15:15
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1664
Offline
@Adoxa, may i request to give back availability to copy only cell value by right click - Copy


Posted on: 2014/11/21 12:26
Open Sirius Mod
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1753
Offline

Posted on: 2014/11/24 5:59
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1664
Offline
Hoho. Thx, it works brilliant!
Screenshot for all modders/players:

Attach file:



gif  Буфер обмена-1.gif (2.80 KB)
388_54738cec6f18c.gif 178X104 px

Posted on: 2014/11/24 19:55
Open Sirius Mod
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1664
Offline
Adoxa - how about additional types - power generator, scanner, tractor, engine, armor? Maybe even Lights like Running Light, Docking Light and Head Light

Posted on: 2015/10/6 20:30
Open Sirius Mod
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1753
Offline
'Fraid not - FLStat has a weird parser, so adding new items is impractical.

Posted on: 2015/10/7 9:43
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1664
Offline
Uhh... Another idea - to show only blank items in addition to "Show blank items"

Posted on: 2/12 19:52
Open Sirius Mod
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1753
Offline
Sorry, don't think I'll worry about that. Is sorting not good enough?

Posted on: 2/13 0:49
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1664
Offline
More than enough. Intresting which items are not in shop

Posted on: 2/13 12:02
Open Sirius Mod
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1664
Offline
Got solution:
- Ships - Right click - Copy table - paste into file 1
- Ships - Show blank items - Right click - Copy table - paste into file 2

Compare files 1 and 2:
- now we know which ships are not in markets

Posted on: 2/14 12:26
Open Sirius Mod
Top
Re: FLStat data extraction tool
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1753
Offline
Ah, I see. I still don't fancy adding it, but I can see it being useful. If you have SQL, a quick query will find unbuyable packages:

Code:
FLStat> select nickname from equipment where category = 10 and buyable = 0;
nickname
-----------
gf1_package

Modifying the supplied macros would probably be the easiest way to get more details (for sqlite3, anyway).

Posted on: 2/15 1:02
Top