Changeset 111
- Timestamp:
- Feb 19, 2009, 4:28:50 PM (16 years ago)
- Location:
- trunk
- Files:
-
- 1 added
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/img_level.php
r106 r111 93 93 94 94 //hlavní kod 95 if ($nothide) 96 $ID = $Database->SQLCommand('SELECT * FROM user'); 97 else 98 $ID = $Database->SQLCommand('SELECT * FROM user WHERE DATE_SUB(NOW(), INTERVAL 2 DAY) < LastLogin'); 95 if ($nothide) $ID = $Database->SQLCommand('SELECT ID,user FROM user'); 96 else $ID = $Database->SQLCommand('SELECT ID,user FROM user WHERE NeedUpdate = 1'); 97 99 98 while ($LineUser = mysql_fetch_array($ID)) { 100 $xp = GetXPFromTranslation($LineUser['ID']); 101 $Database->SQLCommand('UPDATE user SET XP = '.$xp.' WHERE ID = '.$LineUser['ID']); 102 CreateImg($LineUser['user'],$xp); 103 if ($nothide) echo ('<img src="tmp/'.$LineUser['user'].'/level.png" /><br>');99 $xp = GetXPFromTranslation($LineUser['ID']); //načítání XP 100 $Database->SQLCommand('UPDATE user SET XP = '.$xp.' WHERE ID = '.$LineUser['ID']); //ukládání XP pro řazení 101 CreateImg($LineUser['user'],$xp); //vytváření obrázku 102 if ($nothide) echo ('<img src="tmp/'.$LineUser['user'].'/level.png" /><br>'); 104 103 } 104 $Database->SQLCommand('UPDATE user SET NeedUpdate = 0'); 105 105 106 106 if ($nothide) ShowFooter(); -
trunk/save.php
r96 r111 49 49 //echo($sql); 50 50 $Database->SQLCommand($sql); 51 $Database->SQLCommand('UPDATE `user` SET `NeedUpdate` = 1 WHERE ID = '.$UserID); //informace o nutnosti načíst XP 51 52 // echo $sql.'<br />'; 52 53 echo('Změny v překladu: <a href="form.php?group='.$GroupId.'&ID='.$TextID.'">'.$TextID.'</a> uloženy!<br />'); -
trunk/sql/structure.sql
r85 r111 446 446 `Language` int(11) NOT NULL default '1', 447 447 `ExportSetting` text collate utf8_czech_ci NOT NULL, 448 `XP` int(11) NOT NULL default '0', 449 `NeedUpdate` int(11) NOT NULL default '0', 448 450 PRIMARY KEY (`ID`) 449 451 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=553 ;
Note:
See TracChangeset
for help on using the changeset viewer.