Lua Premium points NULL

[Radium]

Hi, Basically i have a working zaypay script but the issue I have is that when I pay with the SMS etc

The points are not added into the Premium_points column in Accounts.

The points are only added when the Premium_points column reads "0" or any number.
The problem i have is that when the accounts are made in-game the premium_points is set to NULL and that is the reason points are not added!

How can i change all of the NULL to 0? Also how do i make it so that they are 0 for every account register? I should make a onLogin script? I suck at luaSQL can anyone help me?

Like example if premium_points NULL then set to 0. however you do that in luaSQL

 

[Cykotitan]

Execute in phpMyAdmin:

ALTER TABLE `accounts` MODIFY `premium_points` INT( 11 ) NOT NULL DEFAULT '0';

 

[Radium]

Will it set to 0 for newly created accounts too?

 

[Cykotitan]

Yep, but I'm not sure if it will update existing accounts.