69 {
70 StringBuilder sb = new StringBuilder();
71 sb.append("INSERT INTO hs_users (");
72 sb.append("id, ");
73 sb.append("username, ");
74 sb.append("rights, ");
75 sb.append("mode, ");
76 sb.append("total_prestiges, ");
77 sb.append("attack_prestiges, ");
78 sb.append("defence_prestiges, ");
79 sb.append("strength_prestiges, ");
80 sb.append("hitpoints_prestiges, ");
81 sb.append("ranged_prestiges, ");
82 sb.append("prayer_prestiges, ");
83 sb.append("magic_prestiges, ");
84 sb.append("cooking_prestiges, ");
85 sb.append("woodcutting_prestiges, ");
86 sb.append("fletching_prestiges, ");
87 sb.append("fishing_prestiges, ");
88 sb.append("firemaking_prestiges, ");
89 sb.append("crafting_prestiges, ");
90 sb.append("smithing_prestiges, ");
91 sb.append("mining_prestiges, ");
92 sb.append("herblore_prestiges, ");
93 sb.append("agility_prestiges, ");
94 sb.append("thieving_prestiges, ");
95 sb.append("slayer_prestiges, ");
96 sb.append("farming_prestiges, ");
97 sb.append("runecrafting_prestiges, ");
98 sb.append("hunter_prestiges, ");
99 sb.append("construction_prestiges,");
100 sb.append("total_level, ");
101 sb.append("overall_xp, ");
102 sb.append("attack_xp, ");
103 sb.append("defence_xp, ");
104 sb.append("strength_xp, ");
105 sb.append("hitpoints_xp, ");
106 sb.append("ranged_xp, ");
107 sb.append("prayer_xp, ");
108 sb.append("magic_xp, ");
109 sb.append("cooking_xp, ");
110 sb.append("woodcutting_xp, ");
111 sb.append("fletching_xp, ");
112 sb.append("fishing_xp, ");
113 sb.append("firemaking_xp, ");
114 sb.append("crafting_xp, ");
115 sb.append("smithing_xp, ");
116 sb.append("mining_xp, ");
117 sb.append("herblore_xp, ");
118 sb.append("agility_xp, ");
119 sb.append("thieving_xp, ");
120 sb.append("slayer_xp, ");
121 sb.append("farming_xp, ");
122 sb.append("runecrafting_xp, ");
123 sb.append("hunter_xp, ");
124 sb.append("construction_xp)");
125 sb.append("VALUES (" +
126 "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, " +
127 "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, " +
128 "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, " +
129 "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, " +
130 "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, " +
131 "?, ?, ?)");
132 return sb.toString();
133 }