Recent posts

#61

Server/Galaxy Specific / Re: Add Server SWG Legacy

Last post by Mr-Miagi - Jun 14, 2024, 12:56 AM

This has been added

Server Name: SWG Legacy
Game Folder: Legacy
Type: NGE
URL: https://swglegacy.com/

#62

Server/Galaxy Specific / Add Server SWG Legacy

Last post by Archpoet - Jun 08, 2024, 03:39 PM

Server Name: SWG Legacy
Game Folder: Legacy
Type: NGE
URL: https://swglegacy.com/

#63

Server/Galaxy Specific / Re: Hoax/joke resource on SWG ...

Last post by Mr-Miagi - Sep 04, 2023, 02:33 AM

Forgot to reply here but marked it for deletion a couple days ago.

The 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).

#64

Server/Galaxy Specific / Re: Add Server Stardust 2.0

Last post by Mr-Miagi - Sep 04, 2023, 02:32 AM

Added...

Server Name: Stardust 2.0
Game Folder (where profiles exist): Stardust
Type: precu or nge: precu
URL of server website: https://stardust-swg.com/

#65

Server/Galaxy Specific / Add Server Stardust 2.0

Last post by Serax - Sep 02, 2023, 09:53 PM

Server Name: Stardust 2.0
Game Folder (where profiles exist): Stardust
Type: precu or nge: precu
URL of server website: https://stardust-swg.com/

#66

General Discussion / Re: Need help with script to g...

Last post by Shozzo - Sep 01, 2023, 03:19 AM

I 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. 

#67

Server/Galaxy Specific / Hoax/joke resource on SWG Lege...

Last post by Davec - Aug 28, 2023, 04:54 PM

The 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).

#68

General Discussion / Re: Need help with script to g...

Last post by thelonejedi - Aug 21, 2023, 11:41 PM

Is there noone that can help with this ??

#69

General Discussion / Need help with script to get r...

Last post by thelonejedi - Aug 17, 2023, 09:14 PM

So 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

#70

Server/Galaxy Specific / Add Server SWG Ravager

Last post by thelonejedi - Aug 16, 2023, 12:17 AM

Server 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