[geeklog-users] Changing Domain

Fri Jun 20 04:20:16 EDT 2003

What does this mean amp; ?  

it is everywhere inside the related field in gl_stories. 

thanks

Can someone answer something? anybody there?  I feel like I'm talking alone

  ----- Original Message ----- 
  From: geeklog-users-admin at lists.geeklog.net 
  To: geeklog-users at lists.geeklog.net 
  Sent: Thursday, June 19, 2003 11:32 PM
  Subject: Re: [geeklog-users] Changing Domain

  I've got a small problem when doing UPDATE in Mysql.

  The content has some quotation symbol ( " ) that brakes the comand entry.

  how can I put some quotations inside a cell using the command Update ??

  Thanks!!!

    ----- Original Message ----- 
    From: geeklog-users-admin at lists.geeklog.net 
    To: geeklog-users at lists.geeklog.net 
    Sent: Thursday, June 19, 2003 11:15 PM
    Subject: Re: [geeklog-users] Changing Domain

    How does the gl_story  table work?

    I did a "Select * from gl_story" in mysql and I get this example. 

    |     1|    0|    0| <li><a haref="http://www.myoldsite.com.ar/search.php?mode=search&amp:type=stories&author=6">More from "user name"</a></li><li><a haref="http://www.myoldsite.com.ar/search.php?mode=search&amp:type=type=stories&topic="topicname" ">  More from "topic name"</a></li>    | 0 |    1|    0|    0|    plaintext|    1|    6|    3|    3|    2|    2|    2|
    3|    2|    2|    2|
    | 20030407015244802 | 6| 0| "topic name" | 2002-03-04 01:52:44 | "story Title"    | "Story content"

    If I want to visualise this I can realize that every Story is a Row separate in Fields by this symbol " | ". 
    Am I right?

    But when I put "describe gl_sotries;" in Mysql   i get 24 Fields   and If I count every field by using this symbol " | "  I get some more and in a diferent order. 

    Per example when I do "Select * from gl_story" I get  the Story Content at the end, and when I do describe table I get it as a number 8 (in terms of order).

    All those 0| 1| 3| etc.  are the story options that were selected when creating the story, per example enable comments on off,  etc.  am I right?

    I realize that here is the place where I see the old URL that the Script didn't change. 

    Do you know any Mysql command to replace all the old URL name by the new one?
    I'm not an expert, I'm just learning the stuff. So I don't know lot of Mysql commands. 

    No i did a "Select related from gl_stories" and I can clearly see the place the target place. 

    It is crazy the way that the script worked, it sometimes add the new URL instead of updating it. 

    So It did this 3 things. 

    1) it sometimes update it right
    2) it sometimes just add the new url at the beggining.
    3) do nothing. 

    Unlikely "do nothing" was what it did the most.

    Wich one will be the right Mysql comman that I need to replace this?

    Update comman?

    Can you please give me an exmaple?

    I have only 4 guys that were writing storys. 

    So I think It should be something like this:

    UPDATE gl_stories SET related = "<li><a haref="http://www.mynewsite.com.ar/search.php?mode=search&amp:type=stories&author=6">More from "user name"</a></li><li><a haref="http://www.mynewsite.com.ar/search.php? mode=search&amp:type=type=stories&topic="topicname" ">  More from "topic name"</a></li>" WHERE uid = "user number";

    mmm, I think this will be a solution.  And by doing this I will get rid of those duplicated links, etc. 

    Another thing that I think this will be usefull is when you change the topic name the related block show the old topic name for the stories that were written under the old topic name instead of looking for that name dynamically. So you can update the old stories to the new topic name by doing it in this way. 

    I hope this work, I'm going to Backup the Database before!!! Cya!!!

    I now I'm the only one with this problem, but I hope it helps to the guys that change the topic name a little bit, so the  "Related Block"  shows the updated topic name.

    : )

    I'm happy!!! : )

    cya

    FB

      ----- Original Message ----- 
      From: geeklog-users-admin at lists.geeklog.net 
      To: geeklog-users at lists.geeklog.net 
      Sent: Thursday, June 19, 2003 9:15 PM
      Subject: Re: [geeklog-users] Changing Domain

      Is there any Plugin that store every "Story Title"  in a special place of the Database?  

      So A user can quickly watch only "the titles" of all the stories?

      Thanks!!

      Another Question,  Do you suggest to post at first here in the "email list" or in the "Geeklog site"?

      How many guys are reading this email list compared to the Geeklog site?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist8.pair.net/pipermail/geeklog-users/attachments/20030620/613a72ce/attachment.html>