this is the first time I actually try my luck with mysql, so forgive me if the question is silly :(
if I want to change the avatar column in yabbse_members table, from tinytext to text, would this query be ok?
ALTER TABLE yabbse_members MODIFY avatar TEXT;
Is there any reason you need to do this in script? The easiest thing to do would be to go in via phpMyAdmin and change it that way.
well... I know
but this is for a mod I have almost complete, I need to give the query for others to do it too... maybe do a script to do it even, dunno
but I do need to be sure it's the correct query before using it in the mod :)
if you do it in phpmyadmin, it will tell you the SQL code too
great! I didn't know!! :o
I did it and it gave me this query
ALTER TABLE `yabbse_members` CHANGE `avatar` `avatar` TEXT DEFAULT NULL
thx guys :)
I'll release the new mod a bit later today then ;D
Quote from: bostasp on August 18, 2003, 05:22:56 PM
well, you can never argue with [Unknown]
Wrong :P.
-[Unknown]
Quote from: bostasp on August 18, 2003, 06:10:06 PM
LOL... this is getting silly :D
Bingo!!!! CORRECT!
-[Unknown]
yeah!!!
it's working!! :D I've done it!! 8)
I'll post it in Completed Mods in a few and will put a link here to the thread :)
but you can have a peek here ;)
http://llama.lewismedia.com/~anguz/forums/index.php?action=viewprofile;user=webmaster
here it is :D
Built-in Avatar Randomizer (http://www.yabbse.org/community/index.php?board=158;action=display;threadid=25478&start=0)
thanks for your help guys :)
oooh cool mod :D
thx!
my members are starting to love it! since it makes it very easy for them to have the avatar script without having a server or knowing code, etc :)
if you have any comments on it, please post them in the mod's thread... I'd love to have some feedback :D