aJE8mVWr

1    /**
2     * Insert a strife to a clan
3     * @param attackerclan
4     * @param victimclan
5     */
6    public void insertStrife(Clan attackerclan, Clan victimclan, Integer amount)
7    {
8        String query = "INSERT INTO `sc_war`(`attacker_clan`, `victim_clan`, `strifes`)";
9        String values = "VALUES ( " + attackerclan.getTag() + ",'" + victimclan.getTag() + "','" + (retrieveStrifes(attackerclan, victimclan) + amount) + "');";
10        core.insert(query + values);
11    }
12
13    /**
14     * Retrieves the strifes relativ to another clan
15     * @param attackerclan
16     * @param victimclan
17     * @return
18     */
19    public Integer retrieveStrifes(Clan attackerclan, Clan victimclan)
20    {
21        String query = "SELECT * FROM  `sc_war`;";
22        ResultSet res = core.select(query);
23        
24        if (res != null)
25        {
26            try
27            {
28                while (res.next())
29                {
30                    try
31                    {
32                        String attacker = res.getString("attacker_clan");
33                        String victim = res.getString("victim_clan");
34                        int strifes = res.getInt("strifes");
35                        
36                        if (attacker.equals(attackerclan.getTag()) && victim.equals(victimclan.getTag())) {
37                            return strifes;
38                        }
39
40                    }
41                    catch (Exception ex)
42                    {
43                        for (StackTraceElement el : ex.getStackTrace())
44                        {
45                            System.out.print(el.toString());
46                        }
47                    }
48                }
49            }
50            catch (SQLException ex)
51            {
52                for (StackTraceElement el : ex.getStackTrace())
53                {
54                    System.out.print(el.toString());
55                }
56            }
57        }
58        return 0;
59    }
60
61-------------------------
62
63                if (!core.existsTable("sc_war"))
64                {
65                    SimpleClans.log("Creating table: sc_kills");
66
67                    String query = "CREATE TABLE IF NOT EXISTS `sc_war` ( `id` bigint(20) NOT NULL auto_increment, `attacker_clan` varchar(16) NOT NULL, `victim_clan` varchar(16) NOT NULL, `strifes` varchar(16) NOT NULL, PRIMARY KEY  (`id`));";
68                    core.execute(query);
69                }