webdevRefinery Forum: AwesomezGuy - Viewing Profile - webdevRefinery Forum

So SQLBeans are pissing me off right now, I have no idea what the fuck I'm doing wrong, and I'm tearing my hair out right now. Code below:

UserGroupBean.php - Error occurs on

$this->permissions = GroupPermissionBean::select($q, true, false, "default");

<?php
namespace trident\sqlbeans;

use hydrogen\sqlbeans\SQLBean;
use hydrogen\database\Query;
use trident\sqlbeans\GroupPermissionBean;

class UserGroupBean extends SQLBean {

	protected static $tableNoPrefix = 'user_groups';
	protected static $tableAlias = 'user_groups';
	protected static $primaryKey = 'id';
	protected static $primaryKeyIsAutoIncrement = true;
	protected static $fields = array(
		'id',
		'name'
	);

	protected $permissions = false;
	public function getPermissions() {
		if (!$this->permissions) {
			$q = new Query("SELECT");
			$q->where("group_permissions.group_id = ?", $this->id);
			$this->permissions = GroupPermissionBean::select($q, true, false, "default");
		}

		return $this->permissions;
	}
}
?>

GroupPermisssionBean.php

<?php
namespace trident\sqlbeans;

use hydrogen\sqlbeans\SQLBean;

class GroupPermissionBean extends SQLBean {

	protected static $tableNoPrefix = 'group_permissions';
	protected static $tableAlias = 'group_permissions';
	protected static $primaryKey = 'id';
	protected static $primaryKeyIsAutoIncrement = true;
	protected static $fields = array(
		'id',
		'group_id',
		'permission_id',
		'value'
	);
	
	protected static $beanMap = array(
		'group' => array(
			'joinType' => 'LEFT',
			'joinBean' => 'trident\sqlbeans\UserGroupBean',
			'foreignKey' => 'group_id'
		),
		'permission' => array(
			'joinType' => 'LEFT',
			'joinBean' => 'trident\sqlbeans\PermissionBean',
			'foreignKey' => 'permission_id'
		)
	);
}
?>

PermissionBean.php

<?php
namespace trident\sqlbeans;

use hydrogen\sqlbeans\SQLBean;
use hydrogen\database\Query;

class PermissionBean extends SQLBean {

	protected static $tableNoPrefix = 'permissions';
	protected static $tableAlias = 'permissions';
	protected static $primaryKey = 'id';
	protected static $primaryKeyIsAutoIncrement = true;
	protected static $fields = array(
		'id',
		'type',
		'name',
		'description'
	);
	
	protected static $beanMap = array(
	);
}
?>

I've dumped out what Hydrogen is doing under the hood and it's constructing the following query, which errors out with

Unknown column 'group_permissions.id' in 'field list'

SELECT `group_permissions.id` `group_permissions_id`, `group_permissions.group_id` `group_permissions_group_id`, `group_permissions.permission_id` `group_permissions_permission_id`, `group_permissions.value` `group_permissions_value`, `group_permissions_user_groups.id` `group_permissions_user_groups_id`, `group_permissions_user_groups.name` `group_permissions_user_groups_name`, `group_permissions_permissions.id` `group_permissions_permissions_id`, `group_permissions_permissions.type` `group_permissions_permissions_type`, `group_permissions_permissions.name` `group_permissions_permissions_name`, `group_permissions_permissions.description` `group_permissions_permissions_description` FROM `group_permissions` `group_permissions` LEFT JOIN `user_groups` group_permissions_user_groups ON group_permissions.group_id = group_permissions_user_groups.id LEFT JOIN `permissions` group_permissions_permissions ON group_permissions.permission_id = group_permissions_permissions.id WHERE group_permissions.group_id = ?

For the life of me I haven't a clue what the problem is, help someone?

So I've been playing Planetside 2 for over 2 months now and I have to say, it's probably the best game I've ever played. The devs are awesome, the game is awesome, and it's free to play. What more could you ask for?

I play on Lithcorp (EU) as Vanu Sovereignty, and I'm part of the management of the largest outfit (think clan) called Trident (ps2trident.com)

If anyone fancies joining me for a few games sometime, feel free to go grab the game at planetside2.com (or planetside2.eu if you live in the EU). Be warned, you do need a fairly powerful PC, I just about get 40-50FPS in large battles on High with an i5 3570k and a Radeon 7870 GHz Edition. The game is very CPU intensive, so if you don't have a fairly recent Quad Core, you probably won't get acceptable framerates.

Hackulous has shut down, which many of you will know was a community for the trialling/piracy of iOS applications. At this point it appears that Apptrackr has also gone down- and with no database release, leaving a distinct absence of a well organized source for cracked applications for iOS.
The closing message can be seen at http://hackulo.us/ and Apptrackr is simply inaccessible.

Seems a bit fishy to me, the sudden closure considering Installous and Apptrackr's continuing popularity. Dissident is not on IRC. The only real reasons I can think of for shutting down would be staff inactivity and boredom.

Edit: Logs from Dissident provided by a member of wdR to me:

Quote

So all my parts arrived a couple of weeks ago and I built the beautiful beast.
The specs:

• Intel Core i5 3570k CPU, Overclocked to 4.2GHz Stable
  
• Cooler Master Hyper 212 EVO CPU Cooler
  
• Asus P8Z77-M Motherboard
  
• Corsair Vengeance 8GB DDR3-1600 RAM
  
• Sapphire Radeon HD 7870 2GB Video Card
  
• Samsung 830B Series 128GB SSD
  
• Seagate Barracuda 1TB HDD
  
• NZXT Phantom 410 Mid Tower Case
  
• XFX Core Edition 550W Power Supply
  
• Asus VS228H 21.5" 1920x1080 Widescreen Monitor
  
• Logitech G500 Gaming Mouse
  
• Logitech K120 Keyboard

Pics of my new battlestation: http://imgur.com/a/FLPmA

It runs BF3 with everything on Ultra, 16x AA, 4x MSAA at 55-70FPS, and it runs Planetside 2 with everything on Medium at 70-85FPS (On High it drops down to 35-40 in big battles which is noticeable to me).
I'm going to try overclocking the GPU at some point and I'll probably be able to get >60 FPS on High with Planetside 2.

I am running Windows 7 on it and so far I've had no problems other than trying to stop myself from X'ing programs and thinking they'll just minimize. The one thing I'm having trouble with is finding a decent backup suite, I'm used to the awesome-ness of Time Machine and I can't find an equivalent for Windows. Anybody know of one?

Finally, if anyone wants to play some Planetside 2 with me, I'm on Lithcorp EU playing Vanu, name is JackJack233. For BF3 my Origin name is also JackJack233.

I AM LOOKING FOR SOMEONE OR GROUP TO CREATE AN OVER THE TOP LOOKING EASY TO USE WEBSITE WITH 3 LANGUAGE CAPABILITY AND ECOMMERCE FOR A SMALL AMOUNT OF THE SITE.

PLEASE READ WHAT IM LOOKING FOR BEFORE YOU REPLY.IF YOU QUALIFY, PLEASE SEND ME YOUR BID ALONG WITH A COUPLE OF WEBSITES YOU DESIGNED THE PERTAIN TO THE QUALITY IM LOOKING FOR.

I DO NOT WANT A COOKIE CUTTER PROJECT OR WEBSITE. SO I DO NOT WANT THE SAME IN THE DESIGNER. I ALSO WANT A PERSON OR GROUP WHO WILL SEND ME THOUGHTS AND IDEAS, A VERY CREATIVE ARTISTIC DESIGNER OR GROUP.

EVERYTHING IN THIS WEBSITE MUST BE OF THE HIGHEST QUALITY. THE HD SHARP VIVID PHOTOS. THE RICH DEEP COLORS AND SO ON.


I WANT TO START OFF WITH A 10 SEC FLASH INTRO.
EXAMPLE:
A SCEEN OF A FIELD WITH AN OAK TREE MAYBE A BROOK AND ROCK WALL.
( THE QUALITY IS LIKE YOUR STANDING THERE LOOKING AT THE DEPTH OF THE FIELD) AND ITS DUSK WITH SWIRLIN G COLORS FOR THE SKY AND QUICKLY IT STARTS TO TURNS DARK , RAINY AND THUNDER AND LIGHTNING. SUDDENLY A LARGE LIGHTNING BOLT STRIKES THE FRONT OF THE FIELD AND THE GROUNG OPENS UP AND 3 SPHERES COME UP FROM THE GROUND AND HOVER. ONE SAYS SPANISH THE OTHER ENGLISH AND THE 3RD HMONG. THEY CLICK ON THE LANGUAGE AND THE SITE OPENS UP TO THE HOME PAGE.

THE HOME PAGE WILL HAVE ROTATING PICTURES EVERY 5 SEC OR SO. NOT YOUR STANDARD ROTATING, SOMETHING UNIQUE. MAYBE THE PICTURE RIPPLES LIKE REAL WATER AND CLEARS UP AS A NEW IMAGE. OR THE PICTURE TWIST LIKE WHEN YOU RING OUT A TOWEL AND THEN UNTWIST WITH A NEW IMAGE. WHAT IM GETTING AT IS, UNIQUE AND NOT THE STANDARD.

THE HOME PAGE WILL ASO HAVE AROUND A DOZEN PAGES THAT NEED TO STAY WHEN EACH PAGE IS OPENED. SO THEY JUST NEED TO CLICK ON ANOTHER PAGE AND SO ON. NOT LOOKING FOR BACK SPACE OR HOME PAGE TO NAVIGATE, REAL SIMPLE. EVEN THE COLORS OF THE PAGE ICONS NEED TO BE RICH IN COLOR, NOT LIKE EVERY OTHER WEBSITE I SEE.

THERE WILL BE ALOT OF TEXT INFORMATION SO THE FONT AND COLOR MUST BE PERFECT. THERE WILL BE SOME LINKS ON EACH PAGE.

THERE WILL BE SOME MEDIA PAGES THAT I HAVE THAT NEED TO BE CLEANED UP AND SAVED SO WHEN THEY CLICK ON THEM THEY ARE ALWAYS THERE ( I HAD SOME BEFORE THAT WERE NO LONGER ON THE WEB SO THE LINK DID NOT WORK)

THERE WILL BE A SHOPPING CART FOR MY ECOMMERCE. THERE WILL ONLY BE TWO ITEMS THAT THIS WILL BE USED FOR. 1 IS A DVD PURCHASE, STRAIGHT FORWARD LIKE ANY OTHER SITE. THEY ADD TO CART THEY CHECK OUT THEY HAVE ALL THE INFOR TO FILL OUT TO PAY.

THE OTHER IS A LITTLE MORE WORK. A PAGE THAT ALLOWS THEM TO SIGN UP FOR A MONTHLY SERVICE. THEY CLICK ON TO REGISTER AND THEY FILL OUT THERE BASIC INFO AND AN EMAIL IS SENT TO THEM WITH AN ACCESS CODE, THEY ENTER THE ACCESS CODE AND THEN COMPLETE A FULL REGISTRATION AND CREDIT CARD INFO. THE PAYMENT WILL ROLLOVER EVERY MONTH UNLESS CAN CELLED. SO ALL THE PRIVACY, RETURN POLICIES AND ACCEPT OUR TERM LANGUAGE MUST BE ON BOTH THESE AREAS. THIS WILL ALSO REQUIRE LOG IN ICON SO THEY CAN ENTER THERE USER NAME WHICH I WANT IT TO BE THERE EMAIL AND THEN THERE PASSWORD. THEY ENTER AN AREA WITH A CONTACT STYLE PAGE WERE THEY CAN SEND AN EMAIL WITH A QUESTION AND WE REPLY AND THE ANSWER GOES TO THER EMAIL THE SET UP. THERE NEEDS TO BE A HISTORY TAB ON THERE PAGE SO THEY CAN LOOK BACK AT ALL THE Q&A FROM THE PAST. THE Q&A AUTOMATICALLY GETS SENT TO THERE HISTORY AREA ONCE THE REPLY IS SENT.

I HAVE ATTACHED SOME WEB PAGES JUST TO SHOW YOU THE QUALITY IM LOOKING FOR. I UNDERSTAND THAT OTHER THAN THE 10 SEC INTRO FLASH WILL NOT BE USED BUT THE QUALITY AND CAPABILITY WILL BE THE SAME.

LOOK AT THE RICH GREEN COLOR
http://www.ninthdegr.../portfolio.aspx

LOOK AT THE DEPTH OF THE FIELD EVEN THOUGH ITS NOT FOCUSED
http://thediviningrod.com/

LOOK HOW THE SPHERES FLOAT AND HAVE SHADOWS
http://www.avatarpartners.com/

LOOK AT THE ARTISTIC QUALITY OF THE SMOKE AND IMAGES
http://themagiclampinn.com/

LOOK AT THE EFFECTS GOOD SOUND CAN HAVE
http://qualityheating.net/

LOOK HOW IT TAKES UP THE WHOLE SCREEN AND NOT A CENTER BLOCK
http://thediviningrod.com/


THESE ARE JUST EXAMPLES OF QUALITY IM LOOKING FOR IN MY WEBSITE. I PUT PLENTY OF INFORMATION FOR YOU TO GIVE ME A BID ON THIS JOB. IT WILL START AS SOON AS I FIND THE PERSON OR GROUP WITH THE TALENT TO CREATE THIS.

BE SURE TO SEND YOUR BEST QUALITY SAMPLES AND ASK ANY QUESTIONS BEFORE YOU BID THIS JOB