| Author |
 Topic  |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
 Posted - 25 November 2005 : 05:10:43
|
Has anyone managed to put together a script that will update the T_POSTS and R_POSTS fields of the TOPICS and REPLY tables that are used by the Post Stamp Mod? I know the mod itself includes a file that will do this for Access but has anyone done one for MySQL? I have been using this script for a while, but I notice today that it's not entirely accurate and, feeling under the weather as I am, I can't muster up the energy to figure it out. If you have a look here (numbers in bold is what the value of [X]_POSTS should be, other number is it's actual value), you'll see that my first 2 posts are "missing" and that I have 2 posts stamped number 24 and 25. Any assistance greatly appreciated  But, in the meantime, I'm going to have another look at the Access script, see if it can't be used with the newer version of MySQL we're using now.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 25 November 2005 : 11:49:13
|
Huzzah! Managed to fix it by going back to the original Access file and coming up with this script. Thank god for UNIONs! 
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
Edited by - Shaggy on 25 November 2005 12:17:32 |
 |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 25 November 2005 : 12:12:42
|
Huzzah for 404's!
 well it *is* the weekend |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 25 November 2005 : 12:18:36
|
Fixed! It's only the weekend for some people; my excuse is, I'm sick!
Should be noted that the above'll only work with later versions of MySQL that support UNIONs.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
| |
Topic |
|
Topic Locked
