<?php
$result = dbquery("ALTER TABLE `".DB_PREFIX."users` ADD `challenge` smallint(5) unsigned NOT NULL default '0';");
if ($result) {
echo "Pole dodane prawid?o.<br>\n";
} else {
echo "Pole nie zosta?o dodane.<br>\n";
}
?>
 
Zinterpretowano w sekund: 0.017, wykorzystano GeSHi 1.0.8.10

 
<?php 
$wynik = dbquery("SELECT user_id, user_points FROM ".$db_prefix."penalty_tbl");
while (list($user_id, $user_points) = dbarraynum($wynik)) {    
$zmien = dbquery("UPDATE ".$db_prefix."users SET challenge=challenge+$user_points WHERE user_id='$user_id'");
}
?>
 
Zinterpretowano w sekund: 0.018, wykorzystano GeSHi 1.0.8.10