problem with update function

[mudmin]

I would say go straight to UserSpice 4.1 full and see what happens. I will tinker with the get function as soon as I get the 4.1 info on the site. Enjoy GOT.

http://userspice.org/?smd_process_download=1&downlhttp://userspice.org/?smd_process_download=1&download_id=1385

[lefox]

Link not working! Is this the same one on the download page?

[lefox]

is the alpha posted in the forums the same as the first download on the download page? I just got the one off the forum and the side nav is working perfectly!

[mudmin]

Oops Yeah. Bad copy/paste on my part. It's http://userspice.org/?smd_process_downlo...ad_id=1385 or the one on the homepage.

[lefox]

fixed the nav problem, took about 5 minutes to integrate all the features I had created. Well done, sir!

[mudmin]

Glad it worked. Thanks for sticking with us! I'm about to take a look at the get method now.

[mudmin]

I created a test to see if the $db->get is losing stuff for me. I see what you're talking about. I did...

Code:

$user1 = $db->get('users',array('id','=',1));

Code:

$user2 = $db->get('users',array('id','=',2));

Code:

dump($user1);

Code:

dump($user2);

and I get the results for user 2 twice. It must be how it's storing it in memory. Let me check on this.

[mudmin]

Ok. I figured out that the findById method works for your situation and is a little simpler. Try this

Code:

$league = $db->findById($leagueKey,'leagues');

and

Code:

$player = $db->findById($playKey,'player');

See if that works.

[mudmin]

Ok. There is a team of people working on this. We realized that both the get and findById methods (by design) only run the query, but do not return results on their own. To use my method above, you'll have to make one change to the db class. I'll push this out on an update (and probably fix your join issue too. In classes/db.php you have to add the ->first() to the end of this line. That will fix your problem.

Code:

public function findById($id,$table){

Code:

return $this->action('SELECT *',$table,array('id','=',$id))->first();

Code:

}

A new and improved get function is coming. I'll document that too.

[lefox]

should i add this to get too?