Kanjut SHELL
Server IP : 172.16.15.8  /  Your IP : 18.216.174.32
Web Server : Apache
System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64
User : apache ( 48)
PHP Version : 7.2.24
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0705) :  /home/jlcrouch/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : //home/jlcrouch/updatePokedex.sql
ALTER TABLE pokedex ADD ss_x tinyint, ADD ss_y tinyint;
UPDATE pokedex SET ss_x='-1' WHERE id='0';
UPDATE pokedex SET ss_y='0' WHERE id='0';
UPDATE pokedex SET ss_x='0' WHERE id='1';
UPDATE pokedex SET ss_y='0' WHERE id='1';
UPDATE pokedex SET ss_x='1' WHERE id='2';
UPDATE pokedex SET ss_y='0' WHERE id='2';
UPDATE pokedex SET ss_x='2' WHERE id='3';
UPDATE pokedex SET ss_y='0' WHERE id='3';
UPDATE pokedex SET ss_x='3' WHERE id='4';
UPDATE pokedex SET ss_y='0' WHERE id='4';
UPDATE pokedex SET ss_x='4' WHERE id='5';
UPDATE pokedex SET ss_y='0' WHERE id='5';
UPDATE pokedex SET ss_x='5' WHERE id='6';
UPDATE pokedex SET ss_y='0' WHERE id='6';
UPDATE pokedex SET ss_x='6' WHERE id='7';
UPDATE pokedex SET ss_y='0' WHERE id='7';
UPDATE pokedex SET ss_x='7' WHERE id='8';
UPDATE pokedex SET ss_y='0' WHERE id='8';
UPDATE pokedex SET ss_x='8' WHERE id='9';
UPDATE pokedex SET ss_y='0' WHERE id='9';
UPDATE pokedex SET ss_x='9' WHERE id='10';
UPDATE pokedex SET ss_y='0' WHERE id='10';
UPDATE pokedex SET ss_x='10' WHERE id='11';
UPDATE pokedex SET ss_y='0' WHERE id='11';
UPDATE pokedex SET ss_x='11' WHERE id='12';
UPDATE pokedex SET ss_y='0' WHERE id='12';
UPDATE pokedex SET ss_x='12' WHERE id='13';
UPDATE pokedex SET ss_y='0' WHERE id='13';
UPDATE pokedex SET ss_x='13' WHERE id='14';
UPDATE pokedex SET ss_y='0' WHERE id='14';
UPDATE pokedex SET ss_x='14' WHERE id='15';
UPDATE pokedex SET ss_y='0' WHERE id='15';
UPDATE pokedex SET ss_x='0' WHERE id='16';
UPDATE pokedex SET ss_y='1' WHERE id='16';
UPDATE pokedex SET ss_x='1' WHERE id='17';
UPDATE pokedex SET ss_y='1' WHERE id='17';
UPDATE pokedex SET ss_x='2' WHERE id='18';
UPDATE pokedex SET ss_y='1' WHERE id='18';
UPDATE pokedex SET ss_x='3' WHERE id='19';
UPDATE pokedex SET ss_y='1' WHERE id='19';
UPDATE pokedex SET ss_x='4' WHERE id='20';
UPDATE pokedex SET ss_y='1' WHERE id='20';
UPDATE pokedex SET ss_x='5' WHERE id='21';
UPDATE pokedex SET ss_y='1' WHERE id='21';
UPDATE pokedex SET ss_x='6' WHERE id='22';
UPDATE pokedex SET ss_y='1' WHERE id='22';
UPDATE pokedex SET ss_x='7' WHERE id='23';
UPDATE pokedex SET ss_y='1' WHERE id='23';
UPDATE pokedex SET ss_x='8' WHERE id='24';
UPDATE pokedex SET ss_y='1' WHERE id='24';
UPDATE pokedex SET ss_x='9' WHERE id='25';
UPDATE pokedex SET ss_y='1' WHERE id='25';
UPDATE pokedex SET ss_x='10' WHERE id='26';
UPDATE pokedex SET ss_y='1' WHERE id='26';
UPDATE pokedex SET ss_x='11' WHERE id='27';
UPDATE pokedex SET ss_y='1' WHERE id='27';
UPDATE pokedex SET ss_x='12' WHERE id='28';
UPDATE pokedex SET ss_y='1' WHERE id='28';
UPDATE pokedex SET ss_x='13' WHERE id='29';
UPDATE pokedex SET ss_y='1' WHERE id='29';
UPDATE pokedex SET ss_x='14' WHERE id='30';
UPDATE pokedex SET ss_y='1' WHERE id='30';
UPDATE pokedex SET ss_x='0' WHERE id='31';
UPDATE pokedex SET ss_y='2' WHERE id='31';
UPDATE pokedex SET ss_x='1' WHERE id='32';
UPDATE pokedex SET ss_y='2' WHERE id='32';
UPDATE pokedex SET ss_x='2' WHERE id='33';
UPDATE pokedex SET ss_y='2' WHERE id='33';
UPDATE pokedex SET ss_x='3' WHERE id='34';
UPDATE pokedex SET ss_y='2' WHERE id='34';
UPDATE pokedex SET ss_x='4' WHERE id='35';
UPDATE pokedex SET ss_y='2' WHERE id='35';
UPDATE pokedex SET ss_x='5' WHERE id='36';
UPDATE pokedex SET ss_y='2' WHERE id='36';
UPDATE pokedex SET ss_x='6' WHERE id='37';
UPDATE pokedex SET ss_y='2' WHERE id='37';
UPDATE pokedex SET ss_x='7' WHERE id='38';
UPDATE pokedex SET ss_y='2' WHERE id='38';
UPDATE pokedex SET ss_x='8' WHERE id='39';
UPDATE pokedex SET ss_y='2' WHERE id='39';
UPDATE pokedex SET ss_x='9' WHERE id='40';
UPDATE pokedex SET ss_y='2' WHERE id='40';
UPDATE pokedex SET ss_x='10' WHERE id='41';
UPDATE pokedex SET ss_y='2' WHERE id='41';
UPDATE pokedex SET ss_x='11' WHERE id='42';
UPDATE pokedex SET ss_y='2' WHERE id='42';
UPDATE pokedex SET ss_x='12' WHERE id='43';
UPDATE pokedex SET ss_y='2' WHERE id='43';
UPDATE pokedex SET ss_x='13' WHERE id='44';
UPDATE pokedex SET ss_y='2' WHERE id='44';
UPDATE pokedex SET ss_x='14' WHERE id='45';
UPDATE pokedex SET ss_y='2' WHERE id='45';
UPDATE pokedex SET ss_x='0' WHERE id='46';
UPDATE pokedex SET ss_y='3' WHERE id='46';
UPDATE pokedex SET ss_x='1' WHERE id='47';
UPDATE pokedex SET ss_y='3' WHERE id='47';
UPDATE pokedex SET ss_x='2' WHERE id='48';
UPDATE pokedex SET ss_y='3' WHERE id='48';
UPDATE pokedex SET ss_x='3' WHERE id='49';
UPDATE pokedex SET ss_y='3' WHERE id='49';
UPDATE pokedex SET ss_x='4' WHERE id='50';
UPDATE pokedex SET ss_y='3' WHERE id='50';
UPDATE pokedex SET ss_x='5' WHERE id='51';
UPDATE pokedex SET ss_y='3' WHERE id='51';
UPDATE pokedex SET ss_x='6' WHERE id='52';
UPDATE pokedex SET ss_y='3' WHERE id='52';
UPDATE pokedex SET ss_x='7' WHERE id='53';
UPDATE pokedex SET ss_y='3' WHERE id='53';
UPDATE pokedex SET ss_x='8' WHERE id='54';
UPDATE pokedex SET ss_y='3' WHERE id='54';
UPDATE pokedex SET ss_x='9' WHERE id='55';
UPDATE pokedex SET ss_y='3' WHERE id='55';
UPDATE pokedex SET ss_x='10' WHERE id='56';
UPDATE pokedex SET ss_y='3' WHERE id='56';
UPDATE pokedex SET ss_x='11' WHERE id='57';
UPDATE pokedex SET ss_y='3' WHERE id='57';
UPDATE pokedex SET ss_x='12' WHERE id='58';
UPDATE pokedex SET ss_y='3' WHERE id='58';
UPDATE pokedex SET ss_x='13' WHERE id='59';
UPDATE pokedex SET ss_y='3' WHERE id='59';
UPDATE pokedex SET ss_x='14' WHERE id='60';
UPDATE pokedex SET ss_y='3' WHERE id='60';
UPDATE pokedex SET ss_x='0' WHERE id='61';
UPDATE pokedex SET ss_y='4' WHERE id='61';
UPDATE pokedex SET ss_x='1' WHERE id='62';
UPDATE pokedex SET ss_y='4' WHERE id='62';
UPDATE pokedex SET ss_x='2' WHERE id='63';
UPDATE pokedex SET ss_y='4' WHERE id='63';
UPDATE pokedex SET ss_x='3' WHERE id='64';
UPDATE pokedex SET ss_y='4' WHERE id='64';
UPDATE pokedex SET ss_x='4' WHERE id='65';
UPDATE pokedex SET ss_y='4' WHERE id='65';
UPDATE pokedex SET ss_x='5' WHERE id='66';
UPDATE pokedex SET ss_y='4' WHERE id='66';
UPDATE pokedex SET ss_x='6' WHERE id='67';
UPDATE pokedex SET ss_y='4' WHERE id='67';
UPDATE pokedex SET ss_x='7' WHERE id='68';
UPDATE pokedex SET ss_y='4' WHERE id='68';
UPDATE pokedex SET ss_x='8' WHERE id='69';
UPDATE pokedex SET ss_y='4' WHERE id='69';
UPDATE pokedex SET ss_x='9' WHERE id='70';
UPDATE pokedex SET ss_y='4' WHERE id='70';
UPDATE pokedex SET ss_x='10' WHERE id='71';
UPDATE pokedex SET ss_y='4' WHERE id='71';
UPDATE pokedex SET ss_x='11' WHERE id='72';
UPDATE pokedex SET ss_y='4' WHERE id='72';
UPDATE pokedex SET ss_x='12' WHERE id='73';
UPDATE pokedex SET ss_y='4' WHERE id='73';
UPDATE pokedex SET ss_x='13' WHERE id='74';
UPDATE pokedex SET ss_y='4' WHERE id='74';
UPDATE pokedex SET ss_x='14' WHERE id='75';
UPDATE pokedex SET ss_y='4' WHERE id='75';
UPDATE pokedex SET ss_x='0' WHERE id='76';
UPDATE pokedex SET ss_y='5' WHERE id='76';
UPDATE pokedex SET ss_x='1' WHERE id='77';
UPDATE pokedex SET ss_y='5' WHERE id='77';
UPDATE pokedex SET ss_x='2' WHERE id='78';
UPDATE pokedex SET ss_y='5' WHERE id='78';
UPDATE pokedex SET ss_x='3' WHERE id='79';
UPDATE pokedex SET ss_y='5' WHERE id='79';
UPDATE pokedex SET ss_x='4' WHERE id='80';
UPDATE pokedex SET ss_y='5' WHERE id='80';
UPDATE pokedex SET ss_x='5' WHERE id='81';
UPDATE pokedex SET ss_y='5' WHERE id='81';
UPDATE pokedex SET ss_x='6' WHERE id='82';
UPDATE pokedex SET ss_y='5' WHERE id='82';
UPDATE pokedex SET ss_x='7' WHERE id='83';
UPDATE pokedex SET ss_y='5' WHERE id='83';
UPDATE pokedex SET ss_x='8' WHERE id='84';
UPDATE pokedex SET ss_y='5' WHERE id='84';
UPDATE pokedex SET ss_x='9' WHERE id='85';
UPDATE pokedex SET ss_y='5' WHERE id='85';
UPDATE pokedex SET ss_x='10' WHERE id='86';
UPDATE pokedex SET ss_y='5' WHERE id='86';
UPDATE pokedex SET ss_x='11' WHERE id='87';
UPDATE pokedex SET ss_y='5' WHERE id='87';
UPDATE pokedex SET ss_x='12' WHERE id='88';
UPDATE pokedex SET ss_y='5' WHERE id='88';
UPDATE pokedex SET ss_x='13' WHERE id='89';
UPDATE pokedex SET ss_y='5' WHERE id='89';
UPDATE pokedex SET ss_x='14' WHERE id='90';
UPDATE pokedex SET ss_y='5' WHERE id='90';
UPDATE pokedex SET ss_x='0' WHERE id='91';
UPDATE pokedex SET ss_y='6' WHERE id='91';
UPDATE pokedex SET ss_x='1' WHERE id='92';
UPDATE pokedex SET ss_y='6' WHERE id='92';
UPDATE pokedex SET ss_x='2' WHERE id='93';
UPDATE pokedex SET ss_y='6' WHERE id='93';
UPDATE pokedex SET ss_x='3' WHERE id='94';
UPDATE pokedex SET ss_y='6' WHERE id='94';
UPDATE pokedex SET ss_x='4' WHERE id='95';
UPDATE pokedex SET ss_y='6' WHERE id='95';
UPDATE pokedex SET ss_x='5' WHERE id='96';
UPDATE pokedex SET ss_y='6' WHERE id='96';
UPDATE pokedex SET ss_x='6' WHERE id='97';
UPDATE pokedex SET ss_y='6' WHERE id='97';
UPDATE pokedex SET ss_x='7' WHERE id='98';
UPDATE pokedex SET ss_y='6' WHERE id='98';
UPDATE pokedex SET ss_x='8' WHERE id='99';
UPDATE pokedex SET ss_y='6' WHERE id='99';
UPDATE pokedex SET ss_x='9' WHERE id='100';
UPDATE pokedex SET ss_y='6' WHERE id='100';
UPDATE pokedex SET ss_x='10' WHERE id='101';
UPDATE pokedex SET ss_y='6' WHERE id='101';
UPDATE pokedex SET ss_x='11' WHERE id='102';
UPDATE pokedex SET ss_y='6' WHERE id='102';
UPDATE pokedex SET ss_x='12' WHERE id='103';
UPDATE pokedex SET ss_y='6' WHERE id='103';
UPDATE pokedex SET ss_x='13' WHERE id='104';
UPDATE pokedex SET ss_y='6' WHERE id='104';
UPDATE pokedex SET ss_x='14' WHERE id='105';
UPDATE pokedex SET ss_y='6' WHERE id='105';
UPDATE pokedex SET ss_x='0' WHERE id='106';
UPDATE pokedex SET ss_y='7' WHERE id='106';
UPDATE pokedex SET ss_x='1' WHERE id='107';
UPDATE pokedex SET ss_y='7' WHERE id='107';
UPDATE pokedex SET ss_x='2' WHERE id='108';
UPDATE pokedex SET ss_y='7' WHERE id='108';
UPDATE pokedex SET ss_x='3' WHERE id='109';
UPDATE pokedex SET ss_y='7' WHERE id='109';
UPDATE pokedex SET ss_x='4' WHERE id='110';
UPDATE pokedex SET ss_y='7' WHERE id='110';
UPDATE pokedex SET ss_x='5' WHERE id='111';
UPDATE pokedex SET ss_y='7' WHERE id='111';
UPDATE pokedex SET ss_x='6' WHERE id='112';
UPDATE pokedex SET ss_y='7' WHERE id='112';
UPDATE pokedex SET ss_x='7' WHERE id='113';
UPDATE pokedex SET ss_y='7' WHERE id='113';
UPDATE pokedex SET ss_x='8' WHERE id='114';
UPDATE pokedex SET ss_y='7' WHERE id='114';
UPDATE pokedex SET ss_x='9' WHERE id='115';
UPDATE pokedex SET ss_y='7' WHERE id='115';
UPDATE pokedex SET ss_x='10' WHERE id='116';
UPDATE pokedex SET ss_y='7' WHERE id='116';
UPDATE pokedex SET ss_x='11' WHERE id='117';
UPDATE pokedex SET ss_y='7' WHERE id='117';
UPDATE pokedex SET ss_x='12' WHERE id='118';
UPDATE pokedex SET ss_y='7' WHERE id='118';
UPDATE pokedex SET ss_x='13' WHERE id='119';
UPDATE pokedex SET ss_y='7' WHERE id='119';
UPDATE pokedex SET ss_x='14' WHERE id='120';
UPDATE pokedex SET ss_y='7' WHERE id='120';
UPDATE pokedex SET ss_x='0' WHERE id='121';
UPDATE pokedex SET ss_y='8' WHERE id='121';
UPDATE pokedex SET ss_x='1' WHERE id='122';
UPDATE pokedex SET ss_y='8' WHERE id='122';
UPDATE pokedex SET ss_x='2' WHERE id='123';
UPDATE pokedex SET ss_y='8' WHERE id='123';
UPDATE pokedex SET ss_x='3' WHERE id='124';
UPDATE pokedex SET ss_y='8' WHERE id='124';
UPDATE pokedex SET ss_x='4' WHERE id='125';
UPDATE pokedex SET ss_y='8' WHERE id='125';
UPDATE pokedex SET ss_x='5' WHERE id='126';
UPDATE pokedex SET ss_y='8' WHERE id='126';
UPDATE pokedex SET ss_x='6' WHERE id='127';
UPDATE pokedex SET ss_y='8' WHERE id='127';
UPDATE pokedex SET ss_x='7' WHERE id='128';
UPDATE pokedex SET ss_y='8' WHERE id='128';
UPDATE pokedex SET ss_x='8' WHERE id='129';
UPDATE pokedex SET ss_y='8' WHERE id='129';
UPDATE pokedex SET ss_x='9' WHERE id='130';
UPDATE pokedex SET ss_y='8' WHERE id='130';
UPDATE pokedex SET ss_x='10' WHERE id='131';
UPDATE pokedex SET ss_y='8' WHERE id='131';
UPDATE pokedex SET ss_x='11' WHERE id='132';
UPDATE pokedex SET ss_y='8' WHERE id='132';
UPDATE pokedex SET ss_x='12' WHERE id='133';
UPDATE pokedex SET ss_y='8' WHERE id='133';
UPDATE pokedex SET ss_x='13' WHERE id='134';
UPDATE pokedex SET ss_y='8' WHERE id='134';
UPDATE pokedex SET ss_x='14' WHERE id='135';
UPDATE pokedex SET ss_y='8' WHERE id='135';
UPDATE pokedex SET ss_x='0' WHERE id='136';
UPDATE pokedex SET ss_y='9' WHERE id='136';
UPDATE pokedex SET ss_x='1' WHERE id='137';
UPDATE pokedex SET ss_y='9' WHERE id='137';
UPDATE pokedex SET ss_x='2' WHERE id='138';
UPDATE pokedex SET ss_y='9' WHERE id='138';
UPDATE pokedex SET ss_x='3' WHERE id='139';
UPDATE pokedex SET ss_y='9' WHERE id='139';
UPDATE pokedex SET ss_x='4' WHERE id='140';
UPDATE pokedex SET ss_y='9' WHERE id='140';
UPDATE pokedex SET ss_x='5' WHERE id='141';
UPDATE pokedex SET ss_y='9' WHERE id='141';
UPDATE pokedex SET ss_x='6' WHERE id='142';
UPDATE pokedex SET ss_y='9' WHERE id='142';
UPDATE pokedex SET ss_x='7' WHERE id='143';
UPDATE pokedex SET ss_y='9' WHERE id='143';
UPDATE pokedex SET ss_x='8' WHERE id='144';
UPDATE pokedex SET ss_y='9' WHERE id='144';
UPDATE pokedex SET ss_x='9' WHERE id='145';
UPDATE pokedex SET ss_y='9' WHERE id='145';
UPDATE pokedex SET ss_x='10' WHERE id='146';
UPDATE pokedex SET ss_y='9' WHERE id='146';
UPDATE pokedex SET ss_x='11' WHERE id='147';
UPDATE pokedex SET ss_y='9' WHERE id='147';
UPDATE pokedex SET ss_x='12' WHERE id='148';
UPDATE pokedex SET ss_y='9' WHERE id='148';
UPDATE pokedex SET ss_x='13' WHERE id='149';
UPDATE pokedex SET ss_y='9' WHERE id='149';
UPDATE pokedex SET ss_x='14' WHERE id='150';
UPDATE pokedex SET ss_y='9' WHERE id='150';
UPDATE pokedex SET ss_x='0' WHERE id='151';
UPDATE pokedex SET ss_y='10' WHERE id='151';

Stv3n404 - 2023