The problem here is simple, it tries to insert as integer to a integer column when it should be inserted as a string.
What we have to do here, is first of change the SQL column `used_by` to not be integer, do so by run this:
When that is done, you have to open file redeem.php and change line
To
@Mariuskens , @kushovu , @calveron
Inserting a string value to a integer field should stand in above post. Sleep is for the weak.
What we have to do here, is first of change the SQL column `used_by` to not be integer, do so by run this:
Code:
ALTER TABLE __cornex_redeem
MODIFY COLUMN used_by varchar(35)
When that is done, you have to open file redeem.php and change line
PHP:
$query = "UPDATE `__cornex_redeem` SET `used_by` = $used_by , `time` = $time , `ip` = $ip WHERE `code` = '$code'";
To
PHP:
$query = "UPDATE `__cornex_redeem` SET `used_by` = '$used_by' , `time` = $time , `ip` = $ip WHERE `code` = '$code'";
@Mariuskens , @kushovu , @calveron
Inserting a string value to a integer field should stand in above post. Sleep is for the weak.
Last edited by a moderator: