AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Snippets and Tutorials (https://forums.alliedmods.net/forumdisplay.php?f=112)
-   -   [DB] Database Manager (https://forums.alliedmods.net/showthread.php?t=60036)

Hova 04-06-2009 07:40

Re: [DB] Database Manager
 
Hi...

I installed you Bank-plugin for sourcemod.

It works quite fine, except the bank datas of the players are not saved on round end/disconnect. :cry:

So I installed the sql_beta.smx and the globaldb.inc as it was shown to do.

I edited the files like you said, but I am just not able to get the goddamn data saved.

I already restarted my server, but it is still not working.

Im on the end of my latin ...

Need help!

Cheers

€dit: Here a screenshot of my database, is something wrong with it?

http://www.abload.de/thumb/unbenannti3vs.jpg

Nican 04-06-2009 11:28

Re: [DB] Database Manager
 
My Bank plugin does need this module to work?

Hova 04-06-2009 12:06

Re: [DB] Database Manager
 
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.

Nican 04-06-2009 12:11

Re: [DB] Database Manager
 
Ok.. Let's step back.

What plugin are you using, or are you trying to script one?

Hova 04-06-2009 12:27

Re: [DB] Database Manager
 
Hell no, I dont even know how to script a plugin ^__^

I am using the advanced-c4-timer, the HLstatsX-plugin, deathbeam, knifefight, the ratechecker, the restrict-plugin, the teambets, and the teamswitch plugin.

I just dont get your SQL-database to work correctly, sometimes the bank-data is just cleaned and all the money is lost ...

And thx for your help in advance!

€: And, not to forget, the SQL-Beta and the Bank-plugin from you!!

Nican 04-06-2009 13:13

Re: [DB] Database Manager
 
I am sorry, I am a bit busy.

Anyway, the bank plugin that I made does not need the database manager. You sure you are not using someone else bank plugin?

http://forums.alliedmods.net/showthread.php?p=523727

Oh, and are you using SQLite or MySQL?

Hova 04-06-2009 14:08

Re: [DB] Database Manager
 
Yep, I am definitely using YOUR plugin. :-)

Err, Idk, I just downloaded and put the a_sql_beta.smx into my sourcemod/plugins folder ... :/

Stevvo 08-06-2009 09:23

Re: [DB] Database Manager
 
Thanks, great include, very useful.

NouveauJoueur 08-20-2009 04:03

Re: [DB] Database Manager
 
Thanks you very much ...

This :

Quote:

If you have acess to root in your linux computer, execute this in shell "ln -s /var/run/mysqld/mysqld.sock
Fixed all problem I had with mysql & sourcemod.

LolderPunkt 09-06-2010 14:44

Re: [DB] Database Manager
 
hi i need some help!
i dont have a mySQL or SQLlite database and cant create one! but i need one plugin that make a way without mySQL or SQLlite database! can you help me? can you say me that its possible to use all the SQL-Plugins without a SQL database?

now i use the databank from db4free.net but bank an rank plugins dont work... i create tables and all but now i surch the problem can you help me? can you give me instruction what i have to do? sorry 4 my english


All times are GMT -4. The time now is 18:51.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.