Jamroom Logo Jamroom 5 Core
is now Open Source!
User Support Forum Archive (Read Only)
Jamroom Developers:
Database
infinityssm



Joined: 01 Apr 2006
Posts: 149

Posted: 08/19/10 11:32 
I created new tables in my jamroom database. How do I have the ranking system pull data from the new tables I created?

Thanks

Back to top
smith.kyle
CodeSmith


Joined: 27 Apr 2006
Posts: 22009
Location: Southern California

Posted: 08/19/10 11:34 
You will need to create a new ranking system plugin - make sure to check out the module developer documentation:

http://www.jamroom.net/Module_Developer_Guide

Kyle


_________________
kyle[at]jamroom.net

Yes...that's a soda machine...

I get bored when no one's posting...
Back to top
infinityssm



Joined: 01 Apr 2006
Posts: 149

Posted: 08/19/10 11:41 
Thank You

Back to top
infinityssm



Joined: 01 Apr 2006
Posts: 149

Posted: 08/19/10 15:04 
I am so confused. I tried to follow the instructions for setting up a new ranking plugin system and I am getting a blank page when I process the reaquest for information on the database.

I created a page called artistclipboard.php by copying the file created for the youtube videos. I changed all of the information that pertains to my database and used the following to call the information nedded.

<form method="post" action="{$JAMROOM_URL}/ranking.php?mode=search">
<input type="hidden" name="header_template" value="search_header.tpl">
<input type="hidden" name="row_template" value="jr_ranking_row.tpl">
<input type="hidden" name="footer_template" value="search_footer.tpl">
<input type="hidden" name="pagebreak" value="{$smarty.config.pagebreak}">
<input type="hidden" name="highlight" value="{$smarty.config.search_highlight}">
<input type="hidden" name="search_color" value="{$smarty.config.search_color}">

{jr_lang id="83" default="search area"}:<br>
{jr_html_select name="genre" options="example.cfg" selected=""}<br>

<input type="submit" value="{jr_lang id="9" default="search"}" class="jform button">
</form></div>


this is calling a text file with a list of genres that i want as search criteria. It is suppose to return a list of artists that belong to the genre searched. It worked originally by only returning the artists genre in the original jamroom database, but not include the data in the new tables I created.

Now I am getting no results, after creating the artistclipboard.php which is placed in

module/digital_clipboard/ranking/artistclipboard.php

Directoy.

I just want to have my artist simply search by genre and get the results from my new database table.


Please Help!

Back to top
Brian
Jamroom Team


Joined: 09 Jul 2003
Posts: 37583
Location: Seattle, WA

Posted: 08/19/10 15:48 
A blank page means a PHP syntax error - make sure your plugin is valid PHP, and check the PHP Error Log for your Jamroom when logged in as the master admin.

Hope this helps!

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation
Back to top
infinityssm



Joined: 01 Apr 2006
Posts: 149

Posted: 08/19/10 22:57 
I checked and fixed the php errors, but now its providing me with results from the original jamroom database, but does not include any of the data in the new database tables I created.

I am not getting any new php errors. How do I find why the data is not showing?

Thanks

Back to top
jamesd116



Joined: 05 Jun 2006
Posts: 1559
Location: Rochester Pa

Posted: 08/20/10 05:26 
First did you check the db and see tht it was there.

infinityssm:
I checked and fixed the php errors, but now its providing me with results from the original jamroom database, but does not include any of the data in the new database tables I created.

I am not getting any new php errors. How do I find why the data is not showing?

Thanks



_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...
Back to top
infinityssm



Joined: 01 Apr 2006
Posts: 149

Posted: 08/20/10 08:36 
Yes the db is fine. I am pulling data logged in as an admin, but as an artist the data is not being pulled from the new tables.

Back to top
Brian
Jamroom Team


Joined: 09 Jul 2003
Posts: 37583
Location: Seattle, WA

Posted: 08/21/10 15:38 

infinityssm:
Yes the db is fine. I am pulling data logged in as an admin, but as an artist the data is not being pulled from the new tables.


What does your ranking plugin look like? Have you defined the proper search areas?

Hope this helps!

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation
Back to top
Display posts from previous:   
User Support Forum Archive (Read Only)
Jamroom Developers

 
Solutions
• Social Media Platform
• Social Networking Software
• Musician Website Manager
• Community Builder
Products
• Jamroom Core
• Jamroom Addons
• Jamroom Modules
• Jamroom Marketplace
Support
• Support Forum
• Documentation
• Support Center
• Contact Support
Community
• Community Forum
• Member Sites
• Developers
Company
• About Us
• Contact Us
• Privacy Policy
©2003 - 2010 Talldude Networks, LLC.