top15

Started by mpasd^
03/03/2015 21:57
Page 1 of 1
mpasd^03/03/2015 21:57(edited 03/03/2015 22:04)

I need help with setting up top 15 for my server...
I have prokreedz plugin and the classic top is set, with nothing but time and cp's, tp'... But i saw on many different severs like nobkz, that the top is different, has more information, world records and is a lot better than mine, i think you know what i mean...
So i was wondering if you could walk me through the process or point me in the right direction to make the top look like that ...

Mathzz04/03/2015 10:09

I think its just a html script for their website. I could be wrong, though.

mpasd^04/03/2015 16:37

Yeah i found out i need a coder for that ...

enddDD24/04/2015 20:16

use the sql files from prokreedz.

mpasd^25/04/2015 02:16(edited 25/04/2015 02:28)

I have no idea what to do with all those php files... Can you help me?

I need to know where to put the files and what to type here:
define("DB_HOST", "IP or HOST");
define("DB_USER", "username");
define("DB_PASS", "password");
define("DB_NAME", "database table name");
What host and username should i put here?

enddDD25/04/2015 10:43

Ok.So here we go:

**.Create a database for your cs server.Most hosts will provide acces to phpmyadmin or so.If not you can ask your host to create a database for you and provide all the information.

**.In the prokreedz.sma you need to find

//#define USE_SQL

replace with:

#define USE_SQL

**.In the same prokreedz .sma find:

#if defined USE_SQL
kz_sql_host = register_cvar("kz_sql_host", "") // Host of DB
kz_sql_user = register_cvar("kz_sql_user", "") // Username of DB
kz_sql_pass = register_cvar("kz_sql_pass", "", FCVAR_PROTECTED) // Password for DB user
kz_sql_db = register_cvar("kz_sql_db", "") // DB Name for the top 15
kz_sql_name = register_cvar("kz_sql_server", "") // Name of server
kz_sql_files = register_cvar("kz_sql_files", "") // Path of the PHP files
#endif

and put your database details in there. replace kz_sql_host with your host user with user, and so on.This assuming that you have a dedicated ip and a webhost.

**.Compile the plugin.
**.Open config.php from top15 mysql files wich is located in the include folder.

define("DB_HOST", "ip of your database"); // UPDATE HERE
define("DB_USER", "user of the database"); // HERE
define("DB_PASS", "password of the database user"); // HERE
define("DB_NAME", "database name ex: top15");

**.Open kreedz.cfg from your addons/amxmodx/configs/kz/

and find and edit like this:


// SQL Config
kz_sql_host "ip of db host"
kz_sql_user "db user"
kz_sql_pass "pass of db user"
kz_sql_db "name of the database"
kz_sql_files "www.yoursite.com/top15" - assumed that you put all the top15 sql files in the folder named top15 on your webhost.This means that tou create a folder in your public_html or root of your website named top15 and in that folder put all the files like: data,flags,images,include,language,motd,and the php files.

After all this it should work.If you have any questions ask here, i`l try to help.


mpasd^25/04/2015 17:51

I just have one last question. About creating a database...
Is that something i can do on my own or do i need to contact the community owners or the ones hosting the server...?
That is the step i never really understood... is it suppossed to be like a website or what?

enddDD25/04/2015 21:07(edited 25/04/2015 21:09)

i really dont know if you can do it yourself or not.Do you have a website? Do you have some sort of cpanel?
The database it should be mysql.search google for mysql and you will understand what it is.In this database your top will save the times,players,steamids,etc to show them on top15.
What kind of acces do you have for your server?Do you have ftp?Do you have some gamepanel?If not you should contact the person who administrate the server.And yes you need a website so you can put the top15 sql files from prokreedz.give me more details about your situation.Are you the owner of the server? etc.

check this to understand what is the database: https://www.youtube.com/watch?v=YbIn--iNmKE

mpasd^25/04/2015 21:34

Well it's a serbian community with lots of servers:
http://forum.milf-cs.net/
And i'm just a head admin of the kreedz server. I have access to ftp for my server, and also some kind of a game panel, which is basically the same as ftp...
And all the server in the community are hosted by kgb hosting...

enddDD25/04/2015 21:46

Contact the owner of the community and ask him about the database.He should know what you want.In gamepanel do you have the option to create a database for your server?Also you need to host the files on some website(maybe community website)and point them in the kreedz.cfg and config.php.

mpasd^25/04/2015 21:51(edited 25/04/2015 22:00)

All i have are basic controls like: stop, start and webftp...
So, what i need is:
1. A mysql database - which i will link to the config.php, prokreedz.sma and kreedz.cfg
and
2. A website which will show the top15, like on nobkz, and link that to the plugin as well ...
Is that it?

EDIT: and also what files am i supposed to upload to the server and what files to the site???

enddDD26/04/2015 00:41

1 and 2 -right. you get those files from here: https://forums.alliedmods.net/showthread.php?t=130417 see the attached files in the first post.
top 15 sql - website
prokreedz -cs server

mpasd^26/04/2015 01:03

Thank you so much for all the help.
I'm currently negotiating with the site owners.
I don't know why, but the owner said he can't give me a mysql database...

enddDD26/04/2015 01:38

That is strange.There are a lot of plugins that uses databases.even the default amx can use db to store admins for example.

mpasd^26/04/2015 02:10

I guess i'll have to try and give him all the needed files and info, and have no acces to it...
Is editing tops still the same? from the configs/kz/top15 ?

Page 1 of 1

Please log in to post replies.