Raised This Month: $32 Target: $400
 8% 

[DB] Database Manager


Post New Thread Reply   
 
Thread Tools Display Modes
Hova
Junior Member
Join Date: Apr 2009
Old 04-06-2009 , 07:40   Re: [DB] Database Manager
Reply With Quote #71

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.

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?


Last edited by Hova; 04-06-2009 at 09:18. Reason: added database-screenshot!
Hova is offline
Nican
Veteran Member
Join Date: Jan 2006
Location: NY
Old 04-06-2009 , 11:28   Re: [DB] Database Manager
Reply With Quote #72

My Bank plugin does need this module to work?
__________________
http://www.nican132.com
I require reputation!
Nican is offline
Send a message via ICQ to Nican Send a message via MSN to Nican
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
Nican
Veteran Member
Join Date: Jan 2006
Location: NY
Old 04-06-2009 , 12:11   Re: [DB] Database Manager
Reply With Quote #74

Ok.. Let's step back.

What plugin are you using, or are you trying to script one?
__________________
http://www.nican132.com
I require reputation!
Nican is offline
Send a message via ICQ to Nican Send a message via MSN to Nican
Hova
Junior Member
Join Date: Apr 2009
Old 04-06-2009 , 12:27   Re: [DB] Database Manager
Reply With Quote #75

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!!

Last edited by Hova; 04-06-2009 at 12:29.
Hova is offline
Nican
Veteran Member
Join Date: Jan 2006
Location: NY
Old 04-06-2009 , 13:13   Re: [DB] Database Manager
Reply With Quote #76

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?
__________________
http://www.nican132.com
I require reputation!
Nican is offline
Send a message via ICQ to Nican Send a message via MSN to Nican
Hova
Junior Member
Join Date: Apr 2009
Old 04-06-2009 , 14:08   Re: [DB] Database Manager
Reply With Quote #77

Yep, I am definitely using YOUR plugin. :-)

Err, Idk, I just downloaded and put the a_sql_beta.smx into my sourcemod/plugins folder ... :/
Hova is offline
Stevvo
New Member
Join Date: Jul 2009
Old 08-06-2009 , 09:23   Re: [DB] Database Manager
Reply With Quote #78

Thanks, great include, very useful.
Stevvo is offline
NouveauJoueur
SourceMod Donor
Join Date: May 2009
Old 08-20-2009 , 04:03   Re: [DB] Database Manager
Reply With Quote #79

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.
__________________

Last edited by NouveauJoueur; 09-16-2010 at 03:27.
NouveauJoueur is offline
LolderPunkt
Junior Member
Join Date: Sep 2010
Location: Germany
Old 09-06-2010 , 14:44   Re: [DB] Database Manager
Reply With Quote #80

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

Last edited by LolderPunkt; 09-07-2010 at 12:55.
LolderPunkt is offline
Send a message via ICQ to LolderPunkt
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 01:50.


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