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)

Rainbow 6 08-30-2007 16:49

Re: [DB] Database Manager
 
you as in haveing a page that displays how much money you have on the server?
if so yes you can do that and if you pm me with your e-mail address i can send you a page but you will have to fill in the database info yourself
Rainbow 6

tkaway69 08-30-2007 19:44

Re: [DB] Database Manager
 
Ok. I sent you the pm. Thanks.

Rainbow 6 08-31-2007 23:17

Re: [DB] Database Manager
 
it will take me some time to get it all worked out but when i am done i will send it your way

kipplitz 09-01-2007 17:47

Re: [DB] Database Manager
 
Completely foreign to me at this point...I can't get the Database Manager to load and run without erroring. Here are snippets form logs and configs.

L 09/01/2007 - 16:39:28: [SM] Plugin encountered error 25: Call was aborted
L 09/01/2007 - 16:39:28: [SM] Native "SetFailState" reported: [MYSQLmanager] Fail state: Could not connect to mysql
L 09/01/2007 - 16:39:28: [SM] Debug mode is not enabled for "a_mysql.smx"
L 09/01/2007 - 16:39:28: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 5 on

L 09/01/2007 - 16:39:28: [a_mysql.smx] [MYSQLmanager] [2005]: Unknown MySQL server host 'db1107.perfora.net' (11004)

"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "mysql"
"host" "db1107.perfora.net"
"database" "db215923511"
"user" "*********"
"pass" "********"
//"timeout" "0"
//"port" "0"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
}


Any guidance appreciated.

Thanks,

KippLitz

tkaway69 09-01-2007 19:09

Re: [DB] Database Manager
 
Quote:

Originally Posted by kipplitz (Post 526105)
Completely foreign to me at this point...I can't get the Database Manager to load and run without erroring. Here are snippets form logs and configs.

L 09/01/2007 - 16:39:28: [SM] Plugin encountered error 25: Call was aborted
L 09/01/2007 - 16:39:28: [SM] Native "SetFailState" reported: [MYSQLmanager] Fail state: Could not connect to mysql
L 09/01/2007 - 16:39:28: [SM] Debug mode is not enabled for "a_mysql.smx"
L 09/01/2007 - 16:39:28: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 5 on

L 09/01/2007 - 16:39:28: [a_mysql.smx] [MYSQLmanager] [2005]: Unknown MySQL server host 'db1107.perfora.net' (11004)

"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "mysql"
"host" "db1107.perfora.net"
"database" "db215923511"
"user" "*********"
"pass" "********"
//"timeout" "0"
//"port" "0"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
}


Any guidance appreciated.

Thanks,

KippLitz

Note: We also tried leaving..

"driver" "mysql" as.... "driver" "default"

still errors.

Nican 09-01-2007 22:41

Re: [DB] Database Manager
 
Did you read the part of:
Unknown MySQL server host 'db1107.perfora.net'

Source mod could not connect to db1107.perfora.net

tkaway69 09-02-2007 01:32

Re: [DB] Database Manager
 
Yea turns out the host we were using did not allow this type of usage.

kipplitz 09-02-2007 02:39

Re: [DB] Database Manager
 
ok, setup a free mysql database and I think it is working. It appears to connect to the data base (no more errors) and it appears to keep track of money. When myself and two others got in the server to try it, we immediately had these HUGE amounts of money in our accounts when we ran bank status. Then we deposited 1000 in to our accounts and then it said we had 50,000. Any ideas?

kipplitz 09-02-2007 15:31

Re: [DB] Database Manager
 
ok...weird.

Last night after I setup the mysql database and the database manager along with bank mod, it acted all weird and in the database there was no data. Now today it appers fine and the database is populated. All new joining players start with 0. Maybe it is like a good bread and just needed time for the yeast to rise? lol.

Nican 09-02-2007 17:48

Re: [DB] Database Manager
 
I am confused... D:


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

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