[ Milan041 @ 09.04.2007. 18:47 ] @
Code: <? include("header.php"); /* This tidbit sells all stocks and puts them in the Bank include("lib/stocks.php"); if ($users[turnsused] <= $config[protection]) TheEnd("Cannot trade on the stock market while under protection!"); //config & load $height = 400; $width = 25; $users[stocks] = explode("|", $users[stocks]); $stocknames = array(); $symbols = array(); $prices = array(); $days1 = array(); $days2 = array(); $days3 = array(); $q = mysql_safe_query("SELECT * FROM $stockdb;"); while($stock = mysql_fetch_array($q)) { $id = $stock['id']; $stocknames[$id] = $stock['name']; $symbols[$id] = $stock['symbol']; $prices[$id] = floor($stock['price']/1000) + $stock['boost']; if($prices[$id] > 200) $prices[$id] = 200; if($prices[$id] < 1) $prices[$id] = 1; $days1[$id] = floor($stock['days1']/1000); $days2[$id] = floor($stock['days2']/1000); $days3[$id] = floor($stock['days3']/1000); } echo "<pre>"; $pn = mysql_query("SELECT num FROM $playerdb;"); while($p = mysql_fetch_array($pn)) { $n = $p[num]; $user = loadUser($n); $st = explode("|", $user[stocks]); $earned = 0; foreach($st as $id => $amt) { $earned += $amt * $prices[$id+1]; } print_r($st); echo $earned."\n\n"; echo $user[savings]."\n\n"; $user[savings] += $earned; echo $user[savings]."\n\n"; $user[stocks] = ""; // saveUserData($user, "savings stocks", true); } echo "</pre>"; exit; */ if ($users[num] != 1) TheEnd("NISTE GLAVNI ADMINISTRATOR!"); if(isset($_POST['do_reset'])) { $cur_admin_pass = sqlsafeeval("SELECT password FROM $playerdb WHERE num=1;"); mysql_safe_query("DROP TABLE `$prefix"."_banned`, `$prefix"."_bounties`, `$prefix"."_clan`, `$prefix"."_clanmarket`, `$prefix"."_code`, `$prefix"."_cron`, `$prefix"."_forums`, `$prefix"."_lottery`, `$prefix"."_market`, `$prefix"."_messages`, `$prefix"."_misc`, `$prefix"."_news2`, `$prefix"."_players`, `$prefix"."_posts`, `$prefix"."_send_mails`, `$prefix"."_stockmarket`, `$prefix"."_topics`, `$prefix"."_users`;"); include("sql-setup.php"); $root = loadUser(1); $root[password] = $cur_admin_pass; $lockdb = 0; //to fool saveUserData saveUserData($root, "password"); TheEnd("IGRA JE U FAZI RESETOVANJA!"); } $tpl->display("dbadmin.html"); TheEnd(""); ?> Krenuo sam prvo od onoga oko cega treba da raspravljamo!Naime ovo je scripta za moju on line igru,ona bi trebala da kada se klikne na dugme reset vrati DB na 0 sto bi se reklo,sta mene zanima,meni treba db-a na 0 ali da ipak igraci koji su napravili naloge ostanu,jer sa ovim kodom se cak i oni brisu,a glupo je da ljudi moraju da se svakog 1. ponovo uclanjuju!Dakle treba se nesto izbaciti iz ovoga koda da se svi igraci vrate na pocetak,ali da ostanu registrovani,a ne i oni da nestanu! Unapred hvala na odgovorima! |