jmginer Posted August 27, 2015 Share Posted August 27, 2015 Hello, the number of domains in the "Popular" categorie is too high. How to edit? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted August 27, 2015 Share Posted August 27, 2015 Hello, the number of domains in the "Popular" category is too high.How to edit? there is no method to edit them from the Admin Area. the only way to change them would be to manually edit the database and remove the entries from one of the tables - but there would be no guarantee that a future WHMCS update wouldn't reassign them to their previous categories. http://docs.whmcs.com/Version_6.0_Database_Changes if you are not familiar with MySQL and editing databases directly, then I would suggest that you do NOT try without making a backup first. there are 173 TLDs in the "Popular" Category - to save you the time finding them yourself, i'll list them below: tld_id:tld 7:academy 20:agency 33:archi 38:asia 39:associates 54:bar 57:bargains 69:best 72:bid 73:bike 76:biz 79:blackfriday 81:blue 88:boutique 97:build 98:builders 101:buzz 106:cab 109:camera 110:camp 112:capital 114:cards 117:careers 123:catering 125:cc 126:center 127:ceo 132:cheap 135:christmas 140:cleaning 143:clothing 145:club 150:co.com 155:codes 156:coffee 159:com 172:community 173:company 175:computer 177:condos 178:construction 181:contractors 182:cooking 184:cool 187:country 199:cruises 203:dance 206:dating 215:democrat 220:diamonds 224:directory 231:domains 243:education 244:email 248:engineering 249:enterprises 251:equipment 255:estate 259:events 260:exchange 261:expert 262:exposed 269:farm 278:fish 279:fishing 283:flights 284:florist 293:foundation 300:futbol 303:gallery 314:gift 318:glass 327:graphics 331:gripe 337:guitars 338:guru 362:holdings 363:holiday 366:horse 373:house 382:immobilien 387:industries 388:info 391:ink 392:institute 395:international 420:kim 421:kitchen 422:kiwi 429:land 436:lease 444:lighting 446:limo 447:link 462:luxury 465:maison 466:management 469:marketing 477:media 484:menu 491:mobi 511:nagoya 512:name 516:net 531:ninja 553:onl 556:org 574:partners 575:parts 587:photo 588:photography 589:photos 591:pics 592:pictures 594:pink 600:plumbing 606:productions 609:properties 611:pub 624:recipes 625:red 632:rentals 633:repair 634:report 636:rest 639:reviews 640:rich 644:rodeo 675:services 677:sexy 682:shiksha 683:shoes 688:singles 695:social 697:solar 698:solutions 716:supplies 717:supply 718:support 724:systems 727:tattoo 733:technology 740:tienda 741:tips 747:today 749:tools 755:trade 757:training 764:uk 768:uno 769:us 773:vacations 777:ventures 781:viajes 783:villas 786:vision 788:vodka 792:voyage 795:watch 800:webcam 808:wiki 813:works 825:xn--3ds443g 834:xn--6frz82g 839:xn--80asehdb 840:xn--80aswg 845:xn--c1avg 862:xn--fiq228c5hs 890:xn--ngbc5azd 893:xn--nqv7f 900:xn--q9jyb4c 915:xyz 924:zone if your familiar with editing database tables and still want to edit them, post back and i'll tell you how. 0 Quote Link to comment Share on other sites More sharing options...
jmginer Posted August 27, 2015 Author Share Posted August 27, 2015 181:contractors popular domain? 0 Quote Link to comment Share on other sites More sharing options...
jmginer Posted August 27, 2015 Author Share Posted August 27, 2015 This in my list of what I consider popular extensions A list of 15-30 TLDs can be popular... 173 TLDs maybe Enom wants to be popular, but not yet... == Generic == com net org info biz == Related my country == es com.es nom.es org.es cat gal eus == Continent == eu us asia africa.com == Extra == tel pro xxx mobi tv fm me to 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted August 27, 2015 Share Posted August 27, 2015 during the beta, I was very critical of the way they've designed this - http://forum.whmcs.com/showthread.php?100134-Domainchecker then once we started getting the standard waffle of "that's certainly not to say it can't or won't happen in the future", I walked away from the thread as I knew it would be better/quicker to work on my own solution - when the time comes, all I will need to do is duplicate the tables, add some useful new features, fix the categories and TLDs, write the action hook to generate the table variables.. simple. for me, I don't even need an interface for this as i'm happy to edit the database directly. but what we've been given so far with this feature is a car with no steering wheel - fine if you want to follow the path decided by WHMCS (e.g use their categories); difficult to drive if you don't!... and don't get me started on why the category titles are not multilingual - it wouldn't have been difficult to make them so. anyway, if you wanted the trim the "Popular" category, you would need to edit the tbltld_category_pivot database table - i'm assuming your familiar with phpmyadmin (or similar). you should be looking for entries that contain the category_id value of "9" (9 is the "Popular" category).. so if we take the first on the above TLD list of ".academy", we can see that it is in 3 categories ("Education", "Popular" and "gTLD"). if you delete the table row highlighted in red above, that will remove ".academy" from the "Popular" Category - but leave it in the other two categories, "Education" 8 and "gTLD" 1... one down, only another 150+ for you to do! 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.