if(command=="pre")
{
int[] ids;
ids=sqlsearch("SELECT id FROM prebot WHERE pre='"+arg+"'");
if(ids.Length==0)
send(csend+"Rls not found");
else
{
for(int i=0;i<ids.Length;i++)
{
if(ids[i]==0)
{
send(csend+"Rls not found");
break;
}
string timediff;
try
{
timediff =Zeitdiff(Convert.ToDouble(sqlsend("select zeit FROM prebot where id='"+ids[i]+"'")));
}
catch
{
timediff="no Time aviable";
}
string x=(sqlsend("select section FROM prebot where id='"+ids[i]+"'")+" "
+sqlsend("select pre FROM prebot where id='"+ids[i]+"'")+" "
+sqlsend("select nukedesc FROM prebot where id='"+ids[i]+"'")+" "
+sqlsend("select unnukedesc FROM prebot where id='"+ids[i]+"'")+timediff
);
send(csend+x);
}
}
}
if(command=="dupe")
{
int[] ids;
ids=sqlsearch("SELECT id FROM prebot WHERE pre like '%"+arg+"%' ORDER BY id DESC");
if(ids.Length==0)
send(csend+"Rls not found");
else
{
send(csend+("Showing last 10 Pres:"));
for(int i=0;i<ids.Length;i++)
{
if(ids[i]==0)
{
send(csend+"Rls not found");
break;
}
string timediff;
try
{
timediff =Zeitdiff(Convert.ToDouble(sqlsend("select zeit FROM prebot where id='"+ids[i]+"'")));
}
catch
{timediff="no Time aviable";}
string x=(sqlsend("select section FROM prebot where id='"+ids[i]+"'")+" "
+sqlsend("select pre FROM prebot where id='"+ids[i]+"'")+" "
+sqlsend("select nukedesc FROM prebot where id='"+ids[i]+"'")+" "
+sqlsend("select unnukedesc FROM prebot where id='"+ids[i]+"'")+timediff
);
send(csend+x);
}
}
}