Jump to content

Web Release: cp_itemdesc populed table


CyberDevil

Recommended Posts


  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  242
  • Reputation:   37
  • Joined:  02/25/18
  • Last Seen:  

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
Link to comment
Share on other sites

  • 11 months later...

  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  242
  • Reputation:   37
  • Joined:  02/25/18
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Forum Moderator
  • Topic Count:  25
  • Topics Per Day:  0.01
  • Content Count:  830
  • Reputation:   316
  • Joined:  02/11/19
  • Last Seen:  

Get your LIKE, good man. ?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  8
  • Reputation:   0
  • Joined:  03/16/19
  • Last Seen:  

Hi.Fail to download?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  242
  • Reputation:   37
  • Joined:  02/25/18
  • Last Seen:  

48 minutes ago, DepTrai said:

Hi.Fail to download?

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  1167
  • Reputation:   159
  • Joined:  06/12/12
  • Last Seen:  

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
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  242
  • Reputation:   37
  • Joined:  02/25/18
  • Last Seen:  

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
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  1167
  • Reputation:   159
  • Joined:  06/12/12
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  41
  • Topics Per Day:  0.01
  • Content Count:  197
  • Reputation:   19
  • Joined:  11/20/11
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  242
  • Reputation:   37
  • Joined:  02/25/18
  • Last Seen:  

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
Link to comment
Share on other sites

×
×
  • Create New...