Reply to thread

Message

<blockquote data-quote="Bop" data-source="post: 484355" data-attributes="member: 94210">If you are searching a furniture and clicking an item but it shows a wall item type. This fix is for you!First, run this query [CODE=sql]UPDATE catalog_itemsSET offer_id = CASE&nbsp; &nbsp; WHEN item_ids LIKE '%;%' AND SUBSTRING_INDEX(item_ids, ';', 1) REGEXP '^[0-9]+$' THEN CAST(SUBSTRING_INDEX(item_ids, ';', 1) AS UNSIGNED)&nbsp; &nbsp; WHEN item_ids LIKE '%:%' AND SUBSTRING_INDEX(item_ids, ':', 1) REGEXP '^[0-9]+$' THEN CAST(SUBSTRING_INDEX(item_ids, ':', 1) AS UNSIGNED)&nbsp; &nbsp; WHEN item_ids REGEXP '^[0-9]+$' THEN CAST(item_ids AS UNSIGNED)&nbsp; &nbsp; ELSE 0&nbsp; -- or another appropriate default valueEND;[/CODE]This will match all id's in the offer_item column to the item_ids columnSecond, after running this query, you will need to install NodeJS, if it's already than no need to install it again<a href="https://nodejs.org/en" target="_blank">NodeJS Installation</a>Third step, place this file/script inside gamedata folder where your FurnitureData.json is located and edit the database credentials to match your current database credentialsRECOMMENDED: Make a backup of your FurnitureData.json[CODE=javascript]const fs = require('fs');const mysql = require('mysql2');const { performance } = require('perf_hooks');// Database connection configurationconst dbConfig = {&nbsp; &nbsp; host: 'localhost',&nbsp; &nbsp; user: 'root',&nbsp; &nbsp; password: 'PASSWORD',&nbsp; &nbsp; database: 'DBNAME'};const connection = mysql.createConnection(dbConfig);function updateOfferIdsForSection(furniTypes, callback) {&nbsp; &nbsp; let completed = 0;&nbsp; &nbsp; furniTypes.forEach((furniture, index) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; const query = 'SELECT offer_id FROM catalog_items WHERE catalog_name = ?';&nbsp; &nbsp; &nbsp; &nbsp; connection.query(query, [furniture.classname], (error, results) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (error) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.error('Error querying database:', error);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return callback(error);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (results.length &gt; 0) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; furniture.offerid = results[0].offer_id;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(`Updated offerid for ${furniture.classname} to ${results[0].offer_id}`);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(`No matching record found for ${furniture.classname}`);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; completed++;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (completed === furniTypes.length) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; callback();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; });}const start = performance.now();fs.readFile('FurnitureData.json', 'utf8', (err, data) =&gt; {&nbsp; &nbsp; if (err) {&nbsp; &nbsp; &nbsp; &nbsp; console.error('Error reading file:', err);&nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; }&nbsp; &nbsp; const furnitureData = JSON.parse(data);&nbsp; &nbsp; updateOfferIdsForSection(furnitureData.wallitemtypes.furnitype, (error) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; if (error) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.error('Error updating wall item types:', error);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; updateOfferIdsForSection(furnitureData.roomitemtypes.furnitype, (error) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (error) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.error('Error updating room item types:', error);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; const updatedJSONData = JSON.stringify(furnitureData, null, 2);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fs.writeFile('FurnitureData.json', updatedJSONData, (err) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (err) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.error('Error writing file:', err);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log('FurnitureData.json updated successfully');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connection.end((err) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (err) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.error('Error closing connection:', err);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; const end = performance.now();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(`Script took ${(end - start) / 1000} seconds to finish`);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; });});[/CODE]Final Step:Use your favorite terminalRun &quot;npm i&quot; or &quot;npm install&quot; to install the dependencies/packagesRun &quot;npm SCRIPTFILENAME.js&quot;</blockquote>

[QUOTE="Bop, post: 484355, member: 94210"] If you are searching a furniture and clicking an item but it shows a wall item type. This fix is for you! First, run this query [CODE=sql] UPDATE catalog_items SET offer_id = CASE WHEN item_ids LIKE '%;%' AND SUBSTRING_INDEX(item_ids, ';', 1) REGEXP '^[0-9]+$' THEN CAST(SUBSTRING_INDEX(item_ids, ';', 1) AS UNSIGNED) WHEN item_ids LIKE '%:%' AND SUBSTRING_INDEX(item_ids, ':', 1) REGEXP '^[0-9]+$' THEN CAST(SUBSTRING_INDEX(item_ids, ':', 1) AS UNSIGNED) WHEN item_ids REGEXP '^[0-9]+$' THEN CAST(item_ids AS UNSIGNED) ELSE 0 -- or another appropriate default value END;[/CODE] This will match all id's in the offer_item column to the item_ids column Second, after running this query, you will need to install NodeJS, if it's already than no need to install it again [URL='https://nodejs.org/en']NodeJS Installation[/URL] Third step, place this file/script inside gamedata folder where your FurnitureData.json is located and edit the database credentials to match your current database credentials RECOMMENDED: Make a backup of your FurnitureData.json [CODE=javascript] const fs = require('fs'); const mysql = require('mysql2'); const { performance } = require('perf_hooks'); // Database connection configuration const dbConfig = { host: 'localhost', user: 'root', password: 'PASSWORD', database: 'DBNAME' }; const connection = mysql.createConnection(dbConfig); function updateOfferIdsForSection(furniTypes, callback) { let completed = 0; furniTypes.forEach((furniture, index) => { const query = 'SELECT offer_id FROM catalog_items WHERE catalog_name = ?'; connection.query(query, [furniture.classname], (error, results) => { if (error) { console.error('Error querying database:', error); return callback(error); } if (results.length > 0) { furniture.offerid = results[0].offer_id; console.log(`Updated offerid for ${furniture.classname} to ${results[0].offer_id}`); } else { console.log(`No matching record found for ${furniture.classname}`); } completed++; if (completed === furniTypes.length) { callback(); } }); }); } const start = performance.now(); fs.readFile('FurnitureData.json', 'utf8', (err, data) => { if (err) { console.error('Error reading file:', err); return; } const furnitureData = JSON.parse(data); updateOfferIdsForSection(furnitureData.wallitemtypes.furnitype, (error) => { if (error) { console.error('Error updating wall item types:', error); return; } updateOfferIdsForSection(furnitureData.roomitemtypes.furnitype, (error) => { if (error) { console.error('Error updating room item types:', error); return; } const updatedJSONData = JSON.stringify(furnitureData, null, 2); fs.writeFile('FurnitureData.json', updatedJSONData, (err) => { if (err) { console.error('Error writing file:', err); return; } console.log('FurnitureData.json updated successfully'); connection.end((err) => { if (err) { console.error('Error closing connection:', err); return; } const end = performance.now(); console.log(`Script took ${(end - start) / 1000} seconds to finish`); }); }); }); }); }); [/CODE] Final Step: Use your favorite terminal Run "npm i" or "npm install" to install the dependencies/packages Run "npm SCRIPTFILENAME.js" [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members