No Active Mixer Device…


Start > Run > services.msc

Start Windows Audio Service

Advertisements

Friend of Friend


———-
UID | FID
———-
1 | 2
1 | 3
1 | 4
2 | 4
4 | 5
Dst…

UID: User ID
FID: Friends ID

—————————————————————————–

join similar table

select u1.uid as people, u2.fid as friend
from tabel u1
inner join tabel u2
on u1.fid=u2.uid
where u1.uid=1;

——————————————————–

select u1.uid as people, u3.fid as friend
from tabel u1
inner join tabel u2
on u1.fid=u2.uid
inner join tabel u3
on u2.fid=u3.uid
where u1.uid=1;

—————————————————————————–
search whose uid=1 :

SELECT fid FROM t WHERE uid=1

search friend of friend whose uid=1 :

SELECT fid FROM t WHERE uid IN (SELECT fid FROM t WHERE uid=1)

or (maybe) :

SELECT DISTINCT t2.fid FROM t t1
INNER JOIN t t2 ON t2.uid=t1.fid
WHERE t1.uid=1

merge friend + friend of friend, use UNION.
—————————————————————————–

display it like friendster do :

select u1.uid as first, u1.fid as second, u2.fid as third
from tabel u1
inner join tabel u2
on u1.fid=u2.uid
where u1.uid=1;

—————————————————————————–

1 level: (result: You > XXX > Target)

$sql=”SELECT friend_2.uid as XXX
FROM friend_3, _users
INNER JOIN friend_2
ON friend_3.fid = friend_2.uid
WHERE
friend_3.uid=$uid and
friend_2.fid=$fid and
limit 1″;
“);

2 level: (result: You > XXX > YYY > Target)

$sql=”SELECT friend_2.uid as XXX, friend_1.uid as YYY
FROM friend_3, _users
INNER JOIN friend_2
ON friend_3.fid = friend_2.uid
INNER JOIN friend_1
ON friend_2.fid = friend_1.uid
WHERE
friend_3.uid=$uid and
friend_1.fid=$fid and
limit 1”;

note: all friend table friend_1, teman_2, friend_3 has 75.000 rows,

problem:

1.very slow especially for 2 level
2. added with order by rand() sometimes time-out
3. how to make it simpler?

—————————————————————————

Total Commander Replacement


Today I’ve tried Double Commander – a file manager software which have a bit similar interface with Total Commander. One thing which attract me is that Double Commander is Open Source. Double Commander project hosted on SourceForge.NET, visit their the Project Page and give it a try.

You can also try Servant Salamander – a commercial product, but they also keep the freeware one which can be downloaded here.

Far Manager has text mode interface – similar with Total Commander predecessor: Norton Commander. Far Manager version 2.0 will become Open Source.

Have a visit also to other places which have broader review than mine:

Enable/Disable Regedit


Create a VBS file, copy/paste this text into that file

Option Explicit

‘Declare variables
Dim WSHShell, n, MyBox, p, t, mustboot, errnum, vers
Dim enab, disab, jobfunc, itemtype

Set WSHShell = WScript.CreateObject(“WScript.Shell”)
p = “HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\System\”
p = p & “DisableRegistryTools”
itemtype = “REG_DWORD”
mustboot = “Log off and back on, or restart your pc to” & vbCR & “effect the changes”
enab = “ENABLED”
disab = “DISABLED”
jobfunc = “Registry Editing Tools are now ”

‘This section tries to read the registry key value. If not present an
‘error is generated.  Normal error return should be 0 if value is
‘present
t = “Confirmation”
Err.Clear
On Error Resume Next
n = WSHShell.RegRead (p)
On Error Goto 0
errnum = Err.Number

if errnum <> 0 then
‘Create the registry key value for DisableRegistryTools with value 0
WSHShell.RegWrite p, 0, itemtype
End If

‘If the key is present, or was created, it is toggled
‘Confirmations can be disabled by commenting out
‘the two MyBox lines below

If n = 0 Then
n = 1
WSHShell.RegWrite p, n, itemtype
Mybox = MsgBox(jobfunc & disab & vbCR & mustboot, 4096, t)
ElseIf n = 1 then
n = 0
WSHShell.RegWrite p, n, itemtype
Mybox = MsgBox(jobfunc & enab & vbCR & mustboot, 4096, t)
End If

source:

http://dougknox.com/security/scripts_desc/regtools.htm

Enable/Disable Windows Scripting Host (WSH)


Create REG_DWORD entries  in:

HKCU\Software\Microsoft\Windows Script Host\Settings\Enabled

and

HKLM\Software\Microsoft\Windows Script Host\Settings\Enabled

set the value to 0 (zero) to disable, and set to 1 to enable

– updated –

I found a software which can do similar task, so you don’t need to do it manually…try to download here