CyberDevil Posted April 5, 2018 Posted April 5, 2018 (edited) View File 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! Submitter CyberDevil Submitted 04/05/2018 Category Other Web/CP Scripts Video Content Author CyberDevil Edited March 29, 2019 by CyberDevil 1 1 1
CyberDevil Posted March 27, 2019 Author Posted March 27, 2019 Update all descriptions to today's date... if you want to thank me you can give me a "LIKE"!
CyberDevil Posted March 27, 2019 Author Posted March 27, 2019 48 minutes ago, DepTrai said: Hi.Fail to download? I think it's in pending approval, try later!
hendra814 Posted March 28, 2019 Posted March 28, 2019 (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 Edited March 28, 2019 by hendra814
CyberDevil Posted March 28, 2019 Author Posted March 28, 2019 (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 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 March 28, 2019 by CyberDevil
hendra814 Posted March 28, 2019 Posted March 28, 2019 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
mirabell Posted March 28, 2019 Posted March 28, 2019 how do you enable flux cp to display descriptions once you add this to mysql?
CyberDevil Posted March 29, 2019 Author Posted March 29, 2019 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 1
Recommended Posts