70S2A1，新建角色王图全开、99999胜点尊10、自动入会触发器分享

xiaomi

触发器一劳永逸，需要NAVICAT软件，这里不做教程，别的帖子有或者自行百度，2、3、4楼贴代码。也可以用我自用的端，已经做了单机化处理，触发已经搞好不用再搞了，里面有修改说明，版本是最新的1.11，测试账号2222/2222
aHR0cHM6Ly9wYW4uYmFpZHUuY29tL3MvMXdiY29GVHh0STF4eDJvSlZGSzhKR0E/cHdkPW4ydzg=

xiaomi

新建角色所有图王者级全开，优点是直接新号就能打王者且不需要共享难度了
use taiwan_cain;
DROP trigger IF EXISTS `add_charac_dungeon`;
CREATE TRIGGER `add_charac_dungeon` BEFORE INSERT ON `charac_dungeon` FOR EACH ROW
BEGIN
set new.dungeon='1|3,2|3,3|3,4|3,5|3,6|3,7|3,8|3,9|3,11|3,12|3,13|3,14|3,15|3,17|3,21|3,22|3,23|3,24|3,25|3,26|3,27|3,31|3,32|3,33|3,34|3,35|3,36|3,37|3,40|3,41|3,42|3,43|3,44|3,45|3,50|3,51|3,52|3,53|3,60|3,61|3,3500|3,6363|3,6464|3,65|3,66|3,67|3,70|3,71|3,72|3,73|3,74|3,75|3,76|3,77|3,80|3,81|3,82|3,83|3,84|3,85|3,86|3,87|3,88|3,89|3,90|3,91|3,92|3,93|3,100|3,101|3,102|3,103|3,104|3,110|3,111|3,112|3,120|3,121|3,140|3,141|3,144|3,145|3,146|3,147|3,148|3,149|3,150|3,151|3,152|3,153|3,154|3,155|3,156|3,157|3,158|3,159|3,160|3,161|3,162|3,163|3,164|3,165|3,166|3,167|3,168|3,169|3,170|3,171|3,172|3,190|3,191|3,192|3,193|3,194|3,195|3,200|3,201|3,202|3,203|3,204|3,205|3,206|3,210|3,212|3,213|3,214|3,215|3,218|3,219|3,220|3,221|3,222|3,223|3,224|3,225|3,310|3,311|3,312|3,313|3,314|3,315|3,316|3,500|3,501|3,502|3,503|3,504|3,505|3,506|3,507|3,508|3,509|3,510|3,511|3,512|3,513|3,514|3,515|3,516|3,517|3,518|3,519|3,520|3,521|3,522|3,1000|3,1001|3,1002|3,1003|3,1004|3,1156|3,1157|3,1158|3,1159|3,1500|3,1501|3,1502|3,1504|3,1506|3,1507|3,2000|3,2001|3,2002|3,2003|3,2004|3,3001|3,3002|3,3003|3,3004|3,3005|3,3006|3,3007|3,3008|3,3009|3,3010|3,3011|3,3012|3,3013|3,3014|3,3015|3,3016|3,3017|3,3018|3,3019|3,3020|3,3021|3,3022|3,3023|3,3024|3,3025|3,3026|3,3027|3,3028|3,3029|3,3030|3,3031|3,3032|3,3033|3,3034|3,3035|3,3036|3,3037|3,3038|3,3039|3,3040|3,3041|3,3042|3,3043|3,3044|3,3045|3,3046|3,3047|3,3048|3,3049|3,3050|3,3051|3,3055|3,3200|3,3201|3,3202|3,3506|3,4017|3,4018|3,4019|3,4020|3,4026|3,4027|3,4028|3,4029|3,4021|3,4022|3,4024|3,4025|3,4117|3,4118|3,5002|3,5003|3,5004|3,5005|3,5009|3,5019|3,5029|3,5039|3,5041|3,5101|3,5102|3,5103|3,5104|3,5105|3,5106|3,5107|3,5354|3,5355|3,5356|3,5357|3,5358|3,5359|3,5360|3,5361|3,5362|3,5363|3,5364|3,5365|3,6000|3,8000|3,8005|3,8006|3,8007|3,8008|3,8009|3,10000|3,10001|3,10002|3,11000|3,11001|3,11006|3,11007|3,11008|3,11009|3,11010|3,11011|3,11012|3,11013|3,11014|3,11015|3,11016|3,11017|3,11018|3,11019|3,11020|3,11021|3,11022|3,11023|3,11024|3,11025|3,11026|3,11027|3,11028|3,11029|3,11030|3,11031|3,11032|3,11033|3,11034|3,11035|3,11036|3,11037|3,11038|3,11039|3,11040|3,11041|3,11042|3,11043|3,11044|3,11045|3,11046|3,11047|3,11048|3,11049|3,11050|3,11051|3,11052|3,11053|3,11054|3,11055|3,11056|3,11057|3,11058|3,11059|3,11060|3,11061|3,11062|3,11063|3,11064|3,11065|3,11066|3,11067|3,11068|3,11069|3,11070|3,11071|3,11072|3,11073|3,11074|3,11075|3,11076|3,11077|3,11078|3,11079|3,11080|3,11081|3,11082|3,11083|3,11084|3,11085|3,11086|3,11087|3,11088|3,11089|3,11090|3,11091|3,11092|3,11093|3,11094|3,11095|3,11096|3,11097|3,11098|3,11099|3,11100|3,11101|3,11102|3,11103|3,11104|3,11105|3,11106|3,11107|3,20000|3,20001|3,20002|3,20003|3,20004|3,20005|3,20006|3,20007|3,20008|3,20009|3,20010|3,20011|3,20012|3,20013|3,20014|3,20015|3,20016|3,20017|3,20018|3,20019|3,20020|3,20021|3,20022|3,20023|3,20024|3,20187|3,20192|3,20197|3,20202|3,29320|3';
END;

xiaomi

新建角色尊10，99999胜点，我看总有人问胜点怎么获取，自动获取最简单，这版本装备挺弱的，那就当战神套是毕业套吧
use taiwan_cain;
DROP trigger IF EXISTS `add_pvppoint`;
CREATE TRIGGER `add_pvppoint` BEFORE INSERT ON `pvp_result` FOR EACH ROW
BEGIN
set new.win_point='99999';
set new.pvp_grade='29';
set new.win='999';
END;

阿苏

感谢分享！

阿荣社区采集员

遥遥领先

arong

怎么去掉公会加的属性呢

arong

好人有好鲍！

Dveridow

有没有详细点的教程

xiaomi

阿荣社区采集员2

感觉又学到了新知识，上个星期学会了调神迹假紫三 S

xiaomi

顶

阿荣社区采集员1

真好 又有新知识灌进脑子里了

xiaomi

4楼被删了，再补一个，自动加入工会并设置优秀会员，运行触发器前需要服务端里有一个建好的公会，如果只有一个工会下面的代码就是对的，两个guild_id = 1就是服务端里第一个建立的工会，否则按照建立工会的顺序修改了再运行，此触发器配合60属性工会很好用，新建的角色自动就入会了并得到属性了
DELIMITER //
CREATE TRIGGER auto_join
AFTER INSERT ON taiwan_cain.charac_stat
FOR EACH ROW
BEGIN
DECLARE v_m_id INT;
DECLARE v_charac_no INT;
DECLARE v_charac_name VARCHAR(255);
DECLARE v_lev INT;
DECLARE v_job INT;
DECLARE v_grow_type INT;
DECLARE v_current_time DATETIME;
UPDATE taiwan_cain.charac_info
SET guild_id = 1, guild_right = 1
WHERE charac_no = NEW.charac_no;
SELECT m_id, charac_no, charac_name, lev, job, grow_type, NOW() INTO v_m_id, v_charac_no, v_charac_name, v_lev, v_job, v_grow_type, v_current_time
FROM taiwan_cain.charac_info
WHERE charac_no = NEW.charac_no;
INSERT INTO d_guild.guild_member
(guild_id, m_id, server_id, charac_no, charac_name, memo, grade, job, grow_type, lev, member_time, member_flag, last_play_time, age, born_year)
VALUES
(1, v_m_id, 3, v_charac_no, v_charac_name, 'Chuan', 3, v_job, v_grow_type, v_lev, v_current_time, 1, v_current_time, 0, '00');
UPDATE d_guild.guild_info
SET member_count = member_count + 1
WHERE guild_id = 1;
END //
DELIMITER ;

阿荣社区采集员1

mark一下

阿荣社区采集员2

看来大佬对触发器很擅长 请问怎么让商城时装礼包打开后 可以自己选择使用期限呢？或者自动帮我选择 时装代码里的 [avatar type select]此条下面的第三项价格