+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: 8 char slots (/showthread.php?tid=3199)
- DeChamp3 - 01-09-2014
hey,
since its possible to have 8 chars on 1 account with the card, id like to know where u can change that permanently, so that u can have 8 chars on 1 account without needing this card
- dethunter12 - 01-09-2014
the table your looking for is t_extendcharslot in newproject_db.
- DeChamp3 - 01-11-2014
the table your looking for is t_extendcharslot in newproject_db.
thanks a lot but any idea how i can set it automatical? i mean thats it for ALL users automaticaly extended without even needing the Character Slot Card
- Sutz - 01-11-2014
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
- DeChamp3 - 01-11-2014
thanks alot, i couldnt think of that xd
can be closed
- Johnny5 - 01-11-2014
A moderator closed this post. Reason: solved