编辑文件 - insert.php

✏️ 正在编辑: insert.php

路径: /home/bpioifn/www/pigmentse/modules/everpsdomtomsecure/sql/insert.php
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

<?php
/**
 * Project : everpsdomtomsecure
 * @author Team Ever
 * @copyright Team Ever
 * @license   Tous droits réservés / Le droit d'auteur s'applique (All rights reserved / French copyright law applies)
 * @link https://www.team-ever.com
 */

if (!defined('_PS_VERSION_')) {
    exit;
}

$sql = array();
$sql[] =
    'INSERT INTO `'._DB_PREFIX_.'everpsdomtomsecure`
    (`city_name`, `postcode`) VALUES
    ("BASSE TERRE","97100"),
    ("POINTE A PITRE","97110"),
    ("MORNE A L EAU","97111"),
    ("GRAND BOURG","97112"),
    ("GOURBEYRE","97113"),
    ("TROIS RIVIERES","97114"),
    ("STE ROSE","97115"),
    ("POINTE NOIRE","97116"),
    ("PORT LOUIS","97117"),
    ("ST FRANCOIS","97118"),
    ("VIEUX HABITANTS","97119"),
    ("ST CLAUDE","97120"),
    ("ANSE BERTRAND","97121"),
    ("BAIE MAHAULT","97122"),
    ("BAILLIF","97123"),
    ("BOUILLANTE","97125"),
    ("PIGEON","97125"),
    ("DESHAIES","97126"),
    ("LA DESIRADE","97127"),
    ("GOYAVE","97128"),
    ("LAMENTIN","97129"),
    ("CAPESTERRE BELLE EAU","97130"),
    ("BANANIER","97130"),
    ("STE MARIE","97130"),
    ("PETIT CANAL","97131"),
    ("LES MANGLES","97131"),
    ("ST BARTHELEMY","97133"),
    ("ST LOUIS","97134"),
    ("TERRE DE BAS","97136"),
    ("TERRE DE HAUT","97137"),
    ("LES ABYMES","97139"),
    ("CAPESTERRE DE MARIE GALANTE","97140"),
    ("VIEUX FORT","97141"),
    ("LES ABYMES","97142"),
    ("ST MARTIN","97150"),
    ("LE MOULE","97160"),
    ("PETIT BOURG","97170"),
    ("STE ANNE","97180"),
    ("DOUVILLE","97180"),
    ("LE GOSIER","97190"),
    ("FORT DE FRANCE","97200"),
    ("RIVIERE PILOTE","97211"),
    ("ST JOSEPH","97212"),
    ("GROS MORNE","97213"),
    ("LE LORRAIN","97214"),
    ("RIVIERE SALEE PETIT BOURG","97215"),
    ("RIVIERE SALEE","97215"),
    ("L AJOUPA BOUILLON","97216"),
    ("LES ANSES D ARLET","97217"),
    ("GRAND RIVIERE","97218"),
    ("BASSE POINTE","97218"),
    ("MACOUBA","97218"),
    ("LA TRINITE","97220"),
    ("LE CARBET","97221"),
    ("BELLEFONTAINE","97222"),
    ("CASE PILOTE","97222"),
    ("LE DIAMANT","97223"),
    ("DUCOS","97224"),
    ("LE MARIGOT","97225"),
    ("LE MORNE VERT","97226"),
    ("STE ANNE","97227"),
    ("STE LUCE","97228"),
    ("LES TROIS ILETS","97229"),
    ("STE MARIE","97230"),
    ("STE MARIE MORNE DES ESSES","97230"),
    ("LE ROBERT","97231"),
    ("ROBERT VERT PRE","97231"),
    ("LE LAMENTIN","97232"),
    ("SCHOELCHER","97233"),
    ("FORT DE FRANCE","97234"),
    ("LE FRANCOIS","97240"),
    ("FONDS ST DENIS","97250"),
    ("ST PIERRE","97250"),
    ("LE PRECHEUR","97250"),
    ("LE MORNE ROUGE","97260"),
    ("ST ESPRIT","97270"),
    ("LE VAUCLIN","97280"),
    ("LE MARIN","97290"),
    ("CAYENNE","97300"),
    ("KOUROU","97310"),
    ("ROURA","97311"),
    ("ST ELIE","97312"),
    ("ST GEORGES","97313"),
    ("SAUL","97314"),
    ("SINNAMARY","97315"),
    ("POMPIDOU PAPA ICHTON","97316"),
    ("APATOU","97317"),
    ("JAVOUHEY","97318"),
    ("AWALA YALIMAPO","97319"),
    ("ST LAURENT DU MARONI","97320"),
    ("CAMOPI","97330"),
    ("GRAND SANTI","97340"),
    ("IRACOUBO","97350"),
    ("MATOURY","97351"),
    ("CACAO","97352"),
    ("KAW","97353"),
    ("REMIRE MONTJOLY","97354"),
    ("MACOURIA TONATE","97355"),
    ("MONTSINERY TONNEGRANDE","97356"),
    ("MANA","97360"),
    ("MARIPASOULA","97370"),
    ("OUANARY","97380"),
    ("REGINA","97390"),
    ("ST DENIS TADAR","97400"),
    ("BELLE PIERRE","97400"),
    ("LE BRULE","97400"),
    ("ST DENIS","97400"),
    ("ST DENIS CAMELIAS","97400"),
    ("ST FRANCOIS","97400"),
    ("BASSE TERRE","97410"),
    ("ST PIERRE","97410"),
    ("MONT VERT","97410"),
    ("RAVINE BLANCHE","97410"),
    ("GRAND BOIS","97410"),
    ("TERRE SAINTE","97410"),
    ("BOIS DE NEFLES ST PAUL","97411"),
    ("RIVIERE DU MAT","97412"),
    ("BRAS PANON","97412"),
    ("PALMISTE ROUGE","97413"),
    ("CILAOS","97413"),
    ("ENTRE DEUX","97414"),
    ("LA CHALOUPE","97416"),
    ("LA MONTAGNE","97417"),
    ("ST BERNARD","97417"),
    ("LA PLAINE DES CAFRES","97418"),
    ("TAMPON 17EME KM","97418"),
    ("LA POSSESSION","97419"),
    ("LE DOS D ANE","97419"),
    ("STE THERESE","97419"),
    ("LA RIVIERE DES GALETS","97419"),
    ("LE PORT MARINE","97420"),
    ("LE PORT","97420"),
    ("LE PORT ZUP","97420"),
    ("LES MAKES","97421"),
    ("LA RIVIERE","97421"),
    ("LA SALINE","97422"),
    ("LE GUILLAUME","97423"),
    ("LE PITON ST LEU","97424"),
    ("LE PLATE","97424"),
    ("LES AVIRONS","97425"),
    ("TEVELAVE","97425"),
    ("LES TROIS BASSINS","97426"),
    ("L ETANG SALE LES BAINS","97427"),
    ("L ETANG SALE","97427"),
    ("PITON GOYAVES","97429"),
    ("PETITE ILE","97429"),
    ("TAMPON 14EME KM","97430"),
    ("LE TAMPON","97430"),
    ("PONT D YVES","97430"),
    ("LES TROIS MARES","97430"),
    ("LA PLAINE DES PALMISTES","97431"),
    ("RAVINE DES CABRIS","97432"),
    ("SALAZIE","97433"),
    ("HELL BOURG","97433"),
    ("LA SALINE LES BAINS","97434"),
    ("ST GILLES LES BAINS","97434"),
    ("BERNICA","97435"),
    ("ST GILLES LES HAUTS","97435"),
    ("TAN ROUGE","97435"),
    ("ST LEU","97436"),
    ("STE ANNE","97437"),
    ("STE MARIE","97438"),
    ("LA GRANDE MONTEE","97438"),
    ("RIVIERE DES PLUIES","97438"),
    ("ROLAND GARROS AEROPORT","97438"),
    ("STE ROSE","97439"),
    ("LE PITON STE ROSE","97439"),
    ("ST ANDRE","97440"),
    ("CAMBUSTON","97440"),
    ("LA CRESSONNIERE","97440"),
    ("STE SUZANNE","97441"),
    ("BASSE VALLEE","97442"),
    ("ST PHILIPPE","97442"),
    ("ST LOUIS","97450"),
    ("ST PAUL","97460"),
    ("BELLEMENE","97460"),
    ("PLATEAU CAILLOUX","97460"),
    ("ST BENOIT","97470"),
    ("BEAUFONDS","97470"),
    ("ST JOSEPH","97480"),
    ("VINCENDO","97480"),
    ("JEAN PETIT","97480"),
    ("LES LIANES","97480"),
    ("BOIS DE NEFLES ST DENIS","97490"),
    ("MOUFIA","97490"),
    ("STE CLOTILDE","97490"),
    ("LA BRETAGNE","97490"),
    ("ST DENIS CHAUDRON","97490"),
    ("MIQUELON LANGLADE","97500"),
    ("LANGLADE","97500"),
    ("ST PIERRE","97500"),
    ("MAMOUDZOU","97600"),
    ("KOUNGOU","97600"),
    ("KAWENI","97600"),
    ("PASSAMAINTI","97605"),
    ("LABATTOIR","97615"),
    ("DZAOUDZI","97615"),
    ("PAMANDZI","97615"),
    ("BOUENI","97620"),
    ("CHIRONGUI","97620"),
    ("KANI KELI","97625"),
    ("ACOUA","97630"),
    ("MTSAMBORO","97630"),
    ("SADA","97640"),
    ("DZOUMOGNE","97650"),
    ("M TSANGAMOUJI","97650"),
    ("BANDRABOUA","97650"),
    ("DEMBENI","97660"),
    ("BANDRELE","97660"),
    ("CHICONI","97670"),
    ("OUANGANI","97670"),
    ("COCONI","97670"),
    ("COMBANI","97680"),
    ("TSINGONI","97680"),
    ("UVEA","98600"),
    ("ALO","98610"),
    ("SIGAVE","98620"),
    ("ARUE","98701"),
    ("PUNAAUIA","98703"),
    ("FAAA","98704"),
    ("HITIAA","98705"),
    ("MAHAENA","98706"),
    ("PAPENOO","98707"),
    ("TIAREI","98708"),
    ("MAHINA","98709"),
    ("OROFARA","98710"),
    ("PAEA","98711"),
    ("PAPARA","98712"),
    ("PAPEETE","98714"),
    ("PIRAE","98716"),
    ("PUNAAUIA","98718"),
    ("TARAVAO","98719"),
    ("AFAAHITI","98719"),
    ("FAAONE","98720"),
    ("PUEU","98721"),
    ("TAUTIRA","98722"),
    ("TEAHUPOO","98723"),
    ("TOAHOTU","98724"),
    ("VAIRAO","98725"),
    ("MATAIEA","98726"),
    ("PAPEARI","98727"),
    ("TIAIA","98728"),
    ("AFAREAITU","98728"),
    ("MAATEA","98728"),
    ("MAHAREPA","98728"),
    ("TEAVARO","98728"),
    ("VAIARE","98728"),
    ("HAUMI","98728"),
    ("PAOPAO","98728"),
    ("TEMAE","98728"),
    ("PIHAENA","98729"),
    ("ATIHA","98729"),
    ("HAAPITI","98729"),
    ("PAOPAO","98729"),
    ("TIAHURA","98729"),
    ("VARARI","98729"),
    ("MAIAO","98729"),
    ("HAURU","98729"),
    ("OPUNOHU","98729"),
    ("PAPETOAI","98729"),
    ("VAIANAE","98729"),
    ("ANAU","98730"),
    ("FAANUI","98730"),
    ("NUNUE","98730"),
    ("VAITAPE","98730"),
    ("MAEVA","98731"),
    ("PAREA","98731"),
    ("FAIE","98731"),
    ("FITII","98731"),
    ("HAAPU","98731"),
    ("TEFARERII","98731"),
    ("FARE","98731"),
    ("HUAHINE","98731"),
    ("MAROE","98731"),
    ("MOPELIA","98732"),
    ("AVERA","98732"),
    ("SCILLY","98732"),
    ("MAUPITI","98732"),
    ("MOTU ONE","98732"),
    ("PATIO","98733"),
    ("RUUTIA","98733"),
    ("TIVA","98733"),
    ("TAHAA","98733"),
    ("HIPU","98733"),
    ("IRIPAU","98733"),
    ("TAPUAMU","98733"),
    ("POUTORU","98734"),
    ("VAITOARE","98734"),
    ("HAAMENE","98734"),
    ("FAAAHA","98734"),
    ("NIUA","98734"),
    ("OPOA","98735"),
    ("UTUROA","98735"),
    ("TEHURUI","98735"),
    ("AVERA","98735"),
    ("TUMARAA","98735"),
    ("FETUNA","98735"),
    ("TAPUTAPUATEA","98735"),
    ("PUOHINE","98735"),
    ("TEVAITOA","98735"),
    ("OMOA","98740"),
    ("HANAVAVE","98740"),
    ("HANAPAOA","98741"),
    ("EIAONE","98741"),
    ("MOTU UA","98741"),
    ("NAHOE","98741"),
    ("PAUMAU","98741"),
    ("HANAIAPA","98741"),
    ("ATUONA","98741"),
    ("NUKUATAHA","98742"),
    ("AAKAPA","98742"),
    ("TAIOHAE","98742"),
    ("TAIPIVAI","98742"),
    ("TERRE DESERTE","98742"),
    ("VAITAHU","98743"),
    ("HAPATONI","98743"),
    ("HANATETENA","98743"),
    ("MOTOPU","98743"),
    ("VAIPAEE","98744"),
    ("HAKAHETAU","98745"),
    ("HAKAHAU","98745"),
    ("HAKATAO","98745"),
    ("HOHOI","98745"),
    ("HAKAMAII","98746"),
    ("HAAKUTI","98746"),
    ("HANE","98747"),
    ("HATIHEU","98748"),
    ("PUAMAU","98749"),
    ("ANATONU","98750"),
    ("MAHANATOA","98750"),
    ("RAIRUA","98750"),
    ("VAIURU","98750"),
    ("AHUREI","98751"),
    ("AMARU","98752"),
    ("ANAPOTO","98752"),
    ("MUTUAURA","98752"),
    ("RIMATARA","98752"),
    ("HAUTI","98753"),
    ("AVERA","98753"),
    ("MOERAI","98753"),
    ("TAAHUAIA","98754"),
    ("MATAURA","98754"),
    ("MAHU","98754"),
    ("ANGAKAUITAI","98755"),
    ("AUKENA","98755"),
    ("MANGAREVA","98755"),
    ("MANIUI","98755"),
    ("MAKAROA","98755"),
    ("KAMAKA","98755"),
    ("RIKITEA","98755"),
    ("TARAVAI","98755"),
    ("AKAMARU","98755"),
    ("TUUHORA","98760"),
    ("RAUTINI","98761"),
    ("NIUTAHI","98762"),
    ("ROTOAVA","98763"),
    ("PAPARARA","98764"),
    ("TEANA","98765"),
    ("TARIONE","98766"),
    ("OTEPA","98767"),
    ("TUPAPATI","98768"),
    ("POUHEVA","98769"),
    ("TENOKUPARA","98770"),
    ("TURIPAOA","98771"),
    ("TEPUKAMARUIA","98772"),
    ("TAVAVA","98773"),
    ("TEONEMAHINA","98774"),
    ("AVATORU","98775"),
    ("TIPUTA","98776"),
    ("PAHUA","98777"),
    ("TUHERAHERA","98778"),
    ("TAPUARAVA","98779"),
    ("MARAUTAGAROA","98780"),
    ("TEAVAROA","98781"),
    ("FAKATOPATERE","98782"),
    ("TUMUKURU","98783"),
    ("FAKAMARU","98784"),
    ("RAITAHITI","98785"),
    ("HITIANAU","98786"),
    ("TEARAVERO","98787"),
    ("TEMANUFAARA","98788"),
    ("HITIANAU","98789"),
    ("AMANU","98790"),
    ("TEANOGA","98790"),
    ("HITI","98790"),
    ("TIKEI","98790"),
    ("HEREHRETUE","98790"),
    ("MANUHANGI","98790"),
    ("AHUNUI","98790"),
    ("MOTUTAPU","98790"),
    ("TEPEPERU","98790"),
    ("HIKITAKE","98790"),
    ("OTETOU","98790"),
    ("TUANAKE","98790"),
    ("VAITEPAUA","98790"),
    ("OFARE","98790"),
    ("NENGONENGO","98790"),
    ("PARAOA","98790"),
    ("MARUTEA NORD","98790"),
    ("TEPOTO SUD","98790"),
    ("TEPUPAHEA","98790"),
    ("TOAU","98790"),
    ("MOTU TAPU","98790"),
    ("RAVAHERE","98790"),
    ("MAHETIKA","98790"),
    ("GARUMAOA","98790"),
    ("HARAIKI","98790"),
    ("HENUAPAREA","98790"),
    ("OTATAKE","98790"),
    ("MORANE","98792"),
    ("MOTUREIVAVAO","98792"),
    ("TEMOE","98792"),
    ("TENARARO","98792"),
    ("TENARUNGA","98792"),
    ("VAHANGA","98792"),
    ("MARIA EST","98792"),
    ("MARUTEA SUD","98793"),
    ("MAROTIRI","98794"),
    ("MARIA ILOTS","98795"),
    ("EIAO","98796"),
    ("FATU HUKU","98796"),
    ("HATU ITI","98796"),
    ("HATUTAA","98796"),
    ("MOHOTANI","98796"),
    ("ILE DE CLIPPERTON","98799"),
    ("NOUMEA","98800"),
    ("MONT DORE","98809"),
    ("MONT DORE","98810"),
    ("BELEP","98811"),
    ("BOULOUPARIS","98812"),
    ("CANALA","98813"),
    ("FAYAOUE","98814"),
    ("HIENGHENE","98815"),
    ("HOUAILOU","98816"),
    ("KAALA GOMEN","98817"),
    ("KOUAOUA","98818"),
    ("MOINDOU","98819"),
    ("WE","98820"),
    ("OUEGOA","98821"),
    ("POINDIMIE","98822"),
    ("PONERIHOUEN","98823"),
    ("POUEBO","98824"),
    ("POUEMBOUT","98825"),
    ("POUM","98826"),
    ("POYA","98827"),
    ("TADINE","98828"),
    ("THIO","98829"),
    ("DUMBEA","98830"),
    ("TOUHO","98831"),
    ("VAO","98832"),
    ("VOH","98833"),
    ("YATE","98834"),
    ("DUMBEA","98835"),
    ("DUMBEA GA","98836"),
    ("DUMBEA","98837"),
    ("PORO","98838"),
    ("DUMBEA","98839"),
    ("TONTOUTA","98840"),
    ("KOUMAC","98850"),
    ("KONE","98859"),
    ("KONE","98860"),
    ("BOURAIL","98870"),
    ("PONT DES FRANCAIS","98874"),
    ("PLUM","98875"),
    ("LA COULEE","98876"),
    ("NEPOUI","98877"),
    ("LA ROCHE","98878"),
    ("LA FOA","98880"),
    ("FARINO","98881"),
    ("SARRAMEA","98882"),
    ("OUACO","98883"),
    ("CHEPENEHE","98884"),
    ("MOU","98885"),
    ("PAITA","98889"),
    ("PAITA","98890")';

foreach ($sql as $s) {
    if (!Db::getInstance()->execute($s)) {
        return false;
    }
}

← 返回文件管理器