Raised This Month: $95 Target: $400
 23% 

MySQL little random problems


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
SkiesOFF
Member
Join Date: Mar 2008
Old 06-24-2010 , 23:55   MySQL little random problems
Reply With Quote #1

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 - 133: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
SkiesOFF is offline
vittu
SuperHero Moderator
Join Date: Oct 2004
Location: L.A. County, CA
Old 06-25-2010 , 16:58   Re: MySQL little random problems
Reply With Quote #2

Quote:
Originally Posted by SkiesOFF View Post
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?
vittu is offline
Send a message via AIM to vittu Send a message via MSN to vittu Send a message via Yahoo to vittu
SkiesOFF
Member
Join Date: Mar 2008
Old 06-26-2010 , 12:29   Re: MySQL little random problems
Reply With Quote #3

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?
SkiesOFF is offline
tonyodd
New Member
Join Date: Jul 2010
Location: USA
Old 07-08-2010 , 15:19   Re: MySQL little random problems
Reply With Quote #4

Thanks for your information. It would help a lot.
tonyodd is offline
rodrigo
Senior Member
Join Date: Jul 2010
Location: Brasil
Old 08-11-2010 , 20:34   Re: MySQL little random problems
Reply With Quote #5

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 *************** 
__________________
rodrigo is offline
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 09:22.


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