PHP - Query Categories And Games

Is there anyway to have users play flash games on my forum and if they win/etc, send them Forum Gold? Wouldn't it be easy to hack it though by just changing the data being sent from the flash app with tamper data? I want to put a poker flash game on my site, and if users play poker/etc and if they win, I want to run a mysql query to update there account with more "Forum gold" If you will, and I want the poker flash game to have correspond and work with the amount of Forum Gold that they have?   Would this have to be custom coded by me If I learn actionscript? OR is there anything out like this that I can use?

Hey guys,
I have been programming for a while and I want to know what sort of design patterns I should look into when making a game?
For example what design pattern is best for:
Database management
User management
Forum management
Etc
I can only think of singleton or factory (for user/forum)
I am reasonably new to OOP, but would like to learn it properly, so I thought creating a simple program such as rock-paper-siccors would work to be able to expand it eventually, and hopefully it will teach me reusable code practice.

Hi,

I own a website called www.gpstudios.com,  a flash games site.
I didn't design it myself, but since having it built a year ago, I understand pretty much all of the inne workings. I'm a game coder so php makes good sense to me.

Anyway, i woudl like to change the way a game info (instructions, description) is fetched.
Currently, we have 650 games in our database. The way all the info is gotten is through mySQL.
So, what I would like to do is take these lengthy instructions/description strings and put them each into a text file, within the folder destination of the game.

Currently though, we don't even have a folder destination for each game, which is also a problem. Some games have extra files, which our site-developers didn't account for. There are several games that we've had to manually put into folders because of this problem (two .xml files cannot be named the same in the same folder)

Also, if you go onto my website and click on a game, you get sent to playgame.php?id=xxx
The main thing I would like to change though (which I have attempted before, but not succeeded with) would be to change the url adress of the games to something more like: www.gpstudios.com/games/game_name/
This is how most game websites do it.

When I tried to do this myself, what I did was to simply create an index.php within the folder of one of the aforementioned games, and within this folder I wrote something as simple as:

include("../../../playgame.php?id=xxx");

But upon loading this page, I would receive a load of error messages regarding all the other includes and requires in the playgame.php.
So by inserting playgame.php?id=xxx in this deep folder, it destroys all other directory links elsewhere.
I investigated and found that inserting set_include_path($_SERVER['DOCUMENT_ROOT']) would fix the problem with all these links, but it didnt - while the page loads, it appears to ignore anything that isn't in the root directory, including images.
I tried the include method with loads of different files, and they just wouldn't load correctly if they used anything outside the root directory.

And my final wish would be to do all of this automatically.
To simply write a php file that I would run once and it would generate all the directories for me.
It would need to copy every single description and instructions from mySQL and put them within text files within directories which are named after the game.
I would then need to automatically create a load of index.phps for each individual game with some simple code similar to: include("../../../playgame.php?id=xxx");
Obviously it would be silly to create a load of unique index files with a hard copy of playgame.php, incase I want to give my site a makeover at some stage.


I'm asking alot aren't I?
Well I know that if I was given the code from another games website, I would understand it and it would be easy to implement, but unfortunately, despite searching, downloading and installing over 10 Flash Game arcade scripts, none of them used this method... despite their demo page showing that they do.


Mainly, all I need to know is how to is how to generate a php/text file, and then I need to know what method I would use for getting the playgame.php running correctly from  within a different folder.
I'm pretty sure I could do the rest on my own then.

Thanks!

Basically I am setting up my own cricket management game, but there are 3 areas that I am slightly stuck on and would appreciate help:

1) When a use registers, I need to create 11 players for their team. For this, I am going to have one text files with first names and one text file with surnames. How can I open each file and select a name and then match them together?

2) I need to create the list of games to be executed at particular times through a cron job. How can I go through all the teams in a table and match them together in games, ensuring everyone plays everyone? If a new player registers, he will be put into a random league and so the games for that league will have to be redone

3) How can I set up a cron job to execute the above games? Each team should play once a day and so if there are 24 teams in a table, there will be 12 games that occur through this cron job. I assume cron jobs are the best thing for this.

Any help would be appreciated.
Thanks.

Hi Guys.

 

Doing an assignment for uni, and stuck on an error. Ill attach some files to show the problem and any help very much appreciated.

 

Error and the screen it comes on

 

Code

<?php
    function dispcategories() {
        include ('dbconn.php');

        $select = mysqli_query($con, "SELECT * FROM categories");

        while ($row = mysqli_fetch_assoc($select)) {
            echo "<table class='category table'>";
            echo "<tr><td class='main-category' colspan='2'>".$row['category_title']."</td></tr>";
            dispsubcategories($row['cat_id']);
            echo "</table>";
        }

    }

    function dispsubcategories($parent_id) {
        include ('dbconn.php');
        $select = mysqli_query($con, "SELECT cat_id, subcat_id, subcategory_title, subcategory_desc FROM categories, subcategories WHERE ($parent_id = categories.cat_id) AND ($parent_id = subcategories.parent_id");
            echo "<tr><th width='90%'>Categories</th><th width='10%'>Topics</th></tr>";
            while ($row = mysqli_fetch_assoc($select)) {
                echo "<tr><td class='category_title'><a href='/Games Forum/topics.php?cid=".$row['cat_id']."scid=".$row['subcat_id']."'>".$row['subcategory_title']."<br />";
                echo $row['subcategory_desc']."</a><td>";
                echo "<td class='num-topics'>".getnumtopics($parent_id, $row['subcat_id'])."</td></tr>";

            }
    }

    function getnumtopics($cat_id, $subcat_id) {
        include ('dbconn.php');
        $select = mysqli_query($con, "SELECT category_id, subcategory_id FROM topics WHERE ".$cat_id." = category_id AND ".$subcat_id." = subcategory_id");
        return mysqli_num_rows($select);
    }
?>

 

 

and the structure of the database

 

 

 

 

 

 

 

Edited March 28, 2020 by Ben555

I have two tables, one called Categories and one called SubCategories. Each subcategory needs to be displayed under its parent category in a HTML table.

So I have this code, but I don't know how to list each Sub-Category under each Category in a HTML table.

<?php

require ('includes/initialize.php');

require 'classes/database.class.php';


$sql = "SELECT * FROM Categories, SubCategories WHERE Categories.ID = SubCategories.CatID";

$Result = $database->Query($sql);
 
$Data = $database->Fetch($Result);

?>

Hi guys

I need help writing a php script

I have a table 'categories'

with fields
'id' 'cat_name' 'parent_id'

the 'parent_id' is just an the id field..

I want to create a way to have unlimited sub categories

so I can have

categorie -> sub-categories
categories  -> sub-categories  -> sub-categories
categories -> products

How can i make unlimited sub categories when i have this mysql fields: id, name, parent


Code: [Select]
$query = "SELECT * FROM cats";
$result = mysql_query($query);
while ($var = mysql_fetch_array($result)) {
  echo $var['name'];
  // now i need here some code for sub cats, but sub cat in subcat :(
}
Can someone help me?

Hello dear friends,

If i've the following ( categories - gifts )

<?PHP
$sql ="select *  from  categories";
$result= mysql_query($sql);
while($line= mysql_fetch_array($result)){
$qryrow="select * from gifts where gifts='$line[1]'";
}
?>

it means select category and its gifts

now my question how to view it all in table for example if i add

Code: [Select]
<TABLE cellSpacing=1 cellPadding=1 width="100%">
<TBODY>
<TR>
<TD>
<?php echo "". $line[1].""; ?>
</TD>
</TR>
</TBODY>
</TABLE>
it will show me like this
 

How can i make it like this



my problem how to make table like this and where to put the php variable  .. 

thanks

Hi there, I have a piece of code that takes all posts with the category of 'model' and puts it on the models page. It then displays the post as a gallery using fancy box. The problem is I want all posts with the category of 'faces' to go on the faces page, but at the moment they are appearing on both pages. Here is the code I have. Any help will guarantee a donation as I am at my wits end trying to figure this out.

Code: [Select]
<?php
  global $post;

  $args = array(
    'numberposts'     => 8,
    'offset'          => 0,
    'category'        => 'models',
    'orderby'         => 'post_date',
    'order'           => 'DESC',
    'post_type'       => 'post',
    'post_status'     => 'publish' );

  $posts_array = get_posts( $args );
  $x = 1; // track model
  foreach( $posts_array as $post ) {
    setup_postdata($post); ?>
    <div id="model-thumb">
<?php
    $arg2 = array( 'post_type' => 'attachment', 'numberposts' => -1, 'order' => 'ASC', 'post_status' => null, 'post_parent' => $post->ID );
    $attachments = get_posts($arg2);
    if ($attachments) {
        $i = 1; // track images
        foreach ( $attachments as $attachment ) {
            $image_attributes = wp_get_attachment_image_src( $attachment->ID, 'full' );
            if ($i == 1) { // Get thumbnail info to display with second image
                $img1src = $image_attributes[0];
                $img1w = $image_attributes[1];
                $img1h = $image_attributes[2];
            } elseif ($i == 2) { // Display thumbnail with link to second image
?>
           <a class="allModels" rel="gallery<?php echo $x; ?>" href="<?php echo $image_attributes[0]; ?>" 
?><img src="<?php echo $img1src; ?>" width="<?php echo $img1w; ?>" height="<?php echo $img1h; ?>"/></a><br /><p><?php the_content();?></p></div>

<?php
            } else { // Other images
?>
                <div style="display:none;"><a class="allModels" rel="gallery<?php echo $x; ?>" href="<?php echo $image_attributes[0]; ?>"><img src="<?php echo $image_attributes[0]; ?>" width="<?php echo $image_attributes[1]; ?>" height="<?php echo $image_attributes[2]; ?>"/></a></div>

<?php
            }
            $i++; // Increase image count
        }
    }

    $x++; // Increase model count
  }

?>

I have made a custom post type for products, and am using a custom taxonomy for the product categories. The thing that I am wondering about is that sometimes a product category is a parent, and sometimes a child, but sometimes both. For instance, if you have a top level category named shoes, then you might have a sub category named Nike. However, Nike also has shirts, so you could say that shoes and shirts were both subcategories of Nike. Do you know what I'm saying? It's like there is no real parent to child relationship, but they are both parents and both children of each other. How do you handle this type of situation?

Hey all,

I have a relationship where a zone has many posts and a category has many zones but a zone can also have many categories. The zones are basically parts of a page, such as the main area and sidepanel stored in database as records with name fields such as 'panel' and 'main'. There's a serious flaw right now and I would like to know the best solution to address it. Right now I access the posts of a zone of a category like this:

Code: [Select]
$category->zone->get()->post->get();

The above ends up displaying all the posts in the database for any given category because when category is selected, it searches for the associating zones, and then selects all posts related to those zones, which is wrong. i want to select all posts of the zones associated with that particular category.

Current database:

Code: [Select]
posts
id zone_id

zones
id name

categories_zones
id zone_id category_id

categories
id

What should I do? Add a category_id column to the posts table and relate the post directly to the category as well as directly to the zones table so the post table would have two foreign keys: category_id and zone_id

Would this be the most effective thing to do given my requirements?

Thanks for response.

Hi,

So i'm having a little trouble trying to simplify some code I already have.

Code: [Select]
$result = mysql_query("SELECT images, cat_id FROM image_cat");

while ($row=mysql_fetch_array($result))
{
$cat_id=$row['cat_id'];
echo $cat_id;
$imgresult = mysql_query("SELECT * FROM images WHERE cat_id='".$cat_id."'");
while ($col=mysql_fetch_array($imgresult))
{
echo $col['img_id'];
}
}

Okay, so this works, however i'm sure I can bring it together under one query, though i'm truly stumped as to how?
I thought I could do a simple join:

Code: [Select]
$result = mysql_query("SELECT image_cat.cat_id, images.img_id WHERE image_cat.cat_id=images.image_cat");

This works, but repeats the image category on each loop. I could remove this via php if statements, but there must be a simpler/mysql solution.

If it doesn't make any sense I need to get

Img cat 1
-img 1
-img 2

img cat 2
-img 3
-img 4

etc etc

That join will give

img cat 1
-img 1
img cat 1
-img 2
img cat 2
-img 3

Hope that makes sense?? And any help would be amazing!
Thanks.

Hi,

I have been working on an eCommerce platform for the last few months. Its almost complete but I need to do one thing and thats to only display sub categories if products exist in them.

This is the site craftgo.me (development site),

and this is how the categories are produced for a category page. ie. http://www.craftgo.me/category.php?cat_id=96

Code: [Select]
if($_GET['cat_id']) {
$parents_id = $_GET['cat_id'];
$cat_num_rows_sql = "SELECT category_id, parent_id FROM mccategories WHERE parent_id = '$parents_id'";
$cat_num_rows_result = mysql_query($cat_num_rows_sql);
$cat_row_count = mysql_num_rows($cat_num_rows_result);

if($cat_row_count == '0'){
$current_cat_parent_sql = "SELECT parent_id FROM mccategories WHERE category_id = '$cat_id'";
$current_cat_parent_result = mysql_query($current_cat_parent_sql);
$cat_parent_row = mysql_fetch_array($current_cat_parent_result);
$parent_id = $cat_parent_row['parent_id'];
} else {
$parent_id = $_GET['cat_id'];
}
}



$catsql = "SELECT category_id, category_name FROM mccategories WHERE cat_showing = '0' AND parent_id = '$parent_id' ORDER BY category_name";
$catresult = mysql_query($catsql);
while($catrow = mysql_fetch_array($catresult)) {

$category_id = $catrow['category_id'];
$cat_name = $catrow['category_name'];

echo '<li><a href="category.php?cat_id=' . $category_id . '">' . $cat_name . '</a></li>';
}

In the mcproducts table the category id for each product is under 'product_category'


Im not even sure where to start to make this work, but if anyone could give me a pointer, that would be super.

Many thanks
Eoin

Hello! I've got exactly what I've wanted in my previous topic so I have decided to make a new topic for some help.

Quote

General
General Discussion
Description here

Entertainment Discussion
Description here

Gaming
Console Discussion
Description here

Handheld Discussion
Description here


And a database like this;
id title description parent 1 General description here 0 2 Gaming description here 0 3 General Discussion description here 1 4 Entertainment Discussion description here 1 5 Console Discussion description here 2 6 Handheld Discussion description here 2

Code: [Select]
<?php
function generate_forums($parent)
{
$has_childs = false;

global $forums_array;        

foreach($forums_array as $key => $value)        
{
if ($value['parent'] == $parent)
{
if ($has_childs === true)
{
$has_childs = false;
}
echo '<a href="/category/' . $value['title'] . '/">' . $value['title'] . '</a><br>' . $value['description'] . '';        
generate_forums($key);        
echo '<br>';
}
} 
}
generate_forums(0);
?>
The code works wonders. But it is hard to customize template wise.

$ID#1 $title = General
I would start off with <table>
I need to have the Categories that Parent = ( 0 ) to have a HTML <tr>
I also need the Categories with Parent = ( Value ) to have a HTML <td>
Then the tags would be closed off before $ID#2 $title = Gaming's template would start again.

I keep trying to scramble the coding around and can't seem to find that probably "simple" touch.
Thanks in Advanced.