RevCMS [PlusEMU] Auto give HC Subscription

[FatalLulz]

Hey,

I've ran this code for when a user registers;

$engine->query("INSERT INTO user_subscriptions (user_id, subscription_id, timestamp_activated, timestamp_expire) VALUES ('" . $userid . "', '" . $userid . "', '1376239398', '1735689630')");

Unfortunately when it's entered into the DB it says that the user ID is 0 and subscription ID is 0..

Any ideas why it's coming up like that?

[MentaL]

[FatalLulz]

-- bump --

[Brought]

Make the default in the database tables 1 instead of 0 for club_subscription or whatever

[FatalLulz]

Make the default in the database tables 1 instead of 0 for club_subscription or whatever

Well if it was that easy I would have done that, but unfortunately it's not so.

Still need help with this.

[D3T0XITY]

Make a welcome page that will give them a subscription

[FatalLulz]

Make a welcome page that will give them a subscription

Or not. Welcome pages are useless and boring. Not a must have or need have.

[Matata]

Because $userid is 0 or an unsupported value.

[Lewislol]

Put this in your client.php, it is tested.

<?php
$getSubscription = mysql_query("SELECT * FROM user_subscriptions WHERE user_id = '".$_SESSION['user']['id']."'");
if (mysql_num_rows($getSubscription) == 0)
{
mysql_query("INSERT INTO user_subscriptions (user_id, subscription_id, timestamp_activated, timestamp_expire) VALUES ('".$_SESSION['user']['id']."', '1', '".time()."', '1503071255')");
}
?>

[Kristophers]

Any exploits in the code above?

[Lewislol]

Any exploits in the code above?

No, I used this on my old hotel for 3 months if there was a exploit my hotel would of been exploited.

[Kristophers]

Well no need to use it anymore as there was a fix for HC