DELIMITER |
CREATE TRIGGER `oncreate_players`
AFTER INSERT
ON `players`
FOR EACH ROW
BEGIN
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END|
DELIMITER ;
Edit Delete 27381 297 298 2001 1 [BLOB - 0B]
Edit Delete 27381 296 297 2001 1 [BLOB - 0B]
Edit Delete 27381 295 296 2001 1 [BLOB - 0B]
Edit Delete 27381 294 295 2001 1 [BLOB - 0B]
Edit Delete 27381 292 294 2001 1 [BLOB - 0B]
Edit Delete 27381 292 293 2408 1 [BLOB - 0B]
Edit Delete 27381 272 292 2001 1 [BLOB - 0B]
Edit Delete 27381 272 291 7590 1 [BLOB - 0B]
Edit Delete 27381 272 290 7590 1 [BLOB - 0B]
Edit Delete 27381 272 289 7590 1 [BLOB - 0B]
Edit Delete 27381 272 288 7590 1 [BLOB - 0B]
Edit Delete 27381 272 287 7590 1 [BLOB - 0B]
Edit Delete 27381 272 285 2352 1 [BLOB - 0B]
Edit Delete 27381 272 286 7885 1 [BLOB - 0B]
Edit Delete 27381 272 284 9970 100 [BLOB - 2B]
Edit Delete 27381 272 283 9970 100 [BLOB - 2B]
Edit Delete 27381 272 282 9970 100 [BLOB - 2B]
Edit Delete 27381 272 281 2196 1 [BLOB - 0B]
Edit Delete 27381 272 280 2196 1 [BLOB - 0B]
Edit Delete 27381 272 279 8884 1 [BLOB - 0B]
Edit Delete 27381 272 278 8884 1 [BLOB - 0B]
Edit Delete 27381 272 277 2352 1 [BLOB - 0B]
Edit Delete 27381 272 276 8922 1 [BLOB - 0B]
Edit Delete 27381 272 275 8851 1 [BLOB - 0B]
Edit Delete 27381 272 274 8910 1 [BLOB - 0B]
Edit Delete 27381 272 273 2139 1 [BLOB - 0B]
Edit Delete 27381 233 272 2001 1 [BLOB - 0B]
Edit Delete 27381 233 271 7590 1 [BLOB - 0B]
Edit Delete 27381 233 270 7590 1 [BLOB - 0B]
Edit Delete 27381 233 269 7590 1 [BLOB - 0B]
Edit Delete 27381 233 268 7590 1 [BLOB - 0B]
Edit Delete 27381 233 267 7590 1 [BLOB - 0B]
Edit Delete 27381 233 266 7590 1 [BLOB - 0B]
Edit Delete 27381 233 264 7590 1 [BLOB - 0B]
Edit Delete 27381 233 265 7590 1 [BLOB - 0B]
Edit Delete 27381 233 263 7590 1 [BLOB - 0B]
Edit Delete 27381 233 262 7590 1 [BLOB - 0B]
Edit Delete 27381 233 261 7590 1 [BLOB - 0B]
Edit Delete 27381 233 260 7590 1 [BLOB - 0B]
Edit Delete 27381 233 259 7590 1 [BLOB - 0B]
Edit Delete 27381 233 258 7590 1 [BLOB - 0B]
Edit Delete 27381 233 257 7590 1 [BLOB - 0B]
Edit Delete 27381 233 256 7590 1 [BLOB - 0B]
Edit Delete 27381 233 255 7590 1 [BLOB - 0B]
Edit Delete 27381 233 254 7590 1 [BLOB - 0B]
Edit Delete 27381 233 253 7590 1 [BLOB - 0B]
Edit Delete 27381 232 252 7590 1 [BLOB - 0B]
Edit Delete 27381 232 251 7590 1 [BLOB - 0B]
Edit Delete 27381 232 250 7590 1 [BLOB - 0B]
Edit Delete 27381 232 249 7590 1 [BLOB - 0B]
Edit Delete 27381 232 248 7590 1 [BLOB - 0B]
Edit Delete 27381 232 247 7590 1 [BLOB - 0B]
Edit Delete 27381 232 246 7590 1 [BLOB - 0B]
Edit Delete 27381 232 245 7590 1 [BLOB - 0B]
Edit Delete 27381 232 244 7590 1 [BLOB - 0B]
Edit Delete 27381 232 243 7590 1 [BLOB - 0B]
Edit Delete 27381 232 242 7590 1 [BLOB - 0B]
Edit Delete 27381 232 241 7590 1 [BLOB - 0B]
Edit Delete 27381 232 240 7590 1 [BLOB - 0B]
Edit Delete 27381 232 239 7590 1 [BLOB - 0B]
Edit Delete 27381 232 238 7590 1 [BLOB - 0B]
Edit Delete 27381 232 237 7590 1 [BLOB - 0B]
Edit Delete 27381 232 236 7590 1 [BLOB - 0B]
Edit Delete 27381 232 235 7590 1 [BLOB - 0B]
Edit Delete 27381 232 234 7590 1 [BLOB - 0B]
Edit Delete 27381 232 233 2001 1 [BLOB - 0B]
Edit Delete 27381 212 232 2001 1 [BLOB - 0B]
Edit Delete 27381 212 230 7590 1 [BLOB - 0B]
Edit Delete 27381 212 231 7590 1 [BLOB - 0B]
Edit Delete 27381 212 229 7590 1 [BLOB - 0B]
Edit Delete 27381 212 228 7590 1 [BLOB - 0B]
Edit Delete 27381 212 227 7590 1 [BLOB - 0B]
Edit Delete 27381 212 226 7590 1 [BLOB - 0B]
Edit Delete 27381 212 225 7590 1 [BLOB - 0B]
Edit Delete 27381 212 224 7590 1 [BLOB - 0B]
Edit Delete 27381 212 223 7590 1 [BLOB - 0B]
Edit Delete 27381 212 222 7590 1 [BLOB - 0B]
Edit Delete 27381 212 221 7590 1 [BLOB - 0B]
Edit Delete 27381 212 220 7590 1 [BLOB - 0B]
Edit Delete 27381 212 219 7590 1 [BLOB - 0B]
Edit Delete 27381 212 218 7590 1 [BLOB - 0B]
Edit Delete 27381 212 217 7590 1 [BLOB - 0B]
Edit Delete 27381 212 216 7590 1 [BLOB - 0B]
Edit Delete 27381 212 215 7590 1 [BLOB - 0B]
Edit Delete 27381 212 214 7590 1 [BLOB - 0B]
Edit Delete 27381 212 213 7590 1 [BLOB - 0B]
Edit Delete 27381 192 212 2001 1 [BLOB - 0B]
Edit Delete 27381 192 211 7590 1 [BLOB - 0B]
Edit Delete 27381 192 210 7590 1 [BLOB - 0B]
Edit Delete 27381 192 209 7590 1 [BLOB - 0B]
Edit Delete 27381 192 208 7590 1 [BLOB - 0B]
Edit Delete 27381 192 207 7590 1 [BLOB - 0B]
Edit Delete 27381 192 206 7590 1 [BLOB - 0B]
Edit Delete 27381 192 205 7590 1 [BLOB - 0B]
Edit Delete 27381 192 204 7590 1 [BLOB - 0B]
Edit Delete 27381 192 203 7435 1 [BLOB - 0B]
Edit Delete 27381 192 202 2139 1 [BLOB - 0B]
Edit Delete 27381 192 201 2408 1 [BLOB - 0B]
Edit Delete 27381 192 200 2644 1 [BLOB - 7B]
Edit Delete 27381 192 199 7895 1 [BLOB - 0B]
player_id pid sid itemtype count attributes
Edit Delete 27381 192 198 8878 1 [BLOB - 0B]
Edit Delete 27381 192 197 8851 1 [BLOB - 0B]
Edit Delete 27381 192 196 2196 1 [BLOB - 0B]
Edit Delete 27381 192 195 8869 1 [BLOB - 0B]
Edit Delete 27381 192 194 7697 1 [BLOB - 3B]
Edit Delete 27381 192 193 7460 1 [BLOB - 0B]
Edit Delete 27381 177 192 2001 1 [BLOB - 0B]
Edit Delete 27381 177 191 7590 1 [BLOB - 0B]
Edit Delete 27381 177 190 7590 1 [BLOB - 0B]
Edit Delete 27381 177 189 7590 1 [BLOB - 0B]
Edit Delete 27381 177 188 7590 1 [BLOB - 0B]
Edit Delete 27381 177 187 7590 1 [BLOB - 0B]
Edit Delete 27381 177 186 7590 1 [BLOB - 0B]
Edit Delete 27381 177 185 7590 1 [BLOB - 0B]
Edit Delete 27381 177 184 7590 1 [BLOB - 0B]
Edit Delete 27381 177 183 7590 1 [BLOB - 0B]
Edit Delete 27381 177 182 7590 1 [BLOB - 0B]
Edit Delete 27381 177 181 7886 1 [BLOB - 0B]
Edit Delete 27381 177 180 2352 1 [BLOB - 0B]
Edit Delete 27381 177 179 7895 1 [BLOB - 0B]
Edit Delete 27381 177 178 7435 1 [BLOB - 0B]
Edit Delete 27381 157 177 2001 1 [BLOB - 0B]
Edit Delete 27381 157 176 7590 1 [BLOB - 0B]
Edit Delete 27381 157 175 7590 1 [BLOB - 0B]
Edit Delete 27381 157 174 7590 1 [BLOB - 0B]
Edit Delete 27381 157 173 7590 1 [BLOB - 0B]
Edit Delete 27381 157 172 7590 1 [BLOB - 0B]
Edit Delete 27381 157 171 7590 1 [BLOB - 0B]
Edit Delete 27381 157 170 7590 1 [BLOB - 0B]
Edit Delete 27381 157 169 7590 1 [BLOB - 0B]
Edit Delete 27381 157 168 7590 1 [BLOB - 0B]
Edit Delete 27381 157 167 7590 1 [BLOB - 0B]
Edit Delete 27381 157 166 7590 1 [BLOB - 0B]
Edit Delete 27381 157 165 7590 1 [BLOB - 0B]
Edit Delete 27381 157 164 7590 1 [BLOB - 0B]
Edit Delete 27381 157 163 7590 1 [BLOB - 0B]
Edit Delete 27381 157 162 7590 1 [BLOB - 0B]
Edit Delete 27381 157 161 7590 1 [BLOB - 0B]
Edit Delete 27381 157 160 7590 1 [BLOB - 0B]
Edit Delete 27381 157 159 7590 1 [BLOB - 0B]
Edit Delete 27381 157 158 7590 1 [BLOB - 0B]
Edit Delete 27381 137 157 2001 1 [BLOB - 0B]
Edit Delete 27381 137 156 7590 1 [BLOB - 0B]
Edit Delete 27381 137 155 7590 1 [BLOB - 0B]
Edit Delete 27381 137 154 7590 1 [BLOB - 0B]
Edit Delete 27381 137 153 7590 1 [BLOB - 0B]
Edit Delete 27381 137 152 7590 1 [BLOB - 0B]
Edit Delete 27381 137 151 7590 1 [BLOB - 0B]
Edit Delete 27381 137 150 7590 1 [BLOB - 0B]
Edit Delete 27381 137 149 7590 1 [BLOB - 0B]
Edit Delete 27381 137 148 7590 1 [BLOB - 0B]
Edit Delete 27381 137 147 7590 1 [BLOB - 0B]
Edit Delete 27381 137 146 7590 1 [BLOB - 0B]
Edit Delete 27381 137 145 7590 1 [BLOB - 0B]
Edit Delete 27381 137 144 7590 1 [BLOB - 0B]
Edit Delete 27381 137 143 7590 1 [BLOB - 0B]
Edit Delete 27381 137 142 7590 1 [BLOB - 0B]
Edit Delete 27381 137 141 7590 1 [BLOB - 0B]
Edit Delete 27381 137 140 7590 1 [BLOB - 0B]
Edit Delete 27381 137 139 7590 1 [BLOB - 0B]
Edit Delete 27381 137 138 7590 1 [BLOB - 0B]
Edit Delete 27381 129 137 2001 1 [BLOB - 0B]
Edit Delete 27381 129 136 7590 1 [BLOB - 0B]
Edit Delete 27381 129 135 7590 1 [BLOB - 0B]
Edit Delete 27381 129 134 7590 1 [BLOB - 0B]
Edit Delete 27381 129 133 7590 1 [BLOB - 0B]
Edit Delete 27381 129 132 7590 1 [BLOB - 0B]
Edit Delete 27381 129 131 7590 1 [BLOB - 0B]
Edit Delete 27381 129 130 7590 1 [BLOB - 0B]
Edit Delete 27381 128 129 2001 1 [BLOB - 0B]
Edit Delete 27381 127 128 2001 1 [BLOB - 0B]
Edit Delete 27381 114 127 2001 1 [BLOB - 0B]
Edit Delete 27381 103 126 2294 1 [BLOB - 3B]
Edit Delete 27381 103 125 2293 100 [BLOB - 3B]
Edit Delete 27381 103 124 7727 1 [BLOB - 0B]
Edit Delete 27381 103 123 2273 100 [BLOB - 3B]
Edit Delete 27381 103 122 2278 100 [BLOB - 3B]
Edit Delete 27381 103 121 2300 1 [BLOB - 3B]
Edit Delete 27381 103 120 9970 36 [BLOB - 2B]
Edit Delete 27381 103 119 2002 1 [BLOB - 0B]
Edit Delete 27381 103 118 2087 1 [BLOB - 3B]
Edit Delete 27381 103 117 2152 55 [BLOB - 2B]
Edit Delete 27381 103 116 2160 1 [BLOB - 2B]
Edit Delete 27381 103 115 6500 100 [BLOB - 2B]
Edit Delete 27381 103 114 2001 1 [BLOB - 0B]
Edit 27381 103 111 8698 1 [BLOB - 72B]
Edit Delete 27381 103 113 2501 1 [BLOB - 0B]
Edit 27381 103 112 8698 1 [BLOB - 67B]
Edit Delete 27381 10 110 2127 1 [BLOB - 0B]
Edit Delete 27381 9 109 7697 1 [BLOB - 3B]
Edit Delete 27381 8 108 2644 1 [BLOB - 7B]
Edit Delete 27381 7 107 7896 1 [BLOB - 0B]
Edit Delete 27381 6 106 8908 1 [BLOB - 0B]
Edit Delete 27381 5 105 8910 1 [BLOB - 0B]
Edit Delete 27381 4 104 8867 1 [BLOB - 0B]
Edit Delete 27381 3 103 9774 1 [BLOB - 0B]
Edit Delete 27381 2 102 2173 1 [BLOB - 0B]
Edit Delete 27381 1 101 2139 1 [BLOB - 0B]
Xexza
u dont have triggers, add this:
Code:DELIMITER | CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players` FOR EACH ROW BEGIN INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10); END| DELIMITER ;
SQL query:
DELIMITER | CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players`
FOR EACH
ROW
BEGIN
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 0, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 1, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 2, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 3, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 4, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 5, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 6, 10
);
END |
<item id="1490" name="poison gas">
<attribute key="type" value="magicfield"/>
<attribute key="decayTo" value="0"/>
<attribute key="duration" value="248"/>
<attribute key="field" value="poison">
<attribute key="ticks" value="5000"/>
[B][COLOR="Red"]<attribute key="start" value="5"/>[/COLOR][/B]
<attribute key="damage" value="105"/>
</attribute>
</item>
std::string Item::getWeightDescription(const ItemType& it, double weight, uint32_t count /*= 1*/)
{
std::stringstream ss;
if(it.stackable [B][COLOR="Red"]&& count > 1[/COLOR][/B])
ss << "They weigh " << std::fixed << std::setprecision(2) << weight << " oz.";
else
ss << "It weighs " << std::fixed << std::setprecision(2) << weight << " oz.";
return ss.str();
}
The Forgotten Server 0.2.5 is crashing a lot on my Host. Anyone could help me ?
Someone else, told me that it could be a problem related to the Scripts.
I had Forgotten Server Mystic Spirit working without any crash until the version 8.4.
Since I migrated the server to 8.42 the crashes started to happen. Sometimes it crashes once a day, sometimes several times in sequence and in another cases, it crashes sometimes in a day.
So anyone could help me on this problem ?
My server has 100~150 players online daily, and this problem is causing loose of players on my server.
I'd appreciate a lot if you guys can help me on this terrible problem.