[Request] Plugin SMS Credit/ Billing System

[back2arie]

As a subject

[rogersozua]

back2arie ...

-- Table structure for table user

CREATE TABLE IF NOT EXISTS user (
id_user int(11) NOT NULL AUTO_INCREMENT,
username varchar(12) NOT NULL,
realname varchar(100) NOT NULL,
password varchar(255) NOT NULL,
phone_number varchar(15) NOT NULL,
level enum('admin','user') NOT NULL DEFAULT 'user',
PRIMARY KEY (id_user),
UNIQUE KEY username (username),
UNIQUE KEY phone_number (phone_number)
UNIQUE KEY credit (credit)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- Dumping data for table user

INSERT INTO user (id_user, username, realname, password, phone_number, credit, level) VALUES
(1, 'kalkun', 'Kalkun SMS', 'f0af18413d1c9e0366d8d1273160f55d5efeddfe', '123456789', 'admin');

but where I would stir in the archives ?

[kingster]

Here is an approach you can take : Create a new table as user_credits with fields id_user and value , and you can manipulate that table as per your need.

[rogersozua]

CREATE TABLE IF NOT EXISTS user_credits (
id_user int(11) NOT NULL,
credits tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (id_user)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping data for table user_credits

INSERT INTO user_credits (id_user, credits) VALUES
(1, 100);

e isso, eu estava tendendo criar uma consulta para a tabela credits, mais não esta aparecendo, eu tenho que mexer eu outro lugar ? -- PT

and this, I was trying to create a query for the table credits, more is not showing up, I have to stir me elsewhere? -- EU

[kingster]

It would be better if you could send a pull request or share the plugin so that it can be pushed with the core.

[rogersozua]

como assim ? me de um exemplo

how so? me an example

[kingster]

Read a brief guide by back2arie at #13

[joaopca]

Estou desenvolvendo um plugin de prepago pro kalkun. Eu criei um SMS Router que verifica operadora antes de mandar o SMS e escolhe p qual modem mandar. Nesse SMS Router eu estou queimando os créditos.

[back2arie]

@joaopca please use English language.

[rogersozua]

Tradução --
I'm developing a plugin for prepaid pro kalkun. I created a SMS Router operator that checks before sending the SMS and to choose which modem send. In this SMS Router I'm burning the credits.