01-11-2014, 06:52 PM
Add a query to your register page to input their user_code , start date and last the date it ends
This is just a demo for you
INSERT INTO newproject_db.t_extendcharslot (a_user_index, a_usedatetime, a_end_datetime) VALUES (usercode,2014-01-01 01:01:01,2020-01-01 01:01:01)
If your using LCCMS edit classes.php an you will find:
// Add 8 char slots to account
//$query = sprintf("INSERT INTO t_extendcharslot (a_user_index, a_use_datetime, a_end_datetime) VALUES (:user, :today, 2020-01-01 01:01:01)", $LCdb );
//$dbh = $conn234->prepare( $query );
//$dbh->execute( array( :user => $resultb[user_code], :today => $Today ));
//$result7 = $dbh->fetch();
Just un comment all this from line 420

