Glad I could help :)

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.

Found it, had to add: return_url=true

Thanks for posting. :)

Thanks data66 very much for the helpful guide!

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.

TextCrawler is an excellent tool for doing this. I renamed one of the core modules on my site without any problems.

http://www.digitalvolcano.co.uk/textcrawler.html

As always it is best to back up your original files and SQL.

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.

Ok, I have found the answer to this as temp fix

Go into admincp >> settings >> manage setting >> core >> then edit line breaks to number 2 I think was set up at default as 0

This worked for the feed, and view more is showing now

Cheers and thanks for the support

Michael

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.

Submit bugs to the bug tracker. Editing source files voids your support.

ok thanks

So, we create a php file and place it in the Fox directory then use the http://www.phpfox.com/addons/view/cronjob-manager/ to run it ?

Note that the core hack will void support. We are cracking down on that too. We do not provide any support for core hacked sites.

Any server processing should be done within a service file. Create a file module/myevents/include/service/myevents.class.php with coding like:


Then you can process it when it gets to the ajax file like:



Again, this is just an example of a way to do this. Your circumstances might warrant a different approach.

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.