AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Tech Support (https://forums.alliedmods.net/forumdisplay.php?f=36)
-   -   MySQL little random problems (https://forums.alliedmods.net/showthread.php?t=130548)

SkiesOFF 06-24-2010 22:55

MySQL little random problems
 
Hello guys,

I don't know if you guys remember my topic, the one i said that my nvault had some bug and half of players had their level erased.

So i moved my database for mysql and i'm using it since than.

After 3 weeks using it, seems working flawless but i had some little bugs:

-> In this 3 weeks, my MySQL gots something like 3.000 new players registers. Only 3 people got their XP erased for a unknow reason.

-> Some rarely times, my server just pause, after 5 seconds unpases and than pause again (i have to do amx_rcon quit to stop)

-> Strange error log:

Quote:

L 06/24/2010 - 13:33:03: [superheromod.amxx] DEBUG: MySQL connect error: [2005] 'Unknown MySQL server host 'myserver.com' (2)' (myserver.com,myuser,mydb)
my cvars:

sh_xpsavedays 30
sh_endroundsave 0
sh_loadimmediate 0

one question, is good to set this cvar 1?
sh_mysql_persistent 0

vittu 06-25-2010 15:58

Re: MySQL little random problems
 
Quote:

Originally Posted by SkiesOFF (Post 1218990)
one question, is good to set this cvar 1?
sh_mysql_persistent 0

I wouldn't use it, I believe it's bugged a bit. Probably wont save anything.


As for the mysql error, can you use the server's IP instead?

SkiesOFF 06-26-2010 11:29

Re: MySQL little random problems
 
I can't, my host don't give me acess to the IP.

For some security, i didn't put my sql cvars in the shconfig.cfg. I edited the include superheromysql with the cvars.

Can this be a reason?

tonyodd 07-08-2010 14:19

Re: MySQL little random problems
 
Thanks for your information. It would help a lot.

rodrigo 08-11-2010 19:34

Re: MySQL little random problems
 
Does anyone know what this is:
recently switched to MySQL, and yesterday I made up, but today, gone all the XP's! Just got the tables!

My shconfig.cfg

PHP Code:

//********************** SUPERHERO CORE CVARS **********************

//Enables/disables the mod.
//    0 - Disabled
//    1 - Enabled
sv_superheros 1

//Admin flag to determine who can access the important server commands
//Note: With AMXX 1.80 or above this can be modified in cmdaccess.ini
sh_adminaccess m

//Debug Message Level.
//ONLY enable this if you are trying to fix something, it prints A LOT of messages.
//    0 - Disabled
//    1 - Server Print
//    2 - Server Log
//    3 or above - More Messages, Server Log (higher the number the more messages)
sh_debug_messages 0

//Number of heroes allowed with bind characters - after that you must pick non-bind heroes only. (max 9 default)
sh_maxbinds 3

//Max number of powers players can pick from, this is also limited by the number of levels you have.
sh_maxpowers 25

//What level to start newcomers at.
sh_minlevel 1

//Save XP or restart it from 0 each map.
//    0 - Reset XP each map (Short Term)
//    1 - Save XP (Long Term)
sh_savexp 1

//Key used to save players XP data by.
//    0 - Force save by name/nick
//    1 - Auto-detect, save by SteamID or IP if LAN (default)
//    2 - Force save by IP
sh_saveby 1

//How many days a user's XP is saved after the user's last connection.
//Recommended max setting of 30 for VAULT style saving. Max value is 365.
sh_xpsavedays 30
//Minimum number of players required to gain any kind of non-frag XP (ie. objective/mercy XP).
sh_minplayersxp 2

//Default server wide reload mode.
//Used only if the hero is set to use the server's reload mode setting.
//    0 - do nothing, normal cs ammo and reloading functionality
//    1 - continuous shooting, no reload
//    2 - fill the backpack (must reload)
//    3 - drop the gun and get a new one with full clip (not recommended)
sh_reloadmode 1

//Block VIP flags
//    a - block use of +powers (good to stop from nocliping to rescue zone)
//    b - block giving of weapons by heroes
//    c - block max health set by heroes
//    d - block max armor set by heroes
//    e - block max speed set by heroes
//    f - block min gravity set by heroes
//    g - block all extradamage set by heroes (includes powers like lasers)
//    h - custom block setting (some heroes might use this)
sh_blockvip "abcdef"

//Enable this to save XP at end of every round.
//May cause a very small amount of lag at round end with MySQL saving.
//    0 - Disabled
//    1 - Enabled
sh_endroundsave 1

//This cvar sets the value of XP given/taken from players for Hostage / Bomb / VIP events.
//Hostage rescues get sh_objectivexp divided by number of hostages on map, per hostage.
sh_objectivexp 500

//Give new players an average level of XP based on people already playing. (Setting is ignored with Saved XP)
//    0 - Disabled
//    1 - Enabled
sh_autobalance 0

//Load XP right when a player joins (may cause lag with large user database)
//    0 - Disabled
//    1 - Enabled
sh_loadimmediate 0

//MercyXP mode, gives players XP if they did not gain any during a round.
//    0 - MercyXP system Disabled.
//    1 - Give any player a set amount of XP which is set with sh_mercyxp.
//    2 - Give only players up to a certain level MercyXP, max level is set with sh_mercyxp.
//        XP given will be the inverse of the amount they would get for killing
//        someone at their level, then this is divided by 2 to keep it low.
//        So as a players level increases they will get less MercyXP with mode 2.
sh_mercyxpmode 0

//If sh_mercyxpmode = 1: How much Mercy XP to give players
//If sh_mercyxpmode = 2: Max level to give MercyXP to players
sh_mercyxp 0

//Command Projector, displays help info to players in a HUD messages non-stop.
//    0 - Disabled
//    1 - Only show to DEAD players
//    2 - Show to ALL players
sh_cmdprojector 1

//How many highest level heroes can a person pick.
//If this is set to 2 and a client is at level 9,
//they can only pick 2 level 9 heroes max, 3 level 8 heroes max, ect.
//There is a bunch of complicated math that goes into this system and it limits more than
//just the highest level available to that person, try it and see what I mean.
//Set to 0 to disable this limiting of choices
sh_lvllimit 1

//SuperHero Menu mode
//    0 - Old style menu, hides disabled heroes from showing on the menu
//    1 - New style menu, shows disabled heroes grayed out
sh_menumode 1

//Headshot Multiplyer - if you kill someone with a headshot the XP given
//will be multiplied by the value.  Setting this to "1.0" will effectively
//disable it because x * 1.0 = x. Any value less than 1.0 is ignored.
sh_hsmult 1.0

//Can clients drop heroes while alive?
//This is OFF by default because many people expliot the server by picking a hero
//like batman, get the weapons, then drop him.  This will prevent that kind of activity.
sh_alivedrop 0

//Set whether Free For All mode is enabled for team killing. (Only works when friendly fire is on)
//    0 - Lose money, frags, and XP on TK (default)
//    1 - Gain money, frags, and XP on TK
sh_ffa 0

// *** MySQL Settings, Only needed if using the mysql saving method ***
// Uncomment the cvar lines to enable these settings

sh_mysql_host "200.98.197.207"
sh_mysql_user "mylogin"
sh_mysql_pass "mypassword"
sh_mysql_db "redemacmaco_3"
sh_mysql_persistent 0

// *************** END SUPERHERO CORE CVARS *************** 



All times are GMT -4. The time now is 17:01.

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