Phpretro register page

[Eronisch]

Hi,

I want that users automatically get hc and a badge, but for some reason it doesn't work.
My sql should be right, the register page doesn't give me any errors.

Code:

​

// Gives a user 12 months of hc
$db->query("INSERT INTO ".PREFIX."users_club(userid,months_expired,months_left,date_monthstarted) VALUES ('".$row[0]."','0','12','".time()."')");
// Give that bitch a shiny badge, bitches loves shiny badges
$db->query("INSERT INTO ".PREFIX."users_badges(userid,badgeid,iscurrent,slotid,badge) VALUES ('".$row[0]."','HC2','1','1','NULL')");

I've added the code under the line:

$db->query("INSERT INTO ".PREFIX."transactions (userid,time,amount,descr) VALUES ('".$row[0]."','".time()."','".$scredits."','Welcome to " . $sitename . "!')");

That should be the right place, does someon know why it doesn't work?

 

[Sledmore]

I don't recall PHPRetro modifying the default holograph tables to it's own prefix, try this:

// Gives a user 12 months of hc
$db->query("INSERT INTO users_club(userid,months_expired,months_left,date_monthstarted) VALUES ('".$row[0]."','0','12','".time()."')");
// Give that bitch a shiny badge, bitches loves shiny badges
$db->query("INSERT INTO users_badges(userid,badgeid,iscurrent,slotid,badge) VALUES ('".$row[0]."','HC2','1','1','NULL')");

 

[Eronisch]

I already tried it without prefix, didn't work.

 

[Sledmore]

Adding the prefix would only try to do cms_users_club, just running it as mysql_query and adding or die(mysql_error()); on the end.

 

[Eronisch]

Ok, i'll give it a try

I know what the problem is, the time was wrong.
phpretro automatically deletes the badge and club.

I currently have got this:

$date = date("d-m-y");
$db->query("INSERT INTO users_club(userid,months_expired,months_left,date_monthstarted) VALUES ('".$row[0]."','0','12', ".$date.")");
But the $date is -2, how is that possible?

 

[Sledmore]

Because your not giving it any value, try using 'time()'.

 

[BatDev]

Because your not giving it any value, try using 'time()'.

Wouldn't UNIX_TIMESTAMP() be better?

 

[Eronisch]

How do you mean?

By the way, thanks for the fast support!

 

[Sledmore]

Wouldn't UNIX_TIMESTAMP() be better?

Not sure, I always going by using 'time()'. personally.

How do you mean?

By the way, thanks for the fast support!

Try urm;

$date = date("d-m-y", time());

 

[BatDev]

Not sure, I always going by using 'time()'. personally.



Try urm;

$date = date("d-m-y", time());

this is the date variable that I use in my scripts

$time = date('d-m-Y h:m');

 

[Eronisch]

Still -2 for both answers.

$time = date('d-m-y');
$db->query("INSERT INTO users_club(userid,months_expired,months_left,date_monthstarted) VALUES ('".$row[0]."','0','12', ".$time.")");

 

[Eronisch]

Fixed it, for fuck sake ..
I was missing the ' before "$time" ... and "d-m-y" inplace of 'd-m-y'

Thanks for the support guys!

 

[Sledmore]

No problem! Thread closed.