Phillyman

+Clients
  • Content count

    661
  • Joined

  • Last visited


2 Followers



About Phillyman

  • Rank
    Spam Happy

Phillyman's Activity

  1. Phillyman added a post in a topic: IP Content Database Statistics Block?   

    I want to display a few statistics about my IP Content databases on my homepage (within a custom block). How would I go about running a few SQL queries to return back the number of results in a bulleted form?
     
    * Total Records in Database 1 (12,045)
    * Total Records in Database 2 (25,031)
    * Number of Records meeting X criteria (3682)
    * Number of Records meeting X criteria (2567)
     
  2. Phillyman added a post in a topic: Contributors Database Block   

    Fantastic! Just what I was looking for. I was willing to settle for just their usernames, but the avatars is a much nicer touch. I tried pasting that code into a custom block (PHP) and when I parsed it in the template my entire site went down. I then just pasted it directly into the template and it worked. I added the following to put it in its own container.....
     
    <div class='maintitle'>Contributors</div> <div class='ipsBox'> <div class='ipsBox_container ipsPad'> {parse template="userSmallPhoto" group="global" params="$data['record']"} <foreach loop="$data['record']['contributers'] as $field"> {parse template="userSmallPhoto" group="global" params="$field[member]"} </foreach> <br class="clear"/> </div></div> <br class="clear"/> Which you can view in action here....
    http://www.retromags.com/games/category/super-nintendo/super-castlevania-iv-r1879#.VJNnTv8M8A
    One last question, is there a way to show either their name or their member card when you hover over the avatar?
     
  3. Phillyman added a post in a topic: Contributors Database Block   

    I have an IP Content database that is set up to allow my members to contribute to it wiki style. I was wondering if anyone could help me out with a custom block. All I want is a side block that shows my members names if they have made a contribution to the database record. Nothing too fancy, just something similar to the Online Users, where it shows their name and you can hover over it for the member card....it would just pull their names from the revision list, rather than the online list.
  4. Phillyman added a post in a topic: Google Analytics - Monitor IP Content Edits?   

    I am sort of interested in how many of my members are clicking the "Edit Record" button in my IP Content databases. Each of these urls follows a similar structure....
    http://www.mysite.com/database/category/record-1?do=edit So I guess what I am asking is, can I monitor for the number of times a webpage is visited that contains ?do=edit. This would let me know how many people are viewing the edit pages of my records....versus how many edits are being made each month.
     
     
  5. Phillyman added a post in a topic: Extract IP Content Database Fields to CSV (Daily)   

    How hard would it be to run a nightly CRON job that went into one of my IP Content databases and dumped four fields to a CSV file, based on a fifth field being populated?

  6. Phillyman added a post in a topic: Pull IP Content Record Contributors   

    Is there an way to create an IP Content block that would just list out members that have made contributions to that particular record? Sort of like a collapsed version of the Revisions page.
  7. Phillyman added a post in a topic: Updating a custom IP.Content database via a scheduled task   

    I am interested in this. Were you able to use the IPB task scheduler to run SQL queries against a IP Content custom database? If so I am looking to do the same. I have about 8 queries that need to be run nightly on various IP Content databases I have. Most of them look to see if a certain field has been populated, and if so.....it will change the status of another field within the same database. Right now I have to manually run them each week, but it would be great if they could be nightly tasks within IPB.

    example of queries I need to run nightly....
    UPDATE `ccs_custom_database_5` SET `record_static_furl`=`record_dynamic_furl` WHERE `field_26`='usa' AND `record_static_furl`=''; UPDATE `ccs_custom_database_5` SET `field_77`='p' WHERE `field_26`='usa' AND `field_76` <> '';
  8. Phillyman added a post in a topic: iCredits   


    +1 for IP Content points for activity. I have 20,000 records that I want my users to contribute to :)
  9. Phillyman added a post in a topic: iCredits   


    Is that what the Forum Activity setting was for? Would it be possible in the future to have greater control over IP Gallery points awarded. I want to reward users for uploading images to specific categories, but not for uploading images to their personal album's. Sort of like how we can give points on a per forum section, would be nice for the Gallery.
  10. Phillyman added a post in a topic: iCredits   

    Also would it be possible to award points for logging in each day, controllable by a max rate per day/hour. Maybe something like, 10 points per visit, time between visits 6 hours. This would prevent users from visiting and signing out and back in to get the points.
  11. Phillyman added a post in a topic: iCredits   

    Can we give points for members making edits to IP Content Databases? Or even better, assign points per field in IP Content Databases!
  12. Phillyman added a post in a topic: SEO: Why is my WordPress site out ranking my Invision Site?   

    I have an IPBoard in which I talk about video game magazines, the site has been around for 9+ years. I created another magazine site based off of WordPress (before I starting using IP Content). So how in the world is my WordPress site, out performing my IP Content site? Take the following for example.....


    Google: "Nintendo Power Issue 72"

    The number 1 result I get is my Wordpress site at the following page.....

    http://www.gamingmagz.com/video-game-magazines/nintendo-power-issue-72-may-1995.html

    Feel free to change the issue number, GamingMagz pops up in the top 10 results almost every time! However my Invision site is NO WHERE to be found.

    IP Content Page
    http://www.retromags.com/magazines/category/usa/nintendo-power/nintendo-power-issue-72

    Gallery Page
    http://community.retromags.com/gallery/image/45-nintendo-power-issue-072/

    Now just for comparison, the Invision site is an older domain, with more links back from other sites, updated more often (havent touched the WordPress site in 2 years). I am just baffled at this point, because a free CMS, with a free Google Sitemap Plugin and only 299 pages of content......should not be beating out a site with 4000 posts, 12,000 IP content pages and much more activity. Is it because the Invision site is much more bloated with 3800+ lines of code, where as the WordPress site is at 780+ lines?

    Any insight is appreciated.
  13. Phillyman added a post in a topic: What colors are available for IPS Badges?   



    What I ended up doing was I found out I could do the following......
    <span class="ipsBadge" style="background:blue;">{$record['field_77_value']}</span> Looks like that method I can use colors like black, yellow, blue, etc...
  14. Phillyman added a post in a topic: What colors are available for IPS Badges?   

    I wrote this small piece of code to color code one of my IP Content database fields. What colors are available? Because blue and black do not seem to work.
    <if test="$record['field_77'] == 'm'"> <span class="ipsBadge ipsBadge_grey">{$record['field_77_value']}</span> </if> <if test="$record['field_77'] == 'a'"> <span class="ipsBadge ipsBadge_blue">{$record['field_77_value']}</span> </if> <if test="$record['field_77'] == 's'"> <span class="ipsBadge ipsBadge_orange">{$record['field_77_value']}</span> </if> <if test="$record['field_77'] == 'e'"> <span class="ipsBadge ipsBadge_purple">{$record['field_77_value']}</span> </if> <if test="$record['field_77'] == 'p'"> <span class="ipsBadge ipsBadge_green">{$record['field_77_value']}</span> </if> <if test="$record['field_77'] == 'x'"> <span class="ipsBadge ipsBadge_red">{$record['field_77_value']}</span> </if>
  15. Phillyman added a post in a topic: My 4.0 IP.Content Wishlist   

    I am still hoping for database records within records. Easiest example I can give is a Music CD. The database record for a Music CD will have things like....

    Name of CD
    Band
    Year Released
    Number of Tracks

    But then it would be nice to build a track database from within that record, listing.....

    Song Name
    Duration
    Rating
    Written by