chery

Can anyone help me - I'm desperate? [attachment deleted by admin]

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;

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

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

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

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>