[Erl] Sudoku Mod: Fehler in der Punkteberechnung beim Reset

[Dungeonwatcher]

Hi!

Im Sudoku Mod 1.0.7a gibt es einen "Schönheitsfehler" in der Berechnung der erreichten Punkte pro Spiel, wenn das Spielfeld resettet wird. D.h. es wird einfach auf -200 Punkte gesetzt, egal wie der Punktestand vor dem Resetten ist.

Dies führt dazu, das Folgendes möglich ist: Wenn ich alle Zahlen kaufe (bis auf die letzte Zahl) habe ich ca.1680 Minuspunkte. Lösche ich das Spielfeld wird der Punktestand (-1680) gelöscht und es wird der Punktestand von -200 angezeigt. Setzte ich jetzt die Zahlen wieder ein, komme ich auf einen Punktestand von mindestens 380 Punkten. Das ist von Spiel zu Spiel unterschiedlich, je nach dem wie viele Zahlen vorgegeben sind. Das lohnt sich ab der 7. gekauften Zahl.

Um dies zu korrigieren suche in der sudoku.php nach:

Code: Alles auswählen

	sudoku_starting_data($pack,$num, SUDOKU_STARTS,'');
	$sql=" UPDATE " . SUDOKU_USERS . "
	SET points=-200,line_1='" . $lrow['line_1'] . "',line_2='" . $lrow['line_2'] . "',line_3='" . $lrow['line_3'] . "',line_4='" . $lrow['line_4'] . "',line_5='" . $lrow['line_5'] . "',line_6='" . $lrow['line_6'] . "',line_7='" . $lrow['line_7'] . "',line_8='" . $lrow['line_8'] . "',line_9='" . $lrow['line_9'] . "'
	WHERE user_id=" . $userdata['user_id'] . "
	AND game_pack=$pack
	AND game_num=$num
	";

darin nach:

Code: Alles auswählen

SET points=-200

und ersetze dies durch:

Code: Alles auswählen

SET points=points-200

Bye

[Dungeonwatcher]

Moin!

Selbiges trifft auch auf die letzte Version 2.5.2 des Sudoku Mods für phpBB2 zu. Suche in der sudoku.php nach:

Code: Alles auswählen

	$sql=" UPDATE " . SUDOKU_USERS . "
		SET points=points-200,line_11='" . $lrow['line_11'] . "',line_12='" . $lrow['line_12'] . "',line_13='" . $lrow['line_13'] . "',line_14='" . $lrow['line_14'] . "',line_15='" . $lrow['line_15'] . "',line_16='" . $lrow['line_16'] . "',line_17='" . $lrow['line_17'] . "',line_18='" . $lrow['line_18'] . "',line_19='" . $lrow['line_19'] . "'
		WHERE user_id=" . $userdata['user_id'] . "
		AND game_type='sudoku'
		AND game_pack=$pack
		AND game_num=$num";

darin nach:

Code: Alles auswählen

SET points=points-200

Suche in der ninja.php nach:

Code: Alles auswählen

	$sql=" UPDATE " . SUDOKU_USERS . "
		SET points=-1800, line_11='" . $lrow['line_11'] . "',line_12='" . $lrow['line_12'] . "',line_13='" . $lrow['line_13'] . "',line_14='" . $lrow['line_14'] . "',line_15='" . $lrow['line_15'] . "',line_16='" . $lrow['line_16'] . "',line_17='" . $lrow['line_17'] . "',line_18='" . $lrow['line_18'] . "',line_19='" . $lrow['line_19'] . "',line_21='" . $lrow['line_21'] . "',line_22='" . $lrow['line_22'] . "',line_23='" . $lrow['line_23'] . "',line_24='" . $lrow['line_24'] . "',line_25='" . $lrow['line_25'] . "',line_26='" . $lrow['line_26'] . "',line_27='" . $lrow['line_27'] . "',line_28='" . $lrow['line_28'] . "',line_29='" . $lrow['line_29'] . "',line_32='" . $lrow['line_32'] . "',line_34='" . $lrow['line_34'] . "',line_35='" . $lrow['line_35'] . "',line_36='" . $lrow['line_36'] . "',line_38='" . $lrow['line_38'] . "',line_41='" . $lrow['line_41'] . "',line_42='" . $lrow['line_42'] . "',line_43='" . $lrow['line_43'] . "',line_44='" . $lrow['line_44'] . "',line_45='" . $lrow['line_45'] . "',line_46='" . $lrow['line_46'] . "',line_47='" . $lrow['line_47'] . "',line_48='" . $lrow['line_48'] . "',line_49='" . $lrow['line_49'] . "',line_51='" . $lrow['line_51'] . "',line_52='" . $lrow['line_52'] . "',line_53='" . $lrow['line_53'] . "',line_54='" . $lrow['line_54'] . "',line_55='" . $lrow['line_55'] . "',line_56='" . $lrow['line_56'] . "',line_57='" . $lrow['line_57'] . "',line_58='" . $lrow['line_58'] . "',line_59='" . $lrow['line_59'] . "',line_61='" . $lrow['line_61'] . "',line_62='" . $lrow['line_62'] . "',line_63='" . $lrow['line_63'] . "',line_64='" . $lrow['line_64'] . "',line_65='" . $lrow['line_65'] . "',line_66='" . $lrow['line_66'] . "',line_68='" . $lrow['line_68'] . "',line_71='" . $lrow['line_71'] . "',line_72='" . $lrow['line_72'] . "',line_74='" . $lrow['line_74'] . "',line_75='" . $lrow['line_75'] . "',line_76='" . $lrow['line_76'] . "',line_77='" . $lrow['line_77'] . "',line_78='" . $lrow['line_78'] . "',line_82='" . $lrow['line_82'] . "',line_83='" . $lrow['line_83'] . "',line_84='" . $lrow['line_84'] . "',line_85='" . $lrow['line_85'] . "',line_86='" . $lrow['line_86'] . "',line_88='" . $lrow['line_88'] . "',line_89='" . $lrow['line_89'] . "',line_92='" . $lrow['line_92'] . "',line_94='" . $lrow['line_94'] . "',line_95='" . $lrow['line_95'] . "',line_96='" . $lrow['line_96'] . "',line_97='" . $lrow['line_97'] . "',line_98='" . $lrow['line_98'] . "',line_99='" . $lrow['line_99'] . "'
		WHERE user_id=" . $userdata['user_id'] . "
		AND game_pack=$pack
		AND game_num=$num
		AND game_type='ninja'";

darim nach:

Code: Alles auswählen

SET points=-1800

ersetze es durch

Code: Alles auswählen

SET points=points-1800

Suche in der samurai.php nach:

Code: Alles auswählen

	$sql=" UPDATE " . SUDOKU_USERS . "
		SET points=-1000, line_11='" . $lrow['line_11'] . "',line_12='" . $lrow['line_12'] . "',line_13='" . $lrow['line_13'] . "',line_14='" . $lrow['line_14'] . "',line_15='" . $lrow['line_15'] . "',line_16='" . $lrow['line_16'] . "',line_17='" . $lrow['line_17'] . "',line_18='" . $lrow['line_18'] . "',line_19='" . $lrow['line_19'] . "',line_21='" . $lrow['line_21'] . "',line_22='" . $lrow['line_22'] . "',line_23='" . $lrow['line_23'] . "',line_24='" . $lrow['line_24'] . "',line_25='" . $lrow['line_25'] . "',line_26='" . $lrow['line_26'] . "',line_27='" . $lrow['line_27'] . "',line_28='" . $lrow['line_28'] . "',line_29='" . $lrow['line_29'] . "',line_32='" . $lrow['line_32'] . "',line_34='" . $lrow['line_34'] . "',line_35='" . $lrow['line_35'] . "',line_36='" . $lrow['line_36'] . "',line_38='" . $lrow['line_38'] . "',line_41='" . $lrow['line_41'] . "',line_42='" . $lrow['line_42'] . "',line_43='" . $lrow['line_43'] . "',line_44='" . $lrow['line_44'] . "',line_45='" . $lrow['line_45'] . "',line_46='" . $lrow['line_46'] . "',line_47='" . $lrow['line_47'] . "',line_48='" . $lrow['line_48'] . "',line_49='" . $lrow['line_49'] . "',line_51='" . $lrow['line_51'] . "',line_52='" . $lrow['line_52'] . "',line_53='" . $lrow['line_53'] . "',line_54='" . $lrow['line_54'] . "',line_55='" . $lrow['line_55'] . "',line_56='" . $lrow['line_56'] . "',line_57='" . $lrow['line_57'] . "',line_58='" . $lrow['line_58'] . "',line_59='" . $lrow['line_59'] . "'
		WHERE user_id=" . $userdata['user_id'] . "
		AND game_pack=$pack
		AND game_num=$num
		AND game_type='samurai'";

darim nach:

Code: Alles auswählen

SET points=-1000

ersetze es durch:

Code: Alles auswählen

SET points=points-1000

Bye]