private function migrateReplies(){ global $wpdb; // đŸ”č dernier topic WP traitĂ© pour les replies $last_topic_wp = (int) $this->getLast_Topic(); // STEP 1 : batch topics WP $topic_rows = $wpdb->get_results($wpdb->prepare(" SELECT p.ID AS wp_topic_id, pm.meta_value AS xoops_topic_id FROM {$wpdb->posts} p JOIN {$wpdb->postmeta} pm ON pm.post_id = p.ID AND pm.meta_key = 'bbex_topic_id' WHERE p.post_type = 'topic' AND p.ID > %d ORDER BY p.ID ASC LIMIT 2000 ", $last_topic_wp)); if(!$topic_rows){ $this->log('🏁 REPLIES DONE → plus aucun topic WP Ă  traiter'); update_option('bbex_replies_done', 1, false); return; } // BUILD MAP $topic_map = []; $xoops_topic_ids = []; foreach($topic_rows as $t){ $topic_map[(int)$t->xoops_topic_id] = (int)$t->wp_topic_id; $xoops_topic_ids[] = (int)$t->xoops_topic_id; } $ids_sql = implode(',', $xoops_topic_ids); $this->log("🔄 REPLIES BATCH START"); $this->log("WP topics batch: " . count($topic_rows)); $this->log("XOOPS topics batch: " . count($xoops_topic_ids)); $this->log("XOOPS range: " . (min($xoops_topic_ids) ?? 0) . " → " . (max($xoops_topic_ids) ?? 0)); // STEP 2 : GET POSTS (LIVE XOOPSEOL) $posts = $wpdb->get_results(" SELECT p.post_id, p.topic_id AS xoops_topic_id, p.uid, p.pid, p.post_time, pt.post_text FROM {$this->getTable('posts')} p JOIN {$this->getTable('posts_text')} pt ON pt.post_id = p.post_id WHERE p.topic_id IN ($ids_sql) ORDER BY p.post_id ASC "); if(!$posts){ $max_wp_topic = max(array_column($topic_rows, 'wp_topic_id')); $this->setLast_Topic($max_wp_topic); $this->log("⚠ Aucun post trouvĂ©"); $this->log("âžĄïž Skip batch → last_topic_wp=$max_wp_topic"); return; } $inserted = 0; $skipped = 0; $updated = 0; $total = count($posts); $i = 0; foreach($posts as $p){ $i++; if($i % 200 === 0 || $i === $total){ $pct = round(($i / $total) * 100, 2); $this->log("⏳ Progress replies: $i/$total ($pct%) | inserted=$inserted skipped=$skipped updated=$updated"); } // user check if(empty($this->user_map[$p->uid])){ $skipped++; continue; } $wp_tid = $topic_map[(int)$p->xoops_topic_id] ?? 0; if(!$wp_tid){ $skipped++; continue; } // MAIN TOPIC POST → CONTENT if($p->pid == 0){ $wpdb->query($wpdb->prepare(" UPDATE {$wpdb->posts} SET post_content = IF(post_content = '', %s, post_content) WHERE ID = %d ", $p->post_text, $wp_tid)); $updated++; continue; } // ANTI DOUBLON $exists = $wpdb->get_var($wpdb->prepare(" SELECT 1 FROM bbex_post_lookup WHERE xoops_post_id = %d AND type = 'reply' LIMIT 1 ", $p->post_id)); if($exists){ $skipped++; continue; } // INSERT REPLY $wpdb->insert($wpdb->posts, [ 'post_author' => $this->user_map[$p->uid], 'post_date' => date('Y-m-d H:i:s', $p->post_time), 'post_content' => $p->post_text, 'post_status' => 'publish', 'post_type' => 'reply', 'post_parent' => $wp_tid ]); $rid = (int) $wpdb->insert_id; if(!$rid){ $skipped++; continue; } $inserted++; // meta topic $wpdb->insert($wpdb->postmeta,[ 'post_id' => $rid, 'meta_key' => '_bbp_topic_id', 'meta_value' => $wp_tid ]); // forum $forum_id = $wpdb->get_var($wpdb->prepare(" SELECT post_parent FROM {$wpdb->posts} WHERE ID = %d ", $wp_tid)); if($forum_id){ $wpdb->insert($wpdb->postmeta,[ 'post_id' => $rid, 'meta_key' => '_bbp_forum_id', 'meta_value' => $forum_id ]); } // lookup $wpdb->query($wpdb->prepare(" INSERT INTO bbex_post_lookup (xoops_post_id, wp_post_id, type) VALUES (%d, %d, 'reply') ON DUPLICATE KEY UPDATE wp_post_id = wp_post_id ", $p->post_id, $rid)); } $max_wp_topic = max(array_column($topic_rows, 'wp_topic_id')); $this->setLast_Topic($max_wp_topic); $this->log("===================================="); $this->log("🏁 REPLIES BATCH FINISHED"); $this->log("📊 total=$total | inserted=$inserted | updated=$updated | skipped=$skipped"); $this->log("âžĄïž last_topic_wp=$max_wp_topic"); $this->log("===================================="); } if(isset($_GET['source'])){ $migration->setSource($_GET['source']); } i am a jack of all buses - Oasis des Artistes. Le plus beau site de poĂ©sie

Oasis des Artistes. Le plus beau site de poésie

Oasis des artistes: PoĂ©sie en ligne, Concours de poĂšmes en ligne – membres !

été 20 ans oasis des artistes
oasisdesartistes.org-logo

i am a jack of all buses

  • Ce sujet contient 2 réponses, 3 participants et a Ă©tĂ© mis Ă  jour pour la derniĂšre fois par Avatar photogrodele, le 30-08-2012 05:50.
  • Créateur
    Sujet
  • 3 septembre 2012 à 19h44 #2621492
    Mascotte d'Oasis
    Avatar photoislander
    Membre Oasis
      • Sujet: 8957
      • RĂ©ponses: 96782

      I am a Jack of all busses,
      from Los Angeles to Jacksonville,
      I look at you people in bus,
      Black kids full of cunningly practices,
      I am a jack of all buses,
      from New York to New Orleans,
      I can feel the storms in hearts,
      ordinary people breaking glasses,
      all stations are the same
      but all people are different,
      I can hear the voice of Springsteen,

      I am a Jack of all busses,
      can’t forget America the great,
      and the laughter of big wheels
      in the fields of my loneliness;
      I am a jack of all buses,
      see your empty faces full of grace
      in every nook of Washington,
      let’s cross the nuclear lands
      when there are such radiations,
      radiations of hearts and knots,
      radiations of hopes and elegies,
      I am a jack of all busses,

      I am a Jack of all busses,
      where are going all these people ?
      I don’t know a single one,
      so I look at the moon of Ohio,
      there is a babe somewhere
      to forgive my soul misery,
      not in a station of the East,
      somewhere down the rainbow
      there is a babe full of kisses
      waiting that the bus stop forever,

      I am a jack of all busses,
      and cause you don’t like poems,
      I ‘m gonna drive no mystery ever
      and get out of this damn bus,
      leaving rivers and sour trains,
      national parks and souvenirs,
      i bear a safety belt of jokes,
      Today, I am a Jack of all busses
      thanks everybody.

      Je suis un vagabond des bus,
      de Los Angeles Ă  Jacksonville,
      je vous observe, peuple des bus,
      enfants noirs pleins de malices,
      je suis un vagabond des bus,
      de New York Ă  New Orleans,
      je peux voir des orages Ă©tranges,
      des gens ordinaires brisant les verres,
      les stations de bus sont les mĂȘmes
      mais les coeurs sont différents,
      j’entend la voix rauque de springsteen

      je suis un vagabond des bus,
      je ne peux oublier l’AmĂ©rique la grande
      ni le rire des grandes roues
      au travers des champs de solitude,
      je suis un vagabond des bus,
      je vois vos visages creux pleins de grĂące
      dans les quartiers de Washington,
      traversons les terres contaminées,
      oĂč il y a tant de radiations,
      celles des coeurs et des cartes,
      celles des espoirs et des élégies,
      je suis un vagabond des bus,

      Je suis un vagabonds des bus,
      OĂč vont tous ces gens ?
      Je n’en connais pas un seul,
      amis, je connais la lune de l’Ohio,
      il y a une poupée quelque part
      qui soigne mon Ăąme malade,
      pas dans une station de l’est,
      quelqu’un au bas de l’arc en ciel,
      une poupée plaine de baisers
      attendant que tous les bus s’arrĂȘtent,

      Je suis un vagabond des bus,
      et si vous n’aimez pas mes poĂšmes,
      je ne conduirai plus ces vieux mystĂšres
      et vais sortir de ce foutu bus,
      laissant les riviĂšres et les trains acides,
      les parcs nationaux, les souvenirs,
      j’ai dĂ©tachĂ© ma ceinture de sĂ©curitĂ©,
      oui, je suis un vagabond des bus,
      merci Ă  chacun d’entre vous,
      compagnons du hasard des routes.

      un poĂšme en souvenir de nombreux trajets en bus aus USA, prĂšs de 4 mois, hommage aussi Ă  Sprignteen et Ă  Kerouac

    • Créateur
      Sujet
    Vous lisez 1 fil de discussion
    Vous lisez 1 fil de discussion
    • Vous devez être connecté pour répondre à ce sujet.