Matt

[Nemesis]

I download your..  Don't Show MySQL Info in Admin Center

I installed it on my SE 1.1.0 board and it still shows the info for MySQL. Does this mod only work with 1.0.0?

[Nemesis]

LOL, Man not my night.

I tried installing your add smily mod for 1.1.0 now I can't even use my site. Here the error I get.

2: Supplied argument is not a valid MySQL result resource
(/home/gamerzalliance/community/Sources/Subs.php ln 686)

 

[Dave A]

Matt has noticed those errors!  And an advice is that all the mods are in Beta!    So download at your own risk!  

[Nemesis]

Code Select Expand

Well this is the error lines from subs.php
[code]
   if ($enableSmilies) {
    {
      $message = parsesmilies($message);
        $SQL_query = mysql_query("SELECT * FROM ".$db_prefix."smilies ORDER BY id");
        $i = 0;
        while($smilie = mysql_fetch_array($SQL_query)) {
           $message = str_replace($smilie[kode],"<img src=$imagesdir/$smilie[url]>",$message);
           $count++;
        }
      
( This is the specific line that causing the error from above )

while($smilie = mysql_fetch_array($SQL_query)) {


What you guys think?[/code]

[irbrian]

Seems to me it doesn't like the fields its being told to search. Is the smilie field correct in the database? Also I would personally use:

$SQL_query = mysql_query("SELECT * FROM {$db_prefix}smilies ORDER BY id");

instead of:

$SQL_query = mysql_query("SELECT * FROM ".$db_prefix."smilies ORDER BY id");

Just because that seems to be the most common syntax.. I'm not familiar with the .'s though and I still know very little about PHP so its very likely I have no idea what I'm talking about.

[Nemesis]

I would think it is right.

I just let SE installed all the datebase, never chaged it.

I'll try your chages too.

[Dave A]

That mod hasn't been working right!  

[Webby]

You mean the Smilies Mod ?!

It works for me !

I had to change 2 tiny things, but now it works great !

[Dave A]

 2 tiny things  

[Matt Siegman]

Actually, that is a new error
I would fix this stuff, but that would involve me getting off my laxy butt and fixing it, and I just found some cool new features I wanna put in Package Manager