21
Server/Galaxy Specific / Re: Add Server Stardust 2.0
Last post by Mr-Miagi - Sep 04, 2023, 02:32 AMAdded...
Quote from: Serax on Sep 02, 2023, 09:53 PMServer Name: Stardust 2.0
Game Folder (where profiles exist): Stardust
Type: precu or nge: precu
URL of server website: https://stardust-swg.com/
22
Server/Galaxy Specific / Add Server Stardust 2.0
Last post by Serax - Sep 02, 2023, 09:53 PMServer Name: Stardust 2.0
Game Folder (where profiles exist): Stardust
Type: precu or nge: precu
URL of server website: https://stardust-swg.com/
Game Folder (where profiles exist): Stardust
Type: precu or nge: precu
URL of server website: https://stardust-swg.com/
23
General Discussion / Re: Need help with script to g...
Last post by Shozzo - Sep 01, 2023, 03:19 AMI don't what database this is pulling from, but from SQL Server you would add FOR XML AUTO; to the end of the query for it to return as XML.
If this is MySQL or Oracle you'd have to google how to get the results to return as XML.
If this is MySQL or Oracle you'd have to google how to get the results to return as XML.
24
Server/Galaxy Specific / Hoax/joke resource on SWG Lege...
Last post by Davec - Aug 28, 2023, 04:54 PMThe resource is: Esbeltateramara - Tatooinian Crustacean Meat Rate: 1000
Age: Inactive
ER CR CD DR FL HR MA PE OQ SR UT
1000
100.0% 1000
100.0%
1000
100.0% 1000
100.0%
Reported: N/A (historical) by: esbeltateramara
With all stats 1000 and reported by a someone using the same name as the resource, it's clearly not a legitimate entry.
There *is* a legit looking entry for Esbeltataresama, an Endor Reptile meat reported by SystemFeed, and only obtainable by veteran resource crate, but even it is flawed by lacking a value for Flavor.
It would be nice to have the hoax one removed as it distorts the 'top ten' lists (and the joke has gone on long enough).
Age: Inactive
ER CR CD DR FL HR MA PE OQ SR UT
1000
100.0% 1000
100.0%
1000
100.0% 1000
100.0%
Reported: N/A (historical) by: esbeltateramara
With all stats 1000 and reported by a someone using the same name as the resource, it's clearly not a legitimate entry.
There *is* a legit looking entry for Esbeltataresama, an Endor Reptile meat reported by SystemFeed, and only obtainable by veteran resource crate, but even it is flawed by lacking a value for Flavor.
It would be nice to have the hoax one removed as it distorts the 'top ten' lists (and the joke has gone on long enough).
25
General Discussion / Re: Need help with script to g...
Last post by thelonejedi - Aug 21, 2023, 11:41 PMIs there noone that can help with this ??
26
General Discussion / Need help with script to get r...
Last post by thelonejedi - Aug 17, 2023, 09:14 PMSo far I have this but when trying to covert this to XML it doesn't separate enough data info into groups.
SELECT resource_id, resource_name, resource_class, regexpsubstr(attributes, '[[:alpha:]]+', 1, lines.column_value) attribute_name, regexp_substr(attributes, '\d+', 1, lines.column_value) attribute_value FROM resource_types, TABLE (CAST (MULTISET (SELECT LEVEL FROM dual CONNECT BY regexp_substr(attributes, '[^:]+', 1, LEVEL) IS NOT NULL) AS sys.odciNumberList)) lines WHERE depleted_timestamp >= (SELECT last_save_time FROM clock);
Can anyone help please
SELECT resource_id, resource_name, resource_class, regexpsubstr(attributes, '[[:alpha:]]+', 1, lines.column_value) attribute_name, regexp_substr(attributes, '\d+', 1, lines.column_value) attribute_value FROM resource_types, TABLE (CAST (MULTISET (SELECT LEVEL FROM dual CONNECT BY regexp_substr(attributes, '[^:]+', 1, LEVEL) IS NOT NULL) AS sys.odciNumberList)) lines WHERE depleted_timestamp >= (SELECT last_save_time FROM clock);
Can anyone help please
27
Server/Galaxy Specific / Add Server SWG Ravager
Last post by thelonejedi - Aug 16, 2023, 12:17 AMServer Name: SWG Ravager
Game Folder (where profiles exist): SWG Ravager Client (Expanded)
Type: precu or nge: NGE
URL of server website: https://sites.google.com/view/swg-ravager/home
Game Folder (where profiles exist): SWG Ravager Client (Expanded)
Type: precu or nge: NGE
URL of server website: https://sites.google.com/view/swg-ravager/home
28
General Discussion / Re: suggestion for the SWGAide...
Last post by Mr-Miagi - Aug 14, 2023, 09:31 PMThere is already a filter/dropdown for professions in the app.
I think I touched base on it in the video tutorial for the Laboratory/Test Bench tutorial. https://swgaide.com/swgaide_video_tutorials.html (scroll down to bottom)
When you manage the assignee's you can use the dropdown in the manage screen to select what profession and then which schematics you want associated from the list.
Hope that helps.
I think I touched base on it in the video tutorial for the Laboratory/Test Bench tutorial. https://swgaide.com/swgaide_video_tutorials.html (scroll down to bottom)
When you manage the assignee's you can use the dropdown in the manage screen to select what profession and then which schematics you want associated from the list.
Hope that helps.
Quote from: CalumWulfe on Aug 14, 2023, 11:28 AMdon't know if it's possible, but if there was a way to add tag or query the server for a character's profession(s),the app could then; potentially, use that to populate an assignee's schematics list.
the tagging would likely be easier, since you wouldn't need anything from the servers.
this may be something worth looking into.
29
General Discussion / suggestion for the SWGAide app
Last post by CalumWulfe - Aug 14, 2023, 11:28 AMdon't know if it's possible, but if there was a way to add tag or query the server for a character's profession(s),the app could then; potentially, use that to populate an assignee's schematics list.
the tagging would likely be easier, since you wouldn't need anything from the servers.
this may be something worth looking into.
the tagging would likely be easier, since you wouldn't need anything from the servers.
this may be something worth looking into.
30
Server/Galaxy Specific / Re: Add of server SWG A New Ho...
Last post by Mr-Miagi - Aug 09, 2023, 01:36 PMThe server has been added.
Quote from: elnitano on Aug 04, 2023, 12:22 PMHello,
I'm the server administrator for SWG A New Hope, and would kindly request adding the newly launched Pre-Cu server to SWGAide.
Server Name: SWG A New Hope
Game Folder (where profiles exist): A New Hope
Type: precu or nge: precu
URL of server website: https://swg-anh.com/
Also I'm not sure if we can get automatic resource pulling, using the XML from GH? ( https://galaxyharvester.net/exports/current126.xml )
I have setup our server to start update at 11:05 EDT - And it takes a couple of minutes, so if possible then update at maybe 11:30 EDT ?
Thank you very much in advance.