Raised This Month: $12 Target: $400
 3% 

Signal PM System - MySQL/SQLite based in-game Private Messaging


Post New Thread Reply   
 
Thread Tools Display Modes
bzellinger
Member
Join Date: Sep 2010
Old 08-12-2011 , 20:40   Re: Signal PM System - MySQL/SQLite based in-game Private Messaging
Reply With Quote #101

For some reason, some of a plugin's cvars need to be put into the server.cfg. The cfg is correct. It now works when i enter the signalpm database into the server.cfg.
bzellinger is offline
Scone
Senior Member
Join Date: Apr 2010
Location: England
Old 08-13-2011 , 07:20   Re: Signal PM System - MySQL/SQLite based in-game Private Messaging
Reply With Quote #102

That's strange, it should have worked if just signal.cfg was edited. Glad to hear it works now though.
__________________
Scone is offline
rautamiekka
Veteran Member
Join Date: Jan 2009
Location: Finland
Old 12-22-2011 , 11:38   Re: Signal PM System - MySQL/SQLite based in-game Private Messaging
Reply With Quote #103

MySQL Workbench: `signal_friends`: table data is not editable because there is no primary key defined for the table.
__________________
Links to posts I received Karma from:
Big thanks to all who gave Karma
rautamiekka is offline
Send a message via ICQ to rautamiekka Send a message via AIM to rautamiekka Send a message via MSN to rautamiekka Send a message via Yahoo to rautamiekka Send a message via Skype™ to rautamiekka
Scone
Senior Member
Join Date: Apr 2010
Location: England
Old 12-22-2011 , 11:51   Re: Signal PM System - MySQL/SQLite based in-game Private Messaging
Reply With Quote #104

Quote:
Originally Posted by rautamiekka View Post
MySQL Workbench: `signal_friends`: table data is not editable because there is no primary key defined for the table.
It sounds like that's a problem with some other piece of software, not the plugin itself. You can probably fix it by changing the 'UNIQUE' index to a primary key for that table.
__________________
Scone is offline
rautamiekka
Veteran Member
Join Date: Jan 2009
Location: Finland
Old 12-22-2011 , 12:49   Re: Signal PM System - MySQL/SQLite based in-game Private Messaging
Reply With Quote #105

These errors occur when using HLSW Console. Nobody gets added.
Code:
19:19:00 pmaddserverfriend "STEAM_0:1:11268321"
19:19:00 L 12/22/2011 - 12:18:57: [SM] Native "IsClientConnected" reported: Client index 0 is invalid
19:19:00 L 12/22/2011 - 12:18:57: [SM] Displaying call stack trace for plugin "signal.smx":
19:19:00 L 12/22/2011 - 12:18:57: [SM]   [0]  Line 2152, /home/groups/alliedmodders/forums/files/7/5/1/7/1/84181.attach::AddFriendDetectName()
19:19:00 L 12/22/2011 - 12:18:57: [SM]   [1]  Line 314, /home/groups/alliedmodders/forums/files/7/5/1/7/1/84181.attach::Command_PmAddServerFriend()
Code:
19:42:36 pmaddserverfriend "STEAM_0:1:26271999"
19:42:36 L 12/22/2011 - 12:42:32: [SM] Native "IsClientConnected" reported: Client index 0 is invalid
19:42:36 L 12/22/2011 - 12:42:32: [SM] Displaying call stack trace for plugin "signal.smx":
19:42:36 L 12/22/2011 - 12:42:32: [SM]   [0]  Line 2152, /home/groups/alliedmodders/forums/files/7/5/1/7/1/84181.attach::AddFriendDetectName()
19:42:36 L 12/22/2011 - 12:42:32: [SM]   [1]  Line 314, /home/groups/alliedmodders/forums/files/7/5/1/7/1/84181.attach::Command_PmAddServerFriend()
This occurs when using RCon in-game. Nobody gets added.
Code:
] rcon pmaddserverfriend "STEAM_0:1:11268321"
[Signal] Usage: pmaddserverfriend "SteamID"
__________________
Links to posts I received Karma from:
Big thanks to all who gave Karma
rautamiekka is offline
Send a message via ICQ to rautamiekka Send a message via AIM to rautamiekka Send a message via MSN to rautamiekka Send a message via Yahoo to rautamiekka Send a message via Skype™ to rautamiekka
Scone
Senior Member
Join Date: Apr 2010
Location: England
Old 12-22-2011 , 16:57   Re: Signal PM System - MySQL/SQLite based in-game Private Messaging
Reply With Quote #106

Updated to version 1.4.2, attached to original post:
- Fixed problems with client 0 (console) running pmaddserverfriend
- All MySQL tables now use primary keys instead of unique keys by default
- Removed invalid char from received message view
That should hopefully fix the problem, please let me know if you spot any more bugs.
__________________
Scone is offline
rautamiekka
Veteran Member
Join Date: Jan 2009
Location: Finland
Old 12-23-2011 , 07:28   Re: Signal PM System - MySQL/SQLite based in-game Private Messaging
Reply With Quote #107

Quote:
Originally Posted by Scone View Post
Updated to version 1.4.2, attached to original post:
- Fixed problems with client 0 (console) running pmaddserverfriend
- All MySQL tables now use primary keys instead of unique keys by default
- Removed invalid char from received message view
That 3rd error, given below, still occurs. Since it occurs with any command requiring same syntax, Valve must've changed things so that a double quote breaks the command into like §"rcon pmaddserverfriend "STEAM_0:1:11268321""§ where the second quote acts as the delimiter; HLSW must be auto-escaping the quotes, since there is no problemo.
Code:
] rcon pmaddserverfriend "STEAM_0:1:11268321"
[Signal] Usage: pmaddserverfriend "SteamID"
__________________
Links to posts I received Karma from:
Big thanks to all who gave Karma
rautamiekka is offline
Send a message via ICQ to rautamiekka Send a message via AIM to rautamiekka Send a message via MSN to rautamiekka Send a message via Yahoo to rautamiekka Send a message via Skype™ to rautamiekka
Scone
Senior Member
Join Date: Apr 2010
Location: England
Old 12-23-2011 , 07:39   Re: Signal PM System - MySQL/SQLite based in-game Private Messaging
Reply With Quote #108

I'll update the plugin if you want, but you don't actually need RCON to run that command - you can do it directly with root admin.
__________________
Scone is offline
rautamiekka
Veteran Member
Join Date: Jan 2009
Location: Finland
Old 12-24-2011 , 05:13   Re: Signal PM System - MySQL/SQLite based in-game Private Messaging
Reply With Quote #109

Quote:
Originally Posted by Scone View Post
I'll update the plugin if you want, but you don't actually need RCON to run that command - you can do it directly with root admin.
Doesn't depend on whether I want.
__________________
Links to posts I received Karma from:
Big thanks to all who gave Karma
rautamiekka is offline
Send a message via ICQ to rautamiekka Send a message via AIM to rautamiekka Send a message via MSN to rautamiekka Send a message via Yahoo to rautamiekka Send a message via Skype™ to rautamiekka
Scone
Senior Member
Join Date: Apr 2010
Location: England
Old 12-24-2011 , 08:08   Re: Signal PM System - MySQL/SQLite based in-game Private Messaging
Reply With Quote #110

Quote:
Originally Posted by rautamiekka View Post
Doesn't depend on whether I want.
What I'm saying is that, if for some reason you need to access that command through rcon in game, I'd be happy to post a new version of the plugin for you. But otherwise, since you can run the command just by typing it in the console, I don't consider this a bug.

Basically, just type:

Code:
pmaddserverfriend "STEAM_0:0:XXXXX"
Instead of:

Code:
rcon pmaddserverfriend "STEAM_0:0:XXXXX"
__________________
Scone 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 17:16.


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