Even so, if you develop your own module and use this query, you don't need to follow the regular PhpFox's strategy, so you can directly store the query in a variable and send it to the data base.
Not exactly true. There are a number of cases where fox will trigger errors or reject statements. There really is no way to send any query directly to the database unless you circumvent the database interface.
A feature request is needed.
This example is contrived but exhibits one issue:
Phpfox::getLib('database')->query("UPDATE phpfox2_user SET full_name='fred' WHERE user_name='steward';UPDATE phpfox2_user SET user_name='fred' WHERE user_id=2");
SQL does this no problem. But Phpfox triggers an error.
There's another, long forgotten now... if I played with the IN() clause I could find it again. Basically fox has reduced all of us to the lowest common denominator of sql.
Which is fine.
But seriously don't kill yourself trying to use the phpfox database library unless you are doing exactly what fox has anticipated.
Compound queries or offbeat constructs require PDO.
Many hours lost here.
It is not the case that you can send arbitrary queries to the database.
Actually I want to disable the core profile feed and create a block that show feed belongs to an user (integrated with third party module). It is very difficult for me to do this. I will follow by your guide and try to do something.
You'll need to rename the module id throughout the product. A mass search and replace sometimes does the trick but it can be quite time consuming to fully test.
I have posted a photo into the pages feed with a hashtag as part of the post. It worked fine to display it. What are you posting to the page with a hashtag?
Sorry if I don't understand your question. If you go to admincp->users->manage user groups and click the arrow beside the group the bottom option allows you to set as many points as you want to each module.
Moved to proper forum section. In the Support menu you will find the developer api, the knowledgebase, and the app documentation. Each of these can be useful for what you want to do. A link to the table of contents is in my signature for the knowledgebase to make that easier to find things also.
Not if you want to rename the folder as you have to go in every file in it and rename the entire module. Best thing to do is the url rewrite and do the phrases as clubs.
If you're using phpMyAdmin, then the table will probably be listed on the SECOND page of table names. (far left of the db. window in the web gui., use the ">" to go to the next page of tables) YMMV.
