CyberDevil Posted April 5, 2018 Group: Members Topic Count: 40 Topics Per Day: 0.02 Content Count: 242 Reputation: 37 Joined: 02/25/18 Last Seen: December 2, 2024 Share 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 Link to comment Share on other sites More sharing options...
CyberDevil Posted March 27, 2019 Group: Members Topic Count: 40 Topics Per Day: 0.02 Content Count: 242 Reputation: 37 Joined: 02/25/18 Last Seen: December 2, 2024 Author Share Posted March 27, 2019 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 More sharing options...
Mael Posted March 27, 2019 Group: Forum Moderator Topic Count: 25 Topics Per Day: 0.01 Content Count: 837 Reputation: 321 Joined: 02/11/19 Last Seen: Yesterday at 01:54 PM Share Posted March 27, 2019 Get your LIKE, good man. Link to comment Share on other sites More sharing options...
DepTrai Posted March 27, 2019 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 8 Reputation: 0 Joined: 03/16/19 Last Seen: October 14, 2019 Share Posted March 27, 2019 Hi.Fail to download? Link to comment Share on other sites More sharing options...
CyberDevil Posted March 27, 2019 Group: Members Topic Count: 40 Topics Per Day: 0.02 Content Count: 242 Reputation: 37 Joined: 02/25/18 Last Seen: December 2, 2024 Author Share Posted March 27, 2019 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 More sharing options...
hendra814 Posted March 28, 2019 Group: Members Topic Count: 59 Topics Per Day: 0.01 Content Count: 1281 Reputation: 170 Joined: 06/12/12 Last Seen: 8 hours ago Share 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 Link to comment Share on other sites More sharing options...
CyberDevil Posted March 28, 2019 Group: Members Topic Count: 40 Topics Per Day: 0.02 Content Count: 242 Reputation: 37 Joined: 02/25/18 Last Seen: December 2, 2024 Author Share 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 Link to comment Share on other sites More sharing options...
hendra814 Posted March 28, 2019 Group: Members Topic Count: 59 Topics Per Day: 0.01 Content Count: 1281 Reputation: 170 Joined: 06/12/12 Last Seen: 8 hours ago Share 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 Link to comment Share on other sites More sharing options...
mirabell Posted March 28, 2019 Group: Members Topic Count: 41 Topics Per Day: 0.01 Content Count: 197 Reputation: 19 Joined: 11/20/11 Last Seen: February 28 Share Posted March 28, 2019 how do you enable flux cp to display descriptions once you add this to mysql? Link to comment Share on other sites More sharing options...
CyberDevil Posted March 29, 2019 Group: Members Topic Count: 40 Topics Per Day: 0.02 Content Count: 242 Reputation: 37 Joined: 02/25/18 Last Seen: December 2, 2024 Author Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts