[Forum] Visitors

[josiah]

Is it possible to clear the names in the visitors box in a members profile ?...........

[Hawk2]

DELETE FROM `profilevisitor` WHERE (`userid`='1')

just change the userid

[josiah]

Thanks but can you be more specific please..

[Hawk2]

Maintenance/Execute SQL Query put that query into Manual Query box and click continue

DELETE FROM `profilevisitor` WHERE (`userid`='1')
just change the userid to the user you want to edit

[josiah]

It would appear that I am not authorised to do that, any ideas ?

[Trevor Hannant]

Make sure that your userid is able to run queries by editing the following section of the config.php file:

 // ****** 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'] = 'x';

where 'x' is your userid.

[josiah]

The only reference I can find to php is "View PHP Info
" in admin cp and it is read only ?

[beishe8]

The only reference I can find to php is "View PHP Info
" in admin cp and it is read only ?

It is not in the admin cp,it is in your config.php file on the server.

Download it from the server.
Edit it as recommended by Trevor.
Upload it to the server.

[josiah]

I appreciate all the input but will have to get someone to do it for me, I have access to the server but not a clue,regards,P