Wednesday, May 18, 2011

2.5 - Dinamikus helyfoglalas

A dinamikus helyfoglalas futas kozben tortenik a memoria heap (halom) szegmenseben.
A valtozok kezelese ebben az esetben a programozo felelossege, a helyfoglalast a new , new[] operatorok vegzik mig a felszabaditast a delete, delete[] operatorok.

Pl:
int *a = new int; // helyfoglalas egyetlen egesz szamnak
*a = 10;
delete a; // felszabaditas

int *t = new int[10] // helyfoglalas egy 10 elemu egesz szamokbol allo tombnek
for(int i=0; i<10; i++)
   t[i]=10;
delete [] t; //felszabaditas

Van egy Datum osztalyunk, keszitsunk belole peldanyokat.
Datum *d = new Datum();
delete d;

// ebben az esetben kotelezo hogy letezen a Datum osztalyunknak
// parameter nelkuli konstruktora
Datum *td = new Datum[10];
delete [] td;

// a masodik megoldas letrehozni egy mutato tombot
// es abban egyenkent inicializalni az elemeket
int i;
Datum **d = new Datum *[10];
for(i=0; i<10; i++)
   d[i] = new Datum(2005,10,i+1);

for(i=0; i<10; i++)
   delete d[i];

delete [] d;

Tuesday, April 5, 2011

How To Use Phoenix Service Software To Recover Dead Nokia Phones

Things to be kept in mind before installing Phoenix Service Software:
  1. Remove Nokia PC Suite, Nokia Software Updater, Nokia Care Suite, Nokia Modem Drivers, Nokia Connectivity Drivers.
  2. Remove all other Nokia stuff from your system through Control Panel>Add/Remove Programs.
  3. Restart your PC.
  4. Do not connect your phone before installing Phoenix software.
  5. Now ensure you have no antivirus software or any other software running on your pc or in the system tray while you are using Phoenix. You should turn them off while using Phoenix. Make sure your system hasn’t got any hanging problem.
  6. Turn off your screensaver.
  7. Charge your phone battery to at least 50%. Although flashing takes only 8-9 minutes.
Installing Phoenix Service Software:
  1. Download Latest Version Of Phoenix Service Software
  2. If you have older version, no need to uninstall it the latest version will automatically replace it.
  3. Install the software. Be patient, it may take some minutes to install all the components.
  4. Don’t run Phoenix software now.
  5. Connect your Nokia handset to your pc with USB cable in PC Suite mode.
  6. Windows will start installing the connectivity drivers as soon as you connect the phone. Let it install completely.
Installing Firmware Files:
  1. If your firmware file is in .rar format, first extract it using WinRar on desktop.
  2. On desktop you will find .exe file of your firmware file.
  3. Install the exe file. It will install it to default location of C:\Program files\Nokia\Phoenix\Products\
    Be sure you install updated firmware. You cannot downgrade your phone’s firmware in BB5 phones which includes all new Nokia phones including N-Series.
  4. Phoenix allows downgrading but your phone doesn’t allow it as your phone has some special security built into it. So no use of trying it. You’ll get an error message.
  5. You can reinstall your current firmware also if you have its package. It is supported. It can also sometimes solve little issues.
  6. You can get latest firmware files for your phone just search the net.
Flashing Procedure [Updating to latest firmware]:
  1. Open Phoenix Service Software.
  2. Connect your phone in PC Suite Mode.
  3. In Phoenix, click File>Manage Connections.
  4. Now click New.
  5. Now select the type of cable you are using. If you are using DKE-2, CA-53 [N-Series] cable, select USB.
  6. Click Next. It will find your product and say FOUND. If it doesn’t find any, you can try changing your cable type by clicking Back.
  7. Click Next and then Finish.
  8. Now your cable type [USB] appears in the connection list. Select it. Click APPLY and then CLOSE.
  9. Now select File>Open Product.
  10. A list of RM code will open. Select your phone’s RM code. Like RM-133 for Nokia N73. Click OK
  11. Now select File>Scan Product.
  12. Your phone’s firmware info will appear at the extreme bottom of the Phoenix window.
  13. Now go to Flashing>Firmware Update.
  14. A window will open.
  15. On that window click Browse button [the one with three dots].
  16. A window will open with various products and various regions. Choose the region or country of your choice according to the language pack you want to install.
  17. Click Ok.
  18. Click Refurbish.
  19.  
  20. Now your actual flashing has started. Don’t touch your phone or press any button until the flashing has finished. Also don’t touch your data cable and your computer system.
  21. At the end Phoenix will tell you to remove your phone as the flashing has finished.
  22.  
  23. Now wait for your phone to reboot into latest firmware.
  24. The flashing procedure takes 8-9 minutes, a lot faster than Nokia Software Updater.
Flashing dead phones [Which show only white screen on startup]

Note: You can install any firmware in dead phones whether it is latest and or the old one.
  1. The procedure is the same for flashing Dead phones.
  2. Start Phoenix. Connect your phone with USB Cable [phone is off at this time].
  3. Click File>Open Product. Select your RM code from the window that appears. Click OK.
  4. Click File> Manage Connections. Select No Connection. Then APPLY and CLOSE.
  5. Now straight away click Flashing>Firmware Update.
  6. A window will open. Click on Browse button [the one with 3 dots].
  7. A window will open with various products and various regions. Choose the region or country of your choice according to the language pack you want to install.
  8. Check the option “Dead Phone USB Flashing”.
  9. Click Refurbish.
  10. Flashing has started.
  11. After some seconds flashing will pause asking you to turn your phone ON.
  12. Press POWER button of your phone until backlight comes up.
  13. Flashing will proceed.
  14. Your phone will automatically start when the flashing finishes. After finish you can safely remove your data cable from handset.
Important Note: If you want to install another update to your phone after a new firmware is released, first remove the previous version you installed in C:\Program files\Nokia\Phoenix\Products\ Just delete all the contents of Products folder before installing a new firmware.

Thanx for info: me.dhillon [me.dhillon@gmail.com] member, DotSIS, originally this is his work. Thanx.

Thursday, December 9, 2010

How to create a torrent

This summary is not available. Please click here to view the post.

Tuesday, November 16, 2010

Lesson 05


Reporting Aggregated Data Using the Group Functions


?# What are group functions?

Group functions operate on sets of rows to give one result per group.

!# Types of Group Functions

* AVG, COUNT, MAX, MIN, STDDEV, SUM, VARIANCE

!# Group Functions: Syntax

Select group_function(column), ...
From table
[Where condition]
[Order By column];

You can use AVG and SUM for numeric data.

Select AVG(salary), MAX(salary), MIN(salary), SUM(salary)
From employees
Where job_id LIKE '%REP%';

You can use MIND and MAX for numeric, character, and date data types

Select MIN(hire_date), MAX(hire_date)
From employees;

COUNT(*) returns the number of rows in a tabel
Select COUNT(*)
From employees
Where department_id = 50;

COUNT(DISTINCT expr) return the number of distinct non-null values of exp.
To display the number of distinct department values in the EMPLOYEES tabel:
Select COUNT(DISTINCT department_id)
From employees;

Group functions ignore null values in the column:
Select AVG(commission_pct)
From employees;

The NVL functions forces group functions to include null values:
Select AVG(NVL(commission_pct, 0 ))
From employees;

Creating Groups of Data:
GROUP BY Clause Syntax


Select column, group_function(column)
From table
[Where condition]
[GROUP BY group_by_expression]
[Order By column];
You can divide rows in a table into smaller groups by using the GROUP BY clause.

All columns in the Select list that are not in group functions must be in the GROUP BY clause.
Select department_id, AVG(salary)
From employees
GROUP BY department_id;

The GROUP BY column does not have to be in the Select list.
Select AVG(salary)
From employees
GROUP BY department_id;

Using the Group by Clause on Multiple Columns
Select department_id, job_id, SUM(salary)
From employees
Where department_id > 40
Group By department_id, job_id
Order By department_id;