[sweede]

Originally Posted by Action-N

I see you figured it out. Is it a simple edit you can share? Thanks

umm..

open up includes/cron/cron.gwowrocster.guildinfo.php and fine the lines..

PHP Code:

                    $rosterinfo_query = "
                        locale = '" . $guild_info['guildKey']['locale'] . "' ,
                        realm = '" . addslashes($guild_info['guildKey']['realm']) . "' ,
                        name = '" . addslashes($guild_info['guildKey']['name']) . "' ,
                        charname = '" . addslashes($character['name']) . "' ,
                        level = '" . $character['level'] . "' ,
                        class = '" . $character['class'] . "' ,
                        classid = '" . $character['classId'] . "' ,
                        gender = '" . $character['gender'] . "' ,
                        genderid = '" . $character['genderId'] . "' ,
                        race = '" . $character['race'] . "' ,
                        raceid = '" . $character['raceId'] . "' ,
                        rank = '" . $character['rank'] . "' ,
                        charurl = '" . $character['url'] . "' ,
                    ";

                    // INSERT GUILD ROSTER
                    if(trim($guild_info['guildKey']['realm']) != '' && trim($guild_info['guildKey']['name']) != '' && trim($guild_info['guildKey']['locale']) != '')
                    {
                        $vbulletin->db->query("REPLACE INTO " . TABLE_PREFIX . "gwowroster_rosterinfo SET " . $rosterinfo_query . " updated = '" . TIMENOW . "'");

                        // INSERT HISTORICAL ENTRY
                        if($vbulletin->options['gwr_guildhistory'])
                        {
                            $vbulletin->db->query("REPLACE INTO " . TABLE_PREFIX . "gwowroster_hist_rosterinfo SET " . $rosterinfo_query . " date = '" . $histdate . "'");
                        }

                        $delete['charname'] .= "'" . addslashes($character['name']) . "',";
                    } 


(around line 83)

Add

PHP Code:

                    if($character['level'] == 70)
                    { 


before the block and add a single } after the block.

It will look like

PHP Code:

if($character['level'] == 70)
                    {
                        $rosterinfo_query = "
                            locale = '" . $guild_info['guildKey']['locale'] . "' ,
                            realm = '" . addslashes($guild_info['guildKey']['realm']) . "' ,
                            name = '" . addslashes($guild_info['guildKey']['name']) . "' ,
                            charname = '" . addslashes($character['name']) . "' ,
                            level = '" . $character['level'] . "' ,
                            class = '" . $character['class'] . "' ,
                            classid = '" . $character['classId'] . "' ,
                            gender = '" . $character['gender'] . "' ,
                            genderid = '" . $character['genderId'] . "' ,
                            race = '" . $character['race'] . "' ,
                            raceid = '" . $character['raceId'] . "' ,
                            rank = '" . $character['rank'] . "' ,
                            charurl = '" . $character['url'] . "' ,
                        ";

                        // INSERT GUILD ROSTER
                        if(trim($guild_info['guildKey']['realm']) != '' && trim($guild_info['guildKey']['name']) != '' && trim($guild_info['guildKey']['locale']) != '')
                        {
                            $vbulletin->db->query("REPLACE INTO " . TABLE_PREFIX . "gwowroster_rosterinfo SET " . $rosterinfo_query . " updated = '" . TIMENOW . "'");
    
                            // INSERT HISTORICAL ENTRY
                            if($vbulletin->options['gwr_guildhistory'])
                            {
                                $vbulletin->db->query("REPLACE INTO " . TABLE_PREFIX . "gwowroster_hist_rosterinfo SET " . $rosterinfo_query . " date = '" . $histdate . "'");
                            }
    
                            $delete['charname'] .= "'" . addslashes($character['name']) . "',";
                        }
                    }