Starting Money

[WormFood 3]

Where can i look to make it so new players start off with some $$$

Edited September 15, 2015 by WormFood

[Sukkaed 56]

ALTER TABLE account ALTER COLUMN money SET DEFAULT 1000;

[rb19810507 4]

where is the what i need to edit?

[bFe 16]

Run the query Sukkaed posted in your database.
I'm using Navicat, but it's probably similar with the other tools.

Query -> New Query  -> paste line below > Run..voila.

 

ALTER TABLE account ALTER COLUMN money SET DEFAULT 1000;

Edited February 3, 2016 by bFe

[Chainsaw Squirrel 144]

As of version 1.02 its
ALTER TABLE account ALTER COLUMN locker SET DEFAULT 1000; 

 

Edited March 26, 2017 by Chainsaw Squirrel

[__Nairic~. 1]

Hi, i do this, it works a few days.

Defaut money to 3500, but when we spawn, now, we see 0 poptabs on xm8 and statusbar, but on MySQL i can see 3500. We must disconnect and connect to see our money...

Any answer?

[WhiteBl00d 7]

On 20.5.2017 at 1:41 AM, __Nairic~. said:

Hi, i do this, it works a few days.

Defaut money to 3500, but when we spawn, now, we see 0 poptabs on xm8 and statusbar, but on MySQL i can see 3500. We must disconnect and connect to see our money...

Any answer?

the default money will if you set it right up only getting add to new created players

if you want to add money to already existing players in your database run this

UPDATE account SET locker = locker + 5000

 

[__Nairic~. 1]

3 hours ago, WhiteBl00d said:

the default money will if you set it right up only getting add to new created players

if you want to add money to already existing players in your database run this

UPDATE account SET locker = locker + 5000

 

Hi, thanks for your answer. 

I want that when everybody spawn, he has 3500 poptabs on him, not in locker. So i have update database player with money +3500 but doesn't work, we must disconnect and reconnect us to see the 3500 on our status bar and use it to trader.

I have just do this, and since 10 days, doesn't work