Explore Public Snippets
Found 50k snippets matching: table
protected function _prepareCollection() { //to join normal attributes; but not sku, type_id and others (see catalog_product_entity database table) $productAttributesArray = array('product_name' => 'name', 'product_seller' => 'seller', 'product_supplier' => 'supplier'); $poTempModel = Mage::getModel('mymodule/modelone')->load($this->getRequest()->getParam('id'),'actual_id'); $collection = Mage::getModel('mymodule/modeltwo')->getCollection()->addFieldToFilter('parent_id',$poTempModel->getId()); foreach ($productAttributesArray as $alias => $attributeCode) { $tableAlias = $attributeCode . '_table'; $attribute = Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, $attributeCode); //Add eav attribute value $collection->getSelect() ->joinLeft( array($tableAlias => $attribute->getBackendTable()), "main_table.product_id = $tableAlias.entity_id AND $tableAlias.attribute_id={$attribute->getId()}", array($alias => 'value') ); } //to join entity attributes such sku, type_id $collection->join( 'catalog/product', 'product_id = `catalog/product`.entity_id',//note the ` . DO NOT USE ' array('sku' => 'sku') ); $this->setCollection($collection); return parent::_prepareCollection(); } protected function _prepareColumns() { $this->addColumn('position', array( 'header'=> 'Position', 'width' => '50px', 'type' => 'number', 'index'=>'position', 'sortable' => false )); $this->addColumn('product_name', array( 'header'=> 'Name', 'type' => 'text', 'index'=>'product_name', 'sortable' => false )); $this->addColumn('sku', array( 'header'=> 'SKU', 'type' => 'text', 'index'=>'sku', 'sortable' => false )); $this->addColumn('poitemtemp_id', array( 'header'=> 'Action', 'align' => 'center', 'type' => 'number', 'index'=>'poitemtemp_id', 'renderer' => 'mymodule/adminhtml_editpo_elements_edit_gridscontainer_currentitemsrender', 'sortable' => false )); return parent::_prepareColumns(); }
public by lbottaro 352485 5 7 7
Css zebra color for alternate style in table rows
<html> <head> <title> Example of zebra color </title> <style> tr:nth-child(even) { background-color: red; } tr:nth-child(odd) { background-color: white; } </style> </head> <body> <table id="myTable"> <th>Lorem ipsum dolor.</th> <th>Nam, sequi, architecto?</th> <th>Aut, eius, esse!</th> <tr> <td>Lorem ipsum dolor.</td> <td>Doloribus, quidem, excepturi.</td> <td>Magnam, dolorum, alias!</td> </tr> <tr> <td>Lorem ipsum dolor.</td> <td>Odio, fuga, distinctio.</td> <td>Cumque, necessitatibus, labore!</td> </tr> <tr> <td>Lorem ipsum dolor.</td> <td>Esse, suscipit, soluta.</td> <td>Nostrum, animi, fugit?</td> </tr> <tr> <td>Lorem ipsum dolor.</td> <td>Error, veritatis, saepe?</td> <td>Alias, cupiditate, debitis.</td> </tr> <tr > <td>Lorem ipsum dolor.</td> <td>Minus, neque, quisquam.</td> <td>Eius, deleniti, sunt.</td> </tr> </table> </body> </html>
public by fabio.nosenzo 264124 8 6 0
Refresh all pivot table excel vba macro
ThisWorkbook.RefreshAll
public by cghersi 328013 0 6 1
Retrieve useful information regarding indexes in MS SQL Server
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET NOCOUNT ON SET ANSI_WARNINGS OFF SET ARITHABORT OFF SET ARITHIGNORE ON SET TEXTSIZE 2147483647 ----------------------------------------------------------------------------------------------------------------------------- -- Declarations / Sets: Declare And Set Variables ----------------------------------------------------------------------------------------------------------------------------- DECLARE @Database_ID AS SMALLINT SET @Database_ID = DB_ID () ----------------------------------------------------------------------------------------------------------------------------- -- Error Trapping: Check If Temp Table(s) Already Exist(s) And Drop If Applicable ----------------------------------------------------------------------------------------------------------------------------- IF OBJECT_ID (N'tempdb.dbo.#temp_index_breakdown_keys_filters', N'U') IS NOT NULL BEGIN DROP TABLE dbo.#temp_index_breakdown_keys_filters END IF OBJECT_ID (N'tempdb.dbo.#temp_index_breakdown_size_info', N'U') IS NOT NULL BEGIN DROP TABLE dbo.#temp_index_breakdown_size_info END ----------------------------------------------------------------------------------------------------------------------------- -- Table Insert: Insert Index Key, Include Key, And Filter Definition Values Into Temp Table ----------------------------------------------------------------------------------------------------------------------------- SELECT sqI.[object_id] ,sqI.index_id ,STUFF (CONVERT (NVARCHAR (MAX), sqI.index_key), 1, 2, N'') AS index_key ,STUFF (CONVERT (NVARCHAR (MAX), sqI.include_key), 1, 2, N'') AS include_key ,sqI.filter_definition ,RANK () OVER ( ORDER BY sqI.[object_id] ,CONVERT (NVARCHAR (MAX), sqI.index_key) ,sqI.filter_definition ) AS dupe_rank INTO dbo.#temp_index_breakdown_keys_filters FROM ( SELECT I.[object_id] ,I.index_id ,( SELECT N', ' + C.name + N' • ' + TYPE_NAME (C.user_type_id) + ISNULL ((N': [ ' + (CASE WHEN C.system_type_id <> C.user_type_id THEN LOWER (TYPE_NAME (C.system_type_id)) END) + N' ]'), N'') + N' ' + (CASE WHEN TY.name NOT IN (N'bigint', N'bit', N'date', N'datetime', N'datetime2', N'datetimeoffset', N'decimal', N'float', N'int', N'money', N'numeric', N'real', N'smalldatetime', N'smallint', N'smallmoney', N'time', N'tinyint') THEN CONVERT (NVARCHAR (30), C.max_length) ELSE CONVERT (NVARCHAR (30), C.max_length) + N' (' + CONVERT (NVARCHAR (30), COLUMNPROPERTY (C.[object_id], C.name, 'Precision')) + N',' + ISNULL (CONVERT (NVARCHAR (30), COLUMNPROPERTY (C.[object_id], C.name, 'Scale')), 0) + N')' END) + N' ' + (CASE WHEN IC.is_descending_key = 0 THEN N'[A]' WHEN IC.is_descending_key = 1 THEN N'[D]' ELSE N'[N/A]' END) AS [text()] FROM sys.index_columns IC INNER JOIN sys.columns C ON C.[object_id] = IC.[object_id] AND C.column_id = IC.column_id INNER JOIN sys.types TY ON TY.user_type_id = C.user_type_id WHERE IC.is_included_column = 0 AND IC.[object_id] = I.[object_id] AND IC.index_id = I.index_id ORDER BY IC.key_ordinal FOR XML PATH ('') ,TYPE ) AS index_key ,( SELECT N', ' + C.name + N' • ' + TYPE_NAME (C.user_type_id) + ISNULL ((N': [ ' + (CASE WHEN C.system_type_id <> C.user_type_id THEN LOWER (TYPE_NAME (C.system_type_id)) END) + N' ]'), N'') + N' ' + (CASE WHEN TY.name NOT IN (N'bigint', N'bit', N'date', N'datetime', N'datetime2', N'datetimeoffset', N'decimal', N'float', N'int', N'money', N'numeric', N'real', N'smalldatetime', N'smallint', N'smallmoney', N'time', N'tinyint') THEN CONVERT (NVARCHAR (30), C.max_length) ELSE CONVERT (NVARCHAR (30), C.max_length) + N' (' + CONVERT (NVARCHAR (30), COLUMNPROPERTY (C.[object_id], C.name, 'Precision')) + N',' + ISNULL (CONVERT (NVARCHAR (30), COLUMNPROPERTY (C.[object_id], C.name, 'Scale')), 0) + N')' END) AS [text()] FROM sys.index_columns IC INNER JOIN sys.columns C ON C.[object_id] = IC.[object_id] AND C.column_id = IC.column_id INNER JOIN sys.types TY ON TY.user_type_id = C.user_type_id WHERE IC.is_included_column = 1 AND IC.[object_id] = I.[object_id] AND IC.index_id = I.index_id ORDER BY IC.key_ordinal FOR XML PATH ('') ,TYPE ) AS include_key ,I.filter_definition FROM sys.indexes I ) sqI ----------------------------------------------------------------------------------------------------------------------------- -- Table Insert: Insert Size Values Into Temp Table ----------------------------------------------------------------------------------------------------------------------------- SELECT DDPS.[object_id] ,DDPS.index_id ,SUM (CASE WHEN DDPS.index_id < 2 THEN DDPS.row_count END) AS [rows] ,SUM (DDPS.reserved_page_count) AS total_pages ,SUM (DDPS.used_page_count) AS used_pages ,SUM (CASE WHEN DDPS.index_id < 2 THEN DDPS.in_row_data_page_count + DDPS.lob_used_page_count + DDPS.row_overflow_used_page_count ELSE DDPS.lob_used_page_count + DDPS.row_overflow_used_page_count END) AS data_pages INTO dbo.#temp_index_breakdown_size_info FROM sys.dm_db_partition_stats DDPS GROUP BY DDPS.[object_id] ,DDPS.index_id ----------------------------------------------------------------------------------------------------------------------------- -- Main Query: Final Display / Output ----------------------------------------------------------------------------------------------------------------------------- SELECT (CASE WHEN sqBAQ.row_filter = 1 THEN sqBAQ.[type] ELSE '' END) AS object_type ,(CASE WHEN sqBAQ.row_filter = 1 THEN DB_NAME () ELSE '' END) AS [database_name] ,(CASE WHEN sqBAQ.row_filter = 1 THEN SCHEMA_NAME (sqBAQ.[schema_id]) ELSE '' END) AS [schema_name] ,(CASE WHEN sqBAQ.row_filter = 1 THEN OBJECT_NAME (sqBAQ.[object_id]) ELSE '' END) AS [object_name] ,(CASE WHEN sqBAQ.row_filter = 1 THEN sqBAQ.create_date ELSE '' END) AS create_date ,(CASE WHEN sqBAQ.row_filter = 1 THEN caMDKL.modify_date ELSE '' END) AS modify_date ,(CASE WHEN sqBAQ.row_filter = 1 THEN REVERSE (SUBSTRING (REVERSE (CONVERT (VARCHAR (25), CONVERT (MONEY, sqBAQ.[rows]), 1)), 4, 22)) ELSE '' END) AS [rows] ,(CASE WHEN sqBAQ.row_filter = 1 THEN CONVERT (VARCHAR (25), CONVERT (MONEY, (sqBAQ.total_pages * 8) / 1024.0), 1) ELSE '' END) AS total_mb ,(CASE WHEN sqBAQ.row_filter = 1 THEN CONVERT (VARCHAR (25), CONVERT (MONEY, (sqBAQ.used_pages * 8) / 1024.0), 1) ELSE '' END) AS used_mb ,(CASE WHEN sqBAQ.row_filter = 1 THEN CONVERT (VARCHAR (25), CONVERT (MONEY, (sqBAQ.unused_pages * 8) / 1024.0), 1) ELSE '' END) AS unused_mb ,(CASE WHEN sqBAQ.row_filter = 1 THEN CONVERT (VARCHAR (25), CONVERT (MONEY, (sqBAQ.data_pages * 8) / 1024.0), 1) ELSE '' END) AS data_mb ,(CASE WHEN sqBAQ.row_filter = 1 THEN CONVERT (VARCHAR (25), CONVERT (MONEY, (sqBAQ.index_pages * 8) / 1024.0), 1) ELSE '' END) AS index_mb ,(CASE WHEN sqBAQ.row_filter = 1 THEN CONVERT (VARCHAR (6), CONVERT (DECIMAL (5, 2), ISNULL (((sqBAQ.data_pages + .0) / sqBAQ.used_pages) * 100, 0))) ELSE '' END) AS pct_data ,(CASE WHEN sqBAQ.row_filter = 1 THEN CONVERT (VARCHAR (6), CONVERT (DECIMAL (5, 2), ISNULL (((sqBAQ.index_pages + .0) / sqBAQ.used_pages) * 100, 0))) ELSE '' END) AS pct_index ,sqBAQ.type_desc AS index_type ,ISNULL (sqBAQ.index_name, '') AS index_name ,(CASE WHEN sqBAQ.type_desc = N'HEAP' THEN '' WHEN sqBAQ.is_primary_key = 0 AND sqBAQ.is_unique = 0 THEN REPLICATE ('.', 6) WHEN sqBAQ.is_system_named = 0 THEN 'No' WHEN sqBAQ.is_system_named = 1 THEN 'Yes' ELSE '' END) AS system_named ,(CASE WHEN sqBAQ.is_primary_key = 1 THEN 'Yes' ELSE '' END) AS is_pk ,(CASE WHEN sqBAQ.is_unique_constraint = 1 THEN 'C' WHEN sqBAQ.is_unique = 1 THEN 'I' ELSE '' END) AS [unique] ,(CASE WHEN sqBAQ.is_disabled = 1 THEN 'Yes' ELSE '' END) AS [disabled] ,(CASE WHEN sqBAQ.is_hypothetical = 1 THEN 'Yes' ELSE '' END) AS hypothetical ,REVERSE (SUBSTRING (REVERSE (CONVERT (VARCHAR (23), CONVERT (MONEY, sqCC.total_columns), 1)), 4, 23)) AS total_columns ,(CASE WHEN sqBAQ.type_desc = N'HEAP' THEN '' ELSE REVERSE (SUBSTRING (REVERSE (CONVERT (VARCHAR (23), CONVERT (MONEY, caMDKL.[index_columns]), 1)), 4, 23)) END) AS [index_columns] ,(CASE WHEN sqBAQ.type_desc = N'HEAP' THEN '' ELSE REVERSE (SUBSTRING (REVERSE (CONVERT (VARCHAR (23), CONVERT (MONEY, caMDKL.include_columns), 1)), 4, 23)) END) AS include_columns ,(CASE WHEN sqBAQ.type_desc = N'HEAP' THEN '' ELSE REVERSE (SUBSTRING (REVERSE (CONVERT (VARCHAR (23), CONVERT (MONEY, (caMDKL.[index_columns] / sqCC.total_columns) * 100), 1)), 1, 23)) END) AS index_pct_of_columns ,(CASE WHEN sqBAQ.type_desc = N'HEAP' THEN '' ELSE REVERSE (SUBSTRING (REVERSE (CONVERT (VARCHAR (23), CONVERT (MONEY, (caMDKL.include_columns / sqCC.total_columns) * 100), 1)), 1, 23)) END) AS include_pct_of_columns ,(CASE WHEN sqBAQ.type_desc = N'HEAP' THEN '' ELSE REVERSE (SUBSTRING (REVERSE (CONVERT (VARCHAR (23), CONVERT (MONEY, ((caMDKL.[index_columns] + caMDKL.include_columns) / sqCC.total_columns) * 100), 1)), 1, 23)) END) AS total_pct_of_columns ,CONVERT (VARCHAR (25), CONVERT (MONEY, (ISNULL (sqBAQ.individual_index_pages, 0) * 8) / 1024.0), 1) AS key_mb ,CONVERT (VARCHAR (6), CONVERT (DECIMAL (5, 2), ISNULL (((sqBAQ.individual_index_pages + .0) / sqBAQ.index_pages) * 100, 0))) AS key_mb_pct ,(CASE WHEN sqBAQ.type_desc = N'HEAP' THEN '' ELSE REVERSE (SUBSTRING (REVERSE (CONVERT (VARCHAR (25), CONVERT (MONEY, sqKL.total_max_length), 1)), 4, 22)) END) AS max_key_size_bytes ,(CASE WHEN sqKL.total_max_length > 900 THEN 'Yes' ELSE '' END) AS over_key_size_limit ,ISNULL (ttIBKF.index_key, N'') AS index_key ,ISNULL (ttIBKF.include_key, N'') AS include_key ,ISNULL (ttIBKF.filter_definition, N'') AS filter_definition ,(CASE WHEN sqED02.dupe_id IS NOT NULL THEN CONVERT (VARCHAR (20), sqED02.dupe_id) + ' - [' + CONVERT (VARCHAR (11), sqED02.total_dupes) + ']' ELSE '' END) AS dupe_id ,sqBAQ.is_unused AS unused ,ISNULL (CONVERT (VARCHAR (10), STATS_DATE (sqBAQ.[object_id], sqBAQ.index_id), 23), '') AS statistics_date ,(CASE WHEN sqBAQ.[allow_row_locks] = 0 THEN 'No' WHEN sqBAQ.[allow_row_locks] = 1 THEN 'Yes' ELSE '' END) AS row_locks ,(CASE WHEN sqBAQ.[allow_page_locks] = 0 THEN 'No' WHEN sqBAQ.[allow_page_locks] = 1 THEN 'Yes' ELSE '' END) AS page_locks ,(CASE WHEN sqBAQ.[ignore_dup_key] = 0 THEN 'No' WHEN sqBAQ.[ignore_dup_key] = 1 THEN 'Yes' ELSE '' END) AS ignore_dupes ,(CASE WHEN sqBAQ.no_recompute = 0 THEN 'Yes' WHEN sqBAQ.no_recompute = 1 THEN 'No' ELSE '' END) AS auto_stats ,(CASE WHEN sqBAQ.is_padded = 0 THEN 'No' WHEN sqBAQ.is_padded = 1 THEN 'Yes' ELSE '' END) AS padded ,(CASE WHEN sqBAQ.fill_factor = 0 THEN 100 ELSE sqBAQ.fill_factor END) AS fill_factor ,(CASE WHEN sqBAQ.user_seeks > 0 THEN CONVERT (VARCHAR (20), sqBAQ.user_seeks) ELSE '' END) AS user_seeks ,(CASE WHEN sqBAQ.user_scans > 0 THEN CONVERT (VARCHAR (20), sqBAQ.user_scans) ELSE '' END) AS user_scans ,(CASE WHEN sqBAQ.user_lookups > 0 THEN CONVERT (VARCHAR (20), sqBAQ.user_lookups) ELSE '' END) AS user_lookups ,(CASE WHEN sqBAQ.user_updates > 0 THEN CONVERT (VARCHAR (20), sqBAQ.user_updates) ELSE '' END) AS user_updates ,ISNULL (CONVERT (VARCHAR (10), sqBAQ.last_user_seek, 23), '') AS last_user_seek ,ISNULL (CONVERT (VARCHAR (10), sqBAQ.last_user_scan, 23), '') AS last_user_scan ,ISNULL (CONVERT (VARCHAR (10), sqBAQ.last_user_lookup, 23), '') AS last_user_lookup ,ISNULL (CONVERT (VARCHAR (10), sqBAQ.last_user_update, 23), '') AS last_user_update ,(CASE WHEN sqBAQ.system_seeks > 0 THEN CONVERT (VARCHAR (20), sqBAQ.system_seeks) ELSE '' END) AS system_seeks ,(CASE WHEN sqBAQ.system_scans > 0 THEN CONVERT (VARCHAR (20), sqBAQ.system_scans) ELSE '' END) AS system_scans ,(CASE WHEN sqBAQ.system_lookups > 0 THEN CONVERT (VARCHAR (20), sqBAQ.system_lookups) ELSE '' END) AS system_lookups ,(CASE WHEN sqBAQ.system_updates > 0 THEN CONVERT (VARCHAR (20), sqBAQ.system_updates) ELSE '' END) AS system_updates ,ISNULL (CONVERT (VARCHAR (10), sqBAQ.last_system_seek, 23), '') AS last_system_seek ,ISNULL (CONVERT (VARCHAR (10), sqBAQ.last_system_scan, 23), '') AS last_system_scan ,ISNULL (CONVERT (VARCHAR (10), sqBAQ.last_system_lookup, 23), '') AS last_system_lookup ,ISNULL (CONVERT (VARCHAR (10), sqBAQ.last_system_update, 23), '') AS last_system_update FROM ( SELECT O.[type] ,O.[schema_id] ,O.[object_id] ,CONVERT (VARCHAR (10), O.create_date, 23) AS create_date ,CONVERT (VARCHAR (10), O.modify_date, 23) AS modify_date ,sqDDPS.[rows] ,sqDDPS.total_pages ,sqDDPS.used_pages ,(CASE WHEN sqDDPS.total_pages > sqDDPS.used_pages THEN sqDDPS.total_pages - sqDDPS.used_pages ELSE 0 END) AS unused_pages ,sqDDPS.data_pages ,(CASE WHEN sqDDPS.used_pages > sqDDPS.data_pages THEN sqDDPS.used_pages - sqDDPS.data_pages ELSE 0 END) AS index_pages ,sqI.type_desc ,sqI.name AS index_name ,sqI.is_system_named ,sqI.is_primary_key ,sqI.is_unique ,sqI.is_disabled ,sqI.is_hypothetical ,sqI.individual_index_pages ,sqI.is_unused ,sqI.[allow_row_locks] ,sqI.[allow_page_locks] ,sqI.[ignore_dup_key] ,sqI.no_recompute ,sqI.is_padded ,sqI.fill_factor ,sqI.user_seeks ,sqI.user_scans ,sqI.user_lookups ,sqI.user_updates ,sqI.last_user_seek ,sqI.last_user_scan ,sqI.last_user_lookup ,sqI.last_user_update ,sqI.system_seeks ,sqI.system_scans ,sqI.system_lookups ,sqI.system_updates ,sqI.last_system_seek ,sqI.last_system_scan ,sqI.last_system_lookup ,sqI.last_system_update ,sqI.is_unique_constraint ,sqI.index_id ,sqI.row_filter FROM sys.objects O INNER JOIN ( SELECT ttIBSI.[object_id] ,SUM (ttIBSI.[rows]) AS [rows] ,SUM (ttIBSI.total_pages) AS total_pages ,SUM (ttIBSI.used_pages) AS used_pages ,SUM (ttIBSI.data_pages) AS data_pages FROM dbo.#temp_index_breakdown_size_info ttIBSI GROUP BY ttIBSI.[object_id] ) sqDDPS ON sqDDPS.[object_id] = O.[object_id] INNER JOIN ( SELECT I.[object_id] ,I.type_desc ,I.name ,KC.is_system_named ,I.is_primary_key ,I.is_unique ,I.is_disabled ,I.is_hypothetical ,(CASE WHEN ttIBSI.used_pages > ttIBSI.data_pages THEN ttIBSI.used_pages - ttIBSI.data_pages END) AS individual_index_pages ,(CASE WHEN I.[type] = 0 THEN '' WHEN I.[type] = 1 THEN REPLICATE ('.', 6) WHEN I.is_primary_key = 1 THEN REPLICATE ('.', 6) WHEN I.is_unique = 1 THEN REPLICATE ('.', 6) WHEN EXISTS ( SELECT * FROM sys.index_columns IC INNER JOIN sys.foreign_key_columns FKC ON FKC.parent_object_id = IC.[object_id] AND FKC.parent_column_id = IC.column_id WHERE IC.[object_id] = I.[object_id] AND IC.index_id = I.index_id ) THEN REPLICATE ('.', 6) WHEN DDIUS.[object_id] IS NOT NULL THEN (CASE WHEN DDIUS.user_seeks + DDIUS.user_scans + DDIUS.user_lookups + DDIUS.user_updates = 0 THEN 'Y/N' ELSE 'No' END) ELSE 'Yes' END) AS is_unused ,I.[allow_row_locks] ,I.[allow_page_locks] ,I.[ignore_dup_key] ,S.no_recompute ,I.is_padded ,I.fill_factor ,DDIUS.user_seeks ,DDIUS.user_scans ,DDIUS.user_lookups ,DDIUS.user_updates ,DDIUS.last_user_seek ,DDIUS.last_user_scan ,DDIUS.last_user_lookup ,DDIUS.last_user_update ,DDIUS.system_seeks ,DDIUS.system_scans ,DDIUS.system_lookups ,DDIUS.system_updates ,DDIUS.last_system_seek ,DDIUS.last_system_scan ,DDIUS.last_system_lookup ,DDIUS.last_system_update ,I.is_unique_constraint ,I.index_id ,ROW_NUMBER () OVER ( PARTITION BY I.[object_id] ORDER BY I.is_primary_key DESC ,(CASE WHEN I.[type] = 0 THEN 'Z' ELSE 'A' END) ,I.[type] ,I.name ) AS row_filter FROM sys.indexes I INNER JOIN dbo.#temp_index_breakdown_size_info ttIBSI ON ttIBSI.[object_id] = I.[object_id] AND ttIBSI.index_id = I.index_id LEFT JOIN sys.key_constraints KC ON KC.parent_object_id = I.[object_id] AND KC.unique_index_id = I.index_id LEFT JOIN sys.stats S ON S.[object_id] = I.[object_id] AND S.stats_id = I.index_id LEFT JOIN master.sys.dm_db_index_usage_stats DDIUS ON DDIUS.[object_id] = I.[object_id] AND DDIUS.index_id = I.index_id AND DDIUS.database_id = @Database_ID ) sqI ON sqI.[object_id] = O.[object_id] WHERE O.[type] IN ('U', 'V') AND O.is_ms_shipped = 0 AND NOT ( SCHEMA_NAME (O.[schema_id]) = N'dbo' AND O.name = N'sysdiagrams' AND O.[type] = 'U' ) ) sqBAQ INNER JOIN ( SELECT C.[object_id] ,COUNT (*) + .0 AS total_columns FROM sys.columns C GROUP BY C.[object_id] ) sqCC ON sqCC.[object_id] = sqBAQ.[object_id] LEFT JOIN dbo.#temp_index_breakdown_keys_filters ttIBKF ON ttIBKF.[object_id] = sqBAQ.[object_id] AND ttIBKF.index_id = sqBAQ.index_id LEFT JOIN ( SELECT IC.[object_id] ,IC.index_id ,SUM (C.max_length) AS total_max_length FROM sys.index_columns IC INNER JOIN sys.columns C ON C.[object_id] = IC.[object_id] AND C.column_id = IC.column_id WHERE IC.is_included_column = 0 GROUP BY IC.[object_id] ,IC.index_id ) sqKL ON sqKL.[object_id] = sqBAQ.[object_id] AND sqKL.index_id = sqBAQ.index_id LEFT JOIN ( SELECT sqED01.dupe_rank ,sqED01.total_dupes ,ROW_NUMBER () OVER ( ORDER BY (SELECT NULL) ) AS dupe_id FROM ( SELECT ttIBKF.dupe_rank ,COUNT (*) AS total_dupes FROM dbo.#temp_index_breakdown_keys_filters ttIBKF GROUP BY ttIBKF.dupe_rank HAVING COUNT (*) > 1 ) sqED01 ) sqED02 ON sqED02.dupe_rank = ttIBKF.dupe_rank CROSS APPLY ( SELECT (CASE WHEN sqBAQ.modify_date = sqBAQ.create_date THEN REPLICATE ('.', 18) ELSE sqBAQ.modify_date END) AS modify_date ,LEN (ttIBKF.index_key) - LEN (REPLACE (ttIBKF.index_key, '•', '')) AS [index_columns] ,ISNULL (LEN (ttIBKF.include_key) - LEN (REPLACE (ttIBKF.include_key, '•', '')), 0) AS include_columns ) caMDKL ORDER BY sqBAQ.[type] ,SCHEMA_NAME (sqBAQ.[schema_id]) ,OBJECT_NAME (sqBAQ.[object_id]) ,sqBAQ.row_filter ----------------------------------------------------------------------------------------------------------------------------- -- Cleanup: Drop Any Remaining Temp Tables ----------------------------------------------------------------------------------------------------------------------------- IF OBJECT_ID (N'tempdb.dbo.#temp_index_breakdown_keys_filters', N'U') IS NOT NULL BEGIN DROP TABLE dbo.#temp_index_breakdown_keys_filters END IF OBJECT_ID (N'tempdb.dbo.#temp_index_breakdown_size_info', N'U') IS NOT NULL BEGIN DROP TABLE dbo.#temp_index_breakdown_size_info END
public by pan 245520 2 5 0
Replace all occurrences of a string in DB
<?php /** * @kudos http://stackoverflow.com/a/10182498 */ header("Content-Type: text/plain"); $host = "localhost"; $username = "root"; $password = ""; $database = "mydatabase"; $string_to_replace = 'old.example.com'; $new_string = 'new.example.com'; // Connect to database server mysql_connect($host, $username, $password); // Select database mysql_select_db($database); // List all tables in database $sql = "SHOW TABLES FROM ".$database; $tables_result = mysql_query($sql); if (!$tables_result) { echo "Database error, could not list tables\nMySQL error: " . mysql_error(); exit; } echo "In these fields '$string_to_replace' have been replaced with '$new_string'\n\n"; while ($table = mysql_fetch_row($tables_result)) { echo "Table: {$table[0]}\n"; $fields_result = mysql_query("SHOW COLUMNS FROM ".$table[0]); if (!$fields_result) { echo 'Could not run query: ' . mysql_error(); exit; } if (mysql_num_rows($fields_result) > 0) { while ($field = mysql_fetch_assoc($fields_result)) { if (stripos($field['Type'], "VARCHAR") !== false || stripos($field['Type'], "TEXT") !== false) { echo " ".$field['Field']."\n"; $sql = "UPDATE ".$table[0]." SET ".$field['Field']." = replace(".$field['Field'].", '$string_to_replace', '$new_string')"; mysql_query($sql); } } echo "\n"; } } mysql_free_result($tables_result);
public by wassim 196354 0 5 0
IOS reload data with last update data/time
- (void)reloadData { // Reload table data [self.tableView reloadData]; // End the refreshing if (self.refreshControl) { NSDateFormatter *formatter = [[NSDateFormatter alloc] init]; [formatter setDateFormat:@"MMM d, h:mm a"]; NSString *title = [NSString stringWithFormat:@"Last update: %@", [formatter stringFromDate:[NSDate date]]]; NSDictionary *attrsDictionary = [NSDictionary dictionaryWithObject:[UIColor whiteColor] forKey:NSForegroundColorAttributeName]; NSAttributedString *attributedTitle = [[NSAttributedString alloc] initWithString:title attributes:attrsDictionary]; self.refreshControl.attributedTitle = attributedTitle; [self.refreshControl endRefreshing]; } }
public by cghersi 179401 5 7 0
Apache Cayenne: how to select with Joins
ObjectContext context = getMyContext(); int id = ...; //the pk of the FirstClass table FirstClass n = Cayenne.objectForPK(context, FirstClass.class, id); Expression qualifier = ExpressionFactory.matchExp(FourthClass.THIRD_CLASS_PROPERTY + "." + ThirdClass.SECOND_CLASS_PROPERTY + "." + SecondClass.FIRST_CLASS_PROPERTY, n); SelectQuery select = new SelectQuery(FourthClass.class, qualifier); List<FourthClass> result = context.performQuery(select);
public by sherazam 2916 0 5 0
How to Insert Clone of an Existing Table in a Word Document inside .NET Apps
// Enter here the actual content of the snippet. //Code samples Shows how to insert a table using the constructors of nodes //[C# Code Sample] // For complete examples and data files, please go to https://github.com/asposewords/Aspose_Words_NET Document doc = new Document(dataDir + "Table.SimpleTable.doc"); // Retrieve the first table in the document. Table table = (Table)doc.GetChild(NodeType.Table, 0, true); // Create a clone of the table. Table tableClone = (Table)table.Clone(true); // Insert the cloned table into the document after the original table.ParentNode.InsertAfter(tableClone, table); // Insert an empty paragraph between the two tables or else they will be combined into one // upon save. This has to do with document validation. table.ParentNode.InsertAfter(new Paragraph(doc), table); dataDir = dataDir + "Table.CloneTableAndInsert_out_.doc"; // Save the document to disk. doc.Save(dataDir); // [Visual Basic Code Sample] ' For complete examples and data files, please go to https://github.com/asposewords/Aspose_Words_NET Dim doc As New Document(dataDir & Convert.ToString("Table.SimpleTable.doc")) ' Retrieve the first table in the document. Dim table As Table = DirectCast(doc.GetChild(NodeType.Table, 0, True), Table) ' Create a clone of the table. Dim tableClone As Table = DirectCast(table.Clone(True), Table) ' Insert the cloned table into the document after the original table.ParentNode.InsertAfter(tableClone, table) ' Insert an empty paragraph between the two tables or else they will be combined into one ' upon save. This has to do with document validation. table.ParentNode.InsertAfter(New Paragraph(doc), table) dataDir = dataDir & Convert.ToString("Table.CloneTableAndInsert_out_.doc") ' Save the document to disk. doc.Save(dataDir) // Code sample Shows how to make a clone of the last row of a table and append it to the table. //[C# Code Sample] // For complete examples and data files, please go to https://github.com/asposewords/Aspose_Words_NET Document doc = new Document(dataDir + "Table.SimpleTable.doc"); // Retrieve the first table in the document. Table table = (Table)doc.GetChild(NodeType.Table, 0, true); // Clone the last row in the table. Row clonedRow = (Row)table.LastRow.Clone(true); // Remove all content from the cloned row's cells. This makes the row ready for // new content to be inserted into. foreach (Cell cell in clonedRow.Cells) cell.RemoveAllChildren(); // Add the row to the end of the table. table.AppendChild(clonedRow); dataDir = dataDir + "Table.AddCloneRowToTable_out_.doc"; // Save the document to disk. doc.Save(dataDir); // [Visual Basic Code Sample] // [Visual Basic Code Sample] ' For complete examples and data files, please go to https://github.com/asposewords/Aspose_Words_NET Dim doc As New Document(dataDir & Convert.ToString("Table.SimpleTable.doc")) ' Retrieve the first table in the document. Dim table As Table = DirectCast(doc.GetChild(NodeType.Table, 0, True), Table) ' Clone the last row in the table. Dim clonedRow As Row = DirectCast(table.LastRow.Clone(True), Row) ' Remove all content from the cloned row's cells. This makes the row ready for ' new content to be inserted into. For Each cell As Cell In clonedRow.Cells cell.RemoveAllChildren() Next ' Add the row to the end of the table. table.AppendChild(clonedRow) dataDir = dataDir & Convert.ToString("Table.AddCloneRowToTable_out_.doc") ' Save the document to disk. doc.Save(dataDir)
public by juntalis 42938 0 3 0
Auto-generated table representing the global variables in CFF Explorer's lua interpreter.
_G = { ["AddDataToLastSection"] = function(...) end, ["AddResource"] = function(...) end, ["AddResourceRaw"] = function(...) end, ["AddSection"] = function(...) end, ["AddSectionHeader"] = function(...) end, ["AddSectionWithData"] = function(...) end, ["AfterDumpHeaderFix"] = function(...) end, ["BIF_BROWSEFORCOMPUTER"] = 4096, ["BIF_BROWSEFORPRINTER"] = 8192, ["BIF_BROWSEINCLUDEFILES"] = 16384, ["BIF_BROWSEINCLUDEURLS"] = 128, ["BIF_DONTGOBELOWDOMAIN"] = 2, ["BIF_EDITBOX"] = 16, ["BIF_NEWDIALOGSTYLE"] = 64, ["BIF_NONEWFOLDERBUTTON"] = 512, ["BIF_NOTRANSLATETARGETS"] = 1024, ["BIF_RETURNFSANCESTORS"] = 8, ["BIF_RETURNONLYFSDIRS"] = 1, ["BIF_SHAREABLE"] = 32768, ["BIF_STATUSTEXT"] = 4, ["BIF_UAHINT"] = 256, ["BIF_USENEWUI"] = 80, ["BIF_VALIDATE"] = 32, ["BindImports"] = function(...) end, ["COMIMAGE_FLAGS_32BITREQUIRED"] = 2, ["COMIMAGE_FLAGS_ILONLY"] = 1, ["COMIMAGE_FLAGS_IL_LIBRARY"] = 4, ["COMIMAGE_FLAGS_NATIVE_ENTRYPOINT"] = 16, ["COMIMAGE_FLAGS_STRONGNAMESIGNED"] = 8, ["COMIMAGE_FLAGS_TRACKDEBUGDATA"] = 65536, ["COR_DELETED_NAME_LENGTH"] = 8, ["COR_ILEXCEPTION_CLAUSE_DEPRECATED"] = 0, ["COR_ILEXCEPTION_CLAUSE_DUPLICATED"] = 8, ["COR_ILEXCEPTION_CLAUSE_FAULT"] = 4, ["COR_ILEXCEPTION_CLAUSE_FILTER"] = 1, ["COR_ILEXCEPTION_CLAUSE_FINALLY"] = 2, ["COR_ILEXCEPTION_CLAUSE_NONE"] = 0, ["COR_ILEXCEPTION_CLAUSE_OFFSETLEN"] = 0, ["COR_ILMETHOD_SECT_SMALL_MAX_DATASIZE"] = 255, ["COR_VERSION_MAJOR"] = 2, ["COR_VERSION_MAJOR_V2"] = 2, ["COR_VERSION_MINOR"] = 0, ["COR_VTABLEGAP_NAME_LENGTH"] = 8, ["COR_VTABLE_32BIT"] = 1, ["COR_VTABLE_64BIT"] = 2, ["COR_VTABLE_CALL_MOST_DERIVED"] = 16, ["COR_VTABLE_FROM_UNMANAGED"] = 4, ["CloseFile"] = function(...) end, ["CloseHandle"] = function(...) end, ["CloseLog"] = function(...) end, ["CompilationRelaxations_NoStringInterning"] = 8, ["CopyFile"] = function(...) end, ["CorILMethod_CompressedIL"] = 64, ["CorILMethod_FatFormat"] = 3, ["CorILMethod_FormatMask"] = 7, ["CorILMethod_FormatShift"] = 3, ["CorILMethod_InitLocals"] = 16, ["CorILMethod_MoreSects"] = 8, ["CorILMethod_Sect_EHTable"] = 1, ["CorILMethod_Sect_FatFormat"] = 64, ["CorILMethod_Sect_KindMask"] = 63, ["CorILMethod_Sect_MoreSects"] = 128, ["CorILMethod_Sect_OptILTable"] = 2, ["CorILMethod_Sect_Reserved"] = 0, ["CorILMethod_SmallFormat"] = 0, ["CorILMethod_TinyFormat"] = 2, ["CorILMethod_TinyFormat1"] = 6, ["CreateDirectory"] = function(...) end, ["CreateLog"] = function(...) end, ["DISASM_NET"] = 3, ["DISASM_X64"] = 2, ["DISASM_X86"] = 1, ["DISASM_X86_16"] = 0, ["DeleteDirectory"] = function(...) end, ["DeleteFile"] = function(...) end, ["DeleteResource"] = function(...) end, ["DeleteSection"] = function(...) end, ["DeleteSectionHeader"] = function(...) end, ["DropMemberRefCAs"] = 2, ["DumpSection"] = function(...) end, ["ELEMENT_TYPE_ARRAY"] = 20, ["ELEMENT_TYPE_BOOLEAN"] = 2, ["ELEMENT_TYPE_BYREF"] = 16, ["ELEMENT_TYPE_CHAR"] = 3, ["ELEMENT_TYPE_CLASS"] = 18, ["ELEMENT_TYPE_CMOD_OPT"] = 32, ["ELEMENT_TYPE_CMOD_REQD"] = 31, ["ELEMENT_TYPE_END"] = 0, ["ELEMENT_TYPE_FNPTR"] = 27, ["ELEMENT_TYPE_GENERICINST"] = 21, ["ELEMENT_TYPE_I"] = 24, ["ELEMENT_TYPE_I1"] = 4, ["ELEMENT_TYPE_I2"] = 6, ["ELEMENT_TYPE_I4"] = 8, ["ELEMENT_TYPE_I8"] = 10, ["ELEMENT_TYPE_INTERNAL"] = 33, ["ELEMENT_TYPE_MAX"] = 34, ["ELEMENT_TYPE_MODIFIER"] = 64, ["ELEMENT_TYPE_MVAR"] = 30, ["ELEMENT_TYPE_OBJECT"] = 28, ["ELEMENT_TYPE_PINNED"] = 69, ["ELEMENT_TYPE_PTR"] = 15, ["ELEMENT_TYPE_R4"] = 12, ["ELEMENT_TYPE_R4_HFA"] = 70, ["ELEMENT_TYPE_R8"] = 13, ["ELEMENT_TYPE_R8_HFA"] = 71, ["ELEMENT_TYPE_SENTINEL"] = 65, ["ELEMENT_TYPE_STRING"] = 14, ["ELEMENT_TYPE_SZARRAY"] = 29, ["ELEMENT_TYPE_TYPEDBYREF"] = 22, ["ELEMENT_TYPE_U"] = 25, ["ELEMENT_TYPE_U1"] = 5, ["ELEMENT_TYPE_U2"] = 7, ["ELEMENT_TYPE_U4"] = 9, ["ELEMENT_TYPE_U8"] = 11, ["ELEMENT_TYPE_VALUETYPE"] = 17, ["ELEMENT_TYPE_VAR"] = 19, ["ELEMENT_TYPE_VOID"] = 1, ["EMARCH_ENC_I17_IC_INST_WORD_POS_X"] = 12, ["EMARCH_ENC_I17_IC_INST_WORD_X"] = 3, ["EMARCH_ENC_I17_IC_SIZE_X"] = 1, ["EMARCH_ENC_I17_IC_VAL_POS_X"] = 21, ["EMARCH_ENC_I17_IMM41a_INST_WORD_POS_X"] = 14, ["EMARCH_ENC_I17_IMM41a_INST_WORD_X"] = 1, ["EMARCH_ENC_I17_IMM41a_SIZE_X"] = 10, ["EMARCH_ENC_I17_IMM41a_VAL_POS_X"] = 22, ["EMARCH_ENC_I17_IMM41b_INST_WORD_POS_X"] = 24, ["EMARCH_ENC_I17_IMM41b_INST_WORD_X"] = 1, ["EMARCH_ENC_I17_IMM41b_SIZE_X"] = 8, ["EMARCH_ENC_I17_IMM41b_VAL_POS_X"] = 32, ["EMARCH_ENC_I17_IMM41c_INST_WORD_POS_X"] = 0, ["EMARCH_ENC_I17_IMM41c_INST_WORD_X"] = 2, ["EMARCH_ENC_I17_IMM41c_SIZE_X"] = 23, ["EMARCH_ENC_I17_IMM41c_VAL_POS_X"] = 40, ["EMARCH_ENC_I17_IMM5C_INST_WORD_POS_X"] = 13, ["EMARCH_ENC_I17_IMM5C_INST_WORD_X"] = 3, ["EMARCH_ENC_I17_IMM5C_SIZE_X"] = 5, ["EMARCH_ENC_I17_IMM5C_VAL_POS_X"] = 16, ["EMARCH_ENC_I17_IMM7B_INST_WORD_POS_X"] = 4, ["EMARCH_ENC_I17_IMM7B_INST_WORD_X"] = 3, ["EMARCH_ENC_I17_IMM7B_SIZE_X"] = 7, ["EMARCH_ENC_I17_IMM7B_VAL_POS_X"] = 0, ["EMARCH_ENC_I17_IMM9D_INST_WORD_POS_X"] = 18, ["EMARCH_ENC_I17_IMM9D_INST_WORD_X"] = 3, ["EMARCH_ENC_I17_IMM9D_SIZE_X"] = 9, ["EMARCH_ENC_I17_IMM9D_VAL_POS_X"] = 7, ["EMARCH_ENC_I17_SIGN_INST_WORD_POS_X"] = 27, ["EMARCH_ENC_I17_SIGN_INST_WORD_X"] = 3, ["EMARCH_ENC_I17_SIGN_SIZE_X"] = 1, ["EMARCH_ENC_I17_SIGN_VAL_POS_X"] = 63, ["ExecuteApp"] = function(...) end, ["ExecuteAppAndWait"] = function(...) end, ["FALSE"] = false, ["FRAME_FPO"] = 0, ["FRAME_NONFPO"] = 3, ["FRAME_TRAP"] = 1, ["FRAME_TSS"] = 2, ["FillBytes"] = function(...) end, ["FindFile"] = function(...) end, ["GetArrayLength"] = function(...) end, ["GetCFFExplorerDirectory"] = function(...) end, ["GetCFFExplorerMachine"] = function(...) end, ["GetCurrentDirectory"] = function(...) end, ["GetDirectory"] = function(...) end, ["GetFileSize"] = function(...) end, ["GetLongPathName"] = function(...) end, ["GetNumberOfSections"] = function(...) end, ["GetOffset"] = function(...) end, ["GetOpenFile"] = function(...) end, ["GetSaveFile"] = function(...) end, ["GetShortPathName"] = function(...) end, ["HasHighPrivileges"] = function(...) end, ["IDOK"] = 1, ["IDCANCEL"] = 2, ["IDABORT"] = 3, ["IDRETRY"] = 4, ["IDIGNORE"] = 5, ["IDYES"] = 6, ["IDNO"] = 7, ["IDCLOSE"] = 8, ["IDHELP"] = 9, ["IDTRYAGAIN"] = 10, ["IDCONTINUE"] = 11, ["IMAGE_ARCHIVE_START_SIZE"] = 8, ["IMAGE_CEE_CS_BYVALUE"] = 10, ["IMAGE_CEE_CS_CALLCONV_C"] = 1, ["IMAGE_CEE_CS_CALLCONV_DEFAULT"] = 0, ["IMAGE_CEE_CS_CALLCONV_EXPLICITTHIS"] = 64, ["IMAGE_CEE_CS_CALLCONV_FASTCALL"] = 4, ["IMAGE_CEE_CS_CALLCONV_FIELD"] = 6, ["IMAGE_CEE_CS_CALLCONV_GENERIC"] = 16, ["IMAGE_CEE_CS_CALLCONV_GENERICINST"] = 10, ["IMAGE_CEE_CS_CALLCONV_HASTHIS"] = 32, ["IMAGE_CEE_CS_CALLCONV_LOCAL_SIG"] = 7, ["IMAGE_CEE_CS_CALLCONV_MASK"] = 15, ["IMAGE_CEE_CS_CALLCONV_MAX"] = 12, ["IMAGE_CEE_CS_CALLCONV_NATIVEVARARG"] = 11, ["IMAGE_CEE_CS_CALLCONV_PROPERTY"] = 8, ["IMAGE_CEE_CS_CALLCONV_STDCALL"] = 2, ["IMAGE_CEE_CS_CALLCONV_THISCALL"] = 3, ["IMAGE_CEE_CS_CALLCONV_UNMGD"] = 9, ["IMAGE_CEE_CS_CALLCONV_VARARG"] = 5, ["IMAGE_CEE_CS_END"] = 0, ["IMAGE_CEE_CS_I4"] = 2, ["IMAGE_CEE_CS_I8"] = 3, ["IMAGE_CEE_CS_OBJECT"] = 7, ["IMAGE_CEE_CS_PTR"] = 6, ["IMAGE_CEE_CS_R4"] = 4, ["IMAGE_CEE_CS_R8"] = 5, ["IMAGE_CEE_CS_STRUCT32"] = 9, ["IMAGE_CEE_CS_STRUCT4"] = 8, ["IMAGE_CEE_CS_VOID"] = 1, ["IMAGE_CEE_UNMANAGED_CALLCONV_C"] = 1, ["IMAGE_CEE_UNMANAGED_CALLCONV_FASTCALL"] = 4, ["IMAGE_CEE_UNMANAGED_CALLCONV_STDCALL"] = 2, ["IMAGE_CEE_UNMANAGED_CALLCONV_THISCALL"] = 3, ["IMAGE_COMDAT_SELECT_ANY"] = 2, ["IMAGE_COMDAT_SELECT_ASSOCIATIVE"] = 5, ["IMAGE_COMDAT_SELECT_EXACT_MATCH"] = 4, ["IMAGE_COMDAT_SELECT_LARGEST"] = 6, ["IMAGE_COMDAT_SELECT_NEWEST"] = 7, ["IMAGE_COMDAT_SELECT_NODUPLICATES"] = 1, ["IMAGE_COMDAT_SELECT_SAME_SIZE"] = 3, ["IMAGE_COR_EATJ_THUNK_SIZE"] = 32, ["IMAGE_COR_MIH_BASICBLOCK"] = 8, ["IMAGE_COR_MIH_EHRVA"] = 2, ["IMAGE_COR_MIH_METHODRVA"] = 1, ["IMAGE_DEBUG_MISC_EXENAME"] = 1, ["IMAGE_DEBUG_TYPE_BORLAND"] = 9, ["IMAGE_DEBUG_TYPE_CLSID"] = 11, ["IMAGE_DEBUG_TYPE_CODEVIEW"] = 2, ["IMAGE_DEBUG_TYPE_COFF"] = 1, ["IMAGE_DEBUG_TYPE_EXCEPTION"] = 5, ["IMAGE_DEBUG_TYPE_FIXUP"] = 6, ["IMAGE_DEBUG_TYPE_FPO"] = 3, ["IMAGE_DEBUG_TYPE_MISC"] = 4, ["IMAGE_DEBUG_TYPE_OMAP_FROM_SRC"] = 8, ["IMAGE_DEBUG_TYPE_OMAP_TO_SRC"] = 7, ["IMAGE_DEBUG_TYPE_UNKNOWN"] = 0, ["IMAGE_DIRECTORY_ENTRY_ARCHITECTURE"] = 7, ["IMAGE_DIRECTORY_ENTRY_BASERELOC"] = 5, ["IMAGE_DIRECTORY_ENTRY_BOUND_IMPORT"] = 11, ["IMAGE_DIRECTORY_ENTRY_COM_DESCRIPTOR"] = 14, ["IMAGE_DIRECTORY_ENTRY_DEBUG"] = 6, ["IMAGE_DIRECTORY_ENTRY_DELAY_IMPORT"] = 13, ["IMAGE_DIRECTORY_ENTRY_EXCEPTION"] = 3, ["IMAGE_DIRECTORY_ENTRY_EXPORT"] = 0, ["IMAGE_DIRECTORY_ENTRY_GLOBALPTR"] = 8, ["IMAGE_DIRECTORY_ENTRY_IAT"] = 12, ["IMAGE_DIRECTORY_ENTRY_IMPORT"] = 1, ["IMAGE_DIRECTORY_ENTRY_LOAD_CONFIG"] = 10, ["IMAGE_DIRECTORY_ENTRY_NET_DESCRIPTOR"] = 14, ["IMAGE_DIRECTORY_ENTRY_RESOURCE"] = 2, ["IMAGE_DIRECTORY_ENTRY_SECURITY"] = 4, ["IMAGE_DIRECTORY_ENTRY_TLS"] = 9, ["IMAGE_DLLCHARACTERISTICS_NO_BIND"] = 2048, ["IMAGE_DLLCHARACTERISTICS_NO_ISOLATION"] = 512, ["IMAGE_DLLCHARACTERISTICS_NO_SEH"] = 1024, ["IMAGE_DLLCHARACTERISTICS_TERMINAL_SERVER_AWARE"] = 32768, ["IMAGE_DLLCHARACTERISTICS_WDM_DRIVER"] = 8192, ["IMAGE_DOS_SIGNATURE"] = 23117, ["IMAGE_FILE_32BIT_MACHINE"] = 256, ["IMAGE_FILE_AGGRESIVE_WS_TRIM"] = 16, ["IMAGE_FILE_BYTES_REVERSED_HI"] = 32768, ["IMAGE_FILE_BYTES_REVERSED_LO"] = 128, ["IMAGE_FILE_DEBUG_STRIPPED"] = 512, ["IMAGE_FILE_DLL"] = 8192, ["IMAGE_FILE_EXECUTABLE_IMAGE"] = 2, ["IMAGE_FILE_LARGE_ADDRESS_AWARE"] = 32, ["IMAGE_FILE_LINE_NUMS_STRIPPED"] = 4, ["IMAGE_FILE_LOCAL_SYMS_STRIPPED"] = 8, ["IMAGE_FILE_MACHINE_ALPHA"] = 388, ["IMAGE_FILE_MACHINE_ALPHA64"] = 644, ["IMAGE_FILE_MACHINE_AM33"] = 467, ["IMAGE_FILE_MACHINE_AMD64"] = 34404, ["IMAGE_FILE_MACHINE_ARM"] = 448, ["IMAGE_FILE_MACHINE_AXP64"] = 644, ["IMAGE_FILE_MACHINE_CEE"] = 49390, ["IMAGE_FILE_MACHINE_CEF"] = 3311, ["IMAGE_FILE_MACHINE_EBC"] = 3772, ["IMAGE_FILE_MACHINE_I386"] = 332, ["IMAGE_FILE_MACHINE_IA64"] = 512, ["IMAGE_FILE_MACHINE_M32R"] = 36929, ["IMAGE_FILE_MACHINE_MIPS16"] = 614, ["IMAGE_FILE_MACHINE_MIPSFPU"] = 870, ["IMAGE_FILE_MACHINE_MIPSFPU16"] = 1126, ["IMAGE_FILE_MACHINE_POWERPC"] = 496, ["IMAGE_FILE_MACHINE_POWERPCFP"] = 497, ["IMAGE_FILE_MACHINE_R10000"] = 360, ["IMAGE_FILE_MACHINE_R3000"] = 354, ["IMAGE_FILE_MACHINE_R4000"] = 358, ["IMAGE_FILE_MACHINE_SH3"] = 418, ["IMAGE_FILE_MACHINE_SH3DSP"] = 419, ["IMAGE_FILE_MACHINE_SH3E"] = 420, ["IMAGE_FILE_MACHINE_SH4"] = 422, ["IMAGE_FILE_MACHINE_SH5"] = 424, ["IMAGE_FILE_MACHINE_THUMB"] = 450, ["IMAGE_FILE_MACHINE_TRICORE"] = 1312, ["IMAGE_FILE_MACHINE_UNKNOWN"] = 0, ["IMAGE_FILE_MACHINE_WCEMIPSV2"] = 361, ["IMAGE_FILE_NET_RUN_FROM_SWAP"] = 2048, ["IMAGE_FILE_RELOCS_STRIPPED"] = 1, ["IMAGE_FILE_REMOVABLE_RUN_FROM_SWAP"] = 1024, ["IMAGE_FILE_SYSTEM"] = 4096, ["IMAGE_FILE_UP_SYSTEM_ONLY"] = 16384, ["IMAGE_NT_OPTIONAL_HDR32_MAGIC"] = 267, ["IMAGE_NT_OPTIONAL_HDR64_MAGIC"] = 523, ["IMAGE_NT_SIGNATURE"] = 17744, ["IMAGE_NUMBEROF_DIRECTORY_ENTRIES"] = 16, ["IMAGE_ORDINAL_FLAG32"] = 2147483648, ["IMAGE_ORDINAL_FLAG64"] = -9223372036854775808, ["IMAGE_OS2_SIGNATURE"] = 17742, ["IMAGE_OS2_SIGNATURE_LE"] = 17740, ["IMAGE_REL_ALPHA_ABSOLUTE"] = 0, ["IMAGE_REL_ALPHA_BRADDR"] = 7, ["IMAGE_REL_ALPHA_GPDISP"] = 6, ["IMAGE_REL_ALPHA_GPREL32"] = 3, ["IMAGE_REL_ALPHA_GPRELHI"] = 23, ["IMAGE_REL_ALPHA_GPRELLO"] = 22, ["IMAGE_REL_ALPHA_HINT"] = 8, ["IMAGE_REL_ALPHA_INLINE_REFLONG"] = 9, ["IMAGE_REL_ALPHA_LITERAL"] = 4, ["IMAGE_REL_ALPHA_LITUSE"] = 5, ["IMAGE_REL_ALPHA_MATCH"] = 13, ["IMAGE_REL_ALPHA_PAIR"] = 12, ["IMAGE_REL_ALPHA_REFHI"] = 10, ["IMAGE_REL_ALPHA_REFLO"] = 11, ["IMAGE_REL_ALPHA_REFLONG"] = 1, ["IMAGE_REL_ALPHA_REFLONGNB"] = 16, ["IMAGE_REL_ALPHA_REFQ1"] = 21, ["IMAGE_REL_ALPHA_REFQ2"] = 20, ["IMAGE_REL_ALPHA_REFQ3"] = 19, ["IMAGE_REL_ALPHA_REFQUAD"] = 2, ["IMAGE_REL_ALPHA_SECREL"] = 15, ["IMAGE_REL_ALPHA_SECRELHI"] = 18, ["IMAGE_REL_ALPHA_SECRELLO"] = 17, ["IMAGE_REL_ALPHA_SECTION"] = 14, ["IMAGE_REL_AMD64_ABSOLUTE"] = 0, ["IMAGE_REL_AMD64_ADDR32"] = 2, ["IMAGE_REL_AMD64_ADDR32NB"] = 3, ["IMAGE_REL_AMD64_ADDR64"] = 1, ["IMAGE_REL_AMD64_PAIR"] = 15, ["IMAGE_REL_AMD64_REL32"] = 4, ["IMAGE_REL_AMD64_REL32_1"] = 5, ["IMAGE_REL_AMD64_REL32_2"] = 6, ["IMAGE_REL_AMD64_REL32_3"] = 7, ["IMAGE_REL_AMD64_REL32_4"] = 8, ["IMAGE_REL_AMD64_REL32_5"] = 9, ["IMAGE_REL_AMD64_SECREL"] = 11, ["IMAGE_REL_AMD64_SECREL7"] = 12, ["IMAGE_REL_AMD64_SECTION"] = 10, ["IMAGE_REL_AMD64_SREL32"] = 14, ["IMAGE_REL_AMD64_SSPAN32"] = 16, ["IMAGE_REL_AMD64_TOKEN"] = 13, ["IMAGE_REL_AM_ABSOLUTE"] = 0, ["IMAGE_REL_AM_ADDR32"] = 1, ["IMAGE_REL_AM_ADDR32NB"] = 2, ["IMAGE_REL_AM_CALL32"] = 3, ["IMAGE_REL_AM_FUNCINFO"] = 4, ["IMAGE_REL_AM_REL32_1"] = 5, ["IMAGE_REL_AM_REL32_2"] = 6, ["IMAGE_REL_AM_SECREL"] = 7, ["IMAGE_REL_AM_SECTION"] = 8, ["IMAGE_REL_AM_TOKEN"] = 9, ["IMAGE_REL_ARM_ABSOLUTE"] = 0, ["IMAGE_REL_ARM_ADDR32"] = 1, ["IMAGE_REL_ARM_ADDR32NB"] = 2, ["IMAGE_REL_ARM_BLX11"] = 9, ["IMAGE_REL_ARM_BLX24"] = 8, ["IMAGE_REL_ARM_BRANCH11"] = 4, ["IMAGE_REL_ARM_BRANCH24"] = 3, ["IMAGE_REL_ARM_GPREL12"] = 6, ["IMAGE_REL_ARM_GPREL7"] = 7, ["IMAGE_REL_ARM_SECREL"] = 15, ["IMAGE_REL_ARM_SECTION"] = 14, ["IMAGE_REL_ARM_TOKEN"] = 5, ["IMAGE_REL_BASED_ABSOLUTE"] = 0, ["IMAGE_REL_BASED_DIR64"] = 10, ["IMAGE_REL_BASED_HIGH"] = 1, ["IMAGE_REL_BASED_HIGHADJ"] = 4, ["IMAGE_REL_BASED_HIGHLOW"] = 3, ["IMAGE_REL_BASED_IA64_IMM64"] = 9, ["IMAGE_REL_BASED_LOW"] = 2, ["IMAGE_REL_BASED_MIPS_JMPADDR"] = 5, ["IMAGE_REL_BASED_MIPS_JMPADDR16"] = 9, ["IMAGE_REL_CEE_ABSOLUTE"] = 0, ["IMAGE_REL_CEE_ADDR32"] = 1, ["IMAGE_REL_CEE_ADDR32NB"] = 3, ["IMAGE_REL_CEE_ADDR64"] = 2, ["IMAGE_REL_CEE_SECREL"] = 5, ["IMAGE_REL_CEE_SECTION"] = 4, ["IMAGE_REL_CEE_TOKEN"] = 6, ["IMAGE_REL_CEF_ABSOLUTE"] = 0, ["IMAGE_REL_CEF_ADDR32"] = 1, ["IMAGE_REL_CEF_ADDR32NB"] = 3, ["IMAGE_REL_CEF_ADDR64"] = 2, ["IMAGE_REL_CEF_SECREL"] = 5, ["IMAGE_REL_CEF_SECTION"] = 4, ["IMAGE_REL_CEF_TOKEN"] = 6, ["IMAGE_REL_I386_ABSOLUTE"] = 0, ["IMAGE_REL_I386_DIR16"] = 1, ["IMAGE_REL_I386_DIR32"] = 6, ["IMAGE_REL_I386_DIR32NB"] = 7, ["IMAGE_REL_I386_REL16"] = 2, ["IMAGE_REL_I386_REL32"] = 20, ["IMAGE_REL_I386_SECREL"] = 11, ["IMAGE_REL_I386_SECREL7"] = 13, ["IMAGE_REL_I386_SECTION"] = 10, ["IMAGE_REL_I386_SEG12"] = 9, ["IMAGE_REL_I386_TOKEN"] = 12, ["IMAGE_REL_IA64_ABSOLUTE"] = 0, ["IMAGE_REL_IA64_ADDEND"] = 31, ["IMAGE_REL_IA64_DIR32"] = 4, ["IMAGE_REL_IA64_DIR32NB"] = 16, ["IMAGE_REL_IA64_DIR64"] = 5, ["IMAGE_REL_IA64_GPREL22"] = 9, ["IMAGE_REL_IA64_GPREL32"] = 28, ["IMAGE_REL_IA64_IMM14"] = 1, ["IMAGE_REL_IA64_IMM22"] = 2, ["IMAGE_REL_IA64_IMM64"] = 3, ["IMAGE_REL_IA64_IMMGPREL64"] = 26, ["IMAGE_REL_IA64_LTOFF22"] = 10, ["IMAGE_REL_IA64_PCREL21B"] = 6, ["IMAGE_REL_IA64_PCREL21F"] = 8, ["IMAGE_REL_IA64_PCREL21M"] = 7, ["IMAGE_REL_IA64_PCREL60B"] = 22, ["IMAGE_REL_IA64_PCREL60F"] = 23, ["IMAGE_REL_IA64_PCREL60I"] = 24, ["IMAGE_REL_IA64_PCREL60M"] = 25, ["IMAGE_REL_IA64_PCREL60X"] = 21, ["IMAGE_REL_IA64_SECREL22"] = 12, ["IMAGE_REL_IA64_SECREL32"] = 14, ["IMAGE_REL_IA64_SECREL64I"] = 13, ["IMAGE_REL_IA64_SECTION"] = 11, ["IMAGE_REL_IA64_SREL14"] = 17, ["IMAGE_REL_IA64_SREL22"] = 18, ["IMAGE_REL_IA64_SREL32"] = 19, ["IMAGE_REL_IA64_TOKEN"] = 27, ["IMAGE_REL_IA64_UREL32"] = 20, ["IMAGE_REL_M32R_ABSOLUTE"] = 0, ["IMAGE_REL_M32R_ADDR24"] = 3, ["IMAGE_REL_M32R_ADDR32"] = 1, ["IMAGE_REL_M32R_ADDR32NB"] = 2, ["IMAGE_REL_M32R_GPREL16"] = 4, ["IMAGE_REL_M32R_PAIR"] = 11, ["IMAGE_REL_M32R_PCREL16"] = 6, ["IMAGE_REL_M32R_PCREL24"] = 5, ["IMAGE_REL_M32R_PCREL8"] = 7, ["IMAGE_REL_M32R_REFHALF"] = 8, ["IMAGE_REL_M32R_REFHI"] = 9, ["IMAGE_REL_M32R_REFLO"] = 10, ["IMAGE_REL_M32R_SECREL32"] = 13, ["IMAGE_REL_M32R_SECTION"] = 12, ["IMAGE_REL_M32R_TOKEN"] = 14, ["IMAGE_REL_MIPS_ABSOLUTE"] = 0, ["IMAGE_REL_MIPS_GPREL"] = 6, ["IMAGE_REL_MIPS_JMPADDR"] = 3, ["IMAGE_REL_MIPS_LITERAL"] = 7, ["IMAGE_REL_MIPS_PAIR"] = 37, ["IMAGE_REL_MIPS_REFHALF"] = 1, ["IMAGE_REL_MIPS_REFHI"] = 4, ["IMAGE_REL_MIPS_REFLO"] = 5, ["IMAGE_REL_MIPS_REFWORD"] = 2, ["IMAGE_REL_MIPS_REFWORDNB"] = 34, ["IMAGE_REL_MIPS_SECREL"] = 11, ["IMAGE_REL_MIPS_SECRELHI"] = 13, ["IMAGE_REL_MIPS_SECRELLO"] = 12, ["IMAGE_REL_MIPS_SECTION"] = 10, ["IMAGE_REL_MIPS_TOKEN"] = 14, ["IMAGE_REL_PPC_ABSOLUTE"] = 0, ["IMAGE_REL_PPC_ADDR14"] = 5, ["IMAGE_REL_PPC_ADDR16"] = 4, ["IMAGE_REL_PPC_ADDR24"] = 3, ["IMAGE_REL_PPC_ADDR32"] = 2, ["IMAGE_REL_PPC_ADDR32NB"] = 10, ["IMAGE_REL_PPC_ADDR64"] = 1, ["IMAGE_REL_PPC_BRNTAKEN"] = 1024, ["IMAGE_REL_PPC_BRTAKEN"] = 512, ["IMAGE_REL_PPC_GPREL"] = 21, ["IMAGE_REL_PPC_IFGLUE"] = 13, ["IMAGE_REL_PPC_IMGLUE"] = 14, ["IMAGE_REL_PPC_NEG"] = 256, ["IMAGE_REL_PPC_PAIR"] = 18, ["IMAGE_REL_PPC_REFHI"] = 16, ["IMAGE_REL_PPC_REFLO"] = 17, ["IMAGE_REL_PPC_REL14"] = 7, ["IMAGE_REL_PPC_REL24"] = 6, ["IMAGE_REL_PPC_SECREL"] = 11, ["IMAGE_REL_PPC_SECREL16"] = 15, ["IMAGE_REL_PPC_SECRELHI"] = 20, ["IMAGE_REL_PPC_SECRELLO"] = 19, ["IMAGE_REL_PPC_SECTION"] = 12, ["IMAGE_REL_PPC_TOCDEFN"] = 2048, ["IMAGE_REL_PPC_TOCREL14"] = 9, ["IMAGE_REL_PPC_TOCREL16"] = 8, ["IMAGE_REL_PPC_TOKEN"] = 22, ["IMAGE_REL_PPC_TYPEMASK"] = 255, ["IMAGE_REL_SH3_ABSOLUTE"] = 0, ["IMAGE_REL_SH3_DIRECT16"] = 1, ["IMAGE_REL_SH3_DIRECT32"] = 2, ["IMAGE_REL_SH3_DIRECT32_NB"] = 16, ["IMAGE_REL_SH3_DIRECT4"] = 6, ["IMAGE_REL_SH3_DIRECT4_LONG"] = 8, ["IMAGE_REL_SH3_DIRECT4_WORD"] = 7, ["IMAGE_REL_SH3_DIRECT8"] = 3, ["IMAGE_REL_SH3_DIRECT8_LONG"] = 5, ["IMAGE_REL_SH3_DIRECT8_WORD"] = 4, ["IMAGE_REL_SH3_GPREL4_LONG"] = 17, ["IMAGE_REL_SH3_PCREL12_WORD"] = 11, ["IMAGE_REL_SH3_PCREL8_LONG"] = 10, ["IMAGE_REL_SH3_PCREL8_WORD"] = 9, ["IMAGE_REL_SH3_SECREL"] = 15, ["IMAGE_REL_SH3_SECTION"] = 14, ["IMAGE_REL_SH3_SIZEOF_SECTION"] = 13, ["IMAGE_REL_SH3_STARTOF_SECTION"] = 12, ["IMAGE_REL_SH3_TOKEN"] = 18, ["IMAGE_RESOURCE_DATA_IS_DIRECTORY"] = 2147483648, ["IMAGE_RESOURCE_NAME_IS_STRING"] = 2147483648, ["IMAGE_ROM_OPTIONAL_HDR_MAGIC"] = 263, ["IMAGE_SCN_ALIGN_MASK"] = 15728640, ["IMAGE_SCN_CNT_CODE"] = 32, ["IMAGE_SCN_CNT_INITIALIZED_DATA"] = 64, ["IMAGE_SCN_CNT_UNINITIALIZED_DATA"] = 128, ["IMAGE_SCN_GPREL"] = 32768, ["IMAGE_SCN_LNK_COMDAT"] = 4096, ["IMAGE_SCN_LNK_INFO"] = 512, ["IMAGE_SCN_LNK_NRELOC_OVFL"] = 16777216, ["IMAGE_SCN_LNK_OTHER"] = 256, ["IMAGE_SCN_LNK_REMOVE"] = 2048, ["IMAGE_SCN_MEM_DISCARDABLE"] = 33554432, ["IMAGE_SCN_MEM_EXECUTE"] = 536870912, ["IMAGE_SCN_MEM_FARDATA"] = 32768, ["IMAGE_SCN_MEM_LOCKED"] = 262144, ["IMAGE_SCN_MEM_NOT_CACHED"] = 67108864, ["IMAGE_SCN_MEM_NOT_PAGED"] = 134217728, ["IMAGE_SCN_MEM_PRELOAD"] = 524288, ["IMAGE_SCN_MEM_PURGEABLE"] = 131072, ["IMAGE_SCN_MEM_READ"] = 1073741824, ["IMAGE_SCN_MEM_SHARED"] = 268435456, ["IMAGE_SCN_MEM_WRITE"] = 2147483648, ["IMAGE_SCN_NO_DEFER_SPEC_EXC"] = 16384, ["IMAGE_SCN_SCALE_INDEX"] = 1, ["IMAGE_SCN_TYPE_NO_PAD"] = 8, ["IMAGE_SEPARATE_DEBUG_FLAGS_MASK"] = 32768, ["IMAGE_SEPARATE_DEBUG_MISMATCH"] = 32768, ["IMAGE_SEPARATE_DEBUG_SIGNATURE"] = 18756, ["IMAGE_SIZEOF_ARCHIVE_MEMBER_HDR"] = 60, ["IMAGE_SIZEOF_FILE_HEADER"] = 20, ["IMAGE_SIZEOF_SECTION_HEADER"] = 40, ["IMAGE_SIZEOF_SHORT_NAME"] = 8, ["IMAGE_SIZEOF_SYMBOL"] = 18, ["IMAGE_SUBSYSTEM_EFI_APPLICATION"] = 10, ["IMAGE_SUBSYSTEM_EFI_BOOT_SERVICE_DRIVER"] = 11, ["IMAGE_SUBSYSTEM_EFI_ROM"] = 13, ["IMAGE_SUBSYSTEM_EFI_RUNTIME_DRIVER"] = 12, ["IMAGE_SUBSYSTEM_NATIVE"] = 1, ["IMAGE_SUBSYSTEM_NATIVE_WINDOWS"] = 8, ["IMAGE_SUBSYSTEM_OS2_CUI"] = 5, ["IMAGE_SUBSYSTEM_POSIX_CUI"] = 7, ["IMAGE_SUBSYSTEM_UNKNOWN"] = 0, ["IMAGE_SUBSYSTEM_WINDOWS_CE_GUI"] = 9, ["IMAGE_SUBSYSTEM_WINDOWS_CUI"] = 3, ["IMAGE_SUBSYSTEM_WINDOWS_GUI"] = 2, ["IMAGE_SUBSYSTEM_XBOX"] = 14, ["IMAGE_SYM_ABSOLUTE"] = -1, ["IMAGE_SYM_CLASS_ARGUMENT"] = 9, ["IMAGE_SYM_CLASS_AUTOMATIC"] = 1, ["IMAGE_SYM_CLASS_BIT_FIELD"] = 18, ["IMAGE_SYM_CLASS_BLOCK"] = 100, ["IMAGE_SYM_CLASS_CLR_TOKEN"] = 107, ["IMAGE_SYM_CLASS_END_OF_FUNCTION"] = 255, ["IMAGE_SYM_CLASS_END_OF_STRUCT"] = 102, ["IMAGE_SYM_CLASS_ENUM_TAG"] = 15, ["IMAGE_SYM_CLASS_EXTERNAL"] = 2, ["IMAGE_SYM_CLASS_EXTERNAL_DEF"] = 5, ["IMAGE_SYM_CLASS_FAR_EXTERNAL"] = 68, ["IMAGE_SYM_CLASS_FILE"] = 103, ["IMAGE_SYM_CLASS_FUNCTION"] = 101, ["IMAGE_SYM_CLASS_LABEL"] = 6, ["IMAGE_SYM_CLASS_MEMBER_OF_ENUM"] = 16, ["IMAGE_SYM_CLASS_MEMBER_OF_STRUCT"] = 8, ["IMAGE_SYM_CLASS_MEMBER_OF_UNION"] = 11, ["IMAGE_SYM_CLASS_NULL"] = 0, ["IMAGE_SYM_CLASS_REGISTER"] = 4, ["IMAGE_SYM_CLASS_REGISTER_PARAM"] = 17, ["IMAGE_SYM_CLASS_SECTION"] = 104, ["IMAGE_SYM_CLASS_STATIC"] = 3, ["IMAGE_SYM_CLASS_STRUCT_TAG"] = 10, ["IMAGE_SYM_CLASS_TYPE_DEFINITION"] = 13, ["IMAGE_SYM_CLASS_UNDEFINED_LABEL"] = 7, ["IMAGE_SYM_CLASS_UNDEFINED_STATIC"] = 14, ["IMAGE_SYM_CLASS_UNION_TAG"] = 12, ["IMAGE_SYM_CLASS_WEAK_EXTERNAL"] = 105, ["IMAGE_SYM_DEBUG"] = -2, ["IMAGE_SYM_DTYPE_ARRAY"] = 3, ["IMAGE_SYM_DTYPE_FUNCTION"] = 2, ["IMAGE_SYM_DTYPE_NULL"] = 0, ["IMAGE_SYM_DTYPE_POINTER"] = 1, ["IMAGE_SYM_SECTION_MAX"] = 65279, ["IMAGE_SYM_TYPE_BYTE"] = 12, ["IMAGE_SYM_TYPE_CHAR"] = 2, ["IMAGE_SYM_TYPE_DOUBLE"] = 7, ["IMAGE_SYM_TYPE_DWORD"] = 15, ["IMAGE_SYM_TYPE_ENUM"] = 10, ["IMAGE_SYM_TYPE_FLOAT"] = 6, ["IMAGE_SYM_TYPE_INT"] = 4, ["IMAGE_SYM_TYPE_LONG"] = 5, ["IMAGE_SYM_TYPE_MOE"] = 11, ["IMAGE_SYM_TYPE_NULL"] = 0, ["IMAGE_SYM_TYPE_PCODE"] = 32768, ["IMAGE_SYM_TYPE_SHORT"] = 3, ["IMAGE_SYM_TYPE_STRUCT"] = 8, ["IMAGE_SYM_TYPE_UINT"] = 14, ["IMAGE_SYM_TYPE_UNION"] = 9, ["IMAGE_SYM_TYPE_VOID"] = 1, ["IMAGE_SYM_TYPE_WORD"] = 13, ["IMAGE_SYM_UNDEFINED"] = 0, ["IMAGE_VXD_SIGNATURE"] = 17740, ["IMAGE_WEAK_EXTERN_SEARCH_ALIAS"] = 3, ["IMAGE_WEAK_EXTERN_SEARCH_LIBRARY"] = 2, ["IMAGE_WEAK_EXTERN_SEARCH_NOLIBRARY"] = 1, ["INVALID_ADDRESS"] = 134217727, ["ImportResourceDirectory"] = function(...) end, ["InitFindFile"] = function(...) end, ["InputBox"] = function(...) end, ["InvertJump"] = function(...) end, ["IsDotNET"] = function(...) end, ["IsPE64"] = function(...) end, ["IsRvaValid"] = function(...) end, ["LANG_AFRIKAANS"] = 54, ["LANG_ALBANIAN"] = 28, ["LANG_ARABIC"] = 1, ["LANG_ARMENIAN"] = 43, ["LANG_ASSAMESE"] = 77, ["LANG_AZERI"] = 44, ["LANG_BASQUE"] = 45, ["LANG_BELARUSIAN"] = 35, ["LANG_BENGALI"] = 69, ["LANG_BULGARIAN"] = 2, ["LANG_CATALAN"] = 3, ["LANG_CHINESE"] = 4, ["LANG_CROATIAN"] = 26, ["LANG_CZECH"] = 5, ["LANG_DANISH"] = 6, ["LANG_DIVEHI"] = 101, ["LANG_DUTCH"] = 19, ["LANG_ENGLISH"] = 9, ["LANG_ESTONIAN"] = 37, ["LANG_FAEROESE"] = 56, ["LANG_FARSI"] = 41, ["LANG_FINNISH"] = 11, ["LANG_FRENCH"] = 12, ["LANG_GALICIAN"] = 86, ["LANG_GEORGIAN"] = 55, ["LANG_GERMAN"] = 7, ["LANG_GREEK"] = 8, ["LANG_GUJARATI"] = 71, ["LANG_HEBREW"] = 13, ["LANG_HINDI"] = 57, ["LANG_HUNGARIAN"] = 14, ["LANG_ICELANDIC"] = 15, ["LANG_INDONESIAN"] = 33, ["LANG_INVARIANT"] = 127, ["LANG_ITALIAN"] = 16, ["LANG_JAPANESE"] = 17, ["LANG_KANNADA"] = 75, ["LANG_KASHMIRI"] = 96, ["LANG_KAZAK"] = 63, ["LANG_KONKANI"] = 87, ["LANG_KOREAN"] = 18, ["LANG_KYRGYZ"] = 64, ["LANG_LATVIAN"] = 38, ["LANG_LITHUANIAN"] = 39, ["LANG_MACEDONIAN"] = 47, ["LANG_MALAY"] = 62, ["LANG_MALAYALAM"] = 76, ["LANG_MANIPURI"] = 88, ["LANG_MARATHI"] = 78, ["LANG_MONGOLIAN"] = 80, ["LANG_NEPALI"] = 97, ["LANG_NEUTRAL"] = 0, ["LANG_NORWEGIAN"] = 20, ["LANG_ORIYA"] = 72, ["LANG_POLISH"] = 21, ["LANG_PORTUGUESE"] = 22, ["LANG_PUNJABI"] = 70, ["LANG_ROMANIAN"] = 24, ["LANG_RUSSIAN"] = 25, ["LANG_SANSKRIT"] = 79, ["LANG_SERBIAN"] = 26, ["LANG_SINDHI"] = 89, ["LANG_SLOVAK"] = 27, ["LANG_SLOVENIAN"] = 36, ["LANG_SPANISH"] = 10, ["LANG_SWAHILI"] = 65, ["LANG_SWEDISH"] = 29, ["LANG_SYRIAC"] = 90, ["LANG_TAMIL"] = 73, ["LANG_TATAR"] = 68, ["LANG_TELUGU"] = 74, ["LANG_THAI"] = 30, ["LANG_TURKISH"] = 31, ["LANG_UKRAINIAN"] = 34, ["LANG_URDU"] = 32, ["LANG_UZBEK"] = 67, ["LANG_VIETNAMESE"] = 42, ["LoadAlways"] = 1, ["LoadDefault"] = 0, ["LoadNever"] = 3, ["LoadSometimes"] = 2, ["LogPrint"] = function(...) end, ["LogPrintStruct"] = function(...) end, ["MAKELANGID"] = function(...) end, ["MAX_CLASS_NAME"] = 1024, ["MAX_PACKAGE_NAME"] = 1024, ["MB_ABORTRETRYIGNORE"] = 2, ["MB_APPLMODAL"] = 0, ["MB_CANCELTRYCONTINUE"] = 6, ["MB_DEFAULT_DESKTOP_ONLY"] = 131072, ["MB_DEFBUTTON1"] = 0, ["MB_DEFBUTTON2"] = 256, ["MB_DEFBUTTON3"] = 512, ["MB_DEFBUTTON4"] = 768, ["MB_DEFMASK"] = 3840, ["MB_HELP"] = 16384, ["MB_ICONASTERISK"] = 64, ["MB_ICONERROR"] = 16, ["MB_ICONEXCLAMATION"] = 48, ["MB_ICONHAND"] = 16, ["MB_ICONINFORMATION"] = 64, ["MB_ICONMASK"] = 240, ["MB_ICONQUESTION"] = 32, ["MB_ICONSTOP"] = 16, ["MB_ICONWARNING"] = 48, ["MB_MISCMASK"] = 49152, ["MB_MODEMASK"] = 12288, ["MB_NOFOCUS"] = 32768, ["MB_OK"] = 0, ["MB_OKCANCEL"] = 1, ["MB_RETRYCANCEL"] = 5, ["MB_RIGHT"] = 524288, ["MB_RTLREADING"] = 1048576, ["MB_SETFOREGROUND"] = 65536, ["MB_SYSTEMMODAL"] = 4096, ["MB_TASKMODAL"] = 8192, ["MB_TOPMOST"] = 262144, ["MB_TYPEMASK"] = 15, ["MB_USERICON"] = 128, ["MB_YESNO"] = 4, ["MB_YESNOCANCEL"] = 3, ["MDAssembly"] = 0, ["MDDupAll"] = -1, ["MDDupAssembly"] = 268435456, ["MDDupAssemblyRef"] = 32768, ["MDDupCustomAttribute"] = 32, ["MDDupDefault"] = 1058840, ["MDDupENC"] = -1, ["MDDupEvent"] = 512, ["MDDupExportedType"] = 131072, ["MDDupFieldDef"] = 1024, ["MDDupFile"] = 65536, ["MDDupGenericParam"] = 524288, ["MDDupGenericParamConstraint"] = 2097152, ["MDDupImplMap"] = 16384, ["MDDupInterfaceImpl"] = 2, ["MDDupManifestResource"] = 262144, ["MDDupMemberRef"] = 16, ["MDDupMethodDef"] = 4, ["MDDupMethodSpec"] = 1048576, ["MDDupModuleRef"] = 4096, ["MDDupParamDef"] = 64, ["MDDupPermission"] = 128, ["MDDupProperty"] = 256, ["MDDupSignature"] = 2048, ["MDDupTypeDef"] = 1, ["MDDupTypeRef"] = 8, ["MDDupTypeSpec"] = 8192, ["MDErrorOutOfOrderAll"] = -1, ["MDErrorOutOfOrderDefault"] = 0, ["MDErrorOutOfOrderNone"] = 0, ["MDEventOutOfOrder"] = 16, ["MDFieldOutOfOrder"] = 2, ["MDImportOptionAll"] = -1, ["MDImportOptionAllCustomAttributes"] = 32, ["MDImportOptionAllEvents"] = 16, ["MDImportOptionAllExportedTypes"] = 64, ["MDImportOptionAllFieldDefs"] = 4, ["MDImportOptionAllMethodDefs"] = 2, ["MDImportOptionAllProperties"] = 8, ["MDImportOptionAllTypeDefs"] = 1, ["MDImportOptionDefault"] = 0, ["MDMemberRefToDef"] = 2, ["MDMethodOutOfOrder"] = 1, ["MDNetModule"] = 1, ["MDNoDupChecks"] = 0, ["MDNotifyAll"] = -1, ["MDNotifyAssemblyRef"] = 16777216, ["MDNotifyCustomAttribute"] = 2048, ["MDNotifyDefault"] = 15, ["MDNotifyEvent"] = 256, ["MDNotifyExportedType"] = 67108864, ["MDNotifyFieldDef"] = 4, ["MDNotifyFile"] = 33554432, ["MDNotifyInterfaceImpl"] = 64, ["MDNotifyMemberRef"] = 2, ["MDNotifyMethodDef"] = 1, ["MDNotifyModuleRef"] = 16384, ["MDNotifyNameSpace"] = 32768, ["MDNotifyNone"] = 0, ["MDNotifyParamDef"] = 32, ["MDNotifyPermission"] = 8192, ["MDNotifyProperty"] = 128, ["MDNotifyResource"] = 134217728, ["MDNotifySecurityValue"] = 4096, ["MDNotifySignature"] = 512, ["MDNotifyTypeDef"] = 16, ["MDNotifyTypeRef"] = 8, ["MDNotifyTypeSpec"] = 1024, ["MDParamOutOfOrder"] = 4, ["MDPropertyOutOfOrder"] = 8, ["MDRefToDefAll"] = -1, ["MDRefToDefDefault"] = 3, ["MDRefToDefNone"] = 0, ["MDSetENCOff"] = 2, ["MDSetENCOn"] = 1, ["MDThreadSafetyDefault"] = 0, ["MDThreadSafetyOff"] = 0, ["MDThreadSafetyOn"] = 1, ["MDTypeRefToDef"] = 1, ["MDUpdateDelta"] = 5, ["MDUpdateENC"] = 1, ["MDUpdateExtension"] = 3, ["MDUpdateFull"] = 2, ["MDUpdateIncremental"] = 4, ["MDUpdateMask"] = 7, ["MESSAGE_RESOURCE_UNICODE"] = 1, ["MakeJumpUnconditional"] = function(...) end, ["MergeExportedTypes"] = 8, ["MergeFlagsNone"] = 0, ["MergeManifest"] = 1, ["MoveFile"] = function(...) end, ["MsgBox"] = function(...) end, ["NATIVE_TYPE_ANSIBSTR"] = 35, ["NATIVE_TYPE_ARRAY"] = 42, ["NATIVE_TYPE_ASANY"] = 40, ["NATIVE_TYPE_BOOLEAN"] = 2, ["NATIVE_TYPE_BSTR"] = 19, ["NATIVE_TYPE_BYVALSTR"] = 34, ["NATIVE_TYPE_CURRENCY"] = 15, ["NATIVE_TYPE_CUSTOMMARSHALER"] = 44, ["NATIVE_TYPE_DATE"] = 18, ["NATIVE_TYPE_DECIMAL"] = 17, ["NATIVE_TYPE_END"] = 0, ["NATIVE_TYPE_ERROR"] = 45, ["NATIVE_TYPE_FIXEDARRAY"] = 30, ["NATIVE_TYPE_FIXEDSYSSTRING"] = 23, ["NATIVE_TYPE_FUNC"] = 38, ["NATIVE_TYPE_I1"] = 3, ["NATIVE_TYPE_I2"] = 5, ["NATIVE_TYPE_I4"] = 7, ["NATIVE_TYPE_I8"] = 9, ["NATIVE_TYPE_IDISPATCH"] = 26, ["NATIVE_TYPE_INT"] = 31, ["NATIVE_TYPE_INTF"] = 28, ["NATIVE_TYPE_IUNKNOWN"] = 25, ["NATIVE_TYPE_LPSTR"] = 20, ["NATIVE_TYPE_LPSTRUCT"] = 43, ["NATIVE_TYPE_LPTSTR"] = 22, ["NATIVE_TYPE_LPWSTR"] = 21, ["NATIVE_TYPE_MAX"] = 80, ["NATIVE_TYPE_MAX_CB"] = 1, ["NATIVE_TYPE_NESTEDSTRUCT"] = 33, ["NATIVE_TYPE_OBJECTREF"] = 24, ["NATIVE_TYPE_PTR"] = 16, ["NATIVE_TYPE_R4"] = 11, ["NATIVE_TYPE_R8"] = 12, ["NATIVE_TYPE_SAFEARRAY"] = 29, ["NATIVE_TYPE_STRUCT"] = 27, ["NATIVE_TYPE_SYSCHAR"] = 13, ["NATIVE_TYPE_TBSTR"] = 36, ["NATIVE_TYPE_U1"] = 4, ["NATIVE_TYPE_U2"] = 6, ["NATIVE_TYPE_U4"] = 8, ["NATIVE_TYPE_U8"] = 10, ["NATIVE_TYPE_UINT"] = 32, ["NATIVE_TYPE_VARIANT"] = 14, ["NATIVE_TYPE_VARIANTBOOL"] = 37, ["NATIVE_TYPE_VOID"] = 1, ["ND"] = 2730, ["NGenDefault"] = 0, ["NGenEager"] = 1, ["NGenLazy"] = 2, ["NGenNever"] = 3, ["NON_PAGED_DEBUG_SIGNATURE"] = 18766, ["NoDupCheck"] = 4, ["NopBytes"] = function(...) end, ["OFN_ALLOWMULTISELECT"] = 512, ["OFN_CREATEPROMPT"] = 8192, ["OFN_DONTADDTORECENT"] = 33554432, ["OFN_ENABLEHOOK"] = 32, ["OFN_ENABLEINCLUDENOTIFY"] = 4194304, ["OFN_ENABLESIZING"] = 8388608, ["OFN_ENABLETEMPLATE"] = 64, ["OFN_ENABLETEMPLATEHANDLE"] = 128, ["OFN_EXPLORER"] = 524288, ["OFN_EXTENSIONDIFFERENT"] = 1024, ["OFN_FILEMUSTEXIST"] = 4096, ["OFN_FORCESHOWHIDDEN"] = 268435456, ["OFN_HIDEREADONLY"] = 4, ["OFN_LONGNAMES"] = 2097152, ["OFN_NOCHANGEDIR"] = 8, ["OFN_NODEREFERENCELINKS"] = 1048576, ["OFN_NOLONGNAMES"] = 262144, ["OFN_NONETWORKBUTTON"] = 131072, ["OFN_NOREADONLYRETURN"] = 32768, ["OFN_NOTESTFILECREATE"] = 65536, ["OFN_NOVALIDATE"] = 256, ["OFN_OVERWRITEPROMPT"] = 2, ["OFN_PATHMUSTEXIST"] = 2048, ["OFN_READONLY"] = 1, ["OFN_SHAREAWARE"] = 16384, ["OFN_SHOWHELP"] = 16, ["OffsetToRva"] = function(...) end, ["OpenFile"] = function(...) end, ["OpenWithCFFExplorer"] = function(...) end, ["PE_BoundImportDirectory"] = 15, ["PE_ConfigurationDirectory"] = 14, ["PE_DataDirectories"] = 4, ["PE_DebugDirectory"] = 12, ["PE_DelayImportDirectory"] = 17, ["PE_DosHeader"] = 0, ["PE_DotNETDirectory"] = 18, ["PE_ExceptionDirectory"] = 9, ["PE_ExportDirectory"] = 6, ["PE_FileHeader"] = 2, ["PE_ImportAddressTableDirectory"] = 16, ["PE_ImportDirectory"] = 7, ["PE_MetaDataTable_Assembly"] = 44, ["PE_MetaDataTable_AssemblyOS"] = 46, ["PE_MetaDataTable_AssemblyProcessor"] = 45, ["PE_MetaDataTable_AssemblyRef"] = 47, ["PE_MetaDataTable_AssemblyRefOS"] = 49, ["PE_MetaDataTable_AssemblyRefProcessor"] = 48, ["PE_MetaDataTable_ClassLayout"] = 31, ["PE_MetaDataTable_Constant"] = 27, ["PE_MetaDataTable_CustomAttribute"] = 28, ["PE_MetaDataTable_DeclSecurity"] = 30, ["PE_MetaDataTable_Event"] = 35, ["PE_MetaDataTable_EventMap"] = 34, ["PE_MetaDataTable_ExportedType"] = 51, ["PE_MetaDataTable_Field"] = 22, ["PE_MetaDataTable_FieldLayout"] = 32, ["PE_MetaDataTable_FieldMarshal"] = 29, ["PE_MetaDataTable_FieldRVA"] = 43, ["PE_MetaDataTable_File"] = 50, ["PE_MetaDataTable_GenericParam"] = 54, ["PE_MetaDataTable_GenericParamConstraint"] = 56, ["PE_MetaDataTable_ImplMap"] = 42, ["PE_MetaDataTable_InterfaceImpl"] = 25, ["PE_MetaDataTable_ManifestResource"] = 52, ["PE_MetaDataTable_MemberRef"] = 26, ["PE_MetaDataTable_Method"] = 23, ["PE_MetaDataTable_MethodImpl"] = 39, ["PE_MetaDataTable_MethodSemantics"] = 38, ["PE_MetaDataTable_MethodSpec"] = 55, ["PE_MetaDataTable_Module"] = 19, ["PE_MetaDataTable_ModuleRef"] = 40, ["PE_MetaDataTable_NestedClass"] = 53, ["PE_MetaDataTable_Param"] = 24, ["PE_MetaDataTable_Property"] = 37, ["PE_MetaDataTable_PropertyMap"] = 36, ["PE_MetaDataTable_StandAloneSig"] = 33, ["PE_MetaDataTable_TypeDef"] = 21, ["PE_MetaDataTable_TypeRef"] = 20, ["PE_MetaDataTable_TypeSpec"] = 41, ["PE_NtHeaders"] = 1, ["PE_OptionalHeader"] = 3, ["PE_RelocationDirectory"] = 11, ["PE_ResourceDirectory"] = 8, ["PE_SectionHeaders"] = 5, ["PE_SecurityDirectory"] = 10, ["PE_TLSDirectory"] = 13, ["RT_ACCELERATOR"] = 9, ["RT_BITMAP"] = 2, ["RT_CURSOR"] = 1, ["RT_DIALOG"] = 5, ["RT_FONT"] = 8, ["RT_FONTDIR"] = 7, ["RT_GROUP_CURSOR"] = 12, ["RT_GROUP_ICON"] = 14, ["RT_HTML"] = 23, ["RT_ICON"] = 3, ["RT_MANIFEST"] = 24, ["RT_MENU"] = 4, ["RT_MESSAGETABLE"] = 11, ["RT_RCDATA"] = 10, ["RT_STRING"] = 6, ["RT_VERSION"] = 16, ["ReadByte"] = function(...) end, ["ReadBytes"] = function(...) end, ["ReadDword"] = function(...) end, ["ReadQword"] = function(...) end, ["ReadString"] = function(...) end, ["ReadWord"] = function(...) end, ["RealignPE"] = function(...) end, ["RebuildImageSize"] = function(...) end, ["RebuildPEHeader"] = function(...) end, ["RemoveDataDirectory"] = function(...) end, ["RemoveDebugDirectory"] = function(...) end, ["RemoveRelocSection"] = function(...) end, ["RemoveStrongNameSignature"] = function(...) end, ["RequestHighPrivileges"] = function(...) end, ["RvaToOffset"] = function(...) end, ["SCRIPT_VERSION"] = 1, ["SERIALIZATION_TYPE_BOOLEAN"] = 2, ["SERIALIZATION_TYPE_CHAR"] = 3, ["SERIALIZATION_TYPE_ENUM"] = 85, ["SERIALIZATION_TYPE_FIELD"] = 83, ["SERIALIZATION_TYPE_I1"] = 4, ["SERIALIZATION_TYPE_I2"] = 6, ["SERIALIZATION_TYPE_I4"] = 8, ["SERIALIZATION_TYPE_I8"] = 10, ["SERIALIZATION_TYPE_PROPERTY"] = 84, ["SERIALIZATION_TYPE_R4"] = 12, ["SERIALIZATION_TYPE_R8"] = 13, ["SERIALIZATION_TYPE_STRING"] = 14, ["SERIALIZATION_TYPE_SZARRAY"] = 29, ["SERIALIZATION_TYPE_TAGGED_OBJECT"] = 81, ["SERIALIZATION_TYPE_TYPE"] = 80, ["SERIALIZATION_TYPE_U1"] = 5, ["SERIALIZATION_TYPE_U2"] = 7, ["SERIALIZATION_TYPE_U4"] = 9, ["SERIALIZATION_TYPE_U8"] = 11, ["SERIALIZATION_TYPE_UNDEFINED"] = 0, ["SIZEOF_RFPO_DATA"] = 16, ["SUBLANG_ARABIC_ALGERIA"] = 5, ["SUBLANG_ARABIC_BAHRAIN"] = 15, ["SUBLANG_ARABIC_EGYPT"] = 3, ["SUBLANG_ARABIC_IRAQ"] = 2, ["SUBLANG_ARABIC_JORDAN"] = 11, ["SUBLANG_ARABIC_KUWAIT"] = 13, ["SUBLANG_ARABIC_LEBANON"] = 12, ["SUBLANG_ARABIC_LIBYA"] = 4, ["SUBLANG_ARABIC_MOROCCO"] = 6, ["SUBLANG_ARABIC_OMAN"] = 8, ["SUBLANG_ARABIC_QATAR"] = 16, ["SUBLANG_ARABIC_SAUDI_ARABIA"] = 1, ["SUBLANG_ARABIC_SYRIA"] = 10, ["SUBLANG_ARABIC_TUNISIA"] = 7, ["SUBLANG_ARABIC_UAE"] = 14, ["SUBLANG_ARABIC_YEMEN"] = 9, ["SUBLANG_AZERI_CYRILLIC"] = 2, ["SUBLANG_AZERI_LATIN"] = 1, ["SUBLANG_CHINESE_HONGKONG"] = 3, ["SUBLANG_CHINESE_MACAU"] = 5, ["SUBLANG_CHINESE_SIMPLIFIED"] = 2, ["SUBLANG_CHINESE_SINGAPORE"] = 4, ["SUBLANG_CHINESE_TRADITIONAL"] = 1, ["SUBLANG_DEFAULT"] = 1, ["SUBLANG_DUTCH"] = 1, ["SUBLANG_DUTCH_BELGIAN"] = 2, ["SUBLANG_ENGLISH_AUS"] = 3, ["SUBLANG_ENGLISH_BELIZE"] = 10, ["SUBLANG_ENGLISH_CAN"] = 4, ["SUBLANG_ENGLISH_CARIBBEAN"] = 9, ["SUBLANG_ENGLISH_EIRE"] = 6, ["SUBLANG_ENGLISH_JAMAICA"] = 8, ["SUBLANG_ENGLISH_NZ"] = 5, ["SUBLANG_ENGLISH_PHILIPPINES"] = 13, ["SUBLANG_ENGLISH_SOUTH_AFRICA"] = 7, ["SUBLANG_ENGLISH_TRINIDAD"] = 11, ["SUBLANG_ENGLISH_UK"] = 2, ["SUBLANG_ENGLISH_US"] = 1, ["SUBLANG_ENGLISH_ZIMBABWE"] = 12, ["SUBLANG_FRENCH"] = 1, ["SUBLANG_FRENCH_BELGIAN"] = 2, ["SUBLANG_FRENCH_CANADIAN"] = 3, ["SUBLANG_FRENCH_LUXEMBOURG"] = 5, ["SUBLANG_FRENCH_MONACO"] = 6, ["SUBLANG_FRENCH_SWISS"] = 4, ["SUBLANG_GERMAN"] = 1, ["SUBLANG_GERMAN_AUSTRIAN"] = 3, ["SUBLANG_GERMAN_LIECHTENSTEIN"] = 5, ["SUBLANG_GERMAN_LUXEMBOURG"] = 4, ["SUBLANG_GERMAN_SWISS"] = 2, ["SUBLANG_ITALIAN"] = 1, ["SUBLANG_ITALIAN_SWISS"] = 2, ["SUBLANG_KASHMIRI_INDIA"] = 2, ["SUBLANG_KOREAN"] = 1, ["SUBLANG_LITHUANIAN"] = 1, ["SUBLANG_MALAY_BRUNEI_DARUSSALAM"] = 2, ["SUBLANG_MALAY_MALAYSIA"] = 1, ["SUBLANG_NEPALI_INDIA"] = 2, ["SUBLANG_NEUTRAL"] = 0, ["SUBLANG_NORWEGIAN_BOKMAL"] = 1, ["SUBLANG_NORWEGIAN_NYNORSK"] = 2, ["SUBLANG_PORTUGUESE"] = 2, ["SUBLANG_PORTUGUESE_BRAZILIAN"] = 1, ["SUBLANG_SERBIAN_CYRILLIC"] = 3, ["SUBLANG_SERBIAN_LATIN"] = 2, ["SUBLANG_SPANISH"] = 1, ["SUBLANG_SPANISH_ARGENTINA"] = 11, ["SUBLANG_SPANISH_BOLIVIA"] = 16, ["SUBLANG_SPANISH_CHILE"] = 13, ["SUBLANG_SPANISH_COLOMBIA"] = 9, ["SUBLANG_SPANISH_COSTA_RICA"] = 5, ["SUBLANG_SPANISH_DOMINICAN_REPUBLIC"] = 7, ["SUBLANG_SPANISH_ECUADOR"] = 12, ["SUBLANG_SPANISH_EL_SALVADOR"] = 17, ["SUBLANG_SPANISH_GUATEMALA"] = 4, ["SUBLANG_SPANISH_HONDURAS"] = 18, ["SUBLANG_SPANISH_MEXICAN"] = 2, ["SUBLANG_SPANISH_MODERN"] = 3, ["SUBLANG_SPANISH_NICARAGUA"] = 19, ["SUBLANG_SPANISH_PANAMA"] = 6, ["SUBLANG_SPANISH_PARAGUAY"] = 15, ["SUBLANG_SPANISH_PERU"] = 10, ["SUBLANG_SPANISH_PUERTO_RICO"] = 20, ["SUBLANG_SPANISH_URUGUAY"] = 14, ["SUBLANG_SPANISH_VENEZUELA"] = 8, ["SUBLANG_SWEDISH"] = 1, ["SUBLANG_SWEDISH_FINLAND"] = 2, ["SUBLANG_SYS_DEFAULT"] = 2, ["SUBLANG_URDU_INDIA"] = 2, ["SUBLANG_URDU_PAKISTAN"] = 1, ["SUBLANG_UZBEK_CYRILLIC"] = 2, ["SUBLANG_UZBEK_LATIN"] = 1, ["SaveFile"] = function(...) end, ["SaveFileAs"] = function(...) end, ["SaveResource"] = function(...) end, ["SaveResourceRaw"] = function(...) end, ["SearchBytes"] = function(...) end, ["SectionFromRva"] = function(...) end, ["SetImageBase"] = function(...) end, ["TRUE"] = true, ["UpdateChecksum"] = function(...) end, ["VER_AND"] = 6, ["VER_BUILDNUMBER"] = 4, ["VER_CONDITION_MASK"] = 7, ["VER_EQUAL"] = 1, ["VER_GREATER"] = 2, ["VER_GREATER_EQUAL"] = 3, ["VER_LESS"] = 4, ["VER_LESS_EQUAL"] = 5, ["VER_MAJORVERSION"] = 2, ["VER_MINORVERSION"] = 1, ["VER_NT_DOMAIN_CONTROLLER"] = 2, ["VER_NT_SERVER"] = 3, ["VER_NT_WORKSTATION"] = 1, ["VER_NUM_BITS_PER_CONDITION_MASK"] = 3, ["VER_OR"] = 7, ["VER_PLATFORMID"] = 8, ["VER_PRODUCT_TYPE"] = 128, ["VER_SERVICEPACKMAJOR"] = 32, ["VER_SERVICEPACKMINOR"] = 16, ["VER_SUITENAME"] = 64, ["VaToOffset"] = function(...) end, ["VaToRva"] = function(...) end, ["WriteByte"] = function(...) end, ["WriteBytes"] = function(...) end, ["WriteDword"] = function(...) end, ["WriteQword"] = function(...) end, ["WriteString"] = function(...) end, ["WriteWord"] = function(...) end, ["X3_BTYPE_QP_INST_VAL_POS_X"] = 0, ["X3_BTYPE_QP_INST_WORD_POS_X"] = 23, ["X3_BTYPE_QP_INST_WORD_X"] = 2, ["X3_BTYPE_QP_SIZE_X"] = 9, ["X3_D_WH_INST_WORD_POS_X"] = 24, ["X3_D_WH_INST_WORD_X"] = 3, ["X3_D_WH_SIGN_VAL_POS_X"] = 0, ["X3_D_WH_SIZE_X"] = 3, ["X3_EMPTY_INST_VAL_POS_X"] = 0, ["X3_EMPTY_INST_WORD_POS_X"] = 14, ["X3_EMPTY_INST_WORD_X"] = 1, ["X3_EMPTY_SIZE_X"] = 2, ["X3_IMM20_INST_WORD_POS_X"] = 4, ["X3_IMM20_INST_WORD_X"] = 3, ["X3_IMM20_SIGN_VAL_POS_X"] = 0, ["X3_IMM20_SIZE_X"] = 20, ["X3_IMM39_1_INST_WORD_POS_X"] = 0, ["X3_IMM39_1_INST_WORD_X"] = 2, ["X3_IMM39_1_SIGN_VAL_POS_X"] = 36, ["X3_IMM39_1_SIZE_X"] = 23, ["X3_IMM39_2_INST_WORD_POS_X"] = 16, ["X3_IMM39_2_INST_WORD_X"] = 1, ["X3_IMM39_2_SIGN_VAL_POS_X"] = 20, ["X3_IMM39_2_SIZE_X"] = 16, ["X3_I_INST_WORD_POS_X"] = 27, ["X3_I_INST_WORD_X"] = 3, ["X3_I_SIGN_VAL_POS_X"] = 59, ["X3_I_SIZE_X"] = 1, ["X3_OPCODE_INST_WORD_POS_X"] = 28, ["X3_OPCODE_INST_WORD_X"] = 3, ["X3_OPCODE_SIGN_VAL_POS_X"] = 0, ["X3_OPCODE_SIZE_X"] = 4, ["X3_P_INST_WORD_POS_X"] = 0, ["X3_P_INST_WORD_X"] = 3, ["X3_P_SIGN_VAL_POS_X"] = 0, ["X3_P_SIZE_X"] = 4, ["X3_TMPLT_INST_WORD_POS_X"] = 0, ["X3_TMPLT_INST_WORD_X"] = 0, ["X3_TMPLT_SIGN_VAL_POS_X"] = 0, ["X3_TMPLT_SIZE_X"] = 4, ["afDisableJITcompileOptimizer"] = 16384, ["afEnableJITcompileTracking"] = 32768, ["afPA_AMD64"] = 64, ["afPA_FullMask"] = 240, ["afPA_IA64"] = 48, ["afPA_MSIL"] = 16, ["afPA_Mask"] = 112, ["afPA_None"] = 0, ["afPA_Shift"] = 4, ["afPA_Specified"] = 128, ["afPA_x86"] = 32, ["afPublicKey"] = 1, ["afRetargetable"] = 256, ["catAll"] = 24575, ["catAssembly"] = 1, ["catClass"] = 4, ["catClassMembers"] = 6140, ["catConstructor"] = 32, ["catDelegate"] = 4096, ["catEnum"] = 16, ["catEvent"] = 512, ["catField"] = 256, ["catGenericParameter"] = 16384, ["catInterface"] = 1024, ["catMethod"] = 64, ["catModule"] = 2, ["catParameter"] = 2048, ["catProperty"] = 128, ["catStruct"] = 8, ["collectgarbage"] = function(...) end, ["cssAccurate"] = 0, ["cssDiscardTransientCAs"] = 2, ["cssQuick"] = 1, ["dclActionMask"] = 31, ["dclActionNil"] = 0, ["dclAssert"] = 3, ["dclDemand"] = 2, ["dclDeny"] = 4, ["dclInheritanceCheck"] = 7, ["dclLinktimeCheck"] = 6, ["dclMaximumValue"] = 15, ["dclNonCasDemand"] = 13, ["dclNonCasInheritance"] = 15, ["dclNonCasLinkDemand"] = 14, ["dclPermitOnly"] = 5, ["dclPrejitDenied"] = 12, ["dclPrejitGrant"] = 11, ["dclRequest"] = 1, ["dclRequestMinimum"] = 8, ["dclRequestOptional"] = 9, ["dclRequestRefuse"] = 10, ["evRTSpecialName"] = 1024, ["evReservedMask"] = 1024, ["evSpecialName"] = 512, ["fdAssembly"] = 3, ["fdFamANDAssem"] = 2, ["fdFamORAssem"] = 5, ["fdFamily"] = 4, ["fdFieldAccessMask"] = 7, ["fdHasDefault"] = 32768, ["fdHasFieldMarshal"] = 4096, ["fdHasFieldRVA"] = 256, ["fdInitOnly"] = 32, ["fdLiteral"] = 64, ["fdNotSerialized"] = 128, ["fdPinvokeImpl"] = 8192, ["fdPrivate"] = 1, ["fdPrivateScope"] = 0, ["fdPublic"] = 6, ["fdRTSpecialName"] = 1024, ["fdReservedMask"] = 38144, ["fdSpecialName"] = 512, ["fdStatic"] = 16, ["ffContainsMetaData"] = 0, ["ffContainsNoMetaData"] = 1, ["gpContravariant"] = 2, ["gpCovariant"] = 1, ["gpDefaultConstructorConstraint"] = 16, ["gpNoSpecialConstraint"] = 0, ["gpNonVariant"] = 0, ["gpNotNullableValueTypeConstraint"] = 8, ["gpReferenceTypeConstraint"] = 4, ["gpSpecialConstraintMask"] = 28, ["gpVarianceMask"] = 3, ["mdAbstract"] = 1024, ["mdAssem"] = 3, ["mdCheckAccessOnOverride"] = 512, ["mdFamANDAssem"] = 2, ["mdFamORAssem"] = 5, ["mdFamily"] = 4, ["mdFinal"] = 32, ["mdHasSecurity"] = 16384, ["mdHideBySig"] = 128, ["mdMemberAccessMask"] = 7, ["mdNewSlot"] = 256, ["mdPinvokeImpl"] = 8192, ["mdPrivate"] = 1, ["mdPrivateScope"] = 0, ["mdPublic"] = 6, ["mdRTSpecialName"] = 4096, ["mdRequireSecObject"] = 32768, ["mdReservedMask"] = 53248, ["mdReuseSlot"] = 0, ["mdSpecialName"] = 2048, ["mdStatic"] = 16, ["mdUnmanagedExport"] = 8, ["mdVirtual"] = 64, ["mdVtableLayoutMask"] = 256, ["mdtAssembly"] = 536870912, ["mdtAssemblyRef"] = 587202560, ["mdtBaseType"] = 1912602624, ["mdtCustomAttribute"] = 201326592, ["mdtEvent"] = 335544320, ["mdtExportedType"] = 654311424, ["mdtFieldDef"] = 67108864, ["mdtFile"] = 637534208, ["mdtGenericParam"] = 704643072, ["mdtGenericParamConstraint"] = 738197504, ["mdtInterfaceImpl"] = 150994944, ["mdtManifestResource"] = 671088640, ["mdtMemberRef"] = 167772160, ["mdtMethodDef"] = 100663296, ["mdtMethodSpec"] = 721420288, ["mdtModule"] = 0, ["mdtModuleRef"] = 436207616, ["mdtName"] = 1895825408, ["mdtParamDef"] = 134217728, ["mdtPermission"] = 234881024, ["mdtProperty"] = 385875968, ["mdtSignature"] = 285212672, ["mdtString"] = 1879048192, ["mdtTypeDef"] = 33554432, ["mdtTypeRef"] = 16777216, ["mdtTypeSpec"] = 452984832, ["miCodeTypeMask"] = 3, ["miForwardRef"] = 16, ["miIL"] = 0, ["miInternalCall"] = 4096, ["miManaged"] = 0, ["miManagedMask"] = 4, ["miMaxMethodImplVal"] = 65535, ["miNative"] = 1, ["miNoInlining"] = 8, ["miOPTIL"] = 2, ["miPreserveSig"] = 128, ["miRuntime"] = 3, ["miSynchronized"] = 32, ["miUnmanaged"] = 4, ["mrPrivate"] = 2, ["mrPublic"] = 1, ["mrVisibilityMask"] = 7, ["msAddOn"] = 8, ["msFire"] = 32, ["msGetter"] = 2, ["msOther"] = 4, ["msRemoveOn"] = 16, ["msSetter"] = 1, ["ntaReserved"] = 65534, ["ntaSizeParamIndexSpecified"] = 1, ["ofCacheImage"] = 4, ["ofCopyMemory"] = 2, ["ofManifestMetadata"] = 8, ["ofNoTypeLib"] = 128, ["ofRead"] = 0, ["ofReadOnly"] = 16, ["ofReadWriteMask"] = 1, ["ofReserved"] = -192, ["ofReserved1"] = 256, ["ofReserved2"] = 512, ["ofTakeOwnership"] = 32, ["ofWrite"] = 1, ["pdHasDefault"] = 4096, ["pdHasFieldMarshal"] = 8192, ["pdIn"] = 1, ["pdOptional"] = 16, ["pdOut"] = 2, ["pdReservedMask"] = 61440, ["pdUnused"] = 53216, ["pe32BitRequired"] = 2, ["pe32Plus"] = 4, ["pe32Unmanaged"] = 8, ["peILonly"] = 1, ["peNot"] = 0, ["pmBestFitDisabled"] = 32, ["pmBestFitEnabled"] = 16, ["pmBestFitMask"] = 48, ["pmBestFitUseAssem"] = 0, ["pmCallConvCdecl"] = 512, ["pmCallConvFastcall"] = 1280, ["pmCallConvMask"] = 1792, ["pmCallConvStdcall"] = 768, ["pmCallConvThiscall"] = 1024, ["pmCallConvWinapi"] = 256, ["pmCharSetAnsi"] = 2, ["pmCharSetAuto"] = 6, ["pmCharSetMask"] = 6, ["pmCharSetNotSpec"] = 0, ["pmCharSetUnicode"] = 4, ["pmMaxValue"] = 65535, ["pmNoMangle"] = 1, ["pmSupportsLastError"] = 64, ["pmThrowOnUnmappableCharDisabled"] = 8192, ["pmThrowOnUnmappableCharEnabled"] = 4096, ["pmThrowOnUnmappableCharMask"] = 12288, ["pmThrowOnUnmappableCharUseAssem"] = 0, ["prHasDefault"] = 4096, ["prRTSpecialName"] = 1024, ["prReservedMask"] = 62464, ["prSpecialName"] = 512, ["prUnused"] = 59903, ["tdAbstract"] = 128, ["tdAnsiClass"] = 0, ["tdAutoClass"] = 131072, ["tdAutoLayout"] = 0, ["tdBeforeFieldInit"] = 1048576, ["tdClass"] = 0, ["tdClassSemanticsMask"] = 96, ["tdCustomFormatClass"] = 196608, ["tdCustomFormatMask"] = 12582912, ["tdExplicitLayout"] = 16, ["tdForwarder"] = 2097152, ["tdHasSecurity"] = 262144, ["tdImport"] = 4096, ["tdInterface"] = 32, ["tdLayoutMask"] = 24, ["tdNestedAssembly"] = 5, ["tdNestedFamANDAssem"] = 6, ["tdNestedFamORAssem"] = 7, ["tdNestedFamily"] = 4, ["tdNestedPrivate"] = 3, ["tdNestedPublic"] = 2, ["tdNotPublic"] = 0, ["tdPublic"] = 1, ["tdRTSpecialName"] = 2048, ["tdReservedMask"] = 264192, ["tdSealed"] = 256, ["tdSequentialLayout"] = 8, ["tdSerializable"] = 8192, ["tdSpecialName"] = 1024, ["tdStringFormatMask"] = 196608, ["tdUnicodeClass"] = 65536, ["tdVisibilityMask"] = 7, ["argc"] = 1, ["argv"] = { [0] = "DumpGlobals.cff" }, ["assert"] = function(...) end, ["dofile"] = function(...) end, ["error"] = function(...) end, ["gcinfo"] = function(...) end, ["getfenv"] = function(...) end, ["getmetatable"] = function(...) end, ["load"] = function(...) end, ["loadfile"] = function(...) end, ["loadstring"] = function(...) end, ["newproxy"] = function(...) end, ["pcall"] = function(...) end, ["print"] = function(...) end, ["rawequal"] = function(...) end, ["rawget"] = function(...) end, ["rawset"] = function(...) end, ["select"] = function(...) end, ["setfenv"] = function(...) end, ["setmetatable"] = function(...) end, ["tonumber"] = function(...) end, ["tostring"] = function(...) end, ["type"] = function(...) end, ["unpack"] = function(...) end, ["xpcall"] = function(...) end, ["coroutine"] = { ["create"] = function(...) end, ["resume"] = function(...) end, ["running"] = function(...) end, ["status"] = function(...) end, ["wrap"] = function(...) end, ["yield"] = function(...) end }, ["string"] = { ["format"] = function(...) end, ["gfind"] = function(...) end, ["gmatch"] = function(...) end, ["gsub"] = function(...) end, ["lower"] = function(...) end, ["match"] = function(...) end, ["reverse"] = function(...) end, ["upper"] = function(...) end }, ["table"] = { ["concat"] = function(...) end, ["foreach"] = function(...) end, ["foreachi"] = function(...) end, ["getn"] = function(...) end, ["insert"] = function(...) end, ["maxn"] = function(...) end, ["remove"] = function(...) end, ["setn"] = function(...) end, ["sort"] = function(...) end }, ["_G"] = _G, ["_VERSION"] = "Lua 5.1" }
public by ronrihoo 2462 78 7 3
libGDX Table background color
import com.badlogic.gdx.Gdx; import com.badlogic.gdx.graphics.Color; import com.badlogic.gdx.graphics.Texture; import com.badlogic.gdx.graphics.g2d.Batch; import com.badlogic.gdx.graphics.g2d.Sprite; import com.badlogic.gdx.graphics.g2d.TextureRegion; import com.badlogic.gdx.scenes.scene2d.utils.Drawable; public class BackgroundColor implements Drawable { private Float x; private Float y; private Float width; private Float height; private Boolean fillParent; private String filename; private Texture texture; private TextureRegion textureRegion; private Sprite sprite; private Color color; public BackgroundColor(String filename) { this(filename, 0.0f, 0.0f, 0.0f, 0.0f); } public BackgroundColor(String filename, float x, float y) { this(filename, x, y, 0.0f, 0.0f); } public BackgroundColor(String filename, float x, float y, float width, float height) { this.setPosition(x, y); this.setSize(width, height); initialize(filename); } private void initialize(String filename) { setFilename(filename); if (x == null || y == null) setPosition(); // x = 0.0f; y = 0.0f; if (width == null || height == null || width < 0.0f || height < 0.0f) setSize(); // width = 0.0f; height = 0.0f; if (color == null) setColor(255, 255, 255, 255); if (sprite == null) { try { setSprite(); } catch (Exception e) { System.err.println(e); } } if (fillParent == null) fillParent = true; } private void setTexture() { if (texture != null) texture.dispose(); texture = new Texture(Gdx.files.internal(getFilename())); } private void setTextureRegion() { textureRegion = new TextureRegion(texture, (int) getWidth(), (int) getHeight()); } private void setSprite() { if (texture == null) setTexture(); setTextureRegion(); sprite = new Sprite(textureRegion); setSpriteColor(); } private void setSpriteColor() { sprite.setColor(color.r, color.g, color.b, color.a); } private void setPosition() { this.x = 0.0f; this.y = 0.0f; } private void setPosition(float x, float y) { this.x = x; this.y = y; } private void setSize() { this.width = sprite.getWidth(); this.height = sprite.getHeight(); } private void setSize(float width, float height) { this.width = width; this.height = height; } public void setColor(int r, int g, int b, int a) { color = new Color(r/255f, g/255f, b/255f, a/255f); } public void setColor(float r, float g, float b, float a) { color = new Color(r/255f, g/255f, b/255f, a/255f); } private void setSpritePosition(float x, float y) { sprite.setX(x); sprite.setY(y); } private void updateSprite(float x, float y, float width, float height) { if (fillParent) { setSpritePosition(x, y); if (width != textureRegion.getRegionWidth() || height != textureRegion.getRegionHeight()) { setSize(width, height); setSprite(); } } } @Override public void draw(Batch batch, float x, float y, float width, float height) { updateSprite(x, y, width, height); sprite.draw(batch); } @Override public float getLeftWidth() { // TODO Auto-generated method stub return 0; } @Override public void setLeftWidth(float leftWidth) { // TODO Auto-generated method stub } @Override public float getRightWidth() { // TODO Auto-generated method stub return 0; } @Override public void setRightWidth(float rightWidth) { // TODO Auto-generated method stub } @Override public float getTopHeight() { // TODO Auto-generated method stub return 0; } @Override public void setTopHeight(float topHeight) { // TODO Auto-generated method stub } @Override public float getBottomHeight() { // TODO Auto-generated method stub return 0; } @Override public void setBottomHeight(float bottomHeight) { // TODO Auto-generated method stub } @Override public float getMinWidth() { // TODO Auto-generated method stub return 0; } @Override public void setMinWidth(float minWidth) { // TODO Auto-generated method stub } @Override public float getMinHeight() { // TODO Auto-generated method stub return 0; } @Override public void setMinHeight(float minHeight) { // TODO Auto-generated method stub } private void setFilename(String filename) { this.filename = filename; } private String getFilename() { return filename; } public float getX() { return x; } public void setX(float x) { this.x = x; } public float getY() { return y; } public void setY(float y) { this.y = y; } public float getWidth() { return width; } public void setWidth(float width) { this.width = width; } public float getHeight() { return height; } public void setHeight(float height) { this.height = height; } public Boolean getFillParent() { return fillParent; } public void setFillParent(Boolean fillParent) { this.fillParent = fillParent; } }