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

[TF2] Unusual effects 2.19 SQL (21/12/2015)


Post New Thread Reply   
 
Thread Tools Display Modes
MaloModo
Veteran Member
Join Date: Aug 2008
Old 06-24-2015 , 11:08   Re: [TF2] Unusual effects 2.16.1 (01/14/2015)
Reply With Quote #391

Been getting effects "lingering" in map lately....I swear I read something about this but can't find it now. Gets pretty annoying and believe leads to client crashes?
MaloModo is offline
Erreur 500
Senior Member
Join Date: Aug 2012
Location: Paris, France
Old 06-26-2015 , 15:20   Re: [TF2] Unusual effects 2.17 (SQL + taunt)
Reply With Quote #392

////////////////// UPDATE \\\\\\\\\\\\\\\\\\\\\\

v 2.17
Remove native functions :
UE_AddUnusualEffect
UE_IsUnusualItem
UE_GetUnusualItemQuality
UE_GetUnusualItemEffect
UE_GetUnusualItemNumber
Rewriting of database structure:
Now use MySQL or SQLite instead of unusual_effects.txt
unusual_effects.txt is not used and removed
Udapte unusual effects:
Unusual Taunt Effects are now allowed!
Unusual Taunt Effects added in unusual_list.cfg
Cvars Change:
Remove unusual_autoupdate
Remove unusual_controlmod
Add unusual_sql_wait
Rewriting of Admin Tools system:
You can now remove unusual effects from unconnected player in DB.
Some fixes.
Unusual Menu:
New option in delete effect menu, "All" to remove all effects.
Remove updater extension.
Update translation file.
__________________
My public creation : PortalMod - Free Duels - Unusual Effects - Particle fireworks - !stuck

Need private plugin ? We can found an agreement !
Steam : Erreur 500
Erreur 500 is offline
Erreur 500
Senior Member
Join Date: Aug 2012
Location: Paris, France
Old 06-26-2015 , 15:20   Re: [TF2] Unusual effects 2.17 (SQL + taunt)
Reply With Quote #393

UNUSUAL EFFECTS SQL CONVERTER




Description

Use this tool to convert the old Unusual Effects DB system (unusual_effects.txt) to the new system : SQLite or MySQL.




How to use it ?

Put unusual_sql_converter.smx in tf\addons\sourcemod\plugins

If you will use SQLite : You don't have to edit databases.cfg !
If you will use MySQL : Be sure that you have linked Unusual Effects to your new MySQL DB !
To do that : Copy/paste this in sourcemod/configs/databases.cfg. Replace by your own data.
PHP Code:
 
"unusual"
{
            
"driver"                          "mysql"
            "host"                            "YourHost"
            "database"                        "YourDatabaseName"
            "user"                            "Login"
            "pass"                            "PassWord"
           
//"timeout"                        "0"
           //"port"                           "0"


When it's done start your server, and in the console write : unusual_sql_start
THAT IS ALL !

You can remove this tool when conversion is finished !





FAQ :

It's write : "ERROR Conversion STOPPED "
Your DB is corrupted ! If you really want to transfer data in the new DB, you need to fix this problem. Before "ERROR Conversion STOPPED " appear, you have the location of the problem.

Conversion never end !!
That mean you have two time the same player SteamID in it. Remove one occurrence !
Attached Files
File Type: sp Get Plugin or Get Source (unusual_sql_converter.sp - 1078 views - 11.3 KB)
__________________
My public creation : PortalMod - Free Duels - Unusual Effects - Particle fireworks - !stuck

Need private plugin ? We can found an agreement !
Steam : Erreur 500

Last edited by Erreur 500; 07-26-2015 at 11:32.
Erreur 500 is offline
YoNer
Member
Join Date: Jul 2014
Old 06-28-2015 , 16:31   Re: [TF2] Unusual effects 2.17 (SQL + taunt)
Reply With Quote #394

Seems plugin is reseting the weapon loadout constantly in some ocasions, i noticed on my server that the spy keeps drawing out his pistol and is unable to shoot or backstab even
YoNer is offline
rengo
Member
Join Date: Jun 2015
Old 06-28-2015 , 21:52   Re: [TF2] Unusual effects 2.17 (SQL + taunt)
Reply With Quote #395

Quote:
Originally Posted by YoNer View Post
Seems plugin is reseting the weapon loadout constantly in some ocasions, i noticed on my server that the spy keeps drawing out his pistol and is unable to shoot or backstab even
idem

Error log:

Quote:
L 06/28/2015 - 01:48:11: [SM] Displaying call stack trace for plugin "unusual.smx":
L 06/28/2015 - 01:48:11: [SM] [0] Line 355, C:\Serveurs\TF2\steamapps\common\Team Fortress 2 Dedicated Server\tf\addons\sourcemod\scripting\include\ tf2_stocks.inc::TF2_GetPlayerClass()
L 06/28/2015 - 01:48:11: [SM] [1] Line 480, C:\Serveurs\TF2\steamapps\common\Team Fortress 2 Dedicated Server\tf\addons\sourcemod\scripting\unusual. sp::UpdateWeapon()
L 06/28/2015 - 01:48:11: [SM] [2] Line 473, C:\Serveurs\TF2\steamapps\common\Team Fortress 2 Dedicated Server\tf\addons\sourcemod\scripting\unusual. sp::TimerUpdateWeapon()
L 06/28/2015 - 01:48:11: [SM] Native "GetEntProp" reported: Entity 8 ( is invalid
L 06/28/2015 - 01:48:11: [SM] Displaying call stack trace for plugin "unusual.smx":
L 06/28/2015 - 01:48:11: [SM] [0] Line 355, C:\Serveurs\TF2\steamapps\common\Team Fortress 2 Dedicated Server\tf\addons\sourcemod\scripting\include\ tf2_stocks.inc::TF2_GetPlayerClass()
L 06/28/2015 - 01:48:11: [SM] [1] Line 480, C:\Serveurs\TF2\steamapps\common\Team Fortress 2 Dedicated Server\tf\addons\sourcemod\scripting\unusual. sp::UpdateWeapon()
L 06/28/2015 - 01:48:11: [SM] [2] Line 473, C:\Serveurs\TF2\steamapps\common\Team Fortress 2 Dedicated Server\tf\addons\sourcemod\scripting\unusual. sp::TimerUpdateWeapon()
L 06/28/2015 - 02:17:17: Error log file session closed.
Thanks!!!
rengo is offline
Send a message via AIM to rengo
Erreur 500
Senior Member
Join Date: Aug 2012
Location: Paris, France
Old 06-30-2015 , 08:57   Re: [TF2] Unusual effects 2.17.1 (SQL + taunt)
Reply With Quote #396

////////////// UPDATE \\\\\\\\\\\\\\\\\

v 2.17.1
Fix an error which can appear when player item load and client left.
Fix an exploit which allow unusual effects on wearable items.
Remove warning sentence black listed item when item load.
__________________
My public creation : PortalMod - Free Duels - Unusual Effects - Particle fireworks - !stuck

Need private plugin ? We can found an agreement !
Steam : Erreur 500

Last edited by Erreur 500; 06-30-2015 at 08:58.
Erreur 500 is offline
Potato Uno
Veteran Member
Join Date: Jan 2014
Location: Atlanta, Georgia
Old 07-02-2015 , 01:38   Re: [TF2] Unusual effects 2.17.1 (SQL + taunt)
Reply With Quote #397

So is this plugin now "illegal" because the new TF2 update is going to introduce unusual weapons?

(Although it seems like they only work on stock reskins or something, I dunno.)

Quote:
Originally Posted by cool_myll View Post
Valve doesnt like the use of plugins for unusual effects on hats. Weapons is another issue though cause Valve doesnt sell unusual weapons (yet?).

Last edited by Potato Uno; 07-02-2015 at 01:39.
Potato Uno is offline
rengo
Member
Join Date: Jun 2015
Old 07-04-2015 , 13:40   Re: [TF2] Unusual effects 2.17.1 (SQL + taunt)
Reply With Quote #398

Hi, keeps going on, but this time when i switch weapon for example the festive shotgun it bugs, switches weapon quick without letting use the principal weapon and without letting shoot either
rengo is offline
Send a message via AIM to rengo
montassier
Junior Member
Join Date: Jan 2013
Old 07-09-2015 , 01:09   Re: [TF2] Unusual effects 2.17.1 (SQL + taunt)
Reply With Quote #399

after the last update of the valve, my server crash with the following error message when using the unusual plugin: crash in module dbi.sqlite.ext.dll
montassier is offline
Erreur 500
Senior Member
Join Date: Aug 2012
Location: Paris, France
Old 07-10-2015 , 04:42   Re: [TF2] Unusual effects 2.17.1 (SQL + taunt)
Reply With Quote #400

Quote:
Originally Posted by rengo View Post
Hi, keeps going on, but this time when i switch weapon for example the festive shotgun it bugs, switches weapon quick without letting use the principal weapon and without letting shoot either
You must not have this problem if you use my plugin normally (without other mod, and cvar change).
I need more information about mod running on your server, and cVars change.


Quote:
Originally Posted by montassier View Post
after the last update of the valve, my server crash with the following error message when using the unusual plugin: crash in module dbi.sqlite.ext.dll
I can't really help you for that : this is a sourcemod error. The best I can advise you, is to re-install your sourcemod version or upgrade to 1.7.
__________________
My public creation : PortalMod - Free Duels - Unusual Effects - Particle fireworks - !stuck

Need private plugin ? We can found an agreement !
Steam : Erreur 500

Last edited by Erreur 500; 07-10-2015 at 04:43.
Erreur 500 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 15:46.


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