We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Database Help. | Forum

Topic location: Forum home » Support » General Questions
Nathan Evans
Nathan Evans Jun 20 '15
I have been looking through the code, through the database, and through everything... I am trying to build a mobile application. Since oxwall has no workable API I was going to build one by exposing aspects of the database using webservices.


I could use some help with select statements to pull stuff like newsfeed. I noticed that you use a lot of joins.  


Optionally i would like to be able to post all data to another location, which i could also if I could find where oxwall gets data and places it into the database.


Any help would be appreciated... The only option i have at this points is starting from scratch and build my own social networking platform... I don't want to I like oxwall it's just to bad it has no api and it's mobile site is terribly inadequate. 


I could fix this is the database was normalized in such a way that it was readable, and the code was commented properly...   

Taissa Team
Taissa Jun 23 '15
Nathan,  to assist you better we need a more specific question. What exactly do you want to know?
Also have a look at this plugin http://www.oxwall.org/store/item/695 and this crash course
http://docs.oxwall.org/dev:crash-course it may be useful for you.
Nathan Evans
Nathan Evans Jun 27 '15
For starters I would like to begin with the news feed, I would like and example of how the data is pulled from the database. Since that[the database] is obfuscated [by what appears to be some sort of hibernate like intermediary library] it makes it difficult to figure out how to construct a select statement for the news feed...


A simple example of a select statement that returns news would be a good place to start since it contains pretty much every element needed to poll almost all data from each user. The rest of the statements for CRUD actions can be extrapolated from that I am assuming.

Basically I am attempting to take all of your modules, and build a second version(or modify existing) to return data from the database without HTML and UI elements as JSON.
This would allow for a simple to use API that could easily be integrated with ANY mobile technology... ONCE completed I have no problem giving it back to the community at NO COST... since Oxwall is fantastic... it just lacks any semblance of a usable API or mobile experience.. the mobile site is atrocious... worse actually.
Not to insult you, just constructive critique. In the interim whilest I work on the API I will build and app for android  and strip the CSS and rewrite it on the fly using webview.. using android  webview I should be able to make the site more user friendly for mobile users...
 once completed I will release the source for the mobile pp to every body interested, because I find the lack of mobile functionality  to be a  terrible waste of a really good social site software.



ross Team
ross Jul 9 '15
The data is from the database is pulled by using these methods:

protected function findActionList()

protected function findActionCount()

protected function findActivityList()


in ow_plugins/newsfeed/classes/feed_driver.php 

site_driver.php and user_driver.php files


As to the returning data as JSON, you need to format it on your own, as we do not provide assistance on code modifications and plugins development

Nathan Evans
Nathan Evans Dec 15 '15
OK, thats fine, i'll have a look...


Rick
Rick Aug 27
I rarely let new people into my life. I feel most comfortable communicating with people I've known for years. But if I have a friend or a good acquaintance I check him through https://radaris.com/reverse-address-lookupIt's the best criminal background check site, which I have used many times. It has district court and federal civil case files there - in all the areas where the person who meets your criteria has lived.
jsimitseo
jsimitseo Aug 28
Injet Energy’s integrated energy management systems are exactly what the future of sustainable energy looks like. 3 Phase Electric Car Charger