# daloRADIUS bug fix for refill traffic or time — Liran Tal

An open source contribution from Ezequiel Villarreal to fix a bug in daloRADIUS's accounting interface

Canonical: https://lirantal.com/blog/2014-05-17

With thanks to Ezequiel Villarreal, and another fine example of the [open source](http://en.wikipedia.org/wiki/Open_source) movement in general and the daloRADIUS users community in specific, a patch has been contributed to [solve](http://sourceforge.net/p/daloradius/code/2120/) an issue with refilling a user’s traffic or time limits in [daloRADIUS’s](http://daloradius.com/) Accounting interface.

Ezequiel was kind enough to e-mail information about a problem, along with constructive feedback on the project (always great to hear!), but not without also sending the fix for it too.

```
> Hi! Liran,
> I’ve downloaded daloradius, it is a great plataform  ![:-)](https://web.archive.org/web/20140625184339im_/http://enginx.com/wp-includes/images/smilies/icon_smile.gif)

> I’ve found a bug when you do a Refill Traffic, it gives you an insert error, but you could see that only debugging.

> On “./include/management/userOperations.php”You have: $sql = “INSERT INTO “.$configValues['CONFIG_DB_TBL_DALOBILLINGHISTORY']. ” (id,username,**planName**,billAmount,billAction,billPerformer,billReason,”. ” paymentmethod,cash,creditcardname,creditcardnumber,creditcardverification,creditcardtype,creditcardexp,”. ” creationdate,creationby”. “)”. ” VALUES “………………..

> There is not planName on billing_history, only you have a planId. then, refilling is not saved on that table.

> I’ve changed code to$sql = “INSERT INTO “.$configValues['CONFIG_DB_TBL_DALOBILLINGHISTORY']. ” (id,username,**planID**,billAmount,billAction,billPerformer,billReason,”. ” paymentmethod,cash,creditcardname,creditcardnumber,creditcardverification,creditcardtype,creditcardexp,”. ” creationdate,creationby”.

> The same problem on refilling time.
>
> And it works perfectly!
> Thank you very much!

> Best Regards,
> Ezequiel Villarreal
```

daloRADIUS accounting and reporting capabilities

[![](https://web.archive.org/web/20140625184339im_/https://sourceforge.net/p/daloradius/mailman/attachment/81237f640807051143h45d1b48ajf0acc685fca11533@mail.gmail.com/3/)](https://sourceforge.net/p/daloradius/mailman/attachment/81237f640807051143h45d1b48ajf0acc685fca11533@mail.gmail.com/3/)

## More writing

[All writing →](/blog)

*   Sep 5, 2026

    ### [Self-Hosting Hermes Agent with Matrix E2EE on Proxmox](/blog/self-host-hermes-agent-matrix-e2ee-proxmox)

*   Aug 2, 2026

    ### [The Practical Second Brain: Building an LLM-Operated Markdown Knowledge Graph](/blog/practical-second-brain-llm-markdown-knowledge-graph)

*   Aug 1, 2026

    ### [Building a Second Brain with LLMs and AI Agents](/blog/building-second-brain-llms-ai-agents)


* * *

Liran Tal is the author of the book [Node.js Secure Coding: Defending Against Command Injection Vulnerabilities](https://www.nodejs-security.com/)

[Start Building Secure Node.js Applications ↗](https://www.nodejs-security.com/)

 [![](/_astro/nodejs-secure-coding-book-3d-style.DiTWpzFs_Z3c7s1.png)](https://www.nodejs-security.com/)