chery
-
Posts
34 -
Joined
-
Last visited
Never
Posts posted by chery
-
-
I've written a php page that extracts random info from the db (it works perfectly).
My next step is to display it on my index page - I'm using phpbb 2 which is tpl based and I'm not sure how to call the php file.
Any help would be much appreciated.
-
Changed
$sql = "SELECT * FROM phpbb_iNA;
To
$sql = "SELECT * FROM " . $table_prefix . "ina_data";
and it worked.
-
It began throwing these errors when I had to change the original code from
$build_array = array(); $sql = "SELECT * FROM " . iNA;
to
$build_array = array(); $sql = "SELECT * FROM phpbb_iNA;
-
$sql = "SELECT * FROM FROM phpbb_iNA";
Forgot the qoutes.
Warning: Invalid argument supplied for foreach() in /home/worldwid/public_html/admin/admin_arcade.php on line 45
Parse error: syntax error, unexpected '[', expecting ']' in /home/worldwid/public_html/admin/admin_arcade_log.php on line 37
-
nothing looks wrong with your code but try this
$build_array["{$value['config_name']}"] = $value['config_value'];Your suggestion gave this error:
Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/worldwid/public_html/admin/admin_arcade.php on line 47
-
You forgot the single quotes...
see below
$build_array[ ' $value['config_name'] ' ] = $value['config_value'];
Your suggestion gave this error:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/worldwid/public_html/admin/admin_arcade.php on line 47
-
Parse error: syntax error, unexpected '[', expecting ']' in /home/worldwid/public_html/admin/admin_arcade.php on line 47
Can anyone see the error and how to fix it?
// // Load DB // $build_array = array(); $sql = "SELECT * FROM FROM phpbb_iNA; $result = $db->sql_query($sql); $ina_info = $db->sql_fetchrowset($result); foreach ($ina_info as $key => $value) { $build_array[$value['config_name']] = $value['config_value']; } unset($ina_info); $arcade_config = $build_array; //line 47 is
$build_array[$value['config_name']] = $value['config_value']; -
Hi there,
I created a simple php file which extracts data from a field in one of my tables:
<?php $sql = "SELECT * FROM phpbb_ina_games ORDER BY game_desc ASC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { echo "<tr>"; echo "<td align=center bgcolor=#DAE4EC border=1><font size=2>".$row['game_desc']."</td>"; echo "</tr>"; } ?>I want to create an rss feed from this page or from the data at least - does anyone have any idea on how this could be accomplished?
Any help would be much appreciated as it has me stumped.
-
Does anyone know how to do this please?
-
SQL result
Host: localhost
Database: worldwid_worldwide
Generation Time: May 13, 2007 at 02:24 PM
Generated by: phpMyAdmin 2.9.0.2 / MySQL 4.1.21-standard
SQL query: SELECT * FROM `phpbb_ina_games` WHERE `game_name` LIKE CONVERT( _utf8 'ninjaturtles1' USING latin1 ) COLLATE latin1_swedish_ci LIMIT 0, 30 ;
Rows: 1
game_id 799
game_name ninjaturtles1
game_path games/ninjaturtles1/
game_desc Ninja Turtles
game_charge 1
game_reward 100
game_bonus 1000
game_use_gl 0
game_flash 1
game_show_score 1
win_width 800
win_height 400
highscore_limit 5
reverse_list 0
played 8
instructions
game_avail 1
allow_guest 0
image_path games/ninjaturtles1/ninjaturtles11.gif
cat_id 6
at_highscore_limit 5
at_game_bonus 1000
score_type 2
game_autosize 0
date_added 1170757468
rank_required 0
level_required 0
group_required 0
game_control 1
highscore_id 346
at_highscore_id 346
-
SQL result
Host: localhost
Database: worldwid_worldwide
Generation Time: May 13, 2007 at 02:24 PM
Generated by: phpMyAdmin 2.9.0.2 / MySQL 4.1.21-standard
SQL query: SELECT * FROM `phpbb_ina_at_scores` WHERE `game_name` LIKE CONVERT( _utf8 'ninjaturtles1' USING latin1 ) COLLATE latin1_swedish_ci LIMIT 0, 30 ;
Rows: 3
game_name ninjaturtles1 ninjaturtles1 ninjaturtles1
player NULL NULL NULL
player_id 346 295 2
player_name DerringDo DerringDo DerringDo
score 930.0000 770.0000 660.0000
date 1171454231 1170996621 1170818411
player_ip 124.120.182.153 laddis chery
time_taken 118 155 119
-
copy the phpbb_ina_at_scores/score for the game_name to phpbb_ina_games/game_reward for the same game_name and update if different.
-
Please tell me exactly what you need - I only want to run the cron once per day to cut doen on server queries.
PHP version 4.4.4
MySQL version 4.1.21-standard
Server: localhost Database: worldwid_worldwide
Table: phpbb_ina_games
Field Type Collation Attributes Null Default
game_reward int(11) UNSIGNED No 100
Table: phpbb_ina_at_scores
Field Type Collation Attributes Null Default
score double(14,4) No 0.0000
-
Thank you so much that would be FANTASTIC !!!
-
arcade and cronjob
I have absolutely no idea on how to do this but I need a cronjob for the arcade that will rewrite the Score per point reward based on the highest AT score.
i.e.
phpbb_ina_at_scores has the field: score
phpbb_ina_games has the field: game_reward
So if the phpbb_ina_at_scores/score is 100
I want the phpbb_ina_games/game_reward to be 100
and if the if the phpbb_ina_at_scores/score is 10050
I want the phpbb_ina_games/game_reward to be 10000
Does anyone have any idea on the php involved with this? I have over 4200 games and checking them manually is draining the joy out of life!
-
I've installed the phpbb referral plus mod which works well but i want to add the member's referral link to their profile page but I am usure how to get the link to show the member's user id.
http://www.wwd-games.com/profile.php?mode=register&refer_id=(user id)
Anyone have any ideas on how to implement this? I have tried contacting the mod creator on phpbb.com with no result.
-
phpBBHacks.com
-
I use the old IM portal but don't use the portal page itself - rather I use my forum's index page with the im blocks.
Take a look and see if this is what you have in mind at [url=http://worldwide-dating.info]WWD Games
[/url] -
What cms are you using?
-
I need an improved code for checking framebreakers.
This is what I use at present but it doesn't seem to catch everything unfortunately.
[code]<?php
if ($QUERY_STRING == "topframe") {
echo("<html><head><title>$title</title></head><body bgcolor=#d3d3d3><div align=center>If you see this text and your site - <i>and didn't get any pop ups or message boxes</i> - your site will probably be approved...</div></body></html>");
} else {
echo("<html><head><title>$title</title></head><frameset rows=20,* border=0><frame marginheight=0 marginwidth=0 scrolling=no noresize border=0 src=/urltest.php?topframe><frame marginheight=0 marginwidth=0 scrolling=auto noresize border=0 src=\"$url\"></frameset></html>");
}
?>[/code] -
I wrote a small random image/link script to retrieve game pics and links from db (it works) as a php page. I want to insert the data into a .tpl page but how do I do this please?
I'd prefer not to use an iframe if possible.
-
BEAUTIFUL - thank you so much !!!
-
This is the entire page:
[attachment deleted by admin] -
[quote author=ataria link=topic=117103.msg477523#msg477523 date=1165066972]
Unfortunately that creates an empty page showing none of the products - any ideas on what I am doing wrong.
You need ot make it show something :P
[code]
<?
$rs=mysql_query("SELECT * FROM Products ORDER BY ProductID");
echo "<table><tr><td></td></tr>"; // header or whatever.
while($row=mysql_fetch_array($rs)){
echo "<tr><td>$row['field'];</td></tr>";
}
?>
[/code]
[/quote]
That's what I was asking about: <table width="75%" border="1" align="center">
<?
while($rsProducts=mysql_fetch_array($rs))
{
WriteProductRow($rsProducts[1]);
}
?>
</table>
phpbb2 sudden error
in Third Party Scripts
Posted
Can anyone help me - I'm desperate?
[attachment deleted by admin]