Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
Reload this Page Excessive System Resource Issue
FAQ Community Calendar Today's Posts Search

Reply
Page 2 of 3 1 2 3
 
Thread Tools
Excessive System Resource Issue Details »»
Excessive System Resource Issue
Version: , by ChrisTech ChrisTech is offline
Developer Last Online: Jun 2020 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 10-16-2006 Last Update: Never Installs: 0
 
No support by the author.

I had my domain recently (today) suspended for high system resource usage due to page views on the forums continually running over 150 MySQL queries each.

Since disabling IBPro Arcade, the high queries went down. Is there any known issue for this to be happening where it queries, what looks like all the high scores from each game?

I have the arcade disabled for now, but if I cannot find a solution to the issue I won't be able to run the mod any longer (on shared hosting). And unfortunally a dedicated isn't an option now (funds-wise).

Any thoughts or ideas here?


Code:
65 Connect     username_vb@localhost on
65 Init DB     username_vbforums
                     65 Query       SELECT arcade_access, p_require FROM vb_usergroup WHERE usergroupid = 1
                     65 Query       SELECT * FROM vb_games_settings
                     65 Query       SELECT m.userid, m.username, m.posts, m.arcade_ban, m.times_played, m.is_arcade_mod AS is_mod,
                     65 Query       SELECT arcade_access, p_require FROM vb_usergroup WHERE usergroupid = 1
                     65 Query       DELETE FROM vb_games_scores WHERE datescored<1158342408
                     65 Query       DELETE FROM vb_games_champs
                     65 Query       SELECT gid, highscore_type, gtitle FROM vb_games_list  ORDER by gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('127','Archery','1940','Gillbert','1159575977','1322')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('100','Asteroids','1','VampYre','1159407981','1430')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('212','Ball Bounce','1940','Gillbert','1160066359','3859')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('205','Ballthrow','74','sick','1160920582','866.6')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('204','Battleship','74','sick','1159670959','4630')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('160','Bejeweled','9','hunnybear','1160574231','2974')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('152','Billards','74','sick','1159417139','6298')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('154','Bingo','1','VampYre','1159493765','6499')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('193','Bloody Orca Slap','74','sick','1160275886','3470')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('103','Bloody Pingu','74','sick','1159705365','1095')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('215','canyonglider','1','VampYre','1160861085','6080')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('142','Casino Blackjack','95','chooks','1159778978','2500')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('187','Cat Batting','82','Apathetic','1159572252','7194')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('129','Cat Bowling','95','chooks','1160891656','100')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('128','Cat-Vac','9','hunnybear','1159565199','3243')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('101','Chopper Challenge','74','sick','1160274029','516')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('216','Chopper Chase','74','sick','1160186698','675')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('202','Collapse','278','jturbo941','1160881166','2905')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('218','Cow Tipping','2288','ScottSAA','1160776271','55')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('188','Cunning Stunt','2288','ScottSAA','1160789844','1497.2')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('118','Curveball','82','Apathetic','1159663667','28415')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('223','Dance Mat','82','Apathetic','1160306165','46')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('221','Dangerous Fishing','2288','ScottSAA','1160718004','1350')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('224','Dare Level','2288','ScottSAA','1160791312','45')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('117','Defend Your Castle','2288','ScottSAA','1160717649','62260')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('217','Desert Battle','74','sick','1160274404','10')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('176','Dirt Bike 2','74','sick','1159629168','1851')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('190','Disco Racer','82','Apathetic','1159594081','4300')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('201','Dolphin Olympics','74','sick','1159718533','274324')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('148','Doom','82','Apathetic','1159572767','101')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('125','Duck Hunt','1940','Gillbert','1160671194','54000')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('143','Fight Man','2288','ScottSAA','1160696399','63400')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('179','Fire Fighter','2288','ScottSAA','1160775488','17130')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('192','Flash Poker','82','Apathetic','1159593265','96')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('199','Gold Miner','95','chooks','1160187433','16879')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('209','Gold Miner Special Edition','1','VampYre','1159667451','23320')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('144','Heli Attack 2','95','chooks','1159416417','7360')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('210','High Wheels','1','VampYre','1159655358','85')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('189','Highway Hunter','82','Apathetic','1159571337','10200')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('120','Home Run Rally','74','sick','1159417600','16')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('157','Ice Age 2: Rising Water','9','hunnybear','1159565900','2475')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('159','Ice Age 4: Ptero Glide','1','VampYre','1159415780','19063')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('198','Ice Age Part 1 - Scrat Jump - Level 2','1','VampYre','1159667831','263.14')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('207','J-Ball','1','VampYre','1160372686','21611')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('150','Kill Stick Figures','2288','ScottSAA','1160718280','3510')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('133','King of the Hill','74','sick','1160277143','37')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('132','Kitten Cannon','74','sick','1159628328','3244')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('161','Knife Throw 2','1','VampYre','1160372792','3000')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('186','Lightning Break','1','VampYre','1160462058','6891')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('163','Lightning Pool','1','VampYre','1159507842','14335')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('121','Mahjong.','3','Rain','1160027137','1320')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('184','Mahjongg Solitaire','3','Rain','1159414174','44090')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('168','Nanaca Crash','1','VampYre','1159718501','3579.84')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('122','Pacman','82','Apathetic','1159670877','8490')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('203','Panda Bounce','74','sick','1159669696','18820')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('222','Parking Zone','74','sick','1160170137','360')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('102','Penguin Bashing','74','sick','1159644000','3172')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('112','Pingu Slap','74','sick','1159704998','479')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('214','Puzzle Express','1','VampYre','1160200375','196485')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('170','Raiden X','1940','Gillbert','1159576812','693400')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('208','Rapid Fire','74','sick','1160276466','4378')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('200','Rumble Ball: Field num.2','1','VampYre','1160027984','21950')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('211','Saints and Sinners Bingo','1','VampYre','1159655899','811')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('165','Shark Attack','74','sick','1159910584','978')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('180','Shoot the Sky.','82','Apathetic','1159571909','15933')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('99','Snake','74','sick','1159628779','1554')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('98','Space Invaders','95','chooks','1159787708','15960')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('105','spankthemonkey','1','VampYre','1160626567','729')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('96','Tetris','6380','EvilKevin','1159610127','32097')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('206','Throw It','74','sick','1159718092','146600')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('166','Tower Defence','74','sick','1160276712','3808')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('146','Tuer Tuer Tuer','74','sick','1159578362','2455')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('178','Ultimate Greed Poker Slingo','82','Apathetic','1159592353','36500')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('131','Yahtzee','82','Apathetic','1159572109','275')
                     65 Query       INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('104','Yeti Sports 1.5','74','sick','1159628067','1322')
                     65 Query       SELECT arcade_language FROM vb_games_settings

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 10-24-2006, 09:17 AM
TheBlackPoet's Avatar
TheBlackPoet TheBlackPoet is offline
 
Join Date: May 2006
Location: Pasadena, Texas, USA
Posts: 577
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
my host suspended me for using 20% of server resources a couple of times.. i didnt have maybe but a coupld in the games area.... and i couldnt understand what the hell was going on..
reading this thread, i'll be going back and looking at my on cron...
Reply With Quote
  #13  
Old 10-24-2006, 11:08 AM
scdurwood scdurwood is offline
 
Join Date: Aug 2006
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by MrZeropage
I should do a setting in AdminCP to disable the league-system, this will reduce all those score-calculation-related things ... hmmmmm
what about making it an option to run on command instead of an automated process?

There's no need to update the ranking per game played anyways...

Better yet, can you make it a configurable timeframe in the ACP? In other words, each admin can choose the number of seconds between each calculation...

For the time being, can the function call be disabled without upsetting the "normal" usage of the arcade and if so, what code would I look for?
Reply With Quote
  #14  
Old 10-24-2006, 05:46 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Ok, I just improved the logic and the performance for the league-stuff and it now definitive has much less queries while saving a result
Reply With Quote
  #15  
Old 10-24-2006, 10:50 PM
scdurwood scdurwood is offline
 
Join Date: Aug 2006
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Is this a wait for the testing to be done sort of fix?
Reply With Quote
  #16  
Old 10-25-2006, 12:43 AM
Mark.B Mark.B is offline
Senior Member
  
Join Date: Feb 2004
Posts: 1,354
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by scdurwood
what about making it an option to run on command instead of an automated process?

There's no need to update the ranking per game played anyways...

Better yet, can you make it a configurable timeframe in the ACP? In other words, each admin can choose the number of seconds between each calculation...

For the time being, can the function call be disabled without upsetting the "normal" usage of the arcade and if so, what code would I look for?
I could do with this as well Mr Zeropage sir, if you would be so kind.

I don't use the league at all, and I don't mind editing files to disable it. I have 472 games and score submission takes an age because of this.
Reply With Quote
  #17  
Old 10-25-2006, 07:13 AM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
score-submission will be quick with v2.5.7+ I just cleaned up that code
Reply With Quote
  #18  
Old 10-25-2006, 09:48 AM
Mark.B Mark.B is offline
Senior Member
  
Join Date: Feb 2004
Posts: 1,354
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by MrZeropage
score-submission will be quick with v2.5.7+ I just cleaned up that code
Thank you Mr Zeropage. Great work!

Any chance of a "patch" of this for those of us on earlier versions for whom upgrading is not currently possible?
Reply With Quote
  #19  
Old 10-25-2006, 10:27 AM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
this is kinda difficult as alot got changed, concerning the league it was somehow completely solved in another way.

Maybe you wait for v2.5.7+ and then compare all the files using "beyond compare" or any other tool, but best way is to always use the current release
Reply With Quote
  #20  
Old 10-25-2006, 07:53 PM
icemanic icemanic is offline
 
Join Date: Jun 2006
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
ITS SO CLOSE!!!!

99.98% DONE!!!!!!
I CANT WAIT!!!!!!!

im drooling more and more every day!
Reply With Quote
  #21  
Old 10-26-2006, 12:25 AM
Mark.B Mark.B is offline
Senior Member
  
Join Date: Feb 2004
Posts: 1,354
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by MrZeropage
this is kinda difficult as alot got changed, concerning the league it was somehow completely solved in another way.

Maybe you wait for v2.5.7+ and then compare all the files using "beyond compare" or any other tool, but best way is to always use the current release
Thanks Mr Z.

I do want to upgrade at some point, it is very hard for me though due to running both arcades on the same forum...I have to update all references to "arcade" and change it to "ibproarcade" so it doesn't clash with v3arcade. On top of that it's quite heavily customised skinwise.

(I should mention, before anyone points it out, that I'm aware there is no technical reason these days to run both arcades as the games interchange, however I like doing it!!)
Reply With Quote
Reply
Page 2 of 3 1 2 3

« Previous Thread | Next Thread »

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. The time now is 04:20 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04491 seconds
  • Memory Usage 2,355KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete