[Split] Smilies Categories

[taylor]

got it! thanks. still working on the other issue. I changed it to:
$cat_id = request_var('cat_id', 8);
and found nothing happening. but i'll keep trying....

[vividacoyote]

Hi I have a problem : when I want to edit a smiley I have an error:

SQL ERROR [ mysql4 ]

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT smiley_url FROM chindus3_smilies WHERE smiley_id = 898)' [1064]

SQL

SELECT smiley_id FROM chindus3_smilies WHERE smiley_id <> 898 AND smiley_url = (SELECT smiley_url FROM chindus3_smilies WHERE smiley_id = 898)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/mods/smilies_categories.php
LINE: 123
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_icons.php
LINE: 460
CALL: update_smiley_categories()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_icons->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

What's the problem, and how could I fix it?

Have a good day

[EXreaction]

What version of MySQL are you using?

[vividacoyote]

Hi

I have the MySQL 4.0.18 version's (I can't upload to MySQL 5 because it's on a public server)
Thanks for your attention.

[EXreaction]

Open the includes/smilies_categories.php file

find:

Code: Select all

      $sql = 'SELECT smiley_id FROM ' . SMILIES_TABLE . '
         WHERE smiley_id <> ' . $smiley_id . '
         AND smiley_url = (SELECT smiley_url FROM ' . SMILIES_TABLE . ' WHERE smiley_id = ' . $smiley_id . ')';

replace with:

Code: Select all

      $sql = 'SELECT smiley_url FROM ' . SMILIES_TABLE . ' WHERE smiley_id = ' . $smiley_id;
      $db->sql_query($sql);
      $smiley_url = $db->sql_fetchfield('smiley_url');
      $db->sql_freeresult();

      $sql = 'SELECT smiley_id FROM ' . SMILIES_TABLE . '
         WHERE smiley_id <> ' . $smiley_id . '
         AND smiley_url = ' . $smiley_url;

I'd recommend you get the MySQL server updated ASAP, it is severely outdated and almost certainly has huge security vulnerabilities.

[vividacoyote]

Hi,

that modification doesn't work, I have a new error :

SQL ERROR [ mysql4 ]

Unknown table 'boxe' in where clause [1109]

SQL

SELECT smiley_id FROM chindus3_smilies WHERE smiley_id <> 898 AND smiley_url = boxe.gif

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/mods/smilies_categories.php
LINE: 128
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_icons.php
LINE: 460
CALL: update_smiley_categories()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_icons->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

I can't update the MySQL version, I have no choice for that

[EXreaction]

Oh, yes, try this:

Code: Select all

      $sql = 'SELECT smiley_url FROM ' . SMILIES_TABLE . ' WHERE smiley_id = ' . $smiley_id;
      $db->sql_query($sql);
      $smiley_url = $db->sql_fetchfield('smiley_url');
      $db->sql_freeresult();

      $sql = 'SELECT smiley_id FROM ' . SMILIES_TABLE . '
         WHERE smiley_id <> ' . $smiley_id . '
         AND smiley_url = \'' . $smiley_url . '\'';

If the MySQL server can not be updated you should look for a new host, if they refuse to update something that old they are not worth any price.

[vividacoyote]

Hi!

Thanks, it works!

For the server, I made a school forum on a school server, so I can't change it and I have nothing to say... That's the life...

Have a good day.

[smart007]

Changed from femu not work, does not add smilies in this category in the 3.0.6 version.

[Wuerzi]

In my 2 boards works perfect

With add new smilies, add in categories, move to other categorie and more