CyberDevil

Web Release: cp_itemdesc populed table

Recommended Posts

cp_itemdesc populed table


I don't know the reason but on my Fluxcp the system "UPLOAD ITEMINFO.LUA" never worked and so I took the file "itemInfo.lua" file translated by @zackdreaver (GIT repo) with all the descriptions of the translated items formatted in HTML and I have made a SQL file that inserts the data in the `cp_itemdesc` table which should be enabled on the Fluxcp "Add Item Info" page.
The option to activate the description of the items is the following in the file "/config/application.php":

'ShowItemDesc'	=> true,	// Displays generated item descs from parsed itemInfo.lua

It depends on the configuration of your "phpmyadmin" (if you use it), but it is very likely that you will need to split this SQL file into several parts to avoid timing out during the query run.
if you want to thank me, you can give me a "LIKE"! ;D

p.s.: the first 8 items on the list are custom of my server!

desc.jpg.4360a96112e81f419cfff66b7290f952.jpg


 

Edited by CyberDevil
  • Upvote 1
  • MVP 1
  • Like 1

Share this post


Link to post
Share on other sites

Update all descriptions to today's date... if you want to thank me you can give me a "LIKE"! 😉

Share this post


Link to post
Share on other sites
48 minutes ago, DepTrai said:

Hi.Fail to download?

I think it's in pending approval, try later!

Share this post


Link to post
Share on other sites
Posted (edited)

how to upload it into sql?

use import or how?

Because i'm using MySQL query browser and open it as script and then execute, have error like this

image.png.74167cc556a08f8d3316f3fd80c91573.png

Edited by hendra814

Share this post


Link to post
Share on other sites
Posted (edited)
3 hours ago, hendra814 said:

how to upload it into sql?

use import or how?

Because i'm using MySQL query browser and open it as script and then execute, have error like this

image.png.74167cc556a08f8d3316f3fd80c91573.png

I don't know this software because I use phpMyAdmin directly on a web server, but if you have an area where you can paste any queries, you can copy a few hundred lines at a time and run the query, thus dividing the data into more trances... for example I started the queries by copying 5000 items at a time, but remember to insert the first line "INSERT INTO `cp_itemdesc` (`itemid`, `itemdesc`) VALUES" (without quotes of course) to each query.
Otherwise another method is to rename (for backup) or delete your "cp_itemdesc" table and recreate it by query, importing this other file which I attached below (it is the same sql file but with the addition of table creation and alteration queries).

cp_itemdesc_with_table.zip

Edited by CyberDevil

Share this post


Link to post
Share on other sites
11 minutes ago, CyberDevil said:

I don't know this software because I use phpMyAdmin directly on a web server, but if you have an area where you can paste any queries, you can copy a few hundred lines at a time and run the query, thus dividing the data into more trances... for example I started the queries by copying 500 items at a time, but remember to insert the first line "INSERT INTO `cp_itemdesc` (`itemid`, `itemdesc`) VALUES" to each query.
Otherwise another method is to rename (for backup) or delete your "cp_itemdesc" table and recreate it by query, importing this other file which I attached below (it is the same sql file but with the addition of table creation and alteration queries).

cp_itemdesc_with_table.zip 782.29 kB · 0 downloads

Thanks a alot, i will try import this file

Share this post


Link to post
Share on other sites

how do you enable flux cp to display descriptions once you add this to mysql?

Share this post


Link to post
Share on other sites
18 hours ago, mirabell said:

how do you enable flux cp to display descriptions once you add this to mysql?

In the file "config/application.php" you can see:

'ShowItemDesc'	=> true,	// Displays generated item descs from parsed itemInfo.lua

 

  • Upvote 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...