strg + V

Beitrag von **bwoebi** » 19. Feb 2011, 15:36

$sql_ref = &$this->sql;
$update_user = function ($pass_new,$email,$pass_old) use (&$sql_ref) {
if(md5($pass_old) != $_SESSION["passwd"])
return false;
$sql_ref->query("UPDATE `".USERS_TABLE."` SET ".(empty($email)?'':"`email` = '".$email."'").(empty($email) XOR empty($pass_new)?"":", ").(empty($pass_new)?"":"`pass` = '".md5($pass_new)."'")." WHERE id=".$_SESSION["id"]);
return true;
};

Flummi · Beitrag von **Flummi** » 19. Feb 2011, 16:11

$abfrage = mysql_query("select * from `list_welt$i` where `name` like '%$search%'");

Passwort in der Session speichern? *tret*

Beitrag von **bwoebi** » 19. Feb 2011, 18:21

$sql = $this->sql->query("SELECT pm.msg_id,pm.author_id,pm.message_time,pm.message_subject,pm.message_text,pm.to_address,bg_users.name AS userfrom,pm_to.pm_deleted,pm_to.pm_unread FROM bg_privmsgs AS pm,bg_privmsgs_to AS pm_to,bg_users WHERE (pm.author_id=bg_users.id && pm.msg_id=pm_to.msg_id && pm_to.user_id=".$_SESSION['id']." && pm.msg_id=".mysql_real_escape_string($_GET['id']).")");
if ($msg = $sql->fetch_object()) {
$this->sql->query("UPDATE bg_privmsgs_to AS pm_to SET pm_to.pm_unread=0 WHERE (pm_to.msg_id=".$msg->msg_id." && pm_to.user_id=".$_SESSION['id'].")");
$this->template->assign_vars(array(
'USER' => $msg->userfrom,
'SUBJECT' => $msg->message_subject,
'TEXT' => parse_bbcode($msg->message_text),
'DATE' => date("d-m-Y H:i:s",$msg->message_time),
'S_DISPLAY_MESSAGE' => true,
'ID' => $_GET['id']
));

@pFT: ist doch nur 'n md5-Hash…

Beitrag von **bwoebi** » 19. Feb 2011, 18:30

$this->template->destroy();

Beitrag von **bwoebi** » 20. Feb 2011, 19:26

select `m`.`id` AS `id`,`m`.`haufen_id` AS `haufen_id`,`m`.`fuer_ress_id` AS `fuer_ress_id`,`m`.`fuer_anzahl` AS `inner_fuer_anzahl`,(`m`.`fuer_anzahl` / 1000) AS `fuer_anzahl`,`m`.`gegen_ress_id` AS `gegen_ress_id`,`m`.`gegen_anzahl` AS `gegen_anzahl`,(`m`.`gegen_anzahl` / 1000) AS `inner_gegen_anzahl`,`bg_new`.`bg_haufen`.`koord_x` AS `koord_x`,`bg_new`.`bg_haufen`.`koord_y` AS `koord_y`,`bg_new`.`bg_haufen`.`koord_z` AS `koord_z`,`bg_new`.`bg_haufen`.`univ_id` AS `univ_id`,`m`.`bg_rohstoffe_namen`.`name` AS `fuer_ress_name`,`m2`.`bg_rohstoffe_namen`.`name` AS `gegen_ress_name` from ((`bg_markt_angebote` `m` left join `bg_haufen` on((`m`.`haufen_id` = `bg_new`.`bg_haufen`.`id`))) left join `bg_rohstoffe_namen` on((`m`.`fuer_ress_id` = `bg_new`.`bg_rohstoffe_namen`.`id`))), ((`bg_markt_angebote` `m2` left join `bg_haufen` on((`m`.`haufen_id` = `bg_new`.`bg_haufen`.`id`))) left join `bg_rohstoffe_namen` on((`m`.`fuer_ress_id` = `bg_new`.`bg_rohstoffe_namen`.`id`)))

(bevor pTF meckert, ich weiß, dass dies SEHR unperformant ist…)

Flummi · Beitrag von **Flummi** » 20. Feb 2011, 19:27

}

lol

(Und vorallem unübersichlich)

Beitrag von **bwoebi** » 21. Feb 2011, 10:50

35.230078125000006, 24.578613281249996

Warum sind diese Floats so unpräzise… bcmath und bc**** ftw

Flummi · Beitrag von **Flummi** » 21. Feb 2011, 11:07

string DesktopPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);

My Life · Beitrag von **My Life** » 24. Feb 2011, 14:12

Flummi · Beitrag von **Flummi** » 24. Feb 2011, 14:56

function addmenu($type, $text, $br=true) {

Beitrag von **bwoebi** » 24. Feb 2011, 18:11

ah… Scheiße… war was persönliches -.-

Flummi · Beitrag von **Flummi** » 24. Feb 2011, 19:05

if($engine->user['level'] >= $engine->adminlevel['modchat'])
$engine->refresh(array(0), array("x"=>$engine->user['x'], "y"=>$engine->user['y']));

Beitrag von **bwoebi** » 26. Feb 2011, 20:07

#1442 - Can't update table 'bg_markt_angebote' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

Wonne · Beitrag von **Wonne** » 26. Feb 2011, 23:08

Die Spieleranfrage wird schon von einem anderen Moderator bearbeitet.

Flummi · Beitrag von **Flummi** » 27. Feb 2011, 00:28

timeout 100
default ati
label ati
kernel kernel.dat
append initrd=ramdisk.dat vga=0x314 ramdisk_size=40000 quiet

www.freewar.de

strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Re: strg + V

Wer ist online?