Windows Two bugs at my server, reputation for help :3

[tejdi]

on my server after the death of skills fall to the initial state (for skills - 10 while mlvl - 0)
lose the whole EQUIPMENT.
How do I fix this? Using reputation.

<?xml version="1.0" encoding="UTF-8"?>
<creaturescripts>
 
	<event type="login" name="PlayerLogin" event="script" value="login.lua"/>
	<event type="login" name="FimVip" event="script" value="vip.lua"/>
	<event type="death" name="PlayerDeath" event="script" value="playerdeath.lua"/>
        <event type="login" name="PremCheck" script="premcheck.lua"/>
	<event type="login" name="Castle" script="castle.lua"/>
        <event type="login" name="Welcome" script="welcome.lua"/>
	<event type="mailreceive" name="Mail" event="script" value="mail.lua"/>
      <event type="login" name="offtrain_PlayerLogin" event="script" value="offtrain_login.lua"/>
	<event type="logout" name="offtrain_PlayerLogout" event="script" value="offtrain_logout.lua"/>
 
	<event type="advance" name="AdvanceSave" event="script" value="advancesave.lua"/>
	<event type="logout" name="demonOakLogout" event="script" value="demonOakLogout.lua"/>
	<event type="death" name="demonOakDeath" event="script" value="demonOakDeath.lua"/>
	<event type="textedit" name="demonOakComplete" event="script" value="demonOakComplete.lua"/>
	<event type="death" name="monster2" event="script" value="monster2.lua"/>
	<event type="death" name="zaoPortals" event="script" value="zaoPortals.lua"/>
        <event type="login" name="Ip" event="script" value="playerip.lua"/>
	<event type="kill" name="inquisitionPortals" script="Inquisition.lua"/>
	<event type="kill" name="ArenaKill" event="script" value="arenakill.lua"/>
	<event type="kill" name="killbossesbroadcast" event="script" value="killbossesbroadcast.lua"/>
	<event type="login" name="first" event="script" value="first.lua"/>
 
	<!-- AUTO LOOT -->
   	<event type="login" name="aloot_reg" event="script" value="aloot.lua"/>
    	<event type="kill" name="aloot_kill" event="script" value="aloot.lua"/>
 
	<!-- Firewalker Boots -->
	<event type="death" name="PythiusDead" script="pythius_the_rotten.lua" />
 
 
	<!-- Zombie Event -->
	<event type="death" name="ga1" event="script" value="ga1.lua"/>
 
	<event type="death" name="ga2" event="script" value="ga2.lua"/>
 
	<event type="death" name="ga3" event="script" value="ga3.lua"/>
 
	<event type="death" name="gv1" event="script" value="gv1.lua"/>
 
	<event type="death" name="gv2" event="script" value="gv2.lua"/>
 
	<event type="death" name="gv3" event="script" value="gv3.lua"/>
 
	<event type="statschange" name="zombieevent" event="script" value="zombievent.lua"/>
 
	<!-- Custom systems -->
	<event type="advance" name="recompensa" event="script" value="recompensa.lua"/>
 
	<!-- WoE -->
	<event type="death" name="empe_broken" event="script" value="empe_broken.lua"/>
	<event type="death" name="pre_empes" event="script" value="pre_empes.lua"/>
	<event type="statschange" name="empe_dmg" event="script" value="empe_dmg.lua"/>
	<event type="login" name="reg_vs_guard" event="script" value="vs_guard.lua"/>
	<event type="statschange" name="vs_guard" event="script" value="vs_guard.lua"/>
	<event type="think" name="SkullCheck" event="script" value="skullcheck.lua"/>
</creaturescripts>

 

[Loney]

Try executing this query, had the same problem before.

CREATE TABLE `player_skills`
(
	`player_id` INT NOT NULL DEFAULT 0,
	`skillid` TINYINT(2) NOT NULL DEFAULT 0,
	`value` INT UNSIGNED NOT NULL DEFAULT 0,
	`count` INT UNSIGNED NOT NULL DEFAULT 0,
	KEY (`player_id`), UNIQUE (`player_id`, `skillid`),
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[tejdi]

Error :

 #1050 - Table 'player_skills' already exists

- - - Updated - - -

bump