Re: [geeklog-users] Changing Domain

geeklog-users-admin Fri, 20 Jun 2003 01:16:22 -0500

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

----- Original Message -----

From: [EMAIL PROTECTED]

To: [EMAIL PROTECTED]

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?

Re: [geeklog-users] Changing Domain

Reply via email to