View Single Post
Hova
Junior Member
Join Date: Apr 2009
Old 04-06-2009 , 12:06   Re: [DB] Database Manager
Reply With Quote #73

Hmmm??

I'm sorry, I do not really get what you're meaning ...

Yes, I know, I installed this plugin and it works.

Then I was looking for a "saved" bank, so the money is not lost after a disconnect/mapchange.

Now, I installed the sql_beta and the globaldb, and the SQL is kinda working, but only half of the time:

The bank seems to be saved some times, and some times not.

I can rejoin and my bank is 5 times saved, and 5 times it is not ...

Also, it seems to be saved after a mapchange, most of the time!

I'm really sorry, I don't know where I'm failing at ...

  • I installed the smx and the inc, I made the database.cfg look like yours, except I wrote "sourcemod" instead of "sm", cause it is called "sourcemod", not "sm", on the ftp.
  • I wrote into my server's autoexec.cfg sm_db_config "storage-local" just like it was written, and then I checked if the second part of the database with the sqlite-stuff looks like yours, and it does!
I really dunno what to do with the
  • new db_money;

    public
    OnPluginStart()
    {
    }

    public
    DB_OnRowsUpdated(){
    db_money = DB_GetColumnId("my_money", true, true, DB_INT);
    if(
    db_money == -1)
    SetFailState("[SMbank] Could not create money column!");
    }

    stock GetUserMoney(client){
    return
    DB_GetColumn( client, db_money );
    }

    stock SetUserMoney(client, money){
    return
    DB_SetInfo(client, db_money , money);
    }
Do I need that? Where do I put it in?

Cheers and sorry for my bad english, it's not my motherlanguage.
Hova is offline