服务端数据库相关（注解）

# 账号登录

## 库名：d_taiwan

> 密码为无加盐MD5

登录,获取uid

```sql

select * from accounts where accountname=? and password=?

```

## 库名：taiwan_cain

选择角色

uid为登录账号获取的uid 需要获取到charac_no charac_name

```sql

select * from charac_info where m_id = ${uid}

```

# 发送道具

## 库名：taiwan_cain_2nd

邮件内容

```sql

INSERT INTO `postal` (occ_time,send_charac_no,send_charac_name,receive_charac_no,item_id,

add_info,endurance,upgrade,amplify_option,amplify_value,gold,delete_flag,

avata_flag,unlimit_flag,seal_flag,creature_flag,postal,letter_id,extend_info,ipg_db_id,

ipg_transaction_id,ipg_nexon_id,auction_id,random_option,seperate_upgrade,type,item_guid

)

VALUES (${datetime}, 0, 'GM', ${charac_id}, ${item_id}, ${item_num}, 0, 0, 0, 0, 0, 

0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '', 0, '', 0, 0, '');

```

# 数据库

## 库名：d_taiwan

账号：d_taiwan

密码：LxBpGmpZXW2Dcmje

## 库名：taiwan_cain

账号：taiwan_cain

密码：EcsbhzXhJBRBBNDe

## 库名：taiwan_cain_2nd

账号：taiwan_cain_2nd

密码：eLBcR8EjFT3zPepH