Announcement

Collapse
No announcement yet.

how to change an Avatar id?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to change an Avatar id?

    how to change the new Avatar id?

    let say
    Avatar Category: Generic Avatars (id: 6)
    how to change the id from 6 to 3

    Situation: I deleted the the Generic Avatars (id:3), and recreated another Generic Avatars, then it does not link to the "Edit Avatar" under users control panel in the forum, so users cannot pick any from the Generic Avatars. I would like to fix it.

    is there somewhere to change the id# in the templates?

    Thanks a lot

  • #2
    I recommend you update the old avatar records to the new categoryid instead. This query should do it (backup first):

    UPDATE avatar
    SET imagecategoryid = 6
    WHERE imagecategoryid = 3

    You run queries in your:

    Admin CP -> Maintenance -> Execute SQL Query

    You must have permission to execute queries in your includes/config.php file:

    Code:
    	//	****** USERS WITH QUERY RUNNING PERMISSIONS ******
    	//	The users specified here will be allowed to run queries from the control panel.
    	//	See the above entries for more information on the format.
    	//	Please note that the ability to run queries is quite powerful. You may wish
    	//	to remove all user IDs from this list for security reasons.
    $config['SpecialUsers']['canrunqueries'] = '';
    After running this query you might need to edit and save an avatar record in your Admin CP to update the cache.

    Comment


    • #3
      Thanks Jake =D

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X