Partner/Dev gesucht.

08/30/2012 18:46 lasttenebre#1
Tag zusammen.


Ich suche einen Partner (Eher gesagt Dev) der mir bei paar Kleinigkeiten (Wirklich Kleinigkeiten) hilft. Dies natürlich mit Gegenleistung.
Einfach Skype-Addy hier im Thread schicken.


Mit freundlichen Grüßen.
08/30/2012 18:52 FapMax#2
DrFapMax

Öffentliche Arbeit bei EPVP :
[Only registered and activated users can see links. Click Here To Register...]
08/30/2012 18:52 The-Apple#3
karolis3301
09/01/2012 19:36 lasttenebre#4
~push~?
09/01/2012 21:19 justBuy#5
Mein Skype: justBuy.epvp
Aber nur adden wenn du einen Root hast
09/01/2012 22:57 WarmongerTM#6
What jobs are looking to get done, and how much are you offering to do them?
09/01/2012 23:25 FapMax#7
Quote:
Originally Posted by WarmongerTM View Post
What jobs are looking to get done, and how much are you offering to do them?
he is offering nothing and have simple questions like "can you fix my SQL Command ?"

his question
Quote:
[30.08.2012 19:09:57] lasttenebre | EPVP: UPDATE t_item SET a_flag =60 WHERE a_flag = 62;
UPDATE t_item SET a_flag =89 WHERE a_flag = 91;
UPDATE t_item SET a_flag =25 WHERE a_flag = 27;
UPDATE t_item SET a_flag =124 WHERE a_flag = 126;
UPDATE t_item SET a_flag =24 WHERE a_flag = 26;
UPDATE t_item SET a_flag =2172 WHERE a_flag = 2174;
UPDATE t_item SET a_flag =40 WHERE a_flag = 42;
UPDATE t_item SET a_flag =265 WHERE a_flag = 267;
UPDATE t_item SET a_flag =281 WHERE a_flag = 283;
UPDATE t_item SET a_flag =9 WHERE a_flag = 11;
UPDATE t_item SET a_flag =40 WHERE a_flag = 42;
UPDATE t_item SET a_flag =3132 WHERE a_flag = 3134;
UPDATE t_item SET a_flag =60 WHERE a_flag = 134742078;

my fix
Quote:
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '60' WHERE `t_item`.`a_flag` = '62';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '89' WHERE `t_item`.`a_flag` = '91';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '25' WHERE `t_item`.`a_flag` = '27';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '124' WHERE `t_item`.`a_flag` = '126';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '24' WHERE `t_item`.`a_flag` = '26';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '2172' WHERE `t_item`.`a_flag` = '2174';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '40' WHERE `t_item`.`a_flag` = '42';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '265' WHERE `t_item`.`a_flag` = '267';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '281' WHERE `t_item`.`a_flag` = '283';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '9' WHERE `t_item`.`a_flag` = '11';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '40' WHERE `t_item`.`a_flag` = '42';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '3132' WHERE `t_item`.`a_flag` = '3134';
UPDATE `newproject_data`.`t_item` SET `t_item`.`a_flag` = '60' WHERE `t_item`.`a_flag` = '134742078';
09/02/2012 00:05 WarmongerTM#8
Quote:
Originally Posted by FapMax View Post
he is offering nothing and have simple questions like "can you fix my SQL Command ?"

his question



my fix
You don't need to specify the table name in the where statement, and it saves a lot of time typing if you just specify which database to use at the start. Other then that seems to me he should of just made a support thread. :)

Code:
USE newproject_data;
UPDATE t_item SET a_flag = '60' WHERE a_flag = '62';
UPDATE t_item SET a_flag = '89' WHERE a_flag = '91';
UPDATE t_item SET a_flag = '25' WHERE a_flag = '27';
UPDATE t_item SET a_flag = '124' WHERE a_flag = '126';
UPDATE t_item SET a_flag = '24' WHERE a_flag = '26';
UPDATE t_item SET a_flag = '2172' WHERE a_flag = '2174';
UPDATE t_item SET a_flag = '40' WHERE a_flag = '42';
UPDATE t_item SET a_flag = '265' WHERE a_flag = '267';
UPDATE t_item SET a_flag = '281' WHERE a_flag = '283';
UPDATE t_item SET a_flag = '9' WHERE a_flag = '11';
UPDATE t_item SET a_flag = '40' WHERE a_flag = '42';
UPDATE t_item SET a_flag = '3132' WHERE a_flag = '3134';
UPDATE t_item SET a_flag = '60' WHERE a_flag = '134742078';
09/02/2012 00:12 FapMax#9
Quote:
Originally Posted by WarmongerTM View Post
You don't need to specify the table name in the where statement, and it saves a lot of time typing if you just specify which database to use at the start. Other then that seems to me he should of just made a support thread. :)
I would have done this like that but how shoud i know that someone like him isnt executing every single Line by itself ? ;)

PS: i dont even had to use the apostrophe to seperate the Integer from the Command :P