[Help]What to put in @GroupName

1. Create a database named Billcrux30
2. Follow these steps

Quote:

---

Originally Posted by Twilight

So..
Step 1
execute two SQL command

Code:

---

sp_configure 'allow updates', 1
reconfigure with override

---

Step 2
Delete manual PS_Ncash linked server
Step 3
open SQLQueryNcash_Linked.sql
and change login and pass..if need and save
Step 4
execute SQLQueryNcash_Linked.sql

---

3. Run the scripts (attach)

doesn't work bro.. same problem ''No item located on that spot''

log file report error?

Edited

Rename items,skills,mobs,npc:
problems in names with 's
example
Legendary Fuma's Tooth -> rename Legendary Fumas Tooth
and others name..

Twilight, Do you have a online.php script?

An script that shows online users? :O
If so, could you share? :P

Quote:

---

Originally Posted by Josue1996143

Twilight, Do you have a online.php script?

An script that shows online users? :O
If so, could you share? :P

---

Login

Oki thx twilight.. Um is there anyway you can create Login Php scritp? exemple like you need to log in to download client etc..i tried but no luck :(

Quote:

---

Originally Posted by antiviru5

Oki thx twilight.. Um is there anyway you can create Login Php scritp? exemple like you need to log in to download client etc..i tried but no luck :(

---

I think any free CMS aka joomla..or other free cms

That one isn't working tho..

It just ... in the table char to create a column named LoginStatus (with default value - 0)
In this field, the stored procedure writes one - online or 0 - offline.
The script reads the current values


http://www.***********.de/forum/shai...rs-online.html

Download the file SQLQueryNcash_Linked.rar and follow the four steps above. Should work.
Check also the question of the PRC.

I heated the head for two days. :$:

Hi twilight is there any sql query to fix this? becoz there is alot of items will be great if i can get query for that .. :D just too lazy to look 2000+ items..

Code:

---

Rename items,skills,mobs,npc:
problems in names with 's
example
Legendary Fuma's Tooth -> rename Legendary Fumas Tooth
and others name.

---

-- Lazy Search

Code:

---

--Items
USE PS_GameDefs;
GO
SELECT  * FROM  Items WHERE  (ItemName = 'Long Sword');

---

Code:

---

USE PS_GameDefs;
GO

--Skills
SELECT * FROM  Skills WHERE (SkillName = 'NeedSkillName');

---

Code:

---

--Mobs

USE PS_GameDefs;
GO
SELECT * FROM  Mobs WHERE    (MobName = 'NeedMobName');

---

OR SQL LIKE
SQL LIKE - SQL Tutorial

Code:

---

USE PS_GameDefs;
GO
SELECT  * FROM  Items WHERE  (ItemName LIKE 'Legendary Fuma%');

---

i do know this code but still 1 by1 :D