----- Original Message -----
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.
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&:type=stories&author=6">More
from "user name"</a></li><li><a
haref="http://www.mynewsite.com.ar/search.php?
mode=search&: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 -----
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?
