1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
EACCELERATORcheck_recruitcheck_recruitS
id?
S
time?
SdbSdb'Sdb;queryPidjSELECT unit,num_unit,num_finished,time_start,time_finished,time_per_unit,villageid from recruit where id='7'A==Sresult&Sdb;Fetch\resultB==Srow&+~PtimeProwQ
time_startS diff_time&ProwQ
time_per_unitA<<floorProwQnum_finishedSunits_finished&ProwQnum_finishedQnum_unit+4ProwQnum_unitQnum_finishedSunits_finished&Sdb;queryProwQunitUPDATE unit_place SET =QunitPunits_finished+'7' where villages_from_id='Q villageid' AND villages_to_id='Q villageid'A==Sdb;queryProwQunitUPDATE villages SET all_=all_QunitPunits_finished+'7' where id='Q villageid'A==P!units_finishedP!rowQ!num_finished!Q!num_unit!+!iS"db;"queryP"id"DELETE from recruit where id='7"'A"=="c#true>#S'db;'queryP'units_finished'.UPDATE recruit SET num_finished=num_finished+'7'' where id='P'id8'7''A'=='P(rowQ(
time_startP(units_finishedQ(num_finished(Q(
time_per_unit((Q(
time_per_unit(>(>,
check_buildscheck_builds‘S6id?6S8dbS8db'8c;falseS;done&;G<S<reload_village&<G=S=
reload_player&=S>db;>queryP>id>8SELECT villageid,building,end_time from build where id='7>'A>==>S>result&>S?db;?Fetch\?resultB?==?S?row&?+?SBdb;BqueryPBidBDELETE from build where id='B'AB==BSEdb;EaffectedRows=EE+ESGdb;GqueryPGrowQG villageidG;SELECT COUNT(*) AS build_count from build where villageid='G'AG==GSGresult2&GSHdb;HFetch\Hresult2BH==HSHrow2&HQIbuild_countI0+IBSJadd_sql&J,main_build='' *K[SOdb;OqueryPOrowQO villageidO5SELECT building,end_time from build where villageid='O' order by end_time LIMIT 1AO==OSOresult2&OSPdb;PFetch\Presult2BP==PSP
next_build&PQRbuildingR
,main_build='R,QRend_timeRR' SRadd_sql&RPWrowQWbuildingWstorage,WkPWrowQWbuildingWwood,WkPWrowQWbuildingWstone,WkPWrowQWbuildingWiron+W|SYdb;YqueryPYrowQY villageidY[SELECT last_prod_aktu,wood,stone,iron,r_wood,r_stone,r_iron,storage from villages where id=YAY==YSYres&Y;Zressis\ZvillagedataBZ=\Zrow]Zend_timeBZ==ZS\db;\queryP\rowQ\building\UPDATE villages SET \=Q\building\P\add_sql\+1 7\ where id='\Q\ villageid\\'A\==\P]rowQ] villageid>]>`check_techcheck_tech0Sjid?jSkdbSkdb'kGnSnreturn&nSodb;oqueryPoido2SELECT research,villageid from research where id='7o'Ao==oSoresult&oSpdb;pFetch\presultBp==pSprow&p+p/Ssdb;squeryPsidsDELETE from research where id='7s'As==sSvdb;vqueryPvrowQvresearchvUPDATE villages SET unit_v_tec_level=unit_Qvresearchvv&_tec_level+'1',smith_tec='' where id='Qv villageidvv'Av==v*w>xcheck_dealerscheck_dealersÑS‚id?‚S‚event_id?‚SƒdbSƒdb'ƒS„
cl_reportsS„
cl_reports'„S‡db;‡queryP‡id‡}SELECT dealers,wood,stone,iron,type,from_village,to_village,start_time,end_time,from_userid,to_userid from dealers where id='7‡'A‡==‡S‡result&‡Sˆdb;ˆFetch\ˆresultBˆ==ˆSˆrow&ˆcŠfalseSŠ also_back&ŠP‹rowQ‹type‹to+‹®SŽdb;ŽqueryPŽrowQŽwoodŽ"UPDATE villages SET r_wood=r_wood+Ž,r_stone=r_stone+QŽstoneŽŽ,r_iron=r_iron+QŽironŽŽ
where id=QŽ
to_villageŽŽAŽ==ŽP‘rowQ‘end_timeS‘
start_time&‘P’rowQ’end_timeQ’end_timeQ’
start_time’’S’end_time&’<”time”+”Dc•trueS• also_back&•S™db;™queryP™
start_time™4UPDATE dealers SET wood=0,stone=0,iron=0,start_time=7™
,end_time=P™end_time8™7™,type='back' where id=P™id8™A™==™S›db;›queryP›end_time›(UPDATE events SET can_knot=0,event_time=7›,cid=0 WHERE event_id=P›id8›7› AND event_type='dealers'A›==›SŸdb;ŸqueryPŸrowQŸfrom_villageŸ#SELECT name from villages where id=ŸAŸ==ŸSŸresult&ŸS db; Fetch\ resultB == S from_village& S¢db;¢queryP¢rowQ¢ to_userid¢$SELECT username from users where id=¢A¢==¢S¢result&¢S£db;£Fetch\£resultB£==£S£to_user&£S¤
cl_reports;¤sendRess\¤row]¤from_useridB¤=\¤row]¤from_villageB¤=;¤entparse\¤from_village]¤nameB¤==¤j¤\¤row]¤ to_useridB¤=;¤entparse\¤to_user]¤usernameB¤==¤j¤\¤row]¤
to_villageB¤=\¤row]¤woodB¤=\¤row]¤stoneB¤=\¤ row]¤ ironB¤= \¤
row]¤
end_timeB¤=
=¤
P¦ also_back,¦®S§db;§queryP§event_id§!DELETE from run_events where id='§dealers'A§==§c¨false>¨P¬rowQ¬type¬back,¬´P¬ also_back+¬ÐS¯db;¯queryP¯rowQ¯dealers¯4UPDATE villages SET dealers_outside=dealers_outside-¯,r_wood=r_wood+Q¯wood¯¯,r_stone=r_stone+Q¯stone¯¯,r_iron=r_iron+Q¯iron¯¯
where id=Q¯from_village¯¯A¯==¯S±db;±queryP±id±DELETE from dealers where id=A±==±c²true>²>´do_movementdo_movement“S¿id?¿S¿event_id?¿S¿time?¿SÁdbSÁdb'ÁSÄdb;ÄqueryPÄidÄ”SELECT die,from_village,to_village,units,type,start_time,end_time,building,from_userid,to_userid,to_userid,wood,stone,iron from movements where id='7Ä'AÄ==ÄSÄresult&ÄSÅdb;ÅFetch\ÅresultBÅ==ÅSÅrow&ÅPÆidSÆrowTÆid&ÆYÉrowZÉtypeLÉ,É$SÊrowTÊtype&ÊPÍrowQÍtype0Îattack+Î5SÏsessionSÏsession'Ï;Ðdo_movement_attack\ÐrowBÐ=\Ðevent_idBÐ=\ÐtimeBÐ==Ð1Ð>Ð0Ósupport+ÓLPÔrowQÔdieÔ1+ÔFSÕdb;ÕqueryPÕrowQÕidÕDELETE from movements where id=ÕAÕ==ÕcÖtrue1Ö>Ö;Ødo_movement_support\ØrowBØ==Ø1Ø>Ø0Ûreturn+ÛcPÜrowQÜdieÜ1+Ü]SÝdb;ÝqueryPÝrowQÝidÝDELETE from movements where id=ÝAÝ==ÝcÞtrue1Þ>Þ;àdo_movement_return\àrowBà==à1à>à0ãback+ãzPärowQädieä1+ätSådb;åqueryPårowQåidåDELETE from movements where id=åAå==åcætrue1æ>æ;èdo_movement_back\èrowBè==è1è>è0ëcancel+ë‘PìrowQìdieì1+ì‹Sídb;íqueryPírowQíidíDELETE from movements where id=íAí==ícîtrue1î>î;òdo_movement_back\òrowBò==ò1ò>ò1ô>ödo_movement_backdo_movement_backYSrow?Scl_unitsScl_units'SdbSdb'Ssql&UPDATE unit_place SET ctrueSfirst&Si&A <;P rowQ unitsB << explodeS ex_units& S
cl_units;
get_arrayA
=dbname=
M
N
@S
dbname&
Pfirst+0Pdbname=Pdbname87+'PiPex_unitsQ'Vsqlc
falseS
........
|