We offer outstanding professional Joomla!TM extensions.

Professional Joomla! Extensions

Professional Joomla! Extensions

Forum Blogomunity Joomla Extensions p8pBB bridge AlphaUserPoints showing alpha points on phpbb3

Member Login



Community Builder

This module is for demo of CB integration.





Forgot login?
No account yet? Register

Latest Forum Activity

showing alpha points on phpbb3

AlphaUserPoints rules integration.
15 posts • Page 1 of 2 • 1, 2

showing alpha points on phpbb3

Postby stefanrenne » January 13th, 2010, 6:16 am

Hi i was working on a code to show alpha user points on phpbb3, but its not working yet, can someone help me out

in viewtopic_body.html (template folder / template)
Under
Code: Select all
<!-- IF postrow.POSTER_POSTS != '' --><dd><strong>{L_POSTS}:</strong> {postrow.POSTER_POSTS}</dd><!-- ENDIF -->

add
Code: Select all
<!-- IF postrow.POSTER_POSTS != '' --><dd><strong>{userpoints}:</strong> {userpoints}</dd><!-- ENDIF -->


in viewtopic.php (root phpbb3)
above
Code: Select all
// Send vars to template

add
Code: Select all
//NLkaiser alpha userpoint addon
$sqlpoint = SELECT jos_alpha.points FROM jos_alpha_userpoints, jos_users WHERE jos_alpha_userpoints.userid=jos_users.id AND jos_users.username='.$row['username'].';
$userpoints= $db->sql_query($sqlpoint);


under
Code: Select all
'FORUM_ID'       => $forum_id,

add
Code: Select all
'userpoints'   => $userpoints,


error:
Parse error: syntax error, unexpected T_STRING in /components/com_jmrphpbb/controller.php(73) : eval()'d code on line 582
Last edited by stefanrenne on January 14th, 2010, 5:38 am, edited 1 time in total.
User avatar
stefanrenne
Newbie
Newbie
 
Posts: 13
Joined: December 18th, 2009, 3:59 am
Name: Stefan Renne
Top

Re: showing alpha points on phpbb3

Postby Admin » January 13th, 2010, 2:14 pm

You have error in the code, change
Code: Select all
$sqlpoint = SELECT jos_alpha.points FROM jos_alpha_userpoints, jos_users WHERE jos_alpha_userpoints.userid=jos_users.id AND jos_users.username='.$row['username'].';
to
Code: Select all
$sqlpoint = 'SELECT jos_alpha_userpoints.points FROM jos_alpha_userpoints, jos_users WHERE jos_alpha_userpoints.userid=jos_users.id AND jos_users.username=\''.$db->sql_escape($row['username']).'\'';
Let he without sin throw the first stone.
User avatar
Admin
Site Admin
Site Admin
 
Posts: 903
Joined: October 21st, 2008, 5:39 pm
Location: index.php
Name: Administrator
Browser: Chrome
Top

Re: showing alpha points on phpbb3

Postby stefanrenne » January 13th, 2010, 3:33 pm

Unknown column 'jos_alpha.points' in 'field list'
in file /phpbb3/viewtopic.php


mm can I somewhere add that in field list?
User avatar
stefanrenne
Newbie
Newbie
 
Posts: 13
Joined: December 18th, 2009, 3:59 am
Name: Stefan Renne
Top

Re: showing alpha points on phpbb3

Postby Admin » January 14th, 2010, 1:42 am

Please check modified code.
Let he without sin throw the first stone.
User avatar
Admin
Site Admin
Site Admin
 
Posts: 903
Joined: October 21st, 2008, 5:39 pm
Location: index.php
Name: Administrator
Browser: Chrome
Top

Re: showing alpha points on phpbb3

Postby stefanrenne » January 14th, 2010, 4:50 am

yea I used that code from your post above, or did you change that code again?

edit: now I see my phpbb forum without a template (just only the text)
User avatar
stefanrenne
Newbie
Newbie
 
Posts: 13
Joined: December 18th, 2009, 3:59 am
Name: Stefan Renne
Top

Re: showing alpha points on phpbb3

Postby Admin » January 14th, 2010, 2:27 pm

The code was changed.
In fact we don't recommend to use this code, it had too much errors :)
Let he without sin throw the first stone.
User avatar
Admin
Site Admin
Site Admin
 
Posts: 903
Joined: October 21st, 2008, 5:39 pm
Location: index.php
Name: Administrator
Browser: Chrome
Top

Re: showing alpha points on phpbb3

Postby stefanrenne » January 14th, 2010, 3:54 pm

take a look at this :D
http://www.phpbb.com/community/viewtopi ... #p11747895

I get this error,

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /home/admin/domains/ps3hype.nl/public_html/dev/components/com_jmrphpbb/controller.php(73) : eval()'d code on line 1493


I understand that you don't recommend adding custom code but I stil would like to show my alpha userpoint on my forum so I decided to continue with adding a custom code
User avatar
stefanrenne
Newbie
Newbie
 
Posts: 13
Joined: December 18th, 2009, 3:59 am
Name: Stefan Renne
Top

Re: showing alpha points on phpbb3

Postby liveunict » February 24th, 2010, 10:12 am

For Admin, could you devolpe something to see points in phpbb3? Many thanks
User avatar
liveunict
Veteran
Veteran
 
Posts: 63
Joined: July 7th, 2009, 7:24 am
Name: vincenzo
Top

Re: showing alpha points on phpbb3

Postby Josi » March 14th, 2010, 3:09 am

Yes please, Admin. That would be great to show alpha user points and rang in phpBB3.
kind regards
Jo
Josi
Newbie
Newbie
 
Posts: 6
Joined: March 3rd, 2010, 7:22 pm
Name: Josi
Top

Re: showing alpha points on phpbb3

Postby Admin » March 14th, 2010, 2:19 pm

We will think about it.
Let he without sin throw the first stone.
User avatar
Admin
Site Admin
Site Admin
 
Posts: 903
Joined: October 21st, 2008, 5:39 pm
Location: index.php
Name: Administrator
Browser: Chrome
Top
Next
15 posts • Page 1 of 2 • 1, 2

Return to AlphaUserPoints

Who is online

Users browsing this forum: CommonCrawl [Bot] and 0 guests

Powered by phpBB® Forum Software © phpBB Group
About Us|Privacy Policy|Information|Contact Us
 
Copyright © 2008-2012 Blogomunity.com
Trademarks and tradenames used herein are the property of their respective holders.
The Joomla!® name is used under a limited license from Open Source Matters in the United States and other countries. Blogomunity is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.