Hey guys. So ... my eSports team and me are getting a new homepage. Now we've stumbled upon a few really bad and wrong coded scripts.
Tbh. I really dont understand anything about programming, thats why i am looking for help here.
One of the major problems is, that the ''squads'' section on the main-page isnt working. it basically shows a long code and it is defenitly not working as intended. Go to ( www.lizard-esports.de ) and you can see what i am talking about.
The page is coded with php and is based on the good old webspell.
So, if there is anyone out here, who is interested in helping me, just hit me up and i'll try to provide every single info i can give.
I don't have fg, so donating is not an option eventhough i'd really like to do it. If there are any other favors i can do for you, just lmk.
Thanks in advance,
chris
edit (thats the code which is shown, not sure if it would help that much):
read_module('squads'); $ergebnis=safe_query("SELECT * FROM ".PREFIX."squads WHERE gamesquad = '1' ORDER BY sort"); if(mysql_num_rows($ergebnis)) { $n=1; while($db=mysql_fetch_array($ergebnis)) { if($n%2) { $bg1=BG_1; $bg2=BG_2; } else { $bg1=BG_3; $bg2=BG_4; } $n++; $anzmembers=mysql_num_rows(safe_query("SELECT sqmID FROM ".PREFIX."squads_members WHERE squadID='".$db['squadID']."'")); $anzmembers = $_language->module['members'].': '.$anzmembers; $anzmatches=mysql_num_rows(safe_query("SELECT squad FROM ".PREFIX."clanwars WHERE squad='".$db['squadID']."'")); $anzmatches = ''.$_language->module['results'].': '; if(!empty($db['icon_small'])) $squadicon=''.getinput($db['name']).''; else $squadicon=''; $squadname=getinput($db['name']); $totalHomeScoreSQ=""; $totalOppScoreSQ=""; $drawall=""; $wonall=""; $loseall=""; $squadcws=safe_query("SELECT * FROM ".PREFIX."clanwars WHERE squad='".$db['squadID']."'"); while($squadcwdata=mysql_fetch_array($squadcws)) { // SQUAD CLANWAR STATISTICS // total squad homescore $sqHomeScoreQry=mysql_fetch_array(safe_query("SELECT homescore FROM ".PREFIX."clanwars WHERE cwID='".$squadcwdata['cwID']."' AND squad='".$db['squadID']."'")); $sqHomeScore=array_sum(unserialize($sqHomeScoreQry['homescore'])); $totalHomeScoreSQ+=array_sum(unserialize($sqHomeScoreQry['homescore'])); // total squad oppscore $sqOppScoreQry=mysql_fetch_array(safe_query("SELECT oppscore FROM ".PREFIX."clanwars WHERE cwID='".$squadcwdata['cwID']."' AND squad='".$db['squadID']."'")); $sqOppScore=array_sum(unserialize($sqOppScoreQry['oppscore'])); $totalOppScoreSQ+=array_sum(unserialize($sqOppScoreQry['oppscore'])); // if($sqHomeScore > $sqOppScore) $wonall++; if($sqHomeScore < $sqOppScore) $loseall++; if($sqHomeScore == $sqOppScore) $drawall++; // unset($sqHomeScore); unset($sqOppScore); } if(empty($wonall)) $wonall=0; if(empty($loseall)) $loseall=0; if(empty($drawall)) $drawall=0; echo '
'; eval ("\$sc_squads = \"".gettemplate("sc_squads")."\";"); echo $sc_squads; echo '
This post was edited by skyLove on Jan 7 2015 07:51pm