function first_schedule($tournament, $members, $numplayers) { global $stage, $id, $fights, $num; $id = $tournament; $q = select("select * from ft_tournaments where TournamentID='{$id}'"); if ($q[StatusID] != 0) { return 0; } if ($members + 1 != $numplayers) { return 0; } $r = select("select * from ft_stages where TournamentTypeID={$q['TournamentTypeID']} and Tour1=1 limit 0,1"); $res2 = runsql("select * from ft_tournament_members where TournamentID='{$id}' order by rand()"); for ($k = 1; $k <= $numplayers; $k++) { $r2 = mysql_fetch_array($res2); $users[$k] = $r2[UserID]; } if ($r[TypeID] == 0) { for ($k = 1; $k <= $numplayers; $k++) { runsql("update ft_tmp_agreements set UserID1='{$users[$k]}',\nLogin1=(select concat(if(GuildID>0 and GuildStatusID=1,concat('<img src=/images/gd_guilds/small/',GuildID,'.jpg border=0 align=absmiddle>','</a> '),''),'<a href=/users/',UserID,'/>',Login,'</a>') from ut_users where UserID='{$users[$k]}') \n where TournamentID='{$id}' and Tour=1 and Pair1='{$k}'"); runsql("update ft_tmp_agreements set UserID2='{$users[$k]}',\nLogin2=(select concat(if(GuildID>0 and GuildStatusID=1,concat('<img src=/images/gd_guilds/small/',GuildID,'.jpg border=0 align=absmiddle>','</a> '),''),'<a href=/users/',UserID,'/>',Login,'</a>') from ut_users where UserID='{$users[$k]}') \n where TournamentID='{$id}' and Tour=1 and Pair2='{$k}'"); } } else { for ($k = 1; $k <= $numplayers; $k++) { runsql("update ft_tmp_agreements set UserID1='{$users[$k]}',\nLogin1=(select concat(if(GuildID>0 and GuildStatusID=1,concat('<img src=/images/gd_guilds/small/',GuildID,'.jpg border=0 align=absmiddle>','</a> '),''),'<a href=/users/',UserID,'/>',Login,'</a>') from ut_users where UserID='{$users[$k]}') \n where TournamentID='{$id}' and Stage=1 and Pair1='{$k}'"); runsql("update ft_tmp_agreements set UserID2='{$users[$k]}',\nLogin2=(select concat(if(GuildID>0 and GuildStatusID=1,concat('<img src=/images/gd_guilds/small/',GuildID,'.jpg border=0 align=absmiddle>','</a> '),''),'<a href=/users/',UserID,'/>',Login,'</a>') from ut_users where UserID='{$users[$k]}') \n where TournamentID='{$id}' and Stage=1 and Pair2='{$k}'"); runsql("update ft_groups set UserID='{$users[$k]}',Login=(select concat(if(GuildID>0 and GuildStatusID=1,concat('<a href=/guilds/',GuildID,'><img src=/images/gd_guilds/small/',GuildID,'.jpg border=0 align=absmiddle>','</a> '),''),'<a href=/users/',UserID,'/>',Login,'</a>') from ut_users where UserID='{$users[$k]}') where TournamentID='{$id}' and Stage=1 and Pair='{$k}'"); } } runsql("delete from ft_agreements where TournamentID='{$id}'"); runsql("insert into ft_agreements\n(UserID1,UserID2,TypeID,ExtraGlad,LimitGlad,LimitSkl,Timeout,TournamentID,Stage,Tour,Fight,Pair,NumFights,StageTypeID,Approved,StatusID,Date,Login1,Login2) \n(select UserID1,UserID2,TypeID,ExtraGlad,LimitGlad,LimitSkl,Timeout,TournamentID ,Stage,Tour,Fight,Pair,NumFights,StageTypeID, 1,2,unix_timestamp(),Login1,Login2\nfrom ft_tmp_agreements where TournamentID='{$id}' and Tour=1 and Fight=1)"); runsql("update ft_tournaments set StatusID=1 where TournamentID='{$id}'"); }
function DrawPart($parent, $pref) { $res = runsql("select t.{$this->id},t.Name_\$lang; as Name from {$this->table} t left outer join {$this->table} p on p.{$this->id}=t.{$this->id} where t.Parent='{$parent}' and t.{$this->id}<>t.Parent group by t.{$this->id} order by t.Name_\$lang;"); if (mysql_error()) { print mysql_error(); exit; } while ($r = mysql_fetch_array($res)) { $num++; unset($str); if ($pref) { $str = "{$pref}"; } if ($this->numbered == 1) { $str .= "{$num}."; } elseif ($parent != '0') { $str .= " "; } if ($this->type == "select") { print " <option value=\"{$r['0']}\""; if ($r[0] == $this->val) { print " selected"; } print ">{$str} {$r['1']}</option>"; } else { print "{$str} <a href=\"{$PHP_SELF}?id={$r['0']}\">{$r['1']}</a>"; print "<br>"; } $r[types] += $this->DrawPart($r[0], $str); } return $r[types]; }
function savetag($item, $key, $wid) { global $tbpref; if (!in_array($item, $_SESSION['TAGS'])) { runsql('insert into ' . $tbpref . 'tags (TgText) values(' . convert_string_to_sqlsyntax($item) . ')', ""); get_tags($refresh = 1); } runsql('insert ignore into ' . $tbpref . 'wordtags (WtWoID, WtTgID) select ' . $wid . ', TgID from ' . $tbpref . 'tags where TgText = ' . convert_string_to_sqlsyntax($item), ""); }
function update($conn, $tablename, $targettablename, $sql, $count) { $recs = reccount($conn, $tablename); $added = addedcount($conn, $targettablename); echo "\n Records - " . $recs; $attempts = get_attempts($recs - $added, $count); for ($x = 0; $x < $attempts; $x++) { $start = $added + $x * $count; $tmp = $sql . " LIMIT " . $start . "," . $count . ";"; //echo "\n" . $tmp; runsql($conn, $tmp); } }
function rec($id) { global $_GET, $type, $_POST; $q = select("select AnswerID from ut_messages where MessageID='{$id}'"); $row = runsql("select * from ut_messages where MessageID='{$q['0']}'"); if (mysql_num_rows($row)) { while ($r1 = mysql_fetch_array($row)) { print "<img src=/images/hr.gif height=10px width=473px style=\"margin-top:5px;margin-bottom:5px\">"; $_GET['id'] = $r1[MessageID]; $f = new cls_form($type, "message"); $f->Draw(); } rec($q[0]); } }
function block_sql($paramarr, $multicachekey = '', $returncount = 0) { global $_G, $_SGLOBAL, $_GET, $_SERVER; if (!empty($paramarr['sql'])) { require_once B_ROOT . './source/function/block_sql.func.php'; if ($returncount > 0) { return runsql($paramarr, '', 1); } list($sqlstring, $listcount) = runsql($paramarr, '', 0, $multicachekey); if (!empty($paramarr['perpage'])) { if ($listcount) { $urlarr = $_GET; foreach ($urlarr as $key => $value) { if (empty($value)) { unset($urlarr[$key]); } else { $urlarr[$key] = rawurlencode($urlarr[$key]); } } unset($urlarr['page']); $phpurl = arraytostring($urlarr, '=', '&'); $phpurl = $phpurl ? 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['SCRIPT_NAME'] . '?' . $phpurl : 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['SCRIPT_NAME']; $theblockarr['multipage'] = multi($listcount, $paramarr['perpage'], $_GET['page'], rawurldecode($phpurl), 1); $theblockarr['listcount'] = $listcount; } } } //查詢數據 if ($listcount) { //查詢 $query = DB::query($sqlstring); while ($value = DB::fetch($query)) { if (isset($value['subjectimage'])) { $value['thumb'] = getattachurl($value['subjectimage'], 1); $value['subjectimage'] = getattachurl($value['subjectimage']); } $theblockarr[] = $value; } } return $theblockarr; }
function drawpanel($id, $blocks) { global $auth, $lang; print "<center><table border=0 cellspacing=0 cellpadding=5><td valign=top width=160px>"; $res = runsql("select m1.*,m1.Name_{$lang} as name,count(m2.MenuID) as cnt from en_menu m1\n\nleft outer join en_menu m2 on m2.Parent=m1.MenuID\nwhere m1.Parent='{$id}'\ngroup by m1.MenuID\n order by Rang"); $num = 0; while ($r = mysql_fetch_array($res)) { if ($r[cnt] > 0) { if ($num > 0 && $num % $blocks == 0 && $num < $blocks * 3) { print "</td><td valign=top width=160px>"; } $num++; print "<table border=0 width=100% cellspacing=1 cellpadding=3 bgcolor=d3d3d3 ><td class=header>"; $r = printmenu($r); print "<center><b>{$r['name']}</b></a></center>"; print "</td></table>"; $res1 = runsql("select m1.*,m1.Name_{$lang} as name,count(m2.MenuID) as cnt from en_menu m1\n\nleft outer join en_menu m2 on m2.Parent=m1.MenuID\nwhere m1.Parent='{$r['MenuID']}'\ngroup by m1.MenuID\n order by Rang"); while ($r1 = mysql_fetch_array($res1)) { print "<table border=0 width=100% cellspacing=1 cellpadding=3 bgcolor=d3d3d3 ><td bgcolor=FFFAE4>"; $r1 = printmenu($r1); if (!$r1[cnt]) { print "» <a href=\"{$r1['Url']}\" {$r1['Target']}>{$r1['name']}</a><br>"; } else { print "» {$r1['name']}<br>"; } $res2 = runsql("select *,Name_{$lang} as name from en_menu where Name_{$lang}<>'{$r1['Name']}' and Parent='{$r1['MenuID']}' order by Rang"); while ($r2 = mysql_fetch_array($res2)) { $r2 = printmenu($r2); print " - <a href=\"{$r2['Url']}\" {$r2['Target']}>{$r2['name']}</a><br>"; } print "</td></table>"; } print "<br>"; } } print "</table>"; }
<?php include "../include/functions.php"; include "../include/db.php"; ?> <?php include "../include/params.php"; include "../include/dictionary2.php"; session_start(); opendb(); $opis = getQUERY("o"); $rbr = getQUERY("rbr"); $h = getQUERY("h"); $ppid = getQUERY("ppid"); $pointkm = getQUERY("pointkm"); $pointtime = getQUERY("pointtime"); $h1 = getQUERY("h1"); $predefined = getQUERY("predefined"); $sqlInsert = "insert into rnalogdetail (opis, ppid, hederid, rbr, poikm, poitime) values ('" . $opis . "', " . $ppid . ", " . $h . ", " . $rbr . ", " . $pointkm . ", " . $pointtime . ") "; runsql($sqlInsert); if ($predefined . '' == 'true') { $sqlInsert = "insert into rnalogdetailpre (opis, ppid, hederid, rbr, poikm, poitime) values ('" . $opis . "', " . $ppid . ", " . $h1 . ", " . $rbr . ", " . $pointkm . ", " . $pointtime . ") "; runsql($sqlInsert); } print "OK"; closedb();
?> ]</td></tr> <?php $gladiator[Level] = $q[Level]; ?> <form name="distribution" method="post" enctype="multipart/form-data" action="/xml/gladiators/level.php?type=gladiators/train&act=distribution"> <input type="hidden" name="step" value="1"/> <input type="hidden" name="id" value="<?php echo $id; ?> "/> <?php $res = runsql("select *,Name_{$lang} as Name from ut_abilities where AbilityID>=1 and AbilityID<=6 order by AbilityID"); while ($r = mysql_fetch_array($res)) { if ($r[AbilityID] <= 2) { print "<tr bgcolor=#545E61><td>{$r['Name']}</td><td >" . $gladiator[$r[Ability]] . "</td></tr>"; } else { print "<tr bgcolor=#545E61><td>{$r['Name']}</td><td>\n<input type=\"button\" onclick=\"changeAbility('{$r['Ability']}',-1)\" id=\"{$r['Ability']}Minus\" class=disabledbutton style=\"width:20;\" value=\"-\"> \n<input type=\"string\" id=\"{$r['Ability']}\" size=\"2\" name=\"{$r['Ability']}\" readonly class=clear style=\"text-align:center;height:16px\" value=\"" . $gladiator[$r[Ability]] . "\"> \n<input type=\"hidden\" id=\"Cur{$r['Ability']}\" value=\"" . $gladiator[$r[Ability]] . "\"> \n<input type=\"button\" onclick=\"changeAbility('{$r['Ability']}',1)\" id=\"{$r['Ability']}Plus\" class=bluebutton style=\"width:20\" value=\"+\"></td>"; } if ($r[AbilityID] == 2) { print "<tr bgcolor=#545E61><td colspan=3>" . message(251) . ": <input type=\"string\" size=\"2\" name=\"Points\" id=\"Points\" readonly class=clear value=\"{$points}\" > </td></tr>"; } } ?> <tr><td colspan=3 bgcolor=#68717> <input class=disabledbutton type=submit id="Submit" value=—охранить onclick="this.disabled = true; this.className='disabledbutton'; document.getElementById('VitMinus').disabled = true;
print "\r\n <tr>\r\n <td width=\"130\" align=\"center\" valign=\"top\"><img src=\"{$img_url}?id={$r['MaterialID']}&record=2\" alt=\"\" width=\"69\"></td>\r\n <td valign=\"top\"><h5>" . $r[Title] . "</h5>\r\n <p>" . $r[Headline] . "</p>\r\n <p align=\"right\"><a href=\"{$site_url}" . "news.php?id={$r['MaterialID']}\" class=\"lnk\">подробнее</a></p></td>\r\n </tr>\r\n\t "; } ?> </table> <?php print "<table width=100% cellspacing=0 cellpadding=2 border=0>"; $form->Pages(''); print "</table>"; ?> </td> </tr> <tr> <td valign="top"><img src="images/mid/shad2.jpg" alt="" width="248" height="27"></td> </tr> </table> <?php } else { $res = runsql("select MaterialID,Date,Headline_{$lang} as Headline, Name_{$lang} as Title, Message_{$lang} as Message, Small from ut_materials where MaterialID={$id}"); while ($r = mysql_fetch_array($res)) { print "\r\n\t\t\t<h3>" . $r[Title] . "</h3><br>"; if ($r[Small]) { print "<img src=\"{$img_url}?id={$r['MaterialID']}&record=1\" alt=\"{$r['Title']}\" align=\"left\" style=\"margin-right: 6px;\"></img>"; } print "<p>" . settags($r[Message]) . "</p>"; } } require "bottom.php";
?> images/text-guest.gif" alt="" width="172" height="17" border="0"></a></td> <td><a href="/screenshots.php"><img src="<?php echo $site_url; ?> images/text-screenshots.gif" alt="" width="121" height="17" border="0"></a></td> </tr> </table> <?php if ($type != "main/screenshots") { ?> <table width="500" border="0" cellspacing="8" cellpadding="0" style="margin: 0px 0px 0px 16px;"> <tr> <?php $res = runsql("select ScreenshotID,Name_{$lang} as Name from ut_screenshots order by rand() limit 0,3"); while ($r = mysql_fetch_array($res)) { ?> <td width="33%" align="center" valign="top"> <?php print "<a href=\"screen.php?record=14&id={$r['0']}\">"; print "<img src=\"/images/ut_screenshots/small/{$r['0']}.jpg\" border=0 "; if ($r[Name]) { print " alt=\"{$r['Name']}\" title=\"{$r['Name']}\""; } print "/> \n"; ?> </a></td> <?php }
<?php $type = "products"; require "up.php"; if (!$id) { $id = '3'; } $res = runsql("select p.*, p.Name_{$lang} as Name, p.Description_{$lang} as Description, t.Name_{$lang} as Type from ut_products p \r\nleft outer join ut_product_types t using(TypeID) where ProductID={$id}"); $r = mysql_fetch_array($res); print "\r\n\t<h3>" . $r[Name] . "</h3><br>\r\n \t<h5> ласс: " . $r[Type] . "</h5><br>"; if ($r[Image]) { print "<img src=\"{$img_url}?id={$r['ProductID']}&record=9\"><br>"; } print settags($r[Description]); require "bottom.php";
if ($stchange > 0) { $stchange = 1; } } else { $stchange = $stchange + 0; $status = $oldstatus + $stchange; if ($status < 1) { $status = 1; } if ($status > 5) { $status = 5; } } $word = get_first_value("select WoText as value from words where WoID = " . $wid); pagestart("Term: " . $word, false); $m1 = runsql('update words set WoStatus = ' . $status . ', WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID = ' . $wid, 'Status changed'); $newscore = get_first_value('select greatest(0,round(WoTodayScore,0)) AS value from words where WoID = ' . $wid) + 0; if ($oldstatus == $status) { echo '<p>Status ' . get_colored_status_msg($status) . ' not changed.</p>'; } else { echo '<p>Status changed from ' . get_colored_status_msg($oldstatus) . ' to ' . get_colored_status_msg($status) . '.</p>'; } echo "<p>Old score was " . $oldscore . ", new score is now " . $newscore . ".</p>"; $totaltests = $_SESSION['testtotal']; $wrong = $_SESSION['testwrong']; $correct = $_SESSION['testcorrect']; $notyettested = $totaltests - $correct - $wrong; if ($notyettested > 0) { if ($stchange >= 0) { $_SESSION['testcorrect']++; } else {
$type = "city/market"; $_POST['user'] = $user; $res = select("select MarketDate from ut_users where UserID='{$auth->user}'"); if (date("d", mktime() - 5 * 3600) != date("d", $res[0]) || date("m", mktime() - 5 * 3600) != date("m", $res[0])) { runsql("update ut_users set MarketDate=unix_timestamp()-5*3600 where UserID='{$auth->user}'"); runsql("delete from ut_slaves where UserID='{$auth->user}'"); runsql("insert into ut_slaves (TypeID, CountryID, Age, Talent, Height, Weight, UserID)\n(select @t:=\n(select TypeID from ut_gladiator_types where TypeID<8 order by rand() limit 1) as TypeID,\n(select CountryID from ut_gladiator_countries where TypeID=@t order by Rate*rand()*rand() desc,Rate desc limit 1) as CountryID,\n@age:=round(18+20*rand()) as Age,\n\n@talent:=if((select @a:=(1000*rand()))>0,\nif(@a<90,1,if(@a<280,2,if(@a<550,3,if(@a<740,4,if(@a<850,5,if(@a<950,6,if(@a<995,7,if(@a<999,8,9)))))))),\nif(@a<90,1,if(@a<280,2,if(@a<550,3,if(@a<740,4,if(@a<850,5,if(@a<950,6,if(@a<995,7,if(@a<999,8,9))))))))\n) as Talent, \n@h:=round(160+30*rand())+(select Height from ut_gladiator_types where TypeID=@t) as Height, \nround(@h-115+50*rand())+(select Weight from ut_gladiator_types where TypeID=@t) as Weight,\n\n'{$auth->user}' as UserID\n\nfrom en_numbers where Number<11)"); $res = runsql("select CountryID,GladiatorID from ut_slaves where UserID='{$auth->user}'"); while ($r = mysql_fetch_array($res)) { unset($a); $level = mt_rand(1, 5); for ($i = 1; $i <= $level * 3; $i++) { $a[mt_rand(0, 3)] += 1; } $n = select("select Name from ut_gladiator_names where CountryID='{$r['CountryID']}' order by rand() limit 1"); runsql("update ut_slaves g set Name='{$n['Name']}',Level='{$level}',Acc=1+'{$a['0']}',Vit=1+'{$a['1']}',Str=1+'{$a['2']}',Dex=1+'{$a['3']}',\nPrice=round(power(1.18,'{$level}')*(12/(10-Talent)-1)*(select Coefficient from ut_gladiator_types where TypeID=g.TypeID)*1.5*EXP((Age-23)*(Age-23)/-200)*100) where GladiatorID='{$r['GladiatorID']}'"); } } require $site_path . "up.php"; if ($form_ok) { $form = new cls_form($type, 'select'); $act = "select"; } require $site_path . "left.php"; ?> <center><img src="/images/art/market.jpg" width=500px height=300px></center> <?php $r1 = select("select sum(Slots) as Slots from tm_buildings where UserID='{$auth->user}'"); foreach ($auth->rst[Gladiators] as $k => $v) { $t = $v[TypeID]; $q = select("select Slots from ut_gladiator_types where TypeID='{$t}'");
Developed by J. Pierre in 2011. ***************************************************************/ /************************************************************** Call: delete_mword.php?wid=[wordid]&tid=[textid] Delete an expression ***************************************************************/ include "connect.inc.php"; include "settings.inc.php"; include "utilities.inc.php"; $showAll = getSetting('showallwords'); $showAll = $showAll == '' ? 1 : ((int) $showAll != 0 ? 1 : 0); $tid = $_REQUEST['tid']; $wid = $_REQUEST['wid']; $word = get_first_value("select WoText as value from words where WoID = " . $wid); pagestart("Term: " . $word, false); $m1 = runsql('delete from words where WoID = ' . $wid, ''); adjust_autoincr('words', 'WoID'); echo "<p>OK, term deleted (" . $m1 . ").</p>"; ?> <script type="text/javascript"> //<![CDATA[ var context = window.parent.frames['l'].document; var contexth = window.parent.frames['h'].document; $('.word<?php echo $wid; ?> ', context).removeClass('status1 status2 status3 status4 status5 status98 status99 word<?php echo $wid; ?> ').addClass('hide').attr('data_status','').attr('data_trans','').attr('data_rom','').attr('data_wid','').attr('title',''); $('#learnstatus', contexth).html('<?php
function savetag($item, $key, $wid) { global $tbpref; runsql('insert into ' . $tbpref . 'tags (TgText) values(' . convert_string_to_sqlsyntax($item) . ')', ""); runsql('insert into ' . $tbpref . 'wordtags (WtWoID, WtTgID) select ' . $wid . ', TgID from ' . $tbpref . 'tags where TgText = ' . convert_string_to_sqlsyntax($item), ""); }
function TourName($large) { $res = runsql("select Name_\$lang; as Name,Tour1,Tour2,Reglament from ut_reglaments where TournamentID='{$this->tournament}' and (Tour1<={$this->tour} and Tour2>={$this->tour}) "); $r = mysql_fetch_array($res); return TName($this->tour, $r, $large); }
Setting all unknown words to Well Known (99) ***************************************************************/ require_once 'settings.inc.php'; require_once 'connect.inc.php'; require_once 'dbutils.inc.php'; require_once 'utilities.inc.php'; $langid = get_first_value("select TxLgID as value from " . $tbpref . "texts where TxID = " . $_REQUEST['text']); pagestart("Setting all blue words to Well-known", false); $sql = 'select distinct TiText, TiTextLC from (' . $tbpref . 'textitems left join ' . $tbpref . 'words on (TiTextLC = WoTextLC) and (TiLgID = WoLgID)) where TiIsNotWord = 0 and WoID is null and TiWordCount = 1 and TiTxID = ' . $_REQUEST['text'] . ' order by TiOrder'; $res = do_mysql_query($sql); $count = 0; $javascript = "var title='';"; while ($record = mysql_fetch_assoc($res)) { $term = $record['TiText']; $termlc = $record['TiTextLC']; $count1 = 0 + runsql('insert into ' . $tbpref . 'words (WoLgID, WoText, WoTextLC, WoStatus, WoStatusChanged,' . make_score_random_insert_update('iv') . ') values( ' . $langid . ', ' . convert_string_to_sqlsyntax($term) . ', ' . convert_string_to_sqlsyntax($termlc) . ', 99 , NOW(), ' . make_score_random_insert_update('id') . ')', ''); $wid = get_last_key(); if ($count1 > 0) { $javascript .= "title = make_tooltip(" . prepare_textdata_js($term) . ",'*','','99');"; } $javascript .= "\$('.TERM" . strToClassName($termlc) . "', context).removeClass('status0').addClass('status99 word" . $wid . "').attr('data_status','99').attr('data_wid','" . $wid . "').attr('title',title);"; $count += $count1; } mysql_free_result($res); echo "<p>OK, you know all " . $count . " word(s) well!</p>"; ?> <script type="text/javascript"> //<![CDATA[ var context = window.parent.frames['l'].document; var contexth = window.parent.frames['h'].document; <?php
$allaction = $_REQUEST['allaction']; if ($allaction == 'delall') { $message = runsql('delete from tags where (1=1) ' . $wh_query, "Deleted"); runsql("DELETE wordtags FROM (wordtags LEFT JOIN tags on WtTgID = TgID) WHERE TgID IS NULL", ''); adjust_autoincr('tags', 'TgID'); } } elseif (isset($_REQUEST['del'])) { $message = runsql('delete from tags where TgID = ' . $_REQUEST['del'], "Deleted"); runsql("DELETE wordtags FROM (wordtags LEFT JOIN tags on WtTgID = TgID) WHERE TgID IS NULL", ''); adjust_autoincr('tags', 'TgID'); } elseif (isset($_REQUEST['op'])) { // INSERT if ($_REQUEST['op'] == 'Save') { $message = runsql('insert into tags (TgText, TgComment) values(' . convert_string_to_sqlsyntax($_REQUEST["TgText"]) . ', ' . convert_string_to_sqlsyntax_nonull($_REQUEST["TgComment"]) . ')', "Saved"); } elseif ($_REQUEST['op'] == 'Change') { $message = runsql('update tags set TgText = ' . convert_string_to_sqlsyntax($_REQUEST["TgText"]) . ', TgComment = ' . convert_string_to_sqlsyntax_nonull($_REQUEST["TgComment"]) . ' where TgID = ' . $_REQUEST["TgID"], "Updated"); } } // NEW if (isset($_REQUEST['new'])) { ?> <h4>New Tag</h4> <form name="newtag" class="validate" action="<?php echo $_SERVER['PHP_SELF']; ?> " method="post"> <table class="tab3" cellspacing="0" cellpadding="5"> <tr> <td class="td1 right">Tag:</td> <td class="td1"><input class="notempty setfocus noblanksnocomma" type="text" name="TgText" data_info="Tag" value="" maxlength="20" size="20" /> <img src="icn/status-busy.png" title="Field must not be empty" alt="Field must not be empty" /></td>
$allaction = $_REQUEST['allaction']; if ($allaction == 'delall') { $message = runsql('delete from ' . $tbpref . 'tags where (1=1) ' . $wh_query, "Deleted"); runsql("DELETE " . $tbpref . "wordtags FROM (" . $tbpref . "wordtags LEFT JOIN " . $tbpref . "tags on WtTgID = TgID) WHERE TgID IS NULL", ''); adjust_autoincr('tags', 'TgID'); } } elseif (isset($_REQUEST['del'])) { $message = runsql('delete from ' . $tbpref . 'tags where TgID = ' . $_REQUEST['del'], "Deleted"); runsql("DELETE " . $tbpref . "wordtags FROM (" . $tbpref . "wordtags LEFT JOIN " . $tbpref . "tags on WtTgID = TgID) WHERE TgID IS NULL", ''); adjust_autoincr('tags', 'TgID'); } elseif (isset($_REQUEST['op'])) { // INSERT if ($_REQUEST['op'] == 'Save') { $message = runsql('insert into ' . $tbpref . 'tags (TgText, TgComment) values(' . convert_string_to_sqlsyntax($_REQUEST["TgText"]) . ', ' . convert_string_to_sqlsyntax_nonull($_REQUEST["TgComment"]) . ')', "Saved", $sqlerrdie = FALSE); } elseif ($_REQUEST['op'] == 'Change') { $message = runsql('update ' . $tbpref . 'tags set TgText = ' . convert_string_to_sqlsyntax($_REQUEST["TgText"]) . ', TgComment = ' . convert_string_to_sqlsyntax_nonull($_REQUEST["TgComment"]) . ' where TgID = ' . $_REQUEST["TgID"], "Updated", $sqlerrdie = FALSE); } } // NEW if (isset($_REQUEST['new'])) { ?> <h4>New Tag</h4> <script type="text/javascript" src="js/unloadformcheck.js" charset="utf-8"></script> <form name="newtag" class="validate" action="<?php echo $_SERVER['PHP_SELF']; ?> " method="post"> <table class="tab3" cellspacing="0" cellpadding="5"> <tr> <td class="td1 right">Tag:</td>
function block_uchspace($paramarr) { global $_SGLOBAL, $_SC, $_SGET; dbconnect(2); if (empty($paramarr['sql'])) { $sql = array(); $sql['select'] = 'SELECT s.*'; $sql['from'] = 'FROM ' . tname('space', '2') . ' s'; if (!empty($paramarr['showdetail'])) { $sql['select'] = 'SELECT sf.*, s.*'; $sql['from'] .= ' LEFT JOIN ' . tname('spacefield', '2') . ' sf ON sf.uid=s.uid'; } $wherearr = array(); //where if (!empty($paramarr['uid'])) { $paramarr['uid'] = getdotstring($paramarr['uid'], 'int'); if ($paramarr['uid']) { $wherearr[] = 's.uid IN (' . $paramarr['uid'] . ')'; } } else { if (!empty($paramarr['avatar'])) { if ($paramarr['avatar'] == 1) { $wherearr[] = 's.avatar = 0'; } else { $wherearr[] = 's.avatar = 1'; } } $scopequery = getscopequery('s', 'viewnum', $paramarr); if (!empty($scopequery)) { $wherearr[] = $scopequery; } $scopequery = getscopequery('s', 'friendnum', $paramarr); if (!empty($scopequery)) { $wherearr[] = $scopequery; } } $sql['where'] = ''; if (!empty($wherearr)) { $sql['where'] = 'WHERE ' . implode(' AND ', $wherearr); } //order if (!empty($paramarr['order'])) { $sql['order'] = 'ORDER BY ' . $paramarr['order']; } //limit if (!empty($paramarr['perpage'])) { $paramarr['perpage'] = intval($paramarr['perpage']); if (empty($paramarr['perpage'])) { $paramarr['perpage'] = 20; } if (empty($_SGET['page'])) { $_SGET['page'] = 1; } $_SGET['page'] = intval($_SGET['page']); if ($_SGET['page'] < 1) { $_SGET['page'] = 1; } $start = ($_SGET['page'] - 1) * $paramarr['perpage']; $sql['limit'] = 'LIMIT ' . $start . ',' . $paramarr['perpage']; } else { if (empty($paramarr['limit'])) { $sql['limit'] = 'LIMIT 0,1'; } else { $paramarr['limit'] = getdotstring($paramarr['limit'], 'int', true, array(), 1, false); if ($paramarr['limit']) { $sql['limit'] = 'LIMIT ' . $paramarr['limit']; } else { $sql['limit'] = 'LIMIT 0,1'; } } } //query $sqlstring = implode(' ', $sql); //multi $listcount = 1; if (!empty($paramarr['perpage'])) { $listcount = $_SGLOBAL['db_uch']->result($_SGLOBAL['db_uch']->query('SELECT COUNT(*) FROM ' . tname('space', '2') . ' ' . $sql['where']), 0); if ($listcount) { $urlarr = $_SGET; unset($urlarr['page']); $theblockarr['multipage'] = multi($listcount, $paramarr['perpage'], $_SGET['page'], $urlarr, 0); } } } else { $uchdb = $_SGLOBAL['db_uch']; include_once S_ROOT . './function/block_sql.func.php'; list($sqlstring, $listcount) = runsql($paramarr, $uchdb); if (!empty($paramarr['perpage'])) { if ($listcount) { $urlarr = $_SGET; unset($urlarr['page']); $theblockarr['multipage'] = multi($listcount, $paramarr['perpage'], $_SGET['page'], $urlarr, 0); } } } //查询数据 if ($listcount) { //预处理 include_once S_ROOT . './uc_client/client.php'; //查询 $query = $_SGLOBAL['db_uch']->query($sqlstring); while ($value = $_SGLOBAL['db_uch']->fetch_array($query)) { //头像处理 $value['avatarflash'] = uc_avatar($_SGLOBAL['supe_uid']); $theblockarr[] = $value; } } return $theblockarr; }
For more information, please refer to [http://unlicense.org/]. ***************************************************************/ /************************************************************** Call: delete_word.php?wid=[wordid]&tid=[textid] Delete a word ***************************************************************/ require_once 'settings.inc.php'; require_once 'connect.inc.php'; require_once 'dbutils.inc.php'; require_once 'utilities.inc.php'; $tid = $_REQUEST['tid']; $wid = $_REQUEST['wid']; $term = get_first_value("select WoText as value from " . $tbpref . "words where WoID = " . $wid); pagestart("Term: " . $term, false); $m1 = runsql('delete from ' . $tbpref . 'words where WoID = ' . $wid, ''); adjust_autoincr('words', 'WoID'); echo "<p>OK, term deleted, now unknown (" . $m1 . ").</p>"; ?> <script type="text/javascript"> //<![CDATA[ var context = window.parent.frames['l'].document; var contexth = window.parent.frames['h'].document; var title = make_tooltip(<?php echo prepare_textdata_js($term); ?> ,'','',''); $('.word<?php echo $wid; ?> ', context).removeClass('status99 status98 status1 status2 status3 status4 status5 word<?php
function tree($project, $daycount, $id, $task, $level, $str, $color, $parent, $own) { global $lang, $j, $auth; $res = runsql("select TypeID, Name_{$lang} as Name \r\n from ut_product_types \r\norder by TypeID asc"); $parent = 0; $j = 1; if ($level == 10) { print "Бесконечный цикл"; exit; } if (mysql_num_rows($res) > 0) { $i = 1; while ($r = mysql_fetch_array($res)) { print "<a href='javascript:;' id='menu" . $j . "parent" . $parent . "' onclick='return checkSubMenus(this)'><b>"; print "<font color=black>"; print $str . $i . ". {$r['Name']}</b></font>"; $res1 = runsql("select ProductID, Name_{$lang} as Name \r\n\t\t\tfrom ut_products \r\n\t\t\twhere TypeID='{$r['TypeID']}' order by ProductID asc"); if (mysql_num_rows($res1) > 0) { $parent2 = $j; //$today=mktime(0,0,0,date("m",time()),date("d",time()),date("Y",time())); while ($r1 = mysql_fetch_array($res1)) { print "<a href='products.php?id={$r1['ProductID']}' style='display:block' id='menu" . $j . "parent" . $parent2 . "' title='{$products}'>- {$r1['Name']}</a>"; } } print "<br>"; $i++; $j++; } } }
function rec($id) { global $type, $HTTP_POST_VARS; $q = select("select AnswerID from ut_messages where MessageID='{$id}'"); $row = runsql("select * from ut_messages where MessageID='{$q['0']}'"); if (mysql_num_rows($row)) { while ($r1 = mysql_fetch_array($row)) { print "<hr>"; $HTTP_GET_VARS['id'] = $r1[MessageID]; $HTTP_POST_VARS['id'] = $r1[MessageID]; $f = new cls_form($type, "message"); $f->Draw(); } rec($q[0]); } }
require_once 'utilities.inc.php'; $message = ""; if (isset($_REQUEST['delpref'])) { if ($_REQUEST['delpref'] !== '-') { $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_archivedtexts', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_archtexttags', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_languages', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_sentences', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_tags', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_tags2', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_textitems', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_texts', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_texttags', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_words', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_wordtags', ''); $dummy = runsql('DROP TABLE ' . $_REQUEST['delpref'] . '_settings', ''); $message = 'Table Set "' . $_REQUEST['delpref'] . '" deleted'; if ($_REQUEST['delpref'] == substr($tbpref, 0, -1)) { $tbpref = ""; LWTTableSet("current_table_prefix", $tbpref); } } } elseif (isset($_REQUEST['newpref'])) { if (in_array($_REQUEST['newpref'], getprefixes())) { $message = 'Table Set "' . $_REQUEST['newpref'] . '" already exists'; } else { $tbpref = $_REQUEST['newpref']; LWTTableSet("current_table_prefix", $tbpref); header("Location: index.php"); exit; }
foreach ($rst[Gladiators] as $k => $gladiator) { //старение--------------------- if (round(date("d", mktime())) == 1) { $rst[Gladiators][$k][Age] = $rst[Gladiators][$k][Age] + 1; } //тренировка-------------------- $exp = expgained($rst, 1); if ($k == 103) { print "{$exp} -- "; exit; } if (strlen($exp)) { $rst[Gladiators][$k][Exp] = floor($rst[Gladiators][$k][Exp] + $exp); //print "$k=> ".$rst[Gladiators][$k][Exp]." = ".expgained($rst,1)."<br>"; $rst[Gladiators][$k][NextTrain] = 0; runsql("update ut_gladiators \nset \nExp='" . $rst[Gladiators][$k][Exp] . "',\nLevel='" . $rst[Gladiators][$k][Level] . "',\nTypeID='" . $rst[Gladiators][$k][TypeID] . "',\nRating='" . $rst[Gladiators][$k][Rating] . "',\nVit='" . $rst[Gladiators][$k][Vit] . "',\nDex='" . $rst[Gladiators][$k][Dex] . "',\nAcc='" . $rst[Gladiators][$k][Acc] . "',\nStr='" . $rst[Gladiators][$k][Str] . "',\nVit='" . $rst[Gladiators][$k][Vit] . "',\n\nWin='" . $rst[Gladiators][$k][Win] . "',\nTie='" . $rst[Gladiators][$k][Tie] . "',\nLose='" . $rst[Gladiators][$k][Lose] . "'\n\nwhere GladiatorID='{$k}'"); } if ($rst[Gladiators][$k][StatusID] > 1) { $salary += round($rst[Gladiators][$k][Price] / 10); } } $rst[TrainDate] = mktime(); $money = moneygained($rst, 1); $rst[ShopDate] = mktime(); //print "$money,1,$r[UserID] (лавка)<br>---------------"; if ($money > 0) { $rst = short_transfer_money($rst, $money, 1, $r[UserID], 20, 0); } //print "$salary,$r[UserID],1 (зарплата гладиаторов)<br>---------------"; if ($salary > 0) { $rst = short_transfer_money($rst, $salary, $r[UserID], 1, 19, 0);
unless such conditions are required by law. Developed by J. Pierre in 2011. ***************************************************************/ /************************************************************** Call: insert_word_wellknown.php?tid=[textid]&ord=[textpos] Ignore single word (new term with status 99) ***************************************************************/ include "connect.inc.php"; include "settings.inc.php"; include "utilities.inc.php"; $word = get_first_value("select TiText as value from textitems where TiWordCount = 1 and TiTxID = " . $_REQUEST['tid'] . " and TiOrder = " . $_REQUEST['ord']); $wordlc = mb_strtolower($word, 'UTF-8'); $langid = get_first_value("select TxLgID as value from texts where TxID = " . $_REQUEST['tid']); pagestart("Term: " . $word, false); $m1 = runsql('insert into words (WoLgID, WoText, WoTextLC, WoStatus, WoStatusChanged,' . make_score_random_insert_update('iv') . ') values( ' . $langid . ', ' . convert_string_to_sqlsyntax($word) . ', ' . convert_string_to_sqlsyntax($wordlc) . ', 99, NOW(), ' . make_score_random_insert_update('id') . ')', 'Term added'); $wid = get_last_key(); echo "<p>OK, you know this term well!</p>"; $hex = strToClassName($wordlc); ?> <script type="text/javascript"> //<![CDATA[ var context = window.parent.frames['l'].document; var contexth = window.parent.frames['h'].document; var title = make_tooltip(<?php echo prepare_textdata_js($word); ?> ,'*','','99'); $('.TERM<?php echo $hex; ?>
saveSetting('set-test-l-framewidth-percent', $_REQUEST['set-test-l-framewidth-percent']); saveSetting('set-test-r-frameheight-percent', $_REQUEST['set-test-r-frameheight-percent']); saveSetting('set-player-skin-name', $_REQUEST['set-player-skin-name']); saveSetting('set-test-main-frame-waiting-time', $_REQUEST['set-test-main-frame-waiting-time']); saveSetting('set-test-edit-frame-waiting-time', $_REQUEST['set-test-edit-frame-waiting-time']); saveSetting('set-test-sentence-count', $_REQUEST['set-test-sentence-count']); saveSetting('set-term-sentence-count', $_REQUEST['set-term-sentence-count']); saveSetting('set-archivedtexts-per-page', $_REQUEST['set-archivedtexts-per-page']); saveSetting('set-texts-per-page', $_REQUEST['set-texts-per-page']); saveSetting('set-terms-per-page', $_REQUEST['set-terms-per-page']); saveSetting('set-tags-per-page', $_REQUEST['set-tags-per-page']); saveSetting('set-show-text-word-counts', $_REQUEST['set-show-text-word-counts']); saveSetting('set-text-visit-statuses-via-key', $_REQUEST['set-text-visit-statuses-via-key']); $message = 'Settings saved'; } else { $dummy = runsql("delete from settings where StKey like 'set-%'", ''); $message = 'All Settings reset to default values'; } } echo error_message_with_hide($message, 1); ?> <form class="validate" action="<?php echo $_SERVER['PHP_SELF']; ?> " method="post"> <table class="tab3" cellspacing="0" cellpadding="5"> <!-- ******************************************************* --> <tr> <th class="th1">Group</th> <th class="th1">Description</th>
$message = runsql('delete from archivedtexts where AtID = ' . $_REQUEST['del'], "Archived Texts deleted"); adjust_autoincr('archivedtexts', 'AtID'); runsql("DELETE archtexttags FROM (archtexttags LEFT JOIN archivedtexts on AgAtID = AtID) WHERE AtID IS NULL", ''); } elseif (isset($_REQUEST['unarch'])) { $message2 = runsql('insert into texts (TxLgID, TxTitle, TxText, TxAudioURI) select AtLgID, AtTitle, AtText, AtAudioURI from archivedtexts where AtID = ' . $_REQUEST['unarch'], "Texts added"); $id = get_last_key(); runsql('insert into texttags (TtTxID, TtT2ID) select ' . $id . ', AgT2ID from archtexttags where AgAtID = ' . $_REQUEST['unarch'], ""); splitText(get_first_value('select TxText as value from texts where TxID = ' . $id), get_first_value('select TxLgID as value from texts where TxID = ' . $id), $id); $message1 = runsql('delete from archivedtexts where AtID = ' . $_REQUEST['unarch'], "Archived Texts deleted"); $message = $message1 . " / " . $message2 . " / Sentences added: " . get_first_value('select count(*) as value from sentences where SeTxID = ' . $id) . " / Text items added: " . get_first_value('select count(*) as value from textitems where TiTxID = ' . $id); adjust_autoincr('archivedtexts', 'AtID'); runsql("DELETE archtexttags FROM (archtexttags LEFT JOIN archivedtexts on AgAtID = AtID) WHERE AtID IS NULL", ''); } elseif (isset($_REQUEST['op'])) { // UPDATE if ($_REQUEST['op'] == 'Change') { $message = runsql('update archivedtexts set ' . 'AtLgID = ' . $_REQUEST["AtLgID"] . ', ' . 'AtTitle = ' . convert_string_to_sqlsyntax($_REQUEST["AtTitle"]) . ', ' . 'AtText = ' . convert_string_to_sqlsyntax($_REQUEST["AtText"]) . ', ' . 'AtAudioURI = ' . convert_string_to_sqlsyntax($_REQUEST["AtAudioURI"]) . ' ' . 'where AtID = ' . $_REQUEST["AtID"], "Updated"); $id = $_REQUEST["AtID"]; } saveArchivedTextTags($id); } // CHG if (isset($_REQUEST['chg'])) { $sql = 'select AtLgID, AtTitle, AtText, AtAudioURI from archivedtexts where AtID = ' . $_REQUEST['chg']; $res = mysql_query($sql); if ($res == FALSE) { die("Invalid Query: {$sql}"); } if ($record = mysql_fetch_assoc($res)) { ?> <h4>Edit Archived Text</h4>
function xml2bd() { global $Xml, $Type, $Act, $PageID, $id, $site_path, $error; while (strstr($Xml, "<--")) { $Xml = substr($Xml, 0, strpos($Xml, "<--")) . substr($Xml, strpos($Xml, "-->", strpos($Xml, "<--")) + 3); } if (!$Type) { $q = select("select @Type"); $Type = $q[0]; } if (!$Site) { $q = select("select @Site"); $Site = $q[0]; } $id = $PageID; $Xml = stripslashes($Xml); $tmp = new cls_xml(); $tmp->loadxml($Xml); $item = $tmp->documentElement; $a = $item->ownerDocument->nodes[0]; $Act = $a->tagname; if (!$item) { runsql("set @error='Not valid XML'"); } else { $item->Xml2File($Type, $Act); } //if(file_exists($site_path."xml/".$Site.$Type.)) }