ok when I run the first query it says this error:

INSERT INTO jos_puarcade_leaderboarddetail( id, userid, username, points )
SELECT 1 , s2.userid, u.username, sum( 20 - (
SELECT COUNT( DISTINCT s.userid )
FROM jos_puarcade s
WHERE s.userid !=0
AND s.userid != s2.userid
AND s.gameid = s2.gameid
AND (
(
s.score > s2.score
AND g2.reverse_score =0
)
OR (
s.score < s2.score
AND g2.reverse_score =1
) ) )
) AS points
FROM jos_puarcade s2, jos_puarcade_games g2, jos_users u
WHERE s2.userid !=0
AND s2.gameid = g2.id
AND s2.userid = u.id
GROUP BY s2.userid, u.username
HAVING points >0
ORDER BY points DESC
LIMIT 0 , 10

MySQL a réponduocumentation
#1146 - Table 'retromundi.jos_puarcade_leaderboarddetail' doesn't exist

and same for second query...
maybe smthin missing in the first query?

I use mysql 5.051
php 5.2.5

what's next?

Ahh, now we are getting somewhere.

To install these last couple SVN's, did you just overwrite the files, or did you do an actual uninstall/re-install?

Those tables are created by the install routine, and were added fairly recently. If you are just overwriting files, they may not have been created.

Can you try doing an uninstall and then a re-install using the latest SVN, instead of just copying the files over?

adroussel wrote:

- Score messages should be displayed under the folderpics line


Fixed in SVN 357

ok CSS for score messages is just fine now.

I apologize for unconsciously having been lazy just uploading svn files.
The leaderboard works now.

It works, but it takes 45 seconds to show even caching!
Where is it supposed to cache? maybe a chmod issue?

As I allredy said I'm missing the leaderboard from 2.1.1 when I could instantly display a top50 users on my main page...
What do you think guys? Miro?


I think beeing able to show his rank to an average or beginner user is the best way to have it addicted wanting to progress.

I also think CB Itemid should be asked in settings to display links to cb profiles on the leaderboard.

adroussel wrote:

- guest restrictions don't work if set 'on' (view and play stuff)


Are you talking about the items you can configure in the settings area? These only apply if you are in flat mode.

If you are using folder mode, you set the permissions on each individual folder.

If you ARE setting the permissions on each individual folder, and it isn't working for you, please post about it. In my testing, it seems to work fine.

adroussel wrote:

- pages navigation don't work within folders


Can you give more information on this? It seems to work in the demo arcade and my test environments. You are talking about the pagination in the front end, right?

[quote]adroussel wrote:

- guest restrictions don't work if set 'on' (view and play stuff)


Report working folder restrictions in SVN 357 and joomla 1.5.6 legacy

Also a question, ¿how does the leaderborad exactly works? ¿can i create game contests? ¿how?

Thanks and best regards!

PS: What happened to the lang file?, I have translated to spanish but some strings are missing in the english file like:

• DEFINE("PUA_GAME_INSTRUCTIONS","Instrucciones del juego:";


• DEFINE("PUA_GAME_INSTRUCTIONS_POS_N", "Sin instrucciones";


• DEFINE("PUA_GAME_INSTRUCTIONS_POS_T", "Arriba";


• DEFINE("PUA_GAME_INSTRUCTIONS_POS_R", "A la derecha";


• DEFINE("PUA_GAME_INSTRUCTIONS_POS_B", "Abajo";


• DEFINE("PUA_GAME_INSTRUCTIONS_POS_L", "A la izquierda";

Please provide me any changes to be translated

I've updated to the latest svn again (Reinstall). Is it normal that i have to install the shoutbox and uddeplugin again ? The Files are in the plugin folder, but under plgins in backend the bots away, so they doesn't work anymore.

MarkusK wrote:
I've updated to the latest svn again (Reinstall). Is it normal that i have to install the shoutbox and uddeplugin again ? The Files are in the plugin folder, but under plgins in backend the bots away, so they doesn't work anymore.

yep same for me

btw anyone having succesfully been using the Pm notification without problem in submitting scores on some games?

f you ARE setting the permissions on each individual folder, and it isn't working for you, please post about it. In my testing, it seems to work fine.

yep right, my apologizes again, seems that when migrating the tables from my old 1.015 & 2.1.1, It missed these folder settings... or maybe just me ...

You are talking about the pagination in the front end, right?

Yes.
I'm not using 'Show Game Selections on Folder' but when I'm in a folder, for ex 'sports' I can not use the page navigation:

<< Start < Prev 1 2 Next > End >>

"2", "next" & "End" links all send me to :
www.domain.com/index.php?limitstart=100?limitstart=100

Instead of something like this:
index.php?option=com_puarcade&fid=4&limitstart=100

(I'm dispalying 100 games in a page caus I can not view next pages... ;/)

adroussel wrote:
You are talking about the pagination in the front end, right?

Yes.
I'm not using 'Show Game Selections on Folder' but when I'm in a folder, for ex 'sports' I can not use the page navigation:

<< Start < Prev 1 2 Next > End >>

"2", "next" & "End" links all send me to :
www.domain.com/index.php?limitstart=100?limitstart=100

Instead of something like this:
index.php?option=com_puarcade&fid=4&limitstart=100

(I'm dispalying 100 games in a page caus I can not view next pages... ;/)

Ahh, ok, I understand. Thanks.

Before i update the the 357 my PM notification worked.
I had the Shoutbox und uddeplugin installed.
And my Frontend pagination works, but i have a problem with pagination in backend.
I have the Gamefolder in Frontend, then click on view alle xx Games, there it works.

MarkusK wrote:
Before i update the the 357 my PM notification worked.
I had the Shoutbox und uddeplugin installed.
And my Frontend pagination works, but i have a problem with pagination in backend.
I have the Gamefolder in Frontend, then click on view alle xx Games, there it works.

you have to reinstall the plugins...
my PM notifications worked also but some games stopped scoring when i used that UddeIM plugin.

I tested, and in both folder displays, my frontend pagination is not usable as described in my post before... Even if as you just said, the "see all games in taht folder" works fine. I guess it's a joomla 1.5 related problem caus it doesn't have it in the demo on here.

Btw I noticed a display problem on the demo here
www.pragmaticutopia.com/component/option...it,15/limitstart,30/

I get this error on every puarcade pages:

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/retrom47/public_html/components/com_puarcade/cls.puarcade.php on line 1445

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/retrom47/public_html/components/com_puarcade/cls.puarcade.php on line 1445

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/retrom47/public_html/components/com_puarcade/cls.puarcade.php on line 1436

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/retrom47/public_html/components/com_puarcade/cls.puarcade.php on line 1436



when the joomfish 2beta abstraction layer plugin is published...
(sv357 & joomla 1.5.6)