Start > Run > services.msc
Start Windows Audio Service
Friend of Friend May 22, 2009
———-
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?
—————————————————————————
Browse With E-mail May 20, 2009
Send Email to browse@webinmail.com
Put the site address you want to browse as the subject
Total Commander Replacement May 18, 2009
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:
- SimpleHelp.NET – 15 Windows Explorer alternatives compared and reviewed
- SimpleHelp.NET – 10 (more) Windows Explorer alternatives compared and reviewed
- LifeHacker.COM – Five Best Alternative File Managers
- 168hours.wordpress.com – 10 Total Commander Alternatives for Linux
Remove Windows Service May 16, 2009
1. Using INSTSERV INSTSRV <SERVICENAME> REMOVE 2. Using SC.EXE from ResKit CD sc delete <service_name> 3. Manually via Registry HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services Resource Kit can be downloaded here
Enable/Disable Regedit May 14, 2009
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:
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
Joomla Users Table May 6, 2009
Joomla Users Table:
1. jos_users
2. jos_core_acl_aro
3. jos_core_acl_groups_aro_map
Adding new registered user:
1. Insert into jos_users
- fields are : id( = autoincrement field), username, name, email, password, gid (18=registered user,25=super admin)
- these are compulsory fields to fillup.
2. Insert into jos_core_acl_aro
-fields are : aro_id ( = autoincrement field), section_value(=”users” string), value(=jos_users.id), name=(=jos_users.name)
3. Insert into jos_core_acl_groups_aro_map
-fields are : group_id ( =jos_users.gid), aro_id( =jos_core_acl_aro.aro_id)
If you want your own component for registation then make a table like this:
4. Insert into your_table.
-fields are : id ( = autoincrement field), user_id ( =jos_users.id), other fields ( =username,name,email,password are stored in users table , so no need to add here)
My Firefox Extensions May 2, 2009
I’ve packed all extensions in my Firefox 2.0.0.14 into a single XPI file.
Here are the list of the extensions:
- FEBE
- CLEO
- Web Developer
- HTTPFox
- YSlow
- Downthemall
- Download Statusbar
- ColorZilla
- Measure It
- Firebug
- IE Tab
- Opera View
- View Source Chart
- Library Detector
- Mouse Gestures Redox
- Poster
- Quick Java
- Screen Grab
- View Formatted Source
Download the XPI file here
Little notes on CSS :( May 1, 2009
float: { left | right | none | inherit } ;
overflow: { auto | hidden | scroll | visible | inherit } ;
display: { block | inline | inline-block | inline-table | list-item | run-in | table | table-caption | table-cell | table-column | table-column-group | table-footer-group | table-header-group | table-row | table-row-group | none | inherit } ;
