Freelancer Community Network
Reminder: Internet Explorer 6 or below are NOT supported.
HomeHome
ForumForum
WikiWiki
DownloadsDownloads
ForgeForge
Multiplayer Connection Tutorial
Collapse/Expand Random Image
freelancerb6 438
Collapse/Expand Login
Username:

Password:

Remember me



Lost Password?

Register now!
Collapse/Expand Main Menu
Collapse/Expand Forum
Collapse/Expand Chat
Collapse/Expand Who's Online
81 user(s) are online (48 user(s) are browsing Forum)

Members: 1
Guests: 80

sukothai, more...
Collapse/Expand Donations
Monthly costs: -30€
Income (ads): +5€
Donations (last month): +165€

Current balance: 105€
(last updated 02/2021)

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

Thanks!
Collapse/Expand Links
Collapse/Expand Advertisement
There are currently 23 users playing Freelancer on 37 servers.
 April. 20, 2021

Browsing this Thread:   2 Anonymous Users



 Bottom   Previous Topic   Next Topic  Register To Post

(1) 2 »


adoxa
FLStat data extraction tool
#1
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1985
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
Xarian_Prime
Re: FLStat data extraction tool
#2
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
HeIIoween
Re: FLStat data extraction tool
#3
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1766
Offline
Oh, thx, will check

Posted on: 2014/4/1 11:32
Open Sirius Mod
Top
starworld
Re: FLStat data extraction tool
#4
Not too shy to talk
Joined:
2011/8/3 19:16
Group:
Registered Users
Posts: 88
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
adoxa
Re: FLStat data extraction tool
#5
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1985
Offline
Fixed, along with a few other improvements.

Posted on: 2014/4/23 15:15
Top
HeIIoween
Re: FLStat data extraction tool
#6
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1766
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
adoxa
Re: FLStat data extraction tool
#7
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1985
Offline
Done.

Posted on: 2014/11/24 5:59
Top
HeIIoween
Re: FLStat data extraction tool
#8
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1766
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
HeIIoween
Re: FLStat data extraction tool
#9
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1766
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
adoxa
Re: FLStat data extraction tool
#10
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1985
Offline
'Fraid not - FLStat has a weird parser, so adding new items is impractical.

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

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

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

Posted on: 2017/2/13 12:02
Open Sirius Mod
Top
HeIIoween
Re: FLStat data extraction tool
#14
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1766
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: 2017/2/14 12:26
Open Sirius Mod
Top
adoxa
Re: FLStat data extraction tool
#15
Home away from home
Joined:
2009/8/16 2:58
From Qld, Aus.
Group:
Registered Users
FLServer Admins
Trusted Speciality Developers
Senior Members
Posts: 1985
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: 2017/2/15 1:02
Top
Top Top   Previous Topic   Next Topic
(1) 2 »

  Register To Post