Raised This Month: $ Target: $400
 0% 

Call Admin MySQL


Post New Thread Reply   
 
Thread Tools Display Modes
Sunshine live
Veteran Member
Join Date: May 2009
Location: Berlin
Old 03-05-2011 , 17:31   Re: Call Admin MySQL
Reply With Quote #21

Hi, I have asked the following namely how to exclude admins and bots?
Since there is at present many bots and admins are reported ....
I hope you can help me

Sorry for my bad english
__________________
Sunshine live is offline
Send a message via ICQ to Sunshine live Send a message via MSN to Sunshine live Send a message via Skype™ to Sunshine live
Old 03-07-2011, 08:14
Viera
This message has been deleted by Viera.
daneleo
Senior Member
Join Date: May 2011
Old 06-03-2011 , 13:58   Re: Call Admin MySQL
Reply With Quote #22

credit goes to carbonated he made the .php script

DO NOT COPY THIS IT WILL BREAK YOUR PHP FILE I USED GOOGLE TRANSLATE AND IT BROKE IT! SO JUST READ WHAT IT SAYS

<? Php
/ *
* MySQL Call Admin System 1.0
* Plugin - IMBA
* Web - [email protected]
* /
/ / Less protection: D START
if (! defined ("key")) {
header ("Location: ./index.php");
}
/ / Less protection: D END
/ / Connect to a database START
$ Host = "localhost"; / / mysql host server (usually localhost)
$ User = "root"; / / user of your database (must have SELECT rights hell (for plugin INSERT))
$ Pass = ""; / / user's password
$ Database = "calladmin"; / / database
$ Table = "call_admin"; / / plugin automatically creates it if does not exist, but if you make edits to the code, not to fumble
/ / Connect to a database END

/ / Conntecting .. DO NOT touch anything (unless you know what you are doing) START
$ Connect = mysql_connect ($ host, $ user, $ pass) or die ("<center> <b> Error # 1 - I can not connect to MySQL server! </ B> <br /> Possible reasons: <br /> - Check that the MySQL server <b> ($ host) </ b> function, and you have access to it <br /> - make sure you entered the correct server name and password in the file config.php </ center> ");
mysql_select_db ($ database, $ connect) or die ("<center> <b> Error # 2 - I can not connect to MySQL a database <b> ($ database) </ b>! </ b> <br / > Possible reasons: <br /> - check database <b> ($ database) </ b> there <br /> - check whether the user you specified <b> ($ user) </ b> has rights Access to the database </ center> ");
/ / Conntecting .. END

/ / Set the system START
$ Last_calls_count = "10" / / how the last of the called admin indicate
$ Last_calls_refresh_count = "20" / / how many seconds to refreshva page
$ Server_color = "# 000000" / / color for all types of server without color RGB! / And can use English names - white, black, green, yellow, pink, etc.
$ Date_color = "grey"; / / color of the date - -
$ Time_color = "blue"; / / color of the hour - -
$ Nick_color = "green"; / / color of the receiver - "-
$ Reason_color = "red"; / / color of the cause - "-
$ Border_color = "blue"; / / color of the enclosure
$ Font_size = "10" / / font size for the recent calls
$ Counter_font_size = "12" / / font size for the counter
/ / Set the system END

?>


Last edited by daneleo; 06-03-2011 at 15:10.
daneleo is offline
Shadymn
Senior Member
Join Date: Sep 2010
Old 06-12-2011 , 05:03   Re: Call Admin MySQL
Reply With Quote #23

can you make it using by IP and Nickname? So we can use it more easy
Shadymn is offline
Gam3ronE
SourceMod Donor
Join Date: Aug 2010
Old 08-30-2011 , 14:23   Re: Call Admin MySQL
Reply With Quote #24

Great idea thank you very much.
Gam3ronE is offline
analogg
Junior Member
Join Date: Sep 2009
Location: Ukraine
Old 09-09-2011 , 10:11   Re: Call Admin MySQL
Reply With Quote #25

Hello!
I have one question:
hostname of my server is in UTF-8 codepage. And when a plugin get hostname string, then in php script and sql DB hostname of server shows incorrect. How can i fix it?
Thx!

P.S. - plugin, php and mysql DB, i save on UTF-8, but still incorrect show.
analogg is offline
xakintosh
I run no-steam servers!
Join Date: Feb 2010
Location: Edge of nowhere
Old 09-10-2011 , 05:03   Re: Call Admin MySQL
Reply With Quote #26

Try to save the plugin in UTF-8 format i think right now its ANSI

File - Save as :



PS. Sorry i didn't see the PS.
I never have tried with UTF8 Encoding and i just don't have right answer for you.
__________________
As soon as possible.

Last edited by xakintosh; 09-10-2011 at 05:07.
xakintosh is offline
Send a message via Yahoo to xakintosh Send a message via Skype™ to xakintosh
analogg
Junior Member
Join Date: Sep 2009
Location: Ukraine
Old 09-10-2011 , 07:42   Re: Call Admin MySQL
Reply With Quote #27

xakintosh, thx for answer! I think encoding lost when a plugin send data to DB, or DB get data of hostname in incorrect encoding.
analogg is offline
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 09-10-2011 , 10:57   Re: Call Admin MySQL
Reply With Quote #28

add a .need or /need players

Type, .need <number> and .need <admin>
__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
omer
Senior Member
Join Date: Nov 2011
Old 03-20-2012 , 10:55   Re: Call Admin MySQL
Reply With Quote #29

Can anyone please make this in mysql i dont like sqlx
omer is offline
GordonFreeman (RU)
Veteran Member
Join Date: Jan 2010
Location: Uzbekistan
Old 03-20-2012 , 10:59   Re: Call Admin MySQL
Reply With Quote #30

Quote:
Originally Posted by omer View Post
Can anyone please make this in mysql i dont like sqlx
sqlx is include for scripters, that provides abilities to accesses MySQL server

yaya mysql = sqlx
__________________
The functional way is the right way
GordonFreeman (RU) is offline
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 13:21.


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