Raised This Month: $ Target: $400
 0% 

Call Admin MySQL


Post New Thread Reply   
 
Thread Tools Display Modes
Plugin Info:     Modification:   Counter-Strike        Category:   General Purpose       
xakintosh
I run no-steam servers!
Join Date: Feb 2010
Location: Edge of nowhere
Old 12-31-2010 , 03:45   Call Admin MySQL
Reply With Quote #1

[img]http://img525.**************/img525/8720/descriptionz.png[/img]
When user say in chat /calladmin Player with speedhack, his message will save with sqlx on table and will show in the php part

/calladmin -- bring up players menu, when you pick the player who's cheating, when you select the cheater just type the reason

/calladmin " " (nothing) will lead to nowhere xD

/calladmin Please admin to join the server! - Will send the message to mysql instantly !

Plugin created by me ( IMBA ) with the idea of ( carbonated ), he is the creator of php part

To do: Multi Server Chat System, Facebook Chat

[img]http://img19.**************/img19/4402/settingsqd.png[/img]
Code:
Need // Steam
Code:
#include <sqlx> // Needed for MySql Connection... #include <colorchat>
Code:
#define szHost  "127.0.0.1" #define szUser  "root" #define szPass  "pass" #define szDb    "test" // your choise
Code:
ca_prefix "AMXX" // This is the Prefix show in chat ca_showmsg "1" // 1.Message to All // 2.Message to only who send it // 3.Message to admins only // 4.Without message

Create database manually named test(your choise) in phpmyadmin (after starting the server will be automatically added tables, etc.)

For web part:
Adjusts easily from the file config.php. For using in your website, include file index.php (can rename it as you want by)
Code:
include "./folder_where_is_it/index.php";

[img]http://img19.**************/img19/4107/snapshots.png[/img]






Code:
1.0 - first version of plugin
2.0 - added Reasons/Players menu support, check for nomessage, steam check, new option in ca_showmsg, i try to fix everything was told me here click
3.0 - Remove Reasons menu and improved Players menu, the check spelling system is update
Attached Files
File Type: zip Call Admin WEB 1.0.zip (2.6 KB, 2293 views)
File Type: sma Get Plugin or Get Source (calladmin.sma - 3874 views - 6.4 KB)

Last edited by xakintosh; 05-26-2013 at 09:31.
xakintosh is offline
Send a message via Yahoo to xakintosh Send a message via Skype™ to xakintosh
zeus
Senior Member
Join Date: Jul 2008
Old 12-31-2010 , 05:57   Re: Call Admin MySQL
Reply With Quote #2

This is good a ideea, i like it
zeus is offline
t3hNox
Senior Member
Join Date: Oct 2009
Old 12-31-2010 , 07:04   Re: Call Admin MySQL
Reply With Quote #3

Definitely useful. GJ
t3hNox is offline
TzK
Member
Join Date: Apr 2010
Old 12-31-2010 , 17:43   Re: Call Admin MySQL
Reply With Quote #4

Good
Maybe you can make, that users can`t call without reasons or maybe if they write /calladmin then open menu with reasons?
TzK is offline
Send a message via Skype™ to TzK
Nextra
Veteran Member
Join Date: Apr 2008
Location: Germany
Old 12-31-2010 , 22:16   Re: Call Admin MySQL
Reply With Quote #5

Design Suggestions:
- SteamId support please. This is a must.

Code Suggestions:
- Check equali directly. You are calling a lot of natives that you won't need most of the time.
- Remove the empty cases from the switch statements.
- You need to escape the nickname and hostname before saving it into the database.
- Most of the MySQL fields are too large.
- You have a global QueryCache variable, use it in HookSay
- Use formatex where applicable.
- You can do switch(get_pcvar_num(xy)) directly.
- You should declare the szText variable static. A say handle will be called quite frequently.
- Is there a particular reason you are not allowing say_team?
__________________
In Flames we trust!
Nextra is offline
s3rserii
Senior Member
Join Date: Jan 2010
Old 01-01-2011 , 12:25   Re: Call Admin MySQL
Reply With Quote #6

it show the first message..


onyl for admins on all server where this plugin is running?

if no is tha a great idea for a update..

if player call a admin on Server1 the the Admins on Server 1,2,3,4 can see the message as a HUD.

is that possible?
s3rserii is offline
xakintosh
I run no-steam servers!
Join Date: Feb 2010
Location: Edge of nowhere
Old 01-01-2011 , 12:51   Re: Call Admin MySQL
Reply With Quote #7

Quote:
Originally Posted by s3rserii View Post
it show the first message..

onyl for admins on all server where this plugin is running?
if no is tha a great idea for a update..
if player call a admin on Server1 the the Admins on Server 1,2,3,4 can see the message as a HUD.
is that possible?
Maybe with sockets it is possible, but i don't know.
I will update soon. Stay posted ;]
__________________
As soon as possible.

Last edited by xakintosh; 01-01-2011 at 13:03.
xakintosh is offline
Send a message via Yahoo to xakintosh Send a message via Skype™ to xakintosh
s3rserii
Senior Member
Join Date: Jan 2010
Old 01-01-2011 , 13:02   Re: Call Admin MySQL
Reply With Quote #8

Quote:
Originally Posted by xakintosh View Post
Maybe with sockets i will update soon. Stay posted ;]
yeah u are the beste thx
s3rserii is offline
Nextra
Veteran Member
Join Date: Apr 2008
Location: Germany
Old 01-01-2011 , 14:16   Re: Call Admin MySQL
Reply With Quote #9

Quote:
Originally Posted by xakintosh View Post
Maybe with sockets it is possible, but i don't know.
I will update soon. Stay posted ;]
It is possible. Look at Cross Server Admin Chat by koST for a way to achieve this.
__________________
In Flames we trust!
Nextra is offline
xakintosh
I run no-steam servers!
Join Date: Feb 2010
Location: Edge of nowhere
Old 01-01-2011 , 14:53   Re: Call Admin MySQL
Reply With Quote #10

New version is here, and a happy new year xD
@Nextra i try to do everything you told me, thanks! I hope I've done it correctly >
If anyone can help i have some issue with empty message http://forums.alliedmods.net/showthread.php?t=146790
__________________
As soon as possible.

Last edited by xakintosh; 01-01-2011 at 15:01.
xakintosh is offline
Send a message via Yahoo to xakintosh Send a message via Skype™ to xakintosh
Reply


Thread Tools
Display Modes

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 11:36.


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