https://wiki.jcihosting.com/api.php?action=feedcontributions&feedformat=atom&user=99.151.252.72 2026-04-23T12:18:04Z User contributions MediaWiki 1.42.3 https://wiki.jcihosting.com/index.php?title=Uncancel_in_MGMT&diff=1198 2013-04-03T02:20:36Z

<p>99.151.252.72: </p> <hr /> <div>this is a manual database update to the following tables: fields<br /> <br /> * customers: status-&gt;1<br /> ** update customers set status=&quot;1&quot; where cid=&quot;col02001&quot;;<br /> * ipmap: (for each ip) relen_date-&gt;null, status-&gt;1<br /> ** update ipmap set status=&quot;1&quot;, relen_date=&quot;null&quot; where ip=&quot;69.55.229.82&quot;;<br /> * subs: (for last/current sub(s)) status-&gt;1, stop_date-&gt;null<br /> ** select * from subs where sysid=&quot;5162&quot;;<br /> ** update subs set status=&quot;1&quot;, stop_date=&quot;null&quot; where subid=&quot;6350&quot;;<br /> * systems: status-&gt;1, stop_date-&gt;null, cancel_date-&gt;null<br /> ** select * from systems where sysid=&quot;5162&quot;;<br /> ** update systems set status=&quot;1&quot;, stop_date=&quot;null&quot;, cancel_date=&quot;null&quot; where sysid=&quot;5162&quot;;</div>

99.151.252.72