 | Arcade Q |  |
 Posted: 08/27/2007 9:30 AM |
 |
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
 |
|
|
|
Joined: Jan 06, 2006
Local time: 10:47 PM
|
|
|
|
|
 |
Hello! Been away on hols 
I'm trying to add my arcade back and I'm not sure about a bit of code I need to add.
| Code:
|
-----------------------------------
----[ OPEN ]-----------------------
-----------------------------------
Root/templates/subSilver/index_body.tpl
-----------------------------------
----[ FIND ]-----------------------
-----------------------------------
[ {L_WHOSONLINE_MOD} ]
-----------------------------------
----[ AFTER, ADD ]----------------
-----------------------------------
[ {L_WHOSONLINE_GAMES} ]
|
I haven't got that bit of code in either of my template files (Diddle or subSilver) so where/how do I add it?
Thanks  |
|
|
|
|
| Back to Top |
|
|
| Re: Arcade Q | |
| Posted: 08/27/2007 10:46 AM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 10:47 PM
|
|
|
|
|
|
The games are working fine without that bit added so not sure I really need it anyway 
I have anohter Q though, my cash mod doesn't work with it even though I have selected it in the config  |
|
|
|
|
| Back to Top |
|
|
| Re: Arcade Q | |
| Posted: 08/27/2007 3:04 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 6:47 PM
Location: St Pete, FL
|
|
|
|
|
|
| Karen wrote:
|
|
my cash mod doesn't work with it even though I have selected it in the config
|
You didn't have the Cash MOD turned on in the Arcade Configuration. It should work now. This is what I had to do to turn it on:
|
|
|
|
|
| Back to Top |
|
|
| Re: Arcade Q | |
| Posted: 08/27/2007 3:12 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:47 PM
Location: St Pete, FL
|
|
|
|
|
|
| Karen wrote:
|
I'm trying to add my arcade back and I'm not sure about a bit of code I need to add.
| Code:
|
-----------------------------------
----[ OPEN ]-----------------------
-----------------------------------
Root/templates/subSilver/index_body.tpl
-----------------------------------
----[ FIND ]-----------------------
-----------------------------------
[ {L_WHOSONLINE_MOD} ]
-----------------------------------
----[ AFTER, ADD ]----------------
-----------------------------------
[ {L_WHOSONLINE_GAMES} ]
|
I haven't got that bit of code in either of my template files (Diddle or subSilver) so where/how do I add it?
Thanks
|
Yes, the Simple Colored Usergroups MOD replaced this part of the code. If you want to add this to your legend, you could probably do this:
| Code:
|
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/index_body.tpl
#
#-----[ FIND ]------------------------------------------
#
{GROUP_LEGEND}
#
#-----[ IN-LINE FIND ]------------------------------------------
#
{GROUP_LEGEND}
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
[ {L_WHOSONLINE_GAMES} ]
|
 |
|
|
|
|
| Back to Top |
|
|
| Re: Arcade Q | |
| Posted: 08/27/2007 3:20 PM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 10:47 PM
|
|
|
|
|
|
Great thanks NR will try that!
I thought I had turned it on doh!
Just found an error, I now have 2 pages of games and when I try to go to page 2 I get this error I'm not sure about.
| Code:
|
Couldn't obtain game data
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5
SELECT * FROM phpbb_ina_games ORDER BY
Line : 749
File : activity.php
|
|
|
|
|
|
| Back to Top |
|
|
| Re: Arcade Q | |
| Posted: 08/27/2007 3:29 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:47 PM
Location: St Pete, FL
|
|
|
|
|
|
Yes, that is a problem. The question is, ORDER BY what? The fieldname is missing after ORDER BY. Check the activity.php file near 749 to make sure the SQL query includes the fieldname after the ORDER BY part of the query...
|
|
|
|
|
| Back to Top |
|
|
| Re: Arcade Q | |
| Posted: 08/27/2007 3:44 PM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 10:47 PM
|
|
|
|
|
|
Here's what it says in the file..
| Code:
|
$extra_where = "AND cat_id = '". $cat ."'";
$new_orderby = "ORDER BY ". $admin_d;
}
else
{
$extra_where = "WHERE cat_id = '". $cat ."'";
$new_orderby = "ORDER BY ". $admin_d;
}
}
else
{
$extra_where = '';
$new_orderby = 'ORDER BY '. $order_by;
}
|
I can't see any field in my phpbb_ina_games table 
I didn't install this originally, can I fix it??  |
|
|
|
|
| Back to Top |
|
|
| Re: Arcade Q | |
| Posted: 08/27/2007 4:02 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:47 PM
Location: St Pete, FL
|
|
|
|
|
|
Ok, this is an obvious logic flaw in the code. There is a section that assigns the order_by part based on the page_order setting, which seems to be set to played for page 2. But there is no option for "played" in this section. There is an option for games_played though, which I suspect should be played instead...
I think this is what the MOD author had in mind though, so go ahead and add this and see if it helps:
OPEN
activity.php
FIND
| Code:
|
|
if ($page_order == 'game_id') $order_by = "game_id $sort_order LIMIT $start,". $finish;
|
AFTER, ADD
| Code:
|
|
if ($page_order == 'played') $order_by = "played $sort_order LIMIT $start,". $finish;
|
|
|
|
|
|
| Back to Top |
|
|
| Re: Arcade Q | |
| Posted: 08/27/2007 4:13 PM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 10:47 PM
|
|
|
|
|
|
Yay that worked!
Thanks |
|
|
|
|
| Back to Top |
|
|
| Re: Arcade Q | |
| Posted: 08/27/2007 4:19 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:47 PM
Location: St Pete, FL
|
|
|
|
|
|
It seems to be showing some of the same games from page 1 though. I still think there are logic errors in this code. It kind of looks like it originally is sorting based on the Cost of the game, so the second page should be doing the same. But instead, the order setting seems to be changing. Now it says that the order is set to proper_name, which wouldn't have been a problem before adding the new line of code...
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
