Climb Plugin/Top15

Started by Shocka J
23/05/2008 01:51
Page 2 of 2
Shocka J11/06/2008 04:21

in the sma file i have

register_cvar( "climb_save", "1" )
register_cvar( "climb_db_type", "mysql" )
register_cvar( "climb_db_host", "208.100.62.225" )
register_cvar( "climb_db_user", klimbzon_server )
register_cvar( "climb_db_pass", klimbzon_server, ***** )
register_cvar( "climb_db_name", "klimbzon_gameserver" )
register_cvar( "climb_db_prefix", "climb_" )
register_cvar( "climb_db_serverid", NULLSTR )
register_cvar( "climb_db_exists", "0" )


and in the sql.cfg i put

amx_sql_host "208.100.62.225"
amx_sql_user "klimbzon_server"
amx_sql_pass "****"
amx_sql_db "klimbzon_gameserver"
amx_sql_table "admins"
amx_sql_type "mysql"

after that i restarted the server and no one had admin, and there was still the database error. [no top15]

Fatalis11/06/2008 11:45

You have to allow your server's IP to connect to the mysql server. It's easy to do in cPanel but you don't have it. As I said a long time ago, ask your host. If you still don't want to ask your host, use sqlite.

anny011/06/2008 14:17

hum a little bit off topic but i just wanted to know if there's the plugin top15 ( pro15 and top15 in fact with or w/o checks ) which save the time steam id and stuff in database... 'cause in the plugin u mentionned there's lot of stuff unneeded so i just wanted to know if someone have Only the part of the plugin concerning the sql save!!

Shocka J11/06/2008 20:16

anny0 there is this plugin if this is what your looking for http://forums.alliedmods.net/showthread.php?p=64594


and..
i did ask my host they said...
As for it running on interworx, it will definitely work just like they said with cpanel. Just create the database, and then the user, and grant that user permission to access that database from your game servers ip.

but idk what that means... :(

Fatalis11/06/2008 20:47

Well I checked the Interworx panel demo and I didn't see anywhere to grant IP access.

Shocka J11/06/2008 22:29

what does that mean =[

Fatalis12/06/2008 00:11

It means you should just use sqlite.

Shocka J12/06/2008 00:26

I don't think i have that.

Fatalis, is there any public mod you would recommend that has th basics [top15, checkpoints, Semi-clip, etc]?

SchlumPF12/06/2008 11:02

if you do not have any maxx coding knowledge you should use kz_jump_plugin. it has no top15 yet but i know regalis posted a version with prokreedz top15 in the plugins thread at alliedmodders.
if would have knowledge you should start coding your own :P

Fatalis12/06/2008 12:36

Originally posted by Fatalis
You should just use sqlite, since it uses no sql server.

Shocka J13/06/2008 01:16

Fatalis they wrote:
Unfortunately, we are not going to install any additional programs on our game server boxes. We run them with as little processes as possible to get maximum performance from the machine itself. If the mod can utilize mysql, your best bet would be to use the remote mysql database.

and thanks SchlumPF* i think im just gonna give up on the server if i cant get this to work =[

Fatalis13/06/2008 03:37

sqlite is basically just a feature built into the mysql module on amxx. YOU DONT NEED ANY EXTERNAL SERVERS OR PROGRAMS.

register_cvar( "climb_db_type", "sqlite" )

Shocka J14/06/2008 07:41

sorry, thats what my host told me..

Fatalis14/06/2008 14:05

ffs just change climb_db_type to "sqlite" and start your server

Shocka J14/06/2008 21:20

yes, it still doesnt work tho
"
[Climb] DB Registration Error: Please notify a server admin"

and i changed it to climb_db_type to "sqlite"

Shocka J14/06/2008 22:06

the compile failed:
http://img264.imageshack.us/img264/372/333oz6.png

SchlumPF14/06/2008 22:57

dont change the sma file xD just add
climb_db_type "sqlite"
to the server.cfg

Shocka J14/06/2008 23:46(edited 14/06/2008 23:47)

what about this stuff?
register_cvar( "climb_save", "1" )
register_cvar( "climb_db_type", "sqlite" )
register_cvar( "climb_db_host", "208.100.62.225" )
register_cvar( "climb_db_user", klimbzon_server )
register_cvar( "climb_db_pass", klimbzon_server, ***** )
register_cvar( "climb_db_name", "klimbzon_gameserver" )
register_cvar( "climb_db_prefix", "climb_" )
register_cvar( "climb_db_serverid", NULLSTR )
register_cvar( "climb_db_exists", "0" )


and in the sql.cfg i put

amx_sql_host "208.100.62.225"
amx_sql_user "klimbzon_server"
amx_sql_pass "****"
amx_sql_db "klimbzon_gameserver"
amx_sql_table "admins"
amx_sql_type "mysql"

Page 2 of 2

Please log in to post replies.