[Modern AAC] Pages/Injection

Kavvson · Jun 23, 2010

So i want add a injection - Gallery. It would be in Guilds_view

\injections\guild_view\Gallery\

So in the Gallery folder is a injection.php file.

The injection.php file INCLUDES a file in \injections\guild_view\Gallery\files

PHP:

<?php

	// initialization
	$result_array = array();
	$counter = 0;

	@$cid = (int)($_GET['cid']);
	@$pid = (int)($_GET['pid']);

	// Category Listing

	if( empty($cid) && empty($pid) )
	{
		$number_of_categories_in_row = 4;

		$result = mysql_query( "SELECT c.category_id,c.category_name,COUNT(photo_id)
						FROM gallery_category as c
						LEFT JOIN gallery_photos as p ON p.photo_category = c.category_id
						GROUP BY c.category_id" );
		while( $row = mysql_fetch_array( $result ) )
		{
			$result_array[] = "<a href='viewgallery.php?cid=".$row[0]."'>".$row[1]."</a> "."(".$row[2].")";
		}
		mysql_free_result( $result );	

		$result_final = "<tr>\n";

		foreach($result_array as $category_link)
		{
			if($counter == $number_of_categories_in_row)
			{	
				$counter = 1;
				$result_final .= "\n</tr>\n<tr>\n";
			}
			else
			$counter++;

			$result_final .= "\t<td>".$category_link."</td>\n";
		}

		if($counter)
		{
			if($number_of_categories_in_row-$counter)
			$result_final .= "\t<td colspan='".($number_of_categories_in_row-$counter)."'>&nbsp;</td>\n";

			$result_final .= "</tr>";
		}
	}


	// Thumbnail Listing

	else if( $cid && empty( $pid ) )
	{
		$number_of_thumbs_in_row = 5;

		$result = mysql_query( "SELECT photo_id,photo_caption,photo_filename FROM gallery_photos WHERE photo_category='".addslashes($cid)."'" );
		$nr = mysql_num_rows( $result );

		if( empty( $nr ) )
		{
			$result_final = "\t<tr><td>No Category found</td></tr>\n";
		}
		else
		{
			while( $row = mysql_fetch_array( $result ) )
			{
				$result_array[] = "<a href='viewgallery.php?cid=$cid&pid=".$row[0]."'><img src='".$images_dir."/tb_".$row[2]."' border='0' alt='".$row[1]."' /></a>";
			}
			mysql_free_result( $result );	

			$result_final = "<tr>\n";
	
			foreach($result_array as $thumbnail_link)
			{
				if($counter == $number_of_thumbs_in_row)
				{	
					$counter = 1;
					$result_final .= "\n</tr>\n<tr>\n";
				}
				else
				$counter++;

				$result_final .= "\t<td>".$thumbnail_link."</td>\n";
			}
	
			if($counter)
			{
				if($number_of_photos_in_row-$counter)
			$result_final .= "\t<td colspan='".($number_of_photos_in_row-$counter)."'>&nbsp;</td>\n";

				$result_final .= "</tr>";
			}
		}
	}

	// Full Size View of Photo
	else if( $pid )
	{
		$result = mysql_query( "SELECT photo_caption,photo_filename FROM gallery_photos WHERE photo_id='".addslashes($pid)."'" );
		list($photo_caption, $photo_filename) = mysql_fetch_array( $result );
		$nr = mysql_num_rows( $result );
		mysql_free_result( $result );	

		if( empty( $nr ) )
		{
			$result_final = "\t<tr><td>No Photo found</td></tr>\n";
		}
		else
		{
			$result = mysql_query( "SELECT category_name FROM gallery_category WHERE category_id='".addslashes($cid)."'" );
			list($category_name) = mysql_fetch_array( $result );
			mysql_free_result( $result );	

			$result_final .= "<tr>\n\t<td>
						<a href='viewgallery.php'>Categories</a> &gt; 
						<a href='viewgallery.php?cid=$cid'>$category_name</a></td>\n</tr>\n";

			$result_final .= "<tr>\n\t<td align='center'>
					<br />
					<img src='".$images_dir."/".$photo_filename."' border='0' alt='".$photo_caption."' />
					<br />
					$photo_caption
					</td>
					</tr>";
		}
	}

// Final Output
echo <<<__HTML_END

<html>
<head>
	<title>Gallery View</title>
</head>
<body>
<table width='100%' border='0' align='center' style='width: 100%;'>
$result_final		
</table>
</body>
</html>

__HTML_END;
?>

As you see

PHP:

$result_array[] = "<a href='viewgallery.php?cid=".$row[0]."'>".$row[1]."</a> "."(".$row[2].")";

Im unable to open such a link.. How can i add a page that will display the content?

404 Page Not Found
The page you requested was not found.

Code:

http://127.0.0.1/index.php/guilds/view/viewgallery.php?cid=1

stian · Jun 23, 2010

Extend the guilds controller with it?

Kavvson · Jun 23, 2010

Hmm and what aobut all sql querys

$result = mysql_query

mysql_fetch_array

all will work?

About the controller.. Add whole php of it?

chojrak · Jun 23, 2010

I guess you cant do ?smth=smth in ModernAAC. (I may be wrong.)

Kavvson · Jun 23, 2010

I never made a controller..

i know only it should be like this

PHP:

	public function gallery(){
	
	}

but the content uhh... dunno

// iv added a attach

http://otland.net/attachments/f16/4285d1277300449-modern-aac-pages-injection-gallery.rar

Look at it.. And tell me if it is possible to make it in modern aac

chojrak · Jun 23, 2010

Code:

public function gallery() { echo 'content'; }

Probably this way but I don't know how to control numbers then or something.

Kavvson · Jun 23, 2010

Let Stian help.. I still dont know how can i execute like the ?cid page.. What does the controller for it?:S

Kavvson · Jun 23, 2010

Or would be also good if this script only displayed the images

PHP:

<?php
	include("config.inc.php");

	// initialization
	$result_array = array();
	$counter = 0;

	@$cid = (int)($_GET['cid']);
	@$pid = (int)($_GET['pid']);

	// Category Listing

	if( empty($cid) && empty($pid) )
	{
		$number_of_categories_in_row = 4;

		$result = mysql_query( "SELECT c.category_id,c.category_name,COUNT(photo_id)
						FROM gallery_category as c
						LEFT JOIN gallery_photos as p ON p.photo_category = c.category_id
						GROUP BY c.category_id" );
		while( $row = mysql_fetch_array( $result ) )
		{
			$result_array[] = "<a href='viewgallery.php?cid=".$row[0]."'>".$row[1]."</a> "."(".$row[2].")";
		}
		mysql_free_result( $result );	

		$result_final = "<tr>\n";

		foreach($result_array as $category_link)
		{
			if($counter == $number_of_categories_in_row)
			{	
				$counter = 1;
				$result_final .= "\n</tr>\n<tr>\n";
			}
			else
			$counter++;

			$result_final .= "\t<td>".$category_link."</td>\n";
		}

		if($counter)
		{
			if($number_of_categories_in_row-$counter)
			$result_final .= "\t<td colspan='".($number_of_categories_in_row-$counter)."'>&nbsp;</td>\n";

			$result_final .= "</tr>";
		}
	}


	// Thumbnail Listing

	else if( $cid && empty( $pid ) )
	{
		$number_of_thumbs_in_row = 5;

		$result = mysql_query( "SELECT photo_id,photo_caption,photo_filename FROM gallery_photos WHERE photo_category='".addslashes($cid)."'" );
		$nr = mysql_num_rows( $result );

		if( empty( $nr ) )
		{
			$result_final = "\t<tr><td>No Category found</td></tr>\n";
		}
		else
		{
			while( $row = mysql_fetch_array( $result ) )
			{
				$result_array[] = "<a href='viewgallery.php?cid=$cid&pid=".$row[0]."'><img src='".$images_dir."/tb_".$row[2]."' border='0' alt='".$row[1]."' /></a>";
			}
			mysql_free_result( $result );	

			$result_final = "<tr>\n";
	
			foreach($result_array as $thumbnail_link)
			{
				if($counter == $number_of_thumbs_in_row)
				{	
					$counter = 1;
					$result_final .= "\n</tr>\n<tr>\n";
				}
				else
				$counter++;

				$result_final .= "\t<td>".$thumbnail_link."</td>\n";
			}
	
			if($counter)
			{
				if($number_of_photos_in_row-$counter)
			$result_final .= "\t<td colspan='".($number_of_photos_in_row-$counter)."'>&nbsp;</td>\n";

				$result_final .= "</tr>";
			}
		}
	}

	// Full Size View of Photo
	else if( $pid )
	{
		$result = mysql_query( "SELECT photo_caption,photo_filename FROM gallery_photos WHERE photo_id='".addslashes($pid)."'" );
		list($photo_caption, $photo_filename) = mysql_fetch_array( $result );
		$nr = mysql_num_rows( $result );
		mysql_free_result( $result );	

		if( empty( $nr ) )
		{
			$result_final = "\t<tr><td>No Photo found</td></tr>\n";
		}
		else
		{
			$result = mysql_query( "SELECT category_name FROM gallery_category WHERE category_id='".addslashes($cid)."'" );
			list($category_name) = mysql_fetch_array( $result );
			mysql_free_result( $result );	

			$result_final .= "<tr>\n\t<td>
						<a href='viewgallery.php'>Categories</a> &gt; 
						<a href='viewgallery.php?cid=$cid'>$category_name</a></td>\n</tr>\n";

			$result_final .= "<tr>\n\t<td align='center'>
					<br />
					<img src='".$images_dir."/".$photo_filename."' border='0' alt='".$photo_caption."' />
					<br />
					$photo_caption
					</td>
					</tr>";
		}
	}

// Final Output
echo <<<__HTML_END

<html>
<head>
	<title>Gallery View</title>
</head>
<body>
<table width='100%' border='0' align='center' style='width: 100%;'>
$result_final		
</table>
</body>
</html>

__HTML_END;
?>

Could someone do?

Kavvson · Jun 23, 2010

Up it

WibbenZ · Jun 23, 2010

bump for this xD

president vankk · Jun 23, 2010

wrong section

Correct Website ? lol
#FAIL

stian · Jun 23, 2010

I can't test it since you don't supply the SQL. But just about every SQL call you make here is wrong.

Kavvson · Jun 23, 2010

Hmm I know.. Its a standlone script:S.. So i ask how to make it work Stian.. Help me

I gonna release it.. I have a nice idea

Paxton · Jun 23, 2010

Use SQL driver already inside, read models and controllers to see how it works.

Kavvson · Jun 23, 2010

Paxi example

i dont know how to recode could you:S

Paxton · Jun 23, 2010

Kavvson said:
Paxi example i dont know how to recode could you:S

Read documentation, u have examples there.

Controllers : CodeIgniter User Guide
Views : CodeIgniter User Guide
Models : CodeIgniter User Guide

Kavvson · Jun 23, 2010

Thanks!

Kavvson · Jun 23, 2010

Ok i know now more.. Now i have question how can i convert

PHP:

		$result = mysql_query( "SELECT c.category_id,c.category_name,COUNT(photo_id)
						FROM gallery_category as c
						LEFT JOIN gallery_photos as p ON p.photo_category = c.category_id
						GROUP BY c.category_id" );
		while( $row = mysql_fetch_array( $result ) )
		{
			$result_array[] = "<a href='viewgallery.php?cid=".$row[0]."'>".$row[1]."</a> "."(".$row[2].")";
		}
		mysql_free_result( $result );

Into Modern AAC... ?

Paxton · Jun 23, 2010

Look at models already made.

Kavvson · Jun 23, 2010

I see only SQL Querys.. No outputs

can u show me the path?

oH

PHP:

		$this->load->database();
		$sql = $this->db->query("SELECT `id`, `title`, `body`, `time` FROM `news` ORDER BY id DESC LIMIT ".$config['newsLimit']."");
		$ret['amount'] = $sql->num_rows;
		$ret['news'] = $sql->result_array();
		return $ret;

Hmm

[Modern AAC] Pages/Injection

Gdy boli cie glowa wez

Attachments

Banned User

Gdy boli cie glowa wez

Banned User

Gdy boli cie glowa wez

Banned User

Gdy boli cie glowa wez

Gdy boli cie glowa wez

Gdy boli cie glowa wez

Global Moderator

Web Developer & AuraOT Owner

Banned User

Gdy boli cie glowa wez

Banned User

Gdy boli cie glowa wez

Banned User

Gdy boli cie glowa wez

Gdy boli cie glowa wez

Banned User

Gdy boli cie glowa wez