pillage

[GoogleCodeExporter]

* Raison du ticket *pillage error in debug mode in GM script
-

* Lien & version de 'eude' *1.4.5.1
-

* Système d'exploitation/navigateur *firefox
-

* Caractéristiques hébergeur *webhost.com
-

* Informations complémentaire *ok i get this when i click on log

XML error, disabling 'eude'...

Data Engine send:
Unknown column 'Player' in 'where clause'

File: class/dataengine.class.php (Line: 95)
Function: parse_backtrace
Args: 

File: class/troops.class.php (Line: 62)
Function: sql
Args: SELECT * FROM SQL_PREFIX_troops_pillage WHERE Player='armageddon' AND 
date=1280024760

File: xml/eude.php (Line: 125)
Function: AddPillage_log
Args: defender, 1280024760, Sir! 
Doolsy has left our planet NewWales. The occupation has ended. 
 He scavenged the following resources: 
Hydrogen:  4

my data dase looks good but here it is for you to see

CREATE TABLE IF NOT EXISTS `SQL_PREFIX_troops_pillage` (
  `pid` int(11) NOT NULL auto_increment,
  `mid` int(11) NOT NULL,
  `Player` varchar(30) NOT NULL,
  `ress0` int(11) NOT NULL,
  `ress1` int(11) NOT NULL,
  `ress2` int(11) NOT NULL,
  `ress3` int(11) NOT NULL,
  `ress4` int(11) NOT NULL,
  `ress5` int(11) NOT NULL,
  `ress6` int(11) NOT NULL,
  `ress7` int(11) NOT NULL,
  `ress8` int(11) NOT NULL,
  `ress9` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY  (`pid`),
  KEY `mid` (`mid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

** Inclure des copies de ce qui marche pas copier/coller/screenshot **

Original issue reported on code.google.com by lifelong...@yahoo.co.uk on 27 Jul 2010 at 8:11

[GoogleCodeExporter]

@life i dont get any xml error's i can add the ground battle log fine my 
problem is it wont pickup the looting log did u update the files when Alex 
changed them maybe we can swap files if u tell me which ones you need 

curtis

Original comment by lee.leed...@gtempaccount.com on 27 Jul 2010 at 8:47

[GoogleCodeExporter]

This: "Unknown column 'Player' in 'where clause'"
And:
"CREATE TABLE IF NOT EXISTS `SQL_PREFIX_troops_pillage` (
  `pid` int(11) NOT NULL auto_increment,
  `mid` int(11) NOT NULL,
  `Player` varchar(30) NOT NULL, [...]"

Just not possible.

mysql can't find column 'Player', and you, you have found it... something is 
wrong, isn't it ?

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 8:55

• Changed state: Incomplet

[GoogleCodeExporter]

curtis i have deleted my logs can you raid me please if we are not allies game 
name _Armageddon_ so i can retest and yes i have up todate files i update then 
every time an error gets fixed

Original comment by lifelong...@yahoo.co.uk on 27 Jul 2010 at 9:07

[GoogleCodeExporter]

Where you found this ?
CREATE TABLE IF NOT EXISTS `SQL_PREFIX_troops_pillage` (
  `pid` int(11) NOT NULL auto_increment,
  `mid` int(11) NOT NULL,
  `Player` varchar(30) NOT NULL,
  `ress0` int(11) NOT NULL,
  `ress1` int(11) NOT NULL,
  `ress2` int(11) NOT NULL,
  `ress3` int(11) NOT NULL,
  `ress4` int(11) NOT NULL,
  `ress5` int(11) NOT NULL,
  `ress6` int(11) NOT NULL,
  `ress7` int(11) NOT NULL,
  `ress8` int(11) NOT NULL,
  `ress9` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY  (`pid`),
  KEY `mid` (`mid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 9:18

[GoogleCodeExporter]

and also i will do a test on the english test server too to see if i get the 
same error

Original comment by lifelong...@yahoo.co.uk on 27 Jul 2010 at 9:19

[GoogleCodeExporter]

You will not have same error on test server, column 'Player' exists on it. 
Does you have reading me ? I have English so bad ?

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 9:27

[GoogleCodeExporter]

Alex i think this is part of the same problem in the 511.script line 1775
there is no xml refereance thats the only reference i can fine for the 
Page: /gamelog/gamelog_view.php?gamelog_id=49097952

function gamelog_spooler () {
    ident = $x('/html/body/div[2]/div/div/table/tbody/tr[2]/td[4]')[0].innerHTML;

    if (ident.indexOf(i18n[c_game_lang]['troop_log_att']) == 0) troop_log('attacker');
    if (ident.indexOf(i18n[c_game_lang]['troop_log_def']) == 0) troop_log('defender');

}

Original comment by lee.leed...@gtempaccount.com on 27 Jul 2010 at 9:39

[GoogleCodeExporter]

nope, not for him, it database structure is imcomplete.

And of course, script need also to be translated.

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 9:48

[GoogleCodeExporter]

for

"i18n[c_game_lang]['troop_log_def']"

see screenshot (if this can help translation)

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 9:54

Attachments:

• issue298-1.png

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

the scrpit shows this i18n['en']['troop_log_def']  = 'Robbed by';

screen shot of my data base structure so you can see that the correct DB is 
there 

Original comment by lifelong...@yahoo.co.uk on 27 Jul 2010 at 11:14

Attachments:

• test12.PNG

[GoogleCodeExporter]

thx Alex i checked that and all seems to be fine 

i18n['en']['troop_log_def']  = ' Robbed by';
i18n['en']['troop_log_att']  = ' Leave planet';

still does not pick up the resouces stolen it add the battle log fine that 
works ok just does not pick up the looting log

// class (detections)
$lng['defender_regex'] = '(.*) has left our planet (.*). The occupation has 
ended.';
$lng['defender_regex_planetid'] = 1;
$lng['defender_regex_userid'] = 2;
$lng['defender_ident'] = 'He scavenged the following resources:';
$lng['attacker_regex'] = 'Our troops have left the planet (.*) of (.*). The 
occupation has ended.';
$lng['attacker_regex_planetid'] = 1;
$lng['attacker_regex_userid'] = 2;
$lng['attacker_ident'] = 'We have taken the following commodities:';

Original comment by lee.leed...@gtempaccount.com on 27 Jul 2010 at 11:17

[GoogleCodeExporter]

#11, Soo this error can't be "Unknown column 'Player' in 'where clause'"...

Should be inverted for you ?
$lng['defender_regex_planetid'] = 2;
$lng['defender_regex_userid'] = 1;
$lng['attacker_regex_planetid'] = 2;
$lng['attacker_regex_userid'] = 1;

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 11:21

[GoogleCodeExporter]

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 11:22

• Added labels: i18n, i18n-en

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

$lng['defender_regex'] = '/(.*) has left our planet (.*)\. The occupation has 
ended\./';
$lng['defender_regex_planetid'] = 2;
$lng['defender_regex_userid'] = 1;
$lng['defender_ident'] = 'He scavenged the following resources:';

$lng['attacker_regex'] = '/Our troops have left the planet (.*) of (.*)\. The 
occupation has ended\./';
$lng['attacker_regex_planetid'] = 2;
$lng['attacker_regex_userid'] = 1;
$lng['attacker_ident'] = 'We have taken the following commodities:';

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 11:26

[GoogleCodeExporter]

ok i changed them round and still nothing

// class (detections)
$lng['defender_regex'] = '(.*) has left our planet (.*). The occupation has 
ended.\./';
$lng['defender_regex_planetid'] = 2;
$lng['defender_regex_userid'] = 1;
$lng['defender_ident'] = 'He scavenged the following resources:';
$lng['attacker_regex'] = 'Our troops have left the planet (.*) of (.*). The 
occupation has ended.\./';
$lng['attacker_regex_planetid'] = 2;
$lng['attacker_regex_userid'] = 1;
$lng['attacker_ident'] = 'We have taken the following commodities:';

Original comment by lee.leed...@gtempaccount.com on 27 Jul 2010 at 11:27

[GoogleCodeExporter]

Regex need to to be exactly like mine ! Do no modify them.

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 11:32

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

ok this is what i have now and still not work

// class (detections)
$lng['defender_regex'] = '/(.*) has left our planet (.*)\. The occupation has 
ended\./';
$lng['defender_regex_planetid'] = 2;
$lng['defender_regex_userid'] = 1;
$lng['defender_ident'] = 'He scavenged the following resources:';

$lng['attacker_regex'] = '/Our troops have left the planet (.*) of (.*)\. The 
occupation has ended\./';
$lng['attacker_regex_planetid'] = 2;
$lng['attacker_regex_userid'] = 1;
$lng['attacker_ident'] = 'We have taken the following commodities:';

Original comment by lee.leed...@gtempaccount.com on 27 Jul 2010 at 11:36

[GoogleCodeExporter]

This should work: "The occupation has ended\./';"
This will never work: "The occupation has ended.\./';"

see: http://en.wikipedia.org/wiki/Regular_expression

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 11:37

[GoogleCodeExporter]

Ok.... (omg, three time to get same thing)

So, what's "not work" =)
Log Screenshot ?

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 11:42

• Changed state: En-attente

[GoogleCodeExporter]

when i click on the looting log nothing happens it opens the looting log to view

Information
    Title       Robbed by bazmando!
    Type        Looting
    Date        27.07.2010 21:35
Message
Sir!
bazmando has left our planet mucca. The occupation has ended.
He scavenged the following resources:
Titanium: 1
Copper: 1
Iron: 1
Aluminium: 1
Mercury: 1
Silicon: 1
Uranium: 1
Krypton: 1
Nitrogen: 1
Hydrogen: 1

Information
    Title       Leave planet
    Type        Looting
    Date        26.07.2010 21:57
Message
Sir!
Our troops have left the planet MOutpost of valheru100. The occupation has 
ended.
300000 troops have returned to our transports, unfortunately there wasn't 
enough room for 0 troops. These troops had to be left behind.
We have taken the following commodities:
Titanium: 1
Copper: 1
Iron: 1
Aluminium: 11.371
Mercury: 1
Silicon: 1
Uranium: 1
Krypton: 10.715
Nitrogen: 1
Hydrogen: 1

Original comment by lee.leed...@gtempaccount.com on 27 Jul 2010 at 11:44

[GoogleCodeExporter]

Without space at beginning ?

i18n['en']['troop_log_def']  = 'Robbed by';
i18n['en']['troop_log_att']  = 'Leave planet';

Original comment by Alex10336@gmail.com on 27 Jul 2010 at 11:50

[GoogleCodeExporter]

Star alex ok the robbed by lof now works

the radi log however gives this 

$lng['log_coordsnotfound'] = 'Coordinates Not Found ? ()';

Original comment by lee.leed...@gtempaccount.com on 27 Jul 2010 at 11:57

[GoogleCodeExporter]

Current SS need to be up to date.

Coords are found within planet name and player name. If any one cannot be 
found, coords also.

Original comment by Alex10336@gmail.com on 28 Jul 2010 at 12:04

[GoogleCodeExporter]

Oh, "robbed by"

So page "/ownuniverse.php" need to by filled.

Original comment by Alex10336@gmail.com on 28 Jul 2010 at 12:06

[GoogleCodeExporter]

ok just checked it made sure the ss was uptodate and still getting the same

'Coordinates Not Found ? ()';

Original comment by lee.leed...@gtempaccount.com on 28 Jul 2010 at 12:10

[GoogleCodeExporter]

ok made sure my player info and control center info is uptodate all are loaded 
onto the dataengine still get same

'Coordinates Not Found ? ()';

Original comment by lee.leed...@gtempaccount.com on 28 Jul 2010 at 12:14

[GoogleCodeExporter]

Oh The Robbed by section works

its the leave planet section that gives

'Coordinates Not Found ? ()';

Original comment by lee.leed...@gtempaccount.com on 28 Jul 2010 at 12:15

[GoogleCodeExporter]

sweet i got it alex

// class (detections)
$lng['defender_regex'] = '/(.*) has left our planet (.*)\. The occupation has 
ended\./';
$lng['defender_regex_planetid'] = 2;
$lng['defender_regex_userid'] = 1;
$lng['defender_ident'] = 'He scavenged the following resources:';

$lng['attacker_regex'] = '/Our troops have left the planet (.*) of (.*)\. The 
occupation has ended\./';
$lng['attacker_regex_planetid'] = 1;
$lng['attacker_regex_userid'] = 2;
$lng['attacker_ident'] = 'We have taken the following commodities:';

everything now works thanks a lot 10/10

Original comment by lee.leed...@gtempaccount.com on 28 Jul 2010 at 12:18

[GoogleCodeExporter]

nice =)

Original comment by Alex10336@gmail.com on 28 Jul 2010 at 12:23

[GoogleCodeExporter]

i will check everthing tomorrow and send u all the updated files

for the english version

thx Again alex

Original comment by lee.leed...@gtempaccount.com on 28 Jul 2010 at 12:27

[GoogleCodeExporter]

Ok,

Thanks too ;)

Original comment by Alex10336@gmail.com on 28 Jul 2010 at 12:29

[GoogleCodeExporter]

ok its working it was my fault as i did not change my site address in game to 
my test site i had it on my main site and i feel like a prick now ty for your 
help and curtis too you may close the issue and thanks again

Original comment by lifelong...@yahoo.co.uk on 28 Jul 2010 at 11:08

[GoogleCodeExporter]

Original comment by XCharism...@gmail.com on 28 Jul 2010 at 4:10

• Changed state: Done