Bravo List - Translation to greek unknown parts of the code

Bravo List (http://www.bvlist.com/index.php)

- BT.Manager (phpMyBitTorrent) (http://www.bvlist.com/forumdisplay.php?f=23)

- - Translation to greek unknown parts of the code (http://www.bvlist.com/showthread.php?t=8255)

Translation to greek unknown parts of the code

Hi i am giving a big try to translate the parts of pmbt that do not exist in language.php but in .php pages. I believe i am over 90% of the translation but there ase some things i need to find and i can't...

1.first the tiny login word in picture 1
2.second in pm.php the inbox/oubox word in picture 2
3.third in details.php?id=1 i the parts in red (view snatched:, [view!], nuked, no , REQUIST A RESEED:, [RESEED NOW!])
4.Last in torrents comments we see "Add a Quick Thankyou to the uploader"

Bump: 2.Inbox/outbox of picture up and right found and successfully edited.Was in pm/inbox.php and pm/outbox.php

Bump: 4.The "thank you" message was in ajax.php

Bump: 3.Found it in ajax.php

Hey Joe i want to translate these 2 lines and change the background colours of them...do you remember where they are located?

i am refering to the green and red message..

I managed to translate all the site pages and language file[i think!] but this part:
It is not in mybonus.php...can anyone tell me where is it located?

it is in the data base

thanks man found it pretty easy...

why it displays ???????????? instead of greek though? the description s collation is in latin1_general_ci

in torrent_torrent change to row descr to utf8 utf8_bin

i mean the description's collation is in latin1_general_ci for this

http://www.bvlist.com/attachment.php...1&d=1347747524

As you can see in picture 6.jpg the word "δοκιμή" is displayed in greek in database but not in page!

change it to utf8 utf8_bin

it has only utf8_bin i changed it to this but still question marks are displayed in the page......

I well check my files

please show me what your table structure looks like

Right now looks like this:Changed the bonus name and description to utf8_bin

you need to let php incode the text like so

PHP Code:


		
			
$db->sql_query("UPDATE `".$db_prefix."_bonus` SET `description` = '".addslashes(strip_tags(urldecode('Αν φτάσετε τα σημεία για αυτή την περίπτωση, μπορείτε να ανταλλάξετε αυτά τα σημεία σχετικά με την πετάξει σε κυκλοφορία, αν αφαιρέσουμε τα σημεία και θα λάβετε την κίνηση.')))."' WHERE `torrent_bonus`.`id` = 1;");

and that inturn inserts text like this

Code:

Αν φτάσετε τα σημεία για αυτή την περίπτωση, μπορείτε να ανταλλάξετε αυτά τα σημεία σχετικά με την πετάξει σε κυκλοφορία, αν αφαιρέσουμε τα σημεία και θα λάβετε την κίνηση.

into the data base then php decodes it to this

Quote:

Αν φτάσετε τα σημεία για αυτή την περίπτωση, μπορείτε να ανταλλάξετε αυτά τα σημεία σχετικά με την πετάξει σε κυκλοφορία, αν αφαιρέσουμε τα σημεία και θα λάβετε την κίνηση.

so you are telling me to run sql command like this and it will work?just alter the greek text of each command accoardingly and the id in the end?

yes you can see how it worked here
http://guv2.com/3/pmbt/mybonus.php

when i run your command it shows me this...

you can not run it in phpmyadmin you add the line to one of your php files
and when you load that page it well run the query.

can you tell me in what page did you add it and where exactly[after what code]?i will take care of the rest myself then...

in mybonus.php like this

PHP Code:


		
			
"<td class=tabletitle align=left>"._btbonus_t."</td>".

"</tr>");
$db->sql_query("UPDATE `".$db_prefix."_bonus` SET `description` = '".addslashes(strip_tags(urldecode('Αν φτάσετε τα σημεία για αυτή την περίπτωση, μπορείτε να ανταλλάξετε αυτά τα σημεία σχετικά με την πετάξει σε κυκλοφορία, αν αφαιρέσουμε τα σημεία και θα λάβετε την κίνηση.')))."' WHERE `torrent_bonus`.`id` = 1;");
$sql = ("SELECT * FROM ".$db_prefix."_bonus order by id");
$res = $db->sql_query($sql);
while ($gets = $db->sql_fetchrow($res))
{

you well only need to load the page one time

i've got it now thanx!

WORK DONE!